protected void display_Click(object sender, EventArgs e)
{
using (OpSurveyManager manager = new OpSurveyManager(this.CurSessionConfig))
{
DataTable table = manager.GetOpSurveyDataResult(int.Parse(this.ddl_year.SelectedValue), this.ddl_dchannel.SelectedValue, this.ddl_plant.SelectedValue, this.ddl_Employee.SelectedValue, this.ddl_EquipmProfile.SelectedValue);
DataView view = new DataView(table);
this.GridViewResult.DataSource = view;
this.DataBind();
if ((table != null) && (table.Rows.Count > 0))
{
StringBuilder builder = new StringBuilder();
DataRow row = table.Rows[table.Rows.Count - 1];
builder.AppendLine("<script type='text/javascript'>");
builder.AppendLine("IsChartReady = true;");
builder.Append("var data = [[");
for (int i = 1; i <= 4; i++)
{
builder.Append("['" + table.Columns[i].ColumnName + "'," + row[i].ToString() + "]" + ((i == 4) ? "" : ","));
}
builder.Append("]];");
builder.AppendLine("</script>");
this.ChartScript.Text = builder.ToString();
}
}
}
protected void display_Click(object sender, EventArgs e)
{
this.CurrentPageIndex = 0;
this.ResultTable = new DataTable();
this.ResultTable.Columns.Add(new DataColumn("Engineer Resp.", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("Sold To", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("notification_no", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("Activity Type", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("notification_subject", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("Equipment", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("SN", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("JobStart", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("JobEnd", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("notification_signby", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("notification_signbydisgn", Type.GetType("System.String")));
this.ResultTable.Columns.Add(new DataColumn("Comments", Type.GetType("System.String")));
using (OpSurveyManager manager = new OpSurveyManager(this.CurSessionConfig))
{
this.ResultTable = manager.GetOpSurveyDataResult(int.Parse(this.ddl_Month.SelectedValue), int.Parse(this.ddl_year.SelectedValue), this.ddl_dchannel.SelectedValue, this.ddl_plant.SelectedValue, this.ddl_Employee.SelectedValue, this.ddl_EquipmProfile.SelectedValue);
DataView view = new DataView(this.ResultTable);
this.GridViewResult.DataSource = view;
this.DataBind();
}
}
