Edit.cshtml 11 KB

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