productdlg.cpp

玩具百货公司销售进货记录系统!界面比较齐全,功能完善

// ProductDlg.cpp : implementation file
//

#include "stdafx.h"
#include "heavenmis.h"
#include "ProductDlg.h"
#include "column.h"
#include "columns.h"
#include "addproddlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProductDlg dialog


CProductDlg::CProductDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CProductDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CProductDlg)
	m_strQuery = _T("");
	//}}AFX_DATA_INIT
}


void CProductDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProductDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodcProduct);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagridProduct);
	DDX_Text(pDX, IDC_EDIT_QUERY, m_strQuery);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProductDlg, CDialog)
	//{{AFX_MSG_MAP(CProductDlg)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_BUTTON_ADD, OnButtonAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProductDlg message handlers

void CProductDlg::ResetColumns()
{
	CColumns allCols;
	CColumn onecol;
	allCols=m_datagridProduct.GetColumns();
	//设置各列标题和宽度
	onecol=allCols.GetItem(COleVariant(long(0)));
	onecol.SetCaption("编号");
	onecol.SetWidth(20);
	onecol=allCols.GetItem(COleVariant(long(1)));
	onecol.SetCaption("商品名称");
	onecol.SetWidth(60);
	onecol=allCols.GetItem(COleVariant(long(2)));
	onecol.SetCaption("目前数量");
	onecol.SetWidth(60);
	onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption("商品描述");
	onecol.SetWidth(80);
}

BOOL CProductDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

	ResetColumns();
	return TRUE;  
}

void CProductDlg::OnButtonQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString strSQL="select * from tbProduct where Name like '%"+m_strQuery+"%'" ;
	m_adodcProduct.SetRecordSource(strSQL);
	m_adodcProduct.Refresh();
	ResetColumns();	
}

void CProductDlg::OnButtonAdd() 
{
	CAddProdDlg addproddlg;
	if(addproddlg.DoModal()==IDOK)
	{
		m_adodcProduct.Refresh();
		ResetColumns();		
	}
}