public object Get(string id = null, string OrganizeCode = null)
{
PageRequest pageReq = new PageRequest();
using (var db = new SysContext())
{
IQueryable <sys_user> query = db.sys_user.AsNoTracking();
if (OrganizeCode != null)
{
query = db.sys_userOrganizeMap.Include("sys_user").Where(o => o.OrganizeCode == OrganizeCode).Select(o => o.sys_user);
}
var rQuery = pageReq.ApplyQuery(query, "UserSeq");
return(rQuery.ToList());
}
}
public object Get()
{
var pageReq = new PageRequest();
using (var db = new MmsContext())
{
IQueryable <mms_check> query = db.mms_check.AsNoTracking();
int total;
query = pageReq.ApplyQuery <mms_check>(query, "BillNo", "desc", out total);
dynamic result = new System.Dynamic.ExpandoObject();
result.rows = query.ToList();
result.total = total;
return(result);
}
}
public object Get()
{
var pageReq = new PageRequest();
using (var db = new LUOLAI1401Context())
{
IQueryable <wq_termPop> query = db.wq_termPop.AsNoTracking();
int total;
query = pageReq.ApplyQuery <wq_termPop>(query, "CompCode", "desc", out total);
dynamic result = new System.Dynamic.ExpandoObject();
result.rows = query.ToList();
result.total = total;
return(result);
}
}
public object Get(string type = null)
{
var pageReq = new PageRequest();
using (var db = new SysContext())
{
IQueryable <sys_code> query = db.sys_code.AsNoTracking();
if (!string.IsNullOrEmpty(type))
{
query = query.Where(c => c.CodeType == type);
}
//query = pageReq.ApplyQuery<sys_code>(query, "Seq");
//return query.ToList();
int total;
query = pageReq.ApplyQuery <sys_code>(query, "Seq", null, out total);
dynamic result = new System.Dynamic.ExpandoObject();
result.rows = query.ToList();
result.total = total;
return(result);
}
}
