科研经费
原经费预算数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 }

浙公网安备 33010602011771号