kucun.cpp

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

// KUCUN.cpp : implementation file
//

#include "stdafx.h"
#include "Supermarket.h"
#include "KUCUN.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKUCUN dialog


CKUCUN::CKUCUN(CWnd* pParent /*=NULL*/)
	: CDialog(CKUCUN::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKUCUN)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CKUCUN::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKUCUN)
	DDX_Control(pDX, IDC_KUCUN_LIST, m_Kucun_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKUCUN, CDialog)
	//{{AFX_MSG_MAP(CKUCUN)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKUCUN message handlers

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

BOOL CKUCUN::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_db.Open(_T("supDNS"));
	m_rs.m_pDatabase=&m_db;
	m_rs.Open();
	this->Cal();
	m_Kucun_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_Kucun_list.InsertColumn(0,"商品名称",LVCFMT_IMAGE|LVCFMT_LEFT);
	m_Kucun_list.InsertColumn(1,"商品代码");
	m_Kucun_list.InsertColumn(2,"产地");
	m_Kucun_list.InsertColumn(3,"总入库量");
	m_Kucun_list.InsertColumn(4,"总出库量");
	m_Kucun_list.InsertColumn(5,"库存");
	m_Kucun_list.InsertColumn(6,"利润");
	int i=0;
	for(i=0;i<7;i++){
		m_Kucun_list.SetColumnWidth(i,84);
	}
	this->show();
	m_rs.Close();
	return TRUE;
}

void CKUCUN::Cal()
{
	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_rs.MoveFirst();
	while(!m_rs.IsEOF())
	{
		int s=0,p=0;
		CString chandi;
		double in=0,out=0;
		m_R_rs.MoveFirst();
		m_C_rs.MoveFirst();
		do
		{
			if(m_R_rs.m_in_id==m_rs.m_id)
			{
				chandi=m_R_rs.m_in_chandi;
				in=m_R_rs.m_in_price;
				s=s+m_R_rs.m_in_number;
			}
			m_R_rs.MoveNext();
		}while(!m_R_rs.IsEOF());
		do
		{
			if(m_C_rs.m_out_id==m_rs.m_id)
			{
				out=m_C_rs.m_out_price;
				p=p+m_C_rs.m_out_number;
			}
			m_C_rs.MoveNext();
		}while(!m_C_rs.IsEOF());
		try
		{
			m_rs.Edit();
			UpdateData(TRUE);
			m_rs.m_chandi=chandi;
			m_rs.m_totalruku=s;
			m_rs.m_totalchuku=p;
			m_rs.m_number=s-p;
			m_rs.m_profit=(out-in)*p;
			m_rs.Update();
		}
		catch(CDBException*e)
		{
			AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
			e->Delete();
			UpdateData(FALSE);
		}
		m_rs.MoveNext();
	}
	m_R_rs.Close();
	m_C_rs.Close();
}

void CKUCUN::show()
{
	int i=0;
	m_rs.MoveFirst();
	do
	{
		CString s;
		m_Kucun_list.InsertItem(i,m_rs.m_name,0);
		m_Kucun_list.SetItemText(i,1,m_rs.m_id);
		m_Kucun_list.SetItemText(i,2,m_rs.m_chandi);
		s.Format("%d",m_rs.m_totalruku);
        m_Kucun_list.SetItemText(i,3,s);
		s.Format("%d",m_rs.m_totalchuku);
		m_Kucun_list.SetItemText(i,4,s);
		s.Format("%d",m_rs.m_number);
        m_Kucun_list.SetItemText(i,5,s);
		s.Format("%.1f",m_rs.m_profit);
		m_Kucun_list.SetItemText(i,6,s);
		i++;
		m_rs.MoveNext();
	} while(!m_rs.IsEOF());
}