//排除无效 销售普通发票数据
stringBuilder.AppendLine(string.Format(@"/*dialect*/
update {0} z
set z.FRECSID=-99
where not exists(
select t1.FRECSID
from {0} t1
inner join (
select
x.fentryid as FRECSID
from
T_IV_SALESICENTRY x
inner join
(
select c.fbillno
from {1} a
inner join T_SAL_ORDERENTRY b on b.FENTRYID=a.forderid
inner join T_SAL_ORDER c on c.FID=b.FID
group by c.fbillno
) y on y.fbillno=x.FSALESORDERNO
) t2 on t1.FRECSID=t2.FRECSID
where z.FRECSID=t1.FRECSID
)
and z.FRECSID>0
", this.flowTable,this.rptFilterTable));
list.Add(new SqlObject(stringBuilder.ToString(), new List<SqlParam>()));
stringBuilder.Clear();
DBUtils.ExecuteBatchWithTime(base.Context, list, 300);
list.Clear();
推荐阅读