YNU_JEUS/app_home/himed/xpapps/mis/acntbaseinfoxp/xp/SPRAC00610_거래처Excel입력.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPRAC00610" position="absolute 0 0 1197 780" titletext="거래처Excel입력" onload="SPRAC00610_onload">
    <Layouts>
      <Layout>
        <Div id="Div00" taborder="1" position="absolute 0 25 832 85" class="div_SA"/>
        <Div position="absolute 0 25 1195 778" id="group2" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout>
              <Shape position="absolute 0 60 1195 66" id="line2" class="line_10" anchor="left top right"/>
              <Grid position="absolute 0 65 1195 297" id="grd_custchecklist" binddataset="ds_hidden_list_custchecklist" anchor="left top right">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25" band="left"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <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="우편번호1"/>
                      <Cell col="13" text="우편번호2"/>
                      <Cell col="14" text="우편번호일련번호"/>
                      <Cell col="15" text="상위주소"/>
                      <Cell col="16" text="하위주소"/>
                      <Cell col="17" text="전화번호"/>
                      <Cell col="18" text="팩스번호"/>
                      <Cell col="19" text="은행코드"/>
                      <Cell col="20" text="예금주"/>
                      <Cell col="21" text="계좌번호"/>
                      <Cell col="22" text="이메일주소"/>
                      <Cell col="23" text="홈페이지주소"/>
                      <Cell col="24" text="승계구사업자등록번호"/>
                      <Cell col="25" text="지불조건"/>
                      <Cell col="26" text="회계담당자명"/>
                      <Cell col="27" text="회계담당자전화번호"/>
                      <Cell col="28" text="회계담당자휴대폰번호"/>
                      <Cell col="29" text="회계담당자이메일주소"/>
                      <Cell col="30" text="거래상태"/>
                      <Cell col="31" text="비고"/>
                      <Cell col="32" text="법인명"/>
                      <Cell col="33" text="출력순서"/>
                      <Cell col="34" text="압류여부"/>
                      <Cell col="35" text="유효여부"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head"/>
                      <Cell col="1" displaytype="text" text="bind:entrregno"/>
                      <Cell col="2" displaytype="text" text="bind:custnm"/>
                      <Cell col="3" displaytype="text" text="bind:fromdd"/>
                      <Cell col="4" displaytype="text" text="bind:todd"/>
                      <Cell col="5" displaytype="text" text="bind:prsdnm"/>
                      <Cell col="6" displaytype="text" text="bind:rrgstno"/>
                      <Cell col="7" displaytype="text" text="bind:bizcont"/>
                      <Cell col="8" displaytype="text" text="bind:item"/>
                      <Cell col="9" displaytype="text" text="bind:mainbizitem"/>
                      <Cell col="10" displaytype="text" text="bind:custflag"/>
                      <Cell col="11" displaytype="text" text="bind:instflag"/>
                      <Cell col="12" displaytype="text" text="bind:zipcd1"/>
                      <Cell col="13" displaytype="text" text="bind:zipcd2"/>
                      <Cell col="14" displaytype="text" text="bind:zipcdseqno"/>
                      <Cell col="15" displaytype="text" text="bind:supaddr"/>
                      <Cell col="16" displaytype="text" text="bind:infaddr"/>
                      <Cell col="17" displaytype="text" text="bind:cntctel"/>
                      <Cell col="18" displaytype="text" text="bind:faxno"/>
                      <Cell col="19" displaytype="text" text="bind:bankcd"/>
                      <Cell col="20" displaytype="text" text="bind:depor"/>
                      <Cell col="21" displaytype="text" text="bind:aactno"/>
                      <Cell col="22" displaytype="text" text="bind:emailaddr"/>
                      <Cell col="23" displaytype="text" text="bind:homepgaddr"/>
                      <Cell col="24" displaytype="text" text="bind:oldentrregno"/>
                      <Cell col="25" displaytype="text" text="bind:paycond"/>
                      <Cell col="26" displaytype="text" text="bind:acntchrgnm"/>
                      <Cell col="27" displaytype="text" text="bind:acntchrgtelno"/>
                      <Cell col="28" displaytype="text" text="bind:acntchrgmpphonno"/>
                      <Cell col="29" displaytype="text" text="bind:acntchrgemailaddr"/>
                      <Cell col="30" displaytype="text" text="bind:custstat"/>
                      <Cell col="31" displaytype="text" text="bind:cmt"/>
                      <Cell col="32" displaytype="text" text="bind:cmpynm"/>
                      <Cell col="33" displaytype="text" text="bind:prntseqno"/>
                      <Cell col="34" displaytype="text" text="bind:seizureyn"/>
                      <Cell col="35" displaytype="checkbox" edittype="checkbox" text="bind:validyn"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button position="absolute 977 32 1019 54" id="btn_excel" class="btn2" taborder="-1" text="검사" anchor="default" onclick="group2_btn_excel_onclick"/>
              <Button position="absolute 977 8 1090 30" id="button1" class="btn7" taborder="-1" text="Excel 불러오기" anchor="default" onclick="group2_button1_onclick"/>
              <Button position="absolute 1135 8 1191 30" id="btn_save" class="btn4" enable="false" taborder="-1" text="저장" anchor="default" onclick="group2_btn_save_onclick"/>
              <Grid position="absolute 0 302 1195 753" id="grd_custlist" binddataset="ds_main_list_custlist" anchor="all">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25" band="left"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                      <Column size="100"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <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="우편번호1"/>
                      <Cell col="13" text="우편번호2"/>
                      <Cell col="14" text="우편번호일련번호"/>
                      <Cell col="15" text="상위주소"/>
                      <Cell col="16" text="하위주소"/>
                      <Cell col="17" text="전화번호"/>
                      <Cell col="18" text="팩스번호"/>
                      <Cell col="19" text="은행코드"/>
                      <Cell col="20" text="예금주"/>
                      <Cell col="21" text="계좌번호"/>
                      <Cell col="22" text="이메일주소"/>
                      <Cell col="23" text="홈페이지주소"/>
                      <Cell col="24" text="승계구사업자등록번호"/>
                      <Cell col="25" text="지불조건"/>
                      <Cell col="26" text="회계담당자명"/>
                      <Cell col="27" text="회계담당자전화번호"/>
                      <Cell col="28" text="회계담당자휴대폰번호"/>
                      <Cell col="29" text="회계담당자이메일주소"/>
                      <Cell col="30" text="거래상태"/>
                      <Cell col="31" text="비고"/>
                      <Cell col="32" text="법인명"/>
                      <Cell col="33" text="출력순서"/>
                      <Cell col="34" text="압류여부"/>
                      <Cell col="35" text="유효여부"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head"/>
                      <Cell col="1" displaytype="text" text="bind:entrregno"/>
                      <Cell col="2" displaytype="text" text="bind:custnm"/>
                      <Cell col="3" displaytype="text" text="bind:fromdd"/>
                      <Cell col="4" displaytype="text" text="bind:todd"/>
                      <Cell col="5" displaytype="text" text="bind:prsdnm"/>
                      <Cell col="6" displaytype="text" text="bind:rrgstno"/>
                      <Cell col="7" displaytype="text" text="bind:bizcont"/>
                      <Cell col="8" displaytype="text" text="bind:item"/>
                      <Cell col="9" displaytype="text" text="bind:mainbizitem"/>
                      <Cell col="10" displaytype="text" text="bind:custflag"/>
                      <Cell col="11" displaytype="text" text="bind:instflag"/>
                      <Cell col="12" displaytype="text" text="bind:zipcd1"/>
                      <Cell col="13" displaytype="text" text="bind:zipcd2"/>
                      <Cell col="14" displaytype="text" text="bind:zipcdseqno"/>
                      <Cell col="15" displaytype="text" text="bind:supaddr"/>
                      <Cell col="16" displaytype="text" text="bind:infaddr"/>
                      <Cell col="17" displaytype="text" text="bind:cntctel"/>
                      <Cell col="18" displaytype="text" text="bind:faxno"/>
                      <Cell col="19" displaytype="text" text="bind:bankcd"/>
                      <Cell col="20" displaytype="text" text="bind:depor"/>
                      <Cell col="21" displaytype="text" text="bind:aactno"/>
                      <Cell col="22" displaytype="text" text="bind:emailaddr"/>
                      <Cell col="23" displaytype="text" text="bind:homepgaddr"/>
                      <Cell col="24" displaytype="text" text="bind:oldentrregno"/>
                      <Cell col="25" displaytype="text" text="bind:paycond"/>
                      <Cell col="26" displaytype="text" text="bind:acntchrgnm"/>
                      <Cell col="27" displaytype="text" text="bind:acntchrgtelno"/>
                      <Cell col="28" displaytype="text" text="bind:acntchrgmpphonno"/>
                      <Cell col="29" displaytype="text" text="bind:acntchrgemailaddr"/>
                      <Cell col="30" displaytype="text" text="bind:custstat"/>
                      <Cell col="31" displaytype="text" text="bind:cmt"/>
                      <Cell col="32" displaytype="text" text="bind:cmpynm"/>
                      <Cell col="33" displaytype="text" text="bind:prntseqno"/>
                      <Cell col="34" displaytype="text" text="bind:seizureyn"/>
                      <Cell col="35" displaytype="text" text="bind:statflag"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Shape position="absolute 0 297 1195 303" id="line1" class="line_10" anchor="left top right"/>
              <Button position="absolute 840 8 975 30" id="button2" class="btn7" taborder="-1" text="Excel 출력(오류분)" anchor="default" onclick="group2_button2_onclick"/>
              <Button position="absolute 840 32 975 54" id="button3" class="btn7" taborder="-1" text="Excel 출력(입력분)" anchor="default" onclick="group2_button3_onclick"/>
              <Button position="absolute 520 11 536 27" align="align:center middle;" id="btn_regnohelp" class="icon_search" taborder="11" text="" anchor="default" onclick="group2_btn_regnohelp_onclick"/>
              <Edit position="absolute 540 9 685 28" id="ipt_custnm" class="input_essential" taborder="12" anchor="default" onkeydown="group2_ipt_custnm_onkeydown"/>
              <Static text="최초입력일자   :" position="absolute 280 34 414 51" id="caption12" class="search_name" anchor="default"/>
              <Static text="~" position="absolute 522 35 542 50" id="caption13" anchor="default"/>
              <Static text="사업자등록번호 :" position="absolute 280 10 405 27" id="caption5" class="search_name" anchor="default"/>
              <Calendar position="absolute 540 33 645 52" id="ipt_inserttodd" class="input_essential" anchor="default"/>
              <MaskEdit position="absolute 409 9 514 28" align="align:center middle;" id="ipt_entrregno" class="input_essential" taborder="10" mask="999-99-99999" anchor="default" onkeydown="group2_ipt_entrregno_onkeydown"/>
              <Calendar position="absolute 409 33 514 52" id="ipt_insertfromdd" class="input_essential" anchor="default"/>
              <Combo position="absolute 95 9 270 28" id="cmb_instcd" class="combo_essential" taborder="1" anchor="default"/>
              <Static text="복사기관 :" position="absolute 6 10 92 27" id="caption14" class="search_name" anchor="default"/>
              <Button position="absolute 706 20 762 42" id="btn_search" class="btn1" taborder="15" text="조회" anchor="default" onclick="group2_btn_search_onclick"/>
              <Combo position="absolute 95 33 270 52" id="cmb_insertinstcd" class="combo_essential" enable="false" taborder="1" anchor="default"/>
              <Static text="기     관 :" position="absolute 6 34 92 51" id="caption1" class="search_name" anchor="default"/>
              <Button position="absolute 764 20 820 42" id="button4" class="btn4" taborder="-1" text="복사" anchor="default" onclick="group2_button4_onclick"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 692 11 698 52"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="거래처 Excel 입력" class="tit_1" position="absolute 0 0 160 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_condition" 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="entrregno" type="STRING" size="256"/>
          <Column id="custnm" type="STRING" size="256"/>
          <Column id="insertfromdd" type="STRING" size="256"/>
          <Column id="inserttodd" type="STRING" size="256"/>
          <Column id="insertinstcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="entrregno"/>
            <Col id="custnm"/>
            <Col id="insertfromdd">20080301</Col>
            <Col id="inserttodd"/>
            <Col id="insertinstcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_list_custchecklist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
      <Dataset id="ds_send_list_custlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="temp" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo/>
      </Dataset>
      <Dataset id="ds_main_list_custlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep"/>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="init" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="init"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_custnm" propid="value" datasetid="ds_send_condition" columnid="custnm"/>
      <BindItem id="item1" compid="group2.ipt_inserttodd" propid="value" datasetid="ds_send_condition" columnid="inserttodd"/>
      <BindItem id="item2" compid="group2.ipt_entrregno" propid="value" datasetid="ds_send_condition" columnid="entrregno"/>
      <BindItem id="item3" compid="group2.ipt_insertfromdd" propid="value" datasetid="ds_send_condition" columnid="insertfromdd"/>
      <BindItem id="item4" compid="group2.cmb_instcd" propid="value" datasetid="ds_send_condition" columnid="instcd"/>
      <BindItem id="item5" compid="group2.cmb_insertinstcd" propid="value" datasetid="ds_send_condition" columnid="insertinstcd"/>
    </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                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::RSZ001.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_acntcommonxp::RAD001.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Argument			: N/A
 * Description		: 초기화
 ****************************************************************************************/
function fInitialize() {
	ds_hidden_list_custchecklist.clearData();
	ds_main_list_custlist.clearData();

	misfComboComCdList("Z0007", group2.cmb_instcd,   "N");
	group2.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");

	misfComboComCdList("Z0007", group2.cmb_insertinstcd,   "N");
	group2.cmb_insertinstcd.value = sysf_getUserInfo("dutplceinstcd");

	group2.ipt_inserttodd.value = utlf_getCurrentDate().toString();
}

/****************************************************************************************
 * Argument			: N/A
 * Description		: 저장
 ****************************************************************************************/
function fSave() 
{
	var dsUpdate = grdf_getGridUpdateData(group2.grd_custlist, "all");
	if( utlf_isNull(dsUpdate) || dsUpdate.rowcount == 0 )
	{						
		return false;
	}		

	ds_send_list_custlist.copyData(ds_main_list_custlist); 
	ds_send_list_custlist.updateColID("statflag","status");
	dsf_setDefaultVal(ds_send_list_custlist, "seizureyn:N,purcuseyn:N,nutruseyn:N,pharmuseyn:N,ctmsuseyn:N");
	var oParam = {};
		oParam.id          = "TXRAC00601";
		oParam.service     = "acntbaseinfoapp.AcntBaseInfo";
		oParam.method      = "reqExeRacmCustlist";
		oParam.inds        = "req=ds_send_list_custlist";
		//oParam.outds       = "ds_hidden_return=return";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRAC00601";

	tranf_submit(oParam);

	ds_hidden_list_custchecklist.applyChange();
	ds_main_list_custlist.applyChange();
}

/****************************************************************************************
 * Argument			: N/A
 * Description		: not null check
 ****************************************************************************************/
function fDataCheck() 
{
	if(group2.grd_custlist.rowcount == 0) return;

	var bDataValidFlag = true;
	var bflag = true;
	
	for(var i = 0 ; i < ds_main_list_custlist.rowcount ; i++)
	{	
		bflag = true;									
		var sCustNm = dsf_getColumnNullToEmpty(ds_main_list_custlist, i, "custnm");
		if(sCustNm == "")
		{
			misfSetGridColor(group2.grd_custlist, "custnm", "#ff0000", "B" ,i);
			bflag = false;
		}
		else
		{
			misfSetGridColor(group2.grd_custlist, "custnm", "#ffff00", "B" ,i);
		}

		var sFromdd = dsf_getColumnNullToEmpty(ds_main_list_custlist, i, "fromdd");
		if(!utlf_isValidDateTime(sFromdd, "YYYYMMDD"))
		{
			misfSetGridColor(group2.grd_custlist, "fromdd", "#ff0000", "B" ,i);
			bflag = false;
		}
		else
		{
			misfSetGridColor(group2.grd_custlist, "fromdd", "#ffff00", "B" ,i);
		}

		var sTodd = dsf_getColumnNullToEmpty(ds_main_list_custlist, i, "todd");
		if(!utlf_isValidDateTime(sFromdd, "YYYYMMDD"))
		{
			misfSetGridColor(group2.grd_custlist, "todd", "#ff0000", "B" ,i);
			bflag = false;
		}
		else
		{
			misfSetGridColor(group2.grd_custlist, "todd", "#ffff00", "B" ,i);
		}

		if(bflag == false)
		{
			ds_main_list_custlist.setColumn(i, "validyn", "N");
			bDataValidFlag = false;							
		}
		else
		{
			ds_main_list_custlist.setColumn(i, "validyn", "Y");
		}
	}
	
	if(bDataValidFlag == true)
	{
		group2.btn_save.enable = true;
		for(var i = 0 ; i < group2.grd_custlist.rowcount; i++)
		{
			grdf_setStatus(group2.grd_custlist, "I", [i]);
		}
	}
}

/****************************************************************************************
 * Argument			: N/A
 * Description		: 엑셀 입력
 ****************************************************************************************/
function fInputExcel(pGrid)
{
	grdf_ImportExcel(pGrid.binddataset, 2, pGrid, 0);
	if(eval(pGrid.binddataset).rowcount > 0) {
		eval(pGrid.binddataset).deleteRow(0);
		for(var i = 0; i < pGrid.rowcount; i++) 
		{
			grdf_setStatus(pGrid, "I", [i]);
		}
	}
}		
 
//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SPRAC00610_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	grdf_setRowTypeIcon(group2.grd_custchecklist, 0); 
	grdf_setRowTypeIcon(group2.grd_custlist, 0); 

	fInitialize();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 검사
 ****************************************************************************************/
function group2_btn_excel_onclick(obj:Button, e:ClickEventInfo) {
	fDataCheck();
}

/****************************************************************************************
 * Components		: Button
 * Description		: Excel 불러오기
 ****************************************************************************************/
function group2_button1_onclick(obj:Button, e:ClickEventInfo) {
	ds_hidden_list_custchecklist.clearData();
	ds_main_list_custlist.clearData();

	fInputExcel(group2.grd_custchecklist);

	group2.btn_save.enable = false;

	var instcd = sysf_getUserInfo("dutplceinstcd")

	var bflag = false;
	var vRowNumber = 0;

	for(var i = 0 ; i < ds_hidden_list_custchecklist.rowcount ; i++)
	{						
		bflag = true;

		sValidYN = ds_hidden_list_custchecklist.getColumn(i, "validyn");							
		if(sValidYN != "Y") continue;
		if(bflag && sValidYN != "Y")
		{
			misfSetGridColor(group3.grd_custchecklist, "all", "#333333", "B" ,i);
			bflag = false;
		}

		sEntrregno = ds_hidden_list_custchecklist.getColumn(i, "entrregno");
		if(bflag && !radfBizCheck(sEntrregno)) 							
		{
			misfSetGridColor(group3.grd_custchecklist, "entrregno", "#ff0000", "B" ,i);
			ds_hidden_list_custchecklist.setColumn(i, "validyn", "ERROR");
			bflag = false;
		}

		if(bflag && !utlf_isNull(radfcheckCustExist(instcd, sEntrregno, "N")))
		{
			misfSetGridColor(group3.grd_custchecklist, "entrregno", "#00ff00", "B" ,i);
			ds_hidden_list_custchecklist.setColumn(i, "validyn", "EXIST");
			bflag = false;
		}							

		if(bflag == true)
		{
			ds_main_list_custlist.insertRow(vRowNumber);
			ds_main_list_custlist.copyRow(vRowNumber, ds_hidden_list_custchecklist, i);
			dsf_makeValue(ds_main_list_custlist, "statflag", "string", "i", vRowNumber);
			vRowNumber++;		
		}	

		for(var j = i+1 ; j < ds_hidden_list_custchecklist.rowcount ; j++)
		{
			if(sEntrregno == ds_hidden_list_custchecklist.getColumn(j, "entrregno"))
			{
				ds_hidden_list_custchecklist.setColumn(j, "validyn", "D");
				misfSetGridColor(group3.grd_custchecklist, "all", "#800080", "B" ,j);
			}
		}
	}	
}

/****************************************************************************************
 * Components		: Button
 * Description		: 저장
 ****************************************************************************************/
function group2_btn_save_onclick(obj:Button, e:ClickEventInfo) {
	fSave();
	group2.btn_save.enable = false;
}

/****************************************************************************************
 * Components		: Button
 * Description		: Excel 출력(오류분)
 ****************************************************************************************/
function group2_button2_onclick(obj:Button, e:ClickEventInfo) {
	misfSaveExcel(group2.grd_custchecklist);
}

/****************************************************************************************
 * Components		: Button
 * Description		: Excel 출력(입력분)
 ****************************************************************************************/
function group2_button3_onclick(obj:Button, e:ClickEventInfo) {
	misfSaveExcel(group2.grd_custlist);
}

/****************************************************************************************
 * Components		: Button
 * Description		: 사업자등록번호 조회팝업
 ****************************************************************************************/
function group2_btn_regnohelp_onclick(obj:Button, e:ClickEventInfo) {
	misfOpenPopUpList("14", group2.ipt_entrregno, "", "entrregno,custnm", "cmb_custstat,cmb_instcd", "custuseyn,instcd");
}

/****************************************************************************************
 * Components		: MaskEdit
 * Description		: 사업자등록명 변경 후 조회
 ****************************************************************************************/
function group2_ipt_custnm_onkeydown(obj:Edit, e:KeyEventInfo) {
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		group2.btn_search.click();
	}
}

/****************************************************************************************
 * Components		: MaskEdit
 * Description		: 사업자등록번호 변경 후 조회
 ****************************************************************************************/
function group2_ipt_entrregno_onkeydown(obj:MaskEdit, e:KeyEventInfo) {
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		group2.btn_search.click();
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function group2_btn_search_onclick(obj:Button, e:ClickEventInfo) {
	ds_hidden_list_custchecklist.clearData();
	ds_main_list_custlist.clearData();

	var oParam = {};
		oParam.id          = "TRRAC00603";
		oParam.service     = "acntbaseinfoapp.AcntBaseInfo";
		oParam.method      = "reqGetRacmCopyCustList";
		oParam.inds        = "req=ds_send_condition";
		oParam.outds       = "ds_hidden_list_custchecklist=custchecklist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAC00603";

	tranf_submit(oParam);
}

/****************************************************************************************
 * Components		: Button
 * Description		: 복사
 ****************************************************************************************/
function group2_button4_onclick(obj:Button, e:ClickEventInfo) {
	ds_main_list_custlist.clearData();

	group2.btn_save.enable = false;					

	var vRowNumber = 0;
	var bflag = true;

	for(var i = 0 ; i < ds_hidden_list_custchecklist.rowcount ; i++)
	{
		bflag = true;

		sValidYN = ds_hidden_list_custchecklist.getColumn(i, "validyn");							

		if(!sValidYN)
		{
			misfSetGridColor(group3.grd_custchecklist, "all", "#333333", "B" ,i);
			bflag = false;
		}

		sEntrregno = ds_hidden_list_custchecklist.getColumn(i, "entrregno");
		if(bflag && !radfBizCheck(sEntrregno)) 							
		{
			misfSetGridColor(group3.grd_custchecklist, "entrregno", "#ff0000", "B" ,i);
			ds_hidden_list_custchecklist.setColumn(i, "validyn", "E");
			bflag = false;
		}															

		if(bflag)
		{
			ds_main_list_custlist.insertRow(vRowNumber);
			ds_main_list_custlist.copyRow(vRowNumber, ds_hidden_list_custchecklist, i);
			dsf_makeValue(ds_main_list_custlist, "statflag", "string", "i", vRowNumber);
			vRowNumber++;							
		}							
	}
}
 
]]></Script>
  </Form>
</FDL>