searchstockdlg.cpp

用vc和access编写的贸易管理系统

// SearchStockDLG.cpp : implementation file
//

#include "stdafx.h"
#include "trade_mis.h"
#include "SearchStockDLG.h"
#include "Trade_MISView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchStockDLG dialog


CSearchStockDLG::CSearchStockDLG(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchStockDLG::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchStockDLG)
	m_sProductName = _T("");
	m_bProductName = true;
	m_sProviderName = _T("");
	m_bProviderName = FALSE;
	//}}AFX_DATA_INIT
}


void CSearchStockDLG::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchStockDLG)
	DDX_CBString(pDX, IDD_SEARCHSTOCK_PRODUCTNAME, m_sProductName);
	DDX_Check(pDX, IDD_SEARCHSTOCK_PRODUCTNAMECHECK, m_bProductName);
	DDX_CBString(pDX, IDD_SEARCHSTOCK_PROVIDERNAME, m_sProviderName);
	DDX_Check(pDX, IDD_SEARCHSTOCK_PROVIDERNAMECHECK, m_bProviderName);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CSearchStockDLG message handlers

void CSearchStockDLG::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	
	if ( !(m_bProviderName || m_bProductName) )
	{
		AfxMessageBox(_T("请选择查询条件！"), MB_ICONEXCLAMATION);
		return;
	}
	
	if (!m_bProviderName) m_sProviderName = "%";
	if (!m_bProductName) m_sProductName = "%";
		
	_variant_t strQuery;
	strQuery = "select * from sstock where ProviderName like '"+m_sProviderName+"' and ProductName like '"+m_sProductName+"'";
    	
	CTrade_MISView* p = (CTrade_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshStock(strQuery);
	
	//CDialog::OnOK();
}

BOOL CSearchStockDLG::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	// Init Provider Combobox
	_variant_t strQuery, Holder;	
	strQuery = "select * from suppliers";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	int iCount = theApp.m_pADOSet->GetRecordCount();
	theApp.m_pADOSet->MoveFirst();
	for (int i=0; i<iCount; i++)
	{
		Holder = theApp.m_pADOSet->GetCollect("CompanyName");
		((CComboBox*)GetDlgItem(IDD_SEARCHSTOCK_PROVIDERNAME))->InsertString(i, Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
		theApp.m_pADOSet->MoveNext();
	}
	((CComboBox*)GetDlgItem(IDD_SEARCHSTOCK_PROVIDERNAME))->SetCurSel(0);
	
	// Init Product Combobox
	strQuery = "select * from products";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	iCount = theApp.m_pADOSet->GetRecordCount();
	theApp.m_pADOSet->MoveFirst();
	for (i=0; i<iCount; i++)
	{
		Holder = theApp.m_pADOSet->GetCollect("ProductName");
		((CComboBox*)GetDlgItem(IDD_SEARCHSTOCK_PRODUCTNAME))->InsertString(i, Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder);
		theApp.m_pADOSet->MoveNext();
	}
	((CComboBox*)GetDlgItem(IDD_SEARCHSTOCK_PRODUCTNAME))->SetCurSel(0);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}