private int CopyKpiList() { Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi(); objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); objBSC.Igroup_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstGroup); objBSC.Iest_level = PageUtility.GetIntByValueDropDownList(ddlEstLevel); objBSC.Itxr_user = gUserInfo.Emp_Ref_ID; int intRtn = objBSC.CopyValuationKpiList(objBSC.Iestterm_ref_id, objBSC.Igroup_ref_id, objBSC.Iest_level, this.IValidationUserID, objBSC.Itxr_user); ltrScript.Text = JSHelper.GetAlertScript(objBSC.Transaction_Message, false); return(intRtn); }
private void SetKpiListPerValidationUser() { Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi(); DataSet rDs = objBSC.GetKpiListPerValidationUser (PageUtility.GetIntByValueDropDownList(ddlEstTerm) , "" , "" , "" , "Y" , "" , 0 //PageUtility.GetIntByValueDropDownList(ddlEstDept) , PageUtility.GetIntByValueDropDownList(ddlEstGroup) , PageUtility.GetIntByValueDropDownList(ddlEstLevel) , this.IValidationUserID); ugrdSelectValidationList.Clear(); ugrdSelectValidationList.DataSource = rDs; ugrdSelectValidationList.DataBind(); }
private int AddKpiPerValidationUser() { CheckBox chk; UltraGridRow row; TemplatedColumn col; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdKpiList.Rows.Count; Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi(); for (int i = 0; i < intRow; i++) { row = ugrdKpiList.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (chk.Checked) { chk.Checked = false; objBSC.Iemp_ref_id = this.IValidationUserID; objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); objBSC.Igroup_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstGroup); objBSC.Iest_level = PageUtility.GetIntByValueDropDownList(ddlEstLevel); objBSC.Ikpi_ref_id = Convert.ToInt32(row.Cells.FromKey("KPI_REF_ID").Value.ToString()); objBSC.Itxr_user = intTxrUser; objBSC.Iopinion = ""; intRtn += objBSC.InsertData(objBSC.Iestterm_ref_id , objBSC.Igroup_ref_id , objBSC.Iest_level , objBSC.Iemp_ref_id , objBSC.Ikpi_ref_id , objBSC.Iopinion , objBSC.Itxr_user); } } return(intRtn); }
private int RemoveKpiPerValidationUser() { CheckBox chk; UltraGridRow row; TemplatedColumn col; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdSelectValidationList.Rows.Count; Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi(); for (int i = 0; i < intRow; i++) { row = ugrdSelectValidationList.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (chk.Checked) { chk.Checked = false; objBSC.Iestterm_ref_id = Convert.ToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value.ToString()); objBSC.Igroup_ref_id = Convert.ToInt32(row.Cells.FromKey("GROUP_REF_ID").Value.ToString()); objBSC.Iest_level = Convert.ToInt32(row.Cells.FromKey("EST_LEVEL").Value.ToString()); objBSC.Iemp_ref_id = Convert.ToInt32(row.Cells.FromKey("EMP_REF_ID").Value.ToString()); objBSC.Ikpi_ref_id = Convert.ToInt32(row.Cells.FromKey("KPI_REF_ID").Value.ToString()); objBSC.Itxr_user = intTxrUser; intRtn += objBSC.DeleteData(objBSC.Iestterm_ref_id , objBSC.Igroup_ref_id , objBSC.Iest_level , objBSC.Iemp_ref_id , objBSC.Ikpi_ref_id , objBSC.Itxr_user); } } return(intRtn); }
/// <summary> /// 지표미적용리스트 /// </summary> private void SetTargetKpiListNotAllocate() { Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi(); DataSet rDs = objBSC.GetKpiListNotAllocate (PageUtility.GetIntByValueDropDownList(ddlEstTerm) , "" , txtKPICode.Text , txtKPIName.Text , "Y" , txtChamName.Text , PageUtility.GetIntByValueDropDownList(ddlEstDept) , PageUtility.GetIntByValueDropDownList(ddlEstGroup) , PageUtility.GetIntByValueDropDownList(ddlEstLevel) , this.IValidationUserID , PageUtility.GetByValueDropDownList(ddlKpiGroup) , PageUtility.GetByValueDropDownList(ddlBASIS_USE_YN) ); ugrdKpiList.Clear(); ugrdKpiList.DataSource = rDs; ugrdKpiList.DataBind(); }
private void SetTargetKpiList() { Biz_Bsc_Validation_Group_Kpi objBSC = new Biz_Bsc_Validation_Group_Kpi(); DataSet rDs = objBSC.GetKpiListPerValidationTarget (PageUtility.GetIntByValueDropDownList(ddlEstTerm) , "" , txtKPICode.Text , txtKPIName.Text , "Y" , txtChamName.Text , PageUtility.GetIntByValueDropDownList(ddlEstDept) , PageUtility.GetIntByValueDropDownList(ddlEstGroup) , PageUtility.GetIntByValueDropDownList(ddlEstLevel) , this.IValidationUserID , PageUtility.GetByValueDropDownList(ddlKpiGroup) , PageUtility.GetByValueDropDownList(ddlBASIS_USE_YN) ); ugrdKpiList.Clear(); ugrdKpiList.DataSource = rDs; ugrdKpiList.DataBind(); lblCntKpiTarget.Text = rDs.Tables[0].Rows.Count.ToString(); }