SMZDM00300_테이블조회.xrw 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573
  1. <?xml version="1.0" encoding="UTF-8"?>
  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>하이메드 테이블정보조회</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <tablelist/>
  11. <ownerlist>
  12. <codename/>
  13. <codevalue/>
  14. </ownerlist>
  15. <desc>
  16. <indexinfo/>
  17. <tableinfo>
  18. <tableName/>
  19. <tableSpaceName/>
  20. <cmt/>
  21. <numrows/>
  22. <lastAnalyzed/>
  23. <part/>
  24. </tableinfo>
  25. <desclist/>
  26. </desc>
  27. <table/>
  28. <tableinput/>
  29. <mstCodeList/>
  30. <commentsinput/>
  31. <pamCdgrList/>
  32. <pamCodeList/>
  33. </main>
  34. <send>
  35. <owner/>
  36. <tableName/>
  37. <likeflag/>
  38. <mstCode>
  39. <code/>
  40. <codeName/>
  41. </mstCode>
  42. <tableCmt/>
  43. <columnCmt/>
  44. <tableComments/>
  45. <pamCode>
  46. <cdGrupId/>
  47. <cdGrupNm/>
  48. </pamCode>
  49. <columnName/>
  50. </send>
  51. <init>
  52. </init>
  53. <hidden>
  54. <copyOption>0</copyOption>
  55. </hidden>
  56. <temp/>
  57. </root>
  58. </instance>
  59. <script type="javascript" ev:event="xforms-ready">
  60. <![CDATA[
  61. // 화면초기화(ownerlist설정)
  62. submit("TRZDM00301");
  63. ]]>
  64. </script>
  65. <submission id="TRZDM00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/ownerlist" resultref="/root/main/ownerlist"/>
  66. <submission id="TRZDM00302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/tablelist"/>
  67. <submission id="TRZDM00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/desc"/>
  68. <submission id="TRZDM00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/mstCode" resultref="/root/main/mstCodeList"/>
  69. <submission id="TXZDM00304" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send"/>
  70. <submission id="TXZDM00305" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send"/>
  71. <submission id="TRZDM00402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/pamCode" resultref="/root/main/pamCdgrList"/>
  72. <submission id="TRZDM00403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/pamCode" resultref="/root/main/pamCodeList"/>
  73. </model>
  74. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  75. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  76. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  77. <script type="javascript">
  78. <![CDATA[
  79. function getTableList() { // 테이블리스트 조회메소드
  80. // owner가 선택되지 않았을 경우
  81. if (model.getValue("/root/main/ownerlist") == '') {
  82. messageBox("OWNER를", "C001");
  83. // 테이블명이 입력되지 않았을 때, 혹은 테이블이 선택되지 않았을 경우
  84. } else if (model.getValue("/root/main/tableinput") == '' && model.getValue("/root/main/commentsinput") == '' ) {
  85. messageBox("테이블명 또는 COMMENTS를", "C001");
  86. // owner + table이 선택되어 있는 경우
  87. } else {
  88. model.setValue("/root/send/owner", model.getValue("/root/main/ownerlist"));
  89. model.setValue("/root/send/tableName", model.getValue("/root/main/tableinput"));
  90. model.setValue("/root/send/tableComments", model.getValue("/root/main/commentsinput"));
  91. model.setValue("/root/send/likeflag", true);
  92. submit("TRZDM00302");
  93. }
  94. }
  95. function fValidFormCode() {
  96. var mstCode = model.getValue("/root/send/mstCode/code");
  97. var mstCodeName = model.getValue("/root/send/mstCode/codeName");
  98. // 필수체크
  99. if ((mstCode == null || mstCode == "") && (mstCodeName == null || mstCodeName == "")) {
  100. messageBox("마스터코드 또는 마스터코드명을", "C001");
  101. return false;
  102. }
  103. // 길이체크(코드SID)
  104. if (mstCode != null && mstCode != "") {
  105. if (mstCode.length < 2) {
  106. messageBox("코드SID는 2자리 이상", "C001");
  107. return false;
  108. }
  109. }
  110. // 길이체크(코드명칭)
  111. if (mstCodeName != null && mstCodeName != "") {
  112. if (mstCodeName.length < 2) {
  113. messageBox("코드명칭은 2자리 이상", "C001");
  114. return false;
  115. }
  116. }
  117. return true;
  118. }
  119. // 원무 공통코드 조회
  120. function ifValidFormPamCode() {
  121. var pamCode = model.getValue("/root/send/pamCode/cdGrupId");
  122. var pamCodeName = model.getValue("/root/send/pamCode/cdGrupNm");
  123. // 필수체크
  124. if ((pamCode == null || pamCode == "") && (pamCodeName == null || pamCodeName == "")) {
  125. messageBox("코드군ID 또는 코드군명칭을", "C001");
  126. return false;
  127. }
  128. // 길이체크(코드SID)
  129. if (pamCode != null && pamCode != "") {
  130. if (pamCode.length < 2) {
  131. messageBox("코드SID는 2자리 이상", "C001");
  132. return false;
  133. }
  134. }
  135. // 길이체크(코드명칭)
  136. if (pamCodeName != null && pamCodeName != "") {
  137. if (pamCodeName.length < 2) {
  138. messageBox("코드군명칭은 2자리 이상", "C001");
  139. return false;
  140. }
  141. }
  142. return true;
  143. }
  144. // 마스터코드 조회
  145. function fSubmitCodeInfo() {
  146. if (fValidFormCode()) {
  147. submit("TRZDM00401");
  148. }
  149. }
  150. // 원무 공통코드 조회
  151. function fSubmitPamCodeInfo() {
  152. if (ifValidFormPamCode()) {
  153. submit("TRZDM00402");
  154. }
  155. }
  156. ]]>
  157. </script>
  158. </xhtml:head>
  159. <xhtml:body guideline="1,1211;2,789;">
  160. <caption id="caption1" class="tit_1" style="left:0px; top:0px; width:120px; height:13px; vertical-align:middle; ">테이블정보조회</caption>
  161. <button id="button2" class="btn_sw" group="tab" selected="true" style="left:10px; top:20px; width:120px; height:22px; ">
  162. <caption>테이블정보</caption>
  163. <toggle case="case1" ev:event="onclick"/>
  164. </button>
  165. <button id="button3" class="btn_sw" group="tab" style="left:130px; top:20px; width:120px; height:22px; ">
  166. <caption>마스터코드정보</caption>
  167. <toggle case="case2" ev:event="onclick"/>
  168. </button>
  169. <button id="button6" class="btn_sw" group="tab" style="left:250px; top:20px; width:120px; height:22px; ">
  170. <caption>원무공통코드정보</caption>
  171. <toggle case="case3" ev:event="onclick"/>
  172. </button>
  173. <switch id="switch1" class="sw_box" style="left:0px; top:40px; width:1200px; height:730px; ">
  174. <case id="case1" selected="true">
  175. <!-- 테이블정보 디자인 시작 -->
  176. <shape id="roundrect4" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:5px; top:10px; width:205px; height:710px; "/>
  177. <shape id="roundrect2" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:220px; top:205px; width:970px; height:515px; "/>
  178. <shape id="roundrect1" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:220px; top:10px; width:380px; height:185px; "/>
  179. <caption id="caption3" class="tit_2" style="left:15px; top:20px; width:100px; height:13px; ">OWNER</caption>
  180. <caption id="caption4" class="tit_2" style="left:15px; top:79px; width:100px; height:13px; ">TABLE</caption>
  181. <caption id="caption5" class="tit_2" style="left:230px; top:215px; width:120px; height:13px; ">COLUMN 정보</caption>
  182. <datagrid id="datagrid2" nodeset="/root/main/desc/desclist" caption="COLUMN^CONSTRAINT^TYPE^LEN^COMMENTS (본 항목의 수정은 1row씩만 가능합니다!!!)" colsep="^" colwidth="140, 90, 88, 46, 544" explorerbar="sortshowmove" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" navindex="-1" style="left:230px; top:240px; width:950px; height:470px; font-size:9pt; ">
  183. <col ref="colName"/>
  184. <col ref="constType"/>
  185. <col ref="dataType"/>
  186. <col ref="dataLength"/>
  187. <col ref="cmt" type="input"/>
  188. <script type="javascript" ev:event="ondblclick">
  189. <![CDATA[
  190. var curRow = datagrid2.row;
  191. if ( curRow > 0 ) {
  192. // 선택한 열에 대한 column 명을 클립보드에 복사
  193. var strColumnName = model.getValue("/root/main/desc/desclist["+curRow+"]/colName");
  194. if (model.getValue("/root/hidden/copyOption") == '1') {
  195. strColumnName = strColumnName + ',';
  196. } else if (model.getValue("/root/hidden/copyOption") == '2') {
  197. strColumnName = 'AND ' + strColumnName;
  198. }
  199. window.clipBoardData = strColumnName;
  200. }
  201. ]]>
  202. </script>
  203. </datagrid>
  204. <select1 id="combo_owner" ref="/root/main/ownerlist" class="combo_default" navindex="1" appearance="minimal" style="left:15px; top:39px; width:185px; height:19px; ">
  205. <choices>
  206. <itemset nodeset="/root/main/ownerlist">
  207. <label ref="codename"/>
  208. <value ref="codevalue"/>
  209. </itemset>
  210. </choices>
  211. <script type="javascript" ev:event="xforms-select">
  212. <![CDATA[
  213. model.setValue("/root/send/owner", model.getValue("/root/main/ownerlist"));
  214. // 기존의 테이블선택정보를 삭제
  215. input1.value = "";
  216. model.setValue("/root/send/tableName", "");
  217. model.setValue("/root/send/likeflag", false);
  218. submit("TRZDM00302");
  219. ]]>
  220. </script>
  221. </select1>
  222. <input id="input1" ref="/root/main/tableinput" navindex="2" imemode="alpha" validateformat="false" _chartype="upper" style="left:15px; top:120px; width:185px; height:19px; ">
  223. <script type="javascript" ev:event="onkeypress">
  224. <![CDATA[
  225. // Enter 입력 시
  226. if (event.keyCode == "13") {
  227. // 현재 입력값 노드 반영
  228. setInputNodeCurText();
  229. model.setValue("/root/send/tableName", input1.value);
  230. model.setValue("/root/send/likeflag", true);
  231. // 테이블리스트 조회메소드 호출
  232. getTableList()
  233. }
  234. ]]>
  235. </script>
  236. </input>
  237. <caption id="caption6" class="search_name" style="left:10px; top:98px; width:135px; height:17px; ">테이블명으로 검색</caption>
  238. <caption id="caption7" class="tit_2" style="left:230px; top:20px; width:100px; height:13px; ">TABLE 정보조회</caption>
  239. <input id="input2" ref="/root/main/desc/tableinfo/cmt" navindex="-1" editable="false" style="left:345px; top:93px; width:245px; height:19px; "/>
  240. <caption id="caption8" style="left:235px; top:93px; width:81px; height:20px; ">COMMENTS :</caption>
  241. <input id="input4" ref="/root/main/desc/tableinfo/lastAnalyzed" navindex="-1" editable="false" style="left:345px; top:117px; width:245px; height:19px; "/>
  242. <caption id="caption9" style="left:235px; top:165px; width:87px; height:20px; ">PARTITIONED :</caption>
  243. <input id="input5" ref="/root/main/desc/tableinfo/numrows" navindex="-1" editable="false" style="left:345px; top:141px; width:245px; height:19px; "/>
  244. <caption id="caption10" style="left:235px; top:140px; width:78px; height:20px; ">NUM_ROWS :</caption>
  245. <caption id="caption11" style="left:235px; top:117px; width:104px; height:20px; ">LAST_ANALIZED :</caption>
  246. <input id="input6" ref="/root/main/desc/tableinfo/part" navindex="-1" editable="false" style="left:345px; top:165px; width:245px; height:19px; "/>
  247. <caption id="caption12" style="left:235px; top:69px; width:95px; height:20px; ">TABLE_SPACE :</caption>
  248. <input id="input7" ref="/root/main/desc/tableinfo/tableSpaceName" navindex="-1" editable="false" style="left:345px; top:69px; width:245px; height:19px; "/>
  249. <caption id="caption13" class="search_name" style="left:10px; top:245px; width:95px; height:17px; ">테이블 선택</caption>
  250. <shape id="roundrect3" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:610px; top:10px; width:580px; height:185px; "/>
  251. <input id="input3" ref="/root/main/desc/tableinfo/tableName" navindex="-1" editable="false" style="left:345px; top:45px; width:245px; height:19px; ">
  252. <script type="javascript" ev:event="ondblclick">
  253. <![CDATA[
  254. var strTableName = model.getValue("/root/main/desc/tableinfo/tableName");
  255. if (!isNull(strTableName)) {
  256. strTableName = model.getValue("/root/main/ownerlist") + "." + strTableName;
  257. // 클립보드에 복사
  258. window.clipBoardData = strTableName;
  259. }
  260. ]]>
  261. </script>
  262. </input>
  263. <caption id="caption14" style="left:235px; top:45px; width:95px; height:20px; ">TABLE_NAME :</caption>
  264. <datagrid id="datagrid3" nodeset="/root/main/desc/indexinfo" caption="INDEX^COLUMN" colsep="^" colwidth="218, 321" mergecellsfixedrows="bycolrec" rowsep="|" navindex="-1" style="left:620px; top:45px; width:560px; height:140px; ">
  265. <col ref="indexName"/>
  266. <col ref="columnName"/>
  267. </datagrid>
  268. <caption id="caption15" class="tit_2" style="left:620px; top:20px; width:100px; height:13px; ">INDEX 정보조회</caption>
  269. <button id="button1" class="btn1_letter2" navindex="4" style="left:145px; top:199px; width:56px; height:22px; ">
  270. <caption>조회</caption>
  271. <script type="javascript" ev:event="DOMActivate">
  272. <![CDATA[
  273. // 테이블리스트 조회메소드 호출
  274. getTableList();
  275. ]]>
  276. </script>
  277. </button>
  278. <button id="button10_r" class="icon_right" navindex="-1" style="left:170px; top:243px; width:26px; height:19px; ">
  279. <caption/>
  280. <script type="javascript" ev:event="onclick">
  281. <![CDATA[
  282. datagrid1.attribute("overflow") = "scroll";
  283. datagrid1.attribute("width") = "480";
  284. ]]>
  285. </script>
  286. </button>
  287. <button id="button10_l" class="icon_left" navindex="-1" style="left:139px; top:243px; width:26px; height:19px; ">
  288. <caption/>
  289. <script type="javascript" ev:event="onclick">
  290. <![CDATA[
  291. datagrid1.attribute("overflow") = "scroll";
  292. datagrid1.attribute("width") = "185";
  293. ]]>
  294. </script>
  295. </button>
  296. <!-- 테이블정보 디자인 종료 -->
  297. <datagrid id="datagrid1" nodeset="/root/main/tablelist" caption="TABLE^COMMENTS" colsep="^" colwidth="165, 333" mergecellsfixedrows="bycolrec" rowsep="|" navindex="5" style="left:15px; top:270px; width:185px; height:440px; ">
  298. <col ref="tablename"/>
  299. <col ref="cmt"/>
  300. <script type="javascript" ev:event="ondblclick">
  301. <![CDATA[
  302. // 선택한 행 정보(테이블명) 설정
  303. model.setValue("/root/send/tableName", model.getValue("/root/main/tablelist[" + datagrid1.row + "]/tablename"));
  304. submit("TRZDM00303");
  305. ]]>
  306. </script>
  307. </datagrid>
  308. <input id="input10" ref="/root/main/commentsinput" navindex="3" imemode="hangul" validateformat="false" style="left:15px; top:170px; width:185px; height:19px; ">
  309. <script type="javascript" ev:event="onkeypress">
  310. <![CDATA[
  311. // Enter 입력 시
  312. if (event.keyCode == "13") {
  313. // 현재 입력값 노드 반영
  314. setInputNodeCurText();
  315. model.setValue("/root/send/tableName", input1.value);
  316. model.setValue("/root/send/likeflag", true);
  317. // 테이블리스트 조회메소드 호출
  318. getTableList()
  319. }
  320. ]]>
  321. </script>
  322. </input>
  323. <caption id="caption19" class="search_name" style="left:10px; top:148px; width:147px; height:17px; ">COMMENTS로 검색</caption>
  324. <button id="button5" class="btn2_letter2" navindex="-1" style="left:990px; top:214px; width:42px; height:19px; ">
  325. <caption>출력</caption>
  326. <script type="javascript" ev:event="DOMActivate">
  327. <![CDATA[
  328. exeReportPreview("RPZDM00300", "XMLSTR", "/root/send/report");
  329. ]]>
  330. </script>
  331. </button>
  332. <button id="button8" class="btn4_letter8" style="left:1040px; top:213px; width:128px; height:22px; ">
  333. <caption>COMMENTS저장</caption>
  334. <script type="javascript" ev:event="DOMActivate">
  335. <![CDATA[
  336. var curRow = datagrid2.row;
  337. if ( curRow > 0 ) {
  338. var msg = "****** 주 의 ******\r\n\r\n"
  339. + "테이블 컬럼의 코멘트 수정은 신중을 기해주시기 바랍니다.\r\n\r\n"
  340. + model.getValue("/root/main/desc/tableinfo/tableName")
  341. + "." + model.getValue("/root/main/desc/desclist["+curRow+"]/colName")
  342. + "의 코멘트를 '" + model.getValue("/root/main/desc/desclist["+curRow+"]/cmt")
  343. + "' (으)로";
  344. if(messageBox(msg, "Q012") == 6) {
  345. // 선택한 열에 대한 요약정보를 클립보드에 복사
  346. model.setValue("/root/send/owner", model.getValue("/root/main/ownerlist"));
  347. model.setValue("/root/send/tableName", model.getValue("/root/main/desc/tableinfo/tableName"));
  348. model.setValue("/root/send/columnName", model.getValue("/root/main/desc/desclist["+curRow+"]/colName"));
  349. model.setValue("/root/send/columnCmt", model.getValue("/root/main/desc/desclist["+curRow+"]/cmt"));
  350. if (submit("TXZDM00304")) {
  351. messageBox("COMMENTS수정", "I001");
  352. }
  353. }
  354. } else {
  355. messageBox("수정대상이 선택되지 않았습니다.", "C000");
  356. }
  357. ]]>
  358. </script>
  359. </button>
  360. <caption id="caption25" style="left:368px; top:218px; width:205px; height:20px; color:#ff0000; ">* 더블클릭 → COLUMN 복사</caption>
  361. <caption id="caption26" style="left:348px; top:25px; width:237px; height:20px; color:#ff0000; ">* 더블클릭 → OWNER.TABLE_NAME 복사</caption>
  362. <caption id="caption27" style="left:545px; top:218px; width:72px; height:20px; ">* 복사옵션 :</caption>
  363. <select1 id="radio1" ref="/root/hidden/copyOption" appearance="full" cellspacing="8" cols="3" overflow="visible" style="left:615px; top:219px; width:180px; height:20px; border-style:none; ">
  364. <choices>
  365. <item>
  366. <label>없음</label>
  367. <value>0</value>
  368. </item>
  369. <item>
  370. <label>comma</label>
  371. <value>1</value>
  372. </item>
  373. <item>
  374. <label>AND</label>
  375. <value>2</value>
  376. </item>
  377. </choices>
  378. </select1>
  379. </case>
  380. <case id="case2">
  381. <!-- 마스터코드정보 디자인 시작 -->
  382. <shape id="roundrect5" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:10px; top:10px; width:660px; height:60px; "/>
  383. <caption id="caption16" style="left:25px; top:40px; width:55px; height:20px; vertical-align:middle; ">코드SID</caption>
  384. <input id="input8" ref="/root/send/mstCode/code" navindex="1" imemode="alpha" _chartype="upper" style="left:75px; top:40px; width:200px; height:19px; ">
  385. <script type="javascript" ev:event="onkeypress">
  386. <![CDATA[
  387. // Enter 입력 시
  388. if (event.keyCode == "13") {
  389. // 현재 입력값 노드 반영
  390. setInputNodeCurText();
  391. model.setValue("/root/send/mstCode/code", input8.value);
  392. // 코드리스트 조회메소드 호출
  393. fSubmitCodeInfo();
  394. }
  395. ]]>
  396. </script>
  397. </input>
  398. <button id="button4" class="btn1_letter2" navindex="3" style="left:600px; top:40px; width:56px; height:22px; ">
  399. <caption>조회</caption>
  400. <script type="javascript" ev:event="DOMActivate">
  401. <![CDATA[
  402. fSubmitCodeInfo();
  403. ]]>
  404. </script>
  405. </button>
  406. <input id="input9" ref="/root/send/mstCode/codeName" navindex="2" imemode="hangul" style="left:370px; top:40px; width:200px; height:19px; ">
  407. <script type="javascript" ev:event="onkeypress">
  408. <![CDATA[
  409. // Enter 입력 시
  410. if (event.keyCode == "13") {
  411. // 현재 입력값 노드 반영
  412. setInputNodeCurText();
  413. model.setValue("/root/send/mstCode/codeName", input9.value);
  414. // 코드리스트 조회메소드 호출
  415. fSubmitCodeInfo();
  416. }
  417. ]]>
  418. </script>
  419. </input>
  420. <caption id="caption2" style="left:315px; top:40px; width:55px; height:20px; vertical-align:middle; ">코드명칭</caption>
  421. <shape id="roundrect6" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:10px; top:80px; width:1175px; height:635px; "/>
  422. <datagrid id="datagrid4" nodeset="/root/main/mstCodeList" caption="코드SID^코드군ID^코드ID^코드명칭^코드값^코드상세내용^코드출력순서^코드유효시작일자^코드유효종료일자" colsep="^" colwidth="110, 90, 72, 210, 79, 252, 82, 130, 110" mergecellsfixedrows="bycolrec" rowsep="|" navindex="-1" style="left:20px; top:110px; width:1155px; height:595px; ">
  423. <col ref="cdsid"/>
  424. <col ref="cdgrupid"/>
  425. <col ref="cdid"/>
  426. <col ref="cdnm"/>
  427. <col ref="cdval"/>
  428. <col ref="detldesc"/>
  429. <col ref="dispseq"/>
  430. <col ref="valifromdd" format="yyyy-mm-dd"/>
  431. <col ref="valitodd" format="yyyy-mm-dd"/>
  432. </datagrid>
  433. <caption id="caption17" class="tit_2" style="left:25px; top:20px; width:160px; height:13px; ">마스터코드 조회조건</caption>
  434. <caption id="caption18" class="tit_2" style="left:25px; top:90px; width:160px; height:13px; ">마스터코드리스트</caption>
  435. <!-- 마스터코드정보 디자인 종료 -->
  436. </case>
  437. <case id="case3">
  438. <!-- 마스터코드정보 디자인 시작 -->
  439. <shape id="roundrect7" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:10px; top:10px; width:660px; height:60px; "/>
  440. <caption id="caption20" style="left:25px; top:40px; width:57px; height:20px; vertical-align:middle; ">코드군ID</caption>
  441. <input id="input11" ref="/root/send/pamCode/cdGrupId" navindex="1" imemode="alpha" _chartype="upper" style="left:80px; top:40px; width:200px; height:19px; ">
  442. <script type="javascript" ev:event="onkeypress">
  443. <![CDATA[
  444. // Enter 입력 시
  445. if (event.keyCode == "13") {
  446. // 현재 입력값 노드 반영
  447. setInputNodeCurText();
  448. model.setValue("/root/send/pamCode/cdGrupId", input11.value);
  449. // 코드리스트 조회메소드 호출
  450. fSubmitPamCodeInfo();
  451. }
  452. ]]>
  453. </script>
  454. </input>
  455. <button id="button7" class="btn1_letter2" navindex="3" style="left:600px; top:40px; width:56px; height:22px; ">
  456. <caption>조회</caption>
  457. <script type="javascript" ev:event="DOMActivate">
  458. <![CDATA[
  459. fSubmitPamCodeInfo();
  460. ]]>
  461. </script>
  462. </button>
  463. <input id="input12" ref="/root/send/pamCode/cdGrupNm" navindex="2" imemode="hangul" style="left:385px; top:40px; width:200px; height:19px; ">
  464. <script type="javascript" ev:event="onkeypress">
  465. <![CDATA[
  466. // Enter 입력 시
  467. if (event.keyCode == "13") {
  468. // 현재 입력값 노드 반영
  469. setInputNodeCurText();
  470. model.setValue("/root/send/pamCode/cdGrupNm", input12.value);
  471. // 코드리스트 조회메소드 호출
  472. fSubmitPamCodeInfo();
  473. }
  474. ]]>
  475. </script>
  476. </input>
  477. <caption id="caption21" style="left:315px; top:40px; width:65px; height:20px; vertical-align:middle; ">코드군명칭</caption>
  478. <shape id="roundrect8" appearance="roundrect" ellipsewidth="20" ellipseheight="20" style="left:10px; top:80px; width:1175px; height:635px; "/>
  479. <datagrid id="datagrid5" nodeset="/root/main/pamCdgrList" caption="코드군ID^기관코드^코드군명칭^코드상세내용^시작일자^종료일자" colsep="^" colwidth="75, 54, 313, 454, 130, 110" mergecellsfixedrows="bycolrec" rowsep="|" navindex="-1" style="left:20px; top:115px; width:1155px; height:205px; ">
  480. <col ref="cdgrupid"/>
  481. <col ref="instcd"/>
  482. <col ref="cdgrupnm"/>
  483. <col ref="detldesc"/>
  484. <col ref="fromdd" format="yyyy-mm-dd"/>
  485. <col ref="todd" format="yyyy-mm-dd"/>
  486. <script type="javascript" ev:event="ondblclick">
  487. <![CDATA[
  488. model.setValue("/root/send/pamCode/cdGrupId", model.getValue("/root/main/pamCdgrList[" + datagrid5.row + "]/cdgrupid"));
  489. submit("TRZDM00403");
  490. ]]>
  491. </script>
  492. </datagrid>
  493. <datagrid id="datagrid6" nodeset="/root/main/pamCodeList" caption="코드군ID^코드ID^코드명칭^코드상세내용^코드출력순서^코드유효시작일자^코드유효종료일자" colsep="^" colwidth="90, 72, 210, 441, 82, 130, 110" mergecellsfixedrows="bycolrec" rowsep="|" navindex="-1" style="left:20px; top:370px; width:1155px; height:335px; ">
  494. <col ref="cdgrupid"/>
  495. <col ref="cdid"/>
  496. <col ref="cdnm"/>
  497. <col ref="detldesc"/>
  498. <col ref="dispseq"/>
  499. <col ref="fromdd" format="yyyy-mm-dd"/>
  500. <col ref="todd" format="yyyy-mm-dd"/>
  501. </datagrid>
  502. <caption id="caption22" class="tit_2" style="left:25px; top:20px; width:217px; height:14px; ">원무공통코드 조회조건</caption>
  503. <caption id="caption23" class="tit_2" style="left:25px; top:95px; width:199px; height:13px; ">원무공통코드리스트</caption>
  504. <!-- 마스터코드정보 디자인 종료 -->
  505. <caption id="caption24" class="tit_2" style="left:25px; top:345px; width:302px; height:13px; ">원무사용 공통코드군에 속한 코드 리스트</caption>
  506. <line id="out_line2" class="line_1" style="x1:20px; y1:365px; x2:1175px; y2:365px; "/>
  507. </case>
  508. </switch>
  509. </xhtml:body>
  510. </xhtml:html>