金蝶--创建一个简单的报表

public class RptTest extends AbstractRptTest
{
    private static final Logger logger = CoreUIObject.getLogger(RptTest.class);
    
    /**
     * output class constructor
     */
    public RptTest() throws Exception
    {
        super();
    }

    

    
    @Override
    public void onLoad() throws Exception {
    	super.onLoad();
    	setUITitle("货单报表");
    }
    
    
    @Override
    public void loadData() throws SQLException, BOSException {
    	//第一次加载不查询数据
    	if(!isFirstLoad){
    		super.loadData();
    	}
    }

    /**
     * output btnReflushTemplate_actionPerformed method
     */
    protected void btnReflushTemplate_actionPerformed(java.awt.event.ActionEvent e) throws Exception
    {
        //write your code here
      //点击
    	super.actionReflush_actionPerformed(e);
    }

    
    

    @Override
    public String getRptSQL() {
    	//取数据的sql语句    
    	
    	
   /* 	
    * 
    *  select T_BD_Person.*,CT_PM_PurchaseInWoreHouse.*
 from  CT_PM_PurchaseInWoreHouse left join T_BD_Person
 on CT_PM_PurchaseInWoreHouse.dfdealperson=T_BD_Person.fid 
 where 1 = 1 
 AND DFCompanyID IN ('9qkAAAAJsk3M567U')  and fname_l1 like '%大%' 
*/
    	 
    	System.out.println("我被执行了");
    	StringBuffer Strbuff = new StringBuffer();   
        String Person = DFDealPerson.getText();
  		Strbuff.append(" select T_BD_Person.fname_l2 dfdealperson,CFSupplierID,DFServiceID,T_BD_Supplier.fname_l2 name  from  CT_PM_PurchaseInWoreHouse  left join T_BD_Supplier on  CT_PM_PurchaseInWoreHouse.CFSupplierID=T_BD_Supplier.fid  left join T_BD_Person on CT_PM_PurchaseInWoreHouse.dfdealperson=T_BD_Person.fid ");
  		Strbuff.append( " where 1 = 1 \n" ) ;
  		
      	if (UIRuleUtil.isNotNull(Person)){
      	   	String where = " AND " + "T_BD_Person.fname_l2  like  '%" +Person+"%' \n";
        	Strbuff.append(where);  
        	}
      	System.out.println(kDBizPromptBox2.getValue());
       
     	if (UIRuleUtil.isNotNull(kDBizPromptBox2.getValue())){
      	   	String where = " AND " + "T_BD_Person.fname_l2  like  '%" +kDBizPromptBox2.getValue()+"%' \n";
        	Strbuff.append(where);  
        	}
       
     	
        Strbuff.append( getWhereOfCompany("DFCompanyID"));//公司
        Strbuff.append( getWhereOfBillNo("FNumber"));//单据编号 


        

        
        System.out.println(Strbuff.toString());
    	return Strbuff.toString();    
    	
    }
    
    
	@Override
    public ArrayList initTotalset() {
    	//报表显示列
    	 super.initTotalset();   
    	 
    		ArrayList alist = new ArrayList();
        	alist.add(setEmptPacke("供应商","name", true, "", false,200,null, null));
        	alist.add(setEmptPacke("服务","DFServiceID", true, "", false,200,null, null));
        	alist.add(setEmptPacke("提供人","dfdealperson", true, "", false,200,null, null));
             
    	return alist;
    }
    
    
    @Override
    public void setIsdialect(boolean bol) {
    	//设置查询后台数据sql是否支持方言,一般都需要支持Ksql
    	super.setIsdialect(true);
    }

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

上面是创建的报表比较重要的几个方法。

2个处理人是自定义的f7，下面的2个是继承基类时生成的f7保留的2个。