CREATE PROCEDURE [dbo].[M_CreateInventoryCk]
AS
DECLARE @tran_error INT;--记录错误数量
DECLARE @cursor CURSOR --游标
BEGIN
SET @cursor=cursor for select LogistHead.[Guid],OrderHead.Guid,LogistHead.Weight,LogistHead.Pack_No From dbo.Kj_Logistics_Head LogistHead
INNER JOIN dbo.Kj_Order_Head OrderHead ON OrderHead.Guid=LogistHead.OrderPK AND OrderHead.Doc_Status='A023'
OPEN @cursor
FETCH NEXT FROM @cursor INTO @M_ID, @OrderGuid, @CURSORWeight,
@CURSORPack_No
WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN TRY
BEGIN TRAN
SET @tran_error = 0;
INSERT INTO [dbo].[Kj_Ni_Inventory_Head]
( [Guid] ,
ShiperName
)
SELECT GETDATE()--汇总时间
,
( CASE OrderHead.Biz_Type
WHEN '1' THEN 'B2CJJ'
WHEN '3' THEN 'BSJ'
ELSE ''
END ) ,
CASE WHEN logistHead.Customs_Code IN (
'2314', '2381' ) THEN '320220'
WHEN logistHead.Customs_Code IN (
'2308' ) THEN '320150'
ELSE '海关编码不是苏州和南京'
END ,
( SELECT REPLACE(LTRIM(NEWID()), '-',
'')
)
FROM dbo.Kj_Logistics_Head logistHead
INNER JOIN dbo.Kj_Order_Head OrderHead ON logistHead.OrderPK = OrderHead.Guid
END TRY
BEGIN CATCH
PRINT '出现异常，错误编号：' + CONVERT(VARCHAR, ERROR_NUMBER())
+ ',错误消息：' + ERROR_MESSAGE()
SET @tran_error = @tran_error + 1
END CATCH
IF ( @tran_error > 0 )
BEGIN
--执行出错，回滚事务
ROLLBACK TRAN;
END
ELSE
BEGIN
--没有异常，提交事务
COMMIT TRAN;
END
FETCH NEXT FROM @cursor INTO @M_ID, @OrderGuid, @CURSORWeight,
@CURSORPack_No
END
CLOSE @cursor
DEALLOCATE @cursor
END
