系统说明书.docx
- 文档编号:30635672
- 上传时间:2023-08-18
- 格式:DOCX
- 页数:31
- 大小:2.50MB
系统说明书.docx
《系统说明书.docx》由会员分享,可在线阅读,更多相关《系统说明书.docx(31页珍藏版)》请在冰豆网上搜索。
系统说明书
黄青在线图书销售系统
产品发布订购系统说明书
计0501B05z508158黄青
—、实践目的
Ø熟悉WEB应用系统开发流程;
Ø掌握ASP.NET技术开发常用WEB应用系统。
二、开发环境
ØMicrosoftWindowsXPProfessional(SP2)(或MicrosoftWindows2000)操作系统及IIS组件
ØMDAC
Ø.NetFramework、.NetFrameworkSDKV1.1(或V2.0)
ØVisualStudio.Net(或MacromediaDreamweaver8)、AdobePhotoshopCS2、SQLServer2000(或ACCESS)等。
三、系统需求分析、概要设计
后台管理帐号和密码为admin
留言本回复和删除密码为admin
系统截图如下:
四、系统详细设计
全局E-R图
各模块主要代码
1、登陆页面login.aspx
voidSubmitBtn_Click(Objectsender,EventArgsE)
{
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
stringqueryStr="select*fromuserswhereuser_id='"+Request.Form["UserID"]+"'";
SqlConnectionconn=newSqlConnection(strConnection);
SqlDataAdapteruserAdapter=newSqlDataAdapter(queryStr,conn);
DataSetuserSet=newDataSet();
userAdapter.Fill(userSet,"users");
if(userSet.Tables["users"].Rows.Count==0)
{
Message.Text="没有这个用户,请重输";
return;
}
if(UserPassword.Value!
=userSet.Tables["users"].Rows[0]["user_pwd"].ToString())
{
Message.Text="密码错误,请重输";
return;
}
FormsAuthenticationTicketticket=newFormsAuthenticationTicket(UserID.Value,false,1800);
//FormsAuthentication.RedirectFromLoginPage(UserID.Value,false);
Label1.Text="恭喜你登陆成功!
";
userlist.DataSource=userSet;
userlist.DataBind();
Session["User"]=Request.Form["UserID"];
}
2、用户注册register.aspx
voidButton1_Click(Objectsender,EventArgsE)
{
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
StringinsertCmd="insertintousers(user_id,user_name,user_pwd,user_email)values(@user_id,@user_name,@user_password,@email)";
SqlConnectionconn=newSqlConnection(strConnection);
SqlCommandistCmd=newSqlCommand(insertCmd,conn);
istCmd.Parameters.Add("@user_id",SqlDbType.VarChar,50).Value=user_id.Text;
istCmd.Parameters.Add("@user_name",SqlDbType.VarChar,20).Value=user_name.Text;
istCmd.Parameters.Add("@user_password",SqlDbType.VarChar,20).Value=user_password.Text;
istCmd.Parameters.Add("@email",SqlDbType.VarChar,50).Value=email.Text;
try
{
conn.Open();
istCmd.ExecuteNonQuery();
conn.Close();
msg.Text="恭喜您已经注册成功!
";
ClearText();
}
catch(System.Data.SqlClient.SqlExceptione)
{
if(e.Number==2627)
{
RequiredFieldValidator2.ErrorMessage="用户名已存在,请重新输入";
RequiredFieldValidator2.IsValid=false;
}
Response.Write(e.ToString());
}
}
privatevoidClearText()
{
user_id.Text="";
user_name.Text="";
user_password.Text="";
email.Text="";
}
3、分类浏览页面showbook.aspx
voidPage_Load(ObjectSource,EventArgsE)
{
if(!
Page.IsPostBack)
{
stringbookType=(string)Request.QueryString["type"];
label1.Text="";
switch(bookType)
{case"lx":
label1.Text="流行文学";
break;
case"sh":
label1.Text="生活时尚";
break;
case"sk":
label1.Text="社科人文";
break;
case"yy":
label1.Text="英语学习";
break;
case"js":
label1.Text="计算机应用";
break;
default:
break;
}
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
SqlConnectionshopConn=newSqlConnection(strConnection);
SqlDataAdaptershopAdapter=newSqlDataAdapter("selectbook_id,title,pricefrombookswheretype='"+bookType+"'",shopConn);
DataSetshopSet=newDataSet();
shopAdapter.Fill(shopSet,"titles");
titleList.DataSource=shopSet.Tables["titles"].DefaultView;
titleList.DataBind();
titleList.RepeatDirection=RepeatDirection.Horizontal;
titleList.RepeatLayout=RepeatLayout.Table;
titleList.RepeatColumns=3;
}
}
4、搜索search.aspx
voidSearch_Click(Objectsender,EventArgsE)
{
stringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
stringqueryStr="selectbook_id,title,price,typefrombookswheretitlelike'%"+keyText.Text+
"%'";
SqlConnectioncn=newSqlConnection(strConnection);
SqlDataAdapterresAdapter=newSqlDataAdapter(queryStr,cn);
DataSetresSet=newDataSet();
resAdapter.Fill(resSet,"books");
bookGrid.DataSource=resSet.Tables["books"].DefaultView;
bookGrid.DataBind();
}
5、图书介绍showdetail.aspx
publicvoidPage_Load(Objectsender,EventArgsE)
{
stringbookID=(string)Request.QueryString["book_id"];
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
SqlConnectionconn=newSqlConnection(strConnection);
conn.Open();
SqlDataReaderdr=null;
SqlCommandcmd=newSqlCommand("Select*Frombookswherebook_id='"+bookID+"'",conn);
dr=cmd.ExecuteReader();
dr.Read();
cover_img.Src="TitleImgs/"+dr.GetString(0)+".gif";
book_id.Text=dr.GetString(0);
title.Text=dr.GetString
(1);
type.Text=dr.GetString
(2);
price.Text=dr.GetSqlMoney(3).ToString();
notes.Text=dr.GetString(4);
purchaseBtn.NavigateUrl="Purchase.aspx?
book_id="+dr.GetString(0);
}
6、购物车shoppingcart.aspx
voidSearch_Click(Objectsender,EventArgsE)
{
stringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
stringqueryStr="selectbook_id,title,price,typefrombookswheretitlelike'%"+keyText.Text+"%'";
SqlConnectioncn=newSqlConnection(strConnection);
SqlDataAdapterresAdapter=newSqlDataAdapter(queryStr,cn);
DataSetresSet=newDataSet();
resAdapter.Fill(resSet,"books");
bookGrid.DataSource=resSet.Tables["books"].DefaultView;
bookGrid.DataBind();
}
publicvoidPage_Load(Objectsender,EventArgse)
{
BindList();
}
voidcartList_EditCommand(Objectsender,DataListCommandEventArgse)
{
cartList.EditItemIndex=(int)e.Item.ItemIndex;
BindList();
}
voidBindList()
{
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
stringuserID=Context.User.Identity.Name;
stringqueryStr="select*fromShoppingCartwhereuser_id='"+userID+"'";
SqlConnectionconn=newSqlConnection(strConnection);
SqlDataAdaptercartAdapter=newSqlDataAdapter(queryStr,conn);
DataSetcartSet=newDataSet();
cartAdapter.Fill(cartSet,"ShoppingCart");
intcount=cartSet.Tables["shoppingCart"].Rows.Count;
if(count>0)
{
cartList.DataSource=cartSet.Tables["shoppingCart"].DefaultView;
cartList.DataBind();
cartList.Visible=true;
divPanel.Visible=true;
}
else
{
cartList.Visible=false;
divPanel.Visible=false;
cartMsg.InnerHtml="您在购物车是空的!
";
}
}
privatevoidpurchase_Click(Objectsender,EventArgsE)
{
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
SqlConnectionconn=newSqlConnection(strConnection);
SqlCommandpurchaseCmd=newSqlCommand();
purchaseCmd.Connection=conn;
purchaseCmd.CommandType=CommandType.StoredProcedure;
purchaseCmd.CommandText="addNewOrder";
purchaseCmd.Parameters.Add("@user_id",SqlDbType.VarChar,50).Value=Context.User.Identity.Name;
conn.Open();
purchaseCmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("default.aspx");
}
privatevoidclear_Click(Objectsender,EventArgsE)
{
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
SqlConnectionconn=newSqlConnection(strConnection);
stringdeleteStr="deletefromShoppingCartwhereuser_id='"+Context.User.Identity.Name+"'";
SqlCommanddelCmd=newSqlCommand(deleteStr,conn);
conn.Open();
delCmd.ExecuteNonQuery();
conn.Close();
BindList();
}
voidcartList_UpdateCommand(Objectsender,DataListCommandEventArgse)
{
intquantity=Int16.Parse(((TextBox)e.Item.FindControl("quantityText")).Text);
StringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
SqlConnectionconn=newSqlConnection(strConnection);
SqlCommandupdateCmd=newSqlCommand();
updateCmd.Connection=conn;
if(quantity==0)
{
StringdeleteStr="deleteShoppingCartwhere(user_id=@user_idandtitle_id=@title_id)";
updateCmd.CommandText=deleteStr;
}
else
{
StringupdateStr="updateShoppingCartsetquantity=@quantitywhere(user_id=@user_idandbook_id=@book_id)";
updateCmd.CommandText=updateStr;
updateCmd.Parameters.Add("@quantity",SqlDbType.Int,4).Value=quantity;
}
updateCmd.Parameters.Add("@user_id",SqlDbType.VarChar,50).Value=Context.User.Identity.Name;
updateCmd.Parameters.Add("@book_id",SqlDbType.VarChar,6).Value=((Label)e.Item.FindControl("bookIdLabel")).Text;
conn.Open();
updateCmd.ExecuteNonQuery();
conn.Close();
cartList.EditItemIndex=-1;
BindList();
}
voidcartList_CancelCommand(Objectsender,DataListCommandEventArgse)
{
cartList.EditItemIndex=-1;
BindList();
}
7、订单管理orders.aspx
publicvoidShow()
{
stringstrConnection="PersistSecurityInfo=false;";
strConnection+="userid=sa;password=;database=hqshop;";
StringqueryStr="selectbook_id,title,quantity,pricefromOrderDetailwhereorder_id='"+orderIdLabel.Text+"'";
SqlConnectionconn=newSqlConnection(strConnection);
SqlDataAdapterdetailAdapter=newSqlDataAdapter(queryStr,conn);
DataSetdetailSet=newDataSet();
detailAdapter.Fill(detailSet,"OrderDetail");
detailsGrid.DataSource=detailSet.Tables["OrderDetail"].DefaultView;
detailsGrid.DataBind();
detailsPanel.Visible=true;
}
publicvoidHide()
{
detailsPanel.Visible=false;
}
publicStringOrderID
{
get{returnorderIdLabel.Text;}
set{orderIdLabel.Text=value;}
}
publicStringUserId
{
get{returnuserIdLabel.Text;}
set{userIdLabel.Text=value;}
}
publicS
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 系统 说明书