customerifdlg.cpp

本程序是居于对话框用access数据库开发的一个简单的销售管理系统

// CustomerifDlg.cpp : implementation file
//

#include "stdafx.h"
#include "WinNerComputers.h"
#include "CustomerifDlg.h"
#include "Cstomerif_XCDlg.h"
#include "Customerif_TJDlg.h"
#include "Customerif_XGDlg.h"
#include "CustomerifSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CCustomerifDlg dialog


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


void CCustomerifDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCustomerifDlg)
	DDX_Control(pDX, IDC_LIST1, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCustomerifDlg, CDialog)
	//{{AFX_MSG_MAP(CCustomerifDlg)
	ON_BN_CLICKED(IDC_SHUAXIN, OnShuaxin)
	ON_BN_CLICKED(IDC_CHAXUN, OnChaxun)
	ON_BN_CLICKED(IDC_TIANJIA, OnTianjia)
	ON_BN_CLICKED(IDC_XIUGAI, OnXiugai)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCustomerifDlg message handlers

void CCustomerifDlg::Cstomers(CString C)
{
	UpdateData();
	m_list.DeleteAllItems();
	m_pSet = new CCustomerifSet();
	m_pSet->m_strFilter =C;
	m_pSet->m_strFilter =m_sFilter;
	m_pSet->Open();
	if (!m_pSet->IsEOF())
	{
		m_pSet->MoveFirst();
	}
	int nIdex=0;
	while (!m_pSet->IsEOF())
	{
		m_list.InsertItem(nIdex,m_pSet->m_CustomerId);
		m_list.SetItemText(nIdex,1,m_pSet->m_CompanyName);
		m_list.SetItemText(nIdex,2,m_pSet->m_ContactName);
		m_list.SetItemText(nIdex,3,m_pSet->m_Address);
		m_list.SetItemText(nIdex,4,m_pSet->m_City);
		m_list.SetItemText(nIdex,5,m_pSet->m_Region);
		m_list.SetItemText(nIdex,6,m_pSet->m_PostalCde);
		m_list.SetItemText(nIdex,7,m_pSet->m_Phone);
		m_list.SetItemText(nIdex,8,m_pSet->m_Fax);
		m_list.SetItemText(nIdex,9,m_pSet->m_HomePage);
		m_list.SetItemText(nIdex,10,m_pSet->m_CustomerNemo);
		nIdex ++;
		m_pSet->MoveNext();
	}
	m_pSet->Close();
	UpdateData(FALSE);

}

BOOL CCustomerifDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_list.InsertColumn(0,"顾客编号",LVCFMT_CENTER,100);
	m_list.InsertColumn(1,"公司名称",LVCFMT_CENTER,100);
	m_list.InsertColumn(2,"联系人姓名",LVCFMT_CENTER,100);
	m_list.InsertColumn(3,"联系地址",LVCFMT_CENTER,100);
	m_list.InsertColumn(4,"所在城市",LVCFMT_CENTER,100);
	m_list.InsertColumn(5,"所在地区",LVCFMT_CENTER,100);
	m_list.InsertColumn(6,"邮政编号",LVCFMT_CENTER,100);
	m_list.InsertColumn(7,"联系电话",LVCFMT_CENTER,100);
	m_list.InsertColumn(8,"传真号码",LVCFMT_CENTER,100);
	m_list.InsertColumn(9,"公司主页",LVCFMT_CENTER,100);
	m_list.InsertColumn(10,"备注信息",LVCFMT_CENTER,200);
	Cstomers("");
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCustomerifDlg::OnShuaxin() 
{
	// TODO: Add your control notification handler code here
	m_sFilter.Format("");
	Cstomers("");
}

void CCustomerifDlg::OnChaxun() 
{
	// TODO: Add your control notification handler code here
	CCstomerif_XCDlg dlg;
	if (dlg.DoModal()==IDOK)
	{
		UpdateData();
		m_sFilter.Format("Customers.CustomerId='%s' and Customers.ContactName = '%s' and Customers.Phone='%s'",dlg.m_gkbh,dlg.m_lxrxm,dlg.m_lxdh );
		Cstomers(m_sFilter);
	}
}

void CCustomerifDlg::OnTianjia() 
{
	// TODO: Add your control notification handler code here
	CCustomerif_TJDlg dlg;
	dlg.DoModal();
}

void CCustomerifDlg::OnXiugai() 
{
	// TODO: Add your control notification handler code here
	CCustomerif_XGDlg dlg;
	int Index = m_list.GetSelectionMark();//获取被选中的记录
	if (Index !=-1)
	{
		dlg.edit = m_list.GetItemText(Index,0);
		dlg.DoModal();
	}
	else
	{
		MessageBox("请选中要修改的项!");
	}
}