ordersifdlg.cpp

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

// OrdersifDlg.cpp : implementation file
//

#include "stdafx.h"
#include "WinNerComputers.h"
#include "OrdersifDlg.h"
#include "OrdersifSet.h"
#include "Ordersif_TJDlg.h"
#include "Ordersif_XGDlg.h"
#include "Orderif_CXDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// COrdersifDlg dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// COrdersifDlg message handlers

void COrdersifDlg::Orders(CString O)
{
	m_list.DeleteAllItems();                      //清空
	m_pSet = new  COrdersifSet();                 //定义一个对象
	m_pSet->m_strFilter = O;
	m_pSet->m_strFilter = m_sFilter; 
	m_pSet->Open();                               //打开数据表
	if (!m_pSet->IsEOF())
	{
		m_pSet->MoveFirst();                      //指向第一列
	}
	int Intem = 0;
	while (!m_pSet->IsEOF())
	{	
		CString str;
		Intem = m_list.InsertItem(Intem,m_pSet->m_OrderId);//插入第一项
		m_list.SetItemText(Intem,1,m_pSet->m_CustomerId);
	    m_list.SetItemText(Intem,2,m_pSet->m_CustomName);
		m_list.SetItemText(Intem,3,m_pSet->m_ProductId);
		m_list.SetItemText(Intem,4,m_pSet->m_ProductName);
		m_list.SetItemText(Intem,5,m_pSet->m_ProductUnit);
		m_list.SetItemText(Intem,6,m_pSet->m_ProductSpec);
		m_list.SetItemText(Intem,7,m_pSet->m_ProductShuL);
		m_list.SetItemText(Intem,8,m_pSet->m_ProductPice);
		m_list.SetItemText(Intem,9,m_pSet->m_ProductTime.Format("%Y-%d-%d"));
		str.Format("%d",m_pSet->m_BaoxiuYears);
		m_list.SetItemText(Intem,10,str);
	    m_list.SetItemText(Intem,11,m_pSet->m_Ordermeno);
		Intem ++;
		m_pSet->MoveNext();           //指向下一个记录
	}
	m_pSet->Close();                  //关闭数据表
	UpdateData(FALSE);                 //更新
}

BOOL COrdersifDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);   //获取List的网格
	m_list.InsertColumn(0,"销售信息编号",LVCFMT_CENTER,100);          //向list中插入第一列(0表示第一,双引号里面的是标题,向中心对齐,宽度为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,100);
	m_list.InsertColumn(11,"备注信息",LVCFMT_LEFT,200);
	Orders("");
	// 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 COrdersifDlg::OnShuaxin() 
{
	// TODO: Add your control notification handler code here
	m_sFilter.Format("");
	Orders("");                         //刷新记录
}

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

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

void COrdersifDlg::OnShanchu2() 
{
	// TODO: Add your control notification handler code here
	int nIndex = m_list.GetSelectionMark();//获取被选中的记录
	CString str;
	str.Format("你确实是要删除顾客编号为%s的记录吗?删除请按[确定]，取消请选择[取消]",m_list.GetItemText(nIndex,1));
	if (MessageBox(str,"确认删除",MB_OKCANCEL)==IDOK)
	{
		COrdersifSet OS;
		OS.m_strFilter.Format("CustomerId = '%s'",m_list.GetItemText(nIndex,1));
		OS.Open();
		if (!OS.IsEOF())
		{
			OS.Delete();
		}
		OS.Close();
		Orders(""); 
	}
	Orders(""); 
//	MessageBox("删除记录成功！");
	UpdateData(FALSE);
}

void COrdersifDlg::OnChaxun2() 
{
	// TODO: Add your control notification handler code here
	COrderif_CXDlg dlg;
	if (dlg.DoModal()==IDOK)
	{
		UpdateData();
		m_sFilter.Format(" Order.OrderId='%s' and Order.ProductId = '%s' and Order.ProductName='%s'",dlg.m_xsid,dlg.m_pinid,dlg.m_pinname );
		Orders(m_sFilter);
	}
	
}