ExportExcel.cshtml 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290
  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>指定文件Excel导出</title>
  10. <meta name="renderer" content="webkit">
  11. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  12. <meta name="viewport"
  13. content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  14. <link rel="stylesheet" href="/layuiadmin/layui/css/layui.css" media="all">
  15. <script src="/admin/js/jquery-1.10.1.min.js"></script>
  16. <script src="/admin/js/LAreaData2.js"></script>
  17. </head>
  18. <body>
  19. <div class="layui-form" lay-filter="layuiadmin-form-useradmin" id="layuiadmin-form-useradmin">
  20. <form class="layui-form" id="confirmFrm">
  21. <div class="layui-card">
  22. <div class="layui-card-body">
  23. <div class="layui-tab" lay-filter="mytabbar">
  24. <ul class="layui-tab-title">
  25. <li class="layui-this" lay-id="1">基本信息</li>
  26. </ul>
  27. <div class="layui-tab-content mt20">
  28. <div class="layui-tab-item layui-show">
  29. <div class="layui-form-item">
  30. <label class="layui-form-label">文件名</label>
  31. <div class="layui-input-inline">
  32. <input class="layui-input" type="text" id="FileName" name="FileName"
  33. maxlength="50" lay-verify="required|" autocomplete="off"
  34. placeholder="请输入文件名">
  35. </div>
  36. </div>
  37. <div class="layui-form-item">
  38. <label class="layui-form-label">后台操作人</label>
  39. <div class="layui-input-block">
  40. <textarea class="layui-textarea" lay-verify="required|" name="Operator" id="Operator"
  41. placeholder="请输入后台操作人,多个用回车隔开"></textarea>
  42. </div>
  43. </div>
  44. <div class="layui-form-item">
  45. <label class="layui-form-label">SQL语句</label>
  46. <div class="layui-input-block">
  47. <textarea class="layui-textarea" lay-verify="required|" name="Sql" id="Sql"
  48. placeholder="请输入SQL语句"></textarea>
  49. </div>
  50. </div>
  51. <div class="layui-form-item">
  52. <label class="layui-form-label">返回数量</label>
  53. <div class="layui-input-inline">
  54. <input class="layui-input" type="number" id="Number" name="Number" value="0"
  55. maxlength="50" lay-verify="" autocomplete="off" placeholder="请输入返回数量">
  56. </div>
  57. </div>
  58. </div>
  59. </div>
  60. </div>
  61. <div class="layui-form-item ml10">
  62. <div class="layui-input-block">
  63. <button type="button" class="layui-btn" onclick="save()">提交</button>
  64. </div>
  65. </div>
  66. </div>
  67. </div>
  68. </form>
  69. </div>
  70. <script src="/layuiadmin/layui/layui.js"></script>
  71. <script
  72. src="/other/oss/upload-min@(MySystem.OssHelper.Instance.OssStatus ? "-oss" : "").js?r=@DateTime.Now.ToString("yyyyMMddHHmmss")"></script>
  73. <script src="/other/mybjq/kindeditor-min.js"></script>
  74. <script src="/other/mybjq/lang/zh_CN.js"></script>
  75. <script>
  76. function save() {
  77. var FileName = $('#FileName').val();
  78. var Operator = $('#Operator').val();
  79. var Sql = $('#Sql').val();
  80. var Number = $('#Number').val();
  81. if (FileName == '') {
  82. layer.msg('请输入文件名');
  83. }
  84. else if (Operator == '') {
  85. layer.msg('请输入后台操作人');
  86. }
  87. else if (Sql == '') {
  88. layer.msg('请输入SQL语句');
  89. }
  90. else if (Number == '') {
  91. layer.msg('请输入返回数量');
  92. }
  93. else {
  94. var index = layer.confirm('确定发送吗?', function (index) {
  95. var indexs = layer.load(1, {
  96. shade: [0.5, '#000']
  97. });
  98. var userdata = $("#confirmFrm").serialize();
  99. $.ajax({
  100. type: "POST",
  101. url: "/Admin/SysTools/ExportExcelDo?r=" + Math.random(1),
  102. data: userdata,
  103. dataType: "text",
  104. success: function (data) {
  105. layer.close(index); //关闭弹层
  106. if (data == "success") {
  107. layer.close(indexs); //关闭弹层
  108. layer.msg('成功', {
  109. time: 1000
  110. }, function () {
  111. window.location.reload();
  112. });
  113. } else if (data.indexOf("Warning") == 0) {
  114. var datalist = data.split('|');
  115. layer.close(indexs); //关闭弹层
  116. layer.alert(datalist[1], { time: 20000 }, function () {
  117. window.location.reload();
  118. });
  119. } else {
  120. layer.close(indexs); //关闭弹层
  121. layer.msg(data);
  122. }
  123. }
  124. });
  125. });
  126. }
  127. }
  128. //编辑器
  129. KindEditor.ready(function (K) {
  130. });
  131. var ids = "";
  132. function getChildren(obj) {
  133. $.each(obj, function (index, value) {
  134. var id = obj[index].id;
  135. ids += id + ",";
  136. var children = obj[index].children;
  137. if (children) {
  138. getChildren(children);
  139. }
  140. });
  141. }
  142. function AreasProvinceInit(tagId, areasVal, form) {
  143. for (var i = 0; i < provs_data.length; i++) {
  144. var sel = "";
  145. if (areasVal.indexOf(provs_data[i].text) > -1) {
  146. sel = " selected=selected";
  147. }
  148. $("#" + tagId + "Province").append('<option value="' + provs_data[i].value + '"' + sel + '>' + provs_data[i].text + '</option>');
  149. }
  150. form.render();
  151. }
  152. function AreasProvinceSelected(tagId, areasVal, form, value) {
  153. $("#" + tagId + "City").html('<option value="">市</option>');
  154. var list = citys_data[value];
  155. for (var i = 0; i < list.length; i++) {
  156. var sel = "";
  157. if (areasVal.indexOf(list[i].text) > -1) {
  158. sel = " selected=selected";
  159. }
  160. $("#" + tagId + "City").append('<option value="' + list[i].value + '"' + sel + '>' + list[i].text + '</option>');
  161. }
  162. $("#" + tagId + "Area").html('<option value="">县/区</option>');
  163. form.render();
  164. $("#" + tagId + "").val($("#" + tagId + "Province option:selected").text() + "," + $("#" + tagId + "City option:selected").text() + "," + $("#" + tagId + "Area option:selected").text());
  165. }
  166. function AreasCitySelected(tagId, areasVal, form, value) {
  167. $("#" + tagId + "Area").html('<option value="">县/区</option>');
  168. var list = dists_data[value];
  169. for (var i = 0; i < list.length; i++) {
  170. var sel = "";
  171. if (areasVal.indexOf(list[i].text) > -1) {
  172. sel = " selected=selected";
  173. }
  174. $("#" + tagId + "Area").append('<option value="' + list[i].value + '"' + sel + '>' + list[i].text + '</option>');
  175. }
  176. form.render();
  177. $("#" + tagId + "").val($("#" + tagId + "Province option:selected").text() + "," + $("#" + tagId + "City option:selected").text() + "," + $("#" + tagId + "Area option:selected").text());
  178. }
  179. function AreasAreaSelected(tagId, form) {
  180. form.render();
  181. $("#" + tagId + "").val($("#" + tagId + "Province option:selected").text() + "," + $("#" + tagId + "City option:selected").text() + "," + $("#" + tagId + "Area option:selected").text());
  182. }
  183. function movePrev(obj, tagId) {
  184. $(obj).parent().prev().insertAfter($(obj).parent());
  185. checkPics(tagId);
  186. }
  187. function moveNext(obj, tagId) {
  188. $(obj).parent().next().insertBefore($(obj).parent());
  189. checkPics(tagId);
  190. }
  191. function deletePic(obj, tagId) {
  192. $(obj).parent().remove();
  193. checkPics(tagId);
  194. }
  195. function checkPics(tagId) {
  196. var pics = "";
  197. var texts = "";
  198. $("#" + tagId + "Image div img").each(function (i) {
  199. pics += $(this).attr("src").replace(osshost, '') + "|";
  200. });
  201. $("#" + tagId + "Image div input").each(function (i) {
  202. texts += $(this).val() + "|";
  203. });
  204. if (pics == "") {
  205. $("#" + tagId).val("");
  206. } else {
  207. pics = pics.substring(0, pics.length - 1);
  208. texts = texts.substring(0, pics.length - 1);
  209. $("#" + tagId).val(pics + "#cut#" + texts);
  210. }
  211. }
  212. function checkBox(tagId) {
  213. var text = "";
  214. $("input[type=checkbox][name=" + tagId + "List]:checked").each(function (i) {
  215. text += $(this).val() + ",";
  216. });
  217. $("#" + tagId).val(text);
  218. }
  219. function showBigPic(picpath) {
  220. parent.layer.open({
  221. type: 1,
  222. title: false,
  223. closeBtn: 0,
  224. shadeClose: true,
  225. area: ['auto', 'auto'],
  226. content: '<img src="' + picpath + '" style="max-width:800px; max-height:800px;" />'
  227. });
  228. }
  229. var tree;
  230. var element;
  231. var upload;
  232. layui.config({
  233. base: '/layuiadmin/' //静态资源所在路径
  234. }).extend({
  235. index: 'lib/index' //主入口模块
  236. }).use(['index', 'form', 'upload', 'layedit', 'laydate', 'element', 'croppers', 'transfer', 'tree', 'util'], function () {
  237. var $ = layui.$
  238. , form = layui.form
  239. , layer = layui.layer
  240. , layedit = layui.layedit
  241. , laydate = layui.laydate
  242. , croppers = layui.croppers
  243. , transfer = layui.transfer
  244. , util = layui.util;
  245. tree = layui.tree;
  246. element = layui.element;
  247. upload = layui.upload;
  248. //Hash地址的定位
  249. var layid = location.hash.replace(/^#test=/, '');
  250. element.tabChange('test', layid);
  251. element.on('tab(test)', function (elem) {
  252. location.hash = 'test=' + $(this).attr('lay-id');
  253. });
  254. //日期
  255. //上传文件
  256. //穿梭框
  257. //TreeView,比如权限管理
  258. //省市区
  259. })
  260. </script>
  261. </body>
  262. </html>