update t_ZJHuiBaoEntry set FDecimal6总有效时长=( case when (FText6机台号='14' Or FText6='15' Or FText6='16' Or FText6='17' Or FText6='18') then round(ftotalmishu总米数*1.8/60/90,2)

when (FText6='08' Or FText6='07' or FText6='06' or FText6='05' or FText6='04' or FText6='03' or FText6='02' or FText6='01' or FText6='10' or FText6='09' or FText6='11' or FText6='12'or FText6='13' or FText6='21' or FText6='22')and FTiaoShu条数<70 and @fnumber物料编码的第一位 = '1' then round(ftotalmishu*0.8/60/300,2)

when (FText6='08' Or FText6='07' or FText6='06' or FText6='05' or FText6='04' or FText6='03' or FText6='02' or FText6='01' or FText6='10' or FText6='09' or FText6='11' or FText6='12'or FText6='13' or FText6='21' or FText6='22')and FTiaoShu<70 and @fnumber = '2' then round(ftotalmishu*0.8/60/150,2)

when (FText6='08' Or FText6='07' or FText6='06' or FText6='05' or FText6='04' or FText6='03' or FText6='02' or FText6='01' or FText6='10' or FText6='09' or FText6='11' or FText6='12'or FText6='13' or FText6='21' or FText6='22')and FTiaoShu>=120 and @fnumber = '1' then round(ftotalmishu*1.2/60/300,2)

when (FText6='08' Or FText6='07' or FText6='06' or FText6='05' or FText6='04' or FText6='03' or FText6='02' or FText6='01' or FText6='10' or FText6='09' or FText6='11' or FText6='12'or FText6='13' or FText6='21' or FText6='22')and FTiaoShu>=120 and @fnumber = '2' then round(ftotalmishu*1.2/60/150,2)

when (FText6='08' Or FText6='07' or FText6='06' or FText6='05' or FText6='04' or FText6='03' or FText6='02' or FText6='01' or FText6='10' or FText6='09' or FText6='11' or FText6='12'or FText6='13' or FText6='21' or FText6='22')and FTiaoShu>=70 and FTiaoShu<120 and @fnumber = '1' then round(ftotalmishu*1/60/300,2)

when (FText6='08' Or FText6='07' or FText6='06' or FText6='05' or FText6='04' or FText6='03' or FText6='02' or FText6='01' or FText6='10' or FText6='09' or FText6='11' or FText6='12'or FText6='13' or FText6='21' or FText6='22')and FTiaoShu>=70 and FTiaoShu<120 and @fnumber = '2' then round(ftotalmishu*1/60/150,2)

else 0 end) from t_ZJHuiBaoEntry where FEntryID=@fentryid and FDecimal9=0

产品问题想问一下能把用触发器写的改成实体服务规则吗？

50 产品问题 想问一下能把用触发器写的改成实体服务规则吗？

恭喜您！

产品问题
想问一下能把用触发器写的改成实体服务规则吗？

50 产品问题想问一下能把用触发器写的改成实体服务规则吗？