/// <summary>
/// 获取gridtable数据源
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sable"></param>
/// <param name="pars">查询参数</param>
/// <param name="selectFields">查询字段</param>
/// <param name="whereObj">参数条件</param>
/// <returns></returns>
public static JsonResultModel <T> GetWidgetsSource <T>(Sqlable sable, GridSearchParams pars, string selectFields = "*", object whereObj = null) where T : class
{
var query = System.Web.HttpContext.Current.Request.QueryString;
Type type = typeof(T);
string tableName = type.Name;
sable = sable.Where(BuildQuery(query));
string orderBy = null;
if (!string.IsNullOrEmpty(pars.sortorder))
{
orderBy = (pars.sortdatafield + " " + pars.sortorder);
}
else
{
orderBy = "getdate()";
}
var rows = sable.SelectToPageList <T>(selectFields, orderBy, pars.pagenum + 1, pars.pagesize, whereObj);
var result = new JsonResultModel <T>()
{
TotalRows = sable.Count(whereObj),
Rows = rows
};
return(result);
}
public JsonResult GetListSourceById(GridSearchParams pars, int whereId)
{
if (pars.sortdatafield == null)
{ //默认按id降序
pars.sortdatafield = "id";
pars.sortorder = "desc";
}
Sqlable sable = ls.GetListSqlable().Where("id=@id");
var model = JQXGrid.GetWidgetsSource<list>(sable, pars, "*", new { id = whereId });//根据grid的参数自动查询
return Json(model, JsonRequestBehavior.AllowGet);
}
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的参数自动查询
GC.Collect();
return Json(model, JsonRequestBehavior.AllowGet);
}
public JsonResult Data(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,"g.*");//根据grid的参数自动查询
return Json(model, JsonRequestBehavior.AllowGet);
}
}