rsingle.cpp

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

// Rsingle.cpp : implementation file
//

#include "stdafx.h"
#include "Supermarket.h"
#include "Rsingle.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRsingle dialog


CRsingle::CRsingle(CWnd* pParent /*=NULL*/)
	: CDialog(CRsingle::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRsingle)
	m_S_name = _T("");
	m_S_id = _T("");
	m_S_profit = 0.0;
	m_S_number = 0;
	//}}AFX_DATA_INIT
}


void CRsingle::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRsingle)
	DDX_Control(pDX, IDC_S_LIST2, m_S_list2);
	DDX_Control(pDX, IDC_S_LIST, m_S_list);
	DDX_Text(pDX, IDC_S_NAME, m_S_name);
	DDX_Text(pDX, IDC_S_ID, m_S_id);
	DDX_Text(pDX, IDC_S_PROFIT, m_S_profit);
	DDX_Text(pDX, IDC_S_KUCUN, m_S_number);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRsingle, CDialog)
	//{{AFX_MSG_MAP(CRsingle)
	ON_BN_CLICKED(ID_S_OK, OnSOk)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRsingle message handlers

void CRsingle::OnSOk() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString p;
	p.Format("name='%s'",m_S_name);
	m_rs.Close();
	m_rs.m_strFilter=p;
	m_rs.Open();
	m_rs.Requery();
	m_S_name=m_rs.m_name;
	m_S_id=m_rs.m_id;
	m_S_number=m_rs.m_number;
	m_S_profit=m_rs.m_profit;
	int recCount=m_rs.GetRecordCount();
	if(recCount==0)
	{
		MessageBox("没有匹配的记录集");
		m_rs.Close();
		m_rs.m_strFilter="";
		m_rs.Open();
	}
	UpdateData(FALSE);
	this->Cshow();
	this->Rshow();
}

BOOL CRsingle::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_db.Open(_T("supDNS"));
	m_rs.m_pDatabase=&m_db;
	m_rs.Open();
	m_R_db.Open(_T("supDNS"));
	m_R_rs.m_pDatabase=&m_R_db;
	m_R_rs.Open();
	m_C_db.Open(_T("supDNS"));
	m_C_rs.m_pDatabase=&m_C_db;
	m_C_rs.Open();
	m_S_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_S_list.InsertColumn(0,"入库日期",LVCFMT_IMAGE|LVCFMT_LEFT);
	m_S_list.InsertColumn(1,"入库数量");
	m_S_list.InsertColumn(2,"进价");
	int i=0;
	for(i=0;i<3;i++){
		m_S_list.SetColumnWidth(i,99);
	}
	m_S_list2.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_S_list2.InsertColumn(0,"出库日期");
	m_S_list2.InsertColumn(1,"出库数量");
	m_S_list2.InsertColumn(2,"零售价");
	int j=0;
	for(j=0;j<3;j++){
		m_S_list2.SetColumnWidth(j,99);
	}
	return TRUE;
}

void CRsingle::OnCancel() 
{
	// TODO: Add extra cleanup here
	m_rs.Close();
	CDialog::OnCancel();
}

void CRsingle::Rshow()
{
	CString p;
	p.Format("in_name='%s'",m_S_name);
	m_R_rs.Close();
	m_R_rs.m_strFilter=p;
	m_R_rs.Open();
	m_R_rs.Requery();
	m_R_rs.MoveFirst();
	int i=0;
	do
	{
		CString s;
		m_S_list.InsertItem(i,m_R_rs.m_in_date,0);
		s.Format("%d",m_R_rs.m_in_number);
		m_S_list.SetItemText(i,1,s);
		s.Format("%.1f",m_R_rs.m_in_price);
		m_S_list.SetItemText(i,2,s);
		i++;
		m_R_rs.MoveNext();
	} while(!m_R_rs.IsEOF());
}

void CRsingle::Cshow()
{
	CString p;
	p.Format("out_name='%s'",m_S_name);
	m_C_rs.Close();
	m_C_rs.m_strFilter=p;
	m_C_rs.Open();
	m_C_rs.Requery();
	m_C_rs.MoveFirst();
	int j=0;
	do
	{
		CString s;
		m_S_list2.InsertItem(j,m_C_rs.m_out_date,0);
		s.Format("%d",m_C_rs.m_out_number);
		m_S_list2.SetItemText(j,1,s);
		s.Format("%.1f",m_C_rs.m_out_price);
		m_S_list2.SetItemText(j,2,s);
		j++;
		m_C_rs.MoveNext();
	} while(!m_C_rs.IsEOF());
}