模糊查询
var query = from n in dbContext.yf_user
orderby n.idjoin 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);