sysdepartment.html 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Cache-Control" content="no-store" />
  5. <meta http-equiv="Pragma" content="no-cache" />
  6. <meta http-equiv="Expires" content="-1" />
  7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  8. <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  9. <title>机构表维护</title>
  10. <script type="text/javascript" src="../../scripts/jquery-1.8.3.js"></script>
  11. <link rel="stylesheet" type="text/css" href="../../themes/icon.css">
  12. <script type="text/javascript" src="../../scripts/jquery.easyui.js"></script>
  13. <script type="text/javascript" src="../../scripts/easyui-lang-zh_CN.js"></script>
  14. <script type="text/javascript"
  15. src="../../scripts/jquery.validate.rules.generate.js"></script>
  16. <script type="text/javascript" src="../../scripts/config.js"></script>
  17. <script type="text/javascript" src="../../scripts/comment.js"></script>
  18. <script type="text/javascript" src="../../scripts/utils.js"></script>
  19. <script type="text/javascript" src="../../scripts/init.js"></script>
  20. <script type="text/javascript" src="../../scripts/Base64.js"></script>
  21. <script type="text/javascript" src="../../scripts/jquery.edatagrid.js"></script>
  22. </head>
  23. <body>
  24. <script type="text/javascript">
  25. //准备加载本地和远程数据
  26. //去掉的支付参数数据
  27. // /**
  28. // * qq_number,客服qq号码,VARCHAR(32),ISNULL: Y
  29. // * @generated
  30. // */
  31. // private String qqNumber;
  32. //
  33. // /**
  34. // * wechat_number,客服微信号码,VARCHAR(32),ISNULL: Y
  35. // * @generated
  36. // */
  37. // private String wechatNumber;
  38. // /**
  39. // * wechat_device_info,设备号 : 终端设备号(门店号或收银设备ID),默认请传"WEB",VARCHAR(32),ISNULL: Y
  40. // * @generated
  41. // */
  42. // private String wechatDeviceInfo;
  43. //
  44. // /**
  45. // * wechat_order_not_exist_timeout_interval,订单不存在查询超时间隔 : 订单不存在查询时间超时间隔,INTEGER(10),ISNULL: Y
  46. // * @generated
  47. // */
  48. // private Integer wechatOrderNotExistTimeoutInterval;
  49. //
  50. // /**
  51. // * wechat_time_close,交易关闭间隔 : 交易关闭间隔,VARCHAR(8),ISNULL: Y
  52. // * @generated
  53. // */
  54. // private String wechatTimeClose;
  55. //
  56. // /**
  57. // * wechat_notifyurl,支付通知地址 : 支付通知地址,VARCHAR(256),ISNULL: Y
  58. // * @generated
  59. // */
  60. // private String wechatNotifyurl;
  61. //
  62. // /**
  63. // * wechat_refund_url,退款通知地址 : 退款通知地址,VARCHAR(256),ISNULL: Y
  64. // * @generated
  65. // */
  66. // private String wechatRefundUrl;
  67. //
  68. // /**
  69. // * wechat_storeclient,私钥文件 : 私钥文件,VARCHAR(64),ISNULL: Y
  70. // * @generated
  71. // */
  72. // private String wechatStoreclient;
  73. //
  74. // /**
  75. // * wechat_pay_querysize,一次查询返回的最多记录条数 : 一次查询返回的最多记录条数,VARCHAR(4),ISNULL: Y
  76. // * @generated
  77. // */
  78. // private String wechatPayQuerysize;
  79. //
  80. // /**
  81. // * wechat_keystore,微信根证书 : 微信根证书,VARCHAR(64),ISNULL: Y
  82. // * @generated
  83. // */
  84. // private String wechatKeystore;
  85. // /**
  86. // * wechat_refund,订单退款URL : 订单退款URL,VARCHAR(64),ISNULL: Y
  87. // * @generated
  88. // */
  89. // private String wechatRefund;
  90. //
  91. // /**
  92. // * wechat_refundquery,订单退款查询URL : 订单退款查询URL,VARCHAR(64),ISNULL: Y
  93. // * @generated
  94. // */
  95. // private String wechatRefundquery;
  96. //
  97. // /**
  98. // * wechat_downloadbill,账单下载URL : 账单下载URL,VARCHAR(64),ISNULL: Y
  99. // * @generated
  100. // */
  101. // private String wechatDownloadbill;
  102. // /**
  103. // * wechat_pay_timegap,一次查询的最长时间间隔 : 一次查询的最长时间间隔,VARCHAR(8),ISNULL: Y
  104. // * @generated
  105. // */
  106. // private String wechatPayTimegap;
  107. //
  108. // /**
  109. // * wechat_refund_notify_url,退款通知地址 : 退款通知地址,VARCHAR(256),ISNULL: Y
  110. // * @generated
  111. // */
  112. // private String wechatRefundNotifyUrl;
  113. // /**
  114. // * alipay_timeout_express,订单最晚付款时间 : 1m~15d。m-分钟,h-小时,d-天,1c-当天,VARCHAR(6),ISNULL: Y ,default:'6m'::character varying
  115. // * @generated
  116. // */
  117. // private String alipayTimeoutExpress;
  118. // /**
  119. // * alipay_create_notify_url,交易创建结果通知 : 交易创建结果通知,VARCHAR(256),ISNULL: Y
  120. // * @generated
  121. // */
  122. // private String alipayCreateNotifyUrl;
  123. </script>
  124. <table id="dg" style="width: 98%; height: 512px" toolbar="#toolbar"
  125. pagination="true" idField="id" rownumbers="true" fitColumns="true"
  126. singleSelect="true">
  127. <thead>
  128. <tr>
  129. <th field="ck" data-options="checkbox:true" width="5"></th>
  130. <!-- 生成的数据库代码段 -->
  131. <th field="id" align="left" hidden=true sortable="true"
  132. width="32">ID</th>
  133. <th field="deptCode" align="left"
  134. data-options="editor:valiBoxEtr(true,'',4,32)" sortable="true"
  135. width="32">机构编码</th>
  136. <th field="deptName" align="left"
  137. data-options="editor:valiBoxEtr(true,'',1,64)" sortable="true"
  138. width="32">机构名称</th>
  139. <th field="parent" align="left"
  140. data-options="editor:valiBoxEtr(false,'',0,32)" hidden=true sortable="true"
  141. width="32">上级机构</th>
  142. <th field="deptType" align="left"
  143. data-options="formatter:dataFmt('deptType'),editor:comboBoxEtr('deptType')"
  144. sortable="true" width="32">机构类型</th>
  145. <th field="deptConn" align="left"
  146. data-options="editor:valiBoxEtr(true,'',1,64)" sortable="true"
  147. width="32">联系人</th>
  148. <th field="deptAddr" align="left"
  149. data-options="editor:valiBoxEtr(true,'',1,64)" sortable="true"
  150. width="32">地址</th>
  151. <th field="deptTell" align="left"
  152. data-options="editor:valiBoxEtr(true,'',1,64)" sortable="true"
  153. width="32">电话</th>
  154. <th field="remarks" align="left"
  155. data-options="editor:valiBoxEtr(false,'',0,128)" sortable="true"
  156. width="32">备注</th>
  157. <th field="organizationCode" align="left"
  158. data-options="editor:valiBoxEtr(true,'',4,32)" sortable="true"
  159. width="32">机构识别码</th>
  160. <th field="qqNumber" align="left"
  161. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  162. width="32">QQ号</th>
  163. <th field="wechatNumber" align="left"
  164. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  165. width="32">微信号</th>
  166. <th field="wechatPublic" align="left"
  167. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  168. width="32">微信公众号</th>
  169. <th field="wechatAppid" align="left"
  170. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  171. width="32">微信应用ID</th>
  172. <th field="wechatMchId" align="left"
  173. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  174. width="32">商户号</th>
  175. <th field="wechatKey" align="left"
  176. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  177. width="32">微信key</th>
  178. <th field="wechatTimeoutInterval" align="left"
  179. data-options="editor:valiBoxEtr(false,'',0,64)" hidden=true sortable="true"
  180. width="32">超时间隔</th>
  181. <th field="wechatUnifiedorder" align="left"
  182. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  183. width="32">下单URL</th>
  184. <th field="wechatOrderquery" align="left"
  185. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  186. width="32">订单查询URL</th>
  187. <th field="wechatCloseorder" align="left"
  188. data-options="editor:valiBoxEtr(false,'',0,64)" hidden=true sortable="true"
  189. width="32">订单关闭URL</th>
  190. <th field="wechatAurl" align="left"
  191. data-options="editor:valiBoxEtr(false,'',0,64)" hidden=true sortable="true"
  192. width="32">微信地址</th>
  193. <th field="channelNo" align="left"
  194. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  195. width="32">渠道号</th>
  196. <th field="packageName" align="left"
  197. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  198. width="32">包名</th>
  199. <th field="alipayAppid" align="left"
  200. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  201. width="32">支付宝APPID</th>
  202. <th field="alipayMerchantId" align="left"
  203. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  204. width="32">商户UID</th>
  205. <th field="alipayPublicKey" align="left"
  206. data-options="editor:valiBoxEtr(false,'',0,4096)" sortable="true"
  207. width="32">支付宝公钥</th>
  208. <th field="alipayPrivateKey" align="left"
  209. data-options="editor:valiBoxEtr(false,'',0,4096)" sortable="true"
  210. width="32">支付宝私钥</th>
  211. <th field="alipayGateway" align="left"
  212. data-options="editor:valiBoxEtr(false,'',0,4096)" sortable="true"
  213. width="32">支付宝网关</th>
  214. <th field="alipayCreateMethod" align="left"
  215. data-options="editor:valiBoxEtr(false,'',0,64)" hidden=true sortable="true"
  216. width="32">交易创建方法</th>
  217. <th field="alipaySignType" align="left"
  218. data-options="editor:valiBoxEtr(false,'',0,64)" sortable="true"
  219. width="32">支付宝加密方式</th>
  220. </tr>
  221. </thead>
  222. </table>
  223. <div id="toolbar">
  224. <!-- 生成的条件查询代码段 -->
  225. <!--<span>系统类型:</span> <input id="systembox" class="easyui-combobox"-->
  226. <!--name="language"-->
  227. <!--data-options="-->
  228. <!--data:getListData('systemClass'),-->
  229. <!--valueField:'id',-->
  230. <!--textField:'text',-->
  231. <!--panelHeight:'auto',-->
  232. <!--required:false,-->
  233. <!--editable:false,-->
  234. <!--value:'manager'-->
  235. <!---->
  236. <!--">-->
  237. <span>机构编码:</span><input id="deptCode1"
  238. style="line-height: 20px; border: 1px solid #ccc" /> <span>机构名称:</span><input
  239. id="deptName1" style="line-height: 20px; border: 1px solid #ccc" />
  240. <a href="#" class="easyui-linkbutton" iconCls="icon-search"
  241. plain="true" onclick="doSearch(0)">查询</a><a href="javascript:void(0)"
  242. class="easyui-linkbutton" iconCls="icon-add" plain="true"
  243. onclick="javascript:$('#dg').edatagrid('addRow')">新增</a> <a
  244. href="javascript:void(0)" class="easyui-linkbutton"
  245. iconCls="icon-save" plain="true"
  246. onclick="javascript:$('#dg').edatagrid('saveRow')">保存</a> <a
  247. href="javascript:void(0)" class="easyui-linkbutton"
  248. iconCls="icon-undo" plain="true"
  249. onclick="javascript:$('#dg').edatagrid('cancelRow')">恢复</a> <a
  250. href="javascript:void(0)" class="easyui-linkbutton"
  251. iconCls="icon-remove" plain="true"
  252. onclick="javascript:$('#dg').edatagrid('destroyRow')">删除</a> <a
  253. href="#" class="easyui-linkbutton" iconCls="icon-excel" plain="true"
  254. onclick="doSearch(1)">导出</a>
  255. </div>
  256. <!-- 生成的大字段的详细查询字段 -->
  257. <script type="text/javascript">
  258. //页面加载调用
  259. $(function(){
  260. //生成的初始化日期时间代码段
  261. doSearch();
  262. });
  263. function doSearch(download){
  264. //生成获取查询条件变量
  265. var systemType = "service";//$('#systembox').combobox('getValue');
  266. var deptCode1 = $('#deptCode1').val()== undefined ? "" : $('#deptCode1').val();
  267. var deptName1 = $('#deptName1').val()== undefined ? "" : $('#deptName1').val();
  268. var params ="";
  269. //生成获取查询发送URL
  270. if(deptCode1!=''){
  271. if(params==''){
  272. params = params+"proNames=deptCode";
  273. }else{
  274. params = params+",deptCode";
  275. }
  276. }
  277. if(deptName1!=''){
  278. if(params==''){
  279. params = params+"proNames=deptName";
  280. }else{
  281. params = params+",deptName";
  282. }
  283. }
  284. if(deptCode1!=''){
  285. if(params==''){
  286. params = "deptCode=$"+deptCode1+"$";
  287. }else{
  288. params = params + "&deptCode=$"+deptCode1+"$";
  289. }
  290. }
  291. if(deptName1!=''){
  292. if(params==''){
  293. params = "deptName=$"+deptName1+"$";
  294. }else{
  295. params = params + "&deptName=$"+deptName1+"$";
  296. }
  297. }
  298. //保存修改删除URL
  299. var params1 = "proNames=id";//&channelNo=+systemType;
  300. //增加系统和排序条件
  301. var param = params+"&channelNo="+systemType+"&orderBy=dept_code";
  302. //区别于查询还是下载
  303. if(download==1){
  304. downloadExcel('#dg','机构表查询','GENERALD01',param);
  305. }else{
  306. $('#dg').edatagrid({
  307. url: getUrl('GENERALD01',param),
  308. saveUrl: getUrl('GENERALD02',params1),
  309. updateUrl: getUrl('GENERALD03',params1),
  310. destroyUrl: getUrl('GENERALD04',params1),
  311. striped:true,
  312. pagination: true,
  313. pageSize: 15,//每页显示的记录条数,默认为20
  314. pageList: [10, 15,25, 50,100],//可以设置每页记录条数的列表
  315. loadFilter: function (data){
  316. loadFilterError(data);
  317. return data;
  318. }
  319. });
  320. }
  321. }
  322. //生成的大字段的详细查询函数
  323. </script>
  324. </body>
  325. </html>