private void InitControlValue() { WebCommon.SetEstTermDropDownList(ddlEstTermInfo); int intEstTermId = (ddlEstTermInfo.Items.Count > 0) ? int.Parse(ddlEstTermInfo.SelectedValue) : 0; //Biz_EtcCodeInfos objCode = new Biz_EtcCodeInfos(); //objCode.getResultMethod(ddlResultInput, "", true, 80); WebCommon.SetTermMonthDropDownList(ddlMonthInfo, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); WebCommon.SetSumTypeDropDownList(ddlSumType, false); //WebCommon.SetSortTypeDropDownList(ddlOrderType, true); //this.SetSignalDropDownList(ddlSignal, true); Biz_Bsc_Stg_Info objStg = new Biz_Bsc_Stg_Info(this.IEstTermRefID, this.IStgRefID); lblStg_Name.Text = objStg.Istg_name; Biz_Bsc_Map_Info objDept = new Biz_Bsc_Map_Info(this.IEstTermRefID, this.IEstDeptID, this.IYmd); lblEst_Dept_Name.Text = objDept.Iest_dept_name; ugrdResultStatus.Columns.FromKey("CHAMPION_EMP_NAME").Header.Caption = this.GetText("LBL_00001", "KPI담당자"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DoInitControl(); DoBindingMaster(); DoBindingTree(); Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail(); DataSet dsTerm = bizTerm.GetAllList(IESTTERM_REF_ID); if (dsTerm.Tables[0].Rows.Count > 0) { ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString(); } if (ITERM_MONTH == "") { Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info(); DataSet dsMap2 = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID); if (dsMap2.Tables[0].Rows.Count > 0) { ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString(); } } } ltrScript.Text = ""; }
private void SetFormData(int est_ref_id) { this.IEstTermRefID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo); this.strYMD = PageUtility.GetByValueDropDownList(ddlEstTermMonth); Biz_Bsc_Map_Info objMap = new Biz_Bsc_Map_Info(this.IEstTermRefID, est_ref_id, this.strYMD); this.IMapVersionID = objMap.Imap_version_id; ltEstDeptName.Text = objMap.Iest_dept_name; lblChampName.Text = objMap.Ibscchampion_name; lblSTGMapName.Text = objMap.Idept_vision; Biz_Bsc_Map_Kpi objKpi = new Biz_Bsc_Map_Kpi(); DataSet rDs = objKpi.GetWeightPerStg(this.IEstTermRefID, est_ref_id, this.strYMD); if (rDs.Tables.Count > 0) { if (rDs.Tables[0].Rows.Count > 0) { rDs.Tables[0].Columns.Add("PARENT_STG", typeof(string)); Biz_Bsc_Map_Stg_Parent objPrt = new Biz_Bsc_Map_Stg_Parent(); int iRow = rDs.Tables[0].Rows.Count; string sUpStg = ""; for (int i = 0; i < iRow; i++) { objPrt.Iestterm_ref_id = int.Parse(rDs.Tables[0].Rows[i]["ESTTERM_REF_ID"].ToString()); objPrt.Iest_dept_ref_id = int.Parse(rDs.Tables[0].Rows[i]["EST_DEPT_REF_ID"].ToString()); objPrt.Imap_version_id = int.Parse(rDs.Tables[0].Rows[i]["MAP_VERSION_ID"].ToString()); objPrt.Istg_ref_id = int.Parse(rDs.Tables[0].Rows[i]["STG_REF_ID"].ToString()); DataSet pDs = objPrt.GetParentStgList (objPrt.Iestterm_ref_id , objPrt.Iest_dept_ref_id , objPrt.Imap_version_id , objPrt.Istg_ref_id); sUpStg = ""; if (pDs.Tables.Count > 0) { for (int k = 0; k < pDs.Tables[0].Rows.Count; k++) { sUpStg += (k == 0) ? pDs.Tables[0].Rows[k]["UP_STG_REF_ID"].ToString() : "," + pDs.Tables[0].Rows[k]["UP_STG_REF_ID"].ToString(); } } rDs.Tables[0].Rows[i]["PARENT_STG"] = sUpStg; } } } ugrdStgList.Clear(); ugrdStgList.DataSource = rDs; ugrdStgList.DataBind(); }
private void DoBinding() { ltEstDeptName.Text = lblSTGMapName.Text = lblChampName.Text = ""; this.IESTTERM_REF_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo); Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map(); DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID); IMAP_VERSION_ID = 1; if (dsMap.Tables[0].Rows.Count > 0) { ltEstDeptName.Text = dsMap.Tables[0].Rows[0]["EST_DEPT_NAME"].ToString(); lblSTGMapName.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString(); lblChampName.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString(); IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]); } Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail(); DataSet dsTerm = bizTerm.GetAllList(IESTTERM_REF_ID); if (dsTerm.Tables[0].Rows.Count > 0) { ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString(); } if (ITERM_MONTH == "") { Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info(); DataSet dsMap2 = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID); if (dsMap2.Tables[0].Rows.Count > 0) { ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString(); } } DataSet dsList = bizMap.GetWorkMapTotalList_DB(); ugrdStgList.Clear(); ugrdStgList.DataSource = dsList.Tables[0]; ugrdStgList.DataBind(); }
private void SetCtrlSetting(int estterm_ref_id, int est_dept_ref_id, int tmcode) { //StrategyMapInfos stgMap = new StrategyMapInfos(estterm_ref_id, est_dept_ref_id); MicroBSC.BSC.Biz.Biz_Bsc_Map_Info stgMap = new Biz_Bsc_Map_Info(estterm_ref_id, est_dept_ref_id, PageUtility.GetByValueDropDownList(ddlMonthInfo)); MicroBSC.Biz.Common.EmpInfos empInfo = new MicroBSC.Biz.Common.EmpInfos(stgMap.Ibscchampion_emp_id); ltrStgMapVision.Text = stgMap.Idept_vision; ltrStgMapChamp.Text = empInfo.Emp_Name; SetViewScoreGrid(estterm_ref_id, est_dept_ref_id, tmcode); string view_kpi_str = (ViewKPI) ? "1" : "0"; string url = "../usr/usr_stg_map.aspx?ESTTERM_REF_ID=" + estterm_ref_id.ToString() + "&EST_DEPT_REF_ID=" + est_dept_ref_id.ToString() + "&TMCODE=" + tmcode + "&LINE_TYPE=" + "0" + "&SHOW_KPI_LIST=" + view_kpi_str; ifm.Attributes.Add("src", Server.UrlDecode(url)); }