| | |
| | | { |
| | | return PumpCurveMappingCacheHelper.GetSet(projectId, () => |
| | | { |
| | | var entities = _dal.QueryAll(projectId); |
| | | var entities = _dal.GetAll(projectId); |
| | | var models = Entity2Models(entities); |
| | | if (models == null) |
| | | { |
| | |
| | | //根据 Id 更新缓存 |
| | | private void UpdateProjectCache(long projectId, long Id) |
| | | { |
| | | var entity_ds = _dal.QueryById(projectId, Id); |
| | | var entity_ds = _dal.GetById(projectId, Id); |
| | | var model_ds = Entity2Model(entity_ds); |
| | | var all = GetProjectCache(projectId); |
| | | var model = all.Find(x => x.Id == Id); |
| | |
| | | //根据 Id 更新缓存并返回 |
| | | public Model.PumpCurveMapping UpdateProjectCacheR(long projectId, long Id) |
| | | { |
| | | var entity_ds = _dal.QueryById(projectId, Id); |
| | | var entity_ds = _dal.GetById(projectId, Id); |
| | | var model_ds = Entity2Model(entity_ds); |
| | | var all = GetProjectCache(projectId); |
| | | var model = all.Find(x => x.Id == Id); |
| | |
| | | { |
| | | if (Ids == null || Ids.Count() < 1) |
| | | return; |
| | | var entities = _dal.QueryByIds(projectId, Ids); |
| | | var entities = _dal.GetByIds(projectId, Ids); |
| | | var models = Entity2Models(entities); |
| | | var all = GetProjectCache(projectId); |
| | | all.RemoveAll(x => Ids.Contains(x.Id)); |
| | |
| | | { |
| | | if (Ids == null && Ids.Count() < 1) |
| | | return default; |
| | | var entity_list = _dal.QueryByIds(projectId, Ids); |
| | | var entity_list = _dal.GetByIds(projectId, Ids); |
| | | var model_list = Entity2Models(entity_list); |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | all.RemoveAll(x => Ids.Contains(x.Id)); |
| | | if (model_list != null && model_list.Count > 0) |
| | | { |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region Query |
| | | #region Get |
| | | |
| | | /// <summary> |
| | | /// 查询全部 |
| | | /// </summary> |
| | | public List<Model.PumpCurveMapping> QueryAll(long projectId) |
| | | public List<Model.PumpCurveMapping> GetAll(long projectId) |
| | | { |
| | | var all = GetProjectCache(projectId); |
| | | return all.OrderBy(x => x.SortCode).ToList(); |
| | |
| | | /// <summary> |
| | | /// 根据 Id查询 |
| | | /// </summary> |
| | | public Model.PumpCurveMapping QueryById(long projectId, long Id) |
| | | public Model.PumpCurveMapping GetById(long projectId, long Id) |
| | | { |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Find(x => x.Id == Id); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据 Ids 查询 |
| | | /// </summary> |
| | | public List<Model.PumpCurveMapping> QueryByIds(long projectId, IEnumerable<long> Ids) |
| | | public List<Model.PumpCurveMapping> GetByIds(long projectId, IEnumerable<long> Ids) |
| | | { |
| | | if (Ids == null || Ids.Count() < 1) |
| | | return default; |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Where(x => Ids.Contains(x.Id)).ToList(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据 PumpId 查询 |
| | | /// </summary> |
| | | public List<Model.PumpCurveMapping> QueryByPumpId(long projectId, long pumpId) |
| | | public List<Model.PumpCurveMapping> GetByPumpId(long projectId, long pumpId) |
| | | { |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Where(x => x.PumpId == pumpId).OrderBy(x => x.SortCode).ToList(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据 PumpIds 查询 |
| | | /// </summary> |
| | | public List<Model.PumpCurveMapping> QueryByPumpIds(long projectId, List<long> pumpIds) |
| | | public List<Model.PumpCurveMapping> GetByPumpIds(long projectId, List<long> pumpIds) |
| | | { |
| | | if (pumpIds == null || pumpIds.Count() < 1) |
| | | return default; |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all?.Where(x => pumpIds.Contains(x.PumpId)).OrderBy(x => x.SortCode).ToList(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据 CurveId 查询 |
| | | /// </summary> |
| | | public List<Model.PumpCurveMapping> QueryByCurveId(long projectId, long curveId) |
| | | public List<Model.PumpCurveMapping> GetByCurveId(long projectId, long curveId) |
| | | { |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all?.Where(x => x.CurveId == curveId).OrderBy(x => x.SortCode).ToList(); |
| | | } |
| | | |
| | |
| | | /// <summary> |
| | | /// 根据 CurveIds 查询 |
| | | /// </summary> |
| | | public List<Model.PumpCurveMapping> QueryByCurveIds(long projectId, List<long> CurveIds) |
| | | public List<Model.PumpCurveMapping> GetByCurveIds(long projectId, List<long> CurveIds) |
| | | { |
| | | if (CurveIds == null || CurveIds.Count() < 1) |
| | | return default; |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Where(x => CurveIds.Contains(x.CurveId)).OrderBy(x => x.SortCode).ToList(); |
| | | } |
| | | |
| | |
| | | /// </summary> |
| | | public bool IsExistById(long projectId, long Id) |
| | | { |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Exists(x => x.Id == Id); |
| | | } |
| | | |
| | |
| | | /// </summary> |
| | | public bool IsExistByPumpId(long projectId, long pumpId) |
| | | { |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Exists(x => x.PumpId == pumpId); |
| | | } |
| | | |
| | |
| | | /// </summary> |
| | | public bool IsExistByCurveId(long projectId, long curveId) |
| | | { |
| | | var all = QueryAll(projectId); |
| | | var all = GetAll(projectId); |
| | | return all.Exists(x => x.CurveId == curveId); |
| | | } |
| | | #endregion |
| | |
| | | public bool DeleteByCurveId(long projectId, long curveId, out string msg) |
| | | { |
| | | msg = string.Empty; |
| | | var all = QueryByCurveId(projectId, curveId); |
| | | var all = GetByCurveId(projectId, curveId); |
| | | if (all != null && all.Count > 0) |
| | | { |
| | | var ids = all.Select(x => x.Id); |