在线精品亚洲一区二区绿巨人,亚洲精品456在线播放,337P日本欧洲亚洲大胆色噜噜,十八禁无码免费网站

北京松源偉立科技有限公司

咨詢熱線:158-0117-0786
咨詢直線:158-0117-0786
公司傳真:
公司網(wǎng)址: dicasdavida.com
公司地址:北京市朝陽區(qū)區(qū)芍藥居北里
首頁  ?   知識庫  ?  用友T1   ?  用友商貿(mào)寶錄入單據(jù)提示系統(tǒng)忙解決方法

用友商貿(mào)寶錄入單據(jù)提示系統(tǒng)忙解決方法

來源:原創(chuàng) 發(fā)布時間:2017-03-21 14:59:08
在查詢分析器里找到那個數(shù)據(jù)庫打上一下的補丁

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER                           PROCEDURE [P_GetBillSN] 
@i_MacMark varchar(30),
@i_BillType int,
@i_BillDate varchar(10),
@i_OperID int,
@i_DftOper int   = -1,    
@i_BillSN varchar(100)  = \'\',    
@o_BillSN varchar(100) output
AS
Declare @Result  int,
@Rule1  int,
@Rule2  int,
@Rule3  int,
@Rule4  int,
@DispMac bit,
@Sign1  varchar(30),
@Sign2  varchar(30),
@Sign3  varchar(30),
@Sign4  varchar(30),
@Sign5  varchar(30),
@Sign6  varchar(30),
@Sign7  varchar(30),
@Sign8  varchar(30),
@Sign9  varchar(30),
@Sign10  varchar(30),
@OperCode varchar(50),
@tmpSN  varchar(100)
Declare @tmpSign varchar(30),
@j  int,
@TranSyb smallint

set nocount on
-- \'P_GetBillSN\'
set @i_BillSN = isNull(@i_BillSN, \'\')
if @i_DftOper = -2
begin
set @TranSyb = 0
set @i_DftOper = -1
end else
set @TranSyb = 1
if (@i_BillSN = \'\') and (@TranSyb = 1)
begin
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 
begin tran GetBillSNPrc
end
Select @OperCode=u_Code from Employee where s_ID=@i_OperID
Select @Rule1=Rule1, @Rule2=Rule2, @Rule3=Rule3, @Rule4=Rule4, @DispMac=MacMark from BillSNRule where s_ID=1

Select @Sign1=IsNull(Sign1,\'\'), @Sign2=IsNull(Sign2,\'\'), @Sign3=IsNull(Sign3,\'\'), @Sign4=IsNull(Sign4,\'\'), @Sign5=IsNull(Sign5,\'\'), @Sign6=IsNull(Sign6,\'\'), 
       @Sign7=IsNull(Sign7,\'\'), @Sign8=IsNull(Sign8,\'\'), @Sign9=IsNull(Sign9,\'\'), @Sign10=IsNull(Sign10,\'\') 
from BillType where BillType=@i_BillType
set @o_BillSN=\'\'
if @DispMac=1
set @o_BillSN = @i_MacMark + \'-\'
set @j=1
while @j<=10 
begin
select @tmpSign = case @j when 1 then @Sign1 when 2 then @Sign2
      when 3 then @Sign3 when 4 then @Sign4
      when 5 then @Sign5 when 6 then @Sign6
      when 7 then @Sign7 when 8 then @Sign8
      when 9 then @Sign9 when 10 then @Sign10
     end
if @tmpSign<>\'\'
begin
  exec P_SetBillSN @i_MacMark, @i_BillType, @i_BillDate,  @i_OperID, @OperCode, @Rule1, @Rule2, @Rule3, @Rule4, @tmpSign, @i_DftOper, @tmpSN output
  set @o_BillSN=@o_BillSN+@tmpSN
end
set @j=@j+1
end
if ((@i_BillSN=\'\') and (@Rule3=0)) or (@i_BillType in (66, 67)) -- 
begin
exec @Result = P_SetBillCount @i_MacMark, @i_BillDate, @i_BillType, @i_OperID, @Rule1, @Rule2, @Rule3, @Rule4, @i_BillSN
if @@Error<>0 or @Result<0 return -1003
end

---------------------------------------------------------------------------------
Success:
if (@i_BillSN = \'\') and (@TranSyb = 1)
begin
  Commit tran GetBillSNPrc
  SET TRANSACTION ISOLATION LEVEL READ COMMITTED
end
return 0     
Error:
if (@i_BillSN = \'\') and (@TranSyb = 1)
begin
  rollback tran GetBillSNPrc
  SET TRANSACTION ISOLATION LEVEL READ COMMITTED
end
return -1









GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
首頁  |   知識庫  |   軟件產(chǎn)品  |   新聞動態(tài)  |   成功案例  |   解決方案  |   產(chǎn)品下載  |   關(guān)于我們  |   聯(lián)系我們
版權(quán)所有:北京松源偉立科技有限公司   公司地址:北京市朝陽區(qū)區(qū)芍藥居北里   客服信箱: service@bjyongyou.com   熱線:158-0117-0786
關(guān)鍵詞:北京用友軟件,財務(wù)軟件,北京用友,北京財務(wù)軟件,用友軟件,進銷存軟件,會計電算化軟件,用友U8,用友T6,用友T3,用友財務(wù)通,用友企業(yè)管理軟件    京ICP備15017070號-1