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