YNU_JEUS/app_home/himed/xpapps/mis/bugtappxp/xp/SMRBQ00500_예산EXCEL입력.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRBQ00500" position="absolute 0 0 1200 773" titletext="본/추경예산EXCEL입력" oninit="SMRBQ00500_oninit" onload="SMRBQ00500_onload">
    <Layouts>
      <Layout>
        <Static id="cap_title" text="예산 Excel 입력" class="tit_1" position="absolute 0 0 190 25"/>
        <Shape id="line2" class="line_10" position="absolute 0 25 1195 31"/>
        <Grid id="grd_bugtexcellist" taborder="1" binddataset="ds_main_bugtexcel_bugtexcellist" useinputpanel="false" position="absolute 0 53 1195 293" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="80" band="left"/>
                <Column size="130" band="left"/>
                <Column size="130" band="left"/>
                <Column size="130" band="left"/>
                <Column size="150"/>
                <Column size="90"/>
                <Column size="60"/>
                <Column size="200"/>
                <Column size="200"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="80"/>
              </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="데이터여부"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="combo" edittype="combo" style="padding:2 2 2 2;" text="bind:bugtflag" combodataset="ds_cmb_bugtflag" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="2" style="align:left middle;padding:2 2 2 2;" text="bind:supacntnm2"/>
                <Cell col="3" style="align:left middle;padding:2 2 2 2;" text="bind:supacntnm3"/>
                <Cell col="4" style="align:left middle;padding:2 2 2 2;" text="bind:supacntnm4"/>
                <Cell col="5" style="align:left middle;padding:2 2 2 2;" text="bind:acntnm"/>
                <Cell col="6" style="align:left middle;padding:2 2 2 2;" text="bind:acntcd"/>
                <Cell col="7" displaytype="combo" edittype="combo" style="align:left middle;padding:2 2 2 2;" text="bind:assgym" combodataset="ds_contextmenu_assgym_item" combocodecol="value" combodatacol="label" enable="false"/>
                <Cell col="8" style="align:left middle;padding:2 2 2 2;" text="bind:bugtappresn"/>
                <Cell col="9" style="align:left middle;padding:2 2 2 2;" text="bind:bugtappbase"/>
                <Cell col="10" displaytype="number" text="bind:orgbugtappamt"/>
                <Cell col="11" displaytype="number" text="bind:revbugtappamt"/>
                <Cell col="12" text="bind:data_exist"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_exceldel" taborder="2" text="삭제" class="btn4" position="absolute 1079 30 1135 52" onclick="btn_exceldel_onclick"/>
        <Button id="btn_inputexcel" taborder="3" text="Excel 저장" class="btn4" position="absolute 984 30 1076 52" onclick="btn_inputexcel_onclick"/>
        <Button id="btn_excelapp" taborder="4" text="적용" class="btn4" position="absolute 1139 30 1195 52" onclick="btn_excelapp_onclick"/>
        <Grid id="grd_bugtchecklist" taborder="5" binddataset="ds_main_bugtcheck_bugtchecklist" useinputpanel="false" position="absolute 0 299 1195 768" autoenter="select" autofittype="col" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="80"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="80"/>
                <Column size="150"/>
                <Column size="60"/>
                <Column size="150"/>
                <Column size="150"/>
                <Column size="90"/>
                <Column size="20"/>
                <Column size="20"/>
                <Column size="20"/>
                <Column size="20"/>
              </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="항"/>
                <Cell col="13" text="목코드"/>
                <Cell col="14" text="목"/>
                <Cell col="15" text="계정코드"/>
                <Cell col="16" text="계정명"/>
                <Cell col="17" text="배정월"/>
                <Cell col="18" text="적요"/>
                <Cell col="19" text="산출근거"/>
                <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 celltype="head"/>
                <Cell col="1" text="bind:instcd"/>
                <Cell col="2" text="bind:acntyy"/>
                <Cell col="3" text="bind:deptcd"/>
                <Cell col="4" text="bind:deptengnm"/>
                <Cell col="5" text="bind:workflag"/>
                <Cell col="6" displaytype="combo" edittype="combo" text="bind:bugtflag"/>
                <Cell col="7" text="bind:supacntcd1"/>
                <Cell col="8" text="bind:supacntmn1"/>
                <Cell col="9" text="bind:supacntcd2"/>
                <Cell col="10" text="bind:supacntmn2"/>
                <Cell col="11" text="bind:supacntcd3"/>
                <Cell col="12" text="bind:supacntmn3"/>
                <Cell col="13" text="bind:supacntcd4"/>
                <Cell col="14" text="bind:supacntmn4"/>
                <Cell col="15" text="bind:acntcd"/>
                <Cell col="16" text="bind:acntnm"/>
                <Cell col="17" displaytype="combo" edittype="combo" text="bind:assgym" combodataset="ds_contextmenu_assgym_item" combocodecol="value" combodatacol="label"/>
                <Cell col="18" text="bind:bugtappresn"/>
                <Cell col="19" text="bind:bugtappbase"/>
                <Cell col="20" text="bind:bugtappamt"/>
                <Cell col="21" text="bind:deptuseacntyn"/>
                <Cell col="22" text="bind:bugtuseyn"/>
                <Cell col="23" text="bind:mngtdeptyn"/>
                <Cell col="24" text="bind:duplication"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" linetype="horizontal" class="line_10" position="absolute 0 294 1195 300"/>
        <Button id="button2" taborder="6" text="입력샘플" class="btn2" position="absolute 5 33 70 52" onclick="button2_onclick"/>
        <Button id="button3" taborder="7" text="Excel(적용)" class="btn2" position="absolute 71 33 157 52" onclick="button3_onclick"/>
        <Combo id="cmb_instcd" taborder="8" class="combo_s_essential" enable="false" position="absolute 274 33 449 52"/>
        <Static id="caption7" text="기     관 :" class="search_name" position="absolute 185 33 271 50"/>
        <Edit id="ipt_depthngnm" taborder="9" class="input_s_essential" enable="false" position="absolute 815 33 965 52"/>
        <Button id="btn_depthelp" taborder="10" class="icon_search" enable="false" position="absolute 794 33 810 49"/>
        <Edit id="ipt_deptcd" taborder="11" class="input_s_essential" enable="false" position="absolute 710 33 790 52"/>
        <Static id="caption2" text="예산년도 :" class="search_name" position="absolute 465 33 551 50"/>
        <Edit id="ipt_acntyy" taborder="12" class="input_s_essential" enable="false" position="absolute 554 33 622 52"/>
        <Grid id="grd_bugtexceluploadlist" taborder="13" binddataset="ds_main_bugtexcelupload_bugtexceluploadlist" useinputpanel="false" visible="false" position="absolute 414 135 1184 240">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
                <Column size="75"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="기관코드"/>
                <Cell col="1" text="회계년도"/>
                <Cell col="2" text="작업구분"/>
                <Cell col="3" text="부서코드"/>
                <Cell col="4" text="예산구분"/>
                <Cell col="5" text="계정코드"/>
                <Cell col="6" text="배정월"/>
                <Cell col="7" text="적요"/>
                <Cell col="8" text="산출근거"/>
                <Cell col="9" text="예산액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:instcd"/>
                <Cell col="1" text="bind:acntyy"/>
                <Cell col="2" text="bind:workflag"/>
                <Cell col="3" text="bind:deptcd"/>
                <Cell col="4" enable="false" text="bind:bugtflag"/>
                <Cell col="5" text="bind:acntcd"/>
                <Cell col="6" enable="false" text="bind:assgym"/>
                <Cell col="7" text="bind:bugtappresn"/>
                <Cell col="8" text="bind:bugtappbase"/>
                <Cell col="9" text="bind:bugtappamt" mask="(-)#,###"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption3" text="부  서 :" class="search_name" position="absolute 636 33 743 50"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="acntyy" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="depthngnm" type="STRING" size="256"/>
          <Column id="workflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="acntyy"/>
            <Col id="deptcd"/>
            <Col id="depthngnm"/>
            <Col id="workflag">1</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_bugtexcel_bugtexcellist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="acntyy" type="STRING" size="256" sumtext="회계년도"/>
          <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="bugtflag" type="STRING" size="256" sumtext="예산구분"/>
          <Column id="supacntnm2" type="STRING" size="256" sumtext="관"/>
          <Column id="supacntnm3" type="STRING" size="256" sumtext="항"/>
          <Column id="supacntnm4" type="STRING" size="256" sumtext="목"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="assgym" type="STRING" size="256" sumtext="발생월"/>
          <Column id="bugtappresn" type="STRING" size="256" sumtext="산출내역"/>
          <Column id="bugtappbase" type="STRING" size="256" sumtext="산출근거"/>
          <Column id="orgbugtappamt" type="DECIMAL" size="256" sumtext="본예산신청액"/>
          <Column id="revbugtappamt" type="DECIMAL" size="256" sumtext="추경예산신청액"/>
          <Column id="data_exist" type="STRING" size="256" sumtext="데이터여부"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_bugtcheck_bugtchecklist" 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="acntyy" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptengnm" type="STRING" size="256"/>
          <Column id="workflag" type="STRING" size="256"/>
          <Column id="bugtflag" type="STRING" size="256"/>
          <Column id="supacntcd1" type="STRING" size="256"/>
          <Column id="supacntmn1" type="STRING" size="256"/>
          <Column id="supacntcd2" type="STRING" size="256"/>
          <Column id="supacntmn2" type="STRING" size="256"/>
          <Column id="supacntcd3" type="STRING" size="256"/>
          <Column id="supacntmn3" type="STRING" size="256"/>
          <Column id="supacntcd4" type="STRING" size="256"/>
          <Column id="supacntmn4" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="assgym" type="STRING" size="256"/>
          <Column id="bugtappresn" type="STRING" size="256"/>
          <Column id="bugtappbase" type="STRING" size="256"/>
          <Column id="bugtappamt" type="DECIMAL" size="256"/>
          <Column id="duplication" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_bugtexcelupload_bugtexceluploadlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_cmb_bugtflag" 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">1</Col>
          </Row>
          <Row>
            <Col id="label">비용</Col>
            <Col id="value">2</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_contextmenu_assgym_item" 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">-</Col>
          </Row>
          <Row>
            <Col id="label">3월</Col>
            <Col id="value">03</Col>
          </Row>
          <Row>
            <Col id="label">4월</Col>
            <Col id="value">04</Col>
          </Row>
          <Row>
            <Col id="label">5월</Col>
            <Col id="value">05</Col>
          </Row>
          <Row>
            <Col id="label">6월</Col>
            <Col id="value">06</Col>
          </Row>
          <Row>
            <Col id="label">7월</Col>
            <Col id="value">07</Col>
          </Row>
          <Row>
            <Col id="label">8월</Col>
            <Col id="value">08</Col>
          </Row>
          <Row>
            <Col id="label">9월</Col>
            <Col id="value">09</Col>
          </Row>
          <Row>
            <Col id="label">10월</Col>
            <Col id="value">10</Col>
          </Row>
          <Row>
            <Col id="label">11월</Col>
            <Col id="value">11</Col>
          </Row>
          <Row>
            <Col id="label">12월</Col>
            <Col id="value">12</Col>
          </Row>
          <Row>
            <Col id="label">1월</Col>
            <Col id="value">01</Col>
          </Row>
          <Row>
            <Col id="label">2월</Col>
            <Col id="value">02</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_target_slipinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="cmb_instcd" propid="value" datasetid="ds_send_condition" columnid="instcd"/>
      <BindItem id="item1" compid="ipt_acntyy" propid="value" datasetid="ds_send_condition" columnid="acntyy"/>
      <BindItem id="item2" compid="ipt_deptcd" propid="value" datasetid="ds_send_condition" columnid="deptcd"/>
      <BindItem id="item3" compid="ipt_depthngnm" propid="value" datasetid="ds_send_condition" columnid="depthngnm"/>
    </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";
include "mis_acntcommonxp::RAD001.xjs";

var vWorkFlag = "";
function SMRBQ00500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRBQ00500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_bugtexcellist);
	grdf_setRowTypeIcon(grd_bugtexcellist, 0);
	
	grdf_initGrid(grd_bugtchecklist);
	grdf_setRowTypeIcon(grd_bugtchecklist, 0);
	
	grdf_initGrid(grd_bugtexceluploadlist);
	
	try
	{
		ds_target_slipinfo.copyData(arg_ds_target);
	}
	catch(e)
	{
	}
	fInitialize();
}

function fInitialize()
{
	vWorkFlag = ds_target_slipinfo.getColumn(0, "workflag");

	if(vWorkFlag == "1")
	{
		cap_title.text = "본예산 Excel 입력";
	}
	else if(vWorkFlag == "2")
	{
		cap_title.text = "추경예산 Excel 입력";
	}
	
	misfComboComCdList("Z0007", cmb_instcd, "N");
	cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	
	ipt_acntyy.value = ds_target_slipinfo.getColumn(0, "acntyy");
	ipt_deptcd.value = ds_target_slipinfo.getColumn(0, "deptcd");
	ipt_depthngnm.value = ds_target_slipinfo.getColumn(0, "depthngnm");
	
	ds_send_condition.setColumn(0, "workflag", vWorkFlag);

	fSearch();
}

function fSearch()
{
	ds_main_bugtexcel_bugtexcellist.clearData();
	ds_main_bugtcheck_bugtchecklist.clearData();
	
	var oParam = {};
		oParam.id          = "TRRBQ00151";
		oParam.service     = "bugtappapp.BugtApp";
		oParam.method      = "reqGetBugtExcelList";
		oParam.inds        = "req=ds_send_condition";
		oParam.outds       = "ds_main_bugtexcel_bugtexcellist=bugtexcellist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRBQ00151";

	tranf_submit(oParam);

	var oParam = {};
		oParam.id          = "TRRBQ00152";
		oParam.service     = "bugtappapp.BugtApp";
		oParam.method      = "reqGetBugtExcelCheckList";
		oParam.inds        = "req=ds_send_condition";
		oParam.outds       = "ds_main_bugtcheck_bugtchecklist=bugtchecklist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRBQ00152";

	tranf_submit(oParam);
	
	if(ds_main_bugtcheck_bugtchecklist.rowcount == 0)
	{
		btn_inputexcel.enable = true;
	}
	else
	{
		btn_inputexcel.enable = false;
	}
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_bugtexcellist, "exportExcel", "see");
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_bugtchecklist, "excel", "see");
}

function btn_inputexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_bugtcheck_bugtchecklist.clearData();
	ds_main_bugtexcel_bugtexcellist.clearData();
	ds_main_bugtexcelupload_bugtexceluploadlist.clearData();
	
	grdf_ImportExcel("ds_main_bugtexcel_bugtexcellist", 2, grd_bugtexcellist)	
	
	for(var i = 0; i < ds_main_bugtexcel_bugtexcellist.rowcount; i++)
	{
		vBugtflag = ds_main_bugtexcel_bugtexcellist.getColumn(i, "bugtflag");
		
		if (vBugtflag == "수익") 
		{
			ds_main_bugtexcel_bugtexcellist.setColumn(i, "bugtflag", "1");
		}
		else if (vBugtflag == "비용") 
		{
			ds_main_bugtexcel_bugtexcellist.setColumn(i, "bugtflag", "2");
		}
		else
		{
			sysf_messageBox("잘못된 예산구분입니다.", "I000");
			return false;
		}			
		
		var vAssgym = "";
		var vBugtflag = "";
		
		if(ds_main_bugtexcel_bugtexcellist.getColumn(i, "assgym")!= "연간")
		{
			vAssgym = ds_main_bugtexcel_bugtexcellist.getColumn(i, "assgym");
			vAssgym = vAssgym.replace("월","").getLeftPad(2,"0");			
			
			if(parseInt(ds_main_bugtexcel_bugtexcellist.getColumn(i, "assgym")) > 12 || parseInt(ds_main_bugtexcel_bugtexcellist.getColumn(i, "assgym")) < 1)
			{
				sysf_messageBox("잘못된 배정월입니다.", "I000");
				return false;
			}
			ds_main_bugtexcel_bugtexcellist.setColumn(i, "assgym", vAssgym);
		}
		else if(ds_main_bugtexcel_bugtexcellist.getColumn(i, "assgym") == "연간")
		{
			ds_main_bugtexcel_bugtexcellist.setColumn(i, "assgym", "-");
		}
	}


	var Instcd 	= cmb_instcd.value;
	var Acntyy 	= ipt_acntyy.value;
	var Deptcd 	= ipt_deptcd.value;

	for(var i = 0; i < ds_main_bugtexcel_bugtexcellist.rowcount; i++)
	{
		var addRow = ds_main_bugtexcelupload_bugtexceluploadlist.addRow();
		
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "instcd", Instcd);
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "workflag", vWorkFlag);
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "acntyy", Acntyy);
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "deptcd", Deptcd);
		
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "bugtflag", ds_main_bugtexcel_bugtexcellist.getColumn(i, "bugtflag"));
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "acntcd", ds_main_bugtexcel_bugtexcellist.getColumn(i, "acntcd"));
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "assgym", ds_main_bugtexcel_bugtexcellist.getColumn(i, "assgym"));
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "bugtappresn", ds_main_bugtexcel_bugtexcellist.getColumn(i, "bugtappresn"));
		ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "bugtappbase", ds_main_bugtexcel_bugtexcellist.getColumn(i, "bugtappbase"));
		
		if(vWorkFlag == "1")
		{
			ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "bugtappamt", ds_main_bugtexcel_bugtexcellist.getColumn(i, "orgbugtappamt"));
		}
		else if(vWorkFlag == "2")
		{
			ds_main_bugtexcelupload_bugtexceluploadlist.setColumn(addRow, "bugtappamt", ds_main_bugtexcel_bugtexcellist.getColumn(i, "revbugtappamt"));
		}							
	}

	var oParam = {};
		oParam.id          = "TXRBQ00151";
		oParam.service     = "bugtappapp.BugtApp";
		oParam.method      = "reqExeBugtExcelSave";
		oParam.inds        = "bugtexceluploadlist=ds_main_bugtexcelupload_bugtexceluploadlist:u";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRBQ00151";

	tranf_submit(oParam);

	fSearch();
}

function btn_exceldel_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TXRBQ00152";
		oParam.service     = "bugtappapp.BugtApp";
		oParam.method      = "reqExeBugtExcelDel";
		oParam.inds        = "req=ds_send_condition";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRBQ00152";

	tranf_submit(oParam);
	
	fSearch();
}

function btn_excelapp_onclick(obj:Button,  e:ClickEventInfo)
{
	var DeptAcnt = "N";
						
	if(radfCheckInstMngt(sysf_getUserInfo("dutplceinstcd"), "condition4") == "Y")
	{
		DeptAcnt = "Y";							
	}
	
	for(var i = 0; i < ds_main_bugtcheck_bugtchecklist.rowcount; i++)
	{
		if(DeptAcnt == "Y")
		{
			if(ds_main_bugtcheck_bugtchecklist.getColumn(i, "deptuseacntyn") == "N")
			{
				sysf_messageBox("사용계정이 아닙니다.", "I000");
				return false;
			}
		}
		
		if(ds_main_bugtcheck_bugtchecklist.getColumn(i, "bugtuseyn") == "N")
		{
			sysf_messageBox("예산계정이 아닙니다.", "I000");
			return false;
		}
		
		if(ds_main_bugtcheck_bugtchecklist.getColumn(i, "mngtdeptyn") == "N")
		{
			sysf_messageBox("예산관리부서가 아닙니다.", "I000");
			return false;
		}
	}
	
	var oParam = {};
		oParam.id          = "TXRBQ00153";
		oParam.service     = "bugtappapp.BugtApp";
		oParam.method      = "reqExeBugtExcelApp";
		oParam.inds        = "req=ds_send_condition";
		oParam.async       = false;
		//oParam.callback    = "cf_TXRBQ00153";

	tranf_submit(oParam);
}
]]></Script>
  </Form>
</FDL>