YNU_JEUS/app_home/himed/xpapps/lis/diagtestbaseinfomngtxp/xp/SMLMF00100_배양균코드관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLMF00100" position="absolute 0 0 1256 805" titletext="New Form" onload="SMLMF00100_onload">
    <Layouts>
      <Layout>
        <Grid id="grd_cddetl" class="CSS::lis.css" taborder="0" useinputpanel="true" position="absolute 0 97 1256 805" anchor="all" autofittype="none" binddataset="ds_grid_grd_cddetl" positiontype="position" autoenter="select" cellsizingtype="both" oncloseup="grd_cddetl_oncloseup">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="324"/>
                <Column size="106"/>
                <Column size="0"/>
                <Column size="120"/>
                <Column size="271"/>
                <Column size="115"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="103"/>
                <Column size="99"/>
                <Column size="84"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="35" band="head"/>
                <Row size="20"/>
              </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="배양균속&#13;&#10;코드"/>
                <Cell col="7" text="보고&#13;&#10;그룹"/>
                <Cell col="8" text="배양균명(약어)"/>
                <Cell col="9" text="배양균명(화면)"/>
                <Cell col="10" text="배양균명(출력)"/>
                <Cell col="11" text="Division"/>
                <Cell col="12" text="GRAM"/>
                <Cell col="13" text="감염정보"/>
                <Cell col="14" text="감염정보&#13;&#10;항균제"/>
                <Cell col="15" text="감염정보&#13;&#10;판정"/>
                <Cell col="16" text="checkcolor"/>
                <Cell col="17" text="BC&#13;&#10;양성률"/>
                <Cell col="18" displaytype="normal" edittype="none" text="ESBL"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" displaytype="image" expr="expr:getRowType(currow) == 2 ?'theme://images/ico_i.png' : (getRowType(currow) == 4 ? 'theme://images/ico_u.png' : (getRowType(currow) == 8 ? 'theme://images/ico_d.png' : 'theme://images/ico_e.png'))"/>
                <Cell col="2" displaytype="date" edittype="date" text="bind:baccdfromdd"/>
                <Cell col="3" displaytype="date" edittype="date" text="bind:baccdtodd"/>
                <Cell col="4" displaytype="text" edittype="text" text="bind:baccd" editlimit="10"/>
                <Cell col="5" displaytype="text" edittype="text" text="bind:bacnm" editlimit="80"/>
                <Cell col="6" displaytype="combo" edittype="combo" class="input_essential3" text="bind:bacgenscd" editlimit="5" combodataset="ds_init_lb0201" combocodecol="cd" combodatacol="nm"/>
                <Cell col="7" displaytype="combo" edittype="combo" text="bind:bacrptgrpcd" combodataset="ds_init_lb0301" combocodecol="cd" combodatacol="nm"/>
                <Cell col="8" displaytype="text" edittype="text" text="bind:bacabbrnm" editlimit="20"/>
                <Cell col="9" displaytype="text" edittype="text" text="bind:bacscrnnm" editlimit="80"/>
                <Cell col="10" displaytype="text" edittype="text" text="bind:bacprntnm" editlimit="10"/>
                <Cell col="11" displaytype="text" edittype="text" style="align:left;" text="bind:division"/>
                <Cell col="12" displaytype="text" edittype="text" style="align:left;" text="bind:gram"/>
                <Cell col="13" displaytype="text" edittype="text" text="bind:infcinfo" editlimit="50"/>
                <Cell col="14" displaytype="text" edittype="text" text="bind:infcrefantbiocd" editlimit="10"/>
                <Cell col="15" displaytype="text" edittype="text" text="bind:infcrefchar" editlimit="5"/>
                <Cell col="16" text="bind:checkcolor"/>
                <Cell col="17" displaytype="combo" edittype="combo" text="bind:division2" combodataset="ds_init_bc" combocodecol="cd" combodatacol="nm"/>
                <Cell col="18" displaytype="checkbox" edittype="checkbox" text="bind:esbl"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption2" text="배양균코드상세내역" class="tit_2" position="absolute 0 77 142 97" positiontype="position"/>
        <Button id="btn_addrow" taborder="1" text="행추가" class="btn2" position="absolute 1200 74 1256 94" anchor="top right" positiontype="position" onclick="btn_addrow_onclick"/>
        <Div id="group1" taborder="2" position="absolute 0 25 1256 67" anchor="left top right" positiontype="position" class="div_SA">
          <Layouts>
            <Layout>
              <Shape id="line3" linetype="vertical" class="line_4" position="absolute 1108 7 1108 29" positiontype="position"/>
              <Static id="caption1" text="조회구분" class="search_name" position="absolute 8 10 82 30" positiontype="position"/>
              <Shape id="line14" linetype="vertical" class="line_4" position="absolute 273 6 273 28" positiontype="position"/>
              <Static id="caption4" text="검색구분" class="search_name" position="absolute 776 13 850 30" positiontype="position" anchor="top right"/>
              <Combo id="cmb_refflag" taborder="1" class="combo_search" position="absolute 82 10 232 30" positiontype="position" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="group1_cmb_refflag_onitemchanged" index="0" value="1" text="사용가능자료">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">사용가능자료</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">전체자료</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Button id="btn_ref" taborder="2" text="조회" class="btn1" position="absolute 235 10 291 30" anchor="left top" positiontype="position" onclick="group1_btn_ref_onclick"/>
              <Combo id="cmb_search" taborder="3" class="combo_search" position="absolute 850 10 1000 30" positiontype="position" codecolumn="codecolumn" datacolumn="datacolumn" index="0" value="1" text="코드" anchor="top right">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">코드</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">코드명</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Edit id="ipt_searchtext" taborder="4" class="input_search" position="absolute 1003 10 1113 30" imemode="hangul" positiontype="position" onkeydown="group1_ipt_searchtext_onkeydown" anchor="top right"/>
              <Button id="btn_reset" taborder="5" text="초기화" class="btn1" position="absolute 1175 10 1244 30" anchor="top right" positiontype="position" onclick="group1_btn_reset_onclick"/>
              <Button id="btn_search" taborder="6" text="검색" class="btn1" position="absolute 1116 10 1172 30" anchor="top right" onclick="group1_btn_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_save" taborder="4" text="저장" onlbuttonup="btn_save_onlbuttonup" class="btn4" position="absolute 1200 0 1256 20" anchor="top right" positiontype="position" onclick="btn_save_onclick"/>
        <Static id="caption6" text="배양균코드관리" class="tit_1" position="absolute 0 0 155 25" positiontype="position"/>
        <Button id="btn_excel" taborder="5" text="엑셀" class="btn7" position="absolute 1145 74 1198 94" onclick="btn_excel_onclick" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grid_grd_cddetl" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false" oncolumnchanged="ds_grid_grd_cddetl_oncolumnchanged">
        <ColumnInfo>
          <Column id="baccdfromdd" type="STRING"/>
          <Column id="baccdtodd" type="STRING"/>
          <Column id="baccd" type="STRING"/>
          <Column id="bacnm" type="STRING"/>
          <Column id="bacgenscd" type="STRING"/>
          <Column id="bacabbrnm" type="STRING"/>
          <Column id="bacscrnnm" type="STRING"/>
          <Column id="bacprntnm" type="STRING"/>
          <Column id="infcinfo" type="STRING"/>
          <Column id="infcrefantbiocd" type="STRING"/>
          <Column id="infcrefchar" type="STRING"/>
          <Column id="checkcolor" type="STRING" size="256"/>
          <Column id="esbl" type="STRING" size="256"/>
          <Column id="bacrptgrpcd" type="STRING" size="256"/>
          <Column id="division" type="STRING" size="256"/>
          <Column id="gram" type="STRING" size="256"/>
          <Column id="division2" type="STRING" size="256"/>
          <Column id="division3" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0201" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_grd_select" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="chk" type="STRING" size="256"/>
          <Column id="baccd" type="STRING" size="256"/>
          <Column id="bacnm" type="STRING" size="256"/>
          <Column id="bacabbrnm" type="STRING" size="256"/>
          <Column id="bacscrnnm" type="STRING" size="256"/>
          <Column id="bacprntnm" type="STRING" size="256"/>
          <Column id="checkcolor" type="STRING" size="256"/>
          <Column id="esbl" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_lb0301" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_database_instcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_bc" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cd" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
          <Row>
            <Col id="cd">P</Col>
            <Col id="nm">오염</Col>
          </Row>
          <Row>
            <Col id="cd">C</Col>
            <Col id="nm">CNS</Col>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item41" compid="btn_excel" propid="enable" datasetid="ds_print" columnid="able"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-09
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-09      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";
include "lis_commonxp::LLZ001.xjs";
include "lis_commonxp::LZZ001.xjs";


var lgv_sInstCd   = sysf_getUserInfo("dutplceinstcd");
var lgv_sTargetDb = "";

function SMLMF00100_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);
	lf_initDataSet();    
	
	var sCol = grd_cddetl.getBindCellIndex("body", "checkcolor");
	if (sCol > -1)
	{
		grd_cddetl.setFormatColProperty(sCol,"size",0);
	}
	
    // 조회
    lf_GetCddetlSearch("1");
	// 그리드 sort
	grdf_setGridSort(grd_cddetl);	
}

function lf_GetCddetlSearch(btnf){

	var sInDsName = dsf_createDsRow("in_ds_search"
	                             , [{col: "refgbn", val: group1.cmb_refflag.value}	
	                             ,  {col: "searchgbn", val: group1.cmb_search.value}
	                             ,  {col: "searchnm", val: group1.ipt_searchtext.value}
							     ,  {col: "btnflag", val: btnf}
							     ,  {col: "cendb", val: lgv_sTargetDb}
								 ,  {col: "instcd", val: lgv_sInstCd}]);									
	ds_grid_grd_cddetl.clearData();		
		
	var oParam = {};
		oParam.id          = "TRLMF00101";
		oParam.service     = "diagtestbaseinfomngtapp.MicroTestBaseInfoMngt";
		oParam.method      = "reqGetBacList";
		oParam.inds        = "cond="+sInDsName;
		oParam.outds       = "ds_grid_grd_cddetl=baclist";
		oParam.async       = false;
		oParam.callback    = "cbf_SMLMF00100";

	tranf_submit(oParam);
}


function lf_initDataSet(){
	lf_getDbDeptcd("0000|0201|0301|","cbf_SMLMF00100");
}

//저장
function lf_saveCddetlInfo(){				
	
	var oParam = {};
		oParam.id          = "TXLMF00101";
		oParam.service     = "diagtestbaseinfomngtapp.MicroTestBaseInfoMngt";
		oParam.method      = "reqExeBacList";
		oParam.inds        = "cond=ds_grid_grd_cddetl:U";
		oParam.outds       = "ds_grid_grd_cddetl=baclist";
		oParam.async       = false;
		oParam.callback    = "cbf_SMLMF00100";

	tranf_submit(oParam);			

}

//콜백함수
function cbf_SMLMF00100(strSvcID, nErrorCode, strErrorMag){
	if(nErrorCode != 0) sysf_messageBox("ID: " + strSvcID + "  Error: " + strErrorMag, "E009", "");	
	if(strSvcID == "TXLMF00101" && nErrorCode==0){
		sysf_messageBox("","I001","");
	}
	lf_changeColor();
}	


// 필수 값 체크
function lf_ckeckNull()
{		
	 var bChkValue= frmf_chkMdtGrid(grd_cddetl,[2,3,4],["사용시작일자","사용종료일자","배양균코드"]);
	 if(bChkValue==true) lf_saveCddetlInfo();

}



//종료된 데이타 색깔 바꾸기
function lf_changeColor(){
	var i =0;
	var j =0;
	if (ds_grid_grd_cddetl.rowcount == 0) return;
	var sExpr = "EXPR(checkcolor)";
	//Row색깔 투입
	ds_grid_grd_cddetl.updatecontrol = false ;
	for(j=0; j < ds_grid_grd_cddetl.rowcount; j++){
		if (ds_grid_grd_cddetl.getColumn(j,"baccdtodd") < utlf_getCurrentDate()) {
			ds_grid_grd_cddetl.setColumn(j, "checkcolor", "yellow");			
		} else {
			ds_grid_grd_cddetl.setColumn(j, "checkcolor", "default");	
		}
		ds_grid_grd_cddetl.setRowType(j,"1");		
	}	
	ds_grid_grd_cddetl.updatecontrol = true ;
	//색깔변경
	for (i=0; i < grd_cddetl.getCellCount('Head'); i++ ) {  						
		grd_cddetl.setCellProperty("Body",i,"background", sExpr); 
		grd_cddetl.setCellProperty("Body",i,"background2", sExpr); 		
	}	
}

 //조회버튼
function group1_btn_ref_onclick(obj:Button,  e:ClickEventInfo)
{
	lf_GetCddetlSearch("1");
}

//검색버튼
function group1_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	lf_GetCddetlSearch("2");
}

 //초키화
function group1_btn_reset_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_grid_grd_cddetl.clearData();
}

 //행추가
function btn_addrow_onclick(obj:Button,  e:ClickEventInfo)
{

	var nRow =0;
	var nSeq =0;
	var objArg = new Object();
	objArg.sDeptFlag = ds_init_lb0201.getColumn(0,"nm");
	ds_grid_grd_select.clearData();
	frmf_modal("SPLMF10100", "SPLMF10100", objArg, "", "", "", "", "", "", "", "", "", "M");
	
	for(var i=0; i < ds_grid_grd_select.rowcount;i++){		
		if(ds_grid_grd_select.getColumn(i,"chk")==1){
			nRow = ds_grid_grd_cddetl.addRow();			
			ds_grid_grd_cddetl.setColumn(nRow,"baccdfromdd",utlf_getCurrentDate());
			ds_grid_grd_cddetl.setColumn(nRow,"baccdtodd","99991231");				
			ds_grid_grd_cddetl.setColumn(nRow,"baccd",ds_grid_grd_select.getColumn(i,"baccd"));	
			ds_grid_grd_cddetl.setColumn(nRow,"bacnm",ds_grid_grd_select.getColumn(i,"bacnm"));	
			ds_grid_grd_cddetl.setColumn(nRow,"bacabbrnm",ds_grid_grd_select.getColumn(i,"bacabbrnm"));	
			ds_grid_grd_cddetl.setColumn(nRow,"bacscrnnm",ds_grid_grd_select.getColumn(i,"bacscrnnm"));	
			ds_grid_grd_cddetl.setColumn(nRow,"bacprntnm",ds_grid_grd_select.getColumn(i,"bacprntnm"));	
		}
	}
}

 //저장
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{	
	lf_ckeckNull();
}

 //검색어 입력 후 엔터
function group1_ipt_searchtext_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode=="13") lf_GetCddetlSearch("2");
}

 // 시작일자 종료일자 체크
function ds_grid_grd_cddetl_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	var fromdd = ds_grid_grd_cddetl.getColumn(e.row,"baccdfromdd");
	var todd = ds_grid_grd_cddetl.getColumn(e.row,"baccdtodd");	
	
	// 종료일자체크
	if((e.columnid == "baccdtodd") || (e.columnid == "baccdfromdd")){
		if(fromdd != "" && todd != "") {
			if(fromdd > todd){
				sysf_messageBox("종료일자가 시작일자보다 이전 날짜입니다.", "I","");				 
				 ds_grid_grd_cddetl.setColumn(e.row,"baccdtodd",ds_grid_grd_cddetl.getOrgColumn(e.row,"baccdtodd"));
			}
		}
	}
}

function grd_cddetl_oncloseup(obj:Grid, e:GridEditEventInfo)
{
	grd_cddetl.updateToDataset();
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	var saveName = "배양균코드";
	
	if(!utlf_isNull(saveName)) {
		grdf_exportExcel(grd_cddetl, lf_lisGetTitle(this) + "_","sheet",false);
	}	
}
]]></Script>
  </Form>
</FDL>