润乾报表自定义数据集

 

 

 

public class CfywDataSet implements IDataSetFactory {

    public static Log log = LogFactory.getLog(CfywDataSet.class);

    private String dataSetName = "ds_cfxx";//数据集名称
    private JdbcTemplate jt = (JdbcTemplate) Framework.getEngine().getContainer().getComponent("jdbcTemplate");
    private SoarBaseService soarBaseService=(SoarBaseService) Framework.getEngine().getContainer().getComponent("soarBaseService");

    private final static String sfls = "0";//是否历史

    public DataSet createDataSet(Context context, DataSetConfig dataSetConfig, boolean b) {
        Map map = context.getAllParamMap();
        //传参
        String fwidstr = (String) map.get("fwid");
        String qzidStr = (String) map.get("qlidstr");//qzid:fwid:ywslid,
        String fwid = "";
        Map<Long,Long> qzidMap=new HashMap<Long,Long>();
        if(StringUtils.isNotEmpty(qzidStr)){
         for(String param:qzidStr.split(",")){
          if(StringUtils.isNotEmpty(param)){
           qzidMap.put(Long.valueOf(param.split(":")[0]),Long.valueOf(param.split(":")[1]));
          }
         }
        }
        //设置数据集名称
        DataSet reportDataSet = new DataSet(dataSetName);
        //获得报表数据map的集合
        reportDataSet.addCol("cfjg");//查封机构
        reportDataSet.addCol("cfdjr");//查封登记人
        reportDataSet.addCol("cfwh");//查封文号
        reportDataSet.addCol("cfqx");//查封期限
        reportDataSet.addCol("cfsj");//查封时间
        reportDataSet.addCol("fwid");//房屋CODE
        reportDataSet.addCol("fwzl");//房屋坐落
        reportDataSet.addCol("zxwh");//执行文号
        reportDataSet.addCol("isNull");//是否为空，实现ds.count()变化
        reportDataSet.addCol("cfzt");//查封状态
       

...........................................................................