YNU_JEUS/app_home/himed/xpapps/ast/pharmacybasexp/xp/SMADB02800_제한약사용부서관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMADB02800" position="absolute 0 0 1204 705" titletext="제한약사용부서관리" oninit="SMADB02800_oninit" onload="SMADB02800_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 75 1195 698" id="group3" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Button position="absolute 1150 6 1192 29" id="button51" class="btn2_letter2" text="엑셀" anchor="default" onclick="group3_button51_onclick"/>
              <Button position="absolute 985 6 1038 29" id="btn_grdadd" class="btn2" text="행추가" anchor="default" onclick="group3_btn_grdadd_onclick"/>
              <Button position="absolute 1040 6 1093 29" id="btn_grdcopy" class="btn2" text="행복사" anchor="default" onclick="group3_btn_grdcopy_onclick"/>
              <Button position="absolute 1095 6 1148 29" id="btn_grddel" class="btn2" text="행삭제" anchor="default" onclick="group3_btn_grddel_onclick"/>
              <Grid position="absolute 0 32 1194 621" id="grid_limitdruglist" binddataset="ds_grid_limitdruglist" autofittype="col" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="26"/>
                      <Column size="106"/>
                      <Column size="260"/>
                      <Column size="90"/>
                      <Column size="100"/>
                      <Column size="200"/>
                      <Column size="90"/>
                      <Column size="90"/>
                      <Column size="135"/>
                      <Column size="75"/>
                      <Column size="0"/>
                      <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="olddrugcd"/>
                      <Cell col="11" text="oldorddeptcd"/>
                      <Cell col="12" text="oldtodd"/>
                      <Cell col="13" text="instcd"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head"/>
                      <Cell col="1" displaytype="text" edittype="text" text="bind:drugcd" expandshow="show"/>
                      <Cell col="2" displaytype="text" edittype="text" text="bind:drugnm"/>
                      <Cell col="3" displaytype="text" edittype="text" text="bind:orddeptcd" expandshow="show"/>
                      <Cell col="4" text="bind:orddeptnm"/>
                      <Cell col="5" displaytype="text" edittype="text" text="bind:alertmsg"/>
                      <Cell col="6" displaytype="date" edittype="date" text="bind:fromdd"/>
                      <Cell col="7" displaytype="date" edittype="date" text="bind:todd" mask="yyyy-mm-dd hh:mm:ss"/>
                      <Cell col="8" text="bind:lastupdtdt" mask="yyyy-mm-dd hh:mm:ss"/>
                      <Cell col="9" text="bind:lastupdtrid"/>
                      <Cell col="10" text="bind:olddrugcd"/>
                      <Cell col="11" text="bind:oldorddeptcd"/>
                      <Cell col="12" text="bind:oldtodd"/>
                      <Cell col="13" text="bind:instcd"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption19" text="제한약사용부서관리" class="tit_1" position="absolute 1 13 143 38"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1130 11 1186 33" onclick="btn_save_onclick"/>
        <Div id="group2" taborder="2" style="align:center top;" class="div_SA" position="absolute 1 38 1192 72">
          <Layouts>
            <Layout>
              <Static id="caption2" text="기준일자 :" class="search_name" position="absolute 5 10 96 27"/>
              <Calendar id="cal_searchdd" taborder="1" class="input_s_essential" position="absolute 95 8 195 27"/>
              <Static id="caption4" text="약품코드 :" class="search_name" position="absolute 226 10 317 27"/>
              <Edit id="inp_code" taborder="2" class="input_search" position="absolute 316 8 416 27"/>
              <Button id="button61" taborder="3" class="icon_search" position="absolute 425 10 441 26" onclick="group2_button61_onclick"/>
              <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1112 7 1118 27"/>
              <Button id="btn_sea" taborder="4" text="조회" class="btn1" position="absolute 1125 6 1181 28" onclick="group2_btn_sea_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grid_limitdruglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="drugcd" type="STRING"/>
          <Column id="drugnm" type="STRING"/>
          <Column id="orddeptcd" type="STRING"/>
          <Column id="orddeptnm" type="STRING"/>
          <Column id="alertmsg" type="STRING"/>
          <Column id="fromdd" type="STRING"/>
          <Column id="todd" type="STRING"/>
          <Column id="lastupdtdt" type="STRING"/>
          <Column id="lastupdtrid" type="STRING"/>
          <Column id="olddrugcd" type="STRING"/>
          <Column id="oldorddeptcd" type="STRING"/>
          <Column id="oldtodd" type="STRING"/>
          <Column id="instcd" type="STRING"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_searchdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchdd" type="STRING" size="256"/>
          <Column id="srchdrugcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_receivedata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_drug" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="drugcd" type="STRING" size="256"/>
          <Column id="drugnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_req" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_limitdruglist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cal_searchdd" propid="value" datasetid="ds_send_searchdata" columnid="srchdd"/>
      <BindItem id="item1" compid="group2.inp_code" propid="value" datasetid="ds_send_searchdata" columnid="srchdrugcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-02
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-02      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

var arErrorCode = new HashArray();
/******************************************************************
 * Argument          : 
 * Description       : 초기화
 ******************************************************************/
function SMADB02800_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMADB02800_onload(obj:Form, e:LoadEventInfo)
{
	//insert, update, delete 관리
	grdf_setRowTypeIcon(group3.grd_datagrid1, 0);
	
	//권한관리
	btn_save.enable 	= frmf_checkAuth("X");	//저장
	
	//조회
	group2_btn_sea_onclick();
}

/******************************************************************
 * Argument          : 
 * Description       : 조회
 ******************************************************************/
function group2_btn_sea_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRADB02801";
		oParam.service     = "pharmacybaseapp.LimitDrug";
		oParam.method      = "reqGetLimitDrugList";
		oParam.inds        = "req=ds_send_searchdata";
		oParam.outds       = "ds_grid_limitdruglist=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRADB02801";

	tranf_submit(oParam);
	ds_temp_limitdruglist.copyData(ds_grid_limitdruglist);
}

/******************************************************************
 * Argument          : 
 * Description       : 약품코드 조회
 ******************************************************************/
function group2_button61_onclick(obj:Button,  e:ClickEventInfo)
{
	getDrug();
	ds_send_searchdata.setColumn(0, "srchdrugcd", ds_drug.getColumn(0, "drugcd"));
}

function getDrug(){
	dsf_createDsRow("ds_temp_receivedata",
				 [{col:"receiveref", type:"string", size:256, val:"ds_drug"}
				 ,{col:"srchflag", type:"string", size:256, val:""}
				 ,{col:"srchcnts", type:"string", size:256, val:""}
				 ,{col:"receivedrugcd", type:"string", size:256, val:"drugcd"}
				 ,{col:"receivedrugnm", type:"string", size:256, val:"drugnm"}
				 ,{col:"drugkind", type:"string", size:256, val:""}],true);
	
	var objArg = new Object();
	objArg.arg_ds_temp_receivedata = ds_temp_receivedata;
	frmf_modal("SPADB60100", "SPADB60100", objArg, null, null, null, null, null, null, null, null, null, "M");
}

/******************************************************************
 * Argument          : 
 * Description       : 행추가
 ******************************************************************/
function group3_btn_grdadd_onclick(obj:Button,  e:ClickEventInfo)
{
	var iRow = ds_grid_limitdruglist.addRow();
	ds_grid_limitdruglist.setColumn(iRown, "fromdd", utlf_getCurrentDate());
	ds_grid_limitdruglist.setColumn(iRown, "todd", "99991231");
}

/******************************************************************
 * Argument          : 
 * Description       : 행복사
 ******************************************************************/
function group3_btn_grdcopy_onclick(obj:Button,  e:ClickEventInfo)
{
	var addRow = ds_grid_limitdruglist.insertRow( ds_grid_limitdruglist.rowposition + 1 );
	ds_grid_limitdruglist.copyRow(addRow, ds_grid_limitdruglist, ds_grid_limitdruglist.rowposition - 1);
	//ds_grid_limitdruglist.setColumn(group3.grid_limitdruglist.currentrow, "todd", "99991231");
}

/******************************************************************
 * Argument          : 
 * Description       : 행삭제
 ******************************************************************/
function group3_btn_grddel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_setStatus(group3.grid_limitdruglist, "D", grdf_getSelectedRows(group3.grid_limitdruglist));
}

/******************************************************************
 * Argument          : 
 * Description       : Excel
 ******************************************************************/
function group3_button51_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_grid_limitdruglist.rowcount > 0 ){
		grdf_exportExcel(group3.grid_limitdruglist, "제한약사용부서관리", "제한약사용부서관리", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}

/******************************************************************
 * Argument          : 
 * Description       : 저장
 ******************************************************************/
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	if( sysf_messageBox("제한약사용부서", "Q002") != 6 ){
		return;
	}

	var oDsUpdate = grdf_getGridUpdateData(group3.grid_limitdruglist);

	if( oDsUpdate.rowcount < 1 ){
		sysf_messageBox("입력","E013");
		return;
	}
	
	grdf_setStatusColumn(oDsUpdate, "m");			// 각행의 status에 rowType 값에 따라 'i', 'u', 'd'로 업데이트 시켜준다
	ds_send_req.copyData(oDsUpdate, true);

	for( var i = 0; i < ds_send_req.rowcount; i++ ){
		// 코드 null check
		if( utlf_isNull(ds_send_req.getColumn(i, "drugcd")) ){
			sysf_messageBox("약품 코드는 ","I003");
			return;
		} else {
			// 동일코드 check
			if( ds_send_req.getColumn(i, "m") == "i" ){
				for( var j = 0; j < ds_temp_datagrid1.rowcount; j++ ){
					var tDrugcd = ds_grid_limitdruglist.getColumn(j, "drugcd");
					var tDeptcd = ds_grid_limitdruglist.getColumn(j, "orddeptcd");
					var sDrugcd = ds_send_req.getColumn(i, "drugcd");
					var sDeptcd = ds_send_req.getColumn(i, "orddeptcd");
					if( tDrugcd == sDrugcd && tDeptcd == sDeptcd ){
						sysf_messageBox("동일 부서에 동일 코드가 존재합니다.","I");
						return;
					}
				}
			}
		}
	}
	
	var oParam = {};
		oParam.id          = "TXADB02801";
		oParam.service     = "pharmacybaseapp.LimitDrug";
		oParam.method      = "reqExeLimitDrugList";
		oParam.inds        = "req=ds_send_req";
		oParam.outds       = "ds_grid_limitdruglist=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TXADB02801";

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