adminkucun.aspx

用c# asp.net 编写b/s模式的管理系统

                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues"
                    ConnectionString="<%$ ConnectionStrings:mmConnectionString %>" DeleteCommand="DELETE FROM [在用办公用品] WHERE [领用时间] = @original_领用时间 AND [名称] = @original_名称 AND [类别] = @original_类别 AND [数量] = @original_数量 AND [领用人] = @original_领用人"
                    InsertCommand="INSERT INTO [在用办公用品] ([名称], [类别], [数量], [领用人], [领用时间]) VALUES (@名称, @类别, @数量, @领用人, @领用时间)"
                    OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [名称], [类别], [数量], [领用人], [领用时间] FROM [在用办公用品]"
                    UpdateCommand="UPDATE [在用办公用品] SET [名称] = @名称, [类别] = @类别, [数量] = @数量, [领用人] = @领用人 WHERE [领用时间] = @original_领用时间 AND [名称] = @original_名称 AND [类别] = @original_类别 AND [数量] = @original_数量 AND [领用人] = @original_领用人">
                    <DeleteParameters>
                        <asp:Parameter Name="original_领用时间" Type="String" />
                        <asp:Parameter Name="original_名称" Type="String" />
                        <asp:Parameter Name="original_类别" Type="String" />
                        <asp:Parameter Name="original_数量" Type="String" />
                        <asp:Parameter Name="original_领用人" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="名称" Type="String" />
                        <asp:Parameter Name="类别" Type="String" />
                        <asp:Parameter Name="数量" Type="String" />
                        <asp:Parameter Name="领用人" Type="String" />
                        <asp:Parameter Name="original_领用时间" Type="String" />
                        <asp:Parameter Name="original_名称" Type="String" />
                        <asp:Parameter Name="original_类别" Type="String" />
                        <asp:Parameter Name="original_数量" Type="String" />
                        <asp:Parameter Name="original_领用人" Type="String" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="名称" Type="String" />
                        <asp:Parameter Name="类别" Type="String" />
                        <asp:Parameter Name="数量" Type="String" />
                        <asp:Parameter Name="领用人" Type="String" />
                        <asp:Parameter Name="领用时间" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
            </div>
            <asp:Label ID="Label2" runat="server" Font-Names="方正行楷简体" Font-Size="Large" Style="left: 209px;
                position: absolute; top: 33px" Text="【领用记录管理】"></asp:Label>
        </div>
        <div style="border-top: black thin solid; z-index: 104; left: 585px; width: 348px;
            border-bottom: black thin solid; position: absolute; top: 72px; height: 220px">
            <asp:Label ID="Label3" runat="server" Font-Names="方正行楷简体" Style="left: 21px; position: absolute;
                top: 52px" Text="名称:"></asp:Label>
            <asp:TextBox ID="TextBox1" runat="server" Style="left: 61px; position: absolute;
                top: 51px" Width="118px"></asp:TextBox>
            <asp:Label ID="Label4" runat="server" Font-Names="方正行楷简体" Style="left: 21px; position: absolute;
                top: 98px" Text="类别:"></asp:Label>
            &nbsp;
            <asp:Label ID="Label5" runat="server" Font-Names="方正行楷简体" Style="left: 21px; position: absolute;
                top: 144px" Text="数量:"></asp:Label>
            <asp:TextBox ID="TextBox3" runat="server" Style="left: 61px; position: absolute;
                top: 143px" Width="57px"></asp:TextBox>
            <asp:Label ID="Label6" runat="server" Font-Names="方正行楷简体" Style="left: 23px; position: absolute;
                top: 9px" Text="添加办公用品"></asp:Label>
            <asp:Button ID="Button2" runat="server" Font-Names="方正行楷简体" Height="29px" OnClick="Button2_Click"
                Style="left: 43px; position: absolute; top: 179px" Text="添加" ValidationGroup="tianjia"
                Width="63px" />
            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                ErrorMessage="名称不能为空" Style="left: 208px; position: absolute; top: 55px" ValidationGroup="tianjia"></asp:RequiredFieldValidator>
            &nbsp;
            <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3"
                ErrorMessage="数量不能为空" Style="left: 137px; position: absolute; top: 141px" ValidationGroup="tianjia"></asp:RequiredFieldValidator>
            &nbsp;
            <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource3"
                DataTextField="类名" DataValueField="类名" Style="left: 64px; position: absolute;
                top: 97px" Width="96px">
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:mmConnectionString %>"
                SelectCommand="SELECT [类名] FROM [类别]"></asp:SqlDataSource>
            <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox3"
                ErrorMessage=" 数量必为整数" Style="left: 129px; position: absolute; top: 185px" ValidationExpression="^[0-9]*[1-9][0-9]*$"
                ValidationGroup="tianjia"></asp:RegularExpressionValidator>
        </div>
        <div style="z-index: 105; left: 585px; width: 350px; border-bottom: black thin solid;
            position: absolute; top: 308px; height: 217px">
            <asp:Label ID="Label9" runat="server" Font-Names="方正行楷简体" Style="left: 22px; position: absolute;
                top: 9px" Text="物品领用"></asp:Label>
            <asp:Label ID="Label10" runat="server" Font-Names="方正行楷简体" Style="left: 25px; position: absolute;
                top: 45px" Text="名称:"></asp:Label>
            <asp:TextBox ID="TextBox4" runat="server" Style="left: 65px; position: absolute;
                top: 45px" Width="112px"></asp:TextBox>
            <asp:Label ID="Label11" runat="server" Font-Names="方正行楷简体" Style="left: 25px; position: absolute;
                top: 84px" Text="数量:"></asp:Label>
            <asp:TextBox ID="TextBox5" runat="server" Style="left: 65px; position: absolute;
                top: 83px" Width="38px"></asp:TextBox>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox4"
                ErrorMessage="请填写名称" Style="left: 209px; position: absolute; top: 47px" ValidationGroup="lingqu"></asp:RequiredFieldValidator>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox5"
                ErrorMessage="请填写数量" Style="left: 137px; position: relative; top: 83px" ValidationGroup="lingqu"></asp:RequiredFieldValidator>
            <asp:Label ID="Label12" runat="server" Font-Names="方正行楷简体" Style="left: 9px; position: absolute;
                top: 123px" Text="领用人:"></asp:Label>
            <asp:TextBox ID="TextBox6" runat="server" Style="left: 65px; position: absolute;
                top: 122px" Width="106px"></asp:TextBox>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox6"
                ErrorMessage="请填写领取人" Style="left: 198px; position: absolute; top: 124px" ValidationGroup="lingqu"></asp:RequiredFieldValidator>
            <asp:Button ID="Button3" runat="server" Font-Names="方正行楷简体" Height="28px" Style="left: 44px;
                position: absolute; top: 166px" Text="确认领取" ValidationGroup="lingqu" Width="84px" OnClick="Button3_Click" />
            <asp:Label ID="Label13" runat="server" Style="left: 148px; position: absolute; top: 172px"
                Width="140px" ForeColor="Red"></asp:Label>
        </div>
        <div style="z-index: 106; left: 34px; width: 923px; border-bottom: black thin solid;
            position: absolute; top: 10px; height: 43px">
            <asp:HyperLink ID="HyperLink1" runat="server" Style="left: 765px; position: absolute;
                top: 11px" Width="100px">HyperLink</asp:HyperLink>
        </div>
    
    </div>
    </form>
</body>
</html>