Editplus 570_4325_key

 

editplus 5.7 build 4352 :
Vovan
3AG46-JJ48E-CEACC-8E6EW-ECUAW

 

 

Editplus 570_4325_key:
username: shejidu
regcode: 8QCCW-CQYUJ-ENUUC-U2W8S-UCWCJ

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
CREATE procedure [IA_CalDif]
@bBusiness bit,
@bDif bit,
@bRdFlag bit,
@PPrice float,
@RPrice float,
@Debit float=null output,
@Credit float=null output
 WITH ENCRYPTION as
    If @bRdFlag=1
    begin
            If @bBusiness=0
            begin
                    If @bDif=0
                begin
                            set @Debit = round(@RPrice - @PPrice,2)
                            set @Credit = Null
                End
                    Else
                begin
                            set @Credit = round(@PPrice - @RPrice,2)
                            set @Debit = Null
                            If Abs(@PPrice) < Abs(@RPrice)
                    begin
                                set @Debit = -1 * @Credit
                                set @Credit = Null
                            End
                End
            End
            Else
            begin
                    set @Credit = round(@PPrice - @RPrice,2)
                    set @Debit = Null
            End
    End
    Else
        If @bBusiness=0
            set @Credit = Round(@RPrice - @PPrice, 2)
        Else
            set @Debit = Round(@PPrice - @RPrice, 2)

  

posted @   samrv  阅读(194)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示