dcheckdlg.cpp

一个VC++写的商品库存管理系统

// DCheckDlg.cpp : implementation file
//

#include "stdafx.h"
#include "商品库存管理系统.h"
#include "DCheckDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr cnn;
/////////////////////////////////////////////////////////////////////////////
// CDCheckDlg dialog
extern CMyApp theApp;

CDCheckDlg::CDCheckDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDCheckDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDCheckDlg)
	m_vEdtMax = _T("");
	m_vEdtMin = _T("");
	m_vEdtStore = _T("");
	m_vEdtWare = _T("");
	m_vEdtNumber = _T("");
	//}}AFX_DATA_INIT
}


void CDCheckDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDCheckDlg)
	DDX_Control(pDX, IDC_BUTUndo, m_ButUndo);
	DDX_Control(pDX, IDC_EDTNumber, m_EdtNumber);
	DDX_Control(pDX, IDC_EDTWare, m_EdtWare);
	DDX_Control(pDX, IDC_EDTStore, m_EdtStore);
	DDX_Control(pDX, IDC_EDTMin, m_EdtMin);
	DDX_Control(pDX, IDC_EDTMax, m_EdtMax);
	DDX_Control(pDX, IDC_BUTExit, m_ButExit);
	DDX_Control(pDX, IDC_BUTEnrol, m_ButEnrol);
	DDX_Control(pDX, IDC_BUTCheck, m_ButCheck);
	DDX_Text(pDX, IDC_EDTMax, m_vEdtMax);
	DDX_Text(pDX, IDC_EDTMin, m_vEdtMin);
	DDX_Text(pDX, IDC_EDTStore, m_vEdtStore);
	DDX_Text(pDX, IDC_EDTWare, m_vEdtWare);
	DDX_Text(pDX, IDC_EDTNumber, m_vEdtNumber);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDCheckDlg, CDialog)
	//{{AFX_MSG_MAP(CDCheckDlg)
	ON_BN_CLICKED(IDC_BUTEnrol, OnBUTEnrol)
	ON_BN_CLICKED(IDC_BUTCheck, OnBUTCheck)
	ON_BN_CLICKED(IDC_BUTExit, OnBUTExit)
	ON_BN_CLICKED(IDC_BUTUndo, OnBUTUndo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDCheckDlg message handlers

void CDCheckDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDCheckDlg::Enabled(bool bEnabled)
{
	m_EdtNumber.EnableWindow(bEnabled);
	m_EdtMin.EnableWindow(bEnabled);
	m_EdtMax.EnableWindow(bEnabled);
	m_ButExit.EnableWindow(!bEnabled);
	m_ButEnrol.EnableWindow(!bEnabled);
	m_ButCheck.EnableWindow(bEnabled);
	m_ButUndo.EnableWindow(bEnabled);
}

BOOL CDCheckDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
		
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDCheckDlg::OnBUTEnrol() 
{
	this->Enabled(true)	;
	this->m_EdtNumber.SetFocus();
}

void CDCheckDlg::OnBUTCheck() 
{
	int a=MessageBox("确定保存此次盘点吗?","系统提示",MB_ICONQUESTION|MB_OKCANCEL);
	if(a!=1)
		return;	
	CString sStore,sWareID,sWare,sNumber,sMax,sMin,sSQL;
	int nStoreID;
	m_EdtNumber.GetWindowText(sNumber);
	m_EdtStore.GetWindowText(sStore);
	m_EdtWare.GetWindowText(sWare);
	m_EdtMin.GetWindowText(sMin);
	m_EdtMax.GetWindowText(sMax);
	sWareID=theApp.NumberTOName("商品信息表","编号","名称",sWare);
	nStoreID=theApp.NumberTOName("仓库信息表","名称",sStore);
	sSQL.Format("Update 库存信息表 Set 库存数量=%s ,库存上限=%s,库存下限=%s WHERE 商品编号='%s' and 仓库编号=%d",sNumber,sMax,sMin,sWareID,nStoreID);
	cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
	this->Enabled(false);
	this->m_ButEnrol.SetFocus();
}

void CDCheckDlg::OnBUTExit() 
{
	this->OnCancel();	
}

void CDCheckDlg::OnBUTUndo() 
{
	int a=MessageBox("确定要撤消操作吗?","系统提示",MB_ICONQUESTION|MB_OKCANCEL);
	if(a!=1)
		return;	
	m_EdtNumber.SetWindowText(m_vEdtNumber);
	m_EdtStore.SetWindowText(m_vEdtStore);
	m_EdtWare.SetWindowText(m_vEdtWare);
	m_EdtMin.SetWindowText(m_vEdtMin);
	m_EdtMax.SetWindowText(m_vEdtMax);
	this->Enabled(false);
	this->m_ButEnrol.SetFocus();

}