private void SetPrjInfoData()
{
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(IPrjRefID);
Biz_Com_Code_Info objPrjPriority = new Biz_Com_Code_Info("PM001", objPrjInfo.IPriority);
Biz_Com_Code_Info objPrjType = new Biz_Com_Code_Info("PM002", objPrjInfo.IPrj_Type);
lblPRJCode.Text = objPrjInfo.IPrj_Code;
lblPRJName.Text = objPrjInfo.IPrj_Name;
lblPRJDefinition.Text = objPrjInfo.IDefinition;
lblPlanStartDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IPlan_Start_Date);
lblPlanEndDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IPlan_End_Date);
lblActualStartDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IActual_Start_Date);
lblActualEndDate.Text = DataTypeUtility.GetToDateTimeText(objPrjInfo.IActual_End_Date);
hdfPrjType.Value = objPrjInfo.IPrj_Type;
lblPRJTypeName.Text = objPrjType.Icode_name;
hdfOwnerDeptID.Value = objPrjInfo.IOwner_Dept_Id.ToString();
lblOwnerDeptName.Text = objPrjInfo.IOwner_Dept_Name;
hdfOwnerEmpID.Value = objPrjInfo.IOwner_Emp_Id.ToString();
lblOwnerEmpName.Text = objPrjInfo.IOwner_Emp_Name;
lblRequestDept.Text = objPrjInfo.IRequest_Dept;
lblPriorityName.Text = objPrjPriority.Icode_name;
hdfPriority.Value = objPrjInfo.IPriority;
lblTotalBudget.Text = objPrjInfo.ITotal_Budget.ToString("###,##0") + " 원";
lblInterested.Text = objPrjInfo.IInterested_Parties;
lblRefStg.Text = objPrjInfo.IRef_Stg;
lblEffectiveness.Text = objPrjInfo.IEffectiveness;
lblRange.Text = objPrjInfo.IRange;
}
private void CheckNoticePopupMenu(int menu_ref_id)
{
Biz_Boards objBoard = new Biz_Boards();
DataSet ds = objBoard.GetBoard("", "NTC", menu_ref_id, "Y");
if (ds.Tables[0].Rows.Count > 0)
{
NOTICE_BOARD_ID = DataTypeUtility.GetToInt32(ds.Tables[0].Rows[0]["BOARD_ID"]);
NOTICE_START_DATE = DataTypeUtility.GetToDateTimeText(ds.Tables[0].Rows[0]["START_DATE"]);
NOTICE_END_DATE = DataTypeUtility.GetToDateTimeText(ds.Tables[0].Rows[0]["END_DATE"]);
}
}
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 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]);
}
}
