dctext.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_dctext : 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;

            }
        }

    }

    public void Binddc()
    {

        string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
        string strcmd = "select * from ZhouQinfo order by " + sort;
        db.BindGridView(strcmd, dcgv);
        //b绑定隐藏gridview，即要导出的data

       

    }


    //清单导出
    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);
        dcgv.RenderControl(hw);
        //导出隐藏gridview的信息
        Response.Write(tw.ToString());
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
    }






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

    }

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

   




    protected void gvtest_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvtest.PageIndex = e.NewPageIndex;
        BindMaterial();
    }






}