📄 clientstaffform.cpp
字号:
tx_department->EnableWindow(false);
tx_positionTitle->EnableWindow(false);
tx_duty->EnableWindow(false);
tx_address->EnableWindow(false);
tx_favourit->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_add->EnableWindow(true);
bt_delete->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_cancelation->EnableWindow(false);
bt_save->EnableWindow(false);
UpdateData(false);
}
void CClientStaffForm::OnModify()
{
tx_staffID->EnableWindow(false);
tx_staffName->EnableWindow(true);
tx_sex->EnableWindow(true);
tx_birthday->EnableWindow(true);
tx_nationality->EnableWindow(true);
tx_marriageCondition->EnableWindow(true);
tx_partyFeature->EnableWindow(true);
tx_educationLevel->EnableWindow(true);
tx_graduateSchool->EnableWindow(true);
tx_telephone->EnableWindow(true);
tx_postCode->EnableWindow(true);
tx_mobile->EnableWindow(true);
tx_QQ->EnableWindow(true);
tx_eMail->EnableWindow(true);
tx_department->EnableWindow(true);
tx_positionTitle->EnableWindow(true);
tx_duty->EnableWindow(true);
tx_address->EnableWindow(true);
tx_favourit->EnableWindow(true);
tx_remark->EnableWindow(true);
bt_add->EnableWindow(false);
bt_delete->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_cancelation->EnableWindow(false);
bt_save->EnableWindow(true);
flag=2;
UpdateData(false);
}
void CClientStaffForm::OnSave()
{
UpdateData(true);
CClientStaff clientStaff;
clientStaff.SetClientID(m_clientID);
clientStaff.SetStaffID(m_staffID);
clientStaff.SetStaffName(m_staffName);
clientStaff.SetSex(m_sex);
clientStaff.SetBirthday(m_birthday);
clientStaff.SetNationality(m_nationality);
clientStaff.SetMarriageCondition(m_marriageCondition);
clientStaff.SetPartyFeature(m_partyFeature);
clientStaff.SetEducationLevel(m_educationLevel);
clientStaff.SetGraduateSchool(m_graduateSchool);
clientStaff.SetTelephone(m_telephone);
clientStaff.SetPostCode(m_postCode);
clientStaff.SetMobile(m_mobile);
clientStaff.SetQQ(m_QQ);
clientStaff.SetEMail(m_eMail);
clientStaff.SetDepartment(m_department);
clientStaff.SetPositionTitle(m_positionTitle);
clientStaff.SetDuty(m_duty);
clientStaff.SetAddress(m_address);
clientStaff.SetFavourit(m_favourit);
clientStaff.SetRemark(m_remark);
if(flag==1)
{
clientStaff.sqlInsert();
CString str;
int i=m_staffList.GetItemCount();
m_staffList.InsertItem(i,m_staffID);
m_staffList.SetItemText(i,1,m_staffName);
m_staffList.SetItemText(i,2,m_sex);
str.Format("%d-%d-%d",m_birthday.GetYear(),m_birthday.GetMonth(),m_birthday.GetDay());
m_staffList.SetItemText(i,3,str);
m_staffList.SetItemText(i,4,m_nationality);
m_staffList.SetItemText(i,5,m_marriageCondition);
m_staffList.SetItemText(i,6,m_partyFeature);
m_staffList.SetItemText(i,7,m_educationLevel);
m_staffList.SetItemText(i,8,m_graduateSchool);
m_staffList.SetItemText(i,9,m_telephone);
m_staffList.SetItemText(i,10,m_postCode);
m_staffList.SetItemText(i,11,m_mobile);
m_staffList.SetItemText(i,12,m_QQ);
m_staffList.SetItemText(i,13,m_eMail);
m_staffList.SetItemText(i,14,m_department);
m_staffList.SetItemText(i,15,m_positionTitle);
m_staffList.SetItemText(i,16,m_duty);
m_staffList.SetItemText(i,17,m_address);
m_staffList.SetItemText(i,18,m_favourit);
m_staffList.SetItemText(i,19,m_remark);
}
else if(flag==2)
{
clientStaff.sqlUpdate(m_clientID,m_staffID);
Refresh();
}
tx_staffID->EnableWindow(false);
tx_staffName->EnableWindow(false);
tx_sex->EnableWindow(false);
tx_birthday->EnableWindow(false);
tx_nationality->EnableWindow(false);
tx_marriageCondition->EnableWindow(false);
tx_partyFeature->EnableWindow(false);
tx_educationLevel->EnableWindow(false);
tx_graduateSchool->EnableWindow(false);
tx_telephone->EnableWindow(false);
tx_postCode->EnableWindow(false);
tx_mobile->EnableWindow(false);
tx_QQ->EnableWindow(false);
tx_eMail->EnableWindow(false);
tx_department->EnableWindow(false);
tx_positionTitle->EnableWindow(false);
tx_duty->EnableWindow(false);
tx_address->EnableWindow(false);
tx_favourit->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_add->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_modify->EnableWindow(false);
bt_cancelation->EnableWindow(false);
bt_save->EnableWindow(false);
}
void CClientStaffForm::OnCancelation()
{
CString m_formID;
int formID=((CClientRelationshipApp*)AfxGetApp())->m_pIDRecordset->GetCollect("clientStaffID").intVal;
if(formID<10)
m_formID.Format("KHYG0000%d",formID);
else if(formID<100&&formID>9)
m_formID.Format("KHYG000%d",formID);
else if(formID<1000&&formID>99)
m_formID.Format("KHYG00%d",formID);
CString str;
str.Format("%d",formID-1);
((CClientRelationshipApp*)AfxGetApp())->m_pIDRecordset->PutCollect("clientStaffID",_variant_t(str));
((CClientRelationshipApp*)AfxGetApp())->m_pIDRecordset->Update();
m_staffID="";
m_staffName = _T("");
m_sex = _T("");
m_birthday = COleDateTime::GetCurrentTime();
m_nationality = _T("");
m_marriageCondition = _T("");
m_partyFeature = _T("");
m_educationLevel = _T("");
m_graduateSchool = _T("");
m_telephone = _T("");
m_postCode = _T("");
m_mobile = _T("");
m_QQ = _T("");
m_eMail = _T("");
m_department = _T("");
m_positionTitle = _T("");
m_duty = _T("");
m_address = _T("");
m_favourit = _T("");
m_remark = _T("");
tx_staffID->EnableWindow(false);
tx_staffName->EnableWindow(false);
tx_sex->EnableWindow(false);
tx_birthday->EnableWindow(false);
tx_nationality->EnableWindow(false);
tx_marriageCondition->EnableWindow(false);
tx_partyFeature->EnableWindow(false);
tx_educationLevel->EnableWindow(false);
tx_graduateSchool->EnableWindow(false);
tx_telephone->EnableWindow(false);
tx_postCode->EnableWindow(false);
tx_mobile->EnableWindow(false);
tx_QQ->EnableWindow(false);
tx_eMail->EnableWindow(false);
tx_department->EnableWindow(false);
tx_positionTitle->EnableWindow(false);
tx_duty->EnableWindow(false);
tx_address->EnableWindow(false);
tx_favourit->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_add->EnableWindow(true);
bt_delete->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_cancelation->EnableWindow(false);
bt_save->EnableWindow(false);
UpdateData(false);
}
void CClientStaffForm::OnExit()
{
this->OnCancel();
}
void CClientStaffForm::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult)
{
UpdateData(true);
POSITION pos = m_clientList.GetFirstSelectedItemPosition();//获取单击的位置
if(pos)
{
int nFirstSelItem = m_clientList.GetNextSelectedItem(pos); //获取单击的条目位置
m_clientID=m_clientList.GetItemText(nFirstSelItem,0); //单击的条目的客户编号
}
m_staffList.DeleteAllItems(); //清空员工列表框
CString strSQL;
strSQL="select * from clientStaff where clientID='";//构造查询指定客户编号的客户的员工信息的sql语句
strSQL=strSQL+m_clientID+"'";
_RecordsetPtr m_pRecordset;
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText); //打开查询记录集
int i=0;
while(!(m_pRecordset->adoEOF))
{
CString str;
m_staffList.InsertItem(i, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffID")));//员工编号
m_staffList.SetItemText(i,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName"))); //性别
m_staffList.SetItemText(i,2, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sex"))); //性别
COleDateTime birthday= m_pRecordset->GetCollect("birthday"); //出生日期
str.Format("%d-%d-%d",birthday.GetYear(),birthday.GetMonth(),birthday.GetDay());
m_staffList.SetItemText(i,3,str);
m_staffList.SetItemText(i,4, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("nationality"))); //民族
m_staffList.SetItemText(i,5, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("marriageCondition")));//婚姻状况
m_staffList.SetItemText(i,6, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("partyFeature")));//政治面貌
m_staffList.SetItemText(i,7, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("educationLevel")));//文化程度
m_staffList.SetItemText(i,8, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("graduateSchool")));//毕业院校
m_staffList.SetItemText(i,9, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("telephone")));//电话
m_staffList.SetItemText(i,10, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("postcode")));//邮编
m_staffList.SetItemText(i,11, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("mobile")));//手机
m_staffList.SetItemText(i,12, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("QQ")));//QQ
m_staffList.SetItemText(i,13, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("eMail"))); //eMail
m_staffList.SetItemText(i,14, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("department")));//部门
m_staffList.SetItemText(i,15, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("positionTitle")));//职称
m_staffList.SetItemText(i,16, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("duty")));//职务
m_staffList.SetItemText(i,17, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address")));//地址
m_staffList.SetItemText(i,18, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("favourit")));//特长爱好
m_staffList.SetItemText(i,19, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark")));//备注
m_pRecordset->MoveNext();//记录集指针向后移动
i++;
}
UpdateData(false); //将数据更新到对话框
*pResult = 0;
}
void CClientStaffForm::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); //单击的条目的员工编号
}
CClientStaff clientStaff; //构造CClientStaff对象
clientStaff.GetData(m_clientID,m_staffID);//查询满足客户编号和员工编号的记录的信息,存储再clientStaff对象中
m_staffID = clientStaff.GetStaffID();//员工编号
m_staffName = clientStaff.GetStaffName();//员工姓名
m_sex = clientStaff.GetSex();//性别
m_birthday = clientStaff.GetBirthday();//出生日期
m_nationality = clientStaff.GetNationality();//民族
m_marriageCondition = clientStaff.GetMarriageCondition();//婚姻状况
m_partyFeature = clientStaff.GetPartyFeature();//政治面貌
m_educationLevel = clientStaff.GetEducationLevel();//文化程度
m_graduateSchool = clientStaff.GetGraduateSchool();//毕业院校
m_telephone = clientStaff.GetTelephone();//电话
m_postCode = clientStaff.GetPostCode();//邮编
m_mobile = clientStaff.GetMobile(); //手机
m_QQ = clientStaff.GetQQ();//QQ
m_eMail = clientStaff.GetEMail();//eMail
m_department = clientStaff.GetDepartment();//部门
m_positionTitle = clientStaff.GetPositionTitle();//职称
m_duty = clientStaff.GetDuty();//职务
m_address = clientStaff.GetAddress();//地址
m_favourit = clientStaff.GetFavourit();//特长爱好
m_remark = clientStaff.GetRemark();//备注
bt_add->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_modify->EnableWindow(true);
bt_cancelation->EnableWindow(false);
bt_save->EnableWindow(false);
UpdateData(false); //将数据更新到对话框
*pResult = 0;
}
void CClientStaffForm::Refresh()
{
m_staffList.DeleteAllItems();
CString strSQL;
strSQL="select * from clientStaff where clientID='";//构造查询指定客户编号的客户的员工信息的sql语句
strSQL=strSQL+m_clientID+"'";
_RecordsetPtr m_pRecordset;
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText); //打开查询记录集
int i=0;
while(!(m_pRecordset->adoEOF))
{
CString str;
m_staffList.InsertItem(i, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffID")));//员工编号
m_staffList.SetItemText(i,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName"))); //性别
m_staffList.SetItemText(i,2, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sex"))); //性别
COleDateTime birthday= m_pRecordset->GetCollect("birthday"); //出生日期
str.Format("%d-%d-%d",birthday.GetYear(),birthday.GetMonth(),birthday.GetDay());
m_staffList.SetItemText(i,3,str);
m_staffList.SetItemText(i,4, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("nationality"))); //民族
m_staffList.SetItemText(i,5, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("marriageCondition")));//婚姻状况
m_staffList.SetItemText(i,6, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("partyFeature")));//政治面貌
m_staffList.SetItemText(i,7, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("educationLevel")));//文化程度
m_staffList.SetItemText(i,8, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("graduateSchool")));//毕业院校
m_staffList.SetItemText(i,9, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("telephone")));//电话
m_staffList.SetItemText(i,10, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("postcode")));//邮编
m_staffList.SetItemText(i,11, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("mobile")));//手机
m_staffList.SetItemText(i,12, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("QQ")));//QQ
m_staffList.SetItemText(i,13, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("eMail"))); //eMail
m_staffList.SetItemText(i,14, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("department")));//部门
m_staffList.SetItemText(i,15, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("positionTitle")));//职称
m_staffList.SetItemText(i,16, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("duty")));//职务
m_staffList.SetItemText(i,17, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address")));//地址
m_staffList.SetItemText(i,18, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("favourit")));//特长爱好
m_staffList.SetItemText(i,19, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark")));//备注
m_pRecordset->MoveNext();//记录集指针向后移动
i++;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -