test13.aspx.cs

互联网程序设计的课程

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Sql;
using System.Data.SqlClient;
using DBClass;
using System.Xml;
using System.Text;
using System.Drawing;
using System.IO;
using System.Web.SessionState;   
public partial class backup_test13 : System.Web.UI.Page
{
    DB db = new DB();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["SortOrder"] = "ZhouQH";
            ViewState["OrderDire"] = "ASC";
            BindMaterial();
           
        }
    }

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        //设定排序顺序为：
        string sPage = e.SortExpression;
        if (ViewState["SortOrder"].ToString() == sPage)
        {
            if (ViewState["OrderDire"].ToString() == "Desc")
                ViewState["OrderDire"] = "ASC";
            else
                ViewState["OrderDire"] = "Desc";
        }
        else
        {
            ViewState["SortOrder"] = e.SortExpression;
        }
        BindMaterial();
    }


    //绑定清单
    public void BindMaterial()
    {

        string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
        string strcmd = "select * from ZhouQinfo order by " + sort;
       db.BindGridView(strcmd, gvtest);
        //b绑定的时候，突出某些不满足条件的显示为红色
       
       




        for (int i = 0; i <= gvtest.Rows.Count - 1; i++)
        {
            int ts = Convert.ToInt32(gvtest.Rows[i].Cells[2].Text);

            if (ts <= 10)
            {
                gvtest.Rows[i].Cells[2].BackColor = System.Drawing.Color.Red;

            }
        }




    }




   




    protected void gvtest_PageIndexChanging(object source, System.Web.UI.WebControls.GridViewPageEventArgs e)
    {
        gvtest.PageIndex = e.NewPageIndex;
        BindMaterial();
      
    }















}