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(); } }