sstockif_xgdlg.cpp

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

// Sstockif_XGDlg.cpp : implementation file
//

#include "stdafx.h"
#include "WinNerComputers.h"
#include "Sstockif_XGDlg.h"
#include "SstockifSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSstockif_XGDlg dialog


CSstockif_XGDlg::CSstockif_XGDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSstockif_XGDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSstockif_XGDlg)
	m_beizhu = _T("");
	m_time = 0;
	m_gonghao = _T("");
	m_gongname = _T("");
	m_jinhao = _T("");
	m_shangdj = _T("");
	m_shangdw = _T("");
	m_shanggui = _T("");
	m_shanghao = _T("");
	m_shangname = _T("");
	m_shangsl = 0;
	edit = "";
	m_pSet = NULL;
	//}}AFX_DATA_INIT
}


void CSstockif_XGDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSstockif_XGDlg)
	DDX_Text(pDX, IDC_beizhu, m_beizhu);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_time);
	DDX_Text(pDX, IDC_gonghao, m_gonghao);
	DDX_Text(pDX, IDC_gongname, m_gongname);
	DDX_Text(pDX, IDC_jinhao, m_jinhao);
	DDX_Text(pDX, IDC_shangdj, m_shangdj);
	DDX_Text(pDX, IDC_shangdw, m_shangdw);
	DDX_Text(pDX, IDC_shanggui, m_shanggui);
	DDX_Text(pDX, IDC_shanghao, m_shanghao);
	DDX_Text(pDX, IDC_shangname, m_shangname);
	DDX_Text(pDX, IDC_shangsl, m_shangsl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSstockif_XGDlg, CDialog)
	//{{AFX_MSG_MAP(CSstockif_XGDlg)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSstockif_XGDlg message handlers

BOOL CSstockif_XGDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	UpdateData();
	m_pSet = new CSstockifSet();
    m_pSet->m_strFilter.Format("StochId = '%s'",edit);
	m_pSet->Open();
	if (!m_pSet->IsEOF())
	{
		m_shanghao = m_pSet->m_ProductId;
		m_shangname = m_pSet->m_ProductName;
		m_shangsl = m_pSet->m_Quantity;
		m_gonghao = m_pSet->m_ProviderId;
		m_gongname = m_pSet->m_ProviName;
		m_beizhu = m_pSet->m_Ordermeno;
		m_time = m_pSet->m_OrderDate;
		m_shanggui = m_pSet->m_Spec;
		m_shangdj = m_pSet->m_UnitPrice;
		m_shangdw = m_pSet->m_Unit;
		m_jinhao = m_pSet->m_StochId;
		UpdateData(FALSE);
	}	
	m_pSet->Close();
	// 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 CSstockif_XGDlg::OnEdit() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_pSet = new CSstockifSet();
	m_pSet->m_strFilter.Format(" StochId= '%s' ",edit);
	m_pSet->Open();
	m_pSet->Edit();
	m_pSet->m_ProductId =m_shanghao;
	m_pSet->m_ProductName= m_shangname;
	m_pSet->m_Quantity = m_shangsl;
	m_pSet->m_ProviderId = m_gonghao;
	m_pSet->m_ProviName	 = m_gongname;
	m_pSet->m_Ordermeno = m_beizhu;
	m_pSet->m_OrderDate = m_time;
	m_pSet->m_Spec = m_shanggui;
	m_pSet->m_UnitPrice	 = m_shangdj;
	m_pSet->m_Unit = m_shangdw;
	m_pSet->m_StochId = m_jinhao;
	m_pSet->Update();
	m_pSet->Requery();
	m_pSet->Close();
	MessageBox("记录修改成功！");
}