📄 productsaleplan.cpp
字号:
}
AfxMessageBox("插入成功！");
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建记录集失败!","错误");
}
}
bt_checked->EnableWindow(true);
bt_cancellation->EnableWindow(false);
UpdateData(false);
}
void CProductSalePlan::OnExit()
{
this->OnCancel();
}
BOOL CProductSalePlan::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_commiditySalePlanList.GetExStyle();
style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
m_commiditySalePlanList.SetExtendedStyle(style);
m_commiditySalePlanList.InsertColumn(0,"产品编号",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(1,"产品名称",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(2,"年计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(3,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(4,"1计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(5,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(6,"2计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(7,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(8,"3计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(9,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(10,"4计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(11,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(12,"5计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(13,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(14,"6计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(15,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(16,"7计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(17,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(18,"8计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(19,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(20,"9计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(21,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(22,"10计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(23,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(24,"11计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(25,"销售定额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(26,"12计划额",LVCFMT_LEFT,100);
m_commiditySalePlanList.InsertColumn(27,"销售定额",LVCFMT_LEFT,100);
_RecordsetPtr m_pRecordset; //用于创建一个查询记录集
CString strSQL;
//-----------------------------------------------
strSQL="SELECT * FROM salePlan where planType='1'";
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_planFormID = ((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_planFormYear = ((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 commiditySalePlanView 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_commiditySalePlanList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));
m_commiditySalePlanList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commodityName")));
m_commiditySalePlanList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearPlan")));
m_commiditySalePlanList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("yearRatio")));
m_commiditySalePlanList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanuaryPlan")));
m_commiditySalePlanList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JanuaryRatio")));
m_commiditySalePlanList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebruaryPlan")));
m_commiditySalePlanList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("FebruaryRatio")));
m_commiditySalePlanList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarchPlan")));
m_commiditySalePlanList.SetItemText(i,9,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MarchRatio")));
m_commiditySalePlanList.SetItemText(i,10,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprilPlan")));
m_commiditySalePlanList.SetItemText(i,11,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AprilRatio")));
m_commiditySalePlanList.SetItemText(i,12,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayPlan")));
m_commiditySalePlanList.SetItemText(i,13,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("MayRatio")));
m_commiditySalePlanList.SetItemText(i,14,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JunePlan")));
m_commiditySalePlanList.SetItemText(i,15,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JuneRatio")));
m_commiditySalePlanList.SetItemText(i,16,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulyPlan")));
m_commiditySalePlanList.SetItemText(i,17,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("JulyRatio")));
m_commiditySalePlanList.SetItemText(i,18,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugustPlan")));
m_commiditySalePlanList.SetItemText(i,19,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("AugustRatio")));
m_commiditySalePlanList.SetItemText(i,20,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SeptemberPlan")));
m_commiditySalePlanList.SetItemText(i,21,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("SeptemberRatio")));
m_commiditySalePlanList.SetItemText(i,22,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctoberPlan")));
m_commiditySalePlanList.SetItemText(i,23,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("OctoberRatio")));
m_commiditySalePlanList.SetItemText(i,24,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovemberPlan")));
m_commiditySalePlanList.SetItemText(i,25,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("NovemberRatio")));
m_commiditySalePlanList.SetItemText(i,26,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecemberPlan")));
m_commiditySalePlanList.SetItemText(i,27,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("DecemberRatio")));
if (!(m_pRecordset->adoEOF))
{
m_pRecordset->MoveNext();
i++;
}
}
}
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
MessageBox("创建报价单记录集失败!","错误");
}
flag=0;
tx_planFormID=GetDlgItem(IDC_planFormID);
tx_formDate=GetDlgItem(IDC_formDate);
tx_planFormYear=GetDlgItem(IDC_planYear);
tx_remark=GetDlgItem(IDC_remark);
tx_planFormID->EnableWindow(false);
tx_formDate->EnableWindow(false);
tx_planFormYear->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 CProductSalePlan::OnClickCommoditySaleList(NMHDR* pNMHDR, LRESULT* pResult)
{
UpdateData(true);
POSITION pos = m_commiditySalePlanList.GetFirstSelectedItemPosition();
if(pos)
{
int nFirstSelItem = m_commiditySalePlanList.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;
}
void CProductSalePlan::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 CProductSalePlan::OnCancellation()
{
int commiditySalePlanID=((CSaleApp*)AfxGetApp())->m_pIDRecordset->GetCollect("commiditySalePlanID").intVal;
CString str;
str.Format("%d",commiditySalePlanID-1);
((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("commiditySalePlanID",_variant_t(str));
((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
OnNextPage();
bt_cancellation->EnableWindow(false);
bt_checked->EnableWindow(true);
tx_planFormID->EnableWindow(false);
tx_formDate->EnableWindow(false);
tx_planFormYear->EnableWindow(false);
tx_remark->EnableWindow(false);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -