改寫newdata()方法導致grid數據加載問題

aomei

改寫newdata()方法導致grid數據加載一閃而過，請問一下，現在3.2版本是不是不讓改寫newdata ,改寫是不是會導致數據加載不上。

jishuang

改为newData()是什么意思？
自己重写的newData()?

aomei

jishuang 发表于 2015-9-1 15:01
改为newData()是什么意思？
自己重写的newData()?

對啊，就是改寫的newdata（）方法也是改寫自帶的create方法

jishuang

具体的代码发一下啊

aomei

jishuang 发表于 2015-9-1 17:48
具体的代码发一下啊

public static Table createMCS_REQUEST_DETAIL(String concept,String fnModel,Table table,Map defaultValues,Map myParams)
        {
                Table Ztable = null;
               
                if(Utils.isNotNull(myParams))
                {
                        int count = 0;
                        String sql = "";
                        //生產工單下的物料需求(bizdata3)
                    if("3".equals(Common.getPara(myParams,"TYPE_NO")))
                    {
                            sql = "SELECT OUTSTORE_SEQ.NEXTVAL AS ROW_ID,OUTSTORE_SEQ.NEXTVAL AS REQUESTDETAILID,'%s' AS REQUESTID,A.AUFNR AS PRODUCTION_NO,A.MATNR AS MATERIAL_NO," +
                            " C.MAKTX AS MATERIAL_NAME,DECODE(A.BDMNG,0,'0',TRIM(TO_CHAR(A.BDMNG,'FM99999999990.000'))) AS ORDER_NUM,A.MEINS AS MATERIAL_UNIT,'0' AS REQUEST_NUM," +
                            " SL.LABST AS FXZ_QTY,SL.INSME AS ZJ_QTY,'1' AS FINISH_STATUS,'0' AS \"version\",'%s' AS COMPANY_CODE " +
                                " FROM SAPSR3.RESB@TO_SAPPRD A, SAPSR3.AFKO@TO_SAPPRD B,SAPSR3.MAKT@TO_SAPPRD C,SAPSR3.MARA@TO_SAPPRD D " +
                                " LEFT JOIN (SELECT T.MATNR,NVL(SUM(T.LABST),0) AS LABST,NVL(SUM(T.INSME),0) AS INSME FROM SAPSR3.MARD@TO_SAPPRD T WHERE T.MANDT='@MANDT' GROUP BY T.MATNR) SL ON SL.MATNR = D.MATNR " +
                            " WHERE B.RSNUM = A.RSNUM AND C.MATNR = A.MATNR AND D.MATNR = C.MATNR AND C.SPRAS = 'E' AND B.MANDT = '@MANDT' AND C.MANDT = '@MANDT'" +
                            " AND D.MANDT = '@MANDT' AND A.MANDT = '@MANDT' AND INSTR(';'||'%s'||';',';'||A.AUFNR||';')>0 AND D.MTART IN( 'PACK', 'ROH')";
                    }
                    else //查詢生產工單詳情
                    {
                            sql = "SELECT OUTSTORE_SEQ.NEXTVAL AS ROW_ID,OUTSTORE_SEQ.NEXTVAL AS REQUESTDETAILID,'%s' AS REQUESTID,AUFNR AS PRODUCTION_NO," +
                            " CHARG AS BATCH,MATNR AS PRODUCT_NO,MAKTX AS PRODUCT_NAME,PGMNG AS PRODUCT_COUNT,MEINS AS PRODUCT_UNIT,GSTRS AS PLAN_DATE, " +
                                " '1' AS FINISH_STATUS,'0' AS \"version\",'%s' AS COMPANY_CODE " +
                                " FROM (SELECT A.AUFNR,D.CHARG, B.MATNR,C.MAKTX, " +
                                " DECODE(D.PGMNG,0,'0',TRIM(TO_CHAR(D.PGMNG,'FM99999999990.000'))) AS PGMNG,D.MEINS," +
                                " TO_CHAR(TO_DATE(A.GSTRS,'YYYY-MM-DD'),'DD-MM-YYYY') AS GSTRS  FROM SAPSR3.CAUFV@TO_SAPPRD A,SAPSR3.MARA@TO_SAPPRD B," +
                                " SAPSR3.MAKT@TO_SAPPRD C,SAPSR3.AFPO@TO_SAPPRD D WHERE D.AUFNR = A.AUFNR AND B.MATNR = A.PLNBEZ AND C.MATNR = B.MATNR" +
                                " AND  C.SPRAS = 'E' AND A.MANDT = '@MANDT' AND B.MANDT = '@MANDT' AND C.MANDT = '@MANDT' AND D.MANDT = '@MANDT'" +
                                " AND INSTR(';'||'%s'||';',';'||A.AUFNR||';')>0 ORDER BY A.AUFNR)";
                    }
                   
                    sql = sql.replaceAll("@MANDT", Common.getPara(myParams,"PUB_CSAPBU"));
                    sql = String.format(sql, Common.getPara(myParams,"REQUESTID"),
                                                                     Common.getPara(myParams,"COMPANY_CODE"),
                                                                     Common.getPara(myParams,"PUB_ORDER_ID"));
                    Ztable = Common.queryTable(sql);
                }
                return Ztable;
        }

jishuang

可以参考http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035把sql打出来看看，不执行newData，直接加载数据执行queryAction，数据显示是否正确

aomei

jishuang 发表于 2015-9-2 09:20
可以参考http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035把sql打 ...

sql沒有問題，我打印的SQL可以在數據庫中運行出數據。

jishuang

不执行newData，直接加载数据执行queryAction，数据显示是否正确

或者把data换一个用标准的action的测试看看

aomei

jishuang 发表于 2015-9-2 13:51
不执行newData，直接加载数据执行queryAction，数据显示是否正确

或者把data换一个用标准的action的测试看 ...

換成標準的ACTION是可以得到數據的，但是之前的設計都是按改寫做的，不好改，不好把數據再追加到BIZDATA

jishuang

aomei 发表于 2015-9-2 13:53
換成標準的ACTION是可以得到數據的，但是之前的設計都是按改寫做的，不好改，不好把數據再追加到BIZDATA ...

那就看queryAction的重写是否正确
把data的autoLoad直接设置为true都不显示，说明queryAction就不对

http://wex5.com/X5Knowledge/know ... 3C53B82C3FE5DE.html

http://wex5.com/X5Knowledge/know ... B65542BC2DDB9B.html