基于BS的新華書(shū)店（北京學(xué)院路店）售書(shū)管理信息系統(tǒng)設(shè)計(jì)與開(kāi)發(fā)

1、基于B/S的新華書(shū)店（北京學(xué)院路店）售書(shū)管理信息系統(tǒng)設(shè)計(jì)與開(kāi)發(fā)Based on B/S of the xinhua bookstore (Beijing xueyuan road shop) books management information system design and development學(xué)部： 信息學(xué)部 專(zhuān)業(yè)： 計(jì)算機(jī)科學(xué)與技術(shù) 畢業(yè)設(shè)計(jì)（論文）完成時(shí)間： 自 2012 年 10 月 至 2013 年 4 月摘 要新華書(shū)店（北京學(xué)院路店）售書(shū)管理信息系統(tǒng)是一個(gè)基于Internet,采用B/S模式，并根據(jù)現(xiàn)有的網(wǎng)上書(shū)店系統(tǒng)的現(xiàn)狀而設(shè)計(jì)開(kāi)發(fā)的電子商務(wù)平臺(tái)。首先介紹了新華書(shū)店售書(shū)

2、管理信息系統(tǒng)的開(kāi)發(fā)背景，然后論述了系統(tǒng)的設(shè)計(jì)目標(biāo)，系統(tǒng)需求和總體設(shè)計(jì)方案，較詳細(xì)的論述了系統(tǒng)的詳細(xì)設(shè)計(jì)和實(shí)現(xiàn)，最后對(duì)新華書(shū)店售書(shū)管理信息系統(tǒng)簡(jiǎn)單介紹。 新華書(shū)店售書(shū)管理信息系統(tǒng)是以VS2010和SQL 2008數(shù)據(jù)庫(kù)作為開(kāi)發(fā)平臺(tái)。使用ASP.NET 設(shè)計(jì)操作控件和編寫(xiě)操作程序，完成數(shù)據(jù)輸入、修改、存儲(chǔ)、調(diào)用查詢(xún)等作用；并使用SQL 2008數(shù)據(jù)庫(kù)形成數(shù)據(jù)表，進(jìn)行數(shù)據(jù)的管理。新華書(shū)店售書(shū)系統(tǒng)主要由用戶(hù)模塊和管理員模塊兩部分組成。用戶(hù)模塊主要包括：用戶(hù)注冊(cè)，登陸/驗(yàn)證，書(shū)籍瀏覽，購(gòu)書(shū)單。管理員模塊主要包括：管理員登陸，庫(kù)存管理，管理員管理，訂單管理，用戶(hù)管理。通過(guò)這些前臺(tái)、后臺(tái)功能模塊的設(shè)計(jì)，基本

3、上實(shí)現(xiàn)了整個(gè)網(wǎng)上售書(shū)交易過(guò)程。關(guān)鍵詞：B/S、數(shù)據(jù)庫(kù)、售書(shū)管理信息系統(tǒng)AbstractXinhua bookstore (Beijing xueyuan road shop) is an internet-based books management information system, using B/S mode, and according to the existing and the present situation of the online bookstore system design and development of e-commerce platform.First

4、ly introduces xinhua bookstore books management information system development background, and then discusses the system design objectives, system requirements and overall design, in detail elaborated the system detailed design and implementation of the simple introduction of xinhua bookstore books

5、management information system.Xinhua bookstore books management information system based on VS2010 and SQL 2008 database as a development platform. Use ASP.NET design operating controls and written operating procedures, complete the data entry, modification, storage, call query etc; And form data ta

6、bles using SQL 2008 database, for data management. Xinhua bookstore books system mainly consists of two parts, the user module and administrator module. User module mainly includes: user registration, login/authentication, browsing books, book list. The administrator module includes: the administrat

7、or login, inventory management, administrator management, order management, user management. Through these at the front desk and backstage function module design, basically realize the online book trading process.Keywords：B/S、database、books management information system目 錄緒論11系統(tǒng)需求分析11.1系統(tǒng)可行性分析11.2系統(tǒng)

8、功能簡(jiǎn)介12 系統(tǒng)總體設(shè)計(jì)12.1開(kāi)發(fā)系統(tǒng)簡(jiǎn)介22.2系統(tǒng)需求概況22.3系統(tǒng)功能結(jié)構(gòu)圖22.4系統(tǒng)E-R圖33 數(shù)據(jù)庫(kù)設(shè)計(jì)33.1邏輯設(shè)計(jì)33.2物理設(shè)計(jì)44 詳細(xì)設(shè)計(jì)54.1用戶(hù)模塊54.1.1用戶(hù)登錄54.1.2用戶(hù)注冊(cè)84.1.3用戶(hù)修改信息104.1.4用戶(hù)購(gòu)物124.2管理員模塊154.2.1管理員登錄154.2.2管理員書(shū)籍管理174.2.3會(huì)員管理19結(jié)論21參考文獻(xiàn)22致謝23緒論隨著Internet技術(shù)的發(fā)展，人們的日常生活已經(jīng)離不開(kāi)網(wǎng)絡(luò)。未來(lái)社會(huì)人們的生活和工作將越來(lái)越依賴(lài)于數(shù)字技術(shù)的發(fā)展，越來(lái)越數(shù)字化、網(wǎng)絡(luò)化、電子化、虛擬化。電子商務(wù)也隨著網(wǎng)絡(luò)的發(fā)展日益和人們的生活貼近

9、。新華書(shū)店售書(shū)系統(tǒng)也成為了電子商務(wù)的一個(gè)時(shí)尚，也是最流行的一個(gè)動(dòng)態(tài)的電子商務(wù)網(wǎng)站，它使每一位顧客不用出門(mén)在家里就能夠通過(guò)上網(wǎng)來(lái)輕松購(gòu)買(mǎi)自己喜愛(ài)的書(shū)籍。1 系統(tǒng)需求分析隨著Internet技術(shù)的發(fā)展，人們的日常生活已經(jīng)離不開(kāi)網(wǎng)絡(luò)。未來(lái)社會(huì)人們的生活和工作將越來(lái)越依賴(lài)于數(shù)字技術(shù)的發(fā)展，越來(lái)越數(shù)字化、網(wǎng)絡(luò)化、電子化、虛擬化。電子商務(wù)也隨著網(wǎng)絡(luò)的發(fā)展日益和人們的生活貼近。新華書(shū)店售書(shū)系統(tǒng)也成為了電子商務(wù)的一個(gè)時(shí)尚，也是最流行的一個(gè)動(dòng)態(tài)的電子商務(wù)網(wǎng)站，它使每一位顧客不用出門(mén)在家里就能夠通過(guò)上網(wǎng)來(lái)輕松購(gòu)買(mǎi)自己喜愛(ài)的書(shū)籍。新華書(shū)店售書(shū)系統(tǒng)為人們提供了更廣闊的環(huán)境：人們不受時(shí)間的限制，不受空間的限制，不受傳統(tǒng)

10、購(gòu)物的諸多限制，可以隨時(shí)隨地在網(wǎng)上交易。更廣闊的市場(chǎng)：在網(wǎng)上這個(gè)世界將會(huì)變得很小，一個(gè)商家可以面對(duì)全球的消費(fèi)者，而一個(gè)消費(fèi)者可以在全球的任何一家商家購(gòu)物。更快速的流通和低廉的價(jià)格：電子商務(wù)減少了商品流通的中間環(huán)節(jié)，節(jié)省了大量的開(kāi)支，從而也大大降低了商品流通和交易的成本。更符合時(shí)代的要求：如今人們?cè)絹?lái)越追求時(shí)尚、講究個(gè)性，注重購(gòu)物的環(huán)境，網(wǎng)上購(gòu)物，更能體現(xiàn)個(gè)性化的購(gòu)物過(guò)程?；竟δ埽海?）游客可以瀏覽網(wǎng)站（2）用戶(hù)注冊(cè)（3）用戶(hù)登陸（4）用戶(hù)能夠?yàn)g覽網(wǎng)站（5）用戶(hù)能夠?qū)ψ约旱淖?cè)資料進(jìn)行修改（6）用戶(hù)下定單購(gòu)買(mǎi)商品（7）用戶(hù)處理定單高級(jí)功能：（1）管理員登錄（2）管理員權(quán)限：商品管理（添加/刪除

11、商品、商品類(lèi)別管理、商品信息處理）、管理用戶(hù)資料、管理定單、處理定單。（3）用戶(hù)可隨時(shí)修改自己的密碼和其他個(gè)人信息 （4）管理員在線(xiàn)編輯2 系統(tǒng)總體設(shè)計(jì)平臺(tái)：Visual Studio 2010 SQL Server 2008系統(tǒng)面向的對(duì)象有兩個(gè)：客戶(hù)和系統(tǒng)管理員 客戶(hù)需求如下：(1)客戶(hù)可以通過(guò)該系統(tǒng)實(shí)現(xiàn)訂購(gòu)圖書(shū)、購(gòu)買(mǎi)圖書(shū)、查詢(xún)書(shū)籍詳細(xì)信息。(2)客戶(hù)修改自己的密碼和其他個(gè)人信息 系統(tǒng)管理員需求如下：（1）系統(tǒng)管理員可以對(duì)圖書(shū)信息進(jìn)行添加、刪除、修改，查詢(xún)。（2）系統(tǒng)管理員可以對(duì)客戶(hù)信息進(jìn)行管理。（3）系統(tǒng)管理員可以根據(jù)網(wǎng)上訂單進(jìn)行售出。圖1 系統(tǒng)結(jié)構(gòu)圖圖2 E-R圖3 數(shù)據(jù)庫(kù)設(shè)計(jì)（1）Me

12、mber表（MemberID、Name、Sex、Password、TrueName、Questions、Answers、Phonecode、Emails、City、Address、PostCode、AdvancePayment、LoadDate）（2）Admin表（AdminID、Admin、Password）（3）BuyInfo表（BuyID、BookID、Num、OrderID、SumPrice、MemberID）（4）BookInfo表（BookID、ClassID、BookName、BookIntroduce、ISBN、PageNum、Publisher、PublishDate、Aut

13、hor、BookUrl、MarketPrice、MemberPrice、Isrefinement、IsHot、AddDate、IsDiscount）（5）ShopCart表（CartID、BookID、Num、SumPrice、MemberID）（1）Member表表1 Member表（2）Admin表表2 Admin表（3）BuyInfo表表3 BuyInfo表（4）BookInfo表表4 BookInfo表（5）ShopCart表表5 ShopCart表4 詳細(xì)設(shè)計(jì)圖3用戶(hù)登錄 public partial class LoadingControl : System.Web.UI.User

14、Control DBClass dbObj = new DBClass(); UserInfoClass uiObj = new UserInfoClass(); protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) lbValid.Text = new randomCode().RandomNum(4); if (SessionUID != null) tabLoad.Visible = true; tabLoading.Visible = false; protected void btnLoad_Cli

15、ck(object sender, EventArgs e) SessionUID = null; SessionUsername = null; if (txtName.Text.Trim() = | txtPassword.Text.Trim() = ) Response.Write(alert(登錄名和密碼不能為空！);location=javascript:history.go(-1);); else if (txtValid.Text.Trim() = lbValid.Text.Trim() int P_Int_IsExists = uiObj.UserExists(txtName.

16、Text.Trim(), txtPassword.Text.Trim(); if (P_Int_IsExists = 100) DataSet ds = uiObj.ReturnUIDs(txtName.Text.Trim(), txtPassword.Text.Trim(), UserInfo); SessionUID = Convert.ToInt32(ds.TablesUserInfo.Rows00.ToString(); SessionUsername = ds.TablesUserInfo.Rows01.ToString(); Response.Redirect(index.aspx

17、); else Response.Write(alert(您的登錄有誤，請(qǐng)核對(duì)后再重新登錄！);location=javascript:history.go(-1);); else Response.Write(alert(請(qǐng)正確輸入驗(yàn)證碼！);location=javascript:history.go(-1);); protected void btnRegister_Click(object sender, EventArgs e) Response.Redirect(Register.aspx); protected void lnkbtnResetInfo_Click(object

18、sender, EventArgs e) Response.Write(window.open(ResetMemberInfo.aspx,width=655,height=655); protected void btnLogout_Click(object sender, EventArgs e) SessionUID = null; SessionUsername = null; tabLoad.Visible = false; tabLoading.Visible = true; 圖4用戶(hù)注冊(cè)public partial class Register : System.Web.UI.Pa

19、ge MangerClass mc = new MangerClass(); UserInfoClass uiObj = new UserInfoClass(); public static int G_Int_MemberID; protected void Page_Load(object sender, EventArgs e) protected void btnSave_Click(object sender, EventArgs e) if (txtPostCode.Text.Trim() = & txtPassword.Text.Trim()=) Response.Write(a

20、lert(請(qǐng)輸入完整信息！);location=javascript:history.go(-1);); else bool P_Bl_Sex; if(Convert.ToInt32(ddlSex.SelectedItem.Value.Trim()=1) P_Bl_Sex =true ; else P_Bl_Sex =false ; G_Int_MemberID = uiObj.AddUInfo(txtName.Text.Trim(), P_Bl_Sex, txtPassword.Text.Trim(), txtTrueName.Text.Trim(), , , txtPhone.Text.T

21、rim(), txtEmail.Text.Trim(), ddlCity.SelectedItem.Text.Trim(), txtAddress.Text.Trim(), txtPostCode.Text.Trim(); SessionUsername = ; SessionUsername =txtName.Text.Trim(); Response.Write(alert(恭喜您，注冊(cè)成功！);location=index.aspx); protected void btnCheck_Click(object sender, EventArgs e) bool result = mc.C

22、heckU(txtName.Text); if (result) lblResult.Text = 該用戶(hù)已存在; else lblResult.Text = 不存在該用戶(hù); 圖5用戶(hù)修改信息 protected void btnUpdate_Click(object sender, EventArgs e) if (Convert.ToString(SessionUID) = | Convert.ToString(SessionUserName) = ) Response.Redirect(index.aspx); if (txtName.Text.Trim() = & txtPasswor

23、d.Text.Trim() = & txtAddress.Text.Trim() = & txtPostCode.Text.Trim() = & txtPassword.Text.Trim() = ) Response.Write(alert(請(qǐng)輸入完整信息！);location=javascript:history.go(-1);); else if (IsValidPostCode(txtPostCode.Text.Trim() = false) Response.Write(alert(您的 輸入有誤！); return; else if (IsValidPhone(txtPhone.T

24、ext.Trim() = false) Response.Write(alert(您輸入的 號(hào)碼有誤，請(qǐng)重新輸入); return; else if (IsValidEmail(txtEmail.Text.Trim() = false) Response.Write(alert(您輸入的E-mail地址格式不正確，請(qǐng)重新輸入); return; else bool P_Bl_Sex; if (Convert.ToInt32(ddlSex.SelectedItem.Value.Trim() = 1) P_Bl_Sex = true; else P_Bl_Sex = false; uiObj.Up

25、dateUInfo(txtName.Text.Trim(), P_Bl_Sex, txtPassword.Text.Trim(), txtTrueName.Text.Trim(), , , txtPhone.Text.Trim(), txtEmail.Text.Trim(), ddlCity.SelectedItem.Text.Trim(), txtAddress.Text.Trim(), txtPostCode.Text.Trim(), Convert.ToInt32(SessionUID.ToString(); SessionUsername = ; SessionUsername = t

26、xtName.Text.Trim(); Response.Write(alert(恭喜您，修改成功！);location=index.aspx;); 圖6用戶(hù)購(gòu)物 protected void Page_Load(object sender, EventArgs e) if (SessionUID = null) Response.Redirect(index.aspx); if (!IsPostBack) ShopCartBind(); TotalDs(); / / 獲取購(gòu)物車(chē)中的圖書(shū)信息 / public void ShopCartBind() ucObj.SCIBind(ShopCart

27、,gvShopCart, Convert.ToInt32(SessionUID.ToString(); / / 顯示購(gòu)物車(chē)中的圖書(shū)合計(jì)金額和圖書(shū)數(shù)量 / public void TotalDs() DataSetds=ucObj.ReturnTotalDs(Convert.ToInt32(SessionUID.ToString(), TotalInfo); lbSumPrice.Text = ucObj.VarStr(ds.TablesTotalInfo.Rows00.ToString(),2); lbSumNum.Text = ucObj.VarStr(ds.TablesTotalInfo.

28、Rows01.ToString(), 1); protected void lnkbtnClear_Click(object sender, EventArgs e) ucObj.DeleteShopCart(Convert.ToInt32(SessionUID.ToString(); ShopCartBind(); TotalDs(); lbLag.Visible = true; protected void gvShopCart_PageIndexChanging(object sender, GridViewPageEventArgs e) gvShopCart.PageIndex =

29、e.NewPageIndex; ShopCartBind(); protected void gvShopCart_RowDeleting(object sender, GridViewDeleteEventArgs e) int P_Int_CartID = Convert.ToInt32(gvShopCart.DataKeyse.RowIndex.Value.ToString(); ucObj.DeleteShopCartByID(Convert.ToInt32(SessionUID.ToString(), P_Int_CartID); ShopCartBind(); TotalDs();

30、 protected void gvShopCart_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) gvShopCart.EditIndex = -1; ShopCartBind(); TotalDs(); protected void gvShopCart_RowUpdating(object sender, GridViewUpdateEventArgs e) int P_Int_CartID = Convert.ToInt32(gvShopCart.DataKeyse.RowIndex.Value.ToStr

31、ing(); int P_Int_Num =Convert.ToInt32( (TextBox)(gvShopCart.Rowse.RowIndex.Cells3.Controls0).Text.ToString(); if (IsValidNum(P_Int_Num.ToString() = true) ucObj.UpdateSCI(Convert.ToInt32(SessionUID.ToString(), P_Int_CartID, P_Int_Num); gvShopCart.EditIndex = -1; ShopCartBind(); TotalDs(); else gvShop

32、Cart.EditIndex = -1; ShopCartBind(); TotalDs(); protected void gvShopCart_RowEditing(object sender, GridViewEditEventArgs e) gvShopCart.EditIndex = e.NewEditIndex; ShopCartBind(); TotalDs(); 圖7管理員登錄public partial class AdminManage_Login : System.Web.UI.Page MangerClass mcObj = new MangerClass(); pro

33、tected void Page_Load(object sender, EventArgs e) protected void btnLogin_Click(object sender, EventArgs e) if (txtAdminName.Text.Trim() = | txtAdminPwd.Text.Trim() = ) Response.Write(alert(登錄名和密碼不能為空！);location=javascript:history.go(-1);); else if (txtAdminCode.Text.Trim() = SessionValid.ToString()

34、.Trim() int P_Int_IsExists = mcObj.AExists(txtAdminName.Text.Trim(), txtAdminPwd.Text.Trim(); if (P_Int_IsExists = 100) DataSet ds = mcObj.ReturnAIDs(txtAdminName.Text.Trim(), txtAdminPwd.Text.Trim(), AInfo); SessionAID = Convert.ToInt32(ds.TablesAInfo.Rows00.ToString(); SessionAname = ds.TablesAInf

35、o.Rows01.ToString(); Response.Write(window.open(AdminIndex.aspx);window.close();); else Response.Write(alert(您輸入的用戶(hù)名或密碼錯(cuò)誤，請(qǐng)重新輸入！);location=javascript:history.go(-1);); else Response.Write(alert(驗(yàn)證碼輸入有誤，請(qǐng)重新輸入！);location=javascript:history.go(-1);); 圖8書(shū)籍管理public partial class Manger_Category : System.

36、Web.UI.Page MangerClass mcObj = new MangerClass(); protected void Page_Load(object sender, EventArgs e) if (Convert.ToString(SessionAID) = ) Response.Redirect(Fail.aspx); if (!IsPostBack) gvBind(); public void gvBind() DataSet ds = mcObj.GetCategory(ClassInfo); gvCategoryList.DataSource = ds.TablesC

37、lassInfo.DefaultView; gvCategoryList.DataBind(); protected void gvCategoryList_PageIndexChanging(object sender, GridViewPageEventArgs e) gvCategoryList.PageIndex = e.NewPageIndex; gvBind(); protected void gvCategoryList_RowDeleting(object sender, GridViewDeleteEventArgs e) int P_Int_ClassID = Conver

38、t.ToInt32(gvCategoryList.DataKeyse.RowIndex.Value); mcObj.DeleteCategory(P_Int_ClassID); gvBind(); 圖9會(huì)員管理public partial class Manger_Member : System.Web.UI.Page MangerClass mcObj = new MangerClass(); protected void Page_Load(object sender, EventArgs e) if (Convert.ToString(SessionAID) = ) Response.R

39、edirect(Fail.aspx); if (!IsPostBack) gvAdminBind(); public void gvAdminBind() DataSet ds = mcObj.ReturnAdminIDs(int)SessionAID, Admin); gvCategoryList.DataSource = ds.TablesAdmin.DefaultView; gvCategoryList.DataBind(); protected void gvCategoryList_PageIndexChanging(object sender, GridViewPageEventA

40、rgs e) gvCategoryList.PageIndex = e.NewPageIndex; gvAdminBind(); protected void gvCategoryList_RowDeleting(object sender, GridViewDeleteEventArgs e) int P_Int_AdminID = Convert.ToInt32(gvCategoryList.DataKeyse.RowIndex.Value.ToString(); mcObj.DeleteAdminInfo(P_Int_AdminID); gvAdminBind(); protected void gvCategoryList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) gvCategoryList.EditIndex = -1; gvAdminBind(); protected void gvCategoryList_RowEditing(object sender, GridViewEditEventArgs e) gvCategoryList.EditIndex = e.NewEditIndex; gvAdminBind(); protected void gvCategoryLis