B2C電子商務(wù)網(wǎng)站源代碼

1、_綜合實(shí)訓(xùn) ( 課程設(shè)計(jì) ) 項(xiàng)目ASP.NET專業(yè)：計(jì)算機(jī)應(yīng)用技術(shù)課程名稱：ASP.NET系部：計(jì)算機(jī)與信息工程系班級：091311指導(dǎo)教師：高 祖 彥完成時(shí)間：2011-11-22學(xué)生姓名：談銳學(xué)號：09131120精品資料_恩施職業(yè)技術(shù)學(xué)院學(xué)生綜合實(shí)訓(xùn)（課程設(shè)計(jì)）評分表學(xué)生姓名談銳專業(yè)計(jì)算機(jī)應(yīng)用班級091311課程名稱A綜合實(shí)訓(xùn)項(xiàng)目(課程設(shè)計(jì)題B2C目 )完成時(shí)間2011-11-22實(shí)訓(xùn)總結(jié)通過這次實(shí)驗(yàn)我自己動(dòng)手用做了一個(gè)電子商務(wù)網(wǎng)（設(shè)計(jì)說明）站，在制作的過程中我學(xué)到了許多知識，為以后的工作打下良好摘要的基礎(chǔ)。指導(dǎo)教師意見指導(dǎo)教師簽字：年月日綜合實(shí)訓(xùn)（課程設(shè)計(jì)）成績精品資料_數(shù)據(jù)庫名：

2、db_NetStore表名： sysdiagrams1序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1namesysname2560否2principal_idint40否3diagram_idint40是是否4versionint40是5definitionvarbinaryMAX0是表名： tb_Admin序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1AdminIDint40是是否2AdminNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Emailvarchar500否6LoadDatedatetime83否get

3、date表名： tb_BookInfo序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1BookIDint40是是否2ClassIDint40否3BookNamevarchar500否4BookIntroducentext160否5Authorvarchar500否6Companyvarchar500否7BookUrlvarchar2000否8MarketPricefloat80否9HotPricefloat80否10Isrefinementbit10否11IsHotbit10否12IsDiscountbit10否13LoadDatedatetime83否getdate表名： tb_Clas

4、s精品資料_序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1ClassIDint40是是否2ClassNamevarchar500否3CategoryUrlvarchar500否表名： tb_Detail序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1DetailIDint40是是否2BookIDint40否3Numint40否4OrderIDint40否5TotailPricefloat80否6Remarkvarchar2000是表名： tb_Image序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1ImageIDint40是是否2ImageNamevarchar500否3Ima

5、geUrlvarchar2000否表名： tb_LeaveWord序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1IDint40是是否2Uidnvarchar500否3Subjectnvarchar500否4Contentntext160是5DateTimedatetime83否6IPnvarchar200否表名： tb_Member序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1MemberIDint40是是否2UserNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否精品資料_5Sexbit10否6Phonecodevar

6、char200否7Emailvarchar500否8Addressvarchar2000否9PostCodechar100否10LoadDatedatetime83否getdate表名： tb_OrderInfo序號列名數(shù)據(jù)類型長度小數(shù)標(biāo)識主鍵允許默認(rèn)值說明位空1OrderIDint40是是否2OrderDatedatetime83否getdate3BooksFeefloat80否4ShipFeefloat80否5TotalPricefloat80否6ShipTypevarchar500否7ReceiverNamevarchar500否8ReceiverPhonevarchar200否9Rec

7、eiverPostCodechar100否10ReceiverAddressvarchar2000否11ReceiverEmailvarchar500否12IsConfirmbit10否013IsSendbit10否014IsEndbit10否015AdminIDint40是16ConfirmTimedatetime83是表名： tb_Reply序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1IDint40是是否2UNamenvarchar500是3Contentntext160是4DateTimedatetime83是5ReplyIDint40是6IPnvarchar200是精品資料_u

8、sing System;using System.Data;using System.Configuration;using System.Web;using System.Collections;CommonClass ccObj = new CommonClass();GoodsClass gcObj = new GoodsClass();protected void Page_Load(object sender, EventArgs e)if (!IsPostBack)RefineBind();HotBind();DiscountBind();/ 綁定市場價(jià)格public string

9、 GetVarMKP(string strMarketPrice)精品資料_return ccObj.VarStr(strMarketPrice, 2);/ 綁定熱賣價(jià)格public string GetVarHot(string strHotPrice)return ccObj.VarStr(strHotPrice, 2);protected void RefineBind()gcObj.DLDeplayGI(1, this.dLRefine, "Refine");protected void HotBind()gcObj.DLDeplayGI(3, this.dlHot

10、, "Hot");protected void DiscountBind()gcObj.DLDeplayGI(2, this.dlDiscount, "Discount");public void AddressBack(DataListCommandEventArgs e)Session"address" = ""Session"address" = "Default.aspx"Response.Redirect("/showInfo.aspx?id="

11、 +protected void dLRefine_ItemCommand(object source, DataListCommandEventArgs e)if (e.CommandName = "detailSee")AddressBack(e);else if (e.CommandName = "buy")AddShopCart(e);protected void dlDiscount_ItemCommand(object source, DataListCommandEventArgs e)精品資料_if (e.CommandName = &q

12、uot;detailSee")AddressBack(e);else if (e.CommandName = "buy")AddShopCart(e);protected void dlHot_ItemCommand(object source, DataListCommandEventArgs e)if (e.CommandName = "detailSee")AddressBack(e);else if (e.CommandName = "buy")AddShopCart(e);/ <summary>/ 向購

13、物車中添加新商品/ </summary>/ <param name="e">/ 獲取或設(shè)置可選參數(shù)，/ 該參數(shù)與關(guān)聯(lián)的 CommandName/ 一起被傳遞到 Command事件。/ </param>public void AddShopCart(DataListCommandEventArgs e)Hashtable hashCar;if (Session"ShopCart" = null)/如果用戶沒有分配購物車hashCar = new Hashtable();/新生成一個(gè)hashCar.Add(e.Comman

14、dArgument, 1); /添加一個(gè)商品Session"ShopCart" = hashCar;/分配給用戶else/用戶已經(jīng)有購物車精品資料_hashCar = (Hashtable)Session"ShopCart"/得到購物車的hash表if (hashCar.Contains(e.CommandArgument)/購物車中已有此商品，商品數(shù)量加 1int count =Convert.ToInt32(hashCare.CommandArgument.ToString();/得到該商品的數(shù)量hashCare.CommandArgument =

15、(count + 1);/商品數(shù)量加 1elsehashCar.Add(e.CommandArgument,1);/如果沒有此商品，則新添加一個(gè)項(xiàng)protected void Button1_Click(object sender, EventArgs e)using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;精品資料_CommonClass ccObj = new CommonClass();DBClass dbObj = new DBClass(

16、);protected void Page_Load(object sender, EventArgs e)if (!IsPostBack)產(chǎn)生驗(yàn)證碼protected void btnLogin_Click(object sender, EventArgs e)/ 判斷用戶是否已輸入了必要的信息Response.Write(ccObj.MessageBox("登錄名和密碼不能為空！");else/判斷用戶輸入的驗(yàn)證碼是否正確/定義一個(gè)字符串，獲取用戶信息string strSql = "select * from tb_Admin whereDataTable

17、dsTable=dbObj.GetDataSetStr(strSql, "tbAdmin");Session"AID" =Convert.ToInt32(dsTable.Rows00.ToString();/ 保存用戶 ID Session"AName" =dsTable.Rows01.ToString();/保存用戶名Response.Write("<scriptlanguage=javascript>window.open('AdminIndex.aspx');window.close();&

18、lt;/s精品資料_cript>");elseResponse.Write(ccObj.MessageBox("您輸入的用戶名或密碼錯(cuò)誤，請重新輸入！");elseResponse.Write(ccObj.MessageBox(" 驗(yàn)證碼輸入有誤，請重新輸入！ ");protected void btnCancel_Click(object sender, EventArgs e)Response.Write("<script>window.close();location='javascript:histo

19、ry.g o(-1)'</script>");精品資料_精品資料_using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;精品資料_CommonClass ccObj = new CommonClass();DBClass dbObj = new DBClass();protected void Page_Load(object sender, EventArgs e)if (!IsPostBack)if (Session"UserName" = null)