YNU_JEUS/app_home/himed/xpapps/com/batchinfoxp/xp/SMZSB00101_배치프로그램관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMZSB00101" position="absolute 0 0 1215 805" titletext="배치프로그램 관리" onload="SMZSB00101_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="배치 프로그램 관리" onclick="&quot;caption6_onclick&quot;" class="tit_1" position="absolute 0 0 169 25"/>
        <Div id="grp_sea" anchor="left top right" taborder="2" style="align:center top;" class="div_SA" position="absolute 0 24 1194 67">
          <Layouts>
            <Layout width="1256" height="43">
              <Static id="caption21" text="업무 구분 :" class="search_name" position="absolute 7 15 85 32" anchor="default"/>
              <Combo id="cmb_bizcd" taborder="17" innerdataset="ds_init_cmb_bizcd" codecolumn="cdengabbrnm" datacolumn="cdengabbrnm" onitemchanged="group5_group6_cmb_bizcd_onitemchanged" class="combo_search" position="absolute 91 13 196 32" anchor="default"/>
              <Static id="caption59" text="조회 항목 :" class="search_name" position="absolute 231 15 356 32" anchor="default"/>
              <Combo id="cmb_selectitem" taborder="18" value="1" text="모듈명" codecolumn="codecolumn" datacolumn="datacolumn" index="0" class="combo_search" position="absolute 321 13 486 32" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">모듈명</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">프로그램 ID</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">프로그램 명</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Edit id="ipt_selectcond" taborder="19" class="input_search" position="absolute 492 13 802 32" anchor="default"/>
              <Button id="btn_select" taborder="20" text="조회" onclick="btn_select_onclick" class="btn1" position="absolute 1004 11 1060 33" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_delrow" taborder="4" text="선택행삭제" onclick="btn_delrow_onclick" class="btn2" position="absolute 1117 81 1192 100" anchor="top right"/>
        <Button id="btn_addrow" taborder="5" text="행추가" onclick="btn_addrow_onclick" class="btn2" position="absolute 1062 81 1115 100" anchor="top right"/>
        <Button id="btn_loadexcel" taborder="6" text="엑셀입력" onclick="btn_loadexcel_onclick" class="btn2" position="absolute 996 81 1060 100" anchor="top right"/>
        <Button id="btn_saveexcel" taborder="7" text="엑셀저장" onclick="btn_saveexcel_onclick" class="btn2" position="absolute 930 81 994 100" anchor="top right"/>
        <Static id="caption48" text="배치 프로그램 목록" class="tit_2" position="absolute 4 83 153 96"/>
        <Grid id="grd_batprgm" taborder="8" binddataset="ds_grd_batprgm" useinputpanel="false" oncellclick="grd_batprgm_oncellclick" ontextchanged="group5_grd_batprgm_ontextchanged" position="absolute 0 110 1194 685" anchor="all" autoenter="key" onenterdown="grd_batprgm_onenterdown">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="73"/>
                <Column size="177"/>
                <Column size="187"/>
                <Column size="355"/>
                <Column size="40"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="80"/>
                <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="프로그램 ID"/>
                <Cell col="3" text="프로그램 명"/>
                <Cell col="4" text="사용"/>
                <Cell col="5" text="최초등록자"/>
                <Cell col="6" text="최초등록일자"/>
                <Cell col="7" text="최종수정자"/>
                <Cell col="8" text="최종수정일자"/>
              </Band>
              <Band id="body">
                <Cell displaytype="combo" edittype="combo" style="align:left middle;padding:0 0 0 5;" text="bind:bizabbr" combodataset="ds_init_cmb_bizcd" combocodecol="cdengabbrnm" combodatacol="cdengabbrnm"/>
                <Cell col="1" displaytype="text" edittype="text" style="padding:0 0 0 5;" text="bind:modulenm"/>
                <Cell col="2" displaytype="text" edittype="text" style="padding:0 0 0 5;" text="bind:prgmid"/>
                <Cell col="3" displaytype="text" edittype="text" style="padding:0 0 0 5;" text="bind:prgmnm" wordwrap="char" autosizerow="limitmin"/>
                <Cell col="4" displaytype="combo" edittype="combo" style="align:center;" text="bind:useyn" combodataset="ds_init_yseyn" combocodecol="value" combodatacol="label"/>
                <Cell col="5" style="align:left;padding:0 0 0 5;" text="bind:fstrgstrid"/>
                <Cell col="6" style="align:left middle;padding:0 0 0 5;" text="bind:fstrgstdt" mask="####-##-##"/>
                <Cell col="7" style="align:left;padding:0 0 0 5;" text="bind:lastupdtrid"/>
                <Cell col="8" style="align:left middle;padding:0 0 0 5;" text="bind:lastupdtdt" mask="####-##-##"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_execute" taborder="14" text="실행" onclick="btn_execute_onclick" class="btn5" position="absolute 1150 696 1192 715" anchor="right bottom"/>
        <Static id="caption00" text="배치 프로그램 실행" class="tit_2" position="absolute 4 696 153 709" anchor="left bottom"/>
        <Static id="caption34" text="모듈명" class="cell_1" position="absolute 227 721 327 744" anchor="left bottom"/>
        <Edit id="ipt_exeprgmnm" taborder="16" readonly="true" position="absolute 898 722 1197 741" anchor="left right bottom"/>
        <Static id="caption42" text="프로그램 명" class="cell_1" position="absolute 796 721 896 744" anchor="left bottom"/>
        <Edit id="ipt_exeprgmid" taborder="17" readonly="true" position="absolute 619 722 793 741" anchor="left bottom"/>
        <Static id="caption35" text="프로그램 ID" class="cell_1" position="absolute 516 721 616 744" anchor="left bottom"/>
        <Edit id="ipt_exemodulenm" taborder="18" readonly="true" position="absolute 329 722 513 741" anchor="left bottom"/>
        <Edit id="ipt_exebizcd" taborder="19" readonly="true" oneditclick="group5_ipt_exebizcd_oneditclick" position="absolute 106 722 223 741" anchor="left bottom"/>
        <Static id="caption47" text="실행 매개변수" class="cell_1" position="absolute 3 745 103 792" anchor="left bottom"/>
        <Static id="caption23" text="업무 구분" class="cell_1" position="absolute 3 721 103 744" anchor="left bottom"/>
        <TextArea id="tar_exeparamcnts" taborder="20" position="absolute 106 747 1197 790" anchor="left right bottom"/>
        <Button id="btn_save" taborder="21" text="저장" onclick="btn_save_onclick" class="btn3" position="absolute 1063 35 1119 57" anchor="top right" style="padding:0 0 0 20;"/>
        <Button id="btn_init" taborder="22" text="초기화" class="btn3" position="absolute 1122 35 1184 57" anchor="top right" style="padding:0 0 0 20;" onclick="btn_init_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_cmb_bizcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdengabbrnm" type="STRING"/>
          <Column id="cdengabbrnm" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_batprgm" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bizabbr" type="STRING"/>
          <Column id="modulenm" type="STRING"/>
          <Column id="prgmid" type="STRING"/>
          <Column id="prgmnm" type="STRING"/>
          <Column id="useyn" type="STRING"/>
          <Column id="fstrgstrid" type="STRING"/>
          <Column id="fstrgstdt" type="STRING"/>
          <Column id="lastupdtrid" type="STRING"/>
          <Column id="lastupdtdt" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_exe" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bizabbr" type="STRING" size="256"/>
          <Column id="modulenm" type="STRING" size="256"/>
          <Column id="prgmid" type="STRING" size="256"/>
          <Column id="prgmnm" type="STRING" size="256"/>
          <Column id="paramcnts" type="STRING" size="256"/>
          <Column id="pagesize" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="pagesize">200</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bizabbr" type="STRING" size="256"/>
          <Column id="modulenm" type="STRING" size="256"/>
          <Column id="prgmid" type="STRING" size="256"/>
          <Column id="prgmnm" type="STRING" size="256"/>
          <Column id="updtdata" type="STRING" size="256"/>
          <Column id="offset" type="STRING" size="256"/>
          <Column id="pagesize" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="pagesize">200</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_yseyn" 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">Y</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">N</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item4" compid="tar_exeparamcnts" propid="value" datasetid="ds_exe" columnid="paramcnts"/>
      <BindItem id="item0" compid="ipt_exebizcd" propid="value" datasetid="ds_exe" columnid="bizabbr"/>
      <BindItem id="item1" compid="ipt_exemodulenm" propid="value" datasetid="ds_exe" columnid="modulenm"/>
      <BindItem id="item2" compid="ipt_exeprgmid" propid="value" datasetid="ds_exe" columnid="prgmid"/>
      <BindItem id="item3" compid="ipt_exeprgmnm" propid="value" datasetid="ds_exe" columnid="prgmnm"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    	:	Mr.손
 * Make Date 		:	2014-11-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2014-11-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
 
 //==============================================================================================
 // Lib Include
 //-----------------------------------------------------------------------------------------------------------------------------
 include "com_commonxp::comm_main.xjs";		// 전체공통 스크립트
 include "com_commodulexp::SSZFM00401.xjs";

 /************************************************************************************************
 ******************************** Form Event ****************************************************
 ************************************************************************************************/


function SMZSB00101_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);
	
	var arrParam = new Array();
	arrParam = [{bizId:"Z0001", cdGrpId:"Z0009", dsNm:"ds_init_cmb_bizcd"}];
	appf_getKindCodeList( arrParam, false, "");
	
	fInitialize();	
}


// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
function fInitialize() {
	lf_commoduleDataSetShow();
		
	ds_grd_batprgm.clearData();
	ds_exe.reset();
	grp_sea.cmb_bizcd.value = "";
	grp_sea.ipt_selectcond.value = "";
		
	// Light Grid 경우 초기화
	grd_batprgm.redraw();
	
}

function btn_select_onclick(obj:Button,  e:ClickEventInfo)
{
	var updtdata = grdf_getGridUpdateData(grd_batprgm);
	
 	if (updtdata.rowcount > 0) {
		var ret = sysf_messageBox("그리드에 작업 중인 내용이 있습니다. 조회 작업을","Q003");
		if (ret != 6) { // not OK
				return;
		}
 	}

	ds_send.addRow();
	ds_send.setColumn(0, "bizabbr", grp_sea.cmb_bizcd.value);
	ds_send.setColumn(0, "offset",  "0");
							
	var queryitem = grp_sea.cmb_selectitem.value;

 	if ( queryitem == "1" ) {
		ds_send.setColumn(0, "modulenm", (grp_sea.ipt_selectcond.value + "%"));
		ds_send.deleteColumn("prgmid");
		ds_send.deleteColumn("prgmnm");
		
 	} else if ( queryitem == "2" ) {
		ds_send.setColumn(0, "prgmid", grp_sea.ipt_selectcond.value + "%");
		ds_send.deleteColumn("modulenm");
		ds_send.deleteColumn("prgmnm");
 	} else if ( queryitem == "3" ) {
		ds_send.setColumn(0, "prgmnm", grp_sea.ipt_selectcond.value + "%");
		ds_send.deleteColumn("prgmid");
		ds_send.deleteColumn("modulenm");
 	}

	ds_grd_batprgm.clearData();
	grd_batprgm.redraw();

	tranf_submit({
                     id: "TRZSB00101"
                   , service: "batchinfoapp.BatchInfo"
	               , method: "reqGetBatchProgramList"
	               , inds : "req=ds_send"
	               , outds: "ds_grd_batprgm=batprgm"
	               , async: true
	               , callback :  "cbf_TRZSB00101"
     });
}

function cbf_TRZSB00101(sSvcId, nErrorCode, sErrorMsg) {
	if(nErrorCode < 0) return;
}

function btn_execute_onclick(obj:Button,  e:ClickEventInfo)
{
	var batchmsg = "배치프로그램 실행이 요청되었습니다. (배치프로그램명=" + ds_exe.getColumn(0, "prgmnm") + ")";
	sysf_messageBox(batchmsg, "I000");
	
	var oParam = {};
    oParam.id          = "TXZSB00102";
    oParam.service     = "batchinfoapp.BatchInfo";
    oParam.method      = "reqExeRunBatchProgram";
    oParam.inds        = "req=ds_exe";
    oParam.outds       = "";
    oParam.async       = false;
    oParam.callback    = "cf_TXZSB00102";

	tranf_submit(oParam);
}

function cf_TXZSB00102(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
}

function fNodeCopyXmlGrid() {
	var cur_row = grd_batprgm.currentrow;
	
	if ( cur_row >= 0 ) {
		ds_exe.copyRow(0, ds_grd_batprgm, cur_row);
	}
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	if(!frmf_chkMdtGrid(grd_batprgm, [0, 3], ["업무구분", "프로그램 명"])) {
		return;
	}		
	var row = ds_grd_batprgm.rowposition;
	
		tranf_submit({
		 id: "TXZSB00101"
	   , service: "batchinfoapp.BatchInfo"
	   , method: "reqExeSaveBatchProgramInfo"
	   , inds : "data=ds_grd_batprgm:U"
	   //, outds: "ds_grd_batprgm=batprgm"
	   , async: true
	   , callback :  "cbf_TXZSB00101"
	});
}

function cbf_TXZSB00101()
{
	ds_grd_batprgm.updatecontrol = true;
	
	frmf_inputEnterKey("grp_sea.btn_select", "onclick", new ClickEventInfo);
}
function btn_init_onclick(obj:Button,  e:ClickEventInfo)
{
	var updtdata = grdf_getGridUpdateData(grd_batprgm);
	if (updtdata.rowcount > 0) {
		var ret = sysf_messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
		if (ret != 6) { // not OK
			return;
		}
	}
	
	fInitialize();
}

function ipt_exebizcd_oneditclick(obj:Edit,  e:EditClickEventInfo)
{
	
}

function grd_batprgm_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	fNodeCopyXmlGrid();
}

function btn_delrow_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_deleteSelectedRows(grd_batprgm, false);
}

function btn_addrow_onclick(obj:Button,  e:ClickEventInfo)
{	
	//Dataset 행추가
	var nRowNum = ds_grd_batprgm.insertRow(0);
	var bizabbr = grp_sea.cmb_bizcd.value;
	
	if (bizabbr == ""){
		bizabbr ="com";
	}
		
	ds_grd_batprgm.setColumn(nRowNum, "bizabbr", bizabbr);
	ds_grd_batprgm.setColumn(nRowNum, "bizabbr", "Y");
	
}

function btn_loadexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	// 엑셀입력( 데이터셋이름, 추가할행위치) )
    grdf_ImportExcel("ds_grd_batprgm", 2, grd_batprgm,1);
}

function btn_saveexcel_onclick(obj:Button,  e:ClickEventInfo)
{
	// 엑셀저장(Grid명,파일명,탭명)
    grdf_exportExcel(grd_batprgm, "배치프로그램" , "배치프로그램");	
}


function grd_batprgm_onenterdown(obj:Grid, e:GridEditEventInfo)
{
	if(obj.getEditText() != undefined)
		obj.showEditor(false);	
}]]></Script>
  </Form>
</FDL>