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

📄 salecontract.cpp

📁 基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
		if (!(m_pRecordset->adoEOF))
		{
			m_pRecordset->MoveNext();
			i++;
		}
	}
	bt_prevPage->EnableWindow(false);
	bt_firstPage->EnableWindow(false);
	bt_lastPage->EnableWindow(true);
	bt_nextPage->EnableWindow(true);

	UpdateData(false);
	
}

void CSaleContract::OnPrevPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	try
	{
	
		m_psaleContractRecordset->MovePrevious();
		
		if (!(m_psaleContractRecordset->adoEOF))
		{
			m_planID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("quoteID"));
			m_contractID = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractID"));
			DATE dt;
			COleDateTime da;
			dt=m_psaleContractRecordset->GetCollect("formDate").date;
			da=COleDateTime(dt); 
			m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("saleType"));
			m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("department"));
			m_contractType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractType"));
			m_seller =((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("sellor"));
			m_companyContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("companyContractPerson"));
			m_transportType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("transportType"));
			m_consignmentAddress=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("consignmentAddress"));
			m_clientContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("clientContractPerson"));
			m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("payCondition"));
			m_subscription=atof(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("subscription")));
			dt=m_psaleContractRecordset->GetCollect("contractEndDate").date;
			da=COleDateTime(dt); 
			m_contractEndDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("clientName"));

			CString checked;
			checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("checked"));
			if(checked=="T")
			{
				SetDlgItemText(IDC_auditing,"弃审");
				bt_modify->EnableWindow(false);
			}
			else
			{
				SetDlgItemText(IDC_auditing,"审核");
				bt_modify->EnableWindow(true);
			}

			strSQL="select * from saleContractView where contractID='";
			strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractID"));
			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_contractList.DeleteAllItems();
		while(!(m_pRecordset->adoEOF))
		{
			m_contractList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));
			m_contractList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commodityName")));				
			m_contractList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standardPrice")));
			m_contractList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));				
			m_contractList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("truePrice")));
			if (!(m_pRecordset->adoEOF))
			{
				m_pRecordset->MoveNext();
				i++;
			}
		}

	}
	catch(_com_error e)///捕捉异常
	{
		bt_firstPage->EnableWindow(false);
		bt_prevPage->EnableWindow(false);
		m_psaleContractRecordset->MoveNext();
		AfxMessageBox("已经到达纪录集的首部！");
	}
	bt_nextPage->EnableWindow(true);
	bt_lastPage->EnableWindow(true);
	UpdateData(false);
	
}

void CSaleContract::OnNextPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	try
	{
		m_psaleContractRecordset->MoveNext();
		
		if (!(m_psaleContractRecordset->adoEOF))
		{
			m_planID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("quoteID"));
			m_contractID = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractID"));
			DATE dt;
			COleDateTime da;
			dt=m_psaleContractRecordset->GetCollect("formDate").date;
			da=COleDateTime(dt); 
			m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("saleType"));
			m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("department"));
			m_contractType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractType"));
			m_seller =((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("sellor"));
			m_companyContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("companyContractPerson"));
			m_transportType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("transportType"));
			m_consignmentAddress=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("consignmentAddress"));
			m_clientContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("clientContractPerson"));
			m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("payCondition"));
			m_subscription=atof(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("subscription")));
			dt=m_psaleContractRecordset->GetCollect("contractEndDate").date;
			da=COleDateTime(dt); 
			m_contractEndDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("clientName"));
	
			CString checked;
			checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("checked"));
			if(checked=="T")
			{
				SetDlgItemText(IDC_auditing,"弃审");
				bt_modify->EnableWindow(false);
			}
			else
			{
				SetDlgItemText(IDC_auditing,"审核");
				bt_modify->EnableWindow(true);
			}

			strSQL="select * from saleContractView where contractID='";
			strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractID"));
			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_contractList.DeleteAllItems();
		while(!(m_pRecordset->adoEOF))
		{
			m_contractList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));
			m_contractList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commodityName")));				
			m_contractList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standardPrice")));
			m_contractList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));				
			m_contractList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("truePrice")));
			if (!(m_pRecordset->adoEOF))
			{
				m_pRecordset->MoveNext();
				i++;
			}
		}
	}

	catch(_com_error e)///捕捉异常
	{
		bt_lastPage->EnableWindow(false);
		bt_nextPage->EnableWindow(false);
		m_psaleContractRecordset->MovePrevious();
		AfxMessageBox("已经到达纪录集的尾部！");
	}
	bt_firstPage->EnableWindow(true);
	bt_prevPage->EnableWindow(true);
	UpdateData(false);
}

void CSaleContract::OnLastPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	m_psaleContractRecordset->MoveLast();
	
	if (!(m_psaleContractRecordset->adoEOF))
	{
		m_planID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("quoteID"));
		m_contractID = ((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractID"));
		DATE dt;
		COleDateTime da;
		dt=m_psaleContractRecordset->GetCollect("formDate").date;
		da=COleDateTime(dt); 
		m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
		m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("saleType"));
		m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("department"));
		m_contractType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractType"));
		m_seller =((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("sellor"));
		m_companyContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("companyContractPerson"));
		m_transportType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("transportType"));
		m_consignmentAddress=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("consignmentAddress"));
		m_clientContractPerson=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("clientContractPerson"));
		m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("payCondition"));
		m_subscription=atof(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("subscription")));
		dt=m_psaleContractRecordset->GetCollect("contractEndDate").date;
		da=COleDateTime(dt); 
		m_contractEndDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
		m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("clientName"));

		CString checked;
		checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("checked"));
		if(checked=="T")
		{
			SetDlgItemText(IDC_auditing,"弃审");
			bt_modify->EnableWindow(false);
		}
		else
		{
			SetDlgItemText(IDC_auditing,"审核");
			bt_modify->EnableWindow(true);
		}

		strSQL="select * from saleContractView where contractID='";
		strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_psaleContractRecordset->GetCollect("contractID"));
		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_contractList.DeleteAllItems();
	while(!(m_pRecordset->adoEOF))
	{
		m_contractList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));
		m_contractList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commodityName")));				
		m_contractList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standardPrice")));
		m_contractList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));				
		m_contractList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("truePrice")));
		if (!(m_pRecordset->adoEOF))
		{
			m_pRecordset->MoveNext();
			i++;
		}
	}

	bt_firstPage->EnableWindow(true);
	bt_prevPage->EnableWindow(true);
	bt_lastPage->EnableWindow(false);
	bt_nextPage->EnableWindow(false);
	UpdateData(false);
	
}

void CSaleContract::OnNew() 
{
	bt_checked->EnableWindow(false);
	bt_cancellaion->EnableWindow(true);
	SetDlgItemText(IDC_auditing,"审核");
	CString strSQL;
	HRESULT hTRes;
	strSQL="select * from client";
	_RecordsetPtr m_pClientRecordset;
	hTRes = m_pClientRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pClientRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
			while(!(m_pClientRecordset->adoEOF))
			{		
			m_clientCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
			m_pClientRecordset->MoveNext();
			}
		}
	}
	m_pClientRecordset->Close();

	strSQL="select * from transportType";
	_RecordsetPtr m_pTransportTypeRecordset;
	hTRes = m_pTransportTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pTransportTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
			while(!(m_pTransportTypeRecordset->adoEOF))
			{		
				m_transportTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTransportTypeRecordset->GetCollect("transportTypeName")));
				m_pTransportTypeRecordset->MoveNext();
			}
		}
	}
	m_pTransportTypeRecordset->Close();


	strSQL="select * from department";
	_RecordsetPtr m_pDepartmentRecordset;
	hTRes = m_pDepartmentRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pDepartmentRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
			while(!(m_pDepartmentRecordset->adoEOF))
			{		
				m_departmentCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDepartmentRecordset->GetCollect("departmentName")));
				m_pDepartmentRecordset->MoveNext();
			}
		}
	}
	m_pDepartmentRecordset->Close();

	strSQL="select * from contractType";
	_RecordsetPtr m_pContractTypeRecordset;
	hTRes = m_pContractTypeRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pContractTypeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
			while(!(m_pContractTypeRecordset->adoEOF))
			{		
				m_contractTypeCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractTypeRecordset->GetCollect("contractTypeName")));
				m_pContractTypeRecordset->MoveNext();
			}
1234

⌨️ 快捷键说明

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