글 수 7,449
황영신
조회 수 : 19689
2009.05.19 (08:03:01)
문의드리려고 한 데이타가 인사 정보여서, 데이타를 수정하느라 늦었습니다.^^;
회사 내규상 외부 메일와 첨부파일은 결제를 받아야 해서 아래와 같이 보내는 점 양해바랍니다.
확인해 보시고 답변 부탁드립니다.
혹시 통화가 필요하면,
02)3480-5536 번으로 전화주시면 됩니다.
-- ds_family 헤더 정보
rowkey:STRING:NORMALTYPE:NORMALKEY,nationality:STRING:NORMALTYPE:NORMALKEY,resRegNo:STRING:NORMALTYPE:NORMALKEY,emp:STRING:NORMALTYPE:NORMALKEY,toDate:STRING:NORMALTYPE:NORMALKEY,famNm:STRING:NORMALTYPE:NORMALKEY,yetaRelation:STRING:NORMALTYPE:NORMALKEY,insrDedctYn:STRING:NORMALTYPE:NORMALKEY,childBringYn:STRING:NORMALTYPE:NORMALKEY,creditCardYn:STRING:NORMALTYPE:NORMALKEY,eduDedctYn:STRING:NORMALTYPE:NORMALKEY,basicDedctYn:STRING:NORMALTYPE:NORMALKEY,disabledDedctYn:STRING:NORMALTYPE:NORMALKEY,medAmtDedctYn:STRING:NORMALTYPE:NORMALKEY,insrAmt1:BIGINT:NORMALTYPE:NORMALKEY,insrAmt2:BIGINT:NORMALTYPE:NORMALKEY,disableInsr1:BIGINT:NORMALTYPE:NORMALKEY,disableInsr2:BIGINT:NORMALTYPE:NORMALKEY,eduPsnlExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduPsnlExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduPreschoolExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduPreschoolExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduSchoolExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduSchoolExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduUnivExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduUnivExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduDisableExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduDisableExpn2:BIGINT:NORMALTYPE:NORMALKEY,creditCard1:BIGINT:NORMALTYPE:NORMALKEY,creditCard2:BIGINT:NORMALTYPE:NORMALKEY,creditCardMed1:BIGINT:NORMALTYPE:NORMALKEY,creditCardMed2:BIGINT:NORMALTYPE:NORMALKEY,cashReceipt1:BIGINT:NORMALTYPE:NORMALKEY,cashReceipt2:BIGINT:NORMALTYPE:NORMALKEY,cashReceiptMed1:BIGINT:NORMALTYPE:NORMALKEY,cashReceiptMed2:BIGINT:NORMALTYPE:NORMALKEY,debitCard1:BIGINT:NORMALTYPE:NORMALKEY,debitCard2:BIGINT:NORMALTYPE:NORMALKEY,debitCardMed1:BIGINT:NORMALTYPE:NORMALKEY,debitCardMed2:BIGINT:NORMALTYPE:NORMALKEY,childBirthYn:STRING:NORMALTYPE:NORMALKEY,multiChildYn:STRING:NORMALTYPE:NORMALKEY,respectYn:STRING:NORMALTYPE:NORMALKEY
"AAAPknAAOAAAvbyAAU","내국인","","19308090","20081231","신**","4","F","T","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","T","F"
"AAAPknAAOAAAvbyAAT","내국인","","19308090","20081231","신**","4","F","T","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","T","F"
"AAAPknAAOAAAvbyAAR","내국인","","19308090","20081231","신**","1","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","T"
"AAAPknAAOAAAvbyAAS","내국인","","19308090","20081231","주**","1","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","T"
"AAAPknAAOAAAvbyAAP","내국인","","19308090","20081231","신**","0","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","F"
"AAAPknAAOAAAvbyAAQ","내국인","","19308090","20081231","임**","3","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","F"
-- H0402YetaInputForm_E.html
<html><head>
<script language=javascript>var frame; try{frame = window.external.GetFrame(window);}catch(e){frame=null;} function _include(nUrl){return 0;}</script><script language=VBScript src="arf.vbs"></script>
<style >
@import url('../../../../css/style.gss');
#panel_main {
background-image : url('../../../../images/mainBg04.gif');
}
@import url('../../../../css/style.gss');
#panel_main {
background-image : url('../../../../images/mainBg01.gif');
}
</style>
<script language=javascript>function _prodigy_static_instance_print(_reference_static_instance_id, _target_dataset_id){var _childNode;var _childNodeName;var _prodigy_static_data_format, _prodigy_static_data_head, _prodigy_static_data_data;var _prodigy_static_root;try {_prodigy_static_root = _reference_static_instance_id.firstChild;_prodigy_static_data_format="", _prodigy_static_data_head="", _prodigy_static_data_data = "";for( _childNode = _prodigy_static_root.firstChild; _childNode != null ; _childNode = _childNode.nextSibling){_childNodeName = _childNode.nodeName.toLowerCase();if( _childNodeName == "format" ){_prodigy_static_data_format = _childNode.text;}else if(_childNodeName == "head-define"){_prodigy_static_data_head = _childNode.text;}else if(_childNodeName == "data" ){_prodigy_static_data_data = _childNode.text;}}if( _prodigy_static_data_head != "" && _prodigy_static_data_head != ""){_target_dataset_id.SetDataHeader(_prodigy_static_data_head);_target_dataset_id.ImportData(_prodigy_static_data_data);_target_dataset_id.ResetStatus(); }}catch(exception){window.status = "_prodigy_static_instance_print : event error(" + exception + ")";}}</script><meta name="err_lang" charset=""><meta http-equiv="content-type" content="text/html; charset=utf-8">
<comment id=CMMT_ARFDIS_ID><object classid="CLSID:AF989B7C-8AC3-40bc-B749-EB335BDFD190" id="ds_session" ></object></comment><script language=VBScript> ArfObjectUnLappedFnc(window.CMMT_ARFDIS_ID) </script>
<comment id=CMMT_ARFDIS_ID><object classid="CLSID:AF989B7C-8AC3-40bc-B749-EB335BDFD190" id="ds_family" >
<param name="syncload" value="True"><param name="viewdeletedrow" value="True">
</object></comment><script language=VBScript> ArfObjectUnLappedFnc(window.CMMT_ARFDIS_ID) </script>
</head><body id="gform" width="1014" height="600" style="" >
<div id="panel_title" style="position:absolute;left:10;top:0;width:1000;height:35;" >
</div>
<div id="panel_1" style="position:absolute;left:10;top:40;width:600;height:450;" >
</div>
<script language=JScript src="../../../../js/common.js"></script><script language=JScript src="../../../../js/commonPopup.js"></script><script language=JScript src="../../../../js/commonMsg.js"></script><script language=JScript src="../../../../js/commonCalendar.js"></script><script language=JScript src="../../../../js/commonButton.js"></script><script language=JScript src="../../../../js/commonReport.js"></script><script language=JScript src="../../../../js/biz/h04Biz.js"></script><script language="javascript" >
_include("../../../../js/common.js"); // 공통함수
_include("../../../../js/commonPopup.js"); // 팝업함수
_include("../../../../js/commonMsg.js"); // 메시지함수
_include("../../../../js/commonCalendar.js"); // 달력함수
_include("../../../../js/commonButton.js"); // 버튼함수
_include("../../../../js/commonReport.js"); // 리포트함수
_include("../../../../js/biz/h04Biz.js"); // 연말정산체크함수
function fnQuery(){
var componentName = "YETA";
var param = "&_param1=" + "19308090"
+ "&_param2=" + "20081231"
;
var serviceName = "retrieveYetaFamily"; // 호출할 메소드명(수정). Conf
fnDataSetUseCall(ds_family, componentName, serviceName, param, "returnType=0"); //컴포넌트 호출
}
function fnSave(){
var tmpStr = ds_family.Text + "n" + ds_family.ExportData(1, ds_family.CountRow, true);
document.getElementById('panel_1').style.fontSize = "12px";
document.getElementById('panel_1').style.fontFamily = '"돋움",Dotum, Arial, Geneva, sans-serif,"Malgun Gothic"';
document.getElementById('panel_1').innerText = tmpStr ;
/**
데이타 포맷
insrAmt1 | insrAmt2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
위와 같은 형태여서 아래 스크립트를 돌리면, 18이란 값이 나왔으면 하는데, 6이란 값만 나오네요~.
확인 부탁드립니다.
**/
var amt = ds_family.sum(ds_family.ColumnIndex("insrAmt1"),0,0)+ds_family.sum(ds_family.ColumnIndex("insrAmt2"),0,0);
alert(amt);
alert(typeof(ds_family.sum(ds_family.ColumnIndex("insrAmt1"),0,0)));
alert(typeof(ds_family.sum(ds_family.ColumnIndex("insrAmt2"),0,0)));
}
</script>
<script language="javascript" for="gform" event="onload" >
var btnSettingArr = ["true","true","true","false","true","false","false","true"];
var titleName = "";
fnCommonAuth(btnSettingArr, titleName);
fnQuery();
</script>
</body></html>
회사 내규상 외부 메일와 첨부파일은 결제를 받아야 해서 아래와 같이 보내는 점 양해바랍니다.
확인해 보시고 답변 부탁드립니다.
혹시 통화가 필요하면,
02)3480-5536 번으로 전화주시면 됩니다.
-- ds_family 헤더 정보
rowkey:STRING:NORMALTYPE:NORMALKEY,nationality:STRING:NORMALTYPE:NORMALKEY,resRegNo:STRING:NORMALTYPE:NORMALKEY,emp:STRING:NORMALTYPE:NORMALKEY,toDate:STRING:NORMALTYPE:NORMALKEY,famNm:STRING:NORMALTYPE:NORMALKEY,yetaRelation:STRING:NORMALTYPE:NORMALKEY,insrDedctYn:STRING:NORMALTYPE:NORMALKEY,childBringYn:STRING:NORMALTYPE:NORMALKEY,creditCardYn:STRING:NORMALTYPE:NORMALKEY,eduDedctYn:STRING:NORMALTYPE:NORMALKEY,basicDedctYn:STRING:NORMALTYPE:NORMALKEY,disabledDedctYn:STRING:NORMALTYPE:NORMALKEY,medAmtDedctYn:STRING:NORMALTYPE:NORMALKEY,insrAmt1:BIGINT:NORMALTYPE:NORMALKEY,insrAmt2:BIGINT:NORMALTYPE:NORMALKEY,disableInsr1:BIGINT:NORMALTYPE:NORMALKEY,disableInsr2:BIGINT:NORMALTYPE:NORMALKEY,eduPsnlExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduPsnlExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduPreschoolExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduPreschoolExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduSchoolExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduSchoolExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduUnivExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduUnivExpn2:BIGINT:NORMALTYPE:NORMALKEY,eduDisableExpn1:BIGINT:NORMALTYPE:NORMALKEY,eduDisableExpn2:BIGINT:NORMALTYPE:NORMALKEY,creditCard1:BIGINT:NORMALTYPE:NORMALKEY,creditCard2:BIGINT:NORMALTYPE:NORMALKEY,creditCardMed1:BIGINT:NORMALTYPE:NORMALKEY,creditCardMed2:BIGINT:NORMALTYPE:NORMALKEY,cashReceipt1:BIGINT:NORMALTYPE:NORMALKEY,cashReceipt2:BIGINT:NORMALTYPE:NORMALKEY,cashReceiptMed1:BIGINT:NORMALTYPE:NORMALKEY,cashReceiptMed2:BIGINT:NORMALTYPE:NORMALKEY,debitCard1:BIGINT:NORMALTYPE:NORMALKEY,debitCard2:BIGINT:NORMALTYPE:NORMALKEY,debitCardMed1:BIGINT:NORMALTYPE:NORMALKEY,debitCardMed2:BIGINT:NORMALTYPE:NORMALKEY,childBirthYn:STRING:NORMALTYPE:NORMALKEY,multiChildYn:STRING:NORMALTYPE:NORMALKEY,respectYn:STRING:NORMALTYPE:NORMALKEY
"AAAPknAAOAAAvbyAAU","내국인","","19308090","20081231","신**","4","F","T","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","T","F"
"AAAPknAAOAAAvbyAAT","내국인","","19308090","20081231","신**","4","F","T","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","T","F"
"AAAPknAAOAAAvbyAAR","내국인","","19308090","20081231","신**","1","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","T"
"AAAPknAAOAAAvbyAAS","내국인","","19308090","20081231","주**","1","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","T"
"AAAPknAAOAAAvbyAAP","내국인","","19308090","20081231","신**","0","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","F"
"AAAPknAAOAAAvbyAAQ","내국인","","19308090","20081231","임**","3","F","F","F","F","T","F","F",1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,"F","F","F"
-- H0402YetaInputForm_E.html
<html><head>
<script language=javascript>var frame; try{frame = window.external.GetFrame(window);}catch(e){frame=null;} function _include(nUrl){return 0;}</script><script language=VBScript src="arf.vbs"></script>
<style >
@import url('../../../../css/style.gss');
#panel_main {
background-image : url('../../../../images/mainBg04.gif');
}
@import url('../../../../css/style.gss');
#panel_main {
background-image : url('../../../../images/mainBg01.gif');
}
</style>
<script language=javascript>function _prodigy_static_instance_print(_reference_static_instance_id, _target_dataset_id){var _childNode;var _childNodeName;var _prodigy_static_data_format, _prodigy_static_data_head, _prodigy_static_data_data;var _prodigy_static_root;try {_prodigy_static_root = _reference_static_instance_id.firstChild;_prodigy_static_data_format="", _prodigy_static_data_head="", _prodigy_static_data_data = "";for( _childNode = _prodigy_static_root.firstChild; _childNode != null ; _childNode = _childNode.nextSibling){_childNodeName = _childNode.nodeName.toLowerCase();if( _childNodeName == "format" ){_prodigy_static_data_format = _childNode.text;}else if(_childNodeName == "head-define"){_prodigy_static_data_head = _childNode.text;}else if(_childNodeName == "data" ){_prodigy_static_data_data = _childNode.text;}}if( _prodigy_static_data_head != "" && _prodigy_static_data_head != ""){_target_dataset_id.SetDataHeader(_prodigy_static_data_head);_target_dataset_id.ImportData(_prodigy_static_data_data);_target_dataset_id.ResetStatus(); }}catch(exception){window.status = "_prodigy_static_instance_print : event error(" + exception + ")";}}</script><meta name="err_lang" charset=""><meta http-equiv="content-type" content="text/html; charset=utf-8">
<comment id=CMMT_ARFDIS_ID><object classid="CLSID:AF989B7C-8AC3-40bc-B749-EB335BDFD190" id="ds_session" ></object></comment><script language=VBScript> ArfObjectUnLappedFnc(window.CMMT_ARFDIS_ID) </script>
<comment id=CMMT_ARFDIS_ID><object classid="CLSID:AF989B7C-8AC3-40bc-B749-EB335BDFD190" id="ds_family" >
<param name="syncload" value="True"><param name="viewdeletedrow" value="True">
</object></comment><script language=VBScript> ArfObjectUnLappedFnc(window.CMMT_ARFDIS_ID) </script>
</head><body id="gform" width="1014" height="600" style="" >
<div id="panel_title" style="position:absolute;left:10;top:0;width:1000;height:35;" >
</div>
<div id="panel_1" style="position:absolute;left:10;top:40;width:600;height:450;" >
</div>
<script language=JScript src="../../../../js/common.js"></script><script language=JScript src="../../../../js/commonPopup.js"></script><script language=JScript src="../../../../js/commonMsg.js"></script><script language=JScript src="../../../../js/commonCalendar.js"></script><script language=JScript src="../../../../js/commonButton.js"></script><script language=JScript src="../../../../js/commonReport.js"></script><script language=JScript src="../../../../js/biz/h04Biz.js"></script><script language="javascript" >
_include("../../../../js/common.js"); // 공통함수
_include("../../../../js/commonPopup.js"); // 팝업함수
_include("../../../../js/commonMsg.js"); // 메시지함수
_include("../../../../js/commonCalendar.js"); // 달력함수
_include("../../../../js/commonButton.js"); // 버튼함수
_include("../../../../js/commonReport.js"); // 리포트함수
_include("../../../../js/biz/h04Biz.js"); // 연말정산체크함수
function fnQuery(){
var componentName = "YETA";
var param = "&_param1=" + "19308090"
+ "&_param2=" + "20081231"
;
var serviceName = "retrieveYetaFamily"; // 호출할 메소드명(수정). Conf
fnDataSetUseCall(ds_family, componentName, serviceName, param, "returnType=0"); //컴포넌트 호출
}
function fnSave(){
var tmpStr = ds_family.Text + "n" + ds_family.ExportData(1, ds_family.CountRow, true);
document.getElementById('panel_1').style.fontSize = "12px";
document.getElementById('panel_1').style.fontFamily = '"돋움",Dotum, Arial, Geneva, sans-serif,"Malgun Gothic"';
document.getElementById('panel_1').innerText = tmpStr ;
/**
데이타 포맷
insrAmt1 | insrAmt2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
위와 같은 형태여서 아래 스크립트를 돌리면, 18이란 값이 나왔으면 하는데, 6이란 값만 나오네요~.
확인 부탁드립니다.
**/
var amt = ds_family.sum(ds_family.ColumnIndex("insrAmt1"),0,0)+ds_family.sum(ds_family.ColumnIndex("insrAmt2"),0,0);
alert(amt);
alert(typeof(ds_family.sum(ds_family.ColumnIndex("insrAmt1"),0,0)));
alert(typeof(ds_family.sum(ds_family.ColumnIndex("insrAmt2"),0,0)));
}
</script>
<script language="javascript" for="gform" event="onload" >
var btnSettingArr = ["true","true","true","false","true","false","false","true"];
var titleName = "";
fnCommonAuth(btnSettingArr, titleName);
fnQuery();
</script>
</body></html>
http://member.shift.co.kr/index.php?document_srl=236072
(*.231.196.1)
|
|
