原经费预算数JS
PC:
console.log('======开始======'); // 获得元素 // 直接金额 var ysje1 = mini.get('YSJE1'); var tzs1 = mini.get('TZS1'); var tzh1 = mini.get('TZH1'); var ysje1DX = mini.get('YSJE1DX'); var tzs1DX = mini.get('TZS1DX'); var tzh1DX = mini.get('TZH1DX'); // 设备费 var ysje2 = mini.get('YSJE2'); var tzs2 = mini.get('TZS2'); var tzh2 = mini.get('TZH2'); var ysje2DX = mini.get('YSJE2DX'); var tzs2DX = mini.get('TZS2DX'); var tzh2DX = mini.get('TZH2DX'); var ysje3 = mini.get('YSJE3'); var tzs3 = mini.get('TZS3'); var tzh3 = mini.get('TZH3'); var ysje3DX = mini.get('YSJE3DX'); var tzs3DX = mini.get('TZS3DX'); var tzh3DX = mini.get('TZH3DX'); var ysje4 = mini.get('YSJE4'); var tzs4 = mini.get('TZS4'); var tzh4 = mini.get('TZH4'); var ysje4DX = mini.get('YSJE4DX'); var tzs4DX = mini.get('TZS4DX'); var tzh4DX = mini.get('TZH4DX'); var ysje5 = mini.get('YSJE5'); var tzs5 = mini.get('TZS5'); var tzh5 = mini.get('TZH5'); var ysje5DX = mini.get('YSJE5DX'); var tzs5DX = mini.get('TZS5DX'); var tzh5DX = mini.get('TZH5DX'); //材料费 var ysje6 = mini.get('YSJE6'); var tzs6 = mini.get('TZS6'); var tzh6 = mini.get('TZH6'); var ysje6DX = mini.get('YSJE6DX'); var tzs6DX = mini.get('TZS6DX'); var tzh6DX = mini.get('TZH6DX'); //测试化验加工费 var ysje7 = mini.get('YSJE7'); var tzs7 = mini.get('TZS7'); var tzh7 = mini.get('TZH7'); var ysje7DX = mini.get('YSJE7DX'); var tzs7DX = mini.get('TZS7DX'); var tzh7DX = mini.get('TZH7DX'); //燃料动力费 var ysje8 = mini.get('YSJE8'); var tzs8 = mini.get('TZS8'); var tzh8 = mini.get('TZH8'); var ysje8DX = mini.get('YSJE8DX'); var tzs8DX = mini.get('TZS8DX'); var tzh8DX = mini.get('TZH8DX'); //会议费/差旅费/国际合作与交流费 var ysje9 = mini.get('YSJE9'); var tzs9 = mini.get('TZS9'); var tzh9 = mini.get('TZH9'); var ysje9DX = mini.get('YSJE9DX'); var tzs9DX = mini.get('TZS9DX'); var tzh9DX = mini.get('TZH9DX'); //出版/文献/信息传播/知识产权事务费 var ysje10 = mini.get('YSJE10'); var tzs10 = mini.get('TZS10'); var tzh10 = mini.get('TZH10'); var ysje10DX = mini.get('YSJE10DX'); var tzs10DX = mini.get('TZS10DX'); var tzh10DX = mini.get('TZH10DX'); //劳务费 var ysje11 = mini.get('YSJE11'); var tzs11 = mini.get('TZS11'); var tzh11 = mini.get('TZH11'); var ysje11DX = mini.get('YSJE11DX'); var tzs11DX = mini.get('TZS11DX'); var tzh11DX = mini.get('TZH11DX'); //专家咨询费 var ysje12 = mini.get('YSJE12'); var tzs12 = mini.get('TZS12'); var tzh12 = mini.get('TZH12'); var ysje12DX = mini.get('YSJE12DX'); var tzs12DX = mini.get('TZS12DX'); var tzh12DX = mini.get('TZH12DX'); //其他支出 var ysje13 = mini.get('YSJE13'); var tzs13 = mini.get('TZS13'); var tzh13 = mini.get('TZH13'); var ysje13DX = mini.get('YSJE13DX'); var tzs13DX = mini.get('TZS13DX'); var tzh13DX = mini.get('TZH13DX'); //间接费用 var ysje14 = mini.get('YSJE14'); var tzs14 = mini.get('TZS14'); var tzh14 = mini.get('TZH14'); var ysje14DX = mini.get('YSJE14DX'); var tzs14DX = mini.get('TZS14DX'); var tzh14DX = mini.get('TZH14DX'); var ysje15 = mini.get('YSJE15'); var tzs15 = mini.get('TZS15'); var tzh15 = mini.get('TZH15'); var ysje15DX = mini.get('YSJE15DX'); var tzs15DX = mini.get('TZS15DX'); var tzh15DX = mini.get('TZH15DX'); var ysje16 = mini.get('YSJE16'); var tzs16 = mini.get('TZS16'); var tzh16 = mini.get('TZH16'); var ysje16DX = mini.get('YSJE16DX'); var tzs16DX = mini.get('TZS16DX'); var tzh16DX = mini.get('TZH16DX'); //外协单位经费 var ysje17 = mini.get('YSJE17'); var tzs17 = mini.get('TZS17'); var tzh17 = mini.get('TZH17'); var ysje17DX = mini.get('YSJE17DX'); var tzs17DX = mini.get('TZS17DX'); var tzh17DX = mini.get('TZH17DX'); //合计 var ysje18 = mini.get('YSJE18'); var tzs18 = mini.get('TZS18'); var tzh18 = mini.get('TZH18'); var ysje18DX = mini.get('YSJE18DX'); var tzs18DX = mini.get('TZS18DX'); var tzh18DX = mini.get('TZH18DX'); // 绑定事件 // 设备费 ysje3.on('valuechanged', codeValue); tzs3.on('valuechanged', codeValue); ysje4.on('valuechanged', codeValue); tzs4.on('valuechanged', codeValue); ysje5.on('valuechanged', codeValue); tzs5.on('valuechanged', codeValue); //材料费 ysje6.on('valuechanged', codeValue); tzs6.on('valuechanged', codeValue); //测试化验加工费 ysje7.on('valuechanged', codeValue); tzs7.on('valuechanged', codeValue); //燃料动力费 ysje8.on('valuechanged', codeValue); tzs8.on('valuechanged', codeValue); //会议费/差旅费/国际合作与交流费 ysje9.on('valuechanged', codeValue); tzs9.on('valuechanged', codeValue); //出版/文献/信息传播/知识产权事务费 ysje10.on('valuechanged', codeValue); tzs10.on('valuechanged', codeValue); //劳务费 ysje11.on('valuechanged', codeValue); tzs11.on('valuechanged', codeValue); //间接费用 ysje15.on('valuechanged', codeValue); tzs15.on('valuechanged', codeValue); ysje16.on('valuechanged', codeValue); tzs16.on('valuechanged', codeValue); //外协单位经费 ysje17.on('valuechanged', codeValue); tzs17.on('valuechanged', codeValue); // 事件方法 function codeValue() { console.log('======执行onchange======'); // 设备费 var ysje3Val = !isNaN(ysje3.getValue())?parseFloat(ysje3.getValue()):0; var tzs3Val = !isNaN(tzs3.getValue())?parseFloat(tzs3.getValue()):0; var ysje4Val = !isNaN(ysje4.getValue())?parseFloat(ysje4.getValue()):0; var tzs4Val = !isNaN(tzs4.getValue())?parseFloat(tzs4.getValue()):0; var ysje5Val = !isNaN(ysje5.getValue())?parseFloat(ysje5.getValue()):0; var tzs5Val = !isNaN(tzs5.getValue())?parseFloat(tzs5.getValue()):0; //材料费 var ysje6Val = !isNaN(ysje6.getValue())?parseFloat(ysje6.getValue()):0; var tzs6Val = !isNaN(tzs6.getValue())?parseFloat(tzs6.getValue()):0; //测试化验加工费 var ysje7Val = !isNaN(ysje7.getValue())?parseFloat(ysje7.getValue()):0; var tzs7Val = !isNaN(tzs7.getValue())?parseFloat(tzs7.getValue()):0; //燃料动力费 var tzs8Val = !isNaN(tzs8.getValue())?parseFloat(tzs8.getValue()):0; var ysje8Val = !isNaN(ysje8.getValue())?parseFloat(ysje8.getValue()):0; //会议费/差旅费/国际合作与交流费 var tzs9Val = !isNaN(tzs9.getValue())?parseFloat(tzs9.getValue()):0; var ysje9Val = !isNaN(ysje9.getValue())?parseFloat(ysje9.getValue()):0; //出版/文献/信息传播/知识产权事务费 var tzs10Val = !isNaN(tzs10.getValue())?parseFloat(tzs10.getValue()):0; var ysje10Val = !isNaN(ysje10.getValue())?parseFloat(ysje10.getValue()):0; //劳务费 var tzs11Val = !isNaN(tzs11.getValue())?parseFloat(tzs11.getValue()):0; var ysje11Val = !isNaN(ysje11.getValue())?parseFloat(ysje11.getValue()):0; //专家咨询费 var tzs12Val = !isNaN(tzs12.getValue())?parseFloat(tzs12.getValue()):0; var ysje12Val = !isNaN(ysje12.getValue())?parseFloat(ysje12.getValue()):0; //其他支出 var tzs13Val = !isNaN(tzs13.getValue())?parseFloat(tzs13.getValue()):0; var ysje13Val = !isNaN(ysje13.getValue())?parseFloat(ysje13.getValue()):0; //间接费用 var ysje15Val = !isNaN(ysje15.getValue())?parseFloat(ysje15.getValue()):0; var tzs15Val = !isNaN(tzs15.getValue())?parseFloat(tzs15.getValue()):0; var ysje16Val = !isNaN(ysje16.getValue())?parseFloat(ysje16.getValue()):0; var tzs16Val = !isNaN(tzs16.getValue())?parseFloat(tzs16.getValue()):0; //外协单位经费 var ysje17Val = !isNaN(ysje17.getValue())?parseFloat(ysje17.getValue()):0; var tzs17Val = !isNaN(tzs17.getValue())?parseFloat(tzs17.getValue()):0; // 计算第三列 var tzh3Val = Math.abs(ysje3Val + tzs3Val).toFixed(2); var tzh4Val = Math.abs(ysje4Val + tzs4Val).toFixed(2); var tzh5Val = Math.abs(ysje5Val + tzs5Val).toFixed(2); var tzh6Val = Math.abs(ysje6Val + tzs6Val).toFixed(2); var tzh7Val = Math.abs(ysje7Val + tzs7Val).toFixed(2); var tzh8Val = Math.abs(ysje8Val + tzs8Val).toFixed(2); var tzh9Val = Math.abs(ysje9Val + tzs9Val).toFixed(2); var tzh10Val = Math.abs(ysje10Val + tzs10Val).toFixed(2); var tzh11Val = Math.abs(ysje11Val + tzs11Val).toFixed(2); var tzh12Val = Math.abs(ysje12Val + tzs12Val).toFixed(2); var tzh13Val = Math.abs(ysje13Val + tzs13Val).toFixed(2); var tzh15Val = Math.abs(ysje15Val + tzs15Val).toFixed(2); var tzh16Val = Math.abs(ysje16Val + tzs16Val).toFixed(2); var tzh17Val = Math.abs(ysje17Val + tzs17Val).toFixed(2); tzh3.setValue(tzh3Val); tzh4.setValue(tzh4Val); tzh5.setValue(tzh5Val); tzh6.setValue(tzh6Val); tzh7.setValue(tzh7Val); tzh8.setValue(tzh8Val); tzh9.setValue(tzh9Val); tzh10.setValue(tzh10Val); tzh11.setValue(tzh11Val); tzh12.setValue(tzh12Val); tzh13.setValue(tzh13Val); tzh15.setValue(tzh15Val); tzh16.setValue(tzh16Val); tzh17.setValue(tzh17Val); // 转换金额大写 //预算数 ysje3DX.setValue(convertCurrency(ysje3Val)); //调整数 if(tzs3Val > 0 ){ tzs3DX.setValue('增加'+convertCurrency(tzs3Val)); } if(tzs3Val == 0){ tzs3DX.setValue('未调整'); } if(tzs3Val < 0) { var TZS3FS = -tzs3Val; tzs3DX.setValue('减少'+convertCurrency(TZS3FS)); } //调整后 if(tzs3Val > 0){ var TZH3ZS = tzs3Val+ysje3Val; tzh3DX.setValue(convertCurrency(TZH3ZS)); } if(tzh3Val == 0){ tzh3DX.setValue('未调整'); } if(tzs3Val < 0){ var TZH3FS = ysje3Val + tzs3Val; tzh3.setValue(TZH3FS); if(TZH3FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH3').setValue(' '); }); } } //预算数 ysje4DX.setValue(convertCurrency(ysje4Val)); //调整数 if(tzs4Val > 0 ){ tzs4DX.setValue('增加'+convertCurrency(tzs4Val)); } if(tzs4Val == 0){ tzs4DX.setValue('未调整'); } if(tzs4Val < 0 ) { var TZS4FS = -tzs4Val; tzs4DX.setValue('减少'+convertCurrency(TZS4FS)); } //调整后 if(tzs4Val > 0){ var TZH4ZS = tzs4Val+ysje4Val; tzh4DX.setValue(convertCurrency(TZH4ZS)); } if(tzh4Val == 0){ tzh4DX.setValue('未调整'); } if(tzs4Val < 0){ var TZH4FS = ysje4Val + tzs4Val; tzh4.setValue(TZH4FS); if(TZH4FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH4').setValue(' '); }); } } //预算数 ysje5DX.setValue(convertCurrency(ysje5Val)); //调整数 if(tzs5Val > 0 ){ tzs5DX.setValue('增加'+convertCurrency(tzs5Val)); } if(tzs5Val == 0){ tzs5DX.setValue('未调整'); } if(tzs5Val < 0 ) { var TZS5FS = -tzs5Val; tzs5DX.setValue('减少'+convertCurrency(TZS5FS)); } //调整后 if(tzs5Val > 0){ var TZH5ZS = tzs5Val+ysje5Val; tzh5DX.setValue(convertCurrency(TZH5ZS)); } if(tzh5Val == 0){ tzh5DX.setValue('未调整'); } if(tzs5Val < 0){ var TZH5FS = ysje5Val + tzs5Val; tzh5.setValue(TZH5FS); if(TZH5FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH5').setValue(' '); }); } } //预算数 ysje6DX.setValue(convertCurrency(ysje6Val)); //调整数 if(tzs6Val > 0 ){ tzs6DX.setValue('增加'+convertCurrency(tzs6Val)); } if(tzs6Val == 0){ tzs6DX.setValue('未调整'); } if(tzs6Val < 0 ) { var TZS6FS = -tzs6Val; tzs6DX.setValue('减少'+convertCurrency(TZS6FS)); } //调整后 if(tzs6Val > 0){ var TZH6ZS = tzs6Val+ysje6Val; tzh6DX.setValue(convertCurrency(TZH6ZS)); } if(tzh6Val == 0){ tzh6DX.setValue('未调整'); } if(tzs6Val < 0){ var TZH6FS = ysje6Val + tzs6Val; tzh6.setValue(TZH6FS); if(TZH6FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH6').setValue(' '); }); } } //预算数 ysje7DX.setValue(convertCurrency(ysje7Val)); //调整数 if(tzs7Val > 0 ){ tzs7DX.setValue('增加'+convertCurrency(tzs7Val)); } if(tzs7Val == 0){ tzs7DX.setValue('未调整'); } if(tzs7Val < 0 ) { var TZS7FS = -tzs7Val; tzs7DX.setValue('减少'+convertCurrency(TZS7FS)); } //调整后 if(tzs7Val > 0){ var TZH7ZS = tzs7Val+ysje7Val; tzh7DX.setValue(convertCurrency(TZH7ZS)); } if(tzh7Val == 0){ tzh7DX.setValue('未调整'); } if(tzs7Val < 0){ var TZH7FS = ysje7Val + tzs7Val; tzh7.setValue(TZH7FS); if(TZH7FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH7').setValue(' '); }); } } //预算数 ysje8DX.setValue(convertCurrency(ysje8Val)); //调整数 if(tzs8Val > 0 ){ tzs8DX.setValue('增加'+convertCurrency(tzs8Val)); } if(tzs8Val == 0){ tzs8DX.setValue('未调整'); } if(tzs8Val < 0 ) { var TZS8FS = -tzs8Val; tzs8DX.setValue('减少'+convertCurrency(TZS8FS)); } //调整后 if(tzs8Val > 0){ var TZH8ZS = tzs8Val+ysje8Val; tzh8DX.setValue(convertCurrency(TZH8ZS)); } if(tzh8Val == 0){ tzh8DX.setValue('未调整'); } if(tzs8Val < 0){ var TZH8FS = ysje8Val + tzs8Val; tzh8.setValue(TZH8FS); if(TZH8FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH8').setValue(' '); }); } } //预算数 ysje9DX.setValue(convertCurrency(ysje9Val)); //调整数 if(tzs9Val > 0 ){ tzs9DX.setValue('增加'+convertCurrency(tzs9Val)); } if(tzs9Val == 0){ tzs9DX.setValue('未调整'); } if(tzs9Val < 0 ) { var TZS9FS = -tzs9Val; tzs9DX.setValue('减少'+convertCurrency(TZS9FS)); } //调整后 if(tzs9Val > 0){ var TZH9ZS = tzs9Val+ysje9Val; tzh9DX.setValue(convertCurrency(TZH9ZS)); } if(tzh9Val == 0){ tzh9DX.setValue('未调整'); } if(tzs9Val < 0){ var TZH9FS = ysje9Val + tzs9Val; tzh9.setValue(TZH9FS); if(TZH9FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH9').setValue(' '); }); } } //预算数 ysje10DX.setValue(convertCurrency(ysje10Val)); //调整数 if(tzs10Val > 0 ){ tzs10DX.setValue('增加'+convertCurrency(tzs10Val)); } if(tzs10Val == 0){ tzs10DX.setValue('未调整'); } if(tzs10Val < 0 ) { var TZS10FS = -tzs10Val; tzs10DX.setValue('减少'+convertCurrency(TZS10FS)); } //调整后 if(tzs10Val > 0){ var TZH10ZS = tzs10Val+ysje10Val; tzh10DX.setValue(convertCurrency(TZH10ZS)); } if(tzh10Val == 0){ tzh10DX.setValue('未调整'); } if(tzs10Val < 0){ var TZH10FS = ysje10Val + tzs10Val; tzh10.setValue(TZH10FS); if(TZH10FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH10').setValue(' '); }); } } //预算数 ysje11DX.setValue(convertCurrency(ysje11Val)); //调整数 if(tzs11Val > 0 ){ tzs11DX.setValue('增加'+convertCurrency(tzs11Val)); } if(tzs11Val == 0){ tzs11DX.setValue('未调整'); } if(tzs11Val < 0 ) { var TZS11FS = -tzs11Val; tzs11DX.setValue('减少'+convertCurrency(TZS11FS)); } //调整后 if(tzs11Val > 0){ var TZH11ZS = tzs11Val+ysje11Val; tzh11DX.setValue(convertCurrency(TZH11ZS)); } if(tzh11Val == 0){ tzh11DX.setValue('未调整'); } if(tzs11Val < 0){ var TZH11FS = ysje11Val + tzs11Val; tzh11.setValue(TZH11FS); if(TZH11FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH11').setValue(' '); }); } } //预算数 ysje12DX.setValue(convertCurrency(ysje12Val)); //调整数 if(tzs12Val > 0 ){ tzs12DX.setValue('增加'+convertCurrency(tzs12Val)); } if(tzs12Val == 0){ tzs12DX.setValue('未调整'); } if(tzs12Val < 0 ) { var TZS12FS = -tzs12Val; tzs12DX.setValue('减少'+convertCurrency(TZS12FS)); } //调整后 if(tzs12Val > 0){ var TZH12ZS = tzs12Val+ysje12Val; tzh12DX.setValue(convertCurrency(TZH12ZS)); } if(tzh12Val == 0){ tzh12DX.setValue('未调整'); } if(tzs12Val < 0){ var TZH12FS = ysje12Val + tzs12Val; tzh12.setValue(TZH12FS); if(TZH12FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH12').setValue(' '); }); } } //预算数 ysje13DX.setValue(convertCurrency(ysje13Val)); //调整数 if(tzs13Val > 0 ){ tzs13DX.setValue('增加'+convertCurrency(tzs13Val)); } if(tzs13Val == 0){ tzs13DX.setValue('未调整'); } if(tzs13Val < 0 ) { var TZS13FS = -tzs13Val; tzs13DX.setValue('减少'+convertCurrency(TZS13FS)); } //调整后 if(tzs13Val > 0){ var TZH13ZS = tzs13Val+ysje13Val; tzh13DX.setValue(convertCurrency(TZH13ZS)); } if(tzh13Val == 0){ tzh13DX.setValue('未调整'); } if(tzs13Val < 0){ var TZH13FS = ysje13Val + tzs13Val; tzh13.setValue(TZH13FS); if(TZH13FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH13').setValue(' '); }); } } //预算数 ysje15DX.setValue(convertCurrency(ysje15Val)); //调整数 if(tzs15Val > 0 ){ tzs15DX.setValue('增加'+convertCurrency(tzs15Val)); } if(tzs15Val == 0){ tzs15DX.setValue('未调整'); } if(tzs15Val < 0 ) { var TZS15FS = -tzs15Val; tzs15DX.setValue('减少'+convertCurrency(TZS15FS)); } //调整后 if(tzs15Val > 0){ var TZH15ZS = tzs15Val+ysje15Val; tzh15DX.setValue(convertCurrency(TZH15ZS)); } if(tzh15Val == 0){ tzh15DX.setValue('未调整'); } if(tzs15Val < 0){ var TZH15FS = ysje15Val + tzs15Val; tzh15.setValue(TZH15FS); if(TZH15FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH15').setValue(' '); }); } } //预算数 ysje16DX.setValue(convertCurrency(ysje16Val)); //调整数 if(tzs16Val > 0 ){ tzs16DX.setValue('增加'+convertCurrency(tzs16Val)); } if(tzs16Val == 0){ tzs16DX.setValue('未调整'); } if(tzs16Val < 0 ) { var TZS16FS = -tzs16Val; tzs16DX.setValue('减少'+convertCurrency(TZS16FS)); } //调整后 if(tzs16Val > 0){ var TZH16ZS = tzs16Val+ysje16Val; tzh16DX.setValue(convertCurrency(TZH16ZS)); } if(tzh16Val == 0){ tzh16DX.setValue('未调整'); } if(tzs16Val < 0){ var TZH16FS = ysje16Val + tzs16Val; tzh16.setValue(TZH16FS); if(TZH16FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH16').setValue(' '); }); } } //预算数 ysje17DX.setValue(convertCurrency(ysje17Val)); //调整数 if(tzs17Val > 0 ){ tzs17DX.setValue('增加'+convertCurrency(tzs17Val)); } if(tzs17Val == 0){ tzs17DX.setValue('未调整'); } if(tzs17Val < 0 ) { var TZS17FS = -tzs17Val; tzs17DX.setValue('减少'+convertCurrency(TZS17FS)); } //调整后 if(tzs17Val > 0){ var TZH17ZS = tzs17Val+ysje17Val; tzh17DX.setValue(convertCurrency(TZH17ZS)); } if(tzh17Val == 0){ tzh17DX.setValue('未调整'); } if(tzs17Val < 0){ var TZH17FS = ysje17Val + tzs17Val; tzh17.setValue(TZH17FS); if(TZH17FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH17').setValue(' '); }); } } // 合计金额计算 var ysje2Val = Math.abs(ysje3Val + ysje4Val + ysje5Val).toFixed(2); var tzs2Val = Math.abs(tzs3Val + tzs4Val + tzs5Val).toFixed(2); var tzh3Val = !isNaN(tzh3Val)?parseFloat(tzh3Val):0; var tzh4Val = !isNaN(tzh4Val)?parseFloat(tzh4Val):0; var tzh5Val = !isNaN(tzh5Val)?parseFloat(tzh5Val):0; var tzh2Val = Math.abs(tzh3Val + tzh4Val + tzh5Val).toFixed(2); var ysje1Val = Math.abs(ysje3Val + ysje4Val + ysje5Val + ysje6Val + ysje7Val + ysje8Val + ysje9Val + ysje10Val + ysje11Val + ysje12Val + ysje13Val).toFixed(2); var tzs1Val = Math.abs(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val ).toFixed(2); var tzh6Val = !isNaN(tzh6Val)?parseFloat(tzh6Val):0; var tzh7Val = !isNaN(tzh7Val)?parseFloat(tzh7Val):0; var tzh8Val = !isNaN(tzh8Val)?parseFloat(tzh8Val):0; var tzh9Val = !isNaN(tzh9Val)?parseFloat(tzh9Val):0; var tzh10Val = !isNaN(tzh10Val)?parseFloat(tzh10Val):0; var tzh11Val = !isNaN(tzh11Val)?parseFloat(tzh11Val):0; var tzh12Val = !isNaN(tzh12Val)?parseFloat(tzh12Val):0; var tzh13Val = !isNaN(tzh13Val)?parseFloat(tzh13Val):0; var tzh1Val = Math.abs(tzh3Val + tzh4Val + tzh5Val + tzh6Val + tzh7Val + tzh8Val + tzh9Val + tzh10Val + tzh11Val + tzh12Val + tzh13Val ).toFixed(2); var ysje14Val = Math.abs(ysje15Val + ysje16Val).toFixed(2); var tzs14Val = Math.abs(tzs15Val + tzs16Val).toFixed(2); var tzh15Val = !isNaN(tzh15Val)?parseFloat(tzh15Val):0; var tzh16Val = !isNaN(tzh16Val)?parseFloat(tzh16Val):0; var tzh14Val = Math.abs(tzh15Val + tzh16Val).toFixed(2); var tzh17Val = !isNaN(tzh17Val)?parseFloat(tzh17Val):0; var ysje18Val = Math.abs(ysje3Val + ysje4Val + ysje5Val + ysje6Val + ysje7Val + ysje8Val + ysje9Val + ysje10Val + ysje11Val + ysje12Val + ysje13Val + ysje15Val + ysje16Val + ysje17Val).toFixed(2); var tzs18Val = Math.abs(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val + tzs15Val + tzs16Val + tzs17Val ).toFixed(2); var tzh18Val = Math.abs(tzh3Val + tzh4Val + tzh5Val + tzh6Val + tzh7Val + tzh8Val + tzh9Val + tzh10Val + tzh11Val + tzh12Val + tzh13Val + tzh15Val + tzh16Val + tzh17Val ).toFixed(2); // 合计金额元素赋值 ysje1.setValue(ysje1Val); tzs1.setValue(tzs1Val); tzh1.setValue(tzh1Val); ysje2.setValue(ysje2Val); tzs2.setValue(tzs2Val); tzh2.setValue(tzh2Val); ysje14.setValue(ysje14Val); tzs14.setValue(tzs14Val); tzh14.setValue(tzh14Val); ysje18.setValue(ysje18Val); tzs18.setValue(tzs18Val); tzh18.setValue(tzh18Val); // 转换合计金额大写 //预算数1 ysje1DX.setValue(convertCurrency(ysje1Val)); //调整数1 if(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val > 0 ){ var TZS1ZS = tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val ; tzs1DX.setValue('增加'+convertCurrency(TZS1ZS)); } if(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val == 0){ tzs1DX.setValue('未调整'); } if(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val < 0 ) { var TZS1FS = -(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val ); tzs1DX.setValue('减少'+convertCurrency(TZS1FS)); tzs1.setValue('-'+tzs1Val); } //调整后1 if(tzs1Val > 0){ tzh1DX.setValue(convertCurrency(tzh1Val)); } if(tzs1Val == 0){ tzh1DX.setValue('未调整'); } if(tzs1Val < 0){ var TZH1FS = ysje1Val + tzs1Val; tzh1.setValue(TZH1FS); if(TZH1FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH1').setValue(' '); }); } } //预算数2 ysje2DX.setValue(convertCurrency(ysje2Val)); //调整数2 if(tzs3Val + tzs4Val + tzs5Val > 0 ){ var TZS2ZS = tzs3Val + tzs4Val + tzs5Val ; tzs2DX.setValue('增加'+convertCurrency(TZS2ZS)); } if(tzs3Val + tzs4Val + tzs5Val == 0 ){ tzs2DX.setValue('未调整'); } if(tzs3Val + tzs4Val + tzs5Val < 0 ) { var TZS2FS = -(tzs3Val + tzs4Val + tzs5Val); tzs2DX.setValue('减少'+convertCurrency(TZS2FS)); tzs2.setValue('-'+tzs2Val); } //调整后2 if(tzs2Val > 0){ var TZH2ZS = ysje2Val+tzs2Val; tzh2DX.setValue(convertCurrency(tzh1Val)); } if(tzs2Val == 0){ tzh2DX.setValue('未调整'); } if(tzs2Val < 0){ var TZH2FS = ysje2Val + tzs2Val; tzh2.setValue(TZH2FS); if(TZH2FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH2').setValue(' '); }); } } //预算数14 ysje14DX.setValue(convertCurrency(ysje14Val)); //调整数14 if(tzs15Val + tzs16Val > 0 ){ var TZS14ZS = tzs15Val + tzs16Val ; tzs14DX.setValue('增加'+convertCurrency(TZS14ZS)); } if(tzs15Val + tzs16Val == 0 ){ tzs14DX.setValue('未调整'); } if(tzs15Val + tzs16Val < 0 ) { var TZS14FS = -(tzs15Val + tzs16Val); tzs14DX.setValue('减少'+convertCurrency(TZS14FS)); tzs14.setValue('-'+tzs14Val); } //调整后14 if(tzs14Val > 0){ var TZH14ZS = ysje14Val+tzs14Val; tzh14DX.setValue(convertCurrency(tzh14Val)); } if(tzs14Val == 0){ tzh14DX.setValue('未调整'); } if(tzs14Val < 0){ var TZH14FS = ysje14Val + tzs14Val; tzh14.setValue(TZH14FS); if(TZH14FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH14').setValue(' '); }); } } //预算数18 ysje18DX.setValue(convertCurrency(ysje18Val)); //调整数18 if(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val + tzs15Val + tzs16Val + tzs17Val > 0 ){ var TZS18ZS = tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val + tzs15Val + tzs16Val + tzs17Val ; tzs18DX.setValue('增加'+convertCurrency(TZS18ZS)); } if(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val + tzs15Val + tzs16Val + tzs17Val == 0 ){ tzs18DX.setValue('未调整'); } if(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val + tzs15Val + tzs16Val + tzs17Val < 0 ) { var TZS18FS = -(tzs3Val + tzs4Val + tzs5Val + tzs6Val + tzs7Val + tzs8Val + tzs9Val + tzs10Val + tzs11Val + tzs12Val + tzs13Val + tzs15Val + tzs16Val + tzs17Val ); tzs18DX.setValue('减少'+convertCurrency(TZS18FS)); tzs18.setValue('-'+tzs18Val); } //调整后18 if(tzs18Val > 0){ var TZH18ZS = ysje18Val+tzs18Val; tzh18DX.setValue(convertCurrency(tzh18Val)); } if(tzs18Val == 0){ tzh18DX.setValue('未调整'); } if(tzs18Val < 0){ var TZH18FS = ysje18Val + tzs18Val; tzh18.setValue(TZH18FS); if(TZH18FS < 0){ mini.alert('无效金额', '提醒', function(){ mini.get('TZH18').setValue(' '); }); } } // ... // 直接金额赋值 /*var ysje3NumVal = !isNaN(ysje3NumVal)?ysje3NumVal:0; var ysje1NumVal = Math.abs(ysje3NumVal).toFixed(2); ysje1.setValue(ysje1NumVal); ysje1DX.setValue(convertCurrency(ysje1NumVal));*/ }; /* * 获得大写金额 */ function convertCurrency(money) { /*汉字的数字*/ var cnNums = new Array('零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖'); /*基本单位*/ var cnIntRadice = new Array('', '拾', '佰', '仟'); /*对应整数部分扩展单位*/ var cnIntUnits = new Array('', '万', '亿', '兆'); /*对应小数部分单位*/ var cnDecUnits = new Array('角', '分', '毫', '厘'); /*整数金额时后面跟的字符*/ var cnInteger = '整'; /*整型完以后的单位*/ var cnIntLast = '元'; /*最大处理的数字*/ var maxNum = 999999999999999.9999; /*金额整数部分*/ var integerNum; /*金额小数部分*/ var decimalNum; /*输出的中文金额字符串*/ var chineseStr = ''; /*分离金额后用的数组,预定义*/ var parts; if (money == '') { return ''; } money = parseFloat(money); if (money >= maxNum) { /*超出最大处理数字*/ return ''; } if (money == 0) { chineseStr = cnNums[0] + cnIntLast + cnInteger; return chineseStr; } /*转换为字符串*/ money = money.toString(); if (money.indexOf('.') == -1) { integerNum = money; decimalNum = ''; } else { parts = money.split('.'); integerNum = parts[0]; decimalNum = parts[1].substr(0, 4); } /*获取整型部分转换*/ if (parseInt(integerNum, 10) > 0) { var zeroCount = 0; var IntLen = integerNum.length; for (var i = 0; i < IntLen; i++) { var n = integerNum.substr(i, 1); var p = IntLen - i - 1; var q = p / 4; var m = p % 4; if (n == '0') { zeroCount++; } else { if (zeroCount > 0) { chineseStr += cnNums[0]; } /*归零*/ zeroCount = 0; chineseStr += cnNums[parseInt(n)] + cnIntRadice[m]; } if (m == 0 && zeroCount < 4) { chineseStr += cnIntUnits[q]; } } chineseStr += cnIntLast; } /*小数部分*/ if (decimalNum != '') { var decLen = decimalNum.length; for (var i = 0; i < decLen; i++) { var n = decimalNum.substr(i, 1); if (n != '0') { chineseStr += cnNums[Number(n)] + cnDecUnits[i]; } } } if (chineseStr == '') { chineseStr += cnNums[0] + cnIntLast + cnInteger; } else if (decimalNum == '') { chineseStr += cnInteger; } return chineseStr; }
网站负责人pc:
$(function(){ $('.seconde'). hide(); debugger; console.log("================111111==========="); mini.get('XMFZR').on('valuechanged', riqiChangeHandler); console.log("================XMFZR==========="); //单选按钮 切换表格 mini.get('XMLXXZ').on('valuechanged', IsCheckStyle); }); //单选按钮切换 function IsCheckStyle(){ var sffzrs=mini.get("XMLXXZ"); console.log("================XMFZR==========="+sffzrs.getValue()); if(sffzrs.getValue()=="1"){ $('.first').show(); $('.seconde'). hide(); }else{ $('.seconde').show(); $('.first'). hide(); } }; function riqiChangeHandler() { var start = mini.get('XMFZR').getValue(); var s1 = start.split('@_@')[0].split(','); mini.get('XMFZRGH').setValue(s1); $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}/queryservice/query.htm?snumber=GHCXQT&HUMANCODE='+mini.get('XMFZRGH').getValue(), dataType:'json', success:function(text){ var phone1 = text[0].TELMOBILE1; //把数据传到控件中 mini.get('XMFZRLXFS').setValue(phone1); }, }); }
网站负责人移动:
var self = this, $XMFZRGH = $('#XMFZRGH', this.parentView.el), $XMFZRLXFS = $('#XMFZRLXFS', this.parentView.el), XMFZRView; this.parentView.fieldsArray.forEach(function(ele){ if(ele.model.get("enfield") == 'XMFZR') XMFZRView = ele; }); console.log($XMFZRGH) console.log(XMFZRView) if(XMFZRView){ self.listenTo(XMFZRView._userSelectorView.collection, 'add remove', function(){ var data = XMFZRView.getData(); var s1 =data.split('@#@')[0].split(','); var val =''; for (var i = 0; i < s1.length; i++) { val += s1[i] + ','; } if(val) val=val.substr(0,val.length-1); $XMFZRGH.val(val); $.ajax({ //通用查询地址+根据哪个控件值 url:'/EIP/queryservice/query.htm?snumber=GHCXQT&HUMANCODE='+val, dataType:'json', success:function(text){ var phone1 = text[0].TELMOBILE1; $XMFZRLXFS.val(phone1); }, }); }); }
脚本控件-社科pc:
//第一列 //资料费 mini.get('SKYSJE20').on('valuechanged', IsSameValue); //数据采集费 mini.get('SKYSJE21').on('valuechanged', IsSameValue1); //会议费/差旅费/国际交流与合作费 mini.get('SKYSJE22').on('valuechanged', IsSameValue2); //设备费 mini.get('SKYSJE23').on('valuechanged', IsSameValue3); //专家咨询费 mini.get('SKYSJE24').on('valuechanged', IsSameValue4); //劳务费 mini.get('SKYSJE25').on('valuechanged', IsSameValue5); //印刷费/宣传费 mini.get('SKYSJE26').on('valuechanged', IsSameValue6); //其他支出 mini.get('SKYSJE27').on('valuechanged', IsSameValue7); //其中:管理费 mini.get('SKYSJE29').on('valuechanged', IsSameValue8); //绩效支出 mini.get('SKYSJE30').on('valuechanged', IsSameValue9); //外协单位经费 mini.get('SKYSJE31').on('valuechanged', IsSameValue10); //第二列 //资料费 mini.get('SKTZS20').on('valuechanged', IsSameValue20); //数据采集费 mini.get('SKTZS21').on('valuechanged', IsSameValue21); //会议费/差旅费/国际交流与合作费 mini.get('SKTZS22').on('valuechanged', IsSameValue22); //设备费 mini.get('SKTZS23').on('valuechanged', IsSameValue23); //专家咨询费 mini.get('SKTZS24').on('valuechanged', IsSameValue24); //劳务费 mini.get('SKTZS25').on('valuechanged', IsSameValue25); //印刷费/宣传费 mini.get('SKTZS26').on('valuechanged', IsSameValue26); //其他支出 mini.get('SKTZS27').on('valuechanged', IsSameValue27); //其中:管理费 mini.get('SKTZS29').on('valuechanged', IsSameValue28); //绩效支出 mini.get('SKTZS30').on('valuechanged', IsSameValue29); //外协单位经费 mini.get('SKTZS31').on('valuechanged', IsSameValue30); //计算合计 function IsSameValue(){ var moneyName="SKYSJE20"; var moneyDX="SKYSJE20DX"; var moneyName1="SKTZS20"; var moneyName2="SKTZH20"; var moneyDX2="SKTZH20DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue1(){ var moneyName="SKYSJE21"; var moneyDX="SKYSJE21DX"; var moneyName1="SKTZS21"; var moneyName2="SKTZH21"; var moneyDX2="SKTZH21DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue2(){ var moneyName="SKYSJE22"; var moneyDX="SKYSJE22DX"; var moneyName1="SKTZS22"; var moneyName2="SKTZH22"; var moneyDX2="SKTZH22DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue3(){ var moneyName="SKYSJE23"; var moneyDX="SKYSJE23DX"; var moneyName1="SKTZS23"; var moneyName2="SKTZH2023"; var moneyDX2="SKTZH23DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue4(){ var moneyName="SKYSJE24"; var moneyDX="SKYSJE24DX"; var moneyName1="SKTZS24"; var moneyName2="SKTZH24"; var moneyDX2="SKTZH24DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue5(){ var moneyName="SKYSJE25"; var moneyDX="SKYSJE25DX"; var moneyName1="SKTZS25"; var moneyName2="SKTZH25"; var moneyDX2="SKTZH25DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue6(){ var moneyName="SKYSJE26"; var moneyDX="SKYSJE26DX"; var moneyName1="SKTZS26"; var moneyName2="SKTZH26"; var moneyDX2="SKTZH26DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue7(){ var moneyName="SKYSJE27"; var moneyDX="SKYSJE27DX"; var moneyName1="SKTZS27"; var moneyName2="SKTZH27"; var moneyDX2="SKTZH27DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue8(){ var moneyName="SKYSJE29"; var moneyDX="SKYSJE29DX"; var moneyName1="SKTZS29"; var moneyName2="SKTZH29"; var moneyDX2="SKTZH29DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_1(); cAdd_1(); } function IsSameValue9(){ var moneyName="SKYSJE30"; var moneyDX="SKYSJE30DX"; var moneyName1="SKTZS30"; var moneyName2="SKTZH30"; var moneyDX2="SKTZH30DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_1(); cAdd_1(); } function IsSameValue10(){ var money=mini.get("SKYSJE31").getValue(); var s1 = money.substring(0,1); if(s1=='-'){ alert('原经费预算不可为负数'); mini.get("SKYSJE31").setValue(0); return; } var xiaoji = justMoney(money); mini.get("SKYSJE31DX").setValue(xiaoji); var money2=mini.get("SKTZS31").getValue(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); mini.get("SKTZH31").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKTZH31DX").setValue(xiaojiheji); cAdd_1(); } function IsSameValue20(){ var moneyName="SKTZS20"; var moneyDX="SKTZS20DX"; var moneyName1="SKYSJE20"; var moneyName2="SKTZH20"; var moneyDX2="SKTZH20DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue21(){ var moneyName="SKTZS21"; var moneyDX="SKTZS21DX"; var moneyName1="SKYSJE21"; var moneyName2="SKTZH21"; var moneyDX2="SKTZH21DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue22(){ var moneyName="SKTZS22"; var moneyDX="SKTZS22DX"; var moneyName1="SKYSJE22"; var moneyName2="SKTZH22"; var moneyDX2="SKTZH22DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue23(){ var moneyName="SKTZS23"; var moneyDX="SKTZS23DX"; var moneyName1="SKYSJE23"; var moneyName2="SKTZH2023"; var moneyDX2="SKTZH23DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue24(){ var moneyName="SKTZS24"; var moneyDX="SKTZS24DX"; var moneyName1="SKYSJE24"; var moneyName2="SKTZH24"; var moneyDX2="SKTZH24DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue25(){ var moneyName="SKTZS25"; var moneyDX="SKTZS25DX"; var moneyName1="SKYSJE25"; var moneyName2="SKTZH25"; var moneyDX2="SKTZH25DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue26(){ var moneyName="SKTZS26"; var moneyDX="SKTZS26DX"; var moneyName1="SKYSJE26"; var moneyName2="SKTZH26"; var moneyDX2="SKTZH26DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue27(){ var moneyName="SKTZS27"; var moneyDX="SKTZS27DX"; var moneyName1="SKYSJE27"; var moneyName2="SKTZH27"; var moneyDX2="SKTZH27DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue28(){ var moneyName="SKTZS28"; var moneyDX="SKTZS28DX"; var moneyName1="SKYSJE28"; var moneyName2="SKTZH28"; var moneyDX2="SKTZH28DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_2(); cAdd_2(); } function IsSameValue29(){ var moneyName="SKTZS29"; var moneyDX="SKTZS29DX"; var moneyName1="SKYSJE29"; var moneyName2="SKTZH29"; var moneyDX2="SKTZH29DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_2(); cAdd_2(); } function IsSameValue30(){ var money=mini.get("SKTZS30").getValue(); var xiaoji = adjustMoney(money); mini.get("SKTZS30DX").setValue(xiaoji); var money2=mini.get("SKYSJE30").getValue(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); mini.get("SKTZH30").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("SKTZH30DX").setValue(xiaojiheji); cAdd_2(); } //第一列行处理 function handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2){ var money=mini.get(moneyName).getValue(); var s1 = money.substring(0,1); if(s1=='-'){ alert('原经费预算不可为负数'); mini.get(moneyName).setValue(0); return; } var xiaoji = justMoney(money); mini.get(moneyDX).setValue(xiaoji ); var money2=mini.get(moneyName1).getValue(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); mini.get(moneyName2).setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get(moneyDX2).setValue(xiaojiheji); } //第二列行处理 function bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2){ var money=mini.get(moneyName).getValue(); var xiaoji = adjustMoney(money); mini.get(moneyDX).setValue(xiaoji); var money2=mini.get(moneyName1).getValue(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); mini.get(moneyName2).setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get(moneyDX2).setValue(xiaojiheji ); } //直接费用第一列数据总和 function aAdd_1(){ var SKYSJE20=mini.get("SKYSJE20").getValue(); var SKYSJE21=mini.get("SKYSJE21").getValue(); var SKYSJE22=mini.get("SKYSJE22").getValue(); var SKYSJE23=mini.get("SKYSJE23").getValue(); var SKYSJE24=mini.get("SKYSJE24").getValue(); var SKYSJE25=mini.get("SKYSJE25").getValue(); var SKYSJE26=mini.get("SKYSJE26").getValue(); var SKYSJE27=mini.get("SKYSJE27").getValue(); //var tvalue=0; //自行添加后续对应数据 var total=CheckIsNullOrEmpty(SKYSJE20)+ CheckIsNullOrEmpty(SKYSJE21)+CheckIsNullOrEmpty(SKYSJE22)+CheckIsNullOrEmpty(SKYSJE23)+ CheckIsNullOrEmpty(SKYSJE24)+CheckIsNullOrEmpty(SKYSJE25)+ CheckIsNullOrEmpty(SKYSJE26) + CheckIsNullOrEmpty(SKYSJE27); mini.get("SKYSJE19").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKYSJE19DX").setValue(xiaojiheji); aAdd_3(); } //间接费用第一列数据总和 function bAdd_1(){ var SKYSJE29=mini.get("SKYSJE29").getValue(); var SKYSJE30=mini.get("SKYSJE30").getValue(); var total=CheckIsNullOrEmpty(SKYSJE29)+ CheckIsNullOrEmpty(SKYSJE30); mini.get("SKYSJE28").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKYSJE28DX").setValue(xiaojiheji); bAdd_3(); } //第一列数据总和 function cAdd_1(){ var SKYSJE19=mini.get("SKYSJE19").getValue(); var SKYSJE28=mini.get("SKYSJE28").getValue(); var SKYSJE31=mini.get("SKYSJE31").getValue(); var total=CheckIsNullOrEmpty(SKYSJE19)+ CheckIsNullOrEmpty(SKYSJE28)+ CheckIsNullOrEmpty(SKYSJE31); mini.get("SKYSJE32").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKYSJE32DX").setValue(xiaojiheji); cAdd_3(); } //直接费用第二列数据总和 function aAdd_2(){ var SKTZS20=mini.get("SKTZS20").getValue(); var SKTZS21=mini.get("SKTZS21").getValue(); var SKTZS22=mini.get("SKTZS22").getValue(); var SKTZS23=mini.get("SKTZS23").getValue(); var SKTZS24=mini.get("SKTZS24").getValue(); var SKTZS25=mini.get("SKTZS25").getValue(); var SKTZS26=mini.get("SKTZS26").getValue(); var SKTZS27=mini.get("SKTZS27").getValue(); var total=CheckIsNullOrEmpty(SKTZS20)+ CheckIsNullOrEmpty(SKTZS21)+CheckIsNullOrEmpty(SKTZS22)+CheckIsNullOrEmpty(SKTZS23)+ CheckIsNullOrEmpty(SKTZS24)+CheckIsNullOrEmpty(SKTZS25)+ CheckIsNullOrEmpty(SKTZS26) + CheckIsNullOrEmpty(SKTZS27); mini.get("SKTZS19").setValue(total); var xiaojiheji = adjustMoney(total.toString()); mini.get("#SKTZS19DX").setValue(xiaojiheji); aAdd_3(); } //间接费用第二列数据总和 function bAdd_2(){ var SKTZS29=mini.get("SKTZS29").getValue(); var SKTZS30=mini.get("SKTZS30").getValue(); var total=CheckIsNullOrEmpty(SKTZS29)+ CheckIsNullOrEmpty(SKTZS30); mini.get("SKTZS28").setValue(total); var xiaojiheji = adjustMoney(total.toString()); mini.get("#SKTZS28DX").setValue(xiaojiheji); bAdd_3(); } //第二列数据总和 function cAdd_2(){ var SKTZS19=mini.get("SKTZS19").getValue(); var SKTZS28=mini.get("SKTZS28").getValue(); var SKTZS31=mini.get("SKTZS31").getValue(); var total=CheckIsNullOrEmpty(SKTZS19)+ CheckIsNullOrEmpty(SKTZS28)+ CheckIsNullOrEmpty(SKTZS31); mini.get("SKTZS32").setValue(total); var xiaojiheji = adjustMoney(total.toString()); mini.get("#SKTZS32DX").setValue(xiaojiheji); cAdd_3(); } //直接费用第三列数据总和 function aAdd_3(){ var SKYSJE19=mini.get("SKYSJE19").getValue(); var SKTZS19=mini.get("SKTZS19").getValue(); var total=CheckIsNullOrEmpty(SKYSJE19)+ CheckIsNullOrEmpty(SKTZS19); mini.get("SKTZH19").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKTZH19DX").setValue(xiaojiheji); } //间接费用第三列数据总和 function bAdd_3(){ var SKYSJE28=mini.get("SKYSJE28").getValue(); var SKTZS28=mini.get("SKTZS28").getValue(); var total=CheckIsNullOrEmpty(SKYSJE28)+ CheckIsNullOrEmpty(SKTZS28); mini.get("SKTZH28").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKTZH28DX").setValue(xiaojiheji); } //第三列数据总和 function cAdd_3(){ var SKYSJE32=mini.get("SKYSJE32").getValue(); var SKTZS32=mini.get("SKTZS32").getValue(); var total=CheckIsNullOrEmpty(SKYSJE32)+ CheckIsNullOrEmpty(SKTZS32); mini.get("SKTZH32").setValue(total); var xiaojiheji = justMoney(total.toString()); mini.get("#SKTZH32DX").setValue(xiaojiheji); } //判断数据是否为Null或者undefined或者为空字符串 function CheckIsNullOrEmptyForPanduan(value) { //正则表达式用于判斷字符串是否全部由空格或换行符组成 var reg = /^\s*$/; var reg1=/^(\-|\+)?\d+(\.\d+)?$/; //返回值为true表示不是空字符串 if (value != null && value != undefined && !reg.test(value) && !reg1.test(value)) return 0; else return "无效数字"; } //判断数据是否为Null或者undefined或者为空字符串 function CheckIsNullOrEmpty(value) { //正则表达式用于判斷字符串是否全部由空格或换行符组成 var reg = /^\s*$/; var reg1=/^(\-|\+)?\d+(\.\d+)?$/; //返回值为true表示不是空字符串 if (value != null && value != undefined && !reg.test(value)) if(reg1.test(value)){ return parseFloat(value); }else{ return 0; } else return 0; } function adjustMoney(str){ debugger; var s= parseFloat(str); var fh='无调整'; if(s==0.0||(s>0&&s<0.0001)){ return fh; } var le=str.length; if(str.length>1){ var s1 = str.substring(0,1); var s2=str.substring(1,str.length); var daxie=''; if(s1=='-'){ fh='减少:'; daxie=changeMoneyToChinese(s2); }else if(s1=='+'){ fh='增加:'; daxie=changeMoneyToChinese(s2); }else{ fh='增加:'; daxie=changeMoneyToChinese(str); } }else{ fh='增加:'; daxie=changeMoneyToChinese(str); } return fh+daxie; } function justMoney(str){ var s= parseFloat(str); var fh='零元整'; var daxie=''; if(str.length>1){ var s1 = str.substring(0,1); var s2=str.substring(1,str.length); if(s1=='-'){ fh='负'; daxie=changeMoneyToChinese(s2); }else{ fh=''; daxie=changeMoneyToChinese(str); } }else{ fh=''; daxie=changeMoneyToChinese(str); } return fh+daxie; } function changeMoneyToChinese(money){ var cnNums = new Array("零","壹","贰","叁","肆","伍","陆","柒","捌","玖"); //汉字的数字 var cnIntRadice = new Array("","拾","佰","仟"); //基本单位 var cnIntUnits = new Array("","万","亿","兆"); //对应整数部分扩展单位 var cnDecUnits = new Array("角","分","毫","厘"); //对应小数部分单位 var cnInteger = "整"; //整数金额时后面跟的字符 var cnIntLast = "元"; //整型完以后的 var maxNum = 999999999999999.9999; //最大处理的数字 var IntegerNum; //金额整数部分 var DecimalNum; //金额小数部分 var ChineseStr=""; //输出的中文金额字符串 var parts; //分离金额后用的数组,预定义 money = parseFloat(money); if( money >= maxNum ){ $.alert('超出最大处理数字'); return ""; } if( money == 0 ){ //ChineseStr = cnNums[0]+cnIntLast+cnInteger; ChineseStr = cnNums[0]+cnIntLast+cnInteger; //document.getElementById("show").value=ChineseStr; return ChineseStr; } money = money.toString(); //转换为字符串 if( money.indexOf(".") == -1 ){ IntegerNum = money; DecimalNum = ''; }else{ parts = money.split("."); IntegerNum = parts[0]; DecimalNum = parts[1].substr(0,4); } if( parseInt(IntegerNum,10) > 0 ){//获取整型部分转换 zeroCount = 0; IntLen = IntegerNum.length; for( i=0;i<IntLen;i++ ){ n = IntegerNum.substr(i,1); p = IntLen - i - 1; q = p / 4; m = p % 4; if( n == "0" ){ zeroCount++; }else{ if( zeroCount >0 ){ ChineseStr += cnNums[0]; } zeroCount = 0; //归零 ChineseStr += cnNums[parseInt(n)]+cnIntRadice[m]; } if( m==0 && zeroCount<4 ){ ChineseStr += cnIntUnits[q]; } } ChineseStr += cnIntLast; //整型部分处理完毕 } if( DecimalNum!= '' ){//小数部分 decLen = DecimalNum.length; for( i=0; i<decLen; i++ ){ n = DecimalNum.substr(i,1); if( n != '0' ){ ChineseStr += cnNums[Number(n)]+cnDecUnits[i]; } } } if( ChineseStr == '' ){ //ChineseStr += cnNums[0]+cnIntLast+cnInteger; ChineseStr += cnNums[0]+cnIntLast; }else if( DecimalNum == '' ){ ChineseStr += cnInteger; } return ChineseStr; }
社科移动:
//第一列 //资料费 $('#SKYSJE20').keyup(IsSameValue); //数据采集费 $('#SKYSJE21').keyup(IsSameValue1); //会议费/差旅费/国际交流与合作费 $('#SKYSJE22').keyup(IsSameValue2); //设备费 $('#SKYSJE23').keyup(IsSameValue3); //专家咨询费 $('#SKYSJE24').keyup(IsSameValue4); //劳务费 $('#SKYSJE25').keyup(IsSameValue5); //印刷费/宣传费 $('#SKYSJE26').keyup(IsSameValue6); //其他支出 $('#SKYSJE27').keyup(IsSameValue7); //其中:管理费 $('#SKYSJE29').keyup(IsSameValue8); //绩效支出 $('#SKYSJE30').keyup(IsSameValue9); //外协单位经费 $('#SKYSJE31').keyup(IsSameValue10); //第二列 //资料费 $('#SKTZS20').keyup(IsSameValue20); //数据采集费 $('#SKTZS21').keyup(IsSameValue21); //会议费/差旅费/国际交流与合作费 $('#SKTZS22').keyup(IsSameValue22); //设备费 $('#SKTZS23').keyup(IsSameValue23); //专家咨询费 $('#SKTZS24').keyup(IsSameValue24); //劳务费 $('#SKTZS25').keyup(IsSameValue25); //印刷费/宣传费 $('#SKTZS26').keyup(IsSameValue26); //其他支出 $('#SKTZS27').keyup(IsSameValue27); //其中:管理费 $('#SKTZS29').keyup(IsSameValue28); //绩效支出 $('#SKTZS30').keyup(IsSameValue29); //外协单位经费 $('#SKTZS31').keyup(IsSameValue30); //计算合计 function IsSameValue(){ var moneyName="SKYSJE20"; var moneyDX="SKYSJE20DX"; var moneyName1="SKTZS20"; var moneyName2="SKTZH20"; var moneyDX2="SKTZH20DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue1(){ var moneyName="SKYSJE21"; var moneyDX="SKYSJE21DX"; var moneyName1="SKTZS21"; var moneyName2="SKTZH21"; var moneyDX2="SKTZH21DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue2(){ var moneyName="SKYSJE22"; var moneyDX="SKYSJE22DX"; var moneyName1="SKTZS22"; var moneyName2="SKTZH22"; var moneyDX2="SKTZH22DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue3(){ var moneyName="SKYSJE23"; var moneyDX="SKYSJE23DX"; var moneyName1="SKTZS23"; var moneyName2="SKTZH2023"; var moneyDX2="SKTZH23DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue4(){ var moneyName="SKYSJE24"; var moneyDX="SKYSJE24DX"; var moneyName1="SKTZS24"; var moneyName2="SKTZH24"; var moneyDX2="SKTZH24DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue5(){ var moneyName="SKYSJE25"; var moneyDX="SKYSJE25DX"; var moneyName1="SKTZS25"; var moneyName2="SKTZH25"; var moneyDX2="SKTZH25DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue6(){ var moneyName="SKYSJE26"; var moneyDX="SKYSJE26DX"; var moneyName1="SKTZS26"; var moneyName2="SKTZH26"; var moneyDX2="SKTZH26DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue7(){ var moneyName="SKYSJE27"; var moneyDX="SKYSJE27DX"; var moneyName1="SKTZS27"; var moneyName2="SKTZH27"; var moneyDX2="SKTZH27DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_1(); cAdd_1(); } function IsSameValue8(){ var moneyName="SKYSJE29"; var moneyDX="SKYSJE29DX"; var moneyName1="SKTZS29"; var moneyName2="SKTZH29"; var moneyDX2="SKTZH29DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_1(); cAdd_1(); } function IsSameValue9(){ var moneyName="SKYSJE30"; var moneyDX="SKYSJE30DX"; var moneyName1="SKTZS30"; var moneyName2="SKTZH30"; var moneyDX2="SKTZH30DX"; handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_1(); cAdd_1(); } function IsSameValue10(){ var money=$('#SKYSJE31').val(); var s1 = money.substring(0,1); if(s1=='-'){ alert('原经费预算不可为负数'); document.querySelector("#SKYSJE31").value=0; return; } var xiaoji = justMoney(money); document.querySelector("#SKYSJE31DX").value=xiaoji; var money2=$('#SKTZS31').val(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); document.querySelector("#SKTZH31").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKTZH31DX").value=xiaojiheji; cAdd_1(); } function IsSameValue20(){ var moneyName="SKTZS20"; var moneyDX="SKTZS20DX"; var moneyName1="SKYSJE20"; var moneyName2="SKTZH20"; var moneyDX2="SKTZH20DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue21(){ var moneyName="SKTZS21"; var moneyDX="SKTZS21DX"; var moneyName1="SKYSJE21"; var moneyName2="SKTZH21"; var moneyDX2="SKTZH21DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue22(){ var moneyName="SKTZS22"; var moneyDX="SKTZS22DX"; var moneyName1="SKYSJE22"; var moneyName2="SKTZH22"; var moneyDX2="SKTZH22DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue23(){ var moneyName="SKTZS23"; var moneyDX="SKTZS23DX"; var moneyName1="SKYSJE23"; var moneyName2="SKTZH2023"; var moneyDX2="SKTZH23DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue24(){ var moneyName="SKTZS24"; var moneyDX="SKTZS24DX"; var moneyName1="SKYSJE24"; var moneyName2="SKTZH24"; var moneyDX2="SKTZH24DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue25(){ var moneyName="SKTZS25"; var moneyDX="SKTZS25DX"; var moneyName1="SKYSJE25"; var moneyName2="SKTZH25"; var moneyDX2="SKTZH25DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue26(){ var moneyName="SKTZS26"; var moneyDX="SKTZS26DX"; var moneyName1="SKYSJE26"; var moneyName2="SKTZH26"; var moneyDX2="SKTZH26DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue27(){ var moneyName="SKTZS27"; var moneyDX="SKTZS27DX"; var moneyName1="SKYSJE27"; var moneyName2="SKTZH27"; var moneyDX2="SKTZH27DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); aAdd_2(); cAdd_2(); } function IsSameValue28(){ var moneyName="SKTZS28"; var moneyDX="SKTZS28DX"; var moneyName1="SKYSJE28"; var moneyName2="SKTZH28"; var moneyDX2="SKTZH28DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_2(); cAdd_2(); } function IsSameValue29(){ var moneyName="SKTZS29"; var moneyDX="SKTZS29DX"; var moneyName1="SKYSJE29"; var moneyName2="SKTZH29"; var moneyDX2="SKTZH29DX"; bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2); bAdd_2(); cAdd_2(); } function IsSameValue30(){ var money=$('#SKTZS30').val(); var xiaoji = adjustMoney(money); document.querySelector("#SKTZS30DX").value=xiaoji; var money2=$('#SKYSJE30').val(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); document.querySelector("#SKTZH30").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKTZH30DX").value=xiaojiheji; cAdd_2(); } //第一列行处理 function handle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2){ var money=$('#'+moneyName).val(); var s1 = money.substring(0,1); if(s1=='-'){ alert('原经费预算不可为负数'); document.querySelector("#"+moneyName).value=0; return; } var xiaoji = justMoney(money); document.querySelector("#"+moneyDX).value=xiaoji; var money2=$('#'+moneyName1).val(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); document.querySelector("#"+moneyName2).value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#"+moneyDX2).value=xiaojiheji; } //第二列行处理 function bhandle(moneyName,moneyDX,moneyName1,moneyName2,moneyDX2){ var money=$('#'+moneyName).val(); var xiaoji = adjustMoney(money); document.querySelector("#"+moneyDX).value=xiaoji; var money2=$('#'+moneyName1).val(); var total=CheckIsNullOrEmpty(money)+ CheckIsNullOrEmpty(money2); document.querySelector("#"+moneyName2).value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#"+moneyDX2).value=xiaojiheji; } //直接费用第一列数据总和 function aAdd_1(){ var SKYSJE20=$('#SKYSJE20').val(); var SKYSJE21=$('#SKYSJE21').val(); var SKYSJE22=$('#SKYSJE22').val(); var SKYSJE23=$('#SKYSJE23').val(); var SKYSJE24=$('#SKYSJE24').val(); var SKYSJE25=$('#SKYSJE25').val(); var SKYSJE26=$('#SKYSJE26').val(); var SKYSJE27=$('#SKYSJE27').val(); var total=CheckIsNullOrEmpty(SKYSJE20)+ CheckIsNullOrEmpty(SKYSJE21)+CheckIsNullOrEmpty(SKYSJE22)+CheckIsNullOrEmpty(SKYSJE23)+ CheckIsNullOrEmpty(SKYSJE24)+CheckIsNullOrEmpty(SKYSJE25)+ CheckIsNullOrEmpty(SKYSJE26) + CheckIsNullOrEmpty(SKYSJE27); document.querySelector("#SKYSJE19").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKYSJE19DX").value=xiaojiheji; aAdd_3(); } //间接费用第一列数据总和 function bAdd_1(){ var SKYSJE29=$('#SKYSJE29').val(); var SKYSJE30=$('#SKYSJE30').val(); var total=CheckIsNullOrEmpty(SKYSJE29)+ CheckIsNullOrEmpty(SKYSJE30); document.querySelector("#SKYSJE28").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKYSJE28DX").value=xiaojiheji; bAdd_3(); } //第一列数据总和 function cAdd_1(){ var SKYSJE19=$('#SKYSJE19').val(); var SKYSJE28=$('#SKYSJE28').val(); var SKYSJE31=$('#SKYSJE31').val(); var total=CheckIsNullOrEmpty(SKYSJE19)+ CheckIsNullOrEmpty(SKYSJE28)+ CheckIsNullOrEmpty(SKYSJE31); document.querySelector("#SKYSJE32").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKYSJE32DX").value=xiaojiheji; cAdd_3(); } //直接费用第二列数据总和 function aAdd_2(){ var SKTZS20=$('#SKTZS20').val(); var SKTZS21=$('#SKTZS21').val(); var SKTZS22=$('#SKTZS22').val(); var SKTZS23=$('#SKTZS23').val(); var SKTZS24=$('#SKTZS24').val(); var SKTZS25=$('#SKTZS25').val(); var SKTZS26=$('#SKTZS26').val(); var SKTZS27=$('#SKTZS27').val(); var total=CheckIsNullOrEmpty(SKTZS20)+ CheckIsNullOrEmpty(SKTZS21)+CheckIsNullOrEmpty(SKTZS22)+CheckIsNullOrEmpty(SKTZS23)+ CheckIsNullOrEmpty(SKTZS24)+CheckIsNullOrEmpty(SKTZS25)+ CheckIsNullOrEmpty(SKTZS26) + CheckIsNullOrEmpty(SKTZS27); document.querySelector("#SKTZS19").value=total; var xiaojiheji = adjustMoney(total.toString()); document.querySelector("#SKTZS19DX").value=xiaojiheji; aAdd_3(); } //间接费用第二列数据总和 function bAdd_2(){ var SKTZS29=$('#SKTZS29').val(); var SKTZS30=$('#SKTZS30').val(); var total=CheckIsNullOrEmpty(SKTZS29)+ CheckIsNullOrEmpty(SKTZS30); document.querySelector("#SKTZS28").value=total; var xiaojiheji = adjustMoney(total.toString()); document.querySelector("#SKTZS28DX").value=xiaojiheji; bAdd_3(); } //第二列数据总和 function cAdd_2(){ var SKTZS19=$('#SKTZS19').val(); var SKTZS28=$('#SKTZS28').val(); var SKTZS31=$('#SKTZS31').val(); var total=CheckIsNullOrEmpty(SKTZS19)+ CheckIsNullOrEmpty(SKTZS28)+ CheckIsNullOrEmpty(SKTZS31); document.querySelector("#SKTZS32").value=total; var xiaojiheji = adjustMoney(total.toString()); document.querySelector("#SKTZS32DX").value=xiaojiheji; cAdd_3(); } //直接费用第三列数据总和 function aAdd_3(){ var SKYSJE19=$('#SKYSJE19').val(); var SKTZS19=$('#SKTZS19').val(); var total=CheckIsNullOrEmpty(SKYSJE19)+ CheckIsNullOrEmpty(SKTZS19); document.querySelector("#SKTZH19").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKTZH19DX").value=xiaojiheji; } //间接费用第三列数据总和 function bAdd_3(){ var SKYSJE28=$('#SKYSJE28').val(); var SKTZS28=$('#SKTZS28').val(); var total=CheckIsNullOrEmpty(SKYSJE28)+ CheckIsNullOrEmpty(SKTZS28); document.querySelector("#SKTZH28").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKTZH28DX").value=xiaojiheji; } //第三列数据总和 function cAdd_3(){ var SKYSJE32=$('#SKYSJE32').val(); var SKTZS32=$('#SKTZS32').val(); var total=CheckIsNullOrEmpty(SKYSJE32)+ CheckIsNullOrEmpty(SKTZS32); document.querySelector("#SKTZH32").value=total; var xiaojiheji = justMoney(total.toString()); document.querySelector("#SKTZH32DX").value= xiaojiheji ; } //判断数据是否为Null或者undefined或者为空字符串 function CheckIsNullOrEmptyForPanduan(value) { //正则表达式用于判斷字符串是否全部由空格或换行符组成 var reg = /^\s*$/; var reg1=/^(\-|\+)?\d+(\.\d+)?$/; //返回值为true表示不是空字符串 if (value != null && value != undefined && !reg.test(value) && !reg1.test(value)) return 0; else return "无效数字"; } //判断数据是否为Null或者undefined或者为空字符串 function CheckIsNullOrEmpty(value) { //正则表达式用于判斷字符串是否全部由空格或换行符组成 var reg = /^\s*$/; var reg1=/^(\-|\+)?\d+(\.\d+)?$/; //返回值为true表示不是空字符串 if (value != null && value != undefined && !reg.test(value)) if(reg1.test(value)){ return parseFloat(value); }else{ return 0; } else return 0; } function adjustMoney(str){ var s= parseFloat(str); var fh='无调整'; if(s==0.0||(s>0&&s<0.0001)){ return fh; } var le=str.length; if(str.length>1){ var s1 = str.substring(0,1); var s2=str.substring(1,str.length); var daxie=''; if(s1=='-'){ fh='减少:'; daxie=changeMoneyToChinese(s2); }else if(s1=='+'){ fh='增加:'; daxie=changeMoneyToChinese(s2); }else{ fh='增加:'; daxie=changeMoneyToChinese(str); } }else{ fh='增加:'; daxie=changeMoneyToChinese(str); } return fh+daxie; } function justMoney(str){ var s= parseFloat(str); var fh='零元整'; var daxie=''; if(str.length>1){ var s1 = str.substring(0,1); var s2=str.substring(1,str.length); if(s1=='-'){ fh='负'; daxie=changeMoneyToChinese(s2); }else{ fh=''; daxie=changeMoneyToChinese(str); } }else{ fh=''; daxie=changeMoneyToChinese(str); } return fh+daxie; } function changeMoneyToChinese(money) { var cnNums = new Array( '零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖' ) //汉字的数字 var cnIntRadice = new Array('', '拾', '佰', '仟') //基本单位 var cnIntUnits = new Array('', '万', '亿', '兆') //对应整数部分扩展单位 var cnDecUnits = new Array('角', '分', '毫', '厘') //对应小数部分单位 //var cnInteger = "整"; //整数金额时后面跟的字符 var cnIntLast = '元' //整型完以后的单位 var maxNum = 999999999999999.9999 //最大处理的数字 var IntegerNum //金额整数部分 var DecimalNum //金额小数部分 var ChineseStr = '' //输出的中文金额字符串 var parts //分离金额后用的数组,预定义 if (money == '') { return '' } money = parseFloat(money) if (money >= maxNum) { alert('超出最大处理数字') return '' } if (money == 0) { //ChineseStr = cnNums[0]+cnIntLast+cnInteger; ChineseStr = cnNums[0] + cnIntLast return ChineseStr } money = money.toString() //转换为字符串 if (money.indexOf('.') == -1) { IntegerNum = money DecimalNum = '' } else { parts = money.split('.') IntegerNum = parts[0] DecimalNum = parts[1].substr(0, 4) } if (parseInt(IntegerNum, 10) > 0) { //获取整型部分转换 zeroCount = 0 IntLen = IntegerNum.length for (i = 0; i < IntLen; i++) { n = IntegerNum.substr(i, 1) p = IntLen - i - 1 q = p / 4 m = p % 4 if (n == '0') { zeroCount++ } else { if (zeroCount > 0) { ChineseStr += cnNums[0] } zeroCount = 0 //归零 ChineseStr += cnNums[parseInt(n)] + cnIntRadice[m] } if (m == 0 && zeroCount < 4) { ChineseStr += cnIntUnits[q] } } ChineseStr += cnIntLast //整型部分处理完毕 } if (DecimalNum != '') { //小数部分 decLen = DecimalNum.length for (i = 0; i < decLen; i++) { n = DecimalNum.substr(i, 1) if (n != '0') { ChineseStr += cnNums[Number(n)] + cnDecUnits[i] } } } if (ChineseStr == '') { //ChineseStr += cnNums[0]+cnIntLast+cnInteger; ChineseStr += cnNums[0] + cnIntLast } return ChineseStr }