📄 productsaleplan.cpp
字号:
void CProductSalePlan::OnDelete()
{
CAffirm dlg;
if(dlg.DoModal()!=IDOK)
{
return;
}
_variant_t RecordsAffected;
CString strSQL;
strSQL="delete from salePlan where planID='";
strSQL=strSQL+m_planFormID+"'";
(((CSaleApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,&RecordsAffected,adCmdText);
m_commiditySalePlanList.DeleteAllItems();
UpdateData(false);
AfxMessageBox("报价单已删除！");
OnNextPage();
}
void CProductSalePlan::OnAddLine()
{
CSelectCommidity dlg;
if(dlg.DoModal()==IDOK)
{
UpdateData(true);
int i=m_commiditySalePlanList.GetItemCount();
m_commiditySalePlanList.InsertItem(i,dlg.commidityID);
m_commiditySalePlanList.SetItemText(i,1,dlg.commidityName);
CString str;
double yearPlan=0;
double yearRatio=0;
str.Format("%f",dlg.m_JanPlan);
m_commiditySalePlanList.SetItemText(i,4,str);
yearPlan+=dlg.m_JanPlan;
str.Format("%f",dlg.m_JanRatio);
m_commiditySalePlanList.SetItemText(i,5,str);
yearRatio+=dlg.m_JanRatio;
str.Format("%f",dlg.m_FebPlan);
m_commiditySalePlanList.SetItemText(i,6,str);
yearPlan+=dlg.m_FebPlan;
str.Format("%f",dlg.m_FebRatio);
m_commiditySalePlanList.SetItemText(i,7,str);
yearRatio+=dlg.m_FebRatio;
str.Format("%f",dlg.m_MarPlan);
m_commiditySalePlanList.SetItemText(i,8,str);
yearPlan+=dlg.m_MarPlan;
str.Format("%f",dlg.m_MarRatio);
m_commiditySalePlanList.SetItemText(i,9,str);
yearRatio+=dlg.m_MarRatio;
str.Format("%f",dlg.m_AprPlan);
m_commiditySalePlanList.SetItemText(i,10,str);
yearPlan+=dlg.m_AprPlan;
str.Format("%f",dlg.m_AprRatio);
m_commiditySalePlanList.SetItemText(i,11,str);
yearRatio+=dlg.m_AprRatio;
str.Format("%f",dlg.m_MayPlan);
m_commiditySalePlanList.SetItemText(i,12,str);
yearPlan+=dlg.m_MayPlan;
str.Format("%f",dlg.m_MayRatio);
m_commiditySalePlanList.SetItemText(i,13,str);
yearRatio+=dlg.m_MayRatio;
str.Format("%f",dlg.m_JunPlan);
m_commiditySalePlanList.SetItemText(i,14,str);
yearPlan+=dlg.m_JunPlan;
str.Format("%f",dlg.m_JunRatio);
m_commiditySalePlanList.SetItemText(i,15,str);
yearRatio+=dlg.m_JunRatio;
str.Format("%f",dlg.m_JulPlan);
m_commiditySalePlanList.SetItemText(i,16,str);
yearPlan+=dlg.m_JulPlan;
str.Format("%f",dlg.m_JulRatio);
m_commiditySalePlanList.SetItemText(i,17,str);
yearRatio+=dlg.m_JulRatio;
str.Format("%f",dlg.m_AugPlan);
m_commiditySalePlanList.SetItemText(i,18,str);
yearPlan+=dlg.m_AugPlan;
str.Format("%f",dlg.m_AugRatio);
m_commiditySalePlanList.SetItemText(i,19,str);
yearRatio+=dlg.m_AugRatio;
str.Format("%f",dlg.m_SepPlan);
m_commiditySalePlanList.SetItemText(i,20,str);
yearPlan+=dlg.m_SepPlan;
str.Format("%f",dlg.m_SepRatio);
m_commiditySalePlanList.SetItemText(i,21,str);
yearRatio+=dlg.m_SepRatio;
str.Format("%f",dlg.m_OctPlan);
m_commiditySalePlanList.SetItemText(i,22,str);
yearPlan+=dlg.m_OctPlan;
str.Format("%f",dlg.m_OctRatio);
m_commiditySalePlanList.SetItemText(i,23,str);
yearRatio+=dlg.m_OctRatio;
str.Format("%f",dlg.m_NovPlan);
m_commiditySalePlanList.SetItemText(i,24,str);
yearPlan+=dlg.m_NovPlan;
str.Format("%f",dlg.m_NovRatio);
m_commiditySalePlanList.SetItemText(i,25,str);
yearRatio+=dlg.m_NovRatio;
str.Format("%f",dlg.m_DecPlan);
m_commiditySalePlanList.SetItemText(i,26,str);
yearPlan+=dlg.m_DecPlan;
str.Format("%f",dlg.m_DecRatio);
m_commiditySalePlanList.SetItemText(i,27,str);
yearRatio+=dlg.m_DecRatio;
str.Format("%f",yearPlan);
m_commiditySalePlanList.SetItemText(i,2,str);
str.Format("%f",yearRatio);
m_commiditySalePlanList.SetItemText(i,3,str);
}
else
{
AfxMessageBox("没有添加产品销售计划！");
}
}
void CProductSalePlan::OnDeleteLine()
{
CAffirm dlg;
if(dlg.DoModal()!=IDOK)
{
return;
}
POSITION pos = m_commiditySalePlanList.GetFirstSelectedItemPosition();
if(pos)
{
int nFirstSelItem = m_commiditySalePlanList.GetNextSelectedItem(pos);
m_commiditySalePlanList.DeleteItem(nFirstSelItem);
}
}
void CProductSalePlan::OnSave()
{
UpdateData(true);
_RecordsetPtr m_pRecordset; //用于创建一个查询记录集
CString strSQL;
if(flag==1) //添加
{
strSQL="SELECT * FROM commiditySalePlan" ;
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_pSalePlanRecordset->AddNew();
m_pSalePlanRecordset->PutCollect("planID",_variant_t(m_planFormID));
m_pSalePlanRecordset->PutCollect("planYear",_variant_t(m_planFormYear));
m_pSalePlanRecordset->PutCollect("remark",_variant_t(m_remark));
m_pSalePlanRecordset->PutCollect("planType",_variant_t("1"));
m_pSalePlanRecordset->PutCollect("formDate",_variant_t(m_FormDate));
m_pSalePlanRecordset->PutCollect("checked",_variant_t("F"));
m_pSalePlanRecordset->Update();
//------------------------------------------
for(int i=0;i<m_commiditySalePlanList.GetItemCount();i++)
{
m_pRecordset->AddNew();
m_pRecordset->PutCollect("planID",_variant_t(m_planFormID));
m_pRecordset->PutCollect("commidityID",_variant_t(m_commiditySalePlanList.GetItemText(i,0)));
//以下插入每月的销售计划数额
m_pRecordset->PutCollect("yearPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,2)));
m_pRecordset->PutCollect("yearRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,3)));
m_pRecordset->PutCollect("JanuaryPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,4)));
m_pRecordset->PutCollect("JanuaryRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,5)));
m_pRecordset->PutCollect("FebruaryPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,6)));
m_pRecordset->PutCollect("FebruaryRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,7)));
m_pRecordset->PutCollect("MarchPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,8)));
m_pRecordset->PutCollect("MarchRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,9)));
m_pRecordset->PutCollect("AprilPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,10)));
m_pRecordset->PutCollect("AprilRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,11)));
m_pRecordset->PutCollect("MayPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,12)));
m_pRecordset->PutCollect("MayRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,13)));
m_pRecordset->PutCollect("JunePlan",_variant_t(m_commiditySalePlanList.GetItemText(i,14)));
m_pRecordset->PutCollect("JuneRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,15)));
m_pRecordset->PutCollect("JulyPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,16)));
m_pRecordset->PutCollect("JulyRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,17)));
m_pRecordset->PutCollect("AugustPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,18)));
m_pRecordset->PutCollect("AugustRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,19)));
m_pRecordset->PutCollect("SeptemberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,20)));
m_pRecordset->PutCollect("SeptemberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,21)));
m_pRecordset->PutCollect("OctoberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,22)));
m_pRecordset->PutCollect("OctoberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,23)));
m_pRecordset->PutCollect("NovemberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,24)));
m_pRecordset->PutCollect("NovemberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,25)));
m_pRecordset->PutCollect("DecemberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,26)));
m_pRecordset->PutCollect("DecemberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,27)));
m_pRecordset->Update();
}
AfxMessageBox("插入成功！");
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
else if(flag==2) //修改
{
_variant_t RecordsAffected;
strSQL="delete from commiditySalePlan where planID='";
strSQL=strSQL+m_planFormID+"'";
(((CSaleApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,&RecordsAffected,adCmdText);
strSQL="SELECT * FROM commiditySalePlan " ;
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_pSalePlanRecordset->PutCollect("planID",_variant_t(m_planID));
// m_pSalePlanRecordset->PutCollect("planYear",_variant_t(m_planYear));
m_pSalePlanRecordset->PutCollect("remark",_variant_t(m_remark));
m_pSalePlanRecordset->Update();
//------------------------------------------
for(int i=0;i<m_commiditySalePlanList.GetItemCount();i++)
{
m_pRecordset->AddNew();
m_pRecordset->PutCollect("planID",_variant_t(m_planFormID));
m_pRecordset->PutCollect("commidityID",_variant_t(m_commiditySalePlanList.GetItemText(i,0)));
//以下插入每月的销售计划数额
m_pRecordset->PutCollect("yearPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,2)));
m_pRecordset->PutCollect("yearRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,3)));
m_pRecordset->PutCollect("JanuaryPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,4)));
m_pRecordset->PutCollect("JanuaryRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,5)));
m_pRecordset->PutCollect("FebruaryPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,6)));
m_pRecordset->PutCollect("FebruaryRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,7)));
m_pRecordset->PutCollect("MarchPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,8)));
m_pRecordset->PutCollect("MarchRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,9)));
m_pRecordset->PutCollect("AprilPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,10)));
m_pRecordset->PutCollect("AprilRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,11)));
m_pRecordset->PutCollect("MayPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,12)));
m_pRecordset->PutCollect("MayRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,13)));
m_pRecordset->PutCollect("JunePlan",_variant_t(m_commiditySalePlanList.GetItemText(i,14)));
m_pRecordset->PutCollect("JuneRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,15)));
m_pRecordset->PutCollect("JulyPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,16)));
m_pRecordset->PutCollect("JulyRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,17)));
m_pRecordset->PutCollect("AugustPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,18)));
m_pRecordset->PutCollect("AugustRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,19)));
m_pRecordset->PutCollect("SeptemberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,20)));
m_pRecordset->PutCollect("SeptemberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,21)));
m_pRecordset->PutCollect("OctoberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,22)));
m_pRecordset->PutCollect("OctoberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,23)));
m_pRecordset->PutCollect("NovemberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,24)));
m_pRecordset->PutCollect("NovemberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,25)));
m_pRecordset->PutCollect("DecemberPlan",_variant_t(m_commiditySalePlanList.GetItemText(i,26)));
m_pRecordset->PutCollect("DecemberRatio",_variant_t(m_commiditySalePlanList.GetItemText(i,27)));
m_pRecordset->Update();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -