?? 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;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -