123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080 |
- <?xml version="1.0" encoding="utf-8" standalone="no"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SPPIE04210" position="absolute 0 0 1198 774" titletext="재료수가변경내역조회" onload="SPPIE04210_onload">
- <Layouts>
- <Layout>
- <Tab id="switch1" position="absolute 600 41 1195 771" style="border:0 solid ;" anchor="all" tabposition="top">
- <Tabpages>
- <Tabpage id="cont" selected="true" position="absolute 0 0 10000 10000" style="" anchor="default">
- <Layouts>
- <Layout width="595" height="698">
- <Shape id="line1" class="line_10" linetype="horizontal" position="absolute 0 32 595 35" style="" anchor="left top right"/>
- <Grid id="grd_cont" binddataset="ds_main_cont" position="absolute 0 36 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_cont_grd_cont_onaftersort" anchor="all" cellsizingtype="col" cellmovingtype="col">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="200"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="80"/>
- <Column size="60"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="100"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- </Columns>
- <Rows>
- <Row size="23" band="head"/>
- <Row size="23"/>
- </Rows>
- <Band id="head">
- <Cell text="기관코드"/>
- <Cell col="1" text="물품구분"/>
- <Cell col="2" text="물품코드"/>
- <Cell col="3" text="EDI코드"/>
- <Cell col="4" text="물품명"/>
- <Cell col="5" text="계약순번"/>
- <Cell col="6" text="계약량"/>
- <Cell col="7" colspan="2" text="적용일자" taborder="undefined"/>
- <Cell col="9" text="계약단가"/>
- <Cell col="10" text="구분"/>
- <Cell col="11" colspan="2" text="단가계약기간" taborder="undefined"/>
- <Cell col="13" text="검수여부"/>
- <Cell col="14" text="최초작성자"/>
- <Cell col="15" text="최초작성일시"/>
- <Cell col="16" text="최종수정자"/>
- <Cell col="17" text="최종수정일시"/>
- <Cell col="18" text="최종수정일"/>
- <Cell col="19" displaytype="none"/>
- <Cell col="20" displaytype="none"/>
- <Cell col="21" displaytype="none"/>
- <Cell col="22" displaytype="none"/>
- <Cell col="23" displaytype="none"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" text="bind:goodflag"/>
- <Cell col="2" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:goodcd"/>
- <Cell col="3" style="background:bind:bgcontedicd;background2:bind:bgcontedicd;selectbackground:bind:bgcontedicd;" text="bind:edicd"/>
- <Cell col="4" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:goodnm"/>
- <Cell col="5" style="background:#ffffffff;background2:#ffffffff;" text="bind:purcconseq"/>
- <Cell col="6" style="background:#ffffffff;background2:#ffffffff;" text="bind:conqty"/>
- <Cell col="7" displaytype="date" text="bind:fromdd"/>
- <Cell col="8" displaytype="date" text="bind:todd"/>
- <Cell col="9" displaytype="number" style="background:bind:bgcontamt;background2:bind:bgcontamt;font:arial,9,bold;selectbackground:bind:bgcontamt;" text="bind:congoodunitcost"/>
- <Cell col="10" style="align:center middle;" text="bind:gubun"/>
- <Cell col="11" displaytype="date" text="bind:fromconterm"/>
- <Cell col="12" displaytype="date" text="bind:toconterm"/>
- <Cell col="13" style="background:#ffffffff;background2:#ffffffff;" text="bind:chkyn"/>
- <Cell col="14" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstrid"/>
- <Cell col="15" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstdt"/>
- <Cell col="16" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtrid"/>
- <Cell col="17" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtdt"/>
- <Cell col="18" displaytype="date" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtdt"/>
- <Cell col="19" displaytype="text" text="bind:bginsuamt"/>
- <Cell col="20" displaytype="text" text="bind:bgautmamt"/>
- <Cell col="21" displaytype="text" text="bind:bgcontamt"/>
- <Cell col="22" displaytype="text" text="bind:bgedicd"/>
- <Cell col="23" displaytype="text" text="bind:bgcontedicd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Static id="caption7" class="tit_2" position="absolute 0 13 105 34" style="" text="계약 내역"/>
- <Button id="Button00" taborder="1" text="엑셀저장" position="absolute 518 10 595 30" class="btn7" onclick="switch1_cont_Button00_onclick" anchor="top right"/>
- <Static id="Static02" position="absolute 87 13 102 28" anchor="left top" style="background:#9fc93cff;border:1 solid #808080ff ;"/>
- <Static id="Static01" position="absolute 216 13 231 28" anchor="left top" style="background:#ffc4ebff;border:1 solid #808080ff ;"/>
- <Static id="Static00" text="EDI코드상이" position="absolute 109 11 209 31"/>
- <Static id="Static03" text="단가상이" position="absolute 238 10 338 30"/>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="wchk" anchor="default">
- <Layouts>
- <Layout>
- <Grid id="grd_wchk" binddataset="ds_main_wchk" position="absolute 0 23 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_wchk_grd_wchk_onaftersort" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="60"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="60"/>
- <Column size="60"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- </Columns>
- <Rows>
- <Row size="23" band="head"/>
- <Row size="23"/>
- </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="검수순번"/>
- <Cell col="6" text="계약일자"/>
- <Cell col="7" text="계약번호"/>
- <Cell col="8" text="검수수량"/>
- <Cell col="9" text="검수단가"/>
- <Cell col="10" text="검수금액"/>
- <Cell col="11" text="계정과목"/>
- <Cell col="12" text="출고부서"/>
- <Cell col="13" text="최초작성자"/>
- <Cell col="14" text="최초작성일시"/>
- <Cell col="15" text="최종수정자"/>
- <Cell col="16" text="최종수정일시"/>
- <Cell col="17" text="최종수정일"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" text="bind:goodflag"/>
- <Cell col="2" style="align:left;background:white;background2:white;" text="bind:goodcd"/>
- <Cell col="3" displaytype="date" style="background:white;background2:white;" text="bind:purcchkdd"/>
- <Cell col="4" style="background:white;background2:white;" text="bind:purcchkno"/>
- <Cell col="5" style="background:white;background2:white;" text="bind:purcchkseq"/>
- <Cell col="6" displaytype="date" style="background:white;background2:white;" text="bind:purccondd"/>
- <Cell col="7" style="background:white;background2:white;" text="bind:purcconno"/>
- <Cell col="8" displaytype="number" style="background:white;background2:white;" text="bind:chkqty"/>
- <Cell col="9" displaytype="number" style="background:white;background2:white;font:arial,9,bold;" text="bind:chkgoodunitcost"/>
- <Cell col="10" style="background:white;background2:white;" text="bind:chkamt"/>
- <Cell col="11" style="background:white;background2:white;" text="bind:acntcd"/>
- <Cell col="12" style="background:white;background2:white;" text="bind:delivedeptcd"/>
- <Cell col="13" style="background:white;background2:white;" text="bind:fstrgstrid"/>
- <Cell col="14" style="background:white;background2:white;" text="bind:fstrgstdt"/>
- <Cell col="15" style="background:white;background2:white;" text="bind:lastupdtrid"/>
- <Cell col="16" style="background:white;background2:white;" text="bind:lastupdtdt"/>
- <Cell col="17" displaytype="date" style="background:white;background2:white;" text="bind:lastupdtdd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Static id="caption2" class="tit_2" position="absolute 0 2 100 18" style="" text="검수 내역"/>
- <Shape id="line4" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="pur" anchor="default">
- <Layouts>
- <Layout>
- <Shape id="line2" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
- <Static id="caption8" class="tit_2" position="absolute 0 2 85 18" style="" text="구매 내역"/>
- <Grid id="grd_pur" binddataset="ds_main_pur" position="absolute 0 23 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_pur_grd_pur_onaftersort" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="200"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="60"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- </Columns>
- <Rows>
- <Row size="23" band="head"/>
- <Row size="23"/>
- </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="계약번호"/>
- <Cell col="6" text="입고일자"/>
- <Cell col="7" text="입고순번"/>
- <Cell col="8" text="구입량"/>
- <Cell col="9" text="구입단가"/>
- <Cell col="10" text="구입금액"/>
- <Cell col="11" text="출고부서"/>
- <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:kwanri_gubun"/>
- <Cell col="2" style="align:left;background:white;background2:white;" text="bind:goodcd"/>
- <Cell col="3" style="align:left;background:white;background2:white;" text="bind:pum_name"/>
- <Cell col="4" style="background:white;background2:white;" text="bind:ky_ymd"/>
- <Cell col="5" style="background:white;background2:white;" text="bind:ky_seq"/>
- <Cell col="6" displaytype="date" style="background:white;background2:white;" text="bind:ibgo_ymd"/>
- <Cell col="7" style="background:white;background2:white;" text="bind:ibgo_seq"/>
- <Cell col="8" displaytype="number" style="background:white;background2:white;" text="bind:qty"/>
- <Cell col="9" displaytype="number" style="background:white;background2:white;font:arial,9,bold;" text="bind:danga1"/>
- <Cell col="10" style="background:white;background2:white;" text="bind:keumak"/>
- <Cell col="11" style="background:white;background2:white;" text="bind:chul_buseo"/>
- <Cell col="12" style="background:white;background2:white;" text="bind:user_id"/>
- <Cell col="13" style="background:white;background2:white;" text="bind:sys_date"/>
- <Cell col="14" style="background:white;background2:white;" text="bind:upd_date"/>
- <Cell col="15" displaytype="date" style="background:white;background2:white;" text="bind:upd_dd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="h604" anchor="default">
- <Layouts>
- <Layout>
- <Grid id="grd_h604" binddataset="ds_main_h604" position="absolute 0 23 595 703" style="" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_h604_grd_h604_onaftersort" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="200"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="60"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="80"/>
- </Columns>
- <Rows>
- <Row size="23" band="head"/>
- <Row size="23"/>
- </Rows>
- <Band id="head">
- <Cell text="기관코드"/>
- <Cell col="1" text="신청여부"/>
- <Cell col="2" text="물품코드"/>
- <Cell col="3" text="EDI코드"/>
- <Cell col="4" text="물품명"/>
- <Cell col="5" text="신청일자"/>
- <Cell col="6" text="신청일련번호"/>
- <Cell col="7" text="구입량"/>
- <Cell col="8" text="구입가"/>
- <Cell col="9" text="개당단가"/>
- <Cell col="10" text="입고일자"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" text="bind:notiyn"/>
- <Cell col="2" style="align:left;background:white;background2:white;" text="bind:goodcd"/>
- <Cell col="3" style="background:white;background2:white;" text="bind:edicd"/>
- <Cell col="4" style="align:left;background:white;background2:white;" text="bind:itemnm"/>
- <Cell col="5" displaytype="date" style="background:white;background2:white;" text="bind:appdd"/>
- <Cell col="6" style="background:white;background2:white;" text="bind:appseqno"/>
- <Cell col="7" displaytype="number" style="background:white;background2:white;" text="bind:winqty"/>
- <Cell col="8" style="background:white;background2:white;" text="bind:winamt"/>
- <Cell col="9" displaytype="number" style="background:white;background2:white;font:arial,9,bold;" text="bind:oneunitcost"/>
- <Cell col="10" displaytype="date" style="background:white;background2:white;" text="bind:windd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Shape id="line5" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
- <Static id="caption5" class="tit_2" position="absolute 0 2 85 18" style="" text="발주 내역"/>
- </Layout>
- </Layouts>
- </Tabpage>
- <Tabpage id="h602" anchor="default">
- <Layouts>
- <Layout>
- <Static id="caption9" class="tit_2" position="absolute 0 2 85 18" style="" text="신고 내역"/>
- <Shape id="line6" class="line_10" linetype="horizontal" position="absolute 0 20 595 23" style="" anchor="left top right"/>
- <Grid id="grd_h602" binddataset="ds_main_h602" position="absolute 0 23 595 703" style="align:center ;" oncellclick="switch1_cont_grd_cont_oncellclick" onaftersort="switch1_h602_grd_h602_onaftersort" anchor="all">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="195"/>
- <Column size="85"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="60"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="80"/>
- </Columns>
- <Rows>
- <Row size="23" band="head"/>
- <Row size="23"/>
- </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="신청번호"/>
- <Cell col="6" text="줄번호"/>
- <Cell col="7" text="입고번호"/>
- <Cell col="8" text="입고순번"/>
- <Cell col="9" text="구입일자"/>
- <Cell col="10" text="구립량"/>
- <Cell col="11" text="구입가"/>
- <Cell col="12" text="개당단가"/>
- <Cell col="13" text="상태"/>
- <Cell col="14" text="최초작성자"/>
- <Cell col="15" text="최초작성일시"/>
- <Cell col="16" text="최종수정자"/>
- <Cell col="17" text="최종수정일시"/>
- <Cell col="18" text="최종수정일"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" text="bind:reptflag"/>
- <Cell col="2" style="align:left;" text="bind:goodcd"/>
- <Cell col="3" text="bind:appitemcd"/>
- <Cell col="4" style="align:left;" text="bind:itemnm"/>
- <Cell col="5" text="bind:appno"/>
- <Cell col="6" text="bind:lnno"/>
- <Cell col="7" text="bind:winno"/>
- <Cell col="8" text="bind:winseqno"/>
- <Cell col="9" text="bind:purcdd"/>
- <Cell col="10" text="bind:purcqty"/>
- <Cell col="11" text="bind:purcamt"/>
- <Cell col="12" displaytype="number" style="font:arial,9,bold;" text="bind:oneunitcost"/>
- <Cell col="13" text="bind:statcd"/>
- <Cell col="14" text="bind:fstrgstrid"/>
- <Cell col="15" text="bind:fstrgstdt"/>
- <Cell col="16" text="bind:lastupdtrid"/>
- <Cell col="17" text="bind:lastupdtdt"/>
- <Cell col="18" displaytype="date" text="bind:lastupdtdd"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Tabpage>
- </Tabpages>
- </Tab>
- <Static id="caption1" class="tit_1" position="absolute 0 0 247 25" style="" text="재료 수가 변경 내역 조회"/>
- <Grid id="grd_mech" binddataset="ds_main_mech" position="absolute 0 104 595 771" style="" oncellclick="grd_mech_oncellclick" onaftersort="grd_mech_onaftersort" anchor="left top bottom" cellmovingtype="col" cellsizingtype="col">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="0"/>
- <Column size="80"/>
- <Column size="200"/>
- <Column size="75"/>
- <Column size="70"/>
- <Column size="0"/>
- <Column size="75"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="75"/>
- <Column size="50"/>
- <Column size="89"/>
- <Column size="100"/>
- </Columns>
- <Rows>
- <Row size="23" band="head"/>
- <Row size="23"/>
- </Rows>
- <Band id="head">
- <Cell text="기관코드"/>
- <Cell col="1" text="수가코드"/>
- <Cell col="2" text="EDI코드"/>
- <Cell col="3" text="EDI코드"/>
- <Cell col="4" text="수가명"/>
- <Cell col="5" text="보험급비1"/>
- <Cell col="6" text="적용일자"/>
- <Cell col="7" text="수가종료일"/>
- <Cell col="8" text="보험가"/>
- <Cell col="9" text="최초작성자"/>
- <Cell col="10" text="최초작성일"/>
- <Cell col="11" text="최종수정자"/>
- <Cell col="12" text="최종수정일"/>
- <Cell col="13" text="자보가"/>
- <Cell col="14" text="무산정"/>
- <Cell col="15" text="처방입력구분"/>
- <Cell col="16" displaytype="normal" edittype="none" text="원내원외"/>
- </Band>
- <Band id="body">
- <Cell text="bind:instcd"/>
- <Cell col="1" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:calcscorcd"/>
- <Cell col="2" style="background:#ffffffff;background2:#ffffffff;" text="bind:insuedicd"/>
- <Cell col="3" text="bind:insuedicd"/>
- <Cell col="4" style="align:left;background:#ffffffff;background2:#ffffffff;" text="bind:hngnm"/>
- <Cell col="5" displaytype="combo" edittype="combo" style="align:center;" text="bind:insupynpy1" combodataset="ds_init_P0104list_P0104" combocodecol="cdid" combodatacol="cdnm"/>
- <Cell col="6" displaytype="date" style="background:#ffffffff;background2:#ffffffff;" text="bind:fromdd"/>
- <Cell col="7" style="background:#ffffffff;background2:#ffffffff;" text="bind:todd"/>
- <Cell col="8" displaytype="number" style="background:#ffffffff;background2:#ffffffff;font:arial,9,bold;" text="bind:insurbpnt"/>
- <Cell col="9" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstrid"/>
- <Cell col="10" style="background:#ffffffff;background2:#ffffffff;" text="bind:fstrgstdt"/>
- <Cell col="11" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtrid"/>
- <Cell col="12" style="background:#ffffffff;background2:#ffffffff;" text="bind:lastupdtdt"/>
- <Cell col="13" displaytype="number" style="background:#ffffffff;background2:#ffffffff;font:arial,9,bold;" text="bind:autmbrbpnt"/>
- <Cell col="14" displaytype="number" style="align:center;background:#ffffffff;background2:#ffffffff;font:arial,9,bold;" text="bind:freeflag"/>
- <Cell col="15" displaytype="combo" style="align:center;" text="bind:ordinptflag" combodataset="ds_init_P0141list_P0141" combocodecol="cdid" combodatacol="cdnm"/>
- <Cell col="16" displaytype="combo" text="bind:hosinflag" combodataset="ds_init_A0601list_A0601" combocodecol="cdid" combodatacol="cdnm"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Static id="caption6" class="tit_2" position="absolute 0 80 90 96" style="" text="재료 수가"/>
- <Shape id="line3" class="line_10" linetype="horizontal" position="absolute 0 100 595 103" style="" anchor="default"/>
- <Static id="cap_rowcnt" position="absolute 371 76 486 95" style="color:#808080ff;align:right;font:Dotum,9,bold;"/>
- <Div id="Div00" taborder="14" position="absolute 0 25 1195 67" class="div_SA" anchor="left top right">
- <Layouts>
- <Layout width="982" height="68">
- <Static id="caption3" text="적용일자 :" class="search_name" position="absolute 6 14 84 31" anchor="left top"/>
- <Button id="btn_excel" taborder="2" text="엑셀저장" onclick="btn_excel_onclick" class="btn7" position="absolute 1107 13 1183 32" anchor="top right" visible="false"/>
- <Shape id="line7" linetype="vertical" position="absolute 1022 10 1025 35" style="border: solid #FFD799 #FFD799;" anchor="top right"/>
- <Button id="btnSearch" taborder="3" text="조회" onclick="btnSearch_onclick" class="btn1" position="absolute 1041 11 1097 33" anchor="top right"/>
- <Grid id="grd_target" taborder="4" binddataset="ds_init_target" useinputpanel="false" oncellclick="grd_target_oncellclick" position="absolute 766 9 1052 31" style="background:#ffffff ;" anchor="left top" autofittype="col" selecttype="multiarea" scrollbars="none" visible="false">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="50"/>
- <Column size="50"/>
- <Column size="50"/>
- <Column size="50"/>
- <Column size="50"/>
- </Columns>
- <Rows>
- <Row size="22"/>
- </Rows>
- <Band id="body">
- <Cell style="font:arial,9,bold;" text="bind:cont"/>
- <Cell col="1" style="font:arial,9,bold;" text="bind:wchk"/>
- <Cell col="2" style="font:arial,9,bold;" text="bind:pur"/>
- <Cell col="3" style="font:arial,9,bold;" text="bind:h604"/>
- <Cell col="4" style="font:arial,9,bold;" text="bind:h602"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Calendar id="ipt_fromdd" taborder="6" class="input_search" position="absolute 84 12 174 31" mask="yyyy-mm-dd" anchor="left top" dateformat="yyyy-MM-dd" value="null"/>
- <Combo id="Combo00" taborder="7" text="Combo00" position="absolute 245 12 315 32" codecolumn="codecolumn" datacolumn="datacolumn">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn" size="256"/>
- <Column id="datacolumn" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn"/>
- <Col id="datacolumn">전체</Col>
- </Row>
- <Row>
- <Col id="codecolumn">1</Col>
- <Col id="datacolumn">재료</Col>
- </Row>
- <Row>
- <Col id="codecolumn">4</Col>
- <Col id="datacolumn">약제</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Static id="caption00" text="구분 :" class="search_name" position="absolute 193 14 243 31" anchor="left top"/>
- <Static id="caption01" text="수가코드 :" class="search_name" position="absolute 344 14 418 31" anchor="left top"/>
- <Static id="caption02" text="EDI코드 :" class="search_name" position="absolute 549 14 619 31" anchor="left top"/>
- <Edit id="Edit00" taborder="8" position="absolute 420 12 520 32" inputmode="upper"/>
- <Edit id="Edit01" taborder="9" position="absolute 623 12 723 32" inputmode="upper"/>
- <Static id="caption04" text="급비 :" class="search_name" position="absolute 749 14 798 31" anchor="left top"/>
- <Combo id="Combo01" taborder="10" text="Combo01" position="absolute 798 12 928 32" innerdataset="@ds_init_P0104list_P0104" codecolumn="cdid" datacolumn="cdnm"/>
- </Layout>
- </Layouts>
- </Div>
- <Button id="Button00" taborder="15" text="엑셀저장" position="absolute 518 78 595 98" class="btn7" onclick="Button00_onclick"/>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_main_cont" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="goodcd" type="STRING" size="256"/>
- <Column id="goodnm" type="STRING" size="256"/>
- <Column id="fromdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="congoodunitcost" type="STRING" size="256"/>
- <Column id="fromconterm" type="STRING" size="256"/>
- <Column id="toconterm" type="STRING" size="256"/>
- <Column id="gubun" type="STRING" size="256"/>
- <Column id="lastupdtdt" type="STRING" size="256"/>
- <Column id="edicd" type="STRING" size="256"/>
- <Column id="bginsuamt" type="STRING" size="256"/>
- <Column id="bgautmamt" type="STRING" size="256"/>
- <Column id="bgcontamt" type="STRING" size="256"/>
- <Column id="bgedicd" type="STRING" size="256"/>
- <Column id="bgcontedicd" type="STRING" size="256"/>
- <Column id="hosinflag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="goodcd"/>
- <Col id="goodnm"/>
- <Col id="fromdd"/>
- <Col id="todd"/>
- <Col id="congoodunitcost"/>
- <Col id="fromconterm"/>
- <Col id="toconterm"/>
- <Col id="gubun"/>
- <Col id="lastupdtdt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_h604" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="goodcd" type="STRING" size="256"/>
- <Column id="edicd" type="STRING" size="256"/>
- <Column id="itemnm" type="STRING" size="256"/>
- <Column id="appdd" type="STRING" size="256"/>
- <Column id="appseqno" type="STRING" size="256"/>
- <Column id="windd" type="STRING" size="256"/>
- <Column id="winqty" type="STRING" size="256"/>
- <Column id="winamt" type="STRING" size="256"/>
- <Column id="oneunitcost" type="STRING" size="256"/>
- <Column id="notiyn" type="STRING" size="256"/>
- <Column id="fstrgstrid" type="STRING" size="256"/>
- <Column id="fstrgstdt" type="STRING" size="256"/>
- <Column id="lastupdtrid" type="STRING" size="256"/>
- <Column id="lastupdtdt" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="goodcd"/>
- <Col id="edicd"/>
- <Col id="itemnm"/>
- <Col id="appdd"/>
- <Col id="appseqno"/>
- <Col id="windd"/>
- <Col id="winqty"/>
- <Col id="winamt"/>
- <Col id="oneunitcost"/>
- <Col id="notiyn"/>
- <Col id="fstrgstrid"/>
- <Col id="fstrgstdt"/>
- <Col id="lastupdtrid"/>
- <Col id="lastupdtdt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="cont" type="STRING" size="256"/>
- <Column id="wchk" type="STRING" size="256"/>
- <Column id="pur" type="STRING" size="256"/>
- <Column id="h604" type="STRING" size="256"/>
- <Column id="h602" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="cont">계약</Col>
- <Col id="wchk">검수</Col>
- <Col id="pur">입고</Col>
- <Col id="h604">집계</Col>
- <Col id="h602">신고</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_pur" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="kwanri_gubun" type="STRING" size="256"/>
- <Column id="pum_code" type="STRING" size="256"/>
- <Column id="pum_name" type="STRING" size="256"/>
- <Column id="ky_ymd" type="STRING" size="256"/>
- <Column id="ky_seq" type="STRING" size="256"/>
- <Column id="ibgo_ymd" type="STRING" size="256"/>
- <Column id="ibgo_seq" type="STRING" size="256"/>
- <Column id="qty" type="STRING" size="256"/>
- <Column id="danga1" type="STRING" size="256"/>
- <Column id="keumak" type="STRING" size="256"/>
- <Column id="chul_buseo" type="STRING" size="256"/>
- <Column id="user_id" type="STRING" size="256"/>
- <Column id="sys_date" type="STRING" size="256"/>
- <Column id="upd_date" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="kwanri_gubun"/>
- <Col id="pum_code"/>
- <Col id="pum_name"/>
- <Col id="ky_ymd"/>
- <Col id="ky_seq"/>
- <Col id="ibgo_ymd"/>
- <Col id="ibgo_seq"/>
- <Col id="qty"/>
- <Col id="danga1"/>
- <Col id="keumak"/>
- <Col id="chul_buseo"/>
- <Col id="user_id"/>
- <Col id="sys_date"/>
- <Col id="upd_date"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="basedd" type="STRING" size="256"/>
- <Column id="matractflag" type="STRING" size="256"/>
- <Column id="srchflag" type="STRING" size="256"/>
- <Column id="calcscorcd" type="STRING" size="256"/>
- <Column id="insuedicd" type="STRING" size="256"/>
- <Column id="insupynpy1" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="basedd"/>
- <Col id="matractflag"/>
- <Col id="srchflag"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="rowcnt" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="rowcnt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_mech" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="calcscorcd" type="STRING" size="256"/>
- <Column id="insuedicd" type="STRING" size="256"/>
- <Column id="hngnm" type="STRING" size="256"/>
- <Column id="fromdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="purcamt" type="STRING" size="256"/>
- <Column id="gnrlrbpnt" type="STRING" size="256"/>
- <Column id="fstrgstrid" type="STRING" size="256"/>
- <Column id="fstrgstdt" type="STRING" size="256"/>
- <Column id="lastupdtrid" type="STRING" size="256"/>
- <Column id="lastupdtdt" type="STRING" size="256"/>
- <Column id="insupynpy1" type="STRING" size="256"/>
- <Column id="autmbrbpnt" type="STRING" size="256"/>
- <Column id="freeflag" type="STRING" size="256"/>
- <Column id="ordinptflag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="calcscorcd"/>
- <Col id="insuedicd"/>
- <Col id="hngnm"/>
- <Col id="fromdd"/>
- <Col id="todd"/>
- <Col id="purcamt"/>
- <Col id="gnrlrbpnt"/>
- <Col id="fstrgstrid"/>
- <Col id="fstrgstdt"/>
- <Col id="lastupdtrid"/>
- <Col id="lastupdtdt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_wchk" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="goodflag" type="STRING" size="256"/>
- <Column id="goodcd" type="STRING" size="256"/>
- <Column id="purcchkdd" type="STRING" size="256"/>
- <Column id="purcchkno" type="STRING" size="256"/>
- <Column id="purcchkseq" type="STRING" size="256"/>
- <Column id="purccondd" type="STRING" size="256"/>
- <Column id="purcconno" type="STRING" size="256"/>
- <Column id="chkqty" type="STRING" size="256"/>
- <Column id="chkgoodunitcost" type="STRING" size="256"/>
- <Column id="chkamt" type="STRING" size="256"/>
- <Column id="acntcd" type="STRING" size="256"/>
- <Column id="delivedeptcd" type="STRING" size="256"/>
- <Column id="fstrgstrid" type="STRING" size="256"/>
- <Column id="fstrgstdt" type="STRING" size="256"/>
- <Column id="lastupdtrid" type="STRING" size="256"/>
- <Column id="lastupdtdt" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="goodflag"/>
- <Col id="goodcd"/>
- <Col id="purcchkdd"/>
- <Col id="purcchkno"/>
- <Col id="purcchkseq"/>
- <Col id="purccondd"/>
- <Col id="purcconno"/>
- <Col id="chkqty"/>
- <Col id="chkgoodunitcost"/>
- <Col id="chkamt"/>
- <Col id="acntcd"/>
- <Col id="delivedeptcd"/>
- <Col id="fstrgstrid"/>
- <Col id="fstrgstdt"/>
- <Col id="lastupdtrid"/>
- <Col id="lastupdtdt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_temp_xlslist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="col1" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_h602" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="goodcd" type="STRING" size="256"/>
- <Column id="appitemcd" type="STRING" size="256"/>
- <Column id="itemnm" type="STRING" size="256"/>
- <Column id="appno" type="STRING" size="256"/>
- <Column id="reptflag" type="STRING" size="256"/>
- <Column id="lnno" type="STRING" size="256"/>
- <Column id="winno" type="STRING" size="256"/>
- <Column id="winseqno" type="STRING" size="256"/>
- <Column id="purcdd" type="STRING" size="256"/>
- <Column id="purcqty" type="STRING" size="256"/>
- <Column id="purcamt" type="STRING" size="256"/>
- <Column id="oneunitcost" type="STRING" size="256"/>
- <Column id="statcd" type="STRING" size="256"/>
- <Column id="fstrgstrid" type="STRING" size="256"/>
- <Column id="fstrgstdt" type="STRING" size="256"/>
- <Column id="lastupdtrid" type="STRING" size="256"/>
- <Column id="lastupdtdt" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="goodcd"/>
- <Col id="appitemcd"/>
- <Col id="itemnm"/>
- <Col id="appno"/>
- <Col id="reptflag"/>
- <Col id="lnno"/>
- <Col id="winno"/>
- <Col id="winseqno"/>
- <Col id="purcdd"/>
- <Col id="purcqty"/>
- <Col id="purcamt"/>
- <Col id="oneunitcost"/>
- <Col id="statcd"/>
- <Col id="fstrgstrid"/>
- <Col id="fstrgstdt"/>
- <Col id="lastupdtrid"/>
- <Col id="lastupdtdt"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_P0104list_P0104" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="P0104" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="P0104"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_A0601list_A0601" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="A0601" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="A0601"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_init_P0141list_P0141" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="P0141" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="P0141"/>
- </Row>
- </Rows>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item2" compid="cap_rowcnt" propid="value" datasetid="ds_hidden" columnid="rowcnt"/>
- <BindItem id="item0" compid="Div00.ipt_fromdd" propid="value" datasetid="ds_send" columnid="basedd"/>
- <BindItem id="item3" compid="cap_rowcnt" propid="text" datasetid="ds_hidden" columnid="rowcnt"/>
- <BindItem id="item1" compid="Div00.Combo00" propid="value" datasetid="ds_send" columnid="matractflag"/>
- <BindItem id="item4" compid="Div00.Edit00" propid="value" datasetid="ds_send" columnid="calcscorcd"/>
- <BindItem id="item5" compid="Div00.Edit01" propid="value" datasetid="ds_send" columnid="insuedicd"/>
- <BindItem id="item6" compid="Div00.Combo01" propid="value" datasetid="ds_send" columnid="insupynpy1"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2016-10-07
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2016-10-07 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- include "com_basiccodexp::ZBC001.xjs";
- function SPPIE04210_onload(obj:Form, e:LoadEventInfo) {
- frmf_initForm(obj);
-
- grdf_initGrid(grd_mech);
- grdf_setToolTipBind(grd_mech);
-
- grdf_initGrid(switch1.cont.grd_cont);
- grdf_setToolTipBind(switch1.cont.grd_cont);
-
- grdf_initGrid(switch1.wchk.grd_wchk);
- grdf_setToolTipBind(switch1.wchk.grd_wchk);
-
- grdf_initGrid(switch1.pur.grd_pur);
- grdf_setToolTipBind(switch1.pur.grd_pur);
-
- grdf_initGrid(switch1.h602.grd_h602);
- grdf_setToolTipBind(switch1.h602.grd_h602);
-
- grdf_initGrid(switch1.h604.grd_h604);
- grdf_setToolTipBind(switch1.h604.grd_h604);
- switch1.tabindex = 0;
- ds_send.setColumn( 0, "srchflag", "cont");
- ds_send.setColumn( 0, "basedd", utlf_getCurrentDate());
-
- //원무사용 기초코드 조회 cache기능 추가 오류심할시 위 주석으로 대체할것
- var arrParam1 = [
- { dsNm: "ds_init_A0601list_A0601", cdGrpId: "A0601" },
- { dsNm: "ds_init_P0104list_P0104", cdGrpId: "P0104" },
- { dsNm: "ds_init_P0141list_P0141", cdGrpId: "P0141" }
- ];
- zbcfGetCodeList(arrParam1);
- }
- function grd_mech_oncellclick(obj:Grid, e:GridClickEventInfo) {
- if (e.row < 0) {
- return;
- }
- var calcscorcd = ds_main_mech.getColumn(e.row, "calcscorcd");
- var flag = ds_send.getColumn(0, "srchflag");
- var grd = eval("ds_main_" + flag);
- var grd_obj = eval("switch1."+flag).components["grd_" + flag];
- var row = grd.findRow("goodcd", calcscorcd);
- if (row > -1) {
- grd.rowposition = row;
- grd_obj.vscrollbar.pos = row - 5;
- } else {
- grd.rowposition = -1;
- }
- }
- function switch1_cont_grd_cont_oncellclick(obj:Grid, e:GridClickEventInfo) {
- var goodcd = obj.getCellValue(e.row, 2);
- var row = ds_main_mech.findRow("calcscorcd", goodcd);
- if (row > -1) {
- ds_main_mech.rowposition = row;
- grd_mech.vscrollbar.pos = row - 5;
- } else {
- ds_main_mech.rowposition = -1;
- }
- }
- function grd_target_oncellclick(obj:Grid, e:GridClickEventInfo) {
- var flag = obj.getCellProperty("body", e.col, "text").split(":")[1];
- ds_send.setColumn( 0, "srchflag", flag);
- switch1.tabindex = e.col;
- }
- function btnSearch_onclick(obj:Button, e:ClickEventInfo) {
- var oParam = {};
- oParam.id = "TRPIE04301";
- oParam.service = "edimngtapp.EdiMngt";
- oParam.method = "reqGetCompareMatr";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_mech=mech ds_main_cont=cont ds_main_wchk=wchk ds_main_pur=pur ds_main_h604=h604 ds_main_h602=h602";
- oParam.async = false;
- //oParam.callback = "cf_TRPIE04301";
- tranf_submit(oParam);
- ds_hidden.setColumn( 0, "rowcnt", "Count : " + ds_main_mech.rowcount);
- }
- function btn_excel_onclick(obj:Button, e:ClickEventInfo) {
- var flag = ds_send.getColumn(0, "srchflag");
- var sGrd = "grd_mech,switch1."+flag+".grd_"+flag;
- var sSheet = "GridSheetTest,GridSheetTest2";
- grdf_exportExcelMulti(sGrd, "재료수가변경내역_" + "수가 vs " + ds_init_target.getColumn(0,flag), sSheet);
- sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
- // var flag = ds_send.getColumn(0, "srchflag");
- //
- // var fileName = window.fileDialog("save", ",", false, "재료수가변경내역_" + "수가 vs " + model.getValue("ds_init_target/" + flag) + "_" + utlf_getCurrentDate(), "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
- //
- // if (fileName == "") {
- // return;
- // }
- //
- // var grd = document.controls("grd_" + flag);
- //
- // ds_temp_xlslist.clearData(); ds_temp_xlslist.addRow();
- //
- // var cols = grd_xls.cols;
- // if (cols > 0) {
- // for (var i = 0; i < cols; i++) {
- // grd_xls.removeColumn(false);
- // }
- // }
- //
- // ds_temp_xlslist.clearData();
- // dsf_makeValue( ds_temp, "xlslist", "string", "" );
- //
- // var colArr = new Array();
- // var idx1 = 0;
- // var capArr = grd_mech.caption.split("^");
- // var cap = "";
- // var wArr = new Array();
- //
- // for (var i = 0; i < grd_mech.cols; i++) {
- // if (!grd_mech.colHidden(i)) {
- // colArr[idx1] = grd_mech.colAttribute(i, "ref");
- // cap += capArr[i] + "^";
- // wArr[idx1] = Math.round(grd_mech.colWidth(i) * 1.2);
- // idx1++;
- // }
- // }
- //
- // cap+= "VS^";
- // colArr[idx1] = "blank";
- // wArr[idx1] = 100;
- //
- // var idx2 = idx1 + 1;
- // capArr = grd.caption.split("^");
- // for (var i = 0; i < grd.cols; i++) {
- // if (!grd.colHidden(i)) {
- // colArr[idx2] = "t" + grd.colAttribute(i, "ref");
- // cap += capArr[i] + "^";
- // wArr[idx2] = Math.round(grd.colWidth(i) * 1.2);
- // idx2++;
- // }
- // }
- //
- // cap = cap.substr(0, cap.length - 1);
- //
- // for (var i = 0; i < colArr.length; i++) {
- // grd_xls.addColumn("ref:" + colArr[i] + "; type:output; ", false);
- // grd_xls.colWidth(i) = wArr[i];
- // }
- // grd_xls.caption = cap;
- //
- // var cnt = instance1.selectNodes("ds_main_mech").length;
- // for (var i = 1; i <= cnt; i++) {
- // for (var j = 0; j < colArr.length; j++) {
- //
- // if (j == idx1) {
- // continue;
- // }
- //
- // if (j < idx1) {
- // model.makeValue("ds_temp_xlslist[" + i + "]/" + colArr[j], model.getValue("ds_main_mech[" + i + "]/" + colArr[j]));
- // } else {
- // var ref = colArr[j].substr(1, colArr[j].length - 1);
- // model.makeValue("ds_temp_xlslist[" + i + "]/" + colArr[j], model.getValue("ds_main/" + flag + "[" + i + "]/" + ref));
- // }
- // }
- // }
- //
- // //grd_xls.refresh();
- //
- // grd_xls.saveExcel(fileName, "sheetname:수가 vs " + model.getValue("ds_init_target/" + flag) + ";colhiddenextend:false;rowhiddenextend:false");
- // sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
- //
- }
- // 수가정보 엑셀저장
- function Button00_onclick(obj:Button, e:ClickEventInfo)
- {
- grdf_exportExcel(grd_mech, "재료수가자료", "see");
- }
- // 물류정보 엑셀저장
- function switch1_cont_Button00_onclick(obj:Button, e:ClickEventInfo)
- {
- grdf_exportExcel(switch1.cont.grd_cont, "계약내역자료", "see");
- }
- ]]></Script>
- </Form>
- </FDL>
|