using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace BLL { /// /// 审批意见 /// public class PunishmentAuditService { /// /// 添加 /// /// public static void AddPunishmentAudit(Model.EMC_PunishmentAudit audit) { Model.EMC_PunishmentAudit newAudit = new Model.EMC_PunishmentAudit { AuditId = audit.AuditId, PunishmentId = audit.PunishmentId, AuditMan = audit.AuditMan, AuditDate = audit.AuditDate, IsPass = audit.IsPass, AuditResult = audit.AuditResult }; Funs.DB.EMC_PunishmentAudit.InsertOnSubmit(newAudit); Funs.DB.SubmitChanges(); } /// /// 修改 /// /// public static void UpdatePunishmentAudit(Model.EMC_PunishmentAudit audit) { Model.EMC_PunishmentAudit newAudit = Funs.DB.EMC_PunishmentAudit.FirstOrDefault(e => e.AuditId == audit.AuditId); if (newAudit != null) { newAudit.AuditMan = audit.AuditMan; newAudit.AuditDate = audit.AuditDate; newAudit.IsPass = audit.IsPass; newAudit.AuditResult = audit.AuditResult; Funs.DB.SubmitChanges(); } } /// /// 删除 /// /// public static void DeletePunishmentAuditByPunishmentId(string punishmentId) { var q = (from x in Funs.DB.EMC_PunishmentAudit where x.PunishmentId == punishmentId select x).ToList(); if (q != null) { Funs.DB.EMC_PunishmentAudit.DeleteAllOnSubmit(q); Funs.DB.SubmitChanges(); } } public static Model.EMC_PunishmentAudit GetAuditBypunishmentIdAndAuditMan(string punishmentId, string auditMan) { return Funs.DB.EMC_PunishmentAudit.FirstOrDefault(e => e.PunishmentId == punishmentId && e.AuditMan == auditMan); } public static Model.EMC_PunishmentAudit GetAuditByAuditMan(string punishmentId, string auditMan) { return Funs.DB.EMC_PunishmentAudit.FirstOrDefault(e => e.PunishmentId == punishmentId && e.AuditMan == auditMan && e.AuditDate == null); } } }