SPRFC00203_임차장비.xfdl 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPRFC00203" position="absolute 0 0 707 459" titletext="임차장비 리스트" oninit="SPRFC00203_oninit" onload="SPRFC00203_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption1" text="임차장비 리스트" class="tit_2" position="absolute 0 0 155 21"/>
  8. <Shape id="line1" class="line_10" position="absolute 0 45 700 51"/>
  9. <Grid id="grd_rfcmfacdlist" taborder="1" binddataset="ds_main_rfcmfacdlist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="none" position="absolute 0 50 700 430" oncelldblclick="grd_rfcmfacdlist_oncelldblclick">
  10. <Formats>
  11. <Format id="default">
  12. <Columns>
  13. <Column size="22"/>
  14. <Column size="0"/>
  15. <Column size="92"/>
  16. <Column size="178"/>
  17. <Column size="75"/>
  18. <Column size="60"/>
  19. <Column size="0"/>
  20. <Column size="0"/>
  21. <Column size="0"/>
  22. <Column size="0"/>
  23. <Column size="0"/>
  24. <Column size="0"/>
  25. <Column size="0"/>
  26. <Column size="0"/>
  27. <Column size="0"/>
  28. <Column size="0"/>
  29. <Column size="0"/>
  30. <Column size="0"/>
  31. <Column size="198"/>
  32. <Column size="0"/>
  33. </Columns>
  34. <Rows>
  35. <Row size="24" band="head"/>
  36. <Row size="24"/>
  37. </Rows>
  38. <Band id="head">
  39. <Cell/>
  40. <Cell col="1" text="기관코드"/>
  41. <Cell col="2" text="자산코드"/>
  42. <Cell col="3" text="자산명"/>
  43. <Cell col="4" text="계약만료일"/>
  44. <Cell col="5" text="처리여부"/>
  45. <Cell col="6" text="취득일자"/>
  46. <Cell col="7" text="규격"/>
  47. <Cell col="8" text="대분류"/>
  48. <Cell col="9" text="중분류"/>
  49. <Cell col="10" text="사용부서"/>
  50. <Cell col="11" text="설치장소"/>
  51. <Cell col="12" text="제조회사"/>
  52. <Cell col="13" text="제조국"/>
  53. <Cell col="14" text="공급처"/>
  54. <Cell col="15" text="보사부코드"/>
  55. <Cell col="16" text="serialno"/>
  56. <Cell col="17" text="허가번호"/>
  57. <Cell col="18" text="비고"/>
  58. <Cell col="19"/>
  59. </Band>
  60. <Band id="body">
  61. <Cell celltype="head" expr="currow+1"/>
  62. <Cell col="1" text="bind:instcd"/>
  63. <Cell col="2" text="bind:fixasetcd"/>
  64. <Cell col="3" style="align:left middle;padding:0 0 0 5;" text="bind:goodflaghngnm"/>
  65. <Cell col="4" displaytype="date" text="bind:delivetermmm" calendardisplaynulltype="nulltext"/>
  66. <Cell col="5" text="bind:flag"/>
  67. <Cell col="6" text="bind:possndd"/>
  68. <Cell col="7" text="bind:goodspec"/>
  69. <Cell col="8" text="bind:lrgcd"/>
  70. <Cell col="9" text="bind:mdlcd"/>
  71. <Cell col="10" text="bind:mngtdeptcd"/>
  72. <Cell col="11" text="bind:installplcecd"/>
  73. <Cell col="12" text="bind:prodcmpy"/>
  74. <Cell col="13" text="bind:prodplce"/>
  75. <Cell col="14" text="bind:suplplcecd"/>
  76. <Cell col="15" text="bind:welfcd"/>
  77. <Cell col="16" text="bind:mngtno"/>
  78. <Cell col="17" text="bind:incmpemtno"/>
  79. <Cell col="18" style="align:left middle;padding:0 0 0 5;" text="bind:cmt"/>
  80. <Cell col="19" displaytype="date" text="bind:condd"/>
  81. </Band>
  82. </Format>
  83. </Formats>
  84. </Grid>
  85. <Button id="button3" taborder="2" text="Excel 저장" class="btn5" position="absolute 625 26 700 45" onclick="button3_onclick"/>
  86. <Button id="btn_cancel" taborder="3" text="닫기" class="btn4" position="absolute 644 432 700 454" onclick="btn_cancel_onclick"/>
  87. </Layout>
  88. </Layouts>
  89. <Objects>
  90. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  91. <ColumnInfo>
  92. <Column id="instcd" type="STRING" size="256"/>
  93. </ColumnInfo>
  94. <Rows>
  95. <Row/>
  96. </Rows>
  97. </Dataset>
  98. <Dataset id="ds_main_rfcmfacdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  99. <ColumnInfo>
  100. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  101. <Column id="fixasetcd" type="STRING" size="256" sumtext="장비코드"/>
  102. <Column id="goodflaghngnm" type="STRING" size="256" sumtext="장비명 "/>
  103. <Column id="delivetermmm" type="STRING" size="256" sumtext="계약만료일 "/>
  104. <Column id="flag" type="STRING" size="256" sumtext="처리여부"/>
  105. <Column id="possndd" type="STRING" size="256" sumtext="취득일자"/>
  106. <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
  107. <Column id="lrgcd" type="STRING" size="256" sumtext="대분류"/>
  108. <Column id="mdlcd" type="STRING" size="256" sumtext="중분류"/>
  109. <Column id="mngtdeptcd" type="STRING" size="256" sumtext="사용부서"/>
  110. <Column id="installplcecd" type="STRING" size="256" sumtext="설치장소"/>
  111. <Column id="prodcmpy" type="STRING" size="256" sumtext="제조회사"/>
  112. <Column id="prodplce" type="STRING" size="256" sumtext="제조국"/>
  113. <Column id="suplplcecd" type="STRING" size="256" sumtext="공급처"/>
  114. <Column id="welfcd" type="STRING" size="256" sumtext="보사부코드"/>
  115. <Column id="mngtno" type="STRING" size="256" sumtext="serial no"/>
  116. <Column id="incmpemtno" type="STRING" size="256" sumtext="허가번호"/>
  117. <Column id="cmt" type="STRING" size="256" sumtext="비고"/>
  118. <Column id="condd" type="STRING" size="256" sumtext="계약일자"/>
  119. </ColumnInfo>
  120. </Dataset>
  121. </Objects>
  122. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  123. * System Name :
  124. * Job Name :
  125. * Creator :
  126. * Make Date : 2017-06-19
  127. * Description :
  128. *---------------------------------------------------------------------------------------
  129. * Modify Date Modifier Modify Description
  130. *---------------------------------------------------------------------------------------
  131. * 2017-06-19 Live Converter TF->XP
  132. *
  133. *---------------------------------------------------------------------------------------
  134. ****************************************************************************************/
  135. include "com_commonxp::comm_main.xjs";
  136. include "mis_miscommonxp::MIS.xjs";
  137. function SPRFC00203_oninit(obj:Form, e:InitEventInfo)
  138. {
  139. frmf_initForm(obj);
  140. }
  141. function SPRFC00203_onload(obj:Form, e:LoadEventInfo)
  142. {
  143. grdf_initGrid(grd_rfcmfacdlist);
  144. fInitialize();
  145. }
  146. function fInitialize()
  147. {
  148. ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  149. misfGridInit(grd_rfcmfacdlist);
  150. var oParam = {};
  151. oParam.id = "TRRSC00202";
  152. oParam.service = "purcbaseapp.PurcBaseMngt";
  153. oParam.method = "reqGetFixasetRent";
  154. oParam.inds = "req=ds_send";
  155. oParam.outds = "ds_main_rfcmfacdlist=rfcmfacdlist";
  156. oParam.async = false;
  157. //oParam.callback = "cf_TRRSC00202";
  158. tranf_submit(oParam);
  159. }
  160. function grd_rfcmfacdlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  161. {
  162. var fixasetcd = ds_main_rfcmfacdlist.getColumn(ds_main_rfcmfacdlist.rowposition, "fixasetcd");
  163. var receiveref = eval("opener.ds_copynode");
  164. if ( frmf_checkOpener() )
  165. {
  166. opener.dsf_makeValue(receiveref, "para_fixasetcd", "string", fixasetcd, 0);
  167. opener.dsf_makeValue(receiveref, "para_closeyn", "string", "N", 0);
  168. }
  169. else
  170. {
  171. var rtn = sysf_messageBox("상위화면을 찾을 수", "E001");
  172. }
  173. this.close();
  174. }
  175. function btn_cancel_onclick(obj:Button, e:ClickEventInfo)
  176. {
  177. this.close();
  178. }
  179. function button3_onclick(obj:Button, e:ClickEventInfo)
  180. {
  181. if( ds_main_rfcmfacdlist.rowcount > 0)
  182. {
  183. var fileName = "임차장비리스트_" + utlf_getCurrentDate();
  184. grdf_exportExcel(grd_rfcmfacdlist, fileName, "임차장비", "true", "", "open");
  185. }
  186. else
  187. {
  188. sysf_messageBox("저장 데이터가","I004");
  189. }
  190. }
  191. ]]></Script>
  192. </Form>
  193. </FDL>