---查詢還有多少數量沒有結算
SELECT DISTINCT T_CC_StockBill.FID,T_CC_StockBillEntry.FSettleQty,T_CC_StockBill.FBillNo,T_CC_StockBill.FClassTypeID 

,T_CC_StockBillEntry.FEntryID,T_CC_StockBillEntry.FIndex  FROM  T_CC_StockBill  INNER JOIN T_CC_StockBillEntry  ON T_CC_StockBill.FID=T_CC_StockBillEntry.FID
 LEFT  JOIN t_BaseBillTypeData  ON T_CC_StockBill.FBillTypeID=t_BaseBillTypeData.FID
 LEFT  JOIN t_Organization  ON T_CC_StockBill.FCustID=t_Organization.FItemID AND t_Organization.FItemID<>0
 LEFT  JOIN t_SubMessage t_SubMessage2 ON T_CC_StockBill.FFetchStyle=t_SubMessage2.FInterID AND t_SubMessage2.FInterID<>0
 LEFT  JOIN t_User  ON T_CC_StockBill.FBillerID=t_User.FUserID AND t_User.FUserID<>0
 LEFT  JOIN t_User t_User1 ON T_CC_StockBill.FCheckerID=t_User1.FUserID AND t_User1.FUserID<>0
 LEFT  JOIN t_Emp  ON T_CC_StockBill.FEmpID=t_Emp.FItemID AND t_Emp.FItemID<>0
 LEFT  JOIN t_Department  ON T_CC_StockBill.FDeptID=t_Department.FItemID AND t_Department.FItemID<>0
 LEFT  JOIN t_ICItem  ON T_CC_StockBillEntry.FItemID=t_ICItem.FItemID AND t_ICItem.FItemID<>0
 LEFT  JOIN t_Stock  ON T_CC_StockBillEntry.FSCStockID=t_Stock.FItemID AND t_Stock.FItemID<>0
 LEFT  JOIN t_Item  ON T_CC_StockBillEntry.FAuxPropID=t_Item.FItemID AND t_Item.FItemID<>0
 LEFT  JOIN t_Measureunit t_Measureunit2 ON T_CC_StockBillEntry.FUnitID=t_Measureunit2.FItemID AND t_Measureunit2.FItemID<>0
 WHERE  2=2 And ( T_CC_StockBill.FDate between '2001-11-07' and '2009-11-07 23:59:59'
)
 AND  T_CC_StockBill.FCustID=294 AND     ( T_CC_StockBill.FStatus ='1'  AND   t_BaseBillTypeData.FName ='委托代銷'  AND t_CC_StockBillEntry.FUnSettleQty>0    )    AND T_CC_StockBill.FClassTypeID=1030003 Order By T_CC_StockBill.FID,T_CC_StockBillEntry.FIndex
-------------------------------------
SELECT  fbillno,t_CC_StockBillEntry.FUnSettleQty,fqty,fitemid,FCustID,FBatchNo,FUnitID,FOrderQty,

FQty,FSecUnitID,FsecCoefficient,FSecQty,FPrice,t_CC_StockBill.FID,t_CC_StockBill.FClassTypeID  ,

t_CC_StockBillEntry.FEntryID,t_CC_StockBillEntry.FIndex, fdate,fbatchno,t_CC_StockBillEntry.fkfdate,t_CC_StockBillEntry.fkfperiod,t_CC_StockBillEntry.fperioddate FROM  t_CC_StockBill  INNER JOIN t_CC_StockBillEntry  ON t_CC_StockBill.FID=t_CC_StockBillEntry.FID
where fbillno like 'wtdx%' and t_CC_StockBill.fcustid='294'and (FDate between '2008-08-01' and '2008-08-31 23:59:59')and t_CC_StockBillEntry.FUnSettleQty<>fqty

t_CC_StockBillEntry.FUnSettleQty<>fqty

update t_user set fsid='' where fname='manager'

----t_CC_StockBill.fcustid客戶內碼id
------------更新委托代銷的有效數量
update t_CC_StockBillEntry set FUnSettleQty=fqty from t_CC_StockBill  INNER JOIN t_CC_StockBillEntry  ON t_CC_StockBill.FID=t_CC_StockBillEntry.FID

where fbillno like 'wtdx%' and t_CC_StockBill.fcustid='294'and (FDate between '2008-08-01' and '2008-08-31 23:59:59')

--FUnSettleQty未使用數量,就是可以返回的實際數量