//===================================: 사업공유정보 조회
private void SetShareGrid()
{
Biz_Prj_Share objPrjShare = new Biz_Prj_Share();
grdProjectShareList.DataSource = objPrjShare.GetAllList(this.IPrjRefID, 0).Tables[0].DefaultView;
grdProjectShareList.DataBind();
}
private void SetFormData()
{
Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID);
Biz_Prj_Resource prjResource = new Biz_Prj_Resource();
Biz_Prj_Share objPrjShare = new Biz_Prj_Share();
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
DataSet actualDs = objSchedule.GetActualDate(this.IPrjRefID);
this.IApp_Ref_Id = objPrj.IApp_Ref_Id;
txtPRJ_CODE.Text = objPrj.IPrj_Code;
txtPRJ_NAME.Text = objPrj.IPrj_Name;
txtDEFINITION.Text = objPrj.IDefinition;
txtEFFECTIVENESS.Text = objPrj.IEffectiveness;
txtRANGE.Text = objPrj.IRange;
txtOWNER_EMP_ID.Text = objPrj.IOwner_Emp_Name;
hdfOWNER_EMP_ID.Value = objPrj.IOwner_Emp_Id.ToString();
this.IDraftEmpID = objPrj.IOwner_Emp_Id;
txtREF_STG.Text = objPrj.IRef_Stg;
txtREQUEST_DEPT.Text = objPrj.IRequest_Dept;
txtTotalBudget.Text = objPrj.ITotal_Budget.ToString("###,##0");
txtINTERESTED_PARTIES.Text = objPrj.IInterested_Parties;
WebUtility.FindByValueDropDownList(ddlOwnerDeptID, objPrj.IOwner_Dept_Id);
WebUtility.FindByValueDropDownList(ddlPRIORITY, objPrj.IPriority);
WebUtility.FindByValueDropDownList(ddlPrjType, objPrj.IPrj_Type);
wdcPlanStartDate.Value = objPrj.IPlan_Start_Date;
wdcPlanEndDate.Value = objPrj.IPlan_End_Date;
wdcActualStartDate.Value = actualDs.Tables[0].Rows[0]["ACTUAL_START_DATE"];
wdcActualEndDate.Value = actualDs.Tables[0].Rows[0]["ACTUAL_END_DATE"];
DataSet dsPSH = objPrjShare.GetAllList(this.IPrjRefID, 0);
if (dsPSH.Tables.Count > 0)
{
dsPSH.Tables[0].DefaultView.Sort = "CREATE_DATE ASC";
ugrdProjectShareList.Clear();
ugrdProjectShareList.DataSource = dsPSH.Tables[0].DefaultView;
ugrdProjectShareList.DataBind();
}
else
{
ugrdProjectShareList.Clear();
}
ugrdResourceList.Clear();
ugrdResourceList.DataSource = prjResource.GetAllList(this.IPrjRefID, 0);
ugrdResourceList.DataBind();
}
private void UpdateViewData()
{
#region 기본정보 저장
Biz_Prj_Info objPrj = new Biz_Prj_Info();
Biz_Prj_Resource objResource = new Biz_Prj_Resource();
Biz_Prj_Share objPrjShare = new Biz_Prj_Share();
objPrj.IPrj_Ref_Id = this.IPrjRefID;
objPrj.IPrj_Code = txtPRJ_CODE.Text.Trim();
objPrj.IPrj_Name = txtPRJ_NAME.Text.Trim();
objPrj.IDefinition = txtDEFINITION.Text.Trim();
objPrj.IRef_Stg = txtREF_STG.Text.Trim();
objPrj.IEffectiveness = txtEFFECTIVENESS.Text.Trim();
objPrj.IRange = txtRANGE.Text.Trim();
objPrj.IOwner_Dept_Id = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
objPrj.IOwner_Emp_Id = DataTypeUtility.GetToInt32(hdfOWNER_EMP_ID.Value);
objPrj.IRequest_Dept = txtREQUEST_DEPT.Text.Trim();
objPrj.IPriority = WebUtility.GetByValueDropDownList(ddlPRIORITY);
objPrj.ITotal_Budget = DataTypeUtility.GetToDecimal(txtTotalBudget.Text);
objPrj.IPrj_Type = WebUtility.GetByValueDropDownList(ddlPrjType);
objPrj.IInterested_Parties = txtINTERESTED_PARTIES.Text.Trim();
objPrj.IPlan_Start_Date = wdcPlanStartDate.Value;
objPrj.IPlan_End_Date = wdcPlanEndDate.Value;
objPrj.IActual_Start_Date = wdcActualStartDate.Value;
objPrj.IActual_End_Date = wdcActualEndDate.Value;
int intRtn = objPrj.UpdateData(objPrj.IPrj_Ref_Id
, objPrj.IPrj_Code
, objPrj.IPrj_Name
, 0
, objPrj.IDefinition
, objPrj.IRef_Stg
, objPrj.IEffectiveness
, objPrj.IRange
, objPrj.IOwner_Dept_Id
, objPrj.IOwner_Emp_Id
, objPrj.IRequest_Dept
, objPrj.IPriority
, objPrj.ITotal_Budget
, objPrj.IPrj_Type
, objPrj.IInterested_Parties
, objPrj.IPlan_Start_Date
, objPrj.IPlan_End_Date
, objPrj.IActual_Start_Date
, objPrj.IActual_End_Date
, gUserInfo.Emp_Ref_ID
);
//사업정보공유정보저장
foreach (UltraGridRow row in ugrdProjectShareList.Rows)
{
objPrjShare.IPrj_Ref_Id = this.IPrjRefID;
objPrjShare.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objPrjShare.InsertData(objPrjShare.IPrj_Ref_Id
, objPrjShare.IEmp_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objPrjShare.DeleteData(objPrjShare.IPrj_Ref_Id
, objPrjShare.IEmp_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
}
//사업수행구성원저장
foreach (UltraGridRow row in ugrdResourceList.Rows)
{
objResource.IPrj_Ref_Id = this.IPrjRefID;
objResource.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
objResource.IRole_Type = DataTypeUtility.GetValue(row.Cells.FromKey("ROLE_TYPE").Value);
objResource.INote = DataTypeUtility.GetValue(row.Cells.FromKey("NOTE").Value);
objResource.IIsdelete = DataTypeUtility.GetValue(row.Cells.FromKey("ISDELETE").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objResource.InsertData(objResource.IPrj_Ref_Id
, objResource.IEmp_Ref_Id
, objResource.IRole_Type
, objResource.INote
, objResource.IIsdelete
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
{
intRtn += objResource.UpdateData(objResource.IPrj_Ref_Id
, objResource.IEmp_Ref_Id
, objResource.IRole_Type
, objResource.INote
, objResource.IIsdelete
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objResource.DeleteData(objResource.IPrj_Ref_Id
, objResource.IEmp_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
}
#endregion
if (intRtn > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("사업정보가 저장되었습니다.");
this.IType = "U";
this.SetFormData();
this.SetButton();
}
}
private void InsertViewData()
{
if (this.CheckFormData())
{
ltrScript.Text = JSHelper.GetAlertScript("사업아이디 또는 사업명이 동일한 값이 존재합니다.");
return;
}
#region 기본정보 저장
Biz_Prj_Info objPrj = new Biz_Prj_Info();
Biz_Prj_Resource objResource = new Biz_Prj_Resource();
Biz_Prj_Share objPrjShare = new Biz_Prj_Share();
objPrj.IPrj_Code = txtPRJ_CODE.Text.Trim();
objPrj.IPrj_Name = txtPRJ_NAME.Text.Trim();
objPrj.IDefinition = txtDEFINITION.Text.Trim();
objPrj.IRef_Stg = txtREF_STG.Text.Trim();
objPrj.IEffectiveness = txtEFFECTIVENESS.Text.Trim();
objPrj.IRange = txtRANGE.Text.Trim();
objPrj.IOwner_Dept_Id = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID);
objPrj.IOwner_Emp_Id = DataTypeUtility.GetToInt32(hdfOWNER_EMP_ID.Value);
objPrj.IRequest_Dept = txtREQUEST_DEPT.Text.Trim();
objPrj.IPriority = WebUtility.GetByValueDropDownList(ddlPRIORITY);
objPrj.ITotal_Budget = DataTypeUtility.GetToDecimal(txtTotalBudget.Text);
objPrj.IPrj_Type = WebUtility.GetByValueDropDownList(ddlPrjType);
objPrj.IInterested_Parties = txtINTERESTED_PARTIES.Text.Trim();
objPrj.IPlan_Start_Date = wdcPlanStartDate.Value;
objPrj.IPlan_End_Date = wdcPlanEndDate.Value;
objPrj.IActual_Start_Date = wdcActualStartDate.Value;
objPrj.IActual_End_Date = wdcActualEndDate.Value;
int intRtn = objPrj.InsertData(objPrj.IPrj_Code
, objPrj.IPrj_Name
, 0
, objPrj.IDefinition
, objPrj.IRef_Stg
, objPrj.IEffectiveness
, objPrj.IRange
, objPrj.IOwner_Dept_Id
, objPrj.IOwner_Emp_Id
, objPrj.IRequest_Dept
, objPrj.IPriority
, objPrj.ITotal_Budget
, objPrj.IPrj_Type
, objPrj.IInterested_Parties
, objPrj.IPlan_Start_Date
, objPrj.IPlan_End_Date
, objPrj.IActual_Start_Date
, objPrj.IActual_End_Date
, gUserInfo.Emp_Ref_ID
);
this.IPrjRefID = objPrj.IPrj_Ref_Id;
//사업정보공유정보저장
foreach (UltraGridRow row in ugrdProjectShareList.Rows)
{
objPrjShare.IPrj_Ref_Id = this.IPrjRefID;
objPrjShare.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objPrjShare.InsertData(objPrjShare.IPrj_Ref_Id
, objPrjShare.IEmp_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objPrjShare.DeleteData(objPrjShare.IPrj_Ref_Id
, objPrjShare.IEmp_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
}
//사업수행구성원저장
foreach (UltraGridRow row in ugrdResourceList.Rows)
{
objResource.IPrj_Ref_Id = this.IPrjRefID;
objResource.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
objResource.IRole_Type = DataTypeUtility.GetValue(row.Cells.FromKey("ROLE_TYPE").Value);
objResource.INote = DataTypeUtility.GetValue(row.Cells.FromKey("NOTE").Value);
objResource.IIsdelete = DataTypeUtility.GetValue(row.Cells.FromKey("ISDELETE").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objResource.InsertData(objResource.IPrj_Ref_Id
, objResource.IEmp_Ref_Id
, objResource.IRole_Type
, objResource.INote
, objResource.IIsdelete
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
{
intRtn += objResource.UpdateData(objResource.IPrj_Ref_Id
, objResource.IEmp_Ref_Id
, objResource.IRole_Type
, objResource.INote
, objResource.IIsdelete
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objResource.DeleteData(objResource.IPrj_Ref_Id
, objResource.IEmp_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
}
#endregion
#region 일정관리
//Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
//objSchedule.IPrj_Ref_Id = this.IPrjRefID;
//objSchedule.IUp_Task_Ref_Id = 0;
//intRtn += objSchedule.InsertData(objSchedule.IPrj_Ref_Id
// , 0
// , this.txtPRJ_NAME.Text.Trim()
// , "PAS"
// , 0
// , objSchedule.IUp_Task_Ref_Id
// , "1.0"
// , this.wdcPlanStartDate.Value
// , this.wdcPlanEndDate.Value
// , null
// , null
// , 0
// , ""
// , "N"
// , "N"
// , 0
// , -1
// , ""
// , gUserInfo.Emp_Ref_ID);
MicroBSC.Integration.PRJ.Biz.Biz_Prj_Schedule bizPrjSchedule = new MicroBSC.Integration.PRJ.Biz.Biz_Prj_Schedule();
intRtn += bizPrjSchedule.AddData(this.IPrjRefID
, 0
, this.txtPRJ_NAME.Text.Trim()
, "PAS"
, 0
, "1.0"
, 0
, this.wdcPlanStartDate.Value
, this.wdcPlanEndDate.Value
, null
, null
, 0
, ""
, "N"
, "N"
, 0
, -1
, ""
, gUserInfo.Emp_Ref_ID);
#endregion
if (intRtn > 0)
{
string url = "./PRJ0101M1.aspx?iType=U&PRJ_REF_ID=" + this.IPrjRefID + "&CCB1=" + ICCB1;
ltrScript.Text = string.Format("<script language=javascript>parent.location.replace('" + url + "'); </script>");
}
}
