下载资源后端资源详情
Database.zip
大小:5.63MB
价格:46积分
下载量:0
评分:
5.0
上传者:love_inter_net
更新日期:2025-09-22

餐厅管理系统

资源文件列表(大概)

文件名
大小
Database/
-
Database/MyPosDlg.cpp
5.92KB
Database/ClassDlg.cpp
14.19KB
Database/BaseDlg.cpp
1.42KB
Database/BaseDlg.h
1.38KB
Database/CallDlg.cpp
1.48KB
Database/CallDlg.h
1.21KB
Database/CheckDlg.cpp
14.18KB
Database/CheckDlg.h
1.68KB
Database/res/
-
Database/res/MyPosMFC.ico
1.05KB
Database/res/MyPos.rc2
397B
Database/res/csy.bmp
508.06KB
Database/res/logo.bmp
21.93KB
Database/res/logon.bmp
196.93KB
Database/res/Thumbs.db
26.5KB
Database/res/MyPos.ico
4.19KB
Database/res/csy_yellow.bmp
508.06KB
Database/ClassDlg.h
1.82KB
Database/CleardataDlg.cpp
3.67KB
Database/CleardataDlg.h
1.29KB
Database/Cypos.mdb
872KB
Database/dbgrid32.cpp
6.88KB
Database/dbgrid32.h
2.68KB
Database/image.cpp
5.26KB
Database/image.h
2.58KB
Database/MyPos.opt
103KB
Database/LogonDlg.h
1.27KB
Database/MaterielDlg.h
1.9KB
Database/ModifyqaDlg.cpp
1.14KB
Database/ModifyqaDlg.h
1.21KB
Database/msdgridctrl.cpp
13.75KB
Database/msdgridctrl.h
4.64KB
Database/msdgridctrl1.cpp
13.75KB
Database/msdgridctrl1.h
4.64KB
Database/msdgridctrl2.cpp
13.75KB
Database/msdgridctrl2.h
4.64KB
Database/MyPos.clw
13.07KB
Database/MyPos.dsp
7.53KB
Database/MyPos.dsw
621B
Database/MyPos.h
1.66KB
Database/MyPos.plg
244B
Database/MyPos.rc
925.49KB
Database/MyPosDlg.h
1.73KB
Database/OffdutyDlg.cpp
12.55KB
Database/OffdutyDlg.h
1.46KB
Database/PaymodeDlg.cpp
5.92KB
Database/PaymodeDlg.h
1.42KB
Database/picture.cpp
1.1KB
Database/picture.h
1.26KB
Database/PosDlg.cpp
37.11KB
Database/PosDlg.h
2.55KB
Database/QueryPY.dll
70KB
Database/resource.h
7.47KB
Database/SelectDlg.cpp
8.07KB
Database/SelectDlg.h
1.52KB
Database/Splash.cpp
3.13KB
Database/Splash.h
1.13KB
Database/StatDlg.cpp
16.04KB
Database/StatDlg.h
1.5KB
Database/StdAfx.cpp
207B
Database/StdAfx.h
1.13KB
Database/SysmtDlg.cpp
1.45KB
Database/SysmtDlg.h
1.34KB
Database/SyssetDlg.cpp
3KB
Database/SyssetDlg.h
1.26KB
Database/TabSheet.cpp
2.41KB
Database/TabSheet.h
1.38KB
Database/UserDlg.cpp
12.51KB
Database/UserDlg.h
1.95KB
Database/MyPos.ncb
209KB
Database/Debug/
-
Database/Debug/msado15.tlh
88.54KB
Database/Debug/msado15.tli
74.84KB
Database/Debug/MyPos.res
762.29KB
Database/Debug/vc60.idb
305KB
Database/Debug/MyPos.pch
7.34MB
Database/Debug/vc60.pdb
564KB
Database/Debug/StdAfx.obj
129.89KB
Database/Debug/SyssetDlg.obj
71.48KB
Database/Debug/SysmtDlg.obj
24.34KB
Database/Debug/StatDlg.obj
156KB
Database/Debug/Splash.obj
20.72KB
Database/Debug/SelectDlg.obj
86.29KB
Database/Debug/PosDlg.obj
307.5KB
Database/Debug/picture.obj
5.25KB
Database/Debug/PaymodeDlg.obj
88.9KB
Database/Debug/OffdutyDlg.obj
118.64KB
Database/Debug/ModifyqaDlg.obj
12.87KB
Database/Debug/image.obj
30.52KB
Database/Debug/CleardataDlg.obj
76KB
Database/Debug/ClassDlg.obj
147.93KB
Database/Debug/CheckDlg.obj
142.92KB
Database/Debug/CallDlg.obj
14.62KB
Database/Debug/BaseDlg.obj
21.33KB
Database/Debug/UserDlg.obj
144.71KB
Database/Debug/TabSheet.obj
14.1KB
Database/Debug/MyPos.pdb
1.02MB
Database/Debug/LogonDlg.obj
59.22KB
Database/Debug/MyPos.ilk
748.99KB
Database/Debug/MyPos.obj
110.56KB
Database/Debug/MyPosDlg.obj
92.06KB
Database/Debug/MaterielDlg.obj
153.47KB
Database/Debug/MyPos.exe
1.41MB
Database/MyPos.aps
789.16KB
Database/MaterielDlg.cpp
15.25KB
Database/LogonDlg.cpp
4.53KB
Database/MyPos.cpp
4.6KB

资源内容介绍

根据资料编写的一个餐厅管理系统.拿来和大家分享一下.希望能对数据库管理系统的FAN 有所帮助.....
// PosDlg.cpp : implementation file//#include "stdafx.h"#include "MyPos.h"#include "PosDlg.h"#include "SelectDlg.h"#include "ModifyqaDlg.h"#include "CallDlg.h"#include "CheckDlg.h"#include "OffdutyDlg.h"#ifdef _DEBUG#define new DEBUG_NEW#undef THIS_FILEstatic char THIS_FILE[] = __FILE__;#endif/////////////////////////////////////////////////////////////////////////////// CPosDlg dialogextern CMyPosApp theApp;CPosDlg::CPosDlg(CWnd* pParent ): CDialog(CPosDlg::IDD, pParent){//{{AFX_DATA_INIT(CPosDlg)//}}AFX_DATA_INIT}void CPosDlg::DoDataExchange(CDataExchange* pDX){CDialog::DoDataExchange(pDX);//{{AFX_DATA_MAP(CPosDlg)DDX_Control(pDX, IDC_EDIT_ACTTOTAL, m_oActtotal);DDX_Control(pDX, IDC_EDIT_TOTAL, m_oTotal);DDX_Control(pDX, IDC_BUTTON_SELMATERIEL, m_oButton);DDX_Control(pDX, IDC_LIST_FORM, m_oFormlist);DDX_Control(pDX, IDC_EDIT_BEGINTIME, m_oBegintime);DDX_Control(pDX, IDC_EDIT_ENDTIME, m_oEndtime);DDX_Control(pDX, IDC_EDIT_CKECK, m_oCheck);DDX_Control(pDX, IDC_EDIT_STATUS, m_oStatus);DDX_Control(pDX, IDC_EDIT_PEASONS, m_oPeasons);DDX_Control(pDX, IDC_EDIT_TABLENO, m_oTableno);DDX_Control(pDX, IDC_LIST_BILL, m_oListbill);//}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP(CPosDlg, CDialog)//{{AFX_MSG_MAP(CPosDlg)ON_BN_CLICKED(IDC_BUTTON_ADDF, OnButtonAddf)ON_LBN_SELCHANGE(IDC_LIST_BILL, OnSelchangeListBill)ON_BN_CLICKED(IDC_BUTTON_SELMATERIEL, OnButtonSelmateriel)ON_NOTIFY(NM_DBLCLK, IDC_LIST_FORM, OnDblclkListForm)ON_BN_CLICKED(IDC_BUTTON_CALLF, OnButtonCallf)ON_BN_CLICKED(IDC_BUTTON_DELF, OnButtonDelf)ON_BN_CLICKED(IDC_BUTTON_HIDEF, OnButtonHidef)ON_BN_CLICKED(IDC_BUTTON_CHECKF, OnButtonCheckf)ON_EN_KILLFOCUS(IDC_EDIT_TABLENO, OnKillfocusEditTableno)ON_EN_KILLFOCUS(IDC_EDIT_PEASONS, OnKillfocusEditPeasons)ON_BN_CLICKED(IDC_BUTTON_OFF, OnButtonOff)ON_BN_CLICKED(IDC_BUTTON_FINDF, OnButtonFindf)ON_BN_CLICKED(IDC_BUTTON_LOCALP, OnButtonLocalp)//}}AFX_MSG_MAPON_MESSAGE(WM_APPLY,OnMyMessage)//Map WM_APPLY message to OnMyMessage function.ON_MESSAGE(WM_CHECKOUT,OnMyCheckMessage)//Map WM_CHECKOUT message to OnMyMessage function.END_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////// CPosDlg message handlersBOOL CPosDlg::OnInitDialog() {CDialog::OnInitDialog();//设置list控件的文字和背景颜色m_oFormlist.SetBkColor(RGB(255,255,255));m_oFormlist.SetTextBkColor(RGB(255,255,255));//清空list控件的数据for(int delcolumn=100;delcolumn>=0;delcolumn--)m_oFormlist.DeleteColumn(delcolumn);//设置list对话框的列DWORD dwStyle;RECT rect;LV_COLUMN lvc;dwStyle = m_oFormlist.GetStyle();dwStyle |= LVS_EX_GRIDLINES |LVS_EX_FULLROWSELECT |LVS_SHOWSELALWAYS |LVS_EDITLABELS ;m_oFormlist.SetExtendedStyle(dwStyle);m_oFormlist.GetClientRect(&rect);lvc.mask = LVCF_TEXT | LVCF_SUBITEM | LVCF_WIDTH |LVCF_FMT;lvc.fmt=LVCFMT_LEFT;lvc.iSubItem = 0;lvc.pszText = _T("序号");lvc.cx = 70;m_oFormlist.InsertColumn(1,&lvc);lvc.iSubItem = 1;lvc.pszText = _T("名称");lvc.cx = 220;m_oFormlist.InsertColumn(2,&lvc);lvc.iSubItem = 2;lvc.pszText = _T("数量");lvc.cx = 80;m_oFormlist.InsertColumn(3,&lvc);lvc.iSubItem = 3;lvc.pszText = _T("金额");lvc.cx = 120;m_oFormlist.InsertColumn(4,&lvc);//Add all bill whos state is "等待" to listbill.CString sql="Select * from SALEBILL where STATUS<>'已结帐'";_RecordsetPtr m_pRecordset; //Must define it in function!!!!try{ m_pRecordset.CreateInstance("ADODB.Recordset");m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);while(!m_pRecordset->adoEOF){m_oListbill.AddString((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ID"));m_pRecordset->MoveNext();}m_pRecordset->Close();}catch(_com_error e)///捕捉异常{CString stemp;stemp.Format("[初始化]读取 '等待' 单据出错:%s",e.ErrorMessage());AfxMessageBox(stemp);}//Select the last billid in listbox and read its items to listctrl and head to edit.int ncount=m_oListbill.GetCount();if(ncount>0){CString sbillid;int nselect;nselect=m_oListbill.SetCurSel(ncount-1);m_oListbill.GetText(nselect,sbillid);ReadBillHead(sbillid);ReadToFormlist(sbillid);}else{//Put the button to the first list row.//将button移到合适的位置并设置其大小m_oFormlist.GetWindowRect(&rect);m_oButton.MoveWindow(440,95, rect.right/33, rect.bottom/25);m_oButton.BringWindowToTop();m_oButton.ShowWindow(SW_SHOW);//从隐藏变为显示}theApp.pWnd=GetSafeHwnd();//Initialize pWnd;return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE}void CPosDlg::OnButtonAddf() {CString snowtime,sfloor,snewid,sbillno;CString sql;_RecordsetPtr m_pRecordset; //Must define it in function!!!!sfloor=GetCompanyFloor(FALSE);//Clear the edit ctrl.m_oTableno.SetWindowText("");m_oPeasons.SetWindowText("");//得到系统时间CTime now=CTime::GetCurrentTime();snowtime=now.Format(_T("%Y-%m-%d %H:%M:%S"));sbillno=GenNewBillID();sql="Insert into SALEBILL (ID,BEGINDATE,STATUS,TOTAL,ACTTOTAL,PAYMODE,FLOOR) values ('"+sbillno+"','"+snowtime+"','等待',0,0,1,'"+sfloor+"')";try{ _variant_t RecordsAffected;theApp.m_pConnection->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);}catch(_com_error e)///捕捉异常{CString temp;temp.Format("[开单]生成单据出错:%s",e.ErrorMessage());AfxMessageBox(temp);return;}m_oStatus.SetWindowText("等待");m_oBegintime.SetWindowText(snowtime);m_oTotal.SetWindowText("0.00");m_oActtotal.SetWindowText("0.00");m_oListbill.AddString(sbillno);m_oListbill.SelectString(-1,sbillno);theApp.scallid=sbillno;//Get current bill id.m_oFormlist.DeleteAllItems();RECT rect;m_oFormlist.GetWindowRect(&rect);m_oButton.MoveWindow(440,95, rect.right/40, rect.bottom/35);m_oButton.BringWindowToTop();m_oButton.ShowWindow(SW_SHOW);//从隐藏变为显示}CString CPosDlg::GenNewBillID(){CString sql,snowtime;CString sNewID,scurid,snewid;long lnewid,lcount;_RecordsetPtr m_pRecordset; //Must define it in function!!!!//得到系统时间CTime now=CTime::GetCurrentTime();snowtime=now.Format(_T("%Y%m%d"));sql="Select count(*) as XXX from SALEBILL where ID like '"+snowtime+"%""'";lcount=GetRecordCount(sql);if(lcount==0){sNewID.Format("%s-00001",snowtime);return sNewID;}sql="Select Max(ID) as AAA from SALEBILL where ID like '"+snowtime+"%""'";try{ m_pRecordset.CreateInstance("ADODB.Recordset");m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);scurid=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AAA");lnewid=atol(scurid.Right(5))+1;snewid.Format("-%05d",lnewid);sNewID=snowtime+snewid;m_pRecordset->Close();}catch(_com_error e)///捕捉异常{CString stemp;stemp.Format("获取最大单据编号出错:%s",e.ErrorMessage());AfxMessageBox(stemp);}return sNewID;}void CPosDlg::OnSelchangeListBill() {CString stemp,sql,sbillid;int iOption; _RecordsetPtr m_pRecordset;iOption = m_oListbill.GetCurSel();m_oListbill.GetText(iOption, sbillid);//得到选中项的文本theApp.scallid=sbillid;//Get current bill id.//Clear the edit ctrl.m_oTableno.SetWindowText("");m_oPeasons.SetWindowText("");sql="select * from SALEBILL where ID='"+sbillid+"'";try{m_pRecordset.CreateInstance("ADODB.Recordset");m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);if(!m_pRecordset->adoEOF){m_oTableno.Se

用户评论 (0)

发表评论

captcha

相关资源

win10/win1桌面图标锁定，防止桌面图标移动

win10/win1桌面图标锁定，防止桌面图标移动

273.62KB42积分

dojo Ajax

dojo ajax framework

3.29MB37积分

Elecard Stream Analyzer

Elecard Stream Analyzer是一个强大的工具，为媒体流的编码和日志介绍分析、语法分析而设计。Stream Analyzer 可以操作以下几种格式：MPEG-1 Video/Audio, MPEG-2 Video/Audio, AAC, AC-3和 AVC/H.264.

3.01MB10积分

php5apache2.dll-php5.1.x.zip

php5apache2.dll-php5.1.x.zip

13.61KB45积分