|
楼主 |
发表于 2019-10-17 14:26:36
|
显示全部楼层
本地的日志是这样的:
2019-10-17 14:24:47 进入supplierQueryPage方法:
2019-10-17 14:24:47 range:[]
2019-10-17 14:24:47 conceptperatingSupplier
2019-10-17 14:24:47 selectperatingSupplier.*,T_PUB_TYPE.TYPE_NAME as TYPE_NAME,case when T_PUB_TYPE.FNAME = '政企' then '集客' else T_PUB_TYPE.FNAME end as fName,T_PUB_TYPE.FCODE as fCode,case when operatingSupplier.STATUS = '1' then '启用' else '已冻结' end as statusName
2019-10-17 14:24:47 fromperatingSupplier operatingSupplier optional join T_PUB_TYPE T_PUB_TYPE on operatingSupplier.TYPE_IDS = T_PUB_TYPE
2019-10-17 14:24:47 aggregate:null
2019-10-17 14:24:47 dataModel:/ERP/PUR/operatingSupplier/data
2019-10-17 14:24:47 fnModel:null
2019-10-17 14:24:47 condition:null
2019-10-17 14:24:47 distinct:false
2019-10-17 14:24:47 idColumnperatingSupplier
2019-10-17 14:24:47 filterSTATUS in ('1','2') )
2019-10-17 14:24:47 limit:20
2019-10-17 14:24:47 offset:0
2019-10-17 14:24:47 columns:ADDRESS,CATEGORY,CHANGEREASON,CITY,CITY_CODE,CONTACT_PHONE,CONTROLINSTRUCTIONS,CUSCLASS,CUSTOMER_NAME,CUSTOMER_NO,CUS_TYPE,ContractorStatusName,FACCOUNTGROUP,FBUSINESSATTACHMENT,FBUSINESSNUM,FCREDITATTACHMENT,FCREDITCODE,FCUSCLASSNAME,FORGATTACHMENT,FREGISTEREDCAPITAL,FTAXATTACHMENT,FTHREEINONE,FTRADE,FUNITPROPERTY,GROUPCUSTOMER,GROUPCUSTOMER_TYPE_ID,ORGANIZATION_CODE,PROVINCE,PROVINCE_CODE,REMARK,STATUS,TAX_REGISTRATION_NO,TYPE_IDS,TYPE_NAME,ZIP_CODE,changeContent,cooperateClass,fActivity,fActivityName,fCode,fCreatdTime,fCreateDeptCode,fCreateDeptID,fCreateDeptName,fCreatePersonCode,fCreatePersonFID,fCreatePersonID,fCreatePersonName,fName,fProcessID,fTaskID,fUpdateTime,oldName,operatingSupplier,processStatus,statusName,version
2019-10-17 14:24:47 orderBy:null
2019-10-17 14:24:47 aggregateColumns:null
2019-10-17 14:24:47 variables:{}
2019-10-17 14:24:47 <rows><userdata name="model">/ERP/PUR/operatingSupplier/data</userdata><userdata name="id-column-name">operatingSupplier</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">operatingSupplier</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">operatingSupplier.ADDRESS,operatingSupplier.CATEGORY,operatingSupplier.CHANGEREASON,operatingSupplier.CITY,operatingSupplier.CITY_CODE,operatingSupplier.CONTACT_PHONE,operatingSupplier.CONTROLINSTRUCTIONS,operatingSupplier.CUSCLASS,operatingSupplier.CUSTOMER_NAME,operatingSupplier.CUSTOMER_NO,operatingSupplier.CUS_TYPE,operatingSupplier.ContractorStatusName,operatingSupplier.FACCOUNTGROUP,operatingSupplier.FBUSINESSATTACHMENT,operatingSupplier.FBUSINESSNUM,operatingSupplier.FCREDITATTACHMENT,operatingSupplier.FCREDITCODE,operatingSupplier.FCUSCLASSNAME,operatingSupplier.FORGATTACHMENT,operatingSupplier.FREGISTEREDCAPITAL,operatingSupplier.FTAXATTACHMENT,operatingSupplier.FTHREEINONE,operatingSupplier.FTRADE,operatingSupplier.FUNITPROPERTY,operatingSupplier.GROUPCUSTOMER,operatingSupplier.GROUPCUSTOMER_TYPE_ID,operatingSupplier.ORGANIZATION_CODE,operatingSupplier.PROVINCE,operatingSupplier.PROVINCE_CODE,operatingSupplier.REMARK,operatingSupplier.STATUS,operatingSupplier.TAX_REGISTRATION_NO,operatingSupplier.TYPE_IDS,T_PUB_TYPE.TYPE_NAME,operatingSupplier.ZIP_CODE,operatingSupplier.changeContent,operatingSupplier.cooperateClass,operatingSupplier.fActivity,operatingSupplier.fActivityName,T_PUB_TYPE.FCODE,operatingSupplier.fCreatdTime,operatingSupplier.fCreateDeptCode,operatingSupplier.fCreateDeptID,operatingSupplier.fCreateDeptName,operatingSupplier.fCreatePersonCode,operatingSupplier.fCreatePersonFID,operatingSupplier.fCreatePersonID,operatingSupplier.fCreatePersonName,EXPRESS,operatingSupplier.fProcessID,operatingSupplier.fTaskID,operatingSupplier.fUpdateTime,operatingSupplier.oldName,operatingSupplier.processStatus,EXPRESS,operatingSupplier.version</userdata><userdata name="relation-types">String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Decimal,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,DateTime,String,String,String,String,String,String,String,String,String,String,DateTime,String,String,String,Integer</userdata><userdata name="relation-alias">ADDRESS,CATEGORY,CHANGEREASON,CITY,CITY_CODE,CONTACT_PHONE,CONTROLINSTRUCTIONS,CUSCLASS,CUSTOMER_NAME,CUSTOMER_NO,CUS_TYPE,ContractorStatusName,FACCOUNTGROUP,FBUSINESSATTACHMENT,FBUSINESSNUM,FCREDITATTACHMENT,FCREDITCODE,FCUSCLASSNAME,FORGATTACHMENT,FREGISTEREDCAPITAL,FTAXATTACHMENT,FTHREEINONE,FTRADE,FUNITPROPERTY,GROUPCUSTOMER,GROUPCUSTOMER_TYPE_ID,ORGANIZATION_CODE,PROVINCE,PROVINCE_CODE,REMARK,STATUS,TAX_REGISTRATION_NO,TYPE_IDS,TYPE_NAME,ZIP_CODE,changeContent,cooperateClass,fActivity,fActivityName,fCode,fCreatdTime,fCreateDeptCode,fCreateDeptID,fCreateDeptName,fCreatePersonCode,fCreatePersonFID,fCreatePersonID,fCreatePersonName,fName,fProcessID,fTaskID,fUpdateTime,oldName,processStatus,statusName,version</userdata><userdata name="sys.count">0</userdata><userdata name="sys.rowid">operatingSupplier</userdata></rows>
|
|