username@email.com
2025-01-23 ee87c4ceb1a22800f8151db590bc732ca21158c6
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
41
42
43
44
45
46
47
48
49
ÿþUSE [ECTEST]
GO
 
DECLARE    @return_value int,
        @pageCount int,
        @recordCount bigint
 
EXEC    @return_value = [dbo].[sp_EC_OrderBasic_Search_Seller]
        @pageIndex = 1,
        @pageSize = 20,
        @pageCount = @pageCount OUTPUT,
        @recordCount = @recordCount OUTPUT,
        @buyerId = NULL,
        @buyerId1 = NULL,
        @sellerId = '88b49967-d590-452c-93c6-0049a75fa5ff',
        @orderId = NULL,
        @buyerName = NULL,
        @SellerName = NULL,
        @createTimeBegin = '2021-09-01',
        @createTimeEnd = '2021-09-16',
        @printType = NULL,
        @orderType = NULL,
        @orderState = NULL,
        @orderPayState = NULL,
        @creater = NULL,
        @customerLevel = NULL,
        @customerManager = NULL,
        @businessManager = NULL,
        @payType = NULL,
        @returnvisit = NULL,
        @appraise = NULL,
        @IsStaff = 1,
        @StaffMemberId = '764152ee-1184-44df-a8b2-316faff0d3e4',
        @StaffId = 2,
        @StaffName = N'ùfeP',
        @KaipiaoshenqingTimeStart = NULL,
        @KaipiaoshenqingTimeEnd = NULL,
        @Kaipiaoshenqing = NULL,
        @Kehuqianshou = NULL,
        @KaipiaoshenqingId = NULL,
        @DocumentName = NULL
 
SELECT    @pageCount as N'@pageCount',
        @recordCount as N'@recordCount'
 
SELECT    'Return Value' = @return_value
 
GO