SMMMT00203_결과관리서식팝업.xfdl 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMMMT00203" position="absolute 0 0 1200 783" titletext="결과관리서식팝업" onload="SMMMT00203_onload">
  5. <Layouts>
  6. <Layout>
  7. <Button position="absolute 551 758 592 777" id="cmd_input" class="btn2" text="입력" onclick="cmd_input_onclick"/>
  8. <TextArea position="absolute 5 645 591 755" id="tar_Sentence1" wordwrap="char" onkeyup="tar_Sentence1_onkeyup" onlbuttonup="tar_Sentence1_onlbuttonup"/>
  9. <TextArea position="absolute 599 645 1190 755" id="tar_Sentence2" wordwrap="char"/>
  10. <Button position="absolute 731 3 776 22" id="button13" class="btn2" text="조회" onclick="button13_onclick"/>
  11. <Grid position="absolute 5 25 240 640" id="grd_sheet" binddataset="ds_grd_sheet" oncellclick="grd_sheet_oncellclick" visible="true">
  12. <Formats>
  13. <Format id="default">
  14. <Columns>
  15. <Column size="198"/>
  16. <Column size="0"/>
  17. <Column size="0"/>
  18. <Column size="0"/>
  19. </Columns>
  20. <Rows>
  21. <Row size="24" band="head"/>
  22. <Row size="24"/>
  23. </Rows>
  24. <Band id="head">
  25. <Cell text="Sheet List"/>
  26. <Cell col="1" text="seq"/>
  27. <Cell col="2" text="defltvw"/>
  28. <Cell col="3" text="grupcd"/>
  29. </Band>
  30. <Band id="body">
  31. <Cell text="bind:sheetnm" edittype="text" displaytype="text"/>
  32. <Cell col="1" text="bind:seq" edittype="text" displaytype="text"/>
  33. <Cell col="2" text="bind:defltvw" edittype="text" displaytype="text"/>
  34. <Cell col="3" text="bind:grupcd" edittype="text" displaytype="text"/>
  35. </Band>
  36. </Format>
  37. </Formats>
  38. </Grid>
  39. <Button position="absolute 917 3 970 22" id="btn_rowdel" class="btn2" text="행삭제" onclick="btn_rowdel_onclick" enable="false"/>
  40. <Button position="absolute 444 765 499 784" id="btn_default" class="btn2" text="Default" visible="false"/>
  41. <Button position="absolute 5 760 91 779" id="btn_datasave" class="btn5" text="편집내용저장" visible="false"/>
  42. <CheckBox position="absolute 105 760 130 780" id="bool1" visible="false"/>
  43. <Static text="관리자모드" position="absolute 129 762 200 777" id="cap_superuser" visible="false"/>
  44. <Button position="absolute 636 0 678 19" id="btn_fontbold" class="btn2_letter2" text="굵게" visible="false"/>
  45. <Button position="absolute 1049 3 1134 22" id="btn_excel" class="btn7" text="엑셀업로드" onclick="btn_excel_onclick" enable="false"/>
  46. <Button position="absolute 557 0 632 19" id="btn_initcell" class="btn2" text="간격초기화" visible="false"/>
  47. <Grid position="absolute 5 25 1190 643" id="grd_sheetdata" binddataset="ds_grd_sheetdata" cellsizingtype="col" oncellclick="grd_sheetdata_oncellclick" selecttype="multiarea" autoenter="key">
  48. <Formats>
  49. <Format id="default">
  50. <Columns>
  51. <Column size="72"/>
  52. <Column size="72"/>
  53. <Column size="72"/>
  54. <Column size="72"/>
  55. <Column size="72"/>
  56. <Column size="72"/>
  57. <Column size="72"/>
  58. <Column size="72"/>
  59. <Column size="72"/>
  60. <Column size="72"/>
  61. <Column size="72"/>
  62. <Column size="72"/>
  63. <Column size="72"/>
  64. <Column size="72"/>
  65. <Column size="72"/>
  66. <Column size="72"/>
  67. <Column size="72"/>
  68. <Column size="72"/>
  69. <Column size="72"/>
  70. <Column size="72"/>
  71. </Columns>
  72. <Rows>
  73. <Row size="24" band="head"/>
  74. <Row size="24"/>
  75. </Rows>
  76. <Band id="head">
  77. <Cell text="A"/>
  78. <Cell col="1" text="B"/>
  79. <Cell col="2" text="C"/>
  80. <Cell col="3" text="D"/>
  81. <Cell col="4" text="E"/>
  82. <Cell col="5" text="F"/>
  83. <Cell col="6" text="G"/>
  84. <Cell col="7" text="H"/>
  85. <Cell col="8" text="I"/>
  86. <Cell col="9" text="J"/>
  87. <Cell col="10" text="K"/>
  88. <Cell col="11" text="L"/>
  89. <Cell col="12" text="M"/>
  90. <Cell col="13" text="N"/>
  91. <Cell col="14" text="O"/>
  92. <Cell col="15" text="P"/>
  93. <Cell col="16" text="Q"/>
  94. <Cell col="17" text="R"/>
  95. <Cell col="18" text="S"/>
  96. <Cell col="19" text="T"/>
  97. </Band>
  98. <Band id="body">
  99. <Cell displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" style="font: ;" text="bind:col0" editautoselect="true" editacceptsdirectionkey="true"/>
  100. <Cell col="1" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col1" editautoselect="true" editacceptsdirectionkey="true"/>
  101. <Cell col="2" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col2" editautoselect="true" editacceptsdirectionkey="true"/>
  102. <Cell col="3" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col3" editautoselect="true" editacceptsdirectionkey="true"/>
  103. <Cell col="4" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col4" editautoselect="true" editacceptsdirectionkey="true"/>
  104. <Cell col="5" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col5" editautoselect="true" editacceptsdirectionkey="true"/>
  105. <Cell col="6" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col6" editautoselect="true" editacceptsdirectionkey="true"/>
  106. <Cell col="7" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col7" editautoselect="true" editacceptsdirectionkey="true"/>
  107. <Cell col="8" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col8" editautoselect="true" editacceptsdirectionkey="true"/>
  108. <Cell col="9" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col9" editautoselect="true" editacceptsdirectionkey="true"/>
  109. <Cell col="10" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col10" editautoselect="true" editacceptsdirectionkey="true"/>
  110. <Cell col="11" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col11" editautoselect="true" editacceptsdirectionkey="true"/>
  111. <Cell col="12" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col12" editautoselect="true" editacceptsdirectionkey="true"/>
  112. <Cell col="13" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col13" editautoselect="true" editacceptsdirectionkey="true"/>
  113. <Cell col="14" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col14" editautoselect="true" editacceptsdirectionkey="true"/>
  114. <Cell col="15" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col15" editautoselect="true" editacceptsdirectionkey="true"/>
  115. <Cell col="16" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col16" editautoselect="true" editacceptsdirectionkey="true"/>
  116. <Cell col="17" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col17" editautoselect="true" editacceptsdirectionkey="true"/>
  117. <Cell col="18" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col18" editautoselect="true" editacceptsdirectionkey="true"/>
  118. <Cell col="19" displaytype="text" edittype="expr:chk_enable.value == true ? 'text' : ''" text="bind:col19" editautoselect="true" editacceptsdirectionkey="true"/>
  119. </Band>
  120. </Format>
  121. </Formats>
  122. </Grid>
  123. <CheckBox position="absolute 200 760 220 780" id="bool2" visible="false"/>
  124. <Static text="자동줄바꿈적용" position="absolute 221 761 307 776" id="caption1" visible="false"/>
  125. <Button position="absolute 972 3 1047 22" id="btn_xlssave" class="btn7" text="엑셀저장" onclick="btn_xlssave_onclick" enable="false"/>
  126. <Button id="btn_save" taborder="1" text="저장" class="btn4" visible="true" position="absolute 1136 3 1190 22" onclick="btn_save_onclick"/>
  127. <CheckBox id="chk_enable" taborder="2" text="자료수정" position="absolute 789 2 861 22" onclick="chk_enable_onclick"/>
  128. <Button id="btn_rowadd" taborder="3" text="행추가" onclick="btn_rowadd_onclick" class="btn2" enable="false" position="absolute 862 3 915 22"/>
  129. </Layout>
  130. </Layouts>
  131. <Objects>
  132. <Dataset id="ds_grd_sheet" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  133. <ColumnInfo>
  134. <Column id="sheetnm" type="STRING"/>
  135. <Column id="seq" type="STRING"/>
  136. <Column id="defltvw" type="STRING"/>
  137. <Column id="grupcd" type="STRING"/>
  138. </ColumnInfo>
  139. </Dataset>
  140. <Dataset id="ds_grd_sheetdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  141. <ColumnInfo>
  142. <Column id="col0" type="STRING"/>
  143. <Column id="col1" type="STRING"/>
  144. <Column id="col2" type="STRING"/>
  145. <Column id="col3" type="STRING"/>
  146. <Column id="col4" type="STRING"/>
  147. <Column id="col5" type="STRING"/>
  148. <Column id="col6" type="STRING"/>
  149. <Column id="col7" type="STRING"/>
  150. <Column id="col8" type="STRING"/>
  151. <Column id="col9" type="STRING"/>
  152. <Column id="col10" type="STRING"/>
  153. <Column id="col11" type="STRING"/>
  154. <Column id="col12" type="STRING"/>
  155. <Column id="col13" type="STRING"/>
  156. <Column id="col14" type="STRING"/>
  157. <Column id="col15" type="STRING"/>
  158. <Column id="col16" type="STRING"/>
  159. <Column id="col17" type="STRING"/>
  160. <Column id="col18" type="STRING"/>
  161. <Column id="col19" type="STRING"/>
  162. <Column id="col20" type="STRING"/>
  163. </ColumnInfo>
  164. </Dataset>
  165. <Dataset id="ds_sheetdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  166. <ColumnInfo>
  167. <Column id="seq" type="STRING" size="256"/>
  168. <Column id="rowno" type="STRING" size="256"/>
  169. <Column id="colno" type="STRING" size="256"/>
  170. <Column id="bold" type="STRING" size="256"/>
  171. <Column id="content" type="STRING" size="256"/>
  172. </ColumnInfo>
  173. </Dataset>
  174. <Dataset id="ds_sheetinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  175. <ColumnInfo>
  176. <Column id="seq" type="STRING" size="256" sumtext=""/>
  177. <Column id="flag" type="STRING" size="256" sumtext=""/>
  178. <Column id="pos" type="STRING" size="256" sumtext=""/>
  179. <Column id="val" type="STRING" size="256" sumtext=""/>
  180. </ColumnInfo>
  181. </Dataset>
  182. <Dataset id="ds_savesheetdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  183. <ColumnInfo>
  184. <Column id="seq" type="STRING" size="256"/>
  185. <Column id="rowno" type="STRING" size="256"/>
  186. <Column id="colno" type="STRING" size="256"/>
  187. <Column id="bold" type="STRING" size="256"/>
  188. <Column id="content" type="STRING" size="256"/>
  189. </ColumnInfo>
  190. </Dataset>
  191. <Dataset id="ds_savesheetinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  192. <ColumnInfo>
  193. <Column id="seq" type="STRING" size="256" sumtext=""/>
  194. <Column id="flag" type="STRING" size="256" sumtext=""/>
  195. <Column id="pos" type="STRING" size="256" sumtext=""/>
  196. <Column id="val" type="STRING" size="256" sumtext=""/>
  197. </ColumnInfo>
  198. </Dataset>
  199. </Objects>
  200. <InitValue>
  201. <Button id="btn_save" visible="true" enable="false"/>
  202. </InitValue>
  203. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  204. * System Name :
  205. * Job Name :
  206. * Creator :
  207. * Make Date : 2015-11-13
  208. * Description :
  209. *---------------------------------------------------------------------------------------
  210. * Modify Date Modifier Modify Description
  211. *---------------------------------------------------------------------------------------
  212. * 2015-11-13 Live Converter TF->XP
  213. *
  214. *---------------------------------------------------------------------------------------
  215. ****************************************************************************************/
  216. include "com_commonxp::comm_main.xjs"
  217. include "com_commonxp::comm_utl.xjs"
  218. var gImpression = false;
  219. var gImpressionVal = "";
  220. var gCaretPos = -1;
  221. function SMMMT00203_onload(obj:Form, e:LoadEventInfo)
  222. {
  223. frmf_initForm(obj);
  224. var ls_superuser = "";
  225. var ls_grupcd = "";
  226. ls_superuser = opener.frmf_getParameter("mmt203_superuser");
  227. ls_grupcd = opener.frmf_getParameter("mmt203_grupcd");
  228. tar_Sentence1.value = opener.frmf_getParameter("mmt203_str1");
  229. tar_Sentence2.value = opener.frmf_getParameter("mmt203_str2");
  230. if( ls_grupcd == "EGD_EF" || ls_grupcd == "EGD_ST" ){
  231. gImpression = true;
  232. }
  233. //model.makeValue("/root/main/grupcd", ls_grupcd);
  234. //var sgrupcd = model.getValue("/root/main/grupcd");
  235. fGetSheetList(ls_grupcd);
  236. var event = new GridClickEventInfo;
  237. grd_sheet.oncellclick.fireEvent(grd_sheet,event);
  238. }
  239. function fGetSheetList(grupcd) {
  240. var ls_defaultseq;
  241. dsf_createDsRow("ds_send_TRAMT00300", [{col: "grupcd", type:"string", size:256, val:grupcd}
  242. ]);
  243. var oParam = {};
  244. oParam.id = "TRAMT00300";
  245. oParam.service = "recpatapp.SheetMngt";
  246. oParam.method = "reqGetSheetList";
  247. oParam.inds = "req=ds_send_TRAMT00300";
  248. oParam.outds = "ds_grd_sheet=sheet";
  249. oParam.async = false;
  250. oParam.callback = "cf_TRAMT00300";
  251. tranf_submit(oParam);
  252. }
  253. function cf_TRAMT00300(sSvcId, nErrorCode, sErrorMsg) {
  254. if(nErrorCode < 0) return;
  255. }
  256. function fGetSheetInfo(asseq) {
  257. var ls_flag = 0;
  258. var ls_pos = 0;
  259. ds_sheetinfo.clearData();
  260. sysf_trace("asseq" +asseq);
  261. dsf_createDsRow("ds_send_TRAMT00303", [{col: "seq", type:"string", size:256, val:asseq}
  262. ]);
  263. var oParam = {};
  264. oParam.id = "TRAMT00303";
  265. oParam.service = "recpatapp.SheetMngt";
  266. oParam.method = "reqGetSheetInfo";
  267. oParam.inds = "req=ds_send_TRAMT00303";
  268. oParam.outds = "ds_sheetinfo=sheet";
  269. oParam.async = false;
  270. //oParam.callback = "cf_TRAMT00303";
  271. tranf_submit(oParam);
  272. var DataCnt = ds_sheetinfo.rowcount;
  273. for(var i=0; i < DataCnt; i++) {
  274. ls_flag = ds_sheetinfo.getColumn(i,"flag");
  275. ls_pos = ds_sheetinfo.getColumn(i,"pos");
  276. ls_value = ds_sheetinfo.getColumn(i,"val");
  277. //C:Col, R:Row
  278. if (ls_flag == "R") {
  279. grd_sheetdata.setFormatRowProperty(ls_pos, "size", parseInt(ls_value));
  280. } else {
  281. grd_sheetdata.setFormatColProperty(ls_pos, "size", parseInt(ls_value));
  282. }
  283. }
  284. }
  285. function fChangefont(font){
  286. // if(font == undefined || font == "" || font == "N")
  287. // font = "arial,12";
  288. // else
  289. // font = "arial,9,bold";
  290. //
  291. // return font;
  292. }
  293. function fGetSheetData(asseq) {
  294. var sRow = 0;
  295. var sCol = 0;
  296. var scontent = "";
  297. var sbold = "";
  298. var setrow = 0;
  299. var addrow = -1;
  300. //저장을 위해 기록
  301. //model.makeValue("/root/main/display/seq", asseq);
  302. //model.makeValue("/root/send/flag/seq", asseq);
  303. ds_sheetdata.clearData();
  304. ds_grd_sheetdata.clearData();
  305. dsf_createDsRow("ds_send_TRAMT00302", [{col: "seq", type:"string", size:256, val:asseq}
  306. ]);
  307. var oParam = {};
  308. oParam.id = "TRAMT00302";
  309. oParam.service = "recpatapp.SheetMngt";
  310. oParam.method = "reqGetSheetData";
  311. oParam.inds = "req=ds_send_TRAMT00302";
  312. oParam.outds = "ds_sheetdata=sheet";
  313. oParam.async = false;
  314. //oParam.callback = "cf_TRAMT00303";
  315. tranf_submit(oParam);
  316. var DataCnt = ds_sheetdata.rowcount;
  317. for(var i=0; i < DataCnt; i++) {
  318. sRow = ds_sheetdata.getColumn(i,"rowno");
  319. sCol = ds_sheetdata.getColumn(i,"colno");
  320. scontent = ds_sheetdata.getColumn(i,"content");
  321. sbold = ds_sheetdata.getColumn(i,"bold");
  322. setcol = "col" + sCol;
  323. // 2016.06.08 빈 Row 추가
  324. if( addrow != sRow ) {
  325. for(var j=addrow+1; j<= sRow; j++){
  326. addrow = ds_grd_sheetdata.addRow();
  327. }
  328. }
  329. ds_grd_sheetdata.setColumn(sRow,setcol,scontent);
  330. }
  331. ds_grd_sheetdata.rowposition = 0;
  332. }
  333. function grd_sheet_oncellclick(obj:Grid, e:GridClickEventInfo)
  334. {
  335. var selRow = ds_grd_sheet.rowposition;
  336. var seq = ds_grd_sheet.getColumn(selRow,"seq");
  337. if (utlf_isNull(seq)) {
  338. return;
  339. }
  340. fGetSheetInfo(seq);
  341. fGetSheetData(seq);
  342. }
  343. function cmd_input_onclick(obj:Button, e:ClickEventInfo)
  344. {
  345. if (frmf_checkOpener()) {
  346. opener.frmf_setParameter("mmt203_str1", tar_Sentence1.value);
  347. opener.frmf_setParameter("mmt203_impressionval", gImpressionVal);
  348. opener.frmf_setParameter("mmt203_caretpos", gCaretPos);
  349. this.close();
  350. }
  351. }
  352. function btn_rowadd_onclick(obj:Button, e:ClickEventInfo)
  353. {
  354. var row = ds_grd_sheetdata.rowposition;
  355. if ( row < 0 ) {
  356. row = 0;
  357. }
  358. ds_grd_sheetdata.insertRow(row);
  359. }
  360. function btn_rowdel_onclick(obj:Button, e:ClickEventInfo)
  361. {
  362. ds_grd_sheetdata.deleteRow(ds_grd_sheetdata.rowposition);
  363. }
  364. function button13_onclick(obj:Button, e:ClickEventInfo)
  365. {
  366. var event = new GridClickEventInfo;
  367. grd_sheet.oncellclick.fireEvent(grd_sheet,event);
  368. }
  369. function chk_enable_onclick(obj:CheckBox, e:ClickEventInfo)
  370. {
  371. if (obj.value == 0 ) {
  372. btn_rowadd.enable = false;
  373. btn_rowdel.enable = false;
  374. btn_save.enable = false;
  375. btn_xlssave.enable = false;
  376. btn_excel.enable = false;
  377. }
  378. else {
  379. btn_rowadd.enable = true;
  380. btn_rowdel.enable = true;
  381. btn_save.enable = true;
  382. btn_xlssave.enable = true;
  383. btn_excel.enable = true;
  384. }
  385. }
  386. function btn_save_onclick(obj:Button, e:ClickEventInfo)
  387. {
  388. fSave();
  389. }
  390. function grd_sheetdata_oncellclick(obj:Grid, e:GridClickEventInfo)
  391. {
  392. if (chk_enable.value == 1){
  393. return;
  394. }
  395. var col = e.col;
  396. var row = e.row;
  397. var oldrow = e.oldrow;
  398. var text = utlf_transNullToEmpty(ds_grd_sheetdata.getColumn(row,col));
  399. if( utlf_isNull(text) ){
  400. return;
  401. }
  402. text = text + " ";
  403. var sImpVal = utlf_transNullToEmpty(ds_grd_sheetdata.getColumn(row,"col0"));
  404. var selidx = tar_Sentence1.getSelect();
  405. var txtSelPos = selidx[0];
  406. var SetEndCursorPos = txtSelPos;
  407. var curText = utlf_transNullToEmpty(tar_Sentence1.value);
  408. var curTextBefore = curText.substr(0, txtSelPos);
  409. var curTextAfter = curText.substr(txtSelPos, curText.length);
  410. if(utlf_isNull(tar_Sentence1.value)){
  411. tar_Sentence1.value = text;
  412. SetEndCursorPos = text.length;
  413. if( gImpression == true && !utlf_isNull(sImpVal) ){
  414. gImpressionVal = sImpVal;
  415. }
  416. } else {
  417. tar_Sentence1.value = curTextBefore + text + curTextAfter;
  418. SetEndCursorPos = (curTextBefore + text).length;
  419. if( gImpression == true && !utlf_isNull(sImpVal) ){
  420. if( utlf_isNull(gImpressionVal)){
  421. gImpressionVal = sImpVal;
  422. }else{
  423. gImpressionVal += "\n"+sImpVal;
  424. }
  425. }
  426. }
  427. tar_Sentence1.setCaretPos(SetEndCursorPos);
  428. gCaretPos = SetEndCursorPos;
  429. tar_Sentence1.setFocus();
  430. }
  431. function fSave()
  432. {
  433. ds_savesheetdata.clearData();
  434. ds_savesheetinfo.clearData();
  435. var rowcount = ds_grd_sheetdata.rowcount;
  436. var seq = ds_grd_sheet.getColumn(0,"seq");
  437. var data = "";
  438. var col = 0 ;
  439. var addrow = 0;
  440. for (var i = 0 ; i < rowcount ; i++)
  441. {
  442. for (var j = 0 ; j < 20 ; j++) {
  443. data = ds_grd_sheetdata.getColumn(i,j);
  444. if (!utlf_isNull(data)) {
  445. addrow = ds_savesheetdata.addRow();
  446. ds_savesheetdata.setColumn(addrow,"seq",seq);
  447. ds_savesheetdata.setColumn(addrow,"rowno",i);
  448. ds_savesheetdata.setColumn(addrow,"colno",j);
  449. ds_savesheetdata.setColumn(addrow,"bold","N");
  450. ds_savesheetdata.setColumn(addrow,"content",data);
  451. }
  452. }
  453. }
  454. for (var j = 0 ; j < 20 ; j++) {
  455. data = grd_sheetdata.getRealColSize(j);
  456. addrow = ds_savesheetinfo.addRow();
  457. ds_savesheetinfo.setColumn(addrow,"seq",seq);
  458. ds_savesheetinfo.setColumn(addrow,"flag","C");
  459. ds_savesheetinfo.setColumn(addrow,"pos",j);
  460. ds_savesheetinfo.setColumn(addrow,"val",data);
  461. }
  462. var oParam = {};
  463. oParam.id = "SMMMT00203_1";
  464. oParam.service = "recpatapp.SheetMngt";
  465. oParam.method = "reqExeSheetData";
  466. oParam.inds = "req=ds_savesheetdata req2=ds_savesheetinfo";
  467. oParam.outds = "";
  468. oParam.async = false;
  469. oParam.callback = "cf_SMMMT00203_1";
  470. tranf_submit(oParam);
  471. }
  472. function cf_SMMMT00203_1(sSvcId, nErrorCode, sErrorMsg) {
  473. if(nErrorCode < 0) return;
  474. sysf_messageBox("정상적으로 처리되었습니다","000");
  475. // arErrorCode.push(sSvcId, nErrorCode);
  476. }
  477. /****************************************************************************************
  478. * Components : Button
  479. * Components ID : btn_xlssave
  480. * Event : onclick
  481. * Argument : 01.obj : Object Event has occurred
  482. * : 02.e : Event Object
  483. * Description : 엑셀 저장
  484. ****************************************************************************************/
  485. function btn_xlssave_onclick(obj:Button, e:ClickEventInfo)
  486. {
  487. grdf_exportExcel(grd_sheetdata, "결과관리서식", "SheetName");
  488. }
  489. /****************************************************************************************
  490. * Components : Button
  491. * Components ID : btn_excel
  492. * Event : onclick
  493. * Argument : 01.obj : Object Event has occurred
  494. * : 02.e : Event Object
  495. * Description : 엑셀 업로드
  496. ****************************************************************************************/
  497. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  498. {
  499. ds_grd_sheetdata.clearData();
  500. grdf_ImportExcel("ds_grd_sheetdata", 2, grd_sheetdata, 0);
  501. if( sysf_messageBox("등록한 내용으로", "Q002") == 6 ){
  502. btn_save.click();
  503. }
  504. }
  505. function tar_Sentence1_onkeyup(obj:TextArea, e:KeyEventInfo)
  506. {
  507. gCaretPos = obj.getCaretPos();
  508. }
  509. function tar_Sentence1_onlbuttonup(obj:TextArea, e:MouseEventInfo)
  510. {
  511. gCaretPos = obj.getCaretPos();
  512. }
  513. ]]></Script>
  514. </Form>
  515. </FDL>