public void getGoal()
{
DataTable dt = objKPI.GetGoal(0, "KPI005", 0);
if (dt.Rows.Count > 0)
{
hiddenKPIID.Value = dt.Rows[0]["KPI_ID"].ToString();
}
}
protected void GetGoal()
{
DataTable dtKPI = objKPI.GetGoal(0, "KPI021", 0);
string KPI_ID = dtKPI.Rows[0]["KPI_ID"].ToString();
hiddenKPIID.Value = KPI_ID;
}
protected void loadPIDetails()
{
int KPI_ID = 0;
DataTable dtKPI = objKPI.GetGoal(0, "KPI030", 0);
if (dtKPI.Rows[0]["KPI_ID"] != null)
{
KPI_ID = Convert.ToInt32(dtKPI.Rows[0]["KPI_ID"]);
}
DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(KPI_ID);
DataTable dt = new DataTable();
DataTable dtPIDtl = ds.Tables[1];
dt.Columns.Add(new DataColumn("sno", typeof(int)));
dt.Columns.Add(new DataColumn("PID", typeof(string)));
dt.Columns.Add(new DataColumn("value", typeof(string)));
dt.Columns.Add(new DataColumn("PIName", typeof(string)));
string exp = "";
if (dtPIDtl.Rows.Count > 0)
{
foreach (DataRow row in dtPIDtl.Rows)
{
dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() });
exp = exp + row["value"].ToString();
}
lblFormula.Text = "KPI Formula : " + exp;
DataTable dt_PI = dt;
dt_PI.DefaultView.RowFilter = "PID <> ''";
DataList1.DataSource = dt_PI.DefaultView;
DataList1.DataBind();
}
}
private void loadFormula()
{
DataTable dtKPI = objKPI.GetGoal(0, "KPI030", 0);
string KPI_ID = dtKPI.Rows[0]["KPI_ID"].ToString();
hdnKPIID.Value = KPI_ID;
DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(UDFLib.ConvertIntegerToNull(KPI_ID));
DataTable dtPIDtl = ds.Tables[1];
string exp = "";
foreach (DataRow row in dtPIDtl.Rows)
{
exp = exp + row["value"].ToString();
}
lblFormula.Text = "KPI Formula : " + exp;
loadPIDetails();
}