dataDiff.jsp 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <meta http-equiv="X-UA-Compatible" content="chrome=1, IE=edge">
  6. <head>
  7. <t:base type="jquery,easyui"></t:base>
  8. <script>
  9. var select1 = 0;
  10. var select2 = 0;
  11. var data = "";
  12. $(function(){
  13. var tableName = getPar("tableName");
  14. var dataId = getPar("dataId");
  15. var id1 = getPar("id1");
  16. var id2 = getPar("id2");
  17. var versionNumber1 = getPar("versionNumber1");
  18. var versionNumber2 = getPar("versionNumber2");
  19. $("#tableName").val(tableName);
  20. $("#dataId").val(dataId);
  21. data = [{}];
  22. data.unshift({id: id1,versionNumber: versionNumber1});
  23. data.unshift({id: id2,versionNumber: versionNumber2});
  24. data.unshift({id: '0',versionNumber: '---请选择---'});
  25. $('#versionNumber1').combobox({
  26. valueField:'id',
  27. textField:'versionNumber',
  28. panelHeight: 70,
  29. editable: false,
  30. data: data,
  31. onSelect: function(record){
  32. select1 = versionNumber1;
  33. }
  34. });
  35. $('#versionNumber2').combobox({
  36. valueField:'id',
  37. textField:'versionNumber',
  38. panelHeight: 70,
  39. editable: false,
  40. data: data,
  41. onSelect: function(record){
  42. select2 = versionNumber2;
  43. }
  44. });
  45. $('#versionNumber1').combobox("select",id1);
  46. $('#versionNumber2').combobox("select",id2);
  47. $("#tableName").change(function(){
  48. var tableNameVal = jQuery.trim($(this).val());
  49. var dataIdVal = jQuery.trim($("#dataId").val());
  50. if(tableNameVal != "" && dataIdVal != ""){
  51. $.ajax({
  52. type: "POST",
  53. url: "systemController.do?getDataVersion",
  54. data: "tableName=" + tableNameVal + "&dataId=" + dataIdVal,
  55. success: function(msg){
  56. data = jQuery.parseJSON(msg).obj;
  57. if(jQuery.isEmptyObject(data)){
  58. data = [{}];
  59. data.unshift({id: '0',versionNumber: '---无数据---'});
  60. }else{
  61. data.unshift({id: '0',versionNumber: '---请选择---'});
  62. }
  63. $('#versionNumber1').combobox({
  64. valueField:'id',
  65. textField:'versionNumber',
  66. panelHeight: 70,
  67. editable: false,
  68. data: data,
  69. onSelect: function(record){
  70. select1 = record.versionNumber;
  71. }
  72. });
  73. $('#versionNumber2').combobox({
  74. valueField:'id',
  75. textField:'versionNumber',
  76. panelHeight: 70,
  77. editable: false,
  78. data: data,
  79. onSelect: function(record){
  80. select2 = record.versionNumber;
  81. }
  82. });
  83. $('#versionNumber1').combobox("select","0");
  84. $('#versionNumber2').combobox("select","0");
  85. }
  86. });
  87. }
  88. });
  89. $("#dataId").change(function(){
  90. var dataIdVal = jQuery.trim($(this).val());
  91. var tableNameVal = jQuery.trim($("#tableName").val());
  92. if(tableNameVal != "" && dataIdVal != ""){
  93. $.ajax({
  94. type: "POST",
  95. url: "systemController.do?getDataVersion",
  96. data: "tableName=" + tableNameVal + "&dataId=" + dataIdVal,
  97. success: function(msg){
  98. data = jQuery.parseJSON(msg).obj;
  99. if(jQuery.isEmptyObject(data)){
  100. data = [{}];
  101. data.unshift({id: '0',versionNumber: '---无数据---'});
  102. }else{
  103. data.unshift({id: '0',versionNumber: '---请选择---'});
  104. }
  105. $('#versionNumber1').combobox({
  106. valueField:'id',
  107. textField:'versionNumber',
  108. panelHeight: 70,
  109. editable: false,
  110. data: data,
  111. onSelect: function(record){
  112. select1 = record.versionNumber;
  113. }
  114. });
  115. $('#versionNumber2').combobox({
  116. valueField:'id',
  117. textField:'versionNumber',
  118. panelHeight: 70,
  119. editable: false,
  120. data: data,
  121. onSelect: function(record){
  122. select2 = record.versionNumber;
  123. }
  124. });
  125. $('#versionNumber1').combobox("select","0");
  126. $('#versionNumber2').combobox("select","0");
  127. }
  128. });
  129. }
  130. });
  131. $('#btn').click(function(){
  132. var id1 = $('#versionNumber1').combobox("getValue");
  133. var id2 = $('#versionNumber2').combobox("getValue");
  134. var url = "systemController.do?diffDataVersion&id1=" + id1 + "&id2=" + id2;
  135. frameElement.api.opener.diffDataVersion(url);
  136. });
  137. })
  138. //得到get url请求参数
  139. function getPar(par){
  140. //获取当前URL
  141. var local_url = document.location.href;
  142. //获取要取得的get参数位置
  143. var get = local_url.indexOf(par +"=");
  144. if(get == -1){
  145. return false;
  146. }
  147. //截取字符串
  148. var get_par = local_url.slice(par.length + get + 1);
  149. //判断截取后的字符串是否还有其他get参数
  150. var nextPar = get_par.indexOf("&");
  151. if(nextPar != -1){
  152. get_par = get_par.slice(0, nextPar);
  153. }
  154. return get_par;
  155. }
  156. </script>
  157. </head>
  158. <body style="overflow-y: hidden" scroll="no">
  159. <t:formvalid formid="formobj" layout="table" dialog="false" action="">
  160. <table cellpadding="0" width="100%" cellspacing="1" class="formtable">
  161. <tr>
  162. <td align="right" height="40" width="15%"><span class="filedzt">数据库表名:</span></td>
  163. <td class="value" width="30%">
  164. <input type="text" class="inuptxt" name="tableName" id="tableName" datatype="*">
  165. <span class="Validform_checktip"></span>
  166. </td>
  167. <td align="right" height="40" width="15%"><span class="filedzt">数据ID:</span></td>
  168. <td class="value" width="30%">
  169. <input type="text" class="inuptxt" name="dataId" id="dataId" datatype="*">
  170. <span class="Validform_checktip"></span>
  171. </td>
  172. </tr>
  173. <tr>
  174. <td align="right" height="40" width="15%"><span class="filedzt">版本号1:</span></td>
  175. <td class="value" width="30%">
  176. <input type="text" class="inuptxt" id="versionNumber1" readonly="readonly"/>
  177. <span class="Validform_checktip"></span>
  178. </td>
  179. <td align="right" height="40" width="15%"><span class="filedzt">版本号2:</span></td>
  180. <td class="value" width="30%">
  181. <input type="text" class="inuptxt" id="versionNumber2" readonly="readonly"/>
  182. <span class="Validform_checktip"></span>
  183. </td>
  184. </tr>
  185. <tr height="40">
  186. <td class="upload" colspan="4">
  187. <a href="#" class="easyui-linkbutton" id="btn" iconCls="icon-search" style="float: right; margin-right: 10px;"> 数据比较 &nbsp;&nbsp; </a>
  188. </td>
  189. </tr>
  190. </table>
  191. </t:formvalid>
  192. </html>