Sio's Programming

평가방법 100% 체크 본문

업무 공부/neXacro

평가방법 100% 체크

SSio 2018. 10. 23. 09:47


/*********************************************************************************************************************************

 * 평가방법을 입력 시 100%가 넘으면 알림

 *  평가방법을 입력 시 합계에 자동계산으로 표시

 *********************************************************************************************************************************/

this.ds_tabpage01_grid01_oncolumnchanged = function(obj:Dataset, e:nexacro.DSColChangeEventInfo)

{

    var mid = 0;

var gimal = 0;

var susi = 0;

var silseup = 0;

var chulse = 0;

var total_Sum = 0;

var testArr = new Array();

if(e.columnid == "MID_SIHEOM_RATE" || e.columnid == "GIMAL_SIHEOM_RATE" || e.columnid == "SUSI_RATE"

|| e.columnid == "SILSEUP_RATE" || e.columnid == "CHULSEOK_RATE")

{

mid = Number(obj.getColumn(obj.rowposition,"MID_SIHEOM_RATE"));

gimal = Number(obj.getColumn(obj.rowposition,"GIMAL_SIHEOM_RATE"));

susi = Number(obj.getColumn(obj.rowposition,"SUSI_RATE"));

silseup = Number(obj.getColumn(obj.rowposition,"SILSEUP_RATE"));

chulseok = Number(obj.getColumn(obj.rowposition,"CHULSEOK_RATE"));

testArr = [mid, gimal, susi, silseup, chulseok];

for(var i = 0; i < testArr.length; i++)

{

total_Sum += testArr[i];

}

this.ds_tabpage01_grid01.setColumn(obj.rowposition,"BANGBEOB_SUM",total_Sum);

var value = this.ds_tabpage01_grid01.getColumn(obj.rowposition,"BANGBEOB_SUM");

if(value > 100)

{

alert("평가방법의 합은 100%를 넘길 수 없습니다.");

obj.setColumn(obj.rowposition,"MID_SIHEOM_RATE","");

obj.setColumn(obj.rowposition,"GIMAL_SIHEOM_RATE","");

obj.setColumn(obj.rowposition,"SUSI_RATE","");

obj.setColumn(obj.rowposition,"SILSEUP_RATE","");

obj.setColumn(obj.rowposition,"CHULSEOK_RATE","");

obj.setColumn(obj.rowposition,"BANGBEOB_SUM","");

return obj.rowposition;

}


}

}