语句复制出来。。放在最上面

select * from  GET_SJHZ_VF_DicWorkFlowForm

where 

WorkFlowFormId IN

(

  SELECT InstanceId

  FROM WF_WorkFlowTask

  WHERE 1=1

  (and  IsDelete IS NULL  OR  IsDelete = 0 ) 

  and State = 6     

  )

${IF(LEN(orgname)==0,"","and 科室='"+orgname+"'")}

${IF(LEN(starttime)==0,"","and 发生时间>='"+starttime+"'")}

${IF(LEN(endtime)==0,"","and 发生时间<='"+endtime+"'")}

and 和select 直接要有字段名 比如 AND XXX字段 IN (SELECT ... WHERE STATE=6)

((IsDelete IS NULL ) OR ( IsDelete = 0 ))  这里多了一个括号

WHERE

(

(((IsDelete IS NULL ) OR ( IsDelete = 0 ))

and State = 6

)

)

写的有问题

WHERE 1=1

(and  IsDelete IS NULL  OR  IsDelete = 0 )

and State = 6