data模型问题

jishuang

看输出的sql语句，这个不是

dh_n

1.   --> sql:SELECT  DISTINCT  ERP_Customer.FCUSTOMERNAME AS CustomerName, ERP_WH_OutInWarehouseRecord.FDOCUMENTNUMBER AS DocumentNumber, ERP_DG_TotalBoxList.fID AS ERP_DG_TotalBoxList, ERP_WH_Warehouse.FFWAREHOUSENAME AS WareHouseName, SA_OPPerson_1.SNAME AS bName, SA_OPPerson.SNAME AS cName, ERP_DG_TotalBoxList.FATTACHMENT AS fAttachment, ERP_DG_TotalBoxList.FATTACHMENT1 AS fAttachment1, ERP_DG_TotalBoxList.FBIZSTATE AS fBizState, ERP_DG_TotalBoxList.FBIZSTATENAME AS fBizStateName, ERP_DG_TotalBoxList.FCARNUMBER AS fCarNumber, ERP_DG_TotalBoxList.FCHECKDATE AS fCheckDate, ERP_DG_TotalBoxList.FCHECKER AS fChecker, ERP_DG_TotalBoxList.FCOURIERNUMBER AS fCourierNumber, ERP_DG_TotalBoxList.FCREATEDATETIME AS fCreateDateTime, ERP_DG_TotalBoxList.FCREATEPERSONID AS fCreatePersonID, ERP_DG_TotalBoxList.FCREATEPERSONNAME AS fCreatePersonName, ERP_DG_TotalBoxList.FCURRENTACTIVITIES AS fCurrentActivities, ERP_DG_TotalBoxList.FCURRENTEXECUTORS AS fCurrentExecutors, ERP_DG_TotalBoxList.FCUSTOMERCODE AS fCustomerCode, ERP_DG_TotalBoxList.FCUSTOMERID AS fCustomerID, ERP_DG_TotalBoxList.FCUSTOMERNAME AS fCustomerName, ERP_DG_TotalBoxList.FDELIVERGOODSNUMBER AS fDeliverGoodsNumber, ERP_DG_TotalBoxList.FDELIVERYDATE AS fDeliveryDate, ERP_DG_TotalBoxList.FEXPLAIN AS fExplain, ERP_DG_TotalBoxList.FGROSSWEIGHTCTN AS fGROSSWEIGHTCTN, ERP_DG_TotalBoxList.FINBOUNDDATETIME AS fInBoundDateTime, ERP_DG_TotalBoxList.FINVOICENO AS fInvoiceNo, ERP_DG_TotalBoxList.FISUSED AS fIsUsed, ERP_DG_TotalBoxList.FLNSPECTIONLIST AS fLnspectionList, ERP_DG_TotalBoxList.FMAILBOX AS fMailBox, ERP_DG_TotalBoxList.FMANAGERTELEPHONENUMBER AS fManagerTelephoneNumber, ERP_DG_TotalBoxList.FMERGEORDERNO AS fMergeOrderNO, ERP_DG_TotalBoxList.FNETWEIGHTCTN AS fNETWEIGHTCTN, ERP_DG_TotalBoxList.FNUMBER AS fNumber, ERP_DG_TotalBoxList.FORGANNAME AS fOrganName, ERP_DG_TotalBoxList.FPACKINGLIST AS fPackingList, ERP_DG_TotalBoxList.FPHONE AS fPhone, ERP_DG_TotalBoxList.FREMARK AS fRemark, ERP_DG_TotalBoxList.FSAFEKEEPINGPERSONID AS fSafeKeepingPersonID, ERP_DG_TotalBoxList.FSHIPTO AS fShipTo, ERP_DG_TotalBoxList.FSHIPVIA AS fShipVia, ERP_DG_TotalBoxList.FSIGNATOREDATETIME AS fSignatoreDateTime, ERP_DG_TotalBoxList.FSIGNATORYID AS fSignatoryID, ERP_DG_TotalBoxList.FSOLDTO AS fSoldTo, ERP_DG_TotalBoxList.FSTATUS AS fStatus, ERP_DG_TotalBoxList.FSUMNUM AS fSumNum, ERP_DG_TotalBoxList.FTOTALPRICE AS fTotalPrice, ERP_DG_TotalBoxList.FWAREHOUSEID AS fWareHouseID, ERP_DG_TotalBoxList.FWAREHOUSEMANAGER AS fWareHouseManager, ERP_DG_TotalBoxList.FOUTBOUNDID AS foutBoundID, SA_OPPerson_2.SNAME AS jName, ERP_DG_TotalBoxList.VERSION AS version FROM ERP_DG_TOTALBOXLIST ERP_DG_TotalBoxList LEFT JOIN ERP_WH_OutInWarehouseRecord ERP_WH_OutInWarehouseRecord ON ERP_DG_TotalBoxList.FOUTBOUNDID = ERP_WH_OutInWarehouseRecord.fID LEFT JOIN SA_OPPerson SA_OPPerson ON ERP_DG_TotalBoxList.FCREATEPERSONID = SA_OPPerson.SID LEFT JOIN SA_OPPerson SA_OPPerson_1 ON ERP_WH_OutInWarehouseRecord.FSAFEKEEPINGPERSONID = SA_OPPerson_1.SID LEFT JOIN SA_OPPerson SA_OPPerson_2 ON ERP_DG_TotalBoxList.FCHECKER = SA_OPPerson_2.SID LEFT JOIN SA_Task SA_Task ON ERP_DG_TotalBoxList.fID = SA_Task.SDATA1 LEFT JOIN ERP_Customer ERP_Customer ON ERP_DG_TotalBoxList.FCUSTOMERCODE = ERP_Customer.FCUSTOMERCODE LEFT JOIN ERP_WH_Warehouse ERP_WH_Warehouse ON ERP_DG_TotalBoxList.FWAREHOUSEID = ERP_WH_Warehouse.fID  WHERE  (ERP_DG_TotalBoxList.FORGANNAME = ?) AND (? = ?)   ORDER BY fPackingList ASC
   
2. --> binds:[测试, 1, 0]

复制代码

WHERE (ERP_DG_TotalBoxList.FORGANNAME = ?) AND (? = ?)   我没有写   AND (? = ?),为什么会出现这个？

jishuang

如果要自己过滤业务数据把process组件的autoFilter设置为false

dh_n

是这个问题，为什么在本地可以有数据呢

jishuang

看你本地的sql确认是一样的，如果是1=0,不管什么地方都获取不到

dh_n

代码就是本地打到服务器上的，本地输出sql语句没有这个1=0

jishuang

那就肯定有不一样的地方，这个设置就是为了过滤业务数据的，就是从上下文中获取sData1的值对业务数据的值主键值进行过滤
http://docs.wex5.com/bex5-process-question-list-10070/

dh_n

肯定 是一样的，可以稳定重现

jishuang

把可以重现问题的BIZ和UI2层的资源发到support_x5@justep.com中