searchconsignmentform.cpp

基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码

	_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"));
		//	CComboBox clientList=GetDlgItem(IDC_client);
		//	AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
			while(!(m_pDepartmentRecordset->adoEOF))
			{		
				m_departmentCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pDepartmentRecordset->GetCollect("departmentName")));
				m_pDepartmentRecordset->MoveNext();
			}
		}
	}
	m_pDepartmentRecordset->Close();



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





	strSQL="select * from quote";
	_RecordsetPtr m_pQuoteRecordset;
	hTRes = m_pQuoteRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		//----------------------------------------------------
		hTRes = m_pQuoteRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
		//	CComboBox clientList=GetDlgItem(IDC_client);
		//	AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
			while(!(m_pQuoteRecordset->adoEOF))
			{		
				m_quoteIDCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pQuoteRecordset->GetCollect("quoteID")));
				m_pQuoteRecordset->MoveNext();
			}
		}
	}
	m_pQuoteRecordset->Close();
	
	strSQL="select * from staff";
	_RecordsetPtr m_pStaffRecordset;
	hTRes = m_pStaffRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		//----------------------------------------------------
		hTRes = m_pStaffRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
		//	CComboBox clientList=GetDlgItem(IDC_client);
		//	AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
			while(!(m_pStaffRecordset->adoEOF))
			{		
				m_sellerCombo.AddString(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pStaffRecordset->GetCollect("staffID")));
				m_pStaffRecordset->MoveNext();
			}
		}
	}
	m_pStaffRecordset->Close();


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


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


	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSearchConsignmentForm::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	HRESULT hTRes;
	CString strSQL;
	CString str;
	int flag=0;
	POSITION pos = m_consignmentFormList.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_consignmentFormList.GetNextSelectedItem(pos);
		
		str=m_consignmentFormList.GetItemText(nFirstSelItem,0);
	}
	strSQL="select * from consignmentFormView1 where consignmentFormID='";
	strSQL=strSQL+str+"'";
	_RecordsetPtr m_pConsignmentFormCommidityRecordset;
	hTRes = m_pConsignmentFormCommidityRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		//----------------------------------------------------
		hTRes = m_pConsignmentFormCommidityRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
			int i=0;
			m_commidityList.DeleteAllItems();
			while(!(m_pConsignmentFormCommidityRecordset->adoEOF))
			{		
				m_commidityList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pConsignmentFormCommidityRecordset->GetCollect("commidityID")));
				m_commidityList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pConsignmentFormCommidityRecordset->GetCollect("commodityName")));
				m_commidityList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pConsignmentFormCommidityRecordset->GetCollect("standardPrice")));
				m_commidityList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pConsignmentFormCommidityRecordset->GetCollect("num")));
				m_commidityList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pConsignmentFormCommidityRecordset->GetCollect("truePrice")));

				m_pConsignmentFormCommidityRecordset->MoveNext();
				i++;
			}
		}
	}
	
	*pResult = 0;
}

void CSearchConsignmentForm::OnYes() 
{
	is_checked=1;
	
}

void CSearchConsignmentForm::OnNo() 
{
	is_checked=-1;
	
}

void CSearchConsignmentForm::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	CString str;
	int flag=0;
	POSITION pos = m_consignmentFormList.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_consignmentFormList.GetNextSelectedItem(pos);		
		str=m_consignmentFormList.GetItemText(nFirstSelItem,0);
	}
	CConsignmentInvoice dlg;
	dlg.consignmentFormID=str;
	dlg.DoModal();
	
	*pResult = 0;
}