得到申请金额【函数-getCommitmentAmount (pwpno)】

函数格式：
getCommitmentAmount (pwpno)
函数说明：
pwpno：
示例：
实现getCommitmentAmount (pwpno)函数的应用
function getCommitmentAmount(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_commitment_detail cd,tlk_tm_commitment 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_ac) as item_amount,'"+domainid+"' as domainid"
                +" from tlk_tm_commitment_discount cd,tlk_tm_commitment 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_commitment_others cd,tlk_tm_commitment 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(cd.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;
        return value;
}
调用
#include " businesslib ";
getCommitmentAmount ("pwpno ");