dlginputbackquery4.cpp

主要功能 企业仓库管理系统由基本信息管理模块、入库管理模块、库存管理模块、查询管理模块等几部分组成。 &#61553 基本信息管理模块 该模块主要包括操作员管理、商品信息管理、库存信息管理、供

// DlgInputBackQuery4.cpp : implementation file
//

#include "stdafx.h"
#include "aaa.h"
#include "DlgInputBackQuery4.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgInputBackQuery4 dialog


CDlgInputBackQuery4::CDlgInputBackQuery4(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgInputBackQuery4::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgInputBackQuery4)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDlgInputBackQuery4::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgInputBackQuery4)
	DDX_Control(pDX, IDC_LIST1, list);
	DDX_Control(pDX, IDC_EDIT1, value);
	DDX_Control(pDX, IDC_DATETIMEPICKER2, endtime);
	DDX_Control(pDX, IDC_DATETIMEPICKER1, starttime);
	DDX_Control(pDX, IDC_COMBO1, fields);
	DDX_Control(pDX, IDC_CHECK2, check2);
	DDX_Control(pDX, IDC_CHECK1, check1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgInputBackQuery4, CDialog)
	//{{AFX_MSG_MAP(CDlgInputBackQuery4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgInputBackQuery4 message handlers

void CDlgInputBackQuery4::CancelQuery()
{
	check1.SetCheck(0);
	check2.SetCheck(0);
	fields.SetCurSel(-1);
	value.SetWindowText("");
	CTime temp = CTime::GetCurrentTime();
	starttime.SetTime(&temp);
	endtime.SetTime(&temp);
	list.DeleteAllItems();	
}

BOOL CDlgInputBackQuery4::OnInitDialog() 
{
	CDialog::OnInitDialog();
	list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_ONECLICKACTIVATE|LVS_EX_INFOTIP|LVS_EX_SUBITEMIMAGES|LVS_EX_GRIDLINES );
	
	//向表格中添加列
	list.InsertColumn(0,"仓库名称");
	list.InsertColumn(1,"商品编号");
	list.InsertColumn(2,"商品名称");
	list.InsertColumn(3,"单价");
	list.InsertColumn(4,"数量");
	list.InsertColumn(5,"折扣");
	list.InsertColumn(6,"金额");
	list.InsertColumn(7,"操作员");	
	list.InsertColumn(8,"退货票号");	

	list.SetColumnWidth(0,60);
	list.SetColumnWidth(1,100);
	list.SetColumnWidth(2,100);
	list.SetColumnWidth(3,50);
	list.SetColumnWidth(4,50);
	list.SetColumnWidth(5,50);
	list.SetColumnWidth(6,60);
	list.SetColumnWidth(7,50);
	list.SetColumnWidth(8,110);		
	return TRUE; 
}

BOOL CDlgInputBackQuery4::PreTranslateMessage(MSG* pMsg) 
{
	if (pMsg->message ==WM_KEYDOWN)
	{
		if (pMsg->wParam==13)
			pMsg->wParam = 9;
	}
	return CDialog::PreTranslateMessage(pMsg);
}

void CDlgInputBackQuery4::Query()
{
	if ((check1.GetCheck() ==false)&&(check2.GetCheck()==false))
	{
		MessageBox("请设置查询条件","提示",64);
		return;
	}
	if ( (check1.GetCheck()==true)&&(check2.GetCheck()==false))
	{
		CString c_field,c_value;
		fields.GetWindowText(c_field);
		value.GetWindowText(c_value);
		if (c_field.IsEmpty()||(c_value.IsEmpty()))
		{
			MessageBox("请设置查询条件","提示",64);
			return;
		}
		CString sql;
		list.DeleteAllItems();
		switch (fields.GetCurSel())
		{
			case 0: 
			{ 
				c_field = "Cancelid";
				//sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice and a.%s = '%s'",c_field,c_value);

				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.CancelID from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.CancelID = c.CancelID and a.%s = '%s'",c_field,c_value);
				break;
			}
			case 1: 
			{ 
				c_field = "provider";
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.CancelID from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.CancelID = c.CancelID and c.%s = '%s' ",c_field,c_value);
				break;
			}
			case 2: 
			{ 
				c_field = "operator"; 
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.CancelID from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.CancelID = c.Cancelid and c.%s = '%s' ",c_field,c_value);
				break;

			}
			case 3:
			{ 
				c_field = "name" ;
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.CancelID from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.CancelID = c.CancelID and b.%s = '%s' ",c_field,c_value);
				break;
			}
		}
		m_pRs->Close();
		m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
		int row = 0;
		while (! m_pRs->adoEOF)
		{
			CString temp;
			list.InsertItem(100,"");
			for (int i = 0;i<9;i++)
			{
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
				list.SetItemText(row,i,temp);
			}
			m_pRs->MoveNext();
			row +=1;
		}		
	}
	else if ((check1.GetCheck()==false)&&(check2.GetCheck()==true))
	{
		list.DeleteAllItems();
		CString sql,c_starttime,c_endtime;
		starttime.GetWindowText(c_starttime);
		endtime.GetWindowText(c_endtime);
		sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator ,a.CancelID from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.Cancelid = c.Cancelid and c.intime between '%s' and '%s' ",c_starttime,c_endtime);
		m_pRs->Close();
		m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
		int row = 0;
		while (! m_pRs->adoEOF)
		{
			CString temp;
			list.InsertItem(100,"");
			for (int i = 0;i<9;i++)
			{
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
				list.SetItemText(row,i,temp);
			}
			m_pRs->MoveNext();
			row +=1;
		}				
	}
	else
	{
		CString c_field,c_value;
		CString sql,c_starttime,c_endtime;
		starttime.GetWindowText(c_starttime);
		endtime.GetWindowText(c_endtime);

		fields.GetWindowText(c_field);
		value.GetWindowText(c_value);
		if (c_field.IsEmpty()||(c_value.IsEmpty()))
		{
			MessageBox("请设置查询条件","提示",64);
			return;
		}
		list.DeleteAllItems();
		switch (fields.GetCurSel())
		{
			case 0: 
			{
				c_field = "Cancelid";
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and a.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
				break;
			}
			case 1: 
			{ 
				c_field = "provider";
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and c.%s = '%s' and c.intime between '%s' and '%s'  ",c_field,c_value,c_starttime,c_endtime);
				break;
			}
			case 2: 
			{ 
				c_field = "operator"; 
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and c.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
				break;
			}
			case 3:
			{ 
				c_field = "name" ;
				sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and b.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
				break;
			}
		}
		m_pRs->Close();
		m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
		int row = 0;
		while (! m_pRs->adoEOF)
		{
			CString temp;
			list.InsertItem(100,"");
			for (int i = 0;i<9;i++)
			{
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
				list.SetItemText(row,i,temp);
			}
			m_pRs->MoveNext();
			row +=1;
		}	
	}
}