{
  "dBType" : "MYSQL5",
  "mOSFilePath" : "psmodules/common/psdataentities/BOOK/psdedataqueries/SIMPLE/psdedqcodes/MYSQL5",
  "name" : "MySQL5",
  "getPSDEDataQueryCodeConds" : [ {
    "condType" : "CUSTOM",
    "customCond" : "( t1.`TYPE` = '历史'  AND  ( t1.`BOOKNAME` LIKE '%我了个老天爷%' ) )",
    "name" : "查询条件"
  } ],
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.`DATE`",
    "name" : "DATE"
  }, {
    "expression" : "t1.`FIELD10`",
    "name" : "FIELD10"
  }, {
    "expression" : "t1.`FIELD11`",
    "name" : "FIELD11"
  }, {
    "expression" : "t1.`FIELD12`",
    "name" : "FIELD12"
  }, {
    "expression" : "t1.`FIELD13`",
    "name" : "FIELD13"
  }, {
    "expression" : "t1.`FIELD14`",
    "name" : "FIELD14"
  }, {
    "expression" : "t1.`FIELD15`",
    "name" : "FIELD15"
  }, {
    "expression" : "t1.`FIELD16`",
    "name" : "FIELD16"
  }, {
    "expression" : "t1.`FIELD17`",
    "name" : "FIELD17"
  }, {
    "expression" : "t1.`FIELD18`",
    "name" : "FIELD18"
  }, {
    "expression" : "t1.`FIELD19`",
    "name" : "FIELD19"
  }, {
    "expression" : "t1.`FIELD20`",
    "name" : "FIELD20"
  }, {
    "expression" : "t1.`FIELD21`",
    "name" : "FIELD21"
  }, {
    "expression" : "t1.`FIELD22`",
    "name" : "FIELD22"
  }, {
    "expression" : "t1.`FIELD4`",
    "name" : "FIELD4"
  }, {
    "expression" : "t1.`FIELD5`",
    "name" : "FIELD5"
  }, {
    "expression" : "t1.`FIELD6`",
    "name" : "FIELD6"
  }, {
    "expression" : "t1.`FIELD7`",
    "name" : "FIELD7"
  }, {
    "expression" : "t1.`FIELD8`",
    "name" : "FIELD8"
  }, {
    "expression" : "t1.`FIELD9`",
    "name" : "FIELD9"
  }, {
    "expression" : "t1.`TYPE`",
    "name" : "TYPE"
  }, {
    "expression" : "t1.`BOOKID`",
    "name" : "BOOKID"
  }, {
    "expression" : "t1.`BOOKNAME`",
    "name" : "BOOKNAME"
  }, {
    "expression" : "t1.`CREATEDATE`",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.`CREATEMAN`",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.`DEPTID`",
    "name" : "DEPTID"
  }, {
    "expression" : "t1.`FIELD`",
    "name" : "FIELD"
  }, {
    "expression" : "t1.`FIELD2`",
    "name" : "FIELD2"
  }, {
    "expression" : "t1.`FIELD3`",
    "name" : "FIELD3"
  }, {
    "expression" : "t1.`ORGID`",
    "name" : "ORGID"
  }, {
    "expression" : "t1.`UPDATEDATE`",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.`UPDATEMAN`",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.`BOOKID`,\nt1.`BOOKNAME`,\nt1.`CREATEDATE`,\nt1.`CREATEMAN`,\nt1.`DEPTID`,\nt1.`FIELD`,\nt1.`FIELD2`,\nt1.`FIELD3`,\nt1.`ORGID`,\nt1.`UPDATEDATE`,\nt1.`UPDATEMAN`\nFROM `T_BOOK` t1 \n",
  "rTMOSFilePath" : "psmodules/common/psdataentities/BOOK/psdedataqueries/SIMPLE/psdedqcodes/MYSQL5",
  "id" : "PSMODULES/common/PSDATAENTITIES/Book/PSDEDATAQUERIES/Simple/PSDEDQCODES/MYSQL5.json"
}