tablesview.aspx.cs

固定资产管理系统 登陆

using System;
using System.Data;
using System.Configuration;
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.SqlClient;
using System.IO;
using System.Text;

public partial class Default4 : System.Web.UI.Page 
{
    //delegate GridView T();

    SqlConnection sqlcon = new SqlConnection("Data Source=42.1.47.11;Database=AssetsDB;Uid=szy;Pwd=123456");
    GridView gv;

    protected void Page_Load(object sender, EventArgs e)
    {
        //Response.Clear();

    }
    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        
        int i = Convert.ToInt32(TreeView1.SelectedValue);

        switch (i)
        {
            case 10:
                GridView0.Visible = true;
                GridView0.Enabled = true;
                GridView1.Enabled = false;
                GridView1.Visible = false;
                GridView2.Enabled = false;
                GridView2.Visible = false;
                GridView3.Enabled = false;
                GridView3.Visible = false;
                GridView4.Enabled = false;
                GridView4.Visible = false;
                GridView5.Enabled = false;
                GridView5.Visible = false;
                GridView6.Enabled = false;
                GridView6.Visible = false;
                gv = GridView0;
                bind("select * from asset_detail_view", gv);
                break;
            case 11:
                GridView0.Visible = false;
                GridView0.Enabled = false;
                GridView1.Enabled = true;
                GridView1.Visible = true;
                GridView2.Enabled = false;
                GridView2.Visible = false;
                GridView3.Enabled = false;
                GridView3.Visible = false;
                GridView4.Enabled = false;
                GridView4.Visible = false;
                GridView5.Enabled = false;
                GridView5.Visible = false;
                GridView6.Enabled = false;
                GridView6.Visible = false;
                gv = GridView1;
                bind("select * from asset_view",gv);
                break;
            case 12:
                GridView0.Visible = false;
                GridView0.Enabled = false;
                GridView1.Enabled = false;
                GridView1.Visible = false;
                GridView2.Enabled = true;
                GridView2.Visible = true;
                GridView3.Enabled = false;
                GridView3.Visible = false;
                GridView4.Enabled = false;
                GridView4.Visible = false;
                GridView5.Enabled = false;
                GridView5.Visible = false;
                GridView6.Enabled = false;
                GridView6.Visible = false;
                gv = GridView2;
                bind("select * from card_view", gv);
                break;

            case 13:
                GridView0.Visible = false;
                GridView0.Enabled = false;
                GridView1.Enabled = false;
                GridView1.Visible = false;
                GridView2.Enabled = false;
                GridView2.Visible = false;
                GridView3.Enabled = true;
                GridView3.Visible = true;
                GridView4.Enabled = false;
                GridView4.Visible = false;
                GridView5.Enabled = false;
                GridView5.Visible = false;
                GridView6.Enabled = false;
                GridView6.Visible = false;
                gv = GridView3;
                bind("select * from change_record",gv);
                break;
            case 21:
                GridView0.Visible = false;
                GridView0.Enabled = false;
                GridView1.Enabled = false;
                GridView1.Visible = false;
                GridView2.Enabled = false;
                GridView2.Visible = false;
                GridView3.Enabled = false;
                GridView3.Visible = false;
                GridView4.Enabled = true;
                GridView4.Visible = true;
                GridView5.Enabled = false;
                GridView5.Visible = false;
                GridView6.Enabled = false;
                GridView6.Visible = false;
                gv = GridView4;
                bind("select * from u_branch",GridView4);
                break;
            case 31:
                GridView0.Visible = false;
                GridView0.Enabled = false;
                GridView1.Enabled = false;
                GridView1.Visible = false;
                GridView2.Enabled = false;
                GridView2.Visible = false;
                GridView3.Enabled = false;
                GridView3.Visible = false;
                GridView4.Enabled = false;
                GridView4.Visible = false;
                GridView5.Enabled = true;
                GridView5.Visible = true;
                GridView6.Enabled = false;
                GridView6.Visible = false;
                gv = GridView5;
                bind("select * from source",GridView5);
                break;
            case 32:
                GridView0.Visible = false;
                GridView0.Enabled = false;
                GridView1.Enabled = false;
                GridView1.Visible = false;
                GridView2.Enabled = false;
                GridView2.Visible = false;
                GridView3.Enabled = false;
                GridView3.Visible = false;
                GridView4.Enabled = false;
                GridView4.Visible = false;
                GridView5.Enabled = false;
                GridView5.Visible = false;
                GridView6.Enabled = true;
                GridView6.Visible = true;
                gv = GridView6;
                bind("select * from purchase_way",GridView6);
                break;


        }

        GridView gv_export = new GridView();
        gv_export.DataSource = gv.DataSource;
        gv_export.AllowPaging = false;
        gv_export.DataBind();

        Application["gv_export_all"] = gv_export;
        Application["gv_id"] = i;
    }

    protected void GridView0_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView0.PageIndex = e.NewPageIndex;
        bind("select * from asset_detail_view", GridView0);
    }


    protected void GridView1_PageIndexChangeing(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        bind("select * from asset_view", GridView1); 
    }

    protected void GridView2_PageIndexChangeing(object sender, GridViewPageEventArgs e)
    {
        this.GridView2.PageIndex = e.NewPageIndex;
        bind("select * from card_view", GridView2); 
    }

    protected void GridView3_PageIndexChangeing(object sender, GridViewPageEventArgs e)
    {
        this.GridView3.PageIndex = e.NewPageIndex;
        bind("select * from change_record", GridView3);
    }

    protected void GridView4_PageIndexChangeing(object sender, GridViewPageEventArgs e)
    {
        //GridView4.Enabled = true;
        //GridView4.Visible = true;
        this.GridView4.PageIndex = e.NewPageIndex;
        bind("select * from u_branch", GridView4);
    }

    protected void GridView5_PageIndexChangeing(object sender, GridViewPageEventArgs e)
    {
        this.GridView5.PageIndex = e.NewPageIndex;
        bind("select * from source", GridView5);
    }

    protected void GridView6_PageIndexChangeing(object sender, GridViewPageEventArgs e)
    {
        this.GridView6.PageIndex = e.NewPageIndex;
        bind("select * from purchase_way", GridView6);
    }


    private void Export(string FileType, string FileName,GridView ref_gridview)
    {
        Response.Clear();
        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();

        try
        {
            HtmlTextWriter hw = new HtmlTextWriter(tw);
            ref_gridview.RenderControl(hw);
            Response.Write(tw.ToString());
            Response.End();
        }
        catch
        {
            Response.Write("<script language=javascript>alert('数据出错！')</script>");
        }
    }

    private void bind(string sqlcmd, GridView ref_GridView)
    {

        try
        {
            SqlDataAdapter myda = new SqlDataAdapter(sqlcmd, sqlcon);
            DataSet myds = new DataSet();
            sqlcon.Open();
            myda.Fill(myds);
            sqlcon.Close();
            ref_GridView.DataSource = myds;
            ref_GridView.DataBind();
        }
        catch
        {
            Response.Write("<script language=javascript>alert('数据出错！')</script>");
        }
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
    }

    protected void Button1_Click1(object sender, EventArgs e)
    {
        //Label1.Text = gv.Client:ID;
        try
        {
            Export("application/ms-excel", "报表.xls", (GridView)Application["gv_export_all"]);
        }
        catch
        {
            Response.Write("<script language=javascript>alert('导出错误！')</script>");
        }
    }
    protected void query_btn_Click(object sender, EventArgs e)
    {

        Response.Clear();
        string select_str;

        GridView gv_export_selected=new GridView();
        gv_export_selected.AllowPaging=false;


        switch (Convert.ToInt32(Application["gv_id"]))
        {
            case 10:
                if (dpl_select.SelectedIndex == 0)
                {
                    select_str = "select * from asset_detail_view where year(增加日期)='" + txt_key.Text + "'";
                    bind(select_str, GridView0);
                }
                else if (dpl_select.SelectedIndex == 1)
                {
                    select_str = "select * from asset_detail_view where 固定资产名称='" + txt_key.Text + "'";
                    bind(select_str, GridView0);
                }
                else if (dpl_select.SelectedIndex == 2)
                {
                    select_str = "select * from asset_detail_view where 品牌名称='" + txt_key.Text + "'";
                    bind(select_str, GridView0);
                }
                else if (dpl_select.SelectedIndex == 3)
                {
                    select_str = "select * from asset_detail_view where 使用状态='" + txt_status.Text + "'";
                    bind(select_str, GridView0);
                }
                else
                {
                    select_str = "select * from asset_detail_view where year(增加日期)='" + txt_key.Text + "' and 使用状态='" + Convert.ToInt16(txt_status.Text) + "' ";
                    bind(select_str, GridView0);
                }

                gv_export_selected.DataSource = GridView0.DataSource;
                break;

            case 11:
                if (dpl_select.SelectedIndex == 0)
                {
                    select_str = "select * from asset_view where year(增加日期)='" + txt_key.Text + "'";
                    bind(select_str, GridView1);
                }
                else if (dpl_select.SelectedIndex == 1)
                {
                    select_str = "select * from asset_view where 固定资产名称='" + txt_key.Text + "'";
                    bind(select_str, GridView1);
                }
                else if (dpl_select.SelectedIndex == 2)
                {
                    select_str = "select * from asset_view where 品牌名称='" + txt_key.Text + "'";
                    bind(select_str, GridView1);
                }
                else
                {
                    Response.Write("<script language=javascript>alert('对不起，报告单没有使用状态字段！')</script>");
                    query_btn.Enabled = false;
                }
                gv_export_selected.DataSource = GridView1.DataSource;
                break;

            case 12:
                if (dpl_select.SelectedIndex == 0)
                {
                    select_str = "select * from card_view where year(增加日期)='" + txt_key.Text + "'";
                    bind(select_str, GridView2);
                }
                else if (dpl_select.SelectedIndex == 1)
                {
                    select_str = "select * from card_view where 固定资产名称='" + txt_key.Text + "'";
                    bind(select_str, GridView2);
                }
                else if (dpl_select.SelectedIndex == 2)
                {
                    select_str = "select * from card_dview where 品牌名称='" + txt_key.Text + "'";
                    bind(select_str, GridView2);
                }
                else if (dpl_select.SelectedIndex == 3)
                {
                    select_str = "select * from card_view where 使用状态='" + txt_status.Text + "'";
                    bind(select_str, GridView2);
                }
                else
                {
                    select_str = "select * from card_view where year(增加日期)='" + txt_key.Text + "' and 使用状态='" + Convert.ToInt16(txt_status.Text) + "' ";
                    bind(select_str, GridView2);
                }
                gv_export_selected.DataSource = GridView2.DataSource;
                break;
        }

        gv_export_selected.DataBind();
        Application["gv_export_selected"] = gv_export_selected;

        
    }

    protected void btn_export_selected_Click(object sender, EventArgs e)
    {
        Export("application/ms-excel", "查询结果报表.xls", (GridView)Application["gv_export_selected"]);
    }
    protected void dpl_select_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (dpl_select.SelectedIndex == 3)
        {
            txt_key.Enabled = false;
            txt_status.Enabled = true;
        }
        else if (dpl_select.SelectedIndex == 4)
        {
            txt_key.Enabled = true;
            txt_status.Enabled = true;
        }
        else
        {
            txt_key.Enabled = true;
            txt_status.Enabled = false;
        }
    }
}