WebApi+Layui增删改查

编程入门行业动态更新时间:2024-10-26 06:29:27

WebApi+Layui增删改查

 <script type="text/html" id="toolbarDemo"><div class="layui-btn-container"><button class="layui-btn layui-btn-warm  site-demo-active" lay-event="add">新增</button><button class="layui-btn layui-btn-normal  site-demo-active" lay-event="sq">授权</button><button class="layui-btn" lay-event="delete" style="background: #FF5722;">删除</button></div></script><script type="text/html" id="tool"><!--{{ d.A_Id }}-->{{#  if(d.A_Id == "" || d.A_Id == null){ }}<a class="layui-btn layui-btn-xs" lay-event="SAuthority" id="shouquan">授权</a><a class="layui-btn layui-btn-xs" lay-event="UpdAuthority">修改权限</a>{{#  } else { }}<a class="layui-btn layui-btn-xs" lay-event="UpdAuthority">修改权限</a>{{#  }}}</script><script type="text/html" id="bar"><a class="layui-btn layui-btn-xs" lay-event="edit">修改</a><a class="layui-btn layui-btn-xs" lay-event="del">删除</a><a class="layui-btn layui-btn-xs" lay-event="CK">查看</a></script><table class="layui-hide" id="RoleTB" lay-filter="test"></table>

<script type="text/javascript">layui.use(['table'], function () {var table = layui.table;var element = layui.element;//方法级渲染table.render({elem: '#RoleTB',toolbar: '#toolbarDemo', height: 'full-50',even: true, id: 'RoleTBList', limit: defaultpagesize, url: Url + "/UserInfo/RoleAuthority/GetRoleList",parseData: function (res) {  //处理返回的数据if (res.result) {return {"code": 0, //解析接口状态"msg": res.setmessage, //解析提示文本"count": res.totlecount, //解析数据长度"data": res.data //解析数据列表};}else {layer.msg(res.setmessage);return {"code": 0, //解析接口状态"msg": res.setmessage, //解析提示文本"count": 0, //解析数据长度"data": null //解析数据列表};}},cols: [[{type: 'checkbox',width: 70},{field: 'R_Id',title: '角色ID',width: 300},{field: 'R_Name',title: '角色名称',width: 300},{title: '权限操作',align: 'center',toolbar: "#tool"},{field: '',width: 300,title: '详情',align: 'center',toolbar: "#bar"}]],page: true //开启分页});//监听工具事件table.on('tool(test)', function (obj) {var data = obj.data;  //获得当前行数据$ = layui.jquery;if (obj.event === 'del') {layer.confirm('真的删除此行么？', function (index) {var data = obj.data;var kk = data['theSer'];$.ajax({dataType: "Json",type: "post",url: Url + "/UserInfo/RoleAuthority/DeleteRoles",data: { "": kk },async: false,success: function (data) {if (data != null) {layer.msg("删除成功", {time: 2000,//显示的时间为2秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('删除失败');}},error: function (XMLHttpRequest, textStatus, errorThrown) {layer.msg('删除失败');}})});}else if (obj.event === 'edit') {var theSer = obj.data['theSer'];var R_Id = obj.data['R_Id'];var R_Name = obj.data['R_Name'];layui.use(['layer', 'table', "laypage", "jquery"], function () {var layer = layui.layer //弹层$("#R_Name").val(R_Name);layer.open({id: 'add',type: 1,title: '修改角色名称',area: ['300px', '280px'],shadeClose: true, //点击遮罩关闭btn: ['确定', '取消'],yes: function () {var json = {};json.theSer = theSer;var id = $("#R_Id").val();if (id == "" || id == null || id == undefined) {layer.msg("角色ID不能为空！");return;} else {json.R_Id = id;}var name = $("#R_Name").val();if (name == "" || name == null || name == undefined) {layer.msg("角色名称不能为空！");return;} else {json.R_Name = name;}$.post(Url + "/UserInfo/RoleAuthority/UpdRoles", json,function (data) {if (data > 0) {layer.msg("角色修改成功！", {time: 2000,//显示的时间为2秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('角色修改失败！');}async: false});},//关闭所有弹框btn2: function () {layer.closeAll();},content: '<div id="content">' + '<div class="layui-form-item" style="margin-left:-25px;margin-top: 30px;"><label class="layui-form-label">角色ID:</label><div class="layui-input-block"><input type="text" name="R_Id" lay-verify="title" autocomplete="off" class="layui-input" id="R_Id"></div></div>' +'<div class="layui-form-item" style="margin-left:-25px;margin-top: 30px;"><label class="layui-form-label">角色名称:</label><div class="layui-input-block"><input type="text" name="R_Name" lay-verify="title" autocomplete="off" class="layui-input" id="R_Name"></div></div>' + '</div>'})$("#R_Id").val(R_Id);$("#R_Name").val(R_Name);})}else if (obj.event === 'CK') {var R_Name = obj.data['R_Name'];layui.use(['layer', 'table', "laypage", "jquery"], function (data) {var layer = layui.layer //弹层GetTreeList(R_Name);layer.open({id: 'FPRole',type: 1,title: '权限列表',area: ['500px', '700px'],shadeClose: true, //点击遮罩关闭content: '<ul id="Treeview" class="ztree demo-tree layui-anim layui-anim-upbit"></ul>'})});}else if (obj.event === 'SAuthority') {var R_Name = obj.data['R_Name'];var R_Id = obj.data['R_Id']layui.use(['layer', 'table', "laypage", "jquery"], function () {var layer = layui.layer //弹层DataList();layer.open({id: 'FPRole',type: 1,title: '分配权限',area: ['500px', '700px'],shadeClose: true, //点击遮罩关闭btn: ['确定', '取消'],yes: function () {var treeObj = $.fn.zTree.getZTreeObj("tree");var nodes = treeObj.getCheckedNodes(true);A_Id = "";for (var i = 0; i < nodes.length; i++) {A_Id += nodes[i].theSer + ",";}if (A_Id.length > 0) {A_Id = A_Id.substr(0, A_Id.length - 1);}var json = {};json.R_Name = R_Name;json.R_Id = R_Id;json.A_Id = A_Id;$.post(Url + "/UserInfo/RoleAuthority/FPRoles", json,function (data) {if (data > 0) {layer.msg("角色权限成功！", {time: 2000,//显示的时间为2秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('角色权限失败！');}async: false});},//关闭所有弹框btn2: function () {layer.closeAll();},content: '<ul id="tree" class="ztree demo-tree layui-anim layui-anim-upbit"></ul>',})})}//修改权限else if (obj.event === 'UpdAuthority') {var theSer = obj.data['theSer'];var R_Id = obj.data['R_Id'];var R_Name = obj.data['R_Name'];layui.use(['layer', 'table', "laypage", "jquery"], function () {var layer = layui.layer //弹层TreeView(theSer);layer.open({id: 'UpdQX',type: 1,title: '修改权限',area: ['500px', '700px'],shadeClose: true, //点击遮罩关闭btn: ['修改', '取消'],yes: function () {var treeObj = $.fn.zTree.getZTreeObj("ztreelist");var nodes = treeObj.getCheckedNodes(true);A_Id = "";for (var i = 0; i < nodes.length; i++) {A_Id += nodes[i].theSer + ",";}if (A_Id.length > 0) {A_Id = A_Id.substr(0, A_Id.length - 1);}var json = {};json.R_Name = R_Name;if (A_Id == "" || A_Id == null) { json.A_Id = ""; }else { json.A_Id = A_Id }json.R_Id = R_Id;$.post(Url + "/UserInfo/RoleAuthority/FPRoles", json,function (data) {if (data > 0) {layer.msg("角色权限修改成功！", {time: 2000,//显示的时间为2秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('角色权限修改失败！');}async: false});},//关闭所有弹框btn2: function () {layer.closeAll();},content: '<ul id="ztreelist" class="ztree demo-tree layui-anim layui-anim-upbit"></ul>',})})}});//监听头工具栏事件toolbartable.on('toolbar(test)', function (obj) {var checkStatus = table.checkStatus(obj.config.id);var data = checkStatus.data; 			//获取选中的数据var tr = data.tr;					//获得当前行 tr 的DOM对象switch (obj.event) {case 'add':layui.use(['layer', 'table', "laypage", "jquery"], function () {var layer = layui.layer //弹层layer.open({id: 'add',type: 1,title: '添加角色',area: ['300px', '280px'],shadeClose: true, //点击遮罩关闭btn: ['确定', '取消'],yes: function () {var json = {};var id = $("#R_Id").val();if (id == "" || id == null || id == undefined) {layer.msg("角色ID不能为空！");return;} else {json.R_Id = id;}var name = $("#R_Name").val();if (name == "" || name == null || name == undefined) {layer.msg("角色名称不能为空！");return;} else {json.R_Name = name;}$.post(Url + "/UserInfo/RoleAuthority/AddRoles", json,function (data) {if (data > 0) {layer.msg("角色添加成功！", {time: 2000,//显示的时间为2秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('角色添加失败！');}async: false});},//关闭所有弹框btn2: function () {layer.closeAll();},content: '<div id="content">' + '<div class="layui-form-item" style="margin-left:-25px;margin-top: 30px;"><label class="layui-form-label">角色ID:</label><div class="layui-input-block"><input type="text" name="R_Id" lay-verify="title" autocomplete="off" class="layui-input" id="R_Id"></div></div>' +'<div class="layui-form-item" style="margin-left:-25px;margin-top: 30px;"><label class="layui-form-label">角色名称:</label><div class="layui-input-block"><input type="text" name="R_Name" lay-verify="title" autocomplete="off" class="layui-input" id="R_Name"></div></div>' + '</div>'})})break;//批量授权case 'sq':if (data.length === 0) {layer.msg('请选择要分配权限的角色！');}else {var arr = [];var str = "";for (var i = 0; i < data.length; i++) {var kk = data[i]['R_Id'];arr.push(kk);}for (var i = 0; i < arr.length; i++) {str += arr[i] + ",";}if (str.length > 0) {str = str.substr(0, str.length - 1);}var arrname = [];var strname = "";for (var i = 0; i < data.length; i++) {var kk = data[i]['R_Name'];arrname.push(kk);}for (var i = 0; i < arrname.length; i++) {strname += arrname[i] + ",";}if (strname.length > 0) {strname = strname.substr(0, strname.length - 1);}layui.use(['layer', 'table', "laypage", "jquery"], function () {var layer = layui.layer //弹层DataList();layer.open({id: 'FPRole',type: 1,title: '分配权限',area: ['500px', '700px'],shadeClose: true, //点击遮罩关闭btn: ['确定', '取消'],yes: function () {var treeObj = $.fn.zTree.getZTreeObj("tree");var nodes = treeObj.getCheckedNodes(true);A_Id = "";for (var i = 0; i < nodes.length; i++) {A_Id += nodes[i].theSer + ",";}if (A_Id.length > 0) {A_Id = A_Id.substr(0, A_Id.length - 1);}var json = {};json.R_Name = strname;json.A_Id = A_Id;json.R_Id = str;$.post(Url + "/UserInfo/RoleAuthority/FPRoles", json,function (data) {if (data > 0) {layer.msg("角色权限成功！", {time: 2000,//显示的时间为2秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('角色权限失败！');}async: false});},//关闭所有弹框btn2: function () {layer.closeAll();},content: '<ul id="tree" class="ztree demo-tree layui-anim layui-anim-upbit"></ul>',})})}break;case 'delete':console.log(data)if (data.length === 0) {layer.msg('请选择一行');} else {layer.confirm('确定删除吗', function () {var arr = [];var str = "";for (var i = 0; i < data.length; i++) {var kk = data[i]['theSer'];arr.push(kk);}for (var i = 0; i < arr.length; i++) {str += arr[i] + ",";}//去掉最后一个逗号(如果不需要去掉，就不用写)if (str.length > 0) {str = str.substr(0, str.length - 1);}$.ajax({dataType: "Json",type: "post",url: Url + "/UserInfo/RoleAuthority/DeleteRoles",data: { "": str },async: false,success: function (data) {if (data != false) {layer.msg("删除成功", {time: 2000,//显示的时间为3秒end: function () {location.reload();//重新加载当前页面}});} else {layer.msg('删除失败');}},error: function (XMLHttpRequest, textStatus, errorThrown) {layer.msg('删除失败');}})return false;})}break;case 'isAll':layer.msg(checkStatus.isAll ? '全选' : '未全选');break;};});$('.demoTable .layui-btn').on('click', function () {var type = $(this).data('type');active[type] ? active[type].call(this) : '';});});var settingss = {view: {selectedMulti: false},data: {simpleData: {open: true,iconOpen: true,selectedMulti: true,showIcon: true,showLine: true,enable: true,idKey: "A_Id",pIdKey: "A_FatherId",rootPId: -1,},key: {name: "A_Name",url: "url",checked: "isChecked",editNameSelectAll: true,showRemoveBtn: true,removeTitle: "删除节点",renameTitle: "编辑节点名称",showRenameBtn: true,}},check: {enable: true,chkStyle: "checkbox",    //复选框nocheckInherit: true,isParent: true,},};function DataList() {$.ajax({type: "get",url: Url + "/UserInfo/RoleAuthority/GetListTree",//url: Url + "/UserInfo/RoleAuthority/GetData",dataType: 'json',async: true,success: function (response) {console.log(response);var zNodes = response;zTreeObj = $.fn.zTree.init($("#tree"), settingss, zNodes); //初始化树//默认展开一二级菜单fillter(zTreeObj);$.fn.zTree.getZTreeObj("A_Id");//加载时展开所有节点zTreeObj.expandAll(true);}})};function fillter(zTreeObj) {var nodeList = zTreeObj.getNodes();　　　　　//展开第一个根节点for (var i = 0; i < nodeList.length; i++)   //设置节点展开第二级节点{zTreeObj.expandNode(nodeList[i], true, false, true);nodeList[i].children;}}//显示已经分配的权限function GetTreeList(name) {$.ajax({type: "get",url: Url + "/UserInfo/RoleAuthority/QXTreeData",dataType: 'json',data: { R_Name: name },async: true,success: function (response) {var zNodes = response;var list = zTreeObj = $.fn.zTree.init($("#Treeview"), setting, zNodes); //初始化树//默认展开一二级菜单//fillter(zTreeObj);//$.fn.zTree.getZTreeObj("A_Id");list.expandAll(true);}})};var setting = {view: {selectedMulti: false},data: {simpleData: {open: true,iconOpen: true,selectedMulti: true,showIcon: true,showLine: true,enable: true,idKey: "A_Id",pIdKey: "A_FatherId",rootPId: -1,},key: {name: "A_Name",url: "url",checked: "isChecked",editNameSelectAll: true,showRemoveBtn: true,removeTitle: "删除节点",renameTitle: "编辑节点名称",showRenameBtn: true,}},check: {nocheckInherit: true,isParent: true,},};function TreeView(id) {$.ajax({type: "get",url: Url + "/UserInfo/RoleAuthority/UpdTree",data: { id: id },dataType: 'json',async: true,success: function (response) {$.get(Url + "/UserInfo/RoleAuthority/GetListTree",function (data) {console.log(data);zTreeObj = $.fn.zTree.init($("#ztreelist"), settingss, data); //初始化树//加载时展开所有节点zTreeObj.expandAll(true);zTree = $.fn.zTree.getZTreeObj("ztreelist");for (var i = 0; i < response.length; i++) {zTree.checkNode(zTree.getNodeByParam("A_Id", response[i].A_Id), true);}})}})};
</script>


```csharp[HttpGet]public HttpResponseMessage GetList(){HttpContext context = HttpContext.Current;var pagesize = Convert.ToInt32(context.Request.QueryString["limit"].ToString());var pageindex = Convert.ToInt32(context.Request.QueryString["page"].ToString());UserGetData user = new UserGetData();int count = 0;var list = user.GetTable(pageindex, pagesize, "", "", out count);if (list != null && list.Count > 0){return SuccNo.SuccListReturn(list, count);}else{return SuccNo.NoListReturn();}}//模糊查询[HttpGet]public object search(){HttpContext context = HttpContext.Current;var search = context.Request.QueryString["search"].ToString();//搜索条件var pagesize = Convert.ToInt32(context.Request.QueryString["limit"].ToString());var pageindex = Convert.ToInt32(context.Request.QueryString["page"].ToString());UserGetData user = new UserGetData();int count = 0;var list = user.GetTable(pageindex, pagesize, search, "", out count);if (list != null && list.Count > 0){return SuccNo.SuccListReturn(list, count);}else{return SuccNo.NoListReturn();}}[HttpPost]//删除public HttpResponseMessage Delete([FromBody] string code){if (!string.IsNullOrEmpty(code)){return SuccNo.toJson(dal.DelTree(code));}else{return null;}}//增加/修改[HttpPost]public int Insert([FromBody] tb_U_AuthorityTable tb_U_Authority){try{if (tb_U_Authority != null){if (tb_U_Authority.theSer != 0){return dal.Update(tb_U_Authority);}else{return dal.Inster(tb_U_Authority);}}else{return 0;}}catch (Exception e){return 0;}}//获取修改[HttpPost]public object Update([FromBody] string id){string sql = string.Format(@"SELECT [theSer],[A_Id],[A_Name] ,[A_Grade],[A_FatherId],[A_IsFather],[A_IsChild] FROM [dbo].[tb_U_Authority] where theSer = " + id);try{DataTable dt = DBHelperSQL.Getdatatable(sql);return dt;}catch (Exception e){return null;}}//把下面方法封装在DAL类里边，在控制器里调用
//查询的方法public List<tb_U_UserTable> GetData(int pageindex, int pagesize, string Proname, string Prostatue, out int totlecount){try{IDbConnection db = new SqlConnection(DbHelper.ConnectionString);if (Proname == ""){var list = db.QuerySet<tb_U_UserTable>().OrderBy(x => x.U_Id).PageList(pageindex, pagesize);var listdata = list.Items.ToList();totlecount = list.Total;return listdata;}else{var list = db.QuerySet<tb_U_UserTable>().Where(x => x.U_Name.Contains(Proname)).OrderBy(x => x.U_Id).PageList(pageindex, pagesize);var listdata = list.Items.ToList();totlecount = list.Total;return listdata;}}catch (Exception ee){totlecount = 0;return null;}}//增删改//添加public int Inster(tb_U_AuthorityTable datas){string query = @"INSERT INTO [dbo].[tb_U_Authority]([A_Id],[A_Name],[A_Grade],[A_FatherId],[A_IsFather],[A_IsChild],[url],[Icon])VALUES(@A_Id,@A_Name,@A_Grade,@A_FatherId,@A_IsFather,@A_IsChild,@url,@Icon)";IDbConnection db = new SqlConnection(DbHelper.ConnectionString);try{if (db.State == ConnectionState.Closed){db.Open();}var data = db.Execute(query, datas);return data;}catch (Exception ee) { throw ee; }finally{db.Close();}}//修改public int Update(tb_U_AuthorityTable datas){string query = @"UPDATE [dbo].[tb_U_Authority]SET [A_Id] =@A_Id,[A_Name] =@A_Name,[A_Grade] =@A_Grade,[A_FatherId] =@A_FatherId,[A_IsFather] =@A_IsFather,[A_IsChild] =@A_IsChildWHERE  theSer=@theSer";IDbConnection db = new SqlConnection(DbHelper.ConnectionString);try{if (db.State == ConnectionState.Closed){db.Open();}var data = db.Execute(query, datas);return data;}catch (Exception ee) { throw ee; }finally{db.Close();}}//删除public int DelRoles(string id){string query = "DELETE FROM TableName  WHERE Id in (" + id + ") ";IDbConnection db = new SqlConnection(DbHelper.ConnectionString);try{if (db.State == ConnectionState.Closed){db.Open();}var data = db.Execute(query);return data;}catch (Exception ee) { throw ee; }finally{db.Close();}}