新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【存储过程】 删除

if exists ( select * from sys.objects where object_id = OBJECT_ID(N'dbo.a_ChangeFunc') AND type in (N'P', N'PC') )
               drop     procedure                                      dbo.a_ChangeFunc
   go
   
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【存储过程】 a_ChangeFunc  更改明细功能：名称,排序

create procedure dbo.a_ChangeFunc
   
       @FuncName    varchar(30) 
      ,@FuncID      int = 0
      ,@SubID       int = 0
      ,@Index       int = 0 
      ,@NewFuncID   int = 0
      ,@Name        varchar(30)
   as

update t_DataFlowSubFunc set FSubSysID = @SubID ,FIndex = @Index ,FFuncName = @Name ,FFuncName_CHT = @Name ,FFuncName_EN = @Name  
      where FSubFuncID = @FuncID ;
     ----------------------------------------
      if @NewFuncID > 0 begin
         update t_DataFlowSubFunc set FSubFuncID = @NewFuncID where FSubFuncID = @FuncID ;
      end
   end

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【修改】 明细功能
  
   if @FuncName = 'Detail' begin
   
      update t_DataFlowDetailFunc set FSubFuncID = @SubID ,FIndex = @Index ,FFuncName = @Name ,FFuncName_CHT = @Name ,FFuncName_EN = @Name  
      where FDetailFuncID = @FuncID ;
     ----------------------------------------
      if @NewFuncID > 0 begin
         update t_DataFlowDetailFunc set FDetailFuncID = @NewFuncID where FDetailFuncID = @FuncID ;
      end
   end
   
   
  ---------------------------------------------------------------------------------
   update t_DataFlowTimeStamp set FName = FName  -- 更新主控台

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

exec a_ChangeFunc 'Sub'    1201   ,12   ,1 ,0 ,'销售'
   exec a_ChangeFunc 'Detail' 120900 ,1201 ,4 ,0 ,'新增 - 受托加工入库单33'
   
   exec a_Select 't_DataFlowDetailFunc' ,@where = 'FSubFuncID like ''12__''  '  -- 明细功能
                                        ,@Order = 'FSubFuncID,FIndex '

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go