⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 productsaleplan.cpp

📁 基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
	CString strSQL;
	HRESULT hTRes;
	try
	{
		if(!(m_pSalePlanRecordset->adoEOF))
		{
			m_pSalePlanRecordset->MoveNext();
			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;
		m_commiditySalePlanList.DeleteAllItems();

		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)///捕捉异常
	{
		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 CProductSalePlan::OnLastPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	m_pSalePlanRecordset->MoveNext();
	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;
	m_commiditySalePlanList.DeleteAllItems();
	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++;
		}
	}

	if(!(m_pSalePlanRecordset->BOF))
	{
		bt_firstPage->EnableWindow(true);
		bt_prevPage->EnableWindow(true);
	}
	bt_nextPage->EnableWindow(false);
	bt_lastPage->EnableWindow(false);
	
	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 CProductSalePlan::OnNew() 
{
	bt_checked->EnableWindow(false);
	bt_cancellation->EnableWindow(true);
	SetDlgItemText(IDC_auditing,"审核");
	int commiditySalePlanID=((CSaleApp*)AfxGetApp())->m_pIDRecordset->GetCollect("commiditySalePlanID").intVal;
	if(commiditySalePlanID<10)
		m_planFormID.Format("commiditySalePlan0000%d",commiditySalePlanID);
	else if(commiditySalePlanID<100&&commiditySalePlanID>9)
		m_planFormID.Format("commiditySalePlan000%d",commiditySalePlanID);
	else if(commiditySalePlanID<1000&&commiditySalePlanID>99)
		m_planFormID.Format("commiditySalePlan00%d",commiditySalePlanID);

	CString str;
	str.Format("%d",commiditySalePlanID+1);
	((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("commiditySalePlanID",_variant_t(str));
	((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
//	m_planFormID = _T("");
	m_planFormYear = _T("");
	m_FormDate = COleDateTime::GetCurrentTime();
	m_remark = _T("");

	m_commiditySalePlanList.DeleteAllItems();
	flag=1;

	tx_planFormID->EnableWindow(false);
	tx_formDate->EnableWindow(false);
	tx_planFormYear->EnableWindow(true);
	tx_remark->EnableWindow(true);

	bt_addLine->EnableWindow(true);
	bt_deleteLine->EnableWindow(true);
	bt_save->EnableWindow(true);

	UpdateData(false);
	
}

void CProductSalePlan::OnModify() 
{
	if(m_pSalePlanRecordset->adoEOF)
		m_pSalePlanRecordset->MovePrevious();
	CString str;
	str=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pSalePlanRecordset->GetCollect("checked"));
	if(str=="T")
	{
		AfxMessageBox("已经通过审核，不可以修改！");
		return;
	}
	else
	{
		SetDlgItemText(IDC_auditing,"审核");
		flag=2;

	//	tx_planFormID->EnableWindow(true);
	//	tx_planFormYear->EnableWindow(true);
	//	tx_formDate->EnableWindow(true);
		tx_remark->EnableWindow(true);

		bt_firstPage->EnableWindow(false);
		bt_prevPage->EnableWindow(false);
		bt_nextPage->EnableWindow(false);
		bt_lastPage->EnableWindow(false);
		bt_add->EnableWindow(false);
		bt_save->EnableWindow(true);
		bt_modify->EnableWindow(false);
		bt_delete->EnableWindow(false);
		bt_addLine->EnableWindow(true);
		bt_deleteLine->EnableWindow(true);
	}
	UpdateData(false);	
}
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -