www.pudn.com > cygl.rar > Czgl.cpp
// Czgl.cpp : implementation file
//
#include "stdafx.h"
#include "cyglxt.h"
#include "Czgl.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CCzgl dialog
CCzgl::CCzgl(CWnd* pParent /*=NULL*/)
: CJieMian(pParent)
{
//{{AFX_DATA_INIT(CCzgl)
//}}AFX_DATA_INIT
}
void CCzgl::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CCzgl)
DDX_Control(pDX, IDCANCEL, m_TUICHU);
DDX_Control(pDX, IDC_BUTTON2, m_XIUGAI);
DDX_Control(pDX, IDC_BUTTON1, m_TIANJIA);
DDX_Control(pDX, IDC_BUTTON3, m_SHANCHU);
DDX_Control(pDX, IDOK, m_QUEDING);
DDX_Control(pDX, IDC_EDIT1, m_czbh);
DDX_Control(pDX, IDC_EDIT2, m_number);
DDX_Control(pDX, IDC_COMBO1, m_leixing);
DDX_Control(pDX, IDC_LIST1, m_CZLB);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CCzgl, CDialog)
//{{AFX_MSG_MAP(CCzgl)
ON_WM_CTLCOLOR()
ON_NOTIFY(NM_CLICK, IDC_LIST1, OnCZLB)
ON_BN_CLICKED(IDC_BUTTON2, OnXiuGai)
ON_WM_PAINT()
ON_WM_NCLBUTTONDOWN()
ON_WM_NCMOUSEMOVE()
ON_WM_SYSCOMMAND()
ON_BN_CLICKED(IDC_BUTTON3, OnShanChu)
ON_BN_CLICKED(IDC_BUTTON1, OnTianJia)
ON_WM_SETCURSOR()
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CCzgl message handlers
BOOL CCzgl::OnInitDialog()
{
CDialog::OnInitDialog();
m_leixing.AddString("大厅");
m_leixing.AddString("包间");
m_leixing.AddString("豪华包间");
m_CZLB.SetTextColor(RGB (0, 255, 255));
m_CZLB.SetTextBkColor(RGB (140, 180, 20));
m_CZLB.SetBkColor(RGB (175, 190, 0));
m_CZLB.InsertColumn(0,"餐桌编号",LVCFMT_LEFT,75);
m_CZLB.InsertColumn(1,"餐桌类型",LVCFMT_LEFT,75);
m_CZLB.InsertColumn(2,"最大进餐人数",LVCFMT_LEFT,90);
m_CZLB.InsertColumn(3,"状态",LVCFMT_LEFT,45);
m_CZLB.InsertColumn(4,"包间费",LVCFMT_LEFT,67);
m_CZLB.ModifyStyle(0,LVS_REPORT | LVS_SHOWSELALWAYS | LVS_SINGLESEL);
m_CZLB.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP);
m_QUEDING.LoadBitmaps(IDB_QUEDING);
m_QUEDING.SizeToContent();
m_SHANCHU.LoadBitmaps(IDB_SHANCHU);
m_SHANCHU.SizeToContent();
m_TIANJIA.LoadBitmaps(IDB_TIANJIA);
m_TIANJIA.SizeToContent();
m_XIUGAI.LoadBitmaps(IDB_XIUGAI);
m_XIUGAI.SizeToContent();
m_TUICHU.LoadBitmaps(IDB_TUICHU);
m_TUICHU.SizeToContent();
shuaxin();
return TRUE;
}
HBRUSH CCzgl::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 CCzgl::shuaxin()
{
ADOConn rst;
rst.OnInitADOConn();
rst.Open("select * from Czb",adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_CZLB.InsertItem(ii-1,"");
m_CZLB.SetItemText(ii-1,0,rst.GetFieldValue("餐桌编号"));
m_CZLB.SetItemText(ii-1,1,rst.GetFieldValue("餐桌类型"));
m_CZLB.SetItemText(ii-1,2,rst.GetFieldValue("最大进餐人数"));
m_CZLB.SetItemText(ii-1,3,rst.GetFieldValue("状态"));
m_CZLB.SetItemText(ii-1,4,rst.GetFieldValue("包间费"));
rst.Move(ii);
}
rst.close();
}
CString bh;
void CCzgl::OnCZLB(NMHDR* pNMHDR, LRESULT* pResult)
{
// TODO: Add your control notification handler code here
int i=m_CZLB.GetSelectionMark();
m_czbh.SetWindowText(m_CZLB.GetItemText(i,0));
m_leixing.SetWindowText(m_CZLB.GetItemText(i,1));
m_number.SetWindowText(m_CZLB.GetItemText(i,2));
bh=m_CZLB.GetItemText(i,0);
*pResult = 0;
}
void CCzgl::OnXiuGai()
{
// TODO: Add your control notification handler code here
CString czbh,leixing,number;
m_czbh.GetWindowText(czbh);
m_leixing.GetWindowText(leixing);
m_number.GetWindowText(number);
UpdateData(true);
if(czbh=="")
{
MessageBox("请选择要修改的餐桌","餐饮管理系统");
return;
}
ADOConn m_AdoConn;
_bstr_t vSQL;
vSQL="UPDATE Czb SET 餐桌编号='"+czbh+"', 餐桌类型='"+leixing+"', 最大进餐人数='"+number+"' WHERE 餐桌编号="+" '"+bh+"'";
m_AdoConn.ExecuteSQL(vSQL);
MessageBox("修改已成功:)","餐饮管理系统");
m_AdoConn.ExitConnect();
m_CZLB.DeleteAllItems();
shuaxin();
UpdateData(false);
}
void CCzgl::OnPaint()
{
CJieMian::OnPaint();
}
void CCzgl::OnNcLButtonDown(UINT nHitTest, CPoint point)
{
// TODO: Add your message handler code here and/or call default
CJieMian::OnNcLButtonDown(nHitTest, point);
}
void CCzgl::OnNcMouseMove(UINT nHitTest, CPoint point)
{
// TODO: Add your message handler code here and/or call default
CJieMian::OnNcMouseMove(nHitTest, point);
}
void CCzgl::OnSysCommand(UINT nID, LPARAM lParam)
{
// TODO: Add your message handler code here and/or call default
CJieMian::OnSysCommand(nID, lParam);
}
void CCzgl::OnShanChu()
{
UpdateData(true);
int i=m_CZLB.GetSelectionMark();
CString czbh;
czbh=m_CZLB.GetItemText(i,0);
if(czbh=="")
{
MessageBox("请选择要删除的餐桌","餐饮管理系统");
return;
}
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
sql.Format("delete from Czb where 餐桌编号='%s'",czbh);
m_AdoConn.ExecuteSQL((_bstr_t)sql);
m_AdoConn.ExitConnect();
MessageBox("删除餐桌成功","餐饮管理系统");
m_CZLB.DeleteAllItems();
shuaxin();
}
void CCzgl::OnTianJia()
{
UpdateData(true);
CString czbh,leixing,number,zhuangtai;
zhuangtai="空闲";
m_czbh.GetWindowText(czbh);
m_leixing.GetWindowText(leixing);
m_number.GetWindowText(number);
UpdateData(true);
if(czbh=="")
{
MessageBox("请将餐桌资料填写完毕","餐饮管理系统");
return;
}
ADOConn rst;
CString ssql;
ssql.Format("SELECT*FROM Czb WHERE 餐桌编号='%s'",czbh);
_RecordsetPtr m_pRecordset;
m_pRecordset=rst.GetRecordSet((_bstr_t)ssql);
if(m_pRecordset->adoEOF)
{
}
else
{
MessageBox("此零餐桌编号已经存在","餐饮管理系统");
return;
}
_bstr_t vSQL;
CString BJF="0";
if(leixing=="包间")
{
BJF="50";
vSQL="INSERT INTO Czb(餐桌编号,餐桌类型,最大进餐人数,状态,包间费)VALUES('"+czbh+"','"+leixing+"','"+number+"','"+zhuangtai+"','"+BJF+"')";
rst.ExecuteSQL(vSQL);
}
else if(leixing=="豪华包间")
{
BJF="100";
vSQL="INSERT INTO Czb(餐桌编号,餐桌类型,最大进餐人数,状态,包间费)VALUES('"+czbh+"','"+leixing+"','"+number+"','"+zhuangtai+"','"+BJF+"')";
rst.ExecuteSQL(vSQL);
}
else if(leixing=="大厅")
{
vSQL="INSERT INTO Czb(餐桌编号,餐桌类型,最大进餐人数,状态,包间费)VALUES('"+czbh+"','"+leixing+"','"+number+"','"+zhuangtai+"')";
rst.ExecuteSQL(vSQL);
}
rst.ExitConnect();
MessageBox("添加餐桌成功:)","餐饮管理系统");
m_CZLB.DeleteAllItems();
shuaxin();
}
BOOL CCzgl::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))
{
SetCursor(LoadCursor(NULL,IDC_HAND));
return TRUE;
}
return CDialog::OnSetCursor(pWnd, nHitTest, message);
}