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);
}
