/// <summary> /// 添加断路(占道)作业票 /// </summary> /// <param name="openCircuit"></param> public static void AddOpenCircuit(Model.License_OpenCircuit openCircuit) { Model.SUBHSSEDB db = Funs.DB; Model.License_OpenCircuit newOpenCircuit = new Model.License_OpenCircuit { OpenCircuitId = openCircuit.OpenCircuitId, ProjectId = openCircuit.ProjectId, LicenseCode = openCircuit.LicenseCode, ApplyUnitId = openCircuit.ApplyUnitId, ApplyManId = openCircuit.ApplyManId, ApplyDate = openCircuit.ApplyDate, WorkPalce = openCircuit.WorkPalce, WorkMeasures = openCircuit.WorkMeasures, ValidityStartTime = openCircuit.ValidityStartTime, ValidityEndTime = openCircuit.ValidityEndTime, RoadName = openCircuit.RoadName, SafeMeasures = openCircuit.SafeMeasures, CancelManId = openCircuit.CancelManId, CancelReasons = openCircuit.CancelReasons, CancelTime = openCircuit.CancelTime, CloseManId = openCircuit.CloseManId, CloseReasons = openCircuit.CloseReasons, CloseTime = openCircuit.CloseTime, NextManId = openCircuit.NextManId, States = openCircuit.States, }; db.License_OpenCircuit.InsertOnSubmit(newOpenCircuit); db.SubmitChanges(); ////增加一条编码记录 CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectOpenCircuitMenuId, openCircuit.ProjectId, openCircuit.ApplyUnitId, openCircuit.OpenCircuitId, openCircuit.ApplyDate); }
/// <summary> /// 根据主键删除断路(占道)作业票 /// </summary> /// <param name="openCircuitId"></param> public static void DeleteOpenCircuitById(string openCircuitId) { Model.SUBHSSEDB db = Funs.DB; Model.License_OpenCircuit openCircuit = db.License_OpenCircuit.FirstOrDefault(e => e.OpenCircuitId == openCircuitId); if (openCircuit != null) { ///删除编码表记录 CodeRecordsService.DeleteCodeRecordsByDataId(openCircuitId); ///删除-安全措施 DeleteLicenseItemByDataId(openCircuitId); ///删除作业票审核信息 DeleteFlowOperateByDataId(openCircuitId); db.License_OpenCircuit.DeleteOnSubmit(openCircuit); db.SubmitChanges(); } }
/// <summary> /// 修改断路(占道)作业票 /// </summary> /// <param name="openCircuit"></param> public static void UpdateOpenCircuit(Model.License_OpenCircuit openCircuit) { Model.SUBHSSEDB db = Funs.DB; Model.License_OpenCircuit newOpenCircuit = db.License_OpenCircuit.FirstOrDefault(e => e.OpenCircuitId == openCircuit.OpenCircuitId); if (newOpenCircuit != null) { newOpenCircuit.WorkPalce = openCircuit.WorkPalce; newOpenCircuit.WorkMeasures = openCircuit.WorkMeasures; newOpenCircuit.ValidityStartTime = openCircuit.ValidityStartTime; newOpenCircuit.ValidityEndTime = openCircuit.ValidityEndTime; newOpenCircuit.RoadName = openCircuit.RoadName; newOpenCircuit.SafeMeasures = openCircuit.SafeMeasures; newOpenCircuit.CancelManId = openCircuit.CancelManId; newOpenCircuit.CancelReasons = openCircuit.CancelReasons; newOpenCircuit.CancelTime = openCircuit.CancelTime; newOpenCircuit.CloseManId = openCircuit.CloseManId; newOpenCircuit.CloseReasons = openCircuit.CloseReasons; newOpenCircuit.CloseTime = openCircuit.CloseTime; newOpenCircuit.NextManId = openCircuit.NextManId; newOpenCircuit.States = openCircuit.States; db.SubmitChanges(); } }