使用计算脚本做表单

24.使用计算脚本做表单.

#include "数据字典";
(function(){
    //项目编号、项目名称、项目类型、项目负责人、合同金额、已开票金额、已到账金额
    var doc = getCurrentDocument();
    var projectId= doc.getItemValueAsString("签进合同ID");
    var projectName="";
    var sql=" select item_项目编号,item_项目名称,item_项目类型,item_项目负责人,合同金额_bak as item_已开合同金额,开票金额_bak as item_已开票金额, ";
    sql +="  到账金额_bak as item_已到帐金额 ,domainid  from tlk_项目 where item_项目编号 in ";
    sql += "(select distinct item_项目编号 from tlk_签进合同明细 where parent ='"+projectId+"' and item_项目编号 is not null ";
    sql +=" and item_项目编号 <> '')";
    var query = queryBySQL(sql);
    var html="";
    if(query!=null){
        html+="<table cellSpacing='0' cellPadding='1' width='100%' align='center' style='border:solid #cccccc;border-width:1px 0px 0px 1px;'><tbody> ";
        html+=" <tr style='line-height:22px;'> ";
        html+="         <td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=200px;' >项目名称</td>  ";
        html+="         <td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=50px' >项目编号</td> ";
        html+="         <td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=50px' >项目类型</td>  ";
        html+="         <td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;'  >项目负责人</td> ";
        html+="         <td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=100px' >项目合同金额(元)</td> ";
        html+="         <td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=100px' >已开票金额(元)</td> ";
        html+="         <td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=100px' >已到账金额(元)</td> ";
        html+="</tr>";
        for(var its = query.iterator();its.hasNext();){
            var datas=its.next();  
            var xmNum=datas.getItemValueAsString("项目编号");
            var xmName=datas.getItemValueAsString("项目名称");
            var xmType_x=datas.getItemValueAsString("项目类型");
            var xmTypeName=getProjectTyle(xmType_x);
            var xmFzPeo_id=datas.getItemValueAsString("项目负责人");
            var xmFzPeo_name="";
            if(xmFzPeo_id!=null && xmFzPeo_id.trim().length()>0){
                var userDoc=getUserById(xmFzPeo_id);
                if(userDoc!=null){
                    xmFzPeo_name=userDoc.getName();
                }
            }
            var xm_htMon=datas.getItemValueAsDouble("已开合同金额");
            var xm_kpMon=datas.getItemValueAsDouble("已开票金额");
            var xm_dzMon=datas.getItemValueAsDouble("已到帐金额");
            html+="<tr><td>"+xmName;
            html+="</td><td>"+xmNum;
            html+="</td><td>"+xmTypeName;
            html+="</td><td>"+xmFzPeo_name;
            html+="</td><td>"+xm_htMon;
            html+="</td><td>"+xm_kpMon;
            html+="</td><td>"+xm_dzMon;
            html+="</td></tr>";

        }
        html+=" </tbody></table>";
    }
    return html;
})();