order_list.aspx.cs

完成一个网上书店系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class Order_List : System.Web.UI.Page
{
    Class1 db = new Class1();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            for (int i = 1; i < GridView1.Columns.Count; i++)
            {//循环所有的列
                DropDownList2.Items.Add(i.ToString());
            }
            Bind();

            //返回上一页
            if (Request.UrlReferrer != null)
                ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
        }
       
    }
    protected void Bind()
    {
        int uid = Convert.ToInt32(Session["UserID"]);//不能放在Page_Load之外，原因好像是静态问题
        GridView1.DataSource = db.createdataset("select * from Orders where UserID=" + uid+"");
        GridView1.DataBind();

        if (GridView1.PageIndex == 0)
        {
            Button7.Enabled = false;
            Button6.Enabled = false;
        }
        else
        {
            Button7.Enabled = true;
            Button6.Enabled = true;
        }
        if (GridView1.PageIndex == GridView1.PageCount-1)
        {
            Button8.Enabled = false;
            Button7.Enabled = false;
        }
        else
        {
            Button8.Enabled = true;
            Button7.Enabled = true;
        }
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //含有特定值的行改变样式
    }
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //判断当前是数据行
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00ffee';");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
        }

    }
    protected void Button2_Click(object sender, EventArgs e)
    {   //隐藏选定的列
        int columns = Convert.ToInt32(DropDownList2.SelectedValue)-1;
        //得到当前正确的列数
        GridView1.Columns[columns].Visible = false;

        //隐藏选定的行
        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
        {
            CheckBox chk = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (chk.Checked)
            {
                GridView1.Rows[i].Visible = false;
            }
        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        //显示全部的列
        for (int i = 0; i < GridView1.Columns.Count;i++ )
        {
            GridView1.Columns[i].Visible = true;
            
        }
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        //删除选定的列
       // foreach (GridViewRow gr in GridView1.Rows)
        for (int i = 0; i <= GridView1.Rows.Count - 1;i++ )
        {
            CheckBox chk = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (chk.Checked)
            {
                //查ID，删除，数据库中实现级联删除操作
                String str = "delete from Orders where OrderID=" + GridView1.DataKeys[i].Value + "";
                //应该设置Datakeynames为OrderID
                db.ExecSql(str); 
                Bind();
            }
        }
    }
    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        foreach(GridViewRow gr in GridView1.Rows)
        {
            //在GridView1的所有行中执行迭代
            CheckBox chk = (CheckBox)gr.Cells[3].FindControl("CheckBox1");
            //找到CheckBox1控件
            if (!chk.Checked)
            {//如果没有选中，就选中它
                chk.Checked = true;
            }
            else {
                chk.Checked = false;
            }
        }
    }
    protected void Button5_Click(object sender, EventArgs e)
    {
        //实现分页
        switch (((Button)sender).CommandArgument.ToString())
        {
            case "first":
                GridView1.PageIndex = 0; break;
            case "last":
                GridView1.PageIndex = GridView1.PageCount - 1; break;
            case "prev":
                GridView1.PageIndex = GridView1.PageIndex - 1; break;
            case "next":
                GridView1.PageIndex = GridView1.PageIndex + 1; break;
        }
        Bind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        //进入编辑模式
        GridView1.EditIndex = e.NewEditIndex;
        Bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        //编辑动作

    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        //canel事件
        GridView1.EditIndex = -1;
        Bind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //删除事件
    }
    protected void Button9_Click(object sender, EventArgs e)
    {
        //返回上一页
        Response.Redirect(ViewState["UrlReferrer"].ToString());
    }
}