www.pudn.com > cygl.rar > Lspgl.cpp
// Lspgl.cpp : implementation file
//
#include "stdafx.h"
#include "cyglxt.h"
#include "Lspgl.h"
#include "ADOConn.h"
#include "Tjlsp.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CLspgl dialog
CLspgl::CLspgl(CWnd* pParent /*=NULL*/)
: CJieMian(pParent)
{
//{{AFX_DATA_INIT(CLspgl)
jinjia=NULL;
maijia=NULL;
//}}AFX_DATA_INIT
}
void CLspgl::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CLspgl)
DDX_Control(pDX, IDC_ShuaXin, m_SHUAXIN);
DDX_Control(pDX, IDC_BUTTON1, m_XIUGAI);
DDX_Control(pDX, IDC_BUTTON2, m_SHANCHU);
DDX_Control(pDX, IDOK, m_TUICHU);
DDX_Control(pDX, IDC_BUTTON3, m_TIANJIA);
DDX_Control(pDX, IDC_EDIT12, m_maijia);
DDX_Control(pDX, IDC_EDIT11, m_jinjia);
DDX_Control(pDX, IDC_EDIT2, m_danwei);
DDX_Control(pDX, IDC_EDIT1, m_lspmc);
DDX_Control(pDX, IDC_LIST1, m_LSP);
DDX_Text(pDX, IDC_EDIT11, jinjia);
DDX_Text(pDX, IDC_EDIT12, maijia);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CLspgl, CDialog)
//{{AFX_MSG_MAP(CLspgl)
ON_NOTIFY(NM_CLICK, IDC_LIST1, OnLSP)
ON_BN_CLICKED(IDC_BUTTON1, OnXiuGai)
ON_BN_CLICKED(IDC_BUTTON2, OnShanChu)
ON_BN_CLICKED(IDC_BUTTON3, OnTianjia)
ON_BN_CLICKED(IDC_ShuaXin, OnShuaXin)
ON_WM_PAINT()
ON_WM_CTLCOLOR()
ON_WM_SYSCOMMAND()
ON_WM_NCMOUSEMOVE()
ON_WM_NCLBUTTONDOWN()
ON_WM_SETCURSOR()
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CLspgl message handlers
BOOL CLspgl::OnInitDialog()
{
CDialog::OnInitDialog();
m_LSP.SetTextColor(RGB (0, 255, 255));
m_LSP.SetTextBkColor(RGB (140, 180, 20));
m_LSP.SetBkColor(RGB (175, 190, 0));
m_LSP.InsertColumn(0,"零售品名称",LVCFMT_LEFT,115);
m_LSP.InsertColumn(1,"单位",LVCFMT_LEFT,52);
m_LSP.InsertColumn(2,"进价(元/单位)",LVCFMT_LEFT,115);
m_LSP.InsertColumn(3,"卖价(元/单位)",LVCFMT_LEFT,115);
m_LSP.InsertColumn(4,"单位利润(元)",LVCFMT_LEFT,124);
m_LSP.ModifyStyle(0,LVS_REPORT | LVS_SHOWSELALWAYS | LVS_SINGLESEL);
m_LSP.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP);
m_SHUAXIN.LoadBitmaps(IDB_SHUAXIN);
m_SHUAXIN.SizeToContent();
m_SHANCHU.LoadBitmaps(IDB_SHANCHU);
m_SHANCHU.SizeToContent();
m_TIANJIA.LoadBitmaps(IDB_TIANJIA1);
m_TIANJIA.SizeToContent();
m_XIUGAI.LoadBitmaps(IDB_XIUGAI);
m_XIUGAI.SizeToContent();
m_TUICHU.LoadBitmaps(IDB_TUICHU);
m_TUICHU.SizeToContent();
shuaxin();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CLspgl::shuaxin()
{
m_LSP.DeleteAllItems();
ADOConn rst;
rst.OnInitADOConn();
rst.Open("select * from Lsp",adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_LSP.InsertItem(ii-1,"");
m_LSP.SetItemText(ii-1,0,rst.GetFieldValue("零售品名称"));
m_LSP.SetItemText(ii-1,1,rst.GetFieldValue("单位"));
m_LSP.SetItemText(ii-1,2,rst.GetFieldValue("进价"));
m_LSP.SetItemText(ii-1,3,rst.GetFieldValue("售价"));
m_LSP.SetItemText(ii-1,4,rst.GetFieldValue("单位利润"));
rst.Move(ii);
}
rst.ExitConnect();
}
CString name1;
void CLspgl::OnLSP(NMHDR* pNMHDR, LRESULT* pResult)
{
int i=m_LSP.GetSelectionMark();
m_lspmc.SetWindowText(m_LSP.GetItemText(i,0));
m_danwei.SetWindowText(m_LSP.GetItemText(i,1));
m_jinjia.SetWindowText(m_LSP.GetItemText(i,2));
m_maijia.SetWindowText(m_LSP.GetItemText(i,3));
name1=m_LSP.GetItemText(i,0);
*pResult = 0;
}
void CLspgl::OnXiuGai()
{
UpdateData(true);
CString name,jj,mj,dw,lirun;
m_danwei.GetWindowText(dw);
m_jinjia.GetWindowText(jj);
m_maijia.GetWindowText(mj);
m_lspmc.GetWindowText(name);
if(name=="")
{
MessageBox("请选择要修改的零售品","餐饮管理系统");
return;
}
float lr;
lr=maijia-jinjia;
lirun.Format("%f",lr);
ADOConn rst;
_bstr_t vSQL;
vSQL="UPDATE Lsp SET 零售品名称='"+name+"',单位='"+dw+"',进价='"+jj+"',售价='"+mj+"',单位利润='"+lirun+"' WHERE 零售品名称="+" '"+name1+"'";
rst.ExecuteSQL(vSQL);
MessageBox("修改已成功:)","餐饮管理系统");
rst.ExitConnect();
shuaxin();
UpdateData(false);
}
void CLspgl::OnShanChu()
{
CString name;
m_lspmc.GetWindowText(name);
if(name=="")
{
MessageBox("请选择要删除的零售品","餐饮管理系统");
return;
}
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
sql.Format("delete from Lsp where 零售品名称='%s'",name1);
m_AdoConn.ExecuteSQL((_bstr_t)sql);
m_AdoConn.ExitConnect();
m_LSP.DeleteAllItems();
shuaxin();// TODO: Add your control notification handler code here
}
void CLspgl::OnTianjia()
{
// TODO: Add your control notification handler code here
CTjlsp *pMyDlg;
pMyDlg = new CTjlsp;
pMyDlg->Create(IDD_TJLSP);
pMyDlg->ShowWindow(SW_SHOW);
}
void CLspgl::OnShuaXin()
{
shuaxin();
}
void CLspgl::OnPaint()
{
CJieMian::OnPaint();
}
HBRUSH CLspgl::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
{
HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
switch (nCtlColor) {
case CTLCOLOR_EDIT:
case CTLCOLOR_STATIC:
case CTLCOLOR_DLG :
case CTLCOLOR_LISTBOX:
case CTLCOLOR_MSGBOX:
case CTLCOLOR_SCROLLBAR:
pDC->SetBkMode(TRANSPARENT);
HBRUSH B = CreateSolidBrush(RGB(234,243,148));
return (HBRUSH) B;
return CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
}
}
void CLspgl::OnSysCommand(UINT nID, LPARAM lParam)
{
// TODO: Add your message handler code here and/or call default
CJieMian::OnSysCommand(nID, lParam);
}
void CLspgl::OnNcMouseMove(UINT nHitTest, CPoint point)
{
// TODO: Add your message handler code here and/or call default
CJieMian::OnNcMouseMove(nHitTest, point);
}
void CLspgl::OnNcLButtonDown(UINT nHitTest, CPoint point)
{
// TODO: Add your message handler code here and/or call default
CJieMian::OnNcLButtonDown(nHitTest, point);
}
BOOL CLspgl::OnSetCursor(CWnd* pWnd, UINT nHitTest, UINT message)
{
if (pWnd==GetDlgItem(IDOK) || pWnd==GetDlgItem(IDCANCEL)||pWnd==GetDlgItem(IDC_BUTTON1)||pWnd==GetDlgItem(IDC_BUTTON2)||pWnd==GetDlgItem(IDC_BUTTON3)||pWnd==GetDlgItem(IDC_ShuaXin))
{
SetCursor(LoadCursor(NULL,IDC_HAND));
return TRUE;
}
return CDialog::OnSetCursor(pWnd, nHitTest, message);
}