protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
{
if (e.SelectedRows[0] != null)
{
imgAdd.Visible = true;
iBtnPrjRemove.Visible = true;
ibnConfirm.Visible = true;
this.ugrdPrjList.Clear();
this.hdfEstEmpID.Value = e.SelectedRows[0].Cells.FromKey("EST_EMP_ID").Value.ToString();
this.hdfEstDeptID.Value = e.SelectedRows[0].Cells.FromKey("EST_DEPT_ID").Value.ToString();
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataSet ds = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("EST_DEPT_ID").Value)
, DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("EST_EMP_ID").Value)
, 0);
ugrdPrjList.DataSource = ds;
ugrdPrjList.DataBind();
}
}
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 BindingGrid(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id)
{
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataSet ds = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(comp_id, est_id, estterm_ref_id, estterm_sub_id, 0, 0, 0, 0);
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
}
protected void ibnConfirm_Click(object sender, ImageClickEventArgs e)
{
//bool isJobOK = EstJobUtility.SetConfirmButtonVisible(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_JOB_ID
// , ibnConfirm
// , ibnConfirmCancel
// , "Y"
// , DateTime.Now
// , EMP_REF_ID
// , ltrScript);
//// 만약 이전에 처리하지 않은 작업이 있다면 아래의 내용을 처리하지 못함
//if (!isJobOK)
// return;
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataTable dataTable = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, 0
, 0
, 0).Tables[0];
dataTable.Columns.Add("DATE", typeof(DateTime));
dataTable.Columns.Add("USER", typeof(int));
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
Biz_Prj_Data objPrjData = new Biz_Prj_Data();
bool isOK = objPrjData.CopyTgtMapDataToEstData(dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 평가자/사업관리 매핑정보를 평가리스트로 설정 및 확정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("설정 중 오류가 발생하였습니다.");
}
}
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);
}
}
private void BindingProjectMap()
{
this.ugrdPrjList.Clear();
Biz_Prj_EmpEstPrjMap objPrjEmpEstPrjMap = new Biz_Prj_EmpEstPrjMap();
DataSet ds = objPrjEmpEstPrjMap.GetPrjEmpEstPrjMap(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, DataTypeUtility.GetToInt32(this.hdfEstDeptID.Value)
, DataTypeUtility.GetToInt32(this.hdfEstEmpID.Value)
, 0);
ugrdPrjList.DataSource = ds;
ugrdPrjList.DataBind();
}
