public ActionResult Exports(JqSearchIn si, GridExportMode gridExportMode, PageSearchModel model)
{
var workbook = _pageService.Exports(si, gridExportMode, model);
var output = new MemoryStream();
workbook.Write(output);
return(File(output.ToArray(), "application/vnd.ms-excel", "Pages.xls"));
}
public Pager <SysPartner> GetPager(string name, PageSearchModel search)
{
var sql = AdminQuery();
var param = new DynamicParameters();
if (!string.IsNullOrEmpty(name))
{
sql += " and Name like @name";
param.Add("name", $"%{name}%");
}
return(Pager(sql, param, search));
}
public Pager <UserRole> GetList(string keyword, PageSearchModel search)
{
var sql = new StringBuilder(AdminQuery());
var param = new DynamicParameters();
if (!string.IsNullOrEmpty(keyword))
{
sql.Append(" and (Name like @keyword or Remark like @keyword)");
param.Add("keyword", $"%{keyword}%");
}
return(Pager(sql.ToString(), param, search));
}
protected PageSearchModel GetSearchModel()
{
var model = new PageSearchModel()
{
Sort = Request.QueryString["sort"] ?? "UpdateTime",
Order = Request.QueryString["order"] ?? "desc",
Offset = StringUtility.ConvertToInt(Request.QueryString["offset"], 0),
Limit = StringUtility.ConvertToInt(Request.QueryString["limit"], 10)
};
return(model);
}
public Pager <TP> Pager <TP>(string sql, DynamicParameters param, PageSearchModel search)
{
var pager = new Pager <TP>();
var countSql = $"Select Count(*) from ({sql}) c";
pager.total = DbConn.QueryFirst <int>(countSql, param);
sql += $" order by {search.Sort} {search.Order} OFFSET {search.Offset} ROWS FETCH NEXT {search.Limit} ROWS ONLY";
pager.rows = DbConn.Query <TP>(sql, param);
return(pager);
}
public void GetPagedList()
{
var search = new PageSearchModel()
{
Limit = 20,
Offset = 0,
Order = "Desc",
Sort = "Id"
};
var list = SysLogRepository.GetPager(search, "og", "211", TableSource.Users, null, "", "", null, null);
Assert.IsNotNull(list);
}
public Pager <ArticleListItemModel> GetPager(IEnumerable <long> lstClz, PageSearchModel search)
{
var sql = @"select a.Id,a.Title,a.ArticleDateTime,a.Author,a.ClassifyId,ac.Name as ClassifyName,ac.PicAttaId as ClassifyPicAttaId from Article a
left join ArticleClassify ac on a.ClassifyId = ac.Id
where ClassifyId in @clzIds and CommonStatus=@status";
var param = new DynamicParameters();
param.Add("clzIds", lstClz);
param.Add("status", CommonStatus.Enabled);
search.Order = "desc";
search.Sort = "ArticleDateTime";
return(Pager <ArticleListItemModel>(sql, param, search));
}
public Pager <SysOperationLog> GetPager(PageSearchModel search, string source, string sourceId,
TableSource?cat, OperationType?type, string q, string uname, DateTime?minTime, DateTime?maxTime)
{
var dynamicParams = new DynamicParameters();
var sqlStr = new StringBuilder(AdminQuery());
if (!string.IsNullOrEmpty(source))
{
sqlStr.Append(" and DataSource like @source");
dynamicParams.Add("source", $"%{source}%");
}
if (!string.IsNullOrEmpty(sourceId))
{
sqlStr.Append(" and DataSouceId = @srcId");
dynamicParams.Add("srcId", sourceId);
}
if (cat.HasValue)
{
sqlStr.Append(" and LogCat = @cat");
dynamicParams.Add("cat", cat.Value);
}
if (type.HasValue)
{
sqlStr.Append(" and LogType = @type");
dynamicParams.Add("type", type.Value);
}
if (!string.IsNullOrEmpty(q))
{
sqlStr.Append(" and LogTitle like @title");
dynamicParams.Add("title", $"%{q}%");
}
if (!string.IsNullOrEmpty(uname))
{
sqlStr.Append(" and CreateUserName = @uname");
dynamicParams.Add("uname", uname);
}
if (minTime.HasValue)
{
sqlStr.Append(" and CreateTime >= @minTime");
dynamicParams.Add("minTime", minTime.Value);
}
if (maxTime.HasValue)
{
sqlStr.Append(" and CreateTime <= @maxTime");
dynamicParams.Add("maxTime", maxTime.Value);
}
return(Pager(sqlStr.ToString(), dynamicParams, search));
}
public Pager <SysConfig> GetPager(string keyword, SysConfigClassify?clz, PageSearchModel search)
{
var sql = new StringBuilder(AdminQuery());
var param = new DynamicParameters();
if (!string.IsNullOrEmpty(keyword))
{
sql.Append(" and (ConKey like @key or Name like @key)");
param.Add("@key", $"%{keyword}%");
}
if (clz.HasValue)
{
sql.Append(" and ConfigClassify = @clz");
param.Add("@clz", clz.Value);
}
return(Pager(sql.ToString(), param, search));
}
/// <summary>
/// 返回所有列表，可以查询
/// </summary>
/// <param name="group"></param>
/// <param name="keyWord">搜索关键词</param>
/// <param name="gender">性别</param>
/// <param name="orderField">排序的字段</param>
/// <param name="orderDirection">排序的顺序</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页显示的数量</param>
/// <returns></returns>
public Pager <Users> GetPager(UserGroup group, string keyWord, PageSearchModel search)
{
var sql = new StringBuilder(AdminQuery());
var param = new DynamicParameters();
sql.Append(" and UserGroup=@group");
param.Add("group", group);
if (!string.IsNullOrEmpty(keyWord))
{
sql.Append($@" and (LoginName like @keyword
or Email like @keyword
or RealName like @keyword)");
param.Add("keyword", keyWord);
}
return(Pager(sql.ToString(), param, search));
}
public Pager <Attachment> GetList(string name, TableSource?src, PageSearchModel search)
{
var sql = new StringBuilder(AdminQuery());
var param = new DynamicParameters();
if (!string.IsNullOrEmpty(name))
{
sql.Append(" and Name like @name");
param.Add("name", $"%{name}%");
}
if (src.HasValue)
{
sql.Append(" and Source = @src");
param.Add("src", src.Value);
}
return(Pager(sql.ToString(), param, search));
}
/// <summary>
/// 返回当前分类下所有的文章
/// </summary>
/// <param name="articleClassifyQuery">分类信息</param>
/// <param name="keyWord">搜索关键词</param>
/// <param name="classifyId">当前分类的Id</param>
/// <param name="orderField">排序的字段</param>
/// <param name="orderDirection">排序的顺序</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页显示的数量</param>
/// <returns></returns>
public Pager <Article> GetPager(string keyWord, long?classifyId, PageSearchModel search)
{
var sql = new StringBuilder(AdminQuery());
var param = new DynamicParameters();
if (!string.IsNullOrEmpty(keyWord))
{
sql.Append(" and (Title like @keyword or Author like @keyword)");
param.Add("keyword", $"%{keyWord}%");
}
if (classifyId.HasValue)
{
sql.Append(" and ClassifyId = @classifyId");
param.Add("classifyId", classifyId.Value);
}
return(Pager(sql.ToString(), param, search));
}
/// <summary>
/// 返回所有的记录
/// </summary>
/// <param name="name">搜索关键词</param>
/// <param name="status"></param>
/// <param name="search"></param>
/// <returns></returns>
public Pager <JobTask> GetPager(string name, CommonStatus?status, PageSearchModel search)
{
var sql = new StringBuilder(Query());
var param = new DynamicParameters();
if (!string.IsNullOrEmpty(name))
{
sql.Append(" and Name like @name");
param.Add("name", $"%{name}%");
}
if (status.HasValue)
{
sql.Append(" and Status = @status");
param.Add("status", status.Value);
}
return(Pager(sql.ToString(), param, search));
}
public async Task <IEnumerable <FileItemExtended> > GetFiles(PageSearchModel model, Expression <Func <FileItem, bool> > searchCriteria)
{
var query = _context.Files
.Include(s => s.User)
.Where(searchCriteria)
.OrderByDescending(s => s.CreatedAt)
.Skip(model.PageIndex * model.PageSize)
.Take(model.PageSize)
.Select(s => new FileItemExtended()
{
Id = s.Id,
UserName = s.User.UserName,
Name = s.Name,
Extension = s.Extension,
Size = s.Size,
DownloadCount = s.DownloadCount,
CreatedAt = s.CreatedAt,
});
return(await query.ToListAsync());
}
/// <summary>
/// Search and return a paging list of users
/// </summary>
public async Task <IEnumerable <UserExtended> > GetUsers(PageSearchModel model, Expression <Func <User, bool> > searchCriteria)
{
var query = _context.Users
.Include(s => s.Role)
.Where(searchCriteria)
.OrderByDescending(s => s.CreatedAt)
.Skip(model.PageIndex * model.PageSize)
.Take(model.PageSize)
.Select(s => new UserExtended()
{
Id = s.Id,
Avatar = s.Avatar,
UserName = s.UserName,
RoleName = s.Role.Name,
Email = s.Email,
EmailConfirmed = s.EmailConfirmed,
CreatedAt = s.CreatedAt,
AccountSuspended = s.AccountSuspended
});
return(await query.ToListAsync());
}
public string _AjaxBinding(JqSearchIn si, PageSearchModel model)
{
return(JsonConvert.SerializeObject(_pageService.SearchPages(si, model)));
}
public GetUsersQuery(PageSearchModel pageSearch)
{
PageSearch = new PageSearchModel(pageSearch);
}
public Pager <ArticleListItemModel> GetPager(long clzId, PageSearchModel search)
{
var lstClzId = ArticleClassifyRepository.GetLstChildId(clzId);
return(ArticleRepository.GetPager(lstClzId, search));
}
public GetFilesQuery(PageSearchModel pageSearch)
{
PageSearch = new PageSearchModel(pageSearch);
}
public Pager <T> Pager(string sql, DynamicParameters param, PageSearchModel search)
{
return(Pager <T>(sql, param, search));
}
public async Task <IActionResult> GetUsers([FromQuery] PageSearchModel model)
{
PagingResult <UserExtended> Result = await _mediatr.Send(new GetUsersQuery(model));
return(HandleResult(Result));
}
public async Task <IActionResult> GetFiles([FromQuery] PageSearchModel pageSearch)
{
PagingResult <FileItemExtended> Result = await _mediatr.Send(new GetFilesQuery(pageSearch));
return(HandleResult(Result));
}
public ActionResult Index()
{
var model = new PageSearchModel();
return(View(model));
}
public async Task <IHttpActionResult> GetPageList(PageSearchModel model)
{
var pageData = await _helper.GetPageListAsync(model.SearchModel, o => o.CreateTime, model.PageParam, false);
return(Success(pageData));
}
public Pager <AdvertBizModel> GetList(long adPosId, string name, AdvertStatus?status, PageSearchModel search)
{
var strBuilder = new StringBuilder(AdminQuery());
var param = new DynamicParameters();
strBuilder.Append(" and AdPosId = @adPosId");
param.Add("adPosId", adPosId);
if (!string.IsNullOrEmpty(name))
{
strBuilder.Append(" and Name like @name");
param.Add("name", $"%{name}%");
}
if (status.HasValue)
{
strBuilder.Append(" and AdvertStatus = @status");
param.Add("status", status.Value);
}
return(Pager <AdvertBizModel>(strBuilder.ToString(), param, search));
}
