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

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › 设置group by之后grid不显示内容
返回列表 发新帖
查看: 1284|回复: 5

[结贴] 设置group by之后grid不显示内容

[复制链接]

35

主题

113

帖子

773

积分

高级会员

Rank: 4

积分
773
QQ
发表于 2025-5-21 10:16:24 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
我参考了这个帖子（http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=54836&pid=165038142），设置了一个queryAction。

当我在ui设置grid的时候，不显示相应内容，全是undefined。

java代码：
  1. /**
  2.          * 分组查询用品信息表
  3.          * @return
  4.          **/
  5.         public static Table queryGroupTab_L_InventoryInfo(String concept,String select,String from,String aggregate,
  6.                         String dataModel,String fnModel,String condition,List range,Boolean distinct,String idColumn,String filter,
  7.                         Integer limit,Integer offset,String columns,String orderBy,String aggregateColumns,Map<String, Object> variables){
  8.                 // 基础SQL语句
  9.                 StringBuilder sqlBuilder = new StringBuilder()
  10.                         .append("select ")
  11.                         .append("MAX(tab_L_InventoryInfo.FID) as tab_L_InventoryInfo, ")
  12.                         .append("MAX(tab_L_InventoryInfo.version) as version, ")
  13.                          .append("MAX(tab_L_InventoryInfo.Year) as Year, ")
  14.                         .append("MAX(tab_L_InventoryInfo.fInitQty) as fInitQty, ")
  15.                          .append("MAX(tab_L_InventoryInfo.fInitPrice) as fInitPrice, ")
  16.                         .append("MAX(tab_L_InventoryInfo.fInitAmount) as fInitAmount, ")
  17.                         .append("SUM(tab_L_InventoryInfo.fInvQty) as fInvQty, ")
  18.                         .append("AVG(tab_L_InventoryInfo.fInvPrice) as fInvPrice, ")
  19.                         .append("SUM(tab_L_InventoryInfo.fInvAmount) as fInvAmount, ")
  20.                         .append("tab_L_InventoryInfo.fItemName as fItemName, ")
  21.                         .append("tab_L_InventoryInfo.fSpecs as fSpecs, ")
  22.                          .append("MAX(tab_L_InventoryInfo.fUnit) as fUnit, ")
  23.                         .append("MAX(tab_L_InventoryInfo.ptParentID) as ptParentID, ")
  24.                         .append("MAX(tab_L_InventoryInfo.fInboundDate) as fInboundDate, ")
  25.                         .append("SUM(tab_L_InventoryInfo.fInboundQty) as fInboundQty, ")
  26.                         .append("tab_L_InventoryInfo.fInboundPrice as fInboundPrice, ")
  27.                         .append("SUM(tab_L_InventoryInfo.fInboundAmount) as fInboundAmount, ")
  28.                         .append("MAX(tab_L_InventoryInfo.pParentID1) as pParentID1, ")
  29.                         .append("MAX(tab_L_InventoryInfo.pParentID2) as pParentID2, ")
  30.                         .append("MAX(tab_L_InventoryInfo.pParentID3) as pParentID3, ")
  31.                         .append("MAX(tab_L_InventoryInfo.fProjectID) as fProjectID, ")
  32.                         .append("MAX(tab_L_InventoryInfo.fProjectName) as fProjectName, ")
  33.                         .append("MAX(tab_L_InventoryInfo.fProjectNo) as fProjectNo, ")
  34.                         .append("MAX(tab_L_InventoryInfo.fOutboundDate) as fOutboundDate, ")
  35.                         .append("SUM(tab_L_InventoryInfo.fOutboundQty) as fOutboundQty, ")
  36.                         .append("MAX(tab_L_InventoryInfo.fOutboundPrice) as fOutboundPrice, ")
  37.                         .append("SUM(tab_L_InventoryInfo.fOutboundAmount) as fOutboundAmount, ")
  38.                     .append("tab_L_InventoryInfo.fUsePerson as fUsePerson, ")
  39.                         .append("MAX(tab_L_InventoryInfo.fUsePersonID) as fUsePersonID, ")
  40.                         .append("MAX(tab_L_InventoryInfo.fUseDept) as fUseDept, ")
  41.                         .append("MAX(tab_L_InventoryInfo.fUseDeptID) as fUseDeptID, ")
  42.                         .append("MAX(tab_L_InventoryInfo.fUseDate) as fUseDate, ")
  43.                         .append("MAX(tab_L_InventoryInfo.fItemStatus) as fItemStatus, ")
  44.                         .append("MAX(tab_L_InventoryInfo.fItemSource) as fItemSource, ")
  45.                         .append("MAX(tab_L_InventoryInfo.sRemarks) as sRemarks, ")
  46.                          .append("MAX(tab_L_InventoryInfo.sCreatePerson) as sCreatePerson, ")
  47.                         .append("MAX(tab_L_InventoryInfo.sCreatePersonID) as sCreatePersonID, ")
  48.                         .append("MAX(tab_L_InventoryInfo.sCreateDept) as sCreateDept, ")
  49.                         .append("MAX(tab_L_InventoryInfo.sCreateDeptID) as sCreateDeptID, ")
  50.                         .append("MAX(tab_L_InventoryInfo.sCreateTime) as sCreateTime, ")
  51.                         .append("MAX(tab_L_InventoryInfo.sUpdatePerson) as sUpdatePerson, ")
  52.                         .append("MAX(tab_L_InventoryInfo.sUpdatePersonID) as sUpdatePersonID, ")
  53.                         .append("MAX(tab_L_InventoryInfo.sUpdateDept) as sUpdateDept, ")
  54.                         .append("MAX(tab_L_InventoryInfo.sUpdateDeptID) as sUpdateDeptID, ")
  55.                          .append("MAX(tab_L_InventoryInfo.sUpdateTime) as sUpdateTime, ")
  56.                         .append("MAX(tab_L_InventoryInfo.sValidState) as sValidState ")
  57.                         .append("from tab_L_InventoryInfo tab_L_InventoryInfo ");
  58.             
  59.             // 动态添加过滤条件
  60.             if (filter != null && !"".equals(filter)) {
  61.                     sqlBuilder.append(" where ")
  62.                             .append(filter);
  63.             }
  64.             
  65.             // 添加group by分组语句
  66.             sqlBuilder.append(" group by ")
  67.                   .append("tab_L_InventoryInfo.fItemName, ")
  68.                   .append("tab_L_InventoryInfo.fSpecs, ")
  69.                   .append("tab_L_InventoryInfo.fInboundPrice, ")
  70.                   .append("tab_L_InventoryInfo.fUsePerson ");
  71.             
  72.             
  73.             // Oracle分页处理
  74.             String offSQL = "select * from ("
  75.                 + "select rownum rn,A.* from (" + sqlBuilder.toString() + ") A " // 内层查询
  76.                 + "where rownum <= " + (offset + limit) + ") " // 限制最大行数
  77.                 + "where rn >= " + (offset + 1) + ""; // 限制最小行数
  78.             
  79.             // 构建数据库方言映射（目前仅支持Oracle）
  80.             Map<String, String> map = new HashMap<>();
  81.             map.put("ORACLE", offSQL);
  82.             
  83.             // 执行分页查询
  84.             Table t = SQL.select(map, null, "/DrcProjManagement/logisticsManagement/data");
  85.             
  86.             // 设置行标识字段（用于更新操作）：不设置不用这个更新
  87.             // t.getProperties().put(Table.PROP_NAME_ROWID, "FID");
  88.             
  89.             // 计算总记录数
  90.             String countNum = "select count(*) as FNUM from (" + sqlBuilder.toString() + ")";
  91.             Map<String, String> map1 = new HashMap<>();
  92.             map1.put("ORACLE", countNum);
  93.             // 执行计数查询
  94.             Table countTable = SQL.select(map1, null, "/DrcProjManagement/logisticsManagement/data");
  95.             BigDecimal num = countTable.iterator().next().getDecimal("FNUM");
  96.             // 设置总记录数属性（用于前端分页显示）
  97.             t.getProperties().put(Table.PROP_DB_COUNT, num);
  98.             
  99.             return t;
  100.         }
复制代码
UI代码：
  1. <div component="$UI/system/components/justep/grid/grid" xid="mainGrid"
  2.       data="mainData" width="100%" hiddenCaptionbar="true" height="auto" class="x-grid-title-center" altRows="true" showRowNumber="true">
  3.       <columns xid="column">
  4.         <column name="fItemName"                 label="品名"                 align="left"         width="118px"></column>
  5.         <column name="fSpecs"                         label="规格"                 align="center"         width="98px"></column>
  6.         <column name="fUnit"                         label="单位"                 align="center"         width="58px"></column>
  7.         
  8.         <column name="fInitQty"                 label="期初数量"         align="center"         width="58px"></column>
  9.         <column name="fInitPrice"                 label="期初单价"         align="center"         width="98px"></column>
  10.         <column name="fInitAmount"                 label="期初金额"         align="center"         width="98px"></column>
  11.         
  12.         <column name="fInboundDate"         label="入库日期"         align="center"         width="108px" formatter="date"><formatoptions xid="default1" newformat="Y-m-d"></formatoptions></column>
  13.         <column name="fInboundQty"                 label="入库数量"         align="center"         width="58px"></column>
  14.         <column name="fInboundPrice"         label="入库单价"         align="center"         width="98px"></column>
  15.         <column name="fInboundAmount"         label="入库金额"         align="center"         width="98px"></column>
  16.         
  17.         <column name="fUsePerson"                 label="领用人"                 align="center"         width="68px"></column>
  18.         <column name="fUseDept"                 label="领用部门"         align="left"         width="108px"></column>
  19.         <column name="fUseDate"                 label="领用日期"         align="center"         width="108px" formatter="date"><formatoptions xid="default1" newformat="Y-m-d"></formatoptions></column>
  20.         <column name="fProjectNo"                 label="项目编号"         align="center"         width="68px"></column>
  21.         <column name="fOutbountQty"         label="出库数量"         align="center"         width="58px"></column>
  22.         <column name="fOutbountPrice"         label="出库单价"         align="center"         width="98px"></column>
  23.         <column name="fOutbountAmount"         label="出库金额"         align="center"         width="98px"></column>
  24.         
  25.         <column name="fInvQty"                         label="库存数量"         align="center"         width="58px"></column>
  26.         <column name="fInvPrice"                 label="库存单价"         align="center"         width="98px"></column>
  27.         <column name="fInvAmount"                 label="库存金额"         align="center"         width="98px"></column>
  28.       </columns>
  29.     </div>
复制代码
相关截图如下：
1747793542176.jpg

1747793690673.jpg
源码如下：
w、js、java源码.zip (4.62 KB, 下载次数: 0)
回复

使用道具 举报

35

主题

113

帖子

773

积分

高级会员

Rank: 4

积分
773
QQ
 楼主| 发表于 2025-5-21 10:52:03 | 显示全部楼层
补充，页面打开时控制台信息：
  1. 2025-05-21 10:50:57 [SQL Time]sql 执行时间：4ms, exec sql:{ORACLE=select * from (select rownum rn,A.* from (select MAX(tab_L_InventoryInfo.FID) as tab_L_InventoryInfo, MAX(tab_L_InventoryInfo.version) as version, MAX(tab_L_InventoryInfo.Year) as Year, MAX(tab_L_InventoryInfo.fInitQty) as fInitQty, MAX(tab_L_InventoryInfo.fInitPrice) as fInitPrice, MAX(tab_L_InventoryInfo.fInitAmount) as fInitAmount, SUM(tab_L_InventoryInfo.fInvQty) as fInvQty, AVG(tab_L_InventoryInfo.fInvPrice) as fInvPrice, SUM(tab_L_InventoryInfo.fInvAmount) as fInvAmount, tab_L_InventoryInfo.fItemName as fItemName, tab_L_InventoryInfo.fSpecs as fSpecs, MAX(tab_L_InventoryInfo.fUnit) as fUnit, MAX(tab_L_InventoryInfo.ptParentID) as ptParentID, MAX(tab_L_InventoryInfo.fInboundDate) as fInboundDate, SUM(tab_L_InventoryInfo.fInboundQty) as fInboundQty, tab_L_InventoryInfo.fInboundPrice as fInboundPrice, SUM(tab_L_InventoryInfo.fInboundAmount) as fInboundAmount, MAX(tab_L_InventoryInfo.pParentID1) as pParentID1, MAX(tab_L_InventoryInfo.pParentID2) as pParentID2, MAX(tab_L_InventoryInfo.pParentID3) as pParentID3, MAX(tab_L_InventoryInfo.fProjectID) as fProjectID, MAX(tab_L_InventoryInfo.fProjectName) as fProjectName, MAX(tab_L_InventoryInfo.fProjectNo) as fProjectNo, MAX(tab_L_InventoryInfo.fOutboundDate) as fOutboundDate, SUM(tab_L_InventoryInfo.fOutboundQty) as fOutboundQty, MAX(tab_L_InventoryInfo.fOutboundPrice) as fOutboundPrice, SUM(tab_L_InventoryInfo.fOutboundAmount) as fOutboundAmount, tab_L_InventoryInfo.fUsePerson as fUsePerson, MAX(tab_L_InventoryInfo.fUsePersonID) as fUsePersonID, MAX(tab_L_InventoryInfo.fUseDept) as fUseDept, MAX(tab_L_InventoryInfo.fUseDeptID) as fUseDeptID, MAX(tab_L_InventoryInfo.fUseDate) as fUseDate, MAX(tab_L_InventoryInfo.fItemStatus) as fItemStatus, MAX(tab_L_InventoryInfo.fItemSource) as fItemSource, MAX(tab_L_InventoryInfo.sRemarks) as sRemarks, MAX(tab_L_InventoryInfo.sCreatePerson) as sCreatePerson, MAX(tab_L_InventoryInfo.sCreatePersonID) as sCreatePersonID, MAX(tab_L_InventoryInfo.sCreateDept) as sCreateDept, MAX(tab_L_InventoryInfo.sCreateDeptID) as sCreateDeptID, MAX(tab_L_InventoryInfo.sCreateTime) as sCreateTime, MAX(tab_L_InventoryInfo.sUpdatePerson) as sUpdatePerson, MAX(tab_L_InventoryInfo.sUpdatePersonID) as sUpdatePersonID, MAX(tab_L_InventoryInfo.sUpdateDept) as sUpdateDept, MAX(tab_L_InventoryInfo.sUpdateDeptID) as sUpdateDeptID, MAX(tab_L_InventoryInfo.sUpdateTime) as sUpdateTime, MAX(tab_L_InventoryInfo.sValidState) as sValidState from tab_L_InventoryInfo tab_L_InventoryInfo  where (tab_L_InventoryInfo.fItemSource in ('主数据', '库存入库') and tab_L_InventoryInfo.sValidState = 1) group by tab_L_InventoryInfo.fItemName, tab_L_InventoryInfo.fSpecs, tab_L_InventoryInfo.fInboundPrice, tab_L_InventoryInfo.fUsePerson ) A where rownum <= 20) where rn >= 1}
  2. --> binds:[]
  3. 2025-05-21 10:50:57 [SQL Time]sql 执行时间：3ms, exec sql:{ORACLE=select count(*) as FNUM from (select MAX(tab_L_InventoryInfo.FID) as tab_L_InventoryInfo, MAX(tab_L_InventoryInfo.version) as version, MAX(tab_L_InventoryInfo.Year) as Year, MAX(tab_L_InventoryInfo.fInitQty) as fInitQty, MAX(tab_L_InventoryInfo.fInitPrice) as fInitPrice, MAX(tab_L_InventoryInfo.fInitAmount) as fInitAmount, SUM(tab_L_InventoryInfo.fInvQty) as fInvQty, AVG(tab_L_InventoryInfo.fInvPrice) as fInvPrice, SUM(tab_L_InventoryInfo.fInvAmount) as fInvAmount, tab_L_InventoryInfo.fItemName as fItemName, tab_L_InventoryInfo.fSpecs as fSpecs, MAX(tab_L_InventoryInfo.fUnit) as fUnit, MAX(tab_L_InventoryInfo.ptParentID) as ptParentID, MAX(tab_L_InventoryInfo.fInboundDate) as fInboundDate, SUM(tab_L_InventoryInfo.fInboundQty) as fInboundQty, tab_L_InventoryInfo.fInboundPrice as fInboundPrice, SUM(tab_L_InventoryInfo.fInboundAmount) as fInboundAmount, MAX(tab_L_InventoryInfo.pParentID1) as pParentID1, MAX(tab_L_InventoryInfo.pParentID2) as pParentID2, MAX(tab_L_InventoryInfo.pParentID3) as pParentID3, MAX(tab_L_InventoryInfo.fProjectID) as fProjectID, MAX(tab_L_InventoryInfo.fProjectName) as fProjectName, MAX(tab_L_InventoryInfo.fProjectNo) as fProjectNo, MAX(tab_L_InventoryInfo.fOutboundDate) as fOutboundDate, SUM(tab_L_InventoryInfo.fOutboundQty) as fOutboundQty, MAX(tab_L_InventoryInfo.fOutboundPrice) as fOutboundPrice, SUM(tab_L_InventoryInfo.fOutboundAmount) as fOutboundAmount, tab_L_InventoryInfo.fUsePerson as fUsePerson, MAX(tab_L_InventoryInfo.fUsePersonID) as fUsePersonID, MAX(tab_L_InventoryInfo.fUseDept) as fUseDept, MAX(tab_L_InventoryInfo.fUseDeptID) as fUseDeptID, MAX(tab_L_InventoryInfo.fUseDate) as fUseDate, MAX(tab_L_InventoryInfo.fItemStatus) as fItemStatus, MAX(tab_L_InventoryInfo.fItemSource) as fItemSource, MAX(tab_L_InventoryInfo.sRemarks) as sRemarks, MAX(tab_L_InventoryInfo.sCreatePerson) as sCreatePerson, MAX(tab_L_InventoryInfo.sCreatePersonID) as sCreatePersonID, MAX(tab_L_InventoryInfo.sCreateDept) as sCreateDept, MAX(tab_L_InventoryInfo.sCreateDeptID) as sCreateDeptID, MAX(tab_L_InventoryInfo.sCreateTime) as sCreateTime, MAX(tab_L_InventoryInfo.sUpdatePerson) as sUpdatePerson, MAX(tab_L_InventoryInfo.sUpdatePersonID) as sUpdatePersonID, MAX(tab_L_InventoryInfo.sUpdateDept) as sUpdateDept, MAX(tab_L_InventoryInfo.sUpdateDeptID) as sUpdateDeptID, MAX(tab_L_InventoryInfo.sUpdateTime) as sUpdateTime, MAX(tab_L_InventoryInfo.sValidState) as sValidState from tab_L_InventoryInfo tab_L_InventoryInfo  where (tab_L_InventoryInfo.fItemSource in ('主数据', '库存入库') and tab_L_InventoryInfo.sValidState = 1) group by tab_L_InventoryInfo.fItemName, tab_L_InventoryInfo.fSpecs, tab_L_InventoryInfo.fInboundPrice, tab_L_InventoryInfo.fUsePerson )}
  4. --> binds:[]
复制代码
直接拿这些sql去数据库软件中查询是能查询到相应结果的。
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36178
发表于 2025-5-21 11:12:07 | 显示全部楼层
确认字段大小写是不是都一致，先确认后端获取后返回的数据是不是正确
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

35

主题

113

帖子

773

积分

高级会员

Rank: 4

积分
773
QQ
 楼主| 发表于 2025-5-21 11:17:10 | 显示全部楼层
jishuang 发表于 2025-5-21 11:12
确认字段大小写是不是都一致，先确认后端获取后返回的数据是不是正确

大小写都一致，并且尝试过全大写也不行。
后端返回的数据是正确的，直接到数据库软件中执行sql拿到的数据就是五行而且有内容，并且和预期的一样。
回复 支持 反对

使用道具 举报

35

主题

113

帖子

773

积分

高级会员

Rank: 4

积分
773
QQ
 楼主| 发表于 2025-5-21 11:34:16 | 显示全部楼层
本帖最后由 叫我银垚就好了 于 2025-5-21 11:35 编辑

补充ontology源码：
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <model xmlns="http://www.justep.com/model">
  3. <concept name="tab_L_InventoryInfo" default-value-expr="guid()"><has-relation relation="version" default-value-expr="0"><label language="zh_CN">版本</label>
  4. </has-relation>
  5. <label language="zh_CN">用品信息表</label>
  6. <!-- 主数据 -->
  7. <has-relation relation="Year" data-type="Integer" default-value-expr="yearOf(currentDateTime())"></has-relation>
  8. <has-relation relation="fInitQty" data-type="Integer"></has-relation>
  9. <has-relation relation="fInitPrice" data-type="Decimal" size="12" scale="2"></has-relation>
  10. <has-relation relation="fInitAmount" data-type="Decimal" size="12" scale="2"></has-relation>
  11. <has-relation relation="fInvQty" data-type="Integer"></has-relation>
  12. <has-relation relation="fInvPrice" data-type="Decimal" size="12" scale="2"></has-relation>
  13. <has-relation relation="fInvAmount" data-type="Decimal" size="12" scale="2"></has-relation>
  14. <!-- 基本数据 -->
  15. <has-relation relation="fItemName" data-type="String"></has-relation>
  16. <has-relation relation="fSpecs" data-type="String"></has-relation>
  17. <has-relation relation="fUnit" data-type="String"></has-relation>
  18. <!-- 子数据 -->
  19. <has-relation relation="ptParentID" data-type="String"></has-relation>
  20. <has-relation relation="fInboundDate" data-type="DateTime"></has-relation>
  21. <has-relation relation="fInboundQty" data-type="Integer"></has-relation>
  22. <has-relation relation="fInboundPrice" data-type="Decimal" size="12" scale="2"></has-relation>
  23. <has-relation relation="fInboundAmount" data-type="Decimal" size="12" scale="2"></has-relation>
  24. <has-relation relation="pParentID1" data-type="String"></has-relation>
  25. <has-relation relation="pParentID2" data-type="String"></has-relation>
  26. <has-relation relation="pParentID3" data-type="String"></has-relation>
  27. <has-relation relation="fProjectID" data-type="String"></has-relation>
  28. <has-relation relation="fProjectName" data-type="String"></has-relation>
  29. <has-relation relation="fProjectNo" data-type="String"></has-relation>
  30. <has-relation relation="fOutboundDate" data-type="DateTime"></has-relation>
  31. <has-relation relation="fOutboundQty" data-type="Integer"></has-relation>
  32. <has-relation relation="fOutboundPrice" data-type="Decimal" size="12" scale="2"></has-relation>
  33. <has-relation relation="fOutboundAmount" data-type="Decimal" size="12" scale="2"></has-relation>
  34. <has-relation relation="fUsePerson" data-type="String"></has-relation>
  35. <has-relation relation="fUsePersonID" data-type="String"></has-relation>
  36. <has-relation relation="fUseDept" data-type="String"></has-relation>
  37. <has-relation relation="fUseDeptID" data-type="String"></has-relation>
  38. <has-relation relation="fUseDate" data-type="DateTime"></has-relation>
  39. <has-relation relation="fItemStatus" data-type="String" default-value-expr="'在库\已领用'"></has-relation>
  40. <has-relation relation="fItemSource" data-type="String" default-value-expr="'库存入库\后勤采购\自购\采购入库\自购入库'"></has-relation>
  41. <!-- 备注 -->
  42. <has-relation relation="sRemarks" data-type="String" size="4000"></has-relation>
  43. <!-- 基本数据 -->
  44. <has-relation relation="sCreatePerson" data-type="String" default-value-expr="currentPersonName()"></has-relation>
  45. <has-relation relation="sCreatePersonID" data-type="String" default-value-expr="currentPersonID()"></has-relation>
  46. <has-relation relation="sCreateDept" data-type="String" default-value-expr="currentDeptName()"></has-relation>
  47. <has-relation relation="sCreateDeptID" data-type="String" default-value-expr="currentDeptID()"></has-relation>
  48. <has-relation relation="sCreateTime" data-type="DateTime" default-value-expr="currentDateTime()"></has-relation>
  49. <has-relation relation="sUpdatePerson" data-type="String"></has-relation>
  50. <has-relation relation="sUpdatePersonID" data-type="String"></has-relation>
  51. <has-relation relation="sUpdateDept" data-type="String"></has-relation>
  52. <has-relation relation="sUpdateDeptID" data-type="String"></has-relation>
  53. <has-relation relation="sUpdateTime" data-type="DateTime"></has-relation>
  54. <has-relation relation="sValidState" data-type="Integer" size="1"></has-relation>
  55. </concept>
  56. <relation name="Year" data-type="Integer"><label language="zh_CN">年度</label></relation>
  57. <relation name="fInitQty" data-type="Integer"><label language="zh_CN">期初数量</label></relation>
  58. <relation name="fInitPrice" data-type="Decimal"><label language="zh_CN">期初单价</label></relation>
  59. <relation name="fInitAmount" data-type="Decimal"><label language="zh_CN">期初金额</label></relation>
  60. <relation name="fInvQty" data-type="Integer"><label language="zh_CN">库存数量</label></relation>
  61. <relation name="fInvPrice" data-type="Decimal"><label language="zh_CN">库存单价</label></relation>
  62. <relation name="fInvAmount" data-type="Decimal"><label language="zh_CN">库存金额</label></relation>
  63. <relation name="fItemName" data-type="String"><label language="zh_CN">品名</label></relation>
  64. <relation name="fSpecs" data-type="String"><label language="zh_CN">规格</label></relation>
  65. <relation name="fUnit" data-type="String"><label language="zh_CN">单位</label></relation>
  66. <relation name="ptParentID" data-type="String"><label language="zh_CN">父ID（本表）</label></relation>
  67. <relation name="fInboundDate" data-type="DateTime"><label language="zh_CN">入库日期</label></relation>
  68. <relation name="fInboundQty" data-type="Integer"><label language="zh_CN">入库数量</label></relation>
  69. <relation name="fInboundPrice" data-type="Decimal"><label language="zh_CN">入库单价</label></relation>
  70. <relation name="fInboundAmount" data-type="Decimal"><label language="zh_CN">入库金额</label></relation>
  71. <relation name="pParentID1" data-type="String"><label language="zh_CN">流程ID（入库）</label></relation>
  72. <relation name="pParentID2" data-type="String"><label language="zh_CN">流程ID（出库）</label></relation>
  73. <relation name="pParentID3" data-type="String"><label language="zh_CN">流程ID（采购）</label></relation>
  74. <relation name="fProjectID" data-type="String"><label language="zh_CN">项目ID</label></relation>
  75. <relation name="fProjectName" data-type="String"><label language="zh_CN">项目名称</label></relation>
  76. <relation name="fProjectNo" data-type="String"><label language="zh_CN">项目编号</label></relation>
  77. <relation name="fOutboundDate" data-type="DateTime"><label language="zh_CN">出库日期</label></relation>
  78. <relation name="fOutboundQty" data-type="Integer"><label language="zh_CN">出库数量</label></relation>
  79. <relation name="fOutboundPrice" data-type="Decimal"><label language="zh_CN">出库单价</label></relation>
  80. <relation name="fOutboundAmount" data-type="Decimal"><label language="zh_CN">出库金额</label></relation>
  81. <relation name="fUsePerson" data-type="String"><label language="zh_CN">领用人</label></relation>
  82. <relation name="fUsePersonID" data-type="String"><label language="zh_CN">领用人ID</label></relation>
  83. <relation name="fUseDept" data-type="String"><label language="zh_CN">领用人部门</label></relation>
  84. <relation name="fUseDeptID" data-type="String"><label language="zh_CN">领用人部门ID</label></relation>
  85. <relation name="fUseDate" data-type="DateTime"><label language="zh_CN">领用日期</label></relation>
  86. <relation name="fItemStatus" data-type="String"><label language="zh_CN">物品状态</label></relation>
  87. <relation name="fItemSource" data-type="String"><label language="zh_CN">物品来源</label></relation>
  88. <relation name="sRemarks" data-type="String"><label language="zh_CN">备注</label></relation>
  89. <relation name="sCreatePerson" data-type="String"><label language="zh_CN">创建人</label></relation>
  90. <relation name="sCreatePersonID" data-type="String"><label language="zh_CN">创建人ID</label></relation>
  91. <relation name="sCreateDept" data-type="String"><label language="zh_CN">创建部门</label></relation>
  92. <relation name="sCreateDeptID" data-type="String"><label language="zh_CN">创建部门ID</label></relation>
  93. <relation name="sUpdatePerson" data-type="String"><label language="zh_CN">更新人</label></relation>
  94. <relation name="sUpdatePersonID" data-type="String"><label language="zh_CN">更新人ID</label></relation>
  95. <relation name="sUpdateDept" data-type="String"><label language="zh_CN">更新部门</label></relation>
  96. <relation name="sUpdateDeptID" data-type="String"><label language="zh_CN">更新部门ID</label></relation>
  97. <relation name="sUpdateTime" data-type="DateTime"><label language="zh_CN">更新时间</label></relation>
  98. </model>
复制代码


回复 支持 反对

使用道具 举报

35

主题

113

帖子

773

积分

高级会员

Rank: 4

积分
773
QQ
 楼主| 发表于 2025-5-21 17:29:27 | 显示全部楼层
已解决，请结贴。
原因是用sql 的 oracle查询返回的数据列名一定是大写。
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2025-6-26 22:28 , Processed in 0.060795 second(s), 29 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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