酒店管理系統(tǒng)實(shí)訓(xùn)指導(dǎo)書(shū)

項(xiàng)目實(shí)訓(xùn)指導(dǎo)書(shū)

版本歷史版本/狀態(tài)修訂人修改日期備注1.0.0鄧?yán)^林2014-07-20創(chuàng)建文檔

開(kāi)發(fā)背景某酒店為提高管理效率，采用全新的計(jì)算機(jī)網(wǎng)絡(luò)和信息管理系統(tǒng)，對(duì)基礎(chǔ)設(shè)施和業(yè)務(wù)流程進(jìn)行智能化控制。項(xiàng)目目的掌握.NET平臺(tái)B/S結(jié)構(gòu)項(xiàng)目的開(kāi)發(fā)掌握ASP.NET項(xiàng)目的基本原理掌握三層架構(gòu)的項(xiàng)目框架思想在項(xiàng)目中的運(yùn)用通用數(shù)據(jù)訪問(wèn)類(lèi)的使用知識(shí)點(diǎn)準(zhǔn)備三層架構(gòu)：三層結(jié)構(gòu)中每一層的主要作用，以及各層之間的關(guān)系實(shí)體類(lèi)在三層結(jié)構(gòu)中主要作用C#語(yǔ)法：C#中using關(guān)鍵作的用泛型集合List<T>的使用ASP.NET：內(nèi)置對(duì)象的使用GridView、DataList、SiteMapPath、Menu等控件的使用驗(yàn)證控件的使用母板頁(yè)（MasterPage）的使用鞏固的知識(shí)點(diǎn)ASP.NET三層架構(gòu)JQuery框架的綜合運(yùn)用ASP.NET中AJAX的靈活運(yùn)用

需求分析系統(tǒng)架構(gòu)功能結(jié)構(gòu)功能清單功能編號(hào)功能名稱(chēng)備注01基礎(chǔ)設(shè)置0101客房管理0102客房類(lèi)型管理02系統(tǒng)功能0201系統(tǒng)登錄0202系統(tǒng)注銷(xiāo)系統(tǒng)用例用例01：基礎(chǔ)設(shè)置用例圖描述： 可以維護(hù)以下的基本信息（增刪改查）：客戶(hù)信息客房類(lèi)型信息用例02：系統(tǒng)功能用例圖：描述：實(shí)現(xiàn)系統(tǒng)登錄系統(tǒng)注銷(xiāo)

數(shù)據(jù)庫(kù)設(shè)計(jì)邏輯設(shè)計(jì)系統(tǒng)的E-R圖如下：數(shù)據(jù)表設(shè)計(jì)表設(shè)計(jì)：表名功能說(shuō)明1、HotelUser系統(tǒng)用戶(hù)2、Floor樓層3、Room房間4、RoomType房間類(lèi)型5、Guest客戶(hù)6、GuestCategory客戶(hù)類(lèi)型表詳細(xì)設(shè)計(jì)：表名：HotelUser序號(hào)列名數(shù)據(jù)類(lèi)型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1UserIDint40是是否2UserNamenvarchar500否3Passwordnvarchar500否表名：Floor序號(hào)列名數(shù)據(jù)類(lèi)型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1FloorIDint40是是否2FloorNamenvarchar500否表名：Room序號(hào)列名數(shù)據(jù)類(lèi)型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1RoomIDint40是是否2Numbernvarchar500否3TypeIDint40是否5BedNumberint40否6Descriptionnvarchar2550否7Statenvarchar500否8GuestNumberint40否表名：RoomType序號(hào)列名數(shù)據(jù)類(lèi)型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1TypeIDint40是是否2TypeNamenvarchar500否3TypePricemoney84否4AddBedPricemoney84否5IsAddBednchar100否6Remarknvarchar2550是表名：Guest序號(hào)列名數(shù)據(jù)類(lèi)型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1GuestIDint40是是否2Namenvarchar500否3CategoryIDint40是否4Sexnvarchar500否5Mobilenvarchar500否6RoomIDint40否7ArriveTimedatetime83否8LeaveTimedatetime83否表名：GuestCategory序號(hào)列名數(shù)據(jù)類(lèi)型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵外鍵允許空默認(rèn)值說(shuō)明1CategoryIDint40是是否2CategoryNamenvarchar500否

系統(tǒng)設(shè)計(jì)類(lèi)圖實(shí)體層類(lèi)圖數(shù)據(jù)訪問(wèn)層類(lèi)圖業(yè)務(wù)邏輯層類(lèi)圖

系統(tǒng)功能設(shè)計(jì)系統(tǒng)登錄主要界面設(shè)計(jì)：核心代碼：登錄按鈕事件///<summary>///執(zhí)行登錄事件///</summary>protectedvoidbtnLogin_Click(objectsender,EventArgse){//根據(jù)用戶(hù)名得到用戶(hù)密碼stringvalidatePwd=UserManager.GetUserPasswordByUserName(this.txtPassword.Text.Trim());//加密密碼stringinputPwd=CryptogramManager.EncryptPassword(this.txtPassword.Text.Trim());//通過(guò)對(duì)比密碼,驗(yàn)證登錄信息是否正確if(inputPwd.Trim()==validatePwd.Trim()){//保存用戶(hù)身份userLigon.AuthenticationUsers(this.txtUserName.Text.Trim());if(!string.IsNullOrEmpty(ReturnUrl))Response.Redirect(ReturnUrl);elseResponse.Redirect("Default.aspx");}elsethis.lblResult.Text="您輸入的用戶(hù)名或密碼不正確！";}系統(tǒng)主窗口主要界面設(shè)計(jì)：核心代碼：窗體主要代碼#region"EventHandler"http:///<summary>///在頁(yè)面載入時(shí),首先判斷用戶(hù)是否通過(guò)身份驗(yàn)證;///如果用戶(hù)通過(guò)身份綁定房間狀態(tài),客房類(lèi)型信息;///如果沒(méi)有通過(guò)身份驗(yàn)證轉(zhuǎn)向登錄頁(yè)///</summary>protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){if(string.IsNullOrEmpty(User.Identity.Name))Response.Redirect("Login.aspx");else{BindRoomState();BindRoomType();}}}///<summary>///將選中的房間狀態(tài)回綁到房間狀態(tài)編輯區(qū)///</summary>protectedvoiddlRoomState_SelectedIndexChanged(objectsender,DataListCommandEventArgse){intn=e.Item.ItemIndex;dlRoomState.Items[n].BackColor=System.Drawing.Color.Red;intkey=Convert.ToInt32(this.dlRoomState.DataKeys[n]);Session["key"]=key;Roomroom=newRoom();room=RoomManager.GetRoomByRoomId(key);if(room.State=="housing")this.rblRoomState.SelectedValue="housing";elseif(room.State=="modify")this.rblRoomState.SelectedValue="modify";elseif(room.State=="arrive")this.rblRoomState.SelectedValue="arrive";elseif(room.State=="leave")this.rblRoomState.SelectedValue="leave";elseif(room.State=="empty")this.rblRoomState.SelectedValue="empty";elsethis.rblRoomState.SelectedValue="helpOneself";}///<summary>///修改房間狀態(tài)///</summary>protectedvoidbtnModifyRoomState_Click(objectsender,EventArgse){stringstate=string.Empty;state=this.rblRoomState.SelectedValue;RoomManager.ModifyRoomState(Convert.ToInt32(Session["key"]),state);//回綁房間狀態(tài)BindRoomState();}///<summary>///在選擇客房類(lèi)型時(shí),根據(jù)客房類(lèi)型檢索該類(lèi)型對(duì)應(yīng)的房間,并展示該房間的狀態(tài)///</summary>protectedvoidddlType_SelectedIndexChanged(objectsender,EventArgse){inttypeid=Convert.ToInt32(this.ddlType.SelectedValue);if(typeid==-1)typeid=0;this.dlRoomState.DataSource=RoomManager.GetAllRoomsByTypeId(typeid);this.dlRoomState.DataBind();}#endregion#region"PublicMethods"http:///<summary>///根據(jù)房間狀態(tài)得到狀態(tài)對(duì)應(yīng)的表示圖///</summary>///<paramname="state">狀態(tài)</param>///<returns></returns>publicstringGetRoomStateImageUrlByState(stringstate){stringimageUrl=string.Empty;if(state=="housing")imageUrl="images/RoomState/housing.jpg";elseif(state=="modify")imageUrl="images/RoomState/modify.jpg";elseif(state=="arrive")imageUrl="images/RoomState/arrive.jpg";elseif(state=="leave")imageUrl="images/RoomState/leave.jpg";elseif(state=="empty")imageUrl="images/RoomState/empty.jpg";elseimageUrl="images/RoomState/helpOneself.jpg";returnimageUrl;}///<summary>///綁定房間狀態(tài)///</summary>publicvoidBindRoomState(){this.dlRoomState.DataSource=RoomManager.GetAllRoomsByTypeId(0);this.dlRoomState.DataBind();}///<summary>///綁定客房類(lèi)型///</summary>publicvoidBindRoomType(){ddlType.DataSource=RoomTypeManager.GetAllRoomTypes();ddlType.DataTextField="TypeName";ddlType.DataValueField="TypeId";ddlType.DataBind();ListItemitem=newListItem();item.Text="--選擇--";item.Value="-1";ddlType.Items.Insert(0,item);}查看客房信息主要界面設(shè)計(jì)：核心代碼：頁(yè)面主要代碼#region"EventHandlers"http:///<summary>///在頁(yè)面加載時(shí),綁定客房信息///</summary>protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){BindRoom();}}///<summary>///執(zhí)行GridView數(shù)據(jù)行綁定事件///</summary>protectedvoidgvRoom_RowDataBound(objectsender,GridViewRowEventArgse){if(e.Row.RowType==DataControlRowType.DataRow){//設(shè)置行顏色e.Row.Attributes.Add("onmouseover","currentcolor=this.style.backgroundColor;this.style.backgroundColor='#ff9900'");//添加自定義屬性，當(dāng)鼠標(biāo)移走時(shí)還原該行的背景色e.Row.Attributes.Add("onmouseout","this.style.backgroundColor=currentcolor");//添加刪除確認(rèn)ImageButtonimgbtn=(ImageButton)e.Row.FindControl("imgbtnDelete");imgbtn.Attributes.Add("onclick","returnconfirm('您確認(rèn)要?jiǎng)h除嗎?');");}}///<summary>///執(zhí)行GridView數(shù)據(jù)行按鈕事件///</summary>protectedvoidgvRoom_RowCommand(objectsender,GridViewCommandEventArgse){//獲取命令名稱(chēng)stringcmd=e.CommandName;introomId=Convert.ToInt32(e.CommandArgument);//獲取命令參數(shù)if(cmd=="De"){//根據(jù)客房ID刪除客房信息RoomManager.DeleteRoomByRoomId(roomId);}elseif(cmd=="Ed"){//跳轉(zhuǎn)到客房信息編輯頁(yè)P(yáng)age.Server.Transfer("EditRoom.aspx?roomid="+roomId.ToString());}BindRoom();}///<summary>///執(zhí)行分頁(yè)事件///</summary>protectedvoidgvRoom_PageIndexChanging(objectsender,GridViewPageEventArgse){gvRoom.PageIndex=e.NewPageIndex;BindRoom();}#endregion#region"PublicMethods"http:///<summary>///綁定客房信息///</summary>protectedvoidBindRoom(){this.gvRoom.DataSource=RoomManager.GetAllRooms();this.gvRoom.DataBind();}///<summary>///綁定客房狀態(tài)///</summary>///<paramname="state">狀態(tài)</param>///<returns></returns>publicstringGetRoomState(stringstate){stringViewState=string.Empty;if(state=="housing")ViewState="入住";elseif(state=="modify")ViewState="維修";elseif(state=="arrive")ViewState="將到";elseif(state=="leave")ViewState="將離";elseif(state=="empty")ViewState="空閑";elseViewState="自用";returnViewState;}///<summary>///根據(jù)類(lèi)型ID得到類(lèi)型名稱(chēng)///</summary>publicstringGetRoomType(stringtypeID){returnRoomTypeManager.GetTypeNameByTypeID(Convert.ToInt32(typeID));}///<summary>///確保客房描述信息最大長(zhǎng)度不能超過(guò)20個(gè)字符///</summary>publicstringSubStringDescription(stringdescription){if(description.Length>20)description=description.Substring(0,20)+"";returndescription;}#endregion新增客房信息主要界面設(shè)計(jì)：核心代碼：“確定”按鈕事件///<summary>///提交客房信息///</summary>protectedvoidtbnSave_Click(objectsender,EventArgse){//根據(jù)房間號(hào)得到客房IDintroomId=RoomManager.GetRoomIdByRoomNo(this.txtRoomNO.Text.Trim());if(roomId>0)this.lblResult.Text="此房間已存在！";else{room.Number=this.txtRoomNO.Text.Trim();room.TypeID=Convert.ToInt32(this.ddlRoomType.SelectedValue);room.State=this.ddlRoomState.SelectedValue;room.BedNumber=Convert.ToInt32(this.txtBedNumber.Text.Trim());room.GuestNumber=Convert.ToInt32(this.txtGuestNumber.Text.Trim());room.Description=this.txtDescription.Text.Trim();roomId=RoomManager.AddRoom(room);if(roomId>0)Page.Server.Transfer("ViewRoom.aspx");elsethis.lblResult.Text="房間創(chuàng)建失??！";}}查看客房類(lèi)型信息主要界面設(shè)計(jì)：核心代碼：頁(yè)面主要代碼#region"EventHandlers"http:///<summary>///在頁(yè)面加載時(shí),綁定類(lèi)型信息///</summary>protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){BindRoomType();}}///<summary>///執(zhí)行GridView數(shù)據(jù)行綁定事件///</summary>protectedvoidgvRoomType_RowDataBound(objectsender,GridViewRowEventArgse){if(e.Row.RowType==DataControlRowType.DataRow){//設(shè)置行顏色e.Row.Attributes.Add("onmouseover","currentcolor=this.style.backgroundColor;this.style.backgroundColor='#ff9900'");//添加自定義屬性，當(dāng)鼠標(biāo)移走時(shí)還原該行的背景色e.Row.Attributes.Add("onmouseout","this.style.backgroundColor=currentcolor");//添加刪除確認(rèn)ImageButtonimgbtn=(ImageButton)e.Row.FindControl("imgbtnDelete");imgbtn.Attributes.Add("onclick","returnconfirm('您確認(rèn)要?jiǎng)h除嗎?');");}}///<summary>///執(zhí)行GridView數(shù)據(jù)行按鈕事件///</summary>protectedvoidgvRoomType_RowCommand(objectsender,GridViewCommandEventArgse){//獲取按鈕命令名稱(chēng)stringcmd=e.CommandName;inttypeId=Convert.ToInt32(e.CommandArgument);//獲取命令參數(shù)if(cmd=="De"){//根據(jù)類(lèi)型ID刪除類(lèi)型信息RoomTypeManager.DeleteRoomTypeByTypeId(typeId);}elseif(cmd=="Ed"){//轉(zhuǎn)向類(lèi)型信息編輯頁(yè)P(yáng)age.Server.Transfer("EditRoomType.aspx?typeId="+Convert.ToString(typeId));}BindRoomType();}///<summary>///執(zhí)行分頁(yè)事件///</summary>protectedvoidgvRoomType_PageIndexChanging(objectsender,GridViewPageEventArgse){gvRoomType.PageIndex=e.NewPageIndex;BindRoomType();}#endregion#region"PublicMethods"http:///<summary>///綁定客房類(lèi)型信息///</summary>publicvoidBindRoomType(){this.gvRoomType.DataSource=RoomTypeManager.GetAllRoomTypes();this.gvRoomType.DataBind();}

新增客房類(lèi)型信息主要界面設(shè)計(jì)：核心代碼：“確定”按鈕事件///<summary>///提交客房類(lèi)型信息///</summary>protectedvoidtbnSave_Click(objectsender,EventArgse){//根據(jù)類(lèi)型名稱(chēng)得到類(lèi)型IDinttypeId=RoomTy