cgformOfDatabase.html 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  5. <script type="text/javascript" src="../../jquery/jquery-1.9.0.js"></script>
  6. <script>
  7. var parentObj =window.parent;
  8. //var langurl = parentObj.langurl.value;
  9. var langurl = parentObj.document.getElementById("langurl").value;
  10. var mutiLangScript = "<script type='text/javascript' src='" + langurl + "'><\/script>";
  11. document.write(mutiLangScript);
  12. window.onload = function() {
  13. window.parent.iframeLoaded();
  14. }
  15. </script>
  16. </head>
  17. <body>
  18. <div>
  19. <table>
  20. <tbody id="template_header_database">
  21. <tr bgcolor="#E6E6E6">
  22. <!-- 增加序号表头 -->
  23. <th align="center" bgcolor="#EEEEEE" mutiLang_id="sequence">序号</th>
  24. <th style="display: none;"><input style="display: none;"></th>
  25. <th align="center" bgcolor="#EEEEEE" mutiLang_id="operation">操作</th>
  26. <th align="center" bgcolor="#EEEEEE" mutiLang_id="fieldname">字段名称</th>
  27. <th align="center" bgcolor="#EEEEEE" mutiLang_id="fieldremark">字段备注</th>
  28. <th align="center" bgcolor="#EEEEEE" mutiLang_id="fieldlength">字段长度</th>
  29. <th align="center" bgcolor="#EEEEEE" mutiLang_id="decimal">小数点</th>
  30. <th align="center" bgcolor="#EEEEEE" mutiLang_id="defaultvalue">默认值</th>
  31. <th align="center" bgcolor="#EEEEEE" mutiLang_id="fieldtype">字段类型</th>
  32. <th align="center" bgcolor="#EEEEEE" mutiLang_id="pk">主键</th>
  33. <th style="display: none;"><input style="display: none;"></th>
  34. <th align="center" bgcolor="#EEEEEE" mutiLang_id="allowempty">允许空值</th>
  35. </tr>
  36. </tbody>
  37. <tbody id="add_column_table_template_database">
  38. <tr>
  39. <!-- 增加行序号<a>标签 -->
  40. <td style="width: 30px;" ><a name="rownumber[#rindex#]"></a></td>
  41. <td style="display: none;"><input style="display: none;" name="columns[#index#].id"
  42. value=""></td>
  43. <td align="left"><input style="width: 30px;" type="checkbox"
  44. name="ck" /></td>
  45. <td align="left">
  46. <input style="width: 120px;" type="text" name="columns[#index#].fieldName" nullmsg="pleaseinputfilename"
  47. datatype="s1-30,/^[a-z\d_]+$/" errormsg="filenamecannotuppercase" class="fieldNameInput" />
  48. <input style="width: 120px;" type="hidden" name="columns[#index#].oldFieldName" />
  49. </td>
  50. <td align="left">
  51. <input style="width: 120px;" type="text" name="columns[#index#].content" nullmsg="pleaseinputfilecomment"
  52. datatype="s2-14" errormsg="fieldcommentfromtwotofourteen" class="contentInput" />
  53. </td>
  54. <td align="left">
  55. <input name="columns[#index#].length" nullmsg="pleaseinputfilelength" datatype="n1-4" errormsg="fieldlengthfromonetofour"
  56. maxlength="4" type="text" value="32" style="width: 60px;">
  57. </td>
  58. <td align="left">
  59. <input name="columns[#index#].pointLength" nullmsg="pleaseinputdicemallength" datatype="n1-2" errormsg="dicemallengthfromonetotwo"
  60. type="text" value="0" style="width: 60px;">
  61. </td>
  62. <td align="left">
  63. <input name="columns[#index#].fieldDefault" datatype="*1-20" errormsg="defaultvaluelessthantwenty" ignore="ignore"
  64. type="text" value="" style="width: 60px;">
  65. </td>
  66. <td align="left">
  67. <select name="columns[#index#].type">
  68. <option value="string">String</option>
  69. <option value="int">Integer</option>
  70. <option value="double">Double</option>
  71. <option value="Date">Date</option>
  72. <option value="BigDecimal">BigDecimal</option>
  73. <option value="Text">Text</option>
  74. <option value="Blob">Blob</option>
  75. </select>
  76. </td>
  77. <td align="left">
  78. <input type="checkbox" style="width: 30px;" name="columns[#index#].isKey">
  79. </td>
  80. <td align="left" style="display: none;">
  81. <input name="columns[#index#].orderNum" maxlength="2" nullmsg="pleaseinputfieldsquence" datatype="n1-2"
  82. errormsg="fieldsquencefromonetotwo" type="hidden" value="0"
  83. style="display: none;">
  84. </td>
  85. <td align="left">
  86. <input type="checkbox" style="width: 50px;" name="columns[#index#].isNull" checked="checked">
  87. </td>
  88. </tr>
  89. </tbody>
  90. </table>
  91. </div>
  92. </body>
  93. </html>
  94. <script>
  95. $(document).ready(function(){
  96. $("[mutiLang_id]").each(function() {
  97. this.innerText = eval(this.attributes["mutiLang_id"].value);
  98. });
  99. $("input:text").each(function(){
  100. var nullmsg = $(this).attr("nullmsg");
  101. var errormsg = $(this).attr("errormsg");
  102. if (typeof(nullmsg) != "undefined")
  103. {
  104. this.attributes["nullmsg"].value = eval(nullmsg);
  105. }
  106. if (typeof(errormsg) != "undefined")
  107. {
  108. this.attributes["errormsg"].value = eval(errormsg);
  109. }
  110. });
  111. /*update-start--Author:gengjiajia Date:20160804 for:如果表类型是“配置表”,则online表单配置的第一个tab\索引tab\外键都不允许修改,禁掉。*/
  112. var tableType = parentObj.document.getElementById("tableType").value;
  113. if(tableType == '1'){
  114. $("#add_column_table_template_database").find("input[name*='columns']").each(function(){
  115. var nameval = ($(this).attr("name"));
  116. $("input[name='"+nameval+"']").attr("readonly","readonly");
  117. });
  118. $("select[name*='columns']").attr("disabled",true);
  119. $("input:checkbox").attr("disabled",true);
  120. }
  121. /*update-end--Author:gengjiajia Date:20160804 for:如果表类型是“配置表”,则online表单配置的第一个tab\索引tab\外键都不允许修改,禁掉。*/
  122. })
  123. </script>