supplierdlg.cpp

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

// SupplierDlg.cpp : implementation file
//

#include "stdafx.h"
#include "heavenmis.h"
#include "SupplierDlg.h"
#include "column.h"
#include "columns.h"
#include "addsuppdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSupplierDlg dialog


CSupplierDlg::CSupplierDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSupplierDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSupplierDlg)
	m_strCity = _T("");
	m_strProvince = _T("");
	//}}AFX_DATA_INIT
}


void CSupplierDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSupplierDlg)
	DDX_Text(pDX, IDC_EDIT_CITY, m_strCity);
	DDX_Text(pDX, IDC_EDIT_PROVINCE, m_strProvince);
	DDX_Control(pDX, IDC_ADODC1, m_adodcSup);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagridSup);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CSupplierDlg message handlers

void CSupplierDlg::ResetColumn()
{
	CColumns allCols;
	CColumn onecol;
	allCols=m_datagridSup.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);
	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption("地址");
	onecol.SetWidth(140);
	onecol=allCols.GetItem(COleVariant(long(5)));
	onecol.SetCaption("省份");
	onecol.SetWidth(100);
	onecol=allCols.GetItem(COleVariant(long(6)));
	onecol.SetCaption("城市");
	onecol.SetWidth(100);
	
}

BOOL CSupplierDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	ResetColumn();
	return TRUE;  
}

void CSupplierDlg::OnButtonQuery() 
{
	UpdateData(TRUE);
	CString strQuery="select * from tbSupplier where ";
	CString temp1="",temp2="";
	//如果没有给定查询条件返回
	if(m_strCity.IsEmpty()&&m_strProvince.IsEmpty())
		return;
	//用查询条件构造SQL语句
	else if(!m_strProvince.IsEmpty())
	{
		temp1.Format("Province='%s'",m_strProvince);
		strQuery+=temp1;
	}
	if(!m_strCity.IsEmpty())
	{
		if(temp1.IsEmpty())
			temp2.Format("City='%s'",m_strCity);
		else		
			temp2.Format("and City='%s'",m_strCity);
		
		strQuery+=temp2;
	}
	//重新设置Recordsource，刷新数据
	m_adodcSup.SetRecordSource(strQuery);
	m_adodcSup.Refresh();
	ResetColumn();
	
}

void CSupplierDlg::OnButtonAdd() 
{
	// TODO: Add your control notification handler code here
	CAddSuppDlg addsupdlg;
	if(addsupdlg.DoModal()==IDOK)
	{
		m_adodcSup.Refresh();
		ResetColumn();
	}
}