using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace IStation.Service { /// /// 结构绑定 /// public partial class PipeLineBinding { #region Cache //通过 CorpID 获取 private List GetCorpCache(long CorpID) { return PipeLineBindingCacheHelper.GetSet(CorpID, () => { var dal=new DAL.PipeLineBinding(); var entity_list = dal.GetByCorpID(CorpID); var model_list = Entity2Models(entity_list); if (model_list == null) { model_list = new List(); } return model_list; }, ConfigHelper.CacheKeepTime, ConfigHelper.CacheRandomTime); } //通过 ID 更新缓存 private void UpdateCorpCache(long CorpID, long ID) { var dal=new DAL.PipeLineBinding(); var entity_ds = dal.GetByID(CorpID, ID); var model_ds = Entity2Model(entity_ds); var all = GetCorpCache(CorpID); var model = all.Find(x => x.ID == ID); if (model == null) { all.Add(model_ds); } else { model.Reset(model_ds); } } //通过 Ids 更新缓存 private void UpdateCorpCache(long CorpID, List Ids) { if (Ids == null || Ids.Count() < 1) return; var dal=new DAL.PipeLineBinding(); var entity_list = dal.GetByIds(CorpID, Ids); var model_list = Entity2Models(entity_list); var all = GetCorpCache(CorpID); all.RemoveAll(x => Ids.Contains(x.ID)); if (model_list != null && model_list.Count > 0) { all.AddRange(model_list); } } #endregion #region Query /// /// 通过 CorpID 获取 /// public List GetByCorpID(long CorpID) { var all = GetCorpCache(CorpID); return all.OrderByDescending(x => x.BindingTime).ToList(); } /// /// 通过 ID 获取 /// public Model.PipeLineBinding GetByID(long CorpID, long ID) { var all = GetByCorpID(CorpID); return all.Find(x => x.ID == ID); } /// /// 通过 Ids 获取 /// public List GetByIds(long CorpID, List Ids) { if (Ids == null || Ids.Count() < 1) return default; var all = GetByCorpID(CorpID); return all.Where(x => Ids.Contains(x.ID)).OrderByDescending(x => x.BindingTime).ToList(); } /// /// 通过 PipeLineID 获取 /// public List GetByPipeLineID(long CorpID, long PipeLineID) { var all = GetByCorpID(CorpID); return all.Where(x => x.PipeLineID == PipeLineID).OrderByDescending(x => x.BindingTime).ToList(); } /// /// 通过 PipeLineIds 获取 /// public List GetByPipeLineIds(long CorpID, List PipeLineIds) { if (PipeLineIds == null || PipeLineIds.Count() < 1) return default; var all = GetByCorpID(CorpID); return all.Where(x => PipeLineIds.Contains(x.PipeLineID)).OrderByDescending(x => x.BindingTime).ToList(); } /// /// 通过 BindingType 和 BindingID 获取 /// public List GetByBindingTypeAndBindingID(long CorpID, string BindingType, long BindingID) { var all = GetByCorpID(CorpID); return all.Where(x => x.BindingType == BindingType && x.BindingID == BindingID).OrderByDescending(x => x.BindingTime).ToList(); } /// /// 通过 PipeLineID 获取在用 /// public List GetUseByPipeLineID(long CorpID, long PipeLineID) { var all = GetByCorpID(CorpID); return all.Where(x => x.PipeLineID==PipeLineID&&x.UnBindingTime==null).OrderByDescending(x => x.BindingTime).ToList(); } /// /// 通过 PipeLineIds 获取在用 /// public List GetUseByPipeLineIds(long CorpID, List PipeLineIds) { if (PipeLineIds == null || PipeLineIds.Count() < 1) return default; var all = GetByCorpID(CorpID); return all.Where(x =>x.UnBindingTime==null&& PipeLineIds.Contains(x.PipeLineID)).OrderByDescending(x => x.BindingTime).ToList(); } /// /// 根据 PipeLineID 判断是否存在 /// public bool IsExistByPipeLineID(long CorpID, long PipeLineID) { var all = GetByCorpID(CorpID); return all.Exists(x=>x.PipeLineID==PipeLineID); } #endregion #region Insert /// /// 插入一条数据 /// public long Insert(Model.PipeLineBinding model) { if (model == null) return default; if (model.CorpID < 1) return default; var dal=new DAL.PipeLineBinding(); var entity = Model2Entity(model); var id = dal.Insert(entity); if (id > 0) { UpdateCorpCache(model.CorpID, id); } return id; } /// /// 插入多条 /// public bool Inserts(List list) { if (list == null || list.Count() < 1) return default; var corpIds = list.Select(x => x.CorpID).Distinct().ToList(); if (corpIds.Count != 1 || corpIds[0] < 1) return default; var dal=new DAL.PipeLineBinding(); var entity_list = Model2Entities(list.ToList()); var ids = dal.InsertsR(entity_list); if (ids != null && ids.Count > 0) { UpdateCorpCache(corpIds[0], ids); return true; } return false; } #endregion #region Update /// /// 更新一条 /// public bool Update(Model.PipeLineBinding model) { if (model == null) return default; if (model.CorpID < 1) return default; if (model.ID < 1) return default; var dal=new DAL.PipeLineBinding(); var entity = Model2Entity(model); var bol = dal.Update(entity); if (bol) { UpdateCorpCache(model.CorpID, model.ID); } return bol; } /// /// 更新多条 /// public bool Updates(List list) { if (list == null || list.Count() < 1) return default; var corpIds = list.Select(x => x.CorpID).Distinct().ToList(); if (corpIds.Count != 1 || corpIds[0] < 1) return default; if (list.ToList().Exists(x => x.ID < 1)) return default; var dal=new DAL.PipeLineBinding(); var entity_list = Model2Entities(list.ToList()); var bol = dal.Updates(entity_list); if (bol) { UpdateCorpCache(corpIds[0], list.Select(x => x.ID).ToList()); } return bol; } #endregion } }