/// <summary> /// 添加受限空间作业票 /// </summary> /// <param name="limitedSpace"></param> public static void AddLimitedSpace(Model.License_LimitedSpace limitedSpace) { Model.SUBHSSEDB db = Funs.DB; Model.License_LimitedSpace newLimitedSpace = new Model.License_LimitedSpace { LimitedSpaceId = limitedSpace.LimitedSpaceId, ProjectId = limitedSpace.ProjectId, LicenseCode = limitedSpace.LicenseCode, ApplyUnitId = limitedSpace.ApplyUnitId, ApplyManId = limitedSpace.ApplyManId, ApplyDate = limitedSpace.ApplyDate, WorkPalce = limitedSpace.WorkPalce, FireWatchManId = limitedSpace.FireWatchManId, FireWatchManName = limitedSpace.FireWatchManName, ValidityStartTime = limitedSpace.ValidityStartTime, ValidityEndTime = limitedSpace.ValidityEndTime, WorkMeasures = limitedSpace.WorkMeasures, CancelManId = limitedSpace.CancelManId, CancelReasons = limitedSpace.CancelReasons, CancelTime = limitedSpace.CancelTime, CloseManId = limitedSpace.CloseManId, CloseReasons = limitedSpace.CloseReasons, CloseTime = limitedSpace.CloseTime, NextManId = limitedSpace.NextManId, States = limitedSpace.States, }; db.License_LimitedSpace.InsertOnSubmit(newLimitedSpace); db.SubmitChanges(); ////增加一条编码记录 CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectLimitedSpaceMenuId, limitedSpace.ProjectId, limitedSpace.ApplyUnitId, limitedSpace.LimitedSpaceId, limitedSpace.ApplyDate); }
/// <summary> /// 根据主键删除受限空间作业票 /// </summary> /// <param name="limitedSpaceId"></param> public static void DeleteLimitedSpaceById(string limitedSpaceId) { Model.SUBHSSEDB db = Funs.DB; Model.License_LimitedSpace limitedSpace = db.License_LimitedSpace.FirstOrDefault(e => e.LimitedSpaceId == limitedSpaceId); if (limitedSpace != null) { ///删除编码表记录 CodeRecordsService.DeleteCodeRecordsByDataId(limitedSpaceId); ///删除-安全措施 DeleteLicenseItemByDataId(limitedSpaceId); ///删除作业票审核信息 DeleteFlowOperateByDataId(limitedSpaceId); db.License_LimitedSpace.DeleteOnSubmit(limitedSpace); db.SubmitChanges(); } }
/// <summary> /// 修改受限空间作业票 /// </summary> /// <param name="limitedSpace"></param> public static void UpdateLimitedSpace(Model.License_LimitedSpace limitedSpace) { Model.SUBHSSEDB db = Funs.DB; Model.License_LimitedSpace newLimitedSpace = db.License_LimitedSpace.FirstOrDefault(e => e.LimitedSpaceId == limitedSpace.LimitedSpaceId); if (newLimitedSpace != null) { newLimitedSpace.WorkPalce = limitedSpace.WorkPalce; newLimitedSpace.FireWatchManId = limitedSpace.FireWatchManId; newLimitedSpace.ValidityStartTime = limitedSpace.ValidityStartTime; newLimitedSpace.ValidityEndTime = limitedSpace.ValidityEndTime; newLimitedSpace.WorkMeasures = limitedSpace.WorkMeasures; newLimitedSpace.CancelManId = limitedSpace.CancelManId; newLimitedSpace.CancelReasons = limitedSpace.CancelReasons; newLimitedSpace.CancelTime = limitedSpace.CancelTime; newLimitedSpace.CloseManId = limitedSpace.CloseManId; newLimitedSpace.CloseReasons = limitedSpace.CloseReasons; newLimitedSpace.CloseTime = limitedSpace.CloseTime; newLimitedSpace.NextManId = limitedSpace.NextManId; newLimitedSpace.States = limitedSpace.States; db.SubmitChanges(); } }