searchcondition.cpp

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

// SearchCondition.cpp : implementation file
//

#include "stdafx.h"
#include "Sale.h"
#include "SearchCondition.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSearchCondition dialog


CSearchCondition::CSearchCondition(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchCondition::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchCondition)
	m_formDateBegin = 0;
	m_formDateEnd = 0;
	m_QuoteID = _T("");
	m_clientName = _T("");
	m_department = _T("");
	m_transportType = _T("");
	m_seller = _T("");
	//}}AFX_DATA_INIT
}


void CSearchCondition::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchCondition)
	DDX_Control(pDX, IDC_seller, m_sellerCombo);
	DDX_Control(pDX, IDC_transportType, m_transportTypeCombo);
	DDX_Control(pDX, IDC_department, m_departmentCombo);
	DDX_Control(pDX, IDC_clientName, m_clientNameCombo);
	DDX_Control(pDX, IDC_quoteID, m_quoteIDCombo);
	DDX_DateTimeCtrl(pDX, IDC_formDateBegin, m_formDateBegin);
	DDX_DateTimeCtrl(pDX, IDC_formDateEnd, m_formDateEnd);
	DDX_CBString(pDX, IDC_quoteID, m_QuoteID);
	DDX_CBString(pDX, IDC_clientName, m_clientName);
	DDX_CBString(pDX, IDC_department, m_department);
	DDX_CBString(pDX, IDC_transportType, m_transportType);
	DDX_CBString(pDX, IDC_seller, m_seller);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchCondition, CDialog)
	//{{AFX_MSG_MAP(CSearchCondition)
	ON_BN_CLICKED(IDC_BUTTON1, OnOK)
	ON_BN_CLICKED(IDC_BUTTON2, Oncancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchCondition message handlers

BOOL CSearchCondition::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	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"));
		//	CComboBox clientList=GetDlgItem(IDC_client);
		//	AfxMessageBox(((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pClientRecordset->GetCollect("clientID")));
			while(!(m_pClientRecordset->adoEOF))
			{		
			m_clientNameCombo.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"));
		//	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 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();


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

void CSearchCondition::OnOk() 
{
	this->OnOK();
	
}

void CSearchCondition::Oncancel() 
{
	this->OnCancel();
	
}