editsell.aspx

来自「一个简单的信息系统 系统用户管理 编辑系统用户 新增系统用户」· ASPX 代码 · 共 29 行

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="editsell.aspx.cs" Inherits="editsell" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" BackColor="White" BorderColor="#336666" BorderStyle="Double"
        BorderWidth="3px" CellPadding="4" DataKeyNames="id" DataSourceID="SqlDataSource1"
        GridLines="Horizontal" Width="522px">
        <FooterStyle BackColor="White" ForeColor="#333333" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            <asp:BoundField DataField="id" HeaderText="编号" InsertVisible="False" ReadOnly="True"
                SortExpression="id" />
            <asp:BoundField DataField="compact_id" HeaderText="合同编号" SortExpression="compact_id" />
            <asp:BoundField DataField="product_id" HeaderText="产品编号" SortExpression="product_id" />
            <asp:BoundField DataField="product_num" HeaderText="总订单数" SortExpression="product_num" />
            <asp:BoundField DataField="product_send" HeaderText="已发货数" SortExpression="product_send" />
            <asp:BoundField DataField="price" HeaderText="已收金额" SortExpression="price" />
        </Columns>
        <RowStyle BackColor="White" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:clientmanageConnectionString %>"
        DeleteCommand="DELETE FROM sell where id=@id" SelectCommand="SELECT * FROM [sell]"
        UpdateCommand="update sell set compact_id=@compact_id,product_id=@product_id,product_num=@product_num,product_send=@product_send,price=CONVERT(money,@price) where id=@id">
    </asp:SqlDataSource>
</asp:Content>