武汉科技大学本科毕业设计
}
BOOL CDriverDlg::OnInitDialog() { }
void CDriverDlg::FillData() { }
void CDriverDlg::ClearData() { }
―32―
case 3: }
SetWindowText(_T(\删除司机\break;
SetStyle(); SetTitle();
CDialog::OnInitDialog();
// TODO: Add extra initialization here
return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE
m_tmDate=selDriver.tmBookDate; m_strAddress=selDriver.strAddress; m_strID=selDriver.strID; m_strKind=selDriver.strCarKind; m_strName=selDriver.strName; m_strNO=selDriver.strNO; m_strPhone=selDriver.strPhone; m_strSex=selDriver.strSex;
m_tmDate=CTime::GetCurrentTime();
m_strAddress=m_strID=m_strKind=m_strName=m_strNO=m_strPhone=m_strSex=\
武汉科技大学本科毕业设计
void CDriverDlg::AddDriver() {
UpdateData(true);
m_strAddress.TrimRight(\m_strID.TrimRight(\m_strKind.TrimRight(\m_strName.TrimRight(\m_strNO.TrimRight(\m_strPhone.TrimRight(\m_strSex.TrimRight(\
// Make sure all needed info is available CString sWarning=\
if ( \驾驶员编号\ if ( \ {
sWarning += _T(\不能为空\
AfxMessageBox(sWarning, MB_ICONEXCLAMATION); return; }
// Judge CustomerID is Unique
_variant_t strQuery = \Driver_NO='\
theApp.ADOExecute(theApp.m_pRs, strQuery); int iCount = theApp.m_pRs->GetRecordCount(); if ( 0!=iCount ) {
AfxMessageBox(_T(\已经存在此驾驶员号的记录!\MB_ICONEXCLAMATION); } //else info CString strI; if (m_strSex==\男\
strI=\
―33―
return;
武汉科技大学本科毕业设计
strQuery = \
driver(Driver_NO,Driver_Name,Driver_SEX,Driver_ID,Driver_Address,Driver_BookDate,Driver_CarKind,Driver_Phone) \\
values ('\
'\m_strKind+\
}
void CDriverDlg::ModifyDriver() {
UpdateData(true);
m_strAddress.TrimRight(\m_strID.TrimRight(\m_strKind.TrimRight(\m_strName.TrimRight(\
―34―
else
strI=\CString strD;
strD=m_tmDate.Format(\
if ( theApp.ADOExecute(theApp.m_pRs, strQuery) ) { } else { }
CMainFrame* pFrame = (CMainFrame*)AfxGetApp()->m_pMainWnd; pFrame->ShowView();
AfxMessageBox(_T(\添加记录失败!\return;
MB_ICONEXCLAMATION);
AfxMessageBox(_T(\添加记录成功!\// Clear all input ClearData(); UpdateData(false);
武汉科技大学本科毕业设计
}
void CDriverDlg::DelDriver() {
―35―
m_strNO.TrimRight(\m_strPhone.TrimRight(\m_strSex.TrimRight(\//else info CString strI; if (m_strSex==\男\
strI=\strI=\else CString strD;
strD=m_tmDate.Format(\ _variant_t strQuery = \ set Driver_Name='\
=\Driver_BookDate='\ne\\
='\if ( theApp.ADOExecute(theApp.m_pRs, strQuery) ) { } else { }
CMainFrame* pFrame = (CMainFrame*)AfxGetApp()->m_pMainWnd; pFrame->ShowView();
AfxMessageBox(_T(\修改记录失败!\return;
MB_ICONEXCLAMATION);
AfxMessageBox(_T(\修改记录成功!\// Clear all input ClearData(); UpdateData(false);
武汉科技大学本科毕业设计
}
void CDriverDlg::OnButtonOk() { }
―36―
bool bDel=false;
bDel=(MessageBox(\删除驾驶员信息意味着与其相关的基他信息(违法和奖惩)将一起删除,确认删除吗?\删除警告\if(!bDel)
return; _variant_t strQuery;
strQuery = \theApp.ADOExecute(theApp.m_pRs, strQuery); strQuery = \Driver_NO='\
theApp.ADOExecute(theApp.m_pRs, strQuery); strQuery = \Driver_NO='\
theApp.ADOExecute(theApp.m_pRs, strQuery);
CMainFrame* pFrame = (CMainFrame*)AfxGetApp()->m_pMainWnd; pFrame->ShowView();
switch(operation) { case 1: }
// TODO: Add your control notification handler code here
AddDriver(); break;
ModifyDriver(); OnOK(); break; DelDriver(); OnOK(); break;
case 2:
case 3: