ruku.cpp

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

// Ruku.cpp : implementation file
//

#include "stdafx.h"
#include "Supermarket.h"
#include "Ruku.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRuku dialog


CRuku::CRuku(CWnd* pParent /*=NULL*/)
	: CDialog(CRuku::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRuku)
	m_In_chandi = _T("");
	m_In_date = _T("");
	m_In_id = _T("");
	m_In_name = _T("");
	m_In_number = 0;
	m_In_price = 0.0;
	//}}AFX_DATA_INIT
}


void CRuku::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRuku)
	DDX_Text(pDX, IDC_IN_CHANDI, m_In_chandi);
	DDX_Text(pDX, IDC_IN_DATE, m_In_date);
	DDX_Text(pDX, IDC_IN_ID, m_In_id);
	DDX_Text(pDX, IDC_IN_NAME, m_In_name);
	DDX_Text(pDX, IDC_IN_NUMBER, m_In_number);
	DDX_Text(pDX, IDC_IN_PRICE, m_In_price);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRuku, CDialog)
	//{{AFX_MSG_MAP(CRuku)
	ON_BN_CLICKED(ID_I_OK, OnIOk)
	ON_BN_CLICKED(IDC_IN_DELETE, OnInDelete)
	ON_BN_CLICKED(IDC_IN_PRE, OnInPre)
	ON_BN_CLICKED(IDC_IN_NEXT, OnInNext)
	ON_BN_CLICKED(IDC_IN_EDIT, OnInEdit)
	ON_BN_CLICKED(IDC_OK, OnOk)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRuku message handlers

BOOL CRuku::OnInitDialog()
{
	m_db.Open(_T("supDNS"));
	m_rs.m_pDatabase=&m_db;
	m_rs.Open();
	m_In_chandi =m_rs.m_in_chandi;
	m_In_date = m_rs.m_in_date;
	m_In_id = m_rs.m_in_id;
	m_In_name = m_rs.m_in_name;
	m_In_number = m_rs.m_in_number;
	m_In_price =m_rs.m_in_price;
	UpdateData(FALSE);
	m_K_db.Open(_T("supDNS"));
	m_K_rs.m_pDatabase=&m_K_db;
	m_K_rs.Open();
	return TRUE;
}

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

void CRuku::OnIOk() 
{
	// TODO: Add your control notification handler code here
		m_In_chandi = _T("");
		m_In_date = _T("");
		m_In_id = _T("");
		m_In_name = _T("");
		m_In_number = 0;
		m_In_price = 0.0;
		UpdateData(FALSE);
}

void CRuku::OnInDelete() 
{
	// TODO: Add your control notificat
	if(m_rs.IsEOF()||m_rs.IsBOF())
		return;
	try
	{
		m_rs.Delete();
		m_In_chandi = _T("");
		m_In_date = _T("");
		m_In_id = _T("");
		m_In_name = _T("");
		m_In_number = 0;
		m_In_price = 0.0;
		MessageBox(" 删除成功");

	}
	catch(CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		return;
	}
	m_rs.MoveFirst();
	m_In_name=m_rs.m_in_name;
	m_In_chandi=m_rs.m_in_chandi;
	m_In_id=m_rs.m_in_id;
	m_In_date=m_rs.m_in_date;
	m_In_number=m_rs.m_in_number;
	m_In_price=m_rs.m_in_price;
	UpdateData(FALSE);
}

void CRuku::OnInPre() 
{
	// TODO: Add your control notification handler code here
	m_rs.MovePrev();
	if(m_rs.IsBOF())
		m_rs.MoveFirst();
	m_In_name=m_rs.m_in_name;
	m_In_chandi=m_rs.m_in_chandi;
	m_In_id=m_rs.m_in_id;
	m_In_date=m_rs.m_in_date;
	m_In_number=m_rs.m_in_number;
	m_In_price=m_rs.m_in_price;
	UpdateData(FALSE);
}

void CRuku::OnInNext() 
{
	// TODO: Add your control notification handler code here
	m_rs.MoveNext();
	if(m_rs.IsEOF())
		m_rs.MoveLast();
	m_In_name=m_rs.m_in_name;
	m_In_chandi=m_rs.m_in_chandi;
	m_In_id=m_rs.m_in_id;
	m_In_date=m_rs.m_in_date;
	m_In_number=m_rs.m_in_number;
	m_In_price=m_rs.m_in_price;
	UpdateData(FALSE);
}

void CRuku::OnInEdit() 
{
	// TODO: Add your control notification handler code here
	CString name,chandi,id,date;
	int number;
	double price;
	name=m_rs.m_in_name;
	chandi=m_rs.m_in_chandi;
	id=m_rs.m_in_id;
	date=m_rs.m_in_date;
	number=m_rs.m_in_number;
	price=m_rs.m_in_price;
	try
	{
		m_rs.Edit();
		UpdateData(TRUE);
		m_rs.m_in_chandi=m_In_chandi;
		m_rs.m_in_date=m_In_date;
		m_rs.m_in_id=m_In_id;
		m_rs.m_in_name=m_In_name;
		m_rs.m_in_number=m_In_number;
		m_rs.m_in_price=m_In_price;
		m_rs.Update();
	}
	catch(CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		m_In_name=name;
		m_In_chandi=chandi;
		m_In_date=date;
		m_In_number=number;
		m_In_id=id;
		m_In_price=price;
		UpdateData(FALSE);
	}
}

void CRuku::Addkucun()
{
	int i=1;
	m_K_rs.MoveFirst();
	UpdateData(TRUE);
	do
	{
		if(m_In_id==m_K_rs.m_id){
			i=-1;
			break;
		}
		m_K_rs.MoveNext();
	}while(!m_K_rs.IsEOF());
	if(i==1)
	{
		try
		{
			m_K_rs.AddNew();
			UpdateData(TRUE);
			m_K_rs.m_name=m_In_name;
			m_K_rs.m_id=m_In_id;
			m_K_rs.Update();
		}
		catch(CDBException*e)
		{
			AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
			e->Delete();
			UpdateData(FALSE);
		}
	}
}

void CRuku::OnOk() 
{
	// TODO: Add your control notification handler code here
	try
	{

		m_rs.AddNew();
		UpdateData(TRUE);
		m_rs.m_in_chandi=m_In_chandi;
		m_rs.m_in_date=m_In_date;
		m_rs.m_in_id=m_In_id;
		m_rs.m_in_name=m_In_name;
		m_rs.m_in_number=m_In_number;
		m_rs.m_in_price=m_In_price;
		m_rs.Update();
		this->Addkucun();
		MessageBox(" 添加成功");
	}
	catch(CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		m_rs.MoveFirst();
		m_In_name=m_rs.m_in_name;
		m_In_chandi=m_rs.m_in_chandi;
		m_In_id=m_rs.m_in_id;
		m_In_date=m_rs.m_in_date;
		m_In_number=m_rs.m_in_number;
		m_In_price=m_rs.m_in_price;
		UpdateData(FALSE);
	}
}