金蝶Bos的报表跟过滤条件

最新推荐文章于 2024-04-11 16:45:01 发布
最新推荐文章于 2024-04-11 16:45:01 发布
阅读量2.3k 收藏 1
点赞数
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_33524771/article/details/71420238
本文介绍了一种基于Kingdee平台的供应商报表设计与实现方法，包括报表显示界面代码及过滤条件设置，通过SQL查询实现数据展示。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

报表的显示界面代码如下：

/**
 * output package name
 */
package com.kingdee.eas.custom.client;

import java.awt.event.*;
import java.sql.SQLException;
import java.text.SimpleDateFormat;

import org.apache.log4j.Logger;
import com.kingdee.bos.ctrl.kdf.table.IRow;
import com.kingdee.bos.BOSException;
import com.kingdee.bos.ui.face.CoreUIObject;
import com.kingdee.bos.ctrl.kdf.table.ISortManager;
import com.kingdee.bos.ctrl.kdf.table.KDTable;
import com.kingdee.bos.dao.query.SQLExecutorFactory;
import com.kingdee.eas.custom.MaterialLittleInfo;
import com.kingdee.eas.custom.SupplierArchiveInfo;
import com.kingdee.eas.framework.report.ICommRptBase;
import com.kingdee.eas.framework.report.client.CommRptBaseConditionUI;
import com.kingdee.eas.framework.report.util.RptParams;
import com.kingdee.jdbc.rowset.IRowSet;

/**
 * output class name
 */
public class TestStatement extends AbstractTestStatement implements ISortManager
{
    private static final Logger logger = CoreUIObject.getLogger(TestStatement.class);
   // Tnumber Tname TCreditCode Taddress TBUSLICDATE TSupStatus TrealName Tphone TcataLoginId TcataLoginName TparentId  TparentName
    private static final String[] rowcont={"Tnumber","Tname","TCreditCode","Taddress","TBUSLICDATE","TSupStatus","TrealName","Tphone","TcataLoginId","TcataLoginName","TparentId","TparentName"};


    /**
     * output class constructor
     */
    public TestStatement() throws Exception
    {
        super();
    }

    /**
     * output storeFields method
     */
    public void storeFields()
    {
        super.storeFields();
    }

    /**
     * output actionPageSetup_actionPerformed
     */
    public void actionPageSetup_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPageSetup_actionPerformed(e);
    }

    /**
     * output actionExitCurrent_actionPerformed
     */
    public void actionExitCurrent_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExitCurrent_actionPerformed(e);
    }

    /**
     * output actionHelp_actionPerformed
     */
    public void actionHelp_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionHelp_actionPerformed(e);
    }

    /**
     * output actionAbout_actionPerformed
     */
    public void actionAbout_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionAbout_actionPerformed(e);
    }

    /**
     * output actionOnLoad_actionPerformed
     */
    public void actionOnLoad_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionOnLoad_actionPerformed(e);
    }

    /**
     * output actionSendMessage_actionPerformed
     */
    public void actionSendMessage_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionSendMessage_actionPerformed(e);
    }

    /**
     * output actionCalculator_actionPerformed
     */
    public void actionCalculator_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCalculator_actionPerformed(e);
    }

    /**
     * output actionExport_actionPerformed
     */
    public void actionExport_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExport_actionPerformed(e);
    }

    /**
     * output actionExportSelected_actionPerformed
     */
    public void actionExportSelected_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExportSelected_actionPerformed(e);
    }

    /**
     * output actionRegProduct_actionPerformed
     */
    public void actionRegProduct_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionRegProduct_actionPerformed(e);
    }

    /**
     * output actionPersonalSite_actionPerformed
     */
    public void actionPersonalSite_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPersonalSite_actionPerformed(e);
    }

    /**
     * output actionProcductVal_actionPerformed
     */
    public void actionProcductVal_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionProcductVal_actionPerformed(e);
    }

    /**
     * output actionExportSave_actionPerformed
     */
    public void actionExportSave_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExportSave_actionPerformed(e);
    }

    /**
     * output actionExportSelectedSave_actionPerformed
     */
    public void actionExportSelectedSave_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExportSelectedSave_actionPerformed(e);
    }

    /**
     * output actionKnowStore_actionPerformed
     */
    public void actionKnowStore_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionKnowStore_actionPerformed(e);
    }

    /**
     * output actionAnswer_actionPerformed
     */
    public void actionAnswer_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionAnswer_actionPerformed(e);
    }

    /**
     * output actionRemoteAssist_actionPerformed
     */
    public void actionRemoteAssist_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionRemoteAssist_actionPerformed(e);
    }

    /**
     * output actionPopupCopy_actionPerformed
     */
    public void actionPopupCopy_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPopupCopy_actionPerformed(e);
    }

    /**
     * output actionHTMLForMail_actionPerformed
     */
    public void actionHTMLForMail_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionHTMLForMail_actionPerformed(e);
    }

    /**
     * output actionExcelForMail_actionPerformed
     */
    public void actionExcelForMail_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExcelForMail_actionPerformed(e);
    }

    /**
     * output actionHTMLForRpt_actionPerformed
     */
    public void actionHTMLForRpt_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionHTMLForRpt_actionPerformed(e);
    }

    /**
     * output actionExcelForRpt_actionPerformed
     */
    public void actionExcelForRpt_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExcelForRpt_actionPerformed(e);
    }

    /**
     * output actionLinkForRpt_actionPerformed
     */
    public void actionLinkForRpt_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionLinkForRpt_actionPerformed(e);
    }

    /**
     * output actionPopupPaste_actionPerformed
     */
    public void actionPopupPaste_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPopupPaste_actionPerformed(e);
    }

    /**
     * output actionToolBarCustom_actionPerformed
     */
    public void actionToolBarCustom_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionToolBarCustom_actionPerformed(e);
    }

    /**
     * output actionCloudFeed_actionPerformed
     */
    public void actionCloudFeed_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCloudFeed_actionPerformed(e);
    }

    /**
     * output actionCloudShare_actionPerformed
     */
    public void actionCloudShare_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCloudShare_actionPerformed(e);
    }

    /**
     * output actionCloudScreen_actionPerformed
     */
    public void actionCloudScreen_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCloudScreen_actionPerformed(e);
    }

    /**
     * output actionXunTongFeed_actionPerformed
     */
    public void actionXunTongFeed_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionXunTongFeed_actionPerformed(e);
    }

    /**
     * output actionRefresh_actionPerformed
     */
    public void actionRefresh_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionRefresh_actionPerformed(e);
    }

    /**
     * output actionQuery_actionPerformed
     */
    public void actionQuery_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionQuery_actionPerformed(e);
    }

    /**
     * output actionPrint_actionPerformed
     */
    public void actionPrint_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPrint_actionPerformed(e);
    }

    /**
     * output actionPrintPreview_actionPerformed
     */
    public void actionPrintPreview_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPrintPreview_actionPerformed(e);
    }

    /**
     * output actionChart_actionPerformed
     */
    public void actionChart_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionChart_actionPerformed(e);
    }

    @Override
    protected RptParams getParamsForInit() {
        // TODO Auto-generated method stub
        try {
            return  this.getQueryDialogUserPanel().getCustomCondition();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return new RptParams();
    }

    @Override
    protected CommRptBaseConditionUI getQueryDialogUserPanel() throws Exception {
        // TODO Auto-generated method stub
        return new TestFiltration();
    }

    @Override
    protected ICommRptBase getRemoteInstance() throws BOSException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    protected KDTable getTableForPrintSetting() {
        // TODO Auto-generated method stub
        return this.kDTable1 ;
    }

    @Override
    protected void query() {
        // TODO Auto-generated method stub
        this.kDTable1.removeRows();
        this.kDTable1.setEditable(false);
        IRowSet iRowSet;
           // Tnumber Tname TCreditCode Taddress TBUSLICDATE TSupStatus TrealName Tphone TcataLoginId TcataLoginName TparentId  TparentName 
        String sql="select os.CFFnumber Tnumber,os.CFFname  Tname,os.CFCreditCode TCreditCode,  os.CFFaddress Taddress, os.CFFBUSLICDATE  TBUSLICDATE,(case os.CFFSupStatus when '1' then '临时' when '2' then '合格' when '3' then '冻结'else '0' end) TSupStatus,"+
        "ocr.CFRealName TrealName,ocr.CFPhone Tphone,"+
        "mbig.CFFnumber TcataLoginId,mbig.CFFname TcataLoginName,"+
        "msub.CFFnumber TparentId,msub.CFFname TparentName"+
        " from CT_CUS_SupplierArchive as os "+
        " inner join CT_CUS_SupplierArchiveEntries as ocr on os.FID=ocr.FParentID"+
        " inner join CT_CUS_SupplierArchiveEntries2 as om  on os.FID=om.FParentID"+
        " inner join  CT_CUS_MaterialLittle  as msub on om.CFParentIdID=msub.FID"+
        " inner join CT_CUS_MaterialBig as mbig on om.CFCataLoginIdID=mbig.FID where 1=1";
        SupplierArchiveInfo testNum=(SupplierArchiveInfo) params.getObject("tnumber");
        MaterialLittleInfo TestLillterNum=(MaterialLittleInfo) params.getObject("tparentId");
        if(this.params.getObject("tFBUSLICDATE")!=null){
            SimpleDateFormat data=new SimpleDateFormat("yyyy-MM-dd");
            String  TestDate=data.format(this.params.getObject("tFBUSLICDATE"));
            if(!"".equals(TestDate)){
                sql+=" and os.CFFBUSLICDATE='"+TestDate+"'";
            }
        }

        if(testNum!=null){
            sql+=" and os.CFFnumber='"+testNum+"'";
        }

        if(TestLillterNum!=null){
            sql+=" and msub.CFFnumber='"+TestLillterNum+"'";
        }
        System.out.println("================"+sql);

    try {
        kDTable1.checkParsed();
        //执行sql语句
         iRowSet = SQLExecutorFactory.getRemoteInstance(sql).executeSQL();
        while (iRowSet.next()) {
            IRow irow=this.kDTable1.addRow();
            for(int i=0;i<rowcont.length;i++){
                if(iRowSet.getObject(rowcont[i])!=null || "".equals(iRowSet.getObject(rowcont[i]))){
                    //把值添加到界面
                    irow.getCell(i).setValue(iRowSet.getObject(rowcont[i]));
                }
            }
        }
    } catch (BOSException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    }

    @Override
    public void sort(int arg0) {
        // TODO Auto-generated method stub

    }

    @Override
    public void sort(int arg0, int arg1) {
        // TODO Auto-generated method stub

    }

}

报表的过滤条件

/**
 * output package name
 */
package com.kingdee.eas.custom.client;

import java.awt.event.*;
import java.sql.SQLException;
import java.text.SimpleDateFormat;

import org.apache.log4j.Logger;
import com.kingdee.bos.ctrl.kdf.table.IRow;
import com.kingdee.bos.BOSException;
import com.kingdee.bos.ui.face.CoreUIObject;
import com.kingdee.bos.ctrl.kdf.table.ISortManager;
import com.kingdee.bos.ctrl.kdf.table.KDTable;
import com.kingdee.bos.dao.query.SQLExecutorFactory;
import com.kingdee.eas.custom.MaterialLittleInfo;
import com.kingdee.eas.custom.SupplierArchiveInfo;
import com.kingdee.eas.framework.report.ICommRptBase;
import com.kingdee.eas.framework.report.client.CommRptBaseConditionUI;
import com.kingdee.eas.framework.report.util.RptParams;
import com.kingdee.jdbc.rowset.IRowSet;

/**
 * output class name
 */
public class TestStatement extends AbstractTestStatement implements ISortManager
{
    private static final Logger logger = CoreUIObject.getLogger(TestStatement.class);
   // Tnumber Tname TCreditCode Taddress TBUSLICDATE TSupStatus TrealName Tphone TcataLoginId TcataLoginName TparentId  TparentName
    private static final String[] rowcont={"Tnumber","Tname","TCreditCode","Taddress","TBUSLICDATE","TSupStatus","TrealName","Tphone","TcataLoginId","TcataLoginName","TparentId","TparentName"};


    /**
     * output class constructor
     */
    public TestStatement() throws Exception
    {
        super();
    }

    /**
     * output storeFields method
     */
    public void storeFields()
    {
        super.storeFields();
    }

    /**
     * output actionPageSetup_actionPerformed
     */
    public void actionPageSetup_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPageSetup_actionPerformed(e);
    }

    /**
     * output actionExitCurrent_actionPerformed
     */
    public void actionExitCurrent_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExitCurrent_actionPerformed(e);
    }

    /**
     * output actionHelp_actionPerformed
     */
    public void actionHelp_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionHelp_actionPerformed(e);
    }

    /**
     * output actionAbout_actionPerformed
     */
    public void actionAbout_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionAbout_actionPerformed(e);
    }

    /**
     * output actionOnLoad_actionPerformed
     */
    public void actionOnLoad_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionOnLoad_actionPerformed(e);
    }

    /**
     * output actionSendMessage_actionPerformed
     */
    public void actionSendMessage_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionSendMessage_actionPerformed(e);
    }

    /**
     * output actionCalculator_actionPerformed
     */
    public void actionCalculator_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCalculator_actionPerformed(e);
    }

    /**
     * output actionExport_actionPerformed
     */
    public void actionExport_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExport_actionPerformed(e);
    }

    /**
     * output actionExportSelected_actionPerformed
     */
    public void actionExportSelected_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExportSelected_actionPerformed(e);
    }

    /**
     * output actionRegProduct_actionPerformed
     */
    public void actionRegProduct_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionRegProduct_actionPerformed(e);
    }

    /**
     * output actionPersonalSite_actionPerformed
     */
    public void actionPersonalSite_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPersonalSite_actionPerformed(e);
    }

    /**
     * output actionProcductVal_actionPerformed
     */
    public void actionProcductVal_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionProcductVal_actionPerformed(e);
    }

    /**
     * output actionExportSave_actionPerformed
     */
    public void actionExportSave_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExportSave_actionPerformed(e);
    }

    /**
     * output actionExportSelectedSave_actionPerformed
     */
    public void actionExportSelectedSave_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExportSelectedSave_actionPerformed(e);
    }

    /**
     * output actionKnowStore_actionPerformed
     */
    public void actionKnowStore_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionKnowStore_actionPerformed(e);
    }

    /**
     * output actionAnswer_actionPerformed
     */
    public void actionAnswer_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionAnswer_actionPerformed(e);
    }

    /**
     * output actionRemoteAssist_actionPerformed
     */
    public void actionRemoteAssist_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionRemoteAssist_actionPerformed(e);
    }

    /**
     * output actionPopupCopy_actionPerformed
     */
    public void actionPopupCopy_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPopupCopy_actionPerformed(e);
    }

    /**
     * output actionHTMLForMail_actionPerformed
     */
    public void actionHTMLForMail_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionHTMLForMail_actionPerformed(e);
    }

    /**
     * output actionExcelForMail_actionPerformed
     */
    public void actionExcelForMail_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExcelForMail_actionPerformed(e);
    }

    /**
     * output actionHTMLForRpt_actionPerformed
     */
    public void actionHTMLForRpt_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionHTMLForRpt_actionPerformed(e);
    }

    /**
     * output actionExcelForRpt_actionPerformed
     */
    public void actionExcelForRpt_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionExcelForRpt_actionPerformed(e);
    }

    /**
     * output actionLinkForRpt_actionPerformed
     */
    public void actionLinkForRpt_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionLinkForRpt_actionPerformed(e);
    }

    /**
     * output actionPopupPaste_actionPerformed
     */
    public void actionPopupPaste_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPopupPaste_actionPerformed(e);
    }

    /**
     * output actionToolBarCustom_actionPerformed
     */
    public void actionToolBarCustom_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionToolBarCustom_actionPerformed(e);
    }

    /**
     * output actionCloudFeed_actionPerformed
     */
    public void actionCloudFeed_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCloudFeed_actionPerformed(e);
    }

    /**
     * output actionCloudShare_actionPerformed
     */
    public void actionCloudShare_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCloudShare_actionPerformed(e);
    }

    /**
     * output actionCloudScreen_actionPerformed
     */
    public void actionCloudScreen_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionCloudScreen_actionPerformed(e);
    }

    /**
     * output actionXunTongFeed_actionPerformed
     */
    public void actionXunTongFeed_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionXunTongFeed_actionPerformed(e);
    }

    /**
     * output actionRefresh_actionPerformed
     */
    public void actionRefresh_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionRefresh_actionPerformed(e);
    }

    /**
     * output actionQuery_actionPerformed
     */
    public void actionQuery_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionQuery_actionPerformed(e);
    }

    /**
     * output actionPrint_actionPerformed
     */
    public void actionPrint_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPrint_actionPerformed(e);
    }

    /**
     * output actionPrintPreview_actionPerformed
     */
    public void actionPrintPreview_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionPrintPreview_actionPerformed(e);
    }

    /**
     * output actionChart_actionPerformed
     */
    public void actionChart_actionPerformed(ActionEvent e) throws Exception
    {
        super.actionChart_actionPerformed(e);
    }

    @Override
    protected RptParams getParamsForInit() {
        // TODO Auto-generated method stub
        try {
            return  this.getQueryDialogUserPanel().getCustomCondition();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return new RptParams();
    }

    @Override
    protected CommRptBaseConditionUI getQueryDialogUserPanel() throws Exception {
        // TODO Auto-generated method stub
        return new TestFiltration();
    }

    @Override
    protected ICommRptBase getRemoteInstance() throws BOSException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    protected KDTable getTableForPrintSetting() {
        // TODO Auto-generated method stub
        return this.kDTable1 ;
    }

    @Override
    protected void query() {
        // TODO Auto-generated method stub
        this.kDTable1.removeRows();
        this.kDTable1.setEditable(false);
        IRowSet iRowSet;
           // Tnumber Tname TCreditCode Taddress TBUSLICDATE TSupStatus TrealName Tphone TcataLoginId TcataLoginName TparentId  TparentName 
        String sql="select os.CFFnumber Tnumber,os.CFFname  Tname,os.CFCreditCode TCreditCode,  os.CFFaddress Taddress, os.CFFBUSLICDATE  TBUSLICDATE,(case os.CFFSupStatus when '1' then '临时' when '2' then '合格' when '3' then '冻结'else '0' end) TSupStatus,"+
        "ocr.CFRealName TrealName,ocr.CFPhone Tphone,"+
        "mbig.CFFnumber TcataLoginId,mbig.CFFname TcataLoginName,"+
        "msub.CFFnumber TparentId,msub.CFFname TparentName"+
        " from CT_CUS_SupplierArchive as os "+
        " inner join CT_CUS_SupplierArchiveEntries as ocr on os.FID=ocr.FParentID"+
        " inner join CT_CUS_SupplierArchiveEntries2 as om  on os.FID=om.FParentID"+
        " inner join  CT_CUS_MaterialLittle  as msub on om.CFParentIdID=msub.FID"+
        " inner join CT_CUS_MaterialBig as mbig on om.CFCataLoginIdID=mbig.FID where 1=1";
        SupplierArchiveInfo testNum=(SupplierArchiveInfo) params.getObject("tnumber");
        MaterialLittleInfo TestLillterNum=(MaterialLittleInfo) params.getObject("tparentId");
        if(this.params.getObject("tFBUSLICDATE")!=null){
            SimpleDateFormat data=new SimpleDateFormat("yyyy-MM-dd");
            String  TestDate=data.format(this.params.getObject("tFBUSLICDATE"));
            if(!"".equals(TestDate)){
                sql+=" and os.CFFBUSLICDATE='"+TestDate+"'";
            }
        }

        if(testNum!=null){
            sql+=" and os.CFFnumber='"+testNum+"'";
        }

        if(TestLillterNum!=null){
            sql+=" and msub.CFFnumber='"+TestLillterNum+"'";
        }
        System.out.println("================"+sql);

    try {
        kDTable1.checkParsed();
        //执行sql语句
         iRowSet = SQLExecutorFactory.getRemoteInstance(sql).executeSQL();
        while (iRowSet.next()) {
            IRow irow=this.kDTable1.addRow();
            for(int i=0;i<rowcont.length;i++){
                if(iRowSet.getObject(rowcont[i])!=null || "".equals(iRowSet.getObject(rowcont[i]))){
                    //把值添加到界面
                    irow.getCell(i).setValue(iRowSet.getObject(rowcont[i]));
                }
            }
        }
    } catch (BOSException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    }

    @Override
    public void sort(int arg0) {
        // TODO Auto-generated method stub

    }

    @Override
    public void sort(int arg0, int arg1) {
        // TODO Auto-generated method stub

    }

}

效果如下：
这里写图片描述

这里写图片描述

这里写图片描述

这里写图片描述

初夏-Sally
关注
金蝶EAS/BOS开发小知识二
weixin_41037336的博客
02-27 940
1：如何通过IObjectPK pk获取实体对象 IObjectPK是一个表示实体对象id的对象，在日常开发工作中，经常需要通过它来获取实体对象。以下是通过IObjectPK获取实体对象代码的模版： I*Info i*Info = *Factory.getLocalInstance(ctx); *Info info = i*Info.get*Info(pk); //以下示例，通过IObjectPK获取成本对象实体：CostObjectInfo ICostObject iCostInfo = Cos
金蝶BOS 报表插件
qq_38571601的博客
04-25 1050
金蝶BOS 报表插件 提示：以下是本篇文章正文内容，下面案例可供参考 一、报表插件 using System; using System.Collections.Generic; using System.Linq; using System.Text; using Kingdee.BOS.Contracts.Report; using Kingdee.BOS.Core.Report; using Kingdee.BOS.Orm.DataEntity; using Kingdee.BOS; using Ki
金蝶 EAS BOS F7过滤
Xuy的博客
04-09 608
1.重写onLoad()方法在里面控制F7 2.一般会把单个F7代码封装在方法里面再让onLoad()调用 3.找到F7的控件在Abstract里面 4.调用.setEntityViewInfo(evi) //包别导错了 import com.kingdee.bos.metadata.query.util.CompareType; //在Abstract protected com.kingdee.bos.ctrl.extendcontrols.KDBizPromptBox prmtorg
即时报表中使用专项过滤条件
bireport的专栏
12-13 465
润乾即时报表提供专项过滤条件的功能。所谓专项过滤条件功能就是使用语义层文件中预先设置好的条件参数过滤查询数据。下面简单介绍一下即时报表中专项过滤条件的使用。注意：只有在语义层文件中设置了条件参数，才可以在基于该语义层文件的即时报表中使用专项过滤条件。下面以产品视图为例，简单介绍如何在即时报表中使用产品视图的专项过滤条件。操作流程如下：首先，在语义层文件中为 产品 视图 添加 条
金蝶EAS bos 报表开发 ---门户扩展报表联查单据跳转出错，找不到URL
老洪的博客
09-08 730
门户扩展报表联查单据跳转出错 扩展报表联查的单据对应的视图需要符合以下条件，才能联查到单据的WAF2页面： 1、标准页面：需要在应用开发平台中修改对应业务单元下的对应视图，需要勾选“该实体该类型的默认调用界面”这个选项。 2、扩展页面：需要进入扩展开发平台中将对应业务单元下的对应扩展页面进设为默认。 3、新页面：不能直接将编辑页面设为默认，需要添加一个查看页面（同一个实体），然后将该查看页面设为默认（点【配置】打开配置页面右栏中勾选“当前类型中的默认页面”）。 ...
金蝶移动bos开发教程_金蝶bos
weixin_30249465的博客
12-31 1430
金蝶BOS产品特性企业应用扩展性EAS针对集成性，主要推出3个解决方案，包括：数据集成、业务集成、银企平台。数据集成：使用EIP解决系统间数据集成的问题。业务集成：使用门户解决系统业务间信息集成的问题。银企平台：银企平台提供了企业与银行的连接问题。企业应用集成性当前企业业务系统越来越趋于复杂和多元化，很少有大型企业只使用一种系统的，并且与上下游供应链、银行、电商、税务等公共系统的接口也日趋丰富。因...
金蝶k3bos二次开发接口表
11-26
4. **序时簿模板 (IClisttemplate)**: 序时簿是一种用于记录历史数据的结构，这个表定义了序时簿的模板，包括其显示字段和过滤条件。 5. **序时簿的显示字段表 (ICchatbilltitle)**: 存储序时簿中用于显示的字段...
金蝶BOS扩展报表详解与权限管理
金蝶kingdee的BOS扩展报表是一个高级应用功能，旨在增强金蝶BOS系统的数据分析和展示能力。该文档详细介绍了如何利用扩展报表进行定制化数据处理，主要涵盖以下几个关键知识点： 1. 技术架构：文档首先阐述了BOS...
【金蝶EAS BOS报表开发绝技】：创建动态交互式报表的方法
本文全面介绍了金蝶EAS BOS报表开发的各个环节，包括报表设计、开发、交互式实现、安全与权限管理以及部署和维护。首先概述了报表开发的基本理念和流程，强调了理解需求和报表结构设计的重要性。随后，深入探讨了...
金蝶扩展报表开发指南（基本开发流程）
码艺丫嘿的博客！
06-10 4653
一、扩展报表菜单 1-1.进入扩展报表工具，路径如下图： 1-2.打开之后，可以看到如下界面： 扩展报表的制作主要分为两部分： 一个是数据集，数据集是去查询数据库返回来的数据，比如基础资料或者单据的一些信息等等，支持自定义SQL语句； 一个是报表模板，报表模板则是引用数据集，把数据集中的数据展示出来给用户，支持格式及样式之类的设计。 二、数据源制作 2-1.选择“SQL数据集”节点，点击创...
K3Cloud实施、BOS开发、报表开发学习资料-全部
01-29
BOS产品应用汇总介绍.pdf E3009 K3 Cloud系统操作手册.docx K3 Cloud V5.0 BOS万能报表设计器用户手册.docx K3+Cloud+BOS+业务配置百问百答.doc K3+Cloud+BOS+技术开发培训_BOS平台设计器.ppt K3+Cloud+BOS+技术开发培训_插件开发.ppt K3+Cloud+BOS+技术开发培训_插件开发环境部署.ppt K3+Cloud+BOS+技术开发培训_系统集成.ppt K3+Cloud+V6.0_产品培训_BOS领域_万能报表平台.pptx K3+Cloud+V6.0_产品培训_BOS领域_业务流程.ppt K3+Cloud+V6.0_产品培训_BOS领域_套打设计平台.pptx K3+Cloud+V6.0_产品培训_BOS领域_集成开发平台.pptx K3Cloud+BOS+插件开发百问百答.docx K3_Cloud_BOS平台架构与核心特色.ppt K3Cloud+WebAPI接口说明文档.docx 初学者-k3cloud插件开发基础.docx
金蝶BOS常见问题集锦(一)
04-07
EAS Bos 开发中常见的问题描述，对于从事金蝶Bos开发人员、实施人员有一定帮助
K3 CLOUD直接SQL报表快速开发步骤
02-12
K3 CLOUD BOS平台中直接SQL报表快速开发步骤，内部讲义。
如何在K3 WISE BOS集成开发工具中自定义字段过滤条件
weixin_30367873的博客
08-22 633
1.结论 对于输入过滤条件后BOS报“列名不正确”的过滤条件，要在列名前增加x2标识 无效的过滤 FNumber in (002,003,004,005,011,020) 正确的过滤 x2.FNumber in (002,003,004,005,011,020) 2.完全可以不看的探索过程 有客户需要我们在WISE中增加新单据，其中有个基础资料字段需要根据客户的的需求...
扩展报表实现一个特殊过滤
我的备忘录
01-23 228
有个报表如下： 产品    是否保税 A         1 B         0 C         1   需要写过滤条件 是否保税过滤 在过滤界面添加过滤条件    isB  (-1 代表 全部 1 代表是 0 代表否) select * from table where  (-1=@isB or 是否保税=@isB) 这样就实现了全部的功能 ...
K3 BOS单据中父子字段的问题
最新发布
weixin_44819434的博客
04-11 422
因业务需求新增了一张BOS单据，其中涉及到装配工序有两级，需要在选好“一级工序”后，“二级工序”跳出来的是一级工序下的内容，经过咨询分析研究，解决办法如下。
金蝶bos给分录的某一列进行过滤
qq_36973387的博客
06-06 1212
import com.kingdee.bos.ctrl.extendcontrols.BizDataFormat;import com.kingdee.bos.ctrl.extendcontrols.KDBizPromptBox;import com.kingdee.bos.ctrl.kdf.table.KDTDefaultCellEditor; protected void kdtEntryF7...
金蝶K3开发-工业老单据序时薄增加过滤条件
Eypsn的专栏
07-02 3601
金蝶工业老单序时薄，用户可以设置多种过滤方案，根据不同的过滤方案，显示不同的数据，可以说能满足大多数业务需求。但这些过滤方案是用户自己设置的，当希望针对所有用户设置一些统一的过滤条件，如所有用户只能看到2019年1月1日之后的销售出库单，这让用户自己设置过滤方案就不合适了，这种情况，是可以通过修改数据库来实现。 以销售出库单序时薄所有用户只能看到2019年1月1日之后的销售出库单为例，在数据库上执行以下语句即可实现： UPDATE ICListTemplate SET FFilter =FFil..
eas BI 报表
张柏的专栏
10-14 1020
1. 框架元数据： Ø  主界面UI：com.kingdee.eas.framework.bireport.client.BireportBaseMainUI.ui Ø  条件界面UI：com.kingdee.eas.framework.bireport.client.BireportBaseFilterUI.ui Ø  Facade功能对象：com.kingdee.eas.frame
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值