searchsalecontract.cpp

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

// SearchSaleContract.cpp : implementation file
//

#include "stdafx.h"
#include "Sale.h"
#include "SearchSaleContract.h"
#include "SaleContract.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchSaleContract dialog


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


void CSearchSaleContract::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchSaleContract)
	DDX_Control(pDX, IDC_LIST2, m_commidityList);
	DDX_Control(pDX, IDC_LIST1, m_contractList);
	DDX_Control(pDX, IDC_contractType, m_contractTypeCombo);
	DDX_Control(pDX, IDC_transportType, m_transportTypeCombo);
	DDX_Control(pDX, IDC_seller, m_sellerCombo);
	DDX_Control(pDX, IDC_clientName, m_clientNameCombo);
	DDX_Control(pDX, IDC_department, m_departmentCombo);
	DDX_Control(pDX, IDC_contractID, m_contractIDCombo);
	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_contractID, m_contractID);
	DDX_CBString(pDX, IDC_department, m_department);
	DDX_CBString(pDX, IDC_clientName, m_clientName);
	DDX_CBString(pDX, IDC_seller, m_seller);
	DDX_CBString(pDX, IDC_transportType, m_transportType);
	DDX_CBString(pDX, IDC_contractType, m_contractType);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchSaleContract, CDialog)
	//{{AFX_MSG_MAP(CSearchSaleContract)
	ON_BN_CLICKED(IDC_search, OnSearch)
	ON_NOTIFY(LVN_ITEMCHANGING, IDC_LIST1, OnItemchangingList)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList)
	ON_BN_CLICKED(IDC_RADIO1, OnYes)
	ON_BN_CLICKED(IDC_RADIO2, OnNo)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchSaleContract message handlers

void CSearchSaleContract::OnSearch() 
{
	UpdateData(true);
	HRESULT hTRes;
	CString strSQL;
	int flag=0;
	m_contractList.DeleteAllItems();
	strSQL="select * from saleContract";
	if(((CSaleApp*)AfxGetApp())->ToStringCTime(m_formDateBegin)!="")
	{
		strSQL=strSQL+" where formDate>='"+((CSaleApp*)AfxGetApp())->ToStringCTime(m_formDateBegin)+"'";
		flag=1;
	}
	if(((CSaleApp*)AfxGetApp())->ToStringCTime(m_formDateEnd)!="")
	{
		strSQL=strSQL+" and formDate<'"+((CSaleApp*)AfxGetApp())->ToStringCTime(m_formDateEnd)+"'";
	//	AfxMessageBox(strSQL);
	}
	if(m_clientName!=""&&flag==1)
	{
		strSQL=strSQL+" and clientName='"+m_clientName+"'";
	}
	else if(m_clientName!=""&&flag==1)
	{
		strSQL=strSQL+" where clientName='"+m_clientName+"'";
		flag=1;
	}
	if(m_department!=""&&flag==1)
	{
		strSQL=strSQL+" and department='"+m_department+"'";
	}
	else if(m_department!=""&&flag==0)
	{
		strSQL=strSQL+" where department='"+m_department+"'";
		flag=1;
	}
	if(m_quoteID!=""&&flag==1)
	{
		strSQL=strSQL+" and quoteID='"+m_quoteID+"'";
	}
	else if(m_quoteID!=""&&flag==0)
	{
		strSQL=strSQL+" where quoteID='"+m_quoteID+"'";
		flag=1;
	}

	if(m_contractID!=""&&flag==1)
	{
		strSQL=strSQL+" and contractID='"+m_contractID+"'";
	}
	else if(m_quoteID!=""&&flag==0)
	{
		strSQL=strSQL+" where contractID='"+m_contractID+"'";
		flag=1;
	}
	if(m_seller!=""&&flag==1)
	{
		strSQL=strSQL+" and sellor='"+m_seller+"'";
	}
	else if(m_seller!=""&&flag==0)
	{
		strSQL=strSQL+" where sellor='"+m_seller+"'";
		flag=1;
	}
	if(m_contractType!=""&&flag==1)
	{
		strSQL=strSQL+" and contracttype='"+m_contractType+"'";
	}
	else if(m_contractType!=""&&flag==0)
	{
		strSQL=strSQL+" where contracttype='"+m_contractType+"'";
		flag=1;
	}
	if(m_transportType!=""&&flag==1)
	{
		strSQL=strSQL+" and transportType='"+m_transportType+"'";
	}
	else if(m_transportType!=""&&flag==0)
	{
		strSQL=strSQL+" where transportType='"+m_transportType+"'";
	}
	if(is_checked==1)
	{
		strSQL=strSQL+" and checked='T'";
	}
	else if(is_checked==-1)
	{
		strSQL=strSQL+" and checked='F'";
	}


	_RecordsetPtr m_pContractRecordset;
	hTRes = m_pContractRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		//----------------------------------------------------
		hTRes = m_pContractRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
		((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		if(SUCCEEDED(hTRes))
		{
			TRACE(_T("连接成功!\n"));
			int i=0;
			m_contractList.DeleteAllItems();
			while(!(m_pContractRecordset->adoEOF))
			{		
				m_contractList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("quoteID")));
				m_contractList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("contractID")));
				m_contractList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("formDate")));
				m_contractList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("clientName")));
				m_contractList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("transportType")));
			
				m_contractList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("payCondition")));
				m_contractList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("sellor")));
				m_contractList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("department")));
				m_contractList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("consignmentAddress")));
		//		m_contractList.SetItemText(i,8,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pContractRecordset->GetCollect("remark")));

	
				m_pContractRecordset->MoveNext();
				i++;
			}
		}
	}
	m_pContractRecordset->Close();
	UpdateData(false);
	
}

BOOL CSearchSaleContract::OnInitDialog() 
{
	CDialog::OnInitDialog();	
	DWORD style;
	style=m_contractList.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_contractList.SetExtendedStyle(style);
	
	m_contractList.InsertColumn(0,"合同编号",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(1,"报价单号",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(2,"制单日期",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(3,"客户",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(4,"运输方式",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(5,"付款条件",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(6,"销售员",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(7,"部门",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(8,"发货地址",LVCFMT_LEFT,100);
	m_contractList.InsertColumn(9,"备注",LVCFMT_LEFT,100);

	style=m_commidityList.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_commidityList.SetExtendedStyle(style);
	
	m_commidityList.InsertColumn(0,"商品编号",LVCFMT_LEFT,100);
	m_commidityList.InsertColumn(1,"商品名称",LVCFMT_LEFT,100);
	m_commidityList.InsertColumn(2,"单价",LVCFMT_LEFT,100);
	m_commidityList.InsertColumn(3,"数量",LVCFMT_LEFT,100);
	m_commidityList.InsertColumn(4,"规格",LVCFMT_LEFT,100);	

	CString strSQL;