1。C++常用代码总结(4)

  

//判断数据库中是否存在该记录

ADOconn m_conn;    _bstr_t vSQL="";_variant_t vResult[3]; _RecordsetPtr m_pRecordset;

CString s_Conn="Provider=SQLOLEDB;Server=10.128.128.221;Database=Eink;uid=stone;pwd=stone";

vSQL="select * from contens where employee='"+employees+"' and week='"+m_vweek+"'";

m_conn.OnInitADOConn(s_Conn);

m_pRecordset=m_conn.GetRecordSet(vSQL);

if(!m_pRecordset->ADOEOF)

{ AfxMessageBox("您已经提报了,如果您还想补充你的周会内容,请选择补充周会内容按钮",MB_OK); }

else

{//做你想做的事情}

//在A对话框前弹出一B对话框

Login dlog;//B对话框的对象

if(dlog.DoModal()!=IDOK)

{        return false; }

CContentsSubmitDlg dlg;//A对话框对象

m_pMainWnd = &dlg;

//需要密码的登陆框

void Login::OnBnClickedOk()

{    UpdateData(true);

    if(this->m_User=="" || this->m_Password=="")

     {        AfxMessageBox("用户名和密码不能为空",MB_OK);       return;

     }

     else

     {   

ADOconn m_conn;    _bstr_t vSQL="";_variant_t vResult; _RecordsetPtr m_pRecordset;

CString s_Conn="Provider=SQLOLEDB;Server=10.128.128.221;Database=Eink;uid=stone;pwd=stone";

vSQL="select employee_name from employee where employee_id='"+m_User+"'and password='"+m_Password+"'";

m_conn.OnInitADOConn(s_Conn);    m_pRecordset=m_conn.GetRecordSet(vSQL);

     if(m_pRecordset->ADOEOF)

         {    AfxMessageBox("您的用户名密码输入错误",MB_OK);          return;       }

         else

         {    vResult=m_pRecordset->GetCollect(_variant_t((long)0));

              employeelogin_name=(LPCTSTR)(_bstr_t)vResult;

              (( CContentsSubmitApp *)AfxGetApp())->namelogin=employeelogin_name;  

              //通过全局变量保存用户名

         }

        OnOK();

     }

}