Nexacro - Dateset 관련 Javascript

농부지기 2017. 1. 19. 14:30

[ Nexacro - Dateset 관련 Javascript]

/* DataSet의 값이 변경되었는지 체크
@param objDs : DataSet @return : 변경되었을 경우 true 리턴
*/
function gfn_isDsUpdate(objDs)
{
	if(objDs.getDeletedRowCount() > 0) return true;
	
	for(var i=0; i<objDs.getRowCount(); i++){
	    if(objDs.getRowType(i) != 1){
	        return true;
	    }
	}
	return false;
}

/* DataSet 필수입력값 체크
Grid 객체를 인자로 넘길 경우 해당 Cell에 focus됨. @param objComp Dataset or Grid
@param sColid Column ID 예) "Column_ID1=SAMPLE_NM1,Column_ID2=SAMPLE_NM2" @param bNormalType : RowType값이 normal(1) 인 상태도 체크할지 유무 ( default : false )
@return boolean 예)
var sCheckCol = "divisionCode=division code,siteGroup=site group"; if(!gfn_valueCheck(ds_siteMaster, sCheckCol)) return false;
*/
function gfn_valueCheck(objComp, sColid, bNormalType)
{
	var objDs, objGrid;
	
	if(bNormalType == null) bNormalType = false; // ROWTYPE_NORMAL 체크유무 
	
	if(objComp instanceof Grid){
	    objGrid = objComp;
	    objDs = this.all[objGrid.binddataset];
	}else{
	    objDs = objComp;
	}
	
	for(var i=0; i<objDs.getColCount(); i++){
	    var objArr1; // Array
	    objArr1 = sColid.split(",");
	
	    for(var j=0; j<objArr1.length; j++){
	        var objArr2; // Array
	        objArr2 = objArr1[j].split("=");
	        if(objDs.getColID(i) == objArr2[0]){
	            var nIdx = -1;
	            for(var k = 0;k<objDs.getRowCount();k++){
	                if(gfn_isNull(objDs.getColumn(k,i))){
	                    var nRowType = objDs.getRowType(k); //RowType 체크 
	                    if(bNormalType == false && nRowType == 1) continue;
	                    if(nRowType == 2 || nRowType == 4 || nRowType == 1){
	                        nIdx = k;
	                        break;
	                    }
	                }
	            }
	            if(nIdx > -1){
	            alert('ok>> ');
	            alert('ok>> ' + objArr2[1]);
	                gfn_alert("requisite.required","[" + objArr2[1] + "]");
	                objDs.rowposition = nIdx;
	
	                if(objGrid != null){
	                    var nCol = gfn_getColumnIdx(objGrid,objArr2[0]);
	                    if(nCol > -1){
	                        var sGridSelType = objGrid.selecttype;
	                        objGrid.selecttype = "currow";
	                        objGrid.setCellPos(nCol);
	                        objGrid.showEditor();
	                        objGrid.selecttype = sGridSelType;
	                    }
	                }
	                return false;
	            }
	        }
	    }//for
	}
	
	return true;
}

/**
desc : 필수입력 체크
param : dsObj - 해당 dataset
coildList(List) - 필수 입력 컬럼(List 형태)
grdObj - 해당 그리드

ex) if(!gfn_requiredVaildCheck(ds_aggregateShipment, ["siteId","type","qty","validYn"], div_data.grd_detailGrid,[1,2,3])){        
        return false;
    }
*/
function gfn_requiredVaildCheck(dsObj,colIdList,grdObj)
{
	var msg, colIndex;
	
	msg ="";
	
	if( dsObj.getRowCount() > 0 ){
	    for( var i=0,cnt=dsObj.getRowCount(); i<cnt; i++ ){
	        if( dsObj.getRowType(i)!=1 && dsObj.getColumn(i,"chk")=="1" ){
	            for( var j=0; j<colIdList.length;j++){
	                if(gfn_isNull(dsObj.getColumn(i,colIdList[j]))){                        
	                    msg = grdObj.getCellProperty("head",grdObj.getBindCellIndex("body",colIdList[j]),"text");                            
	
	                    colIndex = grdObj.getBindCellIndex("body",colIdList[j]);
	                    gfn_alert("dev.warn.com.input", "["+msg+"]");                    
	                    dsObj.rowposition = i;                    
	                    grdObj.setCellPos(colIndex);                        
	                    grdObj.showEditor(true);
	                    return false;
	                }
	            }            
	        }            
	    }
	    return true;
	}
}

/**
desc : 필수입력 체크
param : dsObj - 해당 dataset
coildList(List) - 필수 입력 컬럼(List 형태)
grdObj - 해당 그리드

ex) if(!gfn_requiredVaildCheck(ds_aggregateShipment, ["siteId","type","qty","validYn"], div_data.grd_detailGrid,[1,2,3])){        
        return false;
    }
*/
function gfn_requiredVaild(dsObj,colIdList,grdObj)
{
	var msg, colIndex;
	
	msg ="";
	
	if( dsObj.getRowCount() > 0 ){
	    for( var i=0,cnt=dsObj.getRowCount(); i<cnt; i++ ){
	        if( dsObj.getRowType(i)!=1 ){
	            for( var j=0; j<colIdList.length;j++){
	                if(gfn_isNull(dsObj.getColumn(i,colIdList[j]))){                        
	                    msg = grdObj.getCellProperty("head",grdObj.getBindCellIndex("body",colIdList[j]),"text");                            
	
	                    colIndex = grdObj.getBindCellIndex("body",colIdList[j]);
	                    gfn_alert("dev.warn.com.input", "["+msg+"]");                    
	                    dsObj.rowposition = i;                    
	                    grdObj.setCellPos(colIndex);                        
	                    grdObj.showEditor(true);
	                    return false;
	                }
	            }            
	        }            
	    }
	    return true;
	}
}

/* DataSet에 Sort용 rowno 컬럼추가
@param objComp Dataset /
function gfn_addRowno(objDs)
{
	objDs.enableevent = false;
	objDs.addColumn("rowno","BIGDECIMAL");
	for(var i=0; i<objDs.rowcount; i++){
		objDs.setColumn(i,"rowno",i+1);
	}
	objDs.enableevent = true;
	objDs.applyChange();
}

/* 좌측 DataSet에 선택안했을시 전체 선택용 처리
@param objComp Dataset /
function gfn_datasetchk(toDataset, fromDataset)
{

if(isValidObject("cds_Site")==false)
	{
	    var strDsName="cds_Site";
	    //Dataset 생성
	    var objDataset     = new Dataset;
	    objDataset.name    = strDsName; 
	    this.addChild(strDsName, objDataset);
	}
	
	if(fromDataset.getCaseCount("chk == '1'") == 0)
	{
	    cds_Site.copyData(fromDataset,true);
	    cds_Site.filter("lvl == 4");
	    toDataset.clearData();
	    toDataset.copyData(cds_Site,true);
	    // Body셋팅
	    for(var i=0 ; i< toDataset.rowcount ; i++)
	    {
	        toDataset.setColumn(i, "chk", "1");
	    }
	}
	else
	{
	    cds_Site.copyData(fromDataset,true);
	    cds_Site.filter("lvl == 4 && chk == '1'");
	    toDataset.clearData();
	    toDataset.copyData(cds_Site,true);
	}
}

/* 좌측 DataSet에 To_Site에 선택된 Exception Site From 연계
@param objComp Dataset /
function gfn_exceptionBod(Todataset, Fromdataset)
{
	// 2014.02.24 일 변경
	if(ds_leftToSite.getCaseCount("chk == '1'") != 0)
	{
		var dsCount = gds_exceptionBod.getRowCount();
		for(var i=0 ; i< dsCount ; i++)
		{
			// To Site 체크된 항목만 들어간 데이터 셋
			var codeval = gds_exceptionBod.getColumn(i, "attribute3");
			var siteRow = Todataset.findRow("code", codeval);
			if(siteRow != -1)
			{
				var tocodeval = gds_exceptionBod.getColumn(i, "attribute4");
				var tositeRow = Todataset.findRow("code", tocodeval);
				if(tositeRow != -1)
				{
					var dsaddRow = Fromdataset.addRow();
					Fromdataset.copyRow(dsaddRow, Todataset, tositeRow);
				}
				else
				{
					var dsaddRow = Fromdataset.addRow();
					Fromdataset.copyRow(dsaddRow, Todataset, siteRow);
					Fromdataset.setColumn(dsaddRow, "code", tocodeval);
					Fromdataset.setColumn(dsaddRow, "cdname", gds_exceptionBod.getColumn(i, "attribute2"));
				}
			}
		}
	}
}

/* gfn_setDsFirstRow : 해당 dataset을 카피하면서 첫로우 셋팅해 주는 메소드 - dataset 첫 row setting
@param dsSetObj : 셋팅 대상 데이터셋 @param dsGetObj : 복사해 올 데이터셋
@param strValue : All, Select, Null 등 셋팅 값 /
function gfn_setDsFirstRow(dsSetObj, dsGetObj, strValue){
	dsSetObj.clearData();
	dsSetObj.copyData(dsGetObj);
	dsSetObj.insertRow(0);
	dsSetObj.setColumn(0, "cdname", strValue);
}

/*
@desc : 엑셀 다운로드시 조회조건을 넘기는 것에 대해 셋팅
@param : dsObj - 조회조건 셋팅 dataSet
colName - 조건명
colValue - 조건값 /
function gfn_setExcelDownSearch(dsObj, colName, colValue) {
	var aRow = dsObj.addRow();
	dsObj.setColumn(aRow,"label", colName);
	dsObj.setColumn(aRow,"value", colValue);
}

/*
@desc : 원하는 값을 찾아서 Return
@param : objDs - dataSet
sFindStr - 조건절 (A==B)
sGetColId - 찾을 컬럼명 /
function gfn_getFindValue(objDs, sFindStr, sGetColId){
	var nRow;
	
	nRow = objDs.findRowExpr(sFindStr);
	if (nRow < 0) return '';
	
	return objDs.getColumn(nRow, sGetColId);
}

/*
@desc : 조회된 Dataset에 첫번째 Row에 기본값 Set
@param : objDs - dataSet
sColList - 컬럼목록
sValueList - 값 목록
objCombo - comboname
nSelRow - 선택할 콤보 index /
function gfn_setComboDsFirstRow(objDs, sColList, sValueList, objCombo, nSelRow)
{
	var iRow = objDs.insertRow(0);
	
	var aColList   = sColList.split(',');
	var aValueList = sValueList.split(',');
	for(var i=0; i<aColList.length; i++){
	    objDs.setColumn(iRow, aColList[i] , aValueList[i]);
	}
	
	if (gfn_isExist(objCombo)) objCombo.index = nSelRow;
}

저작자표시 (새창열림)