public JsonResult GetListSource(GridSearchParams pars)
{
if (pars.sortdatafield == null)
{ //默认按id降序
pars.sortdatafield = "id";
pars.sortorder = "desc";
}
Sqlable sable = ls.GetListSqlable();
var model = JQXGrid.GetWidgetsSource <list>(sable, pars, "*");//根据grid的参数自动查询
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult DataChild(GridSearchParams pars)
{
using (SqlSugarClient db = SugarDao.GetInstance())
{
if (pars.sortdatafield == null)
{ //默认按id降序
pars.sortdatafield = "id";
pars.sortorder = "desc";
}
Sqlable sable = db.Sqlable().Form <GridTable>("g"); //查询表的sqlable对象
var model = JQXGrid.GetWidgetsSource <Models.GridTable>(sable, pars, "*"); //根据grid的参数自动查询
return(Json(model, JsonRequestBehavior.AllowGet));
}
}
