📄 opponentstaffform.cpp
字号:
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_favourite->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_add->EnableWindow(true);
bt_delete->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_save->EnableWindow(false);
bt_cancelation->EnableWindow(false);
UpdateData(false);
}
void COpponentStaffForm::OnExit()
{
this->OnCancel();
}
BOOL COpponentStaffForm::OnInitDialog()
{
CDialog::OnInitDialog();
DWORD style;
style=m_opponentList.GetExStyle();
style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
m_opponentList.SetExtendedStyle(style);
m_opponentList.InsertColumn(0,"编码",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(1,"企业法人",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(2,"单位名称",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(3,"登记日期",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(4,"对手级别",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(5,"行业性质",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(6,"总资产",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(7,"规模",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(8,"网站",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(9,"传真",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(10,"电话",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(11,"邮编",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(12,"帐号",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(13,"地址",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(14,"经营范围",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(15,"经营策略",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(16,"目标市场",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(17,"资源情况",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(18,"发展趋势",LVCFMT_LEFT,100);
m_opponentList.InsertColumn(19,"评价分析",LVCFMT_LEFT,100);
CString strSQL;
_RecordsetPtr m_pRecordset;
HRESULT hTRes;
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
strSQL="select distinct departmentName from department";
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
int i=0;
while(!(m_pRecordset->adoEOF))
{
m_departmentCombo.InsertString(i,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("departmentName")));
m_pRecordset->MoveNext();
i++;
}
m_pRecordset->Close();
i=0;
_RecordsetPtr m_pOpponentRecordset;
strSQL="select * from opponent";
hTRes = m_pOpponentRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pOpponentRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
while(!(m_pOpponentRecordset->adoEOF))
{
m_opponentList.InsertItem(i,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("opponentID")));
m_opponentList.SetItemText(i,1,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("legalPerson")));
m_opponentList.SetItemText(i,2,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("opponentName")));
m_opponentList.SetItemText(i,3,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("bookinDate")));
m_opponentList.SetItemText(i,4,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("opponentLevel")));
m_opponentList.SetItemText(i,5,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("industryCharacter")));
m_opponentList.SetItemText(i,6,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("allFunds")));
m_opponentList.SetItemText(i,7,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("scale")));
m_opponentList.SetItemText(i,8,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("webSite")));
m_opponentList.SetItemText(i,9,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("telephone")));
m_opponentList.SetItemText(i,10,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("postCode")));
m_opponentList.SetItemText(i,11,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("account")));
m_opponentList.SetItemText(i,12,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("address")));
m_opponentList.SetItemText(i,13,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("manageRange")));
m_opponentList.SetItemText(i,14,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("managePolicy")));
m_opponentList.SetItemText(i,15,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("goalMarket")));
m_opponentList.SetItemText(i,16,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("resourceCondition")));
m_opponentList.SetItemText(i,17,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("developeTend")));
m_opponentList.SetItemText(i,18,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pOpponentRecordset->GetCollect("assess")));
i++;
m_pOpponentRecordset->MoveNext();
}
}
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,"QQ",LVCFMT_LEFT,100);
m_staffList.InsertColumn(13,"eMail",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);
tx_staffID=GetDlgItem(IDC_staffID);
tx_staffName=GetDlgItem(IDC_staffName);
tx_sex=GetDlgItem(IDC_sex);
tx_birthday=GetDlgItem(IDC_birthday);
tx_nationality=GetDlgItem(IDC_nationality);
tx_marriageCondition=GetDlgItem(IDC_marriageCondition);
tx_partyFeature=GetDlgItem(IDC_partyFeature);
tx_educationLevel=GetDlgItem(IDC_educationLevel);
tx_graduateSchool=GetDlgItem(IDC_graduateSchool);
tx_telephone=GetDlgItem(IDC_telephone);
tx_postcode=GetDlgItem(IDC_postcode);
tx_mobile=GetDlgItem(IDC_mobile);
tx_QQ=GetDlgItem(IDC_QQ);
tx_eMail=GetDlgItem(IDC_eMail);
tx_department=GetDlgItem(IDC_department);
tx_positionTitle=GetDlgItem(IDC_positionTitle);
tx_duty=GetDlgItem(IDC_duty);
tx_address=GetDlgItem(IDC_address);
tx_favourite=GetDlgItem(IDC_favourit);
tx_remark=GetDlgItem(IDC_remark);
bt_add=GetDlgItem(IDC_add);
bt_delete=GetDlgItem(IDC_delete);
bt_modify=GetDlgItem(IDC_modify);
bt_save=GetDlgItem(IDC_save);
bt_cancelation=GetDlgItem(IDC_cancelation);
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_favourite->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_add->EnableWindow(true);
bt_delete->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_save->EnableWindow(false);
bt_cancelation->EnableWindow(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void COpponentStaffForm::OnClickList2(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);
}
COpponentStaff opponentStaff;
opponentStaff.GetData(m_opponentID,m_staffID);
m_staffName = opponentStaff.GetStaffName();
m_sex = opponentStaff.GetSex();
m_birthday = opponentStaff.GetBirthday();
m_nationality = opponentStaff.GetNationality();
m_marriageCondition = opponentStaff.GetMarriageCondition();
m_partyFeature = opponentStaff.GetPartyFeature();
m_educationLevel = opponentStaff.GetEducationLevel();
m_graduateSchool = opponentStaff.GetGraduateSchool();
m_telephone = opponentStaff.GetTelephone();
m_postcode = opponentStaff.GetPostcode();
m_mobile = opponentStaff.GetMobile();
m_QQ = opponentStaff.GetQQ();
m_eMail = opponentStaff.GetEMail();
m_department = opponentStaff.GetDepartment();
m_positionTitle = opponentStaff.GetPositionTitle();
m_duty = opponentStaff.GetDuty();
m_address = opponentStaff.GetAddress();
m_favourite = opponentStaff.GetFavourite();
m_remark = opponentStaff.GetRemark();
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_favourite->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_add->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_modify->EnableWindow(true);
bt_save->EnableWindow(false);
bt_cancelation->EnableWindow(false);
UpdateData(false);
*pResult = 0;
}
void COpponentStaffForm::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult)
{
UpdateData(true);
POSITION pos = m_opponentList.GetFirstSelectedItemPosition();
if(pos)
{
int nFirstSelItem = m_opponentList.GetNextSelectedItem(pos);
m_opponentID=m_opponentList.GetItemText(nFirstSelItem,0);
}
m_staffList.DeleteAllItems();
CString strSQL;
strSQL="select * from opponentStaff where opponentID='";
strSQL=strSQL+m_opponentID+"'";
_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")));
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,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName")));
m_staffList.SetItemText(i,2, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sex")));
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")));
m_staffList.SetItemText(i,13, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("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 COpponentStaffForm::Refresh()
{
m_staffList.DeleteAllItems();
CString strSQL;
strSQL="select * from opponentStaff where opponentID='";
strSQL=strSQL+m_opponentID+"'";
_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")));
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,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName")));
m_staffList.SetItemText(i,2, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sex")));
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")));
m_staffList.SetItemText(i,13, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("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 + -