数据加载日期时间有误

qweasdzxc

1. select sc_dealeruser.dealercode as dealercode,
   
2.          sc_dealeruser.dealername as dealername,
   
3.           NO_Readed.fUpdateDate as readtime,
   
4.           (case when NO_Readed.fReaderID is not null then '1' else '0' end) as statecode,       
   
5.           (case when NO_Readed.fReaderID is not null then '已阅' else '未阅' end) as statename           
   
6. from sc_dealeruser sc_dealeruser left join (select a.* from NO_Readed a where a.fNoticeID = 'ID') NO_Readed on  NO_Readed.fReaderID = sc_dealeruser.dealercode

复制代码

上面是我的KSQL，在数据库管理工具中查出来是正确的日期时间，加载到cdata前debugger看只是日期型，怎么处理？

jishuang

看data的关系设置的什么类型

看table中的数据是类型是什么类型的

qweasdzxc

jishuang 发表于 2018-11-5 17:27
看data的关系设置的什么类型

看table中的数据是类型是什么类型的

都设置的日期时间型，但是通过ksql查出来后就是日期型了

jishuang

返回到table中的数据就是日期类型了？

qweasdzxc

jishuang 发表于 2018-11-6 11:12
返回到table中的数据就是日期类型了？

是的

jishuang

把概念的定义和这个action的java定义代码发一下

qweasdzxc

jishuang 发表于 2018-11-6 14:34
把概念的定义和这个action的java定义代码发一下

1. <div component="$UI/system/components/justep/data/data" autoLoad="false"
   
2.       xid="mainData" idColumn="FID" confirmDelete="false" confirmRefresh="false" onCustomRefresh="mainDataCustomRefresh">
   
3.       <column name="FID" type="String" xid="xid1"/>  
   
4.       <column name="FTYPEID" type="String" xid="xid2"/>  
   
5.       <column name="FTYPENAME" type="String" xid="xid3"/>  
   
6.       <column name="FTYPECODE" type="String" xid="xid4"/>  
   
7.       <column name="FCREATEDATE" type="Date" xid="xid5"/>  
   
8.       <column name="FTITLE" type="String" xid="xid6"/>  
   
9.       <column name="FDETAILS" type="String" xid="xid7"/>  
   
10.       <column name="FFUNCODE" type="String" xid="xid8"/>  
    
11.       <column name="FSTATUSCODE" type="String" xid="xid9"/>  
    
12.       <column name="FSTSTUSNAME" type="String" xid="xid10"/>  
    
13.       <column name="FCREATEPSNNAME" type="String" xid="xid11"/>  
    
14.       <column name="FCREATEPSNID" type="String" xid="xid12"/>  
    
15.       <column name="FCREATEPSNFID" type="String" xid="xid13"/>  
    
16.       <column name="FCREATEPSNCODE" type="String" xid="xid14"/>  
    
17.       <column name="FREADTIME" type="Date" xid="xid15"/>  
    
18.       <column name="FSTATECODE" type="String" xid="xid16"/>  
    
19.       <column name="FSTATENAME" type="String" xid="xid17"/>
    
20.     </div>  
    
21. 
    
22. 
    
23. 
    
24. public static Table queryMyNoticeRead(String typecode, String usercode, String fun, String filter, Integer limit, Integer offset) {
    
25.                 if (fun != null)
    
26.                         filter += " and FFUNCODE = '" + fun + "'";
    
27.                 String sql = "select * from ( select a.*,rownum rn from ( select NO_NoticePublish.fID as fID,( CASE WHEN NO_NoticePublish.fViewPsnID LIKE '%" + usercode
    
28.                                 + "%' and NO_NoticePublish.fStateCode = '2' THEN NO_NoticePublish.fTypeIDView ELSE NO_NoticePublish.fTypeID END ) AS fTypeID, " + "( CASE WHEN NO_NoticePublish.fViewPsnID LIKE '%"
    
29.                                 + usercode + "%' and NO_NoticePublish.fStateCode = '2' THEN NO_NoticePublish.fTypeNameView ELSE NO_NoticePublish.fTypeName END ) AS fTypeName, "
    
30.                                 + "( CASE WHEN NO_NoticePublish.fViewPsnID LIKE '%" + usercode
    
31.                                 + "%' and NO_NoticePublish.fStateCode = '2' THEN NO_NoticePublish.fTypeCodeView ELSE NO_NoticePublish.fTypeCode END ) AS fTypeCode, "
    
32.                                 + "NO_NoticePublish.fCreateDate as fCreateDate, ( CASE WHEN NO_NoticePublish.fViewPsnID LIKE '%"
    
33.                                 + usercode + "%' and NO_NoticePublish.fStateCode = '2' THEN NO_NoticePublish.fTitleView ELSE NO_NoticePublish.fTitle END ) AS fTitle, "
    
34.                                 + "( CASE WHEN NO_NoticePublish.fViewPsnID LIKE '%" + usercode
    
35.                                 + "%' and NO_NoticePublish.fStateCode = '2' THEN NO_NoticePublish.fDetailsView ELSE NO_NoticePublish.fDetails END ) AS fDetails, " + "( CASE WHEN NO_NoticePublish.fViewPsnID LIKE '%"
    
36.                                 + usercode + "%' and NO_NoticePublish.fStateCode = '2' THEN NO_NoticePublish.fFunCodeView ELSE NO_NoticePublish.fFunCode END ) AS fFunCode, "
    
37.                                 + "NO_NoticePublish.fStateCode AS fStatusCode, NO_NoticePublish.fStateName AS fStatusName, NO_NoticePublish.fCreatePsnName AS fCreatePsnName, "
    
38.                                 + "NO_NoticePublish.fCreatePsnID AS fCreatePsnID, NO_NoticePublish.fCreatePsnFID AS fCreatePsnFID, NO_NoticePublish.fCreatePsnCode AS fCreatePsnCode, "
    
39.                                 + "(case when NO_Readed.fUpdateDate is not null then NO_Readed.fUpdateDate else null end) as fReadTime, "
    
40.                                 + "(case when NO_Readed.fReaderID is not null then '1' else '0' end) as fStateCode,"
    
41.                                 + "(case when NO_Readed.fReaderID is not null then '已阅' else '未阅' end) as fStateName from NO_NoticePublish NO_NoticePublish left join (select a.* from "
    
42.                                 + "NO_Readed a where a.fReaderID = '" + usercode + "') NO_Readed on NO_Readed.fNoticeID = NO_NoticePublish.fID where 1=1 and ( ( NO_NoticePublish.fStateCode = '1' "
    
43.                                 + "and NO_NoticePublish.fRangeCode like '%" + typecode + "%' )  or ( NO_NoticePublish.fViewPsnID like '%" + usercode
    
44.                                 + "%' and NO_NoticePublish.fStateCode = '2' ) or ( ( NO_NoticePublish.fTypeID is not null or NO_NoticePublish.fTitle is not null ) and "
    
45.                                 + "NO_NoticePublish.fStateCode = '2' ) ) order by fStateCode asc, fStatusCode desc, NO_Readed.fUpdateDate desc,NO_NoticePublish.fCreateDate desc ) a where 1=1 " + filter
    
46.                                 + "  and rownum <= " + Integer.toString(offset + limit) + " ) where rn > " + Integer.toString(offset);
    
47.                 Table table = SQL.select(sql, null, "/dealer/notice/data", null);
    
48.                 // 设置主键
    
49.                 table.getProperties().put(Table.PROP_NAME_ROWID, "FID");
    
50.                 // 设置总记录数 , 计算分页
    
51.                 int num = queryMyNoticeReadCount(typecode, usercode, filter);
    
52.                 table.getProperties().put(Table.PROP_DB_COUNT, num);
    
53.                 return table;
    
54.         }

复制代码

NO_NoticePublish.fCreateDate 和 NO_Readed.fUpdateDate 在概念定义中都是datetime

jishuang

参考http://bbs.wex5.com/forum.php?mo ... 6&pid=165049439把table的内容输出发一下

data中设置的就没有DateTime类型的

qweasdzxc

jishuang 发表于 2018-11-12 10:21
参考http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=40966&pid=165049439把table的内容输 ...

如下查询的还是不行
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
sqlMap.put(DatabaseProduct.KINGBASE.name(), sql);
sqlMap.put(DatabaseProduct.DB2.name(), sql);
Table table = SQL.select(sqlMap, null, "/dealer/notice/data", null);

jishuang

把table的内容输出发一下啊