YNU_JEUS/app_home/himed/xpapps/ast/examcurexp/xp/SMAEQ01900_핵종구매일계표.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAEQ01900" position="absolute 0 0 1202 759" titletext="핵종구매일계표" oninit="SMAEQ01900_oninit" onload="SMAEQ01900_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="핵종구매일계표" class="tit_1" position="absolute 0 0 183 23"/>
        <Div id="group2" taborder="1" class="div_SA" position="absolute 0 24 1195 59" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line1" linetype="vertical" position="absolute 1112 9 1118 24" anchor="top right"/>
              <Calendar id="input3" taborder="1" class="input_default" position="absolute 100 8 190 27" mask="yyyy-mm" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="group2_input3_onchanged" autoselect="true"/>
              <Static id="caption11" text="기준월 :" class="search_name" position="absolute 10 8 96 25"/>
              <Button id="btn_sea" taborder="2" text="조회" class="btn1" position="absolute 1125 5 1181 27" onclick="group2_btn_sea_onclick" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excsave" taborder="2" text="엑셀저장" class="btn7" position="absolute 1114 63 1194 82" onclick="btn_excsave_onclick" anchor="top right"/>
        <Shape id="line2" class="line_10" position="absolute 0 83 1195 89" anchor="left top right"/>
        <Grid id="grd_list" taborder="3" binddataset="ds_main_daysumrept_daysumreptlist" useinputpanel="false" position="absolute 0 88 1195 753" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="150"/>
                <Column size="80"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
                <Column size="50"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="품명"/>
                <Cell col="1" text="규격"/>
                <Cell col="2" text="1"/>
                <Cell col="3" text="2"/>
                <Cell col="4" text="3"/>
                <Cell col="5" text="4"/>
                <Cell col="6" text="5"/>
                <Cell col="7" text="6"/>
                <Cell col="8" text="7"/>
                <Cell col="9" text="8"/>
                <Cell col="10" text="9"/>
                <Cell col="11" text="10"/>
                <Cell col="12" text="11"/>
                <Cell col="13" text="12"/>
                <Cell col="14" text="13"/>
                <Cell col="15" text="14"/>
                <Cell col="16" text="15"/>
                <Cell col="17" text="16"/>
                <Cell col="18" text="17"/>
                <Cell col="19" text="18"/>
                <Cell col="20" text="19"/>
                <Cell col="21" text="20"/>
                <Cell col="22" text="21"/>
                <Cell col="23" text="22"/>
                <Cell col="24" text="23"/>
                <Cell col="25" text="24"/>
                <Cell col="26" text="25"/>
                <Cell col="27" text="26"/>
                <Cell col="28" text="27"/>
                <Cell col="29" text="28"/>
                <Cell col="30" text="29"/>
                <Cell col="31" text="30"/>
                <Cell col="32" text="31"/>
                <Cell col="33" text="합계"/>
              </Band>
              <Band id="body">
                <Cell style="align:left middle;" text="bind:itemnm"/>
                <Cell col="1" text="bind:specnm"/>
                <Cell col="2" displaytype="number" text="bind:d01"/>
                <Cell col="3" displaytype="number" text="bind:d02"/>
                <Cell col="4" displaytype="number" text="bind:d03"/>
                <Cell col="5" displaytype="number" text="bind:d04"/>
                <Cell col="6" displaytype="number" text="bind:d05"/>
                <Cell col="7" displaytype="number" text="bind:d06"/>
                <Cell col="8" displaytype="number" text="bind:d07"/>
                <Cell col="9" displaytype="number" text="bind:d08"/>
                <Cell col="10" displaytype="number" text="bind:d09"/>
                <Cell col="11" displaytype="number" text="bind:d10"/>
                <Cell col="12" displaytype="number" text="bind:d11"/>
                <Cell col="13" displaytype="number" text="bind:d12"/>
                <Cell col="14" displaytype="number" text="bind:d13"/>
                <Cell col="15" displaytype="number" text="bind:d14"/>
                <Cell col="16" displaytype="number" text="bind:d15"/>
                <Cell col="17" displaytype="number" text="bind:d16"/>
                <Cell col="18" displaytype="number" text="bind:d17"/>
                <Cell col="19" displaytype="number" text="bind:d18"/>
                <Cell col="20" displaytype="number" text="bind:d19"/>
                <Cell col="21" displaytype="number" text="bind:d20"/>
                <Cell col="22" displaytype="number" text="bind:d21"/>
                <Cell col="23" displaytype="number" text="bind:d22"/>
                <Cell col="24" displaytype="number" text="bind:d23"/>
                <Cell col="25" displaytype="number" text="bind:d24"/>
                <Cell col="26" displaytype="number" text="bind:d25"/>
                <Cell col="27" displaytype="number" text="bind:d26"/>
                <Cell col="28" displaytype="number" text="bind:d27"/>
                <Cell col="29" displaytype="number" text="bind:d28"/>
                <Cell col="30" displaytype="number" text="bind:d29"/>
                <Cell col="31" displaytype="number" text="bind:d30"/>
                <Cell col="32" displaytype="number" text="bind:d31"/>
                <Cell col="33" displaytype="number" text="bind:d32"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_daysumrept_daysumreptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="itemcd" type="STRING" size="256" sumtext="물품명"/>
          <Column id="itemnm" type="STRING" size="256" sumtext="물품명"/>
          <Column id="specnm" type="STRING" size="256" sumtext="물품명"/>
          <Column id="ioflag" type="STRING" size="256" sumtext="입출고구분"/>
          <Column id="d00" type="STRING" size="256" sumtext="이월량"/>
          <Column id="d01" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d02" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d03" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d04" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d05" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d06" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d07" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d08" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d09" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d10" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d11" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d12" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d13" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d14" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d15" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d16" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d17" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d18" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d19" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d20" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d21" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d22" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d23" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d24" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d25" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d26" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d27" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d28" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d29" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d30" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d31" type="STRING" size="256" sumtext="기준일"/>
          <Column id="d32" type="STRING" size="256" sumtext="월합계"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchym" type="STRING" size="256"/>
          <Column id="suppdeptcd" type="STRING" size="256"/>
          <Column id="srchflag" type="STRING" size="256"/>
          <Column id="srchbdioflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.input3" propid="value" datasetid="ds_send" columnid="srchym"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "ast_examcurexp::AEZ0001.xjs";
var vSuppdeptcd;
function SMAEQ01900_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAEQ01900_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_list);
	
	lf_aezfSetSuppDeptcd();
	
	vSuppdeptcd = frmf_getPrestDeptCd();
	
	ds_send.setColumn(0, "suppdeptcd", vSuppdeptcd);
	ds_send.setColumn(0, "srchflag", "S");
	ds_send.setColumn(0, "srchbdioflag", "I");
	ds_send.setColumn(0, "srchym", (new Date()).getDateFormat("YYYYMM"));
}

function group2_input3_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = obj.value;
	
	ds_send.setColumn(0, "srchym", String(date).substr(0,6));
}

function group2_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRAEQ01001";
		oParam.service     = "examcurebaseapp.NuclBase";
		oParam.method      = "reqGetDaySumRept";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_daysumrept_daysumreptlist=daysumreptlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAEQ01001";

	tranf_submit(oParam);

}

function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_list, "", "");	
}
]]></Script>
  </Form>
</FDL>