namespace IStation.Service
{
///
/// 租户用户映射
///
public partial class TenantUserMapping
{
#region Cache
//获取缓存
private static List GetCache()
{
var all = TenantUserMappingCacheHelper.GetSet(() =>
{
var dal = new DAL.TenantUserMapping();
var entity_list = dal.GetAll();
var model_list = Entity2Models(entity_list);
if (model_list == null)
{
model_list = new List();
}
return model_list;
}, ConfigHelper.CacheKeepTime, ConfigHelper.CacheRandomTime);
return all;
}
//通过 ID 更新缓存
private static void UpdateCache(long ID)
{
var dal = new DAL.TenantUserMapping();
var entity_ds = dal.GetByID(ID);
var model_ds = Entity2Model(entity_ds);
var all = GetCache();
var model = all.Find(x => x.ID == ID);
if (model == null)
{
all.Add(model_ds);
}
else
{
model.Reset(model_ds);
}
}
//通过 Ids 更新缓存
private static void UpdateCache(List Ids)
{
if (Ids == null || Ids.Count < 1)
return;
var dal = new DAL.TenantUserMapping();
var entity_list = dal.GetByIds(Ids);
var model_list = Entity2Models(entity_list);
var all = GetCache();
all.RemoveAll(x => Ids.Contains(x.ID));
if (model_list != null && model_list.Count > 0)
{
all.AddRange(model_list);
}
}
//通过 TenantID 更新缓存
private static void UpdateCacheByTenantID(long TenantID)
{
var dal = new DAL.TenantUserMapping();
var entity_list = dal.GetByTenantID(TenantID);
var model_list = Entity2Models(entity_list);
var all = GetCache();
all.RemoveAll(x => x.TenantID == TenantID);
if (model_list != null && model_list.Count > 0)
{
all.AddRange(model_list);
}
}
//通过 UserID 更新缓存
private static void UpdateCacheByUserID(long UserID)
{
var dal = new DAL.TenantUserMapping();
var entity_list = dal.GetByUserID(UserID);
var model_list = Entity2Models(entity_list);
var all = GetCache();
all.RemoveAll(x => x.UserID == UserID);
if (model_list != null && model_list.Count > 0)
{
all.AddRange(model_list);
}
}
//移除缓存
private static void RemoveCache(long ID)
{
var all = GetCache();
all.RemoveAll(x => x.ID == ID);
}
#endregion
#region Query
///
/// 获取所有
///
public List GetAll()
{
var all = GetCache();
return all.ToList();
}
///
/// 通过 ID 获取
///
public Model.TenantUserMapping GetByID(long ID)
{
var all = GetAll();
var model = all.Find(x => x.ID == ID);
return model;
}
///
/// 通过 ID 获取
///
public List GetByIds(List Ids)
{
if (Ids == null || Ids.Count < 1)
return default;
var all = GetAll();
var list = all.Where(x => Ids.Contains(x.ID)).ToList();
return list;
}
///
/// 通过 UserID 获取
///
public List GetByUserID(long UserID)
{
var all = GetAll();
return all.Where(x => x.UserID == UserID).ToList();
}
///
/// 通过 TenantID 获取
///
public List GetByTenantID(long TenantID)
{
var all = GetAll();
return all.Where(x => x.TenantID == TenantID).ToList();
}
#endregion
#region Insert
///
/// 添加一条
///
public long Insert(Model.TenantUserMapping model)
{
if (model == null)
return default;
var entity = Model2Entity(model);
var dal = new DAL.TenantUserMapping();
var id = dal.Insert(entity);
if (id > 0)
{
UpdateCache(id);
}
return id;
}
///
/// 批量插入
///
public bool Inserts(List list)
{
if (list == null || list.Count < 1)
return false;
var dal = new DAL.TenantUserMapping();
var entity_list = Model2Entities(list);
var ids = dal.InsertsR(entity_list);
if (ids != null && ids.Count > 0)
{
UpdateCache(ids);
return true;
}
return false;
}
#endregion
#region Update
///
/// 更新一条
///
public bool Update(Model.TenantUserMapping model)
{
if (model == null)
return false;
var entity = Model2Entity(model);
var dal = new DAL.TenantUserMapping();
var bol = dal.Update(entity);
if (bol)
{
UpdateCache(model.ID);
}
return bol;
}
///
/// 批量更新
///
public bool Updates(List list)
{
if (list == null || list.Count < 1)
return false;
var entity_list = Model2Entities(list.ToList());
var dal = new DAL.TenantUserMapping();
var bol = dal.Updates(entity_list);
if (bol)
{
UpdateCache(list.Select(x => x.ID).ToList());
}
return bol;
}
#endregion
#region Exist
///
/// 通过 UserID 判断是否存在
///
public bool IsExistByUserID(long UserID)
{
var all = GetAll();
return all.Exists(x => x.UserID == UserID);
}
///
/// 通过 TenantID 判断是否存在
///
public bool IsExistByTenantID(long TenantID)
{
var all = GetAll();
return all.Exists(x => x.TenantID == TenantID);
}
#endregion
#region Delete
///
/// 通过 ID 删除
///
public bool DeleteByID(long ID, out string Msg)
{
Msg = string.Empty;
var dal = new DAL.TenantUserMapping();
var bol = dal.DeleteByID(ID);
if (bol)
{
RemoveCache(ID);
}
return bol;
}
#endregion
#region Set
///
/// 通过租户设置
///
public bool SetOfTenant(long TenantID, List UserIds)
{
if (UserIds == null)
{
UserIds = new List();
}
var list = new List();
var mappingList = GetByTenantID(TenantID);
if (mappingList == null)
{
mappingList = new List();
}
foreach (var mapping in mappingList)
{
if (!UserIds.Contains(mapping.UserID))
{
var entityMapping = new Entity.TenantUserMappingSelected()
{
TenantID = TenantID,
UserID = mapping.UserID,
Selected = false
};
list.Add(entityMapping);
}
}
foreach (var userId in UserIds)
{
if (!mappingList.Exists(x => x.UserID == userId))
{
var entityMapping = new Entity.TenantUserMappingSelected()
{
TenantID = TenantID,
UserID = userId,
Selected = true
};
list.Add(entityMapping);
}
}
if (list.Count < 1)
return false;
var dal = new DAL.TenantUserMapping();
var bol = dal.Set(list);
if (bol)
{
UpdateCacheByTenantID(TenantID);
}
return bol;
}
///
/// 通过用户设置
///
public bool SetOfUser(long UserID, List TenantIds)
{
if (TenantIds == null)
{
TenantIds = new List();
}
var list = new List();
var mappingList = GetByUserID(UserID);
if (mappingList == null)
{
mappingList = new List();
}
foreach (var mapping in mappingList)
{
if (!TenantIds.Contains(mapping.TenantID))
{
var entityMapping = new Entity.TenantUserMappingSelected()
{
TenantID = mapping.TenantID,
UserID = UserID,
Selected = false
};
list.Add(entityMapping);
}
}
foreach (var tenantId in TenantIds)
{
if (!mappingList.Exists(x => x.TenantID == tenantId))
{
var entityMapping = new Entity.TenantUserMappingSelected()
{
TenantID = tenantId,
UserID = UserID,
Selected = true
};
list.Add(entityMapping);
}
}
if (list.Count < 1)
return false;
var dal = new DAL.TenantUserMapping();
var bol = dal.Set(list);
if (bol)
{
UpdateCacheByUserID(UserID);
}
return bol;
}
#endregion
}
}