SMAEB03402_조영제재고관리조회.xfdl 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAEB03402" position="absolute 0 0 1195 775" titletext="조영제/재료 재고관리 조회" oninit="SMAEB03402_oninit" onload="SMAEB03402_onload">
  5. <Layouts>
  6. <Layout>
  7. <Button position="absolute 510 520 590 542" id="btn_rept" class="btn4" text="입고저장"/>
  8. <Button position="absolute 1105 520 1185 542" id="button1" class="btn4" text="입고저장"/>
  9. <Div position="absolute 0 15 1195 745" id="group2" scrollbars="autoboth" anchor="all">
  10. <Layouts>
  11. <Layout>
  12. <Static text="입출고 현황" position="absolute 0 58 113 75" id="caption22" class="tit_2" anchor="default"/>
  13. <Shape position="absolute 0 73 1193 79" linetype="horizontal" id="line7" class="line_1" anchor="left top right"/>
  14. <Grid position="absolute 0 79 1193 725" id="grd_dyelist" binddataset="ds_main_dyestoclist_item" anchor="all" cellsizingtype="both" selecttype="multirow">
  15. <Formats>
  16. <Format id="default">
  17. <Columns>
  18. <Column size="25" band="left"/>
  19. <Column size="100"/>
  20. <Column size="240"/>
  21. <Column size="90"/>
  22. <Column size="90"/>
  23. <Column size="90"/>
  24. <Column size="90"/>
  25. <Column size="90"/>
  26. <Column size="90"/>
  27. <Column size="270"/>
  28. <Column size="0"/>
  29. <Column size="0"/>
  30. <Column size="0"/>
  31. </Columns>
  32. <Rows>
  33. <Row size="24" band="head"/>
  34. <Row size="24" band="head"/>
  35. <Row size="24"/>
  36. </Rows>
  37. <Band id="head">
  38. <Cell rowspan="2" taborder="undefined"/>
  39. <Cell col="1" rowspan="2" text="조영제/재료코드" taborder="undefined"/>
  40. <Cell col="2" rowspan="2" text="조영제/재료명" taborder="undefined"/>
  41. <Cell col="3" rowspan="2" text="전일재고" taborder="undefined"/>
  42. <Cell col="4" rowspan="2" text="수 령" taborder="undefined"/>
  43. <Cell col="5" rowspan="2" text="총 수" taborder="undefined"/>
  44. <Cell col="6" colspan="2" text="소 모" taborder="undefined"/>
  45. <Cell col="8" rowspan="2" text="현재고" taborder="undefined"/>
  46. <Cell col="9" rowspan="2" text="비 고" taborder="undefined"/>
  47. <Cell col="10"/>
  48. <Cell col="11"/>
  49. <Cell col="12"/>
  50. <Cell row="1" col="6" text="불 출"/>
  51. <Cell row="1" col="7" text="일소모"/>
  52. <Cell row="1" col="10"/>
  53. <Cell row="1" col="11"/>
  54. <Cell row="1" col="12"/>
  55. </Band>
  56. <Band id="body">
  57. <Cell celltype="head"/>
  58. <Cell col="1" style="align:left middle;padding:0 2 0 2;" text="bind:goodcd"/>
  59. <Cell col="2" displaytype="combo" style="align:left middle;padding:0 2 0 2;" text="bind:goodcd" combodataset="ds_main_goodinfo" combocodecol="goodcd" combodatacol="goodnm" enable="false"/>
  60. <Cell col="3" displaytype="number" edittype="none" text="bind:agojego" mask="#,##9.##"/>
  61. <Cell col="4" displaytype="number" edittype="none" text="bind:receive" mask="#,##9.##"/>
  62. <Cell col="5" displaytype="number" text="bind:totsu" mask="#,##9.##"/>
  63. <Cell col="6" displaytype="number" edittype="none" text="bind:outgo" mask="#,##9.##"/>
  64. <Cell col="7" displaytype="number" edittype="none" text="bind:dayused" mask="#,##9.##" enable="true"/>
  65. <Cell col="8" displaytype="number" text="bind:presentcnt" mask="#,##9.##"/>
  66. <Cell col="9" displaytype="text" edittype="none" style="align:left middle;padding:0 2 0 2;" text="bind:rem" enable="true"/>
  67. <Cell col="10" text="bind:iodd"/>
  68. <Cell col="11" text="bind:suppdeptcd"/>
  69. <Cell col="12" text="bind:sectcd"/>
  70. </Band>
  71. </Format>
  72. </Formats>
  73. </Grid>
  74. <Button position="absolute 1114 52 1194 74" id="btn_excsave" class="btn7" text="엑셀저장" anchor="top right" onclick="group2_btn_excsave_onclick"/>
  75. <Shape id="line00" class="line_1" position="absolute 0 74 1193 80" anchor="left top right"/>
  76. <Shape id="line01" class="line_1" position="absolute 0 75 1193 81" anchor="left top right"/>
  77. <CheckBox id="chk_notzero" taborder="1" text="일소모가 없으면 제외" position="absolute 912 51 1076 70" value="false" onclick="group2_chk_notzero_onclick"/>
  78. </Layout>
  79. </Layouts>
  80. </Div>
  81. <Div position="absolute 0 747 1193 772" id="grp_btn" anchor="left right bottom">
  82. <Layouts>
  83. <Layout>
  84. <Button position="absolute 0 0 56 22" id="button2" class="btn6" taborder="6" text="출력" anchor="default" onclick="grp_btn_button2_onclick"/>
  85. </Layout>
  86. </Layouts>
  87. </Div>
  88. <Static id="caption6" text="조영제/재료 소모재고관리" class="tit_1" position="absolute 0 0 200 25"/>
  89. <Div id="group4" taborder="1" class="div_SA" position="absolute 0 25 1194 65" anchor="left top right">
  90. <Layouts>
  91. <Layout>
  92. <Static id="caption19" text="입출고 기간 :" class="search_name" position="absolute 10 14 107 31" anchor="default"/>
  93. <Calendar id="ipt_fromdd" taborder="6" class="input_search" position="absolute 104 12 197 31" mask="yyyy-mm-dd" anchor="default" autoselect="true"/>
  94. <Shape id="line6" linetype="vertical" class="line_4" position="absolute 1113 10 1119 32" anchor="top right"/>
  95. <Static id="caption20" text="검사실 :" class="search_name" position="absolute 705 14 764 31" anchor="default"/>
  96. <Button id="button3" taborder="7" text="조회" class="btn1" position="absolute 1129 10 1185 32" anchor="top right" onclick="group4_button3_onclick"/>
  97. <Combo id="cmb_sectcd" taborder="8" innerdataset="ds_init_excuroomcdlist_excuroom" codecolumn="basecd" datacolumn="basecdflagdesc" position="absolute 769 12 916 31" anchor="default"/>
  98. <Static id="lbl_srchdd" text="구 분 :" class="search_name" position="absolute 520 14 574 31" anchor="default"/>
  99. <Combo id="cmb_excuroomgrp" taborder="9" innerdataset="ds_cmb_info_initexcuroomgrp" codecolumn="excuroomgrpcdid" datacolumn="excuroomgrpcdnm" class="combo_search" position="absolute 576 12 691 31" anchor="default" onitemchanged="group4_cmb_excuroomgrp_onitemchanged"/>
  100. <Static id="lbl_~" text="~" class="search_no_b" position="absolute 200 13 212 30" anchor="default"/>
  101. <Calendar id="ipt_todd" taborder="10" class="input_search" position="absolute 212 12 305 31" anchor="default" autoselect="true"/>
  102. <Static id="caption1" text="지원부서 :" class="search_name" position="absolute 316 14 394 31" anchor="default"/>
  103. <Combo id="cmb_sudpt" taborder="11" innerdataset="ds_cmb_info_suppdept" codecolumn="suppdeptcd" datacolumn="depthngnm" class="combo_search" position="absolute 391 12 511 31" anchor="default" onitemchanged="group4_cmb_sudpt_onitemchanged"/>
  104. <Radio id="rdo_itemcd" taborder="12" columncount="3" rowcount="0" position="absolute 932 13 1094 34" codecolumn="codecolumn" datacolumn="datacolumn" value="A" index="0">
  105. <Dataset id="innerdataset">
  106. <ColumnInfo>
  107. <Column id="codecolumn" size="256"/>
  108. <Column id="datacolumn" size="256"/>
  109. </ColumnInfo>
  110. <Rows>
  111. <Row>
  112. <Col id="codecolumn">A</Col>
  113. <Col id="datacolumn">전체</Col>
  114. </Row>
  115. <Row>
  116. <Col id="codecolumn">C</Col>
  117. <Col id="datacolumn">조영제</Col>
  118. </Row>
  119. <Row>
  120. <Col id="codecolumn">M</Col>
  121. <Col id="datacolumn">재료</Col>
  122. </Row>
  123. </Rows>
  124. </Dataset>
  125. </Radio>
  126. </Layout>
  127. </Layouts>
  128. </Div>
  129. </Layout>
  130. </Layouts>
  131. <Objects>
  132. <Dataset id="ds_rexprnt_dyestoclist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  133. <ColumnInfo>
  134. <Column id="srchiodd" type="STRING" size="256"/>
  135. <Column id="srchsectcd" type="STRING" size="256"/>
  136. <Column id="srchexcuroomgrp" type="STRING" size="256"/>
  137. <Column id="srchsudept" type="STRING" size="256"/>
  138. </ColumnInfo>
  139. <Rows>
  140. <Row>
  141. <Col id="srchiodd"/>
  142. <Col id="srchsectcd"/>
  143. <Col id="srchexcuroomgrp"/>
  144. <Col id="srchsudept"/>
  145. </Row>
  146. </Rows>
  147. </Dataset>
  148. <Dataset id="ds_main_dyestoclist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  149. <ColumnInfo>
  150. <Column id="goodcd" type="STRING" size="256"/>
  151. <Column id="instcd" type="STRING" size="256"/>
  152. <Column id="agojego" type="STRING" size="256"/>
  153. <Column id="receive" type="STRING" size="256"/>
  154. <Column id="totsu" type="STRING" size="256"/>
  155. <Column id="outgo" type="STRING" size="256"/>
  156. <Column id="dayused" type="STRING" size="256"/>
  157. <Column id="presentcnt" type="STRING" size="256"/>
  158. <Column id="rem" type="STRING" size="256"/>
  159. <Column id="srchflag" type="STRING" size="256"/>
  160. <Column id="magamflag" type="STRING" size="256"/>
  161. </ColumnInfo>
  162. <Rows>
  163. <Row>
  164. <Col id="goodcd"/>
  165. <Col id="instcd"/>
  166. <Col id="agojego"/>
  167. <Col id="receive"/>
  168. <Col id="totsu"/>
  169. <Col id="outgo"/>
  170. <Col id="dayused"/>
  171. <Col id="presentcnt"/>
  172. <Col id="rem"/>
  173. <Col id="srchflag"/>
  174. <Col id="magamflag"/>
  175. </Row>
  176. </Rows>
  177. </Dataset>
  178. <Dataset id="ds_main_goodinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  179. <Dataset id="ds_main_dyecdpamlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  180. <ColumnInfo>
  181. <Column id="pid" type="STRING" size="256"/>
  182. <Column id="hngnm" type="STRING" size="256"/>
  183. <Column id="excuexectodd" type="STRING" size="256"/>
  184. <Column id="basecdflagdesc" type="STRING" size="256"/>
  185. <Column id="calcscorcd" type="STRING" size="256"/>
  186. <Column id="excucdnm" type="STRING" size="256"/>
  187. <Column id="goodcd" type="STRING" size="256"/>
  188. <Column id="goodnm" type="STRING" size="256"/>
  189. <Column id="drugqty" type="STRING" size="256"/>
  190. <Column id="speccd" type="STRING" size="256"/>
  191. <Column id="prcpdd" type="STRING" size="256"/>
  192. <Column id="instcd" type="STRING" size="256"/>
  193. <Column id="excuroomcd" type="STRING" size="256"/>
  194. </ColumnInfo>
  195. <Rows>
  196. <Row>
  197. <Col id="pid"/>
  198. <Col id="hngnm"/>
  199. <Col id="excuexectodd"/>
  200. <Col id="basecdflagdesc"/>
  201. <Col id="calcscorcd"/>
  202. <Col id="excucdnm"/>
  203. <Col id="goodcd"/>
  204. <Col id="goodnm"/>
  205. <Col id="drugqty"/>
  206. <Col id="speccd"/>
  207. <Col id="prcpdd"/>
  208. <Col id="instcd"/>
  209. <Col id="excuroomcd"/>
  210. </Row>
  211. </Rows>
  212. </Dataset>
  213. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  214. <ColumnInfo>
  215. <Column id="srchiodd" type="STRING" size="256"/>
  216. <Column id="srchsectcd" type="STRING" size="256"/>
  217. <Column id="srchgoodcd" type="STRING" size="256"/>
  218. <Column id="srchgoodnm" type="STRING" size="256"/>
  219. <Column id="srchexcuroomgrp" type="STRING" size="256"/>
  220. <Column id="srchtodd" type="STRING" size="256"/>
  221. <Column id="srchfromdd" type="STRING" size="256"/>
  222. <Column id="excuroomgrpcdid" type="STRING" size="256"/>
  223. <Column id="srchsuppdeptcd" type="STRING" size="256"/>
  224. <Column id="excuroomcd" type="STRING" size="256"/>
  225. <Column id="itemcd" type="STRING" size="256"/>
  226. </ColumnInfo>
  227. <Rows>
  228. <Row>
  229. <Col id="srchiodd"/>
  230. <Col id="srchsectcd"/>
  231. <Col id="srchgoodcd"/>
  232. <Col id="srchgoodnm"/>
  233. <Col id="srchexcuroomgrp"/>
  234. <Col id="srchtodd"/>
  235. <Col id="srchfromdd"/>
  236. <Col id="excuroomgrpcdid"/>
  237. <Col id="srchsuppdeptcd"/>
  238. <Col id="excuroomcd"/>
  239. </Row>
  240. </Rows>
  241. </Dataset>
  242. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  243. <ColumnInfo>
  244. <Column id="goodcd" type="STRING" size="256"/>
  245. <Column id="goodnm" type="STRING" size="256"/>
  246. <Column id="speccd" type="STRING" size="256"/>
  247. <Column id="safestocqty" type="STRING" size="256"/>
  248. <Column id="inswlniodd" type="STRING" size="256"/>
  249. <Column id="inswlngoodcd" type="STRING" size="256"/>
  250. <Column id="inswlnqty" type="STRING" size="256"/>
  251. <Column id="setwlniodd" type="STRING" size="256"/>
  252. <Column id="setwlngoodcd" type="STRING" size="256"/>
  253. <Column id="setwlnqty" type="STRING" size="256"/>
  254. <Column id="insuseiodd" type="STRING" size="256"/>
  255. <Column id="insusegoodcd" type="STRING" size="256"/>
  256. <Column id="insuseqty" type="STRING" size="256"/>
  257. <Column id="setuseiodd" type="STRING" size="256"/>
  258. <Column id="setusegoodcd" type="STRING" size="256"/>
  259. <Column id="setuseqty" type="STRING" size="256"/>
  260. <Column id="count" type="STRING" size="256"/>
  261. </ColumnInfo>
  262. <Rows>
  263. <Row>
  264. <Col id="goodcd"/>
  265. <Col id="goodnm"/>
  266. <Col id="speccd"/>
  267. <Col id="safestocqty"/>
  268. <Col id="inswlniodd"/>
  269. <Col id="inswlngoodcd"/>
  270. <Col id="inswlnqty"/>
  271. <Col id="setwlniodd"/>
  272. <Col id="setwlngoodcd"/>
  273. <Col id="setwlnqty"/>
  274. <Col id="insuseiodd"/>
  275. <Col id="insusegoodcd"/>
  276. <Col id="insuseqty"/>
  277. <Col id="setuseiodd"/>
  278. <Col id="setusegoodcd"/>
  279. <Col id="setuseqty"/>
  280. <Col id="count"/>
  281. </Row>
  282. </Rows>
  283. </Dataset>
  284. <Dataset id="ds_rexprnt_dyestoclist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  285. <Dataset id="ds_temp_goodlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  286. <ColumnInfo>
  287. <Column id="goodcd" type="STRING" size="256"/>
  288. <Column id="goodnm" type="STRING" size="256"/>
  289. </ColumnInfo>
  290. <Rows>
  291. <Row/>
  292. </Rows>
  293. </Dataset>
  294. <Dataset id="ds_main_goodlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  295. <ColumnInfo>
  296. <Column id="goodcd" type="STRING" size="256"/>
  297. <Column id="goodnm" type="STRING" size="256"/>
  298. <Column id="speccd" type="STRING" size="256"/>
  299. <Column id="safestocqty" type="STRING" size="256"/>
  300. <Column id="exstocqty" type="STRING" size="256"/>
  301. <Column id="wlnqty" type="STRING" size="256"/>
  302. <Column id="sumqty" type="STRING" size="256"/>
  303. <Column id="useqty" type="STRING" size="256"/>
  304. <Column id="stocqty" type="STRING" size="256"/>
  305. <Column id="reqqty" type="STRING" size="256"/>
  306. </ColumnInfo>
  307. <Rows>
  308. <Row>
  309. <Col id="goodcd"/>
  310. <Col id="goodnm"/>
  311. <Col id="speccd"/>
  312. <Col id="safestocqty"/>
  313. <Col id="exstocqty"/>
  314. <Col id="wlnqty"/>
  315. <Col id="sumqty"/>
  316. <Col id="useqty"/>
  317. <Col id="stocqty"/>
  318. <Col id="reqqty"/>
  319. </Row>
  320. </Rows>
  321. </Dataset>
  322. <Dataset id="ds_cmb_info_goodlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  323. <Dataset id="ds_main_mainlist_wlnlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  324. <ColumnInfo>
  325. <Column id="goodcd" type="STRING" size="256"/>
  326. <Column id="goodnm" type="STRING" size="256"/>
  327. <Column id="iodd" type="STRING" size="256"/>
  328. <Column id="qty" type="STRING" size="256"/>
  329. <Column id="usernm" type="STRING" size="256"/>
  330. <Column id="ioflag" type="STRING" size="256"/>
  331. <Column id="sectcd" type="STRING" size="256"/>
  332. <Column id="suppdeptcd" type="STRING" size="256"/>
  333. </ColumnInfo>
  334. <Rows>
  335. <Row>
  336. <Col id="goodcd"/>
  337. <Col id="goodnm"/>
  338. <Col id="iodd"/>
  339. <Col id="qty"/>
  340. <Col id="usernm"/>
  341. <Col id="ioflag"/>
  342. <Col id="sectcd"/>
  343. <Col id="suppdeptcd"/>
  344. </Row>
  345. </Rows>
  346. </Dataset>
  347. <Dataset id="ds_cmb_info_initexcuroomgrp2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  348. <ColumnInfo>
  349. <Column id="excuroomgrpcdid" type="STRING" size="256"/>
  350. <Column id="excuroomgrpcdnm" type="STRING" size="256"/>
  351. </ColumnInfo>
  352. <Rows>
  353. <Row/>
  354. </Rows>
  355. </Dataset>
  356. <Dataset id="ds_main_mainlist_uselist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  357. <ColumnInfo>
  358. <Column id="goodcd" type="STRING" size="256"/>
  359. <Column id="goodnm" type="STRING" size="256"/>
  360. <Column id="iodd" type="STRING" size="256"/>
  361. <Column id="qty" type="STRING" size="256"/>
  362. <Column id="usernm" type="STRING" size="256"/>
  363. <Column id="ioflag" type="STRING" size="256"/>
  364. <Column id="sectcd" type="STRING" size="256"/>
  365. <Column id="suppdeptcd" type="STRING" size="256"/>
  366. </ColumnInfo>
  367. <Rows>
  368. <Row>
  369. <Col id="goodcd"/>
  370. <Col id="goodnm"/>
  371. <Col id="iodd"/>
  372. <Col id="qty"/>
  373. <Col id="usernm"/>
  374. <Col id="ioflag"/>
  375. <Col id="sectcd"/>
  376. <Col id="suppdeptcd"/>
  377. </Row>
  378. </Rows>
  379. </Dataset>
  380. <Dataset id="ds_init_cmb_info2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  381. <Dataset id="ds_cmb_info_suppdept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  382. <ColumnInfo>
  383. <Column id="suppdeptcd" type="STRING" size="256"/>
  384. <Column id="depthngnm" type="STRING" size="256"/>
  385. </ColumnInfo>
  386. <Rows>
  387. <Row/>
  388. </Rows>
  389. </Dataset>
  390. <Dataset id="ds_cmb_info_initexcuroomgrp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  391. <ColumnInfo>
  392. <Column id="excuroomgrpcdid" type="STRING" size="256"/>
  393. <Column id="excuroomgrpcdnm" type="STRING" size="256"/>
  394. </ColumnInfo>
  395. <Rows>
  396. <Row/>
  397. </Rows>
  398. </Dataset>
  399. <Dataset id="ds_init_excuroomcdlist_excuroom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  400. <ColumnInfo>
  401. <Column id="basecd" type="STRING" size="256"/>
  402. <Column id="basecdflagdesc" type="STRING" size="256"/>
  403. </ColumnInfo>
  404. <Rows>
  405. <Row/>
  406. </Rows>
  407. </Dataset>
  408. <Dataset id="ds_init_cmb_info2_initexecroom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  409. </Objects>
  410. <Bind>
  411. <BindItem id="item0" compid="group4.ipt_fromdd" propid="value" datasetid="ds_send" columnid="srchfromdd"/>
  412. <BindItem id="item1" compid="group4.ipt_todd" propid="value" datasetid="ds_send" columnid="srchtodd"/>
  413. <BindItem id="item2" compid="group4.cmb_sudpt" propid="value" datasetid="ds_send" columnid="srchsuppdeptcd"/>
  414. <BindItem id="item3" compid="group4.cmb_excuroomgrp" propid="value" datasetid="ds_send" columnid="srchexcuroomgrp"/>
  415. <BindItem id="item4" compid="group4.cmb_sectcd" propid="value" datasetid="ds_send" columnid="srchsectcd"/>
  416. <BindItem id="item5" compid="group4.rdo_itemcd" propid="value" datasetid="ds_send" columnid="itemcd"/>
  417. </Bind>
  418. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  419. * System Name :
  420. * Job Name :
  421. * Creator :
  422. * Make Date : 2016-06-17
  423. * Description :
  424. *---------------------------------------------------------------------------------------
  425. * Modify Date Modifier Modify Description
  426. *---------------------------------------------------------------------------------------
  427. * 2016-06-17 Live Converter TF->XP
  428. *
  429. *---------------------------------------------------------------------------------------
  430. ****************************************************************************************/
  431. //=======================================================================================
  432. // Lib Include
  433. //---------------------------------------------------------------------------------------
  434. include "com_commonxp::comm_main.xjs"
  435. include "ast_examcurexp::AEZ0001.xjs"
  436. //=======================================================================================
  437. // Global Form Variable
  438. //---------------------------------------------------------------------------------------
  439. var arErrorCode = new HashArray();
  440. var gSuppdeptcd = "";
  441. //=======================================================================================
  442. // Function
  443. //---------------------------------------------------------------------------------------
  444. /****************************************************************************************
  445. * Argument : N/A
  446. * Description :
  447. ****************************************************************************************/
  448. function getGridData() {
  449. if(ds_send.getColumn(0,"srchiodd") != "") {
  450. model.setValue("/root/temp/goodnm", cmb_goodcd.label);
  451. model.setValue("/root/temp/inswlnqty", "0");
  452. model.setValue("/root/temp/setwlnqty", "0");
  453. model.setValue("/root/temp/insuseqty", "0");
  454. model.setValue("/root/temp/setuseqty", "0");
  455. model.removeNodeset("/root/main/mainlist");
  456. model.removeNodeset("/root/main/goodlist/item");
  457. btn_inSave.disabled = true;
  458. btn_inUpdt.disabled = true;
  459. btn_outSave.disabled = true;
  460. btn_outUpdt.disabled = true;
  461. ipt_inswlnday.disabled = true;
  462. ipt_insuseday.disabled = true;
  463. submit("TRAEB03401");
  464. ds_send.setColumn(0,"srchiodd", utlf_getCurrentDate());
  465. var srchgoodcd = ds_send.getColumn(0,"srchgoodcd");
  466. if (srchgoodcd != "") {
  467. btn_inSave.disabled = false;
  468. btn_outSave.disabled = false;
  469. ipt_inswlnday.disabled = false;
  470. ipt_insuseday.disabled = false;
  471. }
  472. // if(model.getXPathValue("count(/root/main/mainlist/wlnlist)") > 0)
  473. // {
  474. // btn_inSave.disabled = true;
  475. // ipt_inswlnqty.disabled = true;
  476. // btn_inUpdt.disabled = false;
  477. // ipt_setwlnqty.disabled = false;
  478. // }
  479. // else
  480. // {
  481. // btn_inUpdt.disabled = true;
  482. // ipt_setwlnqty.disabled = true;
  483. // btn_inSave.disabled = false;
  484. // ipt_inswlnqty.disabled = false;
  485. // }
  486. //
  487. // if(model.getXPathValue("count(/root/main/mainlist/uselist)") > 0)
  488. // {
  489. // btn_outSave.disabled = true;
  490. // ipt_insuseqty.disabled = true;
  491. // btn_outUpdt.disabled = false;
  492. // ipt_setuseqty.disabled = false;
  493. // }
  494. // else
  495. // {
  496. // btn_outUpdt.disabled = true;
  497. // ipt_setuseqty.disabled = true;
  498. // btn_outSave.disabled = false;
  499. // ipt_insuseqty.disabled = false;
  500. // }
  501. model.refresh();
  502. }
  503. else
  504. {
  505. messageBox("날짜를", "C001");
  506. }
  507. }
  508. /****************************************************************************************
  509. * Argument : N/A
  510. * Description : 조회
  511. ****************************************************************************************/
  512. function getDyeList() {
  513. if( utlf_isNull(ds_send.getColumn(0,"srchfromdd")) || utlf_isNull(ds_send.getColumn(0,"srchtodd")) ){
  514. sysf_messageBox("입고일자를", "I007");
  515. return;
  516. }
  517. // 2011.02.07 c y w 조회시 환자정보리스트 클리어
  518. ds_main_dyestoclist_item.clearData();
  519. dsf_createDsRow("ds_req", [
  520. {col:"srchfromdd", type:"STRING", size:256, val:ds_send.getColumn(0,"srchfromdd")}
  521. , {col:"srchtodd", type:"STRING", size:256, val:ds_send.getColumn(0,"srchtodd")}
  522. , {col:"suppdeptcd", type:"STRING", size:256, val:ds_send.getColumn(0,"srchsuppdeptcd")}
  523. , {col:"srchsectcd", type:"STRING", size:256, val:ds_send.getColumn(0,"srchsectcd")}
  524. , {col:"srchexcuroomgrp", type:"STRING", size:256, val:ds_send.getColumn(0,"srchexcuroomgrp")}
  525. , {col:"itemcd", type:"STRING", size:256, val:ds_send.getColumn(0,"itemcd")}
  526. ]);
  527. var oParam = {};
  528. oParam.id = "TRAEB03404";
  529. oParam.service = "examcurebaseapp.DyeCode";
  530. oParam.method = "reqGetDyeStockMngtSearchLst";
  531. oParam.inds = "req=ds_req";
  532. oParam.outds = "ds_main_dyestoclist_item=item";
  533. oParam.async = true;
  534. // oParam.callback = "cf_TRAEB03404";
  535. tranf_submit(oParam);
  536. //sysf_messageBox("0 =" + group2.chk_notzero.value);
  537. if (group2.chk_notzero.value == true ) {
  538. ds_main_dyestoclist_item.filter("dayused != '0'");
  539. } else {
  540. ds_main_dyestoclist_item.filter("");
  541. }
  542. }
  543. function cf_TRAEB03404(sSvcId, nErrorCode, sErrorMsg) {
  544. if(nErrorCode < 0) return;
  545. var cnt = ds_main_dyestoclist_item.rowcount;
  546. for(var i = 0; i < cnt; i++ ){
  547. ds_main_dyestoclist_item.setColumn(i,"rem","");
  548. }
  549. }
  550. //=======================================================================================
  551. // Event
  552. //---------------------------------------------------------------------------------------
  553. /****************************************************************************************
  554. * Components : Form
  555. * Components ID : SMAEB03402
  556. * Event : oninit
  557. * Argument : 01.obj : Object Event has occurred
  558. * : 02.e : Event Object
  559. * Description : 화면 처음 초기화시 폼초기화
  560. ****************************************************************************************/
  561. function SMAEB03402_oninit(obj:Form, e:InitEventInfo)
  562. {
  563. frmf_initForm(obj); // 폼 초기화
  564. }
  565. /****************************************************************************************
  566. * Components : Form
  567. * Components ID : SMAEB03402
  568. * Event : onload
  569. * Argument : 01.obj : Object Event has occurred
  570. * : 02.e : Event Object
  571. * Description : 화면 처음 초기화시 폼초기화
  572. ****************************************************************************************/
  573. function SMAEB03402_onload(obj:Form, e:LoadEventInfo)
  574. {
  575. lf_aezfSetSuppDeptcd(); //AEZ0001.xjs
  576. gSuppdeptcd = frmf_getParameter("AST_DEPTCD");
  577. //20161207 메뉴에서 파라메터 가져오기
  578. var gvMenuParam = frmf_getMenuParam();
  579. //alert(gvMenuParam)
  580. if ( !utlf_isNull(gvMenuParam) && gvMenuParam != "null" ) {
  581. gSuppdeptcd = gvMenuParam ;
  582. }
  583. grdf_setRowTypeIcon(group2.grd_dyelist, 0); // 그리드 상태 표시
  584. ds_send.setColumn(0,"srchfromdd", utlf_getCurrentDate());
  585. ds_send.setColumn(0,"srchtodd" , utlf_getCurrentDate());
  586. ds_send.setColumn(0,"itemcd" , 'A');
  587. ds_main_mainlist_uselist.clearData();
  588. ds_main_mainlist_wlnlist.clearData();
  589. dsf_createDsRow("ds_reqparam", [
  590. {col:"basesuppdeptcd", type:"STRING", size:256, val:gSuppdeptcd}
  591. , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
  592. , {col:"ebasecdflag", type:"STRING", size:256, val:"E"}
  593. , {col:"instcd", type:"STRING", size:256, val:""}
  594. , {col:"initflag", type:"STRING", size:256, val:"1"}
  595. , {col:"alladdyn", type:"STRING", size:256, val:""}
  596. ]);
  597. var oParam = {};
  598. oParam.id = "TRAEA01301";
  599. oParam.service = "examcureacptexecapp.ExamCureAcpt";
  600. oParam.method = "reqGetInitExamCureRoomGrpCodeList";
  601. oParam.inds = "reqparam=ds_reqparam";
  602. oParam.outds = "ds_cmb_info_initexcuroomgrp=initexcuroomgrp ds_cmb_info_initexcuroomgrp2=initexcuroomgrp2 ds_cmb_info_suppdept=suppdept";
  603. oParam.async = false;
  604. oParam.callback = "cf_TRAEA01301";
  605. tranf_submit(oParam);
  606. ds_init_cmb_info2_initexecroom.clear();
  607. ds_init_cmb_info2_initexecroom.copyData(ds_cmb_info_initexcuroomgrp2);
  608. ds_cmb_info_initexcuroomgrp.deleteRow(0);
  609. ds_cmb_info_initexcuroomgrp2.deleteRow(0);
  610. frmf_addComboItem("group4.cmb_excuroomgrp" , "-- 전체 --", "", "above");
  611. frmf_addComboItem("group4.cmb_sectcd" , "-- 전체 --", "", "above");
  612. frmf_addComboItem("group4.cmb_sudpt" , "-- 전체 --", "", "above");
  613. ds_send.setColumn(0,"srchsuppdeptcd", gSuppdeptcd);
  614. frmf_inputEnterKey("group4.cmb_sudpt", "onitemchanged", new ItemChangeEventInfo);
  615. dsf_createDsRow("ds_req", [
  616. {col:"basesuppdeptcd", type:"STRING", size:256, val:gSuppdeptcd}
  617. , {col:"srchgoodcd", type:"STRING", size:256, val:ds_send.getColumn(0,"srchgoodcd")}
  618. , {col:"srchgoodnm", type:"STRING", size:256, val:ds_send.getColumn(0,"srchgoodnm")}
  619. ]);
  620. var oParam = {};
  621. oParam.id = "TRAEB03501";
  622. oParam.service = "examcurebaseapp.DyeCode";
  623. oParam.method = "reqGetDyeCodeList";
  624. oParam.inds = "req=ds_req";
  625. oParam.outds = "ds_main_goodinfo=item";
  626. oParam.async = false;
  627. //oParam.callback = "cf_TRAEB03501";
  628. tranf_submit(oParam);
  629. group4.cmb_excuroomgrp.index = 0;
  630. }
  631. function cf_TRAEA01301(sSvcId, nErrorCode, sErrorMsg) {
  632. if(nErrorCode < 0) return;
  633. ds_cmb_info_initexcuroomgrp.updateColID("basecdcnts","excuroomgrpcdid");
  634. ds_cmb_info_initexcuroomgrp.updateColID("basecdcnts2","excuroomgrpcdnm");
  635. ds_cmb_info_initexcuroomgrp2.updateColID("basecdcnts","excuroomgrpcdid");
  636. ds_cmb_info_initexcuroomgrp2.updateColID("basecdcnts2","excuroomgrpcdnm");
  637. }
  638. /****************************************************************************************
  639. * Components : Combo
  640. * Components ID : group4.cmb_sudpt
  641. * Event : onitemchanged
  642. * Argument : 01.obj : Object Event has occurred
  643. * : 02.e : Event Object
  644. * Description : 지원부서 변경
  645. ****************************************************************************************/
  646. function group4_cmb_sudpt_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  647. {
  648. ds_init_excuroomcdlist_excuroom.clearData();
  649. if(utlf_isNull(ds_send.getColumn(0,"srchsuppdeptcd"))) {
  650. gSuppdeptcd = "";
  651. group4.cmb_excuroomgrp.index = 0;
  652. frmf_inputEnterKey("group4.cmb_excuroomgrp", "onitemchanged", new ItemChangeEventInfo);
  653. }else{
  654. gSuppdeptcd = ds_send.getColumn(0,"srchsuppdeptcd");
  655. ds_send.setColumn(0,"excuroomcd", "");
  656. dsf_createDsRow("ds_req", [
  657. {col:"basecd", type:"STRING", size:256, val:""}
  658. , {col:"basesuppdeptcd", type:"STRING", size:256, val:gSuppdeptcd}
  659. , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
  660. , {col:"instcd", type:"STRING", size:256, val:""}
  661. ]);
  662. var oParam = {};
  663. oParam.id = "TRAEA00902";
  664. oParam.service = "examcurebaseapp.ExamCureRoom";
  665. oParam.method = "reqGetExamCureRoomGrpList";
  666. oParam.inds = "req=ds_req";
  667. oParam.outds = "ds_init_excuroomcdlist_excuroom=item";
  668. oParam.async = false;
  669. //oParam.callback = "cf_TRAEA00902";
  670. tranf_submit(oParam);
  671. if(!utlf_isNull(ds_init_excuroomcdlist_excuroom.getColumn(0,"basecd"))){
  672. frmf_addComboItem("group4.cmb_sectcd", "-- 전체 --", "", "above");
  673. }
  674. group4.cmb_sectcd.index = 0;
  675. }
  676. }
  677. /****************************************************************************************
  678. * Components : Combo
  679. * Components ID : group4.cmb_excuroomgrp
  680. * Event : onitemchanged
  681. * Argument : 01.obj : Object Event has occurred
  682. * : 02.e : Event Object
  683. * Description : 구분 변경
  684. ****************************************************************************************/
  685. function group4_cmb_excuroomgrp_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  686. {
  687. ds_init_cmb_info2_initexecroom.clearData();
  688. ds_init_excuroomcdlist_excuroom.clearData();
  689. ds_send.setColumn(0,"excuroomgrpcdid", ds_send.getColumn(0,"srchexcuroomgrp") );
  690. dsf_createDsRow("ds_reqparam", [
  691. {col:"basesuppdeptcd", type:"STRING", size:256, val:gSuppdeptcd}
  692. , {col:"rbasecdflag", type:"STRING", size:256, val:"R"}
  693. , {col:"ebasecdflag", type:"STRING", size:256, val:"E"}
  694. , {col:"basecdcnts", type:"STRING", size:256, val:ds_send.getColumn(0,"excuroomgrpcdid")}
  695. ]);
  696. var oParam = {};
  697. oParam.id = "TRAEA01306";
  698. oParam.service = "examcureacptexecapp.ExamCureAcpt";
  699. oParam.method = "reqGetInitPhotoExamCureRoomCodeList";
  700. oParam.inds = "reqparam=ds_reqparam";
  701. oParam.outds = "ds_init_cmb_info2_initexecroom=initexcuroom";
  702. oParam.async = false;
  703. oParam.callback = "cf_TRAEA01306";
  704. tranf_submit(oParam);
  705. if(arErrorCode.pop("TRAEA01306") > -1){
  706. var cnt = ds_init_cmb_info2_initexecroom.rowcount;
  707. for(var i = 0; i < cnt; i++ ){
  708. var nRow = ds_init_excuroomcdlist_excuroom.addRow();
  709. ds_init_excuroomcdlist_excuroom.setColumn(nRow,"basecd" ,ds_init_cmb_info2_initexecroom.getColumn(i,"excuroomcdid"));
  710. ds_init_excuroomcdlist_excuroom.setColumn(nRow,"basecdflagdesc" ,ds_init_cmb_info2_initexecroom.getColumn(i,"excuroomcdnm"));
  711. }
  712. if(!utlf_isNull(ds_init_excuroomcdlist_excuroom.getColumn(0,"basecd"))) {
  713. frmf_addComboItem("group4.cmb_sectcd", "-- 전체 --", "", "above");
  714. }
  715. group4.cmb_sectcd.index = 0;
  716. }
  717. }
  718. function cf_TRAEA01306(sSvcId, nErrorCode, sErrorMsg) {
  719. arErrorCode.push(sSvcId, nErrorCode);
  720. ds_init_cmb_info2_initexecroom.updateColID("basecd","excuroomcdid");
  721. ds_init_cmb_info2_initexecroom.updateColID("basecdflagdesc","excuroomcdnm");
  722. }
  723. /****************************************************************************************
  724. * Components : Button
  725. * Components ID : group4.button3
  726. * Event : onclick
  727. * Argument : 01.obj : Object Event has occurred
  728. * : 02.e : Event Object
  729. * Description : 조회
  730. ****************************************************************************************/
  731. function group4_button3_onclick(obj:Button, e:ClickEventInfo)
  732. {
  733. var cTime = utlf_getCurrentTime().substr(0, 4);
  734. if(cTime > "1700" || cTime < "0830") {
  735. } else {
  736. var ddInterval = utlf_getDateInterval(group4.ipt_fromdd.value , group4.ipt_todd.value);
  737. if(ddInterval > 32){
  738. sysf_messageBox("업무시간[08:30 ~ 17:00]에는 31일까지만 조회", "I006");
  739. return;
  740. }
  741. }
  742. getDyeList();
  743. }
  744. /****************************************************************************************
  745. * Components : Button
  746. * Components ID : group2.btn_excsave
  747. * Event : onclick
  748. * Argument : 01.obj : Object Event has occurred
  749. * : 02.e : Event Object
  750. * Description : 엑셀저장
  751. ****************************************************************************************/
  752. function group2_btn_excsave_onclick(obj:Button, e:ClickEventInfo)
  753. {
  754. if( ds_main_dyestoclist_item.rowcount > 0 ){
  755. grdf_exportExcel(group2.grd_dyelist, "입출고현황리스트", "입출고현황리스트", false, "", "user", false);
  756. } else {
  757. sysf_messageBox("조회된 데이터가 ", "I004");
  758. }
  759. }
  760. /****************************************************************************************
  761. * Components : Button
  762. * Components ID : group2.button2
  763. * Event : onclick
  764. * Argument : 01.obj : Object Event has occurred
  765. * : 02.e : Event Object
  766. * Description : 출력
  767. ****************************************************************************************/
  768. function grp_btn_button2_onclick(obj:Button, e:ClickEventInfo)
  769. {
  770. dsf_copyColInfo(ds_rexprnt_dyestoclist_item,ds_main_dyestoclist_item);
  771. var cnt = ds_main_dyestoclist_item.rowcount;
  772. for( var i = 0; i < cnt; i++ ){
  773. var nRow = ds_rexprnt_dyestoclist_item.addRow();
  774. ds_rexprnt_dyestoclist_item.copyRow(nRow,ds_main_dyestoclist_item,i);
  775. ds_rexprnt_dyestoclist_item.setColumn(nRow,"goodcd",group2.grd_dyelist.getCellText(i,2));
  776. dsf_makeValue(ds_rexprnt_dyestoclist_item,"goodcdd","string",ds_main_dyestoclist_item.getColumn(i,"goodcd"),nRow);
  777. }
  778. ds_rexprnt_dyestoclist.setColumn(0,"srchiodd" , group4.ipt_fromdd.text + "-" + group4.ipt_todd.text );
  779. ds_rexprnt_dyestoclist.setColumn(0,"srchsectcd" , group4.cmb_sectcd.text );
  780. ds_rexprnt_dyestoclist.setColumn(0,"srchexcuroomgrp" , group4.cmb_excuroomgrp.text );
  781. ds_rexprnt_dyestoclist.setColumn(0,"srchsudept" , group4.cmb_sudpt.text );
  782. // exeReportPreview("RPAEB03401", "XMLSTR" , "" , "" , "false" , "", "", "", "", "false");
  783. var objDOM = rptf_createDOM(); // DOM 객체 설정
  784. var objParam = new Object();
  785. rptf_setNodeListToDOM(objDOM, "/root/rexprnt/dyestoclist/item" , ds_rexprnt_dyestoclist_item); // 데이터셋 1
  786. rptf_setNodeListToDOM(objDOM, "/root/rexprnt/dyestocinfo" , ds_rexprnt_dyestoclist); // 데이터셋 2
  787. objParam.xml_data_XML1 = objDOM.documentElement.source;
  788. //var option = "open=1;save=1;directprint=1;printdialog=0;print=1;zoom=0";
  789. var option = "open=1;save=1;directprint=0;print=1;zoom=0";
  790. rptf_exeReportPreview30(["RPAEB03401"],[objParam], option);
  791. ds_rexprnt_dyestoclist_item.clear();
  792. }
  793. ]]></Script>
  794. </Form>
  795. </FDL>