SMRAR03400_가수금입력(UPLOAD).xfdl 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRAR03400" position="absolute 0 0 1219 794" titletext="가수금입력(UPLOAD)" onload="SMRAR03400_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div id="group1" position="absolute 0 0 1195 21" style="" scrollbars="none">
  8. <Layouts>
  9. <Layout>
  10. <Static id="caption6" class="tit_1" position="absolute 0 0 189 22" style="" text="가수금 입력(UPLOAD)" anchor="default"/>
  11. <Static id="caption4" class="patient_text_black" position="absolute 922 0 1194 200" style="" anchor="default"/>
  12. </Layout>
  13. </Layouts>
  14. </Div>
  15. <Div id="group3" scrollbars="autoboth" position="absolute 0 40 1195 784" style="">
  16. <Layouts>
  17. <Layout>
  18. <Div id="grp_sea" position="absolute 0 10 1195 48" style="align: top;">
  19. <Layouts>
  20. <Layout>
  21. <Shape id="roundrect1" anchor="default" class="roundrect_search" type="roundrectangle" position="absolute 0 0 1195 38" style="border:1 solid #ffd799 #ffd799;background:#fffbf2 ;"/>
  22. <Static id="caption3" class="search_name" position="absolute 111 10 190 27" style="" text="예금계좌"/>
  23. <Combo innerdataset="ds_init_bankinfo" datacolumn="aactno" codecolumn="aactcd" columncount="-1" rowcount="-1" id="cmb_aactno" class="combo_s_essential" taborder="1" position="absolute 191 9 321 28" style="itemheight:15;" autoskip="true" onitemchanged="group3_grp_sea_cmb_aactno_onitemchanged"/>
  24. <Edit id="opt_aactcd" class="output_fix" position="absolute 321 9 361 28" style="align:center ;" anchor="default" readonly="true"/>
  25. <Static id="cap_codeflag" class="search_name" position="absolute 407 10 497 27" style="" text="가수금일자"/>
  26. <Calendar id="ipt_gadate" class="input_s_essential" mask="yyyy-mm-dd" position="absolute 500 9 595 28" style="" anchor="default"/>
  27. <Shape id="line5" class="line_4" linetype="vertical" position="absolute 642 8 645 30" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
  28. <Button id="btn_select" class="btn1" taborder="4" position="absolute 653 8 709 30" style="align:left ;" text="조회" onclick="group3_grp_sea_btn_select_onclick"/>
  29. </Layout>
  30. </Layouts>
  31. </Div>
  32. <Shape id="line3" class="line_1" linetype="horizontal" position="absolute 0 75 1194 78" style="" anchor="default"/>
  33. <Grid id="grd_main" binddataset="ds_main_search_maindatalist" visible="false" position="absolute 0 80 1194 715" style="" onaftersort="group3_grd_main_onaftersort" ontextchanged="group3_grd_main_ontextchanged" cellsizingtype="col">
  34. <Formats>
  35. <Format id="default">
  36. <Columns>
  37. <Column size="29"/>
  38. <Column size="56"/>
  39. <Column size="169"/>
  40. <Column size="100"/>
  41. <Column size="150"/>
  42. <Column size="256"/>
  43. <Column size="89"/>
  44. <Column size="65"/>
  45. <Column size="64"/>
  46. <Column size="118"/>
  47. </Columns>
  48. <Rows>
  49. <Row size="24" band="head"/>
  50. <Row size="24"/>
  51. </Rows>
  52. <Band id="head">
  53. <Cell/>
  54. <Cell col="1" text="NO"/>
  55. <Cell col="2" text="거래일시"/>
  56. <Cell col="3" text="구분"/>
  57. <Cell col="4" text="가수금"/>
  58. <Cell col="5" text="적요"/>
  59. <Cell col="6" text="가수금일자"/>
  60. <Cell col="7" text="계좌코드"/>
  61. <Cell col="8" text="기관코드"/>
  62. <Cell col="9" text="workid"/>
  63. </Band>
  64. <Band id="body">
  65. <Cell displaytype="checkbox" text="bind:chk"/>
  66. <Cell col="1" text="bind:line"/>
  67. <Cell col="2" text="bind:dealdt"/>
  68. <Cell col="3" text="bind:gubun"/>
  69. <Cell col="4" text="bind:gaamt"/>
  70. <Cell col="5" text="bind:rmrk"/>
  71. <Cell col="6" text="bind:gadate"/>
  72. <Cell col="7" text="bind:aactcd"/>
  73. <Cell col="8" text="bind:instcd"/>
  74. <Cell col="9" text="bind:workid"/>
  75. </Band>
  76. </Format>
  77. </Formats>
  78. </Grid>
  79. <Static id="caption21" class="tit_2" position="absolute 5 57 136 71" style="" text="거래내역"/>
  80. <Grid id="grd_upload" binddataset="ds_main_upload_uploadlist" position="absolute 0 80 1194 715" style="" cellsizingtype="col">
  81. <Formats>
  82. <Format id="default">
  83. <Columns>
  84. <Column size="56"/>
  85. <Column size="169"/>
  86. <Column size="100"/>
  87. <Column size="150"/>
  88. <Column size="256"/>
  89. <Column size="65"/>
  90. <Column size="64"/>
  91. </Columns>
  92. <Rows>
  93. <Row size="24" band="head"/>
  94. <Row size="24"/>
  95. </Rows>
  96. <Band id="head">
  97. <Cell text="NO"/>
  98. <Cell col="1" text="거래일시"/>
  99. <Cell col="2" text="구분"/>
  100. <Cell col="3" text="가수금"/>
  101. <Cell col="4" text="적요"/>
  102. <Cell col="5" text="계좌코드"/>
  103. <Cell col="6" text="기관코드"/>
  104. </Band>
  105. <Band id="body">
  106. <Cell text="bind:line"/>
  107. <Cell col="1" text="bind:dealdt"/>
  108. <Cell col="2" text="bind:gubun"/>
  109. <Cell col="3" displaytype="number" text="bind:gaamt"/>
  110. <Cell col="4" text="bind:rmrk"/>
  111. <Cell col="5" text="bind:aactcd"/>
  112. <Cell col="6" text="bind:instcd"/>
  113. </Band>
  114. </Format>
  115. </Formats>
  116. </Grid>
  117. <Button id="btn_grddel" class="btn2" position="absolute 1137 53 1190 72" style="" text="행삭제" onclick="group3_btn_grddel_onclick"/>
  118. <MaskEdit id="cpt_gaamtsum" taborder="2" position="absolute 260 718 408 738" style="background:#ffccccff;" mask="999,999,990"/>
  119. </Layout>
  120. </Layouts>
  121. </Div>
  122. <Div id="group4" scrollbars="none" position="absolute 0 13 1195 40" style="">
  123. <Layouts>
  124. <Layout>
  125. <Button id="btn_save" class="btn4" position="absolute 1137 3 1193 25" style="" text="저장" onclick="group4_btn_save_onclick"/>
  126. <Shape id="line2" class="line_6" linetype="horizontal" position="absolute 0 25 1194 28" style="" anchor="default"/>
  127. <Button id="btn_upload" class="btn4" position="absolute 994 3 1134 25" style="" text="거래내역 불러오기" onclick="group4_btn_upload_onclick"/>
  128. </Layout>
  129. </Layouts>
  130. </Div>
  131. <Static id="caption1" class="cell_1" position="absolute 134 757 254 780" style="align:center middle;" text="가수금합계"/>
  132. </Layout>
  133. </Layouts>
  134. <Objects>
  135. <Dataset id="ds_main_upload_uploadlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  136. <ColumnInfo>
  137. <Column id="chk" type="STRING" size="256"/>
  138. <Column id="line" type="STRING" size="256"/>
  139. <Column id="dealdt" type="STRING" size="256"/>
  140. <Column id="gubun" type="STRING" size="256"/>
  141. <Column id="gaamt" type="STRING" size="256"/>
  142. <Column id="rmrk" type="STRING" size="256"/>
  143. <Column id="gadate" type="STRING" size="256"/>
  144. <Column id="aactcd" type="STRING" size="256"/>
  145. <Column id="instcd" type="STRING" size="256"/>
  146. </ColumnInfo>
  147. <Rows>
  148. <Row>
  149. <Col id="chk"/>
  150. <Col id="line"/>
  151. <Col id="dealdt"/>
  152. <Col id="gubun"/>
  153. <Col id="gaamt"/>
  154. <Col id="rmrk"/>
  155. <Col id="gadate"/>
  156. <Col id="aactcd"/>
  157. <Col id="instcd"/>
  158. </Row>
  159. </Rows>
  160. </Dataset>
  161. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  162. <ColumnInfo>
  163. <Column id="save" type="STRING" size="256"/>
  164. </ColumnInfo>
  165. </Dataset>
  166. <Dataset id="ds_init_etcinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  167. <ColumnInfo>
  168. <Column id="seqline" type="STRING" size="256"/>
  169. <Column id="janamt" type="STRING" size="256"/>
  170. <Column id="chulamt" type="STRING" size="256"/>
  171. </ColumnInfo>
  172. <Rows>
  173. <Row>
  174. <Col id="seqline"/>
  175. <Col id="janamt"/>
  176. <Col id="chulamt"/>
  177. </Row>
  178. </Rows>
  179. </Dataset>
  180. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  181. <ColumnInfo/>
  182. </Dataset>
  183. <Dataset id="ds_main_upload" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  184. <ColumnInfo/>
  185. </Dataset>
  186. <Dataset id="ds_main_search_maindatalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  187. <ColumnInfo>
  188. <Column id="chk" type="STRING" size="256"/>
  189. <Column id="line" type="STRING" size="256"/>
  190. <Column id="dealdt" type="STRING" size="256"/>
  191. <Column id="gubun" type="STRING" size="256"/>
  192. <Column id="gaamt" type="STRING" size="256"/>
  193. <Column id="rmrk" type="STRING" size="256"/>
  194. <Column id="gadate" type="STRING" size="256"/>
  195. <Column id="aactcd" type="STRING" size="256"/>
  196. <Column id="instcd" type="STRING" size="256"/>
  197. <Column id="workid" type="STRING" size="256"/>
  198. </ColumnInfo>
  199. <Rows>
  200. <Row>
  201. <Col id="chk"/>
  202. <Col id="line"/>
  203. <Col id="dealdt"/>
  204. <Col id="gubun"/>
  205. <Col id="gaamt"/>
  206. <Col id="rmrk"/>
  207. <Col id="gadate"/>
  208. <Col id="aactcd"/>
  209. <Col id="instcd"/>
  210. <Col id="workid"/>
  211. </Row>
  212. </Rows>
  213. </Dataset>
  214. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  215. <ColumnInfo/>
  216. </Dataset>
  217. <Dataset id="ds_hidden_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  218. <ColumnInfo>
  219. <Column id="code" type="STRING" size="256"/>
  220. <Column id="prntnm" type="STRING" size="256"/>
  221. </ColumnInfo>
  222. <Rows>
  223. <Row>
  224. <Col id="code"/>
  225. <Col id="prntnm"/>
  226. </Row>
  227. </Rows>
  228. </Dataset>
  229. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  230. <ColumnInfo>
  231. <Column id="temp" type="STRING" size="256"/>
  232. </ColumnInfo>
  233. </Dataset>
  234. <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  235. <ColumnInfo/>
  236. </Dataset>
  237. <Dataset id="ds_init_bankinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  238. <ColumnInfo>
  239. <Column id="acctno" type="STRING" size="256"/>
  240. <Column id="acctcd" type="STRING" size="256"/>
  241. </ColumnInfo>
  242. <Rows>
  243. <Row>
  244. <Col id="acctno"/>
  245. <Col id="acctcd"/>
  246. </Row>
  247. </Rows>
  248. </Dataset>
  249. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  250. <ColumnInfo>
  251. <Column id="gadate" type="STRING" size="256"/>
  252. <Column id="instcd" type="STRING" size="256"/>
  253. <Column id="aactno" type="STRING" size="256"/>
  254. <Column id="aactcd" type="STRING" size="256"/>
  255. </ColumnInfo>
  256. <Rows>
  257. <Row>
  258. <Col id="gadate"/>
  259. <Col id="instcd"/>
  260. <Col id="aactno"/>
  261. <Col id="aactcd"/>
  262. </Row>
  263. </Rows>
  264. </Dataset>
  265. <Dataset id="ds_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  266. <ColumnInfo>
  267. <Column id="gadate" type="STRING" size="256"/>
  268. <Column id="instcd" type="STRING" size="256"/>
  269. <Column id="aactno" type="STRING" size="256"/>
  270. <Column id="aactcd" type="STRING" size="256"/>
  271. </ColumnInfo>
  272. <Rows>
  273. <Row>
  274. <Col id="gadate"/>
  275. <Col id="instcd"/>
  276. <Col id="aactno"/>
  277. <Col id="aactcd"/>
  278. </Row>
  279. </Rows>
  280. </Dataset>
  281. <Dataset id="ds_hidden_apsl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  282. <ColumnInfo>
  283. <Column id="sumgaamt" type="STRING" size="256"/>
  284. </ColumnInfo>
  285. <Rows>
  286. <Row>
  287. <Col id="sumgaamt"/>
  288. </Row>
  289. </Rows>
  290. </Dataset>
  291. <Dataset id="ds_hidden_save" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  292. <ColumnInfo>
  293. <Column id="filename" type="STRING" size="256"/>
  294. </ColumnInfo>
  295. <Rows>
  296. <Row/>
  297. </Rows>
  298. </Dataset>
  299. <Dataset id="ds_main_upload_uploadlist_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  300. </Objects>
  301. <Bind>
  302. <BindItem id="item0" compid="group3.grp_sea.cmb_aactno" propid="value" datasetid="ds_search" columnid="aactcd"/>
  303. <BindItem id="item1" compid="group3.grp_sea.opt_aactcd" propid="value" datasetid="ds_search" columnid="aactcd"/>
  304. <BindItem id="item2" compid="group3.grp_sea.ipt_gadate" propid="value" datasetid="ds_search" columnid="gadate"/>
  305. </Bind>
  306. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  307. * System Name :
  308. * Job Name :
  309. * Creator :
  310. * Make Date : 2017-06-19
  311. * Description :
  312. *---------------------------------------------------------------------------------------
  313. * Modify Date Modifier Modify Description
  314. *---------------------------------------------------------------------------------------
  315. * 2017-06-19 Live Converter TF->XP
  316. *
  317. *---------------------------------------------------------------------------------------
  318. ****************************************************************************************/
  319. include "com_commonxp::comm_main.xjs";
  320. include "com_basiccodexp::ZBC001.xjs";
  321. include "mis_miscommonxp::MIS.xjs";
  322. //include "mis_humtrafactmngtxp::RPB001xjs";
  323. //엑셀 입력
  324. function fInputExcel(pGrid) {
  325. var fd = new FileDialog();
  326. var fileName = fd.open("open", FileDialog.LOAD,"%MYDOCUMENT%");
  327. //var regExp = /.dat$/gi;
  328. ds_main_upload_uploadlist.clearData();
  329. ds_main_upload_uploadlist_temp.clearData();
  330. if(!utlf_isNull(fileName)) //
  331. {
  332. var objExtCommon = new ExtCommon();
  333. objExtCommon.excelImportByIndex(fileName.fullpath, 0,"ds_main_upload_uploadlist_temp");
  334. }
  335. var tSum = 0;
  336. for(var j = 1; j < ds_main_upload_uploadlist_temp.rowcount; j++)
  337. {
  338. var aRow = ds_main_upload_uploadlist.addRow();
  339. ds_main_upload_uploadlist.setColumn(aRow, "line", ds_main_upload_uploadlist_temp.getColumn(j, "Col01"));
  340. ds_main_upload_uploadlist.setColumn(aRow, "dealdt", ds_main_upload_uploadlist_temp.getColumn(j, "Col02"));
  341. ds_main_upload_uploadlist.setColumn(aRow, "gubun", ds_main_upload_uploadlist_temp.getColumn(j, "Col03"));
  342. ds_main_upload_uploadlist.setColumn(aRow, "gaamt", ds_main_upload_uploadlist_temp.getColumn(j, "Col04"));
  343. ds_main_upload_uploadlist.setColumn(aRow, "rmrk", ds_main_upload_uploadlist_temp.getColumn(j, "Col05"));
  344. ds_main_upload_uploadlist.setColumn(aRow, "aactcd", ds_search.getColumn(0, "aactcd"));
  345. ds_main_upload_uploadlist.setColumn(aRow, "instcd", sysf_getUserInfo("dutplceinstcd"));
  346. //trace('aaa :'+parseInt(ds_main_upload_uploadlist_temp.getColumn(j, "Col04")));
  347. tSum = parseInt(tSum) + parseInt(ds_main_upload_uploadlist_temp.getColumn(j, "Col04"));
  348. //trace('aaa :'+parseInt(ds_main_upload_uploadlist_temp.getColumn(j, "Col04"))+"/"+tSum);
  349. }
  350. group3.cpt_gaamtsum.value = tSum;
  351. //trace(ds_main_upload_uploadlist.saveXML());
  352. // var fd = new FileDialog();
  353. // var fileName = fd.open("open", FileDialog.LOAD,"%MYDOCUMENT%");
  354. // var regExp = /.dat$/gi;
  355. // var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  356. // if(fileName != "") {
  357. // pGrid.loadExcel(fileName, 1, true);
  358. // // pGrid.deleteRow(1);
  359. //
  360. // //pGrid.refresh();
  361. //
  362. // }
  363. }
  364. function SMRAR03400_onload(obj:Form, e:LoadEventInfo) {
  365. frmf_initForm(obj);
  366. //grdf_initGrid(grd_XXX);
  367. //grdf_setGridSort(grd_XXX);
  368. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  369. ds_main_search_maindatalist.clearData();
  370. ds_main_upload_uploadlist.clearData();
  371. ds_search.setColumn( 0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  372. ds_search.setColumn( 0, "gadate", utlf_getCurrentDate());
  373. var oParam = {};
  374. oParam.id = "TRRAR00101";
  375. oParam.service = "accountinginfoapp.AccountingInfo";
  376. oParam.method = "reqGetAccountCdList";
  377. oParam.inds = "req=ds_search";
  378. oParam.outds = "ds_init_bankinfo=bankinfo";
  379. oParam.async = false;
  380. //oParam.callback = "cf_TRRAR00101";
  381. tranf_submit(oParam);
  382. frmf_addComboItem("group3.grp_sea.cmb_aactno","-- 선택 --","","");
  383. }
  384. function group3_grp_sea_btn_select_onclick(obj:Button, e:ClickEventInfo) {
  385. if (utlf_isNull(ds_search.getColumn(0,"aactcd"))){
  386. sysf_messageBox("예금계좌를 ","C002");
  387. return false;
  388. }
  389. ds_main_search_maindatalist.clearData();
  390. group3.grd_main.visible = true; //기표처리작업용 그리드
  391. group3.grd_upload.visible = false; //upload작업용 그리드
  392. group3.cpt_gaamtsum.value = 0;
  393. //setAlertOn();
  394. ds_send.copyData(ds_search);
  395. // if (submit("TRRAR03401")) {
  396. var oParam = {};
  397. oParam.id = "TRRAR03401";
  398. oParam.service = "accountinginfoapp.AccountingInfo";
  399. oParam.method = "reqGetRADMSUSElist";
  400. oParam.inds = "req=ds_search";
  401. oParam.outds = "ds_main_search_maindatalist=maindatalist";
  402. oParam.async = false;
  403. //oParam.callback = "cf_TRRAR03401";
  404. tranf_submit(oParam);
  405. }
  406. function group3_grd_main_ontextchanged(obj:Grid, e:GridEditTextChangedEventInfo) {
  407. //check를 푸는 경우, row의 status를 초기화한다.
  408. if(e.col == 0) { //chk
  409. if(group3.grd_main.valueMatrix(group3.grd_main.row, group3.grd_main.colRef("chk")) == "N") {
  410. group3.grd_main.rowStatus(group3.grd_main.row) = 0;
  411. group3.cpt_gaamtsum.value = parseFloat(group3.cpt_gaamtsum.value) -
  412. parseFloat(group3.grd_main.valueMatrix(group3.grd_main.row, group3.grd_main.colRef("gaamt")));
  413. } else {
  414. group3.grd_main.rowStatus(group3.grd_main.row) = 2; //강제로 2로 setting
  415. group3.cpt_gaamtsum.value = parseFloat(group3.cpt_gaamtsum.value) +
  416. parseFloat(group3.grd_main.valueMatrix(group3.grd_main.row, group3.grd_main.colRef("gaamt")));
  417. }
  418. }
  419. }
  420. function group3_btn_grddel_onclick(obj:Button, e:ClickEventInfo) {
  421. if(group3.grd_upload.visible) { //upload작업이면
  422. if(group3.grd_upload.rows < 2 || group3.grd_upload.row < 1) return;
  423. group3.grd_upload.deleteRow(group3.grd_upload.row);
  424. } else if(group3.grd_main.visible) { //기표처리 작업이면
  425. if(group3.grd_main.rows < 2 || group3.grd_main.row < 1) return;
  426. /*
  427. - 0 : read : 조회시
  428. - 1 : insert : 행추가시
  429. - 2 : update : 조회한 것을 수정시
  430. - 3 : insert & new : 행추가한 것을 수정시
  431. - 4 : delete
  432. - 5 : delete & insert
  433. - 6 : delete & update
  434. */
  435. var status = group3.grd_main.rowStatus(group3.grd_main.row) ;
  436. if(status == 0) {
  437. group3.grd_main.rowStatus(group3.grd_main.row) = 4;
  438. }else if(status == 2) { //check 되어 있는 상태이면
  439. group3.grd_main.rowStatus(group3.grd_main.row) = 4;
  440. group3.grd_main.valueMatrix(group3.grd_main.row, group3.grd_main.colRef("chk")) = "N"; //강제로 check 지움
  441. group3.cpt_gaamtsum.value = parseFloat(group3.cpt_gaamtsum.value) -
  442. parseFloat(group3.grd_main.valueMatrix(group3.grd_main.row, group3.grd_main.colRef("gaamt")));
  443. }else if(status == 4) {
  444. group3.grd_main.rowStatus(group3.grd_main.row) = 0;
  445. }
  446. }
  447. }
  448. function group4_btn_save_onclick(obj:Button, e:ClickEventInfo) {
  449. if(group3.grd_upload.visible) { //upload작업이면
  450. if(ds_main_upload_uploadlist.rowcount < 2) return;
  451. // for(var i = 1 ; i <= model.instance1.selectNodes(group3.grd_upload.nodeset).length ; i++)
  452. // {
  453. // model.setValue(group3.grd_upload.nodeset + "[" + i + "]_aactcd", group3.grp_sea.opt_aactcd.value);
  454. // model.setValue(group3.grd_upload.nodeset + "[" + i + "]_instcd", sysf_getUserInfo("dutplceinstcd"));
  455. // group3.grd_upload.rowStatus(i) = 1; // 1: insert
  456. // }
  457. //ds_hidden.setColumn( 0, "save",group3.grd_upload.getUpdateData());
  458. var oParam = {};
  459. oParam.id = "TXRAR03401";
  460. oParam.service = "accountinginfoapp.AccountingInfo";
  461. oParam.method = "reqExeSaveRADMSUSE";
  462. oParam.inds = "req=ds_main_upload_uploadlist";
  463. oParam.outds = "";
  464. oParam.async = false;
  465. //oParam.callback = "cf_TXRAR03401";
  466. tranf_submit(oParam);
  467. } else if(group3.grd_main.visible) { //기표처리 작업이면
  468. if(ds_main_search_maindatalist.rowcount < 2) return;
  469. for(var i = 0 ; i < ds_main_search_maindatalist.rowcount ; i++)
  470. {
  471. ds_main_search_maindatalist.setColumn(i, "gadate", group3.grp_sea.ipt_gadate.value);
  472. ds_main_search_maindatalist.setColumn(i, "instcd", sysf_getUserInfo("dutplceinstcd"));
  473. }
  474. ds_hidden.setColumn( 0, "save",group3.grd_main.getUpdateData());
  475. var oParam = {};
  476. oParam.id = "TXRAR03402";
  477. oParam.service = "accountinginfoapp.AccountingInfo";
  478. oParam.method = "reqExeTransRADMSUSA";
  479. oParam.inds = "req=ds_main_search_maindatalist";
  480. oParam.outds = "ds_=line";
  481. oParam.async = false;
  482. //oParam.callback = "cf_TXRAR03402";
  483. tranf_submit(oParam);
  484. }
  485. }
  486. function cf_TXRAR03401(sSvcId, nErrorCode, sErrorMsg) {
  487. if(nErrorCode < 0) return;
  488. group3.grp_sea.btn_select.click();
  489. }
  490. function cf_TXRAR03402(sSvcId, nErrorCode, sErrorMsg) {
  491. if(nErrorCode < 0) return;
  492. group3.grp_sea.btn_select.click();
  493. }
  494. function group4_btn_upload_onclick(obj:Button, e:ClickEventInfo) {
  495. if (group3.grp_sea.cmb_aactno.value == ""){
  496. sysf_messageBox("예금계좌를 ","C002");
  497. return false;
  498. }
  499. ds_main_upload_uploadlist.clearData();
  500. group3.grd_main.visible = false; //기표처리작업용 그리드
  501. group3.grd_upload.visible = true; //upload작업용 그리드
  502. group3.cpt_gaamtsum.value = 0;
  503. fInputExcel(group3.grd_upload);
  504. }
  505. function group3_grp_sea_cmb_aactno_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  506. {
  507. obj.updateToDataset();
  508. ds_search.setColumn( 0, "aactno",group3.grp_sea.cmb_aactno.label);
  509. group3.grp_sea.btn_select.click();
  510. group3.grd_main.setFocus();
  511. }
  512. ]]></Script>
  513. </Form>
  514. </FDL>