按照模板事例做了一个时间参数的查询，但是提示错误，大家帮我看看语句哪里写错了？  SELECT * FROM dbo.[IT_Helpdesk] where 1=1 ${if(type='date', " and date(dbo.[IT_Helpdesk].StartData) >= '" +开始日期+ "' and date(dbo.[IT_Helpdesk].StartData)<='" +结束日期+ "'", "")} ${if(type='month', " and cast(strftime('%m',dbo.[IT_Helpdesk].StartData) as int) = "+月+ " and strftime('%Y',dbo.[IT_Helpdesk].StartData) = '" +年+"'", "")} ${if(type='year', " and strftime('%Y',dbo.[IT_Helpdesk].StartData) = '" +年+"'", "")} |
