usermain.aspx

网上书店 含用户注册

<%@ Page Language="C#" MasterPageFile="~/UserPage.master" AutoEventWireup="true" CodeFile="userMain.aspx.cs" Inherits="userMain" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 899px; height: 238px">
        <tr>
            <td rowspan="2" style="vertical-align: top; width: 198px; height: 391px; text-align: right">
                <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>
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
            </td>
            <td colspan="2" rowspan="2" style="vertical-align: top; width: 806px; height: 391px;
                text-align: center">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    DataKeyNames="bookID" DataSourceID="SqlDataSource1" OnRowCommand="GridView1_RowCommand"
                    PageSize="3" Width="663px">
                    <PagerSettings Mode="NumericFirstLast" />
                    <Columns>
                        <asp:TemplateField>
                            <ItemTemplate>
                                <div style="text-align: left">
                                    <table border="0" cellpadding="0" cellspacing="0" style="width: 483px; height: 86px">
                                        <tr>
                                            <td rowspan="4" style="width: 49px; text-align: center">
                                                <asp:Image ID="Image2" runat="server" ImageUrl='<%# "~/picture/"+Eval("bookImage") %>' /></td>
                                            <td style="width: 54px; height: 21px">
                                            书名:</td>
                                            <td colspan="2" style="height: 21px">
                                                <asp:Label ID="Label1" runat="server" Text='<%# Eval("bookName") %>' Width="231px"></asp:Label></td>
                                        </tr>
                                        <tr>
                                            <td style="width: 54px; height: 20px">
                                            作者:</td>
                                            <td colspan="2" style="height: 20px">
                                                <asp:Label ID="Label2" runat="server" Text='<%# Eval("bookAuthor") %>' Width="230px"></asp:Label></td>
                                        </tr>
                                        <tr>
                                            <td style="width: 54px; height: 24px">
                                            价格:</td>
                                            <td colspan="2" style="height: 24px">
                                                <asp:Label ID="Label3" runat="server" Text='<%# Eval("bookPrice") %>' Width="234px"></asp:Label></td>
                                        </tr>
                                        <tr>
                                            <td style="width: 54px">
                                                <asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl='<%# "bookinfo.aspx?bid="+Eval("bookID").ToString() %>'
                                                    Width="49px">详情</asp:HyperLink></td>
                                            <td colspan="2">
                                                <asp:HyperLink ID="HyperLink3" runat="server" NavigateUrl='<%# "Reviews.aspx?bid="+Eval("bookID").ToString() %>'
                                                    Width="36px">评论</asp:HyperLink>
                                                &nbsp; &nbsp;
                                                <asp:Button ID="Button1" runat="server" CommandArgument='<%# Eval("bookID") %>' CommandName="add"
                                                    Text="查看电子书" /></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>
        <tr>
        </tr>
    </table>
</asp:Content>