YNU_JEUS/app_home/himed/xpapps/mis/reqxp/xp/SMRSC20410_장비신청접수도입장비조회(경북대).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSC20410" position="absolute 0 0 1201 442" titletext="도입장비조회" oninit="SMRSC20410_oninit" onload="SMRSC20410_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="도입장비조회" class="tit_1" position="absolute 0 0 201 25"/>
        <Shape id="line17" class="line_6" position="absolute 0 41 1195 47" anchor="left top right"/>
        <Div id="grp_sea" taborder="1" position="absolute 0 45 1195 85" anchor="left top right" class="div_SA2">
          <Layouts>
            <Layout>
              <Static id="caption1" text="기관코드 :" class="search_name" position="absolute 15 9 132 26"/>
              <Combo id="cmb_instcd" taborder="1" class="combo_default" position="absolute 100 10 310 29"/>
              <Static id="caption4" text="심의희차 :" class="search_name" position="absolute 330 10 420 27"/>
              <MaskEdit id="ipt_dcusno" taborder="2" mask="####-##-##" position="absolute 418 10 533 29" autoselect="true" autoskip="true" maskchar=" " type="string" trimtype="both" style="align:center middle;"/>
              <Static id="caption8" text="신청부서 :" class="search_name" position="absolute 550 9 640 26"/>
              <Edit id="ipt_reqdeptcd_search" taborder="3" position="absolute 638 10 758 29" autoselect="true" autoskip="true"/>
              <Button id="btn_reqdeptcd_search" taborder="4" class="icon_search" position="absolute 761 11 777 27" onclick="grp_sea_btn_reqdeptcd_search_onclick"/>
              <Edit id="opt_reqdeptnm_search" taborder="5" readonly="true" position="absolute 780 10 971 29" class="output"/>
              <Button id="btn_search" taborder="6" text="조회" class="btn1" position="absolute 1129 9 1185 31" onclick="grp_sea_btn_search_onclick"/>
              <Shape id="line18" linetype="vertical" class="line_4" position="absolute 1111 9 1117 31"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" class="line_10" position="absolute 0 110 1195 119" anchor="left top right"/>
        <Static id="caption9" text="도입장비 목록" class="tit_2" position="absolute 0 95 120 118"/>
        <Grid id="grd_reqeqitrdlist" taborder="2" binddataset="ds_main_reqeqitrd_reqeqitrdlist" useinputpanel="false" position="absolute 0 116 1195 437" autoenter="select" autofittype="col" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20"/>
                <Column size="60"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="77"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="83"/>
                <Column size="70"/>
                <Column size="71"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </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"/>
                <Cell col="15"/>
                <Cell col="16"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="none" edittype="none" text="bind:dcusno"/>
                <Cell col="2" text="bind:dcusdd"/>
                <Cell col="3" text="bind:acntnm"/>
                <Cell col="4" text="bind:fixasetcd"/>
                <Cell col="5" text="bind:goodflaghngnm"/>
                <Cell col="6" text="bind:goodspec"/>
                <Cell col="7" text="bind:fixasetunitnm"/>
                <Cell col="8" text="bind:fixasetqty"/>
                <Cell col="9" text="bind:possnamt"/>
                <Cell col="10" text="bind:possndd"/>
                <Cell col="11" text="bind:suplplcenm"/>
                <Cell col="12" text="bind:mngtdeptnm"/>
                <Cell col="13" text="bind:installplcenm"/>
                <Cell col="14" text="bind:instcd"/>
                <Cell col="15" text="bind:reqdd"/>
                <Cell col="16" text="bind:reqseqno"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excelsave" taborder="3" text="엑셀저장" class="btn7" position="absolute 1115 92 1195 111" onclick="btn_excelsave_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_search_oncolumnchanged">
        <ColumnInfo>
          <Column id="dcusno" type="STRING" size="256"/>
          <Column id="reqdeptcd" type="STRING" size="256"/>
          <Column id="reqdeptnm" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dcusno"/>
            <Col id="reqdeptcd"/>
            <Col id="reqdeptnm"/>
            <Col id="instcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_reqeqitrd_reqeqitrdlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dcusno" type="STRING" size="256" sumtext="심의차수"/>
          <Column id="dcusdd" type="STRING" size="256" sumtext="심의일자"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정"/>
          <Column id="fixasetcd" type="STRING" size="256" sumtext="자산코드"/>
          <Column id="goodflaghngnm" type="STRING" size="256" sumtext="자산명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
          <Column id="fixasetunitnm" type="STRING" size="256" sumtext="단위"/>
          <Column id="fixasetqty" type="STRING" size="256" sumtext="수량"/>
          <Column id="possnam" type="STRING" size="256" sumtext="취득금액"/>
          <Column id="possndd" type="STRING" size="256" sumtext="취득일"/>
          <Column id="suplplcecd" type="STRING" size="256" sumtext="구입처코드"/>
          <Column id="suplplcenm" type="STRING" size="256" sumtext="구입처"/>
          <Column id="mngtdeptcd" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="mngtdeptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="installplcecd" type="STRING" size="256" sumtext="설치장소코드"/>
          <Column id="installplcenm" type="STRING" size="256" sumtext="설치장소"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send_search" columnid="instcd"/>
      <BindItem id="item1" compid="grp_sea.ipt_dcusno" propid="value" datasetid="ds_send_search" columnid=""/>
      <BindItem id="item2" compid="grp_sea.ipt_reqdeptcd_search" propid="value" datasetid="ds_send_search" columnid="reqdeptcd"/>
      <BindItem id="item3" compid="grp_sea.opt_reqdeptnm_search" propid="value" datasetid="ds_send_search" columnid="reqdeptnm"/>
    </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 SMRSC20410_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRSC20410_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_reqeqitrdlist);
	grdf_setRowTypeIcon(grd_reqeqitrdlist, 0);

	misfGridInit(grd_reqeqitrdlist);
	misfMsterDetailSet(grd_reqeqitrdlist ,null, "TRRSC20411", "Y","free");
	misfComboComCdList("Z0007",grp_sea.cmb_instcd);
	grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
}

function ds_send_search_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "reqdetpcd")
	{
		grp_sea.ipt_reqdeptcd_search.value = e.newvalue;
		grp_sea.ipt_reqdeptcd_search.setFocus();
		
		if(String(e.newvalue).length == 0) 
		{
			grp_sea.opt_reqdeptnm_search.value = "";
		}
		else 
		{
			misfValidationCheck("02", "", "reqdeptcd,reqdeptnm", grp_sea.cmb_instcd.value, "instcd" );
		}
	}						
}

function grp_sea_btn_reqdeptcd_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var recv_list = "reqdeptcd,reqdeptnm";
	misfOpenPopUpList("02", grp_sea.ipt_reqdeptcd_search,"", recv_list, grp_sea.cmb_instcd.value, "instcd") ; 		
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridInit(grd_reqeqitrdlist);
	misfMsterDetailRetrieve();
}

function btn_excelsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_reqeqitrdlist, "도입장비목록_"+utlf_getCurrentDate(), "Sheet1", "true", "", "");
}
]]></Script>
  </Form>
</FDL>