SMRSC03801_물품코드 Master Excel등록.xrw 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>물품코드 일괄등록</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <list>
  11. <goodexcelmap>
  12. <goodexcelmaplist/>
  13. </goodexcelmap>
  14. <rscdexcel>
  15. <rscdexcellist/>
  16. </rscdexcel>
  17. </list>
  18. <ExcelLists>
  19. <ExcelList/>
  20. </ExcelLists>
  21. <ExlMasterLists>
  22. <exlmasterlist/>
  23. </ExlMasterLists>
  24. <ExlAllsizeLists>
  25. <exlallsizelist/>
  26. </ExlAllsizeLists>
  27. <ExlOldnewLists>
  28. <exloldnewlist/>
  29. </ExlOldnewLists>
  30. <ExcelInstLists>
  31. <ExcelInstList/>
  32. </ExcelInstLists>
  33. </main>
  34. <target>
  35. <defaultvalue/>
  36. </target>
  37. <init>
  38. <CompareData>
  39. <goodcd/>
  40. <goodflag/>
  41. <goodnm/>
  42. <goodhngnm/>
  43. <goodengnm/>
  44. <goodspec/>
  45. <goodmodel/>
  46. <asetflag/>
  47. <lrgcd/>
  48. <lrgnm/>
  49. <mdlcd/>
  50. <mdlnm/>
  51. <smlcd/>
  52. <smlnm/>
  53. <edicd/>
  54. <prodcmpycd/>
  55. <prodcmpynm/>
  56. <cmt/>
  57. <goodcd_2/>
  58. <goodflag_2/>
  59. <goodnm_2/>
  60. <goodhngnm_2/>
  61. <goodengnm_2/>
  62. <goodspec_2/>
  63. <goodmodel_2/>
  64. <asetflag_2/>
  65. <lrgcd_2/>
  66. <lrgnm_2/>
  67. <mdlcd_2/>
  68. <mdlnm_2/>
  69. <smlcd_2/>
  70. <smlnm_2/>
  71. <edicd_2/>
  72. <prodcmpycd_2/>
  73. <prodcmpynm_2/>
  74. <cmt_2/>
  75. </CompareData>
  76. <keepmthd>
  77. <label>실온</label>
  78. <value>1</value>
  79. <label>냉소</label>
  80. <value>2</value>
  81. <label>냉장</label>
  82. <value>3</value>
  83. <label>냉동</label>
  84. <value>4</value>
  85. </keepmthd>
  86. <gnrlspcl>
  87. <label>전문</label>
  88. <value>1</value>
  89. <label>일반</label>
  90. <value>2</value>
  91. <label>공산품</label>
  92. <value>3</value>
  93. <label>의약외품</label>
  94. <value>4</value>
  95. <label>기타</label>
  96. <value>5</value>
  97. </gnrlspcl>
  98. <useyn>
  99. <label>사용</label>
  100. <value>Y</value>
  101. <label>불용</label>
  102. <value>N</value>
  103. </useyn>
  104. <popmenu>
  105. <grd_excelmaplist>
  106. <item>
  107. <name>품명일괄변경</name>
  108. <func>fSetGoodnm</func>
  109. </item>
  110. <item>
  111. <name>규격일괄변경</name>
  112. <func>fSetGoodSpec</func>
  113. </item>
  114. <item>
  115. <name>모델일괄변경</name>
  116. <func>fSetGoodModel</func>
  117. </item>
  118. <item>
  119. <name>제조회사일괄변경</name>
  120. <func>fSetGoodProdCmpy</func>
  121. </item>
  122. <item>
  123. <name>-</name>
  124. <func/>
  125. </item>
  126. <item>
  127. <name>포장단위일괄변경</name>
  128. <func>fSetPurcUnit</func>
  129. </item>
  130. <item>
  131. <name>환산수량일괄변경</name>
  132. <func>fSetExchQty</func>
  133. </item>
  134. <item>
  135. <name>수불단위일괄변경</name>
  136. <func>fSetDeliveUnit</func>
  137. </item>
  138. <item>
  139. <name>-</name>
  140. <func/>
  141. </item>
  142. <item>
  143. <name>단가일괄변경</name>
  144. <func>fSetGoodUnitCost</func>
  145. </item>
  146. <item>
  147. <name>-</name>
  148. <func/>
  149. </item>
  150. <item>
  151. <name>주거래처일괄변경</name>
  152. <func>fSetMainCustLastSuplplce</func>
  153. </item>
  154. <item>
  155. <name>판매회사일괄변경</name>
  156. <func>fSetSuppCustCd</func>
  157. </item>
  158. <item>
  159. <name>-</name>
  160. <func/>
  161. </item>
  162. <item>
  163. <name>분류코드일괄변경</name>
  164. <func>fSetLargeCd</func>
  165. </item>
  166. </grd_excelmaplist>
  167. </popmenu>
  168. <popinputcd/>
  169. <popinputnm/>
  170. <poptitle/>
  171. <popcond/>
  172. <popformat/>
  173. <purcunit/>
  174. <prcpunit/>
  175. <iopsnflag>
  176. <label>내자</label>
  177. <value>1</value>
  178. <label>외자</label>
  179. <value>2</value>
  180. </iopsnflag>
  181. <lrgcd/>
  182. <mdlcd/>
  183. <smlcd/>
  184. <workflag>
  185. <label>전체</label>
  186. <value/>
  187. <label>신규</label>
  188. <value>I</value>
  189. <label>변경</label>
  190. <value>U</value>
  191. </workflag>
  192. <saveyn>
  193. <label>전체</label>
  194. <value/>
  195. <label>저장</label>
  196. <value>Y</value>
  197. <label>미저장</label>
  198. <value>N</value>
  199. </saveyn>
  200. <delyn>
  201. <label>전체</label>
  202. <value/>
  203. <label>삭제</label>
  204. <value>Y</value>
  205. <label>미삭제</label>
  206. <value>N</value>
  207. </delyn>
  208. <CopyGoodList>
  209. <goodcd/>
  210. <goodflag/>
  211. <goodnm/>
  212. <goodspec/>
  213. <goodmodel/>
  214. <asetflag/>
  215. <lrgcd/>
  216. <mdlcd/>
  217. <smlcd/>
  218. <edicd/>
  219. <prodcmpycd/>
  220. <prodcmpynm/>
  221. </CopyGoodList>
  222. <CopySizeList>
  223. <goodcd/>
  224. <goodnm/>
  225. <allsizespecid/>
  226. <goodspec/>
  227. </CopySizeList>
  228. <CopyMapList>
  229. <ngoodcd/>
  230. <ogoodcd/>
  231. <goodnm/>
  232. </CopyMapList>
  233. </init>
  234. <send>
  235. <save>
  236. <rscdexcellist/>
  237. <goodexcelmaplist>
  238. <setautoins>
  239. <setyn>N</setyn>
  240. <insfromdd/>
  241. </setautoins>
  242. </goodexcelmaplist>
  243. </save>
  244. <searchlist>
  245. <instcd/>
  246. <goodflag/>
  247. <workflag/>
  248. <saveyn/>
  249. <delyn/>
  250. </searchlist>
  251. <copydata/>
  252. <selectcond>
  253. <instcd/>
  254. <goodflag/>
  255. <workflag/>
  256. <saveyn/>
  257. <delyn/>
  258. <goodcd/>
  259. <ogoodcd/>
  260. </selectcond>
  261. </send>
  262. <temp/>
  263. <CopyData>
  264. <CopyGoodLists>
  265. <CopyGoodList>
  266. <goodcd/>
  267. <goodflag/>
  268. <goodnm/>
  269. <goodspec/>
  270. <goodmodel/>
  271. <asetflag/>
  272. <lrgcd/>
  273. <mdlcd/>
  274. <smlcd/>
  275. <edicd/>
  276. <prodcmpycd/>
  277. <prodcmpynm/>
  278. </CopyGoodList>
  279. </CopyGoodLists>
  280. <CopySizeLists>
  281. <CopySizeList>
  282. <goodcd/>
  283. <goodnm/>
  284. <allsizespecid/>
  285. <goodspec/>
  286. </CopySizeList>
  287. </CopySizeLists>
  288. <CopyMapLists>
  289. <CopyMapList>
  290. <ngoodcd/>
  291. <ogoodcd/>
  292. <goodnm/>
  293. </CopyMapList>
  294. </CopyMapLists>
  295. <CopyCond>
  296. <mastercls/>
  297. <allsizecls/>
  298. <oldnewcls/>
  299. <titleyn>T</titleyn>
  300. </CopyCond>
  301. </CopyData>
  302. </root>
  303. </instance>
  304. <bind id="bind1" ref="/root/main/list/goodexcelmap/goodexcelmaplist/workflag" readonly="../saveyn = 'Y'"/>
  305. <bind id="bind2" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodcd" readonly="../saveyn = 'Y'"/>
  306. <bind id="bind3" ref="/root/main/list/goodexcelmap/goodexcelmaplist/fromdd" readonly="../saveyn = 'Y'"/>
  307. <bind id="bind4" ref="/root/main/list/goodexcelmap/goodexcelmaplist/instcd" readonly="../saveyn = 'Y'"/>
  308. <bind id="bind5" ref="/root/main/list/goodexcelmap/goodexcelmaplist/todd" readonly="../saveyn = 'Y'"/>
  309. <bind id="bind6" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodnm" readonly="../saveyn = 'Y'"/>
  310. <bind id="bind7" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodengnm" readonly="../saveyn = 'Y'"/>
  311. <bind id="bind8" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodspec" readonly="../saveyn = 'Y'"/>
  312. <bind id="bind9" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodmodel" readonly="../saveyn = 'Y'"/>
  313. <bind id="bind10" ref="/root/main/list/goodexcelmap/goodexcelmaplist/lrgcd" readonly="../saveyn = 'Y'"/>
  314. <bind id="bind11" ref="/root/main/list/goodexcelmap/goodexcelmaplist/lrgnm" readonly="../saveyn = 'Y'"/>
  315. <bind id="bind12" ref="/root/main/list/goodexcelmap/goodexcelmaplist/mdlcd" readonly="../saveyn = 'Y'"/>
  316. <bind id="bind13" ref="/root/main/list/goodexcelmap/goodexcelmaplist/mdlnm" readonly="../saveyn = 'Y'"/>
  317. <bind id="bind14" ref="/root/main/list/goodexcelmap/goodexcelmaplist/smlcd" readonly="../saveyn = 'Y'"/>
  318. <bind id="bind15" ref="/root/main/list/goodexcelmap/goodexcelmaplist/smlnm" readonly="../saveyn = 'Y'"/>
  319. <bind id="bind16" ref="/root/main/list/goodexcelmap/goodexcelmaplist/oldcd" readonly="../saveyn = 'Y'"/>
  320. <bind id="bind17" ref="/root/main/list/goodexcelmap/goodexcelmaplist/winacnt" readonly="../saveyn = 'Y'"/>
  321. <bind id="bind18" ref="/root/main/list/goodexcelmap/goodexcelmaplist/winacntnm" readonly="../saveyn = 'Y'"/>
  322. <bind id="bind19" ref="/root/main/list/goodexcelmap/goodexcelmaplist/amtacnt" readonly="../saveyn = 'Y'"/>
  323. <bind id="bind20" ref="/root/main/list/goodexcelmap/goodexcelmaplist/amtacntnm" readonly="../saveyn = 'Y'"/>
  324. <bind id="bind21" ref="/root/main/list/goodexcelmap/goodexcelmaplist/mainmngtdeptcd" readonly="../saveyn = 'Y'"/>
  325. <bind id="bind22" ref="/root/main/list/goodexcelmap/goodexcelmaplist/mainmngtdeptnm" readonly="../saveyn = 'Y'"/>
  326. <bind id="bind23" ref="/root/main/list/goodexcelmap/goodexcelmaplist/mainusedeptcd" readonly="../saveyn = 'Y'"/>
  327. <bind id="bind24" ref="/root/main/list/goodexcelmap/goodexcelmaplist/mainusedeptnm" readonly="../saveyn = 'Y'"/>
  328. <bind id="bind25" ref="/root/main/list/goodexcelmap/goodexcelmaplist/stocmngtflag" readonly="../saveyn = 'Y'"/>
  329. <bind id="bind26" ref="/root/main/list/goodexcelmap/goodexcelmaplist/purcunit" readonly="../saveyn = 'Y'"/>
  330. <bind id="bind27" ref="/root/main/list/goodexcelmap/goodexcelmaplist/deliveunit" readonly="../saveyn = 'Y'"/>
  331. <bind id="bind28" ref="/root/main/list/goodexcelmap/goodexcelmaplist/exchqty" readonly="../saveyn = 'Y'"/>
  332. <bind id="bind29" ref="/root/main/list/goodexcelmap/goodexcelmaplist/edicd" readonly="../saveyn = 'Y'"/>
  333. <bind id="bind30" ref="/root/main/list/goodexcelmap/goodexcelmaplist/reqflag" readonly="../saveyn = 'Y'"/>
  334. <bind id="bind31" ref="/root/main/list/goodexcelmap/goodexcelmaplist/tmpreqflag" readonly="../saveyn = 'Y'"/>
  335. <bind id="bind32" ref="/root/main/list/goodexcelmap/goodexcelmaplist/reqmthd" readonly="../saveyn = 'Y'"/>
  336. <bind id="bind33" ref="/root/main/list/goodexcelmap/goodexcelmaplist/reqprid" readonly="../saveyn = 'Y'"/>
  337. <bind id="bind34" ref="/root/main/list/goodexcelmap/goodexcelmaplist/prodplce" readonly="../saveyn = 'Y'"/>
  338. <bind id="bind35" ref="/root/main/list/goodexcelmap/goodexcelmaplist/prodcmpycd" readonly="../saveyn = 'Y'"/>
  339. <bind id="bind36" ref="/root/main/list/goodexcelmap/goodexcelmaplist/prodcmpynm" readonly="../saveyn = 'Y'"/>
  340. <bind id="bind37" ref="/root/main/list/goodexcelmap/goodexcelmaplist/maincustlastsuplplce" readonly="../saveyn = 'Y'"/>
  341. <bind id="bind38" ref="/root/main/list/goodexcelmap/goodexcelmaplist/maincustlastsuplplcenm" readonly="../saveyn = 'Y'"/>
  342. <bind id="bind39" ref="/root/main/list/goodexcelmap/goodexcelmaplist/suppcustcd" readonly="../saveyn = 'Y'"/>
  343. <bind id="bind40" ref="/root/main/list/goodexcelmap/goodexcelmaplist/suppcustnm" readonly="../saveyn = 'Y'"/>
  344. <bind id="bind41" ref="/root/main/list/goodexcelmap/goodexcelmaplist/estmamt" readonly="../saveyn = 'Y'"/>
  345. <bind id="bind42" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodunitcost" readonly="../saveyn = 'Y'"/>
  346. <bind id="bind43" ref="/root/main/list/goodexcelmap/goodexcelmaplist/purcflag" readonly="../saveyn = 'Y'"/>
  347. <bind id="bind44" ref="/root/main/list/goodexcelmap/goodexcelmaplist/allsizeyn" readonly="../saveyn = 'Y'"/>
  348. <bind id="bind45" ref="/root/main/list/goodexcelmap/goodexcelmaplist/addtaxrate" readonly="../saveyn = 'Y'"/>
  349. <bind id="bind46" ref="/root/main/list/goodexcelmap/goodexcelmaplist/bnscd" readonly="../saveyn = 'Y'"/>
  350. <bind id="bind47" ref="/root/main/list/goodexcelmap/goodexcelmaplist/cntsunit" readonly="../saveyn = 'Y'"/>
  351. <bind id="bind48" ref="/root/main/list/goodexcelmap/goodexcelmaplist/cntsqty" readonly="../saveyn = 'Y'"/>
  352. <bind id="bind49" ref="/root/main/list/goodexcelmap/goodexcelmaplist/specvol" readonly="../saveyn = 'Y'"/>
  353. <bind id="bind50" ref="/root/main/list/goodexcelmap/goodexcelmaplist/keepmthd" readonly="../saveyn = 'Y'"/>
  354. <bind id="bind51" ref="/root/main/list/goodexcelmap/goodexcelmaplist/gnrlspcl" readonly="../saveyn = 'Y'"/>
  355. <bind id="bind52" ref="/root/main/list/goodexcelmap/goodexcelmaplist/welfprt" readonly="../saveyn = 'Y'"/>
  356. <bind id="bind53" ref="/root/main/list/goodexcelmap/goodexcelmaplist/com" readonly="../saveyn = 'Y'"/>
  357. <bind id="bind54" ref="/root/main/list/goodexcelmap/goodexcelmaplist/prcpunit" readonly="../saveyn = 'Y'"/>
  358. <bind id="bind55" ref="/root/main/list/goodexcelmap/goodexcelmaplist/prcpexchqty" readonly="../saveyn = 'Y'"/>
  359. <bind id="bind56" ref="/root/main/list/goodexcelmap/goodexcelmaplist/insucost" readonly="../saveyn = 'Y'"/>
  360. <bind id="bind57" ref="/root/main/list/goodexcelmap/goodexcelmaplist/specunit" readonly="../saveyn = 'Y'"/>
  361. <bind id="bind58" ref="/root/main/list/goodexcelmap/goodexcelmaplist/pemtkeepmthd" readonly="../saveyn = 'Y'"/>
  362. <bind id="bind59" ref="/root/main/list/goodexcelmap/goodexcelmaplist/comnm" readonly="../saveyn = 'Y'"/>
  363. <bind id="bind60" ref="/root/main/list/goodexcelmap/goodexcelmaplist/purcqty" readonly="../saveyn = 'Y'"/>
  364. <bind id="bind61" ref="/root/main/list/goodexcelmap/goodexcelmaplist/prcpqty" readonly="../saveyn = 'Y'"/>
  365. <bind id="bind62" ref="/root/main/list/goodexcelmap/goodexcelmaplist/goodpurccost" readonly="../saveyn = 'Y'"/>
  366. <script type="javascript" ev:event="xforms-ready">
  367. <![CDATA[
  368. //화면 Control을 초기화한다
  369. fInitialize();
  370. ]]>
  371. </script>
  372. <!-- 입력된 Excel 데이터를 읽어오는 submmit-->
  373. <submission id="TRRSC03801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/main/list/goodexcelmap"/>
  374. <!-- Excel 데이터를 저장하는 submmit-->
  375. <submission id="TXRSC03801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save/rscdexcellist" add="bottom" resultref="/root/temp"/>
  376. <!-- 입력된 Excel 데이터를 수정하는 submmit-->
  377. <submission id="TXRSC03802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save/goodexcelmaplist" add="bottom" resultref="/root/temp"/>
  378. <!-- Master에 적용 하는 submmit ( TXRSC05302 ) 과 동일 하나 적용 후 RSCDGDEXCEL TABLE을 업데이트 하기 위해 추가 작업 함-->
  379. <submission id="TXRSC03803" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save/goodexcelmaplist" resultref="/root/hidden/temp"/>
  380. <!-- Master에 적용 하는 submmit -->
  381. <submission id="TXRSC03804" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/copydata" resultref="/root/hidden/temp"/>
  382. <submission id="TRRSC03804" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/selectcond" resultref="/root/main/ExlMasterLists"/>
  383. <submission id="TRRSC03805" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/selectcond" resultref="/root/main/ExlAllsizeLists"/>
  384. <submission id="TRRSC03806" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/selectcond" resultref="/root/main/ExlOldnewLists"/>
  385. </model>
  386. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  387. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  388. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  389. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  390. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  391. <script type="javascript" src="../../../mis/purcbaseweb/js/SMRSC03801.js"/>
  392. </xhtml:head>
  393. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  394. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  395. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:230px; height:14px; ">물품코드 일괄등록</caption>
  396. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  397. </group>
  398. <group id="group3" scroll="auto" style="left:0px; top:38px; width:1195; height:744; ">
  399. <group id="grp_title" style="left:0px; top:10px; width:1195px; height:75px; vertical-align:top; ">
  400. <shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:75px; background-color:#fffbf2; border-color:#ffd799; "/>
  401. <caption id="cap_instcd" class="search_name" style="left:15; top:8px; width:86px; height:17px; ">기관코드 :</caption>
  402. <caption id="cap_goodflag" class="search_name" style="left:364px; top:8px; width:86px; height:17px; ">물품구분 :</caption>
  403. <caption id="caption30" class="search_name" style="left:15px; top:40px; width:90px; height:17px; ">저장구분 :</caption>
  404. <caption id="cap_workflag" class="search_name" style="left:705px; top:8px; width:135px; height:17px; ">신규/변경구분 :</caption>
  405. <button id="btn_search" class="btn1_letter2" style="left:1125px; top:26px; width:56px; height:27px; ">
  406. <caption>조회</caption>
  407. <script type="javascript" ev:event="DOMActivate">
  408. <![CDATA[
  409. submit("TRRSC03804");
  410. // size 원위치
  411. // if(fCheckRetrieveData() == false)return;
  412. // misfMsterDetailRetrieve();
  413. // if(grd_excelmaplist.rows - grd_excelmaplist.fixedRows > 0)
  414. // fMapListValid( grd_excelmaplist );
  415. // setRowStyle("grd_excelmaplist", "6^2", "I^U", "workflag");
  416. // setRowStyle("grd_excelmaplist", "1", "Y", "saveyn", "equal");
  417. ]]>
  418. </script>
  419. </button>
  420. <select1 id="cmb_goodflag" ref="/root/send/searchlist/goodflag" class="combo_search" appearance="minimal" style="left:449px; top:8px; width:225px; height:19px; ">
  421. <choices>
  422. <itemset nodeset="/root/init/goodflag">
  423. <label ref="cdnm"/>
  424. <value ref="cdid"/>
  425. </itemset>
  426. </choices>
  427. <script type="javascript" ev:event="xforms-value-changed">
  428. <![CDATA[
  429. fSetGoodFlagAuth();
  430. ]]>
  431. </script>
  432. </select1>
  433. <line id="line_title" class="line_4" style="x1:1109px; y1:15px; x2:1109px; y2:60px; border-color:#ffe4bb; border-left-style:solid; "/>
  434. <select1 id="cmb_instcd" ref="/root/send/searchlist/instcd" class="combo_search" appearance="minimal" style="left:100px; top:8px; width:238px; height:19px; ">
  435. <choices>
  436. <itemset nodeset="/root/init/instcd">
  437. <label ref="cdnm"/>
  438. <value ref="cdid"/>
  439. </itemset>
  440. </choices>
  441. <script type="javascript" ev:event="xforms-value-changed">
  442. <![CDATA[
  443. misfGridInit(grd_rscdexcellist);
  444. ]]>
  445. </script>
  446. </select1>
  447. <select1 id="cmb_purcunit" ref="/root/init/purcunit" class="combo_search" visibility="hidden" appearance="minimal" style="left:945px; top:10px; width:118px; height:19px; ">
  448. <choices>
  449. <itemset nodeset="/root/init/instcd">
  450. <label ref="cdnm"/>
  451. <value ref="cdid"/>
  452. </itemset>
  453. </choices>
  454. <script type="javascript" ev:event="xforms-value-changed">
  455. <![CDATA[
  456. misfGridInit(grd_rscdexcellist);
  457. ]]>
  458. </script>
  459. </select1>
  460. <select1 id="cmb_prcpunit" ref="/root/init/prcpunit" class="combo_search" visibility="hidden" appearance="minimal" style="left:945px; top:30px; width:118px; height:19px; ">
  461. <choices>
  462. <itemset nodeset="/root/init/instcd">
  463. <label ref="cdnm"/>
  464. <value ref="cdid"/>
  465. </itemset>
  466. </choices>
  467. <script type="javascript" ev:event="xforms-value-changed">
  468. <![CDATA[
  469. misfGridInit(grd_rscdexcellist);
  470. ]]>
  471. </script>
  472. </select1>
  473. <input id="ipt_lrgcd" ref="/root/init/lrgcd" class="input_search" visibility="hidden" style="left:870px; top:30px; width:70px; height:19px; "/>
  474. <input id="ipt_mdlcd" ref="/root/init/mdlcd" class="input_search" visibility="hidden" style="left:795px; top:30px; width:70px; height:19px; "/>
  475. <input id="ipt_smlcd" ref="/root/init/smlcd" class="input_search" visibility="hidden" style="left:720px; top:30px; width:70px; height:19px; "/>
  476. <select1 id="rdo_workflag" ref="/root/send/searchlist/workflag" class="radio_search" appearance="full" cellspacing="10" cols="3" rows="1" overflow="visible" style="left:830px; top:8px; width:100px; height:20px; border-style:none; ">
  477. <choices>
  478. <itemset nodeset="/root/init/workflag">
  479. <label ref="label"/>
  480. <value ref="value"/>
  481. </itemset>
  482. </choices>
  483. </select1>
  484. <select1 id="rdo_saveyn" ref="/root/send/searchlist/saveyn" class="radio_search" appearance="full" cellspacing="10" cols="3" rows="1" overflow="visible" style="left:100px; top:40px; width:100px; height:20px; border-style:none; ">
  485. <choices>
  486. <itemset nodeset="/root/init/saveyn">
  487. <label ref="label"/>
  488. <value ref="value"/>
  489. </itemset>
  490. </choices>
  491. </select1>
  492. <caption id="caption2" class="search_name" visibility="hidden" style="left:365px; top:40px; width:90px; height:17px; ">삭제구분 :</caption>
  493. <select1 id="rdo_delyn" ref="/root/send/searchlist/delyn" class="radio_search" visibility="hidden" appearance="full" cellspacing="10" cols="3" rows="1" overflow="visible" style="left:450px; top:40px; width:100px; height:20px; border-style:none; ">
  494. <choices>
  495. <itemset nodeset="/root/init/delyn">
  496. <label ref="label"/>
  497. <value ref="value"/>
  498. </itemset>
  499. </choices>
  500. </select1>
  501. </group>
  502. <switch id="swt_select" class="sw_box" style="left:0px; top:120px; width:1195px; height:620px; border-style:solid; ">
  503. <case id="cse_costlist" style="left:0px; top:0px; width:1193px; height:620px; ">
  504. <caption id="caption8" class="tit_2" style="left:4px; top:7px; width:161px; height:13px; ">Data Mapping List</caption>
  505. <line id="line3" class="line_1" style="x1:0px; y1:24px; x2:1193px; y2:24px; "/>
  506. <button id="button1" class="btn2_letter4" style="left:1071px; top:3px; width:64px; height:19px; ">
  507. <caption>임시저장</caption>
  508. <script type="javascript" ev:event="DOMActivate">
  509. <![CDATA[
  510. if ( fCheckSaveData( grd_excelmaplist ) != false)
  511. {
  512. if ( getGridUpdateData(grd_excelmaplist) == "")
  513. {
  514. messageBox("변경 데이터가","I004");
  515. return;
  516. }
  517. misfSave("TXRSC03802");
  518. }
  519. ]]>
  520. </script>
  521. </button>
  522. <button id="btn_save" class="btn3_letter2" style="left:1013px; top:2px; width:56px; height:22px; ">
  523. <caption>저장</caption>
  524. <script type="javascript" ev:event="DOMActivate">
  525. <![CDATA[
  526. if ( fCheckSaveData( grd_excelmaplist ) == false) return;
  527. if ( fSetSaveData( grd_excelmaplist ) == false) return;
  528. // model.setValue("/root/send/save/gooddetlist", getGridUpdateData(grd_excelmaplist));
  529. misfSave("TXRSC03803");
  530. if (model.getValue(gvErrorMsgPath + "/type") != "error")
  531. btn_search.dispatch("DOMActivate");
  532. ]]>
  533. </script>
  534. </button>
  535. <button id="btn_delete" class="btn2_letter3" style="left:1138px; top:3px; width:53px; height:19px; ">
  536. <caption>행삭제</caption>
  537. <script type="javascript" ev:event="DOMActivate">
  538. <![CDATA[
  539. if( grd_excelmaplist.rows - grd_excelmaplist.fixedRows > 0 )
  540. {
  541. var tempmag = messageBox("선택한 항목을 ", "Q001");
  542. if ( tempmag == "6" ) {
  543. misfGridIUD(grd_excelmaplist, "D"); // rowStatus = 4
  544. for(currow = 0 ; currow < grd_excelmaplist.selectedRows; currow++)
  545. {
  546. // grd_excelmaplist.rowStatus(grd_excelmaplist.selectedRow(currow)) = "4";
  547. if( grd_excelmaplist.rowStatus(grd_excelmaplist.selectedRow(currow)) == "4" &&
  548. model.getValue(grd_excelmaplist.nodeset + "[" + (grd_excelmaplist.selectedRow(currow)- grd_excelmaplist.fixedRows + 1) + "]/delyn") == "N" ) {
  549. model.setValue(grd_excelmaplist.nodeset + "[" + (grd_excelmaplist.selectedRow(currow)- grd_excelmaplist.fixedRows + 1) + "]/" + "delyn", "Y"); // 대, 중, 소분류 값이 수정이 되면 오류 값을 수정처리 한다.
  550. }
  551. /*
  552. else if ( grd_excelmaplist.rowStatus(grd_excelmaplist.selectedRow(currow)) != "4" &&
  553. model.getValue(grd_excelmaplist.nodeset + "[" + (grd_excelmaplist.selectedRow(currow)- grd_excelmaplist.fixedRows + 1) + "]/delyn") == "Y" ) {
  554. model.setValue(grd_excelmaplist.nodeset + "[" + (grd_excelmaplist.selectedRow(currow)- grd_excelmaplist.fixedRows + 1) + "]/" + "delyn", "N"); // 대, 중, 소분류 값이 수정이 되면 오류 값을 수정처리 한다.
  555. }
  556. */
  557. }
  558. misfSave("TXRSC03802");
  559. }
  560. }
  561. else
  562. {
  563. messageBox("데이터가","I004");
  564. }
  565. ]]>
  566. </script>
  567. </button>
  568. <datagrid id="grd_master" nodeset="/root/main/ExlMasterLists/exlmasterlist" autoresize="true" caption="물품코드^물품구분^물품명^물품명^물품명^물품규격^모델^자산구분^대분류^대분류명^중분류^중분류명^소분류^소분류명^EDI코드^제조회사코드^제조회사명칭^비고^물품코드^물품구분^물품명^물품명^물품명^물품규격^모델^자산구분^대분류코드^대분류코드명^중분류코드^중분류코드명^소분류코드^소분류코드명^EDI코드^제조회사코드^제조회사명칭^비고" colsep="^" colwidth="85, 65, 261, 0, 0, 232, 143, 61, 60, 100, 60, 100, 46, 60, 90, 100, 118, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:30px; width:1193px; height:585px; ">
  569. <col ref="goodcd"/>
  570. <col ref="goodflag"/>
  571. <col ref="goodnm"/>
  572. <col ref="goodhngnm"/>
  573. <col ref="goodengnm"/>
  574. <col ref="goodspec"/>
  575. <col ref="goodmodel"/>
  576. <col ref="asetflag"/>
  577. <col ref="lrgcd"/>
  578. <col ref="lrgnm"/>
  579. <col ref="mdlcd"/>
  580. <col ref="mdlnm"/>
  581. <col ref="smlcd"/>
  582. <col ref="smlnm"/>
  583. <col ref="edicd"/>
  584. <col ref="prodcmpycd"/>
  585. <col ref="prodcmpynm"/>
  586. <col ref="cmt"/>
  587. <col ref="goodcd_2"/>
  588. <col ref="goodflag_2"/>
  589. <col ref="goodnm_2"/>
  590. <col ref="goodhngnm_2"/>
  591. <col ref="goodengnm_2"/>
  592. <col ref="goodspec_2"/>
  593. <col ref="goodmodel_2"/>
  594. <col ref="asetflag_2"/>
  595. <col ref="lrgcd_2"/>
  596. <col ref="lrgnm_2"/>
  597. <col ref="mdlcd_2"/>
  598. <col ref="mdlnm_2"/>
  599. <col ref="smlcd_2"/>
  600. <col ref="smlnm_2"/>
  601. <col ref="edicd_2"/>
  602. <col ref="prodcmpycd_2"/>
  603. <col ref="prodcmpynm_2"/>
  604. <col ref="cmt_2"/>
  605. <script type="javascript" ev:event="ondblclick">
  606. <![CDATA[
  607. if (grd_master.row == 0) return;
  608. fGoodDataCampare(grd_master.row);
  609. ]]>
  610. </script>
  611. </datagrid>
  612. <group id="grp_disp" visibility="hidden" style="left:600px; top:30px; width:590px; height:515px; ">
  613. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:585px; height:510px; background-color:#fffbf2; border-color:#ffd799; "/>
  614. <caption id="caption12" class="cell_1" style="left:10px; top:38px; width:82px; height:23px; vertical-align:middle; ">물품코드</caption>
  615. <caption id="caption1" class="cell_1" style="left:10px; top:64px; width:82px; height:23px; vertical-align:middle; ">물품구분</caption>
  616. <caption id="caption3" class="cell_1" style="left:10px; top:90px; width:82px; height:23px; vertical-align:middle; ">물품명</caption>
  617. <caption id="caption5" class="cell_1" style="left:10px; top:116px; width:82px; height:23px; vertical-align:middle; ">물품명</caption>
  618. <caption id="caption7" class="cell_1" style="left:10px; top:142px; width:82px; height:23px; vertical-align:middle; ">물품명</caption>
  619. <caption id="caption9" class="cell_1" style="left:10px; top:168px; width:82px; height:23px; vertical-align:middle; ">물품규격</caption>
  620. <caption id="caption10" class="cell_1" style="left:10px; top:194px; width:82px; height:23px; vertical-align:middle; ">모델</caption>
  621. <caption id="caption11" class="cell_1" style="left:10px; top:220px; width:82px; height:23px; vertical-align:middle; ">자산구분</caption>
  622. <caption id="caption13" class="cell_1" style="left:10px; top:246px; width:82px; height:23px; vertical-align:middle; ">대분류</caption>
  623. <caption id="caption14" class="cell_1" style="left:10px; top:272px; width:82px; height:23px; vertical-align:middle; ">대분류명</caption>
  624. <caption id="caption15" class="cell_1" style="left:10px; top:298px; width:82px; height:23px; vertical-align:middle; ">중분류</caption>
  625. <caption id="caption16" class="cell_1" style="left:10px; top:324px; width:82px; height:23px; vertical-align:middle; ">중분류명</caption>
  626. <caption id="caption17" class="cell_1" style="left:10px; top:350px; width:82px; height:23px; vertical-align:middle; ">소분류</caption>
  627. <caption id="caption18" class="cell_1" style="left:10px; top:376px; width:82px; height:23px; vertical-align:middle; ">소분류명</caption>
  628. <caption id="caption19" class="cell_1" style="left:10px; top:402px; width:82px; height:23px; vertical-align:middle; ">EDI코드</caption>
  629. <caption id="caption20" class="cell_1" style="left:10px; top:428px; width:82px; height:23px; vertical-align:middle; ">제조회사</caption>
  630. <caption id="caption21" class="cell_1" style="left:10px; top:454px; width:82px; height:23px; vertical-align:middle; ">제조회사명칭</caption>
  631. <caption id="caption22" class="cell_1" style="left:10px; top:480px; width:82px; height:23px; vertical-align:middle; ">비고</caption>
  632. <caption id="caption24" class="cell_1" style="left:95px; top:13px; width:235px; height:23px; font-weight:bold; text-align:center; vertical-align:middle; ">Excel Load Data</caption>
  633. <caption id="caption25" class="cell_1" style="left:335px; top:13px; width:235px; height:23px; font-weight:bold; text-align:center; vertical-align:middle; ">현재 물품 Master</caption>
  634. <input id="opt_goodcd" ref="/root/init/CompareData/goodcd" class="input_default" disabled="true" style="left:95px; top:38px; width:100px; height:19px; ">
  635. <script type="javascript" ev:event="xforms-value-changed">
  636. <![CDATA[
  637. grd_ogoodcd.attribute("visibility") ="hidden" ;
  638. grd_allsize.attribute("visibility") ="hidden" ;
  639. ]]>
  640. </script>
  641. </input>
  642. <output id="opt_goodflag" ref="/root/init/CompareData/goodflag" class="output_fix" style="left:95px; top:64px; width:235px; height:19px; "/>
  643. <output id="opt_goodnm" ref="/root/init/CompareData/goodnm" class="output_fix" style="left:95px; top:90px; width:235px; height:19px; "/>
  644. <output id="opt_goodhngnm" ref="/root/init/CompareData/goodhngnm" class="output_fix" style="left:95px; top:116px; width:235px; height:19px; "/>
  645. <output id="opt_goodengnm" ref="/root/init/CompareData/goodengnm" class="output_fix" style="left:95px; top:142px; width:235px; height:19px; "/>
  646. <output id="opt_goodspec" ref="/root/init/CompareData/goodspec" class="output_fix" style="left:95px; top:168px; width:235px; height:19px; "/>
  647. <output id="opt_goodmodel" ref="/root/init/CompareData/goodmodel" class="output_fix" style="left:95px; top:194px; width:235px; height:19px; "/>
  648. <output id="opt_asetflag" ref="/root/init/CompareData/asetflag" class="output_fix" style="left:95px; top:220px; width:235px; height:19px; "/>
  649. <output id="opt_lrgcd" ref="/root/init/CompareData/lrgcd" class="output_fix" style="left:95px; top:246px; width:235px; height:19px; "/>
  650. <output id="opt_lrgnm" ref="/root/init/CompareData/lrgnm" class="output_fix" style="left:95px; top:272px; width:235px; height:19px; "/>
  651. <output id="opt_mdlcd" ref="/root/init/CompareData/mdlcd" class="output_fix" style="left:95px; top:298px; width:235px; height:19px; "/>
  652. <output id="opt_mdlnm" ref="/root/init/CompareData/mdlnm" class="output_fix" style="left:95px; top:324px; width:235px; height:19px; "/>
  653. <output id="opt_smlcd" ref="/root/init/CompareData/smlcd" class="output_fix" style="left:95px; top:350px; width:235px; height:19px; "/>
  654. <output id="opt_smlnm" ref="/root/init/CompareData/smlnm" class="output_fix" style="left:95px; top:376px; width:235px; height:19px; "/>
  655. <output id="opt_edicd" ref="/root/init/CompareData/edicd" class="output_fix" style="left:95px; top:402px; width:235px; height:19px; "/>
  656. <output id="opt_prodcmpycd" ref="/root/init/CompareData/prodcmpycd" class="output_fix" style="left:95px; top:428px; width:235px; height:19px; "/>
  657. <output id="opt_prodcmpynm" ref="/root/init/CompareData/prodcmpynm" class="output_fix" style="left:95px; top:454px; width:235px; height:19px; "/>
  658. <output id="opt_cmt" ref="/root/init/CompareData/cmt" class="output_fix" style="left:95px; top:480px; width:235px; height:19px; "/>
  659. <output id="opt_goodcd_2" ref="/root/init/CompareData/goodcd_2" class="output_fix" style="left:335px; top:38px; width:235px; height:19px; "/>
  660. <output id="opt_goodflag_2" ref="/root/init/CompareData/goodflag_2" class="output_fix" style="left:335px; top:64px; width:235px; height:19px; "/>
  661. <output id="opt_goodnm_2" ref="/root/init/CompareData/goodnm_2" class="output_fix" style="left:335px; top:90px; width:235px; height:19px; "/>
  662. <output id="opt_goodhngnm_2" ref="/root/init/CompareData/goodhngnm_2" class="output_fix" style="left:335px; top:116px; width:235px; height:19px; "/>
  663. <output id="opt_goodengnm_2" ref="/root/init/CompareData/goodengnm_2" class="output_fix" style="left:335px; top:142px; width:235px; height:19px; "/>
  664. <output id="opt_goodspec_2" ref="/root/init/CompareData/goodspec_2" class="output_fix" style="left:335px; top:168px; width:235px; height:19px; "/>
  665. <output id="opt_goodmodel_2" ref="/root/init/CompareData/goodmodel_2" class="output_fix" style="left:335px; top:194px; width:235px; height:19px; "/>
  666. <output id="opt_asetflag_2" ref="/root/init/CompareData/asetflag_2" class="output_fix" style="left:335px; top:220px; width:235px; height:19px; "/>
  667. <output id="opt_lrgcd_2" ref="/root/init/CompareData/lrgcd_2" class="output_fix" style="left:335px; top:246px; width:235px; height:19px; "/>
  668. <output id="opt_lrgnm_2" ref="/root/init/CompareData/lrgnm_2" class="output_fix" style="left:335px; top:272px; width:235px; height:19px; "/>
  669. <output id="opt_mdlcd_2" ref="/root/init/CompareData/mdlcd_2" class="output_fix" style="left:335px; top:298px; width:235px; height:19px; "/>
  670. <output id="opt_mdlnm_2" ref="/root/init/CompareData/mdlnm_2" class="output_fix" style="left:335px; top:324px; width:235px; height:19px; "/>
  671. <output id="opt_smlcd_2" ref="/root/init/CompareData/smlcd_2" class="output_fix" style="left:335px; top:350px; width:235px; height:19px; "/>
  672. <output id="opt_smlnm_2" ref="/root/init/CompareData/smlnm_2" class="output_fix" style="left:335px; top:376px; width:235px; height:19px; "/>
  673. <output id="opt_edicd_2" ref="/root/init/CompareData/edicd_2" class="output_fix" style="left:335px; top:402px; width:235px; height:19px; "/>
  674. <output id="opt_prodcmpycd_2" ref="/root/init/CompareData/prodcmpycd_2" class="output_fix" style="left:335px; top:428px; width:235px; height:19px; "/>
  675. <output id="opt_prodcmpynm_2" ref="/root/init/CompareData/prodcmpynm_2" class="output_fix" style="left:335px; top:454px; width:235px; height:19px; "/>
  676. <output id="opt_cmt_2" ref="/root/init/CompareData/cmt_2" class="output_fix" style="left:335px; top:480px; width:235px; height:19px; "/>
  677. <button id="button3" class="btn2_letter3" style="left:20px; top:10px; width:53px; height:19px; ">
  678. <caption>확인</caption>
  679. <script type="javascript" ev:event="DOMActivate">
  680. <![CDATA[
  681. grp_disp.attribute("visibility") ="hidden" ;
  682. ]]>
  683. </script>
  684. </button>
  685. <datagrid id="grd_allsize" nodeset="/root/main/ExlAllsizeLists/exlallsizelist" visibility="hidden" caption="물품코드^물품명^규격ID^물품규격" colsep="^" colwidth="0, 0, 99, 333" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:95px; top:245px; width:475px; height:145px; ">
  686. <col ref="goodcd"/>
  687. <col ref="goodnm"/>
  688. <col ref="allsizespecid"/>
  689. <col ref="goodspec"/>
  690. </datagrid>
  691. <datagrid id="grd_ogoodcd" nodeset="/root/main/ExlOldnewLists/exloldnewlist" visibility="hidden" caption="신물품코드^구물품코드^물품명" colsep="^" colwidth="0, 106, 325" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:95px; top:65px; width:475px; height:170px; ">
  692. <col ref="ngoodcd"/>
  693. <col ref="ogoodcd"/>
  694. <col ref="goodnm"/>
  695. </datagrid>
  696. <caption id="caption26" class="cell_1" style="left:200px; top:38px; width:125px; height:20px; text-align:center; vertical-align:middle; ">
  697. <![CDATA[구물품코드 & SIZE]]>
  698. <script type="javascript" ev:event="onclick">
  699. <![CDATA[
  700. fOldCodeAllSizeRead();
  701. ]]>
  702. </script>
  703. </caption>
  704. </group>
  705. </case>
  706. <case id="cse_goodlist" selected="true" style="left:0px; top:0px; width:1193px; height:620px; ">
  707. <caption id="caption23" class="tit_2" style="left:4px; top:7px; width:161px; height:13px; ">Excel Data List</caption>
  708. <datagrid id="grd_rscdexcellist" nodeset="/root/main/ExcelLists/ExcelList" autoresize="true" caption="자재코드^NewCode^EDI코드^중분류^소분류^세분류^Size^품명^규격^모델^제조회사^구매단위^구매불출환산^불출단위^불출처방환산^처방단위^ESTMAMT" colsep="^" colwidth="80, 80, 80, 45, 45, 45, 40, 197, 190, 190, 190, 70, 80, 70, 80, 70, 80" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:25px; width:1193px; height:588px; ">
  709. <col ref="ogood"/>
  710. <col ref="ngood"/>
  711. <col ref="edicode"/>
  712. <col ref="lrgcd"/>
  713. <col ref="mdlcd"/>
  714. <col ref="goodseq"/>
  715. <col ref="allsizeid"/>
  716. <col ref="goodnm"/>
  717. <col ref="goodspec"/>
  718. <col ref="goodmodel"/>
  719. <col ref="prodcmpycd"/>
  720. <col ref="purcunit"/>
  721. <col ref="purcexch"/>
  722. <col ref="outunit"/>
  723. <col ref="outexch"/>
  724. <col ref="useunit"/>
  725. <col ref="estmamt"/>
  726. </datagrid>
  727. <button id="btn_loadexcel" class="btn2_letter8" style="left:1023px; top:3px; width:108px; height:19px; ">
  728. <caption>엑셀자료가져오기</caption>
  729. <script type="javascript" ev:event="DOMActivate">
  730. <![CDATA[
  731. fLoadExcel("0");
  732. ]]>
  733. </script>
  734. </button>
  735. <line id="line4" class="line_1" style="x1:0px; y1:24px; x2:1193px; y2:24px; "/>
  736. <button id="btn_excelsave" class="btn2_letter3" style="left:965px; top:3px; width:53px; height:19px; ">
  737. <caption>저 장</caption>
  738. <script type="javascript" ev:event="DOMActivate">
  739. <![CDATA[
  740. if ( fCheckSaveData( grd_rscdexcellist ) != false)
  741. {
  742. model.setValue("/root/send/save/rscdexcellist", getGridUpdateData(grd_rscdexcellist) );
  743. submit("TXRSC03801");
  744. if (model.getValue(gvErrorMsgPath + "/type") != "error")
  745. {
  746. misfGridInit(grd_rscdexcellist);
  747. btn_cost.dispatch("DOMActivate");
  748. btn_cost.selected="true";
  749. btn_search.dispatch("DOMActivate");
  750. }
  751. }
  752. ]]>
  753. </script>
  754. </button>
  755. <datagrid id="mgoodcopy" nodeset="/root/CopyData/CopyGoodLists/CopyGoodList" visibility="visible" caption="물품코드^물품구분^물품명^물품규격^모델^자산구분^대분류코드^중분류코드^소분류코드^EDI코드^제조회사코드^제조회사명칭" colsep="^" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:45px; top:100px; width:910px; height:170px; ">
  756. <col ref="goodcd"/>
  757. <col ref="goodflag"/>
  758. <col ref="goodnm"/>
  759. <col ref="goodspec"/>
  760. <col ref="goodmodel"/>
  761. <col ref="asetflag"/>
  762. <col ref="lrgcd"/>
  763. <col ref="mdlcd"/>
  764. <col ref="smlcd"/>
  765. <col ref="edicd"/>
  766. <col ref="prodcmpycd"/>
  767. <col ref="prodcmpynm"/>
  768. </datagrid>
  769. <button id="button2" class="btn2_letter7" style="left:845px; top:5px; width:105px; height:19px; ">
  770. <caption>임시마스터생성</caption>
  771. <script type="javascript" ev:event="DOMActivate">
  772. <![CDATA[
  773. fExcel2GoodMasterSave();
  774. ]]>
  775. </script>
  776. </button>
  777. <datagrid id="allsizecopy" nodeset="/root/CopyData/CopySizeLists/CopySizeList" visibility="visible" caption="물품코드^물품명^규격ID^물품규격" colsep="^" colwidth="100, 250, 100, 331" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:40px; top:280px; width:910px; height:145px; ">
  778. <col ref="goodcd"/>
  779. <col ref="goodnm"/>
  780. <col ref="allsizespecid"/>
  781. <col ref="goodspec"/>
  782. </datagrid>
  783. <datagrid id="goodoldnew" nodeset="/root/CopyData/CopyMapLists/CopyMapList" visibility="visible" caption="신물품코드^구물품코드^물품명격" colsep="^" colwidth="100,100, 250" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:40px; top:435px; width:495px; height:170px; ">
  784. <col ref="ngoodcd"/>
  785. <col ref="ogoodcd"/>
  786. <col ref="goodnm"/>
  787. </datagrid>
  788. <select id="chk_master" ref="/root/CopyData/CopyCond/mastercls" overflow="visible" appearance="full" style="left:580px; top:5px; width:80px; height:15px; border-style:none; ">
  789. <choices>
  790. <item>
  791. <label>MASTER</label>
  792. <value>Y</value>
  793. </item>
  794. </choices>
  795. </select>
  796. <select id="chk_allsize" ref="/root/CopyData/CopyCond/allsizecls" overflow="visible" appearance="full" style="left:665px; top:5px; width:80px; height:15px; border-style:none; ">
  797. <choices>
  798. <item>
  799. <label>All Size</label>
  800. <value>Y</value>
  801. </item>
  802. </choices>
  803. </select>
  804. <select id="chk_oldnew" ref="/root/CopyData/CopyCond/oldnewcls" overflow="visible" appearance="full" style="left:750px; top:5px; width:80px; height:15px; border-style:none; ">
  805. <choices>
  806. <item>
  807. <label>Old New</label>
  808. <value>Y</value>
  809. </item>
  810. </choices>
  811. </select>
  812. <button id="button5" class="btn2_letter3" style="left:1135px; top:3px; width:53px; height:19px; ">
  813. <caption>행삭제</caption>
  814. <script type="javascript" ev:event="DOMActivate">
  815. <![CDATA[
  816. if( grd_rscdexcellist.rows - grd_rscdexcellist.fixedRows > 0 )
  817. {
  818. var tempmag = messageBox("선택한 항목을 ", "Q001");
  819. if ( tempmag == "6" ) {
  820. misfGridIUD(grd_rscdexcellist, "D"); // rowStatus = 4
  821. }
  822. }
  823. ]]>
  824. </script>
  825. </button>
  826. </case>
  827. <case id="cse_instcd" style="left:0px; top:0px; width:1193px; height:620px; ">
  828. <button id="button4" class="btn2_letter7" style="left:845px; top:5px; width:105px; height:19px; ">
  829. <caption>임시마스터생성</caption>
  830. <script type="javascript" ev:event="DOMActivate">
  831. <![CDATA[
  832. fExcel2GoodMasterSave();
  833. ]]>
  834. </script>
  835. </button>
  836. <caption id="caption27" class="tit_2" style="left:4px; top:7px; width:161px; height:13px; ">Excel Detail List</caption>
  837. <button id="button6" class="btn2_letter3" style="left:965px; top:3px; width:53px; height:19px; ">
  838. <caption>저 장</caption>
  839. <script type="javascript" ev:event="DOMActivate">
  840. <![CDATA[
  841. if ( fCheckSaveData( grd_rscdexcellist ) != false)
  842. {
  843. model.setValue("/root/send/save/rscdexcellist", getGridUpdateData(grd_rscdexcellist) );
  844. submit("TXRSC03801");
  845. if (model.getValue(gvErrorMsgPath + "/type") != "error")
  846. {
  847. misfGridInit(grd_rscdexcellist);
  848. btn_cost.dispatch("DOMActivate");
  849. btn_cost.selected="true";
  850. btn_search.dispatch("DOMActivate");
  851. }
  852. }
  853. ]]>
  854. </script>
  855. </button>
  856. <button id="button7" class="btn2_letter8" style="left:1023px; top:3px; width:108px; height:19px; ">
  857. <caption>엑셀자료가져오기</caption>
  858. <script type="javascript" ev:event="DOMActivate">
  859. <![CDATA[
  860. fLoadExcel("1");
  861. ]]>
  862. </script>
  863. </button>
  864. <line id="line1" class="line_1" style="x1:0px; y1:24px; x2:1193px; y2:24px; "/>
  865. <datagrid id="grd_instexcellist" nodeset="/root/main/ExcelInstLists/ExcelInstList" autoresize="true" caption="구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^구 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보^신 물품정보|자재코드^신코드^품 명^규 격^모 델^소모구분^단 가^수가코드^EDI Code^구매단위^사용단위^최종입고일^등록일^제조원^New Code^EDI Code^품 명^규 격^모 델^제조원^All Size여부^수가여부^청구방법^청구주기^구매방법^구매단위^구매불출환산^불출단위^불출처방환산^처방단위^ESTMAMT" colsep="^" colwidth="78, 75, 132, 121, 117, 70, 67, 68, 65, 61, 61, 65, 65, 100, 80, 82, 117, 107, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:25px; width:1193px; height:588px; ">
  866. <col ref="ogoodcd"/>
  867. <col ref="ongood"/>
  868. <col ref="ogoodnm"/>
  869. <col ref="ogoodspec"/>
  870. <col ref="ogoodmodel"/>
  871. <col ref="opurcflagnm"/>
  872. <col ref="opurcflag"/>
  873. <col ref="ounitcost"/>
  874. <col ref="oprcpcode"/>
  875. <col ref="oedicd"/>
  876. <col ref="opurcunit"/>
  877. <col ref="ouseunit"/>
  878. <col ref="olastinputdd"/>
  879. <col ref="olastpurcdd"/>
  880. <col ref="oprodcmpynm"/>
  881. <col ref="goodcd"/>
  882. <col ref="edicd"/>
  883. <col ref="goodnm"/>
  884. <col ref="goodspec"/>
  885. <col ref="goodmodel"/>
  886. <col ref="prodcmpynm"/>
  887. <col ref="allsizeyn"/>
  888. <col ref="prcpyn"/>
  889. <col ref="reqmthdnm"/>
  890. <col ref="purcflagnm"/>
  891. <col ref="purcunit"/>
  892. <col ref="exchqty"/>
  893. <col ref="deliveunit"/>
  894. <col ref="prcpexchqty"/>
  895. <col ref="prcpunit"/>
  896. <col ref="estmamt"/>
  897. </datagrid>
  898. <button id="button9" class="btn2_letter3" style="left:1138px; top:3px; width:53px; height:19px; ">
  899. <caption>행삭제</caption>
  900. <script type="javascript" ev:event="DOMActivate">
  901. <![CDATA[
  902. if( grd_instexcellist.rows - grd_instexcellist.fixedRows > 0 )
  903. {
  904. var tempmag = messageBox("선택한 항목을 ", "Q001");
  905. if ( tempmag == "6" ) {
  906. misfGridIUD(grd_instexcellist, "D"); // rowStatus = 4
  907. }
  908. }
  909. ]]>
  910. </script>
  911. </button>
  912. </case>
  913. </switch>
  914. <button id="btn_cost" class="btn_sw" group="tab" selected="true" style="left:0px; top:99px; width:149px; height:22px; ">
  915. <caption>Excel Data Mapping</caption>
  916. <toggle case="cse_costlist" ev:event="DOMActivate"/>
  917. </button>
  918. <button id="btn_excel" class="btn_sw" group="tab" selected="false" style="left:149px; top:99px; width:160px; height:22px; ">
  919. <caption>Excel Master</caption>
  920. <toggle case="cse_goodlist" ev:event="DOMActivate"/>
  921. </button>
  922. <button id="btn_clear" class="btn4_letter3" style="left:1126px; top:92px; width:68px; height:22px; ">
  923. <caption>초기화</caption>
  924. <script type="javascript" ev:event="DOMActivate">
  925. <![CDATA[
  926. fInitialize();
  927. ]]>
  928. </script>
  929. </button>
  930. <button id="button8" class="btn_sw" group="tab" selected="false" style="left:310px; top:100px; width:160px; height:22px; ">
  931. <caption>Excel Detail</caption>
  932. <toggle case="cse_instcd" ev:event="DOMActivate"/>
  933. </button>
  934. </group>
  935. <group id="group2" style="left:0px; top:12px; width:1195px; height:27px; ">
  936. <output id="opt_popinputcd" ref="/root/init/popinputcd" visibility="hidden" style="left:840px; top:3px; width:100px; height:19px; "/>
  937. <output id="opt_poptitle" ref="/root/init/poptitle" visibility="hidden" style="left:737px; top:3px; width:100px; height:19px; "/>
  938. <output id="opt_popcond" ref="/root/init/popcond" visibility="hidden" style="left:634px; top:3px; width:100px; height:19px; "/>
  939. <output id="opt_popformat" ref="/root/init/popformat" visibility="hidden" style="left:531px; top:3px; width:100px; height:19px; "/>
  940. <line id="line7" class="line_6" style="x1:0px; y1:25; x2:1195; y2:25; "/>
  941. </group>
  942. </xhtml:body>
  943. </xhtml:html>