订单管理页面

 <asp:GridView ID="GridView1" runat="server" AllowPaging="true" AutoGenerateColumns="false"
             BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" 
             CellPadding="4" DataKeyNames="流水号" Height="87px" HorizontalAlign="Center"
             OnPageIndexChanging="GridView1_PageIndexChanging"
             OnRowCancelingEdit="GridView1_RowCancelingEdit"
             OnRowDeleting="GridView1_RowDeleting"
             OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"
             PageSize="6" Width="637px">
            <PagerSettings  FirstPageText="" LastPageText="" Mode="NextPrevious" 
                 NextPageText="下一页" PreviousPageText="上一页" PageButtonCount="6"/>
            <Columns>
                <asp:BoundField  DataField="产品流水号" HeaderText="产品号" ReadOnly="true"/>
                 <asp:BoundField  DataField="用户名" HeaderText="用户名" ReadOnly="true"/>
                 <asp:BoundField  DataField="订购数量" HeaderText="订购数量" ReadOnly="true"/>
                 <asp:BoundField  DataField="订购日期" HeaderText="订购日期" ReadOnly="true"/>
                <asp:TemplateField HeaderText="处理标志">
                    <EditItemTemplate>&nbsp;<asp:CheckBox ID="CheckBox1" runat="server" />
                    </EditItemTemplate>
                    <!--用EditItemTemplate添加一个复选按钮-->
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox1" runat="server"  Checked='<%#Bind("处理标志") %>' Enabled="false" />
                    </ItemTemplate>
                    <!--用模板绑定     处理标志-->
                </asp:TemplateField>
                <asp:CommandField ShowEditButton="true" /><!--添加   编辑按钮-->
                <asp:CommandField ShowCancelButton="false" ShowDeleteButton="true" />
                <!--添加    删除按钮-->
            </Columns>
            <SelectedRowStyle  BackColor="#FFCC66" Font-Bold="true" ForeColor="#663399"/>
            <PagerStyle  BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center"/>
            <HeaderStyle BackColor="#990000" Font-Bold="true" ForeColor="#FFFFCC" />

        </asp:GridView>

public partial class delorder : System.Web.UI.Page
{//创建 BaseClass对象，以便引用
    BaseClass ba = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        bindgrig();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {//当点击上一页或下一页时触发
        GridView1.PageIndex = e.NewPageIndex;
        bindgrig();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {//在编辑状态下，点击   取消按钮
        GridView1.EditIndex = -1;
        bindgrig();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {//删除选中的数据
        String strsql = "delete from 订单表 where =" + GridView1.DataKeys[e.RowIndex].Value.ToString()+"";
        ba.execsql(strsql);
        bindgrig();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {//当点击编辑时，触发事件 
        GridView1.EditIndex = e.NewEditIndex;
        bindgrig();
    }
   
    void bindgrig()
    {
        string strsql = "select * from 订单表 order by 流水号 desc";
        DataTable dt = ba.readtable(strsql);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }


    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string str;
        CheckBox ck = (CheckBox)GridView1.Rows[e.RowIndex].FindControl("CheckBox1");
        //在编辑状态下获取CheckBox1的值
        if (ck.Checked == true)
        {
            str = "1";
        }
        else
        {
            str = "0";
        }
        String strsql = "update 订单表 set 处理标志=" + str + "where 流水号=" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "";
        ba.execsql(strsql);
        GridView1.EditIndex = -1;
        bindgrig();
        //当str等于1时更新并返回
    }
}