SMRFE02300_재물조사 이동내역.xfdl 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRFE02300" position="absolute 0 0 1200 776" titletext="재물조사 이동내역" oninit="SMRFE02300_oninit" onload="SMRFE02300_onload">
  5. <Layouts>
  6. <Layout>
  7. <Shape id="line7" class="line_6" position="absolute 0 52 1194 58" anchor="left top right"/>
  8. <Button id="btn_init" taborder="1" text="초기화" class="btn4" position="absolute 1126 31 1194 53" anchor="top right" onclick="btn_init_onclick"/>
  9. <Static id="caption6" text="이동 내역" class="tit_1" position="absolute 0 0 230 25"/>
  10. <Shape id="line1" class="line_10" position="absolute 0 144 1194 150" anchor="left top right"/>
  11. <Static id="caption21" text="이동 내역" class="tit_2" position="absolute 0 128 143 149"/>
  12. <Grid id="grd_fixtrscnfmmvlist" class="datagrid1" taborder="2" binddataset="ds_main_list_fixtrscnfmmvinfo_fixtrscnfmmvlist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 149 1194 769" anchor="all">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="22" band="left"/>
  17. <Column size="0"/>
  18. <Column size="0"/>
  19. <Column size="0"/>
  20. <Column size="0"/>
  21. <Column size="119"/>
  22. <Column size="128"/>
  23. <Column size="0"/>
  24. <Column size="164"/>
  25. <Column size="139"/>
  26. <Column size="120"/>
  27. <Column size="120"/>
  28. <Column size="128"/>
  29. <Column size="118"/>
  30. <Column size="120"/>
  31. </Columns>
  32. <Rows>
  33. <Row size="24" band="head"/>
  34. <Row size="53"/>
  35. </Rows>
  36. <Band id="head">
  37. <Cell/>
  38. <Cell col="1" text="실시년도"/>
  39. <Cell col="2" text="기관코드"/>
  40. <Cell col="3" text="물품코드"/>
  41. <Cell col="4" text="사용부서"/>
  42. <Cell col="5" text="부서명"/>
  43. <Cell col="6" text="장비코드"/>
  44. <Cell col="7" text="(자산코드)순번"/>
  45. <Cell col="8" text="장비명"/>
  46. <Cell col="9" text="모델명"/>
  47. <Cell col="10" text="제조회사"/>
  48. <Cell col="11" text="거래처명"/>
  49. <Cell col="12" text="이동전"/>
  50. <Cell col="13" text="이동후"/>
  51. <Cell col="14" text="비고"/>
  52. </Band>
  53. <Band id="body">
  54. <Cell celltype="head"/>
  55. <Cell col="1" text="bind:execyy"/>
  56. <Cell col="2" text="bind:instcd"/>
  57. <Cell col="3" text="bind:goodflag"/>
  58. <Cell col="4" text="bind:usedeptcd"/>
  59. <Cell col="5" text="bind:deptnm"/>
  60. <Cell col="6" text="bind:fixasetcd"/>
  61. <Cell col="7" text="bind:seqno"/>
  62. <Cell col="8" text="bind:goodflagengnm"/>
  63. <Cell col="9" text="bind:goodmodel"/>
  64. <Cell col="10" text="bind:prodcmpynm"/>
  65. <Cell col="11" text="bind:suplplcenm"/>
  66. <Cell col="12" text="bind:usedeptnm"/>
  67. <Cell col="13" text="bind:possndeptnm"/>
  68. <Cell col="14" displaytype="text" edittype="text" text="bind:cmt"/>
  69. </Band>
  70. </Format>
  71. </Formats>
  72. </Grid>
  73. <Div id="grp_sea" anchor="left top right" taborder="3" class="div_SA2" position="absolute 0 56 1195 116">
  74. <Layouts>
  75. <Layout>
  76. <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1107 4 1113 58" anchor="top right"/>
  77. <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1125 22 1181 44" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
  78. <Combo id="cmb_instcd" taborder="2" innerdataset="ds_init_cmb_instcd" codecolumn="cnstcd" datacolumn="cnstnm" class="combo_default" position="absolute 125 8 295 27"/>
  79. <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 30 7 116 24"/>
  80. <Combo id="cmb_goodflag" taborder="3" innerdataset="ds_init_cmb_goodflag" codecolumn="value" datacolumn="label" class="combo_default" position="absolute 125 34 295 53"/>
  81. <Static id="cap_goodflag" text="물품구분 :" class="search_name" position="absolute 30 33 116 50"/>
  82. <Static id="cap_usedeptcd" text="사용부서 :" class="search_name" position="absolute 500 8 589 25"/>
  83. <Edit id="ipt_usedeptnm" taborder="4" class="input_search" position="absolute 758 7 990 26" style="align:center middle;" autoselect="true" autoskip="true"/>
  84. <Button id="btn_deptcd" taborder="5" class="icon_search" position="absolute 735 10 751 26" onclick="grp_sea_btn_deptcd_onclick"/>
  85. <Edit id="ipt_usedeptcd" taborder="6" class="input_search" position="absolute 595 7 730 26" style="align:center middle;" autoselect="true" autoskip="true" onkeydown="grp_sea_ipt_usedeptcd_onkeydown"/>
  86. <Button id="btn_fixasetcd" taborder="7" class="icon_search" position="absolute 735 35 751 51" onclick="grp_sea_btn_fixasetcd_onclick"/>
  87. <Edit id="ipt_fixasetnm" taborder="8" class="input_search" position="absolute 758 35 990 54" style="align:center middle;" autoselect="true" autoskip="true"/>
  88. <Edit id="ipt_fixasetcd" taborder="9" class="input_search" position="absolute 595 34 730 53" style="align:center middle;" autoselect="true" autoskip="true" onkeydown="grp_sea_ipt_fixasetcd_onkeydown"/>
  89. <Static id="cap_fixasetcd" text="자산코드 :" class="search_name" position="absolute 500 34 589 51"/>
  90. </Layout>
  91. </Layouts>
  92. </Div>
  93. <Button id="btn_excel" taborder="4" text="저장" class="btn2" position="absolute 1071 125 1113 144" anchor="top right" onclick="btn_excel_onclick"/>
  94. <Button id="button1" taborder="5" text="엑셀저장" class="btn7" position="absolute 1114 125 1194 144" anchor="top right" onclick="button1_onclick"/>
  95. </Layout>
  96. </Layouts>
  97. <Objects>
  98. <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_search_oncolumnchanged">
  99. <ColumnInfo>
  100. <Column id="instcd" type="STRING" size="256"/>
  101. <Column id="goodflag" type="STRING" size="256"/>
  102. <Column id="usedeptcd" type="STRING" size="256"/>
  103. <Column id="usedeptnm" type="STRING" size="256"/>
  104. <Column id="fixasetcd" type="STRING" size="256"/>
  105. <Column id="goodflagengnm" type="STRING" size="256"/>
  106. </ColumnInfo>
  107. <Rows>
  108. <Row>
  109. <Col id="instcd"/>
  110. <Col id="goodflag"/>
  111. <Col id="usedeptcd"/>
  112. <Col id="usedeptnm"/>
  113. <Col id="fixasetcd"/>
  114. <Col id="goodflagengnm"/>
  115. </Row>
  116. </Rows>
  117. </Dataset>
  118. <Dataset id="ds_main_list_fixtrscnfmmvinfo_fixtrscnfmmvlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  119. <ColumnInfo>
  120. <Column id="execyy" type="STRING" size="256" sumtext=" 실시년도 "/>
  121. <Column id="instcd" type="STRING" size="256" sumtext=" 기관코드 "/>
  122. <Column id="goodflag" type="STRING" size="256" sumtext=" 물품코드 "/>
  123. <Column id="usedeptcd" type="STRING" size="256" sumtext=" 사용부서 "/>
  124. <Column id="deptnm" type="STRING" size="256" sumtext=" 부서명 "/>
  125. <Column id="fixasetcd" type="STRING" size="256" sumtext=" 장비코드 "/>
  126. <Column id="seqno" type="STRING" size="256" sumtext=" (자산코드)순번 "/>
  127. <Column id="goodflagengnm" type="STRING" size="256" sumtext=" 장비명 "/>
  128. <Column id="goodmodel" type="STRING" size="256" sumtext=" 모델명 "/>
  129. <Column id="prodcmpynm" type="STRING" size="256" sumtext=" 제조회사 "/>
  130. <Column id="suplplcenm" type="STRING" size="256" sumtext=" 거래처명 "/>
  131. <Column id="usedeptnm" type="STRING" size="256" sumtext=" 사용 부서명 (이동전) "/>
  132. <Column id="possndeptnm" type="STRING" size="256" sumtext=" 현보유 부서명 (이동후) "/>
  133. <Column id="cmt" type="STRING" size="256" sumtext=" 비고 "/>
  134. </ColumnInfo>
  135. </Dataset>
  136. </Objects>
  137. <Bind>
  138. <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send_search" columnid="instcd"/>
  139. <BindItem id="item1" compid="grp_sea.cmb_goodflag" propid="value" datasetid="ds_send_search" columnid="goodflag"/>
  140. <BindItem id="item2" compid="grp_sea.ipt_usedeptcd" propid="value" datasetid="ds_send_search" columnid="usedeptcd"/>
  141. <BindItem id="item3" compid="grp_sea.ipt_usedeptnm" propid="value" datasetid="ds_send_search" columnid="usedeptnm"/>
  142. <BindItem id="item4" compid="grp_sea.ipt_fixasetcd" propid="value" datasetid="ds_send_search" columnid="fixasetcd"/>
  143. <BindItem id="item5" compid="grp_sea.ipt_fixasetnm" propid="value" datasetid="ds_send_search" columnid="goodflagengnm"/>
  144. </Bind>
  145. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  146. * System Name :
  147. * Job Name :
  148. * Creator :
  149. * Make Date : 2017-06-19
  150. * Description :
  151. *---------------------------------------------------------------------------------------
  152. * Modify Date Modifier Modify Description
  153. *---------------------------------------------------------------------------------------
  154. * 2017-06-19 Live Converter TF->XP
  155. *
  156. *---------------------------------------------------------------------------------------
  157. ****************************************************************************************/
  158. include "com_commonxp::comm_main.xjs";
  159. include "mis_miscommonxp::MIS.xjs";
  160. include "mis_miscommonxp::RSZ001.xjs";
  161. function SMRFE02300_oninit(obj:Form, e:InitEventInfo)
  162. {
  163. frmf_initForm(obj);
  164. }
  165. function SMRFE02300_onload(obj:Form, e:LoadEventInfo)
  166. {
  167. grdf_initGrid(grd_fixtrscnfmmvlist);
  168. grdf_setRowTypeIcon(grd_fixtrscnfmmvlist, 0);
  169. fInitialize();
  170. }
  171. function fInitialize()
  172. {
  173. rszfGoodFlagListByPgmGubn(grp_sea.cmb_goodflag,"2","N");
  174. misfComboComCdList('Z0007', grp_sea.cmb_instcd);
  175. ds_send_search.enableevent = false;
  176. ds_send_search.updatecontrol = false;
  177. grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
  178. grp_sea.ipt_usedeptcd.value = sysf_getUserInfo("dutplcecd");
  179. grp_sea.ipt_usedeptnm.value = sysf_getUserInfo("dutplcenm");
  180. ds_send_search.updatecontrol = true;
  181. ds_send_search.enableevent = true;
  182. ds_main_list_fixtrscnfmmvinfo_fixtrscnfmmvlist.clearData();
  183. }
  184. function ds_send_search_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  185. {
  186. if(e.columnid == "usedeptcd")
  187. {
  188. var objFocus = this.getFocus();
  189. grp_sea.ipt_usedeptcd.value = e.newvalue;
  190. grp_sea.ipt_usedeptcd.setFocus();
  191. if(utlf_isNull(e.newvalue))
  192. {
  193. grp_sea.ipt_usedeptnm.value = "";
  194. }
  195. else
  196. {
  197. misfValidationCheck("02", "", "usedeptcd,usedeptnm");
  198. }
  199. objFocus.setFocus();
  200. }
  201. if(e.columnid == "usedeptnm")
  202. {
  203. var objFocus = this.getFocus();
  204. grp_sea.ipt_usedeptnm.value = e.newvalue;
  205. grp_sea.ipt_usedeptnm.setFocus();
  206. if(utlf_isNull(e.newvalue))
  207. {
  208. grp_sea.ipt_usedeptcd.value = "";
  209. }
  210. else
  211. {
  212. misfValidationCheck("02", "", "usedeptcd,usedeptnm");
  213. }
  214. objFocus.setFocus();
  215. }
  216. if(e.columnid == "fixasetcd")
  217. {
  218. var objFocus = this.getFocus();
  219. grp_sea.ipt_fixasetcd.value = e.newvalue;
  220. grp_sea.ipt_fixasetcd.setFocus();
  221. if(!utlf_isNull(e.newvalue))
  222. {
  223. rszfValidationCheck("TRRSD00241", "rfcmfacdlist", "requirementcd,instcd,requirementnm", "fixasetcd," + grp_sea.cmb_instcd.value + "," + e.newvalue, "", "fixasetcd,goodflagengnm",
  224. grp_sea.ipt_fixasetcd, "SPRSD00240", "instcd,goodflag","grp_sea.cmb_instcd,grp_sea.cmb_goodflag");
  225. }
  226. else
  227. {
  228. grp_sea.ipt_fixasetnm.value = "";
  229. }
  230. objFocus.setFocus();
  231. }
  232. if(e.columnid == "goodflagengnm")
  233. {
  234. var objFocus = this.getFocus();
  235. grp_sea.ipt_fixasetnm.value = e.newvalue;
  236. grp_sea.ipt_fixasetnm.setFocus();
  237. if(!utlf_isNull(e.newvalue))
  238. {
  239. rszfValidationCheck("TRRSD00241", "rfcmfacdlist", "requirementcd,instcd,requirementnm", "goodflagengnm," + grp_sea.cmb_instcd.value + "," + e.newvalue, "", "fixasetcd,goodflagengnm",
  240. grp_sea.ipt_fixasetnm, "SPRSD00240", "instcd,goodflag","grp_sea.cmb_instcd,grp_sea.cmb_goodflag");
  241. }
  242. else
  243. {
  244. grp_sea.ipt_fixasetcd.value = "";
  245. }
  246. objFocus.setFocus();
  247. }
  248. }
  249. function grp_sea_btn_deptcd_onclick(obj:Button, e:ClickEventInfo)
  250. {
  251. var recv_list = "usedeptcd,usedeptnm";
  252. misfOpenPopUpList("02", grp_sea.ipt_usedeptcd,"", recv_list, ds_send_search.getColumn(0, "instcd"), "instcd") ;
  253. }
  254. function grp_sea_btn_fixasetcd_onclick(obj:Button, e:ClickEventInfo)
  255. {
  256. var temp = "fixasetcd,goodflagengnm";
  257. rszfOpenPopUpListByWndName(grp_sea.ipt_fixasetcd,"", temp, "SPRSD00240","instcd,goodflag","grp_sea.cmb_instcd,grp_sea.cmb_goodflag");
  258. }
  259. function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
  260. {
  261. arrCompId = new Array("grp_sea.cmb_instcd","grp_sea.cmb_goodflag");
  262. if(!frmf_isRequiredControls(arrCompId)) return;
  263. var oParam = {};
  264. oParam.id = "TRRFE02301";
  265. oParam.service = "purcbaseapp.CalcScorTrsmMngt";
  266. oParam.method = "reqGetFixtrsCnfmMvList";
  267. oParam.inds = "req=ds_send_search";
  268. oParam.outds = "ds_main_list_fixtrscnfmmvinfo_fixtrscnfmmvlist=fixtrscnfmmvlist";
  269. oParam.async = false;
  270. //oParam.callback = "cf_TRRFE02301";
  271. tranf_submit(oParam);
  272. }
  273. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  274. {
  275. var retMes = sysf_messageBox("저장 하시겠습니까?", "Q999");
  276. if ( retMes != 6)
  277. {
  278. return;
  279. }
  280. var updtdata = grdf_getGridUpdateData(grd_fixtrscnfmmvlist).rowcount;
  281. if (updtdata == 0)
  282. {
  283. sysf_messageBox("변경된 데이터가","I004");
  284. return;
  285. }
  286. var oParam = {};
  287. oParam.id = "TXRFE02301";
  288. oParam.service = "purcbaseapp.CalcScorTrsmMngt";
  289. oParam.method = "reqExeSaveFixtrsCnfmMvList";
  290. oParam.inds = "req=ds_main_list_fixtrscnfmmvinfo_fixtrscnfmmvlist:u";
  291. oParam.outds = "";
  292. oParam.async = false;
  293. //oParam.callback = "cf_TXRFE02301";
  294. tranf_submit(oParam);
  295. grp_sea.btn_search.click();
  296. }
  297. function button1_onclick(obj:Button, e:ClickEventInfo)
  298. {
  299. grdf_exportExcel(grd_fixtrscnfmmvlist, "excel", "sheet1", "true", "", "");
  300. }
  301. function btn_init_onclick(obj:Button, e:ClickEventInfo)
  302. {
  303. fInitialize();
  304. }
  305. function grp_sea_ipt_usedeptcd_onkeydown(obj:Edit, e:KeyEventInfo)
  306. {
  307. if( e.keycode == 13 ){
  308. obj.updateToDataset();
  309. }
  310. }
  311. function grp_sea_ipt_fixasetcd_onkeydown(obj:Edit, e:KeyEventInfo)
  312. {
  313. if( e.keycode == 13 ){
  314. obj.updateToDataset();
  315. }
  316. }
  317. ]]></Script>
  318. </Form>
  319. </FDL>