{
  "dBType" : "MYSQL5",
  "name" : "MySQL5",
  "getPSDEDataQueryCodeConds" : [ {
    "condType" : "CUSTOM",
    "customCond" : "t21.IBIZORDERID is not null",
    "name" : "查询条件"
  }, {
    "condType" : "CUSTOM",
    "customCond" : "( t21.IBIZORDERID =  ${srfwebcontext('srfkeys','{\"defname\":\"IBIZORDERID\",\"dename\":\"IBIZORDER\"}')} )",
    "name" : "查询条件"
  } ],
  "queryCode" : "SELECT \tT31.IBIZUNIPRODUCTNAME,T21.QUANTITY,T31.UNIT,T31.UNITPRICE,T21.QUANTITY*T31.UNITPRICE AS AMOUNT \tFROM T_IBIZORDER T1  \t\nLEFT JOIN T_IBIZCUSTOMER T11 ON T1.IBIZCUSTOMERID = T11.IBIZCUSTOMERID  \t\nLEFT JOIN T_IBIZORDERDETAIL T21 ON T1.IBIZORDERID = T21.IBIZORDERID  \t\nLEFT JOIN T_IBIZUNIPRODUCT T31 ON T21.IBIZUNIPRODUCTID = T31.IBIZUNIPRODUCTID",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZOrder/PSDEDATAQUERIES/DYDDMXSJY/PSDEDQCODES/MYSQL5.json"
}