private void BindSchedule()
{
_iPrjRefID = WebUtility.GetIntByValueDropDownList(ddlPrjName);
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
objSchedule.IPrj_Ref_Id = IPrjRefID;
DataSet ds = objSchedule.GetUserAllList(objSchedule.IPrj_Ref_Id, 0, gUserInfo.Emp_Ref_ID);
if (ds.Tables.Count == 0 && ds.Tables[0].Rows.Count == 0)
{
return;
}
DataSet tmpDs = ds.Clone();
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns["TASK_REF_ID"]
, ds.Tables[0].Columns["UP_TASK_REF_ID"]
, false);
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (DataTypeUtility.GetToInt32(dbRow["UP_TASK_REF_ID"]) == 0)
{
tmpDs.Tables[0].ImportRow(dbRow);
PopulateScheduleTree(dbRow, tmpDs);
}
}
_prjScheuldeDataProvider = new PrjScheuldeDataProvider(tmpDs.Tables[0]);
_prjScheuldeDataProvider.WebScheduleInfo = this.WebScheduleInfo1;
this.WebScheduleInfo1.AppointmentFormPath = "./PRJ0102M1.aspx?PRJ_REF_ID=" + _iPrjRefID + "&TASK_REF_ID=";
this.WebScheduleInfo1.ReminderFormPath = "./PRJ0102M1.aspx?PRJ_REF_ID=" + _iPrjRefID + "&TASK_REF_ID=" + _iTaskRefID;
this.WebMonthView1.AppointmentFormatString = "<SUBJECT>";
this.WebMonthView1.AppointmentTooltipFormatString = "<DESCRIPTION><NEW_LINE><SUBJECT>";
// 프로젝트 책임자 또는 사업구성원이 아닐경우
Biz_Prj_Info objPrj = new Biz_Prj_Info();
Biz_Prj_Resource objRes = new Biz_Prj_Resource(this._iPrjRefID, gUserInfo.Emp_Ref_ID);
if (!objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) ||
(objRes == null))
{
_readOnlyYN = "Y";
}
else
{
_readOnlyYN = "N";
}
}
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();
}
public void BindSchedule(TreeView treeView
, bool isCheckBox
, TreeNodeSelectAction treeNodeSelectAction
, string checkedValues)
{
string valueStr = "TASK_REF_ID";
string up_valueStr = "UP_TASK_REF_ID";
string textStr = "TASK_NAME";
string iconStr = "TASK_TYPE";
string imageUrlDir = "../images/treeview/";
bool isExtended = true;
DataTable dataTable = null;
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
DataSet ds = objSchedule.GetAllList(PRJ_REF_ID, 0);
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns[valueStr]
, ds.Tables[0].Columns[up_valueStr]
, false);
treeView.Nodes.Clear();
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (DataTypeUtility.GetToInt32(dbRow[up_valueStr]) == 0)
{
TreeNode rootNode = CreateNode(dbRow
, imageUrlDir + "root.gif"
, isExtended
, treeNodeSelectAction
, isCheckBox);
if (isCheckBox && (checkedValues != null || checkedValues == ""))
{
TreeNodeCheck(rootNode, dataTable);
}
treeView.Nodes.Add(rootNode);
PopulateScheduleTree(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable);
}
}
}
public void BindSchedule(string valueStr, string up_valueStr)
{
DataTable dataTable = GetDataTableSchema();
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
DataSet ds = objSchedule.GetAllList(this.IPrjRefID, 0);
object oRate = objSchedule.GetTotalRate(this.IPrjRefID, 0);
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["UP_TASK_REF_ID"] == DBNull.Value | ds.Tables[0].Rows[i]["UP_TASK_REF_ID"].ToString() == "0")
{
ds.Tables[0].Rows[i]["PROCEED_RATE"] = DataTypeUtility.GetString(oRate);
break;
}
}
}
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns[valueStr]
, ds.Tables[0].Columns[up_valueStr]
, false);
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
DataTable dt = ds.Tables[0];
if (DataTypeUtility.GetToInt32(dbRow[up_valueStr]) == 0)
{
dataTable.Rows.Add(MakeDataRow(dataTable, dbRow));
PopulateSchedule(dbRow, dataTable);
}
}
grdTaskList.DataSource = dataTable.DefaultView;
grdTaskList.DataBind();
}
private void FormDataBind()
{
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule(this.IPrjRefID, this.ITaskRefID);
Biz_Prj_Info objInfo = new Biz_Prj_Info(this.IPrjRefID);
Biz_Prj_Schedule objUpSchedule = new Biz_Prj_Schedule(this.IPrjRefID, objSchedule.IUp_Task_Ref_Id);
Biz_Prj_Task_Owner objTaskOwner = new Biz_Prj_Task_Owner();
Biz_Prj_Task_Share objTaskShare = new Biz_Prj_Task_Share();
txtPrjName.Text = objInfo.IPrj_Name;
txtPrjPeriod.Text = DataTypeUtility.GetToDateTimeText(objInfo.IPlan_Start_Date) + " ~ " + DataTypeUtility.GetToDateTimeText(objInfo.IPlan_End_Date);
txtTaskCode.Text = objSchedule.ITask_Code;
txtTaskName.Text = objSchedule.ITask_Name;
txtUpTaskName.Text = objUpSchedule.ITask_Name;
hdfUpTaskRefID.Value = objSchedule.IUp_Task_Ref_Id.ToString();
this.ITaskWeight = objSchedule.ITask_Weight;
wdcSchPlanStartDate.Value = objSchedule.IPlan_Start_Date;
wdcSchPlanEndDate.Value = objSchedule.IPlan_End_Date;
wdcSchActualStartDate.Value = objSchedule.IActual_Start_Date;
wdcSchActualEndDate.Value = objSchedule.IActual_End_Date;
txtProceedRate.Text = objSchedule.IProceed_Rate.ToString("##0.#0");
hdfAttachNo.Value = objSchedule.IAtt_File;
hdfNodeDepth.Value = objSchedule.INode_Depth.ToString();
txtDesction.Text = objSchedule.IDesction;
SetUploadFileInfo(hdfAttachNo.Value, ddlFileUpload);
ugrdTaskOwnerList.Clear();
//ugrdTaskShareList.Clear();
ugrdTaskOwnerList.DataSource = objTaskOwner.GetAllList(this.IPrjRefID, 0, this.ITaskRefID);
ugrdTaskOwnerList.DataBind();
//ugrdTaskShareList.DataSource = objTaskShare.GetAllList(this.IPrjRefID, this.ITaskRefID, 0);
//ugrdTaskShareList.DataBind();
}
private void SetPageType()
{
if (PAGE_TYPE.Equals("P"))
{
SetMenuControl(false, false, false);
IPrjRefID = GetRequestByInt("PRJ_REF_ID", 0);
PRJ_TYPE = GetRequest("PRJ_TYPE", "");
if (IPrjRefID > 0)
{
PageUtility.FindByValueDropDownList(ddlPrjType, this.IPrjRefID.ToString());
}
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(IPrjRefID);
Biz_Com_Code_Info objComCode = new Biz_Com_Code_Info();
DataSet ds = objComCode.GetProjectType(0);
DataRow[] dr = ds.Tables[0].Select("ETC_CODE='" + PRJ_TYPE + "'");
//ddlPrjType.Visible = false;
//ddlPrjName.Visible = false;
iBtnSearch.Visible = false;
lblPrjTypeName.Visible = true;
lblPrjName.Visible = true;
ImgClose.Visible = true;
lblPrjName.Text = objPrjInfo.IPrj_Name;
lblPrjTypeName.Text = dr[0].ItemArray[3].ToString(); //CODE_NAME
BindGanttChart(IPrjRefID);
pnlPrjInfo.Visible = true;
pnlPrjSearch.Visible = false;
}
else
{
pnlPrjInfo.Visible = false;
pnlPrjSearch.Visible = true;
BindGanttChart(IPrjRefID);
}
// 프로젝트 책임자 또는 사업구성원이 아닐경우
Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID);
Biz_Prj_Resource objRes = new Biz_Prj_Resource(this._iPrjRefID, gUserInfo.Emp_Ref_ID);
if (!objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) ||
(objRes == null))
{
_readOnlyYN = "Y";
}
else if (objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID) && objPrj.IComplete_YN == "Y")
{
_readOnlyYN = "Y";
}
else if (this.PAGE_TYPE == "N")
{
_readOnlyYN = "N";
}
else
{
_readOnlyYN = "N";
}
Biz_Prj_Schedule objSch = new Biz_Prj_Schedule();
lblPROCEED_RATE.Text = objSch.GetTotalRate(this.IPrjRefID, 0).ToString();
lblActualEDate.Text = (objPrj.IActual_End_Date == DBNull.Value) ? "" : Convert.ToDateTime(objPrj.IActual_End_Date).ToShortDateString();
lblActualSDate.Text = (objPrj.IActual_Start_Date == DBNull.Value) ? "" : Convert.ToDateTime(objPrj.IActual_Start_Date).ToShortDateString();
lblplanEDate.Text = (objPrj.IPlan_End_Date == DBNull.Value) ? "" : Convert.ToDateTime(objPrj.IPlan_End_Date).ToShortDateString();
lblplanSDate.Text = (objPrj.IPlan_Start_Date == DBNull.Value) ? "" : Convert.ToDateTime(objPrj.IPlan_Start_Date).ToShortDateString();
lblOWNER_DEPT_NAME.Text = objPrj.IOwner_Dept_Name;
lblOWNER_EMP_NAME.Text = objPrj.IOwner_Emp_Name;
PageUtility.FindByValueDropDownList(ddlPRIORITY, objPrj.IPriority);
lblPRIORITY.Text = PageUtility.GetByTextDropDownList(ddlPRIORITY);
lblTOTAL_BUDGET.Text = objPrj.ITotal_Budget.ToString();
lblREF_STG.Text = objPrj.IRef_Stg;
lblEFFECTIVENESS.Text = objPrj.IEffectiveness;
lblRANGE.Text = objPrj.IRange;
lblPRJ_TYPE.Text = PageUtility.GetByTextDropDownList(ddlPrjType);
}
private void BindGanttChart(int iPrjRefID)
{
IPrjRefID = iPrjRefID;
if (PAGE_TYPE.Equals("N"))
{
_iPrjRefID = WebUtility.GetIntByValueDropDownList(ddlPrjName);
}
if (PAGE_TYPE.Equals("N") && _iPrjRefID < 1)
{
return;
}
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
objSchedule.IPrj_Ref_Id = IPrjRefID;
DataSet ds = objSchedule.GetAllList(objSchedule.IPrj_Ref_Id, 0);
if (ds.Tables.Count == 0 && ds.Tables[0].Rows.Count == 0)
{
return;
}
DataSet tmpDs = ds.Clone();
ds.Relations.Add("NodeRelation"
, ds.Tables[0].Columns["TASK_REF_ID"]
, ds.Tables[0].Columns["UP_TASK_REF_ID"]
, false);
foreach (DataRow dbRow in ds.Tables[0].Rows)
{
if (DataTypeUtility.GetToInt32(dbRow["UP_TASK_REF_ID"]) == 0)
{
tmpDs.Tables[0].ImportRow(dbRow);
PopulateScheduleTree(dbRow, tmpDs);
}
}
_dataTable = tmpDs.Tables[0];
// Set Gantt chart type
Chart1.Series["Tasks"].Type = SeriesChartType.Gantt;
Chart1.Series["Progress"].Type = SeriesChartType.Gantt;
Chart1.Legends["Default"].Enabled = true;
Chart1.ChartAreas["Default"].AxisX.MajorGrid.Interval = 2;
Chart1.ChartAreas["Default"].AxisX.LabelsAutoFit = false;
Chart1.ChartAreas["Default"].AxisX.Interval = 1;
Chart1.ChartAreas["Default"].AxisX.Reverse = true;
Chart1.ChartAreas["Default"].AxisY.LabelStyle.Format = "yy.MM.dd";
//Chart1.ChartAreas["Default"].AxisY.MajorGrid.Interval = 28;
//Chart1.ChartAreas["Default"].AxisY.Interval = 10;
Chart1.ChartAreas["Default"].AxisY.LabelsAutoFitStyle ^= LabelsAutoFitStyle.IncreaseFont;
Chart1.ChartAreas["Default"].AxisY.LabelsAutoFit = true;
Chart1.ChartAreas["Default"].Area3DStyle.Enable3D = false;
Chart1.Series["Progress"]["DrawSideBySide"] = "false";
Chart1.Series["Tasks"]["DrawSideBySide"] = "false";
Chart1.Series["Tasks"]["PointWidth"] = "0.7";
Chart1.Series["Progress"]["PointWidth"] = "0.4";
//Chart1.BackColor = Color.White;
//Chart1.BackGradientType = GradientType.None;
//Chart1.BorderColor = Color.Gray;
//Chart1.BorderLineStyle = ChartDashStyle.Solid;
//Chart1.BorderStyle = ChartDashStyle.NotSet;
_htPoints.Clear();
for (int i = 0; i < _dataTable.Rows.Count; i++)
{
DataRow row = _dataTable.Rows[i];
object oPlanStartDate = row["PLAN_START_DATE"];
object oPlanEndDate = row["PLAN_END_DATE"];
object oActualStartDate = row["ACTUAL_START_DATE"];
object oActualEndDate = row["ACTUAL_END_DATE"];
if (oPlanStartDate.ToString() == oPlanEndDate.ToString() && oPlanEndDate != DBNull.Value)
{
oPlanEndDate = (object)DataTypeUtility.GetToDateTime(oPlanEndDate).AddDays(1);
}
if (oActualStartDate.ToString() == oActualEndDate.ToString() && oActualEndDate != DBNull.Value)
{
oActualEndDate = (object)DataTypeUtility.GetToDateTime(oActualEndDate).AddDays(1);
}
if (oPlanStartDate != DBNull.Value && oPlanEndDate != DBNull.Value)
{
Chart1.Series["Tasks"].Points.AddXY(i, oPlanStartDate, oPlanEndDate);
}
else
{
Chart1.Series["Tasks"].Points.AddXY(i, null, null);
}
if (oActualStartDate == DBNull.Value || oActualStartDate == null)
{
oActualStartDate = null;
}
if (oActualEndDate == DBNull.Value || oActualEndDate == null)
{
oActualEndDate = null;
}
if (oActualStartDate == null || oActualEndDate == null)
{
oActualStartDate = null;
oActualEndDate = null;
}
//if (oActualStartDate == DBNull.Value && oActualEndDate != null)
// oActualStartDate = oPlanStartDate;
//if (oActualStartDate != DBNull.Value && (oActualEndDate == null || oActualEndDate == DBNull.Value))
// oActualEndDate = oPlanEndDate;
Chart1.Series["Progress"].Points.AddXY(i, oActualStartDate, oActualEndDate);
//Chart1.Series["Tasks"].Points.AddXY(i, row["PLAN_START_DATE"], row["PLAN_END_DATE"]);
//Chart1.Series["Progress"].Points.AddXY(i, row["ACTUAL_START_DATE"], row["ACTUAL_END_DATE"]);
Chart1.Series["Tasks"].Points[i].AxisLabel = row["TASK_NAME"].ToString();
Chart1.Series["Progress"].Points[i].AxisLabel = row["TASK_NAME"].ToString();
//Chart1.Series["Tasks"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]);
//Chart1.Series["Progress"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]);
//Chart1.Series["Progress"].Points[i].ToolTip = "실행기간 : " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_END_DATE"]);
if (DataTypeUtility.GetToInt32(row["UP_TASK_REF_ID"]) > 0)
{
Chart1.Series["Tasks"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_END_DATE"]);
Chart1.Series["Progress"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["ACTUAL_END_DATE"]);
}
else
{
DataSet actualDs = objSchedule.GetActualDate(this.IPrjRefID);
Chart1.Series["Tasks"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_END_DATE"]);
Chart1.Series["Progress"].Points[i].ToolTip = "계획기간 : " + DataTypeUtility.GetToDateTimeText(row["PLAN_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(row["PLAN_END_DATE"]) + "\r\n" +
"실행기간 : " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_START_DATE"]) + " ~ " + DataTypeUtility.GetToDateTimeText(actualDs.Tables[0].Rows[0]["ACTUAL_END_DATE"]);
}
if (DataTypeUtility.GetToInt32(row["UP_TASK_REF_ID"]) > 0)
{
Chart1.Series["Tasks"].Points[i].Href = "javascript:OpenSchedule('" + row["TASK_REF_ID"].ToString() + "');";
Chart1.Series["Progress"].Points[i].Href = "javascript:OpenSchedule('" + row["TASK_REF_ID"].ToString() + "');";
}
//Chart1.Series["Tasks"].Points[i].Label = Chart1.Series["Tasks"].Points[i].XValue.ToString();
_htPoints.Add(row["TASK_REF_ID"], Chart1.Series["Tasks"].Points[i]);
}
}
protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e)
{
Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule();
Biz_Prj_Task_Owner objTaskOwner = new Biz_Prj_Task_Owner();
Biz_Prj_Task_Share objTaskShare = new Biz_Prj_Task_Share();
string[,] saAttachInfo = TypeUtility.GetSplit(hdfAttachNo.Value);
string strAttach = hdfAttachNo.Value;
if (saAttachInfo.Length / 2 >= 1)
{
if (Convert.ToInt32(saAttachInfo[1, 0]) > 0)
{
strAttach = saAttachInfo[0, 0];
}
}
objSchedule.IPrj_Ref_Id = this.IPrjRefID;
objSchedule.ITask_Ref_Id = this.ITaskRefID;
objSchedule.ITask_Code = txtTaskCode.Text.Trim();
objSchedule.ITask_Name = txtTaskName.Text.Trim();
objSchedule.IUp_Task_Ref_Id = DataTypeUtility.GetToInt32(hdfUpTaskRefID.Value);
objSchedule.ITask_Type = WebUtility.GetByValueDropDownList(ddlTaskType);
objSchedule.IPlan_Start_Date = wdcSchPlanStartDate.Value;
objSchedule.IPlan_End_Date = wdcSchPlanEndDate.Value;
objSchedule.IActual_Start_Date = wdcSchActualStartDate.Value;
objSchedule.IActual_End_Date = wdcSchActualEndDate.Value;
objSchedule.IProceed_Rate = DataTypeUtility.GetToDecimal(txtProceedRate.Text.Trim());
objSchedule.IAtt_File = strAttach;
objSchedule.INode_Depth = DataTypeUtility.GetToInt32(hdfNodeDepth.Value);
objSchedule.IComplete_Yn = "N";
objSchedule.IIsdelete = "N";
objSchedule.IAfter_Task_Ref_Id = -1;
objSchedule.IDesction = this.txtDesction.Text.Trim();
int intRtn = objSchedule.UpdateData(objSchedule.IPrj_Ref_Id
, objSchedule.ITask_Ref_Id
, objSchedule.ITask_Name
, objSchedule.ITask_Type
, this.ITaskWeight
, objSchedule.IUp_Task_Ref_Id
, objSchedule.ITask_Code
, objSchedule.IPlan_Start_Date
, objSchedule.IPlan_End_Date
, objSchedule.IActual_Start_Date
, objSchedule.IActual_End_Date
, objSchedule.IProceed_Rate
, objSchedule.IAtt_File
, objSchedule.IComplete_Yn
, objSchedule.IIsdelete
, objSchedule.INode_Depth
, objSchedule.IAfter_Task_Ref_Id
, objSchedule.IDesction
, gUserInfo.Emp_Ref_ID);
//작업수행담당자 저장
foreach (UltraGridRow row in ugrdTaskOwnerList.Rows)
{
objTaskOwner.IPrj_Ref_Id = this.IPrjRefID;
objTaskOwner.ITask_Ref_Id = this.ITaskRefID;
objTaskOwner.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
{
intRtn += objTaskOwner.InsertData(objTaskOwner.IPrj_Ref_Id
, objTaskOwner.IEmp_Ref_Id
, objTaskOwner.ITask_Ref_Id
, "N"
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
{
intRtn += objTaskOwner.UpdateData(objTaskOwner.IPrj_Ref_Id
, objTaskOwner.IEmp_Ref_Id
, objTaskOwner.ITask_Ref_Id
, "N"
, gUserInfo.Emp_Ref_ID);
}
else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
{
intRtn += objTaskOwner.DeleteData(objTaskOwner.IPrj_Ref_Id
, objTaskOwner.IEmp_Ref_Id
, objTaskOwner.ITask_Ref_Id
, gUserInfo.Emp_Ref_ID);
}
}
////일정공유자 저장
//foreach (UltraGridRow row in ugrdTaskShareList.Rows)
//{
// objTaskShare.IPrj_Ref_Id = this.IPrjRefID;
// objTaskShare.ITask_Ref_Id = this.ITaskRefID;
// objTaskShare.IEmp_Ref_Id = DataTypeUtility.GetToInt32(row.Cells.FromKey("EMP_REF_ID").Value);
// if (row.Cells.FromKey("ITYPE").Value.ToString() == "A")
// {
// intRtn += objTaskShare.InsertData(objTaskShare.IPrj_Ref_Id
// , objTaskShare.ITask_Ref_Id
// , objTaskShare.IEmp_Ref_Id
// , gUserInfo.Emp_Ref_ID);
// }
// else if (row.Cells.FromKey("ITYPE").Value.ToString() == "U")
// {
// intRtn += objTaskShare.UpdateData(objTaskShare.IPrj_Ref_Id
// , objTaskShare.ITask_Ref_Id
// , objTaskShare.IEmp_Ref_Id
// , gUserInfo.Emp_Ref_ID);
// }
// else if (row.Cells.FromKey("ITYPE").Value.ToString() == "D")
// {
// intRtn += objTaskShare.DeleteData(objTaskShare.IPrj_Ref_Id
// , objTaskShare.ITask_Ref_Id
// , objTaskShare.IEmp_Ref_Id
// , gUserInfo.Emp_Ref_ID);
// }
//}
ugrdTaskOwnerList.Clear();
//ugrdTaskShareList.Clear();
ugrdTaskOwnerList.DataSource = objTaskOwner.GetAllList(this.IPrjRefID, 0, this.ITaskRefID);
ugrdTaskOwnerList.DataBind();
//ugrdTaskShareList.DataSource = objTaskShare.GetAllList(this.IPrjRefID, this.ITaskRefID, 0);
//ugrdTaskShareList.DataBind();
if (intRtn > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("작업정보가 저장되었습니다.", true);
}
}
