📄 clientinfor.cpp
字号:
m_pAreaRecordset->Close();
_RecordsetPtr m_pListRecordset; //用于创建一个查询记录集
// CString strSQL;
//-----------------------------------------------
strSQL="SELECT * FROM client";
try
{
HRESULT hTRes;
hTRes = m_pListRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pListRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
m_pListRecordset->MoveFirst();
if (!(m_pListRecordset->adoEOF))
{
int i=0;
while(!m_pListRecordset->adoEOF)
{
//_variant_t vIndex=(long)0;
m_clientList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientID")));
m_clientList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("bookinDate")));
m_clientList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientLevel")));
m_clientList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientType")));
m_clientList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("company")));
m_clientList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("contactPerson")));
m_clientList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("areaID")));
m_clientList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("address")));
m_clientList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("postcode")));
m_clientList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("telephone")));
m_clientList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("fax")));
m_clientList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("webSite")));
m_clientList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("eMail")));
m_clientList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("remark")));
m_clientList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("manageRange")));
m_clientList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("manageProduct")));
m_clientList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("accountBank")));
m_clientList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("acount")));
m_clientList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("taxNO")));
m_clientList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("registerDate")));
m_clientList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("registerFund")));
m_clientList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("scale")));
m_clientList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("industryCharacter")));
m_clientList.SetItemText(i,23,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("allFunds")));
m_clientList.SetItemText(i,24,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientCharacter")));
if (!(m_pListRecordset->adoEOF))
{
m_pListRecordset->MoveNext();
i++;
}
}
}
//---------------------------------------
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
// MessageBox("创建客户记录集失败!","错误");
}
// }
flag=0;
tx_bookinDate= GetDlgItem(IDC_bookinDate);
tx_clientID= GetDlgItem(IDC_clientID);
tx_clientLevel= GetDlgItem(IDC_clientLevel);
tx_clientType= GetDlgItem(IDC_clientType);
tx_company= GetDlgItem(IDC_company);
tx_contactPerson= GetDlgItem(IDC_contactPerson);
tx_area= GetDlgItem(IDC_area);
tx_address= GetDlgItem(IDC_address);
tx_postcode= GetDlgItem(IDC_postcode);
tx_telephone= GetDlgItem(IDC_telephone);
tx_fax= GetDlgItem(IDC_fax);
tx_eMail= GetDlgItem(IDC_eMail);
tx_remark= GetDlgItem(IDC_remark);
tx_manageRange= GetDlgItem(IDC_manageRange);
tx_manageProduct= GetDlgItem(IDC_manageProduct);
tx_accountBank= GetDlgItem(IDC_accountBank);
tx_acount= GetDlgItem(IDC_accounts);
tx_taxNO= GetDlgItem(IDC_taxNO);
tx_registerDate= GetDlgItem(IDC_registerDate);
tx_registerFund= GetDlgItem(IDC_registerFund);
tx_scale= GetDlgItem(IDC_scale);
tx_industryCharacter= GetDlgItem(IDC_industryCharacter);
tx_allFunds= GetDlgItem(IDC_allFunds);
tx_clientCharacter= GetDlgItem(IDC_clientCharacter);
bt_add=GetDlgItem(IDC_BUTTON2);
bt_save=GetDlgItem(IDC_BUTTON5);
bt_modify=GetDlgItem(IDC_BUTTON4);
bt_delete=GetDlgItem(IDC_BUTTON3);
// bt_add=GetDlgItem(IDC_BUTTON2);
bt_save->EnableWindow(false);
bt_modify->EnableWindow(false);
bt_delete->EnableWindow(false);
tx_bookinDate->EnableWindow(false);
tx_clientID->EnableWindow(false);
tx_clientLevel->EnableWindow(false);
tx_clientType->EnableWindow(false);
tx_company->EnableWindow(false);
tx_contactPerson->EnableWindow(false);
tx_area->EnableWindow(false);
tx_address->EnableWindow(false);
tx_postcode->EnableWindow(false);
tx_telephone->EnableWindow(false);
tx_fax->EnableWindow(false);
tx_eMail->EnableWindow(false);
tx_remark->EnableWindow(false);
tx_manageRange->EnableWindow(false);
tx_manageProduct->EnableWindow(false);
tx_accountBank->EnableWindow(false);
tx_acount->EnableWindow(false);
tx_taxNO->EnableWindow(false);
tx_registerDate->EnableWindow(false);
tx_registerFund->EnableWindow(false);
tx_scale->EnableWindow(false);
tx_industryCharacter->EnableWindow(false);
tx_allFunds->EnableWindow(false);
tx_clientCharacter->EnableWindow(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CClientInfor::OnClickClientList(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);
_RecordsetPtr m_pListRecordset; //用于创建一个查询记录集
CString strSQL;
//-----------------------------------------------
strSQL="SELECT * FROM client where clientID='"+m_clientID+"'";
HRESULT hTRes;
hTRes = m_pListRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pListRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
m_bookinDate=m_pListRecordset->GetCollect("bookinDate");
m_clientLevel=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientLevel"));
m_clientType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientType"));
m_company=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("company"));
m_contactPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("contactPerson"));
m_area=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("areaID"));
m_address=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("address"));
m_postcode=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("postcode"));
m_telephone=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("telephone"));
m_fax=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("fax"));
// m_website=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("website"));
m_eMail=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("eMail"));
m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("remark"));
m_manageRange=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("manageRange"));
m_manageProduct=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("manageProduct"));
m_accountBank=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("accountBank"));
m_acount=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("acount"));
m_taxNO=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("taxNO"));
m_registerDate=m_pListRecordset->GetCollect("registerDate");
CString str;
str=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("registerFund"));
m_registerFund=atof(str);
m_scale=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("scale"));
m_industryCharacter=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("industryCharacter"));
str=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("allFunds"));
m_allFunds=atof(str);
m_clientCharacter=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientCharacter"));
}
}
}
//AfxMessageBox(str);
bt_modify->EnableWindow(true);
bt_delete->EnableWindow(true);
UpdateData(false);
*pResult = 0;
}
void CClientInfor::Refresh()
{
m_clientList.DeleteAllItems();
_RecordsetPtr m_pListRecordset; //用于创建一个查询记录集
CString strSQL;
//-----------------------------------------------
strSQL="SELECT * FROM client";
HRESULT hTRes;
hTRes = m_pListRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pListRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
m_pListRecordset->MoveFirst();
if (!(m_pListRecordset->adoEOF))
{
int i=0;
while(!m_pListRecordset->adoEOF)
{
//_variant_t vIndex=(long)0;
m_clientList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientID")));
m_clientList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("bookinDate")));
m_clientList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientLevel")));
m_clientList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientType")));
m_clientList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("company")));
m_clientList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("contactPerson")));
m_clientList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("areaID")));
m_clientList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("address")));
m_clientList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("postcode")));
m_clientList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("telephone")));
m_clientList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("fax")));
m_clientList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("webSite")));
m_clientList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("eMail")));
m_clientList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("remark")));
m_clientList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("manageRange")));
m_clientList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("manageProduct")));
m_clientList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("accountBank")));
m_clientList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("acount")));
m_clientList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("taxNO")));
m_clientList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("registerDate")));
m_clientList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("registerFund")));
m_clientList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("scale")));
m_clientList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("industryCharacter")));
m_clientList.SetItemText(i,23,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("allFunds")));
m_clientList.SetItemText(i,24,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("clientCharacter")));
if (!(m_pListRecordset->adoEOF))
{
m_pListRecordset->MoveNext();
i++;
}
}
}
//---------------------------------------
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -