SMZDD00102_ERUpload.xrw 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>Untitle</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <grid>
  11. <entcomment/>
  12. <entname/>
  13. <entdefinition/>
  14. <colname/>
  15. <coltype/>
  16. <colnull/>
  17. <colcomment/>
  18. <coldefinition/>
  19. <colnote/>
  20. <colpk/>
  21. <colfk/>
  22. </grid>
  23. </main>
  24. <selectValue1>true</selectValue1>
  25. <selectValue2>1</selectValue2>
  26. <hidden/>
  27. <send>
  28. <savedata/>
  29. </send>
  30. </root>
  31. </instance>
  32. <submission id="TRZDD00102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/grid" resultref="/root/hidden"/>
  33. </model>
  34. <script type="javascript" src="../../../com\commonweb\js\common.js"/>
  35. <script type="javascript" src="../../../com\commonweb\js\tfHelper.js"/>
  36. <script type="javascript">
  37. <![CDATA[
  38. var selectValue1 = true;
  39. var selectValue2 = 1;
  40. ]]>
  41. </script>
  42. </xhtml:head>
  43. <xhtml:body>
  44. <line id="line8" class="line_1" style="x1:0px; y1:37px; x2:1194px; y2:37px; "/>
  45. <caption id="caption20" class="tit_2" style="left:6px; top:22px; width:118px; height:14px; ">ER Script</caption>
  46. <caption id="caption1" class="tit_1" style="left:0px; top:0px; width:320px; height:14px; vertical-align:middle; ">ER Upload</caption>
  47. <button id="button2" class="btn1_letter4" style="left:1110px; top:10px; width:80px; height:22px; ">
  48. <caption>ER 저장</caption>
  49. <script type="javascript" ev:event="DOMActivate">
  50. <![CDATA[
  51. for ( i = 1; i <= grd_erlist.rows; i++)
  52. {
  53. grd_erlist.rowStatus(i) = 3;
  54. }
  55. model.makeValue("/root/send/savedata", grd_erlist.getUpdateData());
  56. submit("TRZDD00102");
  57. model.refresh();
  58. alert("ER 저장 완료");
  59. ]]>
  60. </script>
  61. <script type="javascript" ev:event="onclick">
  62. <![CDATA[
  63. ]]>
  64. </script>
  65. </button>
  66. <button id="button1" class="btn1_letter4" style="left:1020px; top:10px; width:80px; height:22px; ">
  67. <caption>ER 입력</caption>
  68. <script type="javascript" ev:event="DOMActivate">
  69. <![CDATA[
  70. var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  71. output1.text = fileName;
  72. grd_erlist.loadExcel(fileName, selectValue2, true);
  73. grd_erlist.deleteRow(1);
  74. grd_erlist.refresh();
  75. alert("ER 입력 완료");
  76. ]]>
  77. </script>
  78. <script type="javascript" ev:event="onclick">
  79. <![CDATA[
  80. ]]>
  81. </script>
  82. </button>
  83. <datagrid id="grd_erlist" nodeset="/root/main/grid" caption="ENTCOMMENT^ENTNAME^ENTDEFINITION^COLNAME^COLTYPE^COLNULL^COLCOMMENT^COLDEFINITION^COLNOTE^COLPK^COLFK" colsep="^" colwidth="98, 113, 147, 156, 127, 79, 100, 133, 105, 65, 67" dataheight="25" defaultrows="0" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:42px; width:1194px; height:528px; border-color:#808080; ">
  84. <col ref="entcomment">
  85. <choices/>
  86. </col>
  87. <col ref="entname"/>
  88. <col ref="entdefinition"/>
  89. <col ref="colname"/>
  90. <col ref="coltype"/>
  91. <col ref="colnull"/>
  92. <col ref="colcomment"/>
  93. <col ref="coldefinition"/>
  94. <col ref="colnote"/>
  95. <col ref="colpk"/>
  96. <col ref="colfk"/>
  97. </datagrid>
  98. <output id="output1" style="left:115px; top:20px; width:545px; height:15px; "/>
  99. </xhtml:body>
  100. </xhtml:html>