public APIResponse Get() { ZYBaseController.SetPager(HttpContext, ref base.pageIndex, ref base.pageSize, ref base.skip); string terminalID = HttpContext.Request.Query["terminalID"]; Expression <Func <LocationLog, bool> > expression = null; if (!string.IsNullOrEmpty(terminalID)) { expression = model => model.TerminalID == terminalID; } else { expression = model => model.TerminalID != null; } int total = _context.LocationLog.Where(expression).ToList().Count(); List <LocationLog> list = _context.LocationLog.Where(expression).OrderByDescending(t => t.SamplingTime).OrderByDescending(t => t.ID).Skip(base.skip).Take(base.pageSize).Select(s => s).ToList(); JObject body = new JObject(); APIResponse response = new APIResponse(); body.Add("Total", total); body.Add("List", JArray.FromObject(list)); response.Body = body; return(response); }
public APIResponse Get() { ZYBaseController.SetPager(HttpContext, ref base.pageIndex, ref base.pageSize, ref base.skip); bool bdLocationHasValue = false; bool.TryParse(HttpContext.Request.Query["bdLocationHasValue"], out bdLocationHasValue); string keywords = HttpContext.Request.Query["keywords"]; Expression <Func <ViewVehicle, bool> > expression = null; if (!string.IsNullOrEmpty(keywords)) { expression = model => model.PolicyNo.Contains(keywords) || model.RealName.Contains(keywords) || model.VIN.Contains(keywords) || model.TerminalID.Contains(keywords); } int total = 0; List <ViewVehicle> list = null; if (expression == null) { total = _context.ViewVehicle.ToList().Count(); list = _context.ViewVehicle.OrderByDescending(t => t.CreateTime).OrderByDescending(t => t.ID).Skip(base.skip).Take(base.pageSize).Select(s => s).ToList(); } else { total = _context.ViewVehicle.Where(expression).ToList().Count(); list = _context.ViewVehicle.Where(expression).OrderByDescending(t => t.CreateTime).OrderByDescending(t => t.ID).Skip(base.skip).Take(base.pageSize).Select(s => s).ToList(); } JObject body = new JObject(); APIResponse response = new APIResponse(); body.Add("Total", total); body.Add("List", JArray.FromObject(list)); response.Body = body; return(response); }
public APIResponse Get() { ZYBaseController.SetPager(HttpContext, ref base.pageIndex, ref base.pageSize, ref base.skip); bool bdLocationHasValue = false; bool.TryParse(HttpContext.Request.Query["bdLocationHasValue"], out bdLocationHasValue); int total = _context.ViewTerminalDetail.Where(t => t.BDLocation.Length > 0).ToList().Count(); List <ViewTerminalDetail> list = _context.ViewTerminalDetail.Where(t => t.BDLocation.Length > 0).OrderByDescending(t => t.AddDate).OrderByDescending(t => t.ID).Skip(base.skip).Take(base.pageSize).Select(s => s).ToList(); JObject body = new JObject(); APIResponse response = new APIResponse(); body.Add("Total", total); body.Add("List", JArray.FromObject(list)); response.Body = body; return(response); }
public APIResponse Get() { ZYBaseController.SetPager(HttpContext, ref base.pageIndex, ref base.pageSize, ref base.skip); string keywords = HttpContext.Request.Query["keywords"]; Expression <Func <ViewSIMCardDetail, bool> > expression = null; if (!string.IsNullOrEmpty(keywords)) { expression = model => model.ICCID.Contains(keywords) || model.NO.Contains(keywords) || model.ISMI.Contains(keywords) || model.SupplierName.Contains(keywords); } int total = 0; List <ViewSIMCardDetail> list = null; if (expression == null) { total = _context.ViewSIMCardDetail.ToList().Count(); list = _context.ViewSIMCardDetail.OrderByDescending(t => t.AddTime).Skip(base.skip).Take(base.pageSize).Select(s => s).ToList(); } else { total = _context.ViewSIMCardDetail.Where(expression).ToList().Count(); list = _context.ViewSIMCardDetail.Where(expression).OrderByDescending(t => t.AddTime).OrderByDescending(t => t.ID).Skip(base.skip).Take(base.pageSize).Select(s => s).ToList(); } JObject body = new JObject(); APIResponse response = new APIResponse(); body.Add("Total", total); body.Add("List", JArray.FromObject(list)); response.Body = body; return(response); }