SMRSM01200_물류물품코드MSDS여부수정.xfdl 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRSM01200" position="absolute 0 0 1196 784" titletext="MSDS 정보 수정(물류)" oninit="SMRSM01200_oninit" onload="SMRSM01200_onload">
  5. <Layouts>
  6. <Layout>
  7. <Shape id="line4" linetype="horizontal" class="line_2" position="absolute 770 325 1190 331" style="align:center middle;" anchor="top right"/>
  8. <Static id="caption6" text="MSDS 정보 수정(물류)" class="tit_1" position="absolute 0 0 203 25" style="align:left middle;" anchor="left top"/>
  9. <Shape id="line2" linetype="horizontal" class="line_6" position="absolute 0 31 1194 37" style="align:center middle;" anchor="left top right"/>
  10. <Button id="btn_save" taborder="1" text="일괄저장" class="btn4" position="absolute 1113 8 1193 30" onclick="btn_save_onclick" style="align:right middle;" anchor="top right"/>
  11. <Div id="grp_sea" taborder="2" class="div_SA2" position="absolute 0 35 1194 75" style="align:center middle;" anchor="left top right">
  12. <Layouts>
  13. <Layout>
  14. <Static id="caption7" text="물품코드" class="search_name" position="absolute 56 13 135 30" anchor="left top" style="align:left middle;"/>
  15. <Shape id="line5" linetype="vertical" class="line_4" position="absolute 507 10 513 32" anchor="top right" style="align:center middle;"/>
  16. <Button id="btn_search" taborder="2" text="조회" class="btn1" position="absolute 528 10 584 32" anchor="top right" onclick="grp_sea_btn_search_onclick" style="align:left middle;"/>
  17. <Edit id="ipt_goodcd" taborder="3" class="input_default" position="absolute 134 12 225 31" anchor="left top" style="align:left middle;" autoselect="true"/>
  18. <Static id="caption1" text="물품명" class="search_name" position="absolute 256 13 320 30" anchor="left top" style="align:left middle;"/>
  19. <Edit id="ipt_goodnm" taborder="4" class="input_default" position="absolute 321 12 475 31" anchor="left top" style="align:left middle;" autoselect="true"/>
  20. </Layout>
  21. </Layouts>
  22. </Div>
  23. <Shape id="line3" linetype="horizontal" class="line_10" position="absolute 0 109 765 115" style="align:center middle;" anchor="left top right"/>
  24. <Shape id="line1" linetype="horizontal" class="line_10" position="absolute 770 109 1190 115" style="align:center middle;" anchor="top right"/>
  25. <Static id="caption21" text="물품 목록" class="tit_2" position="absolute 1 93 79 110" style="align:left top;" anchor="left top"/>
  26. <Static id="caption20" text="상세내역" class="tit_2" position="absolute 770 93 854 109" style="align:left top;" anchor="top right"/>
  27. <Grid id="grd_goodlist" taborder="3" binddataset="ds_main_goodlist" useinputpanel="false" position="absolute 0 114 765 744" oncellclick="grd_goodlist_oncellclick" style="align:center middle;" anchor="all">
  28. <Formats>
  29. <Format id="default">
  30. <Columns>
  31. <Column size="33" band="left"/>
  32. <Column size="77"/>
  33. <Column size="188"/>
  34. <Column size="86"/>
  35. <Column size="94"/>
  36. <Column size="94"/>
  37. <Column size="72"/>
  38. <Column size="0"/>
  39. <Column size="0"/>
  40. <Column size="0"/>
  41. <Column size="77"/>
  42. <Column size="82"/>
  43. <Column size="100"/>
  44. <Column size="100"/>
  45. </Columns>
  46. <Rows>
  47. <Row size="24" band="head"/>
  48. <Row size="24"/>
  49. </Rows>
  50. <Band id="head">
  51. <Cell/>
  52. <Cell col="1" text="물품코드"/>
  53. <Cell col="2" text="물품명"/>
  54. <Cell col="3" text="규격"/>
  55. <Cell col="4" text="제조회사"/>
  56. <Cell col="5" text="주거래처"/>
  57. <Cell col="6" text="MSDS여부"/>
  58. <Cell col="7" text="MSDS여부_old"/>
  59. <Cell col="8" text="제조회사코드"/>
  60. <Cell col="9" text="주거래처코드"/>
  61. <Cell col="10" text="최초등록일"/>
  62. <Cell col="11" text="최종구매일"/>
  63. <Cell col="12" text="사용부서"/>
  64. <Cell col="13" text="적용일자"/>
  65. </Band>
  66. <Band id="body">
  67. <Cell celltype="head"/>
  68. <Cell col="1" class="text_center" text="bind:goodcd"/>
  69. <Cell col="2" style="align:left top;padding:4 2 2 2;" text="bind:goodnm" wordwrap="word"/>
  70. <Cell col="3" style="align:left top;padding:4 2 2 2;" text="bind:goodspec" wordwrap="word"/>
  71. <Cell col="4" style="align:left;" text="bind:prodcmpynm"/>
  72. <Cell col="5" style="align:left;" text="bind:maincustlastsuplplcenm"/>
  73. <Cell col="6" text="bind:msdsflag"/>
  74. <Cell col="7" text="bind:msdsflag_old"/>
  75. <Cell col="8" text="bind:prodcmpycd"/>
  76. <Cell col="9" text="bind:maincustlastsuplplce"/>
  77. <Cell col="10" displaytype="date" edittype="date" text="bind:frgstdd" calendardisplaynulltype="none"/>
  78. <Cell col="11" displaytype="date" edittype="date" text="bind:lastpurcdd" calendardisplaynulltype="none"/>
  79. <Cell col="12" style="align:left;" text="bind:mainusedeptnm"/>
  80. <Cell col="13" style="align:left;" text="bind:fromdd"/>
  81. </Band>
  82. </Format>
  83. </Formats>
  84. </Grid>
  85. <Shape id="line17" linetype="horizontal" class="line_2" position="absolute 770 271 1190 277" style="align:center middle;" anchor="top right"/>
  86. <Static id="caption25" text="물품코드" class="cell_1" position="absolute 770 114 878 139" style="align:left middle;" anchor="top right"/>
  87. <Static id="caption29" text="최초등록일" class="cell_1" position="absolute 770 249 878 274" style="align:left middle;" anchor="top right"/>
  88. <Shape id="line19" linetype="horizontal" class="line_2" position="absolute 770 136 1190 142" style="align:center middle;" anchor="top right"/>
  89. <Static id="caption2" text="물품명" class="cell_1" position="absolute 770 141 878 166" style="align:left middle;" anchor="top right"/>
  90. <Shape id="line7" linetype="horizontal" class="line_2" position="absolute 770 163 1191 169" style="align:center middle;" anchor="top right"/>
  91. <Shape id="line20" linetype="horizontal" class="line_2" position="absolute 770 190 1191 196" style="align:center middle;" anchor="top right"/>
  92. <Static id="caption11" text="규 격" class="cell_1" position="absolute 770 168 878 193" style="align:left middle;" anchor="top right"/>
  93. <Shape id="line9" linetype="horizontal" class="line_2" position="absolute 770 217 1191 223" style="align:center middle;" anchor="top right"/>
  94. <Static id="caption8" text="제조회사" class="cell_1" position="absolute 770 195 878 220" style="align:left middle;" anchor="top right"/>
  95. <Shape id="line10" linetype="horizontal" class="line_2" position="absolute 770 244 1191 250" style="align:center middle;" anchor="top right"/>
  96. <Static id="caption12" text="주거래처" class="cell_1" position="absolute 770 222 878 247" style="align:left middle;" anchor="top right"/>
  97. <Edit id="opt_maincustlastsuplplcenm" taborder="4" readonly="true" position="absolute 930 225 1185 244" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  98. <Edit id="opt_goodcd" taborder="5" readonly="true" position="absolute 881 117 974 136" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  99. <Edit id="opt_goodnm" taborder="6" readonly="true" position="absolute 881 144 1186 163" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  100. <Edit id="opt_goodspec" taborder="7" readonly="true" position="absolute 881 170 1186 189" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  101. <Shape id="line6" linetype="horizontal" class="line_2" position="absolute 770 298 1190 304" style="align:center middle;" anchor="top right"/>
  102. <Static id="caption5" text="최종구매일" class="cell_1" position="absolute 770 276 878 301" style="align:left middle;" anchor="top right"/>
  103. <Static id="caption9" text="사용부서" class="cell_1" position="absolute 770 303 878 328" style="align:left middle;" anchor="top right"/>
  104. <Shape id="line8" linetype="horizontal" class="line_2" position="absolute 769 352 1189 358" style="align:center middle;" anchor="top right"/>
  105. <Static id="caption10" text="MSDS여부" class="cell_1" position="absolute 770 330 878 355" style="align:left middle;" anchor="top right"/>
  106. <Edit id="opt_maincustlastsuplplce" taborder="8" readonly="true" position="absolute 881 225 925 244" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  107. <Edit id="opt_prodcmpycd" taborder="9" readonly="true" position="absolute 881 198 925 217" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  108. <Edit id="opt_prodcmpynm" taborder="10" readonly="true" position="absolute 930 198 1185 217" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  109. <MaskEdit id="opt_frgstdd" taborder="11" readonly="true" mask="####-##-##" position="absolute 881 252 974 271" autoselect="true" autoskip="true" style="align:left middle;" type="string" anchor="top right" class="output" maskchar=" " trimtype="both" displaynulltext=" "/>
  110. <MaskEdit id="opt_lastpurcdd" taborder="12" readonly="true" mask="####-##-##" position="absolute 881 279 974 298" autoselect="true" autoskip="true" style="align:left middle;" type="string" anchor="top right" class="output" maskchar=" " trimtype="both" displaynulltext=" "/>
  111. <Edit id="opt_mainusedeptnm" taborder="13" readonly="true" position="absolute 881 306 1136 325" autoselect="true" autoskip="true" style="align:left middle;" anchor="top right" class="output"/>
  112. <Radio id="rdo_msdsflag" taborder="14" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 885 333 980 353" style="align:left middle;" anchor="top right">
  113. <Dataset id="innerdataset">
  114. <ColumnInfo>
  115. <Column id="codecolumn"/>
  116. <Column id="datacolumn"/>
  117. </ColumnInfo>
  118. <Rows>
  119. <Row>
  120. <Col id="codecolumn">Y</Col>
  121. <Col id="datacolumn">Yes</Col>
  122. </Row>
  123. <Row>
  124. <Col id="codecolumn">N</Col>
  125. <Col id="datacolumn">No</Col>
  126. </Row>
  127. </Rows>
  128. </Dataset>
  129. </Radio>
  130. <Static id="caption3" text="※ 물류 물품마스터의 MSDS여부를 수정합니다." position="absolute 5 750 1055 770" style="color:#ff0000ff;align:left middle;" anchor="left right bottom"/>
  131. </Layout>
  132. </Layouts>
  133. <Objects>
  134. <Dataset id="ds_main_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  135. <ColumnInfo>
  136. <Column id="goodcd" type="STRING"/>
  137. <Column id="goodnm" type="STRING"/>
  138. <Column id="goodspec" type="STRING"/>
  139. <Column id="prodcmpynm" type="STRING"/>
  140. <Column id="maincustlastsuplplcenm" type="STRING"/>
  141. <Column id="msdsflag" type="STRING"/>
  142. <Column id="msdsflag_old" type="STRING"/>
  143. <Column id="prodcmpycd" type="STRING"/>
  144. <Column id="maincustlastsuplplce" type="STRING"/>
  145. <Column id="frgstdd" type="STRING"/>
  146. <Column id="lastpurcdd" type="STRING"/>
  147. <Column id="mainusedeptnm" type="STRING"/>
  148. <Column id="fromdd" type="STRING"/>
  149. <Column id="lsdsflag_old" type="STRING" size="256"/>
  150. </ColumnInfo>
  151. </Dataset>
  152. <Dataset id="ds_main_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  153. <ColumnInfo>
  154. <Column id="goodcd" type="STRING" size="256"/>
  155. <Column id="goodnm" type="STRING" size="256"/>
  156. </ColumnInfo>
  157. <Rows>
  158. <Row/>
  159. </Rows>
  160. </Dataset>
  161. <Dataset id="ds_main_goodinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  162. <ColumnInfo>
  163. <Column id="fromdd" type="STRING" size="256"/>
  164. <Column id="goodcd" type="STRING" size="256"/>
  165. <Column id="goodnm" type="STRING" size="256"/>
  166. <Column id="goodspec" type="STRING" size="256"/>
  167. <Column id="prodcmpycd" type="STRING" size="256"/>
  168. <Column id="prodcmpynm" type="STRING" size="256"/>
  169. <Column id="maincustlastsuplplce" type="STRING" size="256"/>
  170. <Column id="maincustlastsuplplcenm" type="STRING" size="256"/>
  171. <Column id="frgstdd" type="STRING" size="256"/>
  172. <Column id="lastpurcdd" type="STRING" size="256"/>
  173. <Column id="mainusedeptnm" type="STRING" size="256"/>
  174. <Column id="msdsflag" type="STRING" size="256"/>
  175. </ColumnInfo>
  176. <Rows>
  177. <Row/>
  178. </Rows>
  179. </Dataset>
  180. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  181. </Objects>
  182. <Bind>
  183. <BindItem id="item0" compid="grp_sea.ipt_goodcd" propid="value" datasetid="ds_main_condition" columnid="goodcd"/>
  184. <BindItem id="item1" compid="grp_sea.ipt_goodnm" propid="value" datasetid="ds_main_condition" columnid="goodnm"/>
  185. <BindItem id="item2" compid="opt_goodcd" propid="value" datasetid="ds_main_goodinfo" columnid="goodcd"/>
  186. <BindItem id="item3" compid="opt_goodnm" propid="value" datasetid="ds_main_goodinfo" columnid="goodnm"/>
  187. <BindItem id="item4" compid="opt_goodspec" propid="value" datasetid="ds_main_goodinfo" columnid="goodspec"/>
  188. <BindItem id="item5" compid="opt_prodcmpycd" propid="value" datasetid="ds_main_goodinfo" columnid="prodcmpycd"/>
  189. <BindItem id="item6" compid="opt_prodcmpynm" propid="value" datasetid="ds_main_goodinfo" columnid="prodcmpynm"/>
  190. <BindItem id="item7" compid="opt_maincustlastsuplplcenm" propid="value" datasetid="ds_main_goodinfo" columnid="maincustlastsuplplcenm"/>
  191. <BindItem id="item8" compid="opt_maincustlastsuplplce" propid="value" datasetid="ds_main_goodinfo" columnid="maincustlastsuplplce"/>
  192. <BindItem id="item9" compid="opt_frgstdd" propid="value" datasetid="ds_main_goodinfo" columnid="frgstdd"/>
  193. <BindItem id="item10" compid="opt_lastpurcdd" propid="value" datasetid="ds_main_goodinfo" columnid="lastpurcdd"/>
  194. <BindItem id="item11" compid="opt_mainusedeptnm" propid="value" datasetid="ds_main_goodinfo" columnid="mainusedeptnm"/>
  195. <BindItem id="item12" compid="rdo_msdsflag" propid="value" datasetid="ds_main_goodinfo" columnid="msdsflag"/>
  196. </Bind>
  197. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  198. * System Name :
  199. * Job Name :
  200. * Creator :
  201. * Make Date : 2017-06-19
  202. * Description :
  203. *---------------------------------------------------------------------------------------
  204. * Modify Date Modifier Modify Description
  205. *---------------------------------------------------------------------------------------
  206. * 2017-06-19 Live Converter TF->XP
  207. *
  208. *---------------------------------------------------------------------------------------
  209. ****************************************************************************************/
  210. include "com_commonxp::comm_main.xjs";
  211. include "mis_miscommonxp::MIS.xjs";
  212. include "mis_miscommonxp::RAC001.xjs";
  213. include "mis_miscommonxp::RSZ001.xjs";
  214. function SMRSM01200_oninit(obj:Form, e:InitEventInfo)
  215. {
  216. frmf_initForm(obj);
  217. }
  218. function SMRSM01200_onload(obj:Form, e:LoadEventInfo)
  219. {
  220. grdf_initGrid(grd_goodlist);
  221. grdf_setRowTypeIcon(grd_goodlist, 0);
  222. fOpenForm();
  223. }
  224. //초기화
  225. function fOpenForm()
  226. {
  227. misfGridInit(grd_goodlist);
  228. }
  229. //조회
  230. function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
  231. {
  232. if( utlf_isNull(grp_sea.ipt_goodcd.value) && utlf_isNull(grp_sea.ipt_goodnm.value))
  233. {
  234. sysf_messageBox("조회조건을 입력하십시요. ", "E999", "");
  235. grp_sea.ipt_goodcd.setFocus();
  236. return;
  237. }
  238. fGetGoodList();
  239. }
  240. //코드 목록 조회 함수
  241. function fGetGoodList()
  242. {
  243. misfGridInit(grd_goodlist);
  244. ds_main_goodinfo.clearData(); //조회시 기존 데이터 삭제
  245. ds_main_goodinfo.addRow();
  246. ds_send.copyData(ds_main_condition);
  247. var oParam = {};
  248. oParam.id = "TRRSM01201";
  249. oParam.service = "purcbaseapp.PurcBaseMngt";
  250. oParam.method = "reqGetGoodMstList";
  251. oParam.inds = "req=ds_send";
  252. oParam.outds = "ds_main_goodlist=goodlist";
  253. oParam.async = false;
  254. //oParam.callback = "cf_TRRSM01201";
  255. tranf_submit(oParam);
  256. }
  257. function grd_goodlist_oncellclick(obj:Grid, e:GridClickEventInfo)
  258. {
  259. if(ds_main_goodlist.rowcount == 0 || e.col < 1) return;
  260. if( !utlf_isNull(opt_goodcd.value))
  261. {
  262. fPutGoodInfo(); //상세내역 -> 목록
  263. }
  264. var cur_row = ds_main_goodlist.rowposition;
  265. fGetGoodInfo(cur_row);
  266. }
  267. //상세내역 -> 목록
  268. function fPutGoodInfo()
  269. {
  270. if ( true )
  271. {
  272. var iRow = ds_main_goodlist.findRow("goodcd", opt_goodcd.value);
  273. ds_main_goodlist.setColumn(iRow, "msdsflag", rdo_msdsflag.value);
  274. if(ds_main_goodlist.getColumn(iRow, "msdsflag") != ds_main_goodlist.getColumn(iRow, "lsdsflag_old"))
  275. {
  276. var arrPostion = new Array();
  277. arrPostion[0] = iRow;
  278. grdf_setStatus(grd_goodlist, "U", arrPostion);
  279. }
  280. else
  281. {
  282. var arrPostion = new Array();
  283. arrPostion[0] = iRow;
  284. grdf_setStatus(grd_goodlist, "", arrPostion);
  285. }
  286. }
  287. }
  288. //목록 -> 상세내역
  289. function fGetGoodInfo(pRow)
  290. {
  291. trace("pRow = " + pRow);
  292. if ( pRow >= 0 )
  293. {
  294. ds_main_goodinfo.copyRow(0, ds_main_goodlist, pRow);
  295. }
  296. }
  297. //일괄저장
  298. function btn_save_onclick(obj:Button, e:ClickEventInfo)
  299. {
  300. fClickSaveBtn();
  301. }
  302. // 저장버튼 클릭시 저장 수행 함수
  303. function fClickSaveBtn()
  304. {
  305. if( !utlf_isNull(opt_goodcd.value))
  306. {
  307. fPutGoodInfo();
  308. }
  309. var oParam = {};
  310. oParam.id = "TXRSM01201";
  311. oParam.service = "purcbaseapp.PurcBaseMngt";
  312. oParam.method = "reqExeSaveGoodMsds";
  313. oParam.inds = "goodlist=ds_main_goodlist:U";
  314. oParam.async = false;
  315. oParam.callback = "cf_TXRSM01201";
  316. tranf_submit(oParam);
  317. fGetGoodList(); //일괄저장후 재조회
  318. }
  319. function cf_TXRSM01201(sSvcId, nErrorCode, sErrorMsg)
  320. {
  321. if(nErrorCode < 0) return;
  322. else sysf_messageBox("정상적으로 처리되었습니다. .", "I999", "");
  323. }]]></Script>
  324. </Form>
  325. </FDL>