dbo.net分页的使用

List<SqlParameter> paraList = new List<SqlParameter>();
string sqlText = "select * FROM [dbo].[AdvertisementInfo] Where 1=1 ";

if (!string.IsNullOrEmpty(useStatus))
{
sqlText += " AND UseStatus=@UseStatus ";
paraList.Add(new SqlParameter("@UseStatus", useStatus));
}
if (!string.IsNullOrEmpty(personType))
{
sqlText += " AND PersonType=@PersonType ";
paraList.Add(new SqlParameter("@PersonType", personType));
}

sqlText = new ServiceBaseClass().GetSqlScriptByFindList(sqlText, "Order by PersonType ", pageIndex, pageSize);

var tempReturn = SqlHelper.FillDataTable(CommandType.Text, sqlText, paraList.ToArray());

if (tempReturn != null && tempReturn.Rows.Count > 0)
{
returnValue.RecordCount = tempReturn.Rows[0].Field<int>("recordCount");

returnValue.ReturnValue = (from d in tempReturn.AsEnumerable()
select new AdvertisementIndexListReturnVM
{
AdvertisementTypeName = d.Field<string>("AdvertisementTypeName") ?? string.Empty,
AdvertisementUrl = d.Field<string>("AdvertisementUrl") ?? string.Empty,
Id = d.Field<int>("Id"),
ImageUrl = GetImageUrl(d.Field<string>("ImageFileInfoCode")),
PersonTypeName = d.Field<string>("PersonTypeName") ?? string.Empty,
UseStatusName = d.Field<int>("UseStatus") == 0 ? "停用" : "正常",
}).ToList();
}