Add.cshtml 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. @{
  2. string RightInfo = ViewBag.RightInfo as string;
  3. string right = ViewBag.right as string;
  4. }
  5. <!DOCTYPE html>
  6. <html>
  7. <head>
  8. <meta charset="utf-8">
  9. <title>自定义查询(增加)</title>
  10. <meta name="renderer" content="webkit">
  11. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  12. <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  13. <link rel="stylesheet" href="/layuiadmin/layui/css/layui.css" media="all">
  14. <script src="/admin/js/jquery-1.10.1.min.js"></script>
  15. <script src="/admin/js/LAreaData2.js"></script>
  16. </head>
  17. <body>
  18. <div class="layui-form" lay-filter="layuiadmin-form-useradmin" id="layuiadmin-form-useradmin">
  19. <div class="layui-card">
  20. <div class="layui-card-body">
  21. <div class="layui-tab" lay-filter="mytabbar">
  22. <ul class="layui-tab-title">
  23. <li class="layui-this" lay-id="1">基本信息</li>
  24. </ul>
  25. <div class="layui-tab-content mt20">
  26. <div class="layui-tab-item layui-show">
  27. <div class="layui-form-item">
  28. <label class="layui-form-label">标题</label>
  29. <div class="layui-input-inline">
  30. <input class="layui-input" type="text" id="Title" name="Title" maxlength="50"
  31. lay-verify="required|" autocomplete="off" placeholder="请输入标题">
  32. </div>
  33. </div>
  34. <div class="layui-form-item layui-form-text">
  35. <label class="layui-form-label">sql语句</label>
  36. <div class="layui-input-block">
  37. <textarea class="layui-textarea" id="SqlContent" name="SqlContent" maxlength=""
  38. lay-verify="required|" placeholder="请输入sql语句"></textarea>
  39. </div>
  40. </div>
  41. <div class="layui-form-item layui-form-text">
  42. <label class="layui-form-label">返回字段</label>
  43. <div class="layui-input-block">
  44. <textarea class="layui-textarea" id="SeoDescription" name="SeoDescription" maxlength=""
  45. lay-verify="required|" placeholder="请输入返回字段"></textarea>
  46. </div>
  47. </div>
  48. <div class="layui-form-item layui-form-text">
  49. <label class="layui-form-label">后台账号</label>
  50. <div class="layui-input-block">
  51. <textarea class="layui-textarea" id="AdminNames" name="AdminNames" maxlength="500"
  52. lay-verify="" placeholder="请输入后台账号"></textarea>
  53. </div>
  54. </div>
  55. <div class="layui-form-item">
  56. <label class="layui-form-label">执行类型</label>
  57. <div class="layui-input-inline">
  58. <select id="ExcuteFlag" name="ExcuteFlag" lay-search="">
  59. <option value="">请选择</option>
  60. <option value="0">sql查询</option>
  61. <option value="1">sql执行</option>
  62. <option value="2">redis查询</option>
  63. <option value="3">redis执行</option>
  64. <option value="4">查看日志</option>
  65. </select>
  66. </div>
  67. </div>
  68. <div class="layui-form-item">
  69. <label class="layui-form-label">数据库</label>
  70. <div class="layui-input-inline">
  71. <input class="layui-input" type="text" id="DatabaseConnect" name="DatabaseConnect" maxlength="50" lay-verify="required|" autocomplete="off" placeholder="请输入标题">
  72. </div>
  73. </div>
  74. </div>
  75. </div>
  76. </div>
  77. <div class="layui-form-item layui-hide">
  78. <input type="button" lay-submit lay-filter="LAY-list-front-submit" id="LAY-list-front-submit" value="确认">
  79. </div>
  80. </div>
  81. </div>
  82. </div>
  83. <script src="/layuiadmin/layui/layui.js"></script>
  84. <script src="/other/oss/upload-min@(MySystem.OssHelper.Instance.OssStatus ? "-oss" : "").js"></script>
  85. <script src="/other/mybjq/kindeditor-min.js"></script>
  86. <script src="/other/mybjq/lang/zh_CN.js"></script>
  87. <script>
  88. //编辑器
  89. KindEditor.ready(function (K) {
  90. });
  91. var ids = "";
  92. function getChildren(obj) {
  93. $.each(obj, function (index, value) {
  94. var id = obj[index].id;
  95. ids += id + ",";
  96. var children = obj[index].children;
  97. if (children) {
  98. getChildren(children);
  99. }
  100. });
  101. }
  102. function AreasProvinceInit(tagId, areasVal, form) {
  103. for (var i = 0; i < provs_data.length; i++) {
  104. var sel = "";
  105. if (areasVal.indexOf(provs_data[i].text) > -1) {
  106. sel = " selected=selected";
  107. }
  108. $("#" + tagId + "Province").append('<option value="' + provs_data[i].value + '"' + sel + '>' + provs_data[i].text + '</option>');
  109. }
  110. form.render();
  111. }
  112. function AreasProvinceSelected(tagId, areasVal, form, value) {
  113. $("#" + tagId + "City").html('<option value="">市</option>');
  114. var list = citys_data[value];
  115. for (var i = 0; i < list.length; i++) {
  116. var sel = "";
  117. if (areasVal.indexOf(list[i].text) > -1) {
  118. sel = " selected=selected";
  119. }
  120. $("#" + tagId + "City").append('<option value="' + list[i].value + '"' + sel + '>' + list[i].text + '</option>');
  121. }
  122. $("#" + tagId + "Area").html('<option value="">县/区</option>');
  123. form.render();
  124. $("#" + tagId + "").val($("#" + tagId + "Province option:selected").text() + "," + $("#" + tagId + "City option:selected").text() + "," + $("#" + tagId + "Area option:selected").text());
  125. }
  126. function AreasCitySelected(tagId, areasVal, form, value) {
  127. $("#" + tagId + "Area").html('<option value="">县/区</option>');
  128. var list = dists_data[value];
  129. for (var i = 0; i < list.length; i++) {
  130. var sel = "";
  131. if (areasVal.indexOf(list[i].text) > -1) {
  132. sel = " selected=selected";
  133. }
  134. $("#" + tagId + "Area").append('<option value="' + list[i].value + '"' + sel + '>' + list[i].text + '</option>');
  135. }
  136. form.render();
  137. $("#" + tagId + "").val($("#" + tagId + "Province option:selected").text() + "," + $("#" + tagId + "City option:selected").text() + "," + $("#" + tagId + "Area option:selected").text());
  138. }
  139. function AreasAreaSelected(tagId, form) {
  140. form.render();
  141. $("#" + tagId + "").val($("#" + tagId + "Province option:selected").text() + "," + $("#" + tagId + "City option:selected").text() + "," + $("#" + tagId + "Area option:selected").text());
  142. }
  143. function movePrev(obj, tagId) {
  144. $(obj).parent().prev().insertAfter($(obj).parent());
  145. checkPics(tagId);
  146. }
  147. function moveNext(obj, tagId) {
  148. $(obj).parent().next().insertBefore($(obj).parent());
  149. checkPics(tagId);
  150. }
  151. function deletePic(obj, tagId) {
  152. $(obj).parent().remove();
  153. checkPics(tagId);
  154. }
  155. function checkPics(tagId) {
  156. var pics = "";
  157. var texts = "";
  158. $("#" + tagId + "Image div img").each(function (i) {
  159. pics += $(this).attr("src").replace(osshost, '') + "|";
  160. });
  161. $("#" + tagId + "Image div input").each(function (i) {
  162. texts += $(this).val() + "|";
  163. });
  164. if (pics == "") {
  165. $("#" + tagId).val("");
  166. } else {
  167. pics = pics.substring(0, pics.length - 1);
  168. texts = texts.substring(0, pics.length - 1);
  169. $("#" + tagId).val(pics + "#cut#" + texts);
  170. }
  171. }
  172. function checkBox(tagId) {
  173. var text = "";
  174. $("input[type=checkbox][name=" + tagId + "List]:checked").each(function (i) {
  175. text += $(this).val() + ",";
  176. });
  177. $("#" + tagId).val(text);
  178. }
  179. function showBigPic(picpath) {
  180. parent.layer.open({
  181. type: 1,
  182. title: false,
  183. closeBtn: 0,
  184. shadeClose: true,
  185. area: ['auto', 'auto'],
  186. content: '<img src="' + picpath + '" style="max-width:800px; max-height:800px;" />'
  187. });
  188. }
  189. var tree;
  190. var element;
  191. var upload;
  192. layui.config({
  193. base: '/layuiadmin/' //静态资源所在路径
  194. }).extend({
  195. index: 'lib/index' //主入口模块
  196. }).use(['index', 'form', 'upload', 'layedit', 'laydate', 'element', 'croppers', 'transfer', 'tree', 'util'], function () {
  197. var $ = layui.$
  198. , form = layui.form
  199. , layer = layui.layer
  200. , layedit = layui.layedit
  201. , laydate = layui.laydate
  202. , croppers = layui.croppers
  203. , transfer = layui.transfer
  204. , util = layui.util;
  205. tree = layui.tree;
  206. element = layui.element;
  207. upload = layui.upload;
  208. //Hash地址的定位
  209. var layid = location.hash.replace(/^#test=/, '');
  210. element.tabChange('test', layid);
  211. element.on('tab(test)', function (elem) {
  212. location.hash = 'test=' + $(this).attr('lay-id');
  213. });
  214. //日期
  215. //上传文件
  216. //穿梭框
  217. //TreeView,比如权限管理
  218. //省市区
  219. })
  220. </script>
  221. </body>
  222. </html>