SMRSC08300_상한가변경 물품내역비교.xfdl 52 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRSC08300" position="absolute 0 0 1206 802" titletext="상한가 변경 물품내역비교" oninit="SMRSC08300_oninit" onload="SMRSC08300_onload">
  5. <Layouts>
  6. <Layout>
  7. <Combo id="cmb_instcd" taborder="4" innerdataset="ds_init_cmb_instcd" codecolumn="cdid" datacolumn="cdnm" class="combo_default" visible="false" position="absolute 500 202 520 221"/>
  8. <Tab id="switch1" taborder="5" tabindex="0" position="absolute 0 33 1195 781" anchor="all">
  9. <Tabpages>
  10. <Tabpage id="case_compare" text="내 역 비 교" style="anchor:default;">
  11. <Layouts>
  12. <Layout>
  13. <Static id="caption35" text="상한가 변경 물품 내역 비교" class="tit_2" position="absolute 0 54 265 77"/>
  14. <Shape id="line2" linetype="horizontal" class="line_10" position="absolute 0 70 1195 76" anchor="left top right"/>
  15. <Grid id="grd_keumcomparelst" taborder="22" binddataset="ds_main_cmprlst_cmprinfo" useinputpanel="false" position="absolute 0 75 1195 715" autoenter="select" cellsizingtype="col" anchor="all" oncelldblclick="switch1_case_compare_grd_keumcomparelst_oncelldblclick" selecttype="multirow" onlbuttonup="switch1_case_compare_grd_keumcomparelst_onlbuttonup">
  16. <Formats>
  17. <Format id="default">
  18. <Columns>
  19. <Column size="25" band="left"/>
  20. <Column size="20" band="left"/>
  21. <Column size="35" band="left"/>
  22. <Column size="40" band="left"/>
  23. <Column size="87" band="left"/>
  24. <Column size="135" band="left"/>
  25. <Column size="79"/>
  26. <Column size="93"/>
  27. <Column size="90"/>
  28. <Column size="70"/>
  29. <Column size="70"/>
  30. <Column size="70"/>
  31. <Column size="70"/>
  32. <Column size="70"/>
  33. <Column size="96"/>
  34. <Column size="90"/>
  35. <Column size="90"/>
  36. <Column size="55"/>
  37. <Column size="80"/>
  38. <Column size="100"/>
  39. <Column size="60"/>
  40. <Column size="100"/>
  41. <Column size="60"/>
  42. <Column size="200"/>
  43. <Column size="150"/>
  44. <Column size="0"/>
  45. <Column size="0"/>
  46. <Column size="0"/>
  47. <Column size="0"/>
  48. <Column size="0"/>
  49. <Column size="0"/>
  50. <Column size="0"/>
  51. </Columns>
  52. <Rows>
  53. <Row size="36" band="head"/>
  54. <Row size="24"/>
  55. </Rows>
  56. <Band id="head">
  57. <Cell/>
  58. <Cell col="1" displaytype="checkbox" edittype="checkbox" taborder="undefined"/>
  59. <Cell col="2" text="처리&#10;여부" taborder="undefined"/>
  60. <Cell col="3" text="구분" taborder="undefined"/>
  61. <Cell col="4" text="물품코드"/>
  62. <Cell col="5" text="물품명"/>
  63. <Cell col="6" text="규격"/>
  64. <Cell col="7" text="EDI코드"/>
  65. <Cell col="8" text="제조회사명"/>
  66. <Cell col="9" text="변경전&#10;직전계약가"/>
  67. <Cell col="10" text="변경전&#10;상한가"/>
  68. <Cell col="11" text="변경전&#10;계약가"/>
  69. <Cell col="12" text="변경후&#10;상한가"/>
  70. <Cell col="13" text="변경후&#10;계약가"/>
  71. <Cell col="14" text="거래처"/>
  72. <Cell col="15" text="단가계약(From)"/>
  73. <Cell col="16" text="단가계약(To)"/>
  74. <Cell col="17" text="단가계약&#10;여부"/>
  75. <Cell col="18" text="기준일자"/>
  76. <Cell col="19" text="품의일자&#10;품의번호"/>
  77. <Cell col="20" text="품의&#10;순번"/>
  78. <Cell col="21" text="계약일자&#10;계약번호"/>
  79. <Cell col="22" text="계약&#10;순번"/>
  80. <Cell col="23" text="비고"/>
  81. <Cell col="24" text="변경계약사유"/>
  82. <Cell col="25" text="flag"/>
  83. <Cell col="26"/>
  84. <Cell col="27"/>
  85. <Cell col="28"/>
  86. <Cell col="29"/>
  87. <Cell col="30"/>
  88. <Cell col="31" text="시행전계약"/>
  89. </Band>
  90. <Band id="body">
  91. <Cell celltype="head"/>
  92. <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:select" expr="expr:select == 'Y' || select == '1' ? 1 : 0"/>
  93. <Cell col="2" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:state"/>
  94. <Cell col="3" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:teamnm"/>
  95. <Cell col="4" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:goodcd"/>
  96. <Cell col="5" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:goodnm" wordwrap="word"/>
  97. <Cell col="6" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:goodspec" wordwrap="word"/>
  98. <Cell col="7" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:edicd"/>
  99. <Cell col="8" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:prodcmpynm" wordwrap="word"/>
  100. <Cell col="9" displaytype="number" text="bind:bfgoodunitcost"/>
  101. <Cell col="10" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:bfupperlimit"/>
  102. <Cell col="11" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:goodunitcost"/>
  103. <Cell col="12" displaytype="number" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:afupperlimit"/>
  104. <Cell col="13" displaytype="number" edittype="masknumber" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:upperlimit"/>
  105. <Cell col="14" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:maincustlastsuplplce" wordwrap="word"/>
  106. <Cell col="15" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:fromconterm"/>
  107. <Cell col="16" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:toconterm"/>
  108. <Cell col="17" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:costconyn"/>
  109. <Cell col="18" displaytype="date" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:basedd" calendardisplaynulltype="nulltext"/>
  110. <Cell col="19" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purcnst"/>
  111. <Cell col="20" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purccnsttnseq"/>
  112. <Cell col="21" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:aspurccon"/>
  113. <Cell col="22" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purcconseq"/>
  114. <Cell col="23" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:remark" wordwrap="word"/>
  115. <Cell col="24" displaytype="text" edittype="text" style="align:left top;padding:5 2 1 2;background:BIND(colBack);background2:BIND(colBack);" text="bind:chngcmt" wordwrap="word"/>
  116. <Cell col="25" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:flag"/>
  117. <Cell col="26" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purccnsttndd"/>
  118. <Cell col="27" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purccnsttnno"/>
  119. <Cell col="28" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purccondd"/>
  120. <Cell col="29" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:purcconno"/>
  121. <Cell col="30" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:cmt"/>
  122. <Cell col="31" style="background:BIND(colBack);background2:BIND(colBack);" text="bind:bfcontflag"/>
  123. </Band>
  124. </Format>
  125. </Formats>
  126. </Grid>
  127. <Div id="grp_sea" taborder="25" position="absolute 0 2 1195 42" class="div_SA2" anchor="left top right">
  128. <Layouts>
  129. <Layout>
  130. <Static id="caption2" text="계정과목 :" class="search_name" position="absolute 208 12 286 29" anchor="default"/>
  131. <Shape id="line13" linetype="vertical" class="line_4" position="absolute 1067 9 1073 31" anchor="top right"/>
  132. <Calendar id="ipt_srchbasedd" taborder="9" class="input_default" position="absolute 592 10 663 29" mask="yyyy-mm" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="switch1_case_compare_grp_sea_ipt_srchbasedd_onchanged"/>
  133. <Static id="caption1" text="기준일자 :" class="search_name" position="absolute 517 12 607 29" anchor="default"/>
  134. <Button id="btn_regnohelp" taborder="10" class="icon_search" position="absolute 792 12 808 28" anchor="default" onclick="switch1_case_compare_grp_sea_btn_regnohelp_onclick"/>
  135. <Edit id="ipt_maincustlastsuplplcenm" taborder="11" position="absolute 810 10 921 29" anchor="default" class="output" style="background:URL('theme://images/bg_edit_R.png') stretch 5,5;"/>
  136. <Edit id="ipt_maincustlastsuplplce" taborder="12" class="input_default" position="absolute 735 10 789 29" anchor="default" autoselect="true" autoskip="true"/>
  137. <Static id="caption14" text="물품코드 :" class="search_name" position="absolute 5 12 104 29" anchor="default"/>
  138. <Edit id="ipt_srchgoodcd" taborder="13" class="input_default" position="absolute 84 10 189 29" anchor="default" autoselect="true" autoskip="true"/>
  139. <Static id="caption5" text="거래처 :" class="search_name" position="absolute 672 11 738 28" anchor="default"/>
  140. <Edit id="ipt_srchwinacnt" taborder="14" class="input_essential" position="absolute 287 10 367 29" anchor="default" autoselect="true" autoskip="true"/>
  141. <Edit id="opt_srchwinacntnm" taborder="15" readonly="true" position="absolute 390 10 505 29" anchor="default" class="output"/>
  142. <Button id="btn_srchwinacnt" taborder="16" class="icon_search" position="absolute 370 13 386 29" anchor="default" onclick="switch1_case_compare_grp_sea_btn_srchwinacnt_onclick"/>
  143. <Button id="button6" taborder="17" text="초기화" class="btn2" visible="false" position="absolute 1077 9 1094 31" anchor="top right" onclick="switch1_case_compare_grp_sea_button6_onclick"/>
  144. <Button id="button4" taborder="18" text="저장" class="btn4" position="absolute 1136 9 1192 31" anchor="top right" onclick="switch1_case_compare_grp_sea_button4_onclick"/>
  145. <Button id="btn_sea" taborder="19" text="조회" class="btn1" position="absolute 1077 9 1133 31" anchor="top right" onclick="switch1_case_compare_grp_sea_btn_sea_onclick"/>
  146. <Combo id="cmb_instcd" taborder="20" innerdataset="ds_init_cmb_instcd" codecolumn="cdid" datacolumn="cdnm" class="combo_default" visible="false" position="absolute 190 10 210 29"/>
  147. <CheckBox id="checkbox1" taborder="21" position="absolute 1047 7 1068 31" truevalue="PH" onclick="switch1_case_compare_grp_sea_checkbox1_onclick" falsevalue=" "/>
  148. <Static id="Static00" text="약품" position="absolute 1018 9 1045 31"/>
  149. <Static id="Static01" text="시행전계약" position="absolute 928 10 991 32" onclick="switch1_case_compare_grp_sea_Static01_onclick" visible="false"/>
  150. <CheckBox id="checkbox00" taborder="22" value=" " truevalue="BC" falsevalue=" " onclick="switch1_case_compare_grp_sea_checkbox00_onclick" position="absolute 993 7 1014 31" visible="false"/>
  151. </Layout>
  152. </Layouts>
  153. </Div>
  154. <Static id="caption3" position="absolute 795 49 995 69" style="color:#0000ffff;font:돋움체,10,bold;"/>
  155. <Button id="button5" taborder="26" text="Excel 저장" class="btn5" position="absolute 1120 51 1195 70" anchor="top right" onclick="switch1_case_compare_button5_onclick"/>
  156. </Layout>
  157. </Layouts>
  158. </Tabpage>
  159. <Tabpage id="case_upload" text="업 로 드">
  160. <Layouts>
  161. <Layout>
  162. <Static id="caption7" text="상한가 변경 물품 내역 업로드" class="tit_2" position="absolute 0 54 215 75"/>
  163. <Shape id="line3" linetype="horizontal" class="line_10" position="absolute 0 70 1195 76" anchor="left top right"/>
  164. <Static id="caption4" position="absolute 916 46 1056 64" style="color:#0000ffff;font:돋움체,10,bold;"/>
  165. <Grid id="grd_upperlimitupload" taborder="1" binddataset="ds_main_upperlimitlst_upperlimitinfo" useinputpanel="false" position="absolute 0 75 1195 720" autoenter="select" autofittype="none" cellsizingtype="col" anchor="all" oncellclick="switch1_case_upload_grd_upperlimitupload_oncellclick" selecttype="multirow">
  166. <Formats>
  167. <Format id="default">
  168. <Columns>
  169. <Column size="22"/>
  170. <Column size="150"/>
  171. <Column size="200"/>
  172. <Column size="200"/>
  173. <Column size="150"/>
  174. <Column size="400"/>
  175. </Columns>
  176. <Rows>
  177. <Row size="24" band="head"/>
  178. <Row size="24"/>
  179. </Rows>
  180. <Band id="head">
  181. <Cell/>
  182. <Cell col="1" text="EDI 코드"/>
  183. <Cell col="2" text="변경전 상한가(숫자만)"/>
  184. <Cell col="3" text="변경후 상한가(숫자만)"/>
  185. <Cell col="4" text="기준일자(YYYYMMDD)"/>
  186. <Cell col="5" text="비고"/>
  187. </Band>
  188. <Band id="body">
  189. <Cell celltype="head"/>
  190. <Cell col="1" text="bind:edicd"/>
  191. <Cell col="2" displaytype="number" style="align:center middle;" text="bind:bfupperlimit"/>
  192. <Cell col="3" displaytype="number" style="align:center middle;" text="bind:afupperlimit"/>
  193. <Cell col="4" displaytype="date" text="bind:basedd" calendardisplaynulltype="nulltext"/>
  194. <Cell col="5" text="bind:remark"/>
  195. </Band>
  196. </Format>
  197. </Formats>
  198. </Grid>
  199. <Button id="button1" taborder="2" text="업로드" class="btn5" position="absolute 1141 51 1194 70" onclick="switch1_case_upload_button1_onclick"/>
  200. <Div id="group1" taborder="3" position="absolute 0 2 1195 42" class="div_SA2" anchor="left top right">
  201. <Layouts>
  202. <Layout>
  203. <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1049 9 1055 31"/>
  204. <Button id="btn_search" taborder="4" text="조회" class="btn1" position="absolute 1061 8 1117 30" onclick="switch1_case_upload_group1_btn_search_onclick"/>
  205. <Button id="btn_save" taborder="5" text="저장" class="btn4" position="absolute 1125 8 1181 30" onclick="switch1_case_upload_group1_btn_save_onclick"/>
  206. <Static id="caption8" text="기준일자 :" class="search_name" position="absolute 16 12 106 29"/>
  207. <Calendar id="ipt_ubasedd" taborder="6" class="input_default" position="absolute 104 10 204 29" mask="yyyy-mm" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" style="align:center middle;"/>
  208. </Layout>
  209. </Layouts>
  210. </Div>
  211. <Button id="button3" taborder="4" text="전체삭제" class="btn5" position="absolute 1072 51 1136 70" onclick="switch1_case_upload_button3_onclick"/>
  212. </Layout>
  213. </Layouts>
  214. </Tabpage>
  215. </Tabpages>
  216. </Tab>
  217. <Static id="caption6" text="상한가 변경 물품 내역 비교" class="tit_1" position="absolute 0 0 280 25"/>
  218. <Div id="rectangle1" taborder="2" style="background:#ffffccff;border:1 solid #808080ff ;" position="absolute 257 30 990 51">
  219. <Layouts>
  220. <Layout>
  221. <Static id="caption9" text="- 선택클릭 , - Ctrl+클릭 , - 드래그 또는 Shift+클릭 , - 전체선택 또는 전체삭제 클릭" position="absolute 65 2 725 17" anchor="default"/>
  222. <Static id="caption10" text="단일선택" position="absolute 7 3 67 15" style="color:#ff0000ff;font:Dotum,9,bold;" anchor="default"/>
  223. <Static id="caption11" text="건별선택" position="absolute 148 3 208 15" style="color:#ff0000ff;font:Dotum,9,bold;" anchor="default"/>
  224. <Static id="caption12" text="구간선택" position="absolute 287 3 347 15" style="color:#ff0000ff;font:Dotum,9,bold;" anchor="default"/>
  225. <Static id="caption13" text="전체선택" position="absolute 498 3 558 15" style="color:#ff0000ff;font:Dotum,9,bold;" anchor="default"/>
  226. </Layout>
  227. </Layouts>
  228. </Div>
  229. <Button id="btn_exe" taborder="3" text="일괄처리" class="btn3" position="absolute 1096 29 1176 51" anchor="top right" onclick="btn_exe_onclick"/>
  230. </Layout>
  231. </Layouts>
  232. <Objects>
  233. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_oncolumnchanged">
  234. <ColumnInfo>
  235. <Column id="srchgoodcd" type="STRING" size="256"/>
  236. <Column id="srchwinacnt" type="STRING" size="256"/>
  237. <Column id="srchwinacntnm" type="STRING" size="256"/>
  238. <Column id="srchbasedd" type="STRING" size="256"/>
  239. <Column id="srchmaincustlastsuplplce" type="STRING" size="256"/>
  240. <Column id="srchmaincustlastsuplplcenm" type="STRING" size="256"/>
  241. <Column id="ugoodcd" type="STRING" size="256"/>
  242. <Column id="uwinacnt" type="STRING" size="256"/>
  243. <Column id="uwinacntnm" type="STRING" size="256"/>
  244. <Column id="ubasedd" type="STRING" size="256"/>
  245. <Column id="umaincustlastsuplplce" type="STRING" size="256"/>
  246. <Column id="umaincustlastsuplplcenm" type="STRING" size="256"/>
  247. <Column id="sdata" type="STRING" size="256"/>
  248. <Column id="entrregno" type="STRING" size="256"/>
  249. <Column id="refcond" type="STRING" size="256"/>
  250. <Column id="retrnm" type="STRING" size="256"/>
  251. <Column id="custstat" type="STRING" size="256"/>
  252. <Column id="list" type="STRING" size="256"/>
  253. <Column id="instcd" type="STRING" size="256"/>
  254. <Column id="ufromdd" type="STRING" size="256"/>
  255. <Column id="utodd" type="STRING" size="256"/>
  256. <Column id="srchfromdd" type="STRING" size="256"/>
  257. <Column id="srchtodd" type="STRING" size="256"/>
  258. <Column id="selectyn" type="STRING" size="256"/>
  259. <Column id="purccnsttndd" type="STRING" size="256"/>
  260. <Column id="purccnsttnno" type="STRING" size="256"/>
  261. <Column id="purccondd" type="STRING" size="256"/>
  262. <Column id="purcconno" type="STRING" size="256"/>
  263. <Column id="phflag" type="STRING" size="256"/>
  264. <Column id="bfcont" type="STRING" size="256"/>
  265. </ColumnInfo>
  266. <Rows>
  267. <Row>
  268. <Col id="srchgoodcd"/>
  269. <Col id="srchwinacnt"/>
  270. <Col id="srchwinacntnm"/>
  271. <Col id="srchbasedd"/>
  272. <Col id="srchmaincustlastsuplplce"/>
  273. <Col id="srchmaincustlastsuplplcenm"/>
  274. <Col id="ugoodcd"/>
  275. <Col id="uwinacnt"/>
  276. <Col id="uwinacntnm"/>
  277. <Col id="ubasedd"/>
  278. <Col id="umaincustlastsuplplce"/>
  279. <Col id="umaincustlastsuplplcenm"/>
  280. <Col id="sdata"/>
  281. <Col id="entrregno"/>
  282. <Col id="refcond"/>
  283. <Col id="retrnm"/>
  284. <Col id="custstat"/>
  285. <Col id="list"/>
  286. <Col id="instcd"/>
  287. <Col id="ufromdd"/>
  288. <Col id="utodd"/>
  289. <Col id="srchfromdd"/>
  290. <Col id="srchtodd"/>
  291. <Col id="selectyn"/>
  292. <Col id="purccnsttndd"/>
  293. <Col id="purccnsttnno"/>
  294. <Col id="purccondd"/>
  295. <Col id="purcconno"/>
  296. <Col id="phflag"/>
  297. </Row>
  298. </Rows>
  299. </Dataset>
  300. <Dataset id="ds_main_cmprlst_cmprinfo" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_cmprlst_cmprinfo_oncolumnchanged">
  301. <ColumnInfo>
  302. <Column id="select" type="STRING" size="256" sumtext="선택"/>
  303. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드"/>
  304. <Column id="goodnm" type="STRING" size="256" sumtext="물품명"/>
  305. <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
  306. <Column id="prodcmpynm" type="STRING" size="256" sumtext="제조회사"/>
  307. <Column id="edicd" type="STRING" size="256" sumtext="edi코드"/>
  308. <Column id="bfupperlimit" type="STRING" size="256" sumtext="변경전상한가"/>
  309. <Column id="goodunitcost" type="STRING" size="256" sumtext="변경전계약가"/>
  310. <Column id="afupperlimit" type="STRING" size="256" sumtext="변경후상한가"/>
  311. <Column id="upperlimit" type="STRING" size="256" sumtext="변경후계약가"/>
  312. <Column id="maincustlastsuplplce" type="STRING" size="256" sumtext="거래처"/>
  313. <Column id="costconyn" type="STRING" size="256" sumtext="단가계약여부"/>
  314. <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
  315. <Column id="purcnst" type="STRING" size="256" sumtext="품의일자/품의번호"/>
  316. <Column id="purccnsttnseq" type="STRING" size="256" sumtext="품의순번"/>
  317. <Column id="aspurccon" type="STRING" size="256" sumtext="계약일자/계약번호"/>
  318. <Column id="purcconseq" type="STRING" size="256" sumtext="계약순번"/>
  319. <Column id="remark" type="STRING" size="256" sumtext="비고"/>
  320. <Column id="chngcmt" type="STRING" size="256" sumtext="변경계약사유"/>
  321. <Column id="state" type="STRING" size="256" sumtext="처리여부"/>
  322. <Column id="flag" type="STRING" size="256" sumtext="분기flag"/>
  323. <Column id="purccnsttndd" type="STRING" size="256" sumtext="품의일자"/>
  324. <Column id="purccnsttnno" type="STRING" size="256" sumtext="품의번호"/>
  325. <Column id="purccondd" type="STRING" size="256" sumtext="계약일자"/>
  326. <Column id="purcconno" type="STRING" size="256" sumtext="계약번호"/>
  327. <Column id="cmt" type="STRING" size="256" sumtext="계약비고"/>
  328. <Column id="teamnm" type="STRING" size="256" sumtext="구분"/>
  329. <Column id="fromconterm" type="STRING" size="256"/>
  330. <Column id="toconterm" type="STRING" size="256"/>
  331. <Column id="bfcont" type="STRING" size="256"/>
  332. <Column id="bfcontflag" type="STRING" size="256"/>
  333. <Column id="colBack" type="STRING" size="256"/>
  334. <Column id="status" type="STRING" size="256"/>
  335. <Column id="bfgoodunitcost" type="STRING" size="256" sumtext="변경전직전계약단가"/>
  336. </ColumnInfo>
  337. </Dataset>
  338. <Dataset id="ds_main_upperlimitlst_upperlimitinfo" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  339. <ColumnInfo>
  340. <Column id="edicd" type="STRING" size="256" sumtext="EDI코드"/>
  341. <Column id="bfupperlimit" type="STRING" size="256" sumtext="변경전상한가"/>
  342. <Column id="afupperlimit" type="STRING" size="256" sumtext="변경후상한가"/>
  343. <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
  344. <Column id="remark" type="STRING" size="256" sumtext="비고"/>
  345. </ColumnInfo>
  346. </Dataset>
  347. <Dataset id="ds_main_list_custlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  348. <ColumnInfo>
  349. <Column id="entrregno" type="STRING" size="256" sumtext="사업자등록번호"/>
  350. <Column id="custnm" type="STRING" size="256" sumtext="거래처명"/>
  351. <Column id="prsdnm" type="STRING" size="256" sumtext="대표자명"/>
  352. <Column id="cntctel" type="STRING" size="256" sumtext="전화번호"/>
  353. <Column id="addr" type="STRING" size="256" sumtext="전체주소"/>
  354. <Column id="bizcont" type="STRING" size="256" sumtext="업태"/>
  355. <Column id="item" type="STRING" size="256" sumtext="종목"/>
  356. <Column id="fromdd" type="STRING" size="256" sumtext="시작일자"/>
  357. <Column id="todd" type="STRING" size="256" sumtext="종료일자"/>
  358. <Column id="custcode" type="STRING" size="256" sumtext="거래처코드"/>
  359. </ColumnInfo>
  360. </Dataset>
  361. <Dataset id="ds_popbattret_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  362. <Dataset id="ds_temp_main_cmprlst_cmprinfo" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_cmprlst_cmprinfo_oncolumnchanged">
  363. <ColumnInfo>
  364. <Column id="select" type="STRING" size="256" sumtext="선택"/>
  365. <Column id="goodcd" type="STRING" size="256" sumtext="물품코드"/>
  366. <Column id="goodnm" type="STRING" size="256" sumtext="물품명"/>
  367. <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
  368. <Column id="prodcmpynm" type="STRING" size="256" sumtext="제조회사"/>
  369. <Column id="edicd" type="STRING" size="256" sumtext="edi코드"/>
  370. <Column id="bfupperlimit" type="STRING" size="256" sumtext="변경전상한가"/>
  371. <Column id="goodunitcost" type="STRING" size="256" sumtext="변경전계약가"/>
  372. <Column id="afupperlimit" type="STRING" size="256" sumtext="변경후상한가"/>
  373. <Column id="upperlimit" type="STRING" size="256" sumtext="변경후계약가"/>
  374. <Column id="maincustlastsuplplce" type="STRING" size="256" sumtext="거래처"/>
  375. <Column id="costconyn" type="STRING" size="256" sumtext="단가계약여부"/>
  376. <Column id="basedd" type="STRING" size="256" sumtext="기준일자"/>
  377. <Column id="purcnst" type="STRING" size="256" sumtext="품의일자/품의번호"/>
  378. <Column id="purccnsttnseq" type="STRING" size="256" sumtext="품의순번"/>
  379. <Column id="aspurccon" type="STRING" size="256" sumtext="계약일자/계약번호"/>
  380. <Column id="purcconseq" type="STRING" size="256" sumtext="계약순번"/>
  381. <Column id="remark" type="STRING" size="256" sumtext="비고"/>
  382. <Column id="chngcmt" type="STRING" size="256" sumtext="변경계약사유"/>
  383. <Column id="state" type="STRING" size="256" sumtext="처리여부"/>
  384. <Column id="flag" type="STRING" size="256" sumtext="분기flag"/>
  385. <Column id="purccnsttndd" type="STRING" size="256" sumtext="품의일자"/>
  386. <Column id="purccnsttnno" type="STRING" size="256" sumtext="품의번호"/>
  387. <Column id="purccondd" type="STRING" size="256" sumtext="계약일자"/>
  388. <Column id="purcconno" type="STRING" size="256" sumtext="계약번호"/>
  389. <Column id="cmt" type="STRING" size="256" sumtext="계약비고"/>
  390. <Column id="teamnm" type="STRING" size="256" sumtext="구분"/>
  391. <Column id="fromconterm" type="STRING" size="256"/>
  392. <Column id="toconterm" type="STRING" size="256"/>
  393. <Column id="bfcont" type="STRING" size="256"/>
  394. <Column id="bfcontflag" type="STRING" size="256"/>
  395. <Column id="colBack" type="STRING" size="256"/>
  396. </ColumnInfo>
  397. </Dataset>
  398. </Objects>
  399. <Bind>
  400. <BindItem id="item0" compid="switch1.case_compare.grp_sea.ipt_srchgoodcd" propid="value" datasetid="ds_send" columnid="srchgoodcd"/>
  401. <BindItem id="item1" compid="switch1.case_compare.grp_sea.ipt_srchwinacnt" propid="value" datasetid="ds_send" columnid="srchwinacnt"/>
  402. <BindItem id="item2" compid="switch1.case_compare.grp_sea.opt_srchwinacntnm" propid="value" datasetid="ds_send" columnid="srchwinacntnm"/>
  403. <BindItem id="item3" compid="switch1.case_compare.grp_sea.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
  404. <BindItem id="item4" compid="switch1.case_compare.grp_sea.ipt_srchbasedd" propid="value" datasetid="ds_send" columnid="srchbasedd"/>
  405. <BindItem id="item5" compid="switch1.case_compare.grp_sea.ipt_maincustlastsuplplce" propid="value" datasetid="ds_send" columnid="srchmaincustlastsuplplce"/>
  406. <BindItem id="item6" compid="switch1.case_compare.grp_sea.ipt_maincustlastsuplplcenm" propid="value" datasetid="ds_send" columnid="srchmaincustlastsuplplcenm"/>
  407. <BindItem id="item7" compid="switch1.case_compare.grp_sea.checkbox1" propid="value" datasetid="ds_send" columnid="phflag"/>
  408. <BindItem id="item8" compid="switch1.case_upload.group1.ipt_ubasedd" propid="value" datasetid="ds_send" columnid="ubasedd"/>
  409. <BindItem id="item9" compid="switch1.case_compare.grp_sea.checkbox00" propid="value" datasetid="ds_send" columnid="bfcont"/>
  410. </Bind>
  411. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  412. 99System Name :
  413. * Job Name :
  414. * Creator :
  415. * Make Date : 2017-06-19
  416. * Description :
  417. *---------------------------------------------------------------------------------------
  418. * Modify Date Modifier Modify Description
  419. *---------------------------------------------------------------------------------------
  420. * 2017-06-19 Live Converter TF->XP
  421. *
  422. *---------------------------------------------------------------------------------------
  423. ****************************************************************************************/
  424. include "com_commonxp::comm_main.xjs";
  425. include "mis_miscommonxp::MIS.xjs";
  426. include "mis_miscommonxp::RSZ001.xjs";
  427. var arErrorCode = new HashArray();
  428. function SMRSC08300_oninit(obj:Form, e:InitEventInfo)
  429. {
  430. frmf_initForm(obj);
  431. }
  432. function SMRSC08300_onload(obj:Form, e:LoadEventInfo)
  433. {
  434. grdf_initGrid(switch1.case_compare.grd_keumcomparelst);
  435. grdf_setRowTypeIcon(switch1.case_compare.grd_keumcomparelst, 0);
  436. grdf_initGrid(switch1.case_upload.grd_upperlimitupload);
  437. grdf_setRowTypeIcon(switch1.case_upload.grd_upperlimitupload, 0);
  438. fGetScreenInit();
  439. var gDutplceinstcd = sysf_getUserInfo("dutplceinstcd");
  440. var userid = sysf_getUserInfo("userid");
  441. ds_send.setColumn(0, "instcd", gDutplceinstcd);
  442. if ( userid == "99207" || userid == "16474"){
  443. switch1.case_compare.grp_sea.Static01.visible = true ;
  444. switch1.case_compare.grp_sea.checkbox00.visible = true ;
  445. }else{
  446. switch1.case_compare.grp_sea.Static01.visible = false ;
  447. switch1.case_compare.grp_sea.checkbox00.visible = false ;
  448. }
  449. }
  450. function fGetScreenInit()
  451. {
  452. misfGridInit(switch1.case_compare.grd_keumcomparelst);
  453. misfGridInit(switch1.case_upload.grd_upperlimitupload);
  454. ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  455. ds_send.setColumn(0, "srchbasedd", String(utlf_getCurrentDate()).substr(0,6));
  456. ds_send.setColumn(0, "ubasedd", String(utlf_getCurrentDate()).substr(0,6));
  457. switch1.tabindex = 0;
  458. }
  459. function ds_send_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  460. {
  461. if(e.columnid == "srchgoodcd")
  462. {
  463. switch1.case_compare.grp_sea.ipt_srchgoodcd.value = e.newvalue;
  464. switch1.case_compare.grp_sea.ipt_srchgoodcd.setFocus();
  465. obj.setColumn(0, "srchcustnm", "");
  466. if(String(ds_send.getColumn(0, "srchentrregno")).length == 10 )
  467. {
  468. ds_send.setColumn(0, "custstat", "1");
  469. ds_send.setColumn(0, "refcond", "entrregno");
  470. ds_send.setColumn(0, "retrnm", ds_send.getColumn(0, "srchentrregno"));
  471. var oParam = {};
  472. oParam.id = "TRRAC90601";
  473. oParam.service = "miscommoncdrefapp.CommonCdRef";
  474. oParam.method = "reqGetCustomerList";
  475. oParam.inds = "req=ds_send";
  476. oParam.outds = "ds_main_list_custlist=custlist";
  477. oParam.async = false;
  478. oParam.callback = "cf_TRRAC90601";
  479. tranf_submit(oParam);
  480. }
  481. }
  482. if(e.columnid == "srchwinacnt")
  483. {
  484. switch1.case_compare.grp_sea.ipt_srchwinacnt.value = e.newvalue;
  485. switch1.case_compare.grp_sea.ipt_srchwinacnt.setFocus();
  486. if(utlf_isNull(e.newvalue))
  487. {
  488. switch1.case_compare.grp_sea.opt_srchwinacntnm.value = "";
  489. }
  490. else
  491. {
  492. rszfValidationCheck("TRRAC00111", "acntlist", "acntflag,useyn,jobgb,srhtxt","1,,," + e.newvalue ,"","winacnt,winacntnm" ,switch1.case_compare.grp_sea.ipt_srchwinacnt,"PPRAC00100","","");
  493. }
  494. }
  495. if(e.columnid == "srchmaincustlastsuplplce")
  496. {
  497. switch1.case_compare.grp_sea.ipt_maincustlastsuplplce.value = e.newvalue;
  498. switch1.case_compare.grp_sea.ipt_maincustlastsuplplce.setFocus();
  499. misfSearchCust(switch1.case_compare.grp_sea.ipt_maincustlastsuplplcenm,switch1.case_compare.grp_sea.cmb_instcd);
  500. }
  501. }
  502. function cf_TRRAC90601(sSvcId, nErrorCode, sErrorMsg)
  503. {
  504. if(nErrorCode < 0) return;
  505. else
  506. {
  507. ds_send.setColumn(0, "srchcustnm", ds_main_list_custlist.getColumn(0, "custnm"));
  508. }
  509. }
  510. function switch1_case_compare_grp_sea_btn_srchwinacnt_onclick(obj:Button, e:ClickEventInfo)
  511. {
  512. rszfOpenPopUpListByWndName(switch1.case_compare.grp_sea.ipt_srchwinacnt,"","srchwinacnt,srchwinacntnm","PPRAC00100","","");
  513. }
  514. function switch1_case_compare_grp_sea_ipt_srchbasedd_onchanged(obj:Calendar, e:ChangeEventInfo)
  515. {
  516. ds_send.setColumn(0, "srchbasedd", String(obj.value).substr(0,6));
  517. }
  518. function switch1_case_compare_grp_sea_btn_regnohelp_onclick(obj:Button, e:ClickEventInfo)
  519. {
  520. var sinstcd = ds_send.getColumn(0, "instcd");
  521. rszfOpenPopUpListByWndName(switch1.case_compare.grp_sea.ipt_maincustlastsuplplce,"","srchmaincustlastsuplplce,srchmaincustlastsuplplcenm","SPRSD00220","instcd",sinstcd);
  522. }
  523. function switch1_case_compare_grp_sea_checkbox1_onclick(obj:CheckBox, e:ClickEventInfo)
  524. {
  525. if(obj.value == "PH")
  526. {
  527. }
  528. else
  529. {
  530. ds_send.setColumn(0, "phflag", "");
  531. }
  532. }
  533. function switch1_case_compare_grp_sea_button6_onclick(obj:Button, e:ClickEventInfo)
  534. {
  535. ds_send.setColumn(0, "srchwinacnt", "");
  536. ds_send.setColumn(0, "srchwinacntnm", "");
  537. ds_send.setColumn(0, "srchmaincustlastsuplplce", "");
  538. ds_send.setColumn(0, "srchmaincustlastsuplplcenm", "");
  539. }
  540. function switch1_case_compare_grp_sea_btn_sea_onclick(obj:Button, e:ClickEventInfo)
  541. {
  542. var srchbasedd = ds_send.getColumn(0, "srchbasedd");
  543. ds_send.setColumn(0, "srchfromdd", srchbasedd +"01");
  544. ds_send.setColumn(0, "srchtodd", srchbasedd +"31");
  545. var oParam = {};
  546. oParam.id = "TRRSC08304";
  547. oParam.service = "purcbaseapp.PurcBaseMngt";
  548. oParam.method = "reqGetCmprLst";
  549. oParam.inds = "req=ds_send";
  550. oParam.outds = "ds_main_cmprlst_cmprinfo=cmprinfo";
  551. oParam.async = false;
  552. oParam.callback = "cf_TRRSC08304";
  553. tranf_submit(oParam);
  554. ds_main_cmprlst_cmprinfo.addColumn("status", "string");
  555. // ds_main_cmprlst_cmprinfo.updatecontrol = false;
  556. //
  557. // ds_main_cmprlst_cmprinfo.setColumn(0, "colBack", "white");
  558. //
  559. // for( var i=1 ; i<ds_main_cmprlst_cmprinfo.rowcount ; i++ ){
  560. // if( ds_main_cmprlst_cmprinfo.getColumn(i-1, "aspurccon") == ds_main_cmprlst_cmprinfo.getColumn(i, "aspurccon") ){
  561. // ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", ds_main_cmprlst_cmprinfo.getColumn(i-1, "colBack"));
  562. // }else{
  563. // ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", (ds_main_cmprlst_cmprinfo.getColumn(i-1, "colBack")=="lightgrey" ? "white" : "lightgrey"));
  564. // }
  565. // }
  566. //
  567. // ds_main_cmprlst_cmprinfo.updatecontrol = true;
  568. ds_main_cmprlst_cmprinfo.rowposition = 0;
  569. // for(var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++)
  570. // {
  571. // var flag = ds_main_cmprlst_cmprinfo.getColumn(i, "bfcontflag");
  572. //
  573. // if(flag == "Y")
  574. // {
  575. // ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "#FFFFCC");
  576. // }
  577. // else
  578. // {
  579. // ds_main_cmprlst_cmprinfo.setColumn(i, "colBack", "white");
  580. // }
  581. // }
  582. }
  583. function cf_TRRSC08304(sSvcId, nErrorCode, sErrorMsg)
  584. {
  585. if(nErrorCode < 0) return;
  586. else
  587. {
  588. var lstCnt = ds_main_cmprlst_cmprinfo.rowcount;
  589. switch1.case_compare.caption3.text = "(건수:" + lstCnt + "건)";
  590. }
  591. }
  592. function ds_main_cmprlst_cmprinfo_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  593. {
  594. if(e.columnid == "select")
  595. {
  596. obj.setColumn(e.row, "select", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
  597. if(e.newvalue == 0)
  598. {
  599. obj.updatecontrol = false;
  600. obj.setRowType(e.row, "");
  601. obj.updatecontrol = true;
  602. }
  603. else
  604. {
  605. obj.updatecontrol = false;
  606. obj.setRowType(e.row, "u");
  607. obj.updatecontrol = true;
  608. }
  609. }
  610. if(e.columnid == "chngcmt" )
  611. {
  612. var chngcmt = e.newvalue;
  613. var aspurccon = obj.getColumn(e.row, "aspurccon");
  614. for(var i = 0; i < obj.rowcount; i++)
  615. {
  616. var aspurccon1 = obj.getColumn(i, "aspurccon");
  617. if(aspurccon1 == aspurccon)
  618. {
  619. obj.setColumn(i, "chngcmt", chngcmt);
  620. obj.setColumn(i, "select", "Y");
  621. obj.updatecontrol = false;
  622. obj.setRowType(i, "u");
  623. obj.updatecontrol = true;
  624. }
  625. }
  626. }
  627. if(e.columnid == "remark" )
  628. {
  629. obj.setColumn(e.row, "select", "Y");
  630. }
  631. }
  632. function switch1_case_compare_grd_keumcomparelst_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  633. {
  634. var instcd = sysf_getUserInfo("dutplceinstcd");
  635. var flag = ds_main_cmprlst_cmprinfo.getColumn(ds_main_cmprlst_cmprinfo.rowposition, "flag");
  636. var aspurccon = ds_main_cmprlst_cmprinfo.getColumn(ds_main_cmprlst_cmprinfo.rowposition, "aspurccon");
  637. var purccondd = String(aspurccon).substr(0,8);
  638. var purcconno = String(aspurccon).substr(11,4);
  639. dsf_makeValue(ds_popbattret_send, "instcd", "string", instcd, 0);
  640. dsf_makeValue(ds_popbattret_send, "purccondd", "string", purccondd, 0);
  641. dsf_makeValue(ds_popbattret_send, "purcconno", "string", purcconno, 0);
  642. if(e.cell == obj.getBindCellIndex("Body", "aspurccon"))
  643. {
  644. if(flag == "PH")
  645. {
  646. var objArg = new Object();
  647. objArg.arg_ds_temp_callopen = ds_popbattret_send;
  648. frmf_modal("SMRSP00800", "SMRSP00800", objArg, "", "", "", "", "", "", "", "", "", "M");
  649. }
  650. else
  651. {
  652. var objArg = new Object();
  653. objArg.arg_ds_temp_callopen = ds_popbattret_send;
  654. frmf_modal("SMRSP00100", "SMRSP00100", objArg, "", "", "", "", "", "", "", "", "", "M");
  655. }
  656. }
  657. else if(e.cell == obj.getBindCellIndex("Body", "purcconseq"))
  658. {
  659. var objArg = new Object();
  660. objArg.arg_ds_temp_callopen = ds_popbattret_send;
  661. frmf_modal("SMRSP00300", "SMRSP00300", objArg, "", "", "", "", "", "", "", "", "", "M");
  662. }
  663. }
  664. function switch1_case_compare_button5_onclick(obj:Button, e:ClickEventInfo)
  665. {
  666. if( ds_main_cmprlst_cmprinfo.rowcount > 0)
  667. {
  668. var fileName = "상한가변경 물품내역_" + utlf_getCurrentDate();
  669. grdf_exportExcel(switch1.case_compare.grd_keumcomparelst, fileName, "Sheet", "true", "", "");
  670. }
  671. else
  672. {
  673. sysf_messageBox("저장 데이터가","I004");
  674. }
  675. }
  676. function switch1_case_compare_grp_sea_button4_onclick(obj:Button, e:ClickEventInfo)
  677. {
  678. ds_main_cmprlst_cmprinfo.updatecontrol = false;
  679. for(var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++)
  680. {
  681. var basedd = ds_main_cmprlst_cmprinfo.getColumn(i, "basedd");
  682. var edicd = ds_main_cmprlst_cmprinfo.getColumn(i, "edicd");
  683. var costconyn = ds_main_cmprlst_cmprinfo.getColumn(i, "costconyn");
  684. if(ds_main_cmprlst_cmprinfo.getRowType(i) == 4 && costconyn == "N")
  685. {
  686. sysf_messageBox(parseInt(i+1)+"번째 [" + ds_main_cmprlst_cmprinfo.getColumn(i, "goodnm") + "]품목이 단가계약 되어있지않아 일괄처리할 수", "I004", "");
  687. return false;
  688. }
  689. ds_main_cmprlst_cmprinfo.setColumn(i, "status", "u");
  690. }
  691. ds_main_cmprlst_cmprinfo.updatecontrol = true;
  692. updtdata = grdf_getGridUpdateData(switch1.case_compare.grd_keumcomparelst).rowcount;
  693. if(updtdata == 0)
  694. {
  695. sysf_messageBox("저장할 데이터가 ","E014");
  696. return false;
  697. }
  698. else
  699. {
  700. var oParam = {};
  701. oParam.id = "TXRSC08305";
  702. oParam.service = "purcbaseapp.PurcBaseMngt";
  703. oParam.method = "reqSetUpperlimitUpdate";
  704. oParam.inds = "keumcomparelst=ds_main_cmprlst_cmprinfo:a";
  705. oParam.outds = "ds_=item";
  706. oParam.async = false;
  707. oParam.callback = "cf_TXRSC08305";
  708. tranf_submit(oParam);
  709. }
  710. }
  711. function cf_TXRSC08305(sSvcId, nErrorCode, sErrorMsg)
  712. {
  713. if(nErrorCode < 0)
  714. {
  715. sysf_messageBox("저장","E009");
  716. return;
  717. }
  718. else
  719. {
  720. sysf_messageBox("저장이","I002");
  721. switch1.case_compare.grp_sea.btn_sea.click();
  722. }
  723. }
  724. function switch1_case_upload_group1_btn_search_onclick(obj:Button, e:ClickEventInfo)
  725. {
  726. switch1.case_upload.caption4.text = "";
  727. var ubasedd = utlf_transNullToEmpty(ds_send.getColumn(0, "ubasedd"));
  728. ds_send.setColumn(0, "ufromdd", ubasedd.substr(0, 6) +"01");
  729. ds_send.setColumn(0, "utodd", ubasedd.substr(0, 6) +"31");
  730. var oParam = {};
  731. oParam.id = "TRRSC08303";
  732. oParam.service = "purcbaseapp.PurcBaseMngt";
  733. oParam.method = "reqGetUpperLimitLst";
  734. oParam.inds = "req=ds_send";
  735. oParam.outds = "ds_main_upperlimitlst_upperlimitinfo=upperlimitinfo";
  736. oParam.async = false;
  737. oParam.callback = "cf_TRRSC08303";
  738. tranf_submit(oParam);
  739. }
  740. function cf_TRRSC08303(sSvcId, nErrorCode, sErrorMsg)
  741. {
  742. if(nErrorCode < 0) return;
  743. else
  744. {
  745. var lstCnt = ds_main_upperlimitlst_upperlimitinfo.rowcount;
  746. if( lstCnt > 0 )
  747. {
  748. switch1.case_upload.caption4.text = "(건수:" + lstCnt + "건)";
  749. }
  750. }
  751. }
  752. function switch1_case_upload_grd_upperlimitupload_oncellclick(obj:Grid, e:GridClickEventInfo)
  753. {
  754. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
  755. for(var i = 0; i < ds_main_upperlimitlst_upperlimitinfo.rowcount; i++)
  756. {
  757. ds_main_upperlimitlst_upperlimitinfo.setRowType(i, "");
  758. }
  759. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
  760. var rows = grdf_getSelectedRows(switch1.case_upload.grd_upperlimitupload);
  761. for(var i = 0; i < rows.length; i++)
  762. {
  763. var m_row = rows[i];
  764. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
  765. ds_main_upperlimitlst_upperlimitinfo.setRowType(m_row, "d");
  766. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
  767. }
  768. }
  769. function switch1_case_upload_button3_onclick(obj:Button, e:ClickEventInfo)
  770. {
  771. for (var i = 0; i < ds_main_upperlimitlst_upperlimitinfo.rowcount; i++)
  772. {
  773. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
  774. ds_main_upperlimitlst_upperlimitinfo.setRowType(i, "d");
  775. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
  776. }
  777. }
  778. function switch1_case_upload_button1_onclick(obj:Button, e:ClickEventInfo)
  779. {
  780. ds_main_upperlimitlst_upperlimitinfo.clearData();
  781. grdf_ImportExcel("ds_main_upperlimitlst_upperlimitinfo", 1, switch1.case_upload.grd_upperlimitupload, 0);
  782. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = false;
  783. for (var i = 0; i < ds_main_upperlimitlst_upperlimitinfo.rowcount; i++)
  784. {
  785. ds_main_upperlimitlst_upperlimitinfo.setRowType(i, "i");
  786. }
  787. grdf_setStatusColumn(ds_main_upperlimitlst_upperlimitinfo, "status");
  788. ds_main_upperlimitlst_upperlimitinfo.updatecontrol = true;
  789. var lstCnt = ds_main_upperlimitlst_upperlimitinfo.rowcount;
  790. if( lstCnt > 0 )
  791. {
  792. var oParam = {};
  793. oParam.id = "TXRSC08303";
  794. oParam.service = "purcbaseapp.PurcBaseMngt";
  795. oParam.method = "reqSetUpperlimitInsrt";
  796. oParam.inds = "sdata=ds_main_upperlimitlst_upperlimitinfo:u";
  797. oParam.outds = "";
  798. oParam.async = false;
  799. oParam.callback = "cf_TXRSC08303";
  800. tranf_submit(oParam);
  801. if( arErrorCode.pop("TXRSC08303") > -1 ){
  802. switch1.case_upload.group1.btn_search.click();
  803. sysf_messageBox("업로드되었습니다.", "I000");
  804. switch1.case_upload.caption4.text = "(건수:" + lstCnt + "건)";
  805. }
  806. }
  807. }
  808. function cf_TXRSC08303(sSvcId, nErrorCode, sErrorMsg) {
  809. arErrorCode.push(sSvcId, nErrorCode);
  810. }
  811. function btn_exe_onclick(obj:Button, e:ClickEventInfo)
  812. {
  813. if( sysf_messageBox("변경계약 일괄처리", "S001") == "6" ){
  814. ds_main_cmprlst_cmprinfo.updatecontrol = false;
  815. for( var i=0 ; i<ds_main_cmprlst_cmprinfo.rowcount ; i++ ){
  816. ds_main_cmprlst_cmprinfo.setColumn(i, "bfcont", switch1.case_compare.grp_sea.checkbox00.value);
  817. ds_main_cmprlst_cmprinfo.setColumn(i, "status", "u");
  818. if( ds_main_cmprlst_cmprinfo.getColumn(i, "select") == "Y" ){
  819. if( ds_main_cmprlst_cmprinfo.getColumn(i, "state") == "Y" ){
  820. sysf_messageBox(parseInt(i+1) + "번째 [" + ds_main_cmprlst_cmprinfo.getColumn(i, "goodnm") + "]품목이 이미 일괄처리되어", "I010", "");
  821. return false;
  822. }else if( ds_main_cmprlst_cmprinfo.getColumn(i, "costconyn") == "N" ){
  823. sysf_messageBox(parseInt(i+1) + "번째 [" + ds_main_cmprlst_cmprinfo.getColumn(i, "goodnm") + "]품목이 단가계약 되어있지않아 일괄처리할 수", "I004", "");
  824. return false;
  825. }
  826. }
  827. }
  828. ds_main_cmprlst_cmprinfo.updatecontrol = true;
  829. var bfEdicd = "";
  830. var sMessage = "";
  831. ds_temp_main_cmprlst_cmprinfo.copyData(ds_main_cmprlst_cmprinfo);
  832. for( var i=0 ; i<ds_main_cmprlst_cmprinfo.rowcount ; i++ ){
  833. if( ds_main_cmprlst_cmprinfo.getColumn(i, "state") != "Y" && ds_main_cmprlst_cmprinfo.getColumn(i, "select") == "Y" && bfEdicd != ds_main_cmprlst_cmprinfo.getColumn(i, "edicd") ){
  834. bfEdicd = ds_main_cmprlst_cmprinfo.getColumn(i, "edicd");
  835. ds_temp_main_cmprlst_cmprinfo.filter("state!='Y' && select!='Y' && edicd=='"+ds_main_cmprlst_cmprinfo.getColumn(i, "edicd")+"'");
  836. for( var j=0 ; j<ds_temp_main_cmprlst_cmprinfo.rowcount ; j++ ){
  837. sMessage += "- 계약업체 : "+ds_temp_main_cmprlst_cmprinfo.getColumn(j, "maincustlastsuplplce")+"\n"+
  838. "- 계약번호 : "+ds_temp_main_cmprlst_cmprinfo.getColumn(j, "aspurccon")+"\n"+
  839. "- 품목번호 : "+ds_temp_main_cmprlst_cmprinfo.getColumn(j, "purcconseq")+"\n\n";
  840. }
  841. ds_temp_main_cmprlst_cmprinfo.filter("");
  842. }
  843. }
  844. if( !utlf_isNull(sMessage) ){
  845. if( sysf_messageBox("일괄처리 내역 중 EDI코드 동일품목이 다른 계약에도 포함되어 있으므로 동시에 일괄처리 하시기 바랍니다. 그래도 진행하시겠습니까?\n\n"+sMessage, "Q999") == 7 ){
  846. return false;
  847. }
  848. }
  849. bfEdicd = "";
  850. var bFlagCheck = false;
  851. for( var i=0 ; i<ds_main_cmprlst_cmprinfo.rowcount ; i++ ){
  852. if( ds_main_cmprlst_cmprinfo.getColumn(i, "state") != "Y" && ds_main_cmprlst_cmprinfo.getColumn(i, "select") == "Y" && bfEdicd != ds_main_cmprlst_cmprinfo.getColumn(i, "aspurccon") ){
  853. bfEdicd = ds_main_cmprlst_cmprinfo.getColumn(i, "aspurccon");
  854. ds_temp_main_cmprlst_cmprinfo.filter("state!='Y' && select!='Y' && aspurccon=='"+ds_main_cmprlst_cmprinfo.getColumn(i, "aspurccon")+"'");
  855. if( ds_temp_main_cmprlst_cmprinfo.rowcount > 0 ){
  856. bFlagCheck = true;
  857. break;
  858. }
  859. ds_temp_main_cmprlst_cmprinfo.filter("");
  860. }
  861. }
  862. if( bFlagCheck ){
  863. if( sysf_messageBox("동일 계약 건에 일괄처리가 누락된 품목이 있습니다. 그래도 진행하시겠습니까?", "Q999") == 7 ){
  864. return false;
  865. }
  866. }
  867. updtdata = grdf_getGridUpdateData(switch1.case_compare.grd_keumcomparelst).rowcount;
  868. if(updtdata == 0)
  869. {
  870. sysf_messageBox("일괄처리할 데이터를","C002");
  871. return false;
  872. }
  873. else
  874. {
  875. var oParam = {};
  876. oParam.id = "TXRSC08306";
  877. oParam.service = "purcbaseapp.PurcBaseMngt";
  878. oParam.method = "reqSetChngDateUpdate";
  879. oParam.inds = "exelist=ds_main_cmprlst_cmprinfo:a";
  880. oParam.outds = "ds_=item";
  881. oParam.async = false;
  882. oParam.callback = "cf_TXRSC08306";
  883. tranf_submit(oParam);
  884. }
  885. }
  886. }
  887. function cf_TXRSC08306(sSvcId, nErrorCode, sErrorMsg)
  888. {
  889. if(nErrorCode < 0)
  890. {
  891. sysf_messageBox("처리","E009");
  892. return;
  893. }
  894. else
  895. {
  896. sysf_messageBox("처리가","I002");
  897. switch1.case_compare.grp_sea.btn_sea.click();
  898. }
  899. }
  900. function switch1_case_upload_group1_btn_save_onclick(obj:Button, e:ClickEventInfo)
  901. {
  902. if(ds_main_upperlimitlst_upperlimitinfo.rowcount != 0)
  903. {
  904. var oParam = {};
  905. oParam.id = "TXRSC08304";
  906. oParam.service = "purcbaseapp.PurcBaseMngt";
  907. oParam.method = "reqSetUpperlimitDelete";
  908. oParam.inds = "upperlimitinfo=ds_main_upperlimitlst_upperlimitinfo:u";
  909. oParam.outds = "ds_=item";
  910. oParam.async = false;
  911. oParam.callback = "cf_TXRSC08304";
  912. tranf_submit(oParam);
  913. }
  914. }
  915. function cf_TXRSC08304(sSvcId, nErrorCode, sErrorMsg)
  916. {
  917. if(nErrorCode < 0) return;
  918. else
  919. {
  920. switch1.case_upload.group1.btn_search.click();
  921. sysf_messageBox(" ", "I001", "");
  922. }
  923. }
  924. function switch1_case_compare_grd_keumcomparelst_onlbuttonup(obj:Grid, e:GridMouseEventInfo)
  925. {
  926. if (e.row >= 0 && e.col >= 0) {
  927. var arr = grdf_getSelectedRows(switch1.case_compare.grd_keumcomparelst);
  928. ds_main_cmprlst_cmprinfo.enableevent = false;
  929. ds_main_cmprlst_cmprinfo.updatecontrol = false;
  930. for (var i = 0; i < ds_main_cmprlst_cmprinfo.rowcount; i++) {
  931. ds_main_cmprlst_cmprinfo.setColumn(i, "select", "N");
  932. ds_main_cmprlst_cmprinfo.setRowType(i, 1);
  933. }
  934. for (var j = 0; j < arr.length;j++) {
  935. ds_main_cmprlst_cmprinfo.setColumn(arr[j], "select", "Y");
  936. ds_main_cmprlst_cmprinfo.setRowType(arr[j], 4);
  937. }
  938. ds_main_cmprlst_cmprinfo.updatecontrol = true;
  939. ds_main_cmprlst_cmprinfo.enableevent = true;
  940. }
  941. }
  942. function switch1_case_compare_grp_sea_checkbox00_onclick(obj:CheckBox, e:ClickEventInfo)
  943. {
  944. if(obj.value == "BC")
  945. {
  946. }
  947. else
  948. {
  949. ds_send.setColumn(0, "bfcont", "");
  950. }
  951. }
  952. ]]></Script>
  953. </Form>
  954. </FDL>