请问一下,为什么我这个修改的金额,
合计金额等于总金额,查询得到的,
折扣查询统计得到的,@shengyuheji等于合计金额-折扣(例如:100-1=99)对不
但是,我执行算出来(100-1=97),这个折扣我在外面执行出来都是对的,就很神奇
alter trigger KK_SaleBillVouch_up on SaleBillVouch
after update
as
BEGIN
declare @heji DECIMAL
declare @zhekou DECIMAL
declare @kehu varchar(50)
declare @shengyuheji DECIMAL;
IF EXISTS
(select 1 from inserted s WITH (NOLOCK) LEFT JOIN SaleBillVouch sbv WITH (NOLOCK) on s.SBVID=sbv.SBVID
LEFT JOIN SaleBillVouchs sbvs on sbv.SBVID=sbvs.SBVID where 1=1 and sbv.dverifydate is not null and sbv.cInvalider is null)
BEGIN
select @kehu=cus.ccusCode,@heji=cus.cCusDefine13,@zhekou=(sum(sbvs.iDisCount))
from inserted s LEFT JOIN
SaleBillVouch sbv
on s.SBVID=sbv.SBVID
left join SaleBillVouchs sbvs on sbv.SBVID=sbvs.SBVID LEFT JOIN Customer cus on sbv.cCusCode=cus.cCusCode
where 1=1
and sbv.dverifydate is not null
GROUP BY cus.ccusCode,cus.cCusDefine13
set @shengyuheji=(@heji-@zhekou)/3
IF(@heji!=0) or (@shengyuheji >=0)
BEGIN
update Customer set cCusDefine13=@shengyuheji where cCusCode=@kehu
end
end