chuku.cpp

简单功能的盘库mfc编译通过

// Chuku.cpp : implementation file
//

#include "stdafx.h"
#include "Supermarket.h"
#include "Chuku.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CChuku dialog


CChuku::CChuku(CWnd* pParent /*=NULL*/)
	: CDialog(CChuku::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChuku)
	m_Out_date = _T("");
	m_Out_id = _T("");
	m_Out_name = _T("");
	m_Out_number = 0;
	m_Out_price = 0.0;
	//}}AFX_DATA_INIT
}


void CChuku::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChuku)
	DDX_Text(pDX, IDC_OUT_DATE, m_Out_date);
	DDX_Text(pDX, IDC_OUT_ID, m_Out_id);
	DDX_Text(pDX, IDC_OUT_NAME, m_Out_name);
	DDX_Text(pDX, IDC_OUT_NUMBER, m_Out_number);
	DDX_Text(pDX, IDC_OUT_PRICE, m_Out_price);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChuku, CDialog)
	//{{AFX_MSG_MAP(CChuku)
	ON_BN_CLICKED(ID_OUT_OK, OnOutOk)
	ON_BN_CLICKED(IDC_OUT_DELETE, OnOutDelete)
	ON_BN_CLICKED(IDC_OUT_PRE, OnOutPre)
	ON_BN_CLICKED(IDC_OUT_NEXT, OnOutNext)
	ON_BN_CLICKED(IDC_OUT_EDIT, OnOutEdit)
	ON_BN_CLICKED(IDC_OK, OnOk)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChuku message handlers

BOOL CChuku::OnInitDialog()
{
	m_db.Open(_T("supDNS"));
	m_rs.m_pDatabase=&m_db;
	m_rs.Open();
	m_Out_name=m_rs.m_out_name;
	m_Out_id=m_rs.m_out_id;
	m_Out_date=m_rs.m_out_date;
	m_Out_number=m_rs.m_out_number;
	m_Out_price=m_rs.m_out_price;
	UpdateData(FALSE);
	return TRUE;
}

void CChuku::OnOutOk() 
{
	// TODO: Add your control notification handler code here
		m_Out_date = _T("");
		m_Out_id = _T("");
		m_Out_name = _T("");
		m_Out_number = 0;
		m_Out_price = 0.0;
		UpdateData(FALSE);
}

void CChuku::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

void CChuku::OnOutDelete() 
{
	// TODO: Add your control notification handler code here
	if(m_rs.IsEOF()||m_rs.IsBOF())
		return;
	try
	{
		m_rs.Delete();
		m_Out_date = _T("");
		m_Out_id = _T("");
		m_Out_name = _T("");
		m_Out_number = 0;
		m_Out_price = 0.0;
		MessageBox(" 删除成功");
	}
	catch(CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		return;
	}
	m_rs.MoveFirst();
	m_Out_name=m_rs.m_out_name;
	m_Out_id=m_rs.m_out_id;
	m_Out_date=m_rs.m_out_date;
	m_Out_number=m_rs.m_out_number;
	m_Out_price=m_rs.m_out_price;
	UpdateData(FALSE);
}

void CChuku::OnOutPre() 
{
	// TODO: Add your control notification handler code here
		m_rs.MovePrev();
	if(m_rs.IsBOF())
		m_rs.MoveFirst();
	m_Out_name=m_rs.m_out_name;
	m_Out_id=m_rs.m_out_id;
	m_Out_date=m_rs.m_out_date;
	m_Out_number=m_rs.m_out_number;
	m_Out_price=m_rs.m_out_price;
	UpdateData(FALSE);
}

void CChuku::OnOutNext() 
{
	// TODO: Add your control notification handler code here
		m_rs.MoveNext();
	if(m_rs.IsEOF())
		m_rs.MoveLast();
	m_Out_name=m_rs.m_out_name;
	m_Out_id=m_rs.m_out_id;
	m_Out_date=m_rs.m_out_date;
	m_Out_number=m_rs.m_out_number;
	m_Out_price=m_rs.m_out_price;
	UpdateData(FALSE);
}

void CChuku::OnOutEdit() 
{
	// TODO: Add your control notification handler code here
	CString name,chandi,id,date;
	int number;
	double price;
	name=m_rs.m_out_name;
	id=m_rs.m_out_id;
	date=m_rs.m_out_date;
	number=m_rs.m_out_number;
	price=m_rs.m_out_price;
	try
	{
		m_rs.Edit();
		UpdateData(TRUE);
		m_rs.m_out_date=m_Out_date;
		m_rs.m_out_id=m_Out_id;
		m_rs.m_out_name=m_Out_name;
		m_rs.m_out_number=m_Out_number;
		m_rs.m_out_price=m_Out_price;
		m_rs.Update();
	}
	catch(CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		m_Out_name=name;
		m_Out_date=date;
		m_Out_number=number;
		m_Out_id=id;
		m_Out_price=price;
		UpdateData(FALSE);
	}
}

void CChuku::OnOk() 
{
	// TODO: Add your control notification handler code here
		try
	{
		m_rs.AddNew();
		UpdateData(TRUE);
		m_rs.m_out_date=m_Out_date;
		m_rs.m_out_id=m_Out_id;
		m_rs.m_out_name=m_Out_name;
		m_rs.m_out_number=m_Out_number;
		m_rs.m_out_price=m_Out_price;
		m_rs.Update();
		MessageBox(" 添加成功");
	}
	catch(CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		m_rs.MoveFirst();
		m_Out_name=m_rs.m_out_name;
		m_Out_id=m_rs.m_out_id;
		m_Out_date=m_rs.m_out_date;
		m_Out_number=m_rs.m_out_number;
		m_Out_price=m_rs.m_out_price;
		UpdateData(FALSE);
	}
}