今天做报表过滤时:
需要在系统产生的sql上增加过滤条件,刚开始为了代码的书写方便,我直接把过滤条件(T_CYJ_OrgToArea.FAreaID='区域' ,T_CYJ_OrgToState.FOrgIDID=‘业态’)写到了LEFT OUTER JOIN ON后面,源码如下面的黑体字:
from CT_CYK_CustomerBaseInfo" +
" LEFT OUTER JOIN T_BD_Customer ON CT_CYK_CustomerBaseInfo.CFCustNameID=T_BD_Customer.FID");
sql.append(" LEFT OUTER JOIN T_BD_Customer as linCustomer ON CT_CYK_CustomerBaseInfo.CFMainLinkMenID=linCustomer.FID "+
" LEFT OUTER JOIN T_CYJ_CustomerUnit ON CT_CYK_CustomerBaseInfo.CFUnitsOneID=T_CYJ_CustomerUnit.FID "+
" LEFT OUTER JOIN CT_CYK_CustomerBIDIE ON CT_CYK_CustomerBaseInfo.FID=CT_CYK_CustomerBIDIE.FPARENTID and CT_CYK_CustomerBIDIE.CFISMAINDUTY=1 "+
" LEFT OUTER JOIN