| | |
| | | { |
| | | var idlist = db.Queryable<Entity.ValveGroupAndMainMap>() |
| | | .Where(x => x.ValveGroupID == group.ID) |
| | | .Select(x => x.ValveMainID) // 假设 ValveGroupID 是与 ValveMain 关联的外键 |
| | | .Select(x => x.AssetsValveMainID) // 假设 ValveGroupID 是与 AssetsValveMain 关联的外键 |
| | | .ToList(); |
| | | var main = db.Queryable<Entity.ValveGroupAndMainMap>() |
| | | .Where(x => x.ValveGroupID == group.ID) |
| | |
| | | } |
| | | else |
| | | { |
| | | var Map = db.Queryable<Entity.ValveMain>().ToList(); |
| | | var Mapresult = db.Deleteable<Entity.ValveMain>() |
| | | var Map = db.Queryable<Entity.AssetsValveMain>().ToList(); |
| | | var Mapresult = db.Deleteable<Entity.AssetsValveMain>() |
| | | .In(x => x.ID, idlist) |
| | | .ExecuteCommand() > 0; |
| | | if (!Mapresult) |