小型餐飲管理系統(tǒng)

1、第一章 設(shè)計(jì)任務(wù)與要求目的及意義 ：此小型餐飲業(yè)管理系統(tǒng)的設(shè)計(jì)主要是為了方便管理，對于各個(gè)進(jìn)出賬目，支出和收入 的管理便于系統(tǒng)化，在每月匯總計(jì)算中分析運(yùn)營趨勢和餐館的發(fā)展方向進(jìn)行一定的規(guī)劃。 通過各個(gè)月的盈利進(jìn)行對比，分析那種方式更適合餐館的有利運(yùn)營和更好地服務(wù)顧客。 實(shí)現(xiàn)對餐館內(nèi)部各種管理的電子化、自動化，提高各個(gè)模塊之間的辦公效率，為高質(zhì)量 餐館服務(wù)提供保證。任務(wù)：1. 能夠?qū)崿F(xiàn)對該系統(tǒng)進(jìn)行管理的人員的權(quán)限限制；2. 使餐館能夠及時(shí)并靈活的對菜品品種其價(jià)位等進(jìn)行管理；3. 為餐館提供從客戶點(diǎn)餐到結(jié)算等一系列操作的服務(wù)，使之能簡單易行、方便、清楚地進(jìn)行管理第二章 系統(tǒng)功能分析一功能需求： 餐

2、飲管理系統(tǒng)中主要包括對以下幾種管理：賬單管理，財(cái)務(wù)管理， 訂餐管理，菜品管理，系統(tǒng)管理。（1）系統(tǒng)管理：系統(tǒng)管理包括用戶名和密碼，主要用于用戶登陸界面登陸和查詢。（2）賬單管理：賬單管理包括賬單號和餐臺，每一個(gè)餐臺對應(yīng)一個(gè)一個(gè)賬單號，通 過餐臺號的記錄來對對應(yīng)的餐臺進(jìn)行記賬管理，即就是記錄每一個(gè)餐臺的消費(fèi)金額。賬 單管理是財(cái)務(wù)管理的一個(gè)小分支，是服務(wù)于財(cái)務(wù)管理的。（3）財(cái)務(wù)管理：包括賬單號， 時(shí)間和賬目。 賬目用于記錄賬單號的消費(fèi)金額及時(shí)間， 以便用于結(jié)算和匯總。每日的結(jié)算要通過對每個(gè)餐臺號的消費(fèi)金額匯總來記錄，然后由 每日的結(jié)算匯總得出每月的結(jié)算。帳務(wù)系統(tǒng)功能的完整性。一旦該系統(tǒng)正式運(yùn)行，餐

3、廳 每日營業(yè)帳和全部往來客戶帳務(wù)的操作結(jié)算都將依靠計(jì)算機(jī)，該系統(tǒng)面對當(dāng)前餐飲業(yè)各 種復(fù)雜的結(jié)算要求應(yīng)具有很強(qiáng)的應(yīng)變能力。（4）訂餐管理：訂餐管理僅包括單價(jià)。訂餐管理是便于顧客訂餐和賬單管理時(shí)對各 個(gè)菜品消費(fèi)金額的記錄，這樣便于賬單管理和財(cái)務(wù)匯總。（5）菜品管理：菜品管理包括菜名，菜品類別和菜品品種。菜品管理便于顧客點(diǎn)菜 和記錄各個(gè)餐臺的消費(fèi)記賬，菜品品種也便于餐館的食材采購。二. 數(shù)據(jù)需求： 賬單管理中賬單號是主鍵，每一個(gè)餐臺對應(yīng)一個(gè)賬單號。財(cái)務(wù)管理 中賬單號是主鍵，每一個(gè)賬單號都有對應(yīng)的時(shí)間和賬目記錄。訂餐管理中單價(jià)就是主鍵。 菜品管理中菜名是主鍵。系統(tǒng)管理中用戶名是主鍵。三. 性能需求：

4、該餐飲系統(tǒng)操作簡單方便可適應(yīng)各類中小型餐館。第二章系統(tǒng)功能模塊設(shè)計(jì)在該系統(tǒng)功能分析的基礎(chǔ)上，考慮PowerBuilder程序編制的特點(diǎn)，得到如下功能模塊圖小型餐飲業(yè)管理系統(tǒng)訂餐管理財(cái)務(wù)管理用戶管理密碼管理賬單號管理餐臺管理訂單查詢菜名管理菜品管理菜價(jià)管理類 別 管 理餐臺占八、 餐 管 理賬目時(shí)間管理每 日 賬 目 管 理圖1系統(tǒng)功能模塊圖數(shù)據(jù)庫設(shè)計(jì)1. 概念結(jié)構(gòu)設(shè)計(jì)賬單管理賬單財(cái)務(wù)聯(lián)系財(cái)務(wù)管理賬單號 <M> 餐臺賬單訂餐聯(lián)系訂餐管理菜名 <M>單價(jià) <M>時(shí)間賬目用戶名 <M> 密碼 <M>菜品管理菜名<M>單價(jià)<

5、M>菜品類別 菜品品種點(diǎn)菜2. 邏輯結(jié)構(gòu)設(shè)計(jì)FK_CAIWUGL_RELATION_ZHANGDAG3. 數(shù)據(jù)庫實(shí)施1）數(shù)據(jù)庫及表結(jié)構(gòu)的創(chuàng)建設(shè)本系統(tǒng)使用的數(shù)據(jù)庫名為小型餐飲業(yè)管理系統(tǒng)，根據(jù)已設(shè)計(jì)的關(guān)系模式及各模式的完整性要求，現(xiàn)在就可以在SQL Server 6.x數(shù)據(jù)庫系統(tǒng)中實(shí)現(xiàn)這些邏輯結(jié)構(gòu)下面是創(chuàng)建基本表的SQL語句：/* = */* Table: CAIPINGL*/* = */create table CAIPINGL(CPGL_NAMEchar(20)not null,CPGL_DANJIAin tegernot n ull.CPGL_LEIBIEchar(8)n ull ,C

6、PGL_PINGZHONG char(8) null ,CPGL_DIANCAI integer null ,constraint PK_CAIPINGL primary key (CPGL_NAME, CPGL_DANJIA) ) go /* = */* Table: XTGL */* = */ create table XTGL(USERNAMEchar(20)not null,PASSWORDchar(8)not null,constraint PK_XTGL primary key (USERNAME, PASSWORD)go /* = */* Table: ZHANGDAGL*/*

7、= */ create table ZHANGDAGL(ZHANGDAN_NUMBER numericnot null,ZHANGDAN_CANTAI numeric null ,CAI_ZHANGDAN_NUMBER numeric null ,constraint PK_ZHANGDAGL primary key (ZHANGDAN_NUMBER)go*/*/* = /* Index: RELATION_383_FK */* = create index RELATION_383_FK on ZHANGDAGL (CAI_ZHANGDAN_NUMBER) go /* = */* Table

8、: CAIWUGL*/* = */ create table CAIWUGL(ZHANGDAN_NUMBER numericnot null,CAIWU_TIME timestamp null ,CAIWU_AMOUNT char(10) null ,constraint PK_CAIWUGL primary key (ZHANGDAN_NUMBER)go /* = */* Table: DINGCANGL */* = */create table DINGCANGL(ZHANGDAN_NUMBER numeric not null,DCGL_NAME char(20) not null,DC

9、GL_DANJIA int not null,constraint PK_DINGCANGL primary key (ZHANGDAN_NUMBER, DCGL_NAME, DCGL_DANJIA) ) go*/*/* = /* Index: RELATION_451_FK */* = create index RELATION_451_FK on DINGCANGL (ZHANGDAN_NUMBER) go建立相關(guān)觸發(fā)器，執(zhí)行級聯(lián)刪除/* Database name: MODEL_1 */ /* DBMS name: Microsoft SQL Server 6.x*/ /* Create

10、d on: 2010-1-21 18:15 */* = */ /* Insert trigger "ti_caiwugl" for table "CAIWUGL" */ create trigger ti_caiwugl on CAIWUGL for insert as begindeclare numrows int, numnull int, errno int, errmsg varchar(255)select numrows = rowcount if numrows = 0 return/* Parent "ZHANGDAGL&qu

11、ot; must exist when inserting a child in "CAIWUGL" */if update(ZHANGDAN_NUMBER)beginif (select count(*)from ZHANGDAGL t1, inserted t2where t1.ZHANGDAN_NUMBER = t2.ZHANGDAN_NUMBER) != numrows beginselect errno = 30002,errmsg = 'Parent does not exist in "ZHANGDAGL". Cannot crea

12、te child in "CAIWUG L".'goto errorendendreturn /* Errors handling */error:raiserror errno errmsgrollback transactionendgo/* Update trigger "tu_caiwugl" for table "CAIWUGL" */ create trigger tu_caiwugl on CAIWUGL for update as begindeclarenumrows int,numnull int,errn

13、o int,errmsg varchar(255)select numrows = rowcountif numrows = 0return/* Parent "ZHANGDAGL" must exist when updating a child in "CAIWUGL" */if update(ZHANGDAN_NUMBER)beginif (select count(*)from ZHANGDAGL t1, inserted t2where t1.ZHANGDAN_NUMBER = t2.ZHANGDAN_NUMBER) != numrows be

14、ginselect errno = 30003,errmsg = '"ZHANGDAGL" does not exist. Cannot modify child in "CAIWUGL".' goto errorendend/* Modify parent code of "CAIWUGL" for all children in "ZHANGDAGL" */if update(ZHANGDAN_NUMBER)beginupdate ZHANGDAGLset CAI_ZHANGDAN_NUMBER

15、 = i1.ZHANGDAN_NUMBER from ZHANGDAGL t2, inserted i1, deleted d1 where t2.CAI_ZHANGDAN_NUMBER = d1.ZHANGDAN_NUMBER and (i1.ZHANGDAN_NUMBER != d1.ZHANGDAN_NUMBER) endreturn/* Delete trigger "td_caiwugl" for table "CAIWUGL" */ create trigger td_caiwugl on CAIWUGL for delete as begi

16、ndeclare numrows int, errno int,errmsg varchar(255)select numrows = rowcountif numrows = 0return/* Delete all children in "ZHANGDAGL" */delete ZHANGDAGLfrom ZHANGDAGL t2, deleted t1where t2.CAI_ZHANGDAN_NUMBER = t1.ZHANGDAN_NUMBERreturn/* Errors handling */error:raiserror errno errmsgrollb

17、ack transactionendgo/* Insert trigger "ti_dingcangl" for table "DINGCANGL" */ create trigger ti_dingcangl on DINGCANGL for insert as begindeclarenumrows int, numnull int,errno int,errmsg varchar(255)select numrows = rowcountif numrows = 0return/* Parent "ZHANGDAGL" must

18、 exist when inserting a child in "DINGCANGL" */ if update(ZHANGDAN_NUMBER)beginif (select count(*)from ZHANGDAGL t1, inserted t2where t1.ZHANGDAN_NUMBER = t2.ZHANGDAN_NUMBER) != numrows beginselect errno = 30002,errmsg = 'Parent does not exist in "ZHANGDAGL". Cannot create ch

19、ild in "DINGCA NGL".'goto error end endreturn/* Errors handling */error:raiserror errno errmsgrollback transactionendgo/* Update trigger "tu_dingcangl" for table "DINGCANGL" */ create trigger tu_dingcangl on DINGCANGL for update as begindeclarenumrows int,numnull in

20、t,errno int,errmsg varchar(255)select numrows = rowcountif numrows = 0return/* Parent "ZHANGDAGL" must exist when updating a child in "DINGCANGL" */if update(ZHANGDAN_NUMBER)beginif (select count(*)from ZHANGDAGL t1, inserted t2where t1.ZHANGDAN_NUMBER = t2.ZHANGDAN_NUMBER) != nu

21、mrows beginselect errno = 30003,errmsg = '"ZHANGDAGL" does not exist. Cannot modify child in "DINGCANGL".' goto errorendendreturn/* Insert trigger "ti_zhangdagl" for table "ZHANGDAGL" */ create trigger ti_zhangdagl on ZHANGDAGL for insert as begindecla

22、renumrows int,numnull int,errno int,errmsg varchar(255)select numrows = rowcountif numrows = 0return/* Parent "CAIWUGL" must exist when inserting a child in "ZHANGDAGL" */if update(CAI_ZHANGDAN_NUMBER)beginselect numnull = (select count(*)from insertedwhere CAI_ZHANGDAN_NUMBER is

23、 null)if numnull != numrowsif (select count(*)from CAIWUGL t1, inserted t2where t1.ZHANGDAN_NUMBER = t2.CAI_ZHANGDAN_NUMBER) != numrows - numnull beginselect errno = 30002,errmsg = 'Parent does not exist in "CAIWUGL". Cannot create child in "ZHANGDAGL".'goto errorendendre

24、turn/* Errors handling */error:raiserror errno errmsgrollback transactionendgo/* Update trigger "tu_zhangdagl" for table "ZHANGDAGL" */ create trigger tu_zhangdagl on ZHANGDAGL for update as begindeclarenumrows int,numnull int,errno int,errmsg varchar(255)select numrows = rowcoun

25、tif numrows = 0return/* Parent "CAIWUGL" must exist when updating a child in "ZHANGDAGL" */if update(CAI_ZHANGDAN_NUMBER)beginselect numnull = (select count(*)from insertedwhere CAI_ZHANGDAN_NUMBER is null)if numnull != numrowsif (select count(*)from CAIWUGL t1, inserted t2where

26、t1.ZHANGDAN_NUMBER = t2.CAI_ZHANGDAN_NUMBER) != numrows - numnull beginselect errno = 30003,errmsg = '"CAIWUGL" does not exist. Cannot modify child in "ZHANGDAGL".' goto errorendend/* Modify parent code of "ZHANGDAGL" for all children in "CAIWUGL" */if

27、 update(ZHANGDAN_NUMBER)beginupdate CAIWUGLset ZHANGDAN_NUMBER = i1.ZHANGDAN_NUMBERfrom CAIWUGL t2, inserted i1, deleted d1where t2.ZHANGDAN_NUMBER = d1.ZHANGDAN_NUMBERand (i1.ZHANGDAN_NUMBER != d1.ZHANGDAN_NUMBER)end/* Modify parent code of "ZHANGDAGL" for all children in "DINGCANGL&

28、quot; */if update(ZHANGDAN_NUMBER)beginupdate DINGCANGLset ZHANGDAN_NUMBER = i1.ZHANGDAN_NUMBERfrom DINGCANGL t2, inserted i1, deleted d1where t2.ZHANGDAN_NUMBER = d1.ZHANGDAN_NUMBERand (i1.ZHANGDAN_NUMBER != d1.ZHANGDAN_NUMBER)endreturn /* Errors handling */error:/* Delete trigger "td_zhangdag

29、l" for table "ZHANGDAGL" */create trigger td_zhangdagl on ZHANGDAGL for delete asbegindeclarenumrows int,errno int,errmsg varchar(255)select numrows = rowcountif numrows = 0return/* Delete all children in "CAIWUGL" */delete CAIWUGLfrom CAIWUGL t2, deleted t1where t2.ZHANGDAN_NUMBER = t1.ZHANGDAN_NUMBER/* Delete all children in "DINGCANG