public static void Init()
{
ValidationSugar.Init("validate_key_grid_index",
ValidationSugar.CreateOptionItem().Set("name", true /*是否必填*/, "名称").AddRegex(".{5,15}", "长度为5-15字符").ToOptionItem(),
ValidationSugar.CreateOptionItem().Set("quantity", true, "数量").Add(ValidationSugar.OptionItemType.Int, "请输入整数").ToOptionItem(),
ValidationSugar.CreateOptionItem().Set("date", true /*是否必填*/, "日期").Add(ValidationSugar.OptionItemType.Date, "格式为yyyy-MM-dd").ToOptionItem()
);
}
public JsonResult Edit(GridTable gt)
{
using (SqlSugarClient db = SugarDao.GetInstance())
{
ActionResultModel <string> model = new ActionResultModel <string>();
string message = string.Empty;
var isValid = ValidationSugar.PostValidation("validate_key_grid_index", out message);
if (isValid)//后台验证数据完整性
{
model.isSuccess = db.Update <GridTable>(gt, it => it.id == gt.id);
model.responseInfo = model.isSuccess ? "编辑成功" : "编辑失败";
}
else
{
model.isSuccess = false;
model.responseInfo = message;
}
return(Json(model));
}
}
public JsonResult Add(GridTable gt)
{
using (SqlSugarClient db = SugarDao.GetInstance())
{
string message = string.Empty;
var isValid = ValidationSugar.PostValidation("validate_key_grid_index", out message);
ActionResultModel <string> model = new ActionResultModel <string>();
if (isValid)//后台验证数据完整性
{
model.isSuccess = db.Insert(gt) != DBNull.Value;
model.responseInfo = model.isSuccess ? "添加成功" : "添加失败";
}
else
{
model.isSuccess = false;
model.responseInfo = message;
}
return(Json(model));
}
}
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));
}
