select @@identity as value

本文详细介绍了 SQL Server 中的 SCOPE_IDENTITY 函数,它用于返回在当前作用域中插入到带有 IDENTITY 属性的列中的最后一个 IDENTITY 值。与 IDENT_CURRENT 和 @@IDENTITY 相比,该函数更关注当前执行语句的作用域。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

SCOPE_IDENTITY
返回插入到同一作用域中的 IDENTITY 列内的最后一个 IDENTITY 值。一个作用域就是一个模块——存储过程、触发器、函数或批处理。因此,如果两个语句处于同一个存储过程、函数或批处理中,则它们位于相同的作用域中。

语法
SCOPE_IDENTITY( )

返回类型
sql_variant

注释
SCOPE_IDENTITY、IDENT_CURRENT 和 @@IDENTITY 在功能上相似,因为它们都返回插入到 IDENTITY 列中的值。

IDENT_CURRENT 不受作用域和会话的限制,而受限于指定的表。IDENT_CURRENT 返回为任何会话和作用域中的特定表所生成的值。有关更多信息,请参见 IDENT_CURRENT。

SCOPE_IDENTITY 和 @@IDENTITY 返回在当前会话中的任何表内所生成的最后一个标识值。但是,SCOPE_IDENTITY 只返回插入到当前作用域中的值;@@IDENTITY 不受限于特定的作用域。

例如,有两个表 T1 和 T2,在 T1 上定义了一个 INSERT 触发器。当将某行插入 T1 时,触发器被激发,并在 T2 中插入一行。此例说明了两个作用域:一个是在 T1 上的插入,另一个是作为触发器的结果在 T2 上的插入。

假设 T1 和 T2 都有 IDENTITY 列,@@IDENTITY 和 SCOPE_IDENTITY 将在 T1 上的 INSERT 语句的最后返回不同的值。

@@IDENTITY 返回插入到当前会话中任何作用域内的最后一个 IDENTITY 列值,该值是插入 T2 中的值。

SCOPE_IDENTITY() 返回插入 T1 中的 IDENTITY 值,该值是发生在相同作用域中的最后一个 INSERT。如果在作用域中发生插入语句到标识列之前唤醒调用 SCOPE_IDENTITY() 函数,则该函数将返回 NULL 值。

有关说明,请参见示例。

示例
下列示例将创建两个表 TZ 和 TY,并在 TZ 上创建一个 INSERT 触发器。当将某行插入表 TZ 中时,触发器 (Ztrig) 将激发并在 TY 中插入一行。

USE tempdb
GO
CREATE TABLE TZ (
Z_id int IDENTITY(1,1)PRIMARY KEY,
Z_name varchar(20) NOT NULL)

INSERT TZ
VALUES ('Lisa')
INSERT TZ
VALUES ('Mike')
INSERT TZ
VALUES ('Carla')

SELECT * FROM TZ

--Result set: This is how table TZ looks
Z_id Z_name
-------------
1 Lisa
2 Mike
3 Carla

CREATE TABLE TY (
Y_id int IDENTITY(100,5)PRIMARY KEY,
Y_name varchar(20) NULL)

INSERT TY (Y_name)
VALUES ('boathouse')
INSERT TY (Y_name)
VALUES ('rocks')
INSERT TY (Y_name)
VALUES ('elevator')

SELECT * FROM TY
--Result set: This is how TY looks:
Y_id Y_name
---------------
100 boathouse
105 rocks
110 elevator

/*Create the trigger that inserts a row in table TY
when a row is inserted in table TZ*/
CREATE TRIGGER Ztrig
ON TZ
FOR INSERT AS
BEGIN
INSERT TY VALUES ('')
END

/*FIRE the trigger and find out what identity values you get
with the @@IDENTITY and SCOPE_IDENTITY functions*/
INSERT TZ VALUES ('Rosalie')

SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]
GO
SELECT @@IDENTITY AS [@@IDENTITY]
GO

--Here is the result set.
SCOPE_IDENTITY
4
/*SCOPE_IDENTITY returned the last identity value in the same scope, which was the insert on table TZ*/

@@IDENTITY
115
/*@@IDENTITY returned the last identity value inserted to TY by the trigger, which fired due to an earlier insert on TZ*/
/****** Object: StoredProcedure [dbo].[Gp_AddDataToAuditingBill] Script Date: 2025-07-07 15:08:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /* 作者:谢吉康 日期:2005-8-4 描述:增加新的单据到AuditingBill中 新Carpa平台后重新调整 卢春 2009-06 添加询价单,请购单的修改状态 周华 2013-11-27 */ ALTER PROCEDURE [dbo].[Gp_AddDataToAuditingBill] ( @BillNumberId varchar(8000), --单据编号 @BillIndexType int, --单据类型 0.订单 1.借欠 2.一般物流单据 @OperatorETypeID VARCHAR(100) --操作员ID号 ) --@encode$-- AS SET NOCOUNT ON DECLARE @OperatorId varchar(100), @BillType int, @ETypeId varchar(100), @STypeID VARCHAR(100), @BillDate datetime, @BillCode varchar(256), @AuditingId int, @AuditingLevel int, @AuditingLevel1 int, @AuditingType int, @InOrOut varchar(10), @Checke VARCHAR(50) --制单人 BEGIN TRAN -- 判断状态是否待审核或审核通过,是则退出 IF EXISTS(SELECT TOP 1 BillNumberId FROM AuditingBill WHERE BillNumberId = @BillNumberId AND BillIndexType = @BillIndexType AND IfAudit <> -1) BEGIN ROLLBACK TRAN RETURN -2 END -- 审核不通过,则删除掉原记录,重新写记录 IF EXISTS(SELECT TOP 1 BillNumberId FROM AuditingBill WHERE BillNumberId = @BillNumberId AND BillIndexType = @BillIndexType AND IfAudit = -1) BEGIN DELETE AuditingBillDetail WHERE BillNumberId=@BillNumberId AND BillIndexType=@BillIndexType DELETE AuditingBill WHERE BillNumberId = @BillNumberId AND BillIndexType = @BillIndexType IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -6 END END IF @BillIndexType = 0 -- 订单 BEGIN --修改订单状态 IF EXISTS(SELECT TOP 1 BillNumberId FROM OrderIndex WHERE BillNumberId = @BillNumberId) BEGIN UPDATE OrderIndex SET IfAudit = 0 WHERE BillNumberId = @BillNumberId IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ETypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM OrderIndex WHERE BillNumberId = @BillNumberId END IF @BillIndexType = 1 -- 借欠 BEGIN --修改订单状态 IF EXISTS(SELECT TOP 1 BillNumberId FROM dbo.LendIndex WHERE BillNumberId = @BillNumberId) BEGIN UPDATE LendIndex SET IfAudit = 0 WHERE BillNumberId = @BillNumberId IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ETypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM LendIndex WHERE BillNumberId = @BillNumberId END IF @BillIndexType = 2 -- 一般物流单据 BEGIN --修改184报价单状态 IF EXISTS(SELECT TOP 1 BillNumberId FROM BillIndex WHERE BillNumberId = @BillNumberId AND BillType=184) BEGIN UPDATE BillIndex SET IfAudit = 0 WHERE BillNumberId = @BillNumberId AND BillType=184 IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END -- 修改询价单状态 IF EXISTS(SELECT TOP 1 BillNumberId FROM BillIndex WHERE BillNumberId = @BillNumberId AND BillType =185) BEGIN UPDATE BillIndex SET IfAudit = 0 WHERE BillNumberId = @BillNumberId IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ETypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM BillIndex WHERE BillNumberId = @BillNumberId END IF @BillIndexType=3 --请购单 BEGIN -- 修改请购单状态 IF EXISTS(SELECT TOP 1 BillNumberId FROM RequestIndex WHERE BillNumberId = @BillNumberId AND BillType=204) BEGIN UPDATE dbo.RequestIndex SET IfAudit = 0 WHERE BillNumberId = @BillNumberId IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ETypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM dbo.RequestIndex WHERE BillNumberId = @BillNumberId END IF @BillIndexType=4 --提成单 BEGIN ---- 修改请购单状 IF EXISTS(SELECT TOP 1 BillNumberId FROM CommissionBillNew WHERE BillNumberId = @BillNumberId) BEGIN UPDATE dbo.CommissionBillNew SET BillState = 3 WHERE BillNumberId = @BillNumberId IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END --获取单据的信息 SELECT @BillType = 311, @ETypeId = Checke, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM dbo.CommissionBillNew WHERE BillNumberId = @BillNumberId END IF @BillIndexType=5--发票单据 BEGIN IF EXISTS(SELECT TOP 1 BillNumberid FROM ReceiptBillIndex WHERE BillNumberID=@BillNumberId) BEGIN UPDATE dbo.ReceiptBillIndex SET IfAudit=0 WHERE BillNumberID=@BillNumberId IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -1 END END --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ETypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM ReceiptBillIndex WHERE BillNumberId = @BillNumberId END IF @BillIndexType = 7 --实物库存 BEGIN --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ETypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM FactIndex WHERE BillNumberId = @BillNumberId END IF @BillIndexType = 9--门店类 BEGIN --获取单据的信息 SELECT @BillType = BillType, @ETypeId = ApplyEtypeId, @STypeID = STypeID, @BillDate = BillDate, @BillCode = BillCode, @Checke=Checke FROM PosAllotApplyBillIndex WHERE BillNumberId = @BillNumberId END --判断单据是否有审核流程 SELECT @AuditingId = AuditingId, @AuditingLevel = AuditingLevel, @AuditingLevel1 = AuditingLevel1, @AuditingType = AuditingType FROM AuditingFlowSet WHERE BillType = @BillType AND STypeID=@STypeID AND IfUse = 1 --写入审核表(AuditingBill)中 INSERT INTO AuditingBill ( BillNumberId, AuditingId, AuditingSteps, IfAudit, ETypeId, BillDate, BillCode, BillDetail, BillIndexType, PassSteps, Checke )VALUES( @BillNumberId, @AuditingId, REPLACE(REPLICATE(@AuditingLevel,@AuditingLevel),@AuditingLevel,'2'), 0, @ETypeId, @BillDate, @BillCode, '', @BillIndexType, REPLACE(REPLICATE(@AuditingLevel,@AuditingLevel),@AuditingLevel,'2'), @Checke ) IF @@ROWCOUNT = 0 BEGIN ROLLBACK TRAN RETURN -3 END ---------------------------------------------------------------------------------------------- --【定制】销售订单制单人与审核人相同时校验余额是否大于订单金额 IF EXISTS(select TOP 1 1 FROM orderindex WHERE BillNumberId = @BillNumberId AND SaleWay = 1) BEGIN DECLARE @DealBTypeID VARCHAR(50) DECLARE @OrderTotal numeric(24, 10) DECLARE @BillTotal numeric(24, 10) -- 获取订单的DealBTypeID SELECT @DealBTypeID = dealbtypeid FROM orderindex WHERE BillNumberId = @BillNumberId SELECT @BillTotal = ISNULL(SUM(totalmoney),0) - ISNULL(SUM(preferencemoney),0) - ISNULL(( SELECT SUM(totalmoney) FROM orderindex WHERE billtype = 300 AND dealbtypeid=@DealBTypeID AND IfAudit = 1 ),0) FROM billindex WITH ( NOLOCK ) WHERE billtype IN ( 4, 189 ) AND dealbtypeid=@DealBTypeID AND ifcheck = 't' AND redword = '0' SELECT @OrderTotal = totalmoney FROM orderindex WHERE billnumberid=@BillNumberId IF @BillTotal < @OrderTotal BEGIN ROLLBACK TRAN RETURN -9 END END --------------------------------------------------------------------------------------------- -- PassSteps代表整单审核通过需要经历的步骤,与原因相关 DECLARE @PassSteps VARCHAR(50) SET @PassSteps = REPLACE(REPLICATE(@AuditingLevel,@AuditingLevel),@AuditingLevel,'2') CREATE TABLE #temp( BillNumberID INT, BillType NUMERIC(4, 0), PassFlag bit, Reason VARCHAR(500), value VARCHAR(500), AuditingStep int ) INSERT #temp EXEC GP_BillAudtingCheckReason @BillNumberId,@OperatorETypeID,@BillIndexType,'1',-1,0 DECLARE @i INT,@j INT,@stepReason VARCHAR(500),@stepValue VARCHAR(500) -- 处理特审原因 DECLARE CURSOR_str CURSOR FOR SELECT DISTINCT Reason,Value,AuditingStep FROM #temp WHERE PassFlag = 0 ORDER BY AuditingStep OPEN CURSOR_str FETCH NEXT FROM CURSOR_str INTO @stepReason,@stepValue,@i WHILE @@FETCH_STATUS = 0 BEGIN UPDATE AuditingBill SET StepReasons = ISNULL(StepReasons,'') + '0ж' + RTRIM(@stepReason + ' ' + ISNULL(@stepValue,'')) + 'жи' WHERE BillNumberID = @BillNumberId AND BillIndexType = @BillIndexType FETCH NEXT FROM CURSOR_str INTO @stepReason,@stepValue,@i END CLOSE CURSOR_str DEALLOCATE CURSOR_str -- 写入每级相关原因 SET @j = 0 DECLARE CURSOR_str CURSOR FOR SELECT AuditingStep,Reason,value FROM #temp WHERE PassFlag = 0 ORDER BY AuditingStep OPEN CURSOR_str FETCH NEXT FROM CURSOR_str INTO @i,@stepReason,@stepValue WHILE @@FETCH_STATUS = 0 BEGIN IF @stepReason<>'...' BEGIN UPDATE AuditingBill SET StepReasons = ISNULL(StepReasons,'') + CAST(@i AS VARCHAR(10)) + 'ж' + RTRIM(@stepReason + ' ' + ISNULL(@stepValue,'')) + 'жи' WHERE BillNumberID=@BillNumberId AND BillIndexType=@BillIndexType IF @i <> @j BEGIN SET @PassSteps = LEFT(@PassSteps,@i-1) + '1' + RIGHT(@PassSteps,LEN(@PassSteps)-@i) END SET @j = @i END FETCH NEXT FROM CURSOR_str INTO @i,@stepReason,@stepValue END CLOSE CURSOR_str DEALLOCATE CURSOR_str UPDATE AuditingBill SET PassSteps=@PassSteps WHERE BillNumberID=@BillNumberId AND BillIndexType=@BillIndexType -- 设置灯泡提醒 IF @AuditingType = 1 DECLARE AuditingCursor CURSOR FOR SELECT ETypeId FROM AuditingFlowDetail WHERE AuditingId = @AuditingId AND AuditingStep IN (SELECT TOP 1 AuditingStep FROM #temp WHERE PassFlag=0 ORDER BY AuditingStep) IF @AuditingType = 3 DECLARE AuditingCursor CURSOR FOR SELECT ETypeId FROM AuditingFlowDetail WHERE AuditingId = @AuditingId AND AuditingStep IN (SELECT AuditingStep FROM #temp WHERE PassFlag=0 GROUP BY AuditingStep) OPEN AuditingCursor FETCH NEXT FROM AuditingCursor INTO @OperatorId WHILE @@FETCH_STATUS = 0 BEGIN -- 是否有修改他人草稿的权限 0.有 1.无 DECLARE @ifCanEditOtherDraft INT EXEC @ifCanEditOtherDraft = GP_CheckLimit @OperatorId, 135 -- 是否有审核他人草稿的权限 0.有 1.无 DECLARE @AuditingOtherDraft int EXEC @AuditingOtherDraft = GP_CheckLimit @OperatorID,467 DECLARE @checkeWhere VARCHAR(50) IF @ifCanEditOtherDraft = 0 OR @AuditingOtherDraft = 0 SET @checkeWhere = '%%' ELSE SET @checkeWhere = @OperatorId DECLARE @ifAlerm INT SET @ifAlerm = 0 IF @BillType IN (17,21)-- AND @AuditingType = 1 BEGIN -- 检查仓库权限是否有效 0.有效 1.无效 DECLARE @StockLimit INT EXEC @StockLimit = GP_CheckLimit @OperatorID,454 -- 调拨单中,仓库的权限无效 IF EXISTS(SELECT TOP 1 1 FROM Userconfig WHERE ConfigName = 'MoveInOutKLimit' AND Value = '0') OR @StockLimit = 0 BEGIN IF EXISTS( SELECT TOP 1 1 FROM BillIndex WHERE BillNumberId = @BillNumberId AND ETypeId IN (SELECT * FROM F_GetManDetailEType(@OperatorId)) AND (KTypeID IN (SELECT * FROM F_GetManDetailKType(@OperatorId)) OR KTypeID2 IN (SELECT * FROM F_GetManDetailKType(@OperatorId))) AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END ELSE BEGIN IF EXISTS( SELECT TOP 1 1 FROM BillIndex WHERE BillNumberId = @BillNumberId AND ETypeId IN (SELECT * FROM F_GetManDetailEType(@OperatorId)) AND (KTypeID IN (SELECT * FROM F_GetManDetailKType(@OperatorId)) AND KTypeID2 IN (SELECT * FROM F_GetManDetailKType(@OperatorId))) AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END END ELSE IF @BillType IN (300,301) -- 订单 BEGIN IF EXISTS( SELECT TOP 1 1 FROM OrderIndex WHERE BillNumberId = @BillNumberId AND ETypeId IN (SELECT * FROM F_GetManDetailEType(@OperatorId)) AND BTypeId IN (SELECT * FROM F_GetManDetailBType(@OperatorId)) AND KTypeId IN (SELECT * FROM F_GetManDetailKType(@OperatorId)) ) SET @ifAlerm = 1 END ELSE IF @BillType IN (57) BEGIN IF EXISTS( SELECT BillNumberId FROM AdPriceBill WHERE BillNumberId=@BillNumberId AND ChangeAllStock=1 ) BEGIN IF EXISTS( SELECT TOP 1 1 FROM BillIndex WHERE BillNumberId = @BillNumberId AND ETypeId IN (SELECT * FROM F_GetManDetailEType(@OperatorId)) AND (BTypeId IN (SELECT * FROM F_GetManDetailBType(@OperatorId)) OR ISNULL(BTypeId,'')='') AND (KTypeId='00000') AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END ELSE BEGIN IF EXISTS( SELECT TOP 1 1 FROM BillIndex WHERE BillNumberId = @BillNumberId AND ETypeId IN (SELECT * FROM F_GetManDetailEType(@OperatorId)) AND (BTypeId IN (SELECT * FROM F_GetManDetailBType(@OperatorId)) OR ISNULL(BTypeId,'')='') AND (KTypeId IN (SELECT * FROM F_GetManDetailKType(@OperatorId)) OR ISNULL(KTypeId,'')='') AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END END ELSE IF @BillType IN (328,327) --门店单据 BEGIN IF EXISTS( SELECT TOP 1 1 FROM PosAllotApplyBillIndex WHERE BillNumberId = @BillNumberId AND ApplyEtypeId IN (SELECT * FROM F_GetManDetailEType(@OperatorId)) AND (KTypeID IN (SELECT * FROM F_GetManDetailKType(@OperatorId)) OR InKtypeId IN (SELECT * FROM F_GetManDetailKType(@OperatorId))) AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END ELSE BEGIN --2018-08-15 谢吉康 以前的算法不合理,优化 DECLARE @BTypeId VARCHAR(500) SELECT @BTypeId = BTypeID FROM BillIndex WHERE BillNumberid = @BillNumberId IF @BTypeId <> '' BEGIN IF EXISTS( SELECT TOP 1 1 FROM BillIndex B INNER JOIN (SELECT * FROM F_GetManDetailEType(@OperatorId)) E ON B.ETypeId = E.TypeId INNER JOIN (SELECT * FROM F_GetManDetailBTypeForAudit(@OperatorId,@BTypeId)) MB ON MB.TypeId = B.btypeid INNER JOIN (SELECT * FROM F_GetManDetailKType(@OperatorId)) MK ON (MK.TypeId = B.KTypeId OR ISNULL(KTypeId,'')='') WHERE BillNumberId = @BillNumberId AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END ELSE BEGIN IF EXISTS( SELECT TOP 1 1 FROM BillIndex B INNER JOIN (SELECT * FROM F_GetManDetailEType(@OperatorId)) E ON B.ETypeId = E.TypeId INNER JOIN (SELECT * FROM F_GetManDetailKType(@OperatorId)) MK ON (MK.TypeId = B.KTypeId OR ISNULL(KTypeId,'')='') WHERE BillNumberId = @BillNumberId AND checke LIKE @checkeWhere ) SET @ifAlerm = 1 END END IF @ifAlerm = 1 BEGIN IF @AuditingType = 1 BEGIN UPDATE AuditingFlowDetail SET AuditingAlerm = 1 WHERE AuditingId = @AuditingId AND ETypeId = @OperatorId AND AuditingStep IN (SELECT TOP 1 AuditingStep FROM #temp WHERE PassFlag=0 ORDER BY AuditingStep) END IF @AuditingType = 3 BEGIN UPDATE AuditingFlowDetail SET AuditingAlerm = 1 WHERE AuditingId = @AuditingId AND ETypeId = @OperatorId AND AuditingStep IN (SELECT AuditingStep FROM #temp WHERE PassFlag=0 GROUP BY AuditingStep) END END FETCH NEXT FROM AuditingCursor INTO @OperatorId END CLOSE AuditingCursor DEALLOCATE AuditingCursor --处理同一个人审核人的情况 IF EXISTS(SELECT TOP 1 1 FROM dbo.Userconfig WHERE ConfigName = 'samepersonchecked' AND Value = '1') BEGIN IF EXISTS(SELECT TOP 1 1 FROM AuditingFlowSet WHERE BillType = @BillType AND AuditingType = 3) AND EXISTS(SELECT TOP 1 1 FROM AuditingFlowDetail WHERE BillType = @BillType AND AuditingStep <> 0 AND ETypeID = @OperatorETypeID) --会签审核 BEGIN EXEC GP_BillAuditingDeal @OperatorETypeID,@BillNumberId,'1','自动审核通过',@BillIndexType,'','' END ELSE BEGIN --处理审核消息 DECLARE @nextStep INT IF EXISTS(SELECT TOP 1 AuditingStep FROM AuditingBillDetail WHERE BillNumberID = @BillNumberId AND BillIndexType = @BillIndexType) SELECT TOP 1 @nextStep = AuditingStep + 1 FROM AuditingBillDetail WHERE BillNumberID = @BillNumberId AND BillIndexType = @BillIndexType ORDER BY AuditingStep DESC ELSE SET @nextStep = 1 SELECT * INTO #AuditingFlowDetail FROM AuditingFlowDetail WHERE BillType = @BillType AND AuditingStep <> 0 AND ETypeID = @OperatorETypeID WHILE EXISTS(SELECT TOP 1 1 FROM #AuditingFlowDetail WHERE AuditingStep = @nextStep) BEGIN EXEC GP_BillAuditingDeal @OperatorETypeID,@BillNumberId,'1','自动审核通过',@BillIndexType,'','' SET @nextStep += 1 END DROP TABLE #AuditingFlowDetail END END --单据审核流程完成后自动过账 DECLARE @RE INT EXEC @RE = GP_CheckLimit @OperatorETypeID,2659 --处理价格跟踪 IF @BillType IN (184,185,300,301) BEGIN EXEC dbo.GP_BatchPassPT @billnumberid=@BillNumberId,@billtype=@BillType END --自动过账 IF @billtype NOT IN(184,185,300,313,204,185,301,22,326,162,163) AND EXISTS(SELECT TOP 1 1 FROM dbo.AuditingBill WHERE BillNumberID = @BillNumberId AND BillIndexType = @BillIndexType AND IfAudit = 1) AND @RE = 0 BEGIN EXEC dbo.Gp_Auditing @nBillID = @BillNumberId, -- numeric @szCheckMan = @Checke, -- varchar(50) @szPID = '', -- varchar(1000) @chvOpID = @OperatorETypeID, -- varchar(50) @KTypeID = '', -- varchar(50) @billtype = @BillType, -- int @voucherMsg = '', -- varchar(50) @vipcentinfo='', @AssetMsg='', @VipCardCode = '' ,--VARCHAR(200) @CommissionConfirm = 0 ,--INT @strReturnBillCode = '' --VARCHAR(200) IF EXISTS(SELECT TOP 1 1 FROM dbo.Userconfig WHERE ConfigName = 'BillCodeCreateTime' AND Value = 2) EXEC dbo.GP_SaveBillCode_Seed @intBillNumberID=@BillNumberId,@intBillType=@BillType,@dBillDate=@billdate,@strBillCode=@BillCode IF(@BillType IN(17,21,404,327,328)) --没有btypeid 的不要插入,否则报错 begin INSERT INTO BillOperateLog(billnumberid,operatetype,etypeid,OperateTime,ip,billcode,billdate,ifcheck,ntotalmoney,billtype) VALUES(@billnumberid,'自动审核过账',@OperatorETypeID,GETDATE(),'',@billcode,@billdate,'t',0,@billtype) END ELSE BEGIN INSERT INTO BillOperateLog(billnumberid,operatetype,etypeid,OperateTime,ip,billcode,billdate,ifcheck,btypeid,ntotalmoney,billtype) VALUES(@billnumberid,'自动审核过账',@OperatorETypeID,GETDATE(),'',@billcode,@billdate,'t',ISNULL(@btypeid,''),0,@billtype) END --自动审核过账,反写一大堆数量,状态等.正常过账反写以前是写在代码里面的,没有在存储过程里,所以要单独写出来 EXEC Gp_Auditing_UpdateQtyorState @BillNumberId, @BillType END DROP TABLE #temp --成功,退出 COMMIT TRAN RETURN 0
07-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值