?? clientssaleplan.cpp
字號:
HRESULT hTRes;
try
{
if(!(m_pSalePlanRecordset->adoEOF))
{
m_pSalePlanRecordset->MoveNext();
// if (!(m_pSalePlanRecordset->adoEOF))
{
m_planID = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planID"));
DATE dt;
COleDateTime da;
dt=m_pSalePlanRecordset->GetCollect("formDate").date;
da=COleDateTime(dt);
m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
m_planYear = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planYear"));
m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("remark"));
CString checked;
checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("checked"));
if(checked=="T")
{
bt_modify->EnableWindow(false);
SetDlgItemText(IDC_auditing,"棄審");
}
else
{
bt_modify->EnableWindow(true);
SetDlgItemText(IDC_auditing,"審核");
}
strSQL="select * from clientSalePlanView where planID='";
strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planID"));
strSQL+="'";
}
//---------------------------------------
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
// m_pRecordset->MoveFirst();
int i=0;
m_clientSalePlanList.DeleteAllItems();
while(!(m_pRecordset->adoEOF))
{
m_clientSalePlanList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientID")));
m_clientSalePlanList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("company")));
m_clientSalePlanList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearPlan")));
m_clientSalePlanList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearRatio")));
m_clientSalePlanList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanPlan")));
m_clientSalePlanList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanRatio")));
m_clientSalePlanList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebPlan")));
m_clientSalePlanList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebRatio")));
m_clientSalePlanList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarPlan")));
m_clientSalePlanList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarRatio")));
m_clientSalePlanList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprPlan")));
m_clientSalePlanList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprRatio")));
m_clientSalePlanList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayPlan")));
m_clientSalePlanList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayRatio")));
m_clientSalePlanList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunPlan")));
m_clientSalePlanList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunRatio")));
m_clientSalePlanList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulPlan")));
m_clientSalePlanList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulRatio")));
m_clientSalePlanList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugPlan")));
m_clientSalePlanList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugRatio")));
m_clientSalePlanList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepPlan")));
m_clientSalePlanList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepRatio")));
m_clientSalePlanList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctPlan")));
m_clientSalePlanList.SetItemText(i,23,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctRatio")));
m_clientSalePlanList.SetItemText(i,24,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovPlan")));
m_clientSalePlanList.SetItemText(i,25,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovRatio")));
m_clientSalePlanList.SetItemText(i,26,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecPlan")));
m_clientSalePlanList.SetItemText(i,27,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecRatio")));
if (!(m_pRecordset->adoEOF))
{
m_pRecordset->MoveNext();
i++;
}
}
}
}
catch(_com_error e)///捕捉異常
{
bt_nextPage->EnableWindow(false);
bt_lastPage->EnableWindow(false);
AfxMessageBox("已經到達記錄集尾部！");
m_pSalePlanRecordset->MovePrevious();
}
bt_firstPage->EnableWindow(true);
bt_prevPage->EnableWindow(true);
bt_add->EnableWindow(true);
bt_save->EnableWindow(false);
// bt_modify->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_addLine->EnableWindow(false);
bt_deleteLine->EnableWindow(false);
UpdateData(false);
}
void CClientsSalePlan::OnPrevPage()
{
UpdateData(true);
_RecordsetPtr m_pRecordset;
CString strSQL;
HRESULT hTRes;
try
{
m_pSalePlanRecordset->MovePrevious();
if (!(m_pSalePlanRecordset->BOF))
{
m_planID = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planID"));
DATE dt;
COleDateTime da;
dt=m_pSalePlanRecordset->GetCollect("formDate").date;
da=COleDateTime(dt);
m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
m_planYear= ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planYear"));
m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("remark"));
CString checked;
checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("checked"));
if(checked=="T")
{
bt_modify->EnableWindow(false);
SetDlgItemText(IDC_auditing,"棄審");
}
else
{
bt_modify->EnableWindow(true);
SetDlgItemText(IDC_auditing,"審核");
}
strSQL="select * from clientSalePlanView where planID='";
strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planID"));
strSQL+="'";
}
//---------------------------------------
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
// m_pRecordset->MoveFirst();
int i=0;
m_clientSalePlanList.DeleteAllItems();
while(!(m_pRecordset->adoEOF))
{
m_clientSalePlanList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientID")));
m_clientSalePlanList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("company")));
m_clientSalePlanList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearPlan")));
m_clientSalePlanList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearRatio")));
m_clientSalePlanList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanPlan")));
m_clientSalePlanList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanRatio")));
m_clientSalePlanList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebPlan")));
m_clientSalePlanList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebRatio")));
m_clientSalePlanList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarPlan")));
m_clientSalePlanList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarRatio")));
m_clientSalePlanList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprPlan")));
m_clientSalePlanList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprRatio")));
m_clientSalePlanList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayPlan")));
m_clientSalePlanList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayRatio")));
m_clientSalePlanList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunPlan")));
m_clientSalePlanList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunRatio")));
m_clientSalePlanList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulPlan")));
m_clientSalePlanList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulRatio")));
m_clientSalePlanList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugPlan")));
m_clientSalePlanList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugRatio")));
m_clientSalePlanList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepPlan")));
m_clientSalePlanList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepRatio")));
m_clientSalePlanList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctPlan")));
m_clientSalePlanList.SetItemText(i,23,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctRatio")));
m_clientSalePlanList.SetItemText(i,24,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovPlan")));
m_clientSalePlanList.SetItemText(i,25,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovRatio")));
m_clientSalePlanList.SetItemText(i,26,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecPlan")));
m_clientSalePlanList.SetItemText(i,27,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecRatio")));
if (!(m_pRecordset->adoEOF))
{
m_pRecordset->MoveNext();
i++;
}
}
}
catch(_com_error e)///捕捉異常
{
bt_prevPage->EnableWindow(false);
bt_firstPage->EnableWindow(false);
AfxMessageBox("已經到達記錄集首部！");
m_pSalePlanRecordset->MoveNext();
}
bt_add->EnableWindow(true);
bt_save->EnableWindow(false);
// bt_modify->EnableWindow(true);
bt_delete->EnableWindow(true);
bt_addLine->EnableWindow(false);
bt_deleteLine->EnableWindow(false);
UpdateData(false);
}
void CClientsSalePlan::OnFirstPage()
{
UpdateData(true);
_RecordsetPtr m_pRecordset;
CString strSQL;
HRESULT hTRes;
m_pSalePlanRecordset->MoveFirst();
if (!(m_pSalePlanRecordset->adoEOF))
{
m_planID = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planID"));
DATE dt;
COleDateTime da;
dt=m_pSalePlanRecordset->GetCollect("formDate").date;
da=COleDateTime(dt);
m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
m_planYear = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planYear"));
m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("remark"));
CString checked;
checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("checked"));
if(checked=="T")
{
bt_modify->EnableWindow(false);
SetDlgItemText(IDC_auditing,"棄審");
}
else
{
bt_modify->EnableWindow(true);
SetDlgItemText(IDC_auditing,"審核");
}
strSQL="select * from clientSalePlanView where planID='";
strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("planID"));
strSQL+="'";
}
//---------------------------------------
hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
m_pRecordset->MoveFirst();
int i=0;
m_clientSalePlanList.DeleteAllItems();
while(!(m_pRecordset->adoEOF))
{
m_clientSalePlanList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientID")));
m_clientSalePlanList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("company")));
m_clientSalePlanList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearPlan")));
m_clientSalePlanList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearRatio")));
m_clientSalePlanList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanPlan")));
m_clientSalePlanList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanRatio")));
m_clientSalePlanList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebPlan")));
m_clientSalePlanList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebRatio")));
m_clientSalePlanList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarPlan")));
m_clientSalePlanList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarRatio")));
m_clientSalePlanList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprPlan")));
m_clientSalePlanList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprRatio")));
m_clientSalePlanList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayPlan")));
m_clientSalePlanList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayRatio")));
m_clientSalePlanList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunPlan")));
m_clientSalePlanList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunRatio")));
m_clientSalePlanList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulPlan")));
m_clientSalePlanList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulRatio")));
m_clientSalePlanList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugPlan")));
m_clientSalePlanList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugRatio")));
m_clientSalePlanList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepPlan")));
m_clientSalePlanList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepRatio")));
m_clientSalePlanList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctPlan")));
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -