在线销售系统

在线销售系统开发设计文档学生姓名：学号:系别:年级:专业:班级:时间：2012年8月目录一、需求分析 (3)1．问题描述2．基本要求3. 软硬件环境需求二、项目开发环境与规划 (3)1. 开发环境2. 项目规划三、概要设计 (4)1．数据库设计2．功能逻辑图四、详细设计 (7)1．用户登陆模块的实现2．购物车模块的实现3. 显示产品信息模块4. 会员信息的编辑5. 商品详细信息的编辑6. 管理员信息的编辑五、调试分析 (15)六、测试结果 (16)前台1.用户登陆2.网站首页3.购物车后台1.后台登陆2.商品管理3.会员管理4.仓库管理5.定单管理七、用户手册 (22)1．运行环境2．软件安装与使用3、主要功能八、参考文献 (26)一.需求分析1．问题描述如何建立企业的电子商务，如何把企业业务建在Internet上，涉及到建立电子商务网站、开发符合Internet 特点的有效的业务应用、管理网上的交易信息、保证网上数据安全、快速反映市场变化以及充分满足Internet业务进一步发展的要求等等。

对一个运营商业企业来说，电子商务网站是其生存的理由和基础，同时也是企业对外展示信息、从事商务活动的窗口和界面。

如何设计、建立一个经济、实用、安全、高效、稳定的网站是每个电子商务网站必须考虑的问题。

而要解决好这些问题，就必须在提高企业内部管理效率、充分利用企业内部资源的基础上，从整体上降低成本，加快对市场的响应速度，提高服务质量，提高企业的竞争力。

但是企业在利用信息化技术时，必须要考虑成本、技术难度、创造的价值等几个方面。

2．基本要求本网站是在线销售系统，能够方便客户对公司产品的购买，除了具有一般的网站功能以外，计划开展独创用户交流购物体验和专家指导购物体验，以实用有用为目的，使用户知道当前公司最新产品款式和价格。

当然独创的用户体验必须以完善的购物平台为基础。

所以在第一阶段我准备把重点放在一个完善的购物平台上面。

本系统在设计时应该满足以下几个目标：●全面展示公司的所有商品，并可展示最新商品及特价商品。

●实现网上购物。

●商品销售排行，以方便顾客了解本商城内的热销商品及帮助企业领导者做出相应的决策。

●查看商城内的公告信息。

●对用户输入的数据，系统进行严格的数据检验，尽可能排除人为的错误。

●系统最大限度地实现了易维护性和易操作性。

●系统运行稳定、安全可靠。

3.软硬件环境需求软件环境：兼容当前主流操作系统Windows Server 2000,Microsoft Visual Studio 2005,IIS6.0硬件环境：386以上计算机，打印机等。

二、项目开发环境与规划1开发环境前台开发环境：myEclipse6.0,tomcat6.0后台数据库环境：oracle9i,2项目规划开发软件：myEclipse6.0,项目负责人：网页设计：网页美工：后台编写：后期测试：概要设计1．数据库设计数据库表:Tb_Admin,Tb_GoodsInfo,Tb_GoodsTypeID,Tb_Image,Tb_Member,Tb_OrderInfo,Tb_StoreInfoTb_Admin表：管理员表列名数据类型长度允许空描述关系AdminID int 8 否管理员编号主键AdminName varchar50 是管理员姓名AdminPwd varchar20 是管理员密码Tb_GoodsInfo表：产品信息表列名数据类型长度允许空描述关系GoodsID bigint 8 否产品编号主键GoodsTypeID bigint 8 是产品类型编号GoodsName Varchar 50 是产品名称GoodsIntroduce text 16 是产品介绍GoodsPrice bigint 8 是产品价格GoodsPhoto Varchar 50 是产品图片GoodsIsNew char 10 是是否是新产品GoodsDate datetime 8 是生产时间Tb_GoodsTypeID表：产品种类表列名数据类型长度允许空描述关系GoodsTypeID bigint 8 否产品类别编号主键GoodsTypeName Varchar 50 是产品类别名称StoreID Bigint 8 8 存储编号Tb_Image表：注册头像图列名数据类型长度允许空描述关系ImageID Bigint 8 否图片编号主键Image Varchar 50 是图片Tb_Member表：会员表列名数据类型长度允许空描述关系MemberID Bigint 8 否会员编号主键MemberName varchar 50 是会员名MemberSex Char 10 是会员性别MemberPWD Varchar 20 是会员登录密码MembeTName Varchar 20 是MemberQue Varchar 50 是会员找回密码问题MemberAns Varchar 50 是会员找回密码答案MemberPhone Varchar 20 是会员电话MemberEmail Varchar 50 是会员邮箱地址MemberCity Varchar 20 是会员所在城市MemberAddress Varchar 50 是会员所住地址MemberPostCode char 10 是会员邮编地址MemberPhoto varchar 50 是会员头像MemberMoney bigint 8 是会员所剩钱MemberDate Datetime 8 是会员注册时间Tb_OrderInfo表：订单表列名数据类型长度允许空描述关系OrderID Bigint 8 否订单号主键OrderMember Varchar 50 是订单人员GoodsID Bigint 8 是产品号GoodsName Varchar 50 是产品名称GoodsTypeID Bigint 8 是产品类型号GoodsTypeName varchar 50 是产品类型名称GoodsPrice bigint 8 是产品价格IsCheckout char 10 是是否购买OrderDate datetime 8 是订单日期Tb_StoreInfo表：商品信息表列名数据类型长度允许空描述关系StoreID Bigint 8 否商品信息号主键StoreName Varchar 50 是商品名称2,功能逻辑图三、 详细设计1.用户登陆模块的实现public partial class MemberManage_MLogin : System.Web.UI.Page {protected void Page_Load(object sender, EventArgs e) {if (!IsPostBack) {Random randobj = new Random ();labCode.Text = randobj.Next(1000, 10000).ToString(); } }protected void btnLogin_Click(object sender, EventArgs e) {服装网上购物主页用户登录 销售排行 特价商品 商品分类购物车注册忘记密码 查询销售查询商品价格 查询商品信息商品信息 商品价格购物首页女装注册成功查询成功成功SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);sqlconn.Open();SqlCommand sqlcom = new SqlCommand("proMemberInfo", sqlconn);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("@MemberName", SqlDbType.VarChar, 20).Value=txtMName.Text.Trim();sqlcom.Parameters.Add("@MemberPwd", SqlDbType.VarChar, 20).Value = txtMPwd.Text.Trim();SqlDataReader read = sqlcom.ExecuteReader();if (txtMCode.Text.Trim() == labCode.Text.Trim()){if (read.Read()){Session["MName"] = txtMName.Text;Response.Redirect("../Index.aspx");}else{Response.Write("<script>alert('您输入的用户名或密码错误，请重新输入！');location='javascript:history.go(-1)';</script>");}}elseResponse.Write("<script>alert('验证码输入有误，请重新输入！');location='javascript:history.go(-1)';</script>");}protected void btnCancle_Click(object sender, EventArgs e){Response.Write("<script>window.close();location='javascript:history.go(-1)';</script>");}}2．购物车模块的实现public partial class MemberManage_Shopping : 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["MName"] == null){Response.Write("<script>alert('您还没有登录，请登录后再使用该功能！');</script>");}if (!IsPostBack){string sqlstr = "select OrderID,GoodsName,GoodsTypeName,GoodsPrice from tb_OrderInfo"+" where OrderMember='" + Session["MName"].ToString() + "' and IsCheckout='否'";gvOrderInfo.DataKeyNames = new string[] { "OrderID" };sqloperate.gvDataBind(gvOrderInfo, sqlstr);string sqlstrtprice = "select sum(GoodsPrice) as tprice from tb_OrderInfo"+" where OrderMember='" + Session["MName"].ToString() + "' and IsCheckout='否'";sqlconn.Open();SqlDataAdapter myda = new SqlDataAdapter(sqlstrtprice,sqlconn);DataSet myds = new DataSet();myda.Fill(myds,"tb_OrderInfo");DataRowView mydrv=myds.Tables["tb_OrderInfo"].DefaultView[0];labMoney.Text = Convert.ToString(mydrv.Row["tprice"]);}}protected void lbtnCheck_Click(object sender, EventArgs e){if (labMoney.Text == ""){Response.Write("<script>alert('您的购物车中没有任何物品');</script>");}else{string sqlstr = "select MemberName,MemberMoney from tb_Member where MemberName='" + Session["MName"].ToString() + "'";sqlconn.Open();SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn);DataSet myds = new DataSet();myda.Fill(myds, "tb_Member");DataRowView mydrv = myds.Tables["tb_Member"].DefaultView[0];string MPrice = Convert.ToString(mydrv.Row["MemberMoney"]);if (Convert.ToInt32(MPrice) < Convert.ToInt32(labMoney.Text.Trim())){Response.Write("<script>alert('您的余额不足，请重新充值后再购买！');</script>");}else{string sqlstrshop1 = "update tb_Member set MemberMoney='"+ (Convert.ToInt32(MPrice) - Convert.ToInt32(labMoney.Text)) + "' where MemberName='"+ Session["MName"].ToString() + "'";sqloperate.DataCom(sqlstrshop1);string sqlstrshop2 = "update tb_OrderInfo set IsCheckout='是' where OrderMember='" + Session["MName"].ToString() + "'";sqloperate.DataCom(sqlstrshop2);Response.Redirect("SuccShop.aspx");}}}protected void lbtnClear_Click(object sender, EventArgs e){string sqlstr = "delete from tb_OrderInfo where OrderMember='"+ Session["MName"].ToString() + "' and IsCheckout='否'";sqloperate.DataCom(sqlstr);Response.Redirect("Shopping.aspx");}protected void gvOrderInfo_PageIndexChanging(object sender, GridViewPageEventArgs e){gvOrderInfo.PageIndex = e.NewPageIndex;gvOrderInfo.DataBind();}protected void gvOrderInfo_RowDataBound(object sender, GridViewRowEventArgs e){if (e.Row.RowType == DataControlRowType.DataRow){((LinkButton)(e.Row.Cells[3].Controls[0])).Attributes.Add("onclick","return confirm('确定要删除吗？')");}}protected void gvOrderInfo_RowDeleting(object sender, GridViewDeleteEventArgs e){string sqlstr = "delete from tb_OrderInfo where OrderID='"+gvOrderInfo.DataKeys[e.RowIndex].Value+"'";sqloperate.DataCom(sqlstr);Response.Redirect("Shopping.aspx");}}3.显示产品信息模块public partial class MemberManage_GoodsInfo : System.Web.UI.Page{SqlOperate sqloperate = new SqlOperate();protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){string sqlstr = "select * from vb_GoodsInfo";sqloperate.gvDataBind(gvGoodsInfo, sqlstr);}}protected void tvGType_SelectedNodeChanged(object sender, EventArgs e){string sSeleNodeText = tvGType.SelectedValue.ToString();string sqlstr = "select * from vb_GoodsInfo where GoodsTypeName='" + sSeleNodeText + "' or StoreName='" + sSeleNodeText + "'";sqloperate.gvDataBind(gvGoodsInfo, sqlstr);}protected void gvGoodsInfo_PageIndexChanging(object sender, GridViewPageEventArgs e){gvGoodsInfo.PageIndex = e.NewPageIndex;this.gvbind();}protected void btnSel_Click(object sender, EventArgs e){this.gvbind();}public void gvbind(){if (txtKey.Text == ""){string sqlstr = "select * from vb_GoodsInfo";sqloperate.gvDataBind(gvGoodsInfo, sqlstr);}else{string sqlstr = "select * from vb_GoodsInfo where "+ ddlCondition.SelectedValue + " like '%" + txtKey.Text.Trim() + "%'";sqloperate.gvDataBind(gvGoodsInfo, sqlstr);}}}4.会员信息的编辑public partial class MemberManage_EditMInfo : System.Web.UI.Page{SqlOperate sqloperate = new SqlOperate();SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){if (Session["MName"] != null){sqlconn.Open();string sqlstr = "Select * from tb_Member where MemberName='" + Session["MName"].ToString() + "'";SqlDataAdapter myApter = new SqlDataAdapter(sqlstr, sqlconn);DataSet myDS = new DataSet();myApter.Fill(myDS, "tb_Member");DataRowView rowView = myDS.Tables["tb_Member"].DefaultView[0];txtUserID.Text = Convert.ToString(rowView["MemberID"]);txtLoginName.Text = Convert.ToString(rowView["MemberName"]);txtPwd.Text = Convert.ToString(rowView["MemberPWD"]);txtTName.Text = Convert.ToString(rowView["MemberTName"]);txtQuePwd.Text = Convert.ToString(rowView["MemberQue"]);txtAnsPwd.Text = Convert.ToString(rowView["MemberAns"]);txtTel.Text = Convert.ToString(rowView["MemberPhone"]);txtEmail.Text = Convert.ToString(rowView["MemberEmail"]);ddlCity.SelectedValue = Convert.ToString(rowView["MemberCity"]);txtAddress.Text = Convert.ToString(rowView["MemberAddress"]);txtPostCode.Text = Convert.ToString(rowView["MemberPostCode"]);txtMoney.Text = Convert.ToString(rowView["MemberMoney"]);string sqlstrbind = "select * from tb_Image";SqlDataAdapter mydabind = new SqlDataAdapter(sqlstrbind, sqlconn);DataSet mydsbind = new DataSet();mydabind.Fill(mydsbind, "tb_Image");ddlPhoto.DataSource = mydsbind.Tables["tb_Image"];ddlPhoto.DataTextField = "Image";ddlPhoto.DataBind();iGPhoto.ImageUrl = Convert.ToString(rowView["MemberPhoto"]);if (Convert.ToString(rowView["MemberSex"]).Trim() == "男"){ddlSex.SelectedIndex = 0;}if (Convert.ToString(rowView["MemberSex"]).Trim() == "女"){ddlSex.SelectedIndex = 1;}sqlconn.Close();}elseResponse.Write("<script>alert('您还没有登录，请登录后再使用，谢谢！');</script>");}}protected void btnModify_Click(object sender, EventArgs e){string sqlstr = "update tb_Member set MemberName='" + txtLoginName.Text+ "',MemberSex='" + ddlSex.Text + "',MemberPWD='" + txtPwd.Text+ "',MemberTName='" + txtTName.Text + "',MemberQue='" + txtQuePwd.Text+ "',MemberAns='" + txtAnsPwd.Text + "',MemberPhone='" + txtTel.Text+ "',MemberEmail= '" + txtEmail.Text + "',MemberCity = '" + ddlCity.SelectedValue+ "',MemberAddress= '" + txtAddress.Text + "',MemberPostCode='"+ txtPostCode.Text + "',MemberPhoto='" + ddlPhoto.SelectedValue+ "',MemberMoney='" + txtMoney.Text + "' where MemberID = '" + txtUserID.Text + "'";sqloperate.DataCom(sqlstr);Response.Write("<script lanuage=javascript>alert('修改成功');location='javascript:history.go(-1)'</script>"); }protected void btnCancel_Click(object sender, EventArgs e){Response.Redirect("GoodsInfo.aspx");}protected void ddlPhoto_SelectedIndexChanged(object sender, EventArgs e){iGPhoto.ImageUrl = ddlPhoto.SelectedValue;}}5.商品详细信息的编辑public partial class MemberManage_EditGInfo : System.Web.UI.Page{SqlOperate sqloperate = new SqlOperate();SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);string strGTypeID;protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){sqlconn.Open();string strid = Page.Request.QueryString["GoodsID"];string sqlstr = "select * from vb_GoodsInfo where GoodsID='" + strid + "'";SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn);DataSet myds = new DataSet();myda.Fill(myds, "vb_GoodsInfo");DataRowView mydrv = myds.Tables["vb_GoodsInfo"].DefaultView[0];txtGID.Text = Convert.ToString(mydrv.Row["GoodsID"]);txtGName.Text = Convert.ToString(mydrv.Row["GoodsName"]);txtGType.Text = Convert.ToString(mydrv.Row["GoodsTypeName"]);txtGStore.Text = Convert.ToString(mydrv.Row["StoreName"]);txtGPrice.Text = Convert.ToString(mydrv.Row["GoodsPrice"]);txtGDate.Text = Convert.ToString(mydrv.Row["GoodsDate"]);txtGIntro.Text = Convert.ToString(mydrv.Row["GoodsIntroduce"])+"…";iGPhoto.ImageUrl = Convert.ToString(mydrv.Row["GoodsPhoto"]);strGTypeID = Convert.ToString(mydrv.Row["GoodsTypeID"]);}}protected void btnShop_Click(object sender, EventArgs e){if (Session["MName"] == null){Response.Write("<script>alert('您还没有登录，请登录后再购买，谢谢合作！');location='javascript:history.go(-1)';</script>");}else{sqlconn.Open();string strid = Page.Request.QueryString["GoodsID"];string sqlstrbind = "select * from vb_GoodsInfo where GoodsID='" + strid + "'";SqlDataAdapter myda = new SqlDataAdapter(sqlstrbind, sqlconn);DataSet myds = new DataSet();myda.Fill(myds, "vb_GoodsInfo");DataRowView mydrv = myds.Tables["vb_GoodsInfo"].DefaultView[0];strGTypeID = Convert.ToString(mydrv.Row["GoodsTypeID"]);string sqlstr = "insert into tb_OrderInfo"+ "(OrderMember,GoodsID,GoodsName,GoodsTypeID,GoodsTypeName,GoodsPrice,IsCheckout)"+ " values('" + Session["MName"].ToString() + "','" + txtGID.Text.Trim() + "','"+ txtGName.Text.Trim() + "','" + strGTypeID + "','" + txtGType.Text.Trim()+ "','" + txtGPrice.Text.Trim() + "','否')";sqloperate.DataCom(sqlstr);Response.Redirect("Shopping.aspx");}}}6.管理员信息的编辑public partial class AdminManage_EditAdmin : System.Web.UI.Page{SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);SqlOperate sqloperate = new SqlOperate();protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){txtAID.Text = Request["AdminID"].ToString();string sqlstr = "select * from tb_Admin where AdminID='"+Request["AdminID"].ToString()+"'";sqlconn.Open();SqlDataAdapter myda = new SqlDataAdapter(sqlstr,sqlconn);DataSet myds = new DataSet();myda.Fill(myds,"tb_Admin");DataRowView mydrv=myds.Tables["tb_Admin"].DefaultView[0];txtAName.Text = Convert.ToString(mydrv.Row["AdminName"]);txtAPwd.Text = Convert.ToString(mydrv.Row["AdminPwd"]);sqlconn.Close();}}protected void btnAdd_Click(object sender, EventArgs e){string sqltest = "select * from tb_Admin where AdminName='" + txtAName.Text + "'";sqlconn.Open();SqlCommand sqlcom = new SqlCommand(sqltest, sqlconn);SqlDataReader read = sqlcom.ExecuteReader();read.Read();if (read.HasRows){if (this.txtAName.Text.Trim() == read["AdminName"].ToString().Trim()){Response.Write("<script language='javascript'>alert('该管理员已经存在');localtion='EditAdmin.aspx'</script>");return;}}else{string sqlstr = "insert into tb_Admin(AdminName,AdminPwd)"+ " values('" + txtAName.Text.Trim() + "','" + txtAPwd.Text.Trim() + "')";sqloperate.DataCom(sqlstr);Response.Write("<script>alert('添加成功');location='AdminManage.aspx';</script>");}}protected void btnEdit_Click(object sender, EventArgs e){string sqlstr = "update tb_Admin set AdminName='"+txtAName.Text.Trim()+"',AdminPwd='"+txtAPwd.Text.Trim()+"' where AdminID='"+Request["AdminID"].ToString()+"'";sqloperate.DataCom(sqlstr);Response.Write("<script>alert('修改成功');location='AdminManage.aspx';</script>");}protected void btnBack_Click(object sender, EventArgs e){Response.Redirect("AdminManage.aspx");}}五、调试分析购买者可直接查看服装的销售情况，如果服装购买者可以根据本人用户名和密码登录系统，还可以进行本人对购物情况的查询和维护部分个人信息。