前端部分:
表格
<div class="x-body">
<xblock>
<div class="demoTable">
<button class="layui-btn layui-btn-danger" data-type="getCheckdata"><i class="layui-icon"></i>批量删除</button>
<button class="layui-btn" onclick="x_admin_show('添加','./AddMessage',500,450)"><i class="layui-icon"></i>添加</button>
<div class="layui-inline">
<input class="layui-input" name="ID" id="demoReload" autocomplete="off" placeholder="请输入姓名">
</div>
<button class="layui-btn" data-type="reload">搜索</button>
</div>
</xblock>
<table class="layui-hide" id="LAY_table_user" lay-filter="user"></table>
</div>
<div id="add-main" class="x-body" style="display: none;">
<form class="layui-form" id="add-form" action="">
<input type="text" name="ID" style="width: 240px;display:none;" class="layui-input">
<div class="layui-form-item center">
<label class="layui-form-label" style="width: 100px">名字</label>
<div class="layui-input-block">
<input type="text" name="StuName" required value="" style="width: 240px" lay-verify="required" placeholder="请输入信息" autocomplete="off" class="layui-input">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label" style="width: 100px">性别</label>
<div class="layui-input-block">
<input type="text" name="StuSex" required style="width: 240px" lay-verify="required" placeholder="请输入信息" autocomplete="off" class="layui-input">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label" style="width: 100px">年龄</label>
<div class="layui-input-block">
<input type="text" name="StuAge" required style="width: 240px" lay-verify="required" placeholder="请输入信息" autocomplete="off" class="layui-input">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label" style="width: 100px">籍贯</label>
<div class="layui-input-block">
<input type="text" name="StuArea" required style="width: 240px" lay-verify="required" placeholder="请输入信息" autocomplete="off" class="layui-input">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label" style="width: 100px">电话</label>
<div class="layui-input-block">
<input type="text" name="StuPhone" required style="width: 240px" lay-verify="required" placeholder="请输入信息" autocomplete="off" class="layui-input">
</div>
</div>
<div class="layui-form-item">
<div class="layui-input-block">
<button class="layui-btn" lay-submit lay-filter="save">立即提交</button>
<button type="reset" class="layui-btn layui-btn-primary" id="closeBtn">重置</button>
</div>
</div>
</form>
</div>
设置单元格样式
格式化
<script type="text/html" id="sexTpl">
{{# if(d.StuSex === '女'){ }}
<span style="color: #F581B1;">{{ d.StuSex }}</span>
{{# } else { }}
{{ d.StuSex }}
{{# } }}
</script>
添加链接
<script type="text/html" id="usernameTpl">
<a href="http://www.baidu.com" class="layui-table-link" target="_blank">{{ d.StuName }}</a>
</script>
js部分
<script type="text/html" id="barDemo">
<a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">查看</a>
<a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
<script type="text/javascript">
layui.use('table', function () {
var table = layui.table;
var form = layui.form;
//方法级渲染
var tableIns = table.render({
elem: '#LAY_table_user'
//, toolbar: '#toolbarDemo'
, url: '/Home/GetData'
, cols: [[
{ checkbox: true, fixed: true, width: 27, rowspan: 2 }
, { field: 'ID', width: 80, title: '编号', edit: 'text', sort: true, rowspan: 2 }
, { field: 'StuMessage', title: '个人信息', align: 'center', colspan: 3 }
, { field: 'StuArea', width: 180, title: '籍贯', edit: 'text', align: 'center', rowspan: 2 }
, { field: 'StuPhone', width: 180, title: '电话', edit: 'text', align: 'center', rowspan: 2 }
, { field: 'StuEdit', width: 180, title: '操作', align: 'center', fixed: 'right', toolbar: '#barDemo', rowspan: 2 }
], [
{ field: 'StuName', width: 180, title: '名字', edit: 'text', align: 'center', templet: '#usernameTpl' }
, { field: 'StuSex', width: 180, title: '性别', edit: 'text', align: 'center', templet: '#sexTpl' }
, { field: 'StuAge', width: 180, title: '年龄', edit: 'text', align: 'center' }
]]
, id: 'testReload'
, page: {
layout: ['limit', 'count', 'prev', 'page', 'next', 'skip'] //自定义分页布局
}
//, height: 450
//, width: 900
, method: 'post'
});
var $ = layui.$, active = {
reload: function () {
var demoReload = $('#demoReload');
//执行重载
table.reload('testReload', {
page: {
curr: 1 //重新从第 1 页开始
}
, where: {
name: demoReload.val()
}
, url: '/Home/SearchData'
, method: 'post'
});
},
getCheckdata: function () {
var checkStatus = table.checkStatus('testReload')
, data = checkStatus.data;
var arr = [];
if (data.length < 0 || data.length == 0) {
layer.msg('至少选择一条数据', { icon: 2 });
return;
}
else {
for (var i = 0; i < data.length; i++) {
arr.push(data[i]);
}
layer.confirm('确定要删除吗?', function (index) {
$.ajax({
type: 'post',
url: '/Home/DeleData', // ajax请求路径
data: { data: JSON.stringify(arr) },
success: function (r) {
if (r > 0) {
layer.msg('删除成功');
tableIns.reload();
}
else {
layer.msg('删除失败');
}
}
});
});
}
}
};
$('.demoTable .layui-btn').on('click', function () {
var type = $(this).data('type');
active[type] ? active[type].call(this) : '';
});
//监听单元格
table.on('edit(user)', function (obj) {
var value = obj.value //得到修改后的值
, data = obj.data //得到所在行所有键值
, field = obj.field; //得到字段
layui.use('jquery', function () {
var $ = layui.$;
$.ajax({
type: 'post',
url: '/Home/EditData', // ajax请求路径
data: {
id: data.ID,
field: field,
value: value
},
success: function (data) {
if (data > 0) {
layer.msg('修改成功');
tableIns.reload();
}
else {
layer.msg('修改失败');
}
}
});
});
return false;
});
var index0pen;
//监听工具条
table.on('tool(user)', function (obj) {
var data = obj.data;
if (obj.event === 'detail') {
layer.msg('ID:' + data.ID + ' 的查看操作');
} else if (obj.event === 'del') {
layer.confirm('真的删除行' + data.StuName, function (index) {
$.ajax({
url: '/Home/DeleData',
type: "POST",
data: { id: data.ID },
success: function (r) {
if (r > 0) {
layer.msg("删除成功", { icon: 6 });
tableIns.reload();
} else {
layer.msg("删除失败", { icon: 5 });
}
}
});
});
} else if (obj.event === 'edit') {
SetFromValues($("#add-main"), data);
index0pen = layer.open({
type: 1,
title: "编辑",
area: ['500px', '450px'],
content: $("#add-main"),
});
}
});
//监听提交
form.on('submit(save)', function (data) {
var datas = data.field;
$.ajax({
type: 'post',
url: '/Home/EditStudent', // ajax请求路径
data: datas,
success: function (r) {
if (r > 0) {
layer.alert('修改成功', { icon: 6 }, function () {
var index = layer.index;
layer.close(index0pen);
layer.close(index);
});
}
else {
layer.msg('修改失败', { icon: 5 });
}
}
});
return false;
});
});
//弹传值
function SetFromValues(el, data) {
for (var p in data) {
el.find(":input[name='" + p + "']").val(data[p]);
}
}
后端部分:
public ActionResult GetData(int page, int limit)
{
Dictionary<String, Object> rsMap = new Dictionary<String, Object>();
using (MySqlContext db = new MySqlContext())
{
int Total_ = db.Set<Student>().Where(c => c.ID > 0).Count();
var students = getPageDate<Student, int>(c => new { c.ID, c.StuAge, c.StuArea, c.StuName, c.StuPhone, c.StuSex }, c => c.ID > 0, c => c.ID, page, limit, out Total_);
rsMap["count"] = Total_;
rsMap["code"] = 0;
rsMap["msg"] = "detail";
rsMap["data"] = students;
return Content(JsonConvert.SerializeObject(rsMap));
}
}
public List<dynamic> getPageDate<T, TKey>(Expression<Func<T, dynamic>> select, Expression<Func<T, bool>> where, Expression<Func<T, TKey>> order, int pageIndex, int pageSize, out int Total)
where T : class
{
using (MySqlContext db = new MySqlContext())
{
Total = db.Set<T>().Where(where).Count();
var list = db.Set<T>().Where(where).OrderBy(order).Select(select).Skip((pageIndex - 1) * pageSize).Take(pageSize);
return list.ToList();
}
}
public ActionResult EditData(int id, string field, string value)
{
int result = 0;
using (MySqlContext db = new MySqlContext())
{
var hasStudent = db.Student.Where(r => r.ID == id).FirstOrDefault();
if (hasStudent !=null)
{
if (field == "StuName")
{
hasStudent.StuName = value;
}
else if (field == "StuSex")
{
hasStudent.StuSex = value;
}else if (field == "StuAge")
{
hasStudent.StuAge = value;
}
else if (field == "StuArea")
{
hasStudent.StuArea = value;
}
else if (field == "StuPhone")
{
hasStudent.StuPhone = value;
}
result = db.SaveChanges();
}
}
return Content(result.ToString());
}
public ActionResult DeleData(int id)
{
int result = 0;
using (MySqlContext db = new MySqlContext())
{
var hasStudent = db.Student.Where(r => r.ID == id).FirstOrDefault();
if (hasStudent != null)
{
db.Student.Remove(hasStudent);
result = db.SaveChanges();
}
}
return Content(result.ToString());
}
public ActionResult EditStudent(Student data)
{
int result = 0;
using (MySqlContext db = new MySqlContext())
{
var hasStudent = db.Student.Where(r => r.ID == data.ID).FirstOrDefault();
if (hasStudent != null)
{
hasStudent.StuAge = data.StuAge;
hasStudent.StuArea = data.StuArea;
hasStudent.StuName = data.StuName;
hasStudent.StuPhone = data.StuPhone;
hasStudent.StuSex = data.StuSex;
result = db.SaveChanges();
}
}
return Content(result.ToString());
}
[HttpPost]
public ActionResult SearchData(int page, int limit)
{
Dictionary<String, Object> rsMap = new Dictionary<String, Object>();
using (MySqlContext db = new MySqlContext())
{
string key = Request["name"].ToString();//接收值
int Total_ = db.Set<Student>().Where(c => c.StuName.Contains(key)).Count();
var students = getPageDate<Student, int>(c => new { c.ID, c.StuAge, c.StuArea, c.StuName, c.StuPhone, c.StuSex }, c => c.StuName.Contains(key), c => c.ID, page, limit, out Total_);
rsMap["count"] = Total_;
rsMap["code"] = 0;
rsMap["msg"] = "detail";
rsMap["data"] = students;
return Content(JsonConvert.SerializeObject(rsMap));
}
}
[HttpPost]
public ActionResult AddStudent(Student data)
{
int result = 0;
using (MySqlContext db = new MySqlContext())
{
db.Student.Add(data);
result = db.SaveChanges();
}
return Content(result.ToString());
}
[HttpPost]
public ActionResult DeleData(string data)
{
int result = 0;
JArray studentID = JArray.Parse(data);
using (MySqlContext db = new MySqlContext())
{
foreach(var items in studentID)
{
var stuID = items["ID"].ToString();
var student = db.Student.Find(Convert.ToInt32(stuID));
if (student != null)
{
db.Student.Remove(student);
result = db.SaveChanges();
}
}
}
return Content(result.ToString());
}
每天学习一点记录一点进步一点