void CLoginDlg::OnConfirm()
{
// TODO: Add your control notification handler code here
CClerkDataSet mrsDataSet; /*声明记录集*/
CString mSqlStr;
UpdateData(TRUE);
if (m_strName.IsEmpty()) /*判断用户名信息是否为空*/
{
AfxMessageBox("请输入用户名!");
return;
}
mSqlStr = "SELECT * FROM CLERK WHERE NAME='";
mSqlStr = mSqlStr + m_strName;
mSqlStr = mSqlStr + "' AND PASSWORD='";
mSqlStr = mSqlStr + m_strPassword;
mSqlStr = mSqlStr + "'";
if (!mrsDataSet.Open(AFX_DB_USE_DEFAULT_TYPE, mSqlStr))
{
AfxMessageBox("CLERK表打开失败!");
return;
}
if (!mrsDataSet.IsEOF())
{
// Open all function for user
m_bSuccess = TRUE;
m_strUSERID = mrsDataSet.m_CLERK_ID ;
CDialog::OnOK();
}
else
{
AfxMessageBox("登录失败!");
m_strUSERID = _T("");
return;
}
}
void CLoginDlg::OnCancel()
{
// TODO: Add your control notification handler code here
CDialog::OnCancel();
}