新增文章

文章标题分类内容

declare @fcheck_fail int
   declare @fsrccommitfield_prevalue decimal(28,13)
   declare @fsrccommitfield_endvalue decimal(28,13)
   declare @maxorder int 
   
   update src 
      set @fsrccommitfield_prevalue = isnull(src.fcommitqty,0),
          @fsrccommitfield_endvalue = @fsrccommitfield_prevalue + dest.fqty,
          @maxorder = (select fvalue from t_systemprofile where fcategory='ic' and fkey='cqtylargerseqty'),
          @fcheck_fail = case isnull(@maxorder,0) when 1 then 0 else (case when (abs(src.fqty)>abs(@fsrccommitfield_prevalue) or abs(src.fqty)>abs(@fsrccommitfield_endvalue)) then @fcheck_fail else -1 end) end,
          
        src.fcommitqty=@fsrccommitfield_endvalue,
        src.fauxcommitqty=@fsrccommitfield_endvalue/cast(t1.fcoefficient as float)
        
    from seorderentry src 
    inner join seorder srchead on src.finterid=srchead.finterid
    inner join (
        select u1.fsourceinterid as fsourceinterid,u1.fsourceentryid,u1.fitemid,sum(u1.fqty) as fqty
        from  icstockbillentry u1 
        where u1.finterid=1783
        group by u1.fsourceinterid,u1.fsourceentryid,u1.fitemid
        
     ) dest on dest.fsourceinterid = src.finterid and dest.fitemid = src.fitemid and src.fentryid = dest.fsourceentryid
    
    inner join t_measureunit t1 on src.funitid=t1.fitemid
    
    
   if (isnull(@fcheck_fail,0)=-1) 
      raiserror('可能的原因是：
    1、所选单据已被其他单据关联
    2、所选单据已被反审核
    3、当前单据和所选单据的关联数量超过了所选单据的数量
    4、所选单据已经关闭',18,18)
   else
   if exists (
       select 1 from seorder src right join  (select u1.fsourceinterid as fsourceinterid,u1.fsourceentryid,u1.fitemid,sum(u1.fqty) as fqty
       from  icstockbillentry u1 
       where u1.finterid=1783
       group by u1.fsourceinterid,u1.fsourceentryid,u1.fitemid) dest on dest.fsourceinterid = src.finterid where dest.fsourceinterid>0 and src.finterid is null
    )
    raiserror('所选单据已被删除',18,18)