SPPIE04210_재료수가변경내역조회.xfdl 56 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPPIE04210" position="absolute 0 0 1198 774" titletext="재료수가변경내역조회" onload="SPPIE04210_onload">
  5. <Layouts>
  6. <Layout>
  7. <Tab id="switch1" position="absolute 600 41 1195 771" style="border:0 solid ;" anchor="all" tabposition="top">
  8. <Tabpages>
  9. <Tabpage id="cont" selected="true" position="absolute 0 0 10000 10000" style="" anchor="default">
  10. <Layouts>
  11. <Layout width="595" height="698">
  12. <Shape id="line1" class="line_10" linetype="horizontal" position="absolute 0 32 595 35" style="" anchor="left top right"/>
  13. <Grid id="grd_cont" binddataset="ds_main_cont" position="absolute 0 36 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_cont_grd_cont_onaftersort" anchor="all" cellsizingtype="col" cellmovingtype="col">
  14. <Formats>
  15. <Format id="default">
  16. <Columns>
  17. <Column size="0"/>
  18. <Column size="0"/>
  19. <Column size="80"/>
  20. <Column size="80"/>
  21. <Column size="200"/>
  22. <Column size="0"/>
  23. <Column size="0"/>
  24. <Column size="70"/>
  25. <Column size="70"/>
  26. <Column size="80"/>
  27. <Column size="60"/>
  28. <Column size="70"/>
  29. <Column size="70"/>
  30. <Column size="0"/>
  31. <Column size="0"/>
  32. <Column size="0"/>
  33. <Column size="0"/>
  34. <Column size="0"/>
  35. <Column size="100"/>
  36. <Column size="0"/>
  37. <Column size="0"/>
  38. <Column size="0"/>
  39. <Column size="0"/>
  40. <Column size="0"/>
  41. </Columns>
  42. <Rows>
  43. <Row size="23" band="head"/>
  44. <Row size="23"/>
  45. </Rows>
  46. <Band id="head">
  47. <Cell text="기관코드"/>
  48. <Cell col="1" text="물품구분"/>
  49. <Cell col="2" text="물품코드"/>
  50. <Cell col="3" text="EDI코드"/>
  51. <Cell col="4" text="물품명"/>
  52. <Cell col="5" text="계약순번"/>
  53. <Cell col="6" text="계약량"/>
  54. <Cell col="7" colspan="2" text="적용일자" taborder="undefined"/>
  55. <Cell col="9" text="계약단가"/>
  56. <Cell col="10" text="구분"/>
  57. <Cell col="11" colspan="2" text="단가계약기간" taborder="undefined"/>
  58. <Cell col="13" text="검수여부"/>
  59. <Cell col="14" text="최초작성자"/>
  60. <Cell col="15" text="최초작성일시"/>
  61. <Cell col="16" text="최종수정자"/>
  62. <Cell col="17" text="최종수정일시"/>
  63. <Cell col="18" text="최종수정일"/>
  64. <Cell col="19" displaytype="none"/>
  65. <Cell col="20" displaytype="none"/>
  66. <Cell col="21" displaytype="none"/>
  67. <Cell col="22" displaytype="none"/>
  68. <Cell col="23" displaytype="none"/>
  69. </Band>
  70. <Band id="body">
  71. <Cell text="bind:instcd"/>
  72. <Cell col="1" text="bind:goodflag"/>
  73. <Cell col="2" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:goodcd"/>
  74. <Cell col="3" style="background:bind:bgcontedicd;background2:bind:bgcontedicd;selectbackground:bind:bgcontedicd;" text="bind:edicd"/>
  75. <Cell col="4" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:goodnm"/>
  76. <Cell col="5" style="background:#ffffffff;background2:#ffffffff;" text="bind:purcconseq"/>
  77. <Cell col="6" style="background:#ffffffff;background2:#ffffffff;" text="bind:conqty"/>
  78. <Cell col="7" displaytype="date" text="bind:fromdd"/>
  79. <Cell col="8" displaytype="date" text="bind:todd"/>
  80. <Cell col="9" displaytype="number" style="background:bind:bgcontamt;background2:bind:bgcontamt;font:arial,9,bold;selectbackground:bind:bgcontamt;" text="bind:congoodunitcost"/>
  81. <Cell col="10" style="align:center middle;" text="bind:gubun"/>
  82. <Cell col="11" displaytype="date" text="bind:fromconterm"/>
  83. <Cell col="12" displaytype="date" text="bind:toconterm"/>
  84. <Cell col="13" style="background:#ffffffff;background2:#ffffffff;" text="bind:chkyn"/>
  85. <Cell col="14" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstrid"/>
  86. <Cell col="15" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstdt"/>
  87. <Cell col="16" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtrid"/>
  88. <Cell col="17" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtdt"/>
  89. <Cell col="18" displaytype="date" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtdt"/>
  90. <Cell col="19" displaytype="text" text="bind:bginsuamt"/>
  91. <Cell col="20" displaytype="text" text="bind:bgautmamt"/>
  92. <Cell col="21" displaytype="text" text="bind:bgcontamt"/>
  93. <Cell col="22" displaytype="text" text="bind:bgedicd"/>
  94. <Cell col="23" displaytype="text" text="bind:bgcontedicd"/>
  95. </Band>
  96. </Format>
  97. </Formats>
  98. </Grid>
  99. <Static id="caption7" class="tit_2" position="absolute 0 13 105 34" style="" text="계약 내역"/>
  100. <Button id="Button00" taborder="1" text="엑셀저장" position="absolute 518 10 595 30" class="btn7" onclick="switch1_cont_Button00_onclick" anchor="top right"/>
  101. <Static id="Static02" position="absolute 87 13 102 28" anchor="left top" style="background:#9fc93cff;border:1 solid #808080ff ;"/>
  102. <Static id="Static01" position="absolute 216 13 231 28" anchor="left top" style="background:#ffc4ebff;border:1 solid #808080ff ;"/>
  103. <Static id="Static00" text="EDI코드상이" position="absolute 109 11 209 31"/>
  104. <Static id="Static03" text="단가상이" position="absolute 238 10 338 30"/>
  105. </Layout>
  106. </Layouts>
  107. </Tabpage>
  108. <Tabpage id="wchk" anchor="default">
  109. <Layouts>
  110. <Layout>
  111. <Grid id="grd_wchk" binddataset="ds_main_wchk" position="absolute 0 23 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_wchk_grd_wchk_onaftersort" anchor="all">
  112. <Formats>
  113. <Format id="default">
  114. <Columns>
  115. <Column size="0"/>
  116. <Column size="0"/>
  117. <Column size="80"/>
  118. <Column size="80"/>
  119. <Column size="60"/>
  120. <Column size="0"/>
  121. <Column size="80"/>
  122. <Column size="60"/>
  123. <Column size="60"/>
  124. <Column size="80"/>
  125. <Column size="0"/>
  126. <Column size="0"/>
  127. <Column size="0"/>
  128. <Column size="0"/>
  129. <Column size="0"/>
  130. <Column size="0"/>
  131. <Column size="0"/>
  132. <Column size="80"/>
  133. </Columns>
  134. <Rows>
  135. <Row size="23" band="head"/>
  136. <Row size="23"/>
  137. </Rows>
  138. <Band id="head">
  139. <Cell text="기관코드"/>
  140. <Cell col="1" text="물품구분"/>
  141. <Cell col="2" text="물품코드"/>
  142. <Cell col="3" text="검수일자"/>
  143. <Cell col="4" text="검수번호"/>
  144. <Cell col="5" text="검수순번"/>
  145. <Cell col="6" text="계약일자"/>
  146. <Cell col="7" text="계약번호"/>
  147. <Cell col="8" text="검수수량"/>
  148. <Cell col="9" text="검수단가"/>
  149. <Cell col="10" text="검수금액"/>
  150. <Cell col="11" text="계정과목"/>
  151. <Cell col="12" text="출고부서"/>
  152. <Cell col="13" text="최초작성자"/>
  153. <Cell col="14" text="최초작성일시"/>
  154. <Cell col="15" text="최종수정자"/>
  155. <Cell col="16" text="최종수정일시"/>
  156. <Cell col="17" text="최종수정일"/>
  157. </Band>
  158. <Band id="body">
  159. <Cell text="bind:instcd"/>
  160. <Cell col="1" text="bind:goodflag"/>
  161. <Cell col="2" style="align:left;background:white;background2:white;" text="bind:goodcd"/>
  162. <Cell col="3" displaytype="date" style="background:white;background2:white;" text="bind:purcchkdd"/>
  163. <Cell col="4" style="background:white;background2:white;" text="bind:purcchkno"/>
  164. <Cell col="5" style="background:white;background2:white;" text="bind:purcchkseq"/>
  165. <Cell col="6" displaytype="date" style="background:white;background2:white;" text="bind:purccondd"/>
  166. <Cell col="7" style="background:white;background2:white;" text="bind:purcconno"/>
  167. <Cell col="8" displaytype="number" style="background:white;background2:white;" text="bind:chkqty"/>
  168. <Cell col="9" displaytype="number" style="background:white;background2:white;font:arial,9,bold;" text="bind:chkgoodunitcost"/>
  169. <Cell col="10" style="background:white;background2:white;" text="bind:chkamt"/>
  170. <Cell col="11" style="background:white;background2:white;" text="bind:acntcd"/>
  171. <Cell col="12" style="background:white;background2:white;" text="bind:delivedeptcd"/>
  172. <Cell col="13" style="background:white;background2:white;" text="bind:fstrgstrid"/>
  173. <Cell col="14" style="background:white;background2:white;" text="bind:fstrgstdt"/>
  174. <Cell col="15" style="background:white;background2:white;" text="bind:lastupdtrid"/>
  175. <Cell col="16" style="background:white;background2:white;" text="bind:lastupdtdt"/>
  176. <Cell col="17" displaytype="date" style="background:white;background2:white;" text="bind:lastupdtdd"/>
  177. </Band>
  178. </Format>
  179. </Formats>
  180. </Grid>
  181. <Static id="caption2" class="tit_2" position="absolute 0 2 100 18" style="" text="검수 내역"/>
  182. <Shape id="line4" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
  183. </Layout>
  184. </Layouts>
  185. </Tabpage>
  186. <Tabpage id="pur" anchor="default">
  187. <Layouts>
  188. <Layout>
  189. <Shape id="line2" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
  190. <Static id="caption8" class="tit_2" position="absolute 0 2 85 18" style="" text="구매 내역"/>
  191. <Grid id="grd_pur" binddataset="ds_main_pur" position="absolute 0 23 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_pur_grd_pur_onaftersort" anchor="all">
  192. <Formats>
  193. <Format id="default">
  194. <Columns>
  195. <Column size="0"/>
  196. <Column size="0"/>
  197. <Column size="80"/>
  198. <Column size="200"/>
  199. <Column size="0"/>
  200. <Column size="0"/>
  201. <Column size="80"/>
  202. <Column size="0"/>
  203. <Column size="60"/>
  204. <Column size="80"/>
  205. <Column size="0"/>
  206. <Column size="0"/>
  207. <Column size="0"/>
  208. <Column size="0"/>
  209. <Column size="0"/>
  210. <Column size="80"/>
  211. </Columns>
  212. <Rows>
  213. <Row size="23" band="head"/>
  214. <Row size="23"/>
  215. </Rows>
  216. <Band id="head">
  217. <Cell text="기관코드"/>
  218. <Cell col="1" text="관리구분"/>
  219. <Cell col="2" text="물품코드"/>
  220. <Cell col="3" text="물품명"/>
  221. <Cell col="4" text="계약일자"/>
  222. <Cell col="5" text="계약번호"/>
  223. <Cell col="6" text="입고일자"/>
  224. <Cell col="7" text="입고순번"/>
  225. <Cell col="8" text="구입량"/>
  226. <Cell col="9" text="구입단가"/>
  227. <Cell col="10" text="구입금액"/>
  228. <Cell col="11" text="출고부서"/>
  229. <Cell col="12" text="최초작성자"/>
  230. <Cell col="13" text="최초작성일시"/>
  231. <Cell col="14" text="최종수정일시"/>
  232. <Cell col="15" text="최종수정일"/>
  233. </Band>
  234. <Band id="body">
  235. <Cell text="bind:instcd"/>
  236. <Cell col="1" text="bind:kwanri_gubun"/>
  237. <Cell col="2" style="align:left;background:white;background2:white;" text="bind:goodcd"/>
  238. <Cell col="3" style="align:left;background:white;background2:white;" text="bind:pum_name"/>
  239. <Cell col="4" style="background:white;background2:white;" text="bind:ky_ymd"/>
  240. <Cell col="5" style="background:white;background2:white;" text="bind:ky_seq"/>
  241. <Cell col="6" displaytype="date" style="background:white;background2:white;" text="bind:ibgo_ymd"/>
  242. <Cell col="7" style="background:white;background2:white;" text="bind:ibgo_seq"/>
  243. <Cell col="8" displaytype="number" style="background:white;background2:white;" text="bind:qty"/>
  244. <Cell col="9" displaytype="number" style="background:white;background2:white;font:arial,9,bold;" text="bind:danga1"/>
  245. <Cell col="10" style="background:white;background2:white;" text="bind:keumak"/>
  246. <Cell col="11" style="background:white;background2:white;" text="bind:chul_buseo"/>
  247. <Cell col="12" style="background:white;background2:white;" text="bind:user_id"/>
  248. <Cell col="13" style="background:white;background2:white;" text="bind:sys_date"/>
  249. <Cell col="14" style="background:white;background2:white;" text="bind:upd_date"/>
  250. <Cell col="15" displaytype="date" style="background:white;background2:white;" text="bind:upd_dd"/>
  251. </Band>
  252. </Format>
  253. </Formats>
  254. </Grid>
  255. </Layout>
  256. </Layouts>
  257. </Tabpage>
  258. <Tabpage id="h604" anchor="default">
  259. <Layouts>
  260. <Layout>
  261. <Grid id="grd_h604" binddataset="ds_main_h604" position="absolute 0 23 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_h604_grd_h604_onaftersort" anchor="all">
  262. <Formats>
  263. <Format id="default">
  264. <Columns>
  265. <Column size="0"/>
  266. <Column size="0"/>
  267. <Column size="80"/>
  268. <Column size="0"/>
  269. <Column size="200"/>
  270. <Column size="80"/>
  271. <Column size="0"/>
  272. <Column size="60"/>
  273. <Column size="0"/>
  274. <Column size="80"/>
  275. <Column size="80"/>
  276. </Columns>
  277. <Rows>
  278. <Row size="23" band="head"/>
  279. <Row size="23"/>
  280. </Rows>
  281. <Band id="head">
  282. <Cell text="기관코드"/>
  283. <Cell col="1" text="신청여부"/>
  284. <Cell col="2" text="물품코드"/>
  285. <Cell col="3" text="EDI코드"/>
  286. <Cell col="4" text="물품명"/>
  287. <Cell col="5" text="신청일자"/>
  288. <Cell col="6" text="신청일련번호"/>
  289. <Cell col="7" text="구입량"/>
  290. <Cell col="8" text="구입가"/>
  291. <Cell col="9" text="개당단가"/>
  292. <Cell col="10" text="입고일자"/>
  293. </Band>
  294. <Band id="body">
  295. <Cell text="bind:instcd"/>
  296. <Cell col="1" text="bind:notiyn"/>
  297. <Cell col="2" style="align:left;background:white;background2:white;" text="bind:goodcd"/>
  298. <Cell col="3" style="background:white;background2:white;" text="bind:edicd"/>
  299. <Cell col="4" style="align:left;background:white;background2:white;" text="bind:itemnm"/>
  300. <Cell col="5" displaytype="date" style="background:white;background2:white;" text="bind:appdd"/>
  301. <Cell col="6" style="background:white;background2:white;" text="bind:appseqno"/>
  302. <Cell col="7" displaytype="number" style="background:white;background2:white;" text="bind:winqty"/>
  303. <Cell col="8" style="background:white;background2:white;" text="bind:winamt"/>
  304. <Cell col="9" displaytype="number" style="background:white;background2:white;font:arial,9,bold;" text="bind:oneunitcost"/>
  305. <Cell col="10" displaytype="date" style="background:white;background2:white;" text="bind:windd"/>
  306. </Band>
  307. </Format>
  308. </Formats>
  309. </Grid>
  310. <Shape id="line5" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
  311. <Static id="caption5" class="tit_2" position="absolute 0 2 85 18" style="" text="발주 내역"/>
  312. </Layout>
  313. </Layouts>
  314. </Tabpage>
  315. <Tabpage id="h602" anchor="default">
  316. <Layouts>
  317. <Layout>
  318. <Static id="caption9" class="tit_2" position="absolute 0 2 85 18" style="" text="신고 내역"/>
  319. <Shape id="line6" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
  320. <Grid id="grd_h602" binddataset="ds_main_h602" position="absolute 0 23 595 703" style="align:center ;" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_h602_grd_h602_onaftersort" anchor="all">
  321. <Formats>
  322. <Format id="default">
  323. <Columns>
  324. <Column size="0"/>
  325. <Column size="0"/>
  326. <Column size="80"/>
  327. <Column size="0"/>
  328. <Column size="195"/>
  329. <Column size="85"/>
  330. <Column size="0"/>
  331. <Column size="0"/>
  332. <Column size="0"/>
  333. <Column size="0"/>
  334. <Column size="0"/>
  335. <Column size="0"/>
  336. <Column size="80"/>
  337. <Column size="60"/>
  338. <Column size="0"/>
  339. <Column size="0"/>
  340. <Column size="0"/>
  341. <Column size="0"/>
  342. <Column size="80"/>
  343. </Columns>
  344. <Rows>
  345. <Row size="23" band="head"/>
  346. <Row size="23"/>
  347. </Rows>
  348. <Band id="head">
  349. <Cell text="기관코드"/>
  350. <Cell col="1" text="신고서구분"/>
  351. <Cell col="2" text="물품코드"/>
  352. <Cell col="3" text="신고품목코드"/>
  353. <Cell col="4" text="물품명"/>
  354. <Cell col="5" text="신청번호"/>
  355. <Cell col="6" text="줄번호"/>
  356. <Cell col="7" text="입고번호"/>
  357. <Cell col="8" text="입고순번"/>
  358. <Cell col="9" text="구입일자"/>
  359. <Cell col="10" text="구립량"/>
  360. <Cell col="11" text="구입가"/>
  361. <Cell col="12" text="개당단가"/>
  362. <Cell col="13" text="상태"/>
  363. <Cell col="14" text="최초작성자"/>
  364. <Cell col="15" text="최초작성일시"/>
  365. <Cell col="16" text="최종수정자"/>
  366. <Cell col="17" text="최종수정일시"/>
  367. <Cell col="18" text="최종수정일"/>
  368. </Band>
  369. <Band id="body">
  370. <Cell text="bind:instcd"/>
  371. <Cell col="1" text="bind:reptflag"/>
  372. <Cell col="2" style="align:left;" text="bind:goodcd"/>
  373. <Cell col="3" text="bind:appitemcd"/>
  374. <Cell col="4" style="align:left;" text="bind:itemnm"/>
  375. <Cell col="5" text="bind:appno"/>
  376. <Cell col="6" text="bind:lnno"/>
  377. <Cell col="7" text="bind:winno"/>
  378. <Cell col="8" text="bind:winseqno"/>
  379. <Cell col="9" text="bind:purcdd"/>
  380. <Cell col="10" text="bind:purcqty"/>
  381. <Cell col="11" text="bind:purcamt"/>
  382. <Cell col="12" displaytype="number" style="font:arial,9,bold;" text="bind:oneunitcost"/>
  383. <Cell col="13" text="bind:statcd"/>
  384. <Cell col="14" text="bind:fstrgstrid"/>
  385. <Cell col="15" text="bind:fstrgstdt"/>
  386. <Cell col="16" text="bind:lastupdtrid"/>
  387. <Cell col="17" text="bind:lastupdtdt"/>
  388. <Cell col="18" displaytype="date" text="bind:lastupdtdd"/>
  389. </Band>
  390. </Format>
  391. </Formats>
  392. </Grid>
  393. </Layout>
  394. </Layouts>
  395. </Tabpage>
  396. </Tabpages>
  397. </Tab>
  398. <Static id="caption1" class="tit_1" position="absolute 0 0 247 25" style="" text="재료 수가 변경 내역 조회"/>
  399. <Grid id="grd_mech" binddataset="ds_main_mech" position="absolute 0 104 595 771" style="" oncellclick="grd_mech_oncellclick" onaftersort="grd_mech_onaftersort" anchor="left top bottom" cellmovingtype="col" cellsizingtype="col">
  400. <Formats>
  401. <Format id="default">
  402. <Columns>
  403. <Column size="0"/>
  404. <Column size="80"/>
  405. <Column size="0"/>
  406. <Column size="80"/>
  407. <Column size="200"/>
  408. <Column size="75"/>
  409. <Column size="70"/>
  410. <Column size="0"/>
  411. <Column size="75"/>
  412. <Column size="0"/>
  413. <Column size="0"/>
  414. <Column size="0"/>
  415. <Column size="0"/>
  416. <Column size="75"/>
  417. <Column size="50"/>
  418. <Column size="89"/>
  419. <Column size="100"/>
  420. </Columns>
  421. <Rows>
  422. <Row size="23" band="head"/>
  423. <Row size="23"/>
  424. </Rows>
  425. <Band id="head">
  426. <Cell text="기관코드"/>
  427. <Cell col="1" text="수가코드"/>
  428. <Cell col="2" text="EDI코드"/>
  429. <Cell col="3" text="EDI코드"/>
  430. <Cell col="4" text="수가명"/>
  431. <Cell col="5" text="보험급비1"/>
  432. <Cell col="6" text="적용일자"/>
  433. <Cell col="7" text="수가종료일"/>
  434. <Cell col="8" text="보험가"/>
  435. <Cell col="9" text="최초작성자"/>
  436. <Cell col="10" text="최초작성일"/>
  437. <Cell col="11" text="최종수정자"/>
  438. <Cell col="12" text="최종수정일"/>
  439. <Cell col="13" text="자보가"/>
  440. <Cell col="14" text="무산정"/>
  441. <Cell col="15" text="처방입력구분"/>
  442. <Cell col="16" displaytype="normal" edittype="none" text="원내원외"/>
  443. </Band>
  444. <Band id="body">
  445. <Cell text="bind:instcd"/>
  446. <Cell col="1" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:calcscorcd"/>
  447. <Cell col="2" style="background:#ffffffff;background2:#ffffffff;" text="bind:insuedicd"/>
  448. <Cell col="3" text="bind:insuedicd"/>
  449. <Cell col="4" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:hngnm"/>
  450. <Cell col="5" displaytype="combo" edittype="combo" style="align:center;" text="bind:insupynpy1" combodataset="ds_init_P0104list_P0104" combocodecol="cdid" combodatacol="cdnm"/>
  451. <Cell col="6" displaytype="date" style="background:#ffffffff;background2:#ffffffff;" text="bind:fromdd"/>
  452. <Cell col="7" style="background:#ffffffff;background2:#ffffffff;" text="bind:todd"/>
  453. <Cell col="8" displaytype="number" style="background:#ffffffff;background2:#ffffffff;font:arial,9,bold;" text="bind:insurbpnt"/>
  454. <Cell col="9" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstrid"/>
  455. <Cell col="10" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstdt"/>
  456. <Cell col="11" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtrid"/>
  457. <Cell col="12" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtdt"/>
  458. <Cell col="13" displaytype="number" style="background:#ffffffff;background2:#ffffffff;font:arial,9,bold;" text="bind:autmbrbpnt"/>
  459. <Cell col="14" displaytype="number" style="align:center;background:#ffffffff;background2:#ffffffff;font:arial,9,bold;" text="bind:freeflag"/>
  460. <Cell col="15" displaytype="combo" style="align:center;" text="bind:ordinptflag" combodataset="ds_init_P0141list_P0141" combocodecol="cdid" combodatacol="cdnm"/>
  461. <Cell col="16" displaytype="combo" text="bind:hosinflag" combodataset="ds_init_A0601list_A0601" combocodecol="cdid" combodatacol="cdnm"/>
  462. </Band>
  463. </Format>
  464. </Formats>
  465. </Grid>
  466. <Static id="caption6" class="tit_2" position="absolute 0 80 90 96" style="" text="재료 수가"/>
  467. <Shape id="line3" class="line_10" linetype="horizontal" position="absolute 0 100 595 103" style="" anchor="default"/>
  468. <Static id="cap_rowcnt" position="absolute 371 76 486 95" style="color:#808080ff;align:right;font:Dotum,9,bold;"/>
  469. <Div id="Div00" taborder="14" position="absolute 0 25 1195 67" class="div_SA" anchor="left top right">
  470. <Layouts>
  471. <Layout width="982" height="68">
  472. <Static id="caption3" text="적용일자 :" class="search_name" position="absolute 6 14 84 31" anchor="left top"/>
  473. <Button id="btn_excel" taborder="2" text="엑셀저장" onclick="btn_excel_onclick" class="btn7" position="absolute 1107 13 1183 32" anchor="top right" visible="false"/>
  474. <Shape id="line7" linetype="vertical" position="absolute 1022 10 1025 35" style="border: solid #FFD799 #FFD799;" anchor="top right"/>
  475. <Button id="btnSearch" taborder="3" text="조회" onclick="btnSearch_onclick" class="btn1" position="absolute 1041 11 1097 33" anchor="top right"/>
  476. <Grid id="grd_target" taborder="4" binddataset="ds_init_target" useinputpanel="false" oncellclick="grd_target_oncellclick" position="absolute 766 9 1052 31" style="background:#ffffff ;" anchor="left top" autofittype="col" selecttype="multiarea" scrollbars="none" visible="false">
  477. <Formats>
  478. <Format id="default">
  479. <Columns>
  480. <Column size="50"/>
  481. <Column size="50"/>
  482. <Column size="50"/>
  483. <Column size="50"/>
  484. <Column size="50"/>
  485. </Columns>
  486. <Rows>
  487. <Row size="22"/>
  488. </Rows>
  489. <Band id="body">
  490. <Cell style="font:arial,9,bold;" text="bind:cont"/>
  491. <Cell col="1" style="font:arial,9,bold;" text="bind:wchk"/>
  492. <Cell col="2" style="font:arial,9,bold;" text="bind:pur"/>
  493. <Cell col="3" style="font:arial,9,bold;" text="bind:h604"/>
  494. <Cell col="4" style="font:arial,9,bold;" text="bind:h602"/>
  495. </Band>
  496. </Format>
  497. </Formats>
  498. </Grid>
  499. <Calendar id="ipt_fromdd" taborder="6" class="input_search" position="absolute 84 12 174 31" mask="yyyy-mm-dd" anchor="left top" dateformat="yyyy-MM-dd" value="null"/>
  500. <Combo id="Combo00" taborder="7" text="Combo00" position="absolute 245 12 315 32" codecolumn="codecolumn" datacolumn="datacolumn">
  501. <Dataset id="innerdataset">
  502. <ColumnInfo>
  503. <Column id="codecolumn" size="256"/>
  504. <Column id="datacolumn" size="256"/>
  505. </ColumnInfo>
  506. <Rows>
  507. <Row>
  508. <Col id="codecolumn"/>
  509. <Col id="datacolumn">전체</Col>
  510. </Row>
  511. <Row>
  512. <Col id="codecolumn">1</Col>
  513. <Col id="datacolumn">재료</Col>
  514. </Row>
  515. <Row>
  516. <Col id="codecolumn">4</Col>
  517. <Col id="datacolumn">약제</Col>
  518. </Row>
  519. </Rows>
  520. </Dataset>
  521. </Combo>
  522. <Static id="caption00" text="구분 :" class="search_name" position="absolute 193 14 243 31" anchor="left top"/>
  523. <Static id="caption01" text="수가코드 :" class="search_name" position="absolute 344 14 418 31" anchor="left top"/>
  524. <Static id="caption02" text="EDI코드 :" class="search_name" position="absolute 549 14 619 31" anchor="left top"/>
  525. <Edit id="Edit00" taborder="8" position="absolute 420 12 520 32" inputmode="upper"/>
  526. <Edit id="Edit01" taborder="9" position="absolute 623 12 723 32" inputmode="upper"/>
  527. <Static id="caption04" text="급비 :" class="search_name" position="absolute 749 14 798 31" anchor="left top"/>
  528. <Combo id="Combo01" taborder="10" text="Combo01" position="absolute 798 12 928 32" innerdataset="@ds_init_P0104list_P0104" codecolumn="cdid" datacolumn="cdnm"/>
  529. </Layout>
  530. </Layouts>
  531. </Div>
  532. <Button id="Button00" taborder="15" text="엑셀저장" position="absolute 518 78 595 98" class="btn7" onclick="Button00_onclick"/>
  533. </Layout>
  534. </Layouts>
  535. <Objects>
  536. <Dataset id="ds_main_cont" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  537. <ColumnInfo>
  538. <Column id="instcd" type="STRING" size="256"/>
  539. <Column id="goodcd" type="STRING" size="256"/>
  540. <Column id="goodnm" type="STRING" size="256"/>
  541. <Column id="fromdd" type="STRING" size="256"/>
  542. <Column id="todd" type="STRING" size="256"/>
  543. <Column id="congoodunitcost" type="STRING" size="256"/>
  544. <Column id="fromconterm" type="STRING" size="256"/>
  545. <Column id="toconterm" type="STRING" size="256"/>
  546. <Column id="gubun" type="STRING" size="256"/>
  547. <Column id="lastupdtdt" type="STRING" size="256"/>
  548. <Column id="edicd" type="STRING" size="256"/>
  549. <Column id="bginsuamt" type="STRING" size="256"/>
  550. <Column id="bgautmamt" type="STRING" size="256"/>
  551. <Column id="bgcontamt" type="STRING" size="256"/>
  552. <Column id="bgedicd" type="STRING" size="256"/>
  553. <Column id="bgcontedicd" type="STRING" size="256"/>
  554. <Column id="hosinflag" type="STRING" size="256"/>
  555. </ColumnInfo>
  556. <Rows>
  557. <Row>
  558. <Col id="instcd"/>
  559. <Col id="goodcd"/>
  560. <Col id="goodnm"/>
  561. <Col id="fromdd"/>
  562. <Col id="todd"/>
  563. <Col id="congoodunitcost"/>
  564. <Col id="fromconterm"/>
  565. <Col id="toconterm"/>
  566. <Col id="gubun"/>
  567. <Col id="lastupdtdt"/>
  568. </Row>
  569. </Rows>
  570. </Dataset>
  571. <Dataset id="ds_main_h604" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  572. <ColumnInfo>
  573. <Column id="instcd" type="STRING" size="256"/>
  574. <Column id="goodcd" type="STRING" size="256"/>
  575. <Column id="edicd" type="STRING" size="256"/>
  576. <Column id="itemnm" type="STRING" size="256"/>
  577. <Column id="appdd" type="STRING" size="256"/>
  578. <Column id="appseqno" type="STRING" size="256"/>
  579. <Column id="windd" type="STRING" size="256"/>
  580. <Column id="winqty" type="STRING" size="256"/>
  581. <Column id="winamt" type="STRING" size="256"/>
  582. <Column id="oneunitcost" type="STRING" size="256"/>
  583. <Column id="notiyn" type="STRING" size="256"/>
  584. <Column id="fstrgstrid" type="STRING" size="256"/>
  585. <Column id="fstrgstdt" type="STRING" size="256"/>
  586. <Column id="lastupdtrid" type="STRING" size="256"/>
  587. <Column id="lastupdtdt" type="STRING" size="256"/>
  588. </ColumnInfo>
  589. <Rows>
  590. <Row>
  591. <Col id="instcd"/>
  592. <Col id="goodcd"/>
  593. <Col id="edicd"/>
  594. <Col id="itemnm"/>
  595. <Col id="appdd"/>
  596. <Col id="appseqno"/>
  597. <Col id="windd"/>
  598. <Col id="winqty"/>
  599. <Col id="winamt"/>
  600. <Col id="oneunitcost"/>
  601. <Col id="notiyn"/>
  602. <Col id="fstrgstrid"/>
  603. <Col id="fstrgstdt"/>
  604. <Col id="lastupdtrid"/>
  605. <Col id="lastupdtdt"/>
  606. </Row>
  607. </Rows>
  608. </Dataset>
  609. <Dataset id="ds_init_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  610. <ColumnInfo>
  611. <Column id="cont" type="STRING" size="256"/>
  612. <Column id="wchk" type="STRING" size="256"/>
  613. <Column id="pur" type="STRING" size="256"/>
  614. <Column id="h604" type="STRING" size="256"/>
  615. <Column id="h602" type="STRING" size="256"/>
  616. </ColumnInfo>
  617. <Rows>
  618. <Row>
  619. <Col id="cont">계약</Col>
  620. <Col id="wchk">검수</Col>
  621. <Col id="pur">입고</Col>
  622. <Col id="h604">집계</Col>
  623. <Col id="h602">신고</Col>
  624. </Row>
  625. </Rows>
  626. </Dataset>
  627. <Dataset id="ds_main_pur" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  628. <ColumnInfo>
  629. <Column id="instcd" type="STRING" size="256"/>
  630. <Column id="kwanri_gubun" type="STRING" size="256"/>
  631. <Column id="pum_code" type="STRING" size="256"/>
  632. <Column id="pum_name" type="STRING" size="256"/>
  633. <Column id="ky_ymd" type="STRING" size="256"/>
  634. <Column id="ky_seq" type="STRING" size="256"/>
  635. <Column id="ibgo_ymd" type="STRING" size="256"/>
  636. <Column id="ibgo_seq" type="STRING" size="256"/>
  637. <Column id="qty" type="STRING" size="256"/>
  638. <Column id="danga1" type="STRING" size="256"/>
  639. <Column id="keumak" type="STRING" size="256"/>
  640. <Column id="chul_buseo" type="STRING" size="256"/>
  641. <Column id="user_id" type="STRING" size="256"/>
  642. <Column id="sys_date" type="STRING" size="256"/>
  643. <Column id="upd_date" type="STRING" size="256"/>
  644. </ColumnInfo>
  645. <Rows>
  646. <Row>
  647. <Col id="instcd"/>
  648. <Col id="kwanri_gubun"/>
  649. <Col id="pum_code"/>
  650. <Col id="pum_name"/>
  651. <Col id="ky_ymd"/>
  652. <Col id="ky_seq"/>
  653. <Col id="ibgo_ymd"/>
  654. <Col id="ibgo_seq"/>
  655. <Col id="qty"/>
  656. <Col id="danga1"/>
  657. <Col id="keumak"/>
  658. <Col id="chul_buseo"/>
  659. <Col id="user_id"/>
  660. <Col id="sys_date"/>
  661. <Col id="upd_date"/>
  662. </Row>
  663. </Rows>
  664. </Dataset>
  665. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  666. <ColumnInfo>
  667. <Column id="basedd" type="STRING" size="256"/>
  668. <Column id="matractflag" type="STRING" size="256"/>
  669. <Column id="srchflag" type="STRING" size="256"/>
  670. <Column id="calcscorcd" type="STRING" size="256"/>
  671. <Column id="insuedicd" type="STRING" size="256"/>
  672. <Column id="insupynpy1" type="STRING" size="256"/>
  673. </ColumnInfo>
  674. <Rows>
  675. <Row>
  676. <Col id="basedd"/>
  677. <Col id="matractflag"/>
  678. <Col id="srchflag"/>
  679. </Row>
  680. </Rows>
  681. </Dataset>
  682. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  683. <ColumnInfo/>
  684. </Dataset>
  685. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  686. <ColumnInfo/>
  687. </Dataset>
  688. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  689. <ColumnInfo>
  690. <Column id="rowcnt" type="STRING" size="256"/>
  691. </ColumnInfo>
  692. <Rows>
  693. <Row>
  694. <Col id="rowcnt"/>
  695. </Row>
  696. </Rows>
  697. </Dataset>
  698. <Dataset id="ds_main_mech" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  699. <ColumnInfo>
  700. <Column id="instcd" type="STRING" size="256"/>
  701. <Column id="calcscorcd" type="STRING" size="256"/>
  702. <Column id="insuedicd" type="STRING" size="256"/>
  703. <Column id="hngnm" type="STRING" size="256"/>
  704. <Column id="fromdd" type="STRING" size="256"/>
  705. <Column id="todd" type="STRING" size="256"/>
  706. <Column id="purcamt" type="STRING" size="256"/>
  707. <Column id="gnrlrbpnt" type="STRING" size="256"/>
  708. <Column id="fstrgstrid" type="STRING" size="256"/>
  709. <Column id="fstrgstdt" type="STRING" size="256"/>
  710. <Column id="lastupdtrid" type="STRING" size="256"/>
  711. <Column id="lastupdtdt" type="STRING" size="256"/>
  712. <Column id="insupynpy1" type="STRING" size="256"/>
  713. <Column id="autmbrbpnt" type="STRING" size="256"/>
  714. <Column id="freeflag" type="STRING" size="256"/>
  715. <Column id="ordinptflag" type="STRING" size="256"/>
  716. </ColumnInfo>
  717. <Rows>
  718. <Row>
  719. <Col id="instcd"/>
  720. <Col id="calcscorcd"/>
  721. <Col id="insuedicd"/>
  722. <Col id="hngnm"/>
  723. <Col id="fromdd"/>
  724. <Col id="todd"/>
  725. <Col id="purcamt"/>
  726. <Col id="gnrlrbpnt"/>
  727. <Col id="fstrgstrid"/>
  728. <Col id="fstrgstdt"/>
  729. <Col id="lastupdtrid"/>
  730. <Col id="lastupdtdt"/>
  731. </Row>
  732. </Rows>
  733. </Dataset>
  734. <Dataset id="ds_main_wchk" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  735. <ColumnInfo>
  736. <Column id="instcd" type="STRING" size="256"/>
  737. <Column id="goodflag" type="STRING" size="256"/>
  738. <Column id="goodcd" type="STRING" size="256"/>
  739. <Column id="purcchkdd" type="STRING" size="256"/>
  740. <Column id="purcchkno" type="STRING" size="256"/>
  741. <Column id="purcchkseq" type="STRING" size="256"/>
  742. <Column id="purccondd" type="STRING" size="256"/>
  743. <Column id="purcconno" type="STRING" size="256"/>
  744. <Column id="chkqty" type="STRING" size="256"/>
  745. <Column id="chkgoodunitcost" type="STRING" size="256"/>
  746. <Column id="chkamt" type="STRING" size="256"/>
  747. <Column id="acntcd" type="STRING" size="256"/>
  748. <Column id="delivedeptcd" type="STRING" size="256"/>
  749. <Column id="fstrgstrid" type="STRING" size="256"/>
  750. <Column id="fstrgstdt" type="STRING" size="256"/>
  751. <Column id="lastupdtrid" type="STRING" size="256"/>
  752. <Column id="lastupdtdt" type="STRING" size="256"/>
  753. </ColumnInfo>
  754. <Rows>
  755. <Row>
  756. <Col id="instcd"/>
  757. <Col id="goodflag"/>
  758. <Col id="goodcd"/>
  759. <Col id="purcchkdd"/>
  760. <Col id="purcchkno"/>
  761. <Col id="purcchkseq"/>
  762. <Col id="purccondd"/>
  763. <Col id="purcconno"/>
  764. <Col id="chkqty"/>
  765. <Col id="chkgoodunitcost"/>
  766. <Col id="chkamt"/>
  767. <Col id="acntcd"/>
  768. <Col id="delivedeptcd"/>
  769. <Col id="fstrgstrid"/>
  770. <Col id="fstrgstdt"/>
  771. <Col id="lastupdtrid"/>
  772. <Col id="lastupdtdt"/>
  773. </Row>
  774. </Rows>
  775. </Dataset>
  776. <Dataset id="ds_temp_xlslist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  777. <ColumnInfo>
  778. <Column id="col1" type="STRING" size="256"/>
  779. </ColumnInfo>
  780. </Dataset>
  781. <Dataset id="ds_main_h602" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  782. <ColumnInfo>
  783. <Column id="instcd" type="STRING" size="256"/>
  784. <Column id="goodcd" type="STRING" size="256"/>
  785. <Column id="appitemcd" type="STRING" size="256"/>
  786. <Column id="itemnm" type="STRING" size="256"/>
  787. <Column id="appno" type="STRING" size="256"/>
  788. <Column id="reptflag" type="STRING" size="256"/>
  789. <Column id="lnno" type="STRING" size="256"/>
  790. <Column id="winno" type="STRING" size="256"/>
  791. <Column id="winseqno" type="STRING" size="256"/>
  792. <Column id="purcdd" type="STRING" size="256"/>
  793. <Column id="purcqty" type="STRING" size="256"/>
  794. <Column id="purcamt" type="STRING" size="256"/>
  795. <Column id="oneunitcost" type="STRING" size="256"/>
  796. <Column id="statcd" type="STRING" size="256"/>
  797. <Column id="fstrgstrid" type="STRING" size="256"/>
  798. <Column id="fstrgstdt" type="STRING" size="256"/>
  799. <Column id="lastupdtrid" type="STRING" size="256"/>
  800. <Column id="lastupdtdt" type="STRING" size="256"/>
  801. </ColumnInfo>
  802. <Rows>
  803. <Row>
  804. <Col id="instcd"/>
  805. <Col id="goodcd"/>
  806. <Col id="appitemcd"/>
  807. <Col id="itemnm"/>
  808. <Col id="appno"/>
  809. <Col id="reptflag"/>
  810. <Col id="lnno"/>
  811. <Col id="winno"/>
  812. <Col id="winseqno"/>
  813. <Col id="purcdd"/>
  814. <Col id="purcqty"/>
  815. <Col id="purcamt"/>
  816. <Col id="oneunitcost"/>
  817. <Col id="statcd"/>
  818. <Col id="fstrgstrid"/>
  819. <Col id="fstrgstdt"/>
  820. <Col id="lastupdtrid"/>
  821. <Col id="lastupdtdt"/>
  822. </Row>
  823. </Rows>
  824. </Dataset>
  825. <Dataset id="ds_init_P0104list_P0104" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  826. <ColumnInfo>
  827. <Column id="P0104" type="STRING" size="256"/>
  828. </ColumnInfo>
  829. <Rows>
  830. <Row>
  831. <Col id="P0104"/>
  832. </Row>
  833. </Rows>
  834. </Dataset>
  835. <Dataset id="ds_init_A0601list_A0601" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  836. <ColumnInfo>
  837. <Column id="A0601" type="STRING" size="256"/>
  838. </ColumnInfo>
  839. <Rows>
  840. <Row>
  841. <Col id="A0601"/>
  842. </Row>
  843. </Rows>
  844. </Dataset>
  845. <Dataset id="ds_init_P0141list_P0141" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  846. <ColumnInfo>
  847. <Column id="P0141" type="STRING" size="256"/>
  848. </ColumnInfo>
  849. <Rows>
  850. <Row>
  851. <Col id="P0141"/>
  852. </Row>
  853. </Rows>
  854. </Dataset>
  855. </Objects>
  856. <Bind>
  857. <BindItem id="item2" compid="cap_rowcnt" propid="value" datasetid="ds_hidden" columnid="rowcnt"/>
  858. <BindItem id="item0" compid="Div00.ipt_fromdd" propid="value" datasetid="ds_send" columnid="basedd"/>
  859. <BindItem id="item3" compid="cap_rowcnt" propid="text" datasetid="ds_hidden" columnid="rowcnt"/>
  860. <BindItem id="item1" compid="Div00.Combo00" propid="value" datasetid="ds_send" columnid="matractflag"/>
  861. <BindItem id="item4" compid="Div00.Edit00" propid="value" datasetid="ds_send" columnid="calcscorcd"/>
  862. <BindItem id="item5" compid="Div00.Edit01" propid="value" datasetid="ds_send" columnid="insuedicd"/>
  863. <BindItem id="item6" compid="Div00.Combo01" propid="value" datasetid="ds_send" columnid="insupynpy1"/>
  864. </Bind>
  865. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  866. * System Name :
  867. * Job Name :
  868. * Creator :
  869. * Make Date : 2016-10-07
  870. * Description :
  871. *---------------------------------------------------------------------------------------
  872. * Modify Date Modifier Modify Description
  873. *---------------------------------------------------------------------------------------
  874. * 2016-10-07 Live Converter TF->XP
  875. *
  876. *---------------------------------------------------------------------------------------
  877. ****************************************************************************************/
  878. include "com_commonxp::comm_main.xjs";
  879. include "com_basiccodexp::ZBC001.xjs";
  880. function SPPIE04210_onload(obj:Form, e:LoadEventInfo) {
  881. frmf_initForm(obj);
  882. grdf_initGrid(grd_mech);
  883. grdf_setToolTipBind(grd_mech);
  884. grdf_initGrid(switch1.cont.grd_cont);
  885. grdf_setToolTipBind(switch1.cont.grd_cont);
  886. grdf_initGrid(switch1.wchk.grd_wchk);
  887. grdf_setToolTipBind(switch1.wchk.grd_wchk);
  888. grdf_initGrid(switch1.pur.grd_pur);
  889. grdf_setToolTipBind(switch1.pur.grd_pur);
  890. grdf_initGrid(switch1.h602.grd_h602);
  891. grdf_setToolTipBind(switch1.h602.grd_h602);
  892. grdf_initGrid(switch1.h604.grd_h604);
  893. grdf_setToolTipBind(switch1.h604.grd_h604);
  894. switch1.tabindex = 0;
  895. ds_send.setColumn( 0, "srchflag", "cont");
  896. ds_send.setColumn( 0, "basedd", utlf_getCurrentDate());
  897. //원무사용 기초코드 조회 cache기능 추가 오류심할시 위 주석으로 대체할것
  898. var arrParam1 = [
  899. { dsNm: "ds_init_A0601list_A0601", cdGrpId: "A0601" },
  900. { dsNm: "ds_init_P0104list_P0104", cdGrpId: "P0104" },
  901. { dsNm: "ds_init_P0141list_P0141", cdGrpId: "P0141" }
  902. ];
  903. zbcfGetCodeList(arrParam1);
  904. }
  905. function grd_mech_oncellclick(obj:Grid, e:GridClickEventInfo) {
  906. if (e.row < 0) {
  907. return;
  908. }
  909. var calcscorcd = ds_main_mech.getColumn(e.row, "calcscorcd");
  910. var flag = ds_send.getColumn(0, "srchflag");
  911. var grd = eval("ds_main_" + flag);
  912. var grd_obj = eval("switch1."+flag).components["grd_" + flag];
  913. var row = grd.findRow("goodcd", calcscorcd);
  914. if (row > -1) {
  915. grd.rowposition = row;
  916. grd_obj.vscrollbar.pos = row - 5;
  917. } else {
  918. grd.rowposition = -1;
  919. }
  920. }
  921. function switch1_cont_grd_cont_oncellclick(obj:Grid, e:GridClickEventInfo) {
  922. var goodcd = obj.getCellValue(e.row, 2);
  923. var row = ds_main_mech.findRow("calcscorcd", goodcd);
  924. if (row > -1) {
  925. ds_main_mech.rowposition = row;
  926. grd_mech.vscrollbar.pos = row - 5;
  927. } else {
  928. ds_main_mech.rowposition = -1;
  929. }
  930. }
  931. function grd_target_oncellclick(obj:Grid, e:GridClickEventInfo) {
  932. var flag = obj.getCellProperty("body", e.col, "text").split(":")[1];
  933. ds_send.setColumn( 0, "srchflag", flag);
  934. switch1.tabindex = e.col;
  935. }
  936. function btnSearch_onclick(obj:Button, e:ClickEventInfo) {
  937. var oParam = {};
  938. oParam.id = "TRPIE04301";
  939. oParam.service = "edimngtapp.EdiMngt";
  940. oParam.method = "reqGetCompareMatr";
  941. oParam.inds = "req=ds_send";
  942. oParam.outds = "ds_main_mech=mech ds_main_cont=cont ds_main_wchk=wchk ds_main_pur=pur ds_main_h604=h604 ds_main_h602=h602";
  943. oParam.async = false;
  944. //oParam.callback = "cf_TRPIE04301";
  945. tranf_submit(oParam);
  946. ds_hidden.setColumn( 0, "rowcnt", "Count : " + ds_main_mech.rowcount);
  947. }
  948. function btn_excel_onclick(obj:Button, e:ClickEventInfo) {
  949. var flag = ds_send.getColumn(0, "srchflag");
  950. var sGrd = "grd_mech,switch1."+flag+".grd_"+flag;
  951. var sSheet = "GridSheetTest,GridSheetTest2";
  952. grdf_exportExcelMulti(sGrd, "재료수가변경내역_" + "수가 vs " + ds_init_target.getColumn(0,flag), sSheet);
  953. sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
  954. // var flag = ds_send.getColumn(0, "srchflag");
  955. //
  956. // var fileName = window.fileDialog("save", ",", false, "재료수가변경내역_" + "수가 vs " + model.getValue("ds_init_target/" + flag) + "_" + utlf_getCurrentDate(), "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  957. //
  958. // if (fileName == "") {
  959. // return;
  960. // }
  961. //
  962. // var grd = document.controls("grd_" + flag);
  963. //
  964. // ds_temp_xlslist.clearData(); ds_temp_xlslist.addRow();
  965. //
  966. // var cols = grd_xls.cols;
  967. // if (cols > 0) {
  968. // for (var i = 0; i < cols; i++) {
  969. // grd_xls.removeColumn(false);
  970. // }
  971. // }
  972. //
  973. // ds_temp_xlslist.clearData();
  974. // dsf_makeValue( ds_temp, "xlslist", "string", "" );
  975. //
  976. // var colArr = new Array();
  977. // var idx1 = 0;
  978. // var capArr = grd_mech.caption.split("^");
  979. // var cap = "";
  980. // var wArr = new Array();
  981. //
  982. // for (var i = 0; i < grd_mech.cols; i++) {
  983. // if (!grd_mech.colHidden(i)) {
  984. // colArr[idx1] = grd_mech.colAttribute(i, "ref");
  985. // cap += capArr[i] + "^";
  986. // wArr[idx1] = Math.round(grd_mech.colWidth(i) * 1.2);
  987. // idx1++;
  988. // }
  989. // }
  990. //
  991. // cap+= "VS^";
  992. // colArr[idx1] = "blank";
  993. // wArr[idx1] = 100;
  994. //
  995. // var idx2 = idx1 + 1;
  996. // capArr = grd.caption.split("^");
  997. // for (var i = 0; i < grd.cols; i++) {
  998. // if (!grd.colHidden(i)) {
  999. // colArr[idx2] = "t" + grd.colAttribute(i, "ref");
  1000. // cap += capArr[i] + "^";
  1001. // wArr[idx2] = Math.round(grd.colWidth(i) * 1.2);
  1002. // idx2++;
  1003. // }
  1004. // }
  1005. //
  1006. // cap = cap.substr(0, cap.length - 1);
  1007. //
  1008. // for (var i = 0; i < colArr.length; i++) {
  1009. // grd_xls.addColumn("ref:" + colArr[i] + "; type:output; ", false);
  1010. // grd_xls.colWidth(i) = wArr[i];
  1011. // }
  1012. // grd_xls.caption = cap;
  1013. //
  1014. // var cnt = instance1.selectNodes("ds_main_mech").length;
  1015. // for (var i = 1; i <= cnt; i++) {
  1016. // for (var j = 0; j < colArr.length; j++) {
  1017. //
  1018. // if (j == idx1) {
  1019. // continue;
  1020. // }
  1021. //
  1022. // if (j < idx1) {
  1023. // model.makeValue("ds_temp_xlslist[" + i + "]/" + colArr[j], model.getValue("ds_main_mech[" + i + "]/" + colArr[j]));
  1024. // } else {
  1025. // var ref = colArr[j].substr(1, colArr[j].length - 1);
  1026. // model.makeValue("ds_temp_xlslist[" + i + "]/" + colArr[j], model.getValue("ds_main/" + flag + "[" + i + "]/" + ref));
  1027. // }
  1028. // }
  1029. // }
  1030. //
  1031. // //grd_xls.refresh();
  1032. //
  1033. // grd_xls.saveExcel(fileName, "sheetname:수가 vs " + model.getValue("ds_init_target/" + flag) + ";colhiddenextend:false;rowhiddenextend:false");
  1034. // sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
  1035. //
  1036. }
  1037. // 수가정보 엑셀저장
  1038. function Button00_onclick(obj:Button, e:ClickEventInfo)
  1039. {
  1040. grdf_exportExcel(grd_mech, "재료수가자료", "see");
  1041. }
  1042. // 물류정보 엑셀저장
  1043. function switch1_cont_Button00_onclick(obj:Button, e:ClickEventInfo)
  1044. {
  1045. grdf_exportExcel(switch1.cont.grd_cont, "계약내역자료", "see");
  1046. }
  1047. ]]></Script>
  1048. </Form>
  1049. </FDL>