YNU_JEUS/app_home/himed/xpapps/mis/slipxp/xp/SPRAD00104_근로소득자료관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPRAD00104" position="absolute 0 0 773 600" titletext="근로소득자료관리" oninit="SPRAD00104_oninit" onload="SPRAD00104_onload">
    <Layouts>
      <Layout>
        <Static id="cpt_title" text="근로소득자료관리" class="tit_1" position="absolute 0 0 190 23"/>
        <Shape id="line3" class="line_2" position="absolute 0 51 765 57"/>
        <Shape id="line9" class="line_3" position="absolute 0 101 765 107"/>
        <Static id="caption47" text="사원번호" class="cell_1" position="absolute 0 30 100 53"/>
        <Shape id="line2" class="line_10" position="absolute 0 25 765 31"/>
        <Static id="caption7" text="적요" class="cell_1" position="absolute 0 79 100 102"/>
        <Static id="caption10" text="지급액" class="cell_1" position="absolute 0 54 100 77"/>
        <Static id="caption13" text="지급일자" class="cell_1" visible="false" position="absolute 491 30 591 53"/>
        <MaskEdit id="ipt_paytotamt" taborder="1" mask="9,99999999" class="input_s_essential" position="absolute 103 57 253 76" onkeyup="ipt_paytotamt_onkeyup" autoselect="true" autoskip="true"/>
        <Edit id="ipt_cmt" taborder="2" class="input_default" position="absolute 103 81 765 100" autoselect="true" autoskip="true" onkeyup="ipt_cmt_onkeyup"/>
        <Shape id="line10" class="line_2" position="absolute 0 76 765 82"/>
        <Edit id="ipt_paydd" taborder="3" class="input_default" enable="false" visible="false" position="absolute 594 32 765 51"/>
        <Grid id="grd_orchlist" taborder="4" binddataset="ds_main_list_orchlist" useinputpanel="false" position="absolute 0 128 765 537" autoenter="select" autofittype="col" cellsizingtype="col" oncellclick="grd_orchlist_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="19"/>
                <Column size="97"/>
                <Column size="0"/>
                <Column size="91"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="106"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="449"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </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"/>
                <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="우편번호1"/>
                <Cell col="19" text="우편번호2"/>
                <Cell col="20" text="우편번호일련번호"/>
                <Cell col="21" text="주소"/>
                <Cell col="22" text="상세주소"/>
                <Cell col="23" text="업종구분"/>
                <Cell col="24" text="소득구분"/>
              </Band>
              <Band id="body">
                <Cell text="bind:instcd"/>
                <Cell col="1" text="bind:seqno"/>
                <Cell col="2" text="bind:detlseqno"/>
                <Cell col="3" text="bind:chrgflag"/>
                <Cell col="4" celltype="head"/>
                <Cell col="5" text="bind:emplno"/>
                <Cell col="6" text="bind:rrgstno" mask="999999-9999999"/>
                <Cell col="7" text="bind:name"/>
                <Cell col="8" text="bind:entrregno" mask="999-99-99999"/>
                <Cell col="9" text="bind:custnm"/>
                <Cell col="10" text="bind:dayno"/>
                <Cell col="11" text="bind:dypay"/>
                <Cell col="12" displaytype="number" text="bind:paytotamt"/>
                <Cell col="13" text="bind:taxrate"/>
                <Cell col="14" text="bind:incmtax" mask="(-)#,###"/>
                <Cell col="15" text="bind:resdntax" mask="(-)#,###"/>
                <Cell col="16" text="bind:cmt"/>
                <Cell col="17" text="bind:zipcd"/>
                <Cell col="18" text="bind:zipcd1"/>
                <Cell col="19" text="bind:zipcd2"/>
                <Cell col="20" text="bind:zipcdseqno"/>
                <Cell col="21" text="bind:supaddr"/>
                <Cell col="22" text="bind:infaddr"/>
                <Cell col="23" displaytype="combo" edittype="combo" text="bind:induflag" enable="false"/>
                <Cell col="24" displaytype="combo" edittype="combo" text="bind:incmflag"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Edit id="input1" taborder="5" class="input_s_essential" visible="false" position="absolute 185 106 215 125"/>
        <Edit id="input2" taborder="6" class="input_s_essential" visible="false" position="absolute 220 106 250 125"/>
        <Edit id="input3" taborder="7" class="input_s_essential" visible="false" position="absolute 255 106 285 125"/>
        <Edit id="input4" taborder="8" class="input_s_essential" visible="false" position="absolute 290 106 320 125"/>
        <Edit id="input5" taborder="9" class="input_s_essential" visible="false" position="absolute 325 106 355 125"/>
        <Edit id="input6" taborder="10" class="input_s_essential" visible="false" position="absolute 360 106 390 125"/>
        <MaskEdit id="ipt_taxrate" taborder="11" mask="(-)#,###%" class="input_default" visible="false" position="absolute 396 107 450 126"/>
        <Button id="btn_grddel" taborder="12" text="행삭제" class="btn2" enable="false" position="absolute 712 107 765 126" onclick="btn_grddel_onclick"/>
        <Button id="btn_grdadd" taborder="13" text="행추가" class="btn2" position="absolute 658 107 711 126" onclick="btn_grdadd_onclick"/>
        <MaskEdit id="output1" taborder="14" readonly="true" position="absolute 654 542 764 561"/>
        <Static id="caption15" text="지급합액 :" position="absolute 593 542 653 562"/>
        <Edit id="ipt_name" taborder="15" class="input_essential" position="absolute 225 32 450 51" onkeyup="ipt_name_onkeyup" autoskip="true" autoselect="true"/>
        <Button id="btn_userhelp" taborder="16" class="icon_search" position="absolute 205 33 221 49" onclick="btn_userhelp_onclick"/>
        <Edit id="ipt_emplno" taborder="17" class="input_essential" position="absolute 103 32 200 51" autoselect="true" autoskip="true" onkeyup="ipt_emplno_onkeyup"/>
        <Button id="btn_excadd" taborder="18" text="엑셀입력" class="btn7" position="absolute 577 107 657 126" onclick="btn_excadd_onclick"/>
        <Grid id="grd_excelload" taborder="19" binddataset="ds_temp_orchlist" useinputpanel="false" visible="false" position="absolute 200 291 760 429">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="150"/>
                <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="비고"/>
              </Band>
              <Band id="body">
                <Cell text="bind:emplno"/>
                <Cell col="1" text="bind:name"/>
                <Cell col="2" text="bind:paytotamt" mask="(-)#,###"/>
                <Cell col="3" text="bind:cmt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button2" taborder="20" text="엑셀양식" class="btn7" position="absolute 496 107 576 126" onclick="button2_onclick"/>
        <Shape id="line1" class="line_6" position="absolute 0 561 765 567"/>
        <Button id="btn_save" taborder="21" text="저장" class="btn4" position="absolute 592 565 648 587" onclick="btn_save_onclick"/>
        <Button id="btn_delete" taborder="22" text="삭제" class="btn4" position="absolute 650 565 706 587" onclick="btn_delete_onclick"/>
        <Button id="btn_close" taborder="23" text="닫기" class="btn4" position="absolute 708 565 764 587" onclick="btn_close_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_hidden_orchreturn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="amt" type="STRING" size="256"/>
          <Column id="etcnotefact" type="STRING" size="256"/>
          <Column id="incmtax" type="STRING" size="256"/>
          <Column id="resdntax" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="amt"/>
            <Col id="etcnotefact"/>
            <Col id="incmtax"/>
            <Col id="resdntax"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_orchlist" 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="seqno" type="STRING" size="256"/>
          <Column id="detlseqno" type="STRING" size="256"/>
          <Column id="chrgflag" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="entrregno" type="STRING" size="256"/>
          <Column id="rrgstno" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
          <Column id="zipcd" type="STRING" size="256"/>
          <Column id="zipcd1" type="STRING" size="256"/>
          <Column id="zipcd2" type="STRING" size="256"/>
          <Column id="zipcdseqno" type="STRING" size="256"/>
          <Column id="supaddr" type="STRING" size="256"/>
          <Column id="infaddr" type="STRING" size="256"/>
          <Column id="induflag" type="STRING" size="256"/>
          <Column id="incmflag" type="STRING" size="256"/>
          <Column id="dayno" type="STRING" size="256"/>
          <Column id="dypay" type="STRING" size="256"/>
          <Column id="paytotamt" type="STRING" size="256"/>
          <Column id="taxrate" type="STRING" size="256"/>
          <Column id="incmtax" type="STRING" size="256"/>
          <Column id="resdntax" type="STRING" size="256"/>
          <Column id="cmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="seqno"/>
            <Col id="detlseqno"/>
            <Col id="chrgflag"/>
            <Col id="emplno"/>
            <Col id="name"/>
            <Col id="entrregno"/>
            <Col id="rrgstno"/>
            <Col id="custnm"/>
            <Col id="zipcd"/>
            <Col id="zipcd1"/>
            <Col id="zipcd2"/>
            <Col id="zipcdseqno"/>
            <Col id="supaddr"/>
            <Col id="infaddr"/>
            <Col id="induflag"/>
            <Col id="incmflag"/>
            <Col id="dayno"/>
            <Col id="dypay"/>
            <Col id="paytotamt"/>
            <Col id="taxrate"/>
            <Col id="incmtax"/>
            <Col id="resdntax"/>
            <Col id="cmt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_orch_one" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_orch_one_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="seqno" type="STRING" size="256"/>
          <Column id="detlseqno" type="STRING" size="256"/>
          <Column id="chrgflag" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="entrregno" type="STRING" size="256"/>
          <Column id="rrgstno" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
          <Column id="zipcd" type="STRING" size="256"/>
          <Column id="zipcd1" type="STRING" size="256"/>
          <Column id="zipcd2" type="STRING" size="256"/>
          <Column id="zipcdseqno" type="STRING" size="256"/>
          <Column id="supaddr" type="STRING" size="256"/>
          <Column id="infaddr" type="STRING" size="256"/>
          <Column id="induflag" type="STRING" size="256"/>
          <Column id="incmflag" type="STRING" size="256"/>
          <Column id="dayno" type="STRING" size="256"/>
          <Column id="dypay" type="STRING" size="256"/>
          <Column id="paytotamt" type="STRING" size="256"/>
          <Column id="taxrate" type="STRING" size="256"/>
          <Column id="incmtax" type="STRING" size="256"/>
          <Column id="resdntax" type="STRING" size="256"/>
          <Column id="cmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="seqno"/>
            <Col id="detlseqno"/>
            <Col id="chrgflag"/>
            <Col id="emplno"/>
            <Col id="name"/>
            <Col id="entrregno"/>
            <Col id="rrgstno"/>
            <Col id="custnm"/>
            <Col id="zipcd"/>
            <Col id="zipcd1"/>
            <Col id="zipcd2"/>
            <Col id="zipcdseqno"/>
            <Col id="supaddr"/>
            <Col id="infaddr"/>
            <Col id="induflag"/>
            <Col id="incmflag"/>
            <Col id="dayno"/>
            <Col id="dypay"/>
            <Col id="paytotamt"/>
            <Col id="taxrate"/>
            <Col id="incmtax"/>
            <Col id="resdntax"/>
            <Col id="cmt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_orch" 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="seqno" type="STRING" size="256"/>
          <Column id="chrgflag" type="STRING" size="256"/>
          <Column id="unsldd" type="STRING" size="256"/>
          <Column id="unslno" type="STRING" size="256"/>
          <Column id="undeciseqno" type="STRING" size="256"/>
          <Column id="paydd" type="STRING" size="256"/>
          <Column id="status" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="seqno"/>
            <Col id="chrgflag"/>
            <Col id="unsldd"/>
            <Col id="unslno"/>
            <Col id="undeciseqno"/>
            <Col id="paydd"/>
            <Col id="status"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_orchlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <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_retrparams" 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="seqno" type="STRING" size="256"/>
          <Column id="chrgflag" type="STRING" size="256"/>
          <Column id="detlseqno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="seqno"/>
            <Col id="chrgflag"/>
            <Col id="detlseqno"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="incmpsn" type="STRING" size="256"/>
          <Column id="totamt" type="STRING" size="256"/>
          <Column id="maxdetlseqno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="incmpsn"/>
            <Col id="totamt"/>
            <Col id="maxdetlseqno">0000</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_orch_one" 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="seqno" type="STRING" size="256"/>
          <Column id="detlseqno" type="STRING" size="256"/>
          <Column id="chrgflag" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="entrregno" type="STRING" size="256"/>
          <Column id="rrgstno" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
          <Column id="zipcd" type="STRING" size="256"/>
          <Column id="zipcd1" type="STRING" size="256"/>
          <Column id="zipcd2" type="STRING" size="256"/>
          <Column id="zipcdseqno" type="STRING" size="256"/>
          <Column id="supaddr" type="STRING" size="256"/>
          <Column id="infaddr" type="STRING" size="256"/>
          <Column id="induflag" type="STRING" size="256"/>
          <Column id="incmflag" type="STRING" size="256"/>
          <Column id="dayno" type="STRING" size="256"/>
          <Column id="dypay" type="STRING" size="256"/>
          <Column id="paytotamt" type="STRING" size="256"/>
          <Column id="taxrate" type="STRING" size="256"/>
          <Column id="incmtax" type="STRING" size="256"/>
          <Column id="resdntax" type="STRING" size="256"/>
          <Column id="cmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="seqno"/>
            <Col id="detlseqno"/>
            <Col id="chrgflag"/>
            <Col id="emplno"/>
            <Col id="name"/>
            <Col id="entrregno"/>
            <Col id="rrgstno"/>
            <Col id="custnm"/>
            <Col id="zipcd"/>
            <Col id="zipcd1"/>
            <Col id="zipcd2"/>
            <Col id="zipcdseqno"/>
            <Col id="supaddr"/>
            <Col id="infaddr"/>
            <Col id="induflag"/>
            <Col id="incmflag"/>
            <Col id="dayno"/>
            <Col id="dypay"/>
            <Col id="paytotamt"/>
            <Col id="taxrate"/>
            <Col id="incmtax"/>
            <Col id="resdntax"/>
            <Col id="cmt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_seqno" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="seqno" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="output1" propid="value" datasetid="ds_hidden_orchreturn" columnid="amt"/>
      <BindItem id="item1" compid="ipt_emplno" propid="value" datasetid="ds_main_orch_one" columnid="emplno"/>
      <BindItem id="item2" compid="ipt_name" propid="value" datasetid="ds_main_orch_one" columnid="name"/>
      <BindItem id="item3" compid="ipt_paydd" propid="value" datasetid="ds_main_list_orch" columnid="paydd"/>
      <BindItem id="item4" compid="ipt_paytotamt" propid="value" datasetid="ds_main_orch_one" columnid="paytotamt"/>
      <BindItem id="item5" compid="ipt_cmt" propid="value" datasetid="ds_main_orch_one" columnid="cmt"/>
      <BindItem id="item6" compid="input1" propid="value" datasetid="ds_main_list_orch" columnid="instcd"/>
      <BindItem id="item7" compid="input2" propid="value" datasetid="ds_main_list_orch" columnid="seqno"/>
      <BindItem id="item8" compid="input4" propid="value" datasetid="ds_main_list_orch" columnid="unsldd"/>
      <BindItem id="item9" compid="input3" propid="value" datasetid="ds_main_list_orch" columnid="chrgflag"/>
      <BindItem id="item10" compid="input5" propid="value" datasetid="ds_main_list_orch" columnid="unslno"/>
      <BindItem id="item11" compid="input6" propid="value" datasetid="ds_main_list_orch" columnid="undeciseqno"/>
      <BindItem id="item12" compid="ipt_taxrate" propid="value" datasetid="ds_main_orch_one" columnid="taxrate"/>
    </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";
function SPRAD00104_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPRAD00104_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_orchlist);
	grdf_setRowTypeIcon(grd_orchlist, 4);
	
	try
	{
		ds_target_slipinfo.copyData(arg_target_slipinfo)
		ds_target.copyData(arg_target)
	}
	catch(e)
	{
	}
	
	fInitialize();
}

function fInitialize() 
{
	ds_main_list_orchlist.clearData();
	
	var instcd = sysf_getUserInfo("dutplceinstcd");
	
	if(ds_target_slipinfo.getColumn(0, "profflag") == "8")
	{
		this.titletext = "비과세 근로소득자료관리";
		cpt_title.text = "비과세 근로소득자료관리";
	}
	
	if(!utlf_isNull(ds_target_slipinfo.getColumn(0, "seqno")))
	{
		ds_send_retrparams.setColumn(0, "instcd", ds_target_slipinfo.getColumn(0, "instcd"));
		ds_send_retrparams.setColumn(0, "seqno", ds_target_slipinfo.getColumn(0, "seqno"));
		ds_send_retrparams.setColumn(0, "chrgflag", ds_target_slipinfo.getColumn(0, "profflag"));
		
		fSearch();
	} 
	else 
	{
		ds_main_list_orch.setColumn(0, "instcd", ds_target_slipinfo.getColumn(0, "instcd"));
		ds_main_list_orch.setColumn(0, "unsldd", ds_target_slipinfo.getColumn(0, "unsldd"));
		ds_main_list_orch.setColumn(0, "unslno", ds_target_slipinfo.getColumn(0, "unslno"));
		ds_main_list_orch.setColumn(0, "undeciseqno", ds_target_slipinfo.getColumn(0, "unslseqno"));
		ds_main_list_orch.setColumn(0, "chrgflag", ds_target_slipinfo.getColumn(0, "profflag"));
		
		ds_main_orch_one.setColumn(0, "instcd", ds_target_slipinfo.getColumn(0, "instcd"));
		ds_main_orch_one.setColumn(0, "chrgflag", ds_target_slipinfo.getColumn(0, "profflag"));
		ds_main_orch_one.setColumn(0, "detlseqno", "0001");
		
		ds_hidden.setColumn(0, "maxdetlseqno", "0000");
		
		ds_main_list_orch.setColumn(0, "status", "i");
		ds_main_orch_one.setColumn(0, "emplno", ds_target_slipinfo.getColumn(0, "emplno"));
		ds_main_orch_one.setColumn(0, "cmt", ds_target_slipinfo.getColumn(0, "cmt"));
	}
	
	if(ds_target_slipinfo.getColumn(0, "readonly") == "Y")
	{
		btn_grdadd.enable = false;
		btn_save.enable = false;
		btn_delete.enable = false;
	}					
	ipt_name.setFocus();
}

function ipt_emplno_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		ipt_paytotamt.setFocus();
	}
}

function ds_main_orch_one_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "emplno")
	{
		ipt_emplno.value = e.newvalue;
		ipt_emplno.setFocus();
		misfValidationCheck("49", "", "emplno,name", "", "", "code","");
	}
	
	if(e.columnid == "name")
	{
		ipt_name.value = e.newvalue;
		ipt_name.setFocus();
		misfValidationCheck("49", "", "emplno,name", "", "", "code","");
	}
}

function btn_userhelp_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("49", ds_main_orch_one, "", "emplno,name");
	
	ipt_paytotamt.setFocus();
}

function ipt_name_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		ipt_paytotamt.setFocus();
	}
}

function ipt_paytotamt_onkeyup(obj:MaskEdit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		ipt_cmt.setFocus();
	}
}

function ipt_cmt_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		btn_grdadd.setFocus();
	}
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_excelload, "excel", "see", false);
}

function btn_excadd_onclick(obj:Button,  e:ClickEventInfo)
{
	var grd_orchlist_rows = ds_main_list_orchlist.rowcount;
	
	var bfrows = ds_temp_orchlist.rowcount;

	grdf_exportExcel(grd_excelload, "excel", "see", false);
	
	if(ds_temp_orchlist.rowcount == bfrows)
	{
		return;
	}
	
	var rowlevel = 0;
	var grd_excelload_fixedRows = 0;
	var grd_excelload_rows = ds_temp_orchlist.rowcount;
	
	for(var i = grd_excelload_fixedRows ; i < grd_excelload_rows ; i++)
	{					
		var valflag = true;
						
		if(utlf_isNull(ds_temp_orchlist.getColumn(rowlevel, "emplno")))
		{	
			valflag = false;
		}
		
		if(utlf_isNull(ds_temp_orchlist.getColumn(rowlevel, "name")))
		{
			valflag = false;
		}							
		
		if(utlf_isNull(ds_temp_orchlist.getColumn(rowlevel, "paytotamt")))
		{
			valflag = false;
		}
		
		if(utlf_isNull(ds_temp_orchlist.getColumn(rowlevel, "cmt")))
		{
		}
								
		if(valflag == false)
		{
			ds_temp_orchlist.deleteRow(rowlevel);
		}
		else
		{
			rowlevel += 1;
		}
	}
	
	ds_hidden.setColumn(0, "maxdetlseqno", "0001");
	
	for(var i = 0; i < ds_temp_orchlist.rowcount; i++)
	{
		var addRow = ds_main_list_orchlist.addRow();
		
		ds_main_list_orchlist.setColumn(addRow, "instcd", ds_main_orch_one.getColumn(0, "instcd"));
		ds_main_list_orchlist.setColumn(addRow, "detlseqno", ds_hidden.getColumn(0, "maxdetlseqno"));
		ds_main_list_orchlist.setColumn(addRow, "chrgflag", ds_main_orch_one.getColumn(0, "chrgflag"));
		
		ds_main_list_orchlist.setColumn(addRow, "emplno", ds_temp_orchlist.getColumn(i, "emplno"));
		ds_main_list_orchlist.setColumn(addRow, "name", ds_temp_orchlist.getColumn(i, "name"));
		ds_main_list_orchlist.setColumn(addRow, "paytotamt", ds_temp_orchlist.getColumn(i, "paytotamt"));
		ds_main_list_orchlist.setColumn(addRow, "cmt", ds_temp_orchlist.getColumn(i, "cmt"));
		fExcelGetfSeqno();
	}
	
	ds_main_orch_one.setColumn(0, "detlseqno", ds_hidden.getColumn(0, "maxdetlseqno"));
}

function fExcelGetfSeqno()
{
	var detlseqno = ds_hidden.getColumn(0, "maxdetlseqno");
	var seqno = parseInt(detlseqno, 10);

	seqno++;
	
	ds_hidden.setColumn(0, "maxdetlseqno", seqno.toString().getLeftPad(4,"0"));
}

function btn_grdadd_onclick(obj:Button,  e:ClickEventInfo)
{
	fGridRowAddClick();	
}

function btn_grddel_onclick(obj:Button,  e:ClickEventInfo)
{
	fGridRowDelClick();
}

function fGridRowAddClick()
{
	var detlseq = ds_main_orch_one.getColumn(0, "detlseqno");
	var detlseqno = ds_main_list_orchlist.lookup("detlseqno", detlseq, "detlseqno");
	var cur_row = ds_main_list_orchlist.rowposition;
	
	if(fNotNullCheck() == false) 
	{
		return;
	}
	
	if (utlf_isNull(detlseqno))
	{
		ds_main_list_orchlist.addRow();
	} 
	else 
	{
		ds_main_list_orchlist.updatecontrol = false;
		ds_main_list_orchlist.setRowType(cur_row, "u");
		ds_main_list_orchlist.updatecontrol = true;
	}
	
	ds_main_list_orchlist.copyRow(ds_main_list_orchlist.rowposition, ds_main_orch_one, 0);
	
	var maxdetlseqno = ds_hidden.getColumn(0, "maxdetlseqno");
	
	if (parseInt(maxdetlseqno,10) < parseInt(detlseq,10)) 
	{
		ds_hidden.setColumn(0, "maxdetlseqno", detlseq);
	}
	fRowClearClick(); 
}

function fGridRowDelClick()
{
	var rowstat;
	var i, j=0;

	ds_main_list_orchlist.updatecontrol = false;
	ds_main_list_orchlist.setRowType(ds_main_list_orchlist.rowposition, "d");
	ds_main_list_orchlist.updatecontrol = true;
	
	for (var i = 0; i < ds_main_list_orchlist.rowcount; i++) 
	{
		rowstat = parseInt(ds_main_list_orchlist.getRowType(i),10);
		if (rowstat >= 4) 
		{
			j++;
		}
	}
	
	if (j == ds_main_list_orchlist.rowcount - 1) 
	{
		ds_main_list_orch.setColumn(0, "status", "d");
	} 
	else 
	{
		ds_main_list_orch.setColumn(0, "status", "u");
	}
	fRowClearClick();
}

function fNotNullCheck() 
{
	if(String(ds_main_orch_one.getColumn(0, "emplno")).length == 0)
	{
		sysf_messageBox("사원번호는" ,"I003");
		ipt_emplno.setFocus();
		return false;
	}
	
	if(String(ds_main_orch_one.getColumn(0, "name")).length == 0)
	{
		sysf_messageBox("성명은" ,"I003");
		ipt_name.setFocus();
		return false;
	}
	
	if(String(ds_main_orch_one.getColumn(0, "paytotamt")).length == 0)
	{
		sysf_messageBox("지급액은" ,"I003");
		ipt_paytotamt.setFocus();
		return false;
	}
}

	
function fRowClearClick() 
{
	var cmt = ds_main_orch_one.getColumn(0, "cmt");
	
	ds_main_orch_one.clearData();
	ds_main_orch_one.addRow();
	
	ds_main_orch_one.copyRow(0, ds_hidden_orch_one, 0);
	
	fIncreSeqno(ds_main_orch_one);
	
	ds_main_orch_one.setColumn(0, "instcd", ds_main_list_orch.getColumn(0, "instcd"));
	ds_main_orch_one.setColumn(0, "seqno", ds_main_list_orch.getColumn(0, "seqno"));
	ds_main_orch_one.setColumn(0, "chrgflag", ds_main_list_orch.getColumn(0, "chrgflag"));
	ds_main_orch_one.setColumn(0, "cmt", cmt);
	
	btn_grddel.enable = false;
	ipt_name.setFocus();
}

function fIncreSeqno(pRef) 
{
	var detlseqno = ds_hidden.getColumn(0, "maxdetlseqno");
	var seqno = parseInt(detlseqno, 10);
	
	seqno++;
	
	pRef.setColumn(0, "detlseqno", seqno.toString().getLeftPad(4,"0"));
}

function grd_orchlist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	fGridRowClick();
}

function fGridRowClick() 
{
	var cur_row = ds_main_list_orchlist.rowposition;
	
	ds_main_orch_one.clearData();
	ds_main_orch_one.addRow();
	
	ds_main_orch_one.copyRow(0, ds_main_list_orchlist, cur_row);
	
	btn_grddel.enable = true;
	
	ipt_paytotamt.setFocus();
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	fSave();
}

function fSave() 
{
	var updtdata = grdf_getGridUpdateData(grd_orchlist).rowcount;
	if (updtdata == 0) 
	{
		sysf_messageBox("변경된 데이터가","I004");
		return;
	}
	
	var oParam = {};
		oParam.id          = "TXRAD00105";
		oParam.service     = "slipapp.Slip";
		oParam.method      = "reqExeSaveOrch";
		oParam.inds        = "req=ds_main_list_orch req1=ds_main_list_orchlist:u";
		oParam.outds       = "ds_temp_seqno=seqno";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAD00105";

	tranf_submit(oParam);

	ipt_name.setFocus();
}

function cf_TXRAD00105(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		if(!utlf_isNull(ds_temp_seqno.getColumn(0, "seqno")))
		{
			ds_send_retrparams.setColumn(0, "instcd", ds_main_list_orch.getColumn(0, "instcd"));
			ds_send_retrparams.setColumn(0, "seqno", ds_temp_seqno.getColumn(0, "seqno"));
			ds_send_retrparams.setColumn(0, "chrgflag", ds_main_list_orch.getColumn(0, "chrgflag"));
			fSearch();
		} 
		else 
		{
			ds_main_list_orchlist.clearData();
			
			ds_main_list_orch.setColumn(0, "instcd", ds_target_slipinfo.getColumn(0, "instcd"));
			ds_main_list_orch.setColumn(0, "seqno", "");
			ds_main_list_orch.setColumn(0, "unsldd", ds_target_slipinfo.getColumn(0, "unsldd"));
			ds_main_list_orch.setColumn(0, "unslno", ds_target_slipinfo.getColumn(0, "unslno"));
			//ds_main_list_orch.setColumn(0, "undeciseqno", ds_target_slipinfo.getColumn(0, "undeciseqno"));
			ds_main_list_orch.setColumn(0, "chrgflag", ds_target_slipinfo.getColumn(0, "profflag"));
			ds_main_list_orch.setColumn(0, "status", "i");
			ds_hidden.setColumn(0, "maxdetlseqno", "0000");
			fRowClearClick();
		}
		
		var rowcnt = ds_main_list_orchlist.rowcount;
		
		if (rowcnt > 0) 
		{
			if (rowcnt > 1) 
			{
				var cmt = ds_main_list_orchlist.getColumn(0, "cmt")+ " (" + ds_main_list_orchlist.getColumn(0, "name") + " 외 " + (rowcnt) + "명)";
				ds_hidden_orchreturn.setColumn(0, "etcnotefact", cmt);
			} 
			else 
			{
				ds_hidden_orchreturn.setColumn(0, "etcnotefact", ds_main_list_orchlist.getColumn(0, "cmt"));
			}
		} 
		else 
		{
			ds_hidden_orchreturn.setColumn(0, "etcnotefact", "");
		}
		
		var receiveref = eval("opener."+ ds_target.getColumn(0, "receiveref"));
		
		if (frmf_checkOpener())
		{
			receiveref.setColumn(0, "seqno", ds_temp_seqno.getColumn(0, "seqno"));
			receiveref.setColumn(0, "amt", ds_main_orch_one.getColumn(0, "paytotamt"));
			receiveref.setColumn(0, "etcnotefact", ds_hidden_orchreturn.getColumn(0, "etcnotefact"));
			receiveref.setColumn(0, "incmtax", ds_hidden_orchreturn.getColumn(0, "incmtax"));
			receiveref.setColumn(0, "resdntax", ds_hidden_orchreturn.getColumn(0, "resdntax"));
			sysf_messageBox("저장이 " ,"I002");
		}
		else
		{
			sysf_messageBox("상위화면이 변경되어 데이터를 전달할 수 ", "I004");
		}				
	}
}

function fSearch() 
{
	var oParam = {};
		oParam.id          = "TRRAD00105";
		oParam.service     = "slipapp.Slip";
		oParam.method      = "reqGetOrch";
		oParam.inds        = "req=ds_send_retrparams";
		oParam.outds       = "ds_main_list_orch=orch ds_main_list_orchlist=orchlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAD00105";

	tranf_submit(oParam);
	
	if(ds_main_list_orchlist.rowcount == 0)
	{
		dsf_makeValue(ds_main_list_orch, "instcd", "string", ds_target_slipinfo.getColumn(0, "instcd"), 0);
		dsf_makeValue(ds_main_list_orch, "unsldd", "string", ds_target_slipinfo.getColumn(0, "unsldd"), 0);
		dsf_makeValue(ds_main_list_orch, "unslno", "string", ds_target_slipinfo.getColumn(0, "unslno"), 0);
		dsf_makeValue(ds_main_list_orch, "undeciseqno", "string", ds_target_slipinfo.getColumn(0, "unslseqno"), 0);
		dsf_makeValue(ds_main_list_orch, "chrgflag", "string", ds_target_slipinfo.getColumn(0, "profflag"), 0);
		dsf_makeValue(ds_main_list_orch, "status", "string", "i", 0);
		
		dsf_makeValue(ds_main_orch_one, "instcd", "string", ds_target_slipinfo.getColumn(0, "instcd"), 0);
		dsf_makeValue(ds_main_orch_one, "chrgflag", "string", ds_target_slipinfo.getColumn(0, "profflag"), 0);
		dsf_makeValue(ds_main_orch_one, "detlseqno", "string", "0001", 0);
		
		ds_hidden.setColumn(0, "maxdetlseqno", "0000");
	}
	else
	{
		var rowCnt = ds_main_list_orchlist.rowcount-1;

		ds_hidden.setColumn(0, "maxdetlseqno", ds_main_list_orchlist.getColumn(rowCnt, "detlseqno"));
		dsf_makeValue(ds_main_list_orch, "status", "string", "u", 0);
		
		fIncreSeqno(ds_main_orch_one);
		
		ds_main_orch_one.setColumn(0, "instcd", ds_main_list_orch.getColumn(0, "instcd"));
		ds_main_orch_one.setColumn(0, "seqno", ds_main_list_orch.getColumn(0, "seqno"));
		ds_main_orch_one.setColumn(0, "chrgflag", ds_main_list_orch.getColumn(0, "chrgflag"));
	}
}

function btn_close_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}

function btn_delete_onclick(obj:Button,  e:ClickEventInfo)
{
	fDelete();
}

function fDelete() 
{
	if (sysf_messageBox("전체 내역을","Q001") == "6") 
	{
		var rowCnt = ds_main_list_orchlist.rowcount;
		
		ds_main_list_orchlist.updatecontrol = false;
		for (var i = 0; i < rowCnt; i++) 
		{
			ds_main_list_orchlist.setRowType(i, "d");
		}
		ds_main_list_orchlist.updatecontrol = true;
		
		ds_main_list_orch.setColumn(0, "status", "d");
		fSave();						
	}
}]]></Script>
  </Form>
</FDL>