hqlBuffer.append(" from TMsAj fyaj where 1=1 ")
hqlBuffer.append(" and not exists " +
"(select 1 from TAjpcPcjg pcjg where fyaj.CBh=pcjg.CBhAj and pcjg.NPcfslb = 1 and pcjg.NPcjl=2 and pcjg.NAjlb = "+nAjlb+") ");
验证可用
hqlBuffer.append(" from TMsAj fyaj where 1=1 ")
hqlBuffer.append(" and not exists " +
"(select 1 from TAjpcPcjg pcjg where fyaj.CBh=pcjg.CBhAj and pcjg.NPcfslb = 1 and pcjg.NPcjl=2 and pcjg.NAjlb = "+nAjlb+") ");
验证可用