自定义查询，datatime显示格式问题

just_j++

自定义查询，在后台查询的时间格式没有问题，但在界面显示就有问题，概念对应的是datetime。
1.后台：
public static Table queryPG_OrderTrackDetailByOrderNumber(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){
                StringBuffer sb=new StringBuffer(" SELECT \n ");
                sb.append(" PG_OrderTrack.CAROWNERNAME AS CarownerName, \n");
                sb.append(" PG_OrderTrack.CAROWNERPHONE AS CarownerPhone,\n");
                sb.append(" PG_OrderTrack.CREATENAME AS CreateName,\n");
                sb.append(" PG_OrderTrack.DRIVERNAME AS DriverName,\n");
                sb.append(" PG_OrderTrack.DRIVERPHONE AS DriverPhone,\n");
                sb.append(" PG_OrderTrack.ISOPEN AS IsOpen,\n");
                sb.append(" PG_OrderTrack.ORDERNUMBER AS OrderNumber,\n");
                sb.append(" PG_OrderTrack.fID,\n");
                sb.append(" PG_OrderTrack.PLATENUMBER AS PlateNumber,\n");
                sb.append(" PG_OrderTrack.PROVIDERNAME AS ProviderName,\n");
                sb.append(" case PG_OrderTrack.TRACKSTATE when '已发运' then PG_OrderTrack.JOBNUMBER when '已入库' then PG_OrderTrack.JOBNUMBER  else PG_OrderTrack.STOWAGENUMBER end as StowageNumber,\n");
                sb.append(" PG_OrderTrack.TRACKREMARK AS TrackRemark, \n");
                sb.append(" PG_OrderTrack.TRACKREMARKNAME AS TrackRemarkName,\n");
                sb.append(" PG_OrderTrack.TRACKSTATE AS TrackState,\n");
                sb.append(" PG_OrderTrack.TRACKTARGET AS TrackTarget,\n");
                sb.append(" PG_OrderTrack.TRUCKINGNUMBER AS TruckingNumber,\n");
                sb.append(" PG_OrderTrack.SDESCRIPTION AS sDescription,\n");
                sb.append(" PG_OrderTrack.VERSION AS version,\n");
                sb.append(" Base_Organization.Name as orgName,\n");
                sb.append(" PG_OrderTrack.createTime\n");
                sb.append(" FROM PG_ORDERTRACK PG_OrderTrack\n");
                sb.append(" LEFT JOIN Base_Organization Base_Organization ON PG_OrderTrack.CREATEORGID = Base_Organization.fid\n");
                sb.append(" WHERE ").append(filter);
                sb.append(" and PG_OrderTrack.VALID = 1 ");
                sb.append(" ORDER BY PG_OrderTrack.CREATETIME ASC\n");
                System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "+sb.toString());
                Map<String, String> sqlMap = new HashMap<String, String>();
                sqlMap.put(DatabaseProduct.DEFAULT.toString(), sb.toString());
                return SQL.select(sqlMap,null, "/PGFreight/dispatchs/data");
        }

2.界面显示：2015-09-06T09  正常应该是：2015-09-06 09:26:17.467

3.界面grid对应字段formatter没有datetime可选？如图

jishuang

在下面设置

just_j++

1.设置：如图set.png2.界面显示：如图show.png
3.数据库实际是：如图time.png
问题：不能显示时分秒毫秒？

jishuang

在java中操作table，遍历看看table中这列的值是什么？
http://bbs.wex5.com/forum.php?mo ... 6&pid=164970535

just_j++

后台代码：
Table table = StaticFunction.getPagintModeTableForMSSQL(sb.toString(), "/PGFreight/dispatchs/data", limit, offset);
                Iterator<Row> iter=table.iterator();
                while(iter.hasNext()){
                        Row row=iter.next();
                        System.out.println("接单时间："+row.getValue("ReceiptTime"));
               }
后台打印信息：
接单时间：2015-09-06 09:21:43.17
接单时间：2015-09-06 09:21:43.17
接单时间：2015-09-06 09:21:43.17


界面显示：
QQ截图20150908135849.png
字段属性设置：
QQ截图20150908140052.png

jishuang

ontology中设置的关系类型都是正确的吗？
通过data的getValue获取一下关系的值看看是什么

just_j++

1.概念对应的是DateTime。
2.在grid的OnCellRender中看到的是异常日期格式

jishuang

just_j++ 发表于 2015-9-9 18:49
1.概念对应的是DateTime。
2.在grid的OnCellRender中看到的是异常日期格式

grid的onCellRender中的colVal这个格式正确的

本地测试grid中没有设置format显示正确的啊

just_j++

在界面设置格式无效果！！！！！！！
最终的解决方法   是在sql中使用时间函数，将其转成时间。结贴吧