linq的模糊查询和分页

来源：互联网发布：淘宝订单编号有规律吗编辑：程序博客网时间：2024/04/28 12:25

模糊查询

var query = from n in dbContext.yf_user

orderby n.id
join t in dbContext.yf_role on n.roleid equals t.id
where (n.username.Contains(input.username))
select new
{
id = n.id,
username = n.username,
userpass = n.userpass,
roleid = n.roleid,
createtime = n.createtime,
mobile = n.mobile,
rolename = t.rolename,

};

var list = query.ToList();

return ReturnNode.ReturnSuccess(list);

分页

var query = from n in dbContext.yf_user
join t in dbContext.yf_role on n.roleid equals t.id
select new
{
id = n.id,
username = n.username,
state = n.state,
userpass = n.userpass,
roleid = n.roleid,
createtime = n.createtime,
mobile = n.mobile,
rolename = t.rolename,

};

int allCount = query.Count();
var list = query.OrderByDescending(a => a.id).Skip(input.startIndex).Take(input.pageMaxCount).ToList();
var data = new { list = list, allCount = allCount };
return ReturnNode.ReturnSuccess(data);

阅读全文

0 0