asp二手交易網(wǎng)課程設計報告

1、. . . . A 3.5(C#)實踐教程課程設計報告題目：二手交易網(wǎng) 院 系：專 業(yè)：班 級：學 號：姓 名：指導老師： 2013年6月28日目錄一、系統(tǒng)設計要求····································&#

2、183;3二、設計思路·········································3三、需求分析······

3、···································3四、功能模塊··············

4、;···························3五、用例圖······················

5、;·····················4六、系統(tǒng)流程圖···························

6、83;···········5七、E-R圖·····································&#

7、183;·····5八、數(shù)據(jù)庫和表設計···································7九、調試程序······

8、83;··································8十、關鍵程序代碼··············

9、·······················12十二、參考書目·························

10、83;·············20十一、總結···································&#

11、183;·······20一 系統(tǒng)設計要求（1）應用Visual Studio 設計、開發(fā)和發(fā)布； （2）應用HTML相關知識制作頁面；（3）應用Table或者CSS對網(wǎng)頁進行合理布局；（4）應用ASP.NET置對象完成相關邏輯處理；（5）應用ASP.NET各種控件完成相關模塊的重用；（6）應用ADO.NET相關知識完成數(shù)據(jù)庫的連接與處理二、設計思路本為用戶提供一個二手商品交易的網(wǎng)絡平臺，為學生處理個人物品提供一個快捷的途徑，操作簡單。本組設計具有以下特點：簡單性：設計操作簡單易懂，用戶操作易上手，方便同學處理閑置物品。實用

12、性：系統(tǒng)能完成商品展示管理等功能和管理員對信息的處理，有很好的實用性。三、需求分析非注冊用戶，瀏覽商品、注冊會員用戶注冊，商品瀏覽、添加商品、添加購物車、用戶結賬、發(fā)布留言、修改商品、刪除商品等。管理員添加商品、刪除商品、修改商品、留言管理、用戶管理、網(wǎng)址更新維護等。四、功能模塊功能模塊主頁建立主頁面用戶注冊、登錄模塊用戶注冊登錄用戶注冊用戶管理模塊查看修改用戶信息找回密碼商品管理模塊增加商品修改商品信息商品瀏覽和購物車模塊查看商品信息信息添加物品到購物車清空購物車刪除購物車商品搜索和在線幫助模塊物品的模糊查找在線服務幫助訂單管理模塊添加訂單處理訂單查看訂單用戶結賬留言管理模塊留言、查看留言、

13、回復留言、查看回復信息五、用例圖六、系統(tǒng)流程圖七、E-R圖真實XX用戶密碼性別用戶郵箱 號碼注冊時間用戶 登錄名用戶地址用戶編號年齡真實XX管理員密碼管理員登錄名注冊時間郵箱管理員編號管理員商品訂單明細訂單詳細表號商品數(shù)量商品代號商品對應訂單號備注商品總金額商品商品ID商品種類種類編碼名稱商品原價銷售價格詳細描述商品圖片用戶登錄留言留言編號留言內容留言日期用戶id八、數(shù)據(jù)庫和表設計管理員表商品表購物車用戶表九、調試程序注冊登錄上傳頭像修改密碼添加商品主頁留言后臺管理找回密碼十、關鍵程序代碼登陸后臺代碼using System;using System.Collections.Generic;u

14、sing System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;publicpartialclassAdmin_images_login : System.Web.UI.Pageprotectedvoid Page_Load(object sender, EventArgs e) if (Session"UserLoginName" = null) else /string U

15、serLoginName = Session"UserLoginName".ToString(); Response.Redirect("index.aspx?UserLoginName=" + Session"UserLoginName".ToString(); protectedvoid Button1_Click(object sender, EventArgs e) if (TextBox1.Text = "") Response.Write("<script language='j

16、avascript'>alert('用戶名不能為空！');localtion='login.aspx'</script>");return; else if (TextBox2.Text = "") Response.Write("<script language='javascript'>alert('密碼不能為空！');localtion='login.aspx'</script>");return; else

17、string name = TextBox1.Text;string password = TextBox2.Text;string constr = "server=.;database=shopdb;trusted_connection=true"SqlConnection conn = newSqlConnection(constr); conn.Open();SqlCommand cmd = newSqlCommand(); cmd mandText = "select count(*) from users where UserName='&qu

18、ot; + 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('登錄成功')&

19、lt;/script>"); Response.Redirect("usersnews.aspx?UserLoginName=" + TextBox1.Text); else Response.Write("<script>alert('用戶名或密碼錯誤！')</script>");return; conn.Close(); 注冊后臺代碼using System;using System.Collections.Generic;using System.Linq;using System.Web;u

20、sing System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;publicpartialclassAdmin_images_addusers : System.Web.UI.Pageprotectedvoid Page_Load(object sender, EventArgs e) if (Session"UserLoginName " = null) else string name = Session"UserLoginName

21、 ".ToString(); Response.Redirect("index.aspx?sname=" + Session"UserLoginName ".ToString(); protectedvoid Button1_Click(object sender, EventArgs e) string constr = "server=.;database=shopdb;trusted_connection=true"SqlConnection con = newSqlConnection(constr);SqlComm

22、and cmd = newSqlCommand("praddusers", con); cmd.Connection = con; cmd mandText = "praddusers" cmd mandType = CommandType.StoredProcedure;SqlParameter sp1 = newSqlParameter("username", SqlDbType.VarChar, 20); sp1.ParameterName = "username" sp1.Value = TextBox1.

23、Text; cmd.Parameters.Add(sp1);SqlParameter sp2 = newSqlParameter("password", SqlDbType.VarChar, 20); sp2.ParameterName = "password" sp2.Value = TextBox3.Text; cmd.Parameters.Add(sp2);SqlParameter sp3 = newSqlParameter("realname", SqlDbType.VarChar, 20); sp3.ParameterNam

24、e = "realname" sp3.Value = TextBox4.Text; cmd.Parameters.Add(sp3);SqlParameter sp4 = newSqlParameter("sex", SqlDbType.Bit); sp4.ParameterName = "sex" sp4.Value =(RadioButtonList1.SelectedItem.ToString()="男"?1:0); cmd.Parameters.Add(sp4);SqlParameter sp5 = newS

25、qlParameter("age", SqlDbType.Int); sp5.ParameterName = "age" sp5.Value = TextBox5.Text; cmd.Parameters.Add(sp5);SqlParameter sp6 = newSqlParameter("phonecode ", SqlDbType.VarChar, 20); sp6.ParameterName = "phonecode " sp6.Value = TextBox6.Text; cmd.Parameters.

26、Add(sp6);SqlParameter sp7 = newSqlParameter("Address", SqlDbType.VarChar, 50); sp7.ParameterName = "Address" sp7.Value = TextBox7.Text; cmd.Parameters.Add(sp7);SqlParameter sp8 = newSqlParameter("Postcode", SqlDbType.Char, 20); sp8.ParameterName = "Postcode" s

27、p8.Value = TextBox8.Text; cmd.Parameters.Add(sp8);SqlParameter sp9 = newSqlParameter("Email", SqlDbType.Char, 20); sp9.ParameterName = "Email" sp9.Value = TextBox9.Text; cmd.Parameters.Add(sp9);SqlParameter sp11 = newSqlParameter("UserQue", SqlDbType.VarChar, 50); sp11.

28、ParameterName = "UserQue" sp11.Value = TextBox10.Text; cmd.Parameters.Add(sp11);SqlParameter sp12 = newSqlParameter("UserAns", SqlDbType.VarChar, 50); sp12.ParameterName = "UserAns" sp12.Value = TextBox11.Text; cmd.Parameters.Add(sp12);SqlParameter sp10 = newSqlParamete

29、r(" 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('注

30、冊成功')</script>"); Session"UserLoginName" = TextBox1.Text; Response.Redirect("SuccReg.aspx"); else Response.Write("<script>alert('注冊失敗!')</script>"); protectedvoid btnTest_Click(object sender, EventArgs e) if (TextBox1.Text = "&quo

31、t;) Response.Write("<script language='javascript'>alert('會員登錄名不能為空！');localtion='addusers.aspx'</script>"); else string constr = "server=.;database=shopdb;trusted_connection=true"SqlConnection sqlconn = newSqlConnection(constr); sqlconn.Open();

32、string sqlstr = "select * from Users where UserName='" + this.TextBox1.Text + "'"SqlCommand sqlcom = newSqlCommand(sqlstr, sqlconn);SqlDataReader read = sqlcom.ExecuteReader(); read.Read();if (read.HasRows) if (this.TextBox1.Text.Trim() = read"UserName".ToString

33、().Trim() Response.Write("<script language='javascript'>alert('該會員已經(jīng)注冊過');localtion='adduser.aspx'</script>");return; else Response.Write("<script language='javascript'>alert('您可以進行正常注冊');localtion='adduser.aspx'</sc

34、ript>"); read.Close(); sqlconn.Close(); protectedvoid Button2_Click(object sender, EventArgs e) 添加商品后臺代碼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

35、.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;using System.IO;publicpartialclassEditGoods : System.Web.UI.PageSqlOperate sqloperate = newSqlOperate();SqlConnection sqlconn = newSqlConnection(ConfigurationManager.AppSettings"Connection

36、String");protectedvoid Page_Load(object sender, EventArgs e) if (Session"UserLoginName" = null) Response.Redirect("login.aspx"); else protectedvoid Button1_Click(object sender, EventArgs e) string name = TextBox1.Text;string startprice = TextBox2.Text;string saletprice = Tex

37、tBox3.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 = newSqlConnection(constr); conn.Open();/判斷上傳文件的格式if (lastName.ToLower() = "bmp" | lastName.ToLower() = "jpg" | lastName.ToLower() = "gif") int len = fupPicturePath.PostedFile.Con