| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363 |
- <!DOCTYPE html>
- <html>
- <head>
- <title>表单数据源</title>
- <script type="text/javascript" src="plug-in/mutiLang/zh-cn.js"></script>
- <script type="text/javascript" src="plug-in/jquery/jquery-1.9.0.js"></script>
- <script type="text/javascript" src="plug-in/jquery/jquery.cookie.js"></script>
- <script type="text/javascript" src="plug-in/jquery-plugs/storage/jquery.storageapi.min.js"></script>
- <script type="text/javascript" src="plug-in/tools/dataformat.js"></script>
- <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/easyui.css" type="text/css"></link>
- <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/main.css" type="text/css"></link>
- <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/icon.css" type="text/css"></link>
- <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/accordion.css"></link>
- <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/icons.css"></link>
- <script type="text/javascript" src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
- <script type="text/javascript" src="plug-in/easyui/locale/zh-cn.js"></script>
- <script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
- <script type="text/javascript" src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
- <script type="text/javascript" src="plug-in/My97DatePicker/WdatePicker.js"></script>
- <link rel="stylesheet" href="plug-in/tools/css/metrole/common.css" type="text/css"></link>
- <link rel="stylesheet" href="plug-in/ace/css/font-awesome.css" type="text/css"></link>
- <script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
- <script type="text/javascript" src="plug-in/ace/js/bootstrap-tab.js"></script>
- <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
- <script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
- <script type="text/javascript" src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
- <script type="text/javascript" src="plug-in/tools/json2.js"></script>
- <link rel="stylesheet" href="plug-in/Validform/css/metrole/style.css" type="text/css" />
- <link rel="stylesheet" href="plug-in/Validform/css/metrole/tablefrom.css" type="text/css" />
- <script type="text/javascript" src="plug-in/Validform/js/Validform_v5.3.1_min_zh-cn.js"></script>
- <script type="text/javascript" src="plug-in/Validform/js/Validform_Datatype_zh-cn.js"></script>
- <script type="text/javascript" src="plug-in/Validform/js/datatype_zh-cn.js"></script>
- <SCRIPT type="text/javascript" src="plug-in/Validform/plugin/passwordStrength/passwordStrength-min.js"></SCRIPT>
- <script type="text/javascript" src = "content/autoform/autoFormDb.js"></script>
- <script type="text/javascript">
- jQuery(document).ready(function() {
- jQuery('#tt').tabs({
- onSelect: function(title) {
- jQuery('#tt .panel-body').css('width', 'auto');
- }
- });
- jQuery(".tabs-wrap").css('width', '100%');
- });
- jQuery(function() {
- jQuery("#autoFormDbField").load("autoFormDbController.do?autoFormDbFieldList_vm&id=${autoFormDbPage.id}");
- jQuery("#autoFormParam").load("autoFormDbController.do?autoFormParamList_vm&id=${autoFormDbPage.id}");
- jQuery("#autoFormDbFieldForTable").load("autoFormDbController.do?autoFormDbFieldForTableList_vm&id=${autoFormDbPage.id}");
- });
- jQuery(function() {
- hideDataSourceAndDataTable();
- jQuery("input[name='dbType']").change(function() {
- jQuery(".formdbdiv").hide();
- jQuery("#" + jQuery(this).val() + "_div").show();
- hideDataSourceAndDataTable();
- });
- });
-
- function hideDataSourceAndDataTable() {
- var checkedVal = jQuery("input[name='dbType']:checked").val();
- if (checkedVal == 'table') {
- jQuery("#dataSourceTr").hide();
- } else {
- jQuery("#dataSourceTr").show();
- }
- }
- function setDataSourceVal() {
- var checkedVal = jQuery("input[name='dbType']:checked").val();
- if (checkedVal == 'table') {
- jQuery("#tbDbKey").val(jQuery("#dbKey").find("option:selected").val());
- jQuery("#tbDbTableName").val(jQuery("#dbTableName").find("option:selected").val());
- }
- }
- jQuery(function() {
- jQuery("#formobj").Validform({
- tiptype: 3,
- btnSubmit: "#btn_sub",
- btnReset: "#btn_reset",
- ajaxPost: true,
- usePlugin: {
- passwordstrength: {
- minLen: 6,
- maxLen: 18,
- trigger: function(obj, error) {
- if (error) {
- obj.parent().next().find(".Validform_checktip").show();
- obj.find(".passwordStrength").hide();
- } else {
- jQuery(".passwordStrength").show();
- obj.parent().next().find(".Validform_checktip").hide();
- }
- }
- }
- },
- callback: function(data) {
- var win = frameElement.api.opener;
- if (data.success == true) {
- frameElement.api.close();
- win.tip(data.msg);
- } else {
- if (data.responseText == '' || data.responseText == undefined) {
- jQuery.messager.alert('错误', data.msg);
- jQuery.Hidemsg();
- } else {
- try {
- var emsg = data.responseText.substring(data.responseText.indexOf('错误描述'), data.responseText.indexOf('错误信息'));
- jQuery.messager.alert('错误', emsg);
- jQuery.Hidemsg();
- } catch(ex) {
- jQuery.messager.alert('错误', data.responseText + "");
- jQuery.Hidemsg();
- }
- }
- return false;
- }
- win.reloadTable();
- }
- });
- });
- </script>
- </head>
- <body style="overflow-x: hidden;">
- <form id="formobj" action="autoFormDbController.do?doAdd" name="formobj" method="post">
- <input type="hidden" id="btn_sub" class="btn_sub" />
- <input id="id" name="id" type="hidden" value="$!{autoFormDbPage.id}" />
- <input id="createName" name="createName" type="hidden" value="$!{autoFormDbPage.createName}" />
- <input id="createBy" name="createBy" type="hidden" value="$!{autoFormDbPage.createBy}" />
- <input id="updateName" name="updateName" type="hidden" value="$!{autoFormDbPage.updateName}" />
- <input id="updateBy" name="updateBy" type="hidden" value="$!{autoFormDbPage.updateBy}" />
- <input id="sysOrgCode" name="sysOrgCode" type="hidden" value="$!{autoFormDbPage.sysOrgCode}" />
- <input id="sysCompanyCode" name="sysCompanyCode" type="hidden" value="$!{autoFormDbPage.sysCompanyCode}" />
- <input id="createDate" name="createDate" type="hidden" value="$!{autoFormDbPage.createDate}" />
- <input id="updateDate" name="updateDate" type="hidden" value="$!{autoFormDbPage.updateDate}" />
- <input id="autoFormId" name="autoFormId" type="hidden" value="$!{autoFormDbPage.autoFormId}" />
- <table cellpadding="0" cellspacing="1" class="formtable">
- <tr>
- <td align="center" width="100px">
- <label class="Validform_label">数据源编码:</label></td>
- <td class="value">
- <input id="dbName" name="dbName" type="text" style="width: 150px" ajaxurl="autoFormDbController.do?checkDbName" class="inputxt" errorMsg="不能为中文" nullmsg="数据源编码不能为空!" datatype="/^[A-Za-z\d-._]+$/" />
- <span class="Validform_checktip"></span>
- </td>
- <td align="center" width="100px">
- <label class="Validform_label">数据源名称:</label></td>
- <td class="value" colspan="2">
- <input id="dbChName" name="dbChName" type="text" style="width: 150px" class="inputxt" datatype="*" nullmsg="数据源名称不能为空!" />
- <span class="Validform_checktip"></span>
- </td>
- </tr>
- <tr>
- <td align="center" width="100px">
- <label class="Validform_label">数据源类型:</label></td>
- <td class="value">
- <input type="radio" name="dbType" value="table" />数据库表
- <input type="radio" name="dbType" checked="checked" value="sql" />动态SQL
- <input type="radio" name="dbType" value="clazz" />java类
- <span class="Validform_checktip"></span></td>
- <td align="center" width="100px">
- <label class="Validform_label">
- <b>动态数据源:</b>
- </label>
- </td>
- <td class="value">
- <select id="dbKey" name="dbKey">
- <option value="" selected="selected">--动态数据源--</option>
- #if($!{dynamicDataSourceEntitys})
- #foreach($!{info} in $!{dynamicDataSourceEntitys})
- <option value="${info.dbKey}">${info.dbKey}</option>
- #end
- #end
- </select>
- <span class="Validform_checktip"></span>
- </td>
- </tr>
- <tr id="dataSourceTr">
- <td align="center">
- <label class="Validform_label">填报数据源:</label></td>
- <td class="value">
- <select id="tbDbKey" name="tbDbKey">
- <option value="" selected="selected">--平台数据源--</option>
- #if($!{dynamicDataSourceEntitys})
- #foreach($!{info} in $!{dynamicDataSourceEntitys})
- <option value="${info.dbKey}">${info.dbKey}</option>
- #end
- #end
- </select>
- <span class="Validform_checktip"></span>
- </td>
- <td align="center">
- <label class="Validform_label">填报数据库表:</label></td>
- <td class="value">
- <select id="tbDbTableName" name="tbDbTableName">
- <option value="">--请选择--</option>
- #if($!{tableNames})
- #foreach($!{info} in $!{tableNames})
- <option value="${info}">${info}</option>
- #end
- #end
- </select>
- <span class="Validform_checktip"></span>
- </td>
- <td class="value"></td>
- </tr>
- </table>
- <div style="margin-top: 20px;border: 1px solid #E6E6E6;display: none" id="table_div" class="formdbdiv">
- <table cellpadding="0" cellspacing="1" class="formtable">
- <tr>
- <td align="right">
- <label class="Validform_label">数据源:</label></td>
- <td class="value">
- <select id="dbKey" name="dbKey">
- <option value="">平台数据源</option>
- #if($!{dynamicDataSourceEntitys})
- #foreach($!{info} in $!{dynamicDataSourceEntitys})
- <option value="${info.dbKey}">${info.dbKey}</option>
- #end
- #end
- </select>
- <span class="Validform_checktip"></span>
- </td>
- <td align="right">
- <label class="Validform_label">数据库表名:</label></td>
- <td class="value">
- <select id="dbTableName" name="dbTableName">
- #if($!{tableNames})
- #foreach($!{info} in $!{tableNames})
- <option value="${info}">${info}</option>
- #end
- #end
- </select>
- <span class="Validform_checktip"></span>
- </td>
- <td class="value"></td>
- </tr>
- <tr>
- <td class="value" colspan="5">
- <div style="width:100%;height:100%" title="表单数据表" id="autoFormDbFieldForTable"></div>
- </td>
- </tr>
- </table>
- </div>
- <div style="margin-top: 5px;border: 1px solid #E6E6E6" id="sql_div" class="formdbdiv">
- <table cellpadding="0" cellspacing="1" style="width: 100%">
- <tr>
- <td align="right" width="95px">
- <label class="Validform_label">动态查询SQ:</label>
- </td>
- <td class="value" colspan="3" align="center">
- <span id="dbDynSqlButton"></span>
- </td>
- </tr>
- <tr>
- <td class="value" colspan="4">
- <div style="width:100%;border: 1px solid #E6E6E6">
- <textarea id="dbDynSql" style="width:99%;border-style: inset;" class="inputxt" rows="10" name="dbDynSql"></textarea>
- <p>
- 您可以键入“”作为一个参数,这里abc是参数的名称。例如:<br/>
- select * from table where id = ${abc}。<br/>
- select * from table where id = '${abc}'(如果id字段为字符串类型)
- </p>
- </div>
- </td>
- </tr>
- <tr>
- <td class="value" colspan="4">
- <fieldset style="border: 1px solid #E6E6E6;">
- <legend>查询参数</legend>
- <div style="width:100%;height:100%" title="form.db.query.param" id="autoFormParam"></div>
- </fieldset>
- </td>
- </tr>
- <tr>
- <td class="value" colspan="4">
- <fieldset style="border: 1px solid #E6E6E6;">
- <legend>查询数据列</legend>
- <div style="width:100%;height:100%" title="form.db.query.data.column" id="autoFormDbField"></div>
- </fieldset>
- </td>
- </tr>
- </table>
- </div>
- <div style="margin-top: 5px;border: 1px solid #E6E6E6;display: none" id="clazz_div" class="formdbdiv">JAVA类配置</div>
- </form>
- <!-- 添加 附表明细 模版 -->
- <table style="display:none">
- <tbody id="add_autoFormDbField_table_template">
- <tr>
- <td align="center">
- <div style="width: 40px;" name="xh"></div>
- </td>
- <td align="center">
- <input style="width:20px;" type="checkbox" name="ck" />
- </td>
- <td align="left">
- <input name="autoFormDbFieldList[#index#].fieldName" maxlength="32" type="text" class="inputxt" style="width:120px;">
- </td>
- <td align="left">
- <input name="autoFormDbFieldList[#index#].fieldText" maxlength="50" type="text" class="inputxt" style="width:120px;">
- </td>
- <td align="center">
- <div style="width: 50px;" align="center">[
- <a name="delAutoFormDbFieldOneBtn" href="javascript:void(0)" onclick="deleteOne(this)">删除</a>]
- </div>
- </td>
- </tr>
- </tbody>
- <tbody id="add_autoFormParam_table_template">
- <tr>
- <td align="center">
- <div style="width: 40px;" name="xh"></div>
- </td>
- <td align="center">
- <input style="width:20px;" type="checkbox" name="ck" />
- </td>
- <td align="left">
- <input name="autoFormParamList[#index#].paramName" maxlength="32" type="text" class="inputxt" style="width:120px;" datatype="*">
- <label class="Validform_label" style="display: none;">参数</label>
- </td>
- <td align="left">
- <input name="autoFormParamList[#index#].paramDesc" maxlength="32" type="text" class="inputxt" style="width:120px;">
- <label class="Validform_label" style="display: none;">参数文本</label>
- </td>
- <td align="left">
- <input name="autoFormParamList[#index#].paramValue" maxlength="32" type="text" class="inputxt" style="width:120px;">
- <label class="Validform_label" style="display: none;">默认值</label>
- </td>
- <td align="left">
- <input name="autoFormParamList[#index#].seq" maxlength="32" type="text" class="inputxt" style="width:120px;">
- <label class="Validform_label" style="display: none;">排序</label>
- </td>
- <td align="center">
- <div style="width: 50px;" align="center">[
- <a class="delAutoFormParamOneBtn" href="javascript:void(0)" onclick="deleteOne(this)">删除</a>]
- </div>
- </td>
- </tr>
- </tbody>
- <tbody id="add_autoFormDbFieldForTable_table_template">
- <tr>
- <td align="center">
- <div style="width: 40px;" name="xh"></div>
- </td>
- <td align="center">
- <input style="width:20px;" type="checkbox" name="ck" />
- </td>
- <td align="left">
- <input name="autoFormDbFieldList[#index#].fieldName" maxlength="32" type="text" class="inputxt" style="width:120px;">
- </td>
- <td align="left">
- <input name="autoFormDbFieldList[#index#].fieldText" maxlength="50" type="text" class="inputxt" style="width:120px;">
- </td>
- <td align="center">
- <div style="width: 50px;" align="center">[
- <a name="delAutoFormDbFieldForTableOneBtn" href="javascript:void(0)" onclick="deleteOne(this)">删除</a>]
- </div>
- </td>
- </tr>
- </tbody>
- </table>
- </body>
- </html>
|