// 등급코드를 가져온다
private void BindThresholdCodeList()
{
Biz_Bsc_Threshold_Code biz = new Biz_Bsc_Threshold_Code();
COD_ESEQ_COUNT = biz.RtnThresholdCodeMaxSeq();
string strLevel = GetValue(ddlLevel.SelectedValue);
DataSet ds = biz.GetThresholdCodeList(strLevel);
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
}
private void SetKpiSignalMaster()
{
Biz_Bsc_Threshold_Code objBSC = new Biz_Bsc_Threshold_Code();
DataTable dt = objBSC.GetThresholdCodeList("").Tables[0];
foreach (DataRow dr in dt.Rows)
{
dr["IMAGE_FILE_NAME"] = string.Format("../images/org/signal_set{0}/{1}", WebUtility.GetConfig("DTree.SignalSet"), dr["IMAGE_FILE_NAME"]);
}
grvSignal.DataSource = dt;
grvSignal.DataBind();
}
private void GetThresholdCodeBind()
{
Biz_Bsc_Threshold_Code biz = new Biz_Bsc_Threshold_Code();
DataSet ds = biz.GetThresholdCodeList("");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem li = new ListItem();
li.Text = ds.Tables[0].Rows[i]["THRESHOLD_ENAME"].ToString();
li.Value = ds.Tables[0].Rows[i]["THRESHOLD_REF_ID"].ToString();
ddlThresholdCode.Items.Add(li);
}
}
/// <summary>
/// 시그널추이 스키마
/// YMD | E | G | W | A
/// </summary>
/// <returns></returns>
public DataTable GetGradeSchema()
{
DataTable dtGrade = new DataTable("GRADE");
Biz_Bsc_Threshold_Code objTC = new Biz_Bsc_Threshold_Code();
DataSet dsGrade = objTC.GetThresholdCodeList("");
DataRow drGrade = null;
DateTime startYM = (DateTime.ParseExact(this.IYmd, "yyyyMM", null)).AddYears(-1);
dtGrade.Columns.Add(COL_KEY.KEY_FIELD.ToString(), typeof(string));
iRow = dsGrade.Tables[0].Rows.Count;
for (int i = iRow - 1; i > -1; i--)
{
bool IsDefault = (dsGrade.Tables[0].Rows[i]["DEFAULT_IMG_YN"].ToString().ToUpper() == "N") ? false : true;
if (!IsDefault)
{
DataColumn dc = dtGrade.Columns.Add(dsGrade.Tables[0].Rows[i]["THRESHOLD_REF_ID"].ToString(), typeof(decimal));
dc.Caption = dsGrade.Tables[0].Rows[i]["THRESHOLD_COLOR"].ToString();
dc.Namespace = dsGrade.Tables[0].Rows[i]["THRESHOLD_KNAME"].ToString();
}
if (dsGrade.Tables[0].Rows[i]["ALERT_IMG_YN"].ToString().ToUpper() == "Y")
{
this.IThresholdRefID = int.Parse(dsGrade.Tables[0].Rows[i]["THRESHOLD_REF_ID"].ToString());
}
}
for (int i = 1; i <= 12; i++)
{
drGrade = dtGrade.NewRow();
drGrade[COL_KEY.KEY_FIELD.ToString()] = startYM.AddMonths(i).ToString("yyyyMM");
dtGrade.Rows.Add(drGrade);
}
return(dtGrade);
}