/// <summary>
/// 获取参保企业列表
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public PagedResult <EnterpriseSocialSecurity> GetEnterpriseList(EnterpriseSocialSecurityParameter parameter)
{
string sqlstr = $"select * from (select ROW_NUMBER() OVER(ORDER BY s.EnterpriseID )AS Row,s.* from EnterpriseSocialSecurity s where EnterpriseName like '%{parameter.EnterpriseName}%') ss WHERE ss.Row BETWEEN @StartIndex AND @EndIndex";
List <EnterpriseSocialSecurity> modelList = DbHelper.Query <EnterpriseSocialSecurity>(sqlstr, new
{
StartIndex = parameter.SkipCount,
EndIndex = parameter.TakeCount
});
int totalCount = DbHelper.QuerySingle <int>($"select count(0) from EnterpriseSocialSecurity where EnterpriseName like '%{parameter.EnterpriseName}%'");
return(new PagedResult <EnterpriseSocialSecurity>
{
PageIndex = parameter.PageIndex,
PageSize = parameter.PageSize,
TotalItemCount = totalCount,
Items = modelList
});
}
/// <summary>
/// 获取参保企业列表
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public ActionResult GetEnterpriseList(EnterpriseSocialSecurityParameter parameter)
{
PagedResult <EnterpriseSocialSecurity> EnterpriseSocialSecurityList = _enterpriseService.GetEnterpriseList(parameter);
return(View(EnterpriseSocialSecurityList));
}
