protected void ibtnSearch_Click(object sender, CommandEventArgs e) { Panel1.Visible = false; Panel2.Visible = true; if (e.CommandName == "month") { int year = Int32.Parse(ddlYear.SelectedValue); DataTable dt = new DataTable(); string cargoNmae = ddlMaterialNameM.SelectedValue; string storageId = ddlStorageM.SelectedValue; string buildFloor = ddlFloorM.SelectedItem.Text.Replace("--全部楼层--", ""); string storageDeatilId = ddlStorageDetailM.SelectedValue; #region 取得数据源 if (string.IsNullOrEmpty(cargoNmae)) { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 0, "", "", 0, "");//无条件,全部统计 } else { if (string.IsNullOrEmpty(buildFloor)) { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 2, "", storageId, 0, "");//按仓库 } else { if (string.IsNullOrEmpty(storageDeatilId)) { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 3, "", storageId, int.Parse(buildFloor), "");//按楼层 } else { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 4, "", "", 0, storageDeatilId);//按仓位 } } } } else { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 1, cargoNmae, "", 0, "");//按品名 } else { if (string.IsNullOrEmpty(buildFloor)) { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 5, cargoNmae, storageId, 0, "");//按品名仓库 } else { if (string.IsNullOrEmpty(storageDeatilId)) { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 6, cargoNmae, storageId, int.Parse(buildFloor), "");//按品名楼层 } else { dt = GroupInfo.GetGroupIOStorageTotalByMonth(year, 7, cargoNmae, "", 0, storageDeatilId);//按品名仓位 } } } } #endregion Series series1 = chart2.Series[0]; Series series2 = chart2.Series[1]; //数据集声明 // DateTime date1 = DateTime.Now.Date; for (int i = 0; i < dt.Rows.Count; i++) //向数据集绑定数据 { series1.Points.AddXY(dt.Rows[i]["mouth"].ToString() + "月份", dt.Rows[i]["inTotalWeight"].ToString()); series2.Points.AddXY(dt.Rows[i]["mouth"].ToString() + "月份", dt.Rows[i]["outTotalWeight"].ToString()); // date1 = date1.AddDays(1); } while (this.chart2.Series[0].Points.Count > dt.Rows.Count) { // Remove series points foreach (Series s in this.chart2.Series) { s.Points.RemoveAt(0); } } chart2.Titles.Clear(); Title t1 = new Title(year.ToString() + "年每月粮食出入库情况", Docking.Top, new System.Drawing.Font("微软雅黑", 16), System.Drawing.Color.FromArgb(26, 59, 105));//图片标题 chart2.Titles.Add(t1); chart2.ChartAreas["ChartArea1"].AxisY.Title = "重量(单位:吨)"; chart2.ChartAreas["ChartArea1"].AxisX.Title = "月份"; //chart2.ChartAreas["ChartArea1"].AxisX.Interval = 1; } else if (e.CommandName == "year") { int beginYear = Int32.Parse(ddlYearBegin.SelectedValue); int endYear = Int32.Parse(ddlYearEnd.SelectedValue); DataTable dt = new DataTable(); string cargoNmae = ddlMaterialNameY.SelectedValue; string storageId = ddlStorageY.SelectedValue; string buildFloor = ddlFloorY.SelectedItem.Text.Replace("--全部楼层--", ""); string storageDeatilId = ddlStorageDetailY.SelectedValue; #region 取得数据源 if (string.IsNullOrEmpty(cargoNmae)) { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 0, "", "", 0, "");//无条件,全部统计 } else { if (string.IsNullOrEmpty(buildFloor)) { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 2, "", storageId, 0, "");//按仓库 } else { if (string.IsNullOrEmpty(storageDeatilId)) { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 3, "", storageId, int.Parse(buildFloor), "");//按楼层 } else { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 4, "", "", 0, storageDeatilId);//按仓位 } } } } else { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 1, cargoNmae, "", 0, "");//按品名 } else { if (string.IsNullOrEmpty(buildFloor)) { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 5, cargoNmae, storageId, 0, "");//按品名仓库 } else { if (string.IsNullOrEmpty(storageDeatilId)) { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 6, cargoNmae, storageId, int.Parse(buildFloor), "");//按品名楼层 } else { dt = GroupInfo.GetGroupIOStorageTotalByYear(beginYear, endYear, 7, cargoNmae, "", 0, storageDeatilId);//按品名仓位 } } } } #endregion Series series1 = chart2.Series[0]; Series series2 = chart2.Series[1]; //数据集声明 // DateTime date1 = DateTime.Now.Date; for (int i = 0; i < dt.Rows.Count; i++) //向数据集绑定数据 { series1.Points.AddXY(dt.Rows[i]["year"].ToString() + "年", dt.Rows[i]["inTotalWeight"].ToString()); series2.Points.AddXY(dt.Rows[i]["year"].ToString() + "年", dt.Rows[i]["outTotalWeight"].ToString()); // date1 = date1.AddDays(1); } while (this.chart2.Series[0].Points.Count > dt.Rows.Count) { // Remove series points foreach (Series s in this.chart2.Series) { s.Points.RemoveAt(0); } } string title = string.Empty; if (beginYear == endYear) { title = beginYear.ToString(); } else { title = beginYear.ToString() + "至" + endYear.ToString(); } chart2.Titles.Clear(); Title t1 = new Title(title + "粮食出入库情况", Docking.Top, new System.Drawing.Font("微软雅黑", 16), System.Drawing.Color.FromArgb(26, 59, 105));//图片标题 chart2.Titles.Add(t1); chart2.ChartAreas["ChartArea1"].AxisY.Title = "重量(单位:吨)"; chart2.ChartAreas["ChartArea1"].AxisX.Title = "年度"; } else { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Error", "alert('异常操作!')", true); } ltnToExcle.Visible = false; ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Show", "document.getElementById('divtoexcel').style.display='none';", true); }