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]); } }