| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 通过 PumpMainID 获取 |
| | | /// 通过 MainID 获取 |
| | | /// </summary> |
| | | public List<Entity.XhsPumpMainPhartMapping> GetByPumpMainID(long PumpMainID) |
| | | { |
| | | using (var db = new SqlSugarClient(ConnectionConfig)) |
| | | { |
| | | return db.Queryable<Entity.XhsPumpMainPhartMapping>() |
| | | .Where(x => x.PumpMainID == PumpMainID) |
| | | .Where(x => x.MainID == PumpMainID) |
| | | .OrderBy(x => x.SortCode).ToList(); |
| | | } |
| | | } |
| | |
| | | using (var db = new SqlSugarClient(ConnectionConfig)) |
| | | { |
| | | return db.Queryable<Entity.XhsPumpMainPhartMapping>() |
| | | .Where(x => PumpMainIds.Contains(x.PumpMainID)) |
| | | .Where(x => PumpMainIds.Contains(x.MainID)) |
| | | .OrderBy(x => x.SortCode).ToList(); |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 通过 PumpMainID 删除 |
| | | /// 通过 MainID 删除 |
| | | /// </summary> |
| | | public bool DeleteByPumpMainID(long PumpMainID) |
| | | { |
| | | using (var db = new SqlSugarClient(ConnectionConfig)) |
| | | { |
| | | return db.Deleteable<Entity.XhsPumpMainPhartMapping>() |
| | | .Where(x => x.PumpMainID == PumpMainID) |
| | | .Where(x => x.MainID == PumpMainID) |
| | | .ExecuteCommandHasChange(); |
| | | } |
| | | } |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |