protected void ibnSave_Click(object sender, ImageClickEventArgs e) { UltraGridRow row; Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps(); DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema(); for (int i = 0; i < UltraWebGrid1.Rows.Count; i++) { row = UltraWebGrid1.Rows[i]; TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP"); HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID"); TemplatedColumn txt_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP"); TextBox txtTgtEmpName = (TextBox)((CellItem)txt_col.CellItems[row.BandIndex]).FindControl("txtTgtEmpName"); if (hdfTgtEmpID.Value.Equals("")) { row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value; } else { row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value); } } dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1 , new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" } , dataTable); dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL"); foreach (DataRow dataRow in dataTable.Rows) { dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = EST_ID; dataRow["TGT_OPINION_YN"] = "Y"; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; } bool isOK = deptOpinionTgtEmp.SaveDeptOpinionTgtEmp(dataTable, COMP_ID, EST_ID); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자를 설정하였습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다."); } }
protected void ibnUpdateEmpRole_Click(object sender, ImageClickEventArgs e) { UltraGridRow row; Biz_EmpRoleRels empRoleRel = new Biz_EmpRoleRels(); Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps(); DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema(); dataTable.Columns.Add("EMP_REF_ID", typeof(int)); dataTable.Columns.Add("ROLE_REF_ID", typeof(int)); for (int i = 0; i < UltraWebGrid1.Rows.Count; i++) { row = UltraWebGrid1.Rows[i]; TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP"); HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID"); if (hdfTgtEmpID.Value.Equals("")) { row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value; } else { row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value); } } dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1 , new string[] { "TGT_EMP_ID" } , dataTable); dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL"); foreach (DataRow dataRow in dataTable.Rows) { dataRow["EMP_REF_ID"] = dataRow["TGT_EMP_ID"]; dataRow["ROLE_REF_ID"] = ROLE_REF_ID; } bool isOK = empRoleRel.SaveEmpRoleRel(dataTable, ROLE_REF_ID); if (isOK) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자 권한을 부여하였습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("부여된 권한이 없습니다."); } }