|
楼主 |
发表于 2014-10-9 14:21:07
|
显示全部楼层
恳求帮助,实在没招了!!!!!!1
按照帖子的说明
1.生成一个acction
2.保存acction
3.点击生成代码
在代码中生成如下
import java.math.*;
import java.sql.*;
import java.util.*;
import org.dom4j.*;
import com.justep.system.data.*;
public class Caiwufenxi {
public static void queryBalanceSheet1Actionziji(String ksql,Map variables,String dataModel,String fnModel){
}
public static void queryBalanceSheet1Action1(String concept,String select,String from,String aggregate,String dataModel,String fnModel,String condition,List range,Boolean distinct,String idColumn,String filter,Integer limit,Integer offset,String columns,String orderBy,String aggregateColumns,Map variables){
}
}
这段代码和下面帖子里面 简单例子代码怎么结合到一起啊
http://bbs.justep.com/forum.php?mod=viewthread&tid=54836这个帖子中的代码
public static Table queryER_WPXX1(String concept,String select,String from,String aggregate,String dataModel,
String fnModel,String condition,List range,Boolean distinct,String idColumn,String filter,Integer limit,
Integer offset,String columns,String orderBy,String aggregateColumns,Map<String, Object> variables){
//将UI传过来的过滤条件放入ksql
String where = "";
if(filter != null && !"".equals(filter)){
where = " where " + filter;
}
String sql = " from ER_WPXX ER_WPXX " + where + " group by ER_WPXX.fWPMC";
//计算出总记录数
int cnt = 0;
Table tCount = KSQL.select("select count(a.fWPMC) as cnt from (select ER_WPXX.fWPMC " + sql + ") a", variables, dataModel, null);
Iterator<Row> it1 = tCount.iterator();
if(it1.hasNext()){
Row r = it1.next();
cnt = r.getInt("cnt");
}
//加上offset和limit实现分页
Table table = KSQL.select("select ER_WPXX.fWPMC,sum(ER_WPXX.fGG) as fGG " + sql + " limit "+Integer.toString(offset)+","+Integer.toString(limit), variables, dataModel, null);
//不需要设置主键
//table.getProperties().put(Table.PROP_NAME_ROWID, "ER_WPXX");
//设置总记录数
table.getProperties().put(Table.PROP_DB_COUNT, cnt);
return table;
}
|
|