RawSql.html 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
  1. <!DOCTYPE html>
  2. <html class="x-admin-sm">
  3. <head>
  4. <meta charset="UTF-8">
  5. <meta name="renderer" content="webkit">
  6. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  7. <meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
  8. <link rel="shortcut icon" href="https://osscold.baozhida.cn/favicon.ico">
  9. <link rel="bookmark" href="https://osscold.baozhida.cn/favicon.ico">
  10. <link rel="stylesheet" href="https://osscold.baozhida.cn/css/font.css">
  11. <link rel="stylesheet" href="https://osscold.baozhida.cn/css/xadmin.css">
  12. <script src="https://osscold.baozhida.cn/lib/layui/layui.js" charset="utf-8"></script>
  13. <script type="text/javascript" src="https://osscold.baozhida.cn/js/xadmin.js"></script>
  14. </head>
  15. <body>
  16. <div class="x-nav">
  17. <span class="layui-breadcrumb">
  18. <a href="">首页</a>
  19. <a><cite>宝智达</cite></a>
  20. </span>
  21. <a class="layui-btn layui-btn-normal" style="line-height:1.6em;margin-top:3px;float:right" onclick="location.reload()" title="刷新">
  22. <i class="layui-icon layui-icon-refresh" style="line-height:30px"></i>
  23. </a>
  24. </div>
  25. <div class="layui-fluid">
  26. <div class="layui-row layui-col-space15">
  27. <div class="layui-col-md12">
  28. <div class="layui-card">
  29. <div class="layui-card-header">
  30. <!-- <button class="layui-btn layui-btn-danger" onclick="delAll()">-->
  31. <!-- <i class="layui-icon"></i>批量删除</button>-->
  32. <button class="layui-btn layui-btn-normal" onclick="xadmin.open('添加','Raw__html',650,600,false);">
  33. <i class="layui-icon"></i>添加</button></div>
  34. <div class="layui-card-body ">
  35. <table class="layui-table layui-form">
  36. <thead>
  37. <tr>
  38. <th>T_id</th>
  39. <th>标题</th>
  40. <th>SQL</th>
  41. <th style="width: 122.7px;">操作</th></tr>
  42. </thead>
  43. <tbody>
  44. {{range $index, $elem := .List}}
  45. <tr>
  46. <td>{{$elem.T_id}}</td>
  47. <td>{{$elem.T_name}}</td>
  48. <td>{{$elem.T_text}}</td>
  49. <td class="td-manage">
  50. <a title="编辑" onclick="xadmin.open('编辑','Raw__html?id={{$elem.Id}}',650,600,false);" href="javascript:;">
  51. <i class="layui-icon">&#xe63c;</i>编辑</a>
  52. <a title="删除" onclick="member_del(this,'{{$elem.Id}}')" href="javascript:;">
  53. <i class="layui-icon">&#xe640;</i>删除</a>
  54. </td>
  55. </tr>
  56. {{end}}
  57. </tbody>
  58. </table>
  59. </div>
  60. <div class="layui-card-body ">
  61. <div class="page">
  62. <div>
  63. {{range $index, $elem := .Pages}}
  64. {{if eq $elem.A 1}}
  65. <a class="prev" href="?page={{$elem.V}}">&lt;&lt;</a>
  66. {{end}}
  67. {{if eq $elem.A 2}}
  68. <a class="num" href="?page={{$elem.V}}">{{$elem.V}}</a>
  69. {{end}}
  70. {{if eq $elem.A 3}}
  71. <span class="current">{{$elem.V}}</span>
  72. {{end}}
  73. {{if eq $elem.A 4}}
  74. <a class="num" href="?page={{$elem.V}}">{{$elem.V}}</a>
  75. {{end}}
  76. {{if eq $elem.A 5}}
  77. <a class="next" href="?page={{$elem.V}}">&gt;&gt;</a>
  78. {{end}}
  79. {{end}}
  80. </div>
  81. Page:{{.Page}}-
  82. Page_size:{{.Page_size}}-
  83. cnt:{{.cnt}}
  84. </div>
  85. </div>
  86. </div>
  87. </div>
  88. </div>
  89. </div>
  90. </body>
  91. <script>
  92. layui.use(['laydate', 'form'],
  93. function() {
  94. var laydate = layui.laydate;
  95. //执行一个laydate实例
  96. laydate.render({
  97. elem: '#start' //指定元素
  98. });
  99. //执行一个laydate实例
  100. laydate.render({
  101. elem: '#end' //指定元素
  102. });
  103. });
  104. /*用户-删除*/
  105. function member_del(obj, id) {
  106. layer.confirm('确认要删除吗?',
  107. function(index) {
  108. //发异步删除数据
  109. $(obj).parents("tr").remove();
  110. $.ajax({
  111. type: 'POST',
  112. url: 'List_Del',//发送请求
  113. data: {Id:id},
  114. success: function(result) {
  115. console.log(result)
  116. if (result.Code == 200 ){
  117. layer.msg('已删除!', {
  118. icon: 1,
  119. time: 2000
  120. });
  121. window.location.reload();
  122. }else {
  123. layer.msg('删除失败!', {
  124. time: 2000
  125. });
  126. }
  127. }
  128. });
  129. });
  130. }
  131. </script>
  132. </html>