YNU_JEUS/app_home/himed/xpapps/lis/refprintmngtxp/xp/SMLLP02000_외주검사청구서.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLLP02000" position="absolute 0 0 1256 805" titletext="검사 청구서" onload="SMLLP02000_onload" oninit="SMLLP02000_oninit">
    <Layouts>
      <Layout>
        <Static id="caption6" text="검사 청구서" class="tit_1" position="absolute 0 0 124 25"/>
        <Grid id="grd_patlist" taborder="8" useinputpanel="false" position="absolute 740 96 1256 283" autofittype="col" anchor="left top right" binddataset="ds_grid_grd_patlist" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="110"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="115"/>
              </Columns>
              <Rows>
                <Row size="22" band="head"/>
                <Row size="20"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" style="font:arial,9,bold;" text="접수일"/>
                <Cell col="2" style="font:arial,9,bold;" text="수거자"/>
                <Cell col="3" style="font:arial,9,bold;" text="환자명"/>
                <Cell col="4" style="font:arial,9,bold;" text="등록번호"/>
                <Cell col="5" style="font:arial,9,bold;" text="샘플번호"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow+1"/>
                <Cell col="1" style="align:center middle;" text="bind:spcacptdt" mask="expr:spcacptdt==null?'':'####-##-##'"/>
                <Cell col="2" style="align:left middle;" text="bind:spcapctnm"/>
                <Cell col="3" style="align:left middle;" text="bind:patnm"/>
                <Cell col="4" style="align:left middle;" text="bind:pid"/>
                <Cell col="5" style="align:left middle;" text="bind:bcno"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption9" text="외주업체 내역서" class="tit_2" position="absolute 740 77 871 97"/>
        <Button id="button2" taborder="9" text="엑셀" onlbuttonup="button2_onlbuttonup" class="btn7" position="absolute 678 74 730 94"/>
        <Grid id="grd_datagrid2" taborder="10" useinputpanel="false" position="absolute 0 97 730 284" autofittype="col" binddataset="ds_grid_grd_datagrid2" summarytype="top" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="85"/>
                <Column size="70"/>
                <Column size="89"/>
                <Column size="115"/>
                <Column size="115"/>
                <Column size="90"/>
                <Column size="90"/>
              </Columns>
              <Rows>
                <Row size="22" band="head"/>
                <Row size="20"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" style="font:arial,9,bold;" text="시행부서"/>
                <Cell col="2" style="font:arial,9,bold;" text="건수"/>
                <Cell col="3" style="font:arial,9,bold;" text="총단가"/>
                <Cell col="4" style="font:arial,9,bold;" text="총계약가"/>
                <Cell col="5" style="font:arial,9,bold;" text="차액"/>
                <Cell col="6" style="font:arial,9,bold;" text=" 일반가격"/>
                <Cell col="7" style="font:arial,9,bold;" text="보험가격"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow+1"/>
                <Cell col="1" style="align:left middle;" text="bind:sectnm"/>
                <Cell col="2" displaytype="number" style="align:right middle;" text="bind:tclscount" mask="@,@@@"/>
                <Cell col="3" displaytype="number" style="align:right middle;" text="bind:totalpay" mask="@,@@@.@@"/>
                <Cell col="4" displaytype="number" style="align:right middle;" text="bind:totalpay2" mask="@,@@@.@@"/>
                <Cell col="5" displaytype="number" style="align:right middle;" text="bind:margin" mask="@,@@@.@@"/>
                <Cell col="6" displaytype="number" style="align:right middle;" text="bind:gpay" mask="@,@@@.@@"/>
                <Cell col="7" displaytype="number" style="align:right middle;" text="bind:ipay" mask="@,@@@.@@"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" style="align:left;"/>
                <Cell col="2" style="align:right;"/>
                <Cell col="3" displaytype="number" style="align:right;"/>
                <Cell col="4" displaytype="number" style="align:right;"/>
                <Cell col="5" displaytype="number" style="align:right;"/>
                <Cell col="6" displaytype="number" style="align:right;"/>
                <Cell col="7" displaytype="number" style="align:right;"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption8" text="부서별 청구 총액" class="tit_2" position="absolute 0 77 131 97"/>
        <Static id="caption1" text="청구서 상세내역" class="tit_2" position="absolute 0 294 131 314"/>
        <Grid id="grd_datagrid1" taborder="11" useinputpanel="false" position="absolute 0 314 1256 805" autofittype="col" anchor="all" binddataset="ds_grid_grd_datagrid1" oncelldblclick="grd_datagrid1_oncelldblclick" summarytype="top" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="230"/>
                <Column size="45"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="70"/>
                <Column size="90"/>
                <Column size="110"/>
                <Column size="110"/>
                <Column size="90"/>
                <Column size="90"/>
              </Columns>
              <Rows>
                <Row size="22" band="head"/>
                <Row size="20"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" style="font:arial,9,bold;" text="검사코드"/>
                <Cell col="2" style="font:arial,9,bold;" text="시행부서"/>
                <Cell col="3" style="font:arial,9,bold;" text="검사명"/>
                <Cell col="4" style="font:arial,9,bold;" text="유형"/>
                <Cell col="5" style="font:arial,9,bold;" text="단가"/>
                <Cell col="6" style="font:arial,9,bold;" text="계약가"/>
                <Cell col="7" style="font:arial,9,bold;" text="건수"/>
                <Cell col="8" style="font:arial,9,bold;" text="총단가"/>
                <Cell col="9" style="font:arial,9,bold;" text="총계약가"/>
                <Cell col="10" style="font:arial,9,bold;" text="차액"/>
                <Cell col="11" style="font:arial,9,bold;" text=" 일반가격"/>
                <Cell col="12" style="font:arial,9,bold;" text="보험가격"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="expr:currow+1"/>
                <Cell col="1" style="align:left;" text="bind:tclscd"/>
                <Cell col="2" style="align:left middle;" text="bind:sectnm"/>
                <Cell col="3" style="align:left middle;" text="bind:tclsscrnnm"/>
                <Cell col="4" style="align:center middle;" text="bind:gbn"/>
                <Cell col="5" displaytype="number" style="align:right middle;" text="bind:pay" mask="@,@@@.@@"/>
                <Cell col="6" displaytype="number" style="align:right middle;" text="bind:pay2" mask="@,@@@.@@"/>
                <Cell col="7" displaytype="number" style="align:right middle;" text="bind:tclscount" mask="@,@@@"/>
                <Cell col="8" displaytype="number" style="align:right middle;" text="bind:totalpay" mask="@,@@@.@@"/>
                <Cell col="9" displaytype="number" style="align:right middle;" text="bind:totalpay2" mask="@,@@@.@@"/>
                <Cell col="10" displaytype="number" style="align:right middle;" text="bind:margin" mask="@,@@@.@@"/>
                <Cell col="11" displaytype="number" style="align:right middle;" text="bind:gpay" mask="@,@@@.@@"/>
                <Cell col="12" displaytype="number" style="align:right middle;" text="bind:ipay" mask="@,@@@.@@"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" displaytype="text"/>
                <Cell col="2" displaytype="text"/>
                <Cell col="3" displaytype="text" style="align:left;"/>
                <Cell col="4" displaytype="text"/>
                <Cell col="5" displaytype="number" style="align:right;"/>
                <Cell col="6" displaytype="number" style="align:right;"/>
                <Cell col="7" displaytype="number" style="align:right;"/>
                <Cell col="8" displaytype="number" style="align:right;"/>
                <Cell col="9" displaytype="number" style="align:right;"/>
                <Cell col="10" displaytype="number" style="align:right;"/>
                <Cell col="11" displaytype="number" style="align:right;"/>
                <Cell col="12" displaytype="number" style="align:right;"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excel" taborder="12" text="엑셀" onlbuttonup="btn_excel_onlbuttonup" class="btn7" position="absolute 1204 290 1256 310" anchor="top right"/>
        <Div id="grp_sea" taborder="13" style="align:center top;" position="absolute 0 25 1256 67" anchor="left top right" class="div_SA">
          <Layouts>
            <Layout>
              <Static id="caption3" text="의뢰월" class="search_name" position="absolute 608 10 663 30" anchor="default"/>
              <Combo id="combo3" taborder="1" position="absolute 484 10 584 30" anchor="default" innerdataset="@ds_cond_code5" codecolumn="value" datacolumn="label" index="-1"/>
              <Static id="caption4" text="시점기준" class="search_name" position="absolute 408 10 476 30" anchor="default"/>
              <Combo id="combo1" taborder="2" position="absolute 284 10 384 30" anchor="default" innerdataset="@ds_init_lb0110" codecolumn="cd" datacolumn="nm"/>
              <Static id="caption2" text="외주업체" class="search_name" position="absolute 208 10 276 30" anchor="default"/>
              <Combo id="combo4" taborder="3" position="absolute 84 10 184 30" anchor="default" innerdataset="@ds_init_lb0111" codecolumn="cd" datacolumn="nm"/>
              <Static id="caption7" text="시행부서" class="search_name" position="absolute 8 10 76 30" anchor="default"/>
              <Static id="caption5" text="보험선택" class="search_name" position="absolute 795 10 863 30" anchor="default"/>
              <Combo id="combo2" taborder="4" position="absolute 871 10 971 30" anchor="default" innerdataset="@ds_cond_code3" codecolumn="value" datacolumn="label" index="-1"/>
              <Button id="button1" taborder="5" text="조회" class="btn1" position="absolute 1118 10 1174 30" anchor="top right" onclick="grp_sea_button1_onclick"/>
              <Button id="button5" taborder="6" text="초기화" onclick="button5_onclick" class="btn4" position="absolute 1177 10 1245 30" anchor="top right"/>
              <Calendar id="Calendar00" taborder="8" position="absolute 676 10 753 30" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_lb0111" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
          <Column id="etc01" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0106" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0108" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0109" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0110" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0210" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0000" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0124" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb1005" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0128" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_cond_code5" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">수거시점</Col>
            <Col id="value">R</Col>
          </Row>
          <Row>
            <Col id="label">통보시점</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_cond_code3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">-전체-</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">일반</Col>
            <Col id="value">G</Col>
          </Row>
          <Row>
            <Col id="label">보험</Col>
            <Col id="value">I</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_grid_grd_datagrid2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
        <ColumnInfo>
          <column id="sectnm" type="STRING" size="256"/>
          <column id="tclscount" type="STRING" size="256"/>
          <column id="totalpay" type="STRING" size="256"/>
          <column id="totalpay2" type="STRING" size="256"/>
          <column id="margin" type="STRING" size="256"/>
          <column id="gpay" type="STRING" size="256"/>
          <column id="ipay" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_grd_patlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
        <ColumnInfo>
          <column id="spcacptdt" type="STRING" size="256"/>
          <column id="spcapctnm" type="STRING" size="256"/>
          <column id="patnm" type="STRING" size="256"/>
          <column id="pid" type="STRING" size="256"/>
          <column id="bcno" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_grd_datagrid1" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" onrowposchanged="ds_grid_grd_rslt_onrowposchanged">
        <ColumnInfo>
          <column id="tclscd" type="STRING" size="256"/>
          <column id="sectnm" type="STRING" size="256"/>
          <column id="tclsscrnnm" type="STRING" size="256"/>
          <column id="gbn" type="STRING" size="256"/>
          <column id="pay" type="STRING" size="256"/>
          <column id="pay2" type="STRING" size="256"/>
          <column id="tclscount" type="STRING" size="256"/>
          <column id="totalpay" type="STRING" size="256"/>
          <column id="totalpay2" type="STRING" size="256"/>
          <column id="margin" type="STRING" size="256"/>
          <column id="gpay" type="STRING" size="256"/>
          <column id="ipay" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden_ref" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="code1" type="STRING" size="256"/>
          <Column id="code2" type="STRING" size="256"/>
          <Column id="code3" type="STRING" size="256"/>
          <Column id="code4" type="STRING" size="256"/>
          <Column id="code5" type="STRING" size="256"/>
          <Column id="code6" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="code1">00</Col>
            <Col id="code6">00</Col>
            <Col id="code5">R</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.combo2" propid="value" datasetid="ds_hidden_ref" columnid="code3"/>
      <BindItem id="item1" compid="grp_sea.combo3" propid="value" datasetid="ds_hidden_ref" columnid="code5"/>
      <BindItem id="item2" compid="grp_sea.combo1" propid="value" datasetid="ds_hidden_ref" columnid="code1"/>
      <BindItem id="item3" compid="grp_sea.combo4" propid="value" datasetid="ds_hidden_ref" columnid="code6"/>
      <BindItem id="item4" compid="grp_sea.Calendar00" propid="value" datasetid="ds_hidden_ref" columnid="code2"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-05-01
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-05-01      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";
include "lis_commonxp::LZZ001.xjs";
include "lis_commonxp::LLZ001.xjs";

function model1_oninit(obj:Form, e:InitEventInfo)
{
	//폼 초기화 함수
	frmf_initForm(obj);
	fSet(); //초기화 함수 호출
}

function SMLLP02000_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}


function SMLLP02000_onload(obj:Form, e:LoadEventInfo)
{
	ds_grid_grd_datagrid1.clearData();
	ds_grid_grd_datagrid2.clearData();
	ds_grid_grd_patlist.clearData();
	
	//0106 시행부서 // 0105 검체 // 0111 계
	lf_getDbDeptcd("0000|0110|0106|0108|0109|0111|0210|0124|1005|0128|","cbf_SMLLP02000");
	fSet();
}

//날짜
function fSet()
{
	var toDay = utlf_getCurrentDate();
	var toDays = toDay.substr(0, 6);
	ds_hidden_ref.setColumn(0, "code2", toDays);
}

//초기화
function fSetInit()
{
	ds_grid_grd_datagrid1.clearData();
	ds_grid_grd_datagrid2.clearData();
	ds_grid_grd_patlist.clearData();

}

//조회
function fgetListBills()
 {
	var code1 = ds_hidden_ref.getColumn(0, "code1"); 	//외주업체
	var code2 = ds_hidden_ref.getColumn(0, "code2");	//의뢰월
	var code3 = ds_hidden_ref.getColumn(0, "code3"); 	//보험선택
	var code5 = ds_hidden_ref.getColumn(0, "code5"); 	//시점기준
	var code6 = ds_hidden_ref.getColumn(0, "code6"); 	//시행부서
	var check = ""; 									//체크박스
	
	var sInDsName = dsf_createDsRow("ds_temp_search3", [{col : "code1", val:code1 }
													 , {col : "code2", val:code2 }
													 , {col : "code3", val:code3 }
													 , {col : "code5", val:code5 }
													 , {col : "code6", val:code6 }
													 , {col : "check", val:check }]);
	var oParam = {};
		oParam.id          = "TRLLP02001";
		oParam.service     = "refprintmngtapp.GeneralRefPrintMngt";
		oParam.method      = "reqGetListBills";
		oParam.inds        = "cond="+sInDsName;
		oParam.outds       = "ds_grid_grd_datagrid1=getListBills";
		oParam.async       = false;
		//oParam.callback    = "cbf_SMLLP02000";
	tranf_submit(oParam);
}

//조회2
function fgetListBills1()
{
	var code1 = ds_hidden_ref.getColumn(0, "code1"); 	//외주업체
	var code2 = ds_hidden_ref.getColumn(0, "code2");	//의뢰월
	var code3 = ds_hidden_ref.getColumn(0, "code3"); 	//보험선택
	var code5 = ds_hidden_ref.getColumn(0, "code5"); 	//시점기준
	var code6 = ds_hidden_ref.getColumn(0, "code6"); 	//시행부서
	var check = ""; 									//체크박스
	
	trace("code2 = " + code2);
	var sInDsName = dsf_createDsRow("ds_temp_search1", [{col : "code1", val:code1 }
													 , {col : "code2", val:code2 }
													 , {col : "code3", val:code3 }
													 , {col : "code5", val:code5 }
													 , {col : "code6", val:code6 }
													 , {col : "check", val:check }]);
 	                            
	var oParam = {};
		oParam.id          = "TRLLP02003";
		oParam.service     = "refprintmngtapp.GeneralRefPrintMngt";
		oParam.method      = "getListBills1";
		oParam.inds        = "cond="+sInDsName;
		oParam.outds       = "ds_grid_grd_datagrid2=getListBills1";
		oParam.async       = false;
		//oParam.callback    = "cbf_SMLLP02000";
	tranf_submit(oParam);
					
	fgetListBills();
}

 function fClickResultList()
 {	
	var row = ds_grid_grd_datagrid1.rowposition;
	
	
	ds_hidden_ref.setColumn(0, "code4", ds_grid_grd_datagrid1.getColumn(row, "tclscd"));
	
	dsf_createDs("ds_send_data1");
	
	ds_send_data1.copyData(ds_hidden_ref);
	
	var oParam = {};
		oParam.id          = "TRLLP02002";
		oParam.service     = "refprintmngtapp.GeneralRefPrintMngt";
		oParam.method      = "reqGetBills";
		oParam.inds        = "cond=ds_send_data1";
		oParam.outds       = "ds_grid_grd_patlist=getBills";
		oParam.async       = false;
		oParam.callback    = "cbf_SMLLP02000";

	tranf_submit(oParam);
}


// 엑셀 저장
function fExeExcel(pGridId)
{	
	if(pGridId.name == "grd_datagrid1")
	{
		grdf_exportExcel(pGridId, lf_lisGetTitle(this) + "_" + "청구서 상세내역" , "sheet1", false);
	}
	else if(pGridId.name == "grd_datagrid2")
	{
		grdf_exportExcel(pGridId, lf_lisGetTitle(this) + "_" + "부서별청구총액" , "sheet1", false);
	}	
}

// style 설정(Expr)
function lf_setStyle() {
}

// callback 함수
function cbf_SMLLP02000(strSvcID, nErrorCode, strErrorMag)
{	
	if(nErrorCode != 0)
	{
		sysf_messageBox("ID: "+ strSvcID + "  Error: " + strErrorMag, "E009", "");
	}
	else
	{
		switch(strSvcID)
		{
			case "TRLZZ00101":			
					fSet();
					grp_sea.combo4.index = 0;
					grp_sea.combo1.index = 0;
					grp_sea.combo3.index = 0;
					grp_sea.combo2.index = 0;
				break;
			case "TRLLP02001":
					lf_setStyle();
					grd_datagrid2.setCellProperty("Summ", 0, "text", "0");
					
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "sectnm")))
					{
						grd_datagrid2.setCellProperty("Summ", 1, "text", "");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 1, "text", ds_grid_grd_datagrid2.getColumn(0, "sectnm"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "tclscount")))
					{
						grd_datagrid2.setCellProperty("Summ", 2, "text", "0");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 2, "text", ds_grid_grd_datagrid2.getColumn(0, "tclscount"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "totalpay")))
					{
						grd_datagrid2.setCellProperty("Summ", 3, "text", "0");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 3, "text", ds_grid_grd_datagrid2.getColumn(0, "totalpay"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "totalpay2")))
					{
						grd_datagrid2.setCellProperty("Summ", 4, "text", "0");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 4, "text", ds_grid_grd_datagrid2.getColumn(0, "totalpay2"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "margin")))
					{
						grd_datagrid2.setCellProperty("Summ", 5, "text", "0");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 5, "text", ds_grid_grd_datagrid2.getColumn(0, "margin"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "gpay")))
					{
						grd_datagrid2.setCellProperty("Summ", 6, "text", "0");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 6, "text", ds_grid_grd_datagrid2.getColumn(0, "gpay"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid2.getColumn(0, "ipay")))
					{
						grd_datagrid2.setCellProperty("Summ", 7, "text", "0");
					}
					else
					{
						grd_datagrid2.setCellProperty("Summ", 7, "text", ds_grid_grd_datagrid2.getColumn(0, "ipay"));
					}					
					ds_grid_grd_datagrid2.deleteRow(0);
				break;
			case "TRLLP02002":
				break;
			case "TRLLP02003":
					fgetListBills();
					grd_datagrid1.setCellProperty("Summ", 0, "text", "0");
					grd_datagrid1.setCellProperty("Summ", 1, "text", ds_grid_grd_datagrid1.getColumn(0, "tclscd"));					
					
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "sectnm")))
					{
						grd_datagrid1.setCellProperty("Summ", 2, "text", "");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 2, "text", ds_grid_grd_datagrid1.getColumn(0, "sectnm"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "tclsscrnnm")))
					{
						grd_datagrid1.setCellProperty("Summ", 3, "text", "");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 3, "text", ds_grid_grd_datagrid1.getColumn(0, "tclsscrnnm"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "gbn")))
					{
						grd_datagrid1.setCellProperty("Summ", 4, "text", "");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 4, "text", ds_grid_grd_datagrid1.getColumn(0, "gbn"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "pay")))
					{
						grd_datagrid1.setCellProperty("Summ", 5, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 5, "text", ds_grid_grd_datagrid1.getColumn(0, "pay"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "pay2")))
					{
						grd_datagrid1.setCellProperty("Summ", 6, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 6, "text", ds_grid_grd_datagrid1.getColumn(0, "pay2"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "tclscount")))
					{
						grd_datagrid1.setCellProperty("Summ", 7, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 7, "text", ds_grid_grd_datagrid1.getColumn(0, "tclscount"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "totalpay")))
					{
						grd_datagrid1.setCellProperty("Summ", 8, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 8, "text", ds_grid_grd_datagrid1.getColumn(0, "totalpay"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "totalpay2")))
					{
						grd_datagrid1.setCellProperty("Summ", 9, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 9, "text", ds_grid_grd_datagrid1.getColumn(0, "totalpay2"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "margin")))
					{
						grd_datagrid1.setCellProperty("Summ", 10, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 10, "text", ds_grid_grd_datagrid1.getColumn(0, "margin"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "gpay")))
					{
						grd_datagrid1.setCellProperty("Summ", 11, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 11, "text", ds_grid_grd_datagrid1.getColumn(0, "gpay"));
					}
					if(utlf_isNull(ds_grid_grd_datagrid1.getColumn(0, "ipay")))
					{
						grd_datagrid1.setCellProperty("Summ", 12, "text", "0");
					}
					else
					{
						grd_datagrid1.setCellProperty("Summ", 12, "text", ds_grid_grd_datagrid1.getColumn(0, "ipay"));
					}					
					ds_grid_grd_datagrid1.deleteRow(0);
				break;
			default:
				break;
		}
	}
}

//조회버튼
function grp_sea_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	fSetInit();
	fgetListBills1();
}

//청구서 상세내역
function grd_datagrid1_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	fClickResultList();
}

//청구서 상세내역 엑셀 버튼
function btn_excel_onlbuttonup(obj:Button, e:MouseEventInfo)
{
	fExeExcel(grd_datagrid1);					
}

//부서별청구총액 엑셀버튼
function button2_onlbuttonup(obj:Button, e:MouseEventInfo)
{
	fExeExcel(grd_datagrid2);
}

//초기화
function button5_onclick(obj:Button, e:ClickEventInfo)
{
	fSet();
}]]></Script>
  </Form>
</FDL>