SMLQP00400_QC결과연동.xfdl 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMLQP00400" position="absolute 0 0 1256 805" titletext="QC 결과연동" oninit="SMLQP00400_oninit" onload="SMLQP00400_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 0 1195 13" id="group2">
  8. <Layouts>
  9. <Layout/>
  10. </Layouts>
  11. </Div>
  12. <Button id="button5" taborder="1" text="초기화" class="btn4" position="absolute 1185 3 1253 25" anchor="top right"/>
  13. <Static id="caption7" text="QC 결과연동" class="tit_1" position="absolute 1 1 138 27" onclick="caption7_onclick"/>
  14. <Div id="group5" taborder="2" position="absolute 0 32 1255 72" anchor="left top right" class="div_SA">
  15. <Layouts>
  16. <Layout>
  17. <Static id="caption1" text="~" class="search_no_b" position="absolute 245 12 260 29" anchor="left top"/>
  18. <Static id="caption3" text="검사실 :" class="search_name" position="absolute 444 11 519 28" anchor="left top"/>
  19. <Static id="caption4" text="장비 :" class="search_name" position="absolute 661 11 736 28" anchor="left top"/>
  20. <Combo id="cbo_testRoom" taborder="1" innerdataset="ds_init_lb0111" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 524 10 624 29" anchor="left top" onitemchanged="group5_cbo_testRoom_onitemchanged"/>
  21. <Combo id="cbo_emqt" taborder="2" innerdataset="ds_init_lb0701" codecolumn="cd" datacolumn="nm" class="combo_search" position="absolute 726 10 826 29" anchor="left top"/>
  22. <Button id="btn_getRslt" taborder="3" text="조회" class="btn1" position="absolute 1187 9 1243 31" anchor="top right" onclick="group5_btn_getRslt_onclick"/>
  23. <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1169 8 1175 32" anchor="top right"/>
  24. <Static id="caption6" text="접수일자 :" class="search_name" position="absolute 15 11 105 28" anchor="left top"/>
  25. <Calendar id="ipt_acptFromdd" taborder="4" class="input_search" position="absolute 105 10 190 29" anchor="left top"/>
  26. <Calendar id="ipt_acptTodd" taborder="5" class="input_search" position="absolute 260 10 345 29" anchor="left top"/>
  27. <MaskEdit id="ipt_acpfromtm" taborder="6" mask="##:##" class="input_search" position="absolute 191 10 241 29" anchor="left top" type="string"/>
  28. <MaskEdit id="ipt_acpttotm" taborder="7" mask="##:##" class="input_search" position="absolute 346 10 396 29" anchor="left top" type="string"/>
  29. </Layout>
  30. </Layouts>
  31. </Div>
  32. <Grid id="grd_rslt" taborder="4" binddataset="ds_grd_rslt" useinputpanel="false" position="absolute 2 107 1255 800" anchor="all" autofittype="col">
  33. <Formats>
  34. <Format id="default">
  35. <Columns>
  36. <Column size="120"/>
  37. <Column size="169"/>
  38. <Column size="50"/>
  39. <Column size="120"/>
  40. <Column size="30"/>
  41. <Column size="110"/>
  42. <Column size="60"/>
  43. <Column size="60"/>
  44. <Column size="110"/>
  45. <Column size="110"/>
  46. <Column size="0"/>
  47. <Column size="110"/>
  48. <Column size="60"/>
  49. <Column size="40"/>
  50. <Column size="0"/>
  51. <Column size="80"/>
  52. </Columns>
  53. <Rows>
  54. <Row size="24" band="head"/>
  55. <Row size="24"/>
  56. </Rows>
  57. <Band id="head">
  58. <Cell text="접수일자"/>
  59. <Cell col="1" text="검사명"/>
  60. <Cell col="2" text="결과"/>
  61. <Cell col="3" text="검사(확인)일시"/>
  62. <Cell col="4" text="횟수"/>
  63. <Cell col="5" text="물질"/>
  64. <Cell col="6" text="레벨"/>
  65. <Cell col="7" text="LOT번호"/>
  66. <Cell col="8" text="항목코드"/>
  67. <Cell col="9" text="방법"/>
  68. <Cell col="10" text="장비"/>
  69. <Cell col="11" text="시약"/>
  70. <Cell col="12" text="단위"/>
  71. <Cell col="13" text="온도"/>
  72. <Cell col="14" text="Comment"/>
  73. <Cell col="15" text="검사자"/>
  74. </Band>
  75. <Band id="body">
  76. <Cell displaytype="date" edittype="none" text="bind:acptdt" mask="yyyy-MM-dd hh:mm:ss"/>
  77. <Cell col="1" style="align:left middle;" text="bind:testnm"/>
  78. <Cell col="2" style="align:right middle;" text="bind:orgrslt"/>
  79. <Cell col="3" displaytype="date" text="bind:testdt" mask="yyyy-MM-dd hh:mm:ss"/>
  80. <Cell col="4" style="align:right middle;" text="bind:run"/>
  81. <Cell col="5" style="align:left middle;" text="bind:matrnm"/>
  82. <Cell col="6" style="align:left middle;" text="bind:levlnm"/>
  83. <Cell col="7" style="align:center middle;" text="bind:lotno"/>
  84. <Cell col="8" style="align:left middle;" text="bind:ocitemnm"/>
  85. <Cell col="9" style="align:left middle;" text="bind:ocmthdnm"/>
  86. <Cell col="10" text="bind:eqmtcd"/>
  87. <Cell col="11" text="bind:ocreagentnm"/>
  88. <Cell col="12" style="align:right middle;" text="bind:ocunitnm"/>
  89. <Cell col="13" style="align:right middle;" text="bind:octmprnm"/>
  90. <Cell col="14" text="bind:comment"/>
  91. <Cell col="15" text="bind:operator"/>
  92. </Band>
  93. </Format>
  94. </Formats>
  95. </Grid>
  96. <Static id="caption9" text="검체정보상세내역" class="tit_2" position="absolute 3 85 139 104"/>
  97. <Button id="button6" taborder="5" text="엑셀" class="btn7" position="absolute 1194 82 1246 101" anchor="top right" onclick="button6_onclick"/>
  98. <Shape id="line2" linetype="horizontal" class="line_1" position="absolute 2 103 1254 109" style="strokepen:3 solid #33bbbbff;" anchor="left top right"/>
  99. <Button id="btn_saveTxt" taborder="6" text="TEXT" class="btn2" position="absolute 1138 82 1191 101" anchor="top right" onclick="btn_saveTxt_onclick"/>
  100. <Grid id="grd_rslt2" taborder="3" binddataset="ds_grd_rslt" useinputpanel="false" visible="false" position="absolute 2 398 1255 800" anchor="all">
  101. <Formats>
  102. <Format id="default">
  103. <Columns>
  104. <Column size="70"/>
  105. <Column size="130"/>
  106. <Column size="70"/>
  107. <Column size="70"/>
  108. <Column size="60"/>
  109. <Column size="60"/>
  110. <Column size="60"/>
  111. <Column size="60"/>
  112. <Column size="60"/>
  113. <Column size="70"/>
  114. <Column size="70"/>
  115. <Column size="70"/>
  116. <Column size="70"/>
  117. <Column size="70"/>
  118. <Column size="80"/>
  119. <Column size="100"/>
  120. </Columns>
  121. <Rows>
  122. <Row size="24" band="head"/>
  123. <Row size="24"/>
  124. </Rows>
  125. <Band id="head">
  126. <Cell text="Point"/>
  127. <Cell col="1" text="검사(접수)일시"/>
  128. <Cell col="2" text="횟수"/>
  129. <Cell col="3" text="레벨"/>
  130. <Cell col="4" text="시행부서"/>
  131. <Cell col="5" text="LOT번호"/>
  132. <Cell col="6" text="항목코드"/>
  133. <Cell col="7" text="방법"/>
  134. <Cell col="8" text="장비"/>
  135. <Cell col="9" text="시약"/>
  136. <Cell col="10" text="단위"/>
  137. <Cell col="11" text="온도"/>
  138. <Cell col="12" text="검사자"/>
  139. <Cell col="13" text="Comment"/>
  140. <Cell col="14" text="Reserved"/>
  141. <Cell col="15" text="결과"/>
  142. </Band>
  143. <Band id="body">
  144. <Cell text="bind:point"/>
  145. <Cell col="1" text="bind:acptdt"/>
  146. <Cell col="2" text="bind:run"/>
  147. <Cell col="3" text="bind:oclevlcd"/>
  148. <Cell col="4" text="bind:testroom"/>
  149. <Cell col="5" text="bind:oclotno"/>
  150. <Cell col="6" text="bind:ocitemcd"/>
  151. <Cell col="7" text="bind:ocmthdcd"/>
  152. <Cell col="8" text="bind:eqmtcd2"/>
  153. <Cell col="9" text="bind:ocreagentcd"/>
  154. <Cell col="10" text="bind:ocunitcd"/>
  155. <Cell col="11" text="bind:octmprcd"/>
  156. <Cell col="12" text="bind:operator"/>
  157. <Cell col="13" text="bind:comment"/>
  158. <Cell col="14" text="bind:reserved"/>
  159. <Cell col="15" text="bind:orgrslt"/>
  160. </Band>
  161. </Format>
  162. </Formats>
  163. </Grid>
  164. </Layout>
  165. </Layouts>
  166. <Objects>
  167. <Dataset id="ds_init_cbo_testRoom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  168. <ColumnInfo>
  169. <Column id="nm" type="STRING"/>
  170. <Column id="cd" type="STRING"/>
  171. </ColumnInfo>
  172. </Dataset>
  173. <Dataset id="ds_init_cbo_emqt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  174. <ColumnInfo>
  175. <Column id="nm" type="STRING"/>
  176. <Column id="cd" type="STRING"/>
  177. </ColumnInfo>
  178. </Dataset>
  179. <Dataset id="ds_grd_rslt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  180. <ColumnInfo>
  181. <Column id="acptdt" type="STRING"/>
  182. <Column id="testnm" type="STRING"/>
  183. <Column id="orgrslt" type="STRING"/>
  184. <Column id="testdt" type="STRING"/>
  185. <Column id="run" type="STRING"/>
  186. <Column id="matrnm" type="STRING"/>
  187. <Column id="levlnm" type="STRING"/>
  188. <Column id="lotno" type="STRING"/>
  189. <Column id="ocitemnm" type="STRING"/>
  190. <Column id="ocmthdnm" type="STRING"/>
  191. <Column id="eqmtcd" type="STRING"/>
  192. <Column id="ocreagentnm" type="STRING"/>
  193. <Column id="ocunitnm" type="STRING"/>
  194. <Column id="octmprnm" type="STRING"/>
  195. <Column id="comment" type="STRING"/>
  196. <Column id="operator" type="STRING"/>
  197. </ColumnInfo>
  198. </Dataset>
  199. <Dataset id="ds_init_lb0701" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  200. <ColumnInfo>
  201. <Column id="cd" type="STRING" size="256"/>
  202. <Column id="nm" type="STRING" size="256"/>
  203. </ColumnInfo>
  204. </Dataset>
  205. <Dataset id="ds_init_lb0000" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  206. <ColumnInfo>
  207. <Column id="cd" type="STRING" size="256"/>
  208. <Column id="nm" type="STRING" size="256"/>
  209. </ColumnInfo>
  210. </Dataset>
  211. <Dataset id="ds_init_lb0111" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  212. <ColumnInfo>
  213. <Column id="cd" type="STRING" size="256"/>
  214. <Column id="nm" type="STRING" size="256"/>
  215. </ColumnInfo>
  216. </Dataset>
  217. </Objects>
  218. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  219. * System Name :
  220. * Job Name :
  221. * Creator :
  222. * Make Date : 2015-05-08
  223. * Description :
  224. *---------------------------------------------------------------------------------------
  225. * Modify Date Modifier Modify Description
  226. *---------------------------------------------------------------------------------------
  227. * 2015-05-08 Live Converter TF->XP
  228. *
  229. *---------------------------------------------------------------------------------------
  230. ****************************************************************************************/
  231. include "com_commonxp::comm_main.xjs";
  232. include "lis_commonxp::LLZ001.xjs";
  233. function SMLQP00400_oninit(obj:Form, e:InitEventInfo)
  234. {
  235. frmf_initForm(obj); // 화면공통
  236. }
  237. function SMLQP00400_onload(obj:Form, e:LoadEventInfo)
  238. {
  239. lf_setInit();
  240. grdf_initGrid(grd_rslt);
  241. }
  242. function lf_setInit(){
  243. var totm = utlf_getCurrentTime().substring(0,4)
  244. group5.ipt_acptFromdd.value = utlf_getCurrentDate();
  245. group5.ipt_acpfromtm.value = "0000";
  246. group5.ipt_acptTodd.value = utlf_getCurrentDate();
  247. group5.ipt_acpttotm.value = totm;
  248. dsf_createDsRow("ds_temp_search"
  249. , [{col: "codeflag", val: "0000|0111|0701|"}]); //0000:사용자부서코드, 0111:시행부서계 0701: 장비코드 0703: 조치사유
  250. var oParam = {};
  251. oParam.id = "TRLZZ00101";
  252. oParam.service = "diagtestapplib.DiagTestBaseInfoMngt";
  253. oParam.method = "reqGetInitCodeInfo";
  254. oParam.inds = "cond=ds_temp_search";
  255. oParam.outds = "ds_init_lb0000=0000 ds_init_lb0111=0111 ds_init_lb0701=0701";
  256. oParam.async = false;
  257. tranf_submit(oParam);
  258. dsf_createDsRow("ds_temp_search2"
  259. , [{col: "codeflag", val: "0501|"}
  260. , {col: "basecdid", val: ds_init_lb0000.getColumn(0,"nm")}]);
  261. oParam = {};
  262. oParam.id = "TRLZZ00101";
  263. oParam.service = "diagtestapplib.DiagTestBaseInfoMngt";
  264. oParam.method = "reqGetInitCodeInfo";
  265. oParam.inds = "cond=ds_temp_search2";
  266. oParam.outds = "ds_init_lb0501=0501";
  267. oParam.async = false;
  268. tranf_submit(oParam);
  269. }
  270. function group5_btn_getRslt_onclick(obj:Button, e:ClickEventInfo)
  271. {
  272. lf_getRslt();
  273. }
  274. function lf_getRslt() {
  275. if(group5.cbo_emqt.value == "00"){
  276. sysf_messageBox("장비를", "C002","");
  277. return;
  278. }
  279. dsf_createDsRow("ds_temp_search"
  280. , [{col: "fromdd", val: group5.ipt_acptFromdd.value }
  281. , {col: "todd", val: group5.ipt_acptTodd.value }
  282. , {col: "fromtm", val: group5.ipt_acpfromtm.value } //검사실
  283. , {col: "totm", val: group5.ipt_acpttotm.value}
  284. , {col: "testroom", val: group5.cbo_testRoom.value}
  285. , {col: "eqmtcd", val: group5.cbo_emqt.value}]);
  286. var oParam = {};
  287. oParam.id = "TRLQP00401";
  288. oParam.service = "grademngtprintapp.QCRsltReference";
  289. oParam.method = "reqGetRslt";
  290. oParam.inds = "cond=ds_temp_search";
  291. oParam.outds = "ds_grd_rslt=testrslt";
  292. oParam.async = false;
  293. //oParam.callback = "cf_TRLQP00401";
  294. tranf_submit(oParam);
  295. }
  296. function lf_setEqmtCd(){
  297. var sEtc = group5.cbo_testRoom.value;
  298. var sFilter = "cd =='00' || etc01 =='" + sEtc + "'";
  299. ds_init_lb0701.filter("");
  300. if(sEtc != "00"){
  301. ds_init_lb0701.filter(sFilter);
  302. }else{
  303. ds_init_lb0701.filter("cd =='00'");
  304. }
  305. group5.cbo_emqt.index=0;
  306. }
  307. function group5_cbo_testRoom_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  308. {
  309. lf_setEqmtCd();
  310. }
  311. function button6_onclick(obj:Button, e:ClickEventInfo)
  312. {
  313. var name = "QC_"+group5.cbo_emqt.text.substring(6, group5.cbo_emqt.text.length);
  314. grdf_exportExcel(grd_rslt,lf_lisGetTitle(this) + "_" + name , "sheet1", false);
  315. }
  316. function btn_saveTxt_onclick(obj:Button, e:ClickEventInfo)
  317. {
  318. var name = "QC_"+group5.cbo_emqt.text.substring(6, group5.cbo_emqt.text.length);
  319. grdf_exportTxt(grd_rslt2,lf_lisGetTitle(this) + "_" + name , "", "USER");
  320. }
  321. function lf_grdVisible(){
  322. if(grd_rslt2.visible == true){
  323. grd_rslt2.visible = false;
  324. }else{
  325. grd_rslt2.visible = true;
  326. }
  327. }
  328. function caption7_onclick(obj:Static, e:ClickEventInfo)
  329. {
  330. lf_grdVisible();
  331. }
  332. ]]></Script>
  333. </Form>
  334. </FDL>