autoFormDbList.jsp 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  4. <div class="easyui-layout" fit="true">
  5. <div region="center" style="padding:0px;border:0px">
  6. <t:datagrid name="autoFormDbList" checkbox="true" fitColumns="false" title="表单数据源配置" actionUrl="autoFormDbController.do?datagrid&autoFormId=${autoFormId}" idField="id" fit="true" queryMode="group">
  7. <t:dgCol title="" field="id" hidden="true" queryMode="single" width="120"></t:dgCol>
  8. <t:dgCol title="common.createName" field="createName" hidden="true" queryMode="single" width="120"></t:dgCol>
  9. <t:dgCol title="common.createby" field="createBy" hidden="true" queryMode="single" width="120"></t:dgCol>
  10. <t:dgCol title="common.updateName" field="updateName" hidden="true" queryMode="single" width="120"></t:dgCol>
  11. <t:dgCol title="common.updateBy" field="updateBy" hidden="true" queryMode="single" width="120"></t:dgCol>
  12. <!--update-end--Author:luobaoli Date:20150617 for:调整国际化编码-->
  13. <t:dgCol title="common.depart.code" field="sysOrgCode" hidden="true" queryMode="single" dictionary="t_s_depart,id,departname, and org_type != '1' " width="120"></t:dgCol>
  14. <!--update-end--Author:luobaoli Date:20150617 for:调整国际化编码-->
  15. <t:dgCol title="common.company.code" field="sysCompanyCode" hidden="true" queryMode="single" dictionary="t_s_depart,id,departname, and org_type != '1' " width="120"></t:dgCol>
  16. <t:dgCol title="common.createDate" field="createDate" formatter="yyyy-MM-dd" hidden="true" queryMode="single" width="120"></t:dgCol>
  17. <t:dgCol title="common.updateDate" field="updateDate" formatter="yyyy-MM-dd" hidden="true" queryMode="single" width="120"></t:dgCol>
  18. <t:dgCol title="form.db.name" field="dbName" queryMode="single" width="120"></t:dgCol>
  19. <t:dgCol title="form.db.chname" field="dbChName" queryMode="single" width="120"></t:dgCol>
  20. <!--update-end--Author:luobaoli Date:20150701 for:显示中文数据源类型-->
  21. <t:dgCol title="form.db.type" field="dbType" queryMode="single" dictionary="formDbType" width="120"></t:dgCol>
  22. <!--update-end--Author:luobaoli Date:20150701 for:显示中文数据源类型-->
  23. <t:dgCol title="form.db.tablename" field="dbTableName" queryMode="single" width="120"></t:dgCol>
  24. <!--add-start--Author: jg_huangxg Date:20150723 for:新增填报数据源和填报数据库表显示-->
  25. <t:dgCol title="form.tb.db.key" field="tbDbKey" queryMode="single" width="120"></t:dgCol>
  26. <t:dgCol title="form.tb.db.table.name" field="tbDbTableName" queryMode="single" width="120"></t:dgCol>
  27. <!--add-end--Author: jg_huangxg Date:20150723 for:新增填报数据源和填报数据库表显示-->
  28. <t:dgCol title="form.db.synsql" field="dbDynSql" queryMode="single" width="120"></t:dgCol>
  29. <t:dgCol title="common.dynamic.dbsource" field="dbKey" hidden="true" queryMode="single" width="120"></t:dgCol>
  30. <t:dgCol title="common.operation" field="opt"></t:dgCol>
  31. <!-- //update-begin--Author:zhangjq Date:20160904 for:1332 【系统图标统一调整】讲{系统管理模块}{在线开发}的链接按钮,改成ace风格 -->
  32. <t:dgDelOpt title="common.delete" url="autoFormDbController.do?doDel&id={id}" urlclass="ace_button" urlfont="fa-trash-o"/>
  33. <!--add-start--Author:luobaoli Date:20150626 for:新增表单数据源预览操作-->
  34. <t:dgFunOpt title="form.db.preview" funname="goView(id)" urlclass="ace_button" urlfont="fa-search"></t:dgFunOpt>
  35. <!--add-end--Author:luobaoli Date:20150626 for:新增表单数据源预览操作-->
  36. <!-- //update-begin--Author:zhangjq Date:20160904 for:1332 【系统图标统一调整】讲{系统管理模块}{在线开发}的链接按钮,改成ace风格 -->
  37. <%-- <t:dgToolBar title="common.add" icon="icon-add" operationCode="add" url="autoFormDbController.do?goAdd" funname="add" height="600"></t:dgToolBar> --%>
  38. <t:dgToolBar title="common.edit" icon="icon-edit" operationCode="edit" url="autoFormDbController.do?goUpdate" funname="update" height="600"></t:dgToolBar>
  39. <t:dgToolBar title="common.view" icon="icon-search" url="autoFormDbController.do?goUpdate" funname="detail"></t:dgToolBar>
  40. <t:dgToolBar title="common.batch.delete" icon="icon-remove" operationCode="remove" url="autoFormDbController.do?doBatchDel" funname="deleteALLSelect"></t:dgToolBar>
  41. </t:datagrid>
  42. </div>
  43. </div>
  44. <script type="text/javascript">
  45. $(document).ready(function(){
  46. //给时间控件加上样式
  47. $("#autoFormDbListtb").find("input[name='createDate']").attr("class","Wdate").click(function(){WdatePicker({dateFmt:'yyyy-MM-dd'});});
  48. $("#autoFormDbListtb").find("input[name='updateDate']").attr("class","Wdate").click(function(){WdatePicker({dateFmt:'yyyy-MM-dd'});});
  49. });
  50. //导入
  51. function ImportXls() {
  52. openuploadwin('Excel导入', 'autoFormDbController.do?upload', "autoFormDbList");
  53. }
  54. //导出
  55. function ExportXls() {
  56. JeecgExcelExport("autoFormDbController.do?exportXls","autoFormDbList");
  57. }
  58. //模板下载
  59. function ExportXlsByT() {
  60. JeecgExcelExport("autoFormDbController.do?exportXlsByT","autoFormDbList");
  61. }
  62. //--add-start--Author:luobaoli Date:20150626 for:新增表单数据源预览操作
  63. //数据源预览
  64. function goView(id){
  65. openwindow('<t:mutiLang langKey="common.view"/>','autoFormDbController.do?goView&id='+id,'',600,500);
  66. }
  67. //--add-end--Author:luobaoli Date:20150626 for:新增表单数据源预览操作
  68. </script>