第三次
程序员文章站
2022-07-13 21:51:25
...
1.首页模块
（1） 首页界面功能是将该网站的主要功能都显示在上面，主要有首页、二手书列表、退出登陆、会员登陆、会员注册、修改个人资料、我的购物车、我的订单、我的收藏夹、订单查询、用户留言、后台登陆、二手书查询、客户服务等等。只要点击相关的链接就可以进入相关的网页。用户可通过按类查询，查找自己想要的二手书，点击图片进入浏览。
<%@ Page language="c#" Inherits="SCard.index" ResponseEncoding="utf-8" CodeFile="index.aspx.cs" %>
<%@ Register TagPrefix="uc1" TagName="pageHeader" Src="pageHeader.ascx" %>
<%@ Register TagPrefix="uc1" TagName="pageFooter" Src="pageFooter.ascx" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>二手书网络交易平台</title>
<LINK href="style/style.css" type="text/css" rel="stylesheet">
</HEAD>
<body>
<img src="images/1.jpg" width="745" height="102">
<uc1:pageheader id="PageHeader1" runat="server"></uc1:pageheader>
<form id="SelectForm" method="post" runat="server">
<table width="760" class="LMubg" cellpadding=0 cellspacing=0>
<tr><td colspan=3 height=0 bgcolor=#e9e9e9></td></tr>
<tr>
<td width=2></td>
<td width="208">
<!-- 导航条 首页-->
<table><tr><td><IMG src="images/index_dc_20L.gif"></td></tr></table>
</td>
<td>
<!-- 搜索条开始{ -->
<table width="100%">
<tr>
<td width=60 align=center><IMG src="images/leibie.gif"></td>
<td width=45 align=center>按分类</td>
<td width=60 align=center><asp:dropdownlist id="ddlClass" runat="server"></asp:dropdownlist></td>
<td width=45 align=center>关键字</td>
<td width=100 align=center><asp:textbox id="txtSelect" runat="server"></asp:textbox></td>
<td width=40 align=right><asp:button id="btnSelect" style="WIDTH: 60px; COLOR:#ff0000" runat="server" Text="查 询" onclick="btnSelect_Click"></asp:button></td>
<td align=right><IMG src="images/index_dc_20.gif"></td>
</tr>
</table>
<!-- }搜索条结束 -->
</td>
</tr>
<tr><td colspan=3 height=0 bgcolor=#e2e2e2></td></tr>
</table>
</form>
<table width="760" class="ZWenbg" cellpadding=2 cellspacing=2>
<tr vAlign="top">
<td width="185">
<!-- 左边开始 -->
<!-- 分类列表开始 -->
<table width="179" cellSpacing="0" cellPadding="0">
<tr>
<td width="179" colspan=3 background="images/fenlei.gif" height="24"> <b>二手书分类</b></td>
</tr>
<tr>
<td class="LFramebg"></td>
<td align="center" height=100 class="LMubg" valign=top>
<asp:repeater id="CRepeater" runat="server">
<HeaderTemplate>
<table width="177">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td width="12" align=center valign=top><img border="0" src="images/bullet.gif" width="10" height="10"></td>
<td>
<A href='productsList.aspx?cid=<%#DataBinder.Eval(Container.DataItem,"CID")%>'>
<%#DataBinder.Eval(Container.DataItem,"CName")%>
</A>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:repeater>
</td>
<td class="RFramebg"></td>
</tr>
<tr>
<td colspan=3 class="XFramebg"></td>
</tr>
</table>
<!-- }分类列表结束 -->
<table height=10><tr><td></td></tr></table>
<!-- 推荐列表开始{ -->
<table cellSpacing="0" cellPadding="0">
<tr>
<td width="179" colspan=3 height="24" background="images/fenlei.gif"> <b>精品推荐</b></td>
</tr>
<tr>
<td class="LFramebg"></td>
<td align="center" height=200 valign=top>
<asp:repeater id="JRepeater" runat="server">
<HeaderTemplate>
<table width="177">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td width="12" align=center valign=top><img border="0" src="images/p_01.jpg" width="12" height="12"></td>
<td>
<A href='productDisplay.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>
<%#DataBinder.Eval(Container.DataItem,"PName")%>
</A>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:repeater>
</td>
<td class="RFramebg"></td>
</tr>
<tr>
<td colspan=3 class="XFramebg"></td>
</tr>
</table>
<!-- }推荐列表结束 -->
<table height=10><tr><td></td></tr></table>
<table cellSpacing="0" cellPadding="0">
<tr>
<td width="179" colspan=3 height="24" background="images/fenlei.gif"> <b>客户服务</b></td>
</tr>
<tr>
<td class="LFramebg"></td>
<td align="center" height=150 valign=top>
<table cellspacing=5 width="177">
<tr>
<td><img src="images/myInfo/tel.gif"></td>
</tr>
<tr>
<td align=center><img src="images/myInfo/line.gif"></td>
</tr>
<tr>
<td align=center><font color="#754f75"><strong>13888888888</strong></font></td>
</tr>
<tr>
<td><img src="images/myInfo/QQ.gif"></td>
</tr>
<tr>
<td align=center><img src="images/myInfo/line.gif"></td>
</tr>
<tr>
<td>
<font color="#754f75"><strong> 888888888</STRONG>
</font>
</td>
</tr>
<tr>
<td><img src="images/myInfo/mail.gif"></td>
</tr>
<tr>
<td align=center><img src="images/myInfo/line.gif"></td>
</tr>
<tr>
<td align=center><font color="#754f75"><strong>88888888888@163.com</strong></font></td>
</tr>
</table>
</td>
<td class="RFramebg"></td>
</tr>
<tr>
<td colspan=3><IMG src="images/fenleiD.gif" width="179"></td>
</tr>
</table>
<table height=10><tr><td></td></tr></table>
<!-- 左边结束 -->
</TD>
<td width=100% align=right>
<!-- 右边开始{ -->
<table cellSpacing="0" cellPadding="0" width="98%">
<tr>
<td height="22" width="135" background="images/T2.gif"> <span style="font-size:12px;COLOR: #ffffff"><b>[ 热卖二手书 ]</b></span></td>
<td background="images/Z2.gif">
<table width="98%" cellSpacing="0" cellPadding="0">
<tr>
<td align="left" style="height: 16px" ><!-- 公告栏 -->
<marquee id="info" onMouseOver="info.stop()" onMouseOut="info.start()" scrollDelay="180" direction="left" width="98%"><asp:label ForeColor=#ff0000 id="lblAnnounce" Runat="server"></asp:label></marquee>
</td>
</tr>
</table>
</td>
<td width="2" background="images/W2.gif"></td>
</tr>
</table>
<!-- 热卖二手书列表开始{ -->
<table width="98%" cellpadding="0" cellspacing="0" height=300>
<tr>
<td class="LFramebg"></td>
<td valign="top" class="LMubg">
<asp:datalist id="HDataList" Width="100%" runat="server" RepeatDirection="Horizontal" RepeatColumns="3"
ShowHeader="False" ShowFooter="False" CellPadding="10" CellSpacing="3" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<table cellpadding="0" cellspacing="0">
<tr>
<td width="100" align="center">
<a href='productDisplay.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'><img border=0 width=81 height=110 alt='<%#DataBinder.Eval(Container.DataItem,"PName")%>' src='showPP.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>
</a>
</td>
<td width="140" align="left">
<table>
<tr>
<td><%#DataBinder.Eval(Container.DataItem,"PName")%></td>
</tr>
<tr>
<td align="left"> 原价:
<del>
￥<%#String.Format("{0:f}",DataBinder.Eval(Container.DataItem,"PFPrice"))%></del></td>
</tr>
<tr>
<td align="left"> 现价: <font color="#CC0033">￥<%#String.Format("{0:f}",DataBinder.Eval(Container.DataItem,"PNPrice"))%></font></td>
</tr>
</table>
</td>
</tr>
<tr align="center">
<td>[ <A href='productDisplay.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>查看详情</A>
]</td>
<td align="left"> <img src="images/emoney.gif"> [<A target=_blank href='makeOrder.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>购买</A>]
</td>
</tr>
</table>
</ItemTemplate>
</asp:datalist>
</td>
<td class="RFramebg"></td>
</tr>
<tr><td colspan=3 class="XFramebg"></td></tr>
</table>
<!-- }热卖列表二手书结束 -->
<table height=10><tr><td></td></tr></table>
<table><tr><td align=center><a href="productDisplay.aspx?id=9" target=_blank></a></td></tr></table>
<table height=10><tr><td></td></tr></table>
<!-- 最新上架列表开始{ -->
<table width="98%" cellpadding="0" cellspacing="0">
<tr>
<td height="22" width="135" background="images/T3.gif"> <span style="font-size:12px;COLOR: #ffffff"><B>[ 最新上架 ]</B></span></td>
<td background="images/Z3.gif"> </td>
<td width="2" background="images/W3.gif"></td>
</tr>
</table>
<table width="98%" cellpadding=0 cellspacing=0 height=200>
<tr>
<td class="LFramebg"></td>
<td valign="top" class="LMubg">
<asp:DataList id="NDataList" Width="100%" runat="server" RepeatDirection="Horizontal" RepeatColumns="3"
ShowHeader="False" ShowFooter="False" CellPadding="10" CellSpacing="3">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<table cellpadding="0" cellspacing="0">
<tr>
<td width="100" align="center">
<a href='productDisplay.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'><img border=0 width=81 height=110 alt='<%#DataBinder.Eval(Container.DataItem,"PName")%>' src='showPP.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>
</a>
</td>
<td width="140" align="left">
<table>
<tr>
<td><%#DataBinder.Eval(Container.DataItem,"PName")%></td>
</tr>
<tr>
<td align="left"> 原价:
<del>
￥<%#String.Format("{0:f}",DataBinder.Eval(Container.DataItem,"PFPrice"))%></del></td>
</tr>
<tr>
<td align="left"> 现价: <font color="#CC0033">￥<%#String.Format("{0:f}",DataBinder.Eval(Container.DataItem,"PNPrice"))%></font></td>
</tr>
</table>
</td>
</tr>
<tr align="center">
<td>[ <A href='productDisplay.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>查看详情</A>
]</td>
<td align="left"> <img src="images/emoney.gif"> [<A target=_blank href='makeOrder.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>购买</A>]
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</td>
<td class="RFramebg"></td>
</tr>
<tr><td colspan=3 class="XFramebg"></td></tr>
</table>
<!-- }最新上架列表结束 -->
<!-- }右边结束 -->
</td></TR></TABLE>
<uc1:pageFooter id="PageFooter1" runat="server" OnLoad="PageFooter1_Load"></uc1:pageFooter>
</body>
</HTML>
2.会员管理模块
用户管理模块分为用户登录和用户注册两个方面。点击首页的“用户注册”按钮就可以进入会员注册界面。
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Edit.aspx.cs" Inherits="SCard.Reg" %>
<%@ Register Src="pageFooter.ascx" TagName="pageFooter" TagPrefix="uc1" %>
<%@ Register Src="pageHeader.ascx" TagName="pageHeader" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>无标题页</title>
<link href="style/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<uc2:pageHeader ID="PageHeader1" runat="server" />
<table border="0" align="center" class="webname">
<tr>
<td bgcolor="#F0F5F9" style="height: 18px">
</td>
<td bgcolor="#F0F5F9" style="height: 18px; font-weight: bold; font-size: small;">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> 用户修改个人信息 </td>
</tr>
<tr>
<td bgcolor="#F0F5F9"> 用户登录ID</td>
<td bgcolor="#F0F5F9">
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td bgcolor="#f0f5f9">
用户姓名</td>
<td bgcolor="#f0f5f9">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td bgcolor="#F0F5F9"> 密码</td>
<td bgcolor="#F0F5F9">
<asp:TextBox ID="txtPsw" runat="server" TextMode="Password"></asp:TextBox><br />
密码不修改则空</td>
</tr>
<tr>
<td bgcolor="#F0F5F9" style="height: 22px"> 年龄</td>
<td bgcolor="#F0F5F9" style="height: 22px">
<asp:TextBox ID="txtOld" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td bgcolor="#F0F5F9"> 联系方式</td>
<td bgcolor="#F0F5F9">
<asp:TextBox ID="txtZh" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td bgcolor="#F0F5F9" style="height: 21px">
家庭住址</td>
<td bgcolor="#F0F5F9" style="height: 21px">
<asp:TextBox ID="txtNode" runat="server" Height="111px"
TextMode="MultiLine" Width="257px"></asp:TextBox>
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="修改" Height="25px" Width="56px" /><br /> </td>
</tr>
</table>
</div>
<uc1:pageFooter ID="PageFooter1" runat="server" />
</form>
</body>
</html>
3.留言板模块
留言板模块是为了方便会员与管理员之间的沟通而设计的，会员将信息填写完整后，点击“提交”按钮即可。
<%@ Register TagPrefix="uc1" TagName="pageHeader" Src="pageHeader.ascx" %>
<%@ Register TagPrefix="uc1" TagName="pageFooter" Src="pageFooter.ascx" %>
<%@ Page language="c#" Inherits="SCard.message" CodeFile="message.aspx.cs" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>留言板 --</title>
<LINK href="style/style.css" type="text/css" rel="stylesheet">
</HEAD>
<body>
<uc1:pageheader id="PageHeader1" runat="server"></uc1:pageheader>
<table width="760" class="ZWenbg" cellpadding="2" cellspacing="2">
<tr>
<td align="center">
<form id="Form1" method="post" runat="server">
<br>
<table width="600">
<tr>
<td background="images/bgtiao03.gif" height="28"> <B>留言板</B>
</td>
</tr>
</table>
<table cellSpacing="0" cellPadding="5" width="600">
<tr>
<td>
<img src=images/3DAS.gif>
请填写您的联系信息，对您提出的意见和建议，我会尽快作出答复。
</td>
</tr>
<tr><td height=1 bgcolor=#e2e2e2></td></tr>
<tr>
<td align=center class="LMubg">
<table width="90%">
<tr>
<td width="80">姓名</td>
<td><asp:textbox id="txtUserName" Runat="server" Width="150" MaxLength="20"></asp:textbox></td>
</tr>
<tr>
<td>联系电话</td>
<td><asp:textbox id="txtUserPhone" Runat="server" Width="150" MaxLength="20"></asp:textbox></td>
</tr>
<tr>
<td>E-mail<FONT color="#ff0000">*</FONT></td>
<td><asp:textbox id="txtEmail" Runat="server" Width="150" MaxLength="30"></asp:textbox><asp:regularexpressionvalidator id="REVEmail" runat="server" ValidationExpression="\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
ControlToValidate="txtEmail" ErrorMessage="电子邮件格式错误!!"></asp:regularexpressionvalidator></td>
</tr>
<tr>
<td>标题<FONT color="#ff0000">*</FONT></td>
<td><asp:textbox id="txtTitle" Runat="server" Width="250" MaxLength="50"></asp:textbox></td>
</tr>
<tr>
<td vAlign="top">内容<FONT color="#ff0000">*</FONT></td>
<td><asp:textbox id="txtContent" Runat="server" Width="450" TextMode="MultiLine" Rows="7"></asp:textbox></td>
</tr>
</table>
</td>
</tr>
<tr><td height=1 bgcolor=#e2e2e2></td></tr>
<tr>
<td><FONT color="#ff0000">■</FONT><FONT color="#ff0000"> 注：带*号为必填项</FONT>
</td>
</tr>
<tr><td height=1 bgcolor=#bec6d9></td></tr>
<tr>
<td align=center>
<asp:button id="btnOK" Runat="server" Text="提交" onclick="btnOK_Click"></asp:button>
<asp:button id="btnReset" Runat="server" Text="重置" onclick="btnReset_Click"></asp:button>
</td>
</tr>
</table>
</form>
<br>
<br>
</td>
</tr>
</table>
<uc1:pagefooter id="PageFooter1" runat="server"></uc1:pagefooter>
</body>
</HTML>
4.查看二手书详情模块
在查看二手书详情时，点击“收藏该二手书”按钮即可将自己喜欢的二手书放入收藏夹中。在收藏该二手书的下面有一个“评论该二手书”，点击它即可对该二手书进行评论，评论信息会在当前页的最下方显示，以供其它用户在购买时当作参考。在此按钮的旁边还有一个“在线购买”按钮，会员点击它可直接跳入“填写订单”界面，实现是对单件二手书的购买。
<%@ Page language="c#" Inherits="SCard.productDisplay" ResponseEncoding="utf-8" CodeFile="productDisplay.aspx.cs" %>
<%@ Register TagPrefix="uc1" TagName="pageFooter" Src="pageFooter.ascx" %>
<%@ Register TagPrefix="uc1" TagName="pageHeader" Src="pageHeader.ascx" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>二手书详细信息 -- 二手书网络交易平台</title>
<LINK href="style/style.css" type="text/css" rel="stylesheet">
</HEAD>
<body>
<uc1:pageheader id="PageHeader1" runat="server"></uc1:pageheader>
<form id="Form1" method="post" runat="server">
<table width="760" class="LMubg" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" height="0" bgcolor="#e9e9e9"></td>
</tr>
<tr>
<td width="10"></td>
<td width="200">
<!-- 导航条 --><A href="index.aspx">首页</A> >
<asp:label id="lblDaohang" Runat="server" Font-Bold="True"></asp:label>
</td>
<td>
<!-- 搜索条开始{ -->
<table width="100%">
<tr>
<td width="60" align="center"><IMG src="images/leibie.gif"></td>
<td width="45" align="center">按分类</td>
<td width="60" align="center"><asp:dropdownlist id="ddlClass" runat="server"></asp:dropdownlist></td>
<td width="45" align="center">关键字</td>
<td width="100" align="center"><asp:textbox id="txtSelect" runat="server"></asp:textbox></td>
<td width="40" align="right"><asp:button id="btnSelect" style="COLOR: #ff0000" runat="server" Text="查 询" Width="60" onclick="btnSelect_Click"></asp:button></td>
<td align="right"><IMG src="images/index_dc_20.gif"></td>
</tr>
</table>
<!-- }搜索条结束 -->
</td>
</tr>
<tr>
<td colspan="3" height="0" bgcolor="#e9e9e9"></td>
</tr>
</table>
<table width="760" class="ZWenbg" cellpadding="2" cellspacing="2">
<tr vAlign="top">
<td width="185">
<!-- 正文左边开始{ -->
<!-- 分类列表开始{ -->
<table width="179" cellSpacing="0" cellPadding="0">
<TBODY>
<tr>
<td width="179" colspan="3" background="images/fenlei.gif" height="24"> <b>二手书分类</b></td>
</tr>
<tr>
<td class="LFramebg"></td>
<td align="center" height="100" class="LMubg" valign="top">
<asp:repeater id="CRepeater" runat="server">
<HeaderTemplate>
<table width="177">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td width="12" align="center" valign="top"><img border="0" src="images/bullet.gif" width="10" height="10"></td>
<td>
<A href='productsList.aspx?cid=<%#DataBinder.Eval(Container.DataItem,"CID")%>'>
<%#DataBinder.Eval(Container.DataItem,"CName")%>
</A>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate> </asp:repeater>
</td>
<td class="RFramebg"></td>
</tr>
<tr>
<td colspan="3" class="XFramebg"></td>
</tr>
</table>
<!-- }分类列表结束 -->
<table height="10">
<tr>
<td></td>
</tr>
</table>
<!-- 分类对应的热销二手书列表开始{ -->
<table cellSpacing="0" cellPadding="0">
<TBODY>
<tr>
<td width="179" colspan="3" background="images/fenlei.gif" height="24"> <b>热销排行榜</b></td>
</tr>
<tr>
<td class="LFramebg"></td>
<td align="center" height="200" valign="top">
<asp:Repeater id="HotRepeater" runat="server">
<HeaderTemplate>
<table width="177">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td width="12" align="center" valign="top"><img border="0" src="images/p_01.jpg" width="10" height="10"></td>
<td>
<A href='productDisplay.aspx?id=<%#DataBinder.Eval(Container.DataItem,"PID")%>'>
<%#DataBinder.Eval(Container.DataItem,"PName")%>
</A>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate> </asp:Repeater></TD>
<td class="RFramebg"></td>
</TR>
<tr>
<td colspan="3" class="XFramebg"></td>
</tr>
</TBODY></TABLE>
<!-- }分类对应的热销二手书列表结束 -->
<table height="10">
<tr>
<td></td>
</tr>
</table>
<!-- 客户服务开始{ -->
<table cellSpacing="0" cellPadding="0">
<tr>
<td width="179" colspan="3" height="24" background="images/fenlei.gif"> <b>客户服务</b></td>
</tr>
<tr>
<td class="LFramebg"></td>
<td align="center" height="150" valign="top">
<table cellspacing=5 width="177">
<tr>
<td><img src="images/myInfo/tel.gif"></td>
</tr>
<tr>
<td align=center><img src="images/myInfo/line.gif"></td>
</tr>
<tr>
<td align=center><font color="#754f75"><strong>13888888888</strong></font></td>
</tr>
<tr>
<td><img src="images/myInfo/QQ.gif"></td>
</tr>
<tr>
<td align=center><img src="images/myInfo/line.gif"></td>
</tr>
<tr>
<td>
<strong><span style="color: #754f75"> 888888888</span></strong></td>
</tr>
<tr>
<td><img src="images/myInfo/mail.gif"></td>
</tr>
<tr>
<td align=center><img src="images/myInfo/line.gif"></td>
</tr>
<tr>
<td align=center><font color="#754f75"><strong>88888888888@163.com</strong></font></td>
</tr>
</table>
</td>
<td class="RFramebg"></td>
</tr>
<tr>
<td colspan="3"><IMG src="images/fenleiD.gif" width="179"></td>
</tr>
</table>
<!-- }客户服务结束 -->
<!-- }正文左边结束 --> </TD>
<TD width="100%" align="right">
<!-- 正文右边开始{ -->
<!-- 二手书信息开始{ -->
<table width="98%" cellpadding="0" cellspacing="0">
<tr>
<td height="22" width="135" background="images/xiangxiT.gif"> <span style="COLOR: #ffffff"><B>[
二手书详情 ]</B></span></td>
<td background="images/xiangxiZ.gif"> </td>
<td width="1"><img src="images/xiangxiW.gif"></td>
</tr>
</table>
<table width="98%" cellpadding="5" cellspacing="5" class="LMubg">
<tr>
<td width="230" align="right">
<IMG height=260 alt="<%=strPName%>" src="showPP.aspx?id=<%=strPID%>" width=173 border=0 >
</td>
<td>
<table width="90%">
<tr>
<td><asp:label Font-Bold="True" ForeColor="#CC0033" id="lblPName" Runat="server"></asp:label></td>
</tr>
<tr>
<td style="height: 5px"><hr style="BORDER-TOP-STYLE:dashed; BORDER-RIGHT-STYLE:dashed; BORDER-LEFT-STYLE:dashed; BORDER-BOTTOM-STYLE:dashed"
size="1">
</td>
</tr>
<tr>
<td align="left"> <img src="images/emoney.gif"> 原价:
<del>
￥<asp:label id="lblPFPrice" Runat="server"></asp:label></del></td>
</tr>
<tr>
<td align="left"> <img src="images/emoney.gif"> 现价: <font color="#cc0033">￥<asp:label id="lblPNPrice" Runat="server"></asp:label></font></td>
</tr>
<tr>
<td style="height: 22px">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="收藏该二手书" /></td>
</tr>
<tr>
<td><!-- 在线购买 -->
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="评论该商品" /><%=strBuy%></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="98%" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 13px"><img src="images/biaotiT.gif"></td>
<td width="100%" valign="top" background="images/bgtiao2.gif"> <b>买家必读</b></td>
</tr>
<tr class="LMubg">
<td style="width: 13px"></td>
<td height="170" valign="top"><%=strPBewrite%></td>
</tr>
<tr>
<td height="10" style="width: 13px"></td>
</tr>
<tr>
<td style="width: 13px"><img src="images/biaotiT.gif"></td>
<td width="100%" background="images/bgtiao2.gif"> <b>详情介绍</b></td>
</tr>
<tr class="LMubg">
<td style="width: 13px"></td>
<td height="100" valign="top"><%=strPUseMode%></td>
</tr>
<tr>
<td height="10" style="width: 13px"></td>
</tr>
<tr>
<td style="width: 13px"><img src="images/biaotiT.gif"></td>
<td width="100%" background="images/bgtiao2.gif"> <b>二手书简介</b></td>
</tr>
<tr class="LMubg">
<td style="width: 13px"></td>
<td height="50" valign="top"><%=strPValidity%></td>
</tr> <tr>
<td height="10" style="width: 13px"></td>
</tr>
<tr>
<td style="width: 13px"><img src="images/biaotiT.gif"></td>
<td width="100%" background="images/bgtiao2.gif"> <b>评论信息</b></td>
</tr>
<tr class="LMubg">
<td style="width: 13px"></td>
<td height="50" valign="top"><%=strLeaveWord%></td>
</tr>
<tr>
<td height="10" style="width: 13px"></td>
</tr>
</table>
<!-- }二手书信息结束 -->
<!-- }正文右边结束 -->
</TD>
</TR></TABLE></form>
<uc1:pageFooter id="PageFooter1" runat="server"></uc1:pageFooter>
</body>
</HTML>
/*购物车界面核心代码*/
protected void Page_Load(object sender, System.EventArgs e)
{ if (!IsPostBack)
{if (Request.QueryString["did"] != null)
{string Pid = Request.QueryString["did"].ToString();
string sql = "delete from [tblBasket] where id=" + Pid;
DBConn myDB = new DBConn();
myDB.ExecuteNonQuery(sql);
myDB.Close();
}
if (Session["User"] != null)
{ txtName.Enabled = false;
txtName.Text = (string)Session["User"];
DBConn db1 = new DBConn();
TextBox1.Text = db1.LookUp("select 真实姓名from tblUser where UserName='" + (string)Session["User"] + "'", "真实姓名");
lblTotalPric.Text = db1.LookUp("select sum(ismoney) as '1' from viwBasket where tblUser='" + (string)Session["User"] + "'", "1");
}
else
{ Response.Write("<script>alert('未登陆禁止订购');window.close();</script>");
Response.End();
return;
}
getData();
string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
string connStr = (DBPath);
SqlConnection con = new SqlConnection(connStr);
con.Open();
string sql1 = "select * from tblMode";
SqlDataAdapter sda1 = new SqlDataAdapter(sql1, con);
DataSet ds1 = new DataSet();
sda1.Fill(ds1, "tblMode");
foreach (DataRow row in ds1.Tables[0].Rows)
{
this.dplBm.Items.Add(row["名称"].ToString());
}
}
}
private void getData()
{
string sql = "select * from [viwBasket] where tblUser='" + (string)Session["User"] + "'order by ID desc";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "ID desc", 20);
}
protected void btnOK_Click(object sender, System.EventArgs e)
{
string strName = txtName.Text.Trim();
string strEmail = txtEmail.Text.Trim();
string strPhone = txtPhone.Text.Trim();
if (strName == String.Empty || strEmail == String.Empty || strPhone == String.Empty)
{
Response.Write("<script>");
Response.Write("alert('请把必填项添上!!!');");
Response.Write("</script>");
return;
}
if (lblTotalPric.Text == String.Empty || lblTotalPric.Text == "0")
{
Response.Write("<script>");
Response.Write("alert('购物车空,没办法生成订单!!!');");
Response.Write("</script>");
return;
}
if (Session["CheckCode"].ToString() != txtCheck.Text.Trim())
{
Response.Write("<script>");
Response.Write("alert('输入的验证码有误！请重新输入！')");
Response.Write("</script>");
return;
}
Order myOrder = new Order();
myOrder.PID = "0";
myOrder.TotalPrice = lblTotalPric.Text;
myOrder.TName = CleanString.htmlInputText(strName);
myOrder.Email = strEmail;
myOrder.Phone = CleanString.htmlInputText(strPhone);
Session["myOrder"]= myOrder;
Response.Redirect("orderinfo.aspx?key=" + Server.UrlEncode("makeOrder.aspx?id=" ));
}
protected void btnClear_Click(object sender, System.EventArgs e)
{
txtEmail.Text = "";
txtPhone.Text = "";
txtCheck.Text = "";
}
/*前台首页面二手书查询功能核心代码*/
private void getSelectResult(string strClass, string strText)
{
string mySql= "select * from Products order by PID desc";
if( strClass.Equals("-1") )
{
mySql= "select * from Products where PName like '%" + strText + "%' order by PID desc";
}
else
{
mySql= "select * from Products where CID=" + strClass + " and PName like '%" + strText + "%' order by PID desc";
}
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute( SqlPager1, "PDataList", mySql, "PID desc", 10);
}
/*前台首页面二手书类别下拉列表框数据绑定核心代码*/
private void setSelectClass()
{
DBConn myDB = new DBConn();
string mySql = "select CID,CName from Category order by CID desc";
ddlClass.DataSource = myDB.getDataReader( mySql );
ddlClass.DataTextField = "CName";
ddlClass.DataValueField = "CID";
ddlClass.DataBind();
myDB.Close();
ddlClass.Items.Insert(0,new ListItem("所有分类","-1"));
}