📄 selectclient.cpp
字号:
// SelectClient.cpp : implementation file
//
#include "stdafx.h"
#include "Sale.h"
#include "SelectClient.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CSelectClient dialog
CSelectClient::CSelectClient(CWnd* pParent /*=NULL*/)
: CDialog(CSelectClient::IDD, pParent)
{
//{{AFX_DATA_INIT(CSelectClient)
m_yearPlan = 0.0f;
m_yearRatio = 0.0f;
m_JanPlan = 0.0f;
m_JanRatio = 0.0f;
m_FebPlan = 0.0f;
m_FebRatio = 0.0f;
m_MarPlan = 0.0f;
m_MarRatio = 0.0f;
m_AprPlan = 0.0f;
m_AprRatio = 0.0f;
m_MayPlan = 0.0f;
m_MayRatio = 0.0f;
m_JunPlan = 0.0f;
m_JunRatio = 0.0f;
m_JulPlan = 0.0f;
m_JulRatio = 0.0f;
m_AugPlan = 0.0f;
m_AugRatio = 0.0f;
m_SepPlan = 0.0f;
m_SepRatio = 0.0f;
m_OctPlan = 0.0f;
m_OctRatio = 0.0f;
m_NovPlan = 0.0f;
m_NovRatio = 0.0f;
m_DecPlan = 0.0f;
m_DecRatio = 0.0f;
//}}AFX_DATA_INIT
}
void CSelectClient::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CSelectClient)
DDX_Control(pDX, IDC_LIST1, m_clientList);
// DDX_Text(pDX, IDC_yearPlan, m_yearPlan);
// DDX_Text(pDX, IDC_yearRatio, m_yearRatio);
DDX_Text(pDX, IDC_JanPlan, m_JanPlan);
DDX_Text(pDX, IDC_JanRatio, m_JanRatio);
DDX_Text(pDX, IDC_FebPlan, m_FebPlan);
DDX_Text(pDX, IDC_FebRatio, m_FebRatio);
DDX_Text(pDX, IDC_MarPlan, m_MarPlan);
DDX_Text(pDX, IDC_MarRatio, m_MarRatio);
DDX_Text(pDX, IDC_AprPlan, m_AprPlan);
DDX_Text(pDX, IDC_AprRatio, m_AprRatio);
DDX_Text(pDX, IDC_MayPlan, m_MayPlan);
DDX_Text(pDX, IDC_MayRatio, m_MayRatio);
DDX_Text(pDX, IDC_JunPlan, m_JunPlan);
DDX_Text(pDX, IDC_JunRatio, m_JunRatio);
DDX_Text(pDX, IDC_JulPlan, m_JulPlan);
DDX_Text(pDX, IDC_JulRatio, m_JulRatio);
DDX_Text(pDX, IDC_AugPlan, m_AugPlan);
DDX_Text(pDX, IDC_AugRatio, m_AugRatio);
DDX_Text(pDX, IDC_SepPlan, m_SepPlan);
DDX_Text(pDX, IDC_SepRatio, m_SepRatio);
DDX_Text(pDX, IDC_OctPlan, m_OctPlan);
DDX_Text(pDX, IDC_OctRatio, m_OctRatio);
DDX_Text(pDX, IDC_NovPlan, m_NovPlan);
DDX_Text(pDX, IDC_NovRatio, m_NovRatio);
DDX_Text(pDX, IDC_DecPlan, m_DecPlan);
DDX_Text(pDX, IDC_DecRatio, m_DecRatio);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CSelectClient, CDialog)
//{{AFX_MSG_MAP(CSelectClient)
ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickClientList)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CSelectClient message handlers
void CSelectClient::OnClickClientList(NMHDR* pNMHDR, LRESULT* pResult)
{
UpdateData(true);
POSITION pos = m_clientList.GetFirstSelectedItemPosition();
if(pos)
{
int nFirstSelItem = m_clientList.GetNextSelectedItem(pos);
clientID=m_clientList.GetItemText(nFirstSelItem,0);
clientName=m_clientList.GetItemText(nFirstSelItem,4);
}
*pResult=0;
}
BOOL CSelectClient::OnInitDialog()
{
CDialog::OnInitDialog();
DWORD style;
style=m_clientList.GetExStyle();
style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
m_clientList.SetExtendedStyle(style);
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);
_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"));
if (!(m_pListRecordset->adoEOF))
{
int i=0;
while(!m_pListRecordset->adoEOF)
{
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("创建客户记录集失败!","错误");
}
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -