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("부여된 권한이 없습니다.");
}
}