protected void Repeater_OnItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "Show") { string wpId = e.CommandArgument.ToString(); DataTable dt = Storage.GetStorageDetailById(wpId); if (dt != null) { lilInfo.Text = "仓位编码:" + dt.Rows[0]["WPNumber"].ToString() + "<br/>仓位名称:" + dt.Rows[0]["WPName"].ToString() + "<br/>堆号:" + dt.Rows[0]["Number"].ToString(); } Repeater3.DataSource = Storage.GetStorageGrainByStorageDetailId(wpId); Repeater3.DataBind(); DateTime beginDate = DateTime.Now.AddDays(-6).Date; DateTime endDate = DateTime.Now.Date; dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 4, "", "", 0, wpId); Series series1 = chart1.Series[0]; Series series2 = chart1.Series[1]; //数据集声明 // DateTime date1 = DateTime.Now.Date; for (int i = 0; i < dt.Rows.Count; i++) //向数据集绑定数据 { series1.Points.AddXY(Convert.ToDateTime(dt.Rows[i]["opardate"]).ToShortDateString(), dt.Rows[i]["inTotalWeight"].ToString()); series2.Points.AddXY(Convert.ToDateTime(dt.Rows[i]["opardate"]).ToShortDateString(), dt.Rows[i]["outTotalWeight"].ToString()); // date1 = date1.AddDays(1); } while (this.chart1.Series[0].Points.Count > dt.Rows.Count) { // Remove series points foreach (Series s in this.chart1.Series) { s.Points.RemoveAt(0); } } chart1.ChartAreas["ChartArea1"].AxisY.Title = "重量(单位:吨)"; chart1.ChartAreas["ChartArea1"].AxisX.Title = "日期"; ScriptManager.RegisterClientScriptBlock(UpdatePanel1, GetType(), "open", "Open('comment1',260,120);$('comment2').style.display='block';", true); } }
private void DataLoad() { DateTime beginDate = DateTime.Now.AddDays(-6).Date; DateTime endDate = DateTime.Now.Date; DataTable dt = new DataTable(); //if (Cache["IOGrainTable"] == null) //{ dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 0, "", "", 0, ""); // Cache.Insert("IOGrainTable", dt, null, DateTime.Now.AddHours(1), TimeSpan.Zero); //} //else //{ // dt = (DataTable)Cache["IOGrainTable"]; //} Series series1 = chart1.Series[0]; Series series2 = chart1.Series[1]; //数据集声明 for (int i = 0; i < dt.Rows.Count; i++) //向数据集绑定数据 { series1.Points.AddXY(Convert.ToDateTime(dt.Rows[i]["opardate"]).ToShortDateString(), dt.Rows[i]["inTotalWeight"].ToString()); series1.Color = System.Drawing.Color.DodgerBlue; series2.Points.AddXY(Convert.ToDateTime(dt.Rows[i]["opardate"]).ToShortDateString(), dt.Rows[i]["outTotalWeight"].ToString()); series2.Color = System.Drawing.Color.Orange; } while (this.chart1.Series[0].Points.Count > dt.Rows.Count) { // Remove series points foreach (Series s in this.chart1.Series) { s.Points.RemoveAt(0); } } chart1.ChartAreas["ChartArea1"].AxisY.Title = "重量(单位:吨)"; chart1.ChartAreas["ChartArea1"].AxisX.Title = "日期"; DataTable dt1 = GroupInfo.GetGroupCurrentInfo(); //数据集""显示属性设置 Series series3 = chart2.Series[0]; //数据集声明 series3.ToolTip = "#LEGENDTEXT: #VAL{C} million"; //series6.Label = "#PERCENT{P}"; series3.Points.DataBind(dt1.Select("type=0"), "state", "num", "LegendText=state,YValues=num,ToolTip=state"); series3.Points[0].Color = System.Drawing.Color.DodgerBlue; series3.Points[1].Color = System.Drawing.Color.Orange; //数据集""显示属性设置 Series series4 = chart3.Series[0]; //数据集声明 series4.ToolTip = "#LEGENDTEXT: #VAL{C} million"; //series6.Label = "#PERCENT{P}"; series4.Points.DataBind(dt1.Select("type=1"), "state", "num", "LegendText=state,YValues=num,ToolTip=state"); series4.Points[0].Color = System.Drawing.Color.DodgerBlue; series4.Points[1].Color = System.Drawing.Color.Orange; //数据集""显示属性设置 Series series5 = chart4.Series[0]; //数据集声明 series5.ToolTip = "#LEGENDTEXT: #VAL{C} million"; //series6.Label = "#PERCENT{P}"; series5.Points.DataBind(dt1.Select("type=2"), "state", "num", "LegendText=state,YValues=num,ToolTip=state"); series5.Points[0].Color = System.Drawing.Color.DodgerBlue; series5.Points[1].Color = System.Drawing.Color.Orange; }
protected void btnSearch_Click(object sender, EventArgs e) { if (Page.IsValid) { Panel1.Visible = true; Panel2.Visible = false; DateTime beginDate = Convert.ToDateTime(txtPlanStartTime.Text.Trim()); DateTime endDate = Convert.ToDateTime(txtPlanEndTime.Text.Trim()); DataTable dt = new DataTable(); string cargoNmae = ddlMaterialName.SelectedValue; string storageId = ddlStorage.SelectedValue; string buildFloor = ddlFloor.SelectedItem.Text.Replace("--全部楼层--", ""); string storageDeatilId = ddlStorageDetail.SelectedValue; #region 取得数据源 if (string.IsNullOrEmpty(cargoNmae)) { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 0, "", "", 0, "");//无条件,全部统计 } else { if (string.IsNullOrEmpty(buildFloor)) { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 2, "", storageId, 0, "");//按仓库 } else { if (string.IsNullOrEmpty(storageDeatilId)) { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 3, "", storageId, int.Parse(buildFloor), "");//按楼层 } else { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 4, "", "", 0, storageDeatilId);//按仓位 } } } } else { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 1, cargoNmae, "", 0, "");//按品名 } else { if (string.IsNullOrEmpty(storageId)) { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 5, cargoNmae, storageId, 0, "");//按品名仓库 } else { if (string.IsNullOrEmpty(storageDeatilId)) { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 6, cargoNmae, storageId, int.Parse(buildFloor), ""); //按品名楼层 } else { dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 7, cargoNmae, "", 0, storageDeatilId);//按品名仓位 } } } } #endregion GridView1.DataSource = dt; GridView1.DataBind(); ltnToExcle.Visible = true; ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Show", "document.getElementById('divtoexcel').style.display='block';", true); } }
protected void TreeView1_OnSelectedNodeChanged(object sender, EventArgs e) { DateTime beginDate = DateTime.Now.AddDays(-6).Date; DateTime endDate = DateTime.Now.Date; string selectValue = TreeView1.SelectedValue; string level = selectValue.Split(',')[0]; #region 点击仓库信息 if (level == "0") { string whId = selectValue.Split(',')[1]; DataRow[] drs = Storage.GetStorage().Select("WHID='" + whId + "'"); lilInfo.Text = "仓库名称:" + drs[0]["WHName"].ToString() + "<br/>电话:" + drs[0]["WHTel"].ToString() + "<br/>地址:" + drs[0]["WHAddress"].ToString(); Repeater3.DataSource = Storage.GetStorageGrainByStorageId(whId); Repeater3.DataBind(); DataTable dt = GroupInfo.GetGroupIOStorageTotal(beginDate, endDate, 2, "", whId, 0, string.Empty); Series series1 = chart1.Series[0]; Series series2 = chart1.Series[1]; //数据集声明 // DateTime date1 = DateTime.Now.Date; for (int i = 0; i < dt.Rows.Count; i++) //向数据集绑定数据 { series1.Points.AddXY(Convert.ToDateTime(dt.Rows[i]["opardate"]).ToShortDateString(), dt.Rows[i]["inTotalWeight"].ToString()); series2.Points.AddXY(Convert.ToDateTime(dt.Rows[i]["opardate"]).ToShortDateString(), dt.Rows[i]["outTotalWeight"].ToString()); // date1 = date1.AddDays(1); } while (this.chart1.Series[0].Points.Count > dt.Rows.Count) { // Remove series points foreach (Series s in this.chart1.Series) { s.Points.RemoveAt(0); } } chart1.ChartAreas["ChartArea1"].AxisY.Title = "重量(单位:吨)"; chart1.ChartAreas["ChartArea1"].AxisX.Title = "日期"; } #endregion #region 点击楼层信息 if (level == "1") { string whId = selectValue.Split(',')[1]; string floorDigit = selectValue.Split(',')[2]; lilInfo.Text = "楼层:" + TreeView1.SelectedNode.Text; Repeater1.DataSource = Storage.GetStorageDetail(whId, floorDigit, "A"); Repeater1.DataBind(); Repeater2.DataSource = Storage.GetStorageDetail(whId, floorDigit, "B"); Repeater2.DataBind(); TreeView1.Nodes[0].Selected = true; ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "open", "Open('comment2',250,80)", true); return; } #endregion TreeView1.Nodes[0].Selected = true; ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.GetType(), "open", "Open('comment1',250,80)", true); }