using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace BLL { /// /// 尾项 /// public class PunchService { /// /// 根据主键获取尾项信息 /// /// /// public static Model.Editor_Punch GetPunchById(string punchId) { return Funs.DB.Editor_Punch.FirstOrDefault(e => e.PunchId == punchId); } /// /// 添加尾项 /// /// public static void AddPunch(Model.Editor_Punch punch) { Model.Editor_Punch newPunch = new Model.Editor_Punch(); newPunch.PunchId = punch.PunchId; newPunch.EProjectId = punch.EProjectId; newPunch.DisciplineId = punch.DisciplineId; newPunch.DisciplineName = punch.DisciplineName; newPunch.ClassId = punch.ClassId; newPunch.ClassName = punch.ClassName; newPunch.TagNo = punch.TagNo; newPunch.RespUnitPerson = punch.RespUnitPerson; newPunch.ResiedById = punch.ResiedById; newPunch.ResiedByName = punch.ResiedByName; newPunch.PlanedFinishDate = punch.PlanedFinishDate; newPunch.CTECheckerId = punch.CTECheckerId; newPunch.CTECheckerName = punch.CTECheckerName; newPunch.CTECheckDate = punch.CTECheckDate; newPunch.OwnerCheckerId = punch.OwnerCheckerId; newPunch.OwnerCheckerName = punch.OwnerCheckerName; newPunch.OwnerCheckDate = punch.OwnerCheckDate; newPunch.Description = punch.Description; newPunch.Remark = punch.Remark; newPunch.Area = punch.Area; newPunch.ActionType = punch.ActionType; newPunch.InitiatedByDate = punch.InitiatedByDate; newPunch.InitiatedByName = punch.InitiatedByName; newPunch.BYC_Person = punch.BYC_Person; Funs.DB.Editor_Punch.InsertOnSubmit(newPunch); Funs.DB.SubmitChanges(); } /// /// 修改 /// /// public static void UpdatePunch(Model.Editor_Punch punch) { Model.Editor_Punch newPunch = Funs.DB.Editor_Punch.FirstOrDefault(e => e.PunchId == punch.PunchId); if (newPunch != null) { newPunch.DisciplineId = punch.DisciplineId; newPunch.DisciplineName = punch.DisciplineName; newPunch.ClassId = punch.ClassId; newPunch.ClassName = punch.ClassName; newPunch.TagNo = punch.TagNo; newPunch.RespUnitPerson = punch.RespUnitPerson; newPunch.ResiedById = punch.ResiedById; newPunch.ResiedByName = punch.ResiedByName; newPunch.PlanedFinishDate = punch.PlanedFinishDate; newPunch.CTECheckerId = punch.CTECheckerId; newPunch.CTECheckerName = punch.CTECheckerName; newPunch.CTECheckDate = punch.CTECheckDate; newPunch.OwnerCheckerId = punch.OwnerCheckerId; newPunch.OwnerCheckerName = punch.OwnerCheckerName; newPunch.OwnerCheckDate = punch.OwnerCheckDate; newPunch.Description = punch.Description; newPunch.Remark = punch.Remark; newPunch.Area = punch.Area; newPunch.ActionType = punch.ActionType; newPunch.InitiatedByDate = punch.InitiatedByDate; newPunch.InitiatedByName = punch.InitiatedByName; newPunch.BYC_Person = punch.BYC_Person; Funs.DB.SubmitChanges(); } } /// /// 根据主键删除尾项 /// /// public static void DeletePunshById(string punshId) { Model.Editor_Punch punch = Funs.DB.Editor_Punch.FirstOrDefault(e => e.PunchId == punshId); if (punch != null) { Funs.DB.Editor_Punch.DeleteOnSubmit(punch); Funs.DB.SubmitChanges(); } } } }