private List <DbParameter> ListFilter(NewsListParam param, StringBuilder strSql, bool bNewsContent = false)
{
strSql.Append(@"SELECT a.Id,
a.BaseModifyTime,
a.BaseModifierId,
a.NewsTitle,
a.ThumbImage,
a.NewsTag,
a.NewsAuthor,
a.NewsSort,
a.NewsDate,
a.NewsType,
a.ProvinceId,
a.CityId,
a.CountyId,
a.ViewTimes");
if (bNewsContent)
{
strSql.Append(",a.NewsContent");
}
strSql.Append(@" FROM SysNews a
WHERE 1 = 1");
var parameter = new List <DbParameter>();
if (param != null)
{
if (!string.IsNullOrEmpty(param.NewsTitle))
{
strSql.Append(" AND a.NewsTitle like @NewsTitle");
parameter.Add(DbParameterExtension.CreateDbParameter("@NewsTitle", '%' + param.NewsTitle + '%'));
}
if (param.NewsType > 0)
{
strSql.Append(" AND a.NewsType = @NewsType");
parameter.Add(DbParameterExtension.CreateDbParameter("@NewsType", param.NewsType));
}
if (!string.IsNullOrEmpty(param.NewsTag))
{
strSql.Append(" AND a.NewsTag like @NewsTag");
parameter.Add(DbParameterExtension.CreateDbParameter("@NewsTag", '%' + param.NewsTag + '%'));
}
if (param.ProvinceId > 0)
{
strSql.Append(" AND a.ProvinceId = @ProvinceId");
parameter.Add(DbParameterExtension.CreateDbParameter("@ProvinceId", param.ProvinceId));
}
if (param.CityId > 0)
{
strSql.Append(" AND a.CityId = @CityId");
parameter.Add(DbParameterExtension.CreateDbParameter("@CityId", param.CityId));
}
if (param.CountyId > 0)
{
strSql.Append(" AND a.CountId = @CountId");
parameter.Add(DbParameterExtension.CreateDbParameter("@CountyId", param.CountyId));
}
}
return(parameter);
}
private List <DbParameter> ListFilter(NewsListParam param, StringBuilder strSql, bool bNewsContent = false)
{
strSql.Append(@"SELECT a.id as Id,
a.base_modify_time as BaseModifyTime,
a.base_modifier_id as BaseModifierId,
a.news_title as NewsTitle,
a.thumb_image as ThumbImage,
a.news_tag as NewsTag,
a.news_author as NewsAuthor,
a.news_sort as NewsSort,
a.news_date as NewsDate,
a.news_type as NewsType,
a.province_id as ProvinceId,
a.city_id as CityId,
a.county_id as CountyId,
a.view_times as ViewTimes");
if (bNewsContent)
{
strSql.Append(",a.news_content as NewsContent");
}
strSql.Append(@" FROM sys_news a
WHERE 1 = 1");
var parameter = new List <DbParameter>();
if (param != null)
{
if (!string.IsNullOrEmpty(param.NewsTitle))
{
strSql.Append(" AND a.news_title like @NewsTitle");
parameter.Add(DbParameterExtension.CreateDbParameter("@NewsTitle", '%' + param.NewsTitle + '%'));
}
if (param.NewsType > 0)
{
strSql.Append(" AND a.news_type = @NewsType");
parameter.Add(DbParameterExtension.CreateDbParameter("@NewsType", param.NewsType));
}
if (!string.IsNullOrEmpty(param.NewsTag))
{
strSql.Append(" AND a.news_tag like @NewsTag");
parameter.Add(DbParameterExtension.CreateDbParameter("@NewsTag", '%' + param.NewsTag + '%'));
}
if (param.ProvinceId > 0)
{
strSql.Append(" AND a.province_id = @ProvinceId");
parameter.Add(DbParameterExtension.CreateDbParameter("@ProvinceId", param.ProvinceId));
}
if (param.CityId > 0)
{
strSql.Append(" AND a.city_id = @CityId");
parameter.Add(DbParameterExtension.CreateDbParameter("@CityId", param.CityId));
}
if (param.CountyId > 0)
{
strSql.Append(" AND a.county_id = @CountyId");
parameter.Add(DbParameterExtension.CreateDbParameter("@CountyId", param.CountyId));
}
}
return(parameter);
}
public async Task <List <NewsEntity> > GetPageContentList(NewsListParam param, Pagination pagination)
{
var strSql = new StringBuilder();
List <DbParameter> filter = ListFilter(param, strSql, true);
var list = await this.BaseRepository().FindList <NewsEntity>(strSql.ToString(), filter.ToArray(), pagination);
return(list.ToList());
}
public async Task <TData <List <NewsEntity> > > GetPageContentList(NewsListParam param, Pagination pagination)
{
TData <List <NewsEntity> > obj = new TData <List <NewsEntity> >();
obj.Result = await newsService.GetPageContentList(param, pagination);
obj.TotalCount = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <NewsEntity> > > GetList(NewsListParam param)
{
TData <List <NewsEntity> > obj = new TData <List <NewsEntity> >();
areaBLL.SetAreaParam(param);
obj.Result = await newsService.GetList(param);
obj.TotalCount = obj.Result.Count;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <NewsEntity> > > GetPageList(NewsListParam param, Pagination pagination)
{
TData <List <NewsEntity> > obj = new TData <List <NewsEntity> >();
areaBLL.SetAreaParam(param);
obj.Data = await newsService.GetPageList(param, pagination);
obj.Total = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <IActionResult> GetPageListJson(NewsListParam param, Pagination pagination)
{
TData <List <NewsEntity> > obj = await newsBLL.GetPageList(param, pagination);
return(Json(obj));
}
public async Task <TData <List <NewsEntity> > > GetPageContentList([FromQuery] NewsListParam param, [FromQuery] Pagination pagination)
{
TData <List <NewsEntity> > obj = await newsBLL.GetPageContentList(param, pagination);
return(obj);
}