private void LitemCommonCode(DropDownList dl, string code, int type)
{
if (type == 0)
{
DataTable dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().GetCommonCode(code);
ListItem[] li = new ListItem[dt.Rows.Count + 1];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dl.Items.Add(new ListItem(dt.Rows[i]["CODE_NAME"].ToString(), dt.Rows[i]["ETC_CODE"].ToString()));
}
}
}
else
{
DataTable dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().GetCommonCode();
ListItem[] li = new ListItem[dt.Rows.Count + 1];
li[0] = new ListItem(":: 선택 ::", "");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dl.Items.Add(new ListItem(dt.Rows[i]["UNIT_TYPE"].ToString(), dt.Rows[i]["UNIT_TYPE_REF_ID"].ToString()));
}
}
}
}
public void SetKpiPoolGrid()
{
//MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool();
//DataSet ds = objBSC.GetAllList(txtKPIName.Text.Trim(),
// PageUtility.GetByValueDropDownList(ddlKpiType),
// PageUtility.GetByValueDropDownList(ddlUseYn));
//ugrdKPIPool.Clear();
//ugrdKPIPool.DataSource = ds.Tables[0].DefaultView;
//ugrdKPIPool.DataBind();
//lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool bizBscKpiPool = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool();
DataTable dtBscKpiPool = bizBscKpiPool.GetKpiPool_DB(txtKPIName.Text.Trim(),
PageUtility.GetByValueDropDownList(ddlKpiType),
PageUtility.GetByValueDropDownList(ddlUseYn),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlKpiVersion)),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlKpiTemplete)));
ugrdKPIPool.Clear();
ugrdKPIPool.DataSource = dtBscKpiPool;
ugrdKPIPool.DataBind();
lblRowCount.Text = dtBscKpiPool.Rows.Count.ToString();
}
private void TreeMapCreate()
{
trvEstDept.Nodes.Clear();
TreeNode Root = new TreeNode("풀맵");
Root.ImageUrl = "../images/icon/02_2.gif";
Root.SelectAction = TreeNodeSelectAction.Expand;
DataTable ParentDt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().KpiPoolMapFirstSelect();
DataTable SecondDt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().KpiPoolMapSecondSelect();
DataTable ThirddDt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().KpiPoolMapThirdSelect();
for (int i = 0; i < ParentDt.Rows.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = ParentDt.Rows[i]["VIEW_NAME"].ToString();
node.Value = ParentDt.Rows[i]["VIEW_REF_ID"].ToString();
node.ImageUrl = "../images/stg/TREE_V.gif";
node.SelectAction = TreeNodeSelectAction.Expand;
Root.ChildNodes.Add(node);
}
for (int i = 0; i < SecondDt.Rows.Count; i++)
{
foreach (TreeNode node in Root.ChildNodes)
{
if (node.Value == SecondDt.Rows[i]["VIEW_REF_ID"].ToString())
{
TreeNode cnode = new TreeNode();
cnode.Text = SecondDt.Rows[i]["STG_NAME"].ToString();
cnode.Value = SecondDt.Rows[i]["STG_REF_ID"].ToString();
cnode.ImageUrl = "../images/stg/TREE_S.gif";
cnode.SelectAction = TreeNodeSelectAction.Expand;
node.ChildNodes.Add(cnode);
}
}
}
for (int i = 0; i < ThirddDt.Rows.Count; i++)
{
foreach (TreeNode node in Root.ChildNodes)
{
foreach (TreeNode snode in node.ChildNodes)
{
if (snode.Value == ThirddDt.Rows[i]["STG_REF_ID"].ToString())
{
TreeNode cnode = new TreeNode();
cnode.Text = ThirddDt.Rows[i]["KPI_NAME"].ToString();
cnode.Value = ThirddDt.Rows[i]["KPI_POOL_REF_ID"].ToString();
cnode.ImageUrl = "../images/stg/TREE_K.gif";
cnode.SelectAction = TreeNodeSelectAction.Expand;
snode.ChildNodes.Add(cnode);
}
}
}
}
trvEstDept.Nodes.Add(Root);
}
private void SetKpiSignalGrid(int KPI_POOL_REF_ID)
{
DataSet dsSignal = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().GetSignalListPerKpiWithBiz(KPI_POOL_REF_ID, PageUtility.GetByValueDropDownList(tab_ddl_grade));
ugrdSignal.Clear();
ugrdSignal.Rows.Clear();
ugrdSignal.DataSource = dsSignal;
ugrdSignal.DataBind();
}
private void GetBscKpiPoolInfo(int kpi_ref_id)
{
DataTable dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().GETBscKpiPoolInfo(kpi_ref_id);
if (dt.Rows.Count == 1)
{
PageUtility.FindByValueDropDownList(tab_ddl_kpiType, dt.Rows[0]["RESULT_ACHIEVEMENT_TYPE"]);
PageUtility.FindByValueDropDownList(tab_ddl_scoreType, dt.Rows[0]["RESULT_TS_CALC_TYPE"]);
PageUtility.FindByValueDropDownList(tab_ddl_caMethod, dt.Rows[0]["MEASUREMENT_GRADE_TYPE"]);
PageUtility.FindByValueDropDownList(tab_ddl_type, dt.Rows[0]["UNIT_TYPE_REF_ID"]);
PageUtility.FindByValueDropDownList(tab_ddl_grade, dt.Rows[0]["RESULT_MEASUREMENT_STEP"]);
PageUtility.FindByValueDropDownList(tab_ddl_reiod, dt.Rows[0]["RESULT_TERM_TYPE"]);
tab_txt_word.Text = dt.Rows[0]["WORD_DEFINITION"].ToString();
tab_txt_MonthCa.Text = dt.Rows[0]["CALC_FORM_MS"].ToString();
tab_txt_fillCa.Text = dt.Rows[0]["CALC_FORM_TS"].ToString();
}
}
public void DoBindingTempleteMap(int templete_code)
{
UltraWebGrid2.Clear();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool bizBscKpiPool = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool();
DataTable dtBscKpiPool = bizBscKpiPool.GetKpiPool_DB(""
, ""
, ""
, 0
, templete_code);
UltraWebGrid2.DataSource = dtBscKpiPool;
UltraWebGrid2.DataBind();
//lblRowCount.Text = dtBscKpiPool.Rows.Count.ToString();
}
public void SetKpiPoolGrid()
{
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool bizBscKpiPool = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool();
DataTable dtBscKpiPool = bizBscKpiPool.GetKpiPool_DB(txtKpiNames.Text.Trim(),
PageUtility.GetByValueDropDownList(ddlUseYn3),
PageUtility.GetByValueDropDownList(ddlKpiType),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlKpiVersion)),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlKpiTemplete)),
DataTypeUtility.GetToInt32(PageUtility.GetByValueDropDownList(ddlUpPoint)),
DataTypeUtility.GetString(PageUtility.GetByValueDropDownList(ddlKpi)));
ugrdKPIPool.Clear();
ugrdKPIPool.DataSource = dtBscKpiPool;
ugrdKPIPool.DataBind();
lblRowCount.Text = dtBscKpiPool.Rows.Count.ToString();
}
public void GetKpiPoolTerm(int KPI_POOL_REF_ID)
{
DataTable dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().GetKpiPoolTerm(KPI_POOL_REF_ID);
if (dt.Rows.Count == 12)
{
tab_ck_1.Checked = (dt.Rows[0]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_2.Checked = (dt.Rows[1]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_3.Checked = (dt.Rows[2]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_4.Checked = (dt.Rows[3]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_5.Checked = (dt.Rows[4]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_6.Checked = (dt.Rows[5]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_7.Checked = (dt.Rows[6]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_8.Checked = (dt.Rows[7]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_9.Checked = (dt.Rows[8]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_10.Checked = (dt.Rows[9]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_11.Checked = (dt.Rows[10]["CHECK_YN"].ToString() == "Y") ? true : false;
tab_ck_12.Checked = (dt.Rows[11]["CHECK_YN"].ToString() == "Y") ? true : false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
if (!Page.IsPostBack)
{
if (type == "T")
{
dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().CoporationKpiTempleteList();
this.lblPopUpTitle.Text = "전략템플릿 조직 KPI";
}
else
{
dt = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().CoporationKpiList();
dt = DataTypeUtility.FilterSortDataTable(dt, "KPI_EXTERNAL_TYPE='INR'");
this.lblPopUpTitle.Text = "조직KPI 풀";
}
ugrdStgList.DataSource = dt;
ugrdStgList.DataBind();
}
}
