asp二手交易网课程设计报告.doc

A 3.5(C#)实践教程课程设计报告题目： 二手交易网 院 系： 专 业： 班 级： 学 号： 姓 名： 指导老师： 2013年6月28日目录一、系统设计要求·····································3二、设计思路·········································3三、需求分析·········································3四、功能模块·········································3五、用例图···········································4六、系统流程图·······································5七、E-R图···········································5八、数据库和表设计···································7九、调试程序·········································8十、关键程序代码·····································12十二、参考书目·······································20十一、总结···········································20一 系统设计要求（1）应用Visual Studio 设计、开发和发布网站； （2）应用HTML相关知识制作网站页面；（3）应用Table或者CSS对网页进行合理布局；（4）应用ASP.NET内置对象完成相关逻辑处理；（5）应用ASP.NET各种控件完成相关模块的重用；（6）应用ADO.NET相关知识完成数据库的连接与处理二、设计思路本网站为用户提供一个二手商品交易的网络平台，为学生处理个人物品提供一个快捷的途径，操作简单。本组设计网站具有以下特点：简单性：网站设计操作简单易懂，用户操作易上手，方便同学处理闲置物品。实用性：系统能完成商品展示管理等功能和管理员对信息的处理，有很好的实用性。三、需求分析非注册用户，浏览商品、注册会员用户注册，商品浏览、添加商品、添加购物车、用户结账、发布留言、修改商品、删除商品等。管理员添加商品、删除商品、修改商品、留言管理、用户管理、网址更新维护等。四、功能模块功能模块主页建立主页面用户注册、登录模块用户注册登录用户注册用户管理模块查看修改用户信息找回密码商品管理模块增加商品修改商品信息商品浏览和购物车模块查看商品信息信息添加物品到购物车清空购物车删除购物车商品搜索和在线帮助模块物品的模糊查找在线服务帮助订单管理模块添加订单处理订单查看订单用户结账留言管理模块留言、查看留言、回复留言、查看回复信息五、用例图六、系统流程图七、E-R图真实姓名用户密码性别用户邮箱电话号码注册时间用户邮编登录名用户地址用户编号年龄真实姓名管理员密码管理员登录名注册时间邮箱管理员编号管理员商品订单明细订单详细表号商品数量商品代号商品对应订单号备注商品总金额商品商品ID商品种类种类编码名称商品原价销售价格详细描述商品图片用户登录留言留言编号留言内容留言日期用户id八、数据库和表设计管理员表商品表购物车用户表九、调试程序注册登录上传头像修改密码添加商品主页留言后台管理找回密码十、关键程序代码登陆后台代码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('用户名或密码错误！')</script>"); return; conn.Close(); 注册后台代码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('注册成功')</script>"); Session"UserLoginName" = TextBox1.Text; Response.Redirect("SuccReg.aspx"); else Response.Write("<script>alert('注册失败!')</script>"); protected void btnTest_Click(object sender, EventArgs e) if (TextBox1.Text = "") Response.Write("<script language='javascript'>alert('会员登录名不能为空！');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('该会员已经注册过');localtion='adduser.aspx'</script>"); return; else Response.Write("<script language='javascript'>alert('您可以进行正常注册');localtion='adduser.aspx'</script>"); read.Close(); sqlconn.Close(); protected void 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.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; /设置参数值 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>"); 十一、总结通过这次课程设计的锻炼，本组成员受益很大，我们对有了更深层次的了解，更加熟悉和掌握C#语言，解决问题的能力得到了进一步提升，团队合作意识更加强烈。有了老师和同学的帮助，我们又学到了很多以前未接触到的知识与技巧，总之，此次实训让我们受益匪浅。十二、参考书目ASP.NET开发实战1200例（第卷）清华大学出版社ASP.NET开发实战宝典，张跃廷 主编，清华大学出版社，2010；ASP.NET 3.5(C#)实践教程，邵良衫主编，清华大学出版社，2009