📄 staffsaleplan.cpp
字号:
m_pRecordset->PutCollect("AugRatio",_variant_t(m_staffSalePlanList.GetItemText(i,19)));
m_pRecordset->PutCollect("SepPlan",_variant_t(m_staffSalePlanList.GetItemText(i,20)));
m_pRecordset->PutCollect("SepRatio",_variant_t(m_staffSalePlanList.GetItemText(i,21)));
m_pRecordset->PutCollect("OctPlan",_variant_t(m_staffSalePlanList.GetItemText(i,22)));
m_pRecordset->PutCollect("OctRatio",_variant_t(m_staffSalePlanList.GetItemText(i,23)));
m_pRecordset->PutCollect("NovPlan",_variant_t(m_staffSalePlanList.GetItemText(i,24)));
m_pRecordset->PutCollect("NovRatio",_variant_t(m_staffSalePlanList.GetItemText(i,25)));
m_pRecordset->PutCollect("DecPlan",_variant_t(m_staffSalePlanList.GetItemText(i,26)));
m_pRecordset->PutCollect("DecRatio",_variant_t(m_staffSalePlanList.GetItemText(i,27)));
m_pRecordset->Update();
}
AfxMessageBox("修改成功！");
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
bt_checked->EnableWindow(true);
bt_cancellation->EnableWindow(false);
UpdateData(false);
}
void CStaffSalePlan::OnExit()
{
this->OnCancel();
}
void CStaffSalePlan::OnClickStaffSalePlanList(NMHDR* pNMHDR, LRESULT* pResult)
{
UpdateData(true);
POSITION pos = m_staffSalePlanList.GetFirstSelectedItemPosition();
if(pos)
{
int nFirstSelItem = m_staffSalePlanList.GetNextSelectedItem(pos);
// m_payConditionTypeID=m_commiditySalePlanList.GetItemText(nFirstSelItem,0);
// m_payConditionTypeName=m_payConditionTypeList.GetItemText(nFirstSelItem,1);
// m_payConditionTypeRemark=m_payConditionTypeList.GetItemText(nFirstSelItem,2);
}
//AfxMessageBox(str);
bt_addLine->EnableWindow(true);
bt_deleteLine->EnableWindow(true);
UpdateData(false);
*pResult = 0;
}
BOOL CStaffSalePlan::OnInitDialog()
{
CDialog::OnInitDialog();
bt_firstPage=GetDlgItem(IDC_firstPage);
bt_prevPage=GetDlgItem(IDC_prevPage);
bt_nextPage=GetDlgItem(IDC_nextPage);
bt_lastPage=GetDlgItem(IDC_lastPage);
bt_add=GetDlgItem(IDC_new);
bt_save=GetDlgItem(IDC_save);
bt_modify=GetDlgItem(IDC_modify);
bt_delete=GetDlgItem(IDC_delete);
bt_addLine=GetDlgItem(IDC_addLine);
bt_deleteLine=GetDlgItem(IDC_deleteLine);
bt_checked=GetDlgItem(IDC_auditing);
bt_cancellation=GetDlgItem(IDC_cancellation);
DWORD style;
style=m_staffSalePlanList.GetExStyle();
style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
m_staffSalePlanList.SetExtendedStyle(style);
m_staffSalePlanList.InsertColumn(0,"销售员编号",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(1,"销售员姓名",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(2,"年计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(3,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(4,"1计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(5,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(6,"2计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(7,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(8,"3计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(9,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(10,"4计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(11,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(12,"5计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(13,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(14,"6计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(15,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(16,"7计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(17,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(18,"8计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(19,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(20,"9计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(21,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(22,"10计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(23,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(24,"11计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(25,"销售定额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(26,"12计划额",LVCFMT_LEFT,100);
m_staffSalePlanList.InsertColumn(27,"销售定额",LVCFMT_LEFT,100);
_RecordsetPtr m_pRecordset; //用于创建一个查询记录集
CString strSQL;
//-----------------------------------------------
strSQL="SELECT * FROM salePlan where planType='s'";
try
{
HRESULT hTRes;
hTRes = m_pSalePlanRecordset.CreateInstance(_T("ADODB.Recordset"));
if (SUCCEEDED(hTRes))
{
//----------------------------------------------------
hTRes = m_pSalePlanRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
adOpenDynamic,adLockPessimistic,adCmdText);
if(SUCCEEDED(hTRes))
{
TRACE(_T("连接成功!\n"));
//------------------------------------------
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")
{
SetDlgItemText(IDC_auditing,"弃审");
bt_modify->EnableWindow(false);
}
else
{
SetDlgItemText(IDC_auditing,"审核");
bt_modify->EnableWindow(true);
}
strSQL="select * from staffSalePlanView 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);
int i=0;
while(!(m_pRecordset->adoEOF))
{
m_staffSalePlanList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffID")));
m_staffSalePlanList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName")));
m_staffSalePlanList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearPlan")));
m_staffSalePlanList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearRatio")));
m_staffSalePlanList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanPlan")));
m_staffSalePlanList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanRatio")));
m_staffSalePlanList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebPlan")));
m_staffSalePlanList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebRatio")));
m_staffSalePlanList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarPlan")));
m_staffSalePlanList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarRatio")));
m_staffSalePlanList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprPlan")));
m_staffSalePlanList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprRatio")));
m_staffSalePlanList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayPlan")));
m_staffSalePlanList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayRatio")));
m_staffSalePlanList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunPlan")));
m_staffSalePlanList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunRatio")));
m_staffSalePlanList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulPlan")));
m_staffSalePlanList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulRatio")));
m_staffSalePlanList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugPlan")));
m_staffSalePlanList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugRatio")));
m_staffSalePlanList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepPlan")));
m_staffSalePlanList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SepRatio")));
m_staffSalePlanList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctPlan")));
m_staffSalePlanList.SetItemText(i,23,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctRatio")));
m_staffSalePlanList.SetItemText(i,24,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovPlan")));
m_staffSalePlanList.SetItemText(i,25,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovRatio")));
m_staffSalePlanList.SetItemText(i,26,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecPlan")));
m_staffSalePlanList.SetItemText(i,27,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecRatio")));
if (!(m_pRecordset->adoEOF))
{
m_pRecordset->MoveNext();
i++;
}
}
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
// }
flag=0;
tx_planID=GetDlgItem(IDC_planID);
tx_formDate=GetDlgItem(IDC_formDate);
tx_planYear=GetDlgItem(IDC_planYear);
tx_remark=GetDlgItem(IDC_remark);
tx_planID->EnableWindow(false);
tx_formDate->EnableWindow(false);
tx_planYear->EnableWindow(false);
tx_remark->EnableWindow(false);
bt_firstPage->EnableWindow(false);
bt_prevPage->EnableWindow(false);
if(m_pSalePlanRecordset->GetRecordCount()==1)
{
bt_nextPage->EnableWindow(false);
bt_lastPage->EnableWindow(false);
}
// bt_add->EnableWindow(false);
bt_save->EnableWindow(false);
// bt_modify->EnableWindow(false);
// bt_delete->EnableWindow(false);
bt_addLine->EnableWindow(false);
bt_deleteLine->EnableWindow(false);
bt_cancellation->EnableWindow(false);
UpdateData(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CStaffSalePlan::OnAuditing()
{
if(m_pSalePlanRecordset->adoEOF)
m_pSalePlanRecordset->MovePrevious();
CString str;
GetDlgItemText(IDC_auditing,str);
if(str=="审核")
{
m_pSalePlanRecordset->PutCollect("checked",_variant_t("T"));
m_pSalePlanRecordset->Update();
AfxMessageBox("通过审核！");
bt_modify->EnableWindow(false);
SetDlgItemText(IDC_auditing,"弃审");
}
else
{
m_pSalePlanRecordset->PutCollect("checked",_variant_t("F"));
m_pSalePlanRecordset->Update();
AfxMessageBox("审核取消！");
bt_modify->EnableWindow(true);
SetDlgItemText(IDC_auditing,"审核");
}
}
void CStaffSalePlan::OnCancellation()
{
int staffSalePlanID=((CSaleApp*)AfxGetApp())->m_pIDRecordset->GetCollect("staffSalePlanID").intVal;
CString str;
str.Format("%d",staffSalePlanID-1);
((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("staffSalePlanID",_variant_t(str));
((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
OnNextPage();
bt_checked->EnableWindow(true);
bt_cancellation->EnableWindow(false);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -