private void SetCtrlSetting(int estterm_ref_id, int est_dept_ref_id) { Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map(); //DataSet dsMap = bizMap.GetWorkMapTotalList(estterm_ref_id, est_dept_ref_id); DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(estterm_ref_id, est_dept_ref_id); if (dsMap.Tables[0].Rows.Count > 0) { ltrStgMapVision.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString(); ltrStgMapChamp.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString(); this.IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]); } Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail(); string strYMD = bizTerm.GetReleasedMonth(); this.IYMD = (strYMD == "000000" ? DataTypeUtility.GetToInt32(DateTime.Now.ToString("yyyyMM")) : DataTypeUtility.GetToInt32(strYMD)); SetViewScoreGrid(estterm_ref_id, est_dept_ref_id, this.IYMD); 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() + "&MAP_VERSION_ID=" + this.IMAP_VERSION_ID + "&TMCODE=" + this.IYMD + "&LINE_TYPE=0" + "&SHOW_KPI_LIST=" + view_kpi_str + "&WORKINGMAPYN=T"; ifm.Attributes.Add("src", Server.UrlDecode(url)); }
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 = ""; }
protected void iBtnSave_Click(object sender, ImageClickEventArgs e) { object[] objList = GetSelectKpiList(); Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); DataSet dsYear = objTerm.GetTermDetail(ESTTERM_REF_ID); if (dsYear.Tables[0].Rows.Count < 1) { ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요."); return; } Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info(); //if (objMBO.CopyKpiToMbo(ESTTERM_REF_ID // , objList // , gUserInfo.Emp_Ref_ID // , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4) // , "STG")) //{ // DoBindingDept(); // DoBinding(); // ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다."); //} //else //{ // ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다."); //} int checkCount = 0; for (int i = 0; i < objList.Length; i++) { checkCount += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheckPerson(int.Parse(objList[i].ToString()), gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID); } if (checkCount > 0) { Response.Write("<script>alert('중복되는 KPI 풀입니다.');</script>"); } else { string returnStr = objMBO.CopyKpiToMbo_NW(ESTTERM_REF_ID , objList , gUserInfo.Emp_Ref_ID , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4) , "STG"); if (returnStr.Equals(string.Empty)) { DoBindingDept(); ltrScript.Text = JSHelper.GetAlertOpenerReflashScript("복사를 완료하였습니다.", true); } else { ltrScript.Text = JSHelper.GetAlertScript(returnStr); } } }
private void SetTermList() { Biz_Bsc_Term_Detail objTrm = new Biz_Bsc_Term_Detail(); DataSet rDs = objTrm.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTerm)); ugrdTerm.Clear(); ugrdTerm.DataSource = rDs; ugrdTerm.DataBind(); }
protected void ibtnInsert_Click(object sender, ImageClickEventArgs e) { object[] objList = GetSelectKpiList(); Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); DataSet dsYear = objTerm.GetTermDetail(PageUtility.GetIntByValueDropDownList(ddlEstTerm)); if (dsYear.Tables[0].Rows.Count < 1) { ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요."); return; } Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info(); //if (objMBO.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm) // , objList // , gUserInfo.Emp_Ref_ID // , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4) // , "STG")) //{ // DoBindingDept(); // DoBinding(); // ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다."); //} //else //{ // ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다."); //} string returnStr = objMBO.CopyKpiToMbo_NW(PageUtility.GetIntByValueDropDownList(ddlEstTerm) , objList , gUserInfo.Emp_Ref_ID , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4) , "STG"); if (returnStr.Equals(string.Empty)) { DoBindingDept(); DoBinding(); ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript(returnStr); } }
protected void ibtnInsert2_Click(object sender, ImageClickEventArgs e) { object[] objList = GetSelectTeamMboList(); Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); DataSet dsYear = objTerm.GetTermDetail(PageUtility.GetIntByValueDropDownList(ddlEstTerm)); if (dsYear.Tables[0].Rows.Count < 1) { ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요."); return; } Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info(); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info(); bool Result = bizBscKpiInfo.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm) , objList , gUserInfo.Emp_Ref_ID , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4) , "PRS"); /* * bool Result = objMBO.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm) * , objList * , gUserInfo.Emp_Ref_ID * , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4) * , "PRS"); */ if (Result) { DoBindingDeptMBO(); DoBinding(); ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다."); } else { Response.Write(objMBO.Transaction_Message); ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다."); } }
/// <summary> /// 평가기간 /// </summary> /// <param name="ddl"></param> public static void BindEstTerm(DropDownList ddl) { TermInfos term = new TermInfos(); DataSet ds = term.GetAllList(); ddl.DataSource = ds; ddl.DataTextField = "ESTTERM_NAME"; ddl.DataValueField = "ESTTERM_REF_ID"; ddl.DataBind(); // 배포되어있는 평가월의 평가기간을 가져온다 Biz_Bsc_Term_Detail objTD = new Biz_Bsc_Term_Detail(); ddl.ClearSelection(); if (ddl.Items.FindByValue(objTD.GetOpenEstTermID().ToString()) != null) { ddl.Items.FindByValue(objTD.GetOpenEstTermID().ToString()).Selected = true; } }
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(); }
/// <summary> /// 생성쿼리 검증 /// </summary> public void SetQueryValidate() { Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); string sSYmd = objTerm.GetStartEstMonth(); string sCYmd = objTerm.GetReleasedMonth(); decimal dRtnVal = 0; string sRtnMsg = ""; bool bIsSuccess = false; this.IisValidQuery = "Y"; Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(); // 인터페이스 리스트 DataSet rDs = objQry.GetInterfaceData(txtQUERY_AL.Text, sCYmd, out sRtnMsg, out bIsSuccess); lblSuccessAl.Text = sRtnMsg; lblSuccessAl.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red; if (!bIsSuccess) { this.IisValidQuery = "N"; } // 당월실적 쿼리결과 dRtnVal = objQry.GetInterfaceResultMs(txtQUERY_MS.Text, sCYmd, out sRtnMsg, out bIsSuccess); lblSuccessMs.Text = sRtnMsg; lblSuccessMs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red; if (!bIsSuccess) { this.IisValidQuery = "N"; } // 누적실적 쿼리결과 dRtnVal = objQry.GetInterfaceResultTs(txtQUERY_TS.Text, sSYmd, sCYmd, out sRtnMsg, out bIsSuccess); lblSuccessTs.Text = sRtnMsg; lblSuccessTs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red; if (!bIsSuccess) { this.IisValidQuery = "N"; } }
public void SetPreviewGrid() { Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column(); DataSet rDs = objCol.GetAllList(this.IDiCode, gUserInfo.Emp_Ref_ID); int iRow = 0; string sUseYn = "N"; string sColKey = ""; string sColName = ""; int iDPoints = 0; int iGridWith = 0; UltraGridColumn ugCol; if (rDs.Tables.Count > 0) { iRow = rDs.Tables[0].Rows.Count; if (iRow > 0) { ugCol = new UltraGridColumn(); ugCol.Key = "YMD"; ugCol.BaseColumnName = "YMD"; ugCol.Header.Caption = "평가월"; ugCol.Width = Unit.Pixel(50); ugCol.AllowUpdate = AllowUpdate.No; ugCol.DataType = "System.String"; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Center; ugrdPreview.Columns.Add(ugCol); ugCol = new UltraGridColumn(); ugCol.Key = "DD"; ugCol.BaseColumnName = "DD"; ugCol.Header.Caption = "발생일자"; ugCol.Width = Unit.Pixel(35); ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.DataType = "System.String"; ugCol.Header.Style.Wrap = true; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Center; ugrdPreview.Columns.Add(ugCol); for (int i = 0; i < iRow; i++) { sUseYn = rDs.Tables[0].Rows[i]["USE_YN"].ToString(); sColKey = rDs.Tables[0].Rows[i]["COLUMN_ID"].ToString(); sColName = rDs.Tables[0].Rows[i]["COLUMN_ALIAS"].ToString(); iDPoints = Convert.ToInt32(rDs.Tables[0].Rows[i]["DECIMAL_POINTS"].ToString()); iGridWith = Convert.ToInt32(rDs.Tables[0].Rows[i]["GRID_WIDTH"].ToString()); if (sUseYn == "Y") { if (sColKey.Substring(0, 7) == "SVALUES") { ugCol = new UltraGridColumn(); ugCol.Key = sColKey; ugCol.BaseColumnName = sColKey; ugCol.Header.Caption = sColName; ugCol.Width = Unit.Pixel(iGridWith); ugCol.DataType = "System.String"; ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Left; ugrdPreview.Columns.Add(ugCol); } else { ugCol = new UltraGridColumn(); ugCol.Key = sColKey; ugCol.BaseColumnName = sColKey; ugCol.Header.Caption = sColName; ugCol.Width = Unit.Pixel(iGridWith); ugCol.AllowUpdate = AllowUpdate.Yes; ugCol.DataType = "System.Double"; ugCol.Format = "#,###,###,###,###,###,###,##0" + this.GetFormatPoints(iDPoints); ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Right; ugrdPreview.Columns.Add(ugCol); } } } } } Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); string sEstMon = objTerm.GetReleasedMonth(); Random rndObj = new Random(); for (int i = 0; i < 11; i++) { ugrdPreview.Rows.Add(); for (int j = 0; j < ugrdPreview.Columns.Count; j++) { if (ugrdPreview.Columns[j].DataType == "System.String") { if (ugrdPreview.Columns[j].Key == "YMD") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = sEstMon; } else if (ugrdPreview.Columns[j].Key == "DD") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = Convert.ToString(rndObj.Next(1, 31)).PadLeft(2, '0'); } else { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = "String" + i.ToString(); } } else if (ugrdPreview.Columns[j].DataType == "System.Date") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = DateTime.Now; } else if (ugrdPreview.Columns[j].DataType == "System.Double") { ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = rndObj.NextDouble() * rndObj.Next(1000, 1000000); } } } ugrdPreview.Visible = true; }
protected void iBtnSave_Click(object sender, ImageClickEventArgs e) { object[] objList = GetSelectKpiList(UltraWebGrid2); Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail(); DataSet dsYear = objTerm.GetTermDetail(ESTTERM_REF_ID); if (dsYear.Tables[0].Rows.Count < 1) { ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요."); return; } string result_measurement_step = "LV5"; MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info bizComCodeInfo = new MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info(); DataTable dtComCodeInfo = bizComCodeInfo.getCheckStep(0).Tables[0]; DataRow[] rows = dtComCodeInfo.Select(" USE_YN = 'Y' ", "SORT_ORDER DESC"); if (rows.Length > 0) { result_measurement_step = DataTypeUtility.GetValue(rows[0]["ETC_CODE"]); } int unit_type_ref_id = 1; MicroBSC.Biz.Common.Biz.Biz_Com_Unit_Type_Info bizComUnitTypeInfo = new MicroBSC.Biz.Common.Biz.Biz_Com_Unit_Type_Info(); DataTable dtComUnitTypeInfo = bizComUnitTypeInfo.GetAllList().Tables[0]; if (dtComUnitTypeInfo.Rows.Count > 0) { unit_type_ref_id = DataTypeUtility.GetToInt32(dtComUnitTypeInfo.Rows[0]["UNIT_TYPE_REF_ID"]); } Biz_Bsc_Threshold_Step bizBscThresholdStep = new Biz_Bsc_Threshold_Step(); DataTable dtBscThresholdStep = bizBscThresholdStep.GetThresholdLevelList(result_measurement_step).Tables[0]; int checkCount = 0; for (int i = 0; i < objList.Length; i++) { checkCount += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheckPerson(int.Parse(objList[i].ToString()), gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID); } if (checkCount > 0) { Response.Write("<script>alert('중복되는 KPI 풀입니다.');</script>"); } else { MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info(); string returnStr = bizBscKpiInfo.CopyKpiToMboUsingTemplete(ESTTERM_REF_ID , objList , TEMPLETE_ID , TEMPLETE_NAME , gUserInfo.Emp_Ref_ID , DateTime.Now.ToString("yyyy-MM-dd") , result_measurement_step , unit_type_ref_id , "PRS" , dtBscThresholdStep); if (returnStr.Equals(string.Empty)) { DoBindingTemplete(); ltrScript.Text = JSHelper.GetAlertOpenerReflashScript("복사를 완료하였습니다.", true); } else { ltrScript.Text = JSHelper.GetAlertScript(returnStr); } } }