public bool InsertPmsSdpAudit(PmsSdpAudit pmsSdpAudit) { try { m_PMSSqlConnection.Insert("InsertPmsSdpAudit", pmsSdpAudit); return(true); } catch (Exception ex) { m_Logger.Error("PmsSdpAuditBiz/InsertPmsSdpAudit:" + ex.ToString()); return(false); } }
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); }