supplierifdlg.cpp

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

// SupplierifDlg.cpp : implementation file
//

#include "stdafx.h"
#include "WinNerComputers.h"
#include "SupplierifDlg.h"
#include "SupplierifSet.h"
#include "SupplierifDlg.h"
#include "Supplierif_TJDlg.h"
#include "Supplierif_XGDlg.h"
#include "Supplierif_CXDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSupplierifDlg dialog


CSupplierifDlg::CSupplierifDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSupplierifDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSupplierifDlg)
	m_pSet = NULL;
	//m_keyw = _T("");
	//}}AFX_DATA_INIT
}


void CSupplierifDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSupplierifDlg)
	DDX_Control(pDX, IDC_LIST1, m_list);
	//DDX_Text(pDX, IDC_keyw, m_keyw);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSupplierifDlg, CDialog)
	//{{AFX_MSG_MAP(CSupplierifDlg)
	ON_BN_CLICKED(IDC_CHAXUN2, OnChaxun2)
	ON_BN_CLICKED(IDC_SHUAXIN, OnShuaxin)
	ON_BN_CLICKED(IDC_TIANJIA2, OnTianjia2)
	ON_BN_CLICKED(IDC_XIUGAI2, OnXiugai2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSupplierifDlg message handlers
BOOL CSupplierifDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	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);
	Supplier("");
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSupplierifDlg::Supplier(CString S)
{
	UpdateData();
	m_list.DeleteAllItems();
	m_pSet = new CSupplierifSet();
	m_pSet->m_strFilter =S;
	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_SupplierId);
		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_PostalCode);
		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_SupplierMemo);
		nIdex ++;
		m_pSet->MoveNext();
	}
	m_pSet->Close();
	UpdateData(FALSE);

}

void CSupplierifDlg::OnChaxun2() 
{
	// TODO: Add your control notification handler code here
	CSupplierif_CXDlg dlg;
	if (dlg.DoModal()==IDOK)
	{
		UpdateData();
		m_sFilter.Format("suppliers.SupplierId='%s' and suppliers.ContactName = '%s' and suppliers.Phone='%s'",dlg.m_m_gkbh,dlg.m_m_lxrxm,dlg.m_m_lxdh );
		Supplier(m_sFilter);
	}	
}

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

void CSupplierifDlg::OnTianjia2() 
{
	// TODO: Add your control notification handler code here
	CSupplierif_TJDlg  dlg;
	dlg.DoModal();
}

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