浅谈MVC+EF easyui dataGrid 动态加载分页表格

2020-05-27 17:51:55易采站长站整理

body.contents().find("#roleName").val(rows[i].RoleName);
if (rows[i].RoleRemarks != "-") {
body.contents().find("#remarks").val(rows[i].RoleRemarks);
}
body.contents().find("#isstutas").val(rows[i].IsStatus);
}
});
}

function delRole(i) { //删除用户
var rows = $("#roleGrid").datagrid("getRows");

var postData = {
roleId: rows[i].RoleId
};

layer.confirm('确认删除该角色?', {
btn: ['确认', '取消'], //按钮
shade: false //不显示遮罩
}, function (index) {
$.ajax({
type: "POST",
url: "DeleRole",
data: postData,
success: function (result) {
if (result == "true") {
layer.msg("操作成功!", {
icon: 6,
time: 1000,
}, function () {
$("#roleGrid").datagrid("reload");
layer.close(index);
});
} else if (result == "false") {
layer.msg("操作失败!", { icon: 2 });
} else if (result == "msg") {
layer.msg("系统错误,请联系管理员!", { icon: 0 });
}
}
});
}, function (index) {
layer.close(index);
});
}

然后是html

<table id=”roleGrid”> </table>

最后是控制器的方法(这一部分是最重要的,表格能否显示数据,全看这一部分)


/// <summary>
/// 动态生成表格的数据
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public JsonResult GetRoles(int? page, int? rows)
{
page = page == null ? 1 : page; //第几页
rows = rows == null ? 1 : rows; //行数
List<role> rList = rService.GetAllRoles(Convert.ToInt32(page), Convert.ToInt32(rows));
List<role> roleList = new List<role>();
for (int i = 0; i < rList.Count; i++)
{
role r = new role();
r.RoleId = rList[i].RoleId;
r.RoleName = rList[i].RoleName;
if (string.IsNullOrEmpty(rList[i].RoleRemarks))
{
r.RoleRemarks = "-";
}
else
{
r.RoleRemarks = rList[i].RoleRemarks;
}
r.IsStatus = rList[i].IsStatus;
roleList.Add(r);
}
var json = new
{
total = rService.GetTotal(),
rows = roleList
};
return Json(json, JsonRequestBehavior.AllowGet);
}

最后的最后是控制器相关的方法