userbook.aspx

网上书店 含用户注册

<%@ Page Language="C#" MasterPageFile="~/UserPage.master" AutoEventWireup="true" CodeFile="userBook.aspx.cs" Inherits="userBook" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="text-align: center">
        <div style="text-align: center">
            <table border="0" cellpadding="0" cellspacing="0" style="width: 868px; height: 152px">
                <tr>
                    <td style="vertical-align: top; width: 140px; text-align: right">
                        <br />
                        <asp:TreeView ID="twtype" runat="server" OnSelectedNodeChanged="twtype_SelectedNodeChanged"
                            ShowLines="True" Style="vertical-align: middle; text-align: left" Width="134px">
                            <Nodes>
                                <asp:TreeNode Text="图书" Value="1">
                                    <asp:TreeNode Text="教育" Value="2">
                                        <asp:TreeNode Text="英语" Value="7"></asp:TreeNode>
                                        <asp:TreeNode Text="数学" Value="8"></asp:TreeNode>
                                        <asp:TreeNode Text="语文" Value="9"></asp:TreeNode>
                                        <asp:TreeNode Text="物理" Value="10"></asp:TreeNode>
                                        <asp:TreeNode Text="化学" Value="11"></asp:TreeNode>
                                        <asp:TreeNode Text="政治" Value="12"></asp:TreeNode>
                                    </asp:TreeNode>
                                    <asp:TreeNode Text="科技" Value="3">
                                        <asp:TreeNode Text="计算机" Value="13"></asp:TreeNode>
                                        <asp:TreeNode Text="天文" Value="14"></asp:TreeNode>
                                    </asp:TreeNode>
                                    <asp:TreeNode Text="文学" Value="4">
                                        <asp:TreeNode Text="散文" Value="15"></asp:TreeNode>
                                        <asp:TreeNode Text="小说" Value="16"></asp:TreeNode>
                                    </asp:TreeNode>
                                    <asp:TreeNode Text="考试资料" Value="5">
                                        <asp:TreeNode Text="考研资料" Value="17"></asp:TreeNode>
                                        <asp:TreeNode Text="英语四、六资料" Value="18"></asp:TreeNode> 
                                        <asp:TreeNode Text="计算机等级考试" Value="23"></asp:TreeNode>
                                    </asp:TreeNode>
                                    <asp:TreeNode Text="社会百科" Value="6">
                                        <asp:TreeNode Text="体育" Value="19"></asp:TreeNode>
                                        <asp:TreeNode Text="生物" Value="20"></asp:TreeNode>
                                        <asp:TreeNode Text="地理" Value="21"></asp:TreeNode>
                                        <asp:TreeNode Text="历史" Value="22"></asp:TreeNode>
                                    </asp:TreeNode>
                                </asp:TreeNode>
                            </Nodes>
                        </asp:TreeView>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
                            ConnectionString="<%$ ConnectionStrings:sqlBookshopConnectionString %>" DeleteCommand="DELETE FROM [tblBook] WHERE [bookID] = @original_bookID AND [typeID] = @original_typeID AND [bookName] = @original_bookName AND [bookAuthor] = @original_bookAuthor AND [bookPrice] = @original_bookPrice AND [publisher] = @original_publisher AND [publishDate] = @original_publishDate AND [bookImage] = @original_bookImage AND [IsSelling] = @original_IsSelling"
                            InsertCommand="INSERT INTO [tblBook] ([typeID], [bookName], [bookAuthor], [bookPrice], [publisher], [publishDate], [bookImage], [IsSelling]) VALUES (@typeID, @bookName, @bookAuthor, @bookPrice, @publisher, @publishDate, @bookImage, @IsSelling)"
                            OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [tblBook]"
                            UpdateCommand="UPDATE [tblBook] SET [typeID] = @typeID, [bookName] = @bookName, [bookAuthor] = @bookAuthor, [bookPrice] = @bookPrice, [publisher] = @publisher, [publishDate] = @publishDate, [bookImage] = @bookImage, [IsSelling] = @IsSelling WHERE [bookID] = @original_bookID AND [typeID] = @original_typeID AND [bookName] = @original_bookName AND [bookAuthor] = @original_bookAuthor AND [bookPrice] = @original_bookPrice AND [publisher] = @original_publisher AND [publishDate] = @original_publishDate AND [bookImage] = @original_bookImage AND [IsSelling] = @original_IsSelling">
                            <DeleteParameters>
                                <asp:Parameter Name="original_bookID" Type="Int32" />
                                <asp:Parameter Name="original_typeID" Type="Int32" />
                                <asp:Parameter Name="original_bookName" Type="String" />
                                <asp:Parameter Name="original_bookAuthor" Type="String" />
                                <asp:Parameter Name="original_bookPrice" Type="Decimal" />
                                <asp:Parameter Name="original_publisher" Type="String" />
                                <asp:Parameter Name="original_publishDate" Type="DateTime" />
                                <asp:Parameter Name="original_bookImage" Type="String" />
                                <asp:Parameter Name="original_IsSelling" Type="Boolean" />
                            </DeleteParameters>
                            <UpdateParameters>
                                <asp:Parameter Name="typeID" Type="Int32" />
                                <asp:Parameter Name="bookName" Type="String" />
                                <asp:Parameter Name="bookAuthor" Type="String" />
                                <asp:Parameter Name="bookPrice" Type="Decimal" />
                                <asp:Parameter Name="publisher" Type="String" />
                                <asp:Parameter Name="publishDate" Type="DateTime" />
                                <asp:Parameter Name="bookImage" Type="String" />
                                <asp:Parameter Name="IsSelling" Type="Boolean" />
                                <asp:Parameter Name="original_bookID" Type="Int32" />
                                <asp:Parameter Name="original_typeID" Type="Int32" />
                                <asp:Parameter Name="original_bookName" Type="String" />
                                <asp:Parameter Name="original_bookAuthor" Type="String" />
                                <asp:Parameter Name="original_bookPrice" Type="Decimal" />
                                <asp:Parameter Name="original_publisher" Type="String" />
                                <asp:Parameter Name="original_publishDate" Type="DateTime" />
                                <asp:Parameter Name="original_bookImage" Type="String" />
                                <asp:Parameter Name="original_IsSelling" Type="Boolean" />
                            </UpdateParameters>
                            <InsertParameters>
                                <asp:Parameter Name="typeID" Type="Int32" />
                                <asp:Parameter Name="bookName" Type="String" />
                                <asp:Parameter Name="bookAuthor" Type="String" />
                                <asp:Parameter Name="bookPrice" Type="Decimal" />
                                <asp:Parameter Name="publisher" Type="String" />
                                <asp:Parameter Name="publishDate" Type="DateTime" />
                                <asp:Parameter Name="bookImage" Type="String" />
                                <asp:Parameter Name="IsSelling" Type="Boolean" />
                            </InsertParameters>
                        </asp:SqlDataSource>
                    </td>
                    <td style="width: 538px">
                        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                            DataKeyNames="bookID" DataSourceID="SqlDataSource1" PageSize="3" Width="535px" OnRowCommand="GridView1_RowCommand">
                            <Columns>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <div style="text-align: left">
                                            <table border="0" cellpadding="0" cellspacing="0" style="width: 483px; height: 101px">
                                                <tr>
                                                    <td rowspan="4" style="width: 70px; text-align: center">
                                                        <asp:Image ID="Image2" runat="server" ImageUrl='<%# "~/picture/"+Eval("bookImage") %>' /></td>
                                                    <td style="width: 2px; height: 21px">
                                                    </td>
                                                    <td style="height: 21px" colspan="2">
                                                    书名:
                                                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("bookName") %>' Width="149px"></asp:Label></td>
                                                </tr>
                                                <tr>
                                                    <td style="width: 2px; height: 20px">
                                                    </td>
                                                    <td style="height: 20px" colspan="2">
                                                    作者:
                                                        <asp:Label ID="Label2" runat="server" Text='<%# Eval("bookAuthor") %>' Width="150px"></asp:Label></td>
                                                </tr>
                                                <tr>
                                                    <td style="width: 2px; height: 24px">
                                                    </td>
                                                    <td style="height: 24px" colspan="2">
                                                    价格:
                                                        <asp:Label ID="Label3" runat="server" Text='<%# Eval("bookPrice") %>' Width="151px"></asp:Label></td>
                                                </tr>
                                                <tr>
                                                    <td style="width: 2px">
                                                    </td>
                                                    <td colspan="2">
                                                        <asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl='<%# "bookinfo.aspx?bid="+Eval("bookID").ToString() %>'
                                                            Width="49px">详情</asp:HyperLink>&nbsp; &nbsp;<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# "speaking.aspx?bid="+Eval("bookID").ToString() %>' Width="51px">评论</asp:HyperLink>&nbsp; &nbsp;<asp:Button ID="Button1" runat="server" Text="加进购物车" CommandArgument='<%# Eval("bookID") %>' CommandName="add" /></td>
                                                </tr>
                                            </table>
                                        </div>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                        </asp:GridView>
                        <asp:Label ID="Label8" runat="server" ForeColor="Red" Text="对不起!没有你要找的书籍.或选择子节点."
                            Visible="False" Width="378px"></asp:Label></td>
                </tr>
            </table>
        </div>
    </div>
</asp:Content>