得到已报销金额【函数-getExpenseAmount (pwpno)】

函数格式：
getExpenseAmount (pwpno)
函数说明：
pwpno：
示例：
实现getExpenseAmount (pwpno)函数的应用
function getExpenseAmount(pwpno){
        var domainid = getDomainid();
        if(!pwpno) pwpno = getItemValue("pwpno");

        //促销费用明细（非折扣、佣金）
        var sql1 = " select sum(cd.item_amount) as item_amount,'"+domainid+"' as domainid"
                +" from tlk_tm_expense_detail cd,tlk_tm_expense c"
                +" where cd.parent=c.id and c.statelabel <> '申请' and cd.item_pwpno='"+pwpno+"'";
        var count1 = 0;
        var data1 = queryBySQL(sql1);
        var iter1 = data1.iterator();
        if(iter1.hasNext()){
                var doc1 = iter1.next();
                count1 = doc1.getItemValueAsDouble("amount");
        }
        //折让
        var sql2 = " select sum(cd.item_amount) as item_amount,'"+domainid+"' as domainid"
                +" from tlk_tm_expense_discount cd,tlk_tm_expense c"
                +" where cd.parent=c.id and c.statelabel <> '申请' and cd.item_pwpno='"+pwpno+"'";
        var count2 = 0;
        var data2 = queryBySQL(sql2);
        var iter2 = data2.iterator();
        if(iter2.hasNext()){
                var doc2 = iter2.next();
                count2 = doc2.getItemValueAsDouble("amount");
        }
        //其它
        var sql3 = " select sum(cd.item_amount) as item_amount,'"+domainid+"' as domainid"
                +" from tlk_tm_expense_others cd,tlk_tm_expense c"
                +" where cd.parent=c.id and c.statelabel <> '申请' and cd.item_pwpno='"+pwpno+"'";
        var count3 = 0;
        var data3 = queryBySQL(sql3);
        var iter3 = data3.iterator();
        if(iter3.hasNext()){
                var doc3 = iter3.next();
                count3 = doc3.getItemValueAsDouble("amount");
        }
        //样赠
/*        var sql4 = " select sum(item_accountingamount) as item_amount,'"+domainid+"' as domainid"
                +" from tlk_tm_commitment_sample cd,tlk_tm_commitment c"
                +" where cd.parent=c.id and c.statelabel <> '取消' and cd.item_pwpno='"+pwpno+"'";
        var count4 = 0;
        var data4 = queryBySQL(sql4);
        var iter4 = data4.iterator();
        if(iter4.hasNext()){
                var doc4 = iter4.next();
                count4 = doc4.getItemValueAsDouble("amount");
        }
        var value = count1 + count2 + count3 + count4;
        */
        var value = count1 + count2 + count3;
        return value;
}

调用
#include " businesslib ";
getExpenseAmount ("pwpno ");