⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 supplycompany.aspx

📁 课程设计了
💻 ASPX
字号:
🔍 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SupplyCompany.aspx.cs" Inherits="SupplyMag_SupplyCompany" %>

<!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 runat="server">
    <title>无标题页</title>
    <link href="../style/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
            BorderWidth="1px" CellPadding="3" DataKeyNames="SupplyId" DataSourceID="SqlDataSource1"
            GridLines="Vertical" Width="650px">
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <Columns>

                <asp:BoundField DataField="SupplyId" HeaderText="供应商编号" InsertVisible="False"
                    ReadOnly="True" SortExpression="SupplyId" />
                <asp:BoundField DataField="SupplyCompanyName" HeaderText="名称" SortExpression="SupplyCompanyName" />
                <asp:BoundField DataField="SupplyManager" HeaderText="联系人" SortExpression="SupplyManager" />
                <asp:BoundField DataField="SupplyAddress" HeaderText="供应商地址" SortExpression="SupplyAddress" />
                <asp:BoundField DataField="SupplyInfo" HeaderText="备注信息" SortExpression="SupplyInfo" />
               
                                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" HeaderText="操作" />
            </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" />
            <AlternatingRowStyle BackColor="Gainsboro" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>" DeleteCommand="DELETE FROM [SupplyCompany] WHERE [SupplyId] = @original_SupplyId AND [SupplyCompanyName] = @original_SupplyCompanyName AND [SupplyManager] = @original_SupplyManager AND [SupplyAddress] = @original_SupplyAddress AND [SupplyInfo] = @original_SupplyInfo"
            InsertCommand="INSERT INTO [SupplyCompany] ([SupplyCompanyName], [SupplyManager], [SupplyAddress], [SupplyInfo]) VALUES (@SupplyCompanyName, @SupplyManager, @SupplyAddress, @SupplyInfo)"
            OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [SupplyCompany]"
            UpdateCommand="UPDATE [SupplyCompany] SET [SupplyCompanyName] = @SupplyCompanyName, [SupplyManager] = @SupplyManager, [SupplyAddress] = @SupplyAddress, [SupplyInfo] = @SupplyInfo WHERE [SupplyId] = @original_SupplyId AND [SupplyCompanyName] = @original_SupplyCompanyName AND [SupplyManager] = @original_SupplyManager AND [SupplyAddress] = @original_SupplyAddress AND [SupplyInfo] = @original_SupplyInfo">
            <DeleteParameters>
                <asp:Parameter Name="original_SupplyId" Type="Int32" />
                <asp:Parameter Name="original_SupplyCompanyName" Type="String" />
                <asp:Parameter Name="original_SupplyManager" Type="String" />
                <asp:Parameter Name="original_SupplyAddress" Type="String" />
                <asp:Parameter Name="original_SupplyInfo" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="SupplyCompanyName" Type="String" />
                <asp:Parameter Name="SupplyManager" Type="String" />
                <asp:Parameter Name="SupplyAddress" Type="String" />
                <asp:Parameter Name="SupplyInfo" Type="String" />
                <asp:Parameter Name="original_SupplyId" Type="Int32" />
                <asp:Parameter Name="original_SupplyCompanyName" Type="String" />
                <asp:Parameter Name="original_SupplyManager" Type="String" />
                <asp:Parameter Name="original_SupplyAddress" Type="String" />
                <asp:Parameter Name="original_SupplyInfo" Type="String" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="SupplyCompanyName" Type="String" />
                <asp:Parameter Name="SupplyManager" Type="String" />
                <asp:Parameter Name="SupplyAddress" Type="String" />
                <asp:Parameter Name="SupplyInfo" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
        &nbsp;<br />
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" BackColor="White"
            BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="SupplyId"
            DataSourceID="SqlDataSource1" DefaultMode="Insert" Height="50px" Width="474px">
            <FooterStyle BackColor="White" ForeColor="#000066" />
            <EditRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
            <RowStyle ForeColor="#000066" />
            <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
            <Fields>
           
                <asp:BoundField DataField="SupplyCompanyName" HeaderText="供应商姓名" SortExpression="SupplyCompanyName" />
                <asp:BoundField DataField="SupplyManager" HeaderText="联系人" SortExpression="SupplyManager" />
                <asp:BoundField DataField="SupplyAddress" HeaderText="供应商地址" SortExpression="SupplyAddress" />
                <asp:BoundField DataField="SupplyInfo" HeaderText="备注信息" SortExpression="SupplyInfo" />
                <asp:CommandField ShowInsertButton="True" />
            </Fields>
            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
        </asp:DetailsView>
    
    </div>
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -