/// <summary> /// grid数据设置 /// </summary> /// <returns></returns> public static GridDataAdapterSource GetDataAdapterSource() { var adp = new GridDataAdapterSource(); adp.url = "/griddemo/default/GetListSource";//数据源地址 return adp; }
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 static object BindGrid(string gridSelector, GridDataAdapterSource gda, GridConfig gc) { var rootUrl = GetRootURI(); if (rootUrl != "/") { gda.url = rootUrl + "/" + gda.url.TrimStart('/'); } if (gda.datafields == null || gda.datafields.Count == 0) { foreach (var it in gc.columns) { gda.datafields.Add(new GridDatafield() { type = it.datatype, name = it.datafield }); } } StringBuilder gridHtml = new StringBuilder(); gridHtml.AppendFormat(@"var source = {0}", jss.Serialize(gda)); gridHtml.AppendLine(); gridHtml.Append(@" var dataAdapter = new $.jqx.dataAdapter(source, { downloadComplete: function (data) { source.totalrecords = data.TotalRows; }, formatData:" + (!string.IsNullOrEmpty(gda.extendData) ? "function (data) { " + gda.extendData + "(data); return data; }" : "function (data) { return data; }") + @" });"); gridHtml.AppendLine(); gridHtml.AppendFormat(@"$(""{0}"").jqxDataTable(", gridSelector); if (string.IsNullOrEmpty(gc.renderToolbar)) { gc.renderToolbar = "${toolbar}"; } gridHtml.Append(jss.Serialize(gc)); gridHtml.Append(");"); var reval = gridHtml.ToString(); if (gc.editable) { reval = reval.Replace("${updateRow}", @" function (rowId, rowData, commit) {commit(true); }"); } else { reval = reval.Replace("${updateRow}", @" function (rowId, rowData, commit) { }"); } reval = reval .Replace("\"${toolbar}\"", GetToolbar(gridSelector, gc)) .Replace("\"source\":\"dataAdapter\"", "\"source\":dataAdapter") .Replace("\"${localization}\"", "jqxLocalization"); reval += GetCheckFunc(gridSelector); string checkBoxEeventHtml = @" $(""" + gridSelector + @""").on(""click"", ""input:checkbox"", function () { var th = $(this); var isChecked = th.prop(""checked""); if (!isChecked) { $(""" + gridSelector + @""").find(""#jqx_datatable_checkbox_all"").jqxCheckBox(""uncheck""); } }); setTimeout(function () { $(window).resize(); },2000) "; reval = string.Format(@"$(function(){{ {0}; {1} }})", reval, checkBoxEeventHtml); reval = ("<script>\r\n") + reval + @" $(function () { var data = $(""body"").on(""click"", """ + gridSelector + @" .jqx_datatable_checkbox"", function () { if ($(""body"").data(""checkboxloading"") == null) { var th = $(this); var index = th.attr(""data-cbindex""); console.log(index) var num = 0; var setInt = setInterval(function () { $(""" + gridSelector + @" .jqx_datatable_checkbox"").eq(index).prop(""checked"", true); num = num + 100; if (num / 100 == 15) { clearInterval(setInt); } }, 100); } }); setTimeout(function () { $(""body"").data(""checkboxloading"", true); }, 2000); })" + ("\n\r</script>"); reval = FuncAction(reval, @"""cellsRenderer""\:""(.*?)"""); reval = FuncAction(reval, @"""renderer""\:""(.*?)"""); reval = FuncAction(reval, @"""rendered""\:""(.*?)"""); reval = FuncAction(reval, @"""initRowDetails""\:""(.*?)"""); reval = FuncAction(reval, @"""createEditor""\:""(.*?)"""); reval = FuncAction(reval, @"""initEditor""\:""(.*?)"""); reval = FuncAction(reval, @"""getEditorValue""\:""(.*?)"""); reval = FuncAction(reval, @"""ready""\:""(.*?)"""); reval = FuncAction(reval, @"""updateRow""\:""(.*?)"""); return(reval); }
public ActionResult Index() { var adp = new GridDataAdapterSource(); adp.url = "/Grid/Data"; 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.pageSize = 20; gc.width = "80%"; gc.columns = new List<GridColumn>(){ new GridColumn(){ text="编号", datafield="id", width="40px", cellsalign=AlignType.left,datatype=Datatype.dataint }, new GridColumn(){ text="名称", datafield="name", cellsalign=AlignType.left,datatype=Datatype.datastring }, new GridColumn(){ text="产品名", datafield="productname", 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 } }; var grid = JQXGrid.BindGrid("#netgrid", adp, gc); ViewBag.validationBind = ValidationSugar.GetBindScript("validate_key_grid_index"); return View(grid); }
/// <summary> /// grid数据设置 /// </summary> /// <returns></returns> public static GridDataAdapterSource GetDataAdapterSource() { var adp = new GridDataAdapterSource(); adp.url = "/griddemo/ColumnsHierarchies/GetListSource";//数据源地址 return adp; }