CREATE PROCEDURE UpdateYSDZBMX_GZTH
AS
BEGIN
--销售增值税发票查询
SELECT B.CONTRACTNUMBER AS '订单号',SUM(A.FAFTERTOTALTAX) AS '价税合计本位币',A.FDATE AS '专票日期'
INTO #TEMP1
FROM T_IV_SALESIC A
INNER JOIN YingShouZhanKuanMX B ON A.F_PaperNumber = B.CONTRACTNUMBER
WHERE A.FDOCUMENTSTATUS = 'C' 
AND A.FBillTypeID = '50ea4e69b6144f69961d2e9b44820929'
GROUP BY B.CONTRACTNUMBER,A.FDATE

--销售普票查询
SELECT B.CONTRACTNUMBER AS '订单号',SUM(A.FAFTERTOTALTAX) AS '价税合计本位币',A.FDATE AS '普票日期'
INTO #TEMP2
FROM T_IV_SALESIC A
INNER JOIN YingShouZhanKuanMX B ON A.F_PaperNumber = B.CONTRACTNUMBER
WHERE A.FDOCUMENTSTATUS = 'C' 
AND A.FBillTypeID = '1cab58bc33d24e27826be02249f4edac'  
GROUP BY B.CONTRACTNUMBER,A.FDATE

--更新普票开票日期，普票开票金额
UPDATE A
SET A.PPBillingDate = B.[普票日期],A.PPBillingAmount = A.PPBillingAmount + B.价税合计本位币
FROM YingShouZhanKuanMX A
INNER JOIN #TEMP2 B ON  B.[订单号] = A.CONTRACTNUMBER

--更新专票开票日期，专票开票金额
update A
SET A.ZPBillingDate = B.[专票日期],A.ZPBillingAmount = A.ZPBillingAmount + B.价税合计本位币
FROM YingShouZhanKuanMX A
INNER JOIN #TEMP1 B ON  B.[订单号] = A.CONTRACTNUMBER
END;

--更新开票金额等于普票金额+专票金额
update YingShouZhanKuanMX
SET BillingAmount = PPBillingAmount + ZPBillingAmount