/// <summary>
/// 获取列表
/// </summary>
/// <param name="param">搜索实体</param>
public Task <BasePagedListModel <ListDJLBEntity> > GetListAsync(DJLBSearchParam param)
{
if (param == null)
{
throw new ArgumentNullException(nameof(param));
}
return(repository.GetListAsync(param));
}
public async Task <IActionResult> GetGridJson(DJLBSearchParam param)
{
BasePagedListModel <ListDJLBEntity> pageDataModel = await service.GetListAsync(param);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="param">搜索实体</param>
public async Task <BasePagedListModel <ListDJLBEntity> > GetListAsync(DJLBSearchParam param)
{
BasePagedListModel <ListDJLBEntity> list = new BasePagedListModel <ListDJLBEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
if (param.DJQZ.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND DJQZ like '%{0}%'", param.DJQZ.FilterSql());
}
if (param.Name.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND Name like '%{0}%'", param.Name.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "a.*,b.Name AS DJDLName";
criteria.PageSize = param.PageSize;
criteria.TableName = "P_DJLB a JOIN P_DJDL b ON a.DJDLId=b.Id";
criteria.PrimaryKey = "Id";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <ListDJLBEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListAsync(DJLBSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListAsync(DJLBSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListAsync(DJLBSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}
