searchplusinfo.cpp

本项目开发的最终用户是各工厂企业小型仓库。项目的目标是做到管理员能对货物的信息进行入库、出库、查询、修改以及统计货物信息。管理员能对货物的信息进行统计

// SearchplusInfo.cpp : implementation file
//

#include "stdafx.h"
#include "Material_MIS.h"
#include "SearchplusInfo.h"
#include "Material_MISView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchplusInfo dialog


CSearchplusInfo::CSearchplusInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchplusInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchplusInfo)
	m_sName = _T("");
	m_sSpec = _T("");
	m_bCheckName = FALSE;
	m_bCheckSpec = FALSE;
	m_bCheckDown = FALSE;
	m_mbCheckUp = FALSE;
	m_uiNumDown = 0;
	m_uiNumUp = 10000000;
	//}}AFX_DATA_INIT
}


void CSearchplusInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchplusInfo)
	DDX_Text(pDX, IDC_YE_WZNAME, m_sName);
	DDX_Text(pDX, IDC_YE_WZSPEC, m_sSpec);
	DDX_Check(pDX, IDC_YECHECK_NAME, m_bCheckName);
	DDX_Check(pDX, IDC_YECHECK_SPEC, m_bCheckSpec);
	DDX_Check(pDX, IDC_CHECK_DOWN, m_bCheckDown);
	DDX_Check(pDX, IDC_CHECK_UP, m_mbCheckUp);
	DDX_Text(pDX, IDC_EDIT_QUANTITY_DOWN, m_uiNumDown);
	DDV_MinMaxUInt(pDX, m_uiNumDown, 0, 10000000);
	DDX_Text(pDX, IDC_EDIT_QUANTITY_UP, m_uiNumUp);
	DDV_MinMaxUInt(pDX, m_uiNumUp, 0, 10000000);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CSearchplusInfo message handlers

void CSearchplusInfo::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	if ( !m_bCheckName && !m_bCheckSpec)
	{
		AfxMessageBox(_T("请选择查询条件！"), MB_ICONEXCLAMATION);
		return;
	}
	m_sName.TrimRight(" ");
	m_sSpec.TrimRight(" ");

	if ( m_bCheckName ) 
	{
		if ( ""==m_sName ) 
		{
			AfxMessageBox(_T("物资名称不能为空！"), MB_ICONEXCLAMATION);
			return;
		}
		
	} 
	else m_sName="%";
	
	
	if ( m_bCheckSpec ) 
	{
		if ( ""==m_sSpec ) 
		{
			AfxMessageBox(_T("物资型号不能为空！"), MB_ICONEXCLAMATION);
			return;
		}
		
	} 
	else m_sSpec="%";
	_variant_t strQuery;
	CString tmp;
	//	BOOL	m_bCheckDown;
	//	BOOL	m_mbCheckUp;
	if( m_bCheckDown && !m_mbCheckUp )
	{
		tmp.Format("select * from msurplus where yename like '%s' and yespec like '%s' and yeaccount > %d",m_sName,m_sSpec,m_uiNumDown);
	}
	else if( !m_bCheckDown && m_mbCheckUp )
	{
		tmp.Format("select * from msurplus where yename like '%s' and yespec like '%s' and yeaccount < %d",m_sName,m_sSpec,m_uiNumUp);
	}
	else if( !m_bCheckDown && !m_mbCheckUp )
	{
		tmp.Format("select * from msurplus where yename like '%s' and yespec like '%s'",m_sName,m_sSpec);
	}
	else if( m_bCheckDown && m_mbCheckUp )
	{
		tmp.Format("select * from msurplus where yename like '%s' and yespec like '%s' and yeaccount between %d and %d",m_sName,m_sSpec,m_uiNumDown,m_uiNumUp);
	}
//	strQuery = "select * from msurplus where yename like '"+m_sName+"' and yespec like '"+m_sSpec+"' and yeaccount between down and up ";
//	strQuery.Format("select * from msurplus where yename like '%s' and yespec like '%s' and yeaccount between %d and %d ",m_sName,m_sSpec,down,up);
	strQuery = tmp;
	CMaterial_MISView* p = (CMaterial_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshSurplus(strQuery);
	CDialog::OnOK();
}

BOOL CSearchplusInfo::OnInitDialog() 
{
	CDialog::OnInitDialog();
	SetWindowText(_T("物资余额查询"));
	((CEdit*)GetDlgItem(IDC_YE_WZNAME))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_YE_WZSPEC))->SetLimitText(50);
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}