|
写了一个自定义action查询sql,对话框数据来源这个查询,打开对话框,有数据,显示不出,代码和图在下面
action源码:
<action name="getZZCLHXCB_action" global="false"
procedure="getZZCLHXCB_actionProcedure">
<label language="zh_CN">周转材料核销表</label>
<permission name="range" type="List" />
<private name="concept" type="String" value="BA_ZZCLHXCB" />
<private name="select" type="String"
value="(NULL) AS BA_ZZCLHXCB,(NULL) AS VERSION,(NULL) AS FDJBH,(NULL) AS FWZBM,(NULL) AS FWZMC,(NULL) AS FGGXH,(NULL) AS FJLDW,(NULL) AS FCLTZ,(NULL) AS FSL,(NULL) AS FDJ ,(NULL) AS FTXCS,(NULL) AS FTXBL " />
<private name="from" type="String" value="BA_ZZCLHXCB BA_ZZCLHXCB" />
<private name="aggregate" type="String" />
<private name="dataModel" type="String" value="/baseCommon/data" />
<private name="fnModel" type="String" />
<protected name="condition" type="String" />
<public name="distinct" type="Boolean" value="false" />
<public name="idColumn" type="String" value="BA_ZZCLHXCB" />
<public name="filter" type="String" />
<public name="limit" type="Integer" />
<public name="offset" type="Integer" />
<public name="columns" type="String" />
<public name="orderBy" type="String" />
<public name="aggregateColumns" type="String" />
<public name="variables" type="Map" />
</action>
sql代码:
public static Table getZZCLHXCB_action(List range,String concept,String select,String from,String aggregate,String dataModel,String fnModel,String condition,Boolean distinct,String idColumn,String filter,Integer limit,Integer offset,String columns,String orderBy,String aggregateColumns,Map variables){
String sql = "SELECT b.fid BA_ZZCLTXCB,0,a.fDJBH,b.fWZBM,b.fWZMC,b.fGGXH,b.fJLDW,b.fCLTZ,b.fSL,b.fBHSDJ fDJ,b.fTXCS,x.fTXBL "+
"FROM BA_WZRKZB a "+
"LEFT JOIN BA_WZRKCB b "+
"ON a.fID = b.fZBID "+
"LEFT JOIN BA_WZXXB x "+
"ON b.fWZBM = X.fWZBM "+
"WHERE a.fBLX = 'WZZG' "+
"AND a.fDJZT = '已完成' "+
"AND a.fSFTX = '是' "+
"AND X.fTXBL > b.fTXCS "+
"Union "+
"SELECT d.fid BA_ZZCLTXCB,0,c.fDJBH,d.fWZBM,d.fWZMC,d.fGGXH,d.fJLDW,d.fCLTZ,d.fSL ,d.fDJ,d.fTXCS,x.fTXBL "+
"FROM BA_WZCKZB c "+
"LEFT JOIN BA_WZCKCB d "+
"ON c.fID = d.fZBID "+
"LEFT JOIN BA_WZXXB x "+
"ON d.fWZBM = X.fWZBM "+
"WHERE c.fDJZT = '已完成' "+
"AND c.fSFTX = '是' "+
"AND X.fTXBL > d.fTXCS";
System.out.println(sql);
Table table = SQL.select(sql, null,"/materialManagement/goods/data");
return table;
}
然后创建对话框页面,随便选择一个数据表,然后修改dialogData的reader为我自定义的/materialManagement/goods/logic/action/getZZCLHXCB_action
然后去到页面有数据但是显示不出来,没用过这种方法,那位大神帮帮我,谢谢啦
|
-
|