SMZBC00200_코드관계관리.xfdl 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMZBC00200" position="absolute 0 0 1238 795" titletext="코드관계 관리" oninit="SMZBC00200_oninit" onload="SMZBC00200_onload">
  5. <Layouts>
  6. <Layout>
  7. <Button id="btn_save" taborder="1" text="적용" class="btn4" position="absolute 1111 3 1167 23" anchor="top right" onclick="btn_save_onclick"/>
  8. <Button id="btn_init" taborder="2" text="초기화" class="btn4" position="absolute 1170 3 1238 23" anchor="top right"/>
  9. <Static id="caption6" text="코드 관계 관리" class="tit_1" position="absolute 0 0 119 25"/>
  10. <Div id="group2" taborder="3" position="absolute 0 24 1238 65" class="div_SA" anchor="left top right">
  11. <Layouts>
  12. <Layout>
  13. <Shape id="line13" linetype="vertical" position="absolute 1146 11 1152 31" anchor="top right"/>
  14. <Edit id="ipt_search" taborder="1" class="input_search" position="absolute 110 11 210 31" onkeydown="group2_ipt_search_onkeydown" autoselect="true" inputmode="upper"/>
  15. <Button id="btn_search" taborder="2" text="조회" class="btn1" position="absolute 1163 11 1219 31" anchor="top right" onclick="group2_btn_search_onclick"/>
  16. <Static id="caption2" text="코드군 ID :" class="search_name" position="absolute 15 11 111 31" anchor="default"/>
  17. <Button id="Button00" taborder="3" position="absolute 213 11 233 31" class="icon_search" anchor="default" onclick="group2_Button00_onclick"/>
  18. </Layout>
  19. </Layouts>
  20. </Div>
  21. <Static id="caption1" text="하위코드군 목록" class="tit_2" position="absolute 0 418 614 438"/>
  22. <Static id="caption3" text="상위 코드 목록" class="tit_2" position="absolute 622 81 1236 101" anchor="left top right"/>
  23. <Static id="caption4" text="하위 코드 목록" class="tit_2" position="absolute 622 416 1236 436" anchor="left top right"/>
  24. <Shape id="line4" linetype="vertical" class="line_2" position="absolute 0 179 1194 185"/>
  25. <Shape id="line3" linetype="vertical" class="line_2" position="absolute 0 155 1194 161"/>
  26. <Shape id="line2" linetype="vertical" class="line_2" position="absolute 0 131 1194 137"/>
  27. <Shape id="line6" linetype="vertical" class="line_2" position="absolute 0 107 1194 113"/>
  28. <Static id="caption20" text="상위코드군 목록" class="tit_2" position="absolute 0 81 614 101"/>
  29. <Shape id="line8" class="line_10" position="absolute 0 98 1238 104" anchor="left top right"/>
  30. <Grid id="grd_supcdgruplist" taborder="4" binddataset="ds_main_supcodegroup" useinputpanel="false" position="absolute 0 103 616 402" oncelldblclick="grd_supcdgruplist_oncelldblclick" treeuseimage="false">
  31. <Formats>
  32. <Format id="default">
  33. <Columns>
  34. <Column size="150"/>
  35. <Column size="200"/>
  36. <Column size="0"/>
  37. <Column size="0"/>
  38. <Column size="0"/>
  39. <Column size="100"/>
  40. <Column size="100"/>
  41. <Column size="100"/>
  42. <Column size="100"/>
  43. <Column size="100"/>
  44. <Column size="100"/>
  45. <Column size="0"/>
  46. <Column size="0"/>
  47. <Column size="0"/>
  48. <Column size="0"/>
  49. <Column size="0"/>
  50. <Column size="0"/>
  51. <Column size="0"/>
  52. </Columns>
  53. <Rows>
  54. <Row size="24" band="head"/>
  55. <Row size="24"/>
  56. </Rows>
  57. <Band id="head">
  58. <Cell text="코드군ID"/>
  59. <Cell col="1" text="코드군명"/>
  60. <Cell col="2" text="코드길이"/>
  61. <Cell col="3" text="코드군설명"/>
  62. <Cell col="4" text="출력순서"/>
  63. <Cell col="5" text="유효시작일자"/>
  64. <Cell col="6" text="유효종료일자"/>
  65. <Cell col="7" text="권한기관코드"/>
  66. <Cell col="8" text="권한기관명"/>
  67. <Cell col="9" text="권한부서코드"/>
  68. <Cell col="10" text="권한부서명"/>
  69. <Cell col="11" text="최초등록자ID"/>
  70. <Cell col="12" text="최초등록자이름"/>
  71. <Cell col="13" text="최초등록일시"/>
  72. <Cell col="14" text="최종수정자ID"/>
  73. <Cell col="15" text="최종수정자이름"/>
  74. <Cell col="16" text="최종수정일시"/>
  75. <Cell col="17" text="레 벨"/>
  76. </Band>
  77. <Band id="body">
  78. <Cell displaytype="tree" edittype="tree" text="bind:cdgrupid" treestartlevel="1" treelevel="bind:level"/>
  79. <Cell col="1" displaytype="text" text="bind:cdgrupnm"/>
  80. <Cell col="2" text="bind:cdlgth"/>
  81. <Cell col="3" text="bind:detldesc"/>
  82. <Cell col="4" text="bind:dispseq"/>
  83. <Cell col="5" displaytype="date" text="bind:valifromdd" mask="yyyy-mm-dd"/>
  84. <Cell col="6" displaytype="date" text="bind:valitodd" mask="yyyy-mm-dd"/>
  85. <Cell col="7" text="bind:authinstcd"/>
  86. <Cell col="8" displaytype="text" text="bind:authinstnm"/>
  87. <Cell col="9" displaytype="text" text="bind:authdeptcd"/>
  88. <Cell col="10" displaytype="text" text="bind:authdeptnm"/>
  89. <Cell col="11" text="bind:fstrgstrid"/>
  90. <Cell col="12" text="bind:fstrgstrnm"/>
  91. <Cell col="13" text="bind:fstrgstdt" mask="yyyy-mm-dd hh:nn:ss"/>
  92. <Cell col="14" text="bind:lastupdtrid"/>
  93. <Cell col="15" text="bind:lastupdtrnm"/>
  94. <Cell col="16" text="bind:lastupdtdt" mask="yyyy-mm-dd hh:nn:ss"/>
  95. <Cell col="17" text="bind:level"/>
  96. </Band>
  97. </Format>
  98. </Formats>
  99. </Grid>
  100. <Grid id="grd_supcdlist" taborder="5" binddataset="ds_main_supcode" useinputpanel="false" position="absolute 622 103 1238 402" anchor="left top right" oncelldblclick="grd_supcdlist_oncelldblclick">
  101. <Formats>
  102. <Format id="default">
  103. <Columns>
  104. <Column size="203"/>
  105. <Column size="100"/>
  106. <Column size="100"/>
  107. <Column size="100"/>
  108. <Column size="125"/>
  109. <Column size="125"/>
  110. <Column size="100"/>
  111. <Column size="100"/>
  112. <Column size="100"/>
  113. <Column size="100"/>
  114. <Column size="100"/>
  115. <Column size="120"/>
  116. <Column size="80"/>
  117. </Columns>
  118. <Rows>
  119. <Row size="24" band="head"/>
  120. <Row size="24"/>
  121. </Rows>
  122. <Band id="head">
  123. <Cell text="코드 SID"/>
  124. <Cell col="1" text=" 코드군 ID"/>
  125. <Cell col="2" text="코드 ID"/>
  126. <Cell col="3" text="코드 영문 약어명"/>
  127. <Cell col="4" text="코드 이름"/>
  128. <Cell col="5" text="코드 상세설명"/>
  129. <Cell col="6" text="코드값"/>
  130. <Cell col="7" text="최소값"/>
  131. <Cell col="8" text="최대값"/>
  132. <Cell col="9" text="최소 연산자"/>
  133. <Cell col="10" text="최대 연산자"/>
  134. <Cell col="11" text="등록일"/>
  135. <Cell col="12" text="등록사번"/>
  136. </Band>
  137. <Band id="body">
  138. <Cell displaytype="text" text="bind:cdsid"/>
  139. <Cell col="1" displaytype="text" text="bind:cdgrupid"/>
  140. <Cell col="2" displaytype="text" text="bind:cdid"/>
  141. <Cell col="3" displaytype="text" text="bind:cdengabbrnm"/>
  142. <Cell col="4" displaytype="text" text="bind:cdnm"/>
  143. <Cell col="5" displaytype="text" text="bind:detldesc"/>
  144. <Cell col="6" displaytype="text" text="bind:cdval"/>
  145. <Cell col="7" displaytype="text" text="bind:minval"/>
  146. <Cell col="8" displaytype="text" text="bind:maxval"/>
  147. <Cell col="9" displaytype="text" text="bind:minopercd"/>
  148. <Cell col="10" displaytype="text" text="bind:maxopercd"/>
  149. <Cell col="11" displaytype="text" text="bind:fstrgstdt"/>
  150. <Cell col="12" text="bind:fstrgstrid"/>
  151. </Band>
  152. </Format>
  153. </Formats>
  154. </Grid>
  155. <Grid id="grd_subcdlist" taborder="6" binddataset="ds_main_subcode" useinputpanel="false" position="absolute 622 436 1238 795" anchor="all">
  156. <Formats>
  157. <Format id="default">
  158. <Columns>
  159. <Column size="24"/>
  160. <Column size="30"/>
  161. <Column size="101"/>
  162. <Column size="100"/>
  163. <Column size="100"/>
  164. <Column size="150"/>
  165. <Column size="150"/>
  166. <Column size="200"/>
  167. <Column size="100"/>
  168. <Column size="100"/>
  169. <Column size="100"/>
  170. <Column size="100"/>
  171. <Column size="100"/>
  172. </Columns>
  173. <Rows>
  174. <Row size="24" band="head"/>
  175. <Row size="24"/>
  176. </Rows>
  177. <Band id="head">
  178. <Cell/>
  179. <Cell col="1" text="선택"/>
  180. <Cell col="2" text="코드SID"/>
  181. <Cell col="3" text="코드군ID"/>
  182. <Cell col="4" text="코드ID"/>
  183. <Cell col="5" text="코드명"/>
  184. <Cell col="6" text="코드영문약어명"/>
  185. <Cell col="7" text="코드 상세설명"/>
  186. <Cell col="8" text="코드값"/>
  187. <Cell col="9" text="최소값"/>
  188. <Cell col="10" text="최대값"/>
  189. <Cell col="11" text="최소연산자"/>
  190. <Cell col="12" text="최대연산자"/>
  191. </Band>
  192. <Band id="body">
  193. <Cell/>
  194. <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:checked"/>
  195. <Cell col="2" displaytype="text" text="bind:cdsid"/>
  196. <Cell col="3" displaytype="text" text="bind:cdgrupid"/>
  197. <Cell col="4" displaytype="text" text="bind:cdid"/>
  198. <Cell col="5" displaytype="text" text="bind:cdnm"/>
  199. <Cell col="6" displaytype="text" text="bind:cdengabbrnm"/>
  200. <Cell col="7" displaytype="text" text="bind:detldesc"/>
  201. <Cell col="8" displaytype="text" text="bind:cdval"/>
  202. <Cell col="9" displaytype="text" text="bind:minval"/>
  203. <Cell col="10" displaytype="text" text="bind:maxval"/>
  204. <Cell col="11" displaytype="text" text="bind:minopercd"/>
  205. <Cell col="12" displaytype="text" text="bind:maxopercd"/>
  206. </Band>
  207. </Format>
  208. </Formats>
  209. </Grid>
  210. <Grid id="grd_subcdgruplist" taborder="7" binddataset="ds_main_subcdgrup" useinputpanel="false" position="absolute 0 436 616 795" anchor="left top bottom" oncelldblclick="grd_subcdgruplist_oncelldblclick">
  211. <Formats>
  212. <Format id="default">
  213. <Columns>
  214. <Column size="150"/>
  215. <Column size="200"/>
  216. <Column size="0"/>
  217. <Column size="0"/>
  218. <Column size="0"/>
  219. <Column size="100"/>
  220. <Column size="100"/>
  221. <Column size="100"/>
  222. <Column size="100"/>
  223. <Column size="100"/>
  224. <Column size="100"/>
  225. <Column size="0"/>
  226. <Column size="0"/>
  227. <Column size="0"/>
  228. <Column size="0"/>
  229. <Column size="0"/>
  230. <Column size="0"/>
  231. <Column size="0"/>
  232. </Columns>
  233. <Rows>
  234. <Row size="24" band="head"/>
  235. <Row size="24"/>
  236. </Rows>
  237. <Band id="head">
  238. <Cell text="코드군ID"/>
  239. <Cell col="1" text="코드군명"/>
  240. <Cell col="2" text="코드길이"/>
  241. <Cell col="3" text="코드군설명"/>
  242. <Cell col="4" text="출력순서"/>
  243. <Cell col="5" text="유효시작일자"/>
  244. <Cell col="6" text="유효종료일자"/>
  245. <Cell col="7" text="권한기관코드"/>
  246. <Cell col="8" text="권한기관명"/>
  247. <Cell col="9" text="권한부서코드"/>
  248. <Cell col="10" text="권한부서명"/>
  249. <Cell col="11" text="최초등록자ID"/>
  250. <Cell col="12" text="최초등록자이름"/>
  251. <Cell col="13" text="최초등록일시"/>
  252. <Cell col="14" text="최종수정자ID"/>
  253. <Cell col="15" text="최종수정자이름"/>
  254. <Cell col="16" text="최종수정일시"/>
  255. <Cell col="17" text="레 벨"/>
  256. </Band>
  257. <Band id="body">
  258. <Cell displaytype="text" text="bind:cdgrupid"/>
  259. <Cell col="1" displaytype="text" text="bind:cdgrupnm"/>
  260. <Cell col="2" text="bind:cdlgth"/>
  261. <Cell col="3" text="bind:detldesc"/>
  262. <Cell col="4" text="bind:dispseq"/>
  263. <Cell col="5" displaytype="date" text="bind:valifromdd" mask="yyyy-mm-dd"/>
  264. <Cell col="6" displaytype="date" text="bind:valitodd" mask="yyyy-mm-dd"/>
  265. <Cell col="7" text="bind:authinstcd"/>
  266. <Cell col="8" displaytype="text" text="bind:authinstnm"/>
  267. <Cell col="9" displaytype="text" text="bind:authdeptcd"/>
  268. <Cell col="10" displaytype="text" text="bind:authdeptnm"/>
  269. <Cell col="11" text="bind:fstrgstrid"/>
  270. <Cell col="12" text="bind:fstrgstrnm"/>
  271. <Cell col="13" text="bind:fstrgstdt" mask="yyyy-mm-dd hh:nn:ss"/>
  272. <Cell col="14" text="bind:lastupdtrid"/>
  273. <Cell col="15" text="bind:lastupdtrnm"/>
  274. <Cell col="16" text="bind:lastupdtdt" mask="yyyy-mm-dd hh:nn:ss"/>
  275. <Cell col="17" text="bind:level"/>
  276. </Band>
  277. </Format>
  278. </Formats>
  279. </Grid>
  280. </Layout>
  281. </Layouts>
  282. <Objects>
  283. <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  284. <ColumnInfo>
  285. <Column id="level" type="INT" size="256" sumtext="레벨"/>
  286. <Column id="supcdgrupid" type="STRING" size="256" sumtext="상위코드군 ID"/>
  287. <Column id="supcdgrupnm" type="STRING" size="256" sumtext="상위코드군 이름"/>
  288. </ColumnInfo>
  289. <Rows>
  290. <Row/>
  291. </Rows>
  292. </Dataset>
  293. <Dataset id="ds_main_supcodegroup" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  294. <ColumnInfo>
  295. <Column id="cdgrupid" type="STRING" size="256" sumtext="코드군ID"/>
  296. <Column id="cdgrupnm" type="STRING" size="256" sumtext="코드군이름"/>
  297. <Column id="cdlgth" type="STRING" size="256" sumtext="코드길이"/>
  298. <Column id="detldesc" type="STRING" size="256" sumtext="코드군상세설명"/>
  299. <Column id="dispseq" type="STRING" size="256" sumtext="출력순서"/>
  300. <Column id="aliasid" type="STRING" size="256" sumtext="참조코드군ID"/>
  301. <Column id="valifromdd" type="STRING" size="256" sumtext="유효시작일자"/>
  302. <Column id="valitodd" type="STRING" size="256" sumtext="유효종료일자"/>
  303. <Column id="authinstcd" type="STRING" size="256" sumtext="권한기관코드"/>
  304. <Column id="authinstnm" type="STRING" size="256" sumtext="권한기관명"/>
  305. <Column id="authdeptcd" type="STRING" size="256" sumtext="권한부서코드"/>
  306. <Column id="authdeptnm" type="STRING" size="256" sumtext="권한부서명"/>
  307. <Column id="fstrgstrid" type="STRING" size="256" sumtext="최초등록자ID"/>
  308. <Column id="fstrgstrnm" type="STRING" size="256" sumtext="최초등록자이름"/>
  309. <Column id="fstrgstdt" type="STRING" size="256" sumtext="최초등록일시"/>
  310. <Column id="lastupdtrid" type="STRING" size="256" sumtext="최종수정자ID"/>
  311. <Column id="lastupdtrnm" type="STRING" size="256" sumtext="최종수정자이름"/>
  312. <Column id="lastupdtdt" type="STRING" size="256" sumtext="최종수정일시"/>
  313. <Column id="level" type="STRING" size="256" sumtext="레벨"/>
  314. </ColumnInfo>
  315. </Dataset>
  316. <Dataset id="ds_main_subcdgrup" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  317. <ColumnInfo>
  318. <Column id="cdgrupid" type="STRING" size="256" sumtext="코드군ID"/>
  319. <Column id="cdgrupnm" type="STRING" size="256" sumtext="코드군명"/>
  320. <Column id="cdlgth" type="STRING" size="256" sumtext="코드길이"/>
  321. <Column id="detldesc" type="STRING" size="256" sumtext="코드군상세설명"/>
  322. <Column id="fstrgstrid" type="STRING" size="256" sumtext="최초등록자ID"/>
  323. <Column id="fstrgstrnm" type="STRING" size="256" sumtext="최초등록자이름"/>
  324. <Column id="fstrgstdt" type="STRING" size="256" sumtext="최초등록일시"/>
  325. <Column id="lastupdtdt" type="STRING" size="256" sumtext="최종수정일시"/>
  326. <Column id="lastupdtrid" type="STRING" size="256" sumtext="최종수정자ID"/>
  327. <Column id="lastupdtrnm" type="STRING" size="256" sumtext="최종수정자이름"/>
  328. <Column id="authinstcd" type="STRING" size="256" sumtext="권한기관코드"/>
  329. <Column id="authinstnm" type="STRING" size="256" sumtext="권한기관명"/>
  330. <Column id="authdeptcd" type="STRING" size="256" sumtext="권한부서코드"/>
  331. <Column id="authdeptnm" type="STRING" size="256" sumtext="권한부서명"/>
  332. <Column id="valifromdd" type="STRING" size="256" sumtext="유효시작일자"/>
  333. <Column id="valitodd" type="STRING" size="256" sumtext="유효종료일자"/>
  334. </ColumnInfo>
  335. </Dataset>
  336. <Dataset id="ds_main_supcode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  337. <ColumnInfo>
  338. <Column id="cdsid" type="STRING" size="256" sumtext="코드 sid"/>
  339. <Column id="cdgrupid" type="STRING" size="256" sumtext="코드 group id"/>
  340. <Column id="cdid" type="STRING" size="256" sumtext="코드 id"/>
  341. <Column id="cdengabbrnm" type="STRING" size="256" sumtext="코드 영문 약어명"/>
  342. <Column id="cdnm" type="STRING" size="256" sumtext="코드 이름"/>
  343. <Column id="detldesc" type="STRING" size="256" sumtext="코드 상세설명"/>
  344. <Column id="dispseq" type="STRING" size="256" sumtext="보여주기 순서"/>
  345. <Column id="cdval" type="STRING" size="256" sumtext="코드 값"/>
  346. <Column id="minval" type="STRING" size="256" sumtext="최소값"/>
  347. <Column id="maxval" type="STRING" size="256" sumtext="최대값"/>
  348. <Column id="minopercd" type="STRING" size="256" sumtext="최소값 연산자 코드"/>
  349. <Column id="maxopercd" type="STRING" size="256" sumtext="최대값 연산자 코드"/>
  350. <Column id="fstrgstdt" type="STRING" size="256" sumtext="등록일시"/>
  351. <Column id="fstrgstrid" type="STRING" size="256" sumtext="등록자"/>
  352. <Column id="lastupdtdt" type="STRING" size="256" sumtext="최종수정일시"/>
  353. <Column id="lastupdtrid" type="STRING" size="256" sumtext="최종수정자ID"/>
  354. <Column id="valifromdd" type="STRING" size="256" sumtext="유효 시작일시"/>
  355. <Column id="valitodd" type="STRING" size="256" sumtext="유효 종료일시"/>
  356. </ColumnInfo>
  357. </Dataset>
  358. <Dataset id="ds_main_subcode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  359. <ColumnInfo>
  360. <Column id="checked" type="STRING" size="256" sumtext="상위 코드 참조 여부"/>
  361. <Column id="cdsid" type="STRING" size="256" sumtext="코드 sid"/>
  362. <Column id="cdgrupid" type="STRING" size="256" sumtext="코드 group id"/>
  363. <Column id="cdid" type="STRING" size="256" sumtext="코드 id"/>
  364. <Column id="cdengabbrnm" type="STRING" size="256" sumtext="코드 영문 약어명"/>
  365. <Column id="cdnm" type="STRING" size="256" sumtext="코드 이름"/>
  366. <Column id="detldesc" type="STRING" size="256" sumtext="코드 상세설명"/>
  367. <Column id="dispseq" type="STRING" size="256" sumtext="보여주기 순서"/>
  368. <Column id="cdval" type="STRING" size="256" sumtext="코드 값"/>
  369. <Column id="minval" type="INT" size="256" sumtext="최소값"/>
  370. <Column id="maxval" type="INT" size="256" sumtext="최대값"/>
  371. <Column id="minopercd" type="STRING" size="256" sumtext="최소값 연산자 코드"/>
  372. <Column id="maxopercd" type="STRING" size="256" sumtext="최대값 연산자 코드"/>
  373. <Column id="fstrgstdt" type="STRING" size="256" sumtext="등록일시"/>
  374. <Column id="fstrgstrid" type="STRING" size="256" sumtext="등록자"/>
  375. <Column id="lastupdtdt" type="STRING" size="256" sumtext="최종수정일시"/>
  376. <Column id="lastupdtrid" type="STRING" size="256" sumtext="최종수정자ID"/>
  377. <Column id="valifromdd" type="STRING" size="256" sumtext="유효 시작일시"/>
  378. <Column id="valitodd" type="STRING" size="256" sumtext="유효 종료일시"/>
  379. </ColumnInfo>
  380. </Dataset>
  381. <Dataset id="ds_send_search_supcode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  382. <ColumnInfo>
  383. <Column id="cdgrupid" type="STRING" size="256" sumtext="코드군ID"/>
  384. </ColumnInfo>
  385. <Rows>
  386. <Row/>
  387. </Rows>
  388. </Dataset>
  389. <Dataset id="ds_send_search_subcdgrup" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  390. <ColumnInfo>
  391. <Column id="level" type="INT" size="256" sumtext="레벨"/>
  392. <Column id="supcdgrupid" type="STRING" size="256" sumtext="상위코드군 ID"/>
  393. </ColumnInfo>
  394. <Rows>
  395. <Row/>
  396. </Rows>
  397. </Dataset>
  398. <Dataset id="ds_send_search_subcode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  399. <ColumnInfo>
  400. <Column id="supcdsid" type="STRING" size="256" sumtext="상위 코드 SID"/>
  401. <Column id="subcdgrupid" type="STRING" size="256" sumtext="하위 코드군 ID"/>
  402. <Column id="available" type="STRING" size="256"/>
  403. </ColumnInfo>
  404. <Rows>
  405. <Row/>
  406. </Rows>
  407. </Dataset>
  408. <Dataset id="ds_send_save" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  409. <ColumnInfo>
  410. <Column id="checked" type="STRING" size="256" sumtext="상하위 관계 여부"/>
  411. <Column id="supcdsid" type="STRING" size="256" sumtext="상위 코드 SID"/>
  412. <Column id="subcdsid" type="STRING" size="256" sumtext="하위 코드 SID"/>
  413. </ColumnInfo>
  414. </Dataset>
  415. </Objects>
  416. <Bind>
  417. <BindItem id="item0" compid="group2.ipt_search" propid="value" datasetid="ds_send_search" columnid="supcdgrupid"/>
  418. </Bind>
  419. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  420. * System Name :
  421. * Job Name :
  422. * Creator :
  423. * Make Date : 2014-10-31
  424. * Description :
  425. *---------------------------------------------------------------------------------------
  426. * Modify Date Modifier Modify Description
  427. *---------------------------------------------------------------------------------------
  428. * 2014-10-31 Live Converter TF->XP
  429. *
  430. *---------------------------------------------------------------------------------------
  431. ****************************************************************************************/
  432. include "com_commonxp::comm_main.xjs";
  433. function SMZBC00200_oninit(obj:Form, e:InitEventInfo)
  434. {
  435. frmf_initForm(obj);
  436. }
  437. function SMZBC00200_onload(obj:Form, e:LoadEventInfo)
  438. {
  439. grdf_setRowTypeIcon(grd_subcdlist, 0);
  440. }
  441. function group2_ipt_search_onkeydown(obj:Edit, e:KeyEventInfo)
  442. {
  443. if(e.keycode == 13) {
  444. obj.updateToDataset();
  445. group2.btn_search.click();
  446. }
  447. }
  448. function group2_btn_search_onclick(obj:Button, e:ClickEventInfo)
  449. {
  450. ds_send_search.setColumn(0, "level", 3);
  451. ds_main_supcodegroup.clearData();
  452. ds_main_subcdgrup.clearData();
  453. ds_main_supcode.clearData();
  454. ds_main_subcode.clearData();
  455. var oParam = {};
  456. oParam.id = "TRZBC00107";
  457. oParam.service = "basiccodeapp.BasicCodeAdmin";
  458. oParam.method = "reqGetSubCodeGroupList";
  459. oParam.inds = "req=ds_send_search";
  460. oParam.outds = "ds_main_supcodegroup=cdgrup";
  461. oParam.async = true;
  462. oParam.callback = "cf_TRZBC00107";
  463. tranf_submit(oParam);
  464. }
  465. function cf_TRZBC00107(sSvcId, nErrorCode, sErrorMsg) {
  466. if(nErrorCode < 0) return;
  467. ds_main_supcode.clearData();
  468. ds_main_subcode.clearData();
  469. }
  470. function grd_supcdgruplist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  471. {
  472. if(e.row < 0 || e.col < 0) return;
  473. ds_main_subcode.clearData();
  474. var cdgrupid = ds_main_supcodegroup.getColumn(e.row, "cdgrupid");
  475. var cdgrupnm = ds_main_supcodegroup.getColumn(e.row, "cdgrupnm");
  476. caption20.text = "상위코드군 목록 / 현재 선택된 상위코드군 [ 아이디 : "+cdgrupid+", 이름 : "+cdgrupnm+"]";
  477. ds_send_search_supcode.setColumn(0, "cdgrupid", cdgrupid);
  478. var oParam = {};
  479. oParam.id = "TRZBC00106";
  480. oParam.service = "basiccodeapp.BasicCodeAdmin";
  481. oParam.method = "reqGetCodeList";
  482. oParam.inds = "req=ds_send_search_supcode";
  483. oParam.outds = "ds_main_supcode=code";
  484. oParam.async = true;
  485. oParam.callback = "cf_TRZBC00106";
  486. tranf_submit(oParam);
  487. }
  488. function cf_TRZBC00106(sSvcId, nErrorCode, sErrorMsg) {
  489. if(nErrorCode < 0) return;
  490. caption3.text = "상위 코드 목록";
  491. caption1.text = "하위코드군 목록";
  492. //model.setValue("/root/main/mode", "upcdref");
  493. ds_send_search_subcdgrup.setColumn(0, "supcdgrupid", ds_main_supcodegroup.getColumn(ds_main_supcodegroup.rowposition, "cdgrupid"));
  494. ds_send_search_subcdgrup.setColumn(0, "level", 2);
  495. //model.setValue("/root/main/mode", "dncdgrupref");
  496. var oParam = {};
  497. oParam.id = "TRZBC00109";
  498. oParam.service = "basiccodeapp.BasicCodeAdmin";
  499. oParam.method = "reqGetSubCodeGroupList";
  500. oParam.inds = "req=ds_send_search_subcdgrup";
  501. oParam.outds = "ds_main_subcdgrup=cdgrup";
  502. oParam.async = true;
  503. //oParam.callback = "cf_TRZBC00109";
  504. tranf_submit(oParam);
  505. }
  506. function grd_supcdlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  507. {
  508. var supcdgrup_index = ds_main_supcodegroup.rowposition;
  509. if(supcdgrup_index < 0){
  510. sysf_messageBox("상위 코드군 ID를", "C002");
  511. return;
  512. }
  513. var supcd_index = e.row;
  514. if(supcd_index < 0){
  515. sysf_messageBox("상위 코드 ID를", "C002");
  516. return;
  517. }
  518. var subcdgrup_index = ds_main_subcdgrup.rowposition;
  519. if(subcdgrup_index < 0){
  520. sysf_messageBox("하위 코드군 ID를", "C002");
  521. return;
  522. }
  523. var supcdgrupid = ds_main_supcodegroup.getColumn(supcdgrup_index, "cdgrupid");
  524. var supcdsid = ds_main_supcode.getColumn(supcd_index, "cdsid");
  525. var supcdid = ds_main_supcode.getColumn(supcd_index, "cdid");
  526. var supcdnm = ds_main_supcode.getColumn(supcd_index, "cdnm");
  527. var subcdgrupid = ds_main_subcdgrup.getColumn(subcdgrup_index, "cdgrupid");
  528. caption3.text = "상위 코드 목록 / 현제 선택된 상위코드 [아이디 : "+supcdid+", 이름 : "+supcdnm+"]";
  529. ds_send_search_subcode.setColumn(0, "available", true);
  530. ds_send_search_subcode.setColumn(0, "supcdsid", supcdsid);
  531. ds_send_search_subcode.setColumn(0, "subcdgrupid", subcdgrupid);
  532. var oParam = {};
  533. oParam.id = "TRZBC001010";
  534. oParam.service = "basiccodeapp.BasicCodeAdmin";
  535. oParam.method = "reqGetSubCodeListAvailable";
  536. oParam.inds = "req=ds_send_search";
  537. oParam.outds = "ds_main_subcode=code";
  538. oParam.async = true;
  539. oParam.callback = "cf_TRZBC001010";
  540. tranf_submit(oParam);
  541. }
  542. function cf_TRZBC001010(sSvcId, nErrorCode, sErrorMsg) {
  543. if(nErrorCode < 0) {
  544. var supcdgrupid = ds_main_supcodegroup.getColumn(ds_main_supcodegroup.rowposition, "cdgrupid");
  545. var supcdsid = ds_main_supcode.getColumn(ds_main_supcode.rowposition, "cdsid");
  546. var subcdgrupid = ds_main_subcdgrup.getColumn(ds_main_subcdgrup.rowposition, "cdgrupid");
  547. sysf_messageBox("[상위 코드군 ID:"+supcdgrupid+", 상위코드 SID:"+supcdsid+", 하위 코드군 ID : "+subcdgrupid+"] 인 하위 코드 목록을 조회에", "E009");
  548. return;
  549. } else {
  550. grd_subcdlist.setFormatColProperty(1, "size", 30);
  551. }
  552. }
  553. function grd_subcdgruplist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  554. {
  555. var subcdgrupid = ds_main_subcdgrup.getColumn(e.row, "cdgrupid");
  556. var subcdgrupnm = ds_main_subcdgrup.getColumn(e.row, "cdgrupnm");
  557. var row = ds_main_supcode.rowposition;
  558. if(row > -1){
  559. var supcdsid = ds_main_supcode.getColumn(row, "cdsid");
  560. var supcdnm = ds_main_supcode.getColumn(row, "cdnm");
  561. caption3.text = "상위 코드 목록 / 현제 선택된 상위코드 [아이디 : "+supcdsid+", 이름 : "+supcdnm+"]";
  562. }else{
  563. var supcdsid = "abcdefgkkyy";
  564. grd_subcdlist.setFormatColProperty(1, "size", 0);
  565. }
  566. caption1.text = "하위코드군 목록 / 현재 선택된 하위코드군 [ 아이디 : "+subcdgrupid+", 이름 "+subcdgrupnm+"]";
  567. ds_send_search_subcode.setColumn(0, "subcdgrupid", subcdgrupid);
  568. ds_send_search_subcode.setColumn(0, "supcdsid", supcdsid);
  569. ds_send_search_subcode.setColumn(0, "available", true);
  570. var oParam = {};
  571. oParam.id = "TRZBC00110";
  572. oParam.service = "basiccodeapp.BasicCodeAdmin";
  573. oParam.method = "reqGetSubCodeListAvailable";
  574. oParam.inds = "req=ds_send_search_subcode";
  575. oParam.outds = "ds_main_subcode=code";
  576. oParam.async = true;
  577. tranf_submit(oParam);
  578. }
  579. function btn_save_onclick(obj:Button, e:ClickEventInfo)
  580. {
  581. var row = ds_main_supcodegroup.rowposition;
  582. if(row < 0){
  583. sysf_messageBox('상위 코드군을', 'C001');
  584. return;
  585. }
  586. row = ds_main_supcode.rowposition;
  587. if(row < 0){
  588. sysf_messageBox('상위 코드를', 'C001');
  589. return;
  590. }
  591. var row = ds_main_subcdgrup.rowposition;
  592. if(row < 0){
  593. sysf_messageBox('하위 코드군을', 'C001');
  594. return;
  595. }
  596. ds_send_save.clearData();
  597. var supcdsid = ds_main_supcode.getColumn(ds_main_supcode.rowposition, "cdsid");
  598. var oDsUpdate = grdf_getGridUpdateData(grd_subcdlist);
  599. for(var i = 0; i < oDsUpdate.rowcount; i++) {
  600. var row = ds_send_save.addRow();
  601. var checked = oDsUpdate.getColumn(i, "checked");
  602. ds_send_save.setColumn(row, "checked", (checked == "true" || checked == true || checked == 1 || checked == "1") ? "true" : "false");
  603. ds_send_save.setColumn(row, "supcdsid", supcdsid);
  604. ds_send_save.setColumn(row, "subcdsid", oDsUpdate.getColumn(i, "cdsid"));
  605. }
  606. var oParam = {};
  607. oParam.id = "TRZBC00112";
  608. oParam.service = "basiccodeapp.BasicCodeAdmin";
  609. oParam.method = "reqSetCodeRelations";
  610. oParam.inds = "req=ds_send_save";
  611. oParam.async = false;
  612. oParam.callback = "cf_TRZBC00112";
  613. tranf_submit(oParam);
  614. }
  615. function cf_TRZBC00112(sSvcId, nErrorCode, sErrorMsg) {
  616. if(nErrorCode < 0) {
  617. sysf_messageBox("코드상하위 관계가 재정의를", "E001");
  618. return;
  619. }
  620. ds_main_subcode.applyChange();
  621. sysf_messageBox("코드상하위 관계가 재정의가", "I002");
  622. }
  623. function group2_Button00_onclick(obj:Button, e:ClickEventInfo)
  624. {
  625. var searchcondition = "cdgrupid";
  626. var searchterm = ds_send_search.getColumn(0, "supcdgrupid");
  627. var sReturn = appf_openCodeGroupList(searchcondition, searchterm, true);
  628. var supcdgrupid = sReturn.cdgrupid;
  629. var supcdgrupnm = sReturn.cdgrupnm;
  630. if(!utlf_isNull(supcdgrupid))
  631. ds_send_search.setColumn(0,"supcdgrupid", supcdgrupid);
  632. if(!utlf_isNull(supcdgrupnm))
  633. ds_send_search.setColumn(0,"supcdgrupnm", supcdgrupnm);
  634. }
  635. ]]></Script>
  636. </Form>
  637. </FDL>