起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 4117|回复: 4

[结贴] queryAction

[复制链接]

197

主题

834

帖子

1511

积分

金牌会员

Rank: 6Rank: 6

积分
1511
QQ
发表于 2018-2-6 14:38:18 | 显示全部楼层 |阅读模式
<action name="queryV_R_BProjectStatisticsAction" procedure="bizQueryProcedure">
    <permission name="range" type="List"/>  
    <private name="concept" type="String" value="V_R_BProjectStatistics"/>  
    <private name="select" type="String" value="V_R_BProjectStatistics.*"/>  
    <private name="from" type="String" value="V_R_BProjectStatistics V_R_BProjectStatistics"/>  
    <private name="aggregate" type="String" value="sum(C13) as C13, sum(C14) as C14, sum(C15) as C15, sum(C17) as C17, sum(C19) as C19, SUM(CASE WHEN C6 = '否' THEN C20 WHEN C6 = '是' AND C20 < 0 THEN C20 ELSE 0 END) AS C20, sum(C23) as C23, sum(C24) as C24, sum(C25) as C25, sum(C26) as C26, sum(C27) as C27, sum(C28) as C28, sum(C29) as C29, sum(C31) as C31, sum(C32) as C32, sum(C33) as C33, sum(C34) as C34, sum(C35) as C35, sum(C36) as C36,sum(vTotalPaymentByCont) as vTotalPaymentByCont,sum(vTotalAmountByCont) as vTotalAmountByCont,sum(vAccumulatedReceivable) as vAccumulatedReceivable,sum(V_R_BProjectStatistics.fSafeConstructCost) AS vSafeConstructCost,sum(V_R_BProjectStatistics.fAccruedAmt) AS vAccruedAmt,SUM(CASE WHEN C6 = '否' THEN C20 WHEN C6 = '是' AND C20 < 0 THEN C20 ELSE 0 END)+sum(17) AS vExpectWholeIncome,sum(V_R_BProjectStatistics.fCashDeposit) AS vCashDeposit,sum(V_R_BProjectStatistics.fManagersNum) AS vManagersNum,sum(V_R_BProjectStatistics.fDepositPsnNum) AS vDepositPsnNum"/>  
    <private name="dataModel" type="String" value="/BCEG/ECON/data"/>  
    <private name="fnModel" type="String"/>  
    <protected name="condition" type="String"/>  
    <public name="distinct" type="Boolean" value="false"/>  
    <public name="idColumn" type="String" value="V_R_BProjectStatistics"/>  
    <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"/>  
    <label language="zh_CN">在施项目经济指标台账查询</label>
  </action>  
------回复内容仅供参考

197

主题

834

帖子

1511

积分

金牌会员

Rank: 6Rank: 6

积分
1511
QQ
 楼主| 发表于 2018-2-6 14:38:34 | 显示全部楼层
org.dom4j.DocumentException: Error on line 69 of document file:///E:/X5.2.7_dev/X5.2.7/model/BIZ/BCEG/ECON/logic/action/ECON_Proj_Report.action.m : The value of attribute "value" associated with an element type "private" must not contain the '<' character. Nested exception: The value of attribute "value" associated with an element type "private" must not contain the '<' character.
        at org.dom4j.io.SAXReader.read(SAXReader.java:482)
        at org.dom4j.io.SAXReader.read(SAXReader.java:264)
        at com.justep.design.model.ModelParser.readFileAsXML(Unknown Source)
        at com.justep.design.model.ModelParser.parseFile(Unknown Source)
        at com.justep.design.model.ModelParser.parseModel(Unknown Source)
        at com.justep.design.model.ModelParser.parseModel(Unknown Source)
        at com.justep.ui.system.component.data.bizdata.BizDataUtils.getActionModel(Unknown Source)
        at com.justep.ui.system.component.data.bizdata.BizDataDef.loadBizActionModel(Native Method)
        at com.justep.ui.system.component.data.bizdata.BizDataDef.<init>(Unknown Source)
        at BizData.execute(BizData.java:40)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
------回复内容仅供参考
回复 支持 反对

使用道具 举报

197

主题

834

帖子

1511

积分

金牌会员

Rank: 6Rank: 6

积分
1511
QQ
 楼主| 发表于 2018-2-6 14:38:51 | 显示全部楼层
不能写><符号吗?
------回复内容仅供参考
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36185
发表于 2018-2-6 15:11:59 | 显示全部楼层
通过设计器编辑,设计器会做转换,源码值直接写><解析源码会有问题
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

197

主题

834

帖子

1511

积分

金牌会员

Rank: 6Rank: 6

积分
1511
QQ
 楼主| 发表于 2018-2-6 15:27:38 | 显示全部楼层
本帖最后由 1104797209 于 2018-2-6 15:28 编辑

可以了大佬结帖
------回复内容仅供参考
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2025-7-5 06:13 , Processed in 0.064792 second(s), 24 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表