private void DeleteViewData() { #region 기본정보 삭제 Biz_Prj_Info objPrj = new Biz_Prj_Info(); objPrj.IPrj_Ref_Id = this.IPrjRefID; int intRtn = objPrj.DeleteData(objPrj.IPrj_Ref_Id , gUserInfo.Emp_Ref_ID ); ltrScript.Text = JSHelper.GetAlertScript(objPrj.Transaction_Message, false); if (objPrj.Transaction_Result == "Y") { ltrScript.Text = JSHelper.GetAlertScript("사업정보가 삭제되었습니다."); this.IType = "D"; this.SetFormData(); this.SetButton(); } else { } #endregion }
public void InitForm() { WebCommon.FillComDeptTree(trvDept); Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IKey); this.txtTitle.Text = "[" + Biz_Type.biz_type_prm_doc_name + "]" + objPrj.IPrj_Name; }
public void SetPrjList() { Biz_Prj_Info objPrj = new Biz_Prj_Info(); string iprj_code = txtPrjCode.Text.Trim(); string iprj_name = txtPrjName.Text.Trim(); int iowner_dept_id = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID); string iowner_emp_name = txtOwnerEmpName.Text.Trim(); string iprj_type = WebUtility.GetByValueDropDownList(ddlPrjType); DateTime iplan_start_date = (DateTime)wdcPlanStartDate.Value; DateTime iplan_end_date = (DateTime)wdcPlanEndDate.Value; int iowner_emp_id = (User.IsInRole(ROLE_ADMIN)) ? 0 : gUserInfo.Emp_Ref_ID; string sSDate = iplan_start_date.Year.ToString() + "-" + iplan_start_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_start_date.Day.ToString().PadLeft(2, '0') + " 00:00:00"; string sEDate = iplan_end_date.Year.ToString() + "-" + iplan_end_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_end_date.Day.ToString().PadLeft(2, '0') + " 23:59:59"; DataSet rDs = objPrj.GetUserAllList(iprj_code , iprj_name , iowner_dept_id , iowner_emp_name , iprj_type , Convert.ToDateTime(sSDate) , Convert.ToDateTime(sEDate) , iowner_emp_id); ugrdPrjList.Clear(); ugrdPrjList.DataSource = rDs; ugrdPrjList.DataBind(); lblRowCount.Text = rDs.Tables[0].Rows.Count.ToString(); }
public void SetPrjList() { MicroBSC.Integration.PRJ.Biz.Biz_Prj_Info bizPrjInfo = new MicroBSC.Integration.PRJ.Biz.Biz_Prj_Info(); Biz_Prj_Info objPrj = new Biz_Prj_Info(); string iprj_code = ""; //txtPrjCode.Text.Trim(); string iprj_name = ""; // txtPrjName.Text.Trim(); int iowner_dept_id = 0; // WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID); string iowner_emp_name = ""; // txtOwnerEmpName.Text.Trim(); string iprj_type = ""; // WebUtility.GetByValueDropDownList(ddlPrjType); object iplan_start_date = base.GetStartDayofCurrent(); object iplan_end_date = base.GetEndDayofCurrent(); //DataSet rDs = objPrj.GetAllList(iprj_code // , iprj_name // , iowner_dept_id // , iowner_emp_name // , iprj_type // , iplan_start_date // , iplan_end_date); DataTable dt = bizPrjInfo.Get_Prj_Info_Not_In_Question_Map(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); ugrdPrjList.Clear(); ugrdPrjList.DataSource = dt; ugrdPrjList.DataBind(); }
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; }
public void SetFormData() { Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID); 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; }
public void SetPrjList() { Biz_Prj_Info objPrj = new Biz_Prj_Info(); string iprj_code = txtPrjCode.Text.Trim(); string iprj_name = txtPrjName.Text.Trim(); int iowner_dept_id = WebUtility.GetIntByValueDropDownList(ddlOwnerDeptID); string iowner_emp_name = txtOwnerEmpName.Text.Trim(); string iprj_type = WebUtility.GetByValueDropDownList(ddlPrjType); DateTime iplan_start_date = (DateTime)wdcPlanStartDate.Value; DateTime iplan_end_date = (DateTime)wdcPlanEndDate.Value; int iowner_emp_id = (User.IsInRole(ROLE_ADMIN)) ? 0 : EMP_REF_ID; string sSDate = iplan_start_date.Year.ToString() + "-" + iplan_start_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_start_date.Day.ToString().PadLeft(2, '0') + " 00:00:00"; string sEDate = iplan_end_date.Year.ToString() + "-" + iplan_end_date.Month.ToString().PadLeft(2, '0') + "-" + iplan_end_date.Day.ToString().PadLeft(2, '0') + " 23:59:59"; //int iTxrUser = (User.IsInRole(ROLE_ADMIN)) ? 0 : EMP_REF_ID; DataSet rDs = objPrj.GetTotalStateList(iprj_code , iprj_name , iowner_dept_id , iowner_emp_name , iprj_type , Convert.ToDateTime(sSDate) , Convert.ToDateTime(sEDate) , iowner_emp_id); if (rDs.Tables.Count > 0) { rDs.Tables[0].DefaultView.Sort = "PRJ_CODE ASC"; ugrdPrjList.Clear(); ugrdPrjList.DataSource = rDs.Tables[0].DefaultView; ugrdPrjList.DataBind(); } else { ugrdPrjList.Clear(); } lblRowCount.Text = rDs.Tables[0].Rows.Count.ToString(); //DataSet ds = objPrj.GetExcelDownList(iprj_code // , iprj_name // , iowner_dept_id // , iowner_emp_name // , iprj_type // , iplan_start_date // , iplan_end_date // , gUserInfo.Emp_Ref_ID); //UltraWebGrid1.Clear(); //UltraWebGrid1.DataSource = ds; //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 bool CheckFormData() { bool isCheck = false; Biz_Prj_Info objPrj = new Biz_Prj_Info(); objPrj.IPrj_Code = txtPRJ_CODE.Text.Trim(); objPrj.IPrj_Name = txtPRJ_NAME.Text.Trim(); isCheck = objPrj.IsExist(objPrj.IPrj_Code, objPrj.IPrj_Name); return(isCheck); }
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(); }
protected void iBtnUpdate_Click(object sender, ImageClickEventArgs e) { Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID); this.ITotalBudget = objPrj.ITotal_Budget; // 비용금액 체크 if (GetPlanSumBudGet() > this.ITotalBudget) { ltrScript.Text = JSHelper.GetAlertScript("계획예산금액이 총예산금액보다 큽니다. 다시 예산을 책정해주세요."); return; } this.UpdateViewData(); }
private void GridDoLayout(UltraWebGrid grid) { Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(); _iprjType = WebUtility.GetByValueDropDownList(ddlPrjType); _iprjCode = txtPrjCode.Text.Trim(); _iprjName = txtPrjName.Text.Trim(); DataTable dt = objPrjInfo.GetTotalFootInfo(_iprjCode , _iprjName , _iprjType).Tables[0]; UltraGridRow row = new UltraGridRow(); grid.Rows.Add(row); UltraGridRow row2 = new UltraGridRow(); grid.Rows.Add(row2); UltraGridRow row3 = new UltraGridRow(); grid.Rows.Add(row3); row.Cells.FromKey("KPI_NAME").Value = "<B>소요예산 : </B>"; row2.Cells.FromKey("KPI_NAME").Value = "<B>집행현황 : </B>"; row3.Cells.FromKey("KPI_NAME").Value = "<B>진행율(%): </B>"; foreach (UltraGridColumn col in grid.Columns) { foreach (DataRow dr in dt.Rows) { if (col.Header.Column.Key == dr["PRJ_REF_ID"].ToString()) { double dTotalBudget = DataTypeUtility.GetToDouble(dr["TOTAL_BUDGET"]); row.Cells.FromKey(col.Header.Column.Key).Value = dTotalBudget.ToString("###,##0.#0"); double dExecAmount = DataTypeUtility.GetToDouble(dr["EXEC_AMOUNT"]); row2.Cells.FromKey(col.Header.Column.Key).Value = dExecAmount.ToString("###,##0.#0"); double dTotalRate = DataTypeUtility.GetToDouble(dr["RATE"]); row3.Cells.FromKey(col.Header.Column.Key).Value = dTotalRate.ToString("##0.#0"); } } } }
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; } }
private void UpdateComplete(string icompleteYN) { Biz_Prj_Info objPrj = new Biz_Prj_Info(); objPrj.IPrj_Ref_Id = this.IPrjRefID; objPrj.IComplete_YN = icompleteYN; int intRtn = objPrj.UpdateComplete(objPrj.IPrj_Ref_Id , objPrj.IComplete_YN , gUserInfo.Emp_Ref_ID ); if (intRtn > 0) { ltrScript.Text = JSHelper.GetAlertScript("사업정보 마감정보가 변경되었습니다."); this.IType = "U"; this.SetFormData(); this.SetButton(); } }
private void ReUsedViewData() { Biz_Prj_Info objPrj = new Biz_Prj_Info(); objPrj.IPrj_Ref_Id = this.IPrjRefID; int intRtn = objPrj.ReUsedData(objPrj.IPrj_Ref_Id , gUserInfo.Emp_Ref_ID ); ltrScript.Text = JSHelper.GetAlertScript(objPrj.Transaction_Message, false); if (objPrj.Transaction_Result == "Y") { this.IType = "U"; this.SetFormData(); this.SetButton(); } else { } }
protected void iBtnAddRow_Click(object sender, ImageClickEventArgs e) { this.IPrjRefID = WebUtility.GetIntByValueDropDownList(ddlPrjName); if (this._iPrjRefID == 0) { ltrScript.Text = JSHelper.GetAlertScript("사업명을 먼저 선택하여 주세요."); return; } Biz_Prj_Info objInfo = new Biz_Prj_Info(IPrjRefID); UltraGridRow row = new UltraGridRow(new object[] { "", "A", 0, objInfo.IPrj_Ref_Id, objInfo.IPrj_Code, objInfo.IPrj_Name, objInfo.IOwner_Emp_Id, objInfo.IOwner_Emp_Name, "", "", DateTime.Now.ToShortDateString(), "0" }); int cntRow = 0; ugrdPrjList.Rows.Add(row); cntRow = ugrdPrjList.Rows.Count - 1; //ugrdPrjList.Rows[cntRow].Cells.FromKey("ITYPE").Value = "A"; }
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(); }
protected void Page_Load(object sender, EventArgs e) { bizPrjInfo = new Biz_Prj_Info(); bizPrjData = new Biz_Prj_Data(); if (!IsPostBack) { DropDownListCommom.BindComp(ddlCompID, lblCompTitle); DropDownListCommom.BindEstTerm(ddlEstTermRefID); DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, WebUtility.GetIntByValueDropDownList(ddlCompID), "N"); } COMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID); ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID); ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID); ESTTERM_STEP_ID = 2; EST_ID = "3P"; //프로젝트 평가 DIRECTION_TYPE = "DN"; //하향식평가 STATUS_ID = "E"; //점수 산정 완료 ltrScript.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { quizWeight = new DataTable(); } COMP_ID = WebUtility.GetRequestByInt("COMP_ID"); EST_ID = WebUtility.GetRequest("EST_ID"); ESTTERM_REF_ID = WebUtility.GetRequestByInt("ESTTERM_REF_ID"); ESTTERM_SUB_ID = WebUtility.GetRequestByInt("ESTTERM_SUB_ID"); ESTTERM_STEP_ID = WebUtility.GetRequestByInt("ESTTERM_STEP_ID"); EST_DEPT_ID = WebUtility.GetRequestByInt("EST_DEPT_ID"); EST_EMP_ID = WebUtility.GetRequestByInt("EST_EMP_ID"); PRJ_REF_ID = WebUtility.GetRequestByInt("PRJ_REF_ID"); EST_TGT_TYPE = WebUtility.GetRequest("EST_TGT_TYPE", "EST"); TGT_DEPT_ID = WebUtility.GetRequestByInt("TGT_DEPT_ID", 0); TGT_EMP_ID = WebUtility.GetRequestByInt("TGT_EMP_ID", 0); READ_ONLY_YN = WebUtility.GetRequest("READ_ONLY_YN", "N"); _estInfos = new Biz_EstInfos(COMP_ID, EST_ID); _q_item_desc_use_yn = _estInfos.Q_Item_Desc_Use_YN; //PRJ_TYPE Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(PRJ_REF_ID); PRJ_TYPE = objPrjInfo.IPrj_Type; if (READ_ONLY_YN.Equals("N")) { Biz_TermInfos termInfos = new Biz_TermInfos(ESTTERM_REF_ID); Biz_TermSubs termSubs = new Biz_TermSubs(COMP_ID, ESTTERM_SUB_ID); Biz_TermSteps termSteps = new Biz_TermSteps(COMP_ID, ESTTERM_STEP_ID); Biz_EmpInfos estEmpInfos = new Biz_EmpInfos(EST_EMP_ID); Biz_EmpInfos tgtEmpInfos = new Biz_EmpInfos(TGT_EMP_ID); //Biz_DeptInfos estDeptInfo = new Biz_DeptInfos(EST_DEPT_ID); MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info bizComDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(EST_DEPT_ID); MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info tgtDeptInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Dept_Info(TGT_DEPT_ID); //Biz_Prj_Data data = new Biz_Prj_Data(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , EST_DEPT_ID // , EST_EMP_ID // , PRJ_REF_ID); _status_style_id = _estInfos.Status_Style_ID; Biz_Prj_QuestionPrjMap objQuestionPrjMap = new Biz_Prj_QuestionPrjMap(COMP_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , 0 , EST_ID , "" , PRJ_REF_ID); if (objQuestionPrjMap.Q_Obj_ID == null) { ltrScript.Text = JSHelper.GetAlertScript("프로젝트사업명에 대한 평가질의서가 매핑되지 않았습니다.", true); return; } // 창을 띄은 사람이 평가자 인지 체크 if (EST_EMP_ID == EMP_REF_ID) { _status_id = "P"; ibnSaveEst.Visible = true; } //else //{ // ibnSaveEst.Visible = false; // // 롤에 따른 버튼 권한이 있는지 확인 // //BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnSaveEst); //} Q_OBJ_ID = objQuestionPrjMap.Q_Obj_ID; EST_NAME = _estInfos.Est_Name; ESTTERM_REF_NAME = termInfos.EstTerm_Name; ESTTERM_SUB_NAME = termSubs.EstTerm_Sub_Name; ESTTERM_STEP_NAME = termSteps.EstTerm_Step_Name; EST_EMP_NAME = estEmpInfos.Emp_Name; EST_DEPT_NAME = bizComDeptInfo.DEPT_NAME; //estDeptInfo.Dept_Name; TGT_EMP_NAME = tgtEmpInfos.Emp_Name; TGT_DEPT_NAME = tgtDeptInfo.DEPT_NAME; //tgtDeptInfo.Dept_Name; PRJ_NAME = objPrjInfo.IPrj_Name; PRJ_CODE = objPrjInfo.IPrj_Code; } else { Q_OBJ_ID = WebUtility.GetRequest("Q_OBJ_ID"); ibnSaveEst.Visible = false; } if (!Page.IsPostBack) { SetLabelText(); //임의수정 Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); DataTable dt = bizPrjData.GetPrjData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, EST_DEPT_ID, EST_EMP_ID, TGT_DEPT_ID, TGT_EMP_ID, PRJ_REF_ID, "", "").Tables[0]; string Status_ID = ""; if (dt != null && dt.Rows.Count > 0) { Status_ID = dt.Rows[0]["STATUS_ID"].ToString(); } if (Status_ID.Equals("E")) { ibnSaveEst.Visible = false; } DataListBinding(dt); ibnSaveEst.Attributes.Add("onclick", "if(confirm('평가내용을 저장하시겠습니까?')) return ConfirmQuesiton();else return false;"); } ltrScript.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { bizPrjInfo = new Biz_Prj_Info(); bizComEmpRoleRel = new Biz_Com_Emp_Role_Rel(); EST_ID = "3Q"; EST_TGT_TYPE = WebUtility.GetRequest("EST_TGT_TYPE"); EST_EMP_ID = 0; if (EST_TGT_TYPE.Equals("EST")) { EST_EMP_ID = gUserInfo.Emp_Ref_ID; } int role_ref_id = 9;//성과평가관리자 if (bizComEmpRoleRel.IsMatch_EmpRole(gUserInfo.Emp_Ref_ID, role_ref_id)) { EST_EMP_ID = 0; } if (!IsPostBack) { DropDownListCommom.BindComp(ddlCompID, lblCompTitle); DropDownListCommom.BindEstTerm(ddlEstTermRefID); DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, WebUtility.GetIntByValueDropDownList(ddlCompID), "N"); this.prj_sDate.Value = System.DateTime.Now.AddMonths(-1); this.rdo_prj_select.Checked = false; this.rdo_prj_est.Checked = true; } COMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID); ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID); ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID); ltrScript.Text = ""; if (this.rdo_prj_select.Checked) { this.ibnSetTarget.Enabled = true; this.ibnSetTarget.Visible = true; } else { this.ibnSetTarget.Enabled = false; this.ibnSetTarget.Visible = false; } if (!IsPostBack) { doBind(); } }
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>"); } }
private void SetButton() { // 프로젝트 책임자가 아닐경우 Biz_Prj_Info objPrj = new Biz_Prj_Info(this.IPrjRefID); bool bIsOwner = objPrj.IsOwnerEmpIDYN(gUserInfo.Emp_Ref_ID, this.IPrjRefID); if (this.IType == "A") { iBtnInsert.Visible = true; iBtnUpdate.Visible = false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; iBtnDraft.Visible = false; iBtnReDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReqModify.Visible = false; } else if (this.IType == "U") { //iBtnInsert.Visible = false; //iBtnUpdate.Visible = (this.IType == "D") ? false : true; //iBtnDelete.Visible = (this.IType == "D") ? false : true; //iBtnReUsed.Visible = (this.IType == "D") ? true : false; iBtnComplete_Y.Visible = false; iBtnComplete_N.Visible = false; switch (this.IApp_Status) { case "": // 결재상태 없음 iBtnDraft.Visible = (bIsOwner) ? true : false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnDelete.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_nodraft: // 결재상태 없음 iBtnDraft.Visible = (bIsOwner) ? true : false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnDelete.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_draft: // 상신 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_ondraft: // 결재중 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_return: // 반려 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = (bIsOwner) ? true : false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnDelete.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_recall: // 결재회수 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = (bIsOwner) ? true : false; iBtnInsert.Visible = false; iBtnUpdate.Visible = (bIsOwner) ? true : false; iBtnDelete.Visible = (bIsOwner) ? true : false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_onmodify: // 수정결재 iBtnDraft.Visible = false; iBtnMoDraft.Visible = (bIsOwner) ? true : false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; break; case Biz_Type.app_status_complete: // 결재완료 iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = (bIsOwner) ? true : false; iBtnReWrite.Visible = false; iBtnInsert.Visible = false; iBtnUpdate.Visible = false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; if (objPrj.IComplete_YN == "Y") { iBtnComplete_Y.Visible = false; iBtnComplete_N.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; } else { iBtnComplete_Y.Visible = (bIsOwner || (User.IsInRole(ROLE_ADMIN))) ? true : false; iBtnComplete_N.Visible = false; } break; default: iBtnDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReDraft.Visible = false; iBtnReqModify.Visible = false; break; } } else if (this.IType == "D") { iBtnInsert.Visible = false; iBtnUpdate.Visible = (this.IType == "D") ? false : true; iBtnDelete.Visible = (this.IType == "D") ? false : true; iBtnReUsed.Visible = (this.IType == "D") ? true : false; iBtnDraft.Visible = false; iBtnReDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReqModify.Visible = false; } else if (this.IType == "S") { iBtnInsert.Visible = false; iBtnUpdate.Visible = false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; iBtnDraft.Visible = false; iBtnReDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReqModify.Visible = false; iBtnComplete_Y.Visible = false; iBtnComplete_N.Visible = false; } else { iBtnInsert.Visible = false; iBtnUpdate.Visible = false; iBtnDelete.Visible = false; iBtnReUsed.Visible = false; iBtnDraft.Visible = false; iBtnReDraft.Visible = false; iBtnMoDraft.Visible = false; iBtnReqModify.Visible = false; } if (this.IType == "A") { iBtnInsert.Visible = true; } }
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); }
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 InitializeGrid(UltraWebGrid grid) { Biz_Prj_Info objPrjInfo = new Biz_Prj_Info(); objPrjInfo.IPrj_Code = this.txtPrjCode.Text.Trim(); objPrjInfo.IPrj_Name = this.txtPrjName.Text.Trim(); objPrjInfo.IPrj_Type = WebUtility.GetByValueDropDownList(ddlPrjType); DataTable dt = objPrjInfo.GetList(objPrjInfo.IPrj_Code , objPrjInfo.IPrj_Name , 0 , "" , EMP_REF_ID , objPrjInfo.IPrj_Type).Tables[0]; _prjNameCount = dt.Rows.Count; grid.Columns.Clear(); AddColumn(ugrdPrjList , "ESTTERM_REF_ID" , "ESTTERM_REF_ID" , "ESTTERM_REF_ID" , "Left" , 100 , true , false); AddColumn(ugrdPrjList , "DEPT_REF_ID" , "DEPT_REF_ID" , "DEPT_REF_ID" , "Left" , 100 , true , false); AddColumn(ugrdPrjList , "KPI_REF_ID" , "KPI_REF_ID" , "KPI_REF_ID" , "Left" , 100 , true , false); AddColumn(ugrdPrjList , "부서명" , "DEPT_NAME" , "DEPT_NAME" , "Left" , 120 , false , true); AddColumn(ugrdPrjList , "지표명" , "KPI_NAME" , "KPI_NAME" , "Left" , 120 , false , true); // 사업명 컬럼 추가 foreach (DataRow row in dt.Rows) { AddColumn(ugrdPrjList , row["PRJ_NAME"].ToString() , row["PRJ_REF_ID"].ToString() , row["PRJ_REF_ID"].ToString() , "Center" , 150 , false, false); } }