{
  "dBType" : "SQLSERVER",
  "name" : "SqlServer",
  "getPSDEDataQueryCodeConds" : [ {
    "condType" : "CUSTOM",
    "customCond" : "( t1.[IBIZSAMPLE0006ID] =  ${srfdatacontext('IBIZSAMPLE0006ID','{\"defname\":\"IBIZSAMPLE0006ID\",\"dename\":\"IBIZSAMPLE0007\"}')} )",
    "name" : "查询条件"
  } ],
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.[CREATEDATE]",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.[CREATEMAN]",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t11.[DDATE]",
    "name" : "DDATE"
  }, {
    "expression" : "t11.[DNUM]",
    "name" : "DNUM"
  }, {
    "expression" : "t1.[IBIZSAMPLE0006ID]",
    "name" : "IBIZSAMPLE0006ID"
  }, {
    "expression" : "t11.[IBIZSAMPLE0006NAME]",
    "name" : "IBIZSAMPLE0006NAME"
  }, {
    "expression" : "t1.[IBIZSAMPLE0007ID]",
    "name" : "IBIZSAMPLE0007ID"
  }, {
    "expression" : "t1.[IBIZSAMPLE0007NAME]",
    "name" : "IBIZSAMPLE0007NAME"
  }, {
    "expression" : "t1.[UPDATEDATE]",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.[UPDATEMAN]",
    "name" : "UPDATEMAN"
  }, {
    "expression" : "t1.[WFINSTANCEID]",
    "name" : "WFINSTANCEID"
  }, {
    "expression" : "t1.[WFSTATE]",
    "name" : "WFSTATE"
  }, {
    "expression" : "t1.[WFSTEP]",
    "name" : "WFSTEP"
  }, {
    "expression" : "t1.[WFVERSION]",
    "name" : "WFVERSION"
  }, {
    "expression" : "t1.[YWSTATE]",
    "name" : "YWSTATE"
  } ],
  "queryCode" : "SELECT\nt1.[CREATEDATE],\nt1.[CREATEMAN],\nt11.[DDATE],\nt11.[DNUM],\nt1.[IBIZSAMPLE0006ID],\nt11.[IBIZSAMPLE0006NAME],\nt1.[IBIZSAMPLE0007ID],\nt1.[IBIZSAMPLE0007NAME],\nt1.[UPDATEDATE],\nt1.[UPDATEMAN],\nt1.[WFINSTANCEID],\nt1.[WFSTATE],\nt1.[WFSTEP],\nt1.[WFVERSION],\nt1.[YWSTATE]\nFROM [T_IBIZSAMPLE0007] t1 \nLEFT JOIN T_IBIZSAMPLE0006 t11 ON t1.IBIZSAMPLE0006ID = t11.IBIZSAMPLE0006ID \n",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0007/PSDEDATAQUERIES/CurGW/PSDEDQCODES/SQLSERVER.json"
}