public JsonResult GetAllCategorys(string sord = "asc", string sidx = "CategoryName", int page = 1, int rows = 10)
{
IList <object> pros = new List <object>(FindCategoryViewModels(sord, sidx, (page - 1) * rows, rows));
var jsonData = JqGridModel.GridData(page, rows, initCategoryViewModels().Count(), pros);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllUsers(string sord = "asc", string sidx = "UserName", int page = 1, int rows = 10)
{
IList <object> users = new List <object>(_repository.Find(sord, sidx, (page - 1) * rows, rows));
var jsonData = JqGridModel.GridData(page, rows, _repository.Count, users);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult ITArrivalTimeRequestIndex2(string sord = "asc", string sidx = "ProductName", int page = 1,
int rows = 10, bool _search = false, string searchField = "", string searchOper = "", string searchString = "")
{
List <Entities.ImportTrans_main_record> test_JqGrids = _importTrans_main_recordService.getAll();
int count = test_JqGrids.Count();
// var objpros = new List<object>(pros);editArrivalTime
var jsonData = JqGridModel.GridData(page, rows, count, test_JqGrids);
return(Json(jsonData));
}
public JsonResult JqGridIndex2(string sord = "asc", string sidx = "ProductName", int page = 1,
int rows = 10, bool _search = false, string searchField = "", string searchOper = "", string searchString = "")
{
List <Entities.test_JqGrid> test_JqGrids = _itest_JqGridService.getAlltest_JqGrid();
int count = test_JqGrids.Count();
// var objpros = new List<object>(pros);
var jsonData = JqGridModel.GridData(page, rows, count, test_JqGrids);
return(Json(jsonData));
}
public ActionResult GetLogList(JqGridModel.JqGrid jq, PubPage fg)
{
if (jq.page == 0)
{
jq.page = 1;
jq.rows = 10;
jq.sidx = "CreateTime";
jq.sord = "DESC";
}
var list = _iSysLogServices.PageSysLog(fg, jq);
return(Json(JqGridModel.GridData(list.Item1, jq, list.Item2), JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllPros(string sord = "asc", string sidx = "ProductName", int page = 1,
int rows = 10, bool _search = false, string searchField = "", string searchOper = "", string searchString = "")
{
var rawpros = GetRawPros(_search, searchField, searchOper, searchString);
var propertyInfo = typeof(Product).GetProperty(switchSidx(sidx));
Func <Product, object> expn = e => propertyInfo.GetValue(e, null);
var enumerable = rawpros as Product[] ?? rawpros.ToArray();
IEnumerable <Product> pros = sord == "asc" ? enumerable.OrderBy(expn).Skip((page - 1) * rows).Take(rows).ToArray()
: enumerable.OrderByDescending(expn).Skip((page - 1) * rows).Take(rows).ToArray();
var objpros = new List <object>(pros);
var jsonData = JqGridModel.GridData(page, rows, enumerable.Count(), objpros);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}