| | |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | public partial class PumpSeries : BaseDAL_Paras_Flags_TagName_Sorter_UseStatus<Entity.PumpSeries>, IPumpSeries |
| | | public partial class AssetsPumpSeries : BaseDAL_Paras_Flags_TagName_Sorter_UseStatus<Entity.AssetsPumpSeries>, IAssetsPumpSeries |
| | | { |
| | | /// <summary> |
| | | /// |
| | |
| | | try |
| | | { |
| | | db.BeginTran(); |
| | | var project = db.Queryable<Entity.PumpSeries>().ToList().Find(x => x.ID == ID); |
| | | var project = db.Queryable<Entity.AssetsPumpSeries>().ToList().Find(x => x.ID == ID); |
| | | var result = db.Deleteable(project).ExecuteCommand() > 0; |
| | | if (!result) |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | var group = db.Queryable<Entity.PumpGroup>().ToList().Find(x => x.PumpSeriesID == project.ID); |
| | | var group = db.Queryable<Entity.AssetsPumpGroup>().ToList().Find(x => x.PumpSeriesID == project.ID); |
| | | if (group != null) |
| | | { |
| | | var groupresult = db.Deleteable(group).ExecuteCommand() > 0; |
| | |
| | | } |
| | | else |
| | | { |
| | | var map = db.Queryable<Entity.PumpGroupAndMainMap>() |
| | | var map = db.Queryable<Entity.AssetsPumpGroupAndMainMap>() |
| | | .Where(x => x.PumpGroupID == group.ID) |
| | | .ToList(); |
| | | var listid = db.Queryable<Entity.PumpGroupAndMainMap>() |
| | | var listid = db.Queryable<Entity.AssetsPumpGroupAndMainMap>() |
| | | .Where(x => x.PumpGroupID == group.ID) |
| | | .Select(x => x.PumpMainID) |
| | | .ToList(); |
| | |
| | | } |
| | | else |
| | | { |
| | | var main = db.Queryable<Entity.PumpMain>().ToList(); |
| | | var main = db.Queryable<Entity.AssetsPumpMain>().ToList(); |
| | | foreach (var item in main) |
| | | { |
| | | if (item.PumpSeriesID == project.ID) |
| | |
| | | listid.Add(item.ID); |
| | | } |
| | | } |
| | | var mainresult = db.Deleteable<Entity.PumpMain>() |
| | | var mainresult = db.Deleteable<Entity.AssetsPumpMain>() |
| | | .In(x => x.ID, listid) |
| | | .ExecuteCommand() > 0; |
| | | if (!mainresult) |
| | |
| | | else |
| | | { |
| | | var listid = new List<long>(); |
| | | var main = db.Queryable<Entity.PumpMain>().ToList(); |
| | | var main = db.Queryable<Entity.AssetsPumpMain>().ToList(); |
| | | foreach (var item in main) |
| | | { |
| | | if (item.PumpSeriesID == project.ID) |
| | |
| | | } |
| | | if (listid.Count > 0) |
| | | { |
| | | var mainresult = db.Deleteable<Entity.PumpMain>() |
| | | var mainresult = db.Deleteable<Entity.AssetsPumpMain>() |
| | | .In(x => x.ID, listid) |
| | | .ExecuteCommand() > 0; |
| | | if (!mainresult) |