/// <summary>
/// EF操作数据库分页及查询源码
/// </summary>
/// <param name="HdhcmsName"></param>
/// <param name="HdhcmsMobile"></param>
/// <param name="HdhcmsPage">当前的页面</param>
/// <returns></returns>
public IEnumerable<Student> ListStudent(string HdhcmsName = "", string HdhcmsMobile = "", int HdhcmsPage = 1)
{
HdhcmsEntity hdhcmsDb = new HdhcmsEntity();
HdhcmsPage = HdhcmsPage < 1 ? 1 : HdhcmsPage;
IQueryable<Student> stu = hdhcmsDb.Student;
if (!string.IsNullOrEmpty(HdhcmsName))
{
stu = stu.Where(s=>s.HdhcmsName.Contains(HdhcmsName));
}
if (!string.IsNullOrEmpty(HdhcmsMobile))
{
stu = stu.Where(s => s.HdhcmsMobile.Contains(HdhcmsMobile));
}
int PageSize = 2;
stu = stu.OrderByDescending(s=>s.Sid)
.Skip(PageSize * (HdhcmsPage - 1))
.Take(PageSize);
return stu.ToList();
}
查看更多关于EF操作数据库分页及拼接字段查询源码的详细内容...