123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SPRAD00108" position="absolute 0 0 895 537" titletext="이체계좌등록" oninit="SPRAD00108_oninit" onload="SPRAD00108_onload">
- <Layouts>
- <Layout>
- <Button id="btn_grdset" taborder="3" text="행수정" class="btn2" position="absolute 693 236 746 255" onclick="btn_grdset_onclick"/>
- <Button id="btn_grdadd" taborder="26" text="행추가" class="btn2" position="absolute 693 236 746 255" onclick="btn_grdadd_onclick"/>
- <Div position="absolute 0 24 890 64" id="group4" scrollbars="autoboth" class="div_SA">
- <Layouts>
- <Layout>
- <Button position="absolute 824 10 880 32" align="align:left middle;" id="btn_search" class="btn1" visible="true" text="조회" anchor="default" onclick="group4_btn_search_onclick"/>
- <Edit readonly="true" position="absolute 610 12 660 31" id="output1" visible="false" anchor="default"/>
- <Static text="전표정보 :" position="absolute 5 12 91 29" id="caption7" class="search_name" visible="true" anchor="default"/>
- <MaskEdit readonly="true" position="absolute 100 11 200 30" align="align:center middle;" id="output2" visible="true" mask="####-##-##" anchor="default" maskchar=" " trimtype="both" type="string" style="align:center middle;"/>
- <Edit readonly="true" position="absolute 205 11 255 30" align="align:center middle;" id="output3" visible="true" anchor="default"/>
- <Shape position="absolute 801 10 807 32" linetype="vertical" id="line5" class="line_4" anchor="default"/>
- <MaskEdit readonly="true" position="absolute 375 11 490 30" align="align:right middle;" id="output5" visible="true" mask="9,99999999" anchor="default" maskchar=" "/>
- <Static text="전표금액 :" position="absolute 280 12 368 29" id="caption2" class="search_name" visible="true" anchor="default"/>
- <Button position="absolute 668 10 796 32" id="btn_autoaactInstert" class="btn4" enable="true" text="이체계좌자동생성" anchor="default" onclick="group4_btn_autoaactInstert_onclick"/>
- </Layout>
- </Layouts>
- </Div>
- <Static id="caption6" text="이체계좌 등록" class="tit_1" position="absolute 0 0 293 25"/>
- <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 772 510 828 532" onclick="btn_save_onclick"/>
- <Button id="btn_cancel" taborder="2" text="닫기" class="btn4" position="absolute 829 510 885 532" onclick="btn_cancel_onclick"/>
- <Shape id="line32" class="line_6" position="absolute 0 506 885 512"/>
- <Shape id="line3" class="line_10" position="absolute 0 255 890 261"/>
- <Button id="btn_excadd" taborder="4" text="엑셀입력" class="btn7" position="absolute 554 236 634 255" onclick="btn_excadd_onclick"/>
- <Grid id="grd_transacnt" taborder="5" binddataset="ds_main_transacnt" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 260 890 478" onselectchanged="grd_transacnt_onselectchanged" oncellclick="grd_transacnt_oncellclick">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="24"/>
- <Column size="28"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="135"/>
- <Column size="130"/>
- <Column size="0"/>
- <Column size="91"/>
- <Column size="105"/>
- <Column size="150"/>
- <Column size="200"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell text="기관코드"/>
- <Cell col="1" text="미결전표일자"/>
- <Cell col="2" text="미결전표번호"/>
- <Cell col="3"/>
- <Cell col="4" text="Seq"/>
- <Cell col="5" text="상대처구분"/>
- <Cell col="6" text="dummy1"/>
- <Cell col="7" text="상대처코드"/>
- <Cell col="8" text="상대처명"/>
- <Cell col="9" text="계좌번호"/>
- <Cell col="10" text="은행명"/>
- <Cell col="11" text="은행명1"/>
- <Cell col="12" text="예금주"/>
- <Cell col="13" text="금액"/>
- <Cell col="14" text="입금명"/>
- <Cell col="15" text="비고"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" text="bind:unsldd"/>
- <Cell col="2" text="bind:unslno"/>
- <Cell col="3" celltype="head"/>
- <Cell col="4" displaytype="text" edittype="text" text="bind:seqno"/>
- <Cell col="5" displaytype="combo" edittype="combo" text="bind:acntflag"/>
- <Cell col="6" text="bind:dummy1"/>
- <Cell col="7" displaytype="text" edittype="text" text="bind:acntflagcd"/>
- <Cell col="8" displaytype="text" edittype="text" text="bind:acntflagnm"/>
- <Cell col="9" displaytype="text" edittype="text" text="bind:rcipntacntno" enable="false"/>
- <Cell col="10" displaytype="combo" edittype="combo" text="bind:bankcd" combodataset="ds_init_R0001list" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
- <Cell col="11" displaytype="text" edittype="text" text="bind:banknm"/>
- <Cell col="12" displaytype="text" edittype="text" text="bind:depor" enable="false"/>
- <Cell col="13" displaytype="number" edittype="normal" text="bind:amt" enable="false"/>
- <Cell col="14" displaytype="text" edittype="text" text="bind:deponm" enable="false"/>
- <Cell col="15" displaytype="text" edittype="text" text="bind:cmt"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Static id="caption1" text="이체계좌 내역" class="tit_2" position="absolute 0 239 183 260"/>
- <MaskEdit id="output4" taborder="6" readonly="true" mask="9,9999999" position="absolute 761 483 886 502"/>
- <Static id="caption3" text="이체금액 합계 :" position="absolute 671 483 771 503"/>
- <Button id="btn_setaact" taborder="7" text="집합계좌등록" class="btn2" position="absolute 802 236 888 255" onclick="btn_setaact_onclick"/>
- <Static id="caption21" text="계좌번호" class="cell_1" position="absolute 277 71 377 94"/>
- <Static id="caption22" text="예금주" class="cell_1" position="absolute 547 71 647 94"/>
- <Static id="caption23" text="입금자명" class="cell_1" position="absolute 277 97 377 120"/>
- <Static id="caption24" text="금액" class="cell_1" position="absolute 7 97 107 120"/>
- <Static id="caption25" text="은행명" class="cell_1" position="absolute 7 71 107 94"/>
- <Static id="caption4" text="출금내역" class="cell_1" position="absolute 547 97 647 120"/>
- <Shape id="line10" class="line_2" position="absolute 1 198 890 204" onclick="line10_onclick"/>
- <Shape id="line1" class="line_2" position="absolute 0 172 889 178"/>
- <Shape id="line2" class="line_2" position="absolute 0 224 889 230"/>
- <Shape id="line4" class="line_2" position="absolute 0 119 889 125"/>
- <Shape id="line6" class="line_2" position="absolute 0 93 889 99"/>
- <Shape id="line7" class="line_2" position="absolute 0 144 889 150"/>
- <Shape id="line8" linetype="vertical" class="line_2" position="absolute 270 67 276 121"/>
- <Combo id="cmb_bankcd" taborder="8" innerdataset="@ds_init_R0001list" codecolumn="cdid" datacolumn="cdnm" class="combo_search" position="absolute 110 73 270 92" onitemchanged="cmb_bankcd_onitemchanged"/>
- <Edit id="ipt_rcipntacntno" taborder="9" class="input_search" position="absolute 380 73 540 92" onkeydown="ipt_rcipntacntno_onkeydown"/>
- <Edit id="ipt_depor" taborder="10" class="input_search" position="absolute 650 73 810 92" onkeydown="ipt_depor_onkeydown"/>
- <MaskEdit id="ipt_amt" taborder="11" class="input_search" position="absolute 110 99 270 118" maskchar=" " onkeydown="ipt_amt_onkeydown"/>
- <Edit id="ipt_deponm" taborder="12" class="input_search" position="absolute 380 99 540 118" onkeydown="ipt_deponm_onkeydown"/>
- <Edit id="ipt_cmt" taborder="13" class="input_search" position="absolute 650 99 886 118" onkeydown="ipt_cmt_onkeydown"/>
- <Button id="btn_grddel" taborder="14" text="행삭제" class="btn2" position="absolute 748 236 801 255" onclick="btn_grddel_onclick"/>
- <Button id="btn_reset" taborder="15" text="행정리" class="btn2" position="absolute 637 236 690 255" onclick="btn_reset_onclick"/>
- <Button id="btn_custhelp" taborder="16" class="icon_search" position="absolute 220 154 236 170" onclick="btn_custhelp_onclick"/>
- <Button id="btn_emplhelp" taborder="17" class="icon_search" position="absolute 220 179 236 195" onclick="btn_emplhelp_onclick"/>
- <Edit id="ipt_custnm" taborder="18" class="input_search" position="absolute 241 152 435 171" autoskip="true" autoselect="true" onkeydown="ipt_custnm_onkeydown"/>
- <Button id="btn_icpnhelp" taborder="19" class="icon_search" position="absolute 220 204 236 220" onclick="btn_icpnhelp_onclick"/>
- <Edit id="ipt_emplnm" taborder="20" class="input_search" position="absolute 241 178 435 197" autoselect="true" autoskip="true" onkeydown="ipt_emplnm_onkeydown"/>
- <Edit id="ipt_custcd" taborder="21" class="input_search" position="absolute 110 152 215 171" onkeydown="ipt_custcd_onkeydown" autoselect="true" autoskip="true"/>
- <Static id="caption5" text="거래처" class="cell_1" position="absolute 7 150 107 173"/>
- <Edit id="ipt_emplno" taborder="22" class="input_search" position="absolute 110 178 215 197" onkeydown="ipt_emplno_onkeydown" autoselect="true" autoskip="true"/>
- <Static id="caption8" text="교직원" class="cell_1" position="absolute 7 176 107 199"/>
- <Edit id="ipt_icpnnm" taborder="23" class="input_search" position="absolute 241 204 435 223" autoselect="true" autoskip="true" onkeydown="ipt_icpnnm_onkeydown"/>
- <Static id="caption9" text="개인" class="cell_1" position="absolute 7 202 107 225"/>
- <Edit id="ipt_icpnno" taborder="24" class="input_search" position="absolute 110 204 215 223" autoselect="true" autoskip="true" onkeydown="ipt_icpnno_onkeydown"/>
- <Shape id="line9" linetype="vertical" class="line_2" position="absolute 540 67 546 121"/>
- <Static id="caption10" text="계좌 불러오기" class="tit_2" position="absolute 0 129 183 150"/>
- <Grid id="grd_excelload" taborder="25" binddataset="ds_temp_excellist" useinputpanel="false" visible="false" position="absolute 245 389 890 479">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell text="계좌번호"/>
- <Cell col="1" text="은행코드"/>
- <Cell col="2" text="예금주"/>
- <Cell col="3" text="금액"/>
- <Cell col="4" text="입금명"/>
- <Cell col="5" text="비고"/>
- </Band>
- <Band id="body">
- <Cell text="bind:rcipntacntno"/>
- <Cell col="1" text="bind:bankcd"/>
- <Cell col="2" text="bind:depor"/>
- <Cell col="3" text="bind:amt"/>
- <Cell col="4" text="bind:deponm"/>
- <Cell col="5" text="bind:cmt"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="button1" taborder="27" text="엑셀양식" class="btn7" position="absolute 472 236 552 255" onclick="button1_onclick"/>
- <MaskEdit id="output6" taborder="28" readonly="true" mask="9,999999999" visible="false" position="absolute 528 483 653 502"/>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_hidden_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="instnm" type="STRING" size="256"/>
- <Column id="unsldd" type="STRING" size="256"/>
- <Column id="unslno" type="STRING" size="256"/>
- <Column id="cmt" type="STRING" size="256"/>
- <Column id="expsacntsum" type="STRING" size="256"/>
- <Column id="maxseqno" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="instnm"/>
- <Col id="unsldd"/>
- <Col id="unslno"/>
- <Col id="cmt"/>
- <Col id="expsacntsum"/>
- <Col id="maxseqno"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_valuelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_valuelist_oncolumnchanged">
- <ColumnInfo>
- <Column id="seq" type="STRING" size="256"/>
- <Column id="dummy1" type="STRING" size="256"/>
- <Column id="acntflagcd1" type="STRING" size="256"/>
- <Column id="acntflagnm1" type="STRING" size="256"/>
- <Column id="acntflagcd2" type="STRING" size="256"/>
- <Column id="acntflagnm2" type="STRING" size="256"/>
- <Column id="acntflagcd3" type="STRING" size="256"/>
- <Column id="acntflagnm3" type="STRING" size="256"/>
- <Column id="rcipntacntno" type="STRING" size="256"/>
- <Column id="bankcd" type="STRING" size="256"/>
- <Column id="banknm" type="STRING" size="256"/>
- <Column id="depor" type="STRING" size="256"/>
- <Column id="amt" type="INT" size="256"/>
- <Column id="deponm" type="STRING" size="256"/>
- <Column id="cmt" type="STRING" size="256"/>
- <Column id="dummy2" type="STRING" size="256"/>
- <Column id="dummy3" type="STRING" size="256"/>
- <Column id="dummy" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="seq"/>
- <Col id="dummy1"/>
- <Col id="acntflagcd1"/>
- <Col id="acntflagnm1"/>
- <Col id="acntflagcd2"/>
- <Col id="acntflagnm2"/>
- <Col id="acntflagcd3"/>
- <Col id="acntflagnm3"/>
- <Col id="rcipntacntno"/>
- <Col id="bankcd"/>
- <Col id="banknm"/>
- <Col id="depor"/>
- <Col id="amt"/>
- <Col id="deponm"/>
- <Col id="cmt"/>
- <Col id="dummy2"/>
- <Col id="dummy3"/>
- <Col id="dummy"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_transacnt" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_transacnt_oncolumnchanged">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
- <Column id="unsldd" type="STRING" size="256" sumtext="미결전표일자"/>
- <Column id="unslno" type="STRING" size="256" sumtext="미결전표번호"/>
- <Column id="seqno" type="STRING" size="256" sumtext="미결전표번호"/>
- <Column id="acntflag" type="STRING" size="256" sumtext="계좌구분"/>
- <Column id="acntflagcd" type="STRING" size="256" sumtext="계좌구분별코드"/>
- <Column id="acntflagnm" type="STRING" size="256" sumtext="계좌구분별코드명"/>
- <Column id="rcipntacntno" type="STRING" size="256" sumtext="수취인계좌번호"/>
- <Column id="bankcd" type="STRING" size="256" sumtext="은행코드"/>
- <Column id="banknm" type="STRING" size="256" sumtext="은행명"/>
- <Column id="depor" type="STRING" size="256" sumtext="예금주"/>
- <Column id="amt" type="STRING" size="256" sumtext="금액"/>
- <Column id="deponm" type="STRING" size="256" sumtext="입금명"/>
- <Column id="cmt" type="STRING" size="256" sumtext="비고"/>
- <Column id="dummy1" type="STRING" size="256" sumtext="여분1"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_temp_excellist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="amtSum" type="INT" size="256"/>
- <Column id="amtCount" type="INT" size="256"/>
- <Column id="slipkind" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="amtSum"/>
- <Col id="amtCount"/>
- <Col id="slipkind"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_R0001list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="cdnm" type="STRING" size="256"/>
- <Column id="cdid" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_target_slipinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_send_data3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_send_data1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- <Dataset id="ds_main_list_transacntinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="chk" type="STRING" size="256" sumtext="선택"/>
- <Column id="data1" type="STRING" size="256" sumtext="정보1"/>
- <Column id="acntflagcd" type="STRING" size="256" sumtext="계좌구분코드"/>
- <Column id="acntflagnm" type="STRING" size="256" sumtext="계좌구분명"/>
- <Column id="rcipntacntno" type="STRING" size="256" sumtext="이체계좌"/>
- <Column id="bankcd" type="STRING" size="256" sumtext="은행코드"/>
- <Column id="banknm" type="STRING" size="256" sumtext="은행명"/>
- <Column id="depor" type="STRING" size="256" sumtext="예금주"/>
- <Column id="deptnm" type="STRING" size="256" sumtext="예금주"/>
- <Column id="jobposnm" type="STRING" size="256" sumtext="직위"/>
- </ColumnInfo>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group4.output2" propid="value" datasetid="ds_hidden_condition" columnid="unsldd"/>
- <BindItem id="item1" compid="group4.output3" propid="value" datasetid="ds_hidden_condition" columnid="unslno"/>
- <BindItem id="item2" compid="group4.output5" propid="value" datasetid="ds_hidden_condition" columnid=""/>
- <BindItem id="item3" compid="group4.output1" propid="value" datasetid="ds_hidden_condition" columnid="instcd"/>
- <BindItem id="item4" compid="cmb_bankcd" propid="value" datasetid="ds_main_valuelist" columnid="bankcd"/>
- <BindItem id="item5" compid="ipt_rcipntacntno" propid="value" datasetid="ds_main_valuelist" columnid="rcipntacntno"/>
- <BindItem id="item6" compid="ipt_depor" propid="value" datasetid="ds_main_valuelist" columnid="depor"/>
- <BindItem id="item7" compid="ipt_amt" propid="value" datasetid="ds_main_valuelist" columnid="amt"/>
- <BindItem id="item8" compid="ipt_deponm" propid="value" datasetid="ds_main_valuelist" columnid="deponm"/>
- <BindItem id="item9" compid="ipt_cmt" propid="value" datasetid="ds_main_valuelist" columnid="cmt"/>
- <BindItem id="item10" compid="ipt_custcd" propid="value" datasetid="ds_main_valuelist" columnid="acntflagcd1"/>
- <BindItem id="item11" compid="ipt_custnm" propid="value" datasetid="ds_main_valuelist" columnid="acntflagnm1"/>
- <BindItem id="item12" compid="ipt_emplno" propid="value" datasetid="ds_main_valuelist" columnid="acntflagcd2"/>
- <BindItem id="item13" compid="ipt_emplnm" propid="value" datasetid="ds_main_valuelist" columnid="acntflagnm2"/>
- <BindItem id="item14" compid="ipt_icpnno" propid="value" datasetid="ds_main_valuelist" columnid="acntflagcd3"/>
- <BindItem id="item15" compid="ipt_icpnnm" propid="value" datasetid="ds_main_valuelist" columnid="acntflagnm3"/>
- <BindItem id="item16" compid="output6" propid="value" datasetid="ds_hidden" columnid="amtCount"/>
- <BindItem id="item17" compid="output4" propid="value" datasetid="ds_hidden" columnid="amtSum"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-06-19
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-06-19 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- include "mis_miscommonxp::MIS.xjs";
- var Click = "N";
- function SPRAD00108_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SPRAD00108_onload(obj:Form, e:LoadEventInfo)
- {
- grdf_initGrid(grd_transacnt);
- grdf_setRowTypeIcon(grd_transacnt, 3);
-
- try
- {
- ds_target_slipinfo.copyData(arg_ds_target_slipinfo);
- }
- catch(e)
- {
- }
-
- try
- {
- ds_target.copyData(arg_ds_target);
- }
- catch(e)
- {
- }
-
- fOpenForm();
-
- //misfMsterDetailSet(grd_transacnt, null, "TRRAD00108", "Y");
- fGettransacnt();
- ipt_rcipntacntno.setFocus();
- }
- function fOpenForm()
- {
- btn_grdset.visible = false;
-
- var instcd = ds_target_slipinfo.getColumn(0, "instcd");
- var instnm = ds_target_slipinfo.getColumn(0, "instnm");
- var unsldd = ds_target_slipinfo.getColumn(0, "unsldd");
- var unslno = ds_target_slipinfo.getColumn(0, "unslno");
- var expsacntsum = ds_target_slipinfo.getColumn(0, "expsacntsum");
- var cmt = ds_target_slipinfo.getColumn(0, "cmt");
- var acntdeptyn = ds_target_slipinfo.getColumn(0, "acntdeptyn");
- var slipkind = ds_target_slipinfo.getColumn(0, "slipkind");
- var sanctyn = ds_target_slipinfo.getColumn(0, "sanctyn");
-
- ds_hidden.setColumn(0, "slipkind", slipkind);
-
- if(instcd == "103")
- {
- instnm = "가톨릭대성의";
- }
-
- ds_main_transacnt.clearData();
- ds_temp_excellist.clearData();
-
- var arrParam = [ {dsNm: "ds_init_R0001list", cdGrpId: "R0001", showValue: true}]
- appf_getCodeList(arrParam);
- if(ds_target_slipinfo.rowcount != 0)
- {
- ds_hidden_condition.setColumn(0, "instcd", instcd);
- ds_hidden_condition.setColumn(0, "instnm", instnm);
- ds_hidden_condition.setColumn(0, "unsldd", unsldd);
- ds_hidden_condition.setColumn(0, "unslno", unslno);
- ds_hidden_condition.setColumn(0, "cmt", cmt);
- ds_hidden_condition.setColumn(0, "expsacntsum", expsacntsum);
-
- ds_main_valuelist.setColumn(0, "deponm", instnm);
- ds_main_valuelist.setColumn(0, "cmt", cmt);
- }
-
- if(sanctyn == "Y")
- {
- btn_save.enable = false;
- group4.btn_autoaactInstert.enable = false;
- }
-
- if(utlf_isNull(cmb_bankcd.value))
- {
- cmb_bankcd.value = 20;
- }
- }
- function fGettransacnt()
- {
- ds_main_transacnt.clearData();
-
- var oParam = {};
- oParam.id = "TRRAD00108";
- oParam.service = "slipapp.Slip";
- oParam.method = "reqGetTransAcnt";
- oParam.inds = "req=ds_hidden_condition";
- oParam.outds = "ds_main_transacnt=transacnt";
- oParam.async = false;
- //oParam.callback = "cf_TRRAD00108";
- tranf_submit(oParam);
-
- ds_main_transacnt.clearSelect();
-
- //misfSetReadOnlyCol(grd_transacnt, "acntflag,acntflagcd,rcipntacntno,bankcd,depor,amt,deponm,cmt",true);
- var columnid = "acntflag,acntflagcd,rcipntacntno,bankcd,depor,amt,deponm,cmt";
- columnid = columnid.split(",");
-
- for(var i = 0; i < columnid.length; i++)
- {
- grd_transacnt.setCellProperty("Body", grd_transacnt.getBindCellIndex("Body", columnid[i]), "edittype", "none");
- }
-
- btn_grdset.visible = false;
- recalculate();
-
- var expsacntsum = ds_target_slipinfo.getColumn(0, "expsacntsum");
-
- if(utlf_isNull(expsacntsum))
- {
- expsacntsum = 0;
- }
-
- ds_main_valuelist.setColumn(0, "amt", expsacntsum-ds_hidden.getColumn(0, "amtSum"));
- }
- function recalculate()
- {
- fGridSum();
- ds_hidden_condition.setColumn(0, "maxseqno", ds_main_transacnt.getMax("seqno"));
- }
- function fGridSum()
- {
- var iSum = 0;
- var iCount = 0;
-
- for(var i = 0; i < ds_main_transacnt.rowcount; i++)
- {
- if(ds_main_transacnt.getRowType(i) != 8 && !utlf_isNull(ds_main_transacnt.getColumn(i, "amt")))
- {
- iSum = iSum + parseInt(ds_main_transacnt.getColumn(i, "amt"));
- }
- if (ds_main_transacnt.getRowType(i) == 8)
- {
- iCount ++;
- }
- }
-
- ds_hidden.setColumn(0, "amtSum", iSum);
- ds_hidden.setColumn(0, "amtCount", iCount);
- }
- function group4_btn_autoaactInstert_onclick(obj:Button, e:ClickEventInfo)
- {
- if(ds_main_transacnt.rowcount != 0)
- {
- sysf_messageBox("전체 내역을 삭제 후 생성하세요","I000");
- return;
- }
- dsf_makeValue(ds_send_data3, "instcd", "string", ds_target_slipinfo.getColumn(0, "instcd"), 0);
- dsf_makeValue(ds_send_data3, "unsldd", "string", ds_target_slipinfo.getColumn(0, "unsldd"), 0);
- dsf_makeValue(ds_send_data3, "unslno", "string", ds_target_slipinfo.getColumn(0, "unslno"), 0);
-
- var oParam = {};
- oParam.id = "TXRAD00153";
- oParam.service = "slipapp.Slip";
- oParam.method = "reqAutoInsertAact";
- oParam.inds = "req=ds_send_data3";
- oParam.outds = "";
- oParam.async = false;
- //oParam.callback = "cf_TXRAD00153";
- tranf_submit(oParam);
- group4.btn_search.click();
- }
- function group4_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- fGettransacnt();
- }
- function cmb_bankcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
- {
- if(obj.value == "01")
- {
- ds_main_valuelist.setColumn(0, "rcipntacntno", "지로납부");
- ds_main_valuelist.setColumn(0, "depor", "지로납부");
- }
- else if(obj.value == "99")
- {
- ds_main_valuelist.setColumn(0, "rcipntacntno", "현금");
- ds_main_valuelist.setColumn(0, "depor", "현금");
- }
- }
- function ipt_rcipntacntno_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_depor.setFocus();
- }
- }
- function ipt_depor_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_amt.setFocus();
- }
- }
- function ipt_amt_onkeydown(obj:MaskEdit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_deponm.setFocus();
- }
- }
- function ipt_deponm_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_cmt.setFocus();
- }
- }
- function ipt_cmt_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- btn_grdadd.setFocus();
- }
- }
- function ds_main_valuelist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "acntflagcd1")
- {
- if(!utlf_isNull(e.newvalue) && Click == "N")
- {
- obj.setColumn(0, "acntflagcd2", "");
- obj.setColumn(0, "acntflagnm2", "");
- obj.setColumn(0, "acntflagcd3", "");
- obj.setColumn(0, "acntflagnm3", "");
-
- facountSearch("1", "code", e.newvalue, obj.getColumn(0, "acntflagnm1"), btn_custhelp)
- }
- }
-
- if(e.columnid == "acntflagnm1")
- {
- if(!utlf_isNull(e.newvalue) && Click == "N")
- {
- obj.setColumn(0, "acntflagcd2", "");
- obj.setColumn(0, "acntflagnm2", "");
- obj.setColumn(0, "acntflagcd3", "");
- obj.setColumn(0, "acntflagnm3", "");
-
- facountSearch("1", "name", obj.getColumn(0, "acntflagcd1"), e.newvalue, btn_custhelp)
- }
- }
-
- if(e.columnid == "acntflagcd2")
- {
- if(!utlf_isNull(e.newvalue) && Click == "N")
- {
- obj.setColumn(0, "acntflagcd1", "");
- obj.setColumn(0, "acntflagnm1", "");
- obj.setColumn(0, "acntflagcd3", "");
- obj.setColumn(0, "acntflagnm3", "");
-
- facountSearch("4", "code", e.newvalue, obj.getColumn(0, "acntflagnm2"), btn_emplhelp)
- }
- }
-
- if(e.columnid == "acntflagnm2")
- {
- if(!utlf_isNull(e.newvalue) && Click == "N")
- {
- obj.setColumn(0, "acntflagcd1", "");
- obj.setColumn(0, "acntflagnm1", "");
- obj.setColumn(0, "acntflagcd3", "");
- obj.setColumn(0, "acntflagnm3", "");
-
- facountSearch("4", "name", obj.getColumn(0, "acntflagcd2"), e.newvalue, btn_emplhelp);
- }
- }
-
- if(e.columnid == "acntflagcd3")
- {
- if(!utlf_isNull(e.newvalue) && Click == "N")
- {
- obj.setColumn(0, "acntflagcd1", "");
- obj.setColumn(0, "acntflagnm1", "");
- obj.setColumn(0, "acntflagcd2", "");
- obj.setColumn(0, "acntflagnm2", "");
-
- facountSearch("5", "code", e.newvalue, obj.getColumn(0, "acntflagnm3"), btn_icpnhelp);
- }
- }
-
- if(e.columnid == "acntflagnm3")
- {
- if(!utlf_isNull(e.newvalue) && Click == "N")
- {
- obj.setColumn(0, "acntflagcd1", "");
- obj.setColumn(0, "acntflagnm1", "");
- obj.setColumn(0, "acntflagcd2", "");
- obj.setColumn(0, "acntflagnm2", "");
-
- facountSearch("5", "name", obj.getColumn(0, "acntflagcd3"), e.newvalue, btn_icpnhelp);
- }
- }
- }
- function facountSearch(acntflag, getcond, cdid, cdnm, btn_id)
- {
- dsf_makeValue(ds_send_data1, "instcd", "string", sysf_getUserInfo("dutplceinstcd"), 0);
- dsf_makeValue(ds_send_data1, "acntflagcd", "string", cdid, 0);
- dsf_makeValue(ds_send_data1, "acntflagnm", "string", cdnm, 0);
- dsf_makeValue(ds_send_data1, "acntflag", "string", acntflag, 0);
- dsf_makeValue(ds_send_data1, "getcond", "string", getcond, 0);
-
- var oParam = {};
- oParam.id = "TRRAD00110";
- oParam.service = "slipapp.Slip";
- oParam.method = "reqGetTransAcntInfo";
- oParam.inds = "req=ds_send_data1";
- oParam.outds = "ds_main_list_transacntinfo=transacntinfo";
- oParam.async = false;
- //oParam.callback = "cf_TRRAD00110";
- tranf_submit(oParam);
-
- if(ds_main_list_transacntinfo.rowcount == 1)
- {
- if(acntflag == "1")
- {
- i = "1";
- }
- else if(acntflag == "4")
- {
- i = "2";
- }
- else if(acntflag == "5")
- {
- i = "3";
- }
-
- ds_main_valuelist.setColumn(0, "acntflagcd"+i, ds_main_list_transacntinfo.getColumn(0, "acntflagcd"));
- ds_main_valuelist.setColumn(0, "acntflagnm"+i, ds_main_list_transacntinfo.getColumn(0, "acntflagnm"));
- ds_main_valuelist.setColumn(0, "bankcd", ds_main_list_transacntinfo.getColumn(0, "bankcd"));
- ds_main_valuelist.setColumn(0, "rcipntacntno", ds_main_list_transacntinfo.getColumn(0, "rcipntacntno"));
- ds_main_valuelist.setColumn(0, "depor", ds_main_list_transacntinfo.getColumn(0, "depor"));
- }
- else
- {
- btn_id.click();
- }
- }
- function ipt_emplno_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_name.setFocus();
- }
- }
- function ipt_custcd_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_name.setFocus();
- }
- }
-
- function btn_custhelp_onclick(obj:Button, e:ClickEventInfo)
- {
- var instcd = ds_hidden_condition.getColumn(0, "instcd");
- var pVal = instcd + "," + 1 + "," + ipt_custcd.value + "," + ipt_custnm.value;
- misfOpenPopUpList("24", ds_main_valuelist, "", "dummy,dummy1,acntflagcd1,acntflagnm1,dummy2,dummy3,bankcd,banknm,rcipntacntno,depor", pVal, "instcd,acntflag,acntflagcd,acntflagnm");
-
- ds_main_valuelist.setColumn(0, "acntflagcd2", "");
- ds_main_valuelist.setColumn(0, "acntflagnm2", "");
- ds_main_valuelist.setColumn(0, "acntflagcd3", "");
- ds_main_valuelist.setColumn(0, "acntflagnm3", "");
- ipt_rcipntacntno.setFocus();
- }
- function ipt_custnm_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_rcipntacntno.setFocus();
- }
- }
- function btn_emplhelp_onclick(obj:Button, e:ClickEventInfo)
- {
- var instcd = ds_hidden_condition.getColumn(0, "instcd");
- var pVal = instcd + "," + 4 + "," + ipt_emplno.value + "," + ipt_emplnm.value;
- misfOpenPopUpList("24", ds_main_valuelist, "", "dummy,dummy1,acntflagcd2,acntflagnm2,dummy2,dummy3,bankcd,banknm,rcipntacntno,depor", pVal, "instcd,acntflag,acntflagcd,acntflagnm");
-
- ds_main_valuelist.setColumn(0, "acntflagcd1", "");
- ds_main_valuelist.setColumn(0, "acntflagnm1", "");
- ds_main_valuelist.setColumn(0, "acntflagcd3", "");
- ds_main_valuelist.setColumn(0, "acntflagnm3", "");
- ipt_rcipntacntno.setFocus();
- }
- function ipt_emplnm_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_rcipntacntno.setFocus();
- }
- }
- function ipt_icpnno_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_name.setFocus();
- }
- }
- function ipt_icpnnm_onkeydown(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- ipt_rcipntacntno.setFocus();
- }
- }
- function btn_icpnhelp_onclick(obj:Button, e:ClickEventInfo)
- {
- var instcd = ds_hidden_condition.getColumn(0, "instcd");
- var pVal = instcd + "," + 5 + "," + ipt_icpnno.value + "," + ipt_icpnnm.value;
- misfOpenPopUpList("24", ds_main_valuelist, "", "dummy,dummy1,acntflagcd3,acntflagnm3,dummy2,dummy3,bankcd,banknm,rcipntacntno,depor", pVal, "instcd,acntflag,acntflagcd,acntflagnm");
- ds_main_valuelist.setColumn(0, "acntflagcd1", "");
- ds_main_valuelist.setColumn(0, "acntflagnm1", "");
- ds_main_valuelist.setColumn(0, "acntflagcd2", "");
- ds_main_valuelist.setColumn(0, "acntflagnm2", "");
- ipt_rcipntacntno.setFocus();
- }
- function ds_main_transacnt_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- var cur_col = e.col;
- var cur_row = e.row;
- var row_cnt = obj.rowcount;
- var instcd = ds_hidden_condition.getColumn(0, "instcd");
- var acntflag = obj.getColumn(cur_row, "acntflag");
- var acntflagcd = obj.getColumn(cur_row, "acntflagcd");
- var acntflagnm = obj.getColumn(cur_row, "acntflagnm");
- var pVal;
-
- if(e.columnid == "acntflag")
- {
- if (utlf_isNull(e.newvalue))
- {
- sysf_messageBox("계좌구분을 선택하세요.","I000");
-
- grd_transacnt.setCellPos(grd_transacnt.getBindCellIndex("body", "acntflag"));
- grd_transacnt.showEditor(true);
- return;
- }
- }
-
- if (cur_col == 8 && acntflag != "9")
- {
- pVal = instcd + "," + acntflag + "," + acntflagcd + "," + acntflagnm;
-
- grd_transacnt.setFocus();
- misfValidationCheck("24", "", "dummy1,acntflagcd,acntflagnm,rcipntacntno,bankcd,banknm,depor", pVal, "instcd,acntflag,acntflagcd,acntflagnm");
-
- if (row_cnt < obj.rowcount)
- {
- fSetDefaulValue();
- }
- }
- }
- function fSetDefaulValue()
- {
- var acntflag = ds_main_transacnt.getColumn(0, "acntflag");
-
- for(var i = 0; i < ds_main_transacnt.rowcount; i++)
- {
- if(ds_main_transacnt.getRowType(i) == 2)
- {
- ds_main_transacnt.setColumn(i, "instcd", ds_hidden_condition.getColumn(0, "instcd"));
- ds_main_transacnt.setColumn(i, "unsldd", ds_hidden_condition.getColumn(0, "unsldd"));
- ds_main_transacnt.setColumn(i, "unslno", ds_hidden_condition.getColumn(0, "unslno"));
- ds_main_transacnt.setColumn(i, "acntflag", acntflag);
- }
- }
- }
- function grd_transacnt_oncellclick(obj:Grid, e:GridClickEventInfo)
- {
- btn_grdset.visible = true;
- btn_grdadd.visible = false;
-
- Click = "Y";
- if(ds_main_transacnt.rowposition > -1)
- {
- ds_main_valuelist.setColumn(0, "acntflagcd1", "");
- ds_main_valuelist.setColumn(0, "acntflagnm1", "");
- ds_main_valuelist.setColumn(0, "acntflagcd2", "");
- ds_main_valuelist.setColumn(0, "acntflagnm2", "");
- ds_main_valuelist.setColumn(0, "acntflagcd3", "");
- ds_main_valuelist.setColumn(0, "acntflagnm3", "");
-
- if(ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflag") == "1")
- {
- ds_main_valuelist.setColumn(0, "acntflagcd1", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflagcd"));
- ds_main_valuelist.setColumn(0, "acntflagnm1", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflagnm"));
- }
- else if(ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflag") == "4")
- {
- ds_main_valuelist.setColumn(0, "acntflagcd2", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflagcd"));
- ds_main_valuelist.setColumn(0, "acntflagnm2", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflagnm"));
- }
- else if(ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflag") == "5")
- {
- ds_main_valuelist.setColumn(0, "acntflagcd3", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflagcd"));
- ds_main_valuelist.setColumn(0, "acntflagnm3", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "acntflagnm"));
- }
- ds_main_valuelist.setColumn(0, "rcipntacntno", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "rcipntacntno"));
- ds_main_valuelist.setColumn(0, "bankcd", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "bankcd"));
- ds_main_valuelist.setColumn(0, "banknm", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "banknm"));
- ds_main_valuelist.setColumn(0, "depor", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "depor"));
- ds_main_valuelist.setColumn(0, "amt", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "amt"));
- ds_main_valuelist.setColumn(0, "deponm", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "deponm"));
- ds_main_valuelist.setColumn(0, "cmt", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "cmt"));
- ds_main_valuelist.setColumn(0, "seq", ds_main_transacnt.getColumn(ds_main_transacnt.rowposition, "seqno"));
- }
-
- Click = "N";
- }
- function button1_onclick(obj:Button, e:ClickEventInfo)
- {
- grdf_exportExcel(grd_excelload, "excel", "see", false);
- }
- function fCheckStatus()
- {
- var grd_rows = ds_main_transacnt.rowcount;
- for(var i = 0; i < grd_rows ; i++)
- {
- if(ds_main_transacnt.getRowType(i) != 1)
- {
- sysf_messageBox("진행중인 작업 완료/취소 후 실행하십시요" ,"");
- return false;
- }
- }
- return true;
- }
- function btn_excadd_onclick(obj:Button, e:ClickEventInfo)
- {
- if(fCheckStatus() == false)
- {
- return;
- }
-
- grdf_ImportExcel("ds_temp_excellist", 2, grd_excelload)
- var rowlevel = 0;
- var bankcd = "";
-
- var grd_excelload_rows = ds_temp_excellist.rowcount;
- for(var i = 0; i < grd_excelload_rows ; i++)
- {
- var valflag = true;
- bankcd = "";
-
- if(utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "deponm")))
- {
- if(utlf_isNull(ipt_deponm.value))
- {
- sysf_messageBox("입금명이" ,"I004");
- return;
-
- valflag = false;
- }
- ds_temp_excellist.setColumn(rowlevel, "deponm", ipt_deponm.value);
- }
-
- if(utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "cmt")))
- {
- ds_temp_excellist.setColumn(rowlevel, "cmt", ipt_cmt.value);
- }
-
- if(utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "rcipntacntno")))
- {
- sysf_messageBox("계좌번호 정보가" ,"I004");
- return;
-
- valflag = false;
- }
-
- if(utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "bankcd")))
- {
- sysf_messageBox("은행코드 정보가" ,"I004");
- return;
-
- valflag = false;
- }
- else if(!utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "bankcd")))
- {
- bankcd = ds_temp_excellist.getColumn(i, "bankcd");
- bankcd = radfGetBankcd(bankcd);
- if(!utlf_isNull(bankcd))
- {
- ds_temp_excellist.setColumn(i, "bankcd", bankcd);
- }
- }
-
- if(utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "depor")))
- {
- sysf_messageBox("예금주 정보가" ,"I004");
- return;
-
- valflag = false;
- }
-
- if(utlf_isNull(ds_temp_excellist.getColumn(rowlevel, "amt")))
- {
- sysf_messageBox("금액이" ,"I004");
- return;
-
- valflag = false;
- }
-
- if(valflag == false)
- {
- ds_temp_excellist.deleteRow(rowlevel);
- }
- else
- {
- rowlevel += 1;
- }
-
- }
- var bankvalidflag = false;
- for(var i = 0 ; i < ds_temp_excellist.rowcount; i++)
- {
- var LastRow = ds_main_transacnt.addRow();
- fMakeSeqNo(LastRow);
-
- ds_main_transacnt.setColumn(LastRow, "instcd", ds_hidden_condition.getColumn(0, "instcd"));
- ds_main_transacnt.setColumn(LastRow, "unsldd", ds_hidden_condition.getColumn(0, "unsldd"));
- ds_main_transacnt.setColumn(LastRow, "unslno", ds_hidden_condition.getColumn(0, "unslno"));
-
- ds_main_transacnt.setColumn(LastRow, "rcipntacntno", ds_temp_excellist.getColumn(i, "rcipntacntno"));
- ds_main_transacnt.setColumn(LastRow, "bankcd", ds_temp_excellist.getColumn(i, "bankcd"));
- ds_main_transacnt.setColumn(LastRow, "depor", ds_temp_excellist.getColumn(i, "depor"));
- ds_main_transacnt.setColumn(LastRow, "amt", ds_temp_excellist.getColumn(i, "amt"));
- ds_main_transacnt.setColumn(LastRow, "deponm", ds_temp_excellist.getColumn(i, "deponm"));
- ds_main_transacnt.setColumn(LastRow, "cmt", ds_temp_excellist.getColumn(i, "cmt"));
- }
-
- ds_temp_excellist.clearData();
- }
- function fMakeSeqNo(iRowIdx)
- {
- var sSeqno = "";
- var iSeqNo = 0;
-
- if(utlf_isNull(ds_hidden_condition.getColumn(0, "maxseqno")))
- {
- sSeqno = "000";
- }
- else
- {
- sSeqno = ds_hidden_condition.getColumn(0, "maxseqno");
- }
- var iSeqno = parseFloat(sSeqno);
- if(iSeqno >= 0)
- {
- iSeqno ++ ;
- sSeqno = (iSeqno).toString().getLeftPad(3, "0");
- }
- else
- {
- sSeqno = "001";
- }
-
- ds_main_transacnt.setColumn(iRowIdx, "seqno", sSeqno);
- recalculate();
- }
- function btn_reset_onclick(obj:Button, e:ClickEventInfo)
- {
- btn_grdset.visible = false;
- btn_grdadd.visible = true;
- fResetControls();
- }
- function fResetControls()
- {
- ds_main_valuelist.setColumn(0, "dummy1", "");
- ds_main_valuelist.setColumn(0, "acntflagcd1", "");
- ds_main_valuelist.setColumn(0, "acntflagnm1", "");
- ds_main_valuelist.setColumn(0, "acntflagcd2", "");
- ds_main_valuelist.setColumn(0, "acntflagnm2", "");
- ds_main_valuelist.setColumn(0, "acntflagcd3", "");
- ds_main_valuelist.setColumn(0, "acntflagnm3", "");
- ds_main_valuelist.setColumn(0, "rcipntacntno", "");
- ds_main_valuelist.setColumn(0, "bankcd", "");
- ds_main_valuelist.setColumn(0, "banknm", "");
- ds_main_valuelist.setColumn(0, "depor", "");
- ds_main_valuelist.setColumn(0, "amt", "");
- ds_main_valuelist.setColumn(0, "deponm", ds_hidden_condition.getColumn(0, "instnm"));
- ds_main_valuelist.setColumn(0, "cmt", ds_hidden_condition.getColumn(0, "cmt"));
- ds_main_valuelist.setColumn(0, "seq", "");
- var expsacntsum = ds_target_slipinfo.getColumn(0, "expsacntsum");
-
- ds_main_valuelist.setColumn(0, "amt", parseInt(expsacntsum) - ds_hidden.getColumn(0, "amtSum"));
- }
- function btn_grdadd_onclick(obj:Button, e:ClickEventInfo)
- {
- if(utlf_isNull(ds_main_valuelist.getColumn(0, "bankcd")))
- {
- sysf_messageBox("은행명은", "I003");
- cmb_bankcd.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "rcipntacntno")))
- {
- sysf_messageBox("계좌번호는", "I003");
- ipt_rcipntacntno.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "depor")))
- {
- sysf_messageBox("예금주는", "I003");
- ipt_depor.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "amt")) || ds_main_valuelist.getColumn(0, "amt") == 0)
- {
- trace(ds_main_valuelist.getColumn(0, "amt"))
- sysf_messageBox("금액은", "I003");
- ipt_amt.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "deponm")))
- {
- sysf_messageBox("입금자명은", "I003");
- ipt_deponm.setFocus();
- }
- else
- {
- var addRow = ds_main_transacnt.addRow();
-
- var columnid = "rcipntacntno,bankcd,depor,amt,deponm,cmt";
- columnid = columnid.split(",");
-
- for(var i = 0; i < columnid.length; i++)
- {
- grd_transacnt.setCellProperty("Body", grd_transacnt.getBindCellIndex("Body", columnid[i]), "edittype", "none");
- }
-
- grd_transacnt.setCellPos(grd_transacnt.getBindCellIndex("body", "acntflagnm"));
- grd_transacnt.showEditor(true);
-
- if(utlf_isNull(ds_main_transacnt.getColumn(addRow, "seqno")))
- {
- fMakeSeqNo(addRow);
- fRefresh();
- }
- if(!utlf_isNull(ds_main_valuelist.getColumn(0, "acntflagcd1")))
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "1");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", ds_main_valuelist.getColumn(0, "acntflagcd1"));
- ds_main_transacnt.setColumn(addRow, "acntflagnm", ds_main_valuelist.getColumn(0, "acntflagnm1"));
- }
- else if(!utlf_isNull(ds_main_valuelist.getColumn(0, "acntflagcd2")))
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "4");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", ds_main_valuelist.getColumn(0, "acntflagcd2"));
- ds_main_transacnt.setColumn(addRow, "acntflagnm", ds_main_valuelist.getColumn(0, "acntflagnm2"));
- }
- else if(!utlf_isNull(ds_main_valuelist.getColumn(0, "acntflagcd3")))
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "5");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", ds_main_valuelist.getColumn(0, "acntflagcd3"));
- ds_main_transacnt.setColumn(addRow, "acntflagnm", ds_main_valuelist.getColumn(0, "acntflagnm3"));
- }
- else
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "9");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", "-");
- ds_main_transacnt.setColumn(addRow, "acntflagnm", "-");
- }
- ds_main_transacnt.setColumn(addRow, "rcipntacntno", ds_main_valuelist.getColumn(0, "rcipntacntno"));
- ds_main_transacnt.setColumn(addRow, "bankcd", ds_main_valuelist.getColumn(0, "bankcd"));
- ds_main_transacnt.setColumn(addRow, "banknm", ds_main_valuelist.getColumn(0, "banknm"));
- ds_main_transacnt.setColumn(addRow, "depor", ds_main_valuelist.getColumn(0, "depor"));
- ds_main_transacnt.setColumn(addRow, "amt", ds_main_valuelist.getColumn(0, "amt"));
- ds_main_transacnt.setColumn(addRow, "deponm", ds_main_valuelist.getColumn(0, "deponm"));
- ds_main_transacnt.setColumn(addRow, "cmt", ds_main_valuelist.getColumn(0, "cmt"));
- dsf_makeValue(ds_main_transacnt, "instcd", "string", ds_hidden_condition.getColumn(0, "instcd"), addRow);
- dsf_makeValue(ds_main_transacnt, "unsldd", "string", ds_hidden_condition.getColumn(0, "unsldd"), addRow);
- dsf_makeValue(ds_main_transacnt, "unslno", "string", ds_hidden_condition.getColumn(0, "unslno"), addRow);
- fResetControls();
- }
- btn_save.setFocus();
- }
- function fRefresh()
- {
- recalculate();
- }
- function btn_grdset_onclick(obj:Button, e:ClickEventInfo)
- {
- if(utlf_isNull(ds_main_valuelist.getColumn(0, "bankcd")))
- {
- sysf_messageBox("은행명은", "I003");
- cmb_bankcd.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "rcipntacntno")))
- {
- sysf_messageBox("계좌번호는", "I003");
- ipt_rcipntacntno.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "depor")))
- {
- sysf_messageBox("예금주는", "I003");
- ipt_depor.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "amt")) || ds_main_valuelist.getColumn(0, "amt") == 0)
- {
- sysf_messageBox("금액은", "I003");
- ipt_amt.setFocus();
- }
- else if(utlf_isNull(ds_main_valuelist.getColumn(0, "deponm")))
- {
- sysf_messageBox("입금자명은", "I003");
- ipt_deponm.setFocus();
- }
- else
- {
- var sSeq = ds_main_valuelist.getColumn(0, "seq");
- var iRowIdx = ds_main_transacnt.findRow("seqno", sSeq);
- if(iRowIdx != -1)
- {
- ds_main_transacnt.clearSelect();
- ds_main_transacnt.selectRow(iRowIdx);
- ds_main_transacnt.rowposition = iRowIdx;
-
- ds_main_transacnt.updatecontrol = false;
- ds_main_transacnt.setRowType(iRowIdx);
- ds_main_transacnt.updatecontrol = true;
- }
- else
- {
- btn_grdset.visible = false;
- btn_grdadd.visible = true;
- }
-
- var columnid = "rcipntacntno,bankcd,depor,amt,deponm,cmt";
- columnid = columnid.split(",");
-
- for(var i = 0; i < columnid.length; i++)
- {
- grd_transacnt.setCellProperty("Body", grd_transacnt.getBindCellIndex("Body", columnid[i]), "edittype", "none");
- }
-
- grd_transacnt.setCellPos(grd_transacnt.getBindCellIndex("body", "acntflagnm"));
- grd_transacnt.showEditor(true);
-
- if(utlf_isNull(ds_main_transacnt.getColumn(addRow, "seqno")))
- {
- fMakeSeqNo(addRow);
- fRefresh();
- }
- if(!utlf_isNull(ds_main_valuelist.getColumn(0, "acntflagcd1")))
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "1");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", ds_main_valuelist.getColumn(0, "acntflagcd1"));
- ds_main_transacnt.setColumn(addRow, "acntflagnm", ds_main_valuelist.getColumn(0, "acntflagnm1"));
- }
- else if(!utlf_isNull(ds_main_valuelist.getColumn(0, "acntflagcd2")))
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "4");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", ds_main_valuelist.getColumn(0, "acntflagcd2"));
- ds_main_transacnt.setColumn(addRow, "acntflagnm", ds_main_valuelist.getColumn(0, "acntflagnm2"));
- }
- else if(!utlf_isNull(ds_main_valuelist.getColumn(0, "acntflagcd3")))
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "5");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", ds_main_valuelist.getColumn(0, "acntflagcd3"));
- ds_main_transacnt.setColumn(addRow, "acntflagnm", ds_main_valuelist.getColumn(0, "acntflagnm3"));
- }
- else
- {
- ds_main_transacnt.setColumn(addRow, "acntflag", "9");
- ds_main_transacnt.setColumn(addRow, "acntflagcd", "-");
- ds_main_transacnt.setColumn(addRow, "acntflagnm", "-");
- }
- ds_main_transacnt.setColumn(addRow, "rcipntacntno", ds_main_valuelist.getColumn(0, "rcipntacntno"));
- ds_main_transacnt.setColumn(addRow, "bankcd", ds_main_valuelist.getColumn(0, "bankcd"));
- ds_main_transacnt.setColumn(addRow, "banknm", ds_main_valuelist.getColumn(0, "banknm"));
- ds_main_transacnt.setColumn(addRow, "depor", ds_main_valuelist.getColumn(0, "depor"));
- ds_main_transacnt.setColumn(addRow, "amt", ds_main_valuelist.getColumn(0, "amt"));
- ds_main_transacnt.setColumn(addRow, "deponm", ds_main_valuelist.getColumn(0, "deponm"));
- ds_main_transacnt.setColumn(addRow, "cmt", ds_main_valuelist.getColumn(0, "cmt"));
- grd_transacnt.setFocus();
-
- fResetControls();
- }
- }
- function btn_grddel_onclick(obj:Button, e:ClickEventInfo)
- {
- if(ds_main_transacnt.getRowType(ds_main_transacnt.rowposition) == 2)
- {
- ds_main_transacnt.deleteRow(ds_main_transacnt.rowposition);
- }
- else
- {
- ds_main_transacnt.updatecontrol = false;
- ds_main_transacnt.setRowType(ds_main_transacnt.rowposition, "d");
- ds_main_transacnt.updatecontrol = true;
- }
-
- recalculate();
- }
- function btn_setaact_onclick(obj:Button, e:ClickEventInfo)
- {
- if(fCheckStatus() == false)
- {
- return;
- }
-
- var addRow = ds_main_transacnt.addRow();
-
- misfOpenPopUpList("44", ds_main_transacnt, "", "dummy1,acntflag,acntflagcd,acntflagnm,rcipntacntno,bankcd,banknm,depor,amt,deponm,cmt", ds_target_slipinfo.getColumn(0, "instcd"), "instcd");
- for(var i = 0; i < ds_main_transacnt.rowcount; i++)
- {
- if(utlf_isNull(ds_main_transacnt.getColumn(i, "seqno")))
- {
- fMakeSeqNo(i);
- fRefresh();
- ds_main_transacnt.setColumn(i, "instcd", ds_hidden_condition.getColumn(0, "instcd"));
- ds_main_transacnt.setColumn(i, "unsldd", ds_hidden_condition.getColumn(0, "unsldd"));
- ds_main_transacnt.setColumn(i, "unslno", ds_hidden_condition.getColumn(0, "unslno"));
- }
- }
-
- if(utlf_isNull(ds_main_transacnt.getColumn(addRow, "rcipntacntno")))
- {
- ds_main_transacnt.deleteRow(addRow);
- }
- }
- function btn_save_onclick(obj:Button, e:ClickEventInfo)
- {
- var updtdata = grdf_getGridUpdateData(grd_transacnt).rowcount;
- if (updtdata == 0)
- {
- sysf_messageBox("변경된 데이터가","I004");
- return;
- }
- for(var i = 0; i < ds_main_transacnt.rowcount; i++)
- {
- if(utlf_isNull(ds_main_transacnt.getColumn(i, "bankcd")))
- {
- sysf_messageBox("은행을", "C002");
- return;
- }
- if(utlf_isNull(ds_main_transacnt.getColumn(i, "depor")))
- {
- sysf_messageBox("예금주를", "C001");
- return;
- }
- if(utlf_isNull(ds_main_transacnt.getColumn(i, "amt")))
- {
- sysf_messageBox("금액을", "C001");
- return;
- }
- }
- recalculate();
-
- var oParam = {};
- oParam.id = "TXRAD00108";
- oParam.service = "slipapp.Slip";
- oParam.method = "reqExeTransAcnt";
- oParam.inds = "req=ds_main_transacnt:u";
- oParam.outds = "";
- oParam.async = false;
- //oParam.callback = "cf_TXRAD00108";
- tranf_submit(oParam);
- fGettransacnt();
- }
- function btn_cancel_onclick(obj:Button, e:ClickEventInfo)
- {
- if(fCheckStatus() == false)
- {
- return;
- }
-
- var receiveref = eval("opener."+ds_target.getColumn(0, "receiveref2"));
-
- if (frmf_checkOpener())
- {
- var iExpsAcntSum = parseFloat(ds_hidden_condition.getColumn(0, "expsacntsum"));
-
- var iSumAmt = 0;
-
- for(var i = 0 ; i < ds_main_transacnt.rowcount; i++)
- {
- if(ds_main_transacnt.getRowType(i) == 1)
- {
- var iAmt = (ds_main_transacnt.getColumn(i, "amt") == 0) ? 0 : parseFloat(ds_main_transacnt.getColumn(i, "amt"));
-
- iSumAmt += iAmt;
- }
-
- var vRcipntacntno = ds_main_transacnt.getColumn(i, "rcipntacntno");
-
- if(utlf_isNull(vRcipntacntno)|| vRcipntacntno == "-")
- {
- sysf_messageBox("seq [" + utlf_transEmptyToNull(ds_main_transacnt.getColumn(i, "seqno")) + "] 의 계좌번호를 입력해주세요", "I000");
- return;
- }
- }
- receiveref.setColumn(0, "maxslipseqno", iSumAmt);
- }
- else
- {
- sysf_messageBox("상위화면이 변경되어 데이터를 전달할 수 ", "I004");
- }
- this.close();
- }
- ]]></Script>
- </Form>
- </FDL>
|