コード例 #1
0
        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");
            }
        }