private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 this.btnExcel.Attributes.Add("onclick", "javascript:window.open('../DataGridToExcel.aspx', 'Sample', 'toolbar=no,location=no,directories=no,status=yes,menubar=yes,scrollbars=no,resizable=yes,copyhistory=yes,width=790,height=520,left=0,top=0')"); if (Session["Login"] != null) { if (!IsPostBack) { this.ddlQueryType.Items.Add(new ListItem("原材料入库明细", "0")); this.ddlQueryType.Items.Add(new ListItem("入库供应商月报表", "1")); this.ddlQueryType.Items.Add(new ListItem("入库供应商汇总月报表", "2")); string strvalue = ""; string strYear = DateTime.Now.Year.ToString(); for (int i = 0; i < 12; i++) { if (i != 0 && DateTime.Now.AddMonths(-i).Month == 12) { strYear = DateTime.Now.AddYears(-1).Year.ToString(); } if (DateTime.Now.AddMonths(-i).Month < 10) { strvalue = strYear + "0" + (DateTime.Now.AddMonths(-i).Month).ToString(); } else { strvalue = strYear + (DateTime.Now.AddMonths(-i).Month).ToString(); } this.ddlMonth.Items.Add(new ListItem(strvalue, strvalue)); } this.FillDropDownList("tbNameCodeToStorage", this.ddlMaterialType, "vcCommSign='MaterialType'", "全部"); Session.Remove("QUERY"); Session.Remove("toExcel"); Session.Remove("page_view"); Hashtable htapp = (Hashtable)Application["appconf"]; string strcons = (string)htapp["cons"]; msb1 = new MaterialSBusi(strcons); DataTable dtProviderList = msb1.GetProviderList(); this.FillDropDownList(dtProviderList, this.ddlProviderName, "全部"); } if (this.UcPageView1.MyDataGrid.DataSource != null) { if (((DataView)this.UcPageView1.MyDataGrid.DataSource).Count > 0) { UcPageView1.FootBar.Visible = true; btnExcel.Enabled = true; } else { btnExcel.Enabled = false; } } else { btnExcel.Enabled = false; } } else { Response.Redirect("../Exit.aspx"); } }