test.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 registe_MaterialRecord : 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();
            IsFirstLastPage();
        }
    }

    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[3].Text);

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

            }
        }




    }



//隐藏gridview，即要导出的data的绑定
public void Binddc()
    {
        DataSet ds = new DataSet("ds_dry");//创建一个名为ds_dry的DataSet

        DataTable dt = new DataTable("dt_dry");//创建一个名为dt_dry的DataTalbe

       
        dt.Columns.Add(new DataColumn("lx", typeof(string)));
        dt.Columns.Add(new DataColumn("ts", typeof(string)));
        dt.Columns.Add(new DataColumn("yy", typeof(string)));
        dt.Columns.Add(new DataColumn("sj", typeof(string)));//因为是要导出，可以全部设定为string



        for (int i = 0; i <= gvtest.Rows.Count - 1; i++)
        {

            CheckBox cbox = (CheckBox)gvtest.Rows[i].FindControl("cbxCheck");
           if (cbox.Checked == true)
           {

               DataRow dr = dt.NewRow();//注意这边创建dt的新行的方法。指定类型是DataRow而不是TableRow，然后不用new直接的用创建的DataTable下面的NewRow方法。
               if (gvtest.Rows[i].Cells[2].Text.Trim() == "" || gvtest.Rows[i].Cells[2].Text is DBNull )
               {
                   dr["lx"] = " ";
                  
               }
               else {  dr["lx"] = gvtest.Rows[i].Cells[2].Text.Trim();}

               if (gvtest.Rows[i].Cells[3].Text.Trim() == "" || gvtest.Rows[i].Cells[3].Text is DBNull)
               {
                   dr["ts"] = " ";

               }
               else { dr["ts"] = gvtest.Rows[i].Cells[3].Text.Trim(); }


               if (gvtest.Rows[i].Cells[5].Text.Trim() == "" || gvtest.Rows[i].Cells[5].Text is DBNull)
               {
                   dr["yy"] = " ";

               }
               else { dr["yy"] = gvtest.Rows[i].Cells[5].Text.Trim(); }

               if (gvtest.Rows[i].Cells[4].Text.Trim() == "" || gvtest.Rows[i].Cells[4].Text is DBNull)
               {
                   dr["sj"] = " ";

               }
               else { dr["sj"] = gvtest.Rows[i].Cells[4].Text.Trim(); } 
            
               dt.Rows.Add(dr);  
               
           }

        }
//把要导出的data插入gvdc

       
      ds.Tables.Add(dt);
        gvdc.DataSource = ds;
        gvdc.DataBind();



}







    protected void ibtnCalendar_Click(object sender, ImageClickEventArgs e)
    {
        if (this.pCalendar .Visible == false )
        {
            this.pCalendar .Visible = true ;
        }
        else if (this .pCalendar .Visible ==true  )
        {
            this .pCalendar .Visible =false  ;
        }
    }
   //选择日期 
    protected void Calendar_SelectionChanged(object sender, EventArgs e)
    {
        this.tbxCalendar.Text = this.Calendar.SelectedDate.ToShortDateString();
        this.pCalendar.Visible = false;
    }
    //清单导出
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        Binddc();
        Export("application/ms-excel", "周期信息.xls");
    }

    private void Export(string FileType, string FileName)
    {
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        gvdc.RenderControl(hw);
        //导出隐藏gridview的信息
        Response.Write(tw.ToString());
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
    }
   

     protected void PageCut_Click(object sender, EventArgs e)
    {
        String commangArg = ((LinkButton)sender).CommandArgument;

        switch (commangArg)
        {
            case "First":
                {
                    gvtest.PageIndex = 0;
                    break;
                }
            case "Prev":
                {
                    gvtest.PageIndex = (int)Math.Max(0, gvtest.PageIndex - 1);
                    break;
                }
            case "Next":
                {
                    gvtest.PageIndex = (int)Math.Min(gvtest.PageCount - 1, gvtest.PageIndex + 1);
                    break;
                }
            case "Last":
                {
                    gvtest.PageIndex = gvtest.PageCount - 1;
                    break;
                }
            default:
                {
                    break;
                }
        }
        BindMaterial();;
        IsFirstLastPage();

    }

    private void IsFirstLastPage()
    {
        if (gvtest.PageCount > 0)
        {
            if (gvtest.PageCount != 1)
            {
                if (gvtest.PageIndex == 0)
                {
                    LinkButton2.Enabled = false;
                }
                else
                {
                    LinkButton2.Enabled = true;
                }
                if (gvtest.PageIndex == gvtest.PageCount - 1)
                {
                    LinkButton3.Enabled = false;
                }
                else
                {
                    LinkButton3.Enabled = true;
                }
            }
            else
            {
                LinkButton2.Enabled = false;
                LinkButton3.Enabled = false;
            }
        }
        else
        {
            LinkButton1.Enabled = false;
            LinkButton2.Enabled = false;
            LinkButton3.Enabled = false;
            LinkButton4.Enabled = false;
        }

    }





    //打印材料清单
    protected void btnPrint_Click(object sender, EventArgs e)
    {

    }
  
    protected void gvtest_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gvtest.EditIndex = -1;
        BindMaterial();
    }

    protected void cbxAll_CheckedChanged(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in gvtest.Rows)
        {
            CheckBox cbx = (CheckBox)gr.FindControl("cbxCheck");
            if (cbx.Checked == false)
            {
                cbx.Checked = true;
            }
            else
            {
                cbx.Checked = false;
            }
        }
    }




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















}