报表

wenxin8580

jishuang 发表于 2020-9-7 09:24
把table返回的内容输出发一下看看

http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=40966 ...

<RowImpl state=NONE
[<column name=SEND_DATE, state=0, oldValue=null, newValue=2020-09-07>, <column name=ORG_NAME, state=0, oldValue=null, newValue=轻卡>, <column name=QA, state=0, oldValue=null, newValue=HG>, <column name=MTL_LOT_NUMBER, state=0, oldValue=null, newValue=010005-3699652>, <column name=VENDOR_LOT_NUMBER, state=0, oldValue=null, newValue=20170508>, <column name=UOM_CODE, state=0, oldValue=null, newValue=P>, <column name=TRANSACTION_CODE, state=0, oldValue=null, newValue=1000291609>, <column name=PRODUCTE_DATE, state=0, oldValue=null, newValue=20170509>, <column name=PRINT_DATE, state=0, oldValue=null, newValue=2020-09-07 10:08:59.0>, <column name=VENDOR_NAME, state=0, oldValue=null, newValue=金宇粉末冶金有限公司>, <column name=ITEM_CODE, state=0, oldValue=null, newValue=16566>, <column name=ITEM_DESCRIPTION, state=0, oldValue=null, newValue=二轴导套>, <column name=ERWEIMA, state=0, oldValue=null, newValue=item=16566,ver=A,num=200,unit=P,date=20170509,vender=010005,batch=20170508,lot=010005-3699652,cd=>, <column name=ZJWL, state=0, oldValue=null, newValue=物流装备有限公司>, <column name=MTL_VER_CODE, state=0, oldValue=null, newValue=A>, <column name=PO_NUMBER, state=0, oldValue=null, newValue=null>, <column name=VENDOR_CODE, state=0, oldValue=null, newValue=010005>, <column name=QUANTITY, state=0, oldValue=null, newValue=200>, <column name=FROM_SUBINV_CODE, state=0, oldValue=null, newValue=02-SXJS01>]
>
<RowImpl state=NONE
[<column name=SEND_DATE, state=0, oldValue=null, newValue=2020-09-07>, <column name=ORG_NAME, state=0, oldValue=null, newValue=轻卡>, <column name=QA, state=0, oldValue=null, newValue=HG>, <column name=MTL_LOT_NUMBER, state=0, oldValue=null, newValue=020013-3699242>, <column name=VENDOR_LOT_NUMBER, state=0, oldValue=null, newValue=20170508>, <column name=UOM_CODE, state=0, oldValue=null, newValue=P>, <column name=TRANSACTION_CODE, state=0, oldValue=null, newValue=1000291609>, <column name=PRODUCTE_DATE, state=0, oldValue=null, newValue=20170509>, <column name=PRINT_DATE, state=0, oldValue=null, newValue=2020-09-07 10:08:59.0>, <column name=VENDOR_NAME, state=0, oldValue=null, newValue=机械制造有限公司>, <column name=ITEM_CODE, state=0, oldValue=null, newValue=19466>, <column name=ITEM_DESCRIPTION, state=0, oldValue=null, newValue=副箱减速齿轮垫片>, <column name=ERWEIMA, state=0, oldValue=null, newValue=item=19466,ver=A,num=92,unit=P,date=20170509,vender=020013,batch=20170508,lot=020013-3699242,cd=>, <column name=ZJWL, state=0, oldValue=null, newValue=物流装备有限公司>, <column name=MTL_VER_CODE, state=0, oldValue=null, newValue=A>, <column name=PO_NUMBER, state=0, oldValue=null, newValue=null>, <column name=VENDOR_CODE, state=0, oldValue=null, newValue=020013>, <column name=QUANTITY, state=0, oldValue=null, newValue=92>, <column name=FROM_SUBINV_CODE, state=0, oldValue=null, newValue=02-SXJS01>]
>
<RowImpl state=NONE
[<column name=SEND_DATE, state=0, oldValue=null, newValue=2020-09-07>, <column name=ORG_NAME, state=0, oldValue=null, newValue=特轻卡>, <column name=QA, state=0, oldValue=null, newValue=HG>, <column name=MTL_LOT_NUMBER, state=0, oldValue=null, newValue=20170510037897>, <column name=VENDOR_LOT_NUMBER, state=0, oldValue=null, newValue=20170510>, <column name=UOM_CODE, state=0, oldValue=null, newValue=P>, <column name=TRANSACTION_CODE, state=0, oldValue=null, newValue=1000291609>, <column name=PRODUCTE_DATE, state=0, oldValue=null, newValue=20170510>, <column name=PRINT_DATE, state=0, oldValue=null, newValue=2020-09-07 10:08:59.0>, <column name=VENDOR_NAME, state=0, oldValue=null, newValue=机械制造有限公司>, <column name=ITEM_CODE, state=0, oldValue=null, newValue=GB889.2-2000-M20X1.5>, <column name=ITEM_DESCRIPTION, state=0, oldValue=null, newValue=1型非金属嵌件六角锁紧螺母>, <column name=ERWEIMA, state=0, oldValue=null, newValue=item=GB889.2-2000-M20X1.5,ver=A,num=200,unit=P,date=20170510,vender=020013,batch=20170510,lot=20170510037897,cd=>, <column name=ZJWL, state=0, oldValue=null, newValue=物流装备有限公司>, <column name=MTL_VER_CODE, state=0, oldValue=null, newValue=A>, <column name=PO_NUMBER, state=0, oldValue=null, newValue=null>, <column name=VENDOR_CODE, state=0, oldValue=null, newValue=020013>, <column name=QUANTITY, state=0, oldValue=null, newValue=200>, <column name=FROM_SUBINV_CODE, state=0, oldValue=null, newValue=02-SXJS01>]
>

jishuang

发的不是java中输出的table内容吧

wenxin8580

是呀
HashMap<String,String> sqlMap = new HashMap<String,String>();
                sqlMap.put(DatabaseProduct.ORACLE.name(),sql);
                Table table = SQL.select(sqlMap,null,"/wms/report/data/");
                for (Iterator<Row> it = table.iterator(); it.hasNext();) {
                        Row row = it.next();
                        System.out.println(row.toString());
                }

jishuang

看我发的链接中的直接打印table的内容，然后把.w和excel也发一下

wenxin8580

jishuang 发表于 2020-9-7 16:22
看我发的链接中的直接打印table的内容，然后把.w和excel也发一下

<rows><userdata name="model">/wms/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,DateTime,String,String,String,String,Decimal,String,String,String,String,String,String,String,String,String,String,String,String</userdata><userdata name="relation-alias">TRANSACTION_CODE,PRINT_DATE,SEND_DATE,FROM_SUBINV_CODE,ITEM_CODE,ITEM_DESCRIPTION,QUANTITY,MTL_VER_CODE,MTL_LOT_NUMBER,VENDOR_LOT_NUMBER,PRODUCTE_DATE,QA,UOM_CODE,VENDOR_CODE,VENDOR_NAME,ZJWL,ORG_NAME,PO_NUMBER,ERWEIMA</userdata><row><userdata name="recordState"/><cell>1000291609</cell><cell>2020-09-07T16:23:44.000Z</cell><cell>2020-09-07</cell><cell>02-SXJS01</cell><cell>16566</cell><cell>二轴导套</cell><cell>200</cell><cell>A</cell><cell>010005-3699652</cell><cell>20170508</cell><cell>20170509</cell><cell>HG</cell><cell>P</cell><cell>010005</cell><cell>金宇粉末冶金有限公司</cell><cell>中集物流装备有限公司</cell><cell>轻卡</cell><cell></cell><cell>item=16566,ver=A,num=200,unit=P,date=20170509,vender=010005,batch=20170508,lot=010005-3699652,cd=</cell></row><row><userdata name="recordState"/><cell>1000291609</cell><cell>2020-09-07T16:23:44.000Z</cell><cell>2020-09-07</cell><cell>02-SXJS01</cell><cell>19466</cell><cell>副箱减速齿轮垫片</cell><cell>92</cell><cell>A</cell><cell>020013-3699242</cell><cell>20170508</cell><cell>20170509</cell><cell>HG</cell><cell>P</cell><cell>020013</cell><cell>益新机械制造有限公司</cell><cell>中集物流装备有限公司</cell><cell>轻卡</cell><cell></cell><cell>item=19466,ver=A,num=92,unit=P,date=20170509,vender=020013,batch=20170508,lot=020013-3699242,cd=</cell></row><row><userdata name="recordState"/><cell>1000291609</cell><cell>2020-09-07T16:23:44.000Z</cell><cell>2020-09-07</cell><cell>02-SXJS01</cell><cell>GB889.2-2000-M20X1.5</cell><cell>1型非金属嵌件六角锁紧螺母</cell><cell>200</cell><cell>A</cell><cell>20170510037897</cell><cell>20170510</cell><cell>20170510</cell><cell>HG</cell><cell>P</cell><cell>020013</cell><cell>益新机械制造有限公司</cell><cell>中集物流装备有限公司</cell><cell>轻卡</cell><cell></cell><cell>item=GB889.2-2000-M20X1.5,ver=A,num=200,unit=P,date=20170510,vender=020013,batch=20170510,lot=20170510037897,cd=</cell></row></rows>

jishuang

加select的放到最前面

wenxin8580

jishuang 发表于 2020-9-7 18:16
加select的放到最前面

还是不行

jishuang

运行具体是什么效果，截图看一下

wenxin8580

jishuang 发表于 2020-9-8 10:18
运行具体是什么效果，截图看一下

加载失败，后台报错就是首页发的错误

jishuang

用的是标准的queryAction还是自己定义的action？