📄 clientinfor.cpp
字号:
{
//----------------------------------------------------
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
m_pRecordset->AddNew();
m_pRecordset->PutCollect("clientID",_variant_t(m_clientID));
m_pRecordset->PutCollect("bookinDate",_variant_t(m_bookinDate));
m_pRecordset->PutCollect("clientLevel",_variant_t(m_clientLevel));
m_pRecordset->PutCollect("clientType",_variant_t(m_clientType));
m_pRecordset->PutCollect("company",_variant_t(m_company));
m_pRecordset->PutCollect("contactPerson",_variant_t(m_contactPerson));
m_pRecordset->PutCollect("areaID",_variant_t(m_area));
m_pRecordset->PutCollect("address",_variant_t(m_address));
m_pRecordset->PutCollect("postcode",_variant_t(m_postcode));
m_pRecordset->PutCollect("telephone",_variant_t(m_telephone));
m_pRecordset->PutCollect("fax",_variant_t(m_fax));
// m_pRecordset->PutCollect("website",_variant_t(m_website));
m_pRecordset->PutCollect("eMail",_variant_t(m_eMail));
m_pRecordset->PutCollect("remark",_variant_t(m_remark));
m_pRecordset->PutCollect("manageRange",_variant_t(m_manageRange));
m_pRecordset->PutCollect("manageProduct",_variant_t(m_manageProduct));
m_pRecordset->PutCollect("accountBank",_variant_t(m_accountBank));
m_pRecordset->PutCollect("acount",_variant_t(m_acount));
m_pRecordset->PutCollect("taxNO",_variant_t(m_taxNO));
m_pRecordset->PutCollect("registerDate",_variant_t(m_registerDate));
m_pRecordset->PutCollect("registerFund",_variant_t(m_registerFund));
m_pRecordset->PutCollect("scale",_variant_t(m_scale));
m_pRecordset->PutCollect("industryCharacter",_variant_t(m_industryCharacter));
m_pRecordset->PutCollect("allFunds",_variant_t(m_allFunds));
m_pRecordset->PutCollect("clientCharacter",_variant_t(m_clientCharacter));
m_pRecordset->Update();
int j;
// j=m_clientList.GetItemCount();
// m_clientList.InsertItem(j,m_clientID);
// m_clientList.SetItemText(j,1,(LPCTSTR)(_bstr_t)(m_bookinDate));
// m_clientList.SetItemText(j,2,m_clientLevel);
// m_clientList.SetItemText(j,3,m_clientType);
// m_clientList.SetItemText(j,4,m_company);
// m_clientList.SetItemText(j,5,m_contactPerson);
// m_clientList.SetItemText(j,6,m_area);
// m_clientList.SetItemText(j,7,m_address);
// m_clientList.SetItemText(j,8,m_postcode);
// m_clientList.SetItemText(j,9,m_telephone);
// m_clientList.SetItemText(j,10,m_fax);
// m_clientList.SetItemText(j,11,m_webSite);
// m_clientList.SetItemText(j,12,m_eMail);
// m_clientList.SetItemText(j,13,m_remark);
// m_clientList.SetItemText(j,14,m_manageRange);
// m_clientList.SetItemText(j,15,m_manageProduct);
// m_clientList.SetItemText(j,16,m_accountBank);
// m_clientList.SetItemText(j,17,m_acount);
// m_clientList.SetItemText(j,18,m_taxNO);
// m_clientList.SetItemText(j,19,(LPCTSTR)(_bstr_t)(m_registerDate));
// m_clientList.SetItemText(j,20,(LPCTSTR)(_bstr_t)(m_registerFund));
// m_clientList.SetItemText(j,21,m_scale);
// m_clientList.SetItemText(j,22,m_industryCharacter);
// m_clientList.SetItemText(j,23,m_allFunds);
// m_clientList.SetItemText(j,24,m_clientCharacter);
AfxMessageBox("插入成功！");
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
else if(flag==2) //修改
{
strSQL="SELECT * FROM client where clientID='" ;
strSQL=strSQL+m_clientID+"'";
try
{
HRESULT hTRes;
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);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
m_pRecordset->PutCollect("clientID",_variant_t(m_clientID));
m_pRecordset->PutCollect("bookinDate",_variant_t(m_bookinDate));
m_pRecordset->PutCollect("clientLevel",_variant_t(m_clientLevel));
m_pRecordset->PutCollect("clientType",_variant_t(m_clientType));
m_pRecordset->PutCollect("company",_variant_t(m_company));
m_pRecordset->PutCollect("contactPerson",_variant_t(m_contactPerson));
m_pRecordset->PutCollect("areaID",_variant_t(m_area));
m_pRecordset->PutCollect("address",_variant_t(m_address));
m_pRecordset->PutCollect("postcode",_variant_t(m_postcode));
m_pRecordset->PutCollect("telephone",_variant_t(m_telephone));
m_pRecordset->PutCollect("fax",_variant_t(m_fax));
// m_pRecordset->PutCollect("website",_variant_t(m_website));
m_pRecordset->PutCollect("eMail",_variant_t(m_eMail));
m_pRecordset->PutCollect("remark",_variant_t(m_remark));
m_pRecordset->PutCollect("manageRange",_variant_t(m_manageRange));
m_pRecordset->PutCollect("manageProduct",_variant_t(m_manageProduct));
m_pRecordset->PutCollect("accountBank",_variant_t(m_accountBank));
m_pRecordset->PutCollect("acount",_variant_t(m_acount));
m_pRecordset->PutCollect("taxNO",_variant_t(m_taxNO));
m_pRecordset->PutCollect("registerDate",_variant_t(m_registerDate));
m_pRecordset->PutCollect("registerFund",_variant_t(m_registerFund));
m_pRecordset->PutCollect("scale",_variant_t(m_scale));
m_pRecordset->PutCollect("industryCharacter",_variant_t(m_industryCharacter));
m_pRecordset->PutCollect("allFunds",_variant_t(m_allFunds));
m_pRecordset->PutCollect("clientCharacter",_variant_t(m_clientCharacter));
m_pRecordset->Update();
AfxMessageBox("修改成功！");
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
Refresh();
bt_add->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_modify->EnableWindow(true);
bt_save->EnableWindow(true);
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);
UpdateData(false);//
}
void CClientInfor::OnExit()
{
this->OnCancel();
}
BOOL CClientInfor::OnInitDialog()
{
CDialog::OnInitDialog();
DWORD style;
style=m_clientList.GetExStyle();
style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
m_clientList.SetExtendedStyle(style);
// TODO: Add extra initialization here
m_clientList.InsertColumn(0,"客户编号",LVCFMT_LEFT,100);
m_clientList.InsertColumn(1,"登记日期",LVCFMT_LEFT,100);
m_clientList.InsertColumn(2,"客户级别",LVCFMT_LEFT,100);
m_clientList.InsertColumn(3,"客户类型",LVCFMT_LEFT,100);
m_clientList.InsertColumn(4,"单位名称",LVCFMT_LEFT,100);
m_clientList.InsertColumn(5,"联系人",LVCFMT_LEFT,100);
m_clientList.InsertColumn(6,"地区",LVCFMT_LEFT,100);
m_clientList.InsertColumn(7,"地址",LVCFMT_LEFT,100);
m_clientList.InsertColumn(8,"邮编",LVCFMT_LEFT,100);
m_clientList.InsertColumn(9,"电话",LVCFMT_LEFT,100);
m_clientList.InsertColumn(10,"传真",LVCFMT_LEFT,100);
m_clientList.InsertColumn(11,"网站",LVCFMT_LEFT,100);
m_clientList.InsertColumn(12,"邮箱",LVCFMT_LEFT,100);
m_clientList.InsertColumn(13,"备注",LVCFMT_LEFT,100);
m_clientList.InsertColumn(14,"经营范围",LVCFMT_LEFT,100);
m_clientList.InsertColumn(15,"经营产品",LVCFMT_LEFT,100);
m_clientList.InsertColumn(16,"开户行",LVCFMT_LEFT,100);
m_clientList.InsertColumn(17,"账号",LVCFMT_LEFT,100);
m_clientList.InsertColumn(18,"税号",LVCFMT_LEFT,100);
m_clientList.InsertColumn(19,"注册日期",LVCFMT_LEFT,100);
m_clientList.InsertColumn(20,"注册资金",LVCFMT_LEFT,100);
m_clientList.InsertColumn(21,"规模",LVCFMT_LEFT,100);
m_clientList.InsertColumn(22,"行业性质",LVCFMT_LEFT,100);
m_clientList.InsertColumn(23,"总资产",LVCFMT_LEFT,100);
m_clientList.InsertColumn(24,"性质",LVCFMT_LEFT,100);
CString strSQL;
HRESULT hTRes;
strSQL="select * from clientType";
_RecordsetPtr m_pClientTypeRecordset;
hTRes = m_pClientTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pClientTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox((LPCTSTR)(_bstr_t)(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pClientTypeRecordset->adoEOF))
{
m_clientTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientTypeRecordset->GetCollect("clientTypeID")));
m_pClientTypeRecordset->MoveNext();
}
}
}
m_pClientTypeRecordset->Close();
strSQL="select * from clientLevel";
_RecordsetPtr m_pClientLevelRecordset;
hTRes = m_pClientLevelRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pClientLevelRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
while(!(m_pClientLevelRecordset->adoEOF))
{
m_clientLevelCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientLevelRecordset->GetCollect("clientLevelID")));
m_pClientLevelRecordset->MoveNext();
}
}
}
m_pClientLevelRecordset->Close();
strSQL="select * from area";
_RecordsetPtr m_pAreaRecordset;
hTRes = m_pAreaRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
hTRes = m_pAreaRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
// CComboBox clientList=GetDlgItem(IDC_client);
// AfxMessageBox((LPCTSTR)(_bstr_t)(m_pClientRecordset->GetCollect("clientID")));
while(!(m_pAreaRecordset->adoEOF))
{
m_areaCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pAreaRecordset->GetCollect("areaID")));
m_pAreaRecordset->MoveNext();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -