public bool GetAll(string keyword, ref List <TASM_USER> list)
{
if (string.IsNullOrEmpty(keyword))
{
keyword = string.Empty;
}
list = CurrentDb.GetList().Where(it => it.USER_NAME.Contains(keyword) || it.WORK_ID.Contains(keyword)).OrderBy(s => s.WORK_ID).ToList();
return(list.Count > 0);
}
public List <MenuTree> GetTreeMenu()
{
List <MenuTree> _list = new List <MenuTree>();
List <user_menu> user_Menus = CurrentDb.GetList(i => i.parent_id == 0);
if (user_Menus.Count > 0)
{
foreach (var item in user_Menus)
{
MenuTree menuTree = new MenuTree();
menuTree.title = item.um_title;
menuTree.id = Convert.ToString(item.um_id);
menuTree.key = $"{user_Menus.IndexOf(item)}";
_list.Add(menuTree);
}
foreach (var item in _list)
{
List <user_menu> _Menus = CurrentDb.GetList(i => i.parent_id == Convert.ToInt32(item.id));
if (_Menus.Count > 0)
{
List <MenuTree> menuTrees = new List <MenuTree>();
foreach (var _item in _Menus)
{
MenuTree menuTree = new MenuTree();
menuTree.id = Convert.ToString(_item.um_id);
menuTree.title = _item.um_title;
menuTree.key = $"{item.key}-{_Menus.IndexOf(_item)}";
menuTrees.Add(menuTree);
}
item.children = menuTrees;
}
}
}
return(_list);
}
/// <summary>
/// 根据表达式查询
/// </summary>
/// <returns></returns>
public virtual List <T> GetList(Expression <Func <T, bool> > whereExpression)
{
return(CurrentDb.GetList(whereExpression));
}
} //用来处理Sys_UserLogOn表的常用操作
/// <summary>
/// 获取所有
/// </summary>
/// <returns></returns>
public virtual List <T> GetList()
{
return(CurrentDb.GetList());
}
/// <summary>
///
/// </summary>
/// <param name="whereExpression"></param>
/// <returns></returns>
public IEnumerable <News> GetNews(Expression <Func <News, bool> > whereExpression)
{
return(CurrentDb.GetList(whereExpression));
}
/// <summary>
///
/// </summary>
/// <param name="day"></param>
/// <returns></returns>
public List <TodayOnHistory> Query(string day)
{
return(CurrentDb.GetList(x => x.Day == day));
}
public virtual List <TModel> GetList() => CurrentDb.GetList();
public DateTime?GetFirstDateTime(int type = 0)
{
return(CurrentDb.GetList(x => x.Type == type).OrderByDescending(x => x.Date).FirstOrDefault()?.Date);
}
