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）应用置对象完成相关逻辑处理；（5）应用各种控件完成相关模块的重用；（6）应用相关知识完成数据库的连接与处理二、设计思路本为用户提供一个二手商品交易的网络平台，为学生处理个人物品提供一个快捷的途径，操作简单。

本组设计具有以下特点：简单性：设计操作简单易懂，用户操作易上手，方便同学处理闲置物品。

实用性：系统能完成商品展示管理等功能和管理员对信息的处理，有很好的实用性。

三、需求分析非注册用户，浏览商品、注册会员用户注册，商品浏览、添加商品、添加购物车、用户结账、发布留言、修改商品、删除商品等。

管理员添加商品、删除商品、修改商品、留言管理、用户管理、网址更新维护等。

四、功能模块五、用例图六、系统流程图七、E-R 图真实姓名 用户密码 性别 用户邮箱电话号码注册时间用户邮编 登录名 用户地址用户编号年龄真实姓名 管理员密码管理员登录名注册时间邮箱管理员编号管理员管理员表商品表购物车用户表九、调试程序注册登录上传头像修改密码添加商品主页留言后台管理找回密码十、关键程序代码登陆后台代码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();mandText = "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;mandText = "praddusers";mandType = 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 = newSqlConnection(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(stIndexOf(".") + 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 Byte[len];HttpPostedFile htp = fupPicturePath.PostedFile;Stream srm = htp.InputStream;srm.Read(pictureData, 0, len); //读取到pictureData中SqlCommand = new SqlCommand("insert into goods(modelname,startprice,saleprice,typeid,wareshow,picture) values('"+ name + "','"+ startprice + "','" + saletprice + "','" + typeid + "','" + wareshow +"',pictureData)", conn);.Parameters.Add("pictureData", SqlDbType.Image); //指定类型.Parameters["pictureData"].Value = pictureData; //设置参数值.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#语言，解决问题的能力得到了进一步提升，团队合作意识更加强烈。