private void DeleteEmpEstProjectMapGrid() { Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap(); DataTable dataTable = objPrjEmpEstPrjMap.GetDataTableSchema(); dataTable = UltraGridUtility.GetDataTableByCheckValue(ugrdPrjList , "cBox" , "selchk" , new string[] { "PRJ_REF_ID", "EST_DEPT_ID", "EST_EMP_ID" } , dataTable); foreach (DataRow dataRow in dataTable.Rows) { dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = EST_ID; dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID; dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID; } bool isOK = objPrjEmpEstPrjMap.RemovePrjEmpEstPrjMap(dataTable); if (!isOK) { ltrScript.Text = JSHelper.GetAlertScript("삭제할 항목을 선택주세요.", false); } else { BindingProjectMap(); } }
private void AddPrjectData() { Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap(); DataTable dataTable = objPrjEmpEstPrjMap.GetDataTableSchema(); string[] prj_values = hdfPrjRefID.Value.Split(','); for (int i = 0; i < prj_values.Length; i++) { if (!objPrjEmpEstPrjMap.IsExist(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , DataTypeUtility.GetToInt32(this.hdfEstDeptID.Value) , DataTypeUtility.GetToInt32(this.hdfEstEmpID.Value) , DataTypeUtility.GetToInt32(prj_values[i]))) { DataRow dataRow = null; dataRow = dataTable.NewRow(); dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = EST_ID; dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dataRow["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID; dataRow["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID; dataRow["EST_DEPT_ID"] = DataTypeUtility.GetToInt32(this.hdfEstDeptID.Value); dataRow["EST_EMP_ID"] = DataTypeUtility.GetToInt32(this.hdfEstEmpID.Value); dataRow["PRJ_REF_ID"] = prj_values[i]; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; dataTable.Rows.Add(dataRow); } } bool isOK = objPrjEmpEstPrjMap.AddPrjEmpEstPrjMap(dataTable); if (isOK) { BindingProjectMap(); } else { ltrScript.Text = JSHelper.GetAlertScript("프로젝트 추가에 실패하였습니다.", false); } }