/// <summary>
/// 查询角色信息
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public static SysRole QuerySysRoleEntity(Expression <Func <SysRole, bool> > predicate)
{
using var db = new ContextBase(ContextBase.DCOB().Options);
var mo = db.SysRole.Where(predicate).FirstOrDefault();
return(mo);
}
/// <summary>
/// 查询配置信息
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public static List <SysTableConfig> QuerySysTableConfigList(Expression <Func <SysTableConfig, bool> > predicate)
{
using var db = new ContextBase(ContextBase.DCOB().Options);
var list = db.SysTableConfig.Where(predicate).OrderBy(x => x.ColOrder).ToList();
return(list);
}
/// <summary>
/// 查询按钮
/// </summary>
/// <param name="predicate"></param>
/// <param name="cache"></param>
/// <returns></returns>
public static List <SysButton> QuerySysButtonList(Func <SysButton, bool> predicate, bool cache = true)
{
if (!cache || !(Core.CacheTo.Get(GlobalCacheKey.SysButton) is List <SysButton> list))
{
using var db = new ContextBase(ContextBase.DCOB().Options);
list = db.SysButton.OrderBy(x => x.SbBtnOrder).ToList();
Core.CacheTo.Set(GlobalCacheKey.SysButton, list, 300, false);
}
list = list.Where(predicate).ToList();
return(list);
}
/// <summary>
/// 查询角色信息
/// </summary>
/// <param name="predicate"></param>
/// <param name="cache"></param>
/// <returns></returns>
public static SysRole QuerySysRoleEntity(Func <SysRole, bool> predicate, bool cache = true)
{
if (!cache || !(Core.CacheTo.Get(GlobalCacheKey.SysRole) is List <SysRole> list))
{
using var db = new ContextBase(ContextBase.DCOB().Options);
list = db.SysRole.ToList();
Core.CacheTo.Set(GlobalCacheKey.SysRole, list, 300, false);
}
var mo = list.FirstOrDefault(predicate);
return(mo);
}
public DataMirrorService()
{
db = new ContextBase(ContextBase.DCOB().Options);
Tsb = db.SysButton;
Tsd = db.SysDictionary;
Tsm = db.SysMenu;
Tsr = db.SysRole;
Tstc = db.SysTableConfig;
Tsu = db.SysUser;
Tte = db.TempExample;
Ttid = db.TempInvoiceDetail;
Ttim = db.TempInvoiceMain;
}