public BasePageList<BaseUserModel> GetUserList(BaseUserQueryModel query) { return _baseservice.GetUserList(query); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public BasePageList<BaseUserModel> GetUserList(BaseUserQueryModel query) { const string spName = "sp_common_pager"; const string tableName = @"sys_user "; const string fields = "innerid, username, loginname, password, mobile, telephone, email, status, createdtime, modifiedtime"; var oldField = string.IsNullOrWhiteSpace(query.Order) ? " modifiedtime desc " : query.Order; var sqlWhere = new StringBuilder("1=1"); if (query.status != null) { sqlWhere.Append($" and status = %{query.status}%"); } var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex); var list = Helper.ExecutePaging<BaseUserModel>(model, query.Echo); return list; }