booklibraryform.aspx

基于C#和MYSQL的图书管理系统

<%--文件名：BookLibraryForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="BookLibraryForm.aspx.cs" Inherits="BookManage_BookLibraryForm" Title="当前位置：图书管理->馆藏图书管理"%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 556px; height: 161px">
        <tr>
            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
                background-color: darkturquoise">
                &nbsp;请输入需要查询图书的名称：<asp:TextBox ID="TextBox1" runat="server" Width="134px">%%</asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="查询" Width="70px" />
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="新增" Width="70px" />
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="修改" Width="70px" /></td>
        </tr>
        <tr>
            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 27px;
                background-color: palegoldenrod">
                &nbsp;书号：<asp:TextBox ID="TextBox2" runat="server" Width="136px">X</asp:TextBox>
                书名：<asp:TextBox ID="TextBox3" runat="server" Width="306px">X</asp:TextBox>&nbsp;<br />
                &nbsp;作者：<asp:TextBox ID="TextBox4" runat="server" Width="53px">X</asp:TextBox>
                出版公司(社)：<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
                    DataTextField="公司名称" DataValueField="公司编号" Width="121px" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                </asp:DropDownList>
                类别：<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
                    DataTextField="类别名称" DataValueField="类别名称" Width="175px">
                </asp:DropDownList>
                <br />
                &nbsp;版次：<asp:TextBox ID="TextBox7" runat="server" Width="155px">X</asp:TextBox>
                规格：<asp:TextBox ID="TextBox8" runat="server" Width="101px">X</asp:TextBox>
                印数：<asp:TextBox ID="TextBox9" runat="server" Width="51px">0</asp:TextBox>
                页数：<asp:TextBox ID="TextBox10" runat="server" Width="31px">0</asp:TextBox><br />
                &nbsp;单价：<asp:TextBox ID="TextBox11" runat="server" Width="29px">0</asp:TextBox>
                &nbsp;所属丛书：<asp:TextBox ID="TextBox12" runat="server" Width="144px">X</asp:TextBox>
                入库日期：<asp:TextBox ID="TextBox13" runat="server" Width="54px">2007-1-1</asp:TextBox>
                入库数量：<asp:TextBox ID="TextBox14" runat="server" Width="31px">0</asp:TextBox><br />
                &nbsp;出借数量：<asp:TextBox ID="TextBox15" runat="server" Width="44px" BackColor="#E0E0E0" ReadOnly="True">0</asp:TextBox>
                遗失数量：<asp:TextBox ID="TextBox16" runat="server" Width="53px" BackColor="#E0E0E0" ReadOnly="True">0</asp:TextBox>
                存放位置：<asp:TextBox ID="TextBox17" runat="server" Width="214px">X</asp:TextBox><br />
                &nbsp;补充说明：<asp:TextBox ID="TextBox18" runat="server" Width="467px">暂无</asp:TextBox>&nbsp;</td>
        </tr>
        <tr>
            <td style="width: 2232px; height: 100px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="200px" ScrollBars="Auto" Width="553px">
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyBooksDBConnectionString %>"
                        SelectCommand="SELECT * FROM [出版公司] ORDER BY [公司名称]"></asp:SqlDataSource>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyBooksDBConnectionString %>"
                        SelectCommand="SELECT * FROM [图书类别] ORDER BY [类别名称]"></asp:SqlDataSource>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MyBooksDBConnectionString %>"
                        DeleteCommand="DELETE FROM [馆藏图书] WHERE [图书书号] = @图书书号" 
                        InsertCommand="INSERT INTO [馆藏图书] ([图书书号], [图书书名], [图书作者], [出版公司], [图书类别], [图书版次], [图书规格], [图书印数], [图书页数], [图书单价], [所属丛书], [入库日期], [入库数量], [出借数量], [遗失数量], [存放位置], [补充说明]) VALUES (@图书书号, @图书书名, @图书作者, @出版公司, @图书类别, @图书版次, @图书规格, @图书印数, @图书页数, @图书单价, @所属丛书, @入库日期, @入库数量, @出借数量, @遗失数量,@存放位置, @补充说明)"
                        SelectCommand="SELECT * FROM [馆藏图书] WHERE ([图书书名] LIKE '%' + @图书书名 + '%')" 
                        UpdateCommand="UPDATE [馆藏图书] SET [图书书名] = @图书书名, [图书作者] = @图书作者, [出版公司] = @出版公司, [图书类别] = @图书类别, [图书版次] = @图书版次, [图书规格] = @图书规格, [图书印数] = @图书印数, [图书页数] = @图书页数, [图书单价] = @图书单价, [所属丛书] = @所属丛书, [入库日期] = @入库日期, [入库数量] = @入库数量, [出借数量] = @出借数量, [遗失数量] = @遗失数量, [存放位置] = @存放位置, [补充说明] = @补充说明 WHERE [图书书号] = @图书书号">
                        <DeleteParameters>
                            <asp:Parameter Name="图书书号" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:ControlParameter ControlID="TextBox3" Name="图书书名" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox4" Name="图书作者" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList1" Name="出版公司" PropertyName="SelectedItem.Text"
                                Type="String" />
                            <asp:ControlParameter ControlID="DropDownList2" Name="图书类别" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox7" Name="图书版次" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox8" Name="图书规格" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox9" Name="图书印数" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox10" Name="图书页数" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox11" Name="图书单价" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox12" Name="所属丛书" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox13" Name="入库日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox14" Name="入库数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox15" Name="出借数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox16" Name="遗失数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox17" Name="存放位置" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox18" Name="补充说明" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox2" Name="图书书号" PropertyName="Text" Type="String" />
                        </UpdateParameters>
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox1" Name="图书书名" PropertyName="Text" Type="String" />
                        </SelectParameters>
                        <InsertParameters>
                            <asp:ControlParameter ControlID="TextBox2" Name="图书书号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox3" Name="图书书名" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox4" Name="图书作者" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList1" Name="出版公司" PropertyName="SelectedItem.Text"
                                Type="String" />
                            <asp:ControlParameter ControlID="DropDownList2" Name="图书类别" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox7" Name="图书版次" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox8" Name="图书规格" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox9" Name="图书印数" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox10" Name="图书页数" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox11" Name="图书单价" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox12" Name="所属丛书" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox13" Name="入库日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox14" Name="入库数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox15" Name="出借数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox16" Name="遗失数量" PropertyName="Text" Type="Int32" />
                            <asp:Parameter Name="库存数量" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox17" Name="存放位置" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox18" Name="补充说明" PropertyName="Text" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="图书书号"
                        DataSourceID="SqlDataSource3" Font-Names="宋体" Font-Size="Small" GridLines="Vertical"
                        OnRowCreated="GridView1_RowCreated" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
                        Width="2500px">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
                            <asp:TemplateField HeaderText="删除" ShowHeader="False">
                                <ItemTemplate>
                                    <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
                                        Text="删除" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="图书书号" HeaderText="图书书号" ReadOnly="True" SortExpression="图书书号" />
                            <asp:BoundField DataField="图书书名" HeaderText="图书书名" SortExpression="图书书名" />
                            <asp:BoundField DataField="图书作者" HeaderText="图书作者" SortExpression="图书作者" />
                            <asp:BoundField DataField="出版公司" HeaderText="出版公司" SortExpression="出版公司" />
                            <asp:BoundField DataField="图书类别" HeaderText="图书类别" SortExpression="图书类别" />
                            <asp:BoundField DataField="图书版次" HeaderText="图书版次" SortExpression="图书版次" />
                            <asp:BoundField DataField="图书规格" HeaderText="图书规格" SortExpression="图书规格" />
                            <asp:BoundField DataField="图书印数" HeaderText="图书印数" SortExpression="图书印数" />
                            <asp:BoundField DataField="图书页数" HeaderText="图书页数" SortExpression="图书页数" />
                            <asp:BoundField DataField="图书单价" HeaderText="图书单价" SortExpression="图书单价" />
                            <asp:BoundField DataField="所属丛书" HeaderText="所属丛书" SortExpression="所属丛书" />
                            <asp:BoundField DataField="入库日期" HeaderText="入库日期" SortExpression="入库日期" />
                            <asp:BoundField DataField="入库数量" HeaderText="入库数量" SortExpression="入库数量" />
                            <asp:BoundField DataField="出借数量" HeaderText="出借数量" SortExpression="出借数量" />
                            <asp:BoundField DataField="遗失数量" HeaderText="遗失数量" SortExpression="遗失数量" />
                            <asp:BoundField DataField="库存数量" HeaderText="库存数量" ReadOnly="True" SortExpression="库存数量" />
                            <asp:BoundField DataField="存放位置" HeaderText="存放位置" SortExpression="存放位置" />
                            <asp:BoundField DataField="补充说明" HeaderText="补充说明" SortExpression="补充说明" />
                        </Columns>
                        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>