public BasicDataPageResponse GetBasicDataInfoPage(BasicDataPageRequest request)
{
var info = new BasicDataPageResponse();
info.DataList = repository.GetBasicDataInfoPage(request, out int total);
info.Total = total;
return(info);
}/// <summary>
public BaseResponse GetBasicDataInfoPage(BasicDataPageRequest request)
{
try
{
var response = basicDataDomainService.GetBasicDataInfoPage(request);
return(ApiSuccessResult(response));
}
catch (Exception ex)
{
_Log4Net.Error("GetEXTCourseByPage--异常信息", ex);
return(ApiErrorResult(ex.Message));
}
}
public IActionResult exportExcle(BasicDataPageRequest request)
{
try
{
var response = basicDataDomainService.GetBasicDataInfoPage(request);
var stream = ExcelHelper.SaveExcel(response.DataList);
return(File(stream, "application/vnd.ms-excel", "基础数据.xlsx"));
}
catch (Exception ex)
{
_Log4Net.Error("GetEXTCourseByPage--异常信息", ex);
return(null);
}
}
public List <BasicDataPage> GetBasicDataInfoPage(BasicDataPageRequest request, out int total)
{
StringBuilder _query = new StringBuilder();
_query.Append(@"select a.*,b.SysDictValue PocSourceName from T_EXT_BasicData a
left join T_SYS_Dictionary b on b.SysDictKey = cast(a.POCSource as nvarchar)");
var _parameters = new DynamicParameters();
var _where = new StringBuilder(" where 1 = 1");
if (request.PocSource?.Count > 0)
{
_where.Append(" and a.POCSource in @Pocsource");
_parameters.Add("@Pocsource", request.PocSource.ToArray());
}
if (request.OneOrgId?.Count > 0)
{
_where.Append(" and a.OneOrgId in @OneOrgId");
_parameters.Add("@OneOrgId", request.OneOrgId.ToArray());
}
if (!string.IsNullOrWhiteSpace(request.DictValue))
{
var signs = new List <string> {
"'", "[", "%", "_"
};
_where.Append(" and a.DictValue like @DictValue");
_parameters.Add("@DictValue", $"%{request.DictValue.ReplaceBySigns(signs)}%");
}
var countsql = @"select count(1) from T_EXT_BasicData a
left join T_SYS_Dictionary b on b.SysDictKey = cast(a.POCSource as nvarchar)" + _where.ToString();
total = GetInfos <int>(EumDBName.POC, countsql, _parameters).First();
if (request.IsExport)
{
return(GetInfos <BasicDataPage>(EumDBName.POC, _query.ToString() + _where.ToString(), _parameters).ToList());
}
return(GetPageInfos <BasicDataPage>(EumDBName.POC, _query.ToString() + _where.ToString(), "a.Id ASC", request.PageIndex, request.PageSize, _parameters).ToList());
}
