public IActionResult ListingOrder([Bind] DataTableParam param) { if (param == null) { return(BadRequest()); } if (ModelState.IsValid) { var order = _orderService.ListingOrder(param.iSortCol_0, param.sSortDir_0); if (!String.IsNullOrEmpty(param.sSearch)) { order = order.Where(o => o.CustomerName.Contains(param.sSearch) || o.ShippingAddress.Contains(param.sSearch) || o.Status.Contains(param.sSearch) || o.ProductName.Contains(param.sSearch)) .ToList(); } var result = order.Skip(param.iDisplayStart) .Take(param.iDisplayLength) .ToList(); return(Json(new { aaData = result, param.sEcho, iTotalRecords = order.Count(), iTotalDisplayRecords = order.Count() })); } return(NotFound()); }
/// <summary> /// 查询分页数据集 /// </summary> /// <param name="param">DataTables 页面参数</param> /// <returns>返回Json数据集</returns> public JsonResult GetList(DataTableParam param, string keyword) { try { Expression <Func <GpsEdi, bool> > where = w => w.UserId != ""; int _total = 0; var _data = RepGpsedi.ListOffSet(param.Start, param.Length, out _total, where, false, o => o.GpsEdiTime).ToList(); DataTablesResult <GpsEdi> dtr = new DataTablesResult <GpsEdi>(param.Draw, _total, _total, _data); return(Json(dtr)); } catch { return(Json(new DataTablesResult <GpsEdi>(0, 0, 0, new List <GpsEdi>()))); } }
/// <summary> /// 查询分页数据集 /// </summary> /// <param name="param">DataTables 页面参数</param> /// <returns>返回Json数据集</returns> public JsonResult GetList(DataTableParam param, string gpsuserid) { try { Expression <Func <UserAccount, bool> > where = w => w.GpsUserId == gpsuserid; int _total = 0; var _data = RepUserAccount.ListOffSet(param.Start, param.Length, out _total, where, false, o => o.AddTime).ToList(); DataTablesResult <UserAccount> dtr = new DataTablesResult <UserAccount>(param.Draw, _total, _total, _data); return(Json(dtr)); } catch { return(Json(new DataTablesResult <UserAccount>(0, 0, 0, new List <UserAccount>()))); } }
public ActionResult Table(DataTableParam param) //Load Student's Table Via Server Side Processing { var StudentModel = (from i in SDBE.students join x in SDBE.Standards on i.standardID equals x.standardID select new { i.studentID, i.studentName, x.standardID, x.standardName, i.rowVersion }).ToList(); if (!String.IsNullOrEmpty(param.sSearch)) //search { StudentModel = StudentModel.Where(i => i.studentName.Contains(param.sSearch) || i.standardName.Contains(param.sSearch) || i.rowVersion.Contains(param.sSearch)).ToList(); } switch (param.iSortCol_0) //column sorting { case 0: StudentModel = param.sSortDir_0 == "asc" ? StudentModel.OrderBy(c => c.studentID).ToList() : StudentModel.OrderByDescending(c => c.studentID).ToList(); break; case 1: StudentModel = param.sSortDir_0 == "asc" ? StudentModel.OrderBy(c => c.studentName).ToList() : StudentModel.OrderByDescending(c => c.studentName).ToList(); break; case 2: StudentModel = param.sSortDir_0 == "asc" ? StudentModel.OrderBy(c => c.standardName).ToList() : StudentModel.OrderByDescending(c => c.standardName).ToList(); break; case 3: StudentModel = param.sSortDir_0 == "asc" ? StudentModel.OrderBy(c => c.rowVersion).ToList() : StudentModel.OrderByDescending(c => c.rowVersion).ToList(); break; } //pagination var displayResult = StudentModel.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList(); return(Json(new { aaData = displayResult, param.sEcho, iTotalRecords = StudentModel.Count(), iTotalDisplayRecords = StudentModel.Count() }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询分页数据集 /// </summary> /// <param name="param">DataTables 页面参数</param> /// <returns>返回Json数据集</returns> public JsonResult GetList(DataTableParam param, string keyword) { try { Expression <Func <GpsUser, bool> > where = w => w.UserId != ""; if (!string.IsNullOrEmpty(keyword)) { where = where.AndAlso(w => w.UserName.Contains(keyword) || w.UserShortname.Contains(keyword) || w.UserCode.Contains(keyword)); } int _total = 0; var _data = RepGpsUser.ListOffSet(param.Start, param.Length, out _total, where, false, o => o.AddTime).ToList(); DataTablesResult <GpsUser> dtr = new DataTablesResult <GpsUser>(param.Draw, _total, _total, _data); return(Json(dtr)); } catch { return(Json(new DataTablesResult <GpsUser>(0, 0, 0, new List <GpsUser>()))); } }
public JsonResult GetDatabases(DataTableParam dtParams) { IEnumerable <EResDatabaseViewModel> aaData2; int totalRecords = _db.EResDatabases.Count(); int filterdCount = totalRecords; var aaData = from r in _db.EResDatabases join v in _db.EResVendors on r.VendorID equals v.VendorID select new EResDatabaseViewModel { DatabaseID = r.DatabaseID, DatabaseName = r.DatabaseName, DatabaseType = r.DatabaseType, DatabaseTypeName = (r.DatabaseType == 1) ? "A&I" : "Full Text", FundingSource = r.FundingSource, DatabaseCost = r.DatabaseCost, FundingSourceName = (r.FundingSource == 1) ? "UNF" : (r.FundingSource == 2) ? "FLVC" : "Other", VendorID = r.VendorID, VendorName = v.VendorName }; if (!string.IsNullOrEmpty(dtParams.sSearch)) { aaData = aaData.Where(d => d.DatabaseName.Contains(dtParams.sSearch)); filterdCount = aaData.Count(); } /* * Sorting */ var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]); var sortDirection = Request["sSortDir_0"]; // asc or desc Func <EResDatabaseViewModel, string> orderingFunction = (c => sortColumnIndex == 0 ? c.DatabaseID.ToString() : sortColumnIndex == 1 ? c.DatabaseName : sortColumnIndex == 2 ? c.DatabaseTypeName : sortColumnIndex == 3 ? c.DatabaseCost.ToString() : sortColumnIndex == 4 ? c.FundingSource.ToString() : sortColumnIndex == 5 ? c.VendorID.ToString() : c.DatabaseName); if (sortDirection == "asc") { aaData2 = aaData.OrderBy(orderingFunction).ToList(); } else { aaData2 = aaData.OrderByDescending(orderingFunction).ToList(); } aaData2 = aaData2.Skip(dtParams.iDisplayStart).Take(dtParams.iDisplayLength); var list = (from x in aaData2 select new EResDatabaseViewModel { DatabaseID = x.DatabaseID, DatabaseName = x.DatabaseName, DatabaseType = x.DatabaseType, DatabaseTypeName = x.DatabaseTypeName, DatabaseCost = x.DatabaseCost, DatabaseCostString = x.DatabaseCost.ToString("C"), FundingSource = x.FundingSource, FundingSourceName = x.FundingSourceName, VendorID = x.VendorID, VendorName = x.VendorName }).ToList(); return(Json(new { sEcho = dtParams.sEcho, iTotalRecords = totalRecords, iTotalDisplayRecords = filterdCount, aaData = list }, JsonRequestBehavior.AllowGet)); }