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);
}
