strSQL = _T("select BillItemCode as billCode,BillItemName as BillName,Unit,bill.zbsBillItemId,sum(QtySrc) as EntQty,sum(QtyCode) as OtherQty,Sum(qtySrc+QtyCode) as Gcl from ");
strSQL += _T("(select zbsBillItemId,Quantity as QtySrc, 0 as QtyCode from TBSBillItem where CodeSrcFlag=0 union all ");
strSQL += _T("select zbsBillItemId,0 as QtySrc, Quantity as QtyCode from TBSBillItem where CodeSrcFlag=1) as bill ");
strSQL += _T("left join ZBSBillItem on ZBSBillItem.zbsBillItemId=bill.zbsBillItemId ");
strSQL += _T("group by BillItemCode,BillItemName,Unit,bill.zbsBillItemId order by billItemCode ");
strSQL += _T("(select zbsBillItemId,Quantity as QtySrc, 0 as QtyCode from TBSBillItem where CodeSrcFlag=0 union all ");
strSQL += _T("select zbsBillItemId,0 as QtySrc, Quantity as QtyCode from TBSBillItem where CodeSrcFlag=1) as bill ");
strSQL += _T("left join ZBSBillItem on ZBSBillItem.zbsBillItemId=bill.zbsBillItemId ");
strSQL += _T("group by BillItemCode,BillItemName,Unit,bill.zbsBillItemId order by billItemCode ");