| | |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | public partial class PumpGroup : BaseDAL_Paras_Flags_TagName_Sorter<Entity.PumpGroup>, IPumpGroup |
| | | public partial class AssetsPumpGroup : BaseDAL_Paras_Flags_TagName_Sorter<Entity.AssetsPumpGroup>, IAssetsPumpGroup |
| | | { |
| | | /// <summary> |
| | | /// |
| | |
| | | try |
| | | { |
| | | db.BeginTran(); |
| | | var group = db.Queryable<Entity.PumpGroup>().ToList().Find(x => x.ID == ID); |
| | | var group = db.Queryable<Entity.AssetsPumpGroup>().ToList().Find(x => x.ID == ID); |
| | | var groupresult = db.Deleteable(group).ExecuteCommand() > 0; |
| | | if (!groupresult) |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | var idlist = db.Queryable<Entity.PumpGroupAndMainMap>() |
| | | var idlist = db.Queryable<Entity.AssetsPumpGroupAndMainMap>() |
| | | .Where(x => x.PumpGroupID == group.ID) |
| | | .Select(x => x.PumpMainID) // 假设 PumpGroupID 是与 PumpMain 关联的外键 |
| | | .Select(x => x.PumpMainID) // 假设 PumpGroupID 是与 AssetsPumpMain 关联的外键 |
| | | .ToList(); |
| | | var main = db.Queryable<Entity.PumpGroupAndMainMap>() |
| | | var main = db.Queryable<Entity.AssetsPumpGroupAndMainMap>() |
| | | .Where(x => x.PumpGroupID == group.ID) |
| | | .ToList(); |
| | | if (main.Count > 0) |
| | |
| | | } |
| | | else |
| | | { |
| | | var Map = db.Queryable<Entity.PumpMain>().ToList(); |
| | | var Mapresult = db.Deleteable<Entity.PumpMain>() |
| | | var Map = db.Queryable<Entity.AssetsPumpMain>().ToList(); |
| | | var Mapresult = db.Deleteable<Entity.AssetsPumpMain>() |
| | | .In(x => x.ID, idlist) |
| | | .ExecuteCommand() > 0; |
| | | if (!Mapresult) |