存储过程-按条件执行

USE [test]
GO
/****** Object:  StoredProcedure [dbo].[proc_UpdateLld]    Script Date: 2019/6/27 10:58:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[proc_UpdateLld]
    @Lb int,
    @Lld varchar(20),
    @Ljh varchar(20)
AS
BEGIN
    if (select checked from store_produce_require_detail where id = @Lld and souceid = @Ljh) != '1'
    begin
        if @Lb = 0  
        begin
            update store_produce_require_detail set checked = '1'
            where id = @Lld and souceid = @Ljh
        end
        if @Lb = 1
        begin
            delete from shengchan_move_list
            where sbid = @Lld and souceid = @Ljh
        end
        if @Lb = 2
        begin
            delete from  store_produce_in_detail
            where id = @Lld and souceid = @Ljh
        end
    end
END