//关闭统计数据维护
protected void Senior_DetailCLOSE_Click(object sender, EventArgs e)
{
Panel1.Visible = false;
this.UpdatePanel1.Update();
Panel_Name.Visible = false;
this.UpdatePanel_Name.Update();
Senior_DetailOPEN.Visible = true;
Senior_DetailCLOSE.Visible = false;
Panel_Grid.Visible = true;
UpdatePanel_Grid.Update();
panelGraph.Visible = false;
UpdatepanelGraph.Update();
}
//打开统计数据维护
protected void Senior_DetailOPEN_Click(object sender, EventArgs e)
{
Panel_Grid.Visible = false;
this.UpdatePanel_Grid.Update();
Senior_DetailOPEN.Visible = false;
Senior_DetailCLOSE.Visible = true;
Panel1.Visible = true;
UpdatePanel1.Update();
BindGridView1(" and EN_OperationTime is not null and EN_Limit is not null and EN_OperationTime!=-1 and EN_Limit!=-1");
UpdatePanel_Search.Update();
panelGraph.Visible = false;
UpdatepanelGraph.Update();
}
//重置按钮
protected void BtnReset_Click(object sender, EventArgs e)
{
Senior_DetailOPEN.Visible = true;
Senior_DetailCLOSE.Visible = false;
Panel_Grid.Visible = true;
UpdatePanel_Grid.Update();
Panel1.Visible = false;
UpdatePanel1.Update();
Panel_Name.Visible = false;
UpdatePanel_Name.Update();
textname.Text = "";
UpdatePanel_Grid.Update();
panelGraph.Visible = false;
UpdatepanelGraph.Update();
}
//检索按钮
protected void BtnSearch_Click(object sender, EventArgs e)
{
Senior_DetailOPEN.Visible = true;
Senior_DetailCLOSE.Visible = false;
Panel_Grid.Visible = true;
UpdatePanel_Grid.Update();
Panel1.Visible = false;
UpdatePanel1.Update();
Panel_Name.Visible = false;
UpdatePanel_Name.Update();
panelGraph.Visible = false;
UpdatepanelGraph.Update();
if (this.textyear.Text.ToString() == "" || this.textyear.Text.ToString().Length != 4)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "alert", "alert('请填入正确的年份！')", true);
return;
}
string condition = GetCondition();
string year = textyear.Text.Trim().ToString();
BindGrid_Detail(condition, year);
UpdatePanel_Grid.Update();
}
protected void Grid_Detail_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Gra")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_Detail.SelectedIndex = row.RowIndex;
//panelGraph.Visible = true;
//DataSet ds = sd.S_Equiptrend("and EN_EquipName='" + e.CommandArgument + "'",textyear.Text.Trim());
//ds.Tables[0].Select();
//Chart1.DataSource = ds.Tables[0].Select();
//Chart1.Titles[0].Text = e.CommandArgument + "维修率和停机率趋势图";
////设置图表Y轴对应项
//Chart1.Series[0].YValueMembers = "出站数";
//Chart1.Series[1].YValueMembers = "合格率";
////设置图表X轴对应项
//Chart1.Series[0].XValueMember = "月份";
//Chart1.Series[1].XValueMember = "月份";
//Chart1.Series[1].Points.AddXY("一月","Grid_Detail.Rows[row.RowIndex].Cells[1].Text.ToString()");//试试
//绑定数据
//Chart1.DataBind();
//Create a DataTable as the data source of the Chart control
DataTable dt = new DataTable();
//Add three columns to the DataTable
dt.Columns.Add("Date");
dt.Columns.Add("Volume1");
dt.Columns.Add("Volume2");
DataRow dr;
dr = dt.NewRow();
dr["Date"] = "一月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[3].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[4].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "二月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[5].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[6].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "三月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[7].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[8].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "四月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[9].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[10].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "五月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[11].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[12].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "六月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[13].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[14].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "七月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[15].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[16].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "八月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[17].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[18].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "九月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[19].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[20].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "十月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[21].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[22].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "十一月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[23].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[24].Text.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["Date"] = "十二月";
dr["Volume1"] = Grid_Detail.Rows[row.RowIndex].Cells[25].Text.ToString();
dr["Volume2"] = Grid_Detail.Rows[row.RowIndex].Cells[26].Text.ToString();
dt.Rows.Add(dr);
//设置图表的数据源
Chart1.DataSource = dt;
Chart1.Titles[0].Text = e.CommandArgument + "—维修率和停机率趋势图";
//设置图表Y轴对应项
Chart1.Series[0].YValueMembers = "Volume1";
Chart1.Series[1].YValueMembers = "Volume2";
//设置图表X轴对应项
Chart1.Series[0].XValueMember = "Date";
Chart1.Series[1].XValueMember = "Date";
//绑定数据
Chart1.DataBind();
panelGraph.Visible = true;
UpdatepanelGraph.Update();
}
}
