📄 staffinformation.cpp
字号:
// m_staffList.SetItemText(j,13,m_qqID);
// m_staffList.SetItemText(j,14,m_graduateSchool);
// m_staffList.SetItemText(j,15,m_major);
// m_staffList.SetItemText(j,16,m_identity);
// m_staffList.SetItemText(j,17,m_mobile);
// m_staffList.SetItemText(j,18,m_workType);
// m_staffList.SetItemText(j,19,m_remark);
Refresh();
AfxMessageBox("修改成功！");
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
bt_add->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_modify->EnableWindow(true);
bt_save->EnableWindow(false);
tx_department->EnableWindow(false);
tx_address->EnableWindow(false);
tx_birthday->EnableWindow(false);
tx_postcode->EnableWindow(false);
tx_marriageCondition->EnableWindow(false);
tx_staffID->EnableWindow(false);
tx_duty->EnableWindow(false);
tx_name->EnableWindow(false);
tx_sex->EnableWindow(false);
tx_telephone->EnableWindow(false);
tx_nationality->EnableWindow(false);
tx_eMail->EnableWindow(false);
tx_educationDegree->EnableWindow(false);
tx_qqID->EnableWindow(false);
tx_graduateSchool->EnableWindow(false);
tx_major->EnableWindow(false);
tx_identity->EnableWindow(false);
tx_mobile->EnableWindow(false);
tx_remark->EnableWindow(false);
tx_workType->EnableWindow(false);
UpdateData(false);//
}
void CStaffInformation::OnExit()
{
this->OnCancel();
}
BOOL CStaffInformation::OnInitDialog()
{
CDialog::OnInitDialog();
DWORD style;
style=m_staffList.GetExStyle();
style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
m_staffList.SetExtendedStyle(style);
m_staffList.InsertColumn(0,"员工编号",LVCFMT_LEFT,100);
m_staffList.InsertColumn(1,"姓名",LVCFMT_LEFT,100);
m_staffList.InsertColumn(2,"职务",LVCFMT_LEFT,100);
m_staffList.InsertColumn(3,"工作部门",LVCFMT_LEFT,100);
m_staffList.InsertColumn(4,"性别",LVCFMT_LEFT,100);
m_staffList.InsertColumn(5,"住址",LVCFMT_LEFT,100);
m_staffList.InsertColumn(6,"出生年月",LVCFMT_LEFT,100);
m_staffList.InsertColumn(7,"邮编",LVCFMT_LEFT,100);
m_staffList.InsertColumn(8,"婚姻状况",LVCFMT_LEFT,100);
m_staffList.InsertColumn(9,"电话",LVCFMT_LEFT,100);
m_staffList.InsertColumn(10,"民族",LVCFMT_LEFT,100);
m_staffList.InsertColumn(11,"邮箱",LVCFMT_LEFT,100);
m_staffList.InsertColumn(12,"文化程度",LVCFMT_LEFT,100);
m_staffList.InsertColumn(13,"QQ号码",LVCFMT_LEFT,100);
m_staffList.InsertColumn(14,"毕业学校",LVCFMT_LEFT,100);
m_staffList.InsertColumn(15,"专业",LVCFMT_LEFT,100);
m_staffList.InsertColumn(16,"身份证号",LVCFMT_LEFT,100);
m_staffList.InsertColumn(17,"手机",LVCFMT_LEFT,100);
m_staffList.InsertColumn(18,"工种",LVCFMT_LEFT,100);
m_staffList.InsertColumn(19,"备注",LVCFMT_LEFT,100);
_RecordsetPtr m_pTreeRecordset; //用于创建一个查询记录集
CString strSQL;
HRESULT hTRes;
strSQL="select * from duty";
_RecordsetPtr m_pDutyRecordset;
hTRes = m_pDutyRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pDutyRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pDutyRecordset->adoEOF))
{
m_dutyCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDutyRecordset->GetCollect("dutyTypeID")));
m_pDutyRecordset->MoveNext();
}
}
}
m_pDutyRecordset->Close();
strSQL="select * from department";
_RecordsetPtr m_pDepartmentRecordset;
hTRes = m_pDepartmentRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pDepartmentRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pDepartmentRecordset->adoEOF))
{
m_departmentCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDepartmentRecordset->GetCollect("departmentID")));
m_pDepartmentRecordset->MoveNext();
}
}
}
m_pDepartmentRecordset->Close();
//-----------------------------------------------
strSQL="SELECT * FROM staff";
try
{
HRESULT hTRes;
hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
m_pTreeRecordset->MoveFirst();
if (!(m_pTreeRecordset->adoEOF))
{
int i=0;
while(!m_pTreeRecordset->adoEOF)
{
m_staffList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("staffID")));
m_staffList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("staffName")));
m_staffList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("duty")));
m_staffList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("department")));
m_staffList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("sex")));
m_staffList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("address")));
m_staffList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("birthday")));
m_staffList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("postcode")));
m_staffList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("marriageCondition")));
m_staffList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("telephone")));
m_staffList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("nationality")));
m_staffList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("eMail")));
m_staffList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("educationLevel")));
m_staffList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("QQ")));
m_staffList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("graduateSchool")));
m_staffList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("major")));
m_staffList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("identityNO")));
m_staffList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("mobile")));
m_staffList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("workType")));
m_staffList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("remark")));
if (!(m_pTreeRecordset->adoEOF))
{
m_pTreeRecordset->MoveNext();
i++;
}
}
}
}
}
}
catch(_com_error e)
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
flag=0;
tx_department =GetDlgItem(IDC_department);
tx_address =GetDlgItem(IDC_address);
tx_birthday =GetDlgItem(IDC_birthday);
tx_postcode =GetDlgItem(IDC_postcode);
tx_marriageCondition =GetDlgItem(IDC_marriageCondition);
tx_staffID =GetDlgItem(IDC_staffID);
tx_duty =GetDlgItem(IDC_duty);
tx_name =GetDlgItem(IDC_name);
tx_sex =GetDlgItem(IDC_sex);
tx_telephone =GetDlgItem(IDC_telephone);
tx_nationality =GetDlgItem(IDC_nationality);
tx_eMail =GetDlgItem(IDC_eMail);
tx_educationDegree =GetDlgItem(IDC_educationDegree);
tx_qqID =GetDlgItem(IDC_qqID);
tx_graduateSchool =GetDlgItem(IDC_graduateSchool);
tx_major =GetDlgItem(IDC_major);
tx_identity =GetDlgItem(IDC_identity);
tx_mobile =GetDlgItem(IDC_mobile);
tx_remark =GetDlgItem(IDC_remark);
tx_workType=GetDlgItem(IDC_workType);
bt_add=GetDlgItem(IDC_add);
bt_save=GetDlgItem(IDC_save);
bt_modify=GetDlgItem(IDC_modify);
bt_delete=GetDlgItem(IDC_delete);
tx_department->EnableWindow(false);
tx_address->EnableWindow(false);
tx_birthday->EnableWindow(false);
tx_postcode->EnableWindow(false);
tx_marriageCondition->EnableWindow(false);
tx_staffID->EnableWindow(false);
tx_duty->EnableWindow(false);
tx_name->EnableWindow(false);
tx_sex->EnableWindow(false);
tx_telephone->EnableWindow(false);
tx_nationality->EnableWindow(false);
tx_eMail->EnableWindow(false);
tx_educationDegree->EnableWindow(false);
tx_qqID->EnableWindow(false);
tx_graduateSchool->EnableWindow(false);
tx_major->EnableWindow(false);
tx_identity->EnableWindow(false);
tx_mobile->EnableWindow(false);
tx_remark->EnableWindow(false);
tx_workType->EnableWindow(false);
bt_save->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_delete->EnableWindow(false);
UpdateData(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CStaffInformation::OnClickStaffList(NMHDR* pNMHDR, LRESULT* pResult)
{
UpdateData(true);
POSITION pos = m_staffList.GetFirstSelectedItemPosition();
if(pos)
{
int nFirstSelItem = m_staffList.GetNextSelectedItem(pos);
m_staffID=m_staffList.GetItemText(nFirstSelItem,0);
_RecordsetPtr m_pRecordset; //用于创建一个查询记录集
CString strSQL;
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
strSQL="SELECT * FROM staff where staffID='"+m_staffID+"'";
//AfxMessageBox(strSQL);
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
m_name=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName"));
m_duty=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("duty"));
m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("department"));
m_sex=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sex"));
m_address=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address"));
m_birthday=m_pRecordset->GetCollect("birthday");
m_postcode=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("postcode"));
m_marriageCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("marriageCondition"));
m_telephone=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("telephone"));
m_nationality=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("nationality"));
m_eMail=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("eMail"));
m_educationDegree=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("educationLevel"));
m_qqID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("QQ"));
m_graduateSchool=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("graduateSchool"));
m_major=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("major"));
m_identity=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("identityNO"));
m_mobile=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("mobile"));
m_workType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("workType"));
m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));
}
}
bt_modify->EnableWindow(true);
bt_delete->EnableWindow(true);
UpdateData(false);
*pResult = 0;
}
void CStaffInformation::Refresh()
{
m_staffList.DeleteAllItems();
_RecordsetPtr m_pTreeRecordset; //用于创建一个查询记录集
CString strSQL;
HRESULT hTRes;
hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
strSQL="SELECT * FROM staff";
try
{
HRESULT hTRes;
hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
m_pTreeRecordset->MoveFirst();
if (!(m_pTreeRecordset->adoEOF))
{
int i=0;
while(!m_pTreeRecordset->adoEOF)
{
m_staffList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("staffID")));
m_staffList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("staffName")));
m_staffList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("duty")));
m_staffList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("department")));
m_staffList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("sex")));
m_staffList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("address")));
m_staffList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("birthday")));
m_staffList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("postcode")));
m_staffList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("marriageCondition")));
m_staffList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("telephone")));
m_staffList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("nationality")));
m_staffList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("eMail")));
m_staffList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("educationLevel")));
m_staffList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("QQ")));
m_staffList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("graduateSchool")));
m_staffList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("major")));
m_staffList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("identityNO")));
m_staffList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("mobile")));
m_staffList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("workType")));
m_staffList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("remark")));
if (!(m_pTreeRecordset->adoEOF))
{
m_pTreeRecordset->MoveNext();
i++;
}
}
}
}
}
}
catch(_com_error e)
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -