public class OrganizationStructureController
: Controller
{
AoutEntities db
= new AoutEntities
();
ReturnListJsonData jsonData
= new ReturnListJsonData
();
public ActionResult Index
() { return View
(); } #region 模糊查询 public ActionResult GetList
(int page, int limit, string name, string code
) { var list
= db
.OrganizationStructure
.Where
(a
=> a
.IsDel
== false
).ToList
(); if
(!string
.IsNullOrEmpty
(name
)) { list
= list
.Where
(a
=> a
.OrgName
.Contains
(name
)).ToList
(); } if
(!string
.IsNullOrEmpty
(code
)) { list
= list
.Where
(a
=> a
.OrgCode
.Contains
(code
)).ToList
(); } var offset
= (page - 1
) * limit; var data
= list
.OrderByDescending
(a
=> a
.ModifyDate
).Skip
(offset
).Take
(limit
); jsonData
.code
= 0; jsonData
.count
= list
.Count; jsonData
.data
= data; jsonData
.msg
= "success"; return Json
(jsonData, JsonRequestBehavior
.AllowGet
); } #endregion #region 添加组织机构 [HttpPost] public ActionResult Add
(OrganizationStructure org
) { try { org
.ID
= Guid
.NewGuid
(); org
.IsDel
= false; org
.CreateDate
= DateTime.Now; org
.ModifyDate
= DateTime.Now; db
.OrganizationStructure
.Add
(org
); db
.SaveChanges
(); jsonData
.code
= 0; jsonData
.msg
= "添加成功"; } catch
(Exception ex
) { jsonData
.code
= 1; jsonData
.msg
= ex
.Message; } return Json
(jsonData
); } #endregion #region 更新组织机构 [HttpPost] public ActionResult Update
(OrganizationStructure org
) { try { var model
= db
.OrganizationStructure
.FirstOrDefault(a
=> a
.ID
== org
.ID && a
.IsDel
== false
); if
(model !
= null
) { model
.OrgName
= org
.OrgName; model
.OrgCode
= org
.OrgCode; model
.Leve
= org
.Leve; model
.ParentId
= org
.ParentId; model
.ModifyDate
= DateTime.Now; db
.SaveChanges
(); jsonData
.code
= 0; jsonData
.msg
= "更新成功"; } else { jsonData
.code
= 1; jsonData
.msg
= "未找到该组织机构"; } } catch
(Exception ex
) { jsonData
.code
= 1; jsonData
.msg
= ex
.Message; } return Json
(jsonData
); } #endregion #region 删除组织机构（软删除） [HttpPost] public ActionResult Delete
(Guid ID
) { try { var model
= db
.OrganizationStructure
.FirstOrDefault(a
=> a
.ID
== ID && a
.IsDel
== false
); if
(model !
= null
) { model
.IsDel
= true; db
.SaveChanges
(); jsonData
.code
= 0; jsonData
.msg
= "删除成功"; } else { jsonData
.code
= 1; jsonData
.msg
= "未找到该组织机构"; } } catch
(Exception ex
) { jsonData
.code
= 1; jsonData
.msg
= ex
.Message; } return Json
(jsonData
); } #endregion
}
前端页面：
@{
Layout
= null;
}
<!DOCTYPE html> <html> <head> <link href
="~/Scripts/layui/css/layui
.css" rel
="stylesheet" /> <script src
="~/Scripts/layui/layui
.js"></script> <script src
="~/Scripts/jquery-3
.4
.1
.js"></script> <style> body { padding
: 10px 20px 20px 20px; width
: 90% }
.but { margin-top
: -5px } </style> </head> <body> <fieldset class
="layui-elem-field"> <legend> <span class
="layui-breadcrumb"> <a href
="">首页</a> <a href
="">组织机构管理</a> </span> </legend> <div class
="layui-field-box"> <div class
="layui-form-item"> <div class
="layui-inline"> <label class
="layui-form-label">机构名称</label> <div class
="layui-input-block"> <input type
="text" name
="name" id
="name" autocomplete
="off" class
="layui-input"> </div> </div> <div class
="layui-inline"> <label class
="layui-form-label">机构代码</label> <div class
="layui-input-inline"> <input type
="text" name
="code" id
="code" autocomplete
="off" class
="layui-input"> </div> </div> <button type
="button" class
="layui-btn layui-btn-radius but" id
="searchButton" onclick
="Search
()"><i class
="layui-icon layui-icon-search"></i>查询</button> <button type
="button" class
="layui-btn layui-bg-blue but" onclick
="AddOrg
()"><i class
="layui-icon layui-icon-addition"></i>添加</button> </div> </div> </fieldset> <fieldset class
="layui-elem-field"> <table class
="layui-hide" id
="test" lay-filter
="test"></table> <script type
="text/html" id
="toolDemo"> <div class
="layui-clear-space"> <a class
="layui-btn layui-btn-xs" lay-event
="edit" id
="Edit"><i class
="layui-icon layui-icon-edit"></i>编辑</a> <a class
="layui-btn layui-btn-xs layui-bg-orange" lay-event
="del" id
="del"><i class
="layui-icon layui-icon-clear"></i>删除</a> </div> </script> </fieldset> <script> var tableIns; layui
.use
(['table', 'layer', 'form'], function
() { var table
= layui
.table; var layer
= layui
.layer; // 创建渲染实例 tableIns
= table
.render
({ elem
: '#test', url
: '/OrganizationStructure/GetList', page
: true, cols
: [[ { type
: 'numbers', width
: '15%', title
: '序列号' }, { field
: 'OrgName', width
: '20%', title
: '机构名称' }, { field
: 'OrgCode', width
: '20%', title
: '机构代码' }, { field
: 'Leve', width
: '10%', title
: '级别' }, { field
: 'ParentId', width
: '15%', title
: '父节点ID' }, { field
: 'ModifyDate', width
: '20%', title
: '修改时间', templet
: function
(d
) { return formatDate
(d
.ModifyDate
); } }, { title
: '操作', width
: '25%', templet
: '#toolDemo' } ]], }
); // 编辑删除事件 table
.on
('tool
(test
)', function
(obj
) { var data
= obj
.data; if
(obj
.event
=== 'edit'
) { EditOrg
(data
); } else if
(obj
.event
=== 'del'
) { DeleteOrg
(data, obj
); } }
); }
); function formatDate
(dateStr
) { if
(!dateStr
) return ''; var timestamp
= parseInt
(dateStr
.replace
(/\/Date$
(\d+
)$\//, '$1'
)); var date
= new Date
(timestamp
); return date
.getFullYear
() + '-' +
('0' +
(date
.getMonth
() + 1
)).slice
(-2
) + '-' +
('0' + date
.getDate()).slice
(-2
); } // 添加组织机构弹窗 function AddOrg
() { layer
.open
({ type
: 1, title
: '添加组织机构', content
: ` <div style
="padding
:20px"> <div class
="layui-form-item"> <label class
="layui-form-label">机构名称</label> <div class
="layui-input-block"> <input type
="text" id
="add_name" class
="layui-input"> </div> </div> <div class
="layui-form-item"> <label class
="layui-form-label">机构代码</label> <div class
="layui-input-block"> <input type
="text" id
="add_code" class
="layui-input"> </div> </div> <div class
="layui-form-item"> <label class
="layui-form-label">级别</label> <div class
="layui-input-block"> <input type
="number" id
="add_leve" class
="layui-input"> </div> </div> <div class
="layui-form-item"> <label class
="layui-form-label">父节点ID</label> <div class
="layui-input-block"> <input type
="text" id
="add_parentId" class
="layui-input"> </div> </div> </div> `, btn
: ['保存', '取消'], yes
: function
(index
) { $
.post
('/OrganizationStructure/Add', { OrgName
: $
('#add_name'
).val
(), OrgCode
: $
('#add_code'
).val
(), Leve
: $
('#add_leve'
).val
(), ParentId
: $
('#add_parentId'
).val
() }, function
(res
) { if
(res
.code
== 0
) { layer
.close
(index
); Search
(); // 刷新列表 } else { layer
.msg
('操作失败：' + res
.msg
); } }
); } }
); } // 编辑组织机构弹窗 function EditOrg
(data
) { layer
.open
({ type
: 1, title
: '编辑组织机构', content
: ` <div style
="padding
:20px"> <div class
="layui-form-item"> <label class
="layui-form-label">机构名称</label> <div class
="layui-input-block"> <input type
="text" id
="edit_name" value
="${data
.OrgName}" class
="layui-input"> </div> </div> <div class
="layui-form-item"> <label class
="layui-form-label">机构代码</label> <div class
="layui-input-block"> <input type
="text" id
="edit_code" value
="${data
.OrgCode}" class
="layui-input"> </div> </div> <div class
="layui-form-item"> <label class
="layui-form-label">级别</label> <div class
="layui-input-block"> <input type
="number" id
="edit_leve" value
="${data
.Leve}" class
="layui-input"> </div> </div> <div class
="layui-form-item"> <label class
="layui-form-label">父节点ID</label> <div class
="layui-input-block"> <input type
="text" id
="edit_parentId" value
="${data
.ParentId}" class
="layui-input"> </div> </div> </div> `, btn
: ['更新', '取消'], yes
: function
(index
) { $
.post
('/OrganizationStructure/Update', { ID
: data
.ID, OrgName
: $
('#edit_name'
).val
(), OrgCode
: $
('#edit_code'
).val
(), Leve
: $
('#edit_leve'
).val
(), ParentId
: $
('#edit_parentId'
).val
() }, function
(res
) { if
(res
.code
== 0
) { layer
.close
(index
); Search
(); } else { layer
.msg
('更新失败：' + res
.msg
); } }
); } }
); } // 删除组织机构 function DeleteOrg
(data, obj
) { layer
.confirm
('真的删除行 [' + data
.OrgName + '] 么', function
(index
) { $
.post
('/OrganizationStructure/Delete', { ID
: data
.ID }, function
(res
) { if
(res
.code
== 0
) { obj
.del
(); layer
.close
(index
); } else { layer
.msg
('删除失败：' + res
.msg
); } }
); }
); } // 查询重载 function Search
() { var nameVal
= $
('input[name
="name"]'
).val
().trim
(); var codeVal
= $
('input[name
="code"]'
).val
().trim
(); tableIns
.reload
({ where
: { name
: nameVal, code
: codeVal }, page
: { curr
: 1 } // 重置分页 }
); } </script> </body> </html> 帮我整理这两个
博客指出MyBatis生成的SQL中使用GETDATE()获取SQL服务器时间。若SQL服务器与网站服务器时间不一致，会导致判断不成立，如使用_groupStartDateTime < DateTime.Now生成的SQL判断就可能出现问题。
扫一扫
392
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
