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));
}
}
public ActionResult Index()
{
var adp = new GridDataAdapterSource();
adp.url = "/Grid/Data";
adp.extendData = "a";
var gc = new GridConfig();
gc.gridbuttons = new List <GridButton>()
{
new GridButton()
{
click = "add", name = "addbutton", icon = "jqx-icon-plus", title = "添加"
},
new GridButton()
{
click = "edit", name = "editbutton", icon = "jqx-icon-edit", title = "编辑"
},
new GridButton()
{
click = "del", name = "delbutton", icon = "jqx-icon-delete", title = "删除"
}
};
gc.initRowDetails = "initRowDetails";
gc.pageSize = 20;
gc.width = "80%";
gc.filterMode = FilterModel.advanced;
gc.selectionMode = SelectionMode.multipleRows;
// gc.rowDetails = true;
gc.columns = new List <GridColumn>()
{
new GridColumn()
{
text = "编号", datafield = "id", hidden = true, width = "40px", cellsalign = AlignType.left, datatype = Datatype.dataint
},
new GridColumn()
{
text = "名称", datafield = "name", className = "minwidth", width = "200", cellsalign = AlignType.left, datatype = Datatype.datastring, cellsRenderer = "namefun"
},
new GridColumn()
{
text = "产品名", datafield = "productname", width = "500px", cellsalign = AlignType.left, datatype = Datatype.datastring
},
new GridColumn()
{
text = "数量", datafield = "quantity", cellsalign = AlignType.right, datatype = Datatype.dataint
},
new GridColumn()
{
text = "创建时间", datafield = "date", cellsformat = "yyyy-MM-dd", cellsalign = AlignType.right, datatype = Datatype.datadate
}
};
JQXGrid.PublicMehtod.ColumnsPrependCheckbox(gc.columns);
var grid = JQXGrid.BindGrid("#netgrid", adp, gc);
ViewBag.validationBind = ValidationSugar.GetBindScript("validate_key_grid_index");
return(View(grid));
}
public ActionResult Index()
{
ViewBag.Grid = JQXGrid.BindGrid("#grid", CustomCellGridModel.GetDataAdapterSource(), CustomCellGridModel.GetGridConfig());
return(View());
}
public ActionResult Index()
{
ViewBag.Grid = JQXGrid.BindGrid("#grid", MasterDetailGrid.GetDataAdapterSource(), MasterDetailGrid.GetGridConfig());
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
Grid = JQXGrid.BindGrid("#grid", GetDataAdapterSource(), GetGridConfig()).ToString();
}
