sql代码中加入动态条件后${},和条件写死后,显示的不一样。加入动态条件,横向扩展时重复显示。---动态条件where 1=1--合同时间${if(len(stime) == 0,"","and CONVERT(VARCHAR(12),PM_PurchaseOrder.BusinessDate,23) >= '" + stime + "'")}${if(len(etime) == 0,"","and CONVERT(VARCHAR(12),PM_PurchaseOrder.BusinessDate,23) <= '" + etime + "'")}----条件写死where 1=1and CONVERT(VARCHAR(12),PM_PurchaseOrder.BusinessDate,23) >= '2018-08-06' and CONVERT(VARCHAR(12),PM_PurchaseOrder.BusinessDate,23) <= '2018-11-28'---如下图,图一:加入动态条件,图二:条件写死,显示正常