/// <summary>
/// 通过查询条件获取推送信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_User_Information> GetSysUserListBySearch(SearchSysUserList searchParam, GridParams para)
{
using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance())
{
JsonResultModel <V_User_Information> jsonResult = new JsonResultModel <V_User_Information>();
Guid vguid = Guid.Parse(Common.Tools.MasterVGUID.SysAdmin);
var query = _dbMsSql.Queryable <V_User_Information>().Where(i => i.Vguid != vguid);
if (!string.IsNullOrEmpty(searchParam.LoginName))
{
query.Where(i => i.LoginName.Contains(searchParam.LoginName));
}
if (!string.IsNullOrEmpty(searchParam.Role))
{
query.Where(i => i.Role == searchParam.Role);
}
if (!string.IsNullOrEmpty(searchParam.Department))
{
query.Where(i => i.TranslationDepartment.Contains(searchParam.Department));
}
query.OrderBy(para.sortdatafield + " " + para.sortorder);
jsonResult.TotalRows = query.Count();
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize);
//存入操作日志表
string logData = JsonHelper.ModelToJson(jsonResult);
_logLogic.SaveLog(3, 26, Common.CurrentUser.GetCurrentUser().LoginName, "用户管理列表", logData);
return(jsonResult);
}
}
/// <summary>
/// 通过查询条件获取用户信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResult GetSysUserListBySearch(SearchSysUserList searchParam, GridParams para)
{
if (para.sortdatafield == null)
{
para.sortdatafield = "CreatedDate";
para.sortorder = "desc";
}
para.pagenum = para.pagenum + 1;//页0，+1
//List<DeparTment_1> departmenteList = _dl.GetDepartmentList(searchParam, para);
var model = _ul.GetSysUserListBySearch(searchParam, para);
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 通过查询条件获取用户信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_User_Information> GetSysUserListBySearch(SearchSysUserList searchParam, GridParams para)
{
return(_us.GetSysUserListBySearch(searchParam, para));
}
