//===================================: 사업수행구성원 조회 private void SetResourceGrid() { Biz_Prj_Resource prjResource = new Biz_Prj_Resource(); ugrdResourceList.DataSource = prjResource.GetAllList(this.IPrjRefID, 0).Tables[0].DefaultView; ugrdResourceList.DataBind(); }
private void SetPageData() { Biz_Prj_Resource objResource = new Biz_Prj_Resource(); UltraWebGrid1.DataSource = objResource.GetAllList(this.IPrjRefID, 0); UltraWebGrid1.DataBind(); }
//===================================: 비용관리 조회 private void SetBudgetGrid() { Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID); Biz_Prj_Resource prjResource = new Biz_Prj_Resource(); Biz_Prj_Budget objBud = new Biz_Prj_Budget(); if (this.IPrjRefID == 0) { return; } DataSet ds = objBud.SelectMonthRateList(this.IPrjRefID); DataTable dt = objBud.GetDataTableSchema(); DateTime dtStart = DataTypeUtility.GetToDateTime(objPrj.IPlan_Start_Date); DateTime dtEnd = DataTypeUtility.GetToDateTime(objPrj.IPlan_End_Date); for (DateTime date = dtStart; date <= dtEnd;) { TOTAL_CNT++; DataRow dataRow = null; dataRow = GetBudGetYM(ds.Tables[0], date.ToString("yyyyMM")); if (dataRow == null) { dataRow = dt.NewRow(); dataRow["ITYPE"] = "A"; dataRow["PRJ_REF_ID"] = this.IPrjRefID; dataRow["BUDGET_YM"] = date.ToString("yyyyMM"); dataRow["BUDGET_YM_NAME"] = date.ToString("yyyy년 MM월"); dataRow["MONTHLY_AMOUNT"] = 0; dataRow["AMOUNT"] = 0; dataRow["RATE"] = 0; dt.Rows.Add(dataRow); } else { dt.ImportRow(dataRow); } date = date.AddMonths(1); } grdBudgetList.DataSource = dt.DefaultView; grdBudgetList.DataBind(); lblTOTAL_MONTHLY_AMOUNT.Text = TOTAL_MONTHLY_AMOUNT.ToString("###,##0"); lblTOTAL_AMOUNT.Text = TOTAL_AMOUNT.ToString("###,##0"); decimal tmpVar = (TOTAL_RATE / TOTAL_CNT); lblTOTAL_RATE.Text = tmpVar.ToString("##0.#0"); }
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(); }
private void SetButton() { // 프로젝트 책임자 또는 사업구성원이 아닐경우 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)) { this.iBtnAddRow.Visible = false; this.iBtnDelRow.Visible = false; this.iBtnUpdate.Visible = false; } else { this.iBtnAddRow.Visible = true; this.iBtnDelRow.Visible = true; this.iBtnUpdate.Visible = true; } }
protected void ugrdPrjList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { DataRowView dr = (DataRowView)e.Data; Biz_Prj_Resource objResource = new Biz_Prj_Resource(); //Biz_Prj_Schedule objSchedule = new Biz_Prj_Schedule(); DataSet ds = objResource.GetAllList(DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]), 0); //object oRate = objSchedule.GetTotalRate(DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]), 0); //double dTotalRate = 0; string EMP_NAMES = ""; foreach (DataRow row in ds.Tables[0].Rows) { EMP_NAMES += row["EMP_NAME"].ToString() + Environment.NewLine; } e.Row.Cells.FromKey("TASK_OWNER_NAME").Value = EMP_NAMES; //dTotalRate = DataTypeUtility.GetToDouble(oRate); //e.Row.Cells.FromKey("PROCEED_RATE").Value = dTotalRate.ToString("###.#0") + " %"; }
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>"); } }
public void SetFormData() { Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID); Biz_Prj_Resource prjResource = new Biz_Prj_Resource(); Biz_Prj_Budget objBud = new Biz_Prj_Budget(); this.IApp_Ref_Id = objPrj.IApp_Ref_Id; txtPRJ_CODE.Text = objPrj.IPrj_Code; txtPRJ_NAME.Text = objPrj.IPrj_Name; this.IDraftEmpID = objPrj.IOwner_Emp_Id; if (this.IPrjRefID == 0) { return; } lblPrjPeriod.Text = DataTypeUtility.GetToDateTime(objPrj.IPlan_Start_Date).ToShortDateString() + " ~ " + DataTypeUtility.GetToDateTime(objPrj.IPlan_End_Date).ToShortDateString(); this.ITotalBudget = objPrj.ITotal_Budget; lblTotalBudgetAmount.Text = this.ITotalBudget.ToString("###,##0"); ugrdBudgetList.Clear(); DataSet ds = objBud.SelectMonthRateList(this.IPrjRefID); DataTable dt = objBud.GetDataTableSchema(); DateTime dtStart = DataTypeUtility.GetToDateTime(objPrj.IPlan_Start_Date); DateTime dtEnd = DataTypeUtility.GetToDateTime(objPrj.IPlan_End_Date); for (DateTime date = dtStart; date <= dtEnd;) { DataRow dataRow = null; dataRow = GetBudGetYM(ds.Tables[0], date.ToString("yyyyMM")); if (dataRow == null) { dataRow = dt.NewRow(); dataRow["ITYPE"] = "A"; dataRow["PRJ_REF_ID"] = this.IPrjRefID; dataRow["BUDGET_YM"] = date.ToString("yyyyMM"); dataRow["BUDGET_YM_NAME"] = date.ToString("yyyy년 MM월"); dataRow["MONTHLY_AMOUNT"] = 0; dataRow["AMOUNT"] = 0; dataRow["RATE"] = DBNull.Value; dt.Rows.Add(dataRow); } else { dt.ImportRow(dataRow); } date = date.AddMonths(1); } ugrdBudgetList.DataSource = dt; ugrdBudgetList.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); }