?? kucun.cpp
字號(hào):
// 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,"產(chǎn)地");
m_Kucun_list.InsertColumn(3,"總?cè)霂炝?quot;);
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());
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -