SMAED00400_소모품출력.xfdl 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAED00400" position="absolute 0 0 1182 777" titletext="치기공 소모품대장 관리" onload="SMAED00400_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 747 1080 774" id="grp_btn" anchor="left bottom">
  8. <Layouts>
  9. <Layout>
  10. <Button position="absolute 1 3 121 25" id="btn_prt" class="btn6" text="소모품대장 출력" anchor="default" onclick="grp_btn_btn_prt_onclick"/>
  11. <Static text="수납합계" position="absolute 728 4 808 24" align="align:center middle;" id="lbl_rmedadmin" class="cell_1" anchor="default"/>
  12. <MaskEdit position="absolute 469 4 550 23" align="align:right middle;" id="ipt_useqty" class="input_default" mask="###.#" anchor="default"/>
  13. <MaskEdit position="absolute 811 4 931 23" align="align:right middle;" id="ipt_rcptamtsum" class="input_default" mask="#,###" anchor="default"/>
  14. <Static text="누계" position="absolute 308 4 388 23" align="align:center middle;" id="caption3" class="cell_1" anchor="default"/>
  15. <MaskEdit position="absolute 390 4 470 23" align="align:right middle;" id="ipt_inqty" class="input_default" mask="##.#" anchor="default"/>
  16. <Static text="원" position="absolute 933 8 953 23" id="caption8" anchor="default"/>
  17. <MaskEdit position="absolute 549 4 631 23" align="align:right middle;" id="ipt_stockqty" class="input_default" visible="false" mask="##.#" anchor="default"/>
  18. </Layout>
  19. </Layouts>
  20. </Div>
  21. <Div position="absolute 0 18 1181 745" id="grp_main" scrollbars="autoboth" anchor="all">
  22. <Layouts>
  23. <Layout>
  24. <Div position="absolute 0 7 1180 47" align="align:center top;" id="grp_srch" class="div_SA" anchor="left top right">
  25. <Layouts>
  26. <Layout>
  27. <Shape position="absolute 1092 10 1098 32" linetype="vertical" id="line16" class="line_4" anchor="top right"/>
  28. <Button position="absolute 1108 10 1164 32" id="btn_select" class="btn1" text="조회" anchor="top right" onclick="grp_main_grp_srch_btn_select_onclick" taborder="7"/>
  29. <Calendar position="absolute 222 11 322 30" id="ipt_srchtodd" class="input_essential" anchor="default" dateformat="yyyy-MM-dd" autoselect="true" taborder="1"/>
  30. <Calendar position="absolute 106 11 206 30" id="ipt_srchfromdd" class="input_essential" anchor="default" dateformat="yyyy-MM-dd" value="null" autoselect="true" taborder="0"/>
  31. <Static text="조회기간 :" position="absolute 13 13 99 30" id="lbl_srchdd" class="search_name" anchor="default"/>
  32. <Static text="~" position="absolute 208 12 220 29" id="lbl_~" class="search_no_b" anchor="default"/>
  33. <Combo position="absolute 535 11 621 30" id="cmb_sect" class="combo_search" innerdataset="@ds_init_SS002" datacolumn="cdnm" codecolumn="cdid" anchor="default" onitemchanged="grp_main_grp_srch_cmb_sect_onitemchanged" taborder="3"/>
  34. <Static text="조회조건 :" position="absolute 446 13 530 30" id="caption2" class="search_name" anchor="default"/>
  35. <Static text="금속종류 :" position="absolute 730 13 816 30" id="caption4" class="search_name" anchor="default"/>
  36. <Combo position="absolute 824 11 910 30" id="cmb_metalcd" class="combo_search" innerdataset="@ds_main_eqmtlist_item" datacolumn="basecdflagdesc" codecolumn="basecd" anchor="default" taborder="5"/>
  37. <Static text="구분 :" position="absolute 930 13 990 30" id="caption1" class="search_name" anchor="default"/>
  38. <Combo position="absolute 994 11 1080 30" id="cmb_outordyn" class="combo_search" innerdataset="@ds_init_SS001" datacolumn="cdnm" codecolumn="cdid" anchor="default" taborder="6"/>
  39. <Edit position="absolute 625 11 715 30" id="ipt_sect" anchor="default" autoselect="true" taborder="4"/>
  40. <Combo position="absolute 535 11 625 30" id="cmb_prodcd" class="combo_search" innerdataset="@ds_main_eqmtcnlist_item" datacolumn="basecdflagdesc" codecolumn="basecd" anchor="default" taborder="8"/>
  41. <Combo position="absolute 535 11 625 30" id="cmb_prodid" class="combo_search" innerdataset="@ds_main_execrcodelist_execrcode" datacolumn="basecdflagdesc" codecolumn="basecd" anchor="default" taborder="9"/>
  42. <Combo position="absolute 335 11 425 30" id="cmb_dkind" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default" taborder="2">
  43. <Dataset id="innerdataset">
  44. <ColumnInfo>
  45. <Column id="codecolumn"/>
  46. <Column id="datacolumn"/>
  47. </ColumnInfo>
  48. <Rows>
  49. <Row>
  50. <Col id="codecolumn">1</Col>
  51. <Col id="datacolumn">접수일자</Col>
  52. </Row>
  53. <Row>
  54. <Col id="codecolumn">2</Col>
  55. <Col id="datacolumn">완료일자</Col>
  56. </Row>
  57. </Rows>
  58. </Dataset>
  59. </Combo>
  60. </Layout>
  61. </Layouts>
  62. </Div>
  63. <Static text="소모품대장 LIST" position="absolute 0 56 151 73" id="caption45" class="tit_2" anchor="default"/>
  64. <Shape position="absolute 0 72 1180 78" id="line18" class="line_10" anchor="left top right"/>
  65. <Grid id="mltgrd_cnsmblslist" binddataset="ds_main_cnsmblslist_item" position="absolute 0 77 1180 726" style="" anchor="all">
  66. <Formats>
  67. <Format id="default">
  68. <Columns>
  69. <Column size="25" band="left"/>
  70. <Column size="100"/>
  71. <Column size="100"/>
  72. <Column size="90"/>
  73. <Column size="90"/>
  74. <Column size="90"/>
  75. <Column size="80"/>
  76. <Column size="80"/>
  77. <Column size="80"/>
  78. <Column size="100"/>
  79. <Column size="100"/>
  80. <Column size="100"/>
  81. <Column size="100"/>
  82. <Column size="100"/>
  83. </Columns>
  84. <Rows>
  85. <Row size="22" band="head"/>
  86. <Row size="22" band="head"/>
  87. <Row size="22"/>
  88. <Row size="22"/>
  89. </Rows>
  90. <Band id="head">
  91. <Cell rowspan="2" taborder="undefined"/>
  92. <Cell col="1" rowspan="2" text="접수일자" taborder="undefined"/>
  93. <Cell col="2" rowspan="2" text="완료일자" taborder="undefined"/>
  94. <Cell col="3" rowspan="2" text="접수번호" taborder="undefined"/>
  95. <Cell col="4" rowspan="2" text="성명" taborder="undefined"/>
  96. <Cell col="5" rowspan="2" text="처방의사" taborder="undefined"/>
  97. <Cell col="6" rowspan="2" text="수입(g)" taborder="undefined"/>
  98. <Cell col="7" rowspan="2" text="출금(g)" taborder="undefined"/>
  99. <Cell col="8" rowspan="2" text="재고(g)" taborder="undefined"/>
  100. <Cell col="9" rowspan="2" colspan="2" text="진찰부위" taborder="undefined"/>
  101. <Cell col="11" rowspan="2" text="수납금액(원)" taborder="undefined"/>
  102. <Cell col="12" rowspan="2" text="제작자" taborder="undefined"/>
  103. <Cell col="13" rowspan="2" text="비고" taborder="undefined"/>
  104. <Cell col="14" text="접수일자"/>
  105. <Cell col="15" text="완료일자"/>
  106. <Cell col="16" text="접수번호"/>
  107. <Cell col="17" text="성명"/>
  108. <Cell col="18" text="처방의사"/>
  109. <Cell col="19" text="수입(g)"/>
  110. <Cell col="20" text="출금(g)"/>
  111. <Cell col="21" text="재고(g)"/>
  112. <Cell col="22" text="진찰부위"/>
  113. <Cell col="23" text="진찰부위"/>
  114. <Cell col="24" text="수납금액(원)"/>
  115. <Cell col="25" text="제작자"/>
  116. <Cell col="26" text="비고"/>
  117. </Band>
  118. <Band id="body">
  119. <Cell rowspan="2" celltype="head" text="expr:currow+1" taborder="undefined"/>
  120. <Cell col="1" rowspan="2" displaytype="date" text="bind:acptdt" taborder="undefined"/>
  121. <Cell col="2" rowspan="2" displaytype="date" text="bind:enddd" taborder="undefined"/>
  122. <Cell col="3" rowspan="2" text="bind:acptno" mask="expr:utlf_isNull(acptno) ? '' : '####-##-####'" taborder="undefined"/>
  123. <Cell col="4" rowspan="2" text="bind:hngnm" taborder="undefined"/>
  124. <Cell col="5" rowspan="2" text="bind:orddrnm" taborder="undefined"/>
  125. <Cell col="6" rowspan="2" displaytype="number" style="padding:0 5 0 0;" text="bind:inqty" taborder="undefined"/>
  126. <Cell col="7" rowspan="2" displaytype="number" style="padding:0 5 0 0;" text="bind:useqty" taborder="undefined"/>
  127. <Cell col="8" rowspan="2" displaytype="number" style="padding:0 5 0 0;" text="bind:stockqty" taborder="undefined"/>
  128. <Cell col="9" displaytype="text" style="padding:0 0 0 5;" text="bind:tootfact11"/>
  129. <Cell col="10" displaytype="text" style="padding:0 0 0 5;" text="bind:tootfact12"/>
  130. <Cell col="11" rowspan="2" displaytype="number" style="padding:0 5 0 0;" text="bind:rcptamt" taborder="undefined"/>
  131. <Cell col="12" rowspan="2" text="bind:prodnm" taborder="undefined"/>
  132. <Cell col="13" rowspan="2" displaytype="text" text="bind:bigo" wordwrap="char" taborder="undefined"/>
  133. <Cell row="1" col="9" displaytype="text" style="padding:0 0 0 5;" text="bind:tootfact21"/>
  134. <Cell row="1" col="10" displaytype="text" style="padding:0 0 0 5;" text="bind:tootfact22"/>
  135. </Band>
  136. </Format>
  137. </Formats>
  138. </Grid>
  139. </Layout>
  140. </Layouts>
  141. </Div>
  142. <Static id="caption6" text="치기공 소모품대장 관리" class="tit_1" position="absolute 0 0 200 25"/>
  143. </Layout>
  144. </Layouts>
  145. <Objects>
  146. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  147. <ColumnInfo/>
  148. </Dataset>
  149. <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  150. <ColumnInfo>
  151. <Column id="instance1" type="STRING" size="256"/>
  152. </ColumnInfo>
  153. <Rows>
  154. <Row>
  155. <Col id="instance1"/>
  156. </Row>
  157. </Rows>
  158. </Dataset>
  159. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  160. <ColumnInfo>
  161. <Column id="templst" type="STRING" size="256"/>
  162. </ColumnInfo>
  163. <Rows>
  164. <Row>
  165. <Col id="templst"/>
  166. </Row>
  167. </Rows>
  168. </Dataset>
  169. <Dataset id="ds_main_eqmtlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  170. <ColumnInfo>
  171. <Column id="sortno" type="STRING" size="256"/>
  172. <Column id="basecd" type="STRING" size="256"/>
  173. <Column id="basecdflagdesc" type="STRING" size="256"/>
  174. <Column id="basecdcnts" type="STRING" size="256"/>
  175. <Column id="basesuppdeptcd" type="STRING" size="256"/>
  176. <Column id="basecdflag" type="STRING" size="256"/>
  177. </ColumnInfo>
  178. <Rows>
  179. <Row>
  180. <Col id="sortno"/>
  181. <Col id="basecd"/>
  182. <Col id="basecdflagdesc"/>
  183. <Col id="basecdcnts"/>
  184. <Col id="basesuppdeptcd"/>
  185. <Col id="basecdflag"/>
  186. </Row>
  187. </Rows>
  188. </Dataset>
  189. <Dataset id="ds_init_baseinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  190. <ColumnInfo>
  191. <Column id="initinsukind" type="STRING" size="256"/>
  192. </ColumnInfo>
  193. <Rows>
  194. <Row>
  195. <Col id="initinsukind"/>
  196. </Row>
  197. </Rows>
  198. </Dataset>
  199. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  200. <ColumnInfo>
  201. <Column id="inqtysum" type="STRING" size="256"/>
  202. <Column id="useqtysum" type="STRING" size="256"/>
  203. <Column id="rcptamtsum" type="STRING" size="256"/>
  204. <Column id="stockqtysum" type="STRING" size="256"/>
  205. </ColumnInfo>
  206. <Rows>
  207. <Row>
  208. <Col id="inqtysum"/>
  209. <Col id="useqtysum"/>
  210. <Col id="rcptamtsum"/>
  211. <Col id="stockqtysum"/>
  212. </Row>
  213. </Rows>
  214. </Dataset>
  215. <Dataset id="ds_hidden_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  216. <ColumnInfo>
  217. <Column id="count" type="STRING" size="256"/>
  218. </ColumnInfo>
  219. <Rows>
  220. <Row>
  221. <Col id="count"/>
  222. </Row>
  223. </Rows>
  224. </Dataset>
  225. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  226. <ColumnInfo/>
  227. </Dataset>
  228. <Dataset id="ds_rexprnt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  229. <ColumnInfo>
  230. <Column id="cnsmblslist" type="STRING" size="256"/>
  231. <Column id="srchfromdd" type="STRING" size="256"/>
  232. <Column id="srchtodd" type="STRING" size="256"/>
  233. <Column id="prodnm" type="STRING" size="256"/>
  234. <Column id="metalcd" type="STRING" size="256"/>
  235. </ColumnInfo>
  236. </Dataset>
  237. <Dataset id="ds_main_cnsmblslist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  238. <ColumnInfo>
  239. <Column id="acptdt" type="STRING" size="256"/>
  240. <Column id="acptno" type="STRING" size="256"/>
  241. <Column id="hngnm" type="STRING" size="256"/>
  242. <Column id="orddrnm" type="STRING" size="256"/>
  243. <Column id="inqty" type="STRING" size="256"/>
  244. <Column id="useqty" type="STRING" size="256"/>
  245. <Column id="stockqty" type="STRING" size="256"/>
  246. <Column id="tootfact11" type="STRING" size="256"/>
  247. <Column id="tootfact12" type="STRING" size="256"/>
  248. <Column id="tootfact21" type="STRING" size="256"/>
  249. <Column id="tootfact22" type="STRING" size="256"/>
  250. <Column id="rcptamt" type="STRING" size="256"/>
  251. <Column id="prodnm" type="STRING" size="256"/>
  252. <Column id="bigo" type="STRING" size="256"/>
  253. <Column id="enddd" type="STRING" size="256"/>
  254. </ColumnInfo>
  255. <Rows>
  256. <Row>
  257. <Col id="acptdt"/>
  258. <Col id="acptno"/>
  259. <Col id="hngnm"/>
  260. <Col id="orddrnm"/>
  261. <Col id="inqty"/>
  262. <Col id="useqty"/>
  263. <Col id="stockqty"/>
  264. <Col id="tootfact11"/>
  265. <Col id="tootfact12"/>
  266. <Col id="tootfact21"/>
  267. <Col id="tootfact22"/>
  268. <Col id="rcptamt"/>
  269. <Col id="prodnm"/>
  270. <Col id="bigo"/>
  271. <Col id="enddd"/>
  272. </Row>
  273. </Rows>
  274. </Dataset>
  275. <Dataset id="ds_main_execrcodelist_execrcode" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  276. <ColumnInfo>
  277. <Column id="sortno" type="STRING" size="256"/>
  278. <Column id="basecd" type="STRING" size="256"/>
  279. <Column id="basecdflagdesc" type="STRING" size="256"/>
  280. <Column id="basecdcnts" type="STRING" size="256"/>
  281. <Column id="basecdflag" type="STRING" size="256"/>
  282. <Column id="basesuppdeptcd" type="STRING" size="256"/>
  283. <Column id="seq" type="STRING" size="256"/>
  284. </ColumnInfo>
  285. <Rows>
  286. <Row>
  287. <Col id="sortno"/>
  288. <Col id="basecd"/>
  289. <Col id="basecdflagdesc"/>
  290. <Col id="basecdcnts"/>
  291. <Col id="basecdflag"/>
  292. <Col id="basesuppdeptcd"/>
  293. <Col id="seq"/>
  294. </Row>
  295. </Rows>
  296. </Dataset>
  297. <Dataset id="ds_send_srch" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  298. <ColumnInfo>
  299. <Column id="srchsearch" type="STRING" size="256"/>
  300. <Column id="srchfromdd" type="STRING" size="256"/>
  301. <Column id="srchtodd" type="STRING" size="256"/>
  302. <Column id="srchhngnm" type="STRING" size="256"/>
  303. <Column id="srchstate" type="STRING" size="256"/>
  304. <Column id="srchcnclyn" type="STRING" size="256"/>
  305. <Column id="grupcdid" type="STRING" size="256"/>
  306. <Column id="suppdeptcd" type="STRING" size="256"/>
  307. <Column id="dutplceinstcd" type="STRING" size="256"/>
  308. <Column id="prodroom" type="STRING" size="256"/>
  309. <Column id="prcpdd" type="STRING" size="256"/>
  310. <Column id="basesuppdeptcd" type="STRING" size="256"/>
  311. <Column id="excuroomcd" type="STRING" size="256"/>
  312. <Column id="acptyear" type="STRING" size="256"/>
  313. <Column id="basecdcnts" type="STRING" size="256"/>
  314. <Column id="prcpno" type="STRING" size="256"/>
  315. <Column id="metalcd" type="STRING" size="256"/>
  316. <Column id="useqty" type="STRING" size="256"/>
  317. <Column id="srchoutordyn" type="STRING" size="256"/>
  318. <Column id="srchmetalcd" type="STRING" size="256"/>
  319. <Column id="srchsectcd" type="STRING" size="256"/>
  320. <Column id="srchsect" type="STRING" size="256"/>
  321. <Column id="srchhngnm" type="STRING" size="256"/>
  322. <Column id="srchorddrnm" type="STRING" size="256"/>
  323. <Column id="srchprodnm" type="STRING" size="256"/>
  324. <Column id="srchprodcd" type="STRING" size="256"/>
  325. <Column id="srchprodid" type="STRING" size="256"/>
  326. <Column id="srchdkind" type="STRING" size="256"/>
  327. </ColumnInfo>
  328. <Rows>
  329. <Row>
  330. <Col id="srchsearch"/>
  331. <Col id="srchfromdd"/>
  332. <Col id="srchtodd"/>
  333. <Col id="srchhngnm"/>
  334. <Col id="srchstate"/>
  335. <Col id="srchcnclyn"/>
  336. <Col id="grupcdid"/>
  337. <Col id="suppdeptcd"/>
  338. <Col id="dutplceinstcd"/>
  339. <Col id="prodroom"/>
  340. <Col id="prcpdd"/>
  341. <Col id="basesuppdeptcd"/>
  342. <Col id="excuroomcd"/>
  343. <Col id="acptyear"/>
  344. <Col id="basecdcnts"/>
  345. <Col id="prcpno"/>
  346. <Col id="metalcd"/>
  347. <Col id="useqty"/>
  348. <Col id="srchoutordyn"/>
  349. <Col id="srchmetalcd"/>
  350. <Col id="srchsectcd"/>
  351. <Col id="srchsect"/>
  352. <Col id="srchhngnm"/>
  353. <Col id="srchorddrnm"/>
  354. <Col id="srchprodnm"/>
  355. <Col id="srchprodcd"/>
  356. <Col id="srchprodid"/>
  357. <Col id="srchdkind"/>
  358. </Row>
  359. </Rows>
  360. </Dataset>
  361. <Dataset id="ds_main_eqmtcnlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  362. <ColumnInfo>
  363. <Column id="sortno" type="STRING" size="256"/>
  364. <Column id="basecd" type="STRING" size="256"/>
  365. <Column id="basecdflagdesc" type="STRING" size="256"/>
  366. <Column id="basecdcnts" type="STRING" size="256"/>
  367. <Column id="basesuppdeptcd" type="STRING" size="256"/>
  368. <Column id="basecdflag" type="STRING" size="256"/>
  369. </ColumnInfo>
  370. <Rows>
  371. <Row>
  372. <Col id="sortno"/>
  373. <Col id="basecd"/>
  374. <Col id="basecdflagdesc"/>
  375. <Col id="basecdcnts"/>
  376. <Col id="basesuppdeptcd"/>
  377. <Col id="basecdflag"/>
  378. </Row>
  379. </Rows>
  380. </Dataset>
  381. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  382. <ColumnInfo>
  383. <Column id="basecd" type="STRING" size="256"/>
  384. <Column id="basecdflag" type="STRING" size="256"/>
  385. <Column id="instcd" type="STRING" size="256"/>
  386. </ColumnInfo>
  387. </Dataset>
  388. <Dataset id="ds_init_SS002" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  389. <Dataset id="ds_init_SS001" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  390. </Objects>
  391. <Bind>
  392. <BindItem id="item0" compid="grp_btn.ipt_useqty" propid="value" datasetid="ds_main" columnid="useqtysum"/>
  393. <BindItem id="item1" compid="grp_btn.ipt_rcptamtsum" propid="value" datasetid="ds_main" columnid="rcptamtsum"/>
  394. <BindItem id="item2" compid="grp_btn.ipt_inqty" propid="value" datasetid="ds_main" columnid="inqtysum"/>
  395. <BindItem id="item3" compid="grp_btn.ipt_stockqty" propid="value" datasetid="ds_main" columnid="stockqtysum"/>
  396. <BindItem id="item4" compid="grp_main.grp_srch.ipt_srchtodd" propid="value" datasetid="ds_send_srch" columnid="srchtodd"/>
  397. <BindItem id="item5" compid="grp_main.grp_srch.ipt_srchfromdd" propid="value" datasetid="ds_send_srch" columnid="srchfromdd"/>
  398. <BindItem id="item6" compid="grp_main.grp_srch.cmb_sect" propid="value" datasetid="ds_send_srch" columnid="srchsectcd"/>
  399. <BindItem id="item7" compid="grp_main.grp_srch.cmb_metalcd" propid="value" datasetid="ds_send_srch" columnid="srchmetalcd"/>
  400. <BindItem id="item8" compid="grp_main.grp_srch.cmb_outordyn" propid="value" datasetid="ds_send_srch" columnid="srchoutordyn"/>
  401. <BindItem id="item9" compid="grp_main.grp_srch.ipt_sect" propid="value" datasetid="ds_send_srch" columnid="srchsect"/>
  402. <BindItem id="item10" compid="grp_main.grp_srch.cmb_prodcd" propid="value" datasetid="ds_send_srch" columnid="srchprodcd"/>
  403. <BindItem id="item11" compid="grp_main.grp_srch.cmb_prodid" propid="value" datasetid="ds_send_srch" columnid="srchprodid"/>
  404. <BindItem id="item12" compid="grp_main.grp_srch.cmb_dkind" propid="value" datasetid="ds_send_srch" columnid="srchdkind"/>
  405. </Bind>
  406. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  407. * System Name :
  408. * Job Name :
  409. * Creator :
  410. * Make Date : 2016-09-30
  411. * Description :
  412. *---------------------------------------------------------------------------------------
  413. * Modify Date Modifier Modify Description
  414. *---------------------------------------------------------------------------------------
  415. * 2016-09-30 Live Converter TF->XP
  416. *
  417. *---------------------------------------------------------------------------------------
  418. ****************************************************************************************/
  419. //=======================================================================================
  420. // Lib Include
  421. //---------------------------------------------------------------------------------------
  422. include "com_commonxp::comm_main.xjs";
  423. include "ast_examcurexp::AEZ0001.xjs";
  424. include "ast_examcurexp::combolist.xjs";
  425. //include "ast_dentalcraft::dentalcraftcombolist.xjs";
  426. //=======================================================================================
  427. // Global Form Variable
  428. //---------------------------------------------------------------------------------------
  429. var arErrorCode = new HashArray();
  430. //=======================================================================================
  431. // Function
  432. //---------------------------------------------------------------------------------------
  433. /****************************************************************************************
  434. * Argument : N/A
  435. * Description : 콤보 초기화
  436. ****************************************************************************************/
  437. function fGetComboInit() {
  438. var arrParam = [{dsNm: "ds_init_SS001", cdGrpId: "SS001"}
  439. ,{dsNm: "ds_init_SS002", cdGrpId: "SS002"}
  440. ]
  441. lf_getAstCodeList(arrParam);
  442. // 콤보선택
  443. lf_aezfSetSuppDeptcd();
  444. ds_send_globalinstance.setColumn(0,"instance1",frmf_getParameter("AST_DEPTCD"));
  445. ds_send_srch.setColumn( 0, "suppdeptcd", ds_send_globalinstance.getColumn(0, "instance1"));
  446. // 금속종류 코드 LIST(대분류)
  447. // 금속종류 코드 LIST(대분류)
  448. ds_send.setColumn(0,"basecdflag", "H");
  449. ds_main_eqmtlist_item.clearData();
  450. dsf_createDsRow("ds_req", [
  451. {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0,"instance1")}
  452. , {col:"instcd", type:"STRING", size:256, val:""}
  453. , {col:"basecdflag", type:"STRING", size:256, val:"H"}
  454. ]);
  455. var oParam = {};
  456. oParam.id = "TRAED00103";
  457. oParam.service = "dentalcraftapp.DentalCraftCode";
  458. oParam.method = "reqGetEqmtCodeList";
  459. oParam.inds = "req=ds_req";
  460. oParam.outds = "ds_main_eqmtlist_item=item";
  461. oParam.async = false;
  462. //oParam.callback = "cf_TRAED00103";
  463. tranf_submit(oParam);
  464. // 제작물 코드LIST (중분류)
  465. ds_send.setColumn(0,"basecdflag", "I");
  466. dsf_createDsRow("ds_req", [
  467. {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0,"instance1")}
  468. , {col:"instcd", type:"STRING", size:256, val:ds_send.getColumn(0,"instcd")}
  469. , {col:"basecdflag", type:"STRING", size:256, val:ds_send.getColumn(0,"basecdflag")}
  470. , {col:"basecdcnts", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"basecdcnts")}
  471. ]);
  472. var oParam = {};
  473. oParam.id = "TRAED00104";
  474. oParam.service = "dentalcraftapp.DentalCraftCode";
  475. oParam.method = "reqGetEqmtCodeList";
  476. oParam.inds = "req=ds_req";
  477. oParam.outds = "ds_main_eqmtcnlist_item=item";
  478. oParam.async = false;
  479. //oParam.callback = "cf_TRAED00104";
  480. tranf_submit(oParam);
  481. // 제작자 조회
  482. ds_send.setColumn( 0, "basecdflag", "E");
  483. dsf_createDsRow("ds_req", [
  484. {col:"basecd", type:"STRING", size:256, val:ds_send.getColumn(0,"basecd")}
  485. , {col:"basesuppdeptcd", type:"STRING", size:256, val:ds_send_globalinstance.getColumn(0,"instance1")}
  486. , {col:"ebasecdflag", type:"STRING", size:256, val:"E"}
  487. ]);
  488. var oParam = {};
  489. oParam.id = "TRAEB00801";
  490. oParam.service = "examcurebaseapp.ExecrCode";
  491. oParam.method = "reqGetExecrCodeList";
  492. oParam.inds = "req=ds_req";
  493. oParam.outds = "ds_main_execrcodelist_execrcode=execrcode";
  494. oParam.async = false;
  495. //oParam.callback = "cf_TRAEB00801";
  496. tranf_submit(oParam);
  497. var eqmCnt = ds_main_eqmtcnlist_item.rowcount;
  498. // for(var i = 0 ; i < eqmCnt ; i++ ){
  499. // model.makeNode("/root/init/eqmtcnlist/item[" + i + "]");
  500. // model.copyNode("/root/init/eqmtcnlist/item[" + i + "]", "/root/main/eqmtcnlist/item[" + i + "]");
  501. // }
  502. dsf_createDs("ds_init_eqmtcnlist_item");
  503. ds_init_eqmtcnlist_item.copyData(ds_main_eqmtcnlist_item);
  504. ds_init_SS001.deleteRow(0);
  505. ds_init_SS002.deleteRow(0);
  506. // 콤포박스 초기화
  507. frmf_addComboItem("grp_main.grp_srch.cmb_metalcd", "전체", "all", "above");
  508. grp_main.grp_srch.cmb_metalcd.value = "01";
  509. grp_main.grp_srch.cmb_sect.value = "00";
  510. grp_main.grp_srch.cmb_outordyn.value = "00";
  511. grp_main.grp_srch.ipt_sect.visible = true;
  512. grp_main.grp_srch.ipt_sect.enable = false;
  513. grp_main.grp_srch.cmb_prodid.visible = false;
  514. grp_main.grp_srch.cmb_prodcd.visible = false;
  515. }
  516. /****************************************************************************************
  517. * Argument : N/A
  518. * Description : 화면 기본 초기화
  519. ****************************************************************************************/
  520. function fGetScreenInit() {
  521. var curDD = utlf_getCurrentDate();
  522. ds_send.clearData(); ds_send.addRow();
  523. ds_send_srch.clearData(); ds_send_srch.addRow(); dsf_setDefaultVal(ds_send_srch,"all");
  524. ds_send_srch.setColumn( 0, "srchfromdd" , curDD ); // 조회시작일자
  525. ds_send_srch.setColumn( 0, "srchtodd" , curDD ); // 조회종료일자
  526. ds_send_srch.setColumn( 0, "srchsectcd" , "00");
  527. ds_send_srch.setColumn( 0, "srchmetalcd", "all");
  528. ds_send_srch.setColumn( 0, "srchoutordyn", "00");
  529. ds_send_srch.setColumn( 0, "srchdkind", "2"); //완료일자
  530. ds_main_cnsmblslist_item.clearData();
  531. }
  532. /****************************************************************************************
  533. * Argument : N/A
  534. * Description : 소모품대장 출력 List 조회
  535. ****************************************************************************************/
  536. function fGetCnsmblsList() {
  537. ds_main_cnsmblslist_item.clearData();
  538. var sectcd = ds_send_srch.getColumn(0, "srchsectcd");
  539. if( ds_send_srch.getColumn(0, "srchsect") != "" ) {
  540. if( sectcd == "00") { // 전체
  541. ds_send_srch.setColumn( 0, "srchhngnm", "");
  542. ds_send_srch.setColumn( 0, "srchorddrnm", "");
  543. ds_send_srch.setColumn( 0, "srchprodnm", "");
  544. ds_send_srch.setColumn( 0, "srchprodcd", "");
  545. } else if( sectcd == "01") { // 환자이름
  546. ds_send_srch.setColumn( 0, "srchhngnm", ds_send_srch.getColumn(0, "srchsect"));
  547. ds_send_srch.setColumn( 0, "srchorddrnm", "");
  548. ds_send_srch.setColumn( 0, "srchprodnm", "");
  549. ds_send_srch.setColumn( 0, "srchprodcd", "");
  550. } else if( sectcd == "02") { //처방의사
  551. ds_send_srch.setColumn( 0, "srchorddrnm", ds_send_srch.getColumn(0, "srchsect"));
  552. ds_send_srch.setColumn( 0, "srchhngnm", "");
  553. ds_send_srch.setColumn( 0, "srchprodnm", "");
  554. ds_send_srch.setColumn( 0, "srchprodcd", "");
  555. } else if( sectcd == "03") { //제작자
  556. ds_send_srch.setColumn( 0, "srchprodnm", ds_send_srch.getColumn(0, "srchsect"));
  557. ds_send_srch.setColumn( 0, "srchhngnm", "");
  558. ds_send_srch.setColumn( 0, "srchorddrnm", "");
  559. ds_send_srch.setColumn( 0, "srchprodcd", "");
  560. } else { // 04 제작물내용
  561. ds_send_srch.setColumn( 0, "srchprodcd", ds_send_srch.getColumn(0, "srchsect"));
  562. ds_send_srch.setColumn( 0, "srchhngnm", "");
  563. ds_send_srch.setColumn( 0, "srchorddrnm", "");
  564. ds_send_srch.setColumn( 0, "srchprodnm", "");
  565. }
  566. }
  567. if( ds_send_srch.getColumn(0, "srchmetalcd") == "all" ) {
  568. ds_send_srch.setColumn( 0, "srchmetalcd", "");
  569. }
  570. if( ds_send_srch.getColumn(0, "srchoutordyn") == "00" ) {
  571. ds_send_srch.setColumn( 0, "srchoutordyn", "");
  572. }
  573. dsf_createDsRow("ds_req", [
  574. {col:"srchfromdd", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchfromdd")}
  575. , {col:"srchtodd", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchtodd")}
  576. , {col:"metalcd", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchmetalcd")}
  577. , {col:"hngnm", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchhngnm")}
  578. , {col:"orddrnm", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchorddrnm")}
  579. , {col:"prodnm", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchprodnm")}
  580. , {col:"prodcd", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchprodcd")}
  581. , {col:"outordyn", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchoutordyn")}
  582. , {col:"srchdkind", type:"STRING", size:256, val:ds_send_srch.getColumn(0,"srchdkind")}
  583. ]);
  584. var oParam = {};
  585. oParam.id = "TRAED00400";
  586. oParam.service = "dentalcraftapp.DentalCraft";
  587. oParam.method = "reqGetDentalMetalCnsmblsList";
  588. oParam.inds = "req=ds_req";
  589. oParam.outds = "ds_main_cnsmblslist_item=item";
  590. oParam.async = false;
  591. oParam.callback = "cf_TRAED00400";
  592. tranf_submit(oParam);
  593. if( ds_send_srch.getColumn(0, "srchmetalcd") == "" ) {
  594. ds_send_srch.setColumn( 0, "srchmetalcd", "all");
  595. }
  596. if( ds_send_srch.getColumn(0, "srchoutordyn") == "" ) {
  597. ds_send_srch.setColumn( 0, "srchoutordyn", "00");
  598. }
  599. var amt_totalsum = 0;
  600. var in_totalsum = 0;
  601. var use_totalsum = 0;
  602. var sto_totalsum = 0;
  603. var Cnt = ds_main_cnsmblslist_item.rowcount;
  604. if( Cnt > 0 ) {
  605. for( var i = 0 ; i < Cnt ; i++ ) {
  606. if(ds_main_cnsmblslist_item.getColumn(i, "rcptamt") != "" ){
  607. amt_totalsum = amt_totalsum + parseFloat( ds_main_cnsmblslist_item.getColumn(i, "rcptamt") );
  608. }
  609. if( ds_main_cnsmblslist_item.getColumn(i, "inqty") != "" ){
  610. in_totalsum = in_totalsum + parseFloat( ds_main_cnsmblslist_item.getColumn(i, "inqty") );
  611. }
  612. if( ds_main_cnsmblslist_item.getColumn(i, "useqty") != "" ){
  613. use_totalsum = use_totalsum + parseFloat( ds_main_cnsmblslist_item.getColumn(i, "useqty") );
  614. }
  615. if( ds_main_cnsmblslist_item.getColumn(i, "stockqty") != "" ){
  616. sto_totalsum = sto_totalsum + parseFloat( ds_main_cnsmblslist_item.getColumn(i, "stockqty") );
  617. }
  618. ds_main.setColumn( 0, "rcptamtsum" , amt_totalsum);
  619. ds_main.setColumn( 0, "inqtysum" , in_totalsum);
  620. ds_main.setColumn( 0, "useqtysum" , use_totalsum);
  621. ds_main.setColumn( 0, "stockqtysum" , sto_totalsum);
  622. }
  623. }
  624. }
  625. function cf_TRAED00400(sSvcId, nErrorCode, sErrorMsg) {
  626. if(nErrorCode < 0) return;
  627. dsf_setDefaultVal(ds_main_cnsmblslist_item,"all");
  628. }
  629. //=======================================================================================
  630. // Event
  631. //---------------------------------------------------------------------------------------
  632. /****************************************************************************************
  633. * Components : Form
  634. * Description : 화면 처음 초기화시 폼초기화
  635. ****************************************************************************************/
  636. function SMAED00400_onload(obj:Form, e:LoadEventInfo)
  637. {
  638. frmf_initForm(obj);
  639. //grdf_initGrid(grd_XXX);
  640. //grdf_setGridSort(grd_XXX);
  641. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  642. fGetScreenInit();
  643. fGetComboInit();
  644. }
  645. /****************************************************************************************
  646. * Components : Button
  647. * Description : 소모품대장 출력
  648. ****************************************************************************************/
  649. function grp_btn_btn_prt_onclick(obj:Button, e:ClickEventInfo) {
  650. ds_rexprnt.clearData(); ds_rexprnt.addRow();
  651. dsf_createDs("ds_rexprnt_cnsmblslist_item");
  652. var Cnt = ds_main_cnsmblslist_item.rowcount;
  653. if( Cnt > 0 ) {
  654. dsf_copyColInfo(ds_rexprnt_cnsmblslist_item,ds_main_cnsmblslist_item);
  655. for( var i = 0 ; i < Cnt ; i++ ) {
  656. var nRow = ds_rexprnt_cnsmblslist_item.addRow();
  657. ds_rexprnt_cnsmblslist_item.copyRow(nRow, ds_main_cnsmblslist_item, i);
  658. ds_rexprnt_cnsmblslist_item.setColumn(nRow, "acptno", grp_main.mltgrd_cnsmblslist.getCellText(i, grp_main.mltgrd_cnsmblslist.getBindCellIndex("body","acptno")) );
  659. }
  660. ds_rexprnt.setColumn( 0, "srchtodd", grp_main.grp_srch.ipt_srchtodd.text);
  661. ds_rexprnt.setColumn( 0, "srchfromdd", grp_main.grp_srch.ipt_srchfromdd.text);
  662. ds_rexprnt.setColumn( 0, "prodnm", "");
  663. ds_rexprnt.setColumn( 0, "metalcd", grp_main.grp_srch.cmb_metalcd.text);
  664. var objDOM = rptf_createDOM();
  665. var objParam = new Object();
  666. rptf_setNodeListToDOM(objDOM, "/root/rexprnt" , ds_rexprnt);
  667. rptf_setNodeListToDOM(objDOM, "/root/rexprnt/cnsmblslist/item" , ds_rexprnt_cnsmblslist_item);
  668. objParam.xml_data_XML1 = objDOM.documentElement.source;
  669. var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
  670. rptf_exeReportPreview30(["RPAED00400"],[objParam], option);
  671. }
  672. }
  673. /****************************************************************************************
  674. * Components : Button
  675. * Description :
  676. ****************************************************************************************/
  677. function grp_main_grp_srch_btn_select_onclick(obj:Button, e:ClickEventInfo) {
  678. fGetCnsmblsList();
  679. }
  680. /****************************************************************************************
  681. * Components : Combo
  682. * Description : 조회조건 선택
  683. ****************************************************************************************/
  684. function grp_main_grp_srch_cmb_sect_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  685. if( ds_send_srch.getColumn(0, "srchsectcd") == "00" ) {
  686. grp_main.grp_srch.ipt_sect.visible = true;
  687. grp_main.grp_srch.ipt_sect.enable = false;
  688. grp_main.grp_srch.cmb_prodid.visible = false;
  689. grp_main.grp_srch.cmb_prodcd.visible = false;
  690. }
  691. if( ds_send_srch.getColumn(0, "srchsectcd") == "01" || ds_send_srch.getColumn(0, "srchsectcd") == "02" ) {
  692. grp_main.grp_srch.ipt_sect.visible = true;
  693. grp_main.grp_srch.ipt_sect.enable = true;
  694. grp_main.grp_srch.cmb_prodid.visible = false;
  695. grp_main.grp_srch.cmb_prodcd.visible = false;
  696. }
  697. if( ds_send_srch.getColumn(0, "srchsectcd") == "03") { // 제작자
  698. grp_main.grp_srch.cmb_prodid.visible = true;
  699. grp_main.grp_srch.ipt_sect.visible = false;
  700. grp_main.grp_srch.cmb_prodcd.visible = false;
  701. }
  702. if( ds_send_srch.getColumn(0, "srchsectcd") == "04") { // 제작물내용
  703. grp_main.grp_srch.cmb_prodcd.visible = true;
  704. grp_main.grp_srch.ipt_sect.visible = false;
  705. grp_main.grp_srch.cmb_prodid.visible = false;
  706. }
  707. }
  708. ]]></Script>
  709. </Form>
  710. </FDL>