SMRST06900_월마감작업(약국).xfdl 81 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRST06900" position="absolute 0 0 1145 766" titletext="월출고 마감(약국)" oninit="SMRST06900_oninit" onload="SMRST06900_onload">
  5. <Layouts>
  6. <Layout>
  7. <Tab position="absolute 0 27 1135 764" id="switch1" onchanged="switch1_onchanged">
  8. <Tabpages>
  9. <Tabpage text="재고실사내역" id="case1">
  10. <Layouts>
  11. <Layout>
  12. <Grid position="absolute 0 93 1120 703" id="grd_phamlist" binddataset="ds_main_phaminfo_phamlist" autoenter="select" cellsizingtype="col">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="24"/>
  17. <Column size="0"/>
  18. <Column size="100"/>
  19. <Column size="60"/>
  20. <Column size="0"/>
  21. <Column size="0"/>
  22. <Column size="0"/>
  23. <Column size="170"/>
  24. <Column size="70"/>
  25. <Column size="0"/>
  26. <Column size="80"/>
  27. <Column size="80"/>
  28. <Column size="80"/>
  29. <Column size="80"/>
  30. <Column size="80"/>
  31. <Column size="80"/>
  32. <Column size="80"/>
  33. <Column size="80"/>
  34. <Column size="80"/>
  35. <Column size="80"/>
  36. </Columns>
  37. <Rows>
  38. <Row size="24" band="head"/>
  39. <Row size="24"/>
  40. </Rows>
  41. <Band id="head">
  42. <Cell/>
  43. <Cell col="1" text="대분류"/>
  44. <Cell col="2" text="약품코드"/>
  45. <Cell col="3" text="구입단가"/>
  46. <Cell col="4" text="비용계정비"/>
  47. <Cell col="5" text="구코드"/>
  48. <Cell col="6" text="복지부분류"/>
  49. <Cell col="7" text="약품명"/>
  50. <Cell col="8" text="총합"/>
  51. <Cell col="9" text="금액"/>
  52. <Cell col="10" text="부서코드1"/>
  53. <Cell col="11" text="부서코드2"/>
  54. <Cell col="12" text="부서코드3"/>
  55. <Cell col="13" text="부서코드4"/>
  56. <Cell col="14" text="부서코드5"/>
  57. <Cell col="15" text="부서코드6"/>
  58. <Cell col="16" text="부서코드7"/>
  59. <Cell col="17" text="부서코드8"/>
  60. <Cell col="18" text="부서코드9"/>
  61. <Cell col="19" text="부서코드10"/>
  62. </Band>
  63. <Band id="body">
  64. <Cell celltype="head" expr="currow + 1"/>
  65. <Cell col="1" text="bind:c1"/>
  66. <Cell col="2" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:c2" wordwrap="word" editautoselect="true"/>
  67. <Cell col="3" displaytype="text" edittype="text" text="bind:c3" maskchar=" " editautoselect="true"/>
  68. <Cell col="4" text="bind:c4" editautoselect="true"/>
  69. <Cell col="5" text="bind:c5" editautoselect="true"/>
  70. <Cell col="6" text="bind:c6" editautoselect="true"/>
  71. <Cell col="7" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:c7" wordwrap="word" editautoselect="true"/>
  72. <Cell col="8" displaytype="text" edittype="text" style="align:right;" text="bind:c8" editautoselect="true"/>
  73. <Cell col="9" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c9" mask="#,##0"/>
  74. <Cell col="10" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:c10" wordwrap="word" editautoselect="true"/>
  75. <Cell col="11" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c11" mask="#,##0" editautoselect="true"/>
  76. <Cell col="12" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c12" mask="#,##0" editautoselect="true"/>
  77. <Cell col="13" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c13" mask="#,##0" editautoselect="true"/>
  78. <Cell col="14" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c14" mask="#,##0" editautoselect="true"/>
  79. <Cell col="15" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c15" mask="#,##0" editautoselect="true"/>
  80. <Cell col="16" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c16" mask="#,##0" editautoselect="true"/>
  81. <Cell col="17" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c17" mask="#,##0" editautoselect="true"/>
  82. <Cell col="18" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c18" mask="#,##0" editautoselect="true"/>
  83. <Cell col="19" displaytype="number" edittype="masknumber" style="align:right;" text="bind:c19" mask="#,##0" editautoselect="true"/>
  84. </Band>
  85. </Format>
  86. </Formats>
  87. </Grid>
  88. <Grid position="absolute 15 550 490 675" id="datagrid1" visible="false" binddataset="ds_main_phamuseinfo_phamuselist">
  89. <Formats>
  90. <Format id="default">
  91. <Columns>
  92. <Column size="24"/>
  93. <Column size="57"/>
  94. <Column size="99"/>
  95. <Column size="89"/>
  96. <Column size="56"/>
  97. <Column size="74"/>
  98. <Column size="61"/>
  99. </Columns>
  100. <Rows>
  101. <Row size="24" band="head"/>
  102. <Row size="24"/>
  103. </Rows>
  104. <Band id="head">
  105. <Cell/>
  106. <Cell col="1" text="대분류명"/>
  107. <Cell col="2" text="약품코드"/>
  108. <Cell col="3" text="관리실코드"/>
  109. <Cell col="4" text="수량"/>
  110. <Cell col="5" text="구입단가"/>
  111. <Cell col="6" text="총합계"/>
  112. </Band>
  113. <Band id="body">
  114. <Cell celltype="head" expr="currow + 1"/>
  115. <Cell col="1" style="align:left top;padding:5 2 1 2;" text="bind:c1" wordwrap="word"/>
  116. <Cell col="2" style="align:left top;padding:5 2 1 2;" text="bind:c2" wordwrap="word"/>
  117. <Cell col="3" text="bind:stocdeptcd"/>
  118. <Cell col="4" displaytype="number" style="align:right middle;" text="bind:cnt"/>
  119. <Cell col="5" displaytype="number" style="align:right middle;" text="bind:c3"/>
  120. <Cell col="6" text="bind:c8"/>
  121. </Band>
  122. </Format>
  123. </Formats>
  124. </Grid>
  125. <Button position="absolute 1018 72 1116 91" id="btn_loadexcel" class="btn2" enable="false" text="데이터가져오기" onclick="switch1_case1_btn_loadexcel_onclick"/>
  126. <Div position="absolute 0 0 1120 70" align="align:center top;" id="group2">
  127. <Layouts>
  128. <Layout>
  129. <Shape position="absolute 0 0 1115 70" id="roundrect1" type="roundrectangle"/>
  130. <Static text="기관코드 :" position="absolute 5 16 94 33" id="cap_instcd" class="search_name"/>
  131. <Edit readonly="true" position="absolute 95 15 125 34" id="opt_instcd" class="output"/>
  132. <Edit readonly="true" position="absolute 128 15 330 34" id="opt_instcdnm" class="output"/>
  133. <Static text="작 업 자 :" position="absolute 5 40 93 57" id="caption2" class="search_name"/>
  134. <Edit readonly="true" position="absolute 95 40 170 59" id="opt_jobuser" class="output"/>
  135. <Edit readonly="true" position="absolute 178 40 330 59" id="opt_jobusernm" class="output"/>
  136. <Button position="absolute 1035 25 1091 47" id="btm_init" class="btn4" text="조회" onclick="switch1_case1_group2_btm_init_onclick"/>
  137. <Static text="작업년월" position="absolute 355 16 456 33" id="cap_fromdd" class="search_name"/>
  138. <Calendar position="absolute 455 15 552 34" align="align:center middle;" id="ipt_fromdd" class="input_essential" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  139. <Button position="absolute 975 25 1031 47" id="button2" class="btn3" text="저장" onclick="switch1_case1_group2_button2_onclick"/>
  140. <Shape position="absolute 962 10 968 63" linetype="vertical" id="line1" class="line_4"/>
  141. <Static text="부서코드찾기" position="absolute 565 16 667 33" id="caption3" class="search_name"/>
  142. <Edit position="absolute 675 15 772 34" align="align:center middle;" id="ipt_depthngnm" class="input_essential" onkeydown="switch1_case1_group2_ipt_depthngnm_onkeydown"/>
  143. <Button position="absolute 776 17 792 33" id="btn_deptsrch" class="icon_search" text="" onclick="switch1_case1_group2_btn_deptsrch_onclick"/>
  144. <Edit readonly="true" position="absolute 795 15 935 34" id="output1" visible="false"/>
  145. <Static text="부서갯수" position="absolute 355 40 456 57" id="caption4" class="search_name"/>
  146. <Edit position="absolute 455 40 552 59" align="align:center middle;" id="input2" class="input_essential"/>
  147. </Layout>
  148. </Layouts>
  149. </Div>
  150. <Grid position="absolute 75 260 655 399" id="grd_goodlist" visible="false" binddataset="ds_main_goodinfo_goodlist" oncelldblclick="switch1_case1_grd_goodlist_oncelldblclick">
  151. <Formats>
  152. <Format id="default">
  153. <Columns>
  154. <Column size="24"/>
  155. <Column size="102"/>
  156. <Column size="270"/>
  157. <Column size="100"/>
  158. <Column size="61"/>
  159. <Column size="0"/>
  160. <Column size="0"/>
  161. </Columns>
  162. <Rows>
  163. <Row size="24" band="head"/>
  164. <Row size="24"/>
  165. </Rows>
  166. <Band id="head">
  167. <Cell/>
  168. <Cell col="1" text="약품코드"/>
  169. <Cell col="2" text="약품명"/>
  170. <Cell col="3" text="구코드"/>
  171. <Cell col="4" text="단가"/>
  172. <Cell col="5" text="기관코드"/>
  173. <Cell col="6" text="물품구분"/>
  174. </Band>
  175. <Band id="body">
  176. <Cell celltype="head"/>
  177. <Cell col="1" displaytype="text" edittype="none" style="align:left top;padding:5 2 1 2;" text="bind:goodcd" wordwrap="word"/>
  178. <Cell col="2" displaytype="text" edittype="none" style="align:left top;padding:5 2 1 2;" text="bind:goodnm" wordwrap="word"/>
  179. <Cell col="3" text="bind:oldcd"/>
  180. <Cell col="4" displaytype="number" style="align:right middle;" text="bind:goodunitcost" mask="#,###" maskchar=" "/>
  181. <Cell col="5" text="bind:instcd"/>
  182. <Cell col="6" text="bind:goodflag"/>
  183. </Band>
  184. </Format>
  185. </Formats>
  186. </Grid>
  187. <Button position="absolute 860 72 913 91" id="button10" class="btn2" text="행추가" onclick="switch1_case1_button10_onclick"/>
  188. <Button position="absolute 915 72 1016 91" id="button11" class="btn2" text="실사량 가져오기" onclick="switch1_case1_button11_onclick"/>
  189. <Button position="absolute 805 72 858 91" id="btn_excel" class="btn5" text="Excel" onclick="switch1_case1_btn_excel_onclick"/>
  190. </Layout>
  191. </Layouts>
  192. </Tabpage>
  193. <Tabpage text="청구내역출고처리" id="case2">
  194. <Layouts>
  195. <Layout>
  196. <Div id="Div00" taborder="1" position="absolute 48 9 520 140" style="border:1 solid black ;"/>
  197. <Radio position="absolute 170 17 502 37" id="radio1" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1">
  198. <Dataset id="innerdataset">
  199. <ColumnInfo>
  200. <Column id="codecolumn"/>
  201. <Column id="datacolumn"/>
  202. </ColumnInfo>
  203. <Rows>
  204. <Row>
  205. <Col id="codecolumn">P</Col>
  206. <Col id="datacolumn">처방출고처리</Col>
  207. </Row>
  208. <Row>
  209. <Col id="codecolumn">H</Col>
  210. <Col id="datacolumn">수액처방출고처리</Col>
  211. </Row>
  212. <Row>
  213. <Col id="codecolumn">M</Col>
  214. <Col id="datacolumn">청구내역출고처리</Col>
  215. </Row>
  216. </Rows>
  217. </Dataset>
  218. </Radio>
  219. <Calendar position="absolute 282 62 377 81" id="ipt_stocym" class="input_default" mask="yyyy-mm" autoselect="true"/>
  220. <Static text="청구내역 출고" position="absolute 54 56 160 72" id="caption61" class="tit_2"/>
  221. <Button position="absolute 362 73 385 93" id="button39" text=""/>
  222. <Combo position="absolute 282 40 505 59" id="cmb_instcd" class="combo_essential" innerdataset="ds_init_instcd" datacolumn="cdnm" codecolumn="cdid"/>
  223. <Shape position="absolute 181 80 508 86" linetype="horizontal" id="line23" class="line_2"/>
  224. <Shape position="absolute 172 102 507 108" linetype="horizontal" id="line35" class="line_3"/>
  225. <Static text="작업자" position="absolute 172 84 280 103" align="align:center middle;" id="caption7" class="cell_1"/>
  226. <Static text="마감년월" position="absolute 172 62 280 81" align="align:center middle;" id="caption44" class="cell_1"/>
  227. <Shape position="absolute 181 58 508 64" linetype="horizontal" id="line2" class="line_2"/>
  228. <Button position="absolute 463 110 505 129" id="btn_gen" class="btn2" text="생성" onclick="switch1_case2_btn_gen_onclick"/>
  229. <Static text="기관코드" position="absolute 172 40 280 59" align="align:center middle;" id="caption9" class="cell_1"/>
  230. <Shape position="absolute 172 35 508 41" linetype="horizontal" id="line7" class="line_10"/>
  231. <Edit position="absolute 282 84 361 103" id="ipt_userid" class="input_default" autoselect="true"/>
  232. <Edit position="absolute 365 84 505 103" id="ipt_usernm" class="input_default" autoselect="true"/>
  233. </Layout>
  234. </Layouts>
  235. </Tabpage>
  236. <Tabpage text="마감처리" id="case3">
  237. <Layouts>
  238. <Layout>
  239. <Div id="Div00" taborder="1" position="absolute 50 15 385 155" style="border:1 solid black ;"/>
  240. <Calendar position="absolute 162 84 252 103" id="ipt_cond3stocym" class="input_default" mask="yyyy-mm" autoselect="true"/>
  241. <Static text="마감처리" position="absolute 53 19 153 36" id="caption1" class="tit_2"/>
  242. <Combo position="absolute 162 40 375 59" id="cmb_cond3instcd" class="combo_essential" innerdataset="ds_init_instcd" datacolumn="cdnm" codecolumn="cdid"/>
  243. <Shape position="absolute 51 102 378 108" linetype="horizontal" id="line3" class="line_2"/>
  244. <Shape position="absolute 51 124 378 130" linetype="horizontal" id="line4" class="line_3"/>
  245. <Static text="작업년월" position="absolute 52 84 160 103" align="align:center middle;" id="caption5" class="cell_1"/>
  246. <Button position="absolute 334 131 376 150" id="button7" class="btn2" text="생성" onclick="switch1_case3_button7_onclick"/>
  247. <Shape position="absolute 51 80 378 86" linetype="horizontal" id="line5" class="line_2"/>
  248. <Edit position="absolute 162 106 241 125" id="ipt_cond3userid" class="input_default" autoselect="true"/>
  249. <Static text="작업자" position="absolute 52 106 160 125" align="align:center middle;" id="caption8" class="cell_1"/>
  250. <Static text="기관코드" position="absolute 52 40 160 59" align="align:center middle;" id="caption10" class="cell_1"/>
  251. <Edit position="absolute 245 106 375 125" id="ipt_cond3usernm" class="input_default" autoselect="true"/>
  252. <Shape position="absolute 51 35 378 41" linetype="horizontal" id="line6" class="line_10"/>
  253. <Static text="물품구분" position="absolute 52 62 160 81" align="align:center middle;" id="caption11" class="cell_1"/>
  254. <Shape position="absolute 51 58 378 64" linetype="horizontal" id="line9" class="line_2"/>
  255. <Combo position="absolute 162 62 262 81" id="cmb_cond3goodflag" innerdataset="ds_init_goodflag" datacolumn="cdnm" codecolumn="cdid"/>
  256. </Layout>
  257. </Layouts>
  258. </Tabpage>
  259. <Tabpage text="사용분 전표처리" id="case4">
  260. <Layouts>
  261. <Layout>
  262. <Shape position="absolute 60 25 395 165" id="rectangle2" style="border:1 solid black ;"/>
  263. <Edit position="absolute 172 94 251 113" id="ipt_cond4userid" class="input_default" autoselect="true"/>
  264. <Shape position="absolute 61 68 388 74" linetype="horizontal" id="line8" class="line_2"/>
  265. <Edit position="absolute 255 94 385 113" id="ipt_cond4usernm" class="input_default" autoselect="true"/>
  266. <Calendar position="absolute 172 72 262 91" id="input9" class="input_default" mask="yyyy-mm" autoselect="true"/>
  267. <Shape position="absolute 61 112 388 118" linetype="horizontal" id="line10" class="line_2"/>
  268. <Shape position="absolute 61 134 388 140" linetype="horizontal" id="line11" class="line_3"/>
  269. <Shape position="absolute 61 90 383 96" linetype="horizontal" id="line12" class="line_2"/>
  270. <Shape position="absolute 61 45 388 51" linetype="horizontal" id="line13" class="line_10"/>
  271. <Button position="absolute 343 139 385 158" id="button6" class="btn2" text="생성" onclick="switch1_case4_button6_onclick"/>
  272. <Static text="기관" position="absolute 62 50 170 69" align="align:center middle;" id="caption12" class="cell_1"/>
  273. <Static text="출고전표처리" position="absolute 63 29 165 46" id="caption13" class="tit_2"/>
  274. <Static text="작업년월" position="absolute 62 72 170 91" align="align:center middle;" id="caption14" class="cell_1"/>
  275. <Static text="작업부서" position="absolute 62 116 170 135" align="align:center middle;" id="caption15" class="cell_1"/>
  276. <Static text="작업자" position="absolute 62 94 170 113" align="align:center middle;" id="caption16" class="cell_1"/>
  277. <Edit position="absolute 172 116 251 135" id="ipt_deptcd" class="input_default" autoselect="true"/>
  278. <Edit position="absolute 255 116 385 135" id="ipt_deptnm" class="input_default" autoselect="true"/>
  279. </Layout>
  280. </Layouts>
  281. </Tabpage>
  282. <Tabpage text="처리결과" id="case5">
  283. <Layouts>
  284. <Layout>
  285. <Grid position="absolute 0 62 1090 697" id="datagrid3" binddataset="ds_main_outendrsltinfo_outendrsltlist">
  286. <Formats>
  287. <Format id="default">
  288. <Columns>
  289. <Column size="24"/>
  290. <Column size="57"/>
  291. <Column size="0"/>
  292. <Column size="64"/>
  293. <Column size="94"/>
  294. <Column size="0"/>
  295. <Column size="0"/>
  296. <Column size="0"/>
  297. <Column size="82"/>
  298. <Column size="113"/>
  299. <Column size="112"/>
  300. <Column size="113"/>
  301. <Column size="98"/>
  302. <Column size="127"/>
  303. <Column size="91"/>
  304. <Column size="118"/>
  305. </Columns>
  306. <Rows>
  307. <Row size="24" band="head"/>
  308. <Row size="24" band="head"/>
  309. <Row size="24"/>
  310. <Row size="24" band="summ"/>
  311. </Rows>
  312. <Band id="head">
  313. <Cell rowspan="2" taborder="undefined"/>
  314. <Cell col="1" rowspan="2" text="작업년월" taborder="undefined"/>
  315. <Cell col="2" text="대분류&#10;코드"/>
  316. <Cell col="3" rowspan="2" text="대분류명" taborder="undefined"/>
  317. <Cell col="4" rowspan="2" text="비용계정명" taborder="undefined"/>
  318. <Cell col="5" text="비용계정코드"/>
  319. <Cell col="6" text="dcntnm"/>
  320. <Cell col="7" text="dcntcd"/>
  321. <Cell col="8" rowspan="2" text=" 이월수량" taborder="undefined"/>
  322. <Cell col="9" rowspan="2" text=" 전월이월&#10;금액" taborder="undefined"/>
  323. <Cell col="10" rowspan="2" text=" 입고수량" taborder="undefined"/>
  324. <Cell col="11" rowspan="2" text=" 입고금액" taborder="undefined"/>
  325. <Cell col="12" rowspan="2" text="출고수량" taborder="undefined"/>
  326. <Cell col="13" rowspan="2" text=" 출고금액" taborder="undefined"/>
  327. <Cell col="14" rowspan="2" text=" 재고수량" taborder="undefined"/>
  328. <Cell col="15" rowspan="2" text="재고금액" taborder="undefined"/>
  329. <Cell row="1" col="2" text="대분류&#10;코드"/>
  330. <Cell row="1" col="5" text="비용계정코드"/>
  331. <Cell row="1" col="6" text="dcntnm"/>
  332. <Cell row="1" col="7" text="dcntcd"/>
  333. </Band>
  334. <Band id="body">
  335. <Cell celltype="head" expr="currow + 1"/>
  336. <Cell col="1" displaytype="text" text="bind:stocym" mask="####-##" maskchar=" "/>
  337. <Cell col="2" text="bind:goodlrgcd"/>
  338. <Cell col="3" style="align:left;" text="bind:goodlrgnm"/>
  339. <Cell col="4" style="align:left;" text="bind:acntnm"/>
  340. <Cell col="5" text="bind:acntcd"/>
  341. <Cell col="6" text="bind:dcntnm"/>
  342. <Cell col="7" text="bind:dcntcd"/>
  343. <Cell col="8" displaytype="number" style="align:right middle;" text="bind:beftotqty00" mask="#,###.#"/>
  344. <Cell col="9" displaytype="number" style="align:right middle;" text="bind:appunitcost00" mask="#,###.#"/>
  345. <Cell col="10" displaytype="number" style="align:right middle;" text="bind:winqty01" mask="#,###.#"/>
  346. <Cell col="11" displaytype="number" style="align:right middle;" text="bind:winamt" mask="#,###.#"/>
  347. <Cell col="12" displaytype="number" style="align:right middle;" text="bind:outcnts" mask="#,###.#"/>
  348. <Cell col="13" displaytype="number" style="align:right middle;" text="bind:totuseamt" mask="#,###.#"/>
  349. <Cell col="14" displaytype="number" style="align:right middle;" text="bind:stoccnts" mask="#,###.#"/>
  350. <Cell col="15" displaytype="number" style="align:right middle;" text="bind:stocamt" mask="#,###.#"/>
  351. </Band>
  352. <Band id="summary">
  353. <Cell/>
  354. <Cell col="1" text="합계"/>
  355. <Cell col="2"/>
  356. <Cell col="3"/>
  357. <Cell col="4"/>
  358. <Cell col="5"/>
  359. <Cell col="6"/>
  360. <Cell col="7"/>
  361. <Cell col="8" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;beftotqty00&quot;)"/>
  362. <Cell col="9" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;appunitcost00&quot;)"/>
  363. <Cell col="10" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;winqty01&quot;)"/>
  364. <Cell col="11" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;winamt&quot;)"/>
  365. <Cell col="12" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;outcnts&quot;)"/>
  366. <Cell col="13" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;totuseamt&quot;)"/>
  367. <Cell col="14" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;stoccnts&quot;)"/>
  368. <Cell col="15" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;stocamt&quot;)"/>
  369. </Band>
  370. </Format>
  371. </Formats>
  372. </Grid>
  373. <Static text="출고마감 처리 결과" position="absolute 0 44 140 62" id="caption18" class="tit_2"/>
  374. <Button position="absolute 1033 41 1085 60" id="button4" class="btn7" text="엑셀" onclick="switch1_case5_button4_onclick"/>
  375. <Div position="absolute 0 0 1090 40" align="align:center top;" id="group3">
  376. <Layouts>
  377. <Layout>
  378. <Shape position="absolute -10 0 1085 40" id="roundrect2" type="roundrectangle"/>
  379. <Static text="기관코드 :" position="absolute 5 11 94 28" id="caption17" class="search_name"/>
  380. <Edit readonly="true" position="absolute 95 10 125 29" id="output2"/>
  381. <Edit readonly="true" position="absolute 128 10 330 29" id="output3"/>
  382. <Button position="absolute 970 9 1026 31" id="button9" class="btn4" text="조회" onclick="switch1_case5_group3_button9_onclick"/>
  383. <Static text="작업년월" position="absolute 355 11 456 28" id="caption19" class="search_name"/>
  384. <Calendar position="absolute 455 10 552 29" align="align:center middle;" id="input1" class="input_essential" mask="yyyy-mm"/>
  385. <Shape position="absolute 882 5 888 38" linetype="vertical" id="line14" class="line_4"/>
  386. <Radio position="absolute 630 9 805 29" id="rdo_srchflag" columncount="-1" codecolumn="codecolumn" datacolumn="datacolumn" rowcount="-1" onitemchanged="switch1_case5_group3_rdo_srchflag_onitemchanged">
  387. <Dataset id="innerdataset">
  388. <ColumnInfo>
  389. <Column id="codecolumn"/>
  390. <Column id="datacolumn"/>
  391. </ColumnInfo>
  392. <Rows>
  393. <Row>
  394. <Col id="codecolumn">1</Col>
  395. <Col id="datacolumn">대분류별</Col>
  396. </Row>
  397. <Row>
  398. <Col id="codecolumn">2</Col>
  399. <Col id="datacolumn">비용계정별</Col>
  400. </Row>
  401. </Rows>
  402. </Dataset>
  403. </Radio>
  404. <Static text="구분 :" position="absolute 570 11 630 28" id="caption20" class="search_name"/>
  405. <Static text="구분 :" position="absolute 570 11 630 28" id="caption21" class="search_name"/>
  406. <Calendar position="absolute 455 10 552 29" align="align:center middle;" id="input3" class="input_essential" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  407. <Static text="기관코드 :" position="absolute 5 11 94 28" id="caption22" class="search_name"/>
  408. <Static text="작업년월" position="absolute 355 11 456 28" id="caption23" class="search_name"/>
  409. <Edit readonly="true" position="absolute 95 10 125 29" id="output4" class="output"/>
  410. <Edit readonly="true" position="absolute 128 10 330 29" id="output5" class="output"/>
  411. </Layout>
  412. </Layouts>
  413. </Div>
  414. <Combo id="cmb_cond4instcd" taborder="1" innerdataset="ds_init_instcd" codecolumn="cdid" datacolumn="cdnm" class="combo_essential" position="absolute 172 42 385 61" visible="false"/>
  415. </Layout>
  416. </Layouts>
  417. </Tabpage>
  418. <Tabpage text="회계자료조회" id="case6">
  419. <Layouts>
  420. <Layout>
  421. <Div position="absolute 0 0 1090 40" align="align:center top;" id="group4">
  422. <Layouts>
  423. <Layout>
  424. <Shape position="absolute -10 0 1085 40" id="roundrect3" type="roundrectangle"/>
  425. <Static text="기관코드 :" position="absolute 5 11 94 28" id="caption24" class="search_name"/>
  426. <Edit readonly="true" position="absolute 95 10 125 29" id="output6"/>
  427. <Edit readonly="true" position="absolute 128 10 330 29" id="output7"/>
  428. <Button position="absolute 970 10 1026 32" id="button13" class="btn4" text="조회" onclick="switch1_case6_group4_button13_onclick"/>
  429. <Static text="작업년월" position="absolute 355 11 456 28" id="caption25" class="search_name"/>
  430. <Calendar position="absolute 455 10 552 29" align="align:center middle;" id="input4" class="input_essential" mask="yyyy-mm"/>
  431. <Shape position="absolute 882 5 888 38" linetype="vertical" id="line15" class="line_4"/>
  432. <Calendar position="absolute 455 10 552 29" align="align:center middle;" id="input5" class="input_essential" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  433. <Static text="기관코드 :" position="absolute 5 11 94 28" id="caption28" class="search_name"/>
  434. <Static text="작업년월" position="absolute 355 11 456 28" id="caption29" class="search_name"/>
  435. <Edit readonly="true" position="absolute 95 10 125 29" id="output8" class="output"/>
  436. <Edit readonly="true" position="absolute 128 10 330 29" id="output9" class="output"/>
  437. <Static text="~" position="absolute 560 12 572 29" id="caption27" class="search_n_b"/>
  438. <Calendar position="absolute 581 11 678 30" align="align:center middle;" id="input6" class="input_essential" mask="yyyy-mm" autoselect="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
  439. </Layout>
  440. </Layouts>
  441. </Div>
  442. <Grid position="absolute 0 62 1090 697" id="datagrid4" binddataset="ds_main_drugacctinfo_drugacctlist">
  443. <Formats>
  444. <Format id="default">
  445. <Columns>
  446. <Column size="24"/>
  447. <Column size="178"/>
  448. <Column size="94"/>
  449. <Column size="0"/>
  450. <Column size="0"/>
  451. <Column size="0"/>
  452. <Column size="100"/>
  453. <Column size="140"/>
  454. <Column size="112"/>
  455. <Column size="142"/>
  456. <Column size="111"/>
  457. <Column size="146"/>
  458. </Columns>
  459. <Rows>
  460. <Row size="24" band="head"/>
  461. <Row size="24" band="head"/>
  462. <Row size="24"/>
  463. <Row size="24" band="summ"/>
  464. </Rows>
  465. <Band id="head">
  466. <Cell rowspan="2" taborder="undefined"/>
  467. <Cell col="1" rowspan="2" text="작업년월" taborder="undefined"/>
  468. <Cell col="2" rowspan="2" text="비용계정명" taborder="undefined"/>
  469. <Cell col="3" text="비용계정코드"/>
  470. <Cell col="4" text="dcntnm"/>
  471. <Cell col="5" text="dcntcd"/>
  472. <Cell col="6" rowspan="2" text="이월수량" taborder="undefined"/>
  473. <Cell col="7" rowspan="2" text="전월이월금액" taborder="undefined"/>
  474. <Cell col="8" rowspan="2" text=" 입고수량" taborder="undefined"/>
  475. <Cell col="9" rowspan="2" text=" 입고금액" taborder="undefined"/>
  476. <Cell col="10" rowspan="2" text=" 재고수량" taborder="undefined"/>
  477. <Cell col="11" rowspan="2" text="재고금액" taborder="undefined"/>
  478. <Cell row="1" col="3" text="비용계정코드"/>
  479. <Cell row="1" col="4" text="dcntnm"/>
  480. <Cell row="1" col="5" text="dcntcd"/>
  481. </Band>
  482. <Band id="body">
  483. <Cell celltype="head" expr="currow + 1"/>
  484. <Cell col="1" text="bind:stocym"/>
  485. <Cell col="2" style="align:left;" text="bind:acntnm"/>
  486. <Cell col="3" text="bind:acntcd"/>
  487. <Cell col="4" text="bind:dcntnm"/>
  488. <Cell col="5" text="bind:dcntcd"/>
  489. <Cell col="6" displaytype="number" style="align:right middle;" text="bind:beftotqty00" mask="#,###"/>
  490. <Cell col="7" displaytype="number" style="align:right middle;" text="bind:appunitcost00" mask="#,###"/>
  491. <Cell col="8" displaytype="number" style="align:right middle;" text="bind:winqty01" mask="#,###"/>
  492. <Cell col="9" displaytype="number" style="align:right middle;" text="bind:winamt" mask="#,###"/>
  493. <Cell col="10" displaytype="number" style="align:right middle;" text="bind:stoccnts" mask="#,###"/>
  494. <Cell col="11" displaytype="number" style="align:right middle;" text="bind:stocamt" mask="#,###"/>
  495. </Band>
  496. <Band id="summary">
  497. <Cell/>
  498. <Cell col="1" text="합계"/>
  499. <Cell col="2"/>
  500. <Cell col="3"/>
  501. <Cell col="4"/>
  502. <Cell col="5"/>
  503. <Cell col="6" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;beftotqty00&quot;)"/>
  504. <Cell col="7" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;appunitcost00&quot;)"/>
  505. <Cell col="8" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;winqty01&quot;)"/>
  506. <Cell col="9" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;winamt&quot;)"/>
  507. <Cell col="10" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;stoccnts&quot;)"/>
  508. <Cell col="11" displaytype="number" style="align:right middle;" text="expr:getSum(&quot;stocamt&quot;)"/>
  509. </Band>
  510. </Format>
  511. </Formats>
  512. </Grid>
  513. <Button position="absolute 1032 41 1084 60" id="button14" class="btn7" text="엑셀" onclick="switch1_case6_button14_onclick"/>
  514. <Static text="약품 회계자료조회" position="absolute 0 44 145 61" id="caption26" class="tit_2"/>
  515. </Layout>
  516. </Layouts>
  517. </Tabpage>
  518. </Tabpages>
  519. </Tab>
  520. <Div position="absolute 650 118 913 303" id="group1" visible="false" style="background:snow;">
  521. <Layouts>
  522. <Layout>
  523. <Grid position="absolute 5 25 260 185" id="datagrid2" binddataset="ds_init_orddept_deptlist" anchor="default" autoenter="select" oncelldblclick="group1_datagrid2_oncelldblclick">
  524. <Formats>
  525. <Format id="default">
  526. <Columns>
  527. <Column size="100"/>
  528. <Column size="82"/>
  529. <Column size="55"/>
  530. </Columns>
  531. <Rows>
  532. <Row size="24" band="head"/>
  533. <Row size="24"/>
  534. </Rows>
  535. <Band id="head">
  536. <Cell text="부서명"/>
  537. <Cell col="1" text="부서코드명"/>
  538. <Cell col="2" text="영문약어"/>
  539. </Band>
  540. <Band id="body">
  541. <Cell style="align:left top;padding:5 2 1 2;" text="bind:depthngnm" wordwrap="word"/>
  542. <Cell col="1" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:deptcd" wordwrap="word"/>
  543. <Cell col="2" style="align:left top;padding:5 2 1 2;" text="bind:deptengabbr" wordwrap="word"/>
  544. </Band>
  545. </Format>
  546. </Formats>
  547. </Grid>
  548. <Button position="absolute 185 4 238 23" id="button5" class="btn2" text="숨기기" anchor="default" onclick="group1_button5_onclick"/>
  549. </Layout>
  550. </Layouts>
  551. </Div>
  552. <Static id="caption6" text="출고마감처리" class="tit_1" position="absolute 0 0 105 25"/>
  553. <Div id="Div00" taborder="1" text=" " position="absolute 87 27 200 49"/>
  554. </Layout>
  555. </Layouts>
  556. <Objects>
  557. <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  558. <ColumnInfo>
  559. <Column id="deptcnts" type="STRING" size="256"/>
  560. <Column id="instcd" type="STRING" size="256"/>
  561. <Column id="userid" type="STRING" size="256"/>
  562. <Column id="stocym" type="STRING" size="256"/>
  563. <Column id="depthngnm" type="STRING" size="256"/>
  564. <Column id="totcnts" type="STRING" size="256"/>
  565. <Column id="instnm" type="STRING" size="256"/>
  566. <Column id="usernm" type="STRING" size="256"/>
  567. </ColumnInfo>
  568. <Rows>
  569. <Row>
  570. <Col id="deptcnts"/>
  571. <Col id="instcd"/>
  572. <Col id="userid"/>
  573. <Col id="stocym"/>
  574. <Col id="depthngnm"/>
  575. <Col id="totcnts"/>
  576. <Col id="instnm"/>
  577. <Col id="usernm"/>
  578. </Row>
  579. </Rows>
  580. </Dataset>
  581. <Dataset id="ds_main_phaminfo_phamlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_phaminfo_phamlist_oncolumnchanged"/>
  582. <Dataset id="ds_main_phamuseinfo_phamuselist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  583. <ColumnInfo>
  584. <Column id="dummy" type="STRING" size="256"/>
  585. <Column id="phamuselist" type="STRING" size="256"/>
  586. </ColumnInfo>
  587. <Rows>
  588. <Row>
  589. <Col id="dummy"/>
  590. <Col id="phamuselist"/>
  591. </Row>
  592. </Rows>
  593. </Dataset>
  594. <Dataset id="ds_main_toggle2_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  595. <ColumnInfo>
  596. <Column id="instcd" type="STRING" size="256"/>
  597. <Column id="stocym" type="STRING" size="256"/>
  598. <Column id="userid" type="STRING" size="256"/>
  599. <Column id="usernm" type="STRING" size="256"/>
  600. <Column id="stocflag" type="STRING" size="256"/>
  601. <Column id="stocdd" type="STRING" size="256"/>
  602. </ColumnInfo>
  603. <Rows>
  604. <Row>
  605. <Col id="instcd"/>
  606. <Col id="stocym"/>
  607. <Col id="userid"/>
  608. <Col id="usernm"/>
  609. <Col id="stocflag"/>
  610. <Col id="stocdd"/>
  611. </Row>
  612. </Rows>
  613. </Dataset>
  614. <Dataset id="ds_main_toggle3_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  615. <ColumnInfo>
  616. <Column id="instcd" type="STRING" size="256"/>
  617. <Column id="goodflag" type="STRING" size="256"/>
  618. <Column id="stocym" type="STRING" size="256"/>
  619. <Column id="userid" type="STRING" size="256"/>
  620. <Column id="usernm" type="STRING" size="256"/>
  621. </ColumnInfo>
  622. <Rows>
  623. <Row>
  624. <Col id="instcd"/>
  625. <Col id="goodflag"/>
  626. <Col id="stocym"/>
  627. <Col id="userid"/>
  628. <Col id="usernm"/>
  629. </Row>
  630. </Rows>
  631. </Dataset>
  632. <Dataset id="ds_main_toggle4_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  633. <ColumnInfo>
  634. <Column id="instcd" type="STRING" size="256"/>
  635. <Column id="stocym" type="STRING" size="256"/>
  636. <Column id="userid" type="STRING" size="256"/>
  637. <Column id="usernm" type="STRING" size="256"/>
  638. <Column id="stocdeptcd" type="STRING" size="256"/>
  639. <Column id="stocdeptnm" type="STRING" size="256"/>
  640. </ColumnInfo>
  641. <Rows>
  642. <Row>
  643. <Col id="instcd"/>
  644. <Col id="stocym"/>
  645. <Col id="userid"/>
  646. <Col id="usernm"/>
  647. <Col id="stocdeptcd"/>
  648. <Col id="stocdeptnm"/>
  649. </Row>
  650. </Rows>
  651. </Dataset>
  652. <Dataset id="ds_main_toggle5_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  653. <ColumnInfo>
  654. <Column id="instcd" type="STRING" size="256"/>
  655. <Column id="stocym" type="STRING" size="256"/>
  656. <Column id="instnm" type="STRING" size="256"/>
  657. <Column id="srchflag" type="STRING" size="256"/>
  658. </ColumnInfo>
  659. <Rows>
  660. <Row>
  661. <Col id="instcd"/>
  662. <Col id="stocym"/>
  663. <Col id="instnm"/>
  664. <Col id="srchflag">1</Col>
  665. </Row>
  666. </Rows>
  667. </Dataset>
  668. <Dataset id="ds_main_toggle6_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  669. <ColumnInfo>
  670. <Column id="instcd" type="STRING" size="256"/>
  671. <Column id="fromstocym" type="STRING" size="256"/>
  672. <Column id="instnm" type="STRING" size="256"/>
  673. <Column id="tostocym" type="STRING" size="256"/>
  674. </ColumnInfo>
  675. <Rows>
  676. <Row>
  677. <Col id="instcd"/>
  678. <Col id="fromstocym"/>
  679. <Col id="instnm"/>
  680. <Col id="tostocym"/>
  681. </Row>
  682. </Rows>
  683. </Dataset>
  684. <Dataset id="ds_main_outendrsltinfo_outendrsltlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  685. <Dataset id="ds_main_drugacctinfo_drugacctlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  686. <Dataset id="ds_main_goodinfo_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  687. <Dataset id="ds_main_good_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  688. <ColumnInfo>
  689. <Column id="goodcd" type="STRING" size="256"/>
  690. <Column id="goodnm" type="STRING" size="256"/>
  691. <Column id="flag" type="STRING" size="256"/>
  692. <Column id="instcd" type="STRING" size="256"/>
  693. <Column id="stocym" type="STRING" size="256"/>
  694. </ColumnInfo>
  695. <Rows>
  696. <Row>
  697. <Col id="goodcd"/>
  698. <Col id="goodnm"/>
  699. <Col id="flag"/>
  700. <Col id="instcd"/>
  701. <Col id="stocym"/>
  702. </Row>
  703. </Rows>
  704. </Dataset>
  705. <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  706. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  707. <ColumnInfo>
  708. <Column id="orddept" type="STRING" size="256"/>
  709. <Column id="goodflag" type="STRING" size="256"/>
  710. </ColumnInfo>
  711. <Rows>
  712. <Row>
  713. <Col id="orddept"/>
  714. <Col id="goodflag"/>
  715. </Row>
  716. </Rows>
  717. </Dataset>
  718. <Dataset id="ds_tmp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  719. <ColumnInfo>
  720. <Column id="cnts" type="STRING" size="256"/>
  721. </ColumnInfo>
  722. <Rows>
  723. <Row>
  724. <Col id="cnts"/>
  725. </Row>
  726. </Rows>
  727. </Dataset>
  728. <Dataset id="ds_init_orddept_deptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  729. <Dataset id="ds_main_phaminfo_deptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  730. <ColumnInfo>
  731. <Column id="lrgnm" type="STRING" size="256"/>
  732. <Column id="goodcd" type="STRING" size="256"/>
  733. <Column id="unitcost" type="STRING" size="256"/>
  734. <Column id="totstocqty" type="STRING" size="256"/>
  735. <Column id="oristocqty" type="STRING" size="256"/>
  736. <Column id="instcd" type="STRING" size="256"/>
  737. <Column id="userid" type="STRING" size="256"/>
  738. <Column id="stocym" type="STRING" size="256"/>
  739. </ColumnInfo>
  740. <Rows>
  741. <Row>
  742. <Col id="lrgnm"/>
  743. <Col id="goodcd"/>
  744. <Col id="unitcost"/>
  745. <Col id="totstocqty"/>
  746. <Col id="oristocqty"/>
  747. <Col id="instcd"/>
  748. <Col id="userid"/>
  749. <Col id="stocym"/>
  750. </Row>
  751. </Rows>
  752. </Dataset>
  753. </Objects>
  754. <Bind>
  755. <BindItem id="item0" compid="switch1.case1.group2.opt_instcd" propid="value" datasetid="ds_main_cond" columnid="instcd"/>
  756. <BindItem id="item1" compid="switch1.case1.group2.opt_instcdnm" propid="value" datasetid="ds_main_cond" columnid="instnm"/>
  757. <BindItem id="item2" compid="switch1.case1.group2.ipt_fromdd" propid="value" datasetid="ds_main_cond" columnid="stocym"/>
  758. <BindItem id="item3" compid="switch1.case1.group2.ipt_depthngnm" propid="value" datasetid="ds_main_cond" columnid="depthngnm"/>
  759. <BindItem id="item4" compid="switch1.case1.group2.opt_jobuser" propid="value" datasetid="ds_main_cond" columnid="userid"/>
  760. <BindItem id="item5" compid="switch1.case1.group2.opt_jobusernm" propid="value" datasetid="ds_main_cond" columnid="usernm"/>
  761. <BindItem id="item6" compid="switch1.case1.group2.input2" propid="value" datasetid="ds_main_cond" columnid="deptcnts"/>
  762. <BindItem id="item7" compid="switch1.case2.radio1" propid="value" datasetid="ds_main_toggle2_cond" columnid="stocflag"/>
  763. <BindItem id="item8" compid="switch1.case2.cmb_instcd" propid="value" datasetid="ds_main_toggle2_cond" columnid="instcd"/>
  764. <BindItem id="item9" compid="switch1.case2.ipt_stocym" propid="value" datasetid="ds_main_toggle2_cond" columnid="stocym"/>
  765. <BindItem id="item10" compid="switch1.case2.ipt_userid" propid="value" datasetid="ds_main_toggle2_cond" columnid="userid"/>
  766. <BindItem id="item11" compid="switch1.case2.ipt_usernm" propid="value" datasetid="ds_main_toggle2_cond" columnid="usernm"/>
  767. <BindItem id="item12" compid="switch1.case3.cmb_cond3instcd" propid="value" datasetid="ds_main_toggle3_cond" columnid="instcd"/>
  768. <BindItem id="item13" compid="switch1.case3.cmb_cond3goodflag" propid="value" datasetid="ds_main_toggle3_cond" columnid="goodflag"/>
  769. <BindItem id="item14" compid="switch1.case3.ipt_cond3stocym" propid="value" datasetid="ds_main_toggle3_cond" columnid="stocym"/>
  770. <BindItem id="item15" compid="switch1.case3.ipt_cond3userid" propid="value" datasetid="ds_main_toggle3_cond" columnid="userid"/>
  771. <BindItem id="item16" compid="switch1.case3.ipt_cond3usernm" propid="value" datasetid="ds_main_toggle3_cond" columnid="usernm"/>
  772. <BindItem id="item18" compid="switch1.case4.input9" propid="value" datasetid="ds_main_toggle4_cond" columnid="stocym"/>
  773. <BindItem id="item19" compid="switch1.case4.ipt_cond4userid" propid="value" datasetid="ds_main_toggle4_cond" columnid="userid"/>
  774. <BindItem id="item20" compid="switch1.case4.ipt_cond4usernm" propid="value" datasetid="ds_main_toggle4_cond" columnid="usernm"/>
  775. <BindItem id="item21" compid="switch1.case4.ipt_deptcd" propid="value" datasetid="ds_main_toggle4_cond" columnid="stocdeptcd"/>
  776. <BindItem id="item22" compid="switch1.case4.ipt_deptnm" propid="value" datasetid="ds_main_toggle4_cond" columnid="stocdeptnm"/>
  777. <BindItem id="item23" compid="switch1.case5.group3.output4" propid="value" datasetid="ds_main_toggle5_cond" columnid="instcd"/>
  778. <BindItem id="item24" compid="switch1.case5.group3.output5" propid="value" datasetid="ds_main_toggle5_cond" columnid="instnm"/>
  779. <BindItem id="item25" compid="switch1.case5.group3.input3" propid="value" datasetid="ds_main_toggle5_cond" columnid="stocym"/>
  780. <BindItem id="item26" compid="switch1.case5.group3.rdo_srchflag" propid="value" datasetid="ds_main_toggle5_cond" columnid="srchflag"/>
  781. <BindItem id="item27" compid="switch1.case6.group4.output8" propid="value" datasetid="ds_main_toggle6_cond" columnid="instcd"/>
  782. <BindItem id="item28" compid="switch1.case6.group4.output9" propid="value" datasetid="ds_main_toggle6_cond" columnid="instnm"/>
  783. <BindItem id="item29" compid="switch1.case6.group4.input5" propid="value" datasetid="ds_main_toggle6_cond" columnid="fromstocym"/>
  784. <BindItem id="item30" compid="switch1.case6.group4.input6" propid="value" datasetid="ds_main_toggle6_cond" columnid="tostocym"/>
  785. <BindItem id="item17" compid="switch1.case5.cmb_cond4instcd" propid="value" datasetid="ds_main_toggle4_cond" columnid="instcd"/>
  786. </Bind>
  787. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  788. * System Name :
  789. * Job Name :
  790. * Creator :
  791. * Make Date : 2017-06-19
  792. * Description :
  793. *---------------------------------------------------------------------------------------
  794. * Modify Date Modifier Modify Description
  795. *---------------------------------------------------------------------------------------
  796. * 2017-06-19 Live Converter TF->XP
  797. *
  798. *---------------------------------------------------------------------------------------
  799. ****************************************************************************************/
  800. include "com_commonxp::comm_main.xjs";
  801. include "mis_miscommonxp::MIS.xjs";
  802. include "mis_miscommonxp::PIC002.xjs";
  803. include "mis_miscommonxp::RAC001.xjs";
  804. include "mis_miscommonxp::RBC001.xjs";
  805. include "mis_miscommonxp::RSZ001.xjs";
  806. include "com_commodulexp::SSZFM00701.xjs";
  807. var arErrorCode = new HashArray();
  808. function SMRST06900_oninit(obj:Form, e:InitEventInfo)
  809. {
  810. frmf_initForm(obj); //폼 초기화
  811. }
  812. function SMRST06900_onload(obj:Form, e:LoadEventInfo)
  813. {
  814. lf_setTabPageVisble(switch1, "case4", false);
  815. switch1.tabindex = 0;
  816. switch1_onchanged();
  817. switch1_case5_group3_rdo_srchflag_onitemchanged();
  818. }
  819. function switch1_case5_group3_rdo_srchflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  820. {
  821. var srchflag = ds_main_toggle5_cond.getColumn(0, "srchflag");
  822. if(srchflag=="1"){
  823. switch1.case5.datagrid3.setFormatColProperty(switch1.case5.datagrid3.getBindCellIndex("body", "goodlrgnm"), "size", 64);
  824. switch1.case5.datagrid3.setFormatColProperty(switch1.case5.datagrid3.getBindCellIndex("body", "acntnm"), "size", 0);
  825. }else if(srchflag=="2"){
  826. switch1.case5.datagrid3.setFormatColProperty(switch1.case5.datagrid3.getBindCellIndex("body", "goodlrgnm"), "size", 0);
  827. switch1.case5.datagrid3.setFormatColProperty(switch1.case5.datagrid3.getBindCellIndex("body", "acntnm"), "size", 94);
  828. }
  829. }
  830. function switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
  831. {
  832. if(switch1.tabindex == 0){
  833. rszfUserGoodFlagList("switch1.case3.cmb_cond3goodflag", sysf_getUserInfo("userid"));
  834. var sDate = utlf_getCurrentDate();
  835. var cDate = sDate.substring(0, 6);
  836. ds_main_cond.setColumn(0, "stocym" , cDate);
  837. switch1.case1.group2.opt_instcd.value = sysf_getUserInfo("dutplceinstcd");
  838. switch1.case1.group2.opt_instcdnm.value = sysf_getUserInfo("dutplceinstnm");
  839. ds_main_cond.setColumn(0, "userid", sysf_getUserId());
  840. ds_main_cond.setColumn(0, "usernm", sysf_getUserInfo("usernm"));
  841. }else if(switch1.tabindex == 1){
  842. // model.toggle("case2");
  843. // rszfUserInstList(cmb_instcd,getUserInfo("userid"));
  844. // model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
  845. // model.setValue(ipt_userid.attribute("ref") , getUserInfo("userid"));
  846. // model.setValue(ipt_usernm.attribute("ref") , getUserInfo("usernm"));
  847. // model.setValue("/root/main/toggle2_cond/stocym", model.getValue("/root/main/cond/stocym"));
  848. }else if(switch1.tabindex == 2){
  849. rszfUserInstList(switch1.case3.cmb_cond3instcd,sysf_getUserInfo("userid"));
  850. ds_main_toggle3_cond.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  851. switch1.case3.ipt_cond3userid.value = sysf_getUserInfo("userid");
  852. switch1.case3.ipt_cond3usernm.value = sysf_getUserInfo("usernm");
  853. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  854. ds_main_toggle3_cond.setColumn(0, "goodflag", "PH");
  855. ds_main_toggle3_cond.setColumn(0, "stocym" , ds_main_cond.getColumn(0, "stocym"));
  856. }else if(switch1.tabindex == 3){
  857. rszfUserInstList(switch1.case5.cmb_cond4instcd,sysf_getUserInfo("userid"));
  858. ds_main_toggle5_cond.setColumn(0, "instcd" , sysf_getUserInfo("dutplceinstcd"));
  859. switch1.case5.group3.output5.value = sysf_getUserInfo("dutplceinstnm");
  860. ds_main_toggle5_cond.setColumn(0, "stocym" , ds_main_cond.getColumn(0, "stocym"));
  861. ds_main_toggle5_cond.setColumn(0, "srchflag","2");
  862. switch1_case5_group3_rdo_srchflag_onitemchanged();
  863. }else if(switch1.tabindex == 4){
  864. rszfUserInstList(switch1.case5.cmb_cond4instcd,sysf_getUserInfo("userid"));
  865. ds_main_toggle6_cond.setColumn(0, "instcd" , sysf_getUserInfo("dutplceinstcd"));
  866. switch1.case6.group4.output9.value = sysf_getUserInfo("dutplceinstnm");
  867. ds_main_toggle6_cond.setColumn(0, "tostocym" , ds_main_cond.getColumn(0, "stocym"));
  868. ds_main_toggle6_cond.setColumn(0, "fromstocym" , ds_main_cond.getColumn(0, "stocym"));
  869. }
  870. }
  871. function ds_main_phaminfo_phamlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  872. {
  873. if (ds_main_phaminfo_phamlist.rowposition >= 0) {
  874. ds_main_good_cond.addRow();
  875. ds_main_good_cond.setColumn(0, "stocym", ds_main_cond.getColumn(0, "stocym"));
  876. ds_main_good_cond.setColumn(0, "instcd", ds_main_cond.getColumn(0, "instcd"));
  877. if (switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c2") ||
  878. switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c7")) {
  879. if (switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c2")) {
  880. ds_main_good_cond.setColumn(0, "flag", "C");
  881. ds_main_good_cond.setColumn(0, "goodcd", ds_main_good_cond.getColumn(ds_main_good_cond.rowposition, "c2"));
  882. } else if (switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c7")) {
  883. ds_main_good_cond.setColumn(0, "flag", "N");
  884. ds_main_good_cond.setColumn(0, "goodnm", ds_main_good_cond.getColumn(ds_main_good_cond.rowposition, "c7"));
  885. }
  886. var oParam = {};
  887. oParam.id = "TRRST06906";
  888. oParam.service = "stocsumapp.StocSumMngt";
  889. oParam.method = "reqGetBaseDrugList";
  890. oParam.inds = "req=ds_main_good_cond";
  891. oParam.outds = "ds_main_goodinfo_goodlist=goodlist";
  892. oParam.async = false;
  893. tranf_submit(oParam);
  894. var nodeCnts = ds_main_goodinfo_goodlist.rowcount;
  895. if (nodeCnts >= 2) {
  896. switch1.case1.grd_goodlist.visible = true;
  897. } else if (nodeCnts == 1){
  898. var goodcd = ds_main_goodinfo_goodlist.getColumn(0, "goodcd");
  899. var goodnm = ds_main_goodinfo_goodlist.getColumn(0, "goodnm");
  900. var goodunitcost = ds_main_goodinfo_goodlist.getColumn(0, "goodunitcost");
  901. var row2 = ds_main_phaminfo_phamlist.rowposition;
  902. dsf_makeValue(ds_main_phaminfo_phamlist, "c2" , "string", goodcd, row2);
  903. dsf_makeValue(ds_main_phaminfo_phamlist, "c7" , "string", goodnm, row2);
  904. dsf_makeValue(ds_main_phaminfo_phamlist, "c3" , "string", goodunitcost, row2);
  905. } else {
  906. sysf_messageBox("조회된 결과가 없습니다.", "I");
  907. }
  908. } else if (switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c10") || switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c11")
  909. ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c12") ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c13")
  910. ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c14") ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c15")
  911. ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c16") ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c17")
  912. ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c18") ||switch1.case1.grd_phamlist.currentcol == switch1.case1.grd_phamlist.getBindCellIndex("body", "c19")) {
  913. var row2 = ds_main_phaminfo_phamlist.rowposition;
  914. var c10 = ds_main_phaminfo_phamlist.getColumn(row2, "c10");
  915. if (utlf_isNull(c10)) {
  916. c10 = 0;
  917. }
  918. var c11 = ds_main_phaminfo_phamlist.getColumn(row2, "c11");
  919. if (utlf_isNull(c11)) {
  920. c11 = 0;
  921. }
  922. var c12 = ds_main_phaminfo_phamlist.getColumn(row2, "c12");
  923. if (utlf_isNull(c12)) {
  924. c12 = 0;
  925. }
  926. var c13 = ds_main_phaminfo_phamlist.getColumn(row2, "c13");
  927. if (utlf_isNull(c13)) {
  928. c13 = 0;
  929. }
  930. var c14 = ds_main_phaminfo_phamlist.getColumn(row2, "c14");
  931. if (utlf_isNull(c14)) {
  932. c14 = 0;
  933. }
  934. var c15 = ds_main_phaminfo_phamlist.getColumn(row2, "c15");
  935. if (utlf_isNull(c15)) {
  936. c15 = 0;
  937. }
  938. var c16 = ds_main_phaminfo_phamlist.getColumn(row2, "c16");
  939. if (utlf_isNull(c16)) {
  940. c16 = 0;
  941. }
  942. var c17 = ds_main_phaminfo_phamlist.getColumn(row2, "c17");
  943. if (utlf_isNull(c17)) {
  944. c17 = 0;
  945. }
  946. var c18 = ds_main_phaminfo_phamlist.getColumn(row2, "c18");
  947. if (utlf_isNull(c18)) {
  948. c18 = 0;
  949. }
  950. var c19 = ds_main_phaminfo_phamlist.getColumn(row2, "c19");
  951. if (utlf_isNull(c19)) {
  952. c19 = 0;
  953. }
  954. var totalsum = parseInt(c10) + parseInt(c11) + parseInt(c12) + parseInt(c13) + parseInt(c14)
  955. + parseInt(c15) + parseInt(c16) + parseInt(c17) + parseInt(c18) + parseInt(c19);
  956. ds_main_phaminfo_phamlist.setColumn(row2, "c8" , totalsum);
  957. }
  958. }
  959. }
  960. function switch1_case1_btn_loadexcel_onclick(obj:Button, e:ClickEventInfo)
  961. {
  962. // var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  963. // grd_phamlist.loadExcel(fileName, 1);
  964. }
  965. function switch1_case1_group2_btm_init_onclick(obj:Button, e:ClickEventInfo)
  966. {
  967. dsf_setDefaultVal(ds_main_cond, "goodflag:P");
  968. var oParam = {};
  969. oParam.id = "TRRST06901";
  970. oParam.service = "stocsumapp.StocSumMngt";
  971. oParam.method = "reqGetPhamOutSlipEnd1StepList";
  972. oParam.inds = "req=ds_main_cond";
  973. oParam.outds = "ds_main_phaminfo_phamlist=phamlist ds_main_phaminfo_deptlist=deptlist";
  974. oParam.async = false;
  975. oParam.callback = "cf_TRRST06901";
  976. tranf_submit(oParam);
  977. if(ds_main_phaminfo_phamlist.rowcount > 0){
  978. ds_main_phaminfo_phamlist.updateColID("lgrcd" , "c1");
  979. ds_main_phaminfo_phamlist.updateColID("goodcd" , "c2");
  980. ds_main_phaminfo_phamlist.updateColID("appunitcost" , "c3");
  981. ds_main_phaminfo_phamlist.updateColID("stocym" , "c4");
  982. ds_main_phaminfo_phamlist.updateColID("instcd" , "c5");
  983. ds_main_phaminfo_phamlist.updateColID("userid" , "c6");
  984. ds_main_phaminfo_phamlist.updateColID("goodnm" , "c7");
  985. ds_main_phaminfo_phamlist.updateColID("apptotqty" , "c8");
  986. ds_main_phaminfo_phamlist.updateColID("apptotamt" , "c9");
  987. ds_main_phaminfo_phamlist.updateColID("d1" , "c10");
  988. ds_main_phaminfo_phamlist.updateColID("d2" , "c11");
  989. ds_main_phaminfo_phamlist.updateColID("d3" , "c12");
  990. ds_main_phaminfo_phamlist.updateColID("d4" , "c13");
  991. ds_main_phaminfo_phamlist.updateColID("d5" , "c14");
  992. ds_main_phaminfo_phamlist.updateColID("d6" , "c15");
  993. ds_main_phaminfo_phamlist.updateColID("d7" , "c16");
  994. ds_main_phaminfo_phamlist.updateColID("d8" , "c17");
  995. ds_main_phaminfo_phamlist.updateColID("d9" , "c18");
  996. ds_main_phaminfo_phamlist.updateColID("d10" , "c19");
  997. }
  998. if (arErrorCode.pop("TRRST06901") > -1) {
  999. var grd_deptcd = ds_main_phaminfo_deptlist.getColumn(0, "grd_deptcd");
  1000. if (!utlf_isNull(grd_deptcd)) {
  1001. var arr = "대분류^약품코드^구입단가^비용계정비^구코드^복지부분류^약품명^총합^금액^" + grd_deptcd;
  1002. arr = arr.split("^");
  1003. for(var i = 0; i < arr.length; i++){
  1004. switch1.case1.grd_phamlist.setCellProperty( "Head", i + 1, "text", arr[i]);
  1005. }
  1006. }
  1007. }
  1008. }
  1009. function cf_TRRST06901(sSvcId, nErrorCode, sErrorMsg) {
  1010. arErrorCode.push(sSvcId, nErrorCode);
  1011. }
  1012. function switch1_case1_group2_button2_onclick(obj:Button, e:ClickEventInfo)
  1013. {
  1014. ds_main_phamuseinfo_phamuselist.clearData();
  1015. // dsf_makeNode("/root/main/phamuseinfo/dummy")
  1016. var deptcnts = ds_main_cond.getColumn(0, "deptcnts");
  1017. if (utlf_isNull(deptcnts)) {
  1018. sysf_messageBox("부서갯수를 입력해 주세요", "C");
  1019. return;
  1020. }
  1021. var stocym = ds_main_cond.getColumn(0, "stocym");
  1022. if (utlf_isNull(stocym)) {
  1023. sysf_messageBox("작업년월을 입력하십시오", "C");
  1024. return;
  1025. }
  1026. // // 엑셀에서 데이터를 가지고 와서 실제 사용할 수 있는 데이터 형태로 가공한다.
  1027. // var ins = document.models( 0 ).instances( 0 );
  1028. // var nodes = ins.selectNodes( "/root/main/phaminfo/phamlist" );
  1029. //
  1030. // // 속도를 위해서 그리드의 리스트를 먼저 만들어 둔다.
  1031. // var length = (parseInt(nodes.length) -1) * deptcnts;
  1032. // for(i = 0; i < length ; i++) {
  1033. // var newNode = instance1.createElement("phamuselist");
  1034. // var node = root.main.phamuseinfo;
  1035. // var destNode = root.main.phamuseinfo.dummy;
  1036. // node.insertAfter(newNode ,destNode);
  1037. // }
  1038. var nodes2 = ds_main_phamuseinfo_phamuselist.rowcount;
  1039. var instcd = ds_main_cond.getColumn(0, "instcd");
  1040. var userid = ds_main_cond.getColumn(0, "userid");
  1041. var stocym = ds_main_cond.getColumn(0, "stocym");
  1042. var cnt=0;
  1043. for(var i = 1; i < ds_main_phaminfo_phamlist.rowcount; i++) {
  1044. for(j = 1; j <= deptcnts; j++) {
  1045. var addRow = ds_main_phamuseinfo_phamuselist.addRow();
  1046. //대분류명 node copy
  1047. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "lrgnm", ds_main_phaminfo_phamlist.getColumn(0, "C1"));
  1048. //약품코드 node copy
  1049. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "goodcd", ds_main_phaminfo_phamlist.getColumn(0, "C2"));
  1050. //구입단가 node copy
  1051. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "unitcost", ds_main_phaminfo_phamlist.getColumn(0, "C3"));
  1052. //총합계 node copy
  1053. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "totstocqty", ds_main_phaminfo_phamlist.getColumn(0, "C8"));
  1054. //관리부서 node copy
  1055. //ds_main_phamuseinfo_phamuselist.setColumn(addRow, "stocdeptcd", ds_main_phaminfo_phamlist.getColumn(0, "C"+ ((evalj)+9)));
  1056. //수량 node copy
  1057. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "oristocqty", ds_main_phaminfo_phamlist.getColumn(0, "C"+ (eval(j)+9)));
  1058. // 기관코드를 조회한다.
  1059. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "instcd", ds_main_phaminfo_phamlist.getColumn(0, "C5"));
  1060. //사용자 ID를 넣어준다.
  1061. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "userid", ds_main_phaminfo_phamlist.getColumn(0, "C6"));
  1062. //작업년월을 넣어준다.
  1063. ds_main_phamuseinfo_phamuselist.setColumn(addRow, "stocym", ds_main_phaminfo_phamlist.getColumn(0, "C4"));
  1064. cnt++;
  1065. }
  1066. }
  1067. var oParam = {};
  1068. oParam.id = "TXRST06901";
  1069. oParam.service = "stocsumapp.StocSumMngt";
  1070. oParam.method = "reqExePhamOutSlipEnd1Step";
  1071. oParam.inds = "req=ds_main_phamuseinfo_phamuselist";
  1072. oParam.outds = "";
  1073. oParam.async = false;
  1074. oParam.callback = "cf_TXRST06901";
  1075. tranf_submit(oParam);
  1076. if(arErrorCode.pop("TXRST06901") > -1){
  1077. var oParam = {};
  1078. oParam.id = "TRRST06901";
  1079. oParam.service = "stocsumapp.StocSumMngt";
  1080. oParam.method = "reqGetPhamOutSlipEnd1StepList";
  1081. oParam.inds = "req=ds_main_cond";
  1082. oParam.outds = "ds_main_phaminfo_phamlist=phamlist ds_main_phaminfo_deptlist=deptlist";
  1083. oParam.async = false;
  1084. oParam.callback = "cf_TRRST06901";
  1085. tranf_submit(oParam);
  1086. ds_main_phaminfo_phamlist.updateColID("lgrcd" , "c1");
  1087. ds_main_phaminfo_phamlist.updateColID("goodcd" , "c2");
  1088. ds_main_phaminfo_phamlist.updateColID("appunitcost" , "c3");
  1089. ds_main_phaminfo_phamlist.updateColID("stocym" , "c4");
  1090. ds_main_phaminfo_phamlist.updateColID("instcd" , "c5");
  1091. ds_main_phaminfo_phamlist.updateColID("userid" , "c6");
  1092. ds_main_phaminfo_phamlist.updateColID("goodnm" , "c7");
  1093. ds_main_phaminfo_phamlist.updateColID("apptotqty" , "c8");
  1094. ds_main_phaminfo_phamlist.updateColID("apptotamt" , "c9");
  1095. ds_main_phaminfo_phamlist.updateColID("d1" , "c10");
  1096. ds_main_phaminfo_phamlist.updateColID("d2" , "c11");
  1097. ds_main_phaminfo_phamlist.updateColID("d3" , "c12");
  1098. ds_main_phaminfo_phamlist.updateColID("d4" , "c13");
  1099. ds_main_phaminfo_phamlist.updateColID("d5" , "c14");
  1100. ds_main_phaminfo_phamlist.updateColID("d6" , "c15");
  1101. ds_main_phaminfo_phamlist.updateColID("d7" , "c16");
  1102. ds_main_phaminfo_phamlist.updateColID("d8" , "c17");
  1103. ds_main_phaminfo_phamlist.updateColID("d9" , "c18");
  1104. ds_main_phaminfo_phamlist.updateColID("d10" , "c19");
  1105. if (arErrorCode.pop("TRRST06901") > -1) {
  1106. var grd_deptcd = ds_main_phaminfo_deptlist.getColumn(0, "grd_deptcd");
  1107. if (!utlf_isNull(grd_deptcd)) {
  1108. var arr = "대분류^약품코드^구입단가^비용계정비^구코드^복지부분류^약품명^총합^금액^" + grd_deptcd;
  1109. arr = arr.split("^");
  1110. for(var i = 0; i < arr.length; i++){
  1111. switch1.case1.grd_phamlist.setCellProperty( "Head", i + 1, "text", arr[i]);
  1112. }
  1113. }
  1114. }
  1115. }
  1116. }
  1117. function cf_TXRST06901(sSvcId, nErrorCode, sErrorMsg) {
  1118. arErrorCode.push(sSvcId, nErrorCode);
  1119. }
  1120. function switch1_case1_button10_onclick(obj:Button, e:ClickEventInfo)
  1121. {
  1122. dsf_makeValue(ds_main_phaminfo_phamlist, "c1" , "string", "대분류");
  1123. dsf_makeValue(ds_main_phaminfo_phamlist, "c2" , "string", "약품코드");
  1124. dsf_makeValue(ds_main_phaminfo_phamlist, "c3" , "string", "구입단가");
  1125. dsf_makeValue(ds_main_phaminfo_phamlist, "c4" , "string", "비용계정비");
  1126. dsf_makeValue(ds_main_phaminfo_phamlist, "c5" , "string", "구코드");
  1127. dsf_makeValue(ds_main_phaminfo_phamlist, "c6" , "string", "복지부분류");
  1128. dsf_makeValue(ds_main_phaminfo_phamlist, "c7" , "string", "약품명");
  1129. dsf_makeValue(ds_main_phaminfo_phamlist, "c8" , "string", "총합");
  1130. dsf_makeValue(ds_main_phaminfo_phamlist, "c9" , "string", "금액");
  1131. if(utlf_isNull(ds_main_phaminfo_phamlist.getColumnInfo("c10"))){
  1132. dsf_makeValue(ds_main_phaminfo_phamlist, "c10" , "string", "");//부서코드
  1133. }else{
  1134. if(utlf_isNull(ds_main_phaminfo_phamlist.getColumn(0, "c10"))) {
  1135. dsf_makeValue(ds_main_phaminfo_phamlist, "c10" , "string", "");//부서코드
  1136. }
  1137. }
  1138. dsf_makeValue(ds_main_phaminfo_phamlist, "c11" , "string", "");
  1139. dsf_makeValue(ds_main_phaminfo_phamlist, "c12" , "string", "");
  1140. dsf_makeValue(ds_main_phaminfo_phamlist, "c13" , "string", "");
  1141. dsf_makeValue(ds_main_phaminfo_phamlist, "c14" , "string", "");
  1142. dsf_makeValue(ds_main_phaminfo_phamlist, "c15" , "string", "");
  1143. dsf_makeValue(ds_main_phaminfo_phamlist, "c16" , "string", "");
  1144. dsf_makeValue(ds_main_phaminfo_phamlist, "c17" , "string", "");
  1145. dsf_makeValue(ds_main_phaminfo_phamlist, "c18" , "string", "");
  1146. dsf_makeValue(ds_main_phaminfo_phamlist, "c19" , "string", "");
  1147. ds_main_phaminfo_phamlist.addRow();
  1148. }
  1149. function switch1_case1_group2_btn_deptsrch_onclick(obj:Button, e:ClickEventInfo)
  1150. {
  1151. dsf_makeValue(ds_send_reqdata, "instcd" , "string", ds_main_cond.getColumn(0, "instcd"));
  1152. dsf_makeValue(ds_send_reqdata, "depthngnm" , "string", switch1.case1.group2.ipt_depthngnm.text);
  1153. getRszDeptCdList("ds_send_reqdata", ds_init_orddept_deptlist);
  1154. var nodeCnts = ds_init_orddept_deptlist.rowcount;
  1155. if (nodeCnts > 0 ) {
  1156. group1.visible = true;
  1157. } else {
  1158. sysf_messageBox("검색된 결과가 없습니다.", "I");
  1159. }
  1160. }
  1161. function switch1_case1_group2_ipt_depthngnm_onkeydown(obj:Edit, e:KeyEventInfo)
  1162. {
  1163. if (e.keycode == "13") {
  1164. switch1_case1_group2_btn_deptsrch_onclick();
  1165. }
  1166. }
  1167. function switch1_case1_grd_goodlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  1168. {
  1169. if (e.row >= 0 && e.col >= 0) {
  1170. var row = ds_main_goodinfo_goodlist.rowposition;
  1171. var goodcd = ds_main_goodinfo_goodlist.getColumn(row, "goodcd");
  1172. var goodnm = ds_main_goodinfo_goodlist.getColumn(row, "goodnm");
  1173. var goodunitcost = ds_main_goodinfo_goodlist.getColumn(row, "goodunitcost");
  1174. var row2 = ds_main_phaminfo_phamlist.rowposition;
  1175. dsf_makeValue(ds_main_phaminfo_phamlist, "c2" , "string", goodcd, row2);
  1176. dsf_makeValue(ds_main_phaminfo_phamlist, "c7" , "string", goodnm, row2);
  1177. dsf_makeValue(ds_main_phaminfo_phamlist, "c3" , "string", goodunitcost, row2);
  1178. switch1.case1.grd_goodlist.visible = false;
  1179. }
  1180. }
  1181. function switch1_case1_button11_onclick(obj:Button, e:ClickEventInfo)
  1182. {
  1183. dsf_setDefaultVal(ds_main_cond, "goodflag:PH");
  1184. var oParam = {};
  1185. oParam.id = "TRRST06903";
  1186. oParam.service = "stocsumapp.StocSumMngt";
  1187. oParam.method = "reqGetPhamOutSlipEnd1StepListBySsst";
  1188. oParam.inds = "req=ds_main_cond";
  1189. oParam.outds = "ds_main_phaminfo_phamlist=phamlist";
  1190. oParam.async = false;
  1191. tranf_submit(oParam);
  1192. if(ds_main_phaminfo_phamlist.rowcount > 0){
  1193. ds_main_phaminfo_phamlist.updateColID("lgrcd" , "c1");
  1194. ds_main_phaminfo_phamlist.updateColID("goodcd" , "c2");
  1195. ds_main_phaminfo_phamlist.updateColID("appunitcost" , "c3");
  1196. ds_main_phaminfo_phamlist.updateColID("stocym" , "c4");
  1197. ds_main_phaminfo_phamlist.updateColID("instcd" , "c5");
  1198. ds_main_phaminfo_phamlist.updateColID("userid" , "c6");
  1199. ds_main_phaminfo_phamlist.updateColID("goodnm" , "c7");
  1200. ds_main_phaminfo_phamlist.updateColID("apptotqty" , "c8");
  1201. ds_main_phaminfo_phamlist.updateColID("apptotamt" , "c9");
  1202. ds_main_phaminfo_phamlist.updateColID("d1" , "c10");
  1203. ds_main_phaminfo_phamlist.updateColID("d2" , "c11");
  1204. ds_main_phaminfo_phamlist.updateColID("d3" , "c12");
  1205. ds_main_phaminfo_phamlist.updateColID("d4" , "c13");
  1206. ds_main_phaminfo_phamlist.updateColID("d5" , "c14");
  1207. ds_main_phaminfo_phamlist.updateColID("d6" , "c15");
  1208. ds_main_phaminfo_phamlist.updateColID("d7" , "c16");
  1209. ds_main_phaminfo_phamlist.updateColID("d8" , "c17");
  1210. ds_main_phaminfo_phamlist.updateColID("d9" , "c18");
  1211. ds_main_phaminfo_phamlist.updateColID("d10" , "c19");
  1212. }
  1213. }
  1214. function switch1_case1_btn_excel_onclick(obj:Button, e:ClickEventInfo)
  1215. {
  1216. var Stocy = ds_main_cond.getColumn(0, "stocym").substr(0,4);
  1217. var Stocm = ds_main_cond.getColumn(0, "stocym").substr(5,7);
  1218. misfSaveExcel(switch1.case1.grd_phamlist, Stocy+"년"+Stocm+"월"+" "+"재고실사내역");
  1219. }
  1220. function group1_button5_onclick(obj:Button, e:ClickEventInfo)
  1221. {
  1222. group1.visible = false;
  1223. }
  1224. function switch1_case2_btn_gen_onclick(obj:Button, e:ClickEventInfo)
  1225. {
  1226. // var stocflag = model.getValue("/root/main/toggle2_cond/stocflag");
  1227. // if (stocflag == "P") {
  1228. // for (var i = 1; i <= 31; i++ ) {
  1229. // var dd = "";
  1230. // if ( i < 10) {
  1231. // dd = "0" + (i).toString();
  1232. // } else {
  1233. // dd = (i).toString();
  1234. // }
  1235. //
  1236. // var stocdd = model.getValue("/root/main/toggle2_cond/stocym") + dd;
  1237. // model.setValue("/root/main/toggle2_cond/stocdd", stocdd);
  1238. // submit("TXRST06902");
  1239. // }
  1240. // if (submit("TRRST06902") == true) {
  1241. // var cnts = getNodesetCount("/root/tmp/cntinfo/cntlist");
  1242. // if (cnts > 1 ) {
  1243. // messageBox("처방출고처리가 완료되지 않았습니다. \n 다시 생성버튼을 눌러주세요.", "I");
  1244. // } else {
  1245. // messageBox("성공적으로 처방출고처리 되었습니다.", "I");
  1246. // }
  1247. // }
  1248. // }else if(stocflag == "H"){
  1249. // for (var i = 1; i <= 31; i++ ) {
  1250. // var dd = "";
  1251. // if ( i < 10) {
  1252. // dd = "0" + (i).toString();
  1253. // } else {
  1254. // dd = (i).toString();
  1255. // }
  1256. //
  1257. // var stocdd = model.getValue("/root/main/toggle2_cond/stocym") + dd;
  1258. // model.setValue("/root/main/toggle2_cond/stocdd", stocdd);
  1259. // submit("TXRST06902");
  1260. // }
  1261. // if (submit("TRRST06902") == true) {
  1262. // var cnts = getNodesetCount("/root/tmp/cntinfo/cntlist");
  1263. // if (cnts > 1 ) {
  1264. // messageBox("처방출고처리가 완료되지 않았습니다. \n 다시 생성버튼을 눌러주세요.", "I");
  1265. // } else {
  1266. // messageBox("성공적으로 처방출고처리 되었습니다.", "I");
  1267. // }
  1268. // }
  1269. // }else {
  1270. // if (submit("TXRST06902") == true) {
  1271. // messageBox("작업이 성공적으로 수행되었습니다.", "I");
  1272. // }
  1273. // }
  1274. }
  1275. function switch1_case3_button7_onclick(obj:Button, e:ClickEventInfo)
  1276. {
  1277. var oParam = {};
  1278. oParam.id = "TRRST06903";
  1279. oParam.service = "stocsumapp.StocSumMngt";
  1280. oParam.method = "reqExePhamOutSlipEnd3Step";
  1281. oParam.inds = "req=ds_main_toggle3_cond";
  1282. oParam.outds = "";
  1283. oParam.async = false;
  1284. oParam.callback = "cf_TRRST06903";
  1285. tranf_submit(oParam);
  1286. if (arErrorCode.pop("TRRST06903") > -1) {
  1287. sysf_messageBox("작업이 성공적으로 수행되었습니다.", "I");
  1288. }
  1289. }
  1290. function cf_TRRST06903(sSvcId, nErrorCode, sErrorMsg) {
  1291. arErrorCode.push(sSvcId, nErrorCode);
  1292. }
  1293. function switch1_case4_button6_onclick(obj:Button, e:ClickEventInfo)
  1294. {
  1295. var oParam = {};
  1296. oParam.id = "TRRST06904";
  1297. oParam.service = "stocsumapp.StocSumMngt";
  1298. oParam.method = "reqExePhamOutSlipEnd4Step";
  1299. oParam.inds = "req=ds_main_toggle4_cond";
  1300. oParam.outds = "";
  1301. oParam.async = false;
  1302. oParam.callback = "cf_TRRST06904";
  1303. tranf_submit(oParam);
  1304. if (arErrorCode.pop("TRRST06904") > -1) {
  1305. sysf_messageBox("작업이 성공적으로 수행되었습니다.", "I");
  1306. }
  1307. }
  1308. function cf_TRRST06904(sSvcId, nErrorCode, sErrorMsg) {
  1309. arErrorCode.push(sSvcId, nErrorCode);
  1310. }
  1311. function switch1_case5_button4_onclick(obj:Button, e:ClickEventInfo)
  1312. {
  1313. grdf_exportExcel(switch1.case5.datagrid3, "처리결과" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
  1314. }
  1315. function switch1_case5_group3_button9_onclick(obj:Button, e:ClickEventInfo)
  1316. {
  1317. dsf_setDefaultVal(ds_main_toggle5_cond, "goodflag:P");
  1318. ds_main_toggle5_cond.setColumn(0, "stocym", ds_main_toggle5_cond.getColumn(0, "stocym").substr(0, 6));
  1319. var oParam = {};
  1320. oParam.id = "TRRST06905";
  1321. oParam.service = "stocsumapp.StocSumMngt";
  1322. oParam.method = "reqGetPhamOutEndRsltList";
  1323. oParam.inds = "req=ds_main_toggle5_cond";
  1324. oParam.outds = "ds_main_outendrsltinfo_outendrsltlist=outendrsltlist";
  1325. oParam.async = false;
  1326. oParam.callback = "cf_TRRST06905";
  1327. tranf_submit(oParam);
  1328. if(arErrorCode.pop("TRRST06905") > -1){
  1329. dsf_setTypeFormat(ds_main_outendrsltinfo_outendrsltlist, "appunitcost00:BIGDECIMAL^beftotqty00:BIGDECIMAL^winqty01:BIGDECIMAL^winamt:BIGDECIMAL^outcnts:BIGDECIMAL^totuseamt:BIGDECIMAL^stoccnts:BIGDECIMAL^stocamt:BIGDECIMAL");
  1330. }
  1331. }
  1332. function cf_TRRST06905(sSvcId, nErrorCode, sErrorMsg) {
  1333. arErrorCode.push(sSvcId, nErrorCode);
  1334. }
  1335. function switch1_case6_group4_button13_onclick(obj:Button, e:ClickEventInfo)
  1336. {
  1337. ds_main_toggle6_cond.setColumn(0, "fromstocym", ds_main_toggle6_cond.getColumn(0, "fromstocym").substr(0, 6));
  1338. ds_main_toggle6_cond.setColumn(0, "tostocym", ds_main_toggle6_cond.getColumn(0, "tostocym").substr(0, 6));
  1339. var oParam = {};
  1340. oParam.id = "TRRST06907";
  1341. oParam.service = "stocsumapp.StocSumMngt";
  1342. oParam.method = "reqGetDrugAcctInfo";
  1343. oParam.inds = "req=ds_main_toggle6_cond";
  1344. oParam.outds = "ds_main_drugacctinfo_drugacctlist=drugacctlist";
  1345. oParam.async = false;
  1346. oParam.callback = "cf_TRRST06907";
  1347. tranf_submit(oParam);
  1348. if(arErrorCode.pop("TRRST06907") > -1){
  1349. dsf_setTypeFormat(ds_main_drugacctinfo_drugacctlist, "beftotqty00:BIGDECIMAL^appunitcost00:BIGDECIMAL^winqty01:BIGDECIMAL^winamt:BIGDECIMAL^stoccnts:BIGDECIMAL^stocamt:BIGDECIMAL");
  1350. }
  1351. }
  1352. function cf_TRRST06907(sSvcId, nErrorCode, sErrorMsg) {
  1353. arErrorCode.push(sSvcId, nErrorCode);
  1354. }
  1355. function switch1_case6_button14_onclick(obj:Button, e:ClickEventInfo)
  1356. {
  1357. grdf_exportExcel(switch1.case6.datagrid4, "회계자료조회" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
  1358. }
  1359. function group1_datagrid2_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  1360. {
  1361. if (group1.datagrid2.currentcol == group1.datagrid2.getBindCellIndex("body", "depthngnm")) {
  1362. ds_main_phaminfo_phamlist.setColumn(ds_main_phaminfo_phamlist.rowposition, "depthngnm", ds_init_orddept_deptlist.getColumn(ds_init_orddept_deptlist.rowposition, "deptcd"));
  1363. group1.visible = false;
  1364. }
  1365. }
  1366. ]]></Script>
  1367. </Form>
  1368. </FDL>