SMRSC03700_자재Spec일괄변경.xfdl 86 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRSC03700" position="absolute 0 0 1197 771" titletext="기관별 자재Spec.일괄변경" onload="SMRSC03700_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 51 1195 769" id="group3" scrollbars="autoboth">
  8. <Layouts>
  9. <Layout>
  10. <Div position="absolute 0 0 1195 120" align="align:center top;" id="grp_title" class="div_SA2" anchor="default">
  11. <Layouts>
  12. <Layout>
  13. <Static text="기관코드 :" position="absolute 15 9 101 26" id="cap_instcd" class="search_name" anchor="default"/>
  14. <Combo position="absolute 100 8 265 27" id="cmb_instcd" class="combo_search" innerdataset="ds_init_instcd" datacolumn="cdnm" codecolumn="cdid" anchor="default" onitemchanged="group3_grp_title_cmb_instcd_onitemchanged"/>
  15. <Static text="주 거 래 처 :" position="absolute 530 51 633 68" id="cap_maincustlastsuplplce" class="search_name" anchor="default"/>
  16. <Static text="물품구분 :" position="absolute 15 30 101 47" id="cap_goodflag" class="search_name" anchor="default"/>
  17. <Calendar position="absolute 774 29 885 48" id="input1" class="input_default" anchor="default" autoselect="true"/>
  18. <Static text="대 분 류 :" position="absolute 15 51 98 68" id="cap_lrgcd" class="search_name" anchor="default"/>
  19. <Static text="물 품 명 :" position="absolute 530 9 633 26" id="caption27" class="search_name" anchor="default"/>
  20. <Static text="중 분 류 :" position="absolute 15 72 98 89" id="caption28" class="search_name" anchor="default"/>
  21. <Static text="제 조 회 사 :" position="absolute 530 93 633 110" id="caption29" class="search_name" anchor="default"/>
  22. <Static text="소 분 류 :" position="absolute 15 93 98 110" id="caption30" class="search_name" anchor="default"/>
  23. <Static text="보조거래처 :" position="absolute 530 72 633 89" id="cap_suppcustcd" class="search_name" anchor="default"/>
  24. <Edit position="absolute 635 8 885 27" id="ipt_goodnm" class="input_default" anchor="default" autoselect="true"/>
  25. <Edit position="absolute 635 92 746 111" id="ipt_prodcmpycd" class="input_search" anchor="default" onkeyup="Edit_onkeyup" autoselect="true"/>
  26. <Edit position="absolute 774 92 1019 111" id="ipt_prodcmpynm" class="input_search" anchor="default" onkeyup="Edit_onkeyup" autoselect="true"/>
  27. <Button position="absolute 753 94 769 110" id="btn_prodcmpycd" class="icon_search" text="" anchor="default" onclick="group3_grp_title_btn_prodcmpycd_onclick"/>
  28. <Edit position="absolute 774 50 1019 69" id="ipt_maincustlastsuplplcenm" class="input_search" anchor="default" onkeyup="Edit_onkeyup" autoselect="true"/>
  29. <Button position="absolute 753 52 769 68" id="btn_maincustlastsuplplce" class="icon_search" text="" anchor="default" onclick="group3_grp_title_btn_maincustlastsuplplce_onclick"/>
  30. <Edit position="absolute 635 50 746 69" id="ipt_maincustlastsuplplce" class="input_search" anchor="default" onkeyup="Edit_onkeyup" autoselect="true"/>
  31. <Edit position="absolute 774 71 1019 90" id="ipt_suppcustnm" class="input_search" anchor="default" onkeyup="Edit_onkeyup" autoselect="true"/>
  32. <Edit position="absolute 635 71 746 90" id="ipt_suppcustcd" class="input_search" anchor="default" onkeyup="Edit_onkeyup" autoselect="true"/>
  33. <Button position="absolute 753 73 769 89" id="btn_suppcustcd" class="icon_search" text="" anchor="default" onclick="group3_grp_title_btn_suppcustcd_onclick"/>
  34. <Edit position="absolute 375 50 505 69" id="ipt_edicd" class="input_default" anchor="default" autoselect="true"/>
  35. <Edit position="absolute 375 8 505 27" id="ipt_goodcd" class="input_default" anchor="default" autoselect="true"/>
  36. <Static text="물품코드 :" position="absolute 290 9 379 26" id="cap_goodcd" class="search_name" anchor="default"/>
  37. <Static text="EDI코드 :" position="absolute 290 51 379 68" id="caption34" class="search_name" anchor="default"/>
  38. <Static text="사용여부 :" position="absolute 290 93 379 110" id="caption37" class="search_name" anchor="default"/>
  39. <Radio position="absolute 376 92 504 111" id="rbo_useyn" class="radio_search" columncount="3" rowcount="1" innerdataset="@ds_init_useyn" datacolumn="label" codecolumn="value" anchor="default"/>
  40. <Button position="absolute 1124 49 1180 71" id="btn_search" class="btn1" text="조회" anchor="default" onclick="group3_grp_title_btn_search_onclick"/>
  41. <Combo position="absolute 100 29 265 48" id="cmb_goodflag" class="combo_search" innerdataset="ds_init_goodflag" datacolumn="cdnm" codecolumn="cdid" anchor="default" onitemchanged="group3_grp_title_cmb_goodflag_onitemchanged"/>
  42. <Calendar position="absolute 635 29 746 48" id="input23" class="input_default" anchor="default" autoselect="true"/>
  43. <Static text="적 용 기 간 :" position="absolute 530 30 633 47" id="caption38" class="search_name" anchor="default"/>
  44. <Static text="~" position="absolute 754 29 769 49" id="caption1" anchor="default"/>
  45. <Calendar position="absolute 375 71 505 90" id="ipt_insfromdd" class="input_default" anchor="default" autoselect="true"/>
  46. <Static text="변경일자 :" position="absolute 290 72 379 89" id="caption7" class="search_name" anchor="default"/>
  47. <Static text="구 코 드 :" position="absolute 290 30 379 47" id="caption82" class="search_name" anchor="default"/>
  48. <Edit position="absolute 375 29 505 48" id="ipt_oldcd_search" class="input_search" anchor="default" autoselect="true"/>
  49. <Shape position="absolute 1106 15 1112 109" linetype="vertical" id="line_title" class="line_4" anchor="default"/>
  50. <Combo position="absolute 100 50 265 69" id="cmb_lrgcd_search" anchor="default" onitemchanged="group3_grp_title_cmb_lrgcd_search_onitemchanged"/>
  51. <Combo position="absolute 100 71 265 90" id="cmb_mdlcd_search" anchor="default" onitemchanged="group3_grp_title_cmb_mdlcd_search_onitemchanged"/>
  52. <Combo position="absolute 100 92 265 111" id="cmb_smlcd_search" anchor="default"/>
  53. </Layout>
  54. </Layouts>
  55. </Div>
  56. <Tab position="absolute 0 133 1195 718" id="swt_select" class="sw_box" anchor="default">
  57. <Tabpages>
  58. <Tabpage text=" 단가, 거래처 일괄변경 " position="absolute 0 0 1193 578" id="cse_costlist">
  59. <Layouts>
  60. <Layout>
  61. <Button position="absolute 1066 0 1195 22" id="bbt_excelload" class="btn7" text="엑셀자료가져오기" anchor="default" onclick="group3_swt_select_cse_costlist_bbt_excelload_onclick"/>
  62. <Grid position="absolute 0 27 1195 409" id="grd_costlist" binddataset="ds_main_list_good_goodlist" anchor="default" onmousemove="Grid_onmousemove" autoenter="key" cellsizingtype="both" selecttype="multirow" extendsizetype="row" onselectchanged="group3_swt_select_cse_costlist_grd_costlist_onselectchanged" onrbuttonup="group3_swt_select_cse_costlist_grd_costlist_onrbuttonup" onexpandup="group3_swt_select_cse_costlist_grd_costlist_onexpandup">
  63. <Formats>
  64. <Format id="default">
  65. <Columns>
  66. <Column size="25" band="left"/>
  67. <Column size="69"/>
  68. <Column size="64"/>
  69. <Column size="163"/>
  70. <Column size="74"/>
  71. <Column size="55"/>
  72. <Column size="94"/>
  73. <Column size="15"/>
  74. <Column size="81"/>
  75. <Column size="61"/>
  76. <Column size="79"/>
  77. <Column size="52"/>
  78. <Column size="94"/>
  79. <Column size="15"/>
  80. <Column size="94"/>
  81. <Column size="15"/>
  82. <Column size="60"/>
  83. <Column size="69"/>
  84. <Column size="0"/>
  85. <Column size="0"/>
  86. <Column size="0"/>
  87. <Column size="0"/>
  88. <Column size="0"/>
  89. <Column size="0"/>
  90. <Column size="0"/>
  91. <Column size="0"/>
  92. <Column size="0"/>
  93. <Column size="0"/>
  94. <Column size="0"/>
  95. <Column size="0"/>
  96. <Column size="0"/>
  97. <Column size="0"/>
  98. <Column size="0"/>
  99. <Column size="0"/>
  100. <Column size="0"/>
  101. <Column size="0"/>
  102. <Column size="0"/>
  103. <Column size="0"/>
  104. <Column size="0"/>
  105. <Column size="0"/>
  106. <Column size="0"/>
  107. <Column size="0"/>
  108. <Column size="0"/>
  109. <Column size="0"/>
  110. <Column size="0"/>
  111. <Column size="0"/>
  112. <Column size="0"/>
  113. <Column size="0"/>
  114. <Column size="0"/>
  115. <Column size="0"/>
  116. <Column size="0"/>
  117. <Column size="0"/>
  118. <Column size="0"/>
  119. <Column size="0"/>
  120. <Column size="0"/>
  121. <Column size="0"/>
  122. <Column size="0"/>
  123. <Column size="0"/>
  124. <Column size="0"/>
  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="0"/>
  133. <Column size="0"/>
  134. <Column size="0"/>
  135. <Column size="0"/>
  136. <Column size="0"/>
  137. <Column size="0"/>
  138. <Column size="0"/>
  139. <Column size="0"/>
  140. <Column size="0"/>
  141. <Column size="0"/>
  142. <Column size="0"/>
  143. <Column size="0"/>
  144. <Column size="0"/>
  145. <Column size="0"/>
  146. <Column size="0"/>
  147. <Column size="0"/>
  148. <Column size="0"/>
  149. <Column size="0"/>
  150. <Column size="0"/>
  151. <Column size="0"/>
  152. <Column size="0"/>
  153. <Column size="0"/>
  154. </Columns>
  155. <Rows>
  156. <Row size="24" band="head"/>
  157. <Row size="24"/>
  158. </Rows>
  159. <Band id="head">
  160. <Cell/>
  161. <Cell col="1" text="적용일자"/>
  162. <Cell col="2" text="물품코드"/>
  163. <Cell col="3" text="품명"/>
  164. <Cell col="4" text="규격"/>
  165. <Cell col="5" text="모델"/>
  166. <Cell col="6" colspan="2" text="제조회사" taborder="undefined"/>
  167. <Cell col="8" text="포장단위"/>
  168. <Cell col="9" text="환산수량"/>
  169. <Cell col="10" text="수불단위"/>
  170. <Cell col="11" text="단가"/>
  171. <Cell col="12" colspan="2" text="주거래처" taborder="undefined"/>
  172. <Cell col="14" colspan="2" text="보조거래처" taborder="undefined"/>
  173. <Cell col="16" text="수정자"/>
  174. <Cell col="17" text="수정일시"/>
  175. <Cell col="18"/>
  176. <Cell col="19"/>
  177. <Cell col="20"/>
  178. <Cell col="21"/>
  179. <Cell col="22"/>
  180. <Cell col="23"/>
  181. <Cell col="24"/>
  182. <Cell col="25"/>
  183. <Cell col="26"/>
  184. <Cell col="27"/>
  185. <Cell col="28"/>
  186. <Cell col="29"/>
  187. <Cell col="30"/>
  188. <Cell col="31"/>
  189. <Cell col="32"/>
  190. <Cell col="33"/>
  191. <Cell col="34"/>
  192. <Cell col="35"/>
  193. <Cell col="36"/>
  194. <Cell col="37"/>
  195. <Cell col="38"/>
  196. <Cell col="39"/>
  197. <Cell col="40"/>
  198. <Cell col="41"/>
  199. <Cell col="42"/>
  200. <Cell col="43"/>
  201. <Cell col="44"/>
  202. <Cell col="45"/>
  203. <Cell col="46"/>
  204. <Cell col="47"/>
  205. <Cell col="48"/>
  206. <Cell col="49"/>
  207. <Cell col="50"/>
  208. <Cell col="51"/>
  209. <Cell col="52"/>
  210. <Cell col="53"/>
  211. <Cell col="54"/>
  212. <Cell col="55"/>
  213. <Cell col="56"/>
  214. <Cell col="57"/>
  215. <Cell col="58"/>
  216. <Cell col="59"/>
  217. <Cell col="60"/>
  218. <Cell col="61"/>
  219. <Cell col="62"/>
  220. <Cell col="63"/>
  221. <Cell col="64"/>
  222. <Cell col="65"/>
  223. <Cell col="66"/>
  224. <Cell col="67"/>
  225. <Cell col="68"/>
  226. <Cell col="69"/>
  227. <Cell col="70"/>
  228. <Cell col="71"/>
  229. <Cell col="72"/>
  230. <Cell col="73"/>
  231. <Cell col="74"/>
  232. <Cell col="75"/>
  233. <Cell col="76"/>
  234. <Cell col="77"/>
  235. <Cell col="78"/>
  236. <Cell col="79"/>
  237. <Cell col="80"/>
  238. <Cell col="81"/>
  239. <Cell col="82"/>
  240. <Cell col="83"/>
  241. <Cell col="84"/>
  242. <Cell col="85"/>
  243. <Cell col="86"/>
  244. <Cell col="87"/>
  245. </Band>
  246. <Band id="body">
  247. <Cell celltype="head"/>
  248. <Cell col="1" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:fromdd" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" mask="expr:utlf_isNull(fromdd) ? '' : '####-##-##'" autosizerow="limitmin"/>
  249. <Cell col="2" displaytype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:goodcd" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  250. <Cell col="3" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:goodnm" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" editautoselect="true" autosizerow="limitmin"/>
  251. <Cell col="4" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:goodspec" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" editautoselect="true" autosizerow="limitmin"/>
  252. <Cell col="5" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:goodmodel" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" editautoselect="true" autosizerow="limitmin"/>
  253. <Cell col="6" displaytype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:prodcmpynm" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  254. <Cell col="7" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:prodcmpycd" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" expandshow="show" autosizerow="limitmin"/>
  255. <Cell col="8" displaytype="combo" edittype="combo" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:purcunit" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  256. <Cell col="9" displaytype="number" edittype="masknumber" style="align:right middle;padding:1 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:exchqty" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" editautoselect="true" autosizerow="limitmin"/>
  257. <Cell col="10" displaytype="combo" edittype="combo" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:deliveunit" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  258. <Cell col="11" displaytype="number" edittype="masknumber" style="align:right middle;padding:1 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:goodunitcost" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" editautoselect="true" autosizerow="limitmin"/>
  259. <Cell col="12" displaytype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:maincustlastsuplplcenm" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  260. <Cell col="13" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:maincustlastsuplplce" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" expandshow="show" autosizerow="limitmin"/>
  261. <Cell col="14" displaytype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:suppcustnm" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  262. <Cell col="15" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:suppcustcd" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" expandshow="show" autosizerow="limitmin"/>
  263. <Cell col="16" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:lastupdtrnm" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" autosizerow="limitmin"/>
  264. <Cell col="17" style="align:left top;padding:5 2 1 2;font:EXPR(font_up == 'Y' ? 'Dotum,15' : '');" text="bind:lastupdtdt" wordwrap="expr:font_up == 'Y' ? 'char' : 'none'" mask="expr:utlf_isNull(lastupdtdt) ? '' : '####-##-##'" autosizerow="limitmin"/>
  265. <Cell col="18" text="bind:pregoodnm"/>
  266. <Cell col="19" text="bind:prepurcunit"/>
  267. <Cell col="20" text="bind:preexchqty"/>
  268. <Cell col="21" text="bind:predeliveunit"/>
  269. <Cell col="22" text="bind:pregoodspec"/>
  270. <Cell col="23" text="bind:pregoodmodel"/>
  271. <Cell col="24" text="bind:pregoodunitcost"/>
  272. <Cell col="25" text="bind:premaincustlastsuplplce"/>
  273. <Cell col="26" text="bind:presuppcustcd"/>
  274. <Cell col="27" text="bind:preprodcmpycd"/>
  275. <Cell col="28" text="bind:todd"/>
  276. <Cell col="29" text="bind:prefromdd"/>
  277. <Cell col="30" text="bind:pregoodspec"/>
  278. <Cell col="31" text="bind:pregoodmodel"/>
  279. <Cell col="32" text="bind:instcd"/>
  280. <Cell col="33" text="bind:useyn"/>
  281. <Cell col="34" text="bind:goodflag"/>
  282. <Cell col="35" text="bind:goodhngnm"/>
  283. <Cell col="36" text="bind:goodengnm"/>
  284. <Cell col="37" text="bind:asetflag"/>
  285. <Cell col="38" text="bind:lrgcd"/>
  286. <Cell col="39" text="bind:mdlcd"/>
  287. <Cell col="40" text="bind:smlcd"/>
  288. <Cell col="41" text="bind:proddrugsetflag"/>
  289. <Cell col="42" text="bind:winacnt"/>
  290. <Cell col="43" text="bind:amtacnt"/>
  291. <Cell col="44" text="bind:mainmngtdeptcd"/>
  292. <Cell col="45" text="bind:mainusedeptcd"/>
  293. <Cell col="46" text="bind:stocmngtflag"/>
  294. <Cell col="47" text="bind:minexch"/>
  295. <Cell col="48" text="bind:reuseyn"/>
  296. <Cell col="49" text="bind:divusenvalqty"/>
  297. <Cell col="50" text="bind:calcscorinfoacptstat"/>
  298. <Cell col="51" text="bind:calcscorinfoacptdd"/>
  299. <Cell col="52" text="bind:edicd"/>
  300. <Cell col="53" text="bind:reqdeptcd"/>
  301. <Cell col="54" text="bind:reqdeptnm"/>
  302. <Cell col="55" text="bind:reqpsn"/>
  303. <Cell col="56" text="bind:reqflag"/>
  304. <Cell col="57" text="bind:reqmthd"/>
  305. <Cell col="58" text="bind:reqprid"/>
  306. <Cell col="59" text="bind:prodplce"/>
  307. <Cell col="60" text="bind:conflag"/>
  308. <Cell col="61" text="bind:fromconterm"/>
  309. <Cell col="62" text="bind:toconterm"/>
  310. <Cell col="63" text="bind:estmamt"/>
  311. <Cell col="64" text="bind:forgncurncyunitcost"/>
  312. <Cell col="65" text="bind:curncyunit"/>
  313. <Cell col="66" text="bind:purcflag"/>
  314. <Cell col="67" text="bind:allsizeyn"/>
  315. <Cell col="68" text="bind:setplceordflag"/>
  316. <Cell col="69" text="bind:plceordbase"/>
  317. <Cell col="70" text="bind:plceordqtycretflag"/>
  318. <Cell col="71" text="bind:plceordnonusedd"/>
  319. <Cell col="72" text="bind:addtaxrate"/>
  320. <Cell col="73" text="bind:lastpurcdd"/>
  321. <Cell col="74" text="bind:nonusetretresn"/>
  322. <Cell col="75" text="bind:mngtflag"/>
  323. <Cell col="76" text="bind:bnscd"/>
  324. <Cell col="77" text="bind:expnyn"/>
  325. <Cell col="78" text="bind:cmt"/>
  326. <Cell col="79" text="bind:ddavguseqty"/>
  327. <Cell col="80" text="bind:mmavgusescheqty"/>
  328. <Cell col="81" text="bind:mmavguseqty"/>
  329. <Cell col="82" text="bind:prprtystocpossndayno"/>
  330. <Cell col="83" text="bind:oldcd"/>
  331. <Cell col="84" text="bind:insuyn"/>
  332. <Cell col="85" text="bind:prcpunit"/>
  333. <Cell col="86" text="bind:prcpexchqty"/>
  334. <Cell col="87" text="bind:tmpreqflag"/>
  335. </Band>
  336. </Format>
  337. </Formats>
  338. </Grid>
  339. <Shape position="absolute 0 22 1195 28" id="line3" class="line_10" anchor="default"/>
  340. <Button position="absolute 967 0 1064 22" id="btn_zoomin" class="btn2" text="크게/작게 보기" anchor="default" onclick="group3_swt_select_cse_costlist_btn_zoomin_onclick"/>
  341. <Button position="absolute 731 0 795 22" id="btn_ZoomIn" class="btn2" visible="false" text="ZoomIn" anchor="default" onclick="group3_swt_select_cse_costlist_btn_ZoomIn_onclick"/>
  342. <Button position="absolute 797 0 872 22" id="btn_ZoomOut" class="btn2" visible="false" text="ZoomOut" anchor="default" onclick="group3_swt_select_cse_costlist_btn_ZoomOut_onclick"/>
  343. <Button position="absolute 874 0 965 22" id="button3" class="btn7" taborder="12" text="Excel 저장" anchor="default" onclick="group3_swt_select_cse_costlist_button3_onclick"/>
  344. <Shape position="absolute 0 438 1195 444" id="line8" class="line_10" anchor="default"/>
  345. <Grid position="absolute 0 443 1195 558" id="grd_goodhistory" binddataset="ds_main_list_goodhistory_goodhistorylist" anchor="default" oncelldblclick="group3_swt_select_cse_costlist_grd_goodhistory_oncelldblclick">
  346. <Formats>
  347. <Format id="default">
  348. <Columns>
  349. <Column size="25" band="left"/>
  350. <Column size="80"/>
  351. <Column size="0"/>
  352. <Column size="65"/>
  353. <Column size="60"/>
  354. <Column size="66"/>
  355. <Column size="66"/>
  356. <Column size="80"/>
  357. <Column size="80"/>
  358. <Column size="75"/>
  359. <Column size="71"/>
  360. <Column size="73"/>
  361. <Column size="64"/>
  362. <Column size="100"/>
  363. <Column size="70"/>
  364. <Column size="71"/>
  365. <Column size="70"/>
  366. <Column size="69"/>
  367. <Column size="71"/>
  368. <Column size="71"/>
  369. <Column size="100"/>
  370. <Column size="100"/>
  371. <Column size="100"/>
  372. <Column size="100"/>
  373. <Column size="100"/>
  374. <Column size="100"/>
  375. </Columns>
  376. <Rows>
  377. <Row size="24" band="head"/>
  378. <Row size="24"/>
  379. </Rows>
  380. <Band id="head">
  381. <Cell/>
  382. <Cell col="1" text="적용일자*"/>
  383. <Cell col="2" text="사용유무"/>
  384. <Cell col="3" text="규격"/>
  385. <Cell col="4" text="모델"/>
  386. <Cell col="5" text="제조회사"/>
  387. <Cell col="6" text="제조국"/>
  388. <Cell col="7" text="주거래처"/>
  389. <Cell col="8" text="보조거래처"/>
  390. <Cell col="9" text="EDI 코드"/>
  391. <Cell col="10" text="입고단위"/>
  392. <Cell col="11" text="불출단위"/>
  393. <Cell col="12" text="제품단가"/>
  394. <Cell col="13" text="입고계정"/>
  395. <Cell col="14" text="비용계정"/>
  396. <Cell col="15" text="견적가"/>
  397. <Cell col="16" text="외화단가"/>
  398. <Cell col="17" text="화폐단위"/>
  399. <Cell col="18" text="제품단가"/>
  400. <Cell col="19" text="수불단가"/>
  401. <Cell col="20" text="의료수가"/>
  402. <Cell col="21" text="대분류"/>
  403. <Cell col="22" text="중분류"/>
  404. <Cell col="23" text="소분류"/>
  405. <Cell col="24" text="수정자"/>
  406. <Cell col="25" text="수정일시"/>
  407. </Band>
  408. <Band id="body">
  409. <Cell celltype="head"/>
  410. <Cell col="1" displaytype="text" text="bind:fromdd" mask="expr:utlf_isNull(fromdd) ? '' : '####-##-##'"/>
  411. <Cell col="2" text="bind:useyn"/>
  412. <Cell col="3" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:goodspec" wordwrap="word"/>
  413. <Cell col="4" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:goodmodel" wordwrap="word"/>
  414. <Cell col="5" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:prodcmpynm" wordwrap="word"/>
  415. <Cell col="6" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:prodplcenm" wordwrap="word"/>
  416. <Cell col="7" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:maincustlastsuplplcenm" wordwrap="word"/>
  417. <Cell col="8" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:suppcustnm" wordwrap="word"/>
  418. <Cell col="9" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:edicd" wordwrap="word"/>
  419. <Cell col="10" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:purcunitnm" wordwrap="word"/>
  420. <Cell col="11" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:deliveunitnm" wordwrap="word"/>
  421. <Cell col="12" displaytype="number" text="bind:goodunitcost"/>
  422. <Cell col="13" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:winacntnm" wordwrap="word"/>
  423. <Cell col="14" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:amtacntnm" wordwrap="word"/>
  424. <Cell col="15" displaytype="number" text="bind:estmamt"/>
  425. <Cell col="16" displaytype="number" text="bind:forgncurncyunitcost"/>
  426. <Cell col="17" displaytype="text" text="bind:curncyunitnm"/>
  427. <Cell col="18" displaytype="number" text="bind:goodunitcost"/>
  428. <Cell col="19" displaytype="number"/>
  429. <Cell col="20" displaytype="text" style="align:left top;padding:5 2 1 2;" wordwrap="word"/>
  430. <Cell col="21" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:lrgnm" wordwrap="word"/>
  431. <Cell col="22" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:mdlnm" wordwrap="word"/>
  432. <Cell col="23" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:smlnm" wordwrap="word"/>
  433. <Cell col="24" displaytype="text" text="bind:lastupdtrnm"/>
  434. <Cell col="25" displaytype="text" text="bind:lastupdtdt" mask="expr:utlf_isNull(lastupdtdt) ? '' : '####-##-##'"/>
  435. </Band>
  436. </Format>
  437. </Formats>
  438. </Grid>
  439. <Static text="이력정보" position="absolute 0 422 95 438" id="caption8" class="tit_2" anchor="default"/>
  440. <Div position="absolute 0 0 1195 558" id="grp_copygood" visible="false" anchor="default" style="background:white;">
  441. <Layouts>
  442. <Layout>
  443. <Button position="absolute 1028 0 1080 22" id="button2" class="btn2" text="행삭제" anchor="default" onclick="group3_swt_select_cse_costlist_grp_copygood_button2_onclick"/>
  444. <Grid position="absolute 0 27 1195 558" id="grd_copygood" binddataset="ds_init_CopyData_CopyGoodLists_goodexcel" anchor="default" onmousemove="Grid_onmousemove" autoenter="key" cellsizingtype="col" onexpandup="group3_swt_select_cse_costlist_grp_copygood_grd_copygood_onexpandup">
  445. <Formats>
  446. <Format id="default">
  447. <Columns>
  448. <Column size="25" band="left"/>
  449. <Column size="95"/>
  450. <Column size="90"/>
  451. <Column size="130"/>
  452. <Column size="62"/>
  453. <Column size="63"/>
  454. <Column size="61"/>
  455. <Column size="83"/>
  456. <Column size="98"/>
  457. <Column size="100"/>
  458. <Column size="100"/>
  459. <Column size="100"/>
  460. <Column size="56"/>
  461. <Column size="66"/>
  462. <Column size="100"/>
  463. </Columns>
  464. <Rows>
  465. <Row size="24" band="head"/>
  466. <Row size="24"/>
  467. </Rows>
  468. <Band id="head">
  469. <Cell/>
  470. <Cell col="1" text="적용일자"/>
  471. <Cell col="2" text="물품코드"/>
  472. <Cell col="3" text="품명"/>
  473. <Cell col="4" text="구매구분"/>
  474. <Cell col="5" text="청구주기"/>
  475. <Cell col="6" text="청구방법"/>
  476. <Cell col="7" text="단가"/>
  477. <Cell col="8" text="주거래처"/>
  478. <Cell col="9" text="주거래처명"/>
  479. <Cell col="10" text="보조거래처"/>
  480. <Cell col="11" text="보조거래처명"/>
  481. <Cell col="12" text="제조사"/>
  482. <Cell col="13" text="제조사명"/>
  483. <Cell col="14" text="비고"/>
  484. </Band>
  485. <Band id="body">
  486. <Cell celltype="head"/>
  487. <Cell col="1" displaytype="date" edittype="date" style="padding:0 0 0 0;" text="bind:fromdd" editautoselect="true" editautoskip="false" calendardisplay="display" calendardisplaynulltype="none"/>
  488. <Cell col="2" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:goodcd" wordwrap="word"/>
  489. <Cell col="3" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:goodnm" wordwrap="word"/>
  490. <Cell col="4" displaytype="combo" edittype="combo" style="padding:1 2 1 2;" text="bind:purcflag"/>
  491. <Cell col="5" displaytype="combo" edittype="combo" style="padding:1 2 1 2;" text="bind:reqprid"/>
  492. <Cell col="6" displaytype="combo" edittype="combo" style="padding:1 2 1 2;" text="bind:reqmthd"/>
  493. <Cell col="7" displaytype="number" edittype="masknumber" text="bind:goodunitcost"/>
  494. <Cell col="8" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:maincustlastsuplplce" wordwrap="word" editautoselect="true" expandshow="show"/>
  495. <Cell col="9" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:suplplcenm" wordwrap="word"/>
  496. <Cell col="10" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:suppcustcd" wordwrap="word" editautoselect="true" expandshow="show"/>
  497. <Cell col="11" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:suppcustnm" wordwrap="word"/>
  498. <Cell col="12" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:prodcmpycd" wordwrap="word" editautoselect="true" expandshow="show"/>
  499. <Cell col="13" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:prodcmpynm" wordwrap="word"/>
  500. <Cell col="14" displaytype="text" style="align:left top;padding:5 2 1 2;" text="bind:cmt" wordwrap="word"/>
  501. </Band>
  502. </Format>
  503. </Formats>
  504. </Grid>
  505. <Shape position="absolute 0 22 1195 28" id="line5" class="line_10" anchor="default"/>
  506. <Button position="absolute 1139 0 1195 22" id="button7" class="btn4" text="저장" anchor="default" onclick="group3_swt_select_cse_costlist_grp_copygood_button7_onclick"/>
  507. <Static text="자재Spec일괄변경 Excel Data Lists" position="absolute 0 6 248 22" id="caption5" class="tit_2" anchor="default"/>
  508. <Button position="absolute 1082 0 1137 22" id="button10" class="btn4" text="취소" anchor="default" onclick="group3_swt_select_cse_costlist_grp_copygood_button10_onclick"/>
  509. <Static text="**" position="absolute 360 3 725 23" id="caption9" visible="false" anchor="default" style="color:#ff0000ff;font:Dotum,9,bold;"/>
  510. </Layout>
  511. </Layouts>
  512. </Div>
  513. </Layout>
  514. </Layouts>
  515. </Tabpage>
  516. <Tabpage text=" Excel 고시단가 Update " position="absolute 0 0 1193 578" id="cse_goodlist">
  517. <Layouts>
  518. <Layout>
  519. <Grid position="absolute 0 27 1195 558" id="grd_rscdgchglist" binddataset="ds_main_list_rscdgchg_rscdgchglist" anchor="default" onmousemove="Grid_onmousemove" autoenter="key" cellsizingtype="col">
  520. <Formats>
  521. <Format id="default">
  522. <Columns>
  523. <Column size="25" band="left"/>
  524. <Column size="143"/>
  525. <Column size="120"/>
  526. <Column size="100"/>
  527. <Column size="100"/>
  528. <Column size="100"/>
  529. <Column size="100"/>
  530. <Column size="120"/>
  531. <Column size="120"/>
  532. <Column size="249"/>
  533. <Column size="0"/>
  534. </Columns>
  535. <Rows>
  536. <Row size="24" band="head"/>
  537. <Row size="24"/>
  538. </Rows>
  539. <Band id="head">
  540. <Cell/>
  541. <Cell col="1" text="물품코드"/>
  542. <Cell col="2" text="적용일자"/>
  543. <Cell col="3" text="OLD 단가"/>
  544. <Cell col="4" text="NEW 단가"/>
  545. <Cell col="5" text="OLD Edi Code"/>
  546. <Cell col="6" text="NEW Edi Code"/>
  547. <Cell col="7" text="OLD 보조거래처"/>
  548. <Cell col="8" text="NEW 보조거래처"/>
  549. <Cell col="9" text="고시"/>
  550. <Cell col="10"/>
  551. </Band>
  552. <Band id="body">
  553. <Cell celltype="head"/>
  554. <Cell col="1" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:goodcd" wordwrap="word" editautoselect="true"/>
  555. <Cell col="2" displaytype="date" edittype="date" style="padding:0 0 0 0;" text="bind:fromdd" calendardisplay="display" calendardisplaynulltype="none"/>
  556. <Cell col="3" displaytype="number" edittype="masknumber" text="bind:oldgoodunitcost"/>
  557. <Cell col="4" displaytype="number" edittype="masknumber" text="bind:newgoodunitcost"/>
  558. <Cell col="5" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:oldedicd" wordwrap="word" editautoselect="true"/>
  559. <Cell col="6" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:newedicd" wordwrap="word" editautoselect="true"/>
  560. <Cell col="7" style="align:left top;padding:5 2 1 2;" text="bind:oldsuppcustcd" wordwrap="word"/>
  561. <Cell col="8" style="align:left top;padding:5 2 1 2;" text="bind:newsuppcustcd" wordwrap="word"/>
  562. <Cell col="9" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;" text="bind:chgcmt" wordwrap="word" editautoselect="true"/>
  563. <Cell col="10" text="bind:instcd"/>
  564. </Band>
  565. </Format>
  566. </Formats>
  567. </Grid>
  568. <Button position="absolute 1071 0 1195 22" id="btn_loadexcel" class="btn7" text="엑셀자료가져오기" anchor="default" onclick="group3_swt_select_cse_goodlist_btn_loadexcel_onclick"/>
  569. <Shape position="absolute 0 22 1195 28" id="line4" class="line_10" anchor="default"/>
  570. <Button position="absolute 982 0 1069 22" id="button1" class="btn2" text="데이터지우기" anchor="default" onclick="group3_swt_select_cse_goodlist_button1_onclick"/>
  571. <Static text="총 건수 :" position="absolute 710 5 785 22" id="caption2" anchor="default" style="font:Dotum,9,bold;"/>
  572. <Static text="0" position="absolute 775 5 835 22" align="align:right middle;" id="cap_cnt" mask="#,###" anchor="default" style="font:Dotum,9,bold;"/>
  573. <Static text="건" position="absolute 840 5 915 22" id="caption3" anchor="default" style="font:Dotum,9,bold;"/>
  574. <Button position="absolute 927 0 980 22" id="button8" class="btn2" text="행삭제" anchor="default" onclick="group3_swt_select_cse_goodlist_button8_onclick"/>
  575. </Layout>
  576. </Layouts>
  577. </Tabpage>
  578. </Tabpages>
  579. </Tab>
  580. <Static text="**" position="absolute 360 133 725 153" id="caption10" visible="false" anchor="default" style="color:#ff0000ff;font:Dotum,9,bold;"/>
  581. </Layout>
  582. </Layouts>
  583. </Div>
  584. <Div position="absolute 0 25 1195 53" id="group2">
  585. <Layouts>
  586. <Layout>
  587. <Button position="absolute 58 1 138 23" id="btn_scrnmove" class="btn3" visible="false" text="화면이동" anchor="default"/>
  588. <Button position="absolute 0 1 56 23" id="btn_print" class="btn6" visible="false" text="출력" anchor="default"/>
  589. <Button position="absolute 1069 1 1125 23" id="btn_save" class="btn4" text="저장" anchor="default" onclick="group2_btn_save_onclick"/>
  590. <Button position="absolute 1127 1 1195 23" id="btn_clear" class="btn4" text="초기화" anchor="default" onclick="group2_btn_clear_onclick"/>
  591. <Edit readonly="true" position="absolute 840 2 940 21" id="opt_popinputcd" visible="false" anchor="default" style="background:transparent;"/>
  592. <Edit readonly="true" position="absolute 737 2 837 21" id="opt_poptitle" visible="false" anchor="default" style="background:transparent;"/>
  593. <Edit readonly="true" position="absolute 634 2 734 21" id="opt_popcond" visible="false" anchor="default" style="background:transparent;"/>
  594. <Edit readonly="true" position="absolute 531 2 631 21" id="opt_popformat" visible="false" anchor="default" style="background:transparent;"/>
  595. <Shape position="absolute 0 22 1195 28" id="line7" class="line_6" anchor="default"/>
  596. <Combo position="absolute 380 2 445 21" id="cmb_prcpunit" class="combo_search" visible="false" innerdataset="ds_init_goodflag" datacolumn="cdnm" codecolumn="cdid" anchor="default" onitemchanged="group2_cmb_prcpunit_onitemchanged"/>
  597. </Layout>
  598. </Layouts>
  599. </Div>
  600. <Static id="caption6" text="기관별 자재Spec.일괄변경" class="tit_1" position="absolute 0 0 200 25"/>
  601. </Layout>
  602. </Layouts>
  603. <Objects>
  604. <Dataset id="ds_main_list_excelcost_excelcostlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
  605. <Dataset id="ds_main_list_rscdgchg_rscdgchglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
  606. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  607. <ColumnInfo>
  608. <Column id="temp" type="STRING" size="256"/>
  609. </ColumnInfo>
  610. </Dataset>
  611. <Dataset id="ds_main_list_goodhistory_goodhistorylist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
  612. <Dataset id="ds_main_list_good_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
  613. <Dataset id="ds_main_gooddet_gooddetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
  614. <Dataset id="ds_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  615. <ColumnInfo>
  616. <Column id="defaultvalue" type="STRING" size="256"/>
  617. </ColumnInfo>
  618. <Rows>
  619. <Row>
  620. <Col id="defaultvalue"/>
  621. </Row>
  622. </Rows>
  623. </Dataset>
  624. <Dataset id="ds_init_allsizeyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  625. <ColumnInfo>
  626. <Column id="label" type="STRING" size="256"/>
  627. <Column id="value" type="STRING" size="256"/>
  628. </ColumnInfo>
  629. <Rows>
  630. <Row>
  631. <Col id="label">예</Col>
  632. <Col id="value">Y</Col>
  633. </Row>
  634. <Row>
  635. <Col id="label">아니오</Col>
  636. <Col id="value">N</Col>
  637. </Row>
  638. </Rows>
  639. </Dataset>
  640. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  641. <ColumnInfo>
  642. <Column id="popinputcd" type="STRING" size="256"/>
  643. <Column id="popinputnm" type="STRING" size="256"/>
  644. <Column id="poptitle" type="STRING" size="256"/>
  645. <Column id="popcond" type="STRING" size="256"/>
  646. <Column id="popformat" type="STRING" size="256"/>
  647. <Column id="prcpunit" type="STRING" size="256"/>
  648. </ColumnInfo>
  649. </Dataset>
  650. <Dataset id="ds_init_popmenu_grd_costlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  651. <ColumnInfo>
  652. <Column id="hardcdnm" type="STRING" size="256"/>
  653. <Column id="hardcd" type="STRING" size="256"/>
  654. </ColumnInfo>
  655. <Rows>
  656. <Row>
  657. <Col id="hardcdnm">품명일괄변경</Col>
  658. <Col id="hardcd">fSetGoodnm</Col>
  659. </Row>
  660. <Row>
  661. <Col id="hardcdnm">규격일괄변경</Col>
  662. <Col id="hardcd">fSetGoodSpec</Col>
  663. </Row>
  664. <Row>
  665. <Col id="hardcdnm">모델일괄변경</Col>
  666. <Col id="hardcd">fSetGoodModel</Col>
  667. </Row>
  668. <Row>
  669. <Col id="hardcdnm">제조회사일괄변경</Col>
  670. <Col id="hardcd">fSetGoodProdCmpy</Col>
  671. </Row>
  672. <Row>
  673. <Col id="hardcdnm">-</Col>
  674. <Col id="hardcd"/>
  675. </Row>
  676. <Row>
  677. <Col id="hardcdnm">포장단위일괄변경</Col>
  678. <Col id="hardcd">fSetPurcUnit</Col>
  679. </Row>
  680. <Row>
  681. <Col id="hardcdnm">환산수량일괄변경</Col>
  682. <Col id="hardcd">fSetExchQty</Col>
  683. </Row>
  684. <Row>
  685. <Col id="hardcdnm">수불단위일괄변경</Col>
  686. <Col id="hardcd">fSetDeliveUnit</Col>
  687. </Row>
  688. <Row>
  689. <Col id="hardcdnm">-</Col>
  690. <Col id="hardcd"/>
  691. </Row>
  692. <Row>
  693. <Col id="hardcdnm">단가일괄변경</Col>
  694. <Col id="hardcd">fSetGoodUnitCost</Col>
  695. </Row>
  696. <Row>
  697. <Col id="hardcdnm">-</Col>
  698. <Col id="hardcd"/>
  699. </Row>
  700. <Row>
  701. <Col id="hardcdnm">주거래처일괄변경</Col>
  702. <Col id="hardcd">fSetMainCustLastSuplplce</Col>
  703. </Row>
  704. <Row>
  705. <Col id="hardcdnm">보조거래처일괄변경</Col>
  706. <Col id="hardcd">fSetSuppCustCd</Col>
  707. </Row>
  708. </Rows>
  709. </Dataset>
  710. <Dataset id="ds_init_CopyData_CopyGoodLists_goodexcel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  711. <ColumnInfo>
  712. <Column id="fromdd" type="STRING" size="256"/>
  713. <Column id="goodcd" type="STRING" size="256"/>
  714. <Column id="goodnm" type="STRING" size="256"/>
  715. <Column id="purcflag" type="STRING" size="256"/>
  716. <Column id="purcflagnm" type="STRING" size="256"/>
  717. <Column id="reqprid" type="STRING" size="256"/>
  718. <Column id="reqpridnm" type="STRING" size="256"/>
  719. <Column id="reqmthd" type="STRING" size="256"/>
  720. <Column id="reqmthdnm" type="STRING" size="256"/>
  721. <Column id="goodunitcost" type="STRING" size="256"/>
  722. <Column id="maincustlastsuplplce" type="STRING" size="256"/>
  723. <Column id="suplplcenm" type="STRING" size="256"/>
  724. <Column id="suppcustcd" type="STRING" size="256"/>
  725. <Column id="suppcustnm" type="STRING" size="256"/>
  726. <Column id="prodcmpycd" type="STRING" size="256"/>
  727. <Column id="prodcmpynm" type="STRING" size="256"/>
  728. <Column id="cmt" type="STRING" size="256"/>
  729. </ColumnInfo>
  730. <Rows>
  731. <Row>
  732. <Col id="fromdd"/>
  733. <Col id="goodcd"/>
  734. <Col id="goodnm"/>
  735. <Col id="purcflag"/>
  736. <Col id="purcflagnm"/>
  737. <Col id="reqprid"/>
  738. <Col id="reqpridnm"/>
  739. <Col id="reqmthd"/>
  740. <Col id="reqmthdnm"/>
  741. <Col id="goodunitcost"/>
  742. <Col id="maincustlastsuplplce"/>
  743. <Col id="suplplcenm"/>
  744. <Col id="suppcustcd"/>
  745. <Col id="suppcustnm"/>
  746. <Col id="prodcmpycd"/>
  747. <Col id="prodcmpynm"/>
  748. <Col id="cmt"/>
  749. </Row>
  750. </Rows>
  751. </Dataset>
  752. <Dataset id="ds_init_useyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  753. <ColumnInfo>
  754. <Column id="label" type="STRING" size="256"/>
  755. <Column id="value" type="STRING" size="256"/>
  756. </ColumnInfo>
  757. <Rows>
  758. <Row>
  759. <Col id="label">사용</Col>
  760. <Col id="value">Y</Col>
  761. </Row>
  762. <Row>
  763. <Col id="label">불용</Col>
  764. <Col id="value">N</Col>
  765. </Row>
  766. <Row>
  767. <Col id="label">전체</Col>
  768. <Col id="value">A</Col>
  769. </Row>
  770. </Rows>
  771. </Dataset>
  772. <Dataset id="ds_send_save_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
  773. <Dataset id="ds_send_save" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  774. <ColumnInfo>
  775. <Column id="chngyn" type="STRING" size="256"/>
  776. </ColumnInfo>
  777. <Rows>
  778. <Row>
  779. <Col id="chngyn">Y</Col>
  780. </Row>
  781. </Rows>
  782. </Dataset>
  783. <Dataset id="ds_send_goodhistory" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  784. <ColumnInfo>
  785. <Column id="goodcd" type="STRING" size="256"/>
  786. </ColumnInfo>
  787. <Rows>
  788. <Row>
  789. <Col id="goodcd"/>
  790. </Row>
  791. </Rows>
  792. </Dataset>
  793. <Dataset id="ds_send_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep" oncolumnchanged="ds_send_goodlist_oncolumnchanged">
  794. <ColumnInfo>
  795. <Column id="instcd" type="STRING" size="256"/>
  796. <Column id="lrgcd" type="STRING" size="256"/>
  797. <Column id="lrgnm" type="STRING" size="256"/>
  798. <Column id="mdlcd" type="STRING" size="256"/>
  799. <Column id="mdlnm" type="STRING" size="256"/>
  800. <Column id="smlcd" type="STRING" size="256"/>
  801. <Column id="smlnm" type="STRING" size="256"/>
  802. <Column id="edicd" type="STRING" size="256"/>
  803. <Column id="goodcd" type="STRING" size="256"/>
  804. <Column id="goodflag" type="STRING" size="256"/>
  805. <Column id="goodnm" type="STRING" size="256"/>
  806. <Column id="prodcmpycd" type="STRING" size="256"/>
  807. <Column id="prodcmpynm" type="STRING" size="256"/>
  808. <Column id="maincustlastsuplplce" type="STRING" size="256"/>
  809. <Column id="maincustlastsuplplcenm" type="STRING" size="256"/>
  810. <Column id="suppcustcd" type="STRING" size="256"/>
  811. <Column id="suppcustnm" type="STRING" size="256"/>
  812. <Column id="purcflag" type="STRING" size="256"/>
  813. <Column id="stocmngtflag" type="STRING" size="256"/>
  814. <Column id="reqmthd" type="STRING" size="256"/>
  815. <Column id="allsizeyn" type="STRING" size="256"/>
  816. <Column id="conflag" type="STRING" size="256"/>
  817. <Column id="useyn" type="STRING" size="256"/>
  818. <Column id="fr_fromdd" type="STRING" size="256"/>
  819. <Column id="to_fromdd" type="STRING" size="256"/>
  820. <Column id="reqflag" type="STRING" size="256"/>
  821. <Column id="sch_goodcd" type="STRING" size="256"/>
  822. <Column id="offset" type="STRING" size="256"/>
  823. <Column id="pagesize" type="STRING" size="256"/>
  824. <Column id="oldcd" type="STRING" size="256"/>
  825. </ColumnInfo>
  826. <Rows>
  827. <Row>
  828. <Col id="instcd"/>
  829. <Col id="lrgcd"/>
  830. <Col id="lrgnm"/>
  831. <Col id="mdlcd"/>
  832. <Col id="mdlnm"/>
  833. <Col id="smlcd"/>
  834. <Col id="smlnm"/>
  835. <Col id="edicd"/>
  836. <Col id="goodcd"/>
  837. <Col id="goodflag"/>
  838. <Col id="goodnm"/>
  839. <Col id="prodcmpycd"/>
  840. <Col id="prodcmpynm"/>
  841. <Col id="maincustlastsuplplce"/>
  842. <Col id="maincustlastsuplplcenm"/>
  843. <Col id="suppcustcd"/>
  844. <Col id="suppcustnm"/>
  845. <Col id="purcflag"/>
  846. <Col id="stocmngtflag"/>
  847. <Col id="reqmthd"/>
  848. <Col id="allsizeyn"/>
  849. <Col id="conflag"/>
  850. <Col id="useyn"/>
  851. <Col id="fr_fromdd"/>
  852. <Col id="to_fromdd"/>
  853. <Col id="reqflag"/>
  854. <Col id="sch_goodcd"/>
  855. <Col id="offset"/>
  856. <Col id="pagesize">20</Col>
  857. <Col id="oldcd"/>
  858. </Row>
  859. </Rows>
  860. </Dataset>
  861. <Dataset id="ds_send_save_setautoins" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  862. <ColumnInfo>
  863. <Column id="setyn" type="STRING" size="256"/>
  864. <Column id="insfromdd" type="STRING" size="256"/>
  865. </ColumnInfo>
  866. <Rows>
  867. <Row>
  868. <Col id="setyn">Y</Col>
  869. <Col id="insfromdd"/>
  870. </Row>
  871. </Rows>
  872. </Dataset>
  873. <Dataset id="ds_send_goodcostlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  874. <ColumnInfo>
  875. <Column id="instcd" type="STRING" size="256"/>
  876. <Column id="goodcd" type="STRING" size="256"/>
  877. </ColumnInfo>
  878. <Rows>
  879. <Row>
  880. <Col id="instcd"/>
  881. <Col id="goodcd"/>
  882. </Row>
  883. </Rows>
  884. </Dataset>
  885. </Objects>
  886. <Bind>
  887. <BindItem id="item0" compid="group3.grp_title.cmb_instcd" propid="value" datasetid="ds_send_goodlist" columnid="instcd"/>
  888. <BindItem id="item1" compid="group3.grp_title.input1" propid="value" datasetid="ds_send_goodlist" columnid="to_fromdd"/>
  889. <BindItem id="item2" compid="group3.grp_title.ipt_goodnm" propid="value" datasetid="ds_send_goodlist" columnid="goodnm"/>
  890. <BindItem id="item3" compid="group3.grp_title.ipt_prodcmpycd" propid="value" datasetid="ds_send_goodlist" columnid="prodcmpycd"/>
  891. <BindItem id="item4" compid="group3.grp_title.ipt_prodcmpynm" propid="value" datasetid="ds_send_goodlist" columnid="prodcmpynm"/>
  892. <BindItem id="item5" compid="group3.grp_title.ipt_maincustlastsuplplcenm" propid="value" datasetid="ds_send_goodlist" columnid="maincustlastsuplplcenm"/>
  893. <BindItem id="item6" compid="group3.grp_title.ipt_maincustlastsuplplce" propid="value" datasetid="ds_send_goodlist" columnid="maincustlastsuplplce"/>
  894. <BindItem id="item7" compid="group3.grp_title.ipt_suppcustnm" propid="value" datasetid="ds_send_goodlist" columnid="suppcustnm"/>
  895. <BindItem id="item8" compid="group3.grp_title.ipt_suppcustcd" propid="value" datasetid="ds_send_goodlist" columnid="suppcustcd"/>
  896. <BindItem id="item9" compid="group3.grp_title.ipt_edicd" propid="value" datasetid="ds_send_goodlist" columnid="edicd"/>
  897. <BindItem id="item10" compid="group3.grp_title.ipt_goodcd" propid="value" datasetid="ds_send_goodlist" columnid="sch_goodcd"/>
  898. <BindItem id="item11" compid="group3.grp_title.rbo_useyn" propid="value" datasetid="ds_send_goodlist" columnid="useyn"/>
  899. <BindItem id="item12" compid="group3.grp_title.cmb_goodflag" propid="value" datasetid="ds_send_goodlist" columnid="goodflag"/>
  900. <BindItem id="item13" compid="group3.grp_title.input23" propid="value" datasetid="ds_send_goodlist" columnid="fr_fromdd"/>
  901. <BindItem id="item14" compid="group3.grp_title.ipt_insfromdd" propid="value" datasetid="ds_send_save_setautoins" columnid="insfromdd"/>
  902. <BindItem id="item15" compid="group3.grp_title.ipt_oldcd_search" propid="value" datasetid="ds_send_goodlist" columnid="oldcd"/>
  903. <BindItem id="item16" compid="group3.grp_title.cmb_lrgcd_search" propid="value" datasetid="ds_send_goodlist" columnid="lrgcd"/>
  904. <BindItem id="item17" compid="group3.grp_title.cmb_mdlcd_search" propid="value" datasetid="ds_send_goodlist" columnid="mdlcd"/>
  905. <BindItem id="item18" compid="group3.grp_title.cmb_smlcd_search" propid="value" datasetid="ds_send_goodlist" columnid="smlcd"/>
  906. <BindItem id="item19" compid="group2.opt_popinputcd" propid="value" datasetid="ds_init" columnid="popinputcd"/>
  907. <BindItem id="item20" compid="group2.opt_poptitle" propid="value" datasetid="ds_init" columnid="poptitle"/>
  908. <BindItem id="item21" compid="group2.opt_popcond" propid="value" datasetid="ds_init" columnid="popcond"/>
  909. <BindItem id="item22" compid="group2.opt_popformat" propid="value" datasetid="ds_init" columnid="popformat"/>
  910. <BindItem id="item23" compid="group2.cmb_prcpunit" propid="value" datasetid="ds_init" columnid="prcpunit"/>
  911. </Bind>
  912. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  913. * System Name :
  914. * Job Name :
  915. * Creator :
  916. * Make Date : 2017-06-19
  917. * Description :
  918. *---------------------------------------------------------------------------------------
  919. * Modify Date Modifier Modify Description
  920. *---------------------------------------------------------------------------------------
  921. * 2017-06-19 Live Converter TF->XP
  922. *
  923. *---------------------------------------------------------------------------------------
  924. ****************************************************************************************/
  925. //=======================================================================================
  926. // Lib Include
  927. //---------------------------------------------------------------------------------------
  928. include "com_commonxp::comm_main.xjs";
  929. include "mis_miscommonxp::MIS.xjs";
  930. include "mis_miscommonxp::RSZ001.xjs";
  931. include "mis_purcbasexp::SMRSC03700.xjs";
  932. //=======================================================================================
  933. // Global Form Variable
  934. //---------------------------------------------------------------------------------------
  935. var arErrorCode = new HashArray();
  936. //=======================================================================================
  937. // Function
  938. //---------------------------------------------------------------------------------------
  939. /****************************************************************************************
  940. * Argument : N/A
  941. * Description :
  942. ****************************************************************************************/
  943. //=======================================================================================
  944. // Event
  945. //---------------------------------------------------------------------------------------
  946. /****************************************************************************************
  947. * Components : Form
  948. * Description : 화면 처음 초기화시 폼초기화
  949. ****************************************************************************************/
  950. function SMRSC03700_onload(obj:Form, e:LoadEventInfo) {
  951. frmf_initForm(obj);
  952. //grdf_initGrid(grd_XXX);
  953. //grdf_setGridSort(grd_XXX);
  954. grdf_setRowTypeIcon(group3.swt_select.cse_costlist.grd_costlist, 0);
  955. grdf_setRowTypeIcon(group3.swt_select.cse_costlist.grd_goodhistory, 0);
  956. grdf_setRowTypeIcon(group3.swt_select.cse_goodlist.grd_rscdgchglist, 0);
  957. grdf_setRowTypeIcon(group3.swt_select.cse_costlist.grp_copygood.grd_copygood, 0);
  958. grdf_setGridSort(group3.swt_select.cse_costlist.grd_costlist);
  959. grdf_setGridSort(group3.swt_select.cse_costlist.grd_goodhistory);
  960. grdf_setToolTipBind(group3.swt_select.cse_costlist.grd_costlist);
  961. //화면 Control을 초기화한다
  962. fInitForm();
  963. frmf_createPopupMenuDs("pmn_menu", "pmn_menu_onmenuclick", ds_init_popmenu_grd_costlist_item);
  964. }
  965. /****************************************************************************************
  966. * Components : Grid
  967. * Description : 그리드 버튼 바로 눌러지도록
  968. ****************************************************************************************/
  969. function Grid_onmousemove(obj:Grid, e:GridMouseEventInfo)
  970. {
  971. if(e.row < 0) return;
  972. if(e.col == obj.getBindCellIndex("body","fromdd")
  973. || e.col == obj.getBindCellIndex("body","prodcmpycd")
  974. || e.col == obj.getBindCellIndex("body","maincustlastsuplplce")
  975. || e.col == obj.getBindCellIndex("body","suppcustcd")
  976. ) obj.autoenter = "select";
  977. else obj.autoenter = "key";
  978. }
  979. /****************************************************************************************
  980. * Components : Combo
  981. * Description : 기관코드 변경
  982. ****************************************************************************************/
  983. function group3_grp_title_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  984. misfGridInit(group3.swt_select.cse_costlist.grd_costlist);
  985. misfGridInit(group3.swt_select.cse_goodlist.grd_rscdgchglist);
  986. fUnitSet();
  987. }
  988. /****************************************************************************************
  989. * Components : Button
  990. * Description : 제조회사 검색 팝업
  991. ****************************************************************************************/
  992. function group3_grp_title_btn_prodcmpycd_onclick(obj:Button, e:ClickEventInfo) {
  993. rszfOpenPopUpListByWndName(group3.grp_title.ipt_prodcmpycd,"","prodcmpycd,prodcmpynm","SPRSD00160","","");
  994. }
  995. /****************************************************************************************
  996. * Components : Button
  997. * Description : 주거래처 검색 팝업
  998. ****************************************************************************************/
  999. function group3_grp_title_btn_maincustlastsuplplce_onclick(obj:Button, e:ClickEventInfo) {
  1000. rszfOpenPopUpListByWndName(group3.grp_title.ipt_maincustlastsuplplce,"","maincustlastsuplplce,maincustlastsuplplcenm","SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1001. }
  1002. /****************************************************************************************
  1003. * Components : Button
  1004. * Description : 보조거래처 검색 팝업
  1005. ****************************************************************************************/
  1006. function group3_grp_title_btn_suppcustcd_onclick(obj:Button, e:ClickEventInfo) {
  1007. rszfOpenPopUpListByWndName(group3.grp_title.ipt_suppcustcd,"","suppcustcd,suppcustnm","SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1008. }
  1009. /****************************************************************************************
  1010. * Components : Button
  1011. * Description : 조회
  1012. ****************************************************************************************/
  1013. function group3_grp_title_btn_search_onclick(obj:Button, e:ClickEventInfo) {
  1014. // size 원위치
  1015. fZoomInOut("search")
  1016. if(fCheckRetrieveData() == false) return;
  1017. if(group3.swt_select.tabindex == 0){
  1018. misfMsterDetailRetrieve();
  1019. }
  1020. ds_main_list_good_goodlist.addColumn("font_up","string");
  1021. }
  1022. /****************************************************************************************
  1023. * Components : Combo
  1024. * Description : 물품구분 변경
  1025. ****************************************************************************************/
  1026. function group3_grp_title_cmb_goodflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  1027. misfGridInit(group3.swt_select.cse_costlist.grd_costlist);
  1028. fSetGoodFlagAuth();
  1029. fUnitSet();
  1030. rszfLMSComboList(group3.grp_title.cmb_goodflag.value, "", "", "group3.grp_title.cmb_lrgcd_search", "", "L", "Y", "Y");
  1031. }
  1032. /****************************************************************************************
  1033. * Components : Combo
  1034. * Description : 대분류 변경
  1035. ****************************************************************************************/
  1036. function group3_grp_title_cmb_lrgcd_search_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  1037. rszfLMSComboList(group3.grp_title.cmb_goodflag.value, group3.grp_title.cmb_lrgcd_search.value, "", "group3.grp_title.cmb_mdlcd_search", "", "M", "Y", "Y");
  1038. group3.grp_title.cmb_mdlcd_search.value = "";
  1039. frmf_inputEnterKey("group3.grp_title.cmb_mdlcd_search", "onitemchanged", new ItemChangeEventInfo);
  1040. }
  1041. /****************************************************************************************
  1042. * Components : Combo
  1043. * Description : 중분류 변경
  1044. ****************************************************************************************/
  1045. function group3_grp_title_cmb_mdlcd_search_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  1046. rszfLMSComboList(group3.grp_title.cmb_goodflag.value, group3.grp_title.cmb_lrgcd_search.value, group3.grp_title.cmb_mdlcd_search.value, "group3.grp_title.cmb_smlcd_search", "", "S", "Y", "Y");
  1047. group3.grp_title.cmb_smlcd_search.value = "";
  1048. }
  1049. /****************************************************************************************
  1050. * Components : Button
  1051. * Description : 단가, 거래처 일괄변경 / 엑셀가져오기
  1052. ****************************************************************************************/
  1053. function group3_swt_select_cse_costlist_bbt_excelload_onclick(obj:Button, e:ClickEventInfo) {
  1054. fLoadExcel_2("0",group3.swt_select.cse_costlist.grp_copygood, group3.swt_select.cse_costlist.grp_copygood.grd_copygood);
  1055. }
  1056. /****************************************************************************************
  1057. * Components : Button
  1058. * Description : 크게/작게 보기
  1059. ****************************************************************************************/
  1060. function group3_swt_select_cse_costlist_btn_zoomin_onclick(obj:Button, e:ClickEventInfo) {
  1061. fZoomInOut();
  1062. }
  1063. /****************************************************************************************
  1064. * Components : Button
  1065. * Description : 단가, 거래처 일괄변경 / ZoomIn
  1066. ****************************************************************************************/
  1067. function group3_swt_select_cse_costlist_btn_ZoomIn_onclick(obj:Button, e:ClickEventInfo) {
  1068. fWindowPosition("I");
  1069. }
  1070. /****************************************************************************************
  1071. * Components : Button
  1072. * Description : 단가, 거래처 일괄변경 / ZoomOut
  1073. ****************************************************************************************/
  1074. function group3_swt_select_cse_costlist_btn_ZoomOut_onclick(obj:Button, e:ClickEventInfo) {
  1075. fWindowPosition("O");
  1076. }
  1077. /****************************************************************************************
  1078. * Components : Button
  1079. * Description : 단가, 거래처 일괄변경 / 엑셀저장
  1080. ****************************************************************************************/
  1081. function group3_swt_select_cse_costlist_button3_onclick(obj:Button, e:ClickEventInfo) {
  1082. misfSaveExcel(group3.swt_select.cse_costlist.grd_costlist, "자재SPEC일괄변경List", "Sheet1");
  1083. }
  1084. /****************************************************************************************
  1085. * Components : Grid
  1086. * Description : 단가, 거래처 일괄변경 / 이력정보 선택(1.0 오류발생 사용안하는듯)
  1087. ****************************************************************************************/
  1088. function group3_swt_select_cse_costlist_grd_goodhistory_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
  1089. // if(group3.swt_select.cse_costlist.grd_costlist.currentrow > -1)
  1090. // {
  1091. // dsf_createDs("ds_send_gooddetlist")
  1092. // ds_send_gooddetlist.setColumn( 0, "goodcd", model.getValue(group3.swt_select.cse_costlist.grd_costlist.nodeset + "["+ group3.swt_select.cse_costlist.grd_costlist.row + "]_goodcd" ));
  1093. // ds_send_gooddetlist.setColumn( 0, "fromdd", model.getValue(group3.swt_select.cse_costlist.grd_costlist.nodeset + "["+ group3.swt_select.cse_costlist.grd_costlist.row + "]_fromdd" ));
  1094. // // submit("TRRSC05302");
  1095. // dsf_setDefaultVal(oDataset, "tabname:RSCDGOOD,changedt:20081001,preretr:N");
  1096. // var oParam = {};
  1097. // oParam.id = "TRRSC05302";
  1098. // oParam.service = "purcbaseapp.PurcBaseMngt";
  1099. // oParam.method = "reqGetDetGood";
  1100. // oParam.inds = "req=ds_";
  1101. // oParam.outds = "ds_=gooddetlist ds_=goodconstlist ds_=goodinstlist ds_=oldcdinfo ds_=rscdtchglist ds_=gooddrugprodcmpylist";
  1102. // oParam.async = false;
  1103. // oParam.callback = "cf_TRRSC05302";
  1104. //
  1105. // tranf_submit(oParam);
  1106. // /*
  1107. //
  1108. // function cf_TRRSC05302(sSvcId, nErrorCode, sErrorMsg) {
  1109. // arErrorCode.push(sSvcId, nErrorCode);
  1110. // }
  1111. // arErrorCode.pop("TRRSC05302") > -1
  1112. // arErrorCode.pop("TRRSC05302") < 0
  1113. // */
  1114. //
  1115. //
  1116. // fAfterRetrGoodList();
  1117. // ds_send_gooddetlist.setColumn( 0, "fromdd","" );
  1118. // }
  1119. }
  1120. // function cf_TRRSC05302(sSvcId, nErrorCode, sErrorMsg) {
  1121. // if(nErrorCode < 0) return;
  1122. // }
  1123. /****************************************************************************************
  1124. * Components : Button
  1125. * Description : 자재Spec일괄변경 Excel Data Lists / 행삭제
  1126. ****************************************************************************************/
  1127. function group3_swt_select_cse_costlist_grp_copygood_button2_onclick(obj:Button, e:ClickEventInfo) {
  1128. ds_init_CopyData_CopyGoodLists_goodexcel.deleteRow(ds_init_CopyData_CopyGoodLists_goodexcel.rowposition);
  1129. }
  1130. /****************************************************************************************
  1131. * Components : Button
  1132. * Description : 자재Spec일괄변경 Excel Data Lists / 저장
  1133. ****************************************************************************************/
  1134. function group3_swt_select_cse_costlist_grp_copygood_button7_onclick(obj:Button, e:ClickEventInfo) {
  1135. // 선택물품을 적용하는 처리하는 함수
  1136. fSaveGoodExcel();
  1137. }
  1138. /****************************************************************************************
  1139. * Components : Button
  1140. * Description : 자재Spec일괄변경 Excel Data Lists / 취소
  1141. ****************************************************************************************/
  1142. function group3_swt_select_cse_costlist_grp_copygood_button10_onclick(obj:Button, e:ClickEventInfo) {
  1143. group3.swt_select.cse_costlist.grp_copygood.visible = false;
  1144. misfGridInit(group3.swt_select.cse_costlist.grp_copygood.grd_copygood);
  1145. }
  1146. /****************************************************************************************
  1147. * Components : Button
  1148. * Description : Excel 고시단가 Update / 엑셀자료업로드
  1149. ****************************************************************************************/
  1150. function group3_swt_select_cse_goodlist_btn_loadexcel_onclick(obj:Button, e:ClickEventInfo) {
  1151. fLoadExcel();
  1152. }
  1153. /****************************************************************************************
  1154. * Components : Button
  1155. * Description : Excel 고시단가 Update / 데이터지우기
  1156. ****************************************************************************************/
  1157. function group3_swt_select_cse_goodlist_button1_onclick(obj:Button, e:ClickEventInfo) {
  1158. misfGridInit(group3.swt_select.cse_goodlist.grd_rscdgchglist);
  1159. group3.swt_select.cse_goodlist.cap_cnt.text = "0";
  1160. }
  1161. /****************************************************************************************
  1162. * Components : Button
  1163. * Description : Excel 고시단가 Update / 행삭제
  1164. ****************************************************************************************/
  1165. function group3_swt_select_cse_goodlist_button8_onclick(obj:Button, e:ClickEventInfo) {
  1166. ds_main_list_rscdgchg_rscdgchglist.deleteRow(ds_main_list_rscdgchg_rscdgchglist.rowposition);
  1167. group3.swt_select.cse_goodlist.cap_cnt.text = group3.swt_select.cse_goodlist.grd_rscdgchglist.rowcount;
  1168. }
  1169. function group3_caption10_onclick(obj:Static, e:ClickEventInfo) {
  1170. //window.load("\\..\\자재SPEC일괄변경_SAMPLE_2.xls","html");
  1171. }
  1172. /****************************************************************************************
  1173. * Components : Button
  1174. * Description : 저장
  1175. ****************************************************************************************/
  1176. function group2_btn_save_onclick(obj:Button, e:ClickEventInfo) {
  1177. fSaveDataSetting();
  1178. }
  1179. /****************************************************************************************
  1180. * Components : Button
  1181. * Description : 초기화
  1182. ****************************************************************************************/
  1183. function group2_btn_clear_onclick(obj:Button, e:ClickEventInfo) {
  1184. fInitialize();
  1185. }
  1186. function group2_cmb_prcpunit_onitemchanged(obj:Combo, e:ItemChangeEventInfo) {
  1187. fSetGoodFlagAuth();
  1188. }
  1189. /****************************************************************************************
  1190. * Components : Edit
  1191. * Description : 조회조건 변경시 처리
  1192. ****************************************************************************************/
  1193. function Edit_onkeyup(obj:Edit, e:KeyEventInfo)
  1194. {
  1195. if(e.keycode == 13) obj.updateToDataset();
  1196. }
  1197. function ds_send_goodlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  1198. {
  1199. //주거래처 조회
  1200. if(e.columnid == "maincustlastsuplplce") {
  1201. if(utlf_isNull(e.newvalue)) {
  1202. group3.grp_title.ipt_maincustlastsuplplcenm.value = "";
  1203. } else {
  1204. group3.grp_title.ipt_maincustlastsuplplce.setFocus();
  1205. rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm", group3.grp_title.cmb_instcd.value +",," + e.newvalue,"","maincustlastsuplplce,maincustlastsuplplcenm" ,group3.grp_title.ipt_maincustlastsuplplce,"SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1206. }
  1207. }
  1208. if(e.columnid == "maincustlastsuplplcenm") {
  1209. if(utlf_isNull(e.newvalue)) {
  1210. group3.grp_title.ipt_maincustlastsuplplce.value = "";
  1211. } else {
  1212. group3.grp_title.ipt_maincustlastsuplplcenm.setFocus();
  1213. rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm",
  1214. group3.grp_title.cmb_instcd.value +",custnm," + e.newvalue,
  1215. "","maincustlastsuplplce,maincustlastsuplplcenm" ,group3.grp_title.ipt_maincustlastsuplplce,"SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1216. }
  1217. }
  1218. //보조거래처 조회
  1219. if(e.columnid == "suppcustcd") {
  1220. if (utlf_isNull(e.newvalue)) {
  1221. group3.grp_title.ipt_suppcustnm.value = "";
  1222. } else {
  1223. group3.grp_title.ipt_suppcustcd.setFocus();
  1224. rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm", group3.grp_title.cmb_instcd.value +",," + e.newvalue,"","suppcustcd,suppcustnm" ,group3.grp_title.ipt_suppcustcd,"SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1225. }
  1226. }
  1227. if(e.columnid == "suppcustnm") {
  1228. if(utlf_isNull(e.newvalue)) {
  1229. group3.grp_title.ipt_suppcustcd.value = "";
  1230. } else {
  1231. group3.grp_title.ipt_suppcustnm.setFocus();
  1232. rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm",
  1233. group3.grp_title.cmb_instcd.value +",custnm," + e.newvalue,
  1234. "","suppcustcd,suppcustnm" ,group3.grp_title.ipt_suppcustcd,"SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1235. }
  1236. }
  1237. //제조회사
  1238. if(e.columnid == "prodcmpycd") {
  1239. if(utlf_isNull(e.newvalue)) {
  1240. group3.grp_title.ipt_prodcmpynm.value = "";
  1241. } else {
  1242. group3.grp_title.ipt_prodcmpycd.setFocus();
  1243. rszfValidationCheck("TRRSD00161", "prodcmpylist", "refcond,prodcmpycd,prodcmpynm","prodcmpycd," + e.newvalue + "," ,"","prodcmpycd,prodcmpynm" ,group3.grp_title.ipt_prodcmpycd,"SPRSD00160","","");
  1244. }
  1245. }
  1246. if(e.columnid == "prodcmpynm") {
  1247. if(utlf_isNull(e.newvalue)) {
  1248. group3.grp_title.ipt_prodcmpycd.value = "";
  1249. } else {
  1250. group3.grp_title.ipt_prodcmpynm.setFocus();
  1251. rszfValidationCheck("TRRSD00161", "prodcmpylist", "refcond,prodcmpycd,prodcmpynm",
  1252. "prodcmpynm,," + e.newvalue,
  1253. "","prodcmpycd,prodcmpynm" ,group3.grp_title.ipt_prodcmpycd,"SPRSD00160","","");
  1254. }
  1255. }
  1256. }
  1257. /****************************************************************************************
  1258. * Components : Grid
  1259. * Description : 자재Spec일괄변경 Excel Data Lists / 그리드버튼 클릭
  1260. ****************************************************************************************/
  1261. function group3_swt_select_cse_costlist_grp_copygood_grd_copygood_onexpandup(obj:Grid, e:GridMouseEventInfo) {
  1262. if(e.col == obj.getBindCellIndex("body","prodcmpycd")) {
  1263. rszfOpenPopUpListByWndName(obj,"","prodcmpycd,prodcmpynm","SPRSD00160","","");
  1264. } else if(e.col == obj.getBindCellIndex("body","maincustlastsuplplce")) {
  1265. rszfOpenPopUpListByWndName(obj,"","maincustlastsuplplce,suplplcenm","SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1266. } else if(e.col == obj.getBindCellIndex("body","suppcustcd")) {
  1267. rszfOpenPopUpListByWndName(obj,"","suppcustcd,suppcustnm","SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1268. }
  1269. }
  1270. /****************************************************************************************
  1271. * Components : Button
  1272. * Description : 단가, 거래처 일괄변경 / 그리드 변경시 조회
  1273. ****************************************************************************************/
  1274. function group3_swt_select_cse_costlist_grd_costlist_onselectchanged(obj:Grid, e:GridSelectEventInfo)
  1275. {
  1276. misfMsterDetailRetrieve();
  1277. }
  1278. /****************************************************************************************
  1279. * Components : Button
  1280. * Description : 단가, 거래처 일괄변경 / 그리드 우클릭 팝업메뉴
  1281. ****************************************************************************************/
  1282. function group3_swt_select_cse_costlist_grd_costlist_onrbuttonup(obj:Grid, e:GridMouseEventInfo)
  1283. {
  1284. if(e.row > -1) {
  1285. grdf_setSelectedCell(obj, e); // 선택된 행 확실히 선택해줌
  1286. pmn_menu.trackPopup(e.screenX,e.screenY);
  1287. }
  1288. return true;
  1289. }
  1290. /****************************************************************************************
  1291. * Components : PopupMenu
  1292. * Description : 단가, 거래처 일괄변경 / 팝업메뉴 함수 실행
  1293. ****************************************************************************************/
  1294. function pmn_menu_onmenuclick(obj:PopupMenu, e:MenuClickEventInfo)
  1295. {
  1296. eval(e.id + "()");
  1297. }
  1298. /****************************************************************************************
  1299. * Components : Grid
  1300. * Description : 단가, 거래처 일괄변경 / 그리드 버튼 실행
  1301. ****************************************************************************************/
  1302. function group3_swt_select_cse_costlist_grd_costlist_onexpandup(obj:Grid, e:GridMouseEventInfo)
  1303. {
  1304. if(e.col == obj.getBindCellIndex("body","prodcmpycd")) {
  1305. rszfOpenPopUpListByWndName(obj,"","prodcmpycd,prodcmpynm","SPRSD00160","","");
  1306. } else if(e.col == obj.getBindCellIndex("body","maincustlastsuplplce")) {
  1307. rszfOpenPopUpListByWndName(obj,"","maincustlastsuplplce,maincustlastsuplplcenm","SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1308. } else if(e.col == obj.getBindCellIndex("body","suppcustcd")) {
  1309. rszfOpenPopUpListByWndName(obj,"","suppcustcd,suppcustnm","SPRSD00220","instcd","group3.grp_title.cmb_instcd");
  1310. }
  1311. }
  1312. ]]></Script>
  1313. </Form>
  1314. </FDL>