private void DoBinding() { DataSet ds; MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result(); int emp_id = this.gUserInfo.Emp_Ref_ID; if (this.EMP_ROLES.Contains("1") || this.EMP_ROLES.Contains("8")) { emp_id = 0; } ds = bizBscKpiResult.SelectKpiList(_iestterm_ref_id, _iest_dept_id, _iymd, emp_id); this.ugridKpiTargetList.DataSource = ds; this.ugridKpiTargetList.DataBind(); lblRowCount.Text = ugridKpiTargetList.Rows.Count.ToString(); DataRow[] rows = ds.Tables[0].Select(" CLOSE_YN = 'Y' "); if (rows.Length > 0) { lblMsg.Text = "마감된 평가 기간 입니다."; iBtnApply.Visible = false; iBtnUpdate.Visible = false; } else { lblMsg.Text = string.Empty; iBtnApply.Visible = true; iBtnUpdate.Visible = true; } }
private void DoBinding() { MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result(); int emp_id = this.gUserInfo.Emp_Ref_ID; if (this.EMP_ROLES.Contains("1") || this.EMP_ROLES.Contains("8")) { emp_id = 0; } DS_DATA = bizBscKpiResult.SelectKpiTargetList(_iestterm_ref_id, _iest_dept_id, _iymd, emp_id); this.ugridKpiTargetList.Clear(); this.ugridKpiTargetList.DataSource = DS_DATA; this.ugridKpiTargetList.DataBind(); lblRowCount.Text = ugridKpiTargetList.Rows.Count.ToString(); }
public void SetResultListGrid() { DataSet ds; //MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result(); //if (((SitePrincipal)this.User).Roles.Contains("1") == true || ((SitePrincipal)this.User).Roles.Contains("8") == true) // ds = objBSC.SelectKpiResultYear(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), (txtDeptCode.Value == string.Empty ? 0 : int.Parse(txtDeptCode.Value)), 0); //else // ds = objBSC.SelectKpiResultYear(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), (txtDeptCode.Value == string.Empty ? 0 : int.Parse(txtDeptCode.Value)), this.gUserInfo.Emp_Ref_ID); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result(); int emp_id = this.gUserInfo.Emp_Ref_ID; if (this.EMP_ROLES.Contains("1") || this.EMP_ROLES.Contains("8")) { emp_id = 0; } ds = bizBscKpiResult.SelectKpiResultYear(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , (txtDeptCode.Value == string.Empty ? 0 : int.Parse(txtDeptCode.Value)) , emp_id); this.ugridKpiTargetList.Clear(); this.ugridKpiTargetList.DataSource = ds.Tables[0]; this.ugridKpiTargetList.DataBind(); lblRowCount.Text = (ugridKpiTargetList.Rows.Count).ToString(); //MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result(); DataTable dtBscThresholdCode = bizBscKpiResult.SelectKpiResultYear_BscThresholdCode().Tables[0]; dtTH = dtBscThresholdCode; }
protected void iBtnUpdate_Click(object sender, EventArgs e) { //setUpdate(); DataTable dtResult = new DataTable(); dtResult.Columns.Add("ESTTERM_REF_ID"); dtResult.Columns.Add("KPI_REF_ID"); dtResult.Columns.Add("YMD"); dtResult.Columns.Add("RESULT_MS"); dtResult.Columns.Add("RESULT_TS"); dtResult.Columns.Add("APP_REF_ID"); dtResult.Columns.Add("CHECK_APPING_YN"); int iesttermRefId; int ikpiRefId; string iymd; int itxrUser; double iresultMs; double iresultTs; TemplatedColumn template; CellItem cellItemObject; Infragistics.WebUI.WebDataInput.WebNumericEdit inputTxt; TemplatedColumn col_cBox; CheckBox cBox; foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow row in this.ugridKpiTargetList.Rows) { iesttermRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("estTermRefId").Value); ikpiRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("kpiRefId").Value); iymd = DataTypeUtility.GetValue(row.Cells.FromKey("estYmd").Value); itxrUser = DataTypeUtility.GetToInt32(this.USERID); template = (TemplatedColumn)row.Cells.FromKey("resultMs").Column; cellItemObject = (CellItem)template.CellItems[row.Index]; inputTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultMs"); iresultMs = inputTxt.ValueDouble; template = (TemplatedColumn)row.Cells.FromKey("resultTs").Column; cellItemObject = (CellItem)template.CellItems[row.Index]; inputTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultTs"); iresultTs = inputTxt.ValueDouble; col_cBox = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl("cBox"); string check_apping_yn = DataTypeUtility.GetBooleanToYN(cBox.Checked); DataRow rowResult = dtResult.NewRow(); rowResult["ESTTERM_REF_ID"] = iesttermRefId; rowResult["KPI_REF_ID"] = ikpiRefId; rowResult["YMD"] = iymd; rowResult["RESULT_MS"] = iresultMs; rowResult["RESULT_TS"] = iresultTs; rowResult["APP_REF_ID"] = iesttermRefId; rowResult["CHECK_APPING_YN"] = check_apping_yn; dtResult.Rows.Add(rowResult); } string pagePath = this.Page.Request.Url.AbsolutePath; MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result(); string returnVal = bizBscKpiResult.ModifyKpiResultDataBulker_DB(dtResult , "" , this.gUserInfo.Emp_Ref_ID , DateTime.Now.ToString("yyyy-MM-dd")); string msg = returnVal; if (returnVal.Equals(string.Empty)) { msg = "저장 되었습니다."; } ltrScript.Text = JSHelper.GetAlertScript(msg); }
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { string col_goal = "GOAL_MS"; string col_target = "TARGET_MS"; string col_result = "RESULT_MS"; string col_goal_dal = "GOAL_DAL_MS"; string col_target_dal = "TARGET_DAL_MS"; if (rdoMethod.SelectedIndex.Equals(1)) { col_goal = "GOAL_TS"; col_target = "TARGET_TS"; col_result = "RESULT_TS"; col_goal_dal = "GOAL_DAL_TS"; col_target_dal = "TARGET_DAL_TS"; } double goal_p = 0; double target_p = 0; double result = 0; double goal_dal = 0; double target_dal = 0; DataRowView drw = (DataRowView)e.Data; int kpi_ref_id = DataTypeUtility.GetToInt32(e.Row.Cells.FromKey("KPI_REF_ID").Value); // 목표 MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target_Goal bizBscKpiTargetGoal = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target_Goal(); DataTable dtBscKpiTargetGoal = bizBscKpiTargetGoal.GetBscKpiTargetGoalTong_DB(IEstTermRefID , kpi_ref_id , IYmd); if (dtBscKpiTargetGoal.Rows.Count > 0) { goal_p = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTargetGoal.Rows[0][col_goal]).Replace("-", "0")); goal_dal = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTargetGoal.Rows[0][col_goal_dal]).Replace("-", "0")); } // 실적 MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result(); DataTable dtBscKpiResult = bizBscKpiResult.GetBscKpiTargetGoalTong_DB(IEstTermRefID , kpi_ref_id , IYmd); if (dtBscKpiResult.Rows.Count > 0) { result = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiResult.Rows[0][col_result]).Replace("-", "0")); } // 달성율 MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target bizBscKpiTarget = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target(); DataTable dtBscKpiTarget = bizBscKpiTarget.GetBscKpiTargetGoalTong_DB(IEstTermRefID , kpi_ref_id , IYmd); if (dtBscKpiTarget.Rows.Count > 0) { target_p = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTarget.Rows[0][col_target]).Replace("-", "0")); target_dal = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTarget.Rows[0][col_target_dal]).Replace("-", "0")); } e.Row.Cells.FromKey("GOAL_P").Value = goal_p; e.Row.Cells.FromKey("TARGET_P").Value = target_p; e.Row.Cells.FromKey("RESULT").Value = result; e.Row.Cells.FromKey("GOAL_DAL").Value = goal_dal; e.Row.Cells.FromKey("TARGET_DAL").Value = target_dal; }
// 탬플릿을 이용한 kpi 복사 public string CopyKpiToMboUsingTemplete(int estterm_ref_id , object[] objKpiPoolList , string templete_id , string templete_name , int emp_ref_id , string nowDate , string result_measurement_step , int unit_type_ref_id , string class_type , DataTable dtBscThresholdStep) { string reVal = string.Empty; MicroBSC.BSC.Dac.Dac_Bsc_Kpi_Info dac = new MicroBSC.BSC.Dac.Dac_Bsc_Kpi_Info(); Dac_Bsc_Mbo_Kpi_Classification dacBscMboKpiClassification = new Dac_Bsc_Mbo_Kpi_Classification(); Dac_Bsc_Kpi_Target_Version dacBscKpiTargetVersion = new Dac_Bsc_Kpi_Target_Version(); Dac_Bsc_Kpi_Result dacBscKpiResult = new Dac_Bsc_Kpi_Result(); Dac_Com_Emp_Role_Rel dacEmpRoleRel = new Dac_Com_Emp_Role_Rel(); Dac_Bsc_Kpi_Term dacBscKpiTerm = new Dac_Bsc_Kpi_Term(); Dac_Bsc_Kpi_Target dacBscKpiTarget = new Dac_Bsc_Kpi_Target(); Dac_Bsc_Kpi_Threshold_Info dacBscKpiThresholdInfo = new Dac_Bsc_Kpi_Threshold_Info(); Dac_Bsc_Kpi_Initiative dacBscKpiInitiative = new Dac_Bsc_Kpi_Initiative(); int rtn_kpi_ref_id = 0; int affectedRow = 0; bool Result; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { //for (int i = 0; i < objList.Length; i++) //{ // DataTable dt = dacBscMboKpiClassification.Select_DB(conn, trx, estterm_ref_id, emp_ref_id, 0, objList[i], ""); // if (dt.Rows.Count > 0 && DataTypeUtility.GetToInt32(dt.Rows[0]["ESTTERM_REF_ID"]) > 0) // return false; //} MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new Biz_Bsc_Kpi_Result(); for (int i = 0; i < objKpiPoolList.Length; i++) { rtn_kpi_ref_id = dac.SelectMaxBscKpiInfo_DB(conn, trx); object kpi_pool_ref_id = objKpiPoolList[i]; #region 기존 코드에서 strQuery1 //KPI INFO COPY int okCnt = _data.InsertData_DB(conn , trx , estterm_ref_id , rtn_kpi_ref_id , rtn_kpi_ref_id , kpi_pool_ref_id , string.Format("{0}_{1}", templete_id, templete_name) , "" , emp_ref_id , "MAN" , "ATY" , "ETC" , result_measurement_step , "RATE" , unit_type_ref_id , 1 , "" , "" , "N" , "N" , "N" , "Y" , nowDate , emp_ref_id); //MAX KPI_REF_ID //rtn_kpi_ref_id = _data.Select_Max_Kpi_Ref_Id(conn, trx); //KPI TARGET VERSION INSERT dacBscKpiTargetVersion.Insert_DB(conn, trx , estterm_ref_id , rtn_kpi_ref_id , 1 , "당초계획" , "당초계획(자동생성)" , 1 , 12 , "Y" , emp_ref_id); //Champion Role Insert dacEmpRoleRel.Delete_DB(conn, trx, emp_ref_id, 3); dacEmpRoleRel.Insert_DB(conn, trx, emp_ref_id, 3); //지표구분테이블에 일상업무정보 추가 BSC_MBO_KPI_CLASSIFICATION dacBscMboKpiClassification.Insert_DB(conn , trx , estterm_ref_id , emp_ref_id , rtn_kpi_ref_id , rtn_kpi_ref_id , class_type , emp_ref_id); #endregion affectedRow = 0; if (rtn_kpi_ref_id > 0) { string year = DateTime.Now.Year.ToString(); #region 기존코드에서 strQuery2 for (int k = 1; k < 13; k++) { string month = k.ToString().PadLeft(2, '0'); string ymd = year + month; //KPI RESULT INSERT affectedRow += bizBscKpiResult.InsertData_DB(conn , trx , estterm_ref_id , rtn_kpi_ref_id , ymd , 0 , 0 , ymd , 0 , 0 , "N" , "" , "" , "" , "" , "" , "" , "" , "" , nowDate , emp_ref_id); dacBscKpiTerm.Insert_DB(conn , trx , estterm_ref_id , rtn_kpi_ref_id , ymd , "N" , "N" , "N" , emp_ref_id); dacBscKpiTarget.InsertData_DB(conn , trx , estterm_ref_id , rtn_kpi_ref_id , 1 , ymd , 0 , 0 , emp_ref_id); dacBscKpiInitiative.InsertData_DB(conn , trx , estterm_ref_id , rtn_kpi_ref_id , ymd , DBNull.Value , DBNull.Value , DBNull.Value , DBNull.Value , emp_ref_id); } if (affectedRow != 12) { return("false"); } #endregion //////////////////////////////////////////////////// // KPI THRESHOLD //////////////////////////////////////////////////// for (int k = 0; k < dtBscThresholdStep.Rows.Count; k++) { string threshold_ref_id = DataTypeUtility.GetValue(dtBscThresholdStep.Rows[k]["THRESHOLD_REF_ID"]); dacBscKpiThresholdInfo.InsertData_DB(conn , trx , estterm_ref_id , rtn_kpi_ref_id , threshold_ref_id , result_measurement_step , 0 , 0 , 0 , 0 , nowDate , emp_ref_id); } } } trx.Commit(); } catch (Exception ex) { reVal = ex.Message; trx.Rollback(); rtn_kpi_ref_id = 0; } finally { conn.Close(); } return(reVal); }