private void InitPage() { Serial = int.Parse(Request.Params["Serial"]); string PmsId = Request.Params["PmsID"]; string crId = Request.Params["CrId"]; //Abel test用 //Serial = 697; //PmsId = "PMS201303010003"; SdpDetail sdpDetailParms = new SdpDetail(); sdpDetailParms.Serial = Serial; IList <PmsHead> pmsHead = new PmsHeadBiz().SelectPmsHeadByPmsId(PmsId); ; PmsHead ph = pmsHead[0]; TextBoxCrNo.Text = crId; TextBoxCrName.Text = ph.PmsName; IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms); if (sdpDetailList == null && sdpDetailList.Count == 0) { Msgbox("Data is null"); return; } SdpDetailResult = (sdpDetailList == null || sdpDetailList.Count == 0) ? new SdpDetail() : sdpDetailList[0]; ApprovedOutData(); ControlEnabled(SdpDetailResult.TaskStatus); }
protected void ButtonSave_Click(object sender, EventArgs e) { SdpDetail sdpDetail = new SdpDetail(); SdpDetailBiz sdpDetailBiz = new SdpDetailBiz(); bool result = true; sdpDetail.Resource = this.DropDownListNewResource.Text.Trim(); sdpDetail.Pmsid = PmsId; string[] serialArray = Serials.Split(';'); foreach (string serial in serialArray) { sdpDetail.Serial = int.Parse(serial); if (!sdpDetailBiz.UpdateSdpDetailResource(sdpDetail)) { result = false; } } if (!result) { Msgbox("Update resource failed!"); return; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true); } }
protected void InitData(string detailSerial) { Qisda.PMS.Entity.SdpDetail detail = new SdpDetail(); detail.Serial = Convert.ToInt32(detailSerial); detail = myTaskDetailBiz.GetDetailInfoBySerial(detail); if (detail != null) { this.TextBoxActualCost.Text = detail.Actualcost.ToString(); this.TextBoxComplete.Text = (detail.Completedpercent == null) ? string.Empty : detail.Completedpercent.ToString(); //add by Abel.Li 2014-01-06 this.TextBoxTaskStatus.Text = (detail.TaskStatusDesc == null) ? string.Empty : detail.TaskStatusDesc; //this.TextBoxForeTask.Text = (detail.PretaskNo == null) ? string.Empty : detail.PretaskNo.ToString(); this.TextBoxPlanCost.Text = (detail.Plancost == null) ? string.Empty : detail.Plancost.ToString(); this.TextBoxRemark.Text = (detail.Remark == null) ? string.Empty : detail.Remark.Trim(); this.TextBoxTaskName.Text = (detail.TaskName == null) ? string.Empty : detail.TaskName.Trim(); this.TextBoxPlanEnd.Text = pmsCommonBiz.ConvertDateToString(detail.Planendday); this.TextBoxPlanStart.Text = pmsCommonBiz.ConvertDateToString(detail.Planstartday); this.DateTextBoxActualEnd.Text = pmsCommonBiz.ConvertDateToString(detail.Actualendday); this.DateTextBoxActualStart.Text = pmsCommonBiz.ConvertDateToString(detail.Actualstartday); this.TextBoxRole.Text = (detail.Role == null) ? string.Empty : detail.Role.Trim(); this.TextBoxResource.Text = (detail.Resource == null) ? string.Empty : detail.Resource.Trim(); } PmsHead head = new PmsHeadBiz().SelectPmsHeadByPmsId(detail.Pmsid)[0]; if (head != null) { this.TextBoxProjectName.Text = (head.PmsName == null) ? string.Empty : head.PmsName.Trim(); this.TextBoxSysName.Text = (head.System == null) ? string.Empty : head.System.Trim(); } }
private void EditOutData() { SdpDetail sdpDetailParms = new SdpDetail(); sdpDetailParms.Serial = Serial; sdpDetailParms.Pmsid = PmsId; SdpDetailResult = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms)[0]; this.TextBoxAuditStatus.Text = SdpDetailResult.AuditStatusDesc; this.TextBoxTaskStatus.Text = SdpDetailResult.TaskStatusDesc; this.TextBoxTaskName.Text = SdpDetailResult.TaskName; this.DropDownListOperationType.SelectedValue = SdpDetailResult.OperationType.ToString(); this.DropDownListTaskType.SelectedValue = SdpDetailResult.TaskType.ToString(); this.DropDownListFunctionType.SelectedValue = SdpDetailResult.FunctionType.ToString(); this.DropDownListProgramLanguage.SelectedValue = SdpDetailResult.ProgramLanguage.ToString(); this.DropDownListTaskComplexity.SelectedValue = SdpDetailResult.TaskComplexity.ToString(); this.TextBoxRefCost.Text = (SdpDetailResult.Refcost.ToString() == "0") ? "" : SdpDetailResult.Refcost.ToString(); this.TextBoxPlanCost.Text = (SdpDetailResult.Plancost.ToString() == "0") ? "" : SdpDetailResult.Plancost.ToString(); this.DateTextBoxPlanStartDate.Text = new PmsCommonBiz().FormatDateTime(SdpDetailResult.Planstartday.ToString("yyyy-MM-dd").Trim()); this.DateTextBoxPlanEndDate.Text = new PmsCommonBiz().FormatDateTime(SdpDetailResult.Planendday.ToString("yyyy-MM-dd").Trim()); this.DropDownListResource.SelectedValue = SdpDetailResult.Resource; this.DropDownListRole.Items.Add(new ListItem(SdpDetailResult.Role, SdpDetailResult.Role)); this.DropDownListRole.SelectedValue = SdpDetailResult.Role; this.TextBoxPlanRemark.Text = SdpDetailResult.ScheduleRemark; }
protected void ButtonSave_Click(object sender, EventArgs e) { if (Request.QueryString["Serial"] != null) { Qisda.PMS.Entity.SdpDetail detail = new SdpDetail(); detail.Serial = Convert.ToInt32(Request.QueryString["Serial"].ToString().Trim()); detail = myTaskDetailBiz.GetDetailInfoBySerial(detail); detail.Actualstartday = pmsCommonBiz.ConvertDateTime(this.DateTextBoxActualStart.Text); detail.Actualendday = pmsCommonBiz.ConvertDateTime(this.DateTextBoxActualEnd.Text); detail.Actualcost = pmsCommonBiz.ConvertStringToFloat(this.TextBoxActualCost.Text); detail.Completedpercent = pmsCommonBiz.ConvertStringToFloat(this.TextBoxComplete.Text); detail.PretaskNo = pmsCommonBiz.ConvertStringToInt(this.TextBoxForeTask.Text); detail.Remark = this.TextBoxRemark.Text.Trim(); detail.Maintaindate = DateTime.Now; detail.Maintainuser = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", "."); if (myTaskDetailBiz.UpdatePmsSapDesignDetailInfo(detail)) { ScriptManager.RegisterStartupScript(updateActualCost, this.GetType(), "saveScript", "alert('Save Successful!');", true); //ScriptManager.RegisterStartupScript(updateActualCost, this.GetType(), // "updateScript", "window.close();", true); //ScriptManager.RegisterStartupScript(this.updateActualCost, this.GetType(), "deleteScript", "window.close();", true); Response.Write("<script>window.close();</script>"); } else { ScriptManager.RegisterStartupScript(updateActualCost, this.GetType(), "saveScript", "alert('Save Failed,Please try later!');", true); } } }
protected SdpDetail getSdpDetail(string pmsID) { SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Pmsid = pmsID; sdpDetail.Type = "Service"; return(sdpDetail); }
public bool UpdateSdpDetailAuditStatus(string serials, int auditStatus) { SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Serials = ""; sdpDetail.AuditStatus = auditStatus; return(new SdpDetailBiz().UpdateSdpDetailAuditStatus(sdpDetail)); }
protected void ButtonSave_Click(object sender, EventArgs e) { SdpDetailBiz sdpDetailBiz = new SdpDetailBiz(); SdpDetail sdpDetail = new SdpDetail(); DateTime dateTime = PmsSysBiz.GetDBDateTime(); sdpDetail.Pmsid = PmsId; sdpDetail.Phase = Phase; if (PhaseNull) { sdpDetail.Phase = DropDownListPhases.Text.Trim(); } sdpDetail.TaskName = TextBoxTaskName.Text.Trim(); sdpDetail.OperationType = int.Parse(DropDownListOperationType.Text.Trim()); sdpDetail.TaskType = int.Parse(DropDownListTaskType.Text.Trim()); sdpDetail.FunctionType = int.Parse(DropDownListFunctionType.Text.Trim()); sdpDetail.ProgramLanguage = int.Parse(DropDownListProgramLanguage.Text.Trim()); sdpDetail.TaskComplexity = int.Parse(DropDownListTaskComplexity.Text.Trim()); //sdpDetail.Actualcost = double.Parse(TextBoxRefCost.Text.Trim()); sdpDetail.Refcost = double.Parse(HiddenFieldRefCost.Value.Trim()); sdpDetail.Plancost = double.Parse(TextBoxPlanCost.Text.Trim()); sdpDetail.Auditor = new BaseDataUserBiz().SelectLeaderByLoginName(LoginName); HiddenFieldAuditor.Value = sdpDetail.Auditor; IList <PmsSys> pmsSysList = new PmsSysBiz().SelectData2ByTypeData1("PM", "AuditAgent", sdpDetail.Auditor); sdpDetail.AuditorAgent = (pmsSysList == null || pmsSysList.Count == 0) ? "" : pmsSysList.FirstOrDefault().Data2; HiddenFieldAuditorAgent.Value = sdpDetail.AuditorAgent; sdpDetail.Planstartday = DateTime.Parse(DateTextBoxPlanStartDate.Text.Trim()); sdpDetail.Planendday = DateTime.Parse(DateTextBoxPlanEndDate.Text.Trim()); sdpDetail.Resource = DropDownListResource.Text.Trim(); //sdpDetail.Role = DropDownListRole.Text.Trim(); sdpDetail.Role = HiddenFieldRole.Value.Trim(); sdpDetail.ScheduleRemark = TextBoxPlanRemark.Text.Trim(); sdpDetail.AuditStatus = 1; sdpDetail.TaskStatus = 1; sdpDetail.Taskno = 1; sdpDetail.Iseditable = "Y"; sdpDetail.Deleteflag = "N"; sdpDetail.Createdate = dateTime; sdpDetail.Createuser = LoginName; sdpDetail.Maintaindate = dateTime; sdpDetail.Maintainuser = LoginName; TaskSerial = sdpDetailBiz.InsertSdpDetail(sdpDetail); HiddenFieldSerial.Value = TaskSerial.ToString(); if (TaskSerial > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true); } else { Msgbox("Save the new item failed!"); return; } //更新head表的PlanStartDate new PmsHeadBiz().UpdatePmsHeadPlanStartDate(PmsId); }
public bool InsertCopyFromDevelopment(IList <SdpDetail> pmsSdpDetailIlist, string strPmsID, string strUser) { DateTime dateTime = PmsSysBiz.GetDBDateTime(); PmsCommonBiz pmsCommonBiz = new PmsCommonBiz(); try { m_PMSSqlConnection.BeginTransaction(); for (int i = 0; i < pmsSdpDetailIlist.Count; i++) { SdpDetail pmsSdpDetail = new SdpDetail(); pmsSdpDetail.Pmsid = strPmsID; pmsSdpDetail.TaskName = pmsSdpDetailIlist[i].TaskName; pmsSdpDetail.Phase = PmsCommonEnum.EnumSdpPhase.Test.ToString(); pmsSdpDetail.Role = pmsSdpDetailIlist[i].Role; pmsSdpDetail.Resource = pmsSdpDetailIlist[i].Resource; pmsSdpDetail.Taskno = int.Parse(pmsSdpDetailIlist[i].Taskno.ToString()); pmsSdpDetail.Plancost = double.Parse(pmsSdpDetailIlist[i].Plancost.ToString()); pmsSdpDetail.Actualcost = double.Parse(pmsSdpDetailIlist[i].Actualcost.ToString()); pmsSdpDetail.Completedpercent = double.Parse(pmsSdpDetailIlist[i].Completedpercent.ToString()); pmsSdpDetail.Planstartday = pmsSdpDetailIlist[i].Planstartday; pmsSdpDetail.Planendday = pmsSdpDetailIlist[i].Planendday; pmsSdpDetail.Actualstartday = pmsCommonBiz.ConvertDateTime(""); pmsSdpDetail.Actualendday = pmsCommonBiz.ConvertDateTime(""); pmsSdpDetail.PretaskNo = int.Parse(pmsSdpDetailIlist[i].PretaskNo.ToString()); pmsSdpDetail.Remark = pmsSdpDetailIlist[i].Remark; pmsSdpDetail.Iseditable = "Y"; pmsSdpDetail.Deleteflag = "N"; pmsSdpDetail.Createdate = dateTime; pmsSdpDetail.Createuser = strUser; pmsSdpDetail.Maintaindate = dateTime; pmsSdpDetail.Maintainuser = strUser; int insertResult = InsertSdpDetail(pmsSdpDetail); if (insertResult <= 0) { m_PMSSqlConnection.RollBackTransaction(); return(false); } } m_PMSSqlConnection.CommitTransaction(); return(true); } catch (Exception ex) { m_PMSSqlConnection.RollBackTransaction(); m_Logger.Error("SdpDetailBiz/InsertFromCopyFromDevelopment:" + ex.Message.ToString()); return(false); } }
public IList <SdpDetail> SelectPmsSdpDetailInfo(SdpDetail pmsSdpDetail) { try { return(m_PMSSqlConnection.QueryForList <SdpDetail>("SelectPmsSdpDetailInfo", pmsSdpDetail)); } catch (Exception ex) { m_Logger.Error("SdpDetailBiz/SelectPmsSdpDetailInfo" + ex.Message.ToString()); return(null); } }
/// <summary> /// get sdp detail infromaton by serial ,then return object sdepdetail /// </summary> /// <param name="pmsSdpDetail"></param> /// <returns></returns> public SdpDetail GetDetailInfoBySerial(SdpDetail sdpDetail) { try { return(m_PMSSqlConnection.QueryForObject <SdpDetail>("SelectSdpDetail", sdpDetail)); } catch (Exception ex) { m_Logger.Error("MyTaskDetailBiz/GetPmsSdpDetailBySerial" + ex.Message.ToString()); return(null); } }
public IList <SdpDetail> SelectSdpDetail(SdpDetail sdpDetail) { try { return(m_PMSSqlConnection.QueryForList <SdpDetail>("SelectSdpDetail", sdpDetail)); } catch (Exception ex) { m_Logger.Error("SdpDetailBiz/SelectSdpDetail:" + ex.ToString()); return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { bool updateTrue; if (this.HiddenButtonName.Value == "Save" || this.HiddenButtonName.Value == "Reactive" || this.HiddenButtonName.Value == "Pending") { SdpDetailResult.Actualstartday = (this.DateTextBoxActualStartDate.Text.Trim() == "") ? new DateTime() : DateTime.Parse(this.DateTextBoxActualStartDate.Text.Trim()); SdpDetailResult.Actualendday = (this.DateTextBoxActualEndDate.Text.Trim() == "") ? new DateTime() : DateTime.Parse(this.DateTextBoxActualEndDate.Text.Trim()); SdpDetailResult.Actualcost = (this.TextBoxActualCost.Text.Trim() == "") ? 0 : double.Parse(this.TextBoxActualCost.Text.Trim()); SdpDetailResult.Completedpercent = (this.HiddenPercent.Value == "") ? 0 : double.Parse(this.HiddenPercent.Value); SdpDetailResult.ExecuteRemark = this.TextBoxExecuteRemark.Text; SdpDetailResult.TaskStatus = int.Parse(this.HiddenTaskStatus.Value); updateTrue = new SdpDetailBiz().UpdateSdpDetail(SdpDetailResult); } else if (this.HiddenButtonName.Value == "HardClose") { SdpDetailResult.TaskStatus = int.Parse(this.HiddenTaskStatus.Value); SdpDetailResult.Actualendday = PmsSysBiz.GetDBDateTime(); SdpDetailResult.Completedpercent = 100d; updateTrue = new SdpDetailBiz().UpdateSdpDetail(SdpDetailResult); } else { SdpDetailResult.TaskStatus = int.Parse(this.HiddenTaskStatus.Value); updateTrue = new SdpDetailBiz().UpdateSdpDetail(SdpDetailResult); } if (this.HiddenButtonName.Value == "Save" && updateTrue) { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "SaveSuccess();", true); //更新head表的ActualStartDate new PmsHeadBiz().UpdatePmsHeadActualStartDate(SdpDetailResult.Pmsid); } if (!updateTrue) { Msgbox("Update fails!"); } SdpDetail sdpDetailParms = new SdpDetail(); sdpDetailParms.Serial = Serial; SdpDetailResult = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms)[0]; this.TextBoxTaskStatus.Text = SdpDetailResult.TaskStatusDesc; this.HiddenFieldResultTaskStatus.Value = SdpDetailResult.TaskStatus.ToString(); ControlEnabled(SdpDetailResult.TaskStatus); InitPage(); }
public bool UpdatePmsSapDesignDetailInfo(SdpDetail sdpDetail) { try { object obj = m_PMSSqlConnection.Update("UpdatePmsSapDesignDetailInfo", sdpDetail); return(true); } catch (Exception ex) { m_Logger.Error("MyTaskDetailBiz/UpdatePmsSapDesignDetailInfo:" + ex.Message.ToString()); return(false); } }
private void BindGrid() { SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Pmsid = this.PmsID; sdpDetail.Phase = this.Phase.ToString(); IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetail); if (sdpDetailList != null && sdpDetailList.Count > 0) { GridViewByPhase.DataSource = sdpDetailList; GridViewByPhase.DataBind(); } }
/// <summary> /// Save Service Data /// </summary> /// <param name="pmsHead"></param> /// <param name="sdpDetail"></param> /// <param name="pmsFlow"></param> /// <param name="pmsDocuments"></param> /// <returns></returns> public int InsertServiceDataToDB(PmsHead pmsHead, SdpDetail sdpDetail, PmsFlow pmsFlow, PmsDocuments pmsDocuments) { int returnResult = 0; try { m_PMSSqlConnection.BeginTransaction(); // Insert PmsHead pmsHead.Vid = "PM"; pmsHead.Stage = 1; pmsHead.Pm = ""; pmsHead.Sd = ""; pmsHead.Se = ""; pmsHead.Qa = ""; // m_PMSSqlConnection.Insert("InsertPmsHead", pmsHead); // Insert SdpDetail SdpDetailBiz sdpDetailBiz = new SdpDetailBiz(); returnResult = sdpDetailBiz.InsertSdpDetailByTemplate(sdpDetail); if (returnResult == 0) { m_PMSSqlConnection.RollBackTransaction(); return(returnResult); } // Insert PmsFlow PmsFlowBiz pmsFlowBiz = new PmsFlowBiz(); pmsFlowBiz.InsertPmsFlow(pmsFlow); // Insert PmsDocuments if (pmsDocuments.FileName != string.Empty) { m_PMSSqlConnection.Insert("InsertPmsDocuments", pmsDocuments); } m_PMSSqlConnection.CommitTransaction(); } catch (Exception ex) { m_PMSSqlConnection.RollBackTransaction(); m_Logger.Error("PmsHeadBiz/InsertServiceDataToDB" + ex.Message.ToString()); } return(returnResult); }
private void BindGrid() { SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Pmsid = Request.QueryString["PmsId"]; sdpDetail.Phase = this.Phase.ToString(); sdpDetail.AuditStatus = (int)PmsCommonEnum.AuditStatus.HasApproved; IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetail); if (sdpDetailList != null && sdpDetailList.Count > 0) { GridViewByPhase.DataSource = sdpDetailList; GridViewByPhase.DataBind(); } }
//add by Ename Wang on 20131227 public bool UpdateSdpDetailAuditStatus(SdpDetail sdpDetail) { bool updateResult = false; try { m_PMSSqlConnection.Update("UpdateSdpDetailAuditStatus", sdpDetail); updateResult = true; } catch (Exception ex) { m_Logger.Error("SdpDetailBiz/UpdateSdpDetail:" + ex.ToString()); } return(updateResult); }
protected void BindDataList(DataList dataList, PmsCommonEnum.EnumTime type) { MyTaskBiz myTaskBusiness = new MyTaskBiz(); SdpDetail detail = new SdpDetail(); detail.Resource = WSC.GlobalDefinition.Cookie_LoginUser.Trim().Replace(" ", "."); dataList.DataSource = myTaskBusiness.GetMyTaskData(detail, type); //dataList.DataSource = new List<MyTaskCondition>() //{ //}; dataList.DataBind(); if (dataList.Items.Count == 0) { dataList.ShowHeader = false; } }
protected void GridViewByPhase_OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { SdpDetail sdpDetail = e.Row.DataItem as SdpDetail; if (sdpDetail != null) { e.Row.Attributes.Add("serial", sdpDetail.Serial.ToString()); e.Row.Attributes.Add("createuser", sdpDetail.Createuser == null ? "" : sdpDetail.Createuser.ToUpper()); e.Row.Attributes.Add("phase", this.Phase.ToString()); e.Row.Attributes.Add("auditstatus", sdpDetail.AuditStatus.ToString()); e.Row.Attributes.Add("taskstatus", sdpDetail.TaskStatus.ToString()); e.Row.Attributes.Add("resource", sdpDetail.Resource == null ? "" : sdpDetail.Resource.ToUpper()); e.Row.Attributes.Add("auditor", sdpDetail.Auditor == null ? "" : sdpDetail.Auditor.ToUpper()); e.Row.Attributes.Add("auditoragent", sdpDetail.AuditorAgent == null ? "" : sdpDetail.AuditorAgent.ToUpper()); } } }
public int InsertSdpDetailByTemplate(SdpDetail sdpDetail) { int returnSerial = 0; try { object objResult = m_PMSSqlConnection.Insert("InsertSdpDetailByTemplate", sdpDetail); if (objResult != null) { returnSerial = (int)objResult; } } catch (Exception ex) { m_Logger.Error("SdpDetailBiz/InsertSdpDetailByTemplate" + ex.Message.ToString()); } return(returnSerial); }
public string CheckTaskNameAndResource(string taskName, string resource, string pmsid, string phase, string role) { SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Pmsid = pmsid; sdpDetail.TaskName = taskName; sdpDetail.Phase = phase; sdpDetail.Role = role; sdpDetail.Resource = resource; IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetail); if (sdpDetailList != null && sdpDetailList.Count > 0) { if (sdpDetailList[0].TaskName == sdpDetail.TaskName && sdpDetailList[0].Resource == sdpDetail.Resource) { return("{'Exist':'Y','TaskStatus':'" + sdpDetailList[0].TaskStatus + "','serial':'" + sdpDetailList[0].Serial + "'}"); } } return("{'Exist':'N','TaskStatus':'0','serial':'-1'}"); }
protected void GridViewByPhase_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { SdpDetail sdpDetail = e.Row.DataItem as SdpDetail; if (sdpDetail != null) { e.Row.Attributes.Add("serial", sdpDetail.Serial.ToString()); e.Row.Attributes.Add("createuser", sdpDetail.Createuser == null ? "" : sdpDetail.Createuser.ToUpper().ToString()); e.Row.Attributes.Add("phase", this.Phase.ToString()); e.Row.Attributes.Add("taskname", sdpDetail.TaskName.ToString()); e.Row.Attributes.Add("tasktypedesc", sdpDetail.TaskTypeDesc.ToUpper().ToString()); e.Row.Attributes.Add("taskstatus", sdpDetail.TaskStatus.ToString()); e.Row.Attributes.Add("resource", sdpDetail.Resource == null ? "" : sdpDetail.Resource.ToUpper().ToString()); e.Row.Attributes.Add("auditor", sdpDetail.Auditor == null ? "" : sdpDetail.Auditor.ToUpper().ToString()); e.Row.Attributes.Add("auditoragent", sdpDetail.AuditorAgent == null ? "" : sdpDetail.AuditorAgent.ToUpper().ToString()); e.Row.Attributes.Add("completepercent", sdpDetail.Completedpercent.ToString()); e.Row.Attributes.Add("plancost", sdpDetail.Plancost.ToString()); e.Row.Attributes.Add("actualcost", sdpDetail.Actualcost.ToString()); } } }
protected void Page_Load(object sender, EventArgs e) { string PmsId = Request.QueryString["PmsID"]; string CrID = Request.QueryString["CrId"]; string Phase = Request.QueryString["Phase"]; int Serial = 0; int.TryParse(Request.QueryString["Serial"], out Serial); if (PmsId == null || CrID == null || Phase == null || Serial == 0) { return; } IList <PmsHead> pmsHeadList = new PmsHeadBiz().SelectPmsHead(PmsId, ""); PmsHead pmsHead; if (pmsHeadList != null && pmsHeadList.Count > 0) { pmsHead = pmsHeadList[0]; } else { return; } SdpDetail sdpDetailParms = new SdpDetail(); sdpDetailParms.Serial = Serial; sdpDetailParms.Pmsid = PmsId; IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sdpDetailParms); SdpDetail sdpDetailResult = (sdpDetailList == null || sdpDetailList.Count == 0) ? new SdpDetail() : sdpDetailList[0]; PmsCommonEnum.PlanPhase planPhase = (PmsCommonEnum.PlanPhase)System.Enum.Parse(typeof(PmsCommonEnum.PlanPhase), Phase); string phaseDescription = planPhase.GetDescription(); string formatPlanstartday = new PmsCommonBiz().FormatDateTime(sdpDetailResult.Planstartday.ToString("yyyy-MM-dd").Trim()); string formatPlanendday = new PmsCommonBiz().FormatDateTime(sdpDetailResult.Planendday.ToString("yyyy-MM-dd").Trim()); string resultHtml = "<table class='ViewTaskTable'>" + "<tr><td><span class='ViewTaskSpan'>CR No</span></td><td colspan='3'><input type='text' class='ViewTaskOnlyTextBox' value='" + pmsHead.CrId + "' /></td></tr>" + "<tr><td><span class='ViewTaskSpan'>CR Name</span></td><td colspan='3'><input type='text' class='ViewTaskOnlyTextBox' value='" + pmsHead.PmsName + "'style='width: 325px;'/></td></tr>" + "<tr><td><span class='ViewTaskSpan'>任务阶段</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + phaseDescription + "'/></td>" + "<td><span class='ViewTaskSpan'>审核状态</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.AuditStatusDesc + "' /></td></tr>" + "<tr><td><span class='ViewTaskSpan'>任务状态</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.TaskStatusDesc + "' /></td><td> </td><td> </td></tr>" + "<tr><td><span class='ViewTaskSpan'>任务名称</span></td>" + "<td colspan='3'><div style=' border-bottom: 1px solid #CCCCCC;width: 325px; white-space: normal;text-overflow: ellipsis; text-align: Left'>" + sdpDetailResult.TaskName + "</div></td></tr>" + "<tr><td><span class='ViewTaskSpan'>作业方式</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.OperationTypeDesc + "'/></td>" + "<td><span class='ViewTaskSpan'>任务类型</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.TaskTypeDesc + "'/></td></tr>" + "<tr><td><span class='ViewTaskSpan'>功能分类</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.FunctionTypeDesc + "'/></td>" + "<td><span class='ViewTaskSpan'>语言</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.ProgramLanguageDesc + "'/></td></tr>" + "<tr><td><span class='ViewTaskSpan'>复杂度</span></td>" + "<td colspan='3'><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.TaskComplexityDesc + "'/></td></tr>" + "<tr><td><span class='ViewTaskSpan'>参考工时</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Actualcost + "' /></td>" + "<td><span class='ViewTaskSpan'>计划工时</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Plancost + "' /></td></tr>" + "<tr><td><span class='ViewTaskSpan'>计划开始</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + formatPlanstartday + "' /></td>" + "<td><span class='ViewTaskSpan'>计划结束</span></td><td><input type='text' class='ViewTaskOnlyTextBox' value='" + formatPlanendday + "' /> </td></tr>" + "<tr><td><span class='ViewTaskSpan'>指派给</span></td>" + "<td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Resource + "'/></td><td><span class='ViewTaskSpan'>资源角色</span></td>" + "<td><input type='text' class='ViewTaskOnlyTextBox' value='" + sdpDetailResult.Role + "'/></td></tr>" + "<tr><td><span class='ViewTaskSpan'>说明</span></td>" + "<td colspan='3'><div style='border-bottom: 1px solid #CCCCCC; width: 325px; white-space: normal;text-overflow: ellipsis; text-align: Left'>" + sdpDetailResult.ScheduleRemark + "</div></td></tr>"; Response.Write(resultHtml); }
private int GetAuditStatus(SdpDetail sdpDetailResult, SdpDetail sdpDetailPage) { int AuditStatus = -1; switch (sdpDetailResult.AuditStatus) { case 1: AuditStatus = 1; break; case 2: SdpDetail sParms = new SdpDetail(); sParms.Serial = Serial; IList <SdpDetail> sdpDetailList = new SdpDetailBiz().SelectSdpDetail(sParms); if (sdpDetailList[0].AuditStatus != 2) { Msgbox("Audit status has changed, please refresh. "); } else { AuditStatus = 2; } break; case 3: if (sdpDetailResult.TaskStatus == 1) { AuditStatus = 1; } if (sdpDetailResult.TaskStatus == 3 || sdpDetailResult.TaskStatus == 4 || sdpDetailResult.TaskStatus == 5 || sdpDetailResult.TaskStatus == 6) { Msgbox("This audit status can not save! "); break; } if (sdpDetailResult.TaskStatus == 2) { if (hidvalueIsSave.Value != "Y") { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "Test();", true); break; } else { SdpDetail oldParms = new SdpDetail(); oldParms.Serial = Serial; SdpDetail oldSdpDetail = new SdpDetailBiz().SelectSdpDetail(oldParms)[0]; if (oldSdpDetail.Plancost != sdpDetailPage.Plancost || oldSdpDetail.Planstartday != sdpDetailPage.Planstartday || oldSdpDetail.Planendday != sdpDetailPage.Planendday) { AuditStatus = 1; break; } else { AuditStatus = oldSdpDetail.AuditStatus; } } } break; case 4: AuditStatus = 1; break; } return(AuditStatus); }
/// <summary> /// 检查是否已上传stage必要的文档 /// </summary> /// <param name="pmsId">当前的PmsId</param> /// <param name="stage">当前的项目进度Stage</param> /// <param name="message">记录用以返回的必要的提示信息</param> /// <returns>如果该Stage必要的所有文档都已上传,则返回true,否则返回false</returns> public bool CheckDocuments(PmsHead pmsHead, int stage, out string message) { message = string.Empty; // modified by Ename Wang on 20120209 string pmsId = pmsHead.PmsId; PmsDocumentTypeBiz pmsDocumentTypeBiz = new PmsDocumentTypeBiz(); IList <PmsDocumentType> pmsDocumentTypeIdName = pmsDocumentTypeBiz.SelectDistinctDocTypeIdName(pmsId, stage); //end modified //STP属于PIS|STP阶段的产出文档,当由Develop|Test Premote到下一个Stage时要做额外的check。 //STC属于Develop|Test 阶段的产出文档,当由Develop|Test Stage Premote到下一个Stage时要做额外的check。 if (stage == (int)PmsCommonEnum.ProjectStage.Develop_Test) { if (pmsHead.NeedSTP == "Y") { PmsDocumentType pmsDocumentTypeSTP = new PmsDocumentType(); pmsDocumentTypeSTP.TypeId = (int)PmsCommonEnum.DocumentType.STP; pmsDocumentTypeSTP.TypeName = PmsCommonEnum.DocumentType.STP.GetDescription(); pmsDocumentTypeIdName.Add(pmsDocumentTypeSTP); } if (pmsHead.NeedSTC == "Y") { PmsDocumentType pmsDocumentTypeSTC = new PmsDocumentType(); pmsDocumentTypeSTC.TypeId = (int)PmsCommonEnum.DocumentType.STC; pmsDocumentTypeSTC.TypeName = PmsCommonEnum.DocumentType.STC.GetDescription(); pmsDocumentTypeIdName.Add(pmsDocumentTypeSTC); } } // add by Ename Wang on 20130308 在点Release or Partial Release的时候,如果开发计划工时>80H 就必须上传STP,STC if (stage == (int)PmsCommonEnum.ProjectStage.Release) { SdpDetailBiz sdpDetailBiz = new SdpDetailBiz(); SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Pmsid = pmsHead.PmsId; sdpDetail.Phase = "5"; IList <SdpDetail> sdpDetailList = sdpDetailBiz.SelectSdpDetail(sdpDetail); decimal totalPlanCost = (decimal)sdpDetailList.Select(t => t.Plancost).Sum(); if (totalPlanCost > 80) { PmsDocumentType pmsDocumentTypeSTP = new PmsDocumentType(); pmsDocumentTypeSTP.TypeId = (int)PmsCommonEnum.DocumentType.STP; pmsDocumentTypeSTP.TypeName = PmsCommonEnum.DocumentType.STP.GetDescription(); pmsDocumentTypeIdName.Add(pmsDocumentTypeSTP); PmsDocumentType pmsDocumentTypeSTC = new PmsDocumentType(); pmsDocumentTypeSTC.TypeId = (int)PmsCommonEnum.DocumentType.STC; pmsDocumentTypeSTC.TypeName = PmsCommonEnum.DocumentType.STC.GetDescription(); pmsDocumentTypeIdName.Add(pmsDocumentTypeSTC); } } // end add //TypeId为int型,所以需要不用加上‘’ string docTypeId = pmsDocumentTypeIdName.Aggregate(string.Empty, (current, pmsDocumentType) => + pmsDocumentType.TypeId + "," + current); //如果docTypeId为空,则证明该stage不需要文档,因此返回true if (string.IsNullOrEmpty(docTypeId)) { message = string.Empty; return(true); } //如果docTypeId不为空,则需要检查数据库中是否存在该stage必要上传的文件。 docTypeId = docTypeId.Substring(0, docTypeId.Length - 1); PmsDocumentsBiz pmsDocumentsBiz = new PmsDocumentsBiz(); IList <PmsDocuments> pmsDocumentsDocTypeId = pmsDocumentsBiz.SelectPmsDocumentsDocTypeId(pmsHead.PmsId, docTypeId); IList <int> typeIdExist = pmsDocumentsDocTypeId.Select(t => t.DocTypeId).ToList(); // IList<int> typeIdExist = pmsDocumentsBiz.SelectPmsDocumentsDocTypeId(pmsId, docTypeId); bool result = true; StringBuilder msg = new StringBuilder(); msg.Append("Please upload the necessary documents:"); foreach (PmsDocumentType documentType in pmsDocumentTypeIdName) { if (!typeIdExist.Contains(documentType.TypeId)) { msg.Append(documentType.TypeName); msg.Append(","); result = false; } } if (!result) { message = msg.ToString(); message = message.Substring(0, message.Length - 1) + "!"; } return(result); }
public int InsertPmsHeadAndDoc(PmsHead pmsHead, SdpDetail sdpDetail, PmsChangeHistory pmsChangeHistory, PmsItarmMapping pmsItarmMapping, PmsFlow pmsFlow, ItarmCrList itarmCrList, IList <PmsDocuments> listPmsDocuments, out string errorInfo) { errorInfo = string.Empty; int returnResult = 0; try { m_PMSSqlConnection.BeginTransaction(); #region Insert PmsHead //string type = pmsHead.PmsName.GetTypeCode; m_PMSSqlConnection.Insert("InsertPmsHead", pmsHead); #endregion #region Insert PmsItarmMapping PmsItarmMappingBiz pmsItarmMappingBiz = new PmsItarmMappingBiz(); pmsItarmMappingBiz.InsertPmsItarmMapping(pmsItarmMapping); #endregion #region Insert PmsDocuments if (listPmsDocuments != null) { foreach (PmsDocuments pmsDocuments in listPmsDocuments) { if (pmsDocuments.DocTypeId == 0) { errorInfo = "DocTypeId is Invalid!"; return(returnResult); } if (pmsDocuments.FileName == string.Empty) { errorInfo = "FileName is Empty!"; return(returnResult); } if (pmsDocuments.FileName != string.Empty) { m_PMSSqlConnection.Insert("InsertPmsDocuments", pmsDocuments); } } } #endregion #region Insert SdpDetail SdpDetailBiz sdpDetailBiz = new SdpDetailBiz(); returnResult = sdpDetailBiz.InsertSdpDetailByTemplate(sdpDetail); if (returnResult == 0) { m_PMSSqlConnection.RollBackTransaction(); return(returnResult); } #endregion #region Insert PmsChangeHistory PmsChangeHistoryBiz pmsChangeHistoryBiz = new PmsChangeHistoryBiz(); pmsChangeHistoryBiz.InsertPmsChangeHistory(pmsChangeHistory); #endregion #region Insert PmsFlow PmsFlowBiz pmsFlowBiz = new PmsFlowBiz(); pmsFlowBiz.InsertPmsFlow(pmsFlow); #endregion #region Insert ItarmCrList bool resultInsertItarm = new PmsCRCreatBiz().InsertItarmCrList(itarmCrList); if (!resultInsertItarm) { m_PMSSqlConnection.RollBackTransaction(); errorInfo = "Save Fail"; return(0); } #endregion m_PMSSqlConnection.CommitTransaction(); } catch (Exception ex) { m_PMSSqlConnection.RollBackTransaction(); errorInfo = "Save Fail"; m_Logger.Error("PmsHeadBiz/InsertPmsHeadAndDoc" + ex.Message.ToString()); } return(returnResult); }
//private void BindDropDownListSiteAndImpactSite() //{ // try // { // PmsSys pmsSys = new PmsSys(); // pmsSys.Vid = "PM"; // pmsSys.Type = "Site"; // PmsSysBiz pmsSysBiz = new PmsSysBiz(); // IList<PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType(pmsSys); // dropdownlistSite.DataSource = pmsSysList; // dropdownlistSite.DataTextField = "Data1"; // dropdownlistSite.DataValueField = "Data1"; // dropdownlistSite.DataBind(); // dropdownlistSite.Items.Insert(0, ""); // dropdownlistImpactSite.DataSource = pmsSysList; // dropdownlistImpactSite.DataTextField = "Data1"; // dropdownlistImpactSite.DataValueField = "Data1"; // dropdownlistImpactSite.DataBind(); // QWeb.SelectItem(dropdownlistImpactSite, "QCS"); // //dropdownlistSite.Items.Insert(0, new ListItem()); // //dropdownlistSite.Items[0].Text = ""; // //dropdownlistSite.Items[0].Value = ""; // //dropdownlistImpactSite.Items.Insert(0, new ListItem()); // //dropdownlistImpactSite.Items[0].Text = ""; // //dropdownlistImpactSite.Items[0].Value = ""; // } // catch // { // ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Bind ImpactSite failure');", true); // } //} #endregion #endregion protected void buttonSave_Click(object sender, EventArgs e) { try { //#region Define Variable ////string strSavePath = ""; ////int iTypeID = 0; //#endregion //检查控件中的值 if (!CheckControlValue()) { return; } //获取新的Pmsid,CrId以及他们的创建时间 DateTime dtCurDate; string strPmsID = string.Empty; string strCrId = string.Empty; m_PmsCRCreatBiz.GetNewPmsIdTempCrId(out dtCurDate, out strPmsID, out strCrId); #region Get StageID PmsFlowTemplateBiz pmsFlowTemplateBiz = new PmsFlowTemplateBiz(); IList <PmsFlowTemplate> pmsFlowTemplateList = pmsFlowTemplateBiz.SelectPmsFlowTemplateByTypeId(dropdownlistType.SelectedValue.Trim()); int stageId = pmsFlowTemplateList[0].Stageid; #endregion #region For Insert PmsHead PmsHead pmsHeadInsert = new PmsHead(); pmsHeadInsert.Vid = "PM"; pmsHeadInsert.PmsId = strPmsID; pmsHeadInsert.PmsName = textboxPmsName.Text.Trim().Replace("'", ""); pmsHeadInsert.Type = dropdownlistType.SelectedItem.Text.Trim(); pmsHeadInsert.Description = textboxDescription.Text.Trim().Replace("'", ""); pmsHeadInsert.System = textboxSystem.Text.Trim().Replace("'", ""); pmsHeadInsert.Domain = dropdownlistDomain.SelectedItem.Text.Trim(); pmsHeadInsert.Priority = dropdownlistPriority.SelectedItem.Text.Trim(); pmsHeadInsert.Site = dropdownlistSite.SelectedValue; pmsHeadInsert.ImpactSite = dropdownlistImpactSite.SelectedItem.Text.Trim(); pmsHeadInsert.NeedSTP = RadioButtonNeedSTPYes.Checked ? "Y" : "N"; pmsHeadInsert.NeedSTC = RadioButtonNeedSTCYes.Checked ? "Y" : "N"; //要插VB2Net add by ITO.Abel.Li 2014-01-06 pmsHeadInsert.Category = RadioButtonVB2NetYes.Checked ? "Y" : "N"; pmsHeadInsert.NewVersion = textboxNewVersion.Text.Trim().Replace("'", ""); // pmsHeadInsert.OldVersion = textboxOldVersion.Text.Trim().Replace("'", ""); pmsHeadInsert.OldVersion = HiddenFieldOldVersion.Value.Trim().Replace("'", ""); pmsHeadInsert.DueDate = DateTime.Parse(dateTextBoxDueDate.Text.Trim()); pmsHeadInsert.PlanStartDate = DateTime.Parse(dateTextBoxPlanStartDate.Text.Trim()); //pmsHeadInsert.ReleaseDate = 0; //pmsHeadInsert.CloseDate = 0; pmsHeadInsert.Stage = stageId; pmsHeadInsert.Pm = textboxPM.Text.Trim().Replace("'", ""); pmsHeadInsert.Sd = ""; pmsHeadInsert.Se = ""; pmsHeadInsert.Qa = ""; pmsHeadInsert.AbnormalStage = 0; pmsHeadInsert.Rerver1 = ""; pmsHeadInsert.Rerver2 = ""; pmsHeadInsert.Rerver3 = ""; pmsHeadInsert.Rerver4 = ""; pmsHeadInsert.Rerver5 = ""; pmsHeadInsert.CreateDate = dtCurDate; pmsHeadInsert.Creator = LoginName; //pmsHeadInsert.MaintainDate = dtCurDate; pmsHeadInsert.MaintainUser = ""; pmsHeadInsert.OwnerDept = m_PmsCRCreatBiz.GetOwnerDept(LoginName) ?? string.Empty; pmsHeadInsert.RelatedCrNo = textboxRelatedCrNo.Text.Trim(); #endregion #region For Insert PMS_ITARM_Mapping PmsItarmMapping pmsItarmMapping = new PmsItarmMapping(); pmsItarmMapping.PmsId = strPmsID; pmsItarmMapping.CrId = strCrId; pmsItarmMapping.Creator = LoginName; pmsItarmMapping.CreateDate = dtCurDate; #endregion #region File(注释不用) #region Get Document Type //PmsDocumentType pmsDocType = new PmsDocumentType(); //pmsDocType.Vid = "PM"; //pmsDocType.TypeName = "PES"; //PmsDocumentTypeBiz pmsDocTypeBiz = new PmsDocumentTypeBiz(); //IList<PmsDocumentType> pmsDocTypeList = pmsDocTypeBiz.SelectPmsDocumentType(pmsDocType); //if (pmsDocTypeList != null && pmsDocTypeList.Count > 0) //{ // iTypeID = pmsDocTypeList[0].TypeId; //} #endregion #region Get UploadFilePath //PmsSys pmsSys = new PmsSys(); //pmsSys.Vid = "PM"; //pmsSys.Type = "UploadFilePath"; //PmsSysBiz pmsSysBiz = new PmsSysBiz(); //IList<PmsSys> pmsSysList = pmsSysBiz.SelectData1ByType(pmsSys); //if (pmsSysList != null && pmsSysList.Count > 0) //{ // strSavePath = pmsSysList[0].Data1.ToString().Trim(); //} //else //{ // ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('Please maintain UploadFilePath!');", true); // return; //} #endregion #region For Insert PmsDocuments //PmsDocuments pmsDocuments = new PmsDocuments(); //pmsDocuments.PmsId = strPmsID; //pmsDocuments.DocTypeId = iTypeID; //pmsDocuments.FileName = pesUpload.PostedFile.FileName.Substring(pesUpload.PostedFile.FileName.LastIndexOf("\\") + 1); //string strTmp = strSavePath + "\\" + strPmsID + "\\" + pmsDocuments.FileName; //if (strTmp.Length > 150) //{ // ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('The length of SavePath is larger than 150!');", true); // pesUpload.Focus(); // return; //} //pmsDocuments.Path = strSavePath + "\\" + strPmsID + "\\" + pmsDocuments.FileName; //pmsDocuments.Size = pesUpload.PostedFile.ContentLength.ToString().Trim(); //pmsDocuments.Creator = LoginName; //pmsDocuments.CreateDate = dtCurDate; //#endregion //#region Upload PES File //if (pmsDocuments.FileName != "") //{ // strSavePath = strSavePath + "\\" + strPmsID; // if (!QFile.CheckFolderExist(strSavePath)) // { // QFile.CreateDirectory(strSavePath); // } // strSavePath = strSavePath + "\\" + pmsDocuments.FileName; // pesUpload.PostedFile.SaveAs(strSavePath); //} #endregion #endregion #region For Insert SdpDetail SdpDetail sdpDetail = new SdpDetail(); sdpDetail.Pmsid = strPmsID; sdpDetail.Type = dropdownlistType.SelectedValue.Trim(); #endregion #region For Insert PmsFlow //pmsFlowTemplateList = pmsFlowTemplateBiz.SelectPmsFlowTemplateByTypeId(dropdownlistType.SelectedValue.Trim()); PmsFlow pmsFlow = new PmsFlow(); pmsFlow.FlowId = pmsFlowTemplateList[0].FlowId; pmsFlow.PmsId = strPmsID; pmsFlow.Creator = LoginName; pmsFlow.CreateDate = dtCurDate; #endregion #region For Insert PMSChangeHistory PmsChangeHistory pmsChangeHistory = new PmsChangeHistory(); pmsChangeHistory.PmsId = strPmsID; pmsChangeHistory.ChangeContent = ""; pmsChangeHistory.Action = "CREATE"; pmsChangeHistory.CreateDate = dtCurDate; pmsChangeHistory.Creator = LoginName; #endregion #region For Insert Itarm_Cr_List ItarmCrList itarmCrList = new ItarmCrList(); itarmCrList.CrId = strCrId; itarmCrList.CrName = textboxPmsName.Text.Trim().Replace("'", ""); itarmCrList.Site = dropdownlistSite.SelectedValue; itarmCrList.Creator = LoginName; itarmCrList.CreateDate = dtCurDate; itarmCrList.Pm = textboxPM.Text.Trim().Replace("'", ""); itarmCrList.System = textboxSystem.Text.Trim().Replace("'", ""); #endregion #region Insert PmsHeadBiz pmsInsert = new PmsHeadBiz(); string errorInfo; int insertResult = pmsInsert.InsertPmsHeadAndDoc(pmsHeadInsert, sdpDetail, pmsChangeHistory, pmsItarmMapping, pmsFlow, itarmCrList, null, out errorInfo); if (insertResult == 0) { Msgbox("Save Fail!"); } else { #region 更新系统版本表 bool upVerResult = m_PmsCRCreatBiz.UpdateSysVersion(dropdownlistDomain.SelectedValue, textboxSystem.Text.Trim(), dropdownlistSite.SelectedValue, textboxNewVersion.Text.Trim()); if (!upVerResult) { Msgbox("Updated system version number fail!"); } #endregion // Session["InquiryPage_Refresh"] = "Y"; //发送创建成功的Mail LoginName.Replace(".", " "); pmsHeadInsert.UserName = LoginName; new MailBiz().SendCreateMail(pmsHeadInsert); Msgbox("Create Successful!"); PageRegisterStartupScript("window.close();"); } #endregion } catch (Exception exception) { Msgbox("Save Fail!"); } }
protected void ButtonSave_Click(object sender, EventArgs e) { try { //get creator,createDate,pmsID,crID string creator = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", "."); DateTime createDate; string pmsID = string.Empty; string crId = string.Empty; m_PmsCRCreatBiz.GetNewPmsIdTempCrId(out createDate, out pmsID, out crId); //get pmsHead,pmsflow,sdpDetail,getPmsChangeHistory,getPmsItarmMapping,getPmsFlow,itarmCrList PmsHead pmsHead = getPmsHead(creator, createDate, pmsID); SdpDetail sdpDetail = getSdpDetail(pmsID); PmsChangeHistory pmsChangeHistory = getPmsChangeHistory(creator, createDate, pmsID); PmsItarmMapping pmsItarmMapping = getPmsItarmMapping(creator, createDate, pmsID, crId); PmsFlow pmsFlow = getPmsFlow(creator, createDate, pmsID); ItarmCrList itarmCrList = getItarmCrList(creator, createDate, crId); IList <PmsDocuments> pmsDocuments = getPmsDocuments(creator, createDate, pmsID, crId); if (pmsHead == null) { Msgbox("Save failed"); return; } //Insert PmsHeadBiz pmsInsert = new PmsHeadBiz(); string errorInfo; int insertResult = pmsInsert.InsertPmsHeadAndDoc(pmsHead, sdpDetail, pmsChangeHistory, pmsItarmMapping, pmsFlow, itarmCrList, pmsDocuments, out errorInfo); if (insertResult == 0) { Msgbox(errorInfo); } else { //将TempFile文件夹里的文件移动到UploadFile下以CRNO命名的文件夹里并删除Temp里的文件。 MoveUploadFileDeleteTempFile(crId); LoginName.Replace(".", " "); pmsHead.UserName = LoginName; new MailBiz().SendCreateMail(pmsHead); // 更新Stage 自动把这个Cr推进到AssginMember int oldStage = (int)PmsCommonEnum.ProjectStage.PES; int newStage = (int)PmsCommonEnum.ProjectStage.AssignMember; string strAction = Enum.Parse(typeof(PmsCommonEnum.ProjectStage), oldStage.ToString()).GetDescription(); bool blResult = new BasicInformationDetailBiz().UpdateStages(pmsID, LoginName, oldStage, newStage, strAction); if (!blResult) { Msgbox("更新stage数据失败!"); return; } new MailBiz().SendPromoteMail(pmsHead, newStage); Msgbox("Create Successful!"); PageRegisterStartupScript("window.close();"); } } catch (Exception exception) { throw new Exception(exception.ToString()); } }
public bool UpdateSdpDetailAuditStatus(string serials, int auditStatus, string auditComment) { bool result = false; string[] serialArray = serials.Split(';'); string serialAll = serialArray.Aggregate(string.Empty, (current, next) => current + "'" + next + "',").TrimEnd(','); SdpDetail sdpDetail = new SdpDetail(); PmsSdpAudit pmsSdpAudit = new PmsSdpAudit(); sdpDetail.Serials = serialAll; sdpDetail.AuditStatus = auditStatus; if (new SdpDetailBiz().UpdateSdpDetailAuditStatus(sdpDetail)) { //同意或拒绝会新增版本 if ((auditStatus == (int)PmsCommonEnum.AuditStatus.HasApproved) || auditStatus == (int)PmsCommonEnum.AuditStatus.BeenRejected) { PmsSdpVersion pmsSdpVersion = new PmsSdpVersion(); foreach (var serial in serialArray) { IList <PmsSdpVersion> PmsSdpVersionList = new PmsSdpVersionBiz().SelectPmsSdpVersionByTaskno(serial); IList <SdpDetail> listSdpDetail = new SdpDetailBiz().SelectSdpDetail(new SdpDetail { Serial = int.Parse(serial) }); if (listSdpDetail == null || listSdpDetail.Count == 0) { return(result); } sdpDetail = listSdpDetail.FirstOrDefault(); pmsSdpVersion.Taskno = int.Parse(serial); pmsSdpVersion.Pmsid = sdpDetail.Pmsid; pmsSdpVersion.PlanStartDay = sdpDetail.Planstartday; pmsSdpVersion.PlanEndDay = sdpDetail.Planendday; pmsSdpVersion.PlanCost = (float)sdpDetail.Plancost; pmsSdpVersion.RefCost = (float)sdpDetail.Refcost; pmsSdpVersion.Creator = LoginName; pmsSdpVersion.CreateDate = DateTime.Now; pmsSdpVersion.Version = (PmsSdpVersionList == null || PmsSdpVersionList.Count == 0) ? 1.0f : PmsSdpVersionList.Max(t => t.Version) + 0.1f; new PmsSdpVersionBiz().InsertPmsSdpVersion(pmsSdpVersion); } IList <PmsSdpAudit> pmsSdpAuditList = new PmsSdpAuditBiz().SelectPmsSdpAuditByPmsId(sdpDetail.Pmsid); pmsSdpAudit.Pmsid = sdpDetail.Pmsid; pmsSdpAudit.SdpVersion = (pmsSdpAuditList == null || pmsSdpAuditList.Count == 0) ? 1.0f : pmsSdpAuditList.Max(t => t.SdpVersion) + 0.1f; pmsSdpAudit.Auditor = LoginName; if (auditComment == "") { pmsSdpAudit.AuditResult = "Approve"; } else { pmsSdpAudit.AuditResult = "Reject"; } pmsSdpAudit.AuditComment = auditComment; pmsSdpAudit.CreateDate = DateTime.Now; pmsSdpAudit.Creator = LoginName; new PmsSdpAuditBiz().InsertPmsSdpAudit(pmsSdpAudit); } //发mail通知相关人员(提交人或者审核人) result = new MailBiz().TaskMail(serialArray[0], auditStatus); } return(result); }