asp二手交易網(wǎng)課程設(shè)計(jì)報(bào)告

A 3.5(C#)實(shí)踐教程課程設(shè)計(jì)報(bào)告題目： 二手交易網(wǎng) 院 系： 專 業(yè)： 班 級(jí)： 學(xué) 號(hào)： 姓 名： 指導(dǎo)老師： 2013年6月28日目錄一、系統(tǒng)設(shè)計(jì)要求3二、設(shè)計(jì)思路3三、需求分析3四、功能模塊3五、用例圖4六、系統(tǒng)流程圖5七、E-R圖5八、數(shù)據(jù)庫(kù)和表設(shè)計(jì)7九、調(diào)試程序8十、關(guān)鍵程序代碼12十二、參考書目20十一、總結(jié)20一 系統(tǒng)設(shè)計(jì)要求（1）應(yīng)用Visual Studio 設(shè)計(jì)、開發(fā)和發(fā)布網(wǎng)站； （2）應(yīng)用HTML相關(guān)知識(shí)制作網(wǎng)站頁(yè)面；（3）應(yīng)用Table或者CSS對(duì)網(wǎng)頁(yè)進(jìn)行合理布局；（4）應(yīng)用ASP.NET內(nèi)置對(duì)象完成相關(guān)邏輯處理；（5）應(yīng)用ASP.NET各種控件完成相關(guān)模塊的重用；（6）應(yīng)用ADO.NET相關(guān)知識(shí)完成數(shù)據(jù)庫(kù)的連接與處理二、設(shè)計(jì)思路本網(wǎng)站為用戶提供一個(gè)二手商品交易的網(wǎng)絡(luò)平臺(tái)，為學(xué)生處理個(gè)人物品提供一個(gè)快捷的途徑，操作簡(jiǎn)單。本組設(shè)計(jì)網(wǎng)站具有以下特點(diǎn)：簡(jiǎn)單性：網(wǎng)站設(shè)計(jì)操作簡(jiǎn)單易懂，用戶操作易上手，方便同學(xué)處理閑置物品。實(shí)用性：系統(tǒng)能完成商品展示管理等功能和管理員對(duì)信息的處理，有很好的實(shí)用性。三、需求分析非注冊(cè)用戶，瀏覽商品、注冊(cè)會(huì)員用戶注冊(cè)，商品瀏覽、添加商品、添加購(gòu)物車、用戶結(jié)賬、發(fā)布留言、修改商品、刪除商品等。管理員添加商品、刪除商品、修改商品、留言管理、用戶管理、網(wǎng)址更新維護(hù)等。四、功能模塊功能模塊主頁(yè)建立主頁(yè)面用戶注冊(cè)、登錄模塊用戶注冊(cè)登錄用戶注冊(cè)用戶管理模塊查看修改用戶信息找回密碼商品管理模塊增加商品修改商品信息商品瀏覽和購(gòu)物車模塊查看商品信息信息添加物品到購(gòu)物車清空購(gòu)物車刪除購(gòu)物車商品搜索和在線幫助模塊物品的模糊查找在線服務(wù)幫助訂單管理模塊添加訂單處理訂單查看訂單用戶結(jié)賬留言管理模塊留言、查看留言、回復(fù)留言、查看回復(fù)信息五、用例圖六、系統(tǒng)流程圖七、E-R圖真實(shí)姓名用戶密碼性別用戶郵箱電話號(hào)碼注冊(cè)時(shí)間用戶郵編登錄名用戶地址用戶編號(hào)年齡真實(shí)姓名管理員密碼管理員登錄名注冊(cè)時(shí)間郵箱管理員編號(hào)管理員商品訂單明細(xì)訂單詳細(xì)表號(hào)商品數(shù)量商品代號(hào)商品對(duì)應(yīng)訂單號(hào)備注商品總金額商品商品ID商品種類種類編碼名稱商品原價(jià)銷售價(jià)格詳細(xì)描述商品圖片用戶登錄留言留言編號(hào)留言內(nèi)容留言日期用戶id八、數(shù)據(jù)庫(kù)和表設(shè)計(jì)管理員表商品表購(gòu)物車用戶表九、調(diào)試程序注冊(cè)登錄上傳頭像修改密碼添加商品主頁(yè)留言后臺(tái)管理找回密碼十、關(guān)鍵程序代碼登陸后臺(tái)代碼using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;public partial class Admin_images_login : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (Session"UserLoginName" = null) else /string UserLoginName = Session"UserLoginName".ToString(); Response.Redirect("index.aspx?UserLoginName=" + Session"UserLoginName".ToString(); protected void Button1_Click(object sender, EventArgs e) if (TextBox1.Text = "") Response.Write("<script language=javascript>alert(用戶名不能為空！);localtion=login.aspx</script>"); return; else if (TextBox2.Text = "") Response.Write("<script language=javascript>alert(密碼不能為空！);localtion=login.aspx</script>"); return; else string name = TextBox1.Text; string password = TextBox2.Text; string constr = "server=.;database=shopdb;trusted_connection=true" SqlConnection conn = new SqlConnection(constr); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from users where UserName=" + name + "and Password=" + TextBox2.Text + "" cmd.Connection = conn; /int count = (int)cmd.ExecuteScalar(); if (Convert.ToInt32(cmd.ExecuteScalar() > 0) Session"UserLoginName" = TextBox1.Text; Response.Write("<script>alert(登錄成功)</script>"); Response.Redirect("usersnews.aspx?UserLoginName=" + TextBox1.Text); else Response.Write("<script>alert(用戶名或密碼錯(cuò)誤！)</script>"); return; conn.Close(); 注冊(cè)后臺(tái)代碼using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;public partial class Admin_images_addusers : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (Session"UserLoginName " = null) else string name = Session"UserLoginName ".ToString(); Response.Redirect("index.aspx?sname=" + Session"UserLoginName ".ToString(); protected void Button1_Click(object sender, EventArgs e) string constr = "server=.;database=shopdb;trusted_connection=true" SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand("praddusers", con); cmd.Connection = con; cmd.CommandText = "praddusers" cmd.CommandType = CommandType.StoredProcedure; SqlParameter sp1 = new SqlParameter("username", SqlDbType.VarChar, 20); sp1.ParameterName = "username" sp1.Value = TextBox1.Text; cmd.Parameters.Add(sp1); SqlParameter sp2 = new SqlParameter("password", SqlDbType.VarChar, 20); sp2.ParameterName = "password" sp2.Value = TextBox3.Text; cmd.Parameters.Add(sp2); SqlParameter sp3 = new SqlParameter("realname", SqlDbType.VarChar, 20); sp3.ParameterName = "realname" sp3.Value = TextBox4.Text; cmd.Parameters.Add(sp3); SqlParameter sp4 = new SqlParameter("sex", SqlDbType.Bit); sp4.ParameterName = "sex" sp4.Value =(RadioButtonList1.SelectedItem.ToString()="男"?1:0); cmd.Parameters.Add(sp4); SqlParameter sp5 = new SqlParameter("age", SqlDbType.Int); sp5.ParameterName = "age" sp5.Value = TextBox5.Text; cmd.Parameters.Add(sp5); SqlParameter sp6 = new SqlParameter("phonecode ", SqlDbType.VarChar, 20); sp6.ParameterName = "phonecode " sp6.Value = TextBox6.Text; cmd.Parameters.Add(sp6); SqlParameter sp7 = new SqlParameter("Address", SqlDbType.VarChar, 50); sp7.ParameterName = "Address" sp7.Value = TextBox7.Text; cmd.Parameters.Add(sp7); SqlParameter sp8 = new SqlParameter("Postcode", SqlDbType.Char, 20); sp8.ParameterName = "Postcode" sp8.Value = TextBox8.Text; cmd.Parameters.Add(sp8); SqlParameter sp9 = new SqlParameter("Email", SqlDbType.Char, 20); sp9.ParameterName = "Email" sp9.Value = TextBox9.Text; cmd.Parameters.Add(sp9); SqlParameter sp11 = new SqlParameter("UserQue", SqlDbType.VarChar, 50); sp11.ParameterName = "UserQue" sp11.Value = TextBox10.Text; cmd.Parameters.Add(sp11); SqlParameter sp12 = new SqlParameter("UserAns", SqlDbType.VarChar, 50); sp12.ParameterName = "UserAns" sp12.Value = TextBox11.Text; cmd.Parameters.Add(sp12); SqlParameter sp10 = new SqlParameter(" userid", SqlDbType.Int); sp10.ParameterName = "userid" sp10.Direction = ParameterDirection.Output; cmd.Parameters.Add(sp10); con.Open(); cmd.ExecuteNonQuery(); con.Close(); int id = int.Parse(sp10.Value.ToString(); if (id > 0) Response.Write("<script>alert(注冊(cè)成功)</script>"); Session"UserLoginName" = TextBox1.Text; Response.Redirect("SuccReg.aspx"); else Response.Write("<script>alert(注冊(cè)失敗!)</script>"); protected void btnTest_Click(object sender, EventArgs e) if (TextBox1.Text = "") Response.Write("<script language=javascript>alert(會(huì)員登錄名不能為空！);localtion=addusers.aspx</script>"); else string constr = "server=.;database=shopdb;trusted_connection=true" SqlConnection sqlconn = new SqlConnection(constr); sqlconn.Open(); string sqlstr = "select * from Users where UserName=" + this.TextBox1.Text + "" SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn); SqlDataReader read = sqlcom.ExecuteReader(); read.Read(); if (read.HasRows) if (this.TextBox1.Text.Trim() = read"UserName".ToString().Trim() Response.Write("<script language=javascript>alert(該會(huì)員已經(jīng)注冊(cè)過(guò));localtion=adduser.aspx</script>"); return; else Response.Write("<script language=javascript>alert(您可以進(jìn)行正常注冊(cè));localtion=adduser.aspx</script>"); read.Close(); sqlconn.Close(); protected void Button2_Click(object sender, EventArgs e) 添加商品后臺(tái)代碼using System;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;using System.IO;public partial class EditGoods : System.Web.UI.Page SqlOperate sqloperate = new SqlOperate(); SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings"ConnectionString"); protected void Page_Load(object sender, EventArgs e) if (Session"UserLoginName" = null) Response.Redirect("login.aspx"); else protected void Button1_Click(object sender, EventArgs e) string name = TextBox1.Text; string startprice = TextBox2.Text; string saletprice = TextBox3.Text; string typeid = TextBox4.Text; string wareshow = TextBox5.Text; string pictureName = fupPicturePath.FileName; /獲取文件名 string lastName = pictureName.Substring(pictureName.LastIndexOf(".") + 1); /獲取文件后綴名 string constr = "server=.;database=shopdb;trusted_connection=true" SqlConnection conn = new SqlConnection(constr); conn.Open(); /判斷上傳文件的格式 if (lastName.ToLower() = "bmp" | lastName.ToLower() = "jpg" | lastName.ToLower() = "gif") int len = fupPicturePath.PostedFile.ContentLength; /獲取文件的大小 Byte pictureData = new Bytelen; HttpPostedFile htp = fupPicturePath.PostedFile; Stream srm = htp.InputStream; srm.Read(pictureData, 0, len); /讀取到pictureData中 SqlCommand com = new SqlCommand("insert into goods (modelname,startprice,saleprice,typeid,wareshow,picture) values(" + name + "," + startprice + "," + saletprice + "," + typeid + "," + wareshow + ",pictureData)", conn); com.Parameters.Add("pictureData", SqlDbType.Image); /指定類型 com.Parameters"pictureData".Value = pictureData; /設(shè)置參數(shù)值 com.ExecuteNonQuery(); conn.Close(); Response.Write("<script language=javascript>alert(上傳成功！);localtion=index.aspx</script>"); else /RegisterStartupScript("false", "<script>alert(圖片格式不正確！)</script>"); Response.Write("<script language=javascript>alert(圖片格式不正確！)</script>"); 十一、總結(jié)通過(guò)這次課程設(shè)計(jì)的鍛煉，本組成員受益很大，我們對(duì)有了更深層次的了解，更加熟悉和掌握C#語(yǔ)言，解決問題的能力得到了進(jìn)一步提升，團(tuán)隊(duì)合作意識(shí)更加強(qiáng)烈。有了老師和同學(xué)的幫助，我們又學(xué)到了很多以前未接觸到的知識(shí)與技巧，總之，此次實(shí)訓(xùn)讓我們受益匪淺。十二、參考書目ASP.NET開發(fā)實(shí)戰(zhàn)1200例（第卷）清華大學(xué)出版社ASP.NET開發(fā)實(shí)戰(zhàn)寶典，張躍廷 主編，清華大學(xué)出版社，2010；ASP.NET 3.5(C#)實(shí)踐教程，邵良衫主編，清華大學(xué)出版社，2009