admin
2023-07-12 3166a48f4510573dfe9d1d4ca7017c2f77a2ceec
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
#!/usr/bin/python3
# -*- coding: UTF-8 -*-
import hashlib
import json
import random
import socket
import threading
import time
 
import traderapi
import importlib
import importlib.util
 
# ---------------------------------------专业版-------------------------
# 登录用户
UserID = '00043201'
# 登陆密码
Password = '45249973'
# 投资者账户
InvestorID = '11160150'
# 经济公司部门代码
DepartmentID = '0003'
# 资金账户
AccountID = '00043201'
# 沪市股东账号
SSE_ShareHolderID = 'A00043201'
# 深市股东账号
SZSE_ShareHolderID = '700043201'
 
 
def import_data():
    if importlib.util.find_spec("time"):
        return importlib.import_module("time")
    return None
 
 
# # 登录用户
# UserID = '00572083'
# # 登陆密码
# Password = '16121950'
# # 投资者账户
# InvestorID = '11160150'
# # 经济公司部门代码
# DepartmentID = '0057'
# # 资金账户
# AccountID = '00572083'
# # 沪市股东账号
# SSE_ShareHolderID = 'A00572083'
# # 深市股东账号
# SZSE_ShareHolderID = '700572083'
 
 
class TraderSpi(traderapi.CTORATstpTraderSpi):
    def __init__(self, api):
        traderapi.CTORATstpTraderSpi.__init__(self)
        self.__api = api
        self.__req_id = 0
        self.__front_id = 0
        self.__session_id = 0
 
    def OnFrontConnected(self) -> "void":
        print('OnFrontConnected')
 
        # 获取终端信息
        self.__req_id += 1
        ret = self.__api.ReqGetConnectionInfo(self.__req_id)
        if ret != 0:
            print('ReqGetConnectionInfo fail, ret[%d]' % ret)
 
    def OnFrontDisconnected(self, nReason: "int") -> "void":
        print('OnFrontDisconnected: [%d]' % nReason)
 
    def OnRspGetConnectionInfo(self, pConnectionInfoField: "CTORATstpConnectionInfoField",
                               pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('inner_ip_address[%s]' % pConnectionInfoField.InnerIPAddress)
            print('inner_port[%d]' % pConnectionInfoField.InnerPort)
            print('outer_ip_address[%s]' % pConnectionInfoField.OuterIPAddress)
            print('outer_port[%d]' % pConnectionInfoField.OuterPort)
            print('mac_address[%s]' % pConnectionInfoField.MacAddress)
 
            # 请求登录
            login_req = traderapi.CTORATstpReqUserLoginField()
 
            # 支持以用户代码、资金账号和股东账号方式登录
            # (1)以用户代码方式登录
            login_req.LogInAccount = UserID
            login_req.LogInAccountType = traderapi.TORA_TSTP_LACT_UserID
            # (2)以资金账号方式登录
            # login_req.DepartmentID = DepartmentID
            # login_req.LogInAccount = AccountID
            # login_req.LogInAccountType = traderapi.TORA_TSTP_LACT_AccountID
            # (3)以上海股东账号方式登录
            # login_req.LogInAccount = SSE_ShareHolderID
            # login_req.LogInAccountType = traderapi.TORA_TSTP_LACT_SHAStock
            # (4)以深圳股东账号方式登录
            # login_req.LogInAccount = SZSE_ShareHolderID
            # login_req.LogInAccountType = traderapi.TORA_TSTP_LACT_SZAStock
 
            # 支持以密码和指纹(移动设备)方式认证
            # (1)密码认证
            # 密码认证时AuthMode可不填
            # login_req.AuthMode = traderapi.TORA_TSTP_AM_Password
            login_req.Password = Password
            # (2)指纹认证
            # 非密码认证时AuthMode必填
            # login_req.AuthMode = traderapi.TORA_TSTP_AM_FingerPrint
            # login_req.DeviceID = '03873902'
            # login_req.CertSerial = '9FAC09383D3920CAEFF039'
 
            # 终端信息采集
            # UserProductInfo填写终端名称
            login_req.UserProductInfo = 'jiabei'
            # 按照监管要求填写终端信息
            login_req.TerminalInfo = 'PC;IIP=000.000.000.000;IPORT=00000;LIP=x.xx.xxx.xxx;MAC=123ABC456DEF;HD=XXXXXXXXXX'
            # 以下内外网IP地址若不填则柜台系统自动采集,若填写则以终端填值为准报送
            # login_req.MacAddress = '5C-87-9C-96-F3-E3'
            # login_req.InnerIPAddress = '10.0.1.102'
            # login_req.OuterIPAddress = '58.246.43.50'
 
            self.__req_id += 1
            ret = self.__api.ReqUserLogin(login_req, self.__req_id)
            if ret != 0:
                print('ReqUserLogin fail, ret[%d]' % ret)
 
        else:
            print('GetConnectionInfo fail, [%d] [%d] [%s]!!!' % (
                nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspUserLogin(self, pRspUserLoginField: "traderapi.CTORATstpRspUserLoginField",
                       pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('Login success! [%d]' % nRequestID)
 
            self.__front_id = pRspUserLoginField.FrontID
            self.__session_id = pRspUserLoginField.SessionID
 
            if 0:
                # 修改密码
                req_field = traderapi.CTORATstpUserPasswordUpdateField()
                req_field.UserID = UserID
                req_field.OldPassword = Password
                req_field.NewPassword = '123456'
 
                self.__req_id += 1
                ret = self.__api.ReqUserPasswordUpdate(req_field, self.__req_id)
                if ret != 0:
                    print('ReqUserPasswordUpdate fail, ret[%d]' % ret)
                return
 
            if 0:
                # 查询合约
                req_field = traderapi.CTORATstpQrySecurityField()
 
                # 以下字段不填表示不设过滤条件,即查询全部合约
                # req_field.ExchangeID = traderapi.TORA_TSTP_EXD_SSE
                # req_field.SecurityID = '600000'
 
                self.__req_id += 1
                ret = self.__api.ReqQrySecurity(req_field, self.__req_id)
                if ret != 0:
                    print('ReqQrySecurity fail, ret[%d]' % ret)
 
            if 1:
                # 查询投资者
                req_field = traderapi.CTORATstpQryInvestorField()
 
                # 以下字段不填表示不设过滤条件
                # req_field.InvestorID = InvestorID
 
                self.__req_id += 1
                ret = self.__api.ReqQryInvestor(req_field, self.__req_id)
                if ret != 0:
                    print('ReqQryInvestor fail, ret[%d]' % ret)
 
            if 1:
                # 查询股东账号
                req_field = traderapi.CTORATstpQryShareholderAccountField()
 
                # 以下字段不填表示不设过滤条件,即查询所有股东账号
                # req_field.ExchangeID = traderapi.TORA_TSTP_EXD_SSE
 
                self.__req_id += 1
                ret = self.__api.ReqQryShareholderAccount(req_field, self.__req_id)
                if ret != 0:
                    print('ReqQryShareholderAccount fail, ret[%d]' % ret)
 
            if 0:
                # 查询资金账号
                req_field = traderapi.CTORATstpQryTradingAccountField()
 
                # 以下字段不填表示不设过滤条件,即查询所有资金账号
                req_field.InvestorID = InvestorID
                req_field.DepartmentID = DepartmentID
                req_field.AccountID = AccountID
 
                self.__req_id += 1
                ret = self.__api.ReqQryTradingAccount(req_field, self.__req_id)
                if ret != 0:
                    print('ReqQryTradingAccount fail, ret[%d]' % ret)
 
            if 0:
                # 查询报单
                req_field = traderapi.CTORATstpQryOrderField()
 
                # 以下字段不填表示不设过滤条件,即查询所有报单
                # req_field.SecurityID = '600000'
                # req_field.InsertTimeStart = '09:35:00'
                # req_field.InsertTimeEnd = '10:00:00'
 
                # IsCancel字段填1表示只查询可撤报单
                req_field.IsCancel = 1
 
                self.__req_id += 1
                ret = self.__api.ReqQryOrder(req_field, self.__req_id)
                if ret != 0:
                    print('ReqQryOrder fail, ret[%d]' % ret)
 
            if 1:
                # 查询持仓
                req_field = traderapi.CTORATstpQryPositionField()
 
                # 以下字段不填表示不设过滤条件,即查询所有持仓
                # req_field.SecurityID = '600000'
 
                self.__req_id += 1
                ret = self.__api.ReqQryPosition(req_field, self.__req_id)
                if ret != 0:
                    print('ReqQryPosition fail, ret[%d]' % ret)
 
            if 0:
                req_field = traderapi.CTORATstpQryTradeField()
                self.__req_id += 1
                ret = api.ReqQryTrade(req_field, self.__req_id)
                if ret != 0:
                    raise Exception('ReqQryTrade fail, ret[%d]' % ret)
 
            if 0:
                # 请求报单
                req_field = traderapi.CTORATstpInputOrderField()
 
                req_field.ExchangeID = traderapi.TORA_TSTP_EXD_SSE
                req_field.ShareholderID = SSE_ShareHolderID
                req_field.SecurityID = '601985'
                req_field.Direction = traderapi.TORA_TSTP_D_Sell
                req_field.VolumeTotalOriginal = 700
 
                '''
                上交所支持限价指令和最优五档剩撤、最优五档剩转限两种市价指令,对于科创板额外支持本方最优和对手方最优两种市价指令和盘后固定价格申报指令
                深交所支持限价指令和立即成交剩余撤销、全额成交或撤销、本方最优、对手方最优和最优五档剩撤五种市价指令
                限价指令和上交所科创板盘后固定价格申报指令需填写报单价格,其它市价指令无需填写报单价格
                以下以上交所限价指令为例,其它指令参考开发指南相关说明填写OrderPriceType、TimeCondition和VolumeCondition三个字段:
                '''
                req_field.LimitPrice = 6.69
                req_field.OrderPriceType = traderapi.TORA_TSTP_OPT_LimitPrice
                req_field.TimeCondition = traderapi.TORA_TSTP_TC_GFD
                req_field.VolumeCondition = traderapi.TORA_TSTP_VC_AV
 
                '''
                OrderRef为报单引用,类型为整型,该字段报单时为选填
                若不填写,则系统会为每笔报单自动分配一个报单引用
                若填写,则需保证同一个TCP会话下报单引用严格单调递增,不要求连续递增,至少需从1开始编号
                '''
                # req_field.OrderRef = 1
 
                '''
                InvestorID为选填,若填写则需保证填写正确
                Operway为委托方式,根据券商要求填写,无特殊说明置空即可
                终端自定义字段,终端可根据需要填写如下字段的值,该字段值不会被柜台系统修改,在报单回报和查询报单时返回给终端
                '''
                # req_field.SInfo = 'sinfo'
                # req_field.IInfo = 123
 
                '''
                其它字段置空
                '''
 
                self.__req_id += 1
                ret = self.__api.ReqOrderInsert(req_field, self.__req_id)
                if ret != 0:
                    print('ReqOrderInsert fail, ret[%d]' % ret)
 
            if 0:
                # 请求撤单
                req_field = traderapi.CTORATstpInputOrderActionField()
 
                req_field.ExchangeID = traderapi.TORA_TSTP_EXD_SSE
                req_field.ActionFlag = traderapi.TORA_TSTP_AF_Delete
 
                # 撤单支持以下两种方式定位原始报单:
                # (1)报单引用方式
                # req_field.FrontID = self.__front_id
                # req_field.SessionID = self.__session_id
                # req_field.OrderRef = 1
                # (2)系统报单编号方式
                req_field.OrderSysID = '110019400000005'
 
                # OrderActionRef报单操作引用,用法同报单引用,可根据需要选填
 
                '''
                终端自定义字段,终端可根据需要填写如下字段的值,该字段值不会被柜台系统修改,在查询撤单时返回给终端
                '''
                # req_field.SInfo = 'sinfo'
                # req_field.IInfo = 123
 
                '''
                委托方式字段根据券商要求填写,无特殊说明置空即可
                其它字段置空
                '''
 
                self.__req_id += 1
                ret = self.__api.ReqOrderAction(req_field, self.__req_id)
                if ret != 0:
                    print('ReqOrderAction fail, ret[%d]' % ret)
 
            if 0:
                # 查询集中交易资金
                req_field = traderapi.CTORATstpReqInquiryJZFundField()
 
                req_field.DepartmentID = DepartmentID
                req_field.AccountID = AccountID
                req_field.CurrencyID = traderapi.TORA_TSTP_CID_CNY
 
                self.__req_id += 1
                ret = self.__api.ReqInquiryJZFund(req_field, self.__req_id)
                if ret != 0:
                    print('ReqInquiryJZFund fail, ret[%d]' % ret)
 
            if 0:
                # 资金转移(包括资金调拨和银证转账)
                req_field = traderapi.CTORATstpInputTransferFundField()
 
                req_field.DepartmentID = DepartmentID
                req_field.AccountID = AccountID
                req_field.CurrencyID = traderapi.TORA_TSTP_CID_CNY
                req_field.Amount = 100000.0
 
                '''
                转移方向:
                TORA_TSTP_TRNSD_MoveIn表示资金从集中交易柜台调拨至快速交易柜台
                TORA_TSTP_TRNSD_MoveOut表示资金从快速交易柜台调拨至集中交易柜台
                TORA_TSTP_TRNSD_StockToBank表示证券快速交易系统资金转入银行,即出金
                TORA_TSTP_TRNSD_BankToStock表示银行资金转入证券快速交易系统,即入金
                以下说明各场景下字段填值:
                '''
                # (1)资金从集中交易柜台调拨至快速交易柜台
                req_field.TransferDirection = traderapi.TORA_TSTP_TRNSD_MoveIn
                # (2)资金从快速交易柜台调拨至集中交易柜台
                # req_field.TransferDirection = traderapi.TORA_TSTP_TRNSD_MoveOut
                # (3)证券快速交易系统资金转入银行,需填写银行代码和资金密码
                # req_field.TransferDirection = traderapi.TORA_TSTP_TRNSD_StockToBank
                # req_field.BankID = traderapi.TORA_TSTP_BKID_CCB
                # req_field.AccountPassword = '123456'
                # (4)银行资金转入证券快速交易系统,需填写银行代码和银行卡密码
                # req_field.TransferDirection = traderapi.TORA_TSTP_TRNSD_BankToStock
                # req_field.BankID = traderapi.TORA_TSTP_BKID_CCB
                # req_field.BankPassword = '123456'
 
                '''
                申请流水号ApplySerial字段为选填字段
                若不填写则柜台系统会自动生成一个申请流水号
                若填写则需保证同一个TCP会话下申请流水号不重复
                '''
                # req_field.ApplySerial = 1
 
                self.__req_id += 1
                ret = self.__api.ReqTransferFund(req_field, self.__req_id)
                if ret != 0:
                    print('ReqTransferFund fail, ret[%d]', ret)
 
            if 0:
                '''登出,目前登出成功连接会立即被柜台系统断开,终端不会收到OnRspUserLogout应答
                连接断开后接口内部会触发重新连接,为不使连接成功后又触发重新登录,需终端做好逻辑控制
                一般情况下若希望登出,直接调用Release接口即可,释放成功连接将被终端强制关闭,Release接口调用注意事项见下文说明
                '''
                req_field = traderapi.CTORATstpUserLogoutField()
 
                self.__req_id += 1
                ret = self.__api.ReqUserLogout(req_field, self.__req_id)
                if ret != 0:
                    print('ReqUserLogout fail, ret[%d]' % ret)
        else:
            print('Login fail!!! [%d] [%d] [%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
        return
 
    def OnRspUserPasswordUpdate(self, pUserPasswordUpdateField: "CTORATstpUserPasswordUpdateField",
                                pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('OnRspUserPasswordUpdate: OK! [%d]' % nRequestID)
        else:
            print('OnRspUserPasswordUpdate: Error! [%d] [%d] [%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspOrderInsert(self, pInputOrderField: "CTORATstpInputOrderField", pRspInfoField: "CTORATstpRspInfoField",
                         nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('OnRspOrderInsert: OK! [%d] [%s]' % (nRequestID, pInputOrderField.SInfo))
        else:
            print('OnRspOrderInsert: Error! [%d] [%d] [%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspOrderAction(self, pInputOrderActionField: "CTORATstpInputOrderActionField",
                         pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('OnRspOrderAction: OK! [%d]' % nRequestID)
        else:
            print('OnRspOrderAction: Error! [%d] [%d] [%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspInquiryJZFund(self, pRspInquiryJZFundField: "CTORATstpRspInquiryJZFundField",
                           pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('OnRspInquiryJZFund: OK! [%d] [%.2f] [%.2f]'
                  % (nRequestID, pRspInquiryJZFundField.UsefulMoney, pRspInquiryJZFundField.FetchLimit))
        else:
            print('OnRspInquiryJZFund: Error! [%d] [%d] [%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspTransferFund(self, pInputTransferFundField: "CTORATstpInputTransferFundField",
                          pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int") -> "void":
        if pRspInfoField.ErrorID == 0:
            print('OnRspTransferFund: OK! [%d]' % nRequestID)
        else:
            print('OnRspTransferFund: Error! [%d] [%d] [%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRtnOrder(self, pOrderField: "CTORATstpOrderField") -> "void":
        print(
            '[%d]  OnRtnOrder: InvestorID[%s] SecurityID[%s] OrderRef[%d] OrderLocalID[%s] LimitPrice[%.2f] VolumeTotalOriginal[%d] OrderSysID[%s] OrderStatus[%s] StatusMsg[%s]'
            % (round(time.time() * 1000), pOrderField.InvestorID, pOrderField.SecurityID, pOrderField.OrderRef,
               pOrderField.OrderLocalID,
               pOrderField.LimitPrice, pOrderField.VolumeTotalOriginal, pOrderField.OrderSysID,
               pOrderField.OrderStatus, pOrderField.StatusMsg))
 
    def OnRtnTrade(self, pTradeField: "CTORATstpTradeField") -> "void":
        print(
            'OnRtnTrade: TradeID[%s] InvestorID[%s] SecurityID[%s] OrderRef[%d] OrderLocalID[%s] Price[%.2f] Volume[%d]'
            % (pTradeField.TradeID, pTradeField.InvestorID, pTradeField.SecurityID,
               pTradeField.OrderRef, pTradeField.OrderLocalID, pTradeField.Price, pTradeField.Volume))
 
    def OnRtnMarketStatus(self, pMarketStatusField: "CTORATstpMarketStatusField") -> "void":
        print('OnRtnMarketStatus: MarketID[%s] MarketStatus[%s]'
              % (pMarketStatusField.MarketID, pMarketStatusField.MarketStatus))
 
    def OnRspQrySecurity(self, pSecurityField: "CTORATstpSecurityField", pRspInfoField: "CTORATstpRspInfoField",
                         nRequestID: "int", bIsLast: "bool") -> "void":
        if bIsLast != 1:
            print(
                'OnRspQrySecurity[%d]: SecurityID[%s] SecurityName[%s] MarketID[%s] OrderUnit[%s] OpenDate[%s] UpperLimitPrice[%.2f] LowerLimitPrice[%.2f]'
                % (nRequestID, pSecurityField.SecurityID, pSecurityField.SecurityName, pSecurityField.MarketID,
                   pSecurityField.OrderUnit, pSecurityField.OpenDate, pSecurityField.UpperLimitPrice,
                   pSecurityField.LowerLimitPrice))
        else:
            print('查询合约结束[%d] ErrorID[%d] ErrorMsg[%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspQryInvestor(self, pInvestorField: "CTORATstpInvestorField", pRspInfoField: "CTORATstpRspInfoField",
                         nRequestID: "int", bIsLast: "bool") -> "void":
        if bIsLast != 1:
            print('OnRspQryInvestor[%d]: InvestorID[%s]  Operways[%s]'
                  % (nRequestID, pInvestorField.InvestorID,
                     pInvestorField.Operways))
        else:
            print('查询投资者结束[%d] ErrorID[%d] ErrorMsg[%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspQryShareholderAccount(self, pShareholderAccountField: "CTORATstpShareholderAccountField",
                                   pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int",
                                   bIsLast: "bool") -> "void":
        if bIsLast != 1:
            print('OnRspQryShareholderAccount[%d]: InvestorID[%s] ExchangeID[%s] ShareholderID[%s]'
                  % (nRequestID, pShareholderAccountField.InvestorID, pShareholderAccountField.ExchangeID,
                     pShareholderAccountField.ShareholderID))
        else:
            print('查询股东账户结束[%d] ErrorID[%d] ErrorMsg[%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspQryTradingAccount(self, pTradingAccountField: "CTORATstpTradingAccountField",
                               pRspInfoField: "CTORATstpRspInfoField", nRequestID: "int", bIsLast: "bool") -> "void":
        if bIsLast != 1:
            print(
                'OnRspQryTradingAccount[%d]: DepartmentID[%s] InvestorID[%s] AccountID[%s] CurrencyID[%s] UsefulMoney[%.2f] FetchLimit[%.2f]'
                % (nRequestID, pTradingAccountField.DepartmentID, pTradingAccountField.InvestorID,
                   pTradingAccountField.AccountID, pTradingAccountField.CurrencyID,
                   pTradingAccountField.UsefulMoney, pTradingAccountField.FetchLimit))
        else:
            print('查询资金账号结束[%d] ErrorID[%d] ErrorMsg[%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspQryOrder(self, pOrderField: "CTORATstpOrderField", pRspInfoField: "CTORATstpRspInfoField",
                      nRequestID: "int", bIsLast: "bool") -> "void":
        if bIsLast != 1:
            print(
                'OnRspQryOrder[%d]: SecurityID[%s] OrderLocalID[%s] OrderRef[%d] OrderSysID[%s] VolumeTraded[%d] OrderStatus[%s] OrderSubmitStatus[%s], StatusMsg[%s]'
                % (nRequestID, pOrderField.SecurityID, pOrderField.OrderLocalID, pOrderField.OrderRef,
                   pOrderField.OrderSysID,
                   pOrderField.VolumeTraded, pOrderField.OrderStatus, pOrderField.OrderSubmitStatus,
                   pOrderField.StatusMsg))
        else:
            print('查询报单结束[%d] ErrorID[%d] ErrorMsg[%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
    def OnRspQryPosition(self, pPositionField: "CTORATstpPositionField", pRspInfoField: "CTORATstpRspInfoField",
                         nRequestID: "int", bIsLast: "bool") -> "void":
        if bIsLast != 1:
            print('OnRspQryPosition[%d]: InvestorID[%s] SecurityID[%s] HistoryPos[%d] TodayBSPos[%d] TodayPRPos[%d]'
                  % (nRequestID, pPositionField.InvestorID, pPositionField.SecurityID, pPositionField.HistoryPos,
                     pPositionField.TodayBSPos, pPositionField.TodayPRPos))
        else:
            print('查询持仓结束[%d] ErrorID[%d] ErrorMsg[%s]'
                  % (nRequestID, pRspInfoField.ErrorID, pRspInfoField.ErrorMsg))
 
        # 查询成交响应,参数pTradeField是一个CTORATstpTradeField类对象
 
    def OnRspQryTrade(self, pTradeField: "CTORATstpTradeField", pRspInfoField: "CTORATstpRspInfoField",
                      nRequestID: "int", bIsLast: "bool") -> "void":
        print("查询成交响应")
        if not bIsLast:
            print(pTradeField.OrderSysID)
        else:
            pass
 
 
def __send_msg(data):
    # 签名
    list_str = []
    for k in data:
        list_str.append(f"{k}={data[k]}")
    list_str.sort()
    __str = "&".join(list_str) + "JiaBei@!*."
    md5 = hashlib.md5(__str.encode(encoding='utf-8')).hexdigest()
    data["sign"] = md5
    # 生成socket,连接server
    ip_port = ("127.0.0.1", 9002)  # server地址和端口号(最好是10000以后)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(json.dumps(data).encode("utf-8"))
    rec = client.recv(1024000)
    result = rec.decode("gbk")
    client.close()
    return result
 
 
def __buy():
    data = {"type": 0, "req_id": f"test-{random.randint(0, 10000)}",
            "data": json.dumps({"code": "002146", "count": 1000, "price": 1.29})}
    result = __send_msg(data)
    print("下单结果", json.loads(result))
 
 
def __cancel_buy():
    data = {"type": 1, "req_id": f"test-{random.randint(0, 10000)}",
            "data": json.dumps({"code": "002146", "order_sys_id": "12002P900020732"})}
    result = __send_msg(data)
    print("取消订单", json.loads(result))
 
 
def __list_delegate():
    data = {"type": 2, "req_id": f"test-{random.randint(0, 10000)}"}
    result_str = __send_msg(data)
    result_json = json.loads(result_str)
    print("可撤委托列表", result_json)
    if result_json["code"] == 0:
        for item in result_json["data"]:
            print(item)
    else:
        print(result_json['msg'])
 
 
def __list_traded():
    data = {"type": 3, "req_id": f"test-{random.randint(0, 10000)}"}
    result = __send_msg(data)
    result = json.loads(result)
    print("已成交列表")
    for item in result["data"]:
        print(item)
 
 
def __list_position():
    data = {"type": 4, "req_id": f"test-{random.randint(0, 10000)}"}
    result = __send_msg(data)
    result = json.loads(result)
    print("持仓列表")
    for item in result["data"]:
        print(item)
 
 
def test1(index, sk):
    st = ""
    for i in range(20):
        st += f"{index}"
    sk.sendall(json.dumps({"type": st}).encode("utf-8"))
 
 
def analyse_l2():
    datas = []
    with open("C:\\Users\\Administrator\\Desktop\\草稿\\orderdetail.2023-06-26.log", mode="r", encoding="utf-8") as f:
        while True:
            line = f.readline()
            if not line:
                break
            if line.find("600310#") < 0:
                continue
            line = line.split("600310#")[1]
            datas += eval(line)
    count = 0
    for d in datas:
        # if "TradePrice" in d and d["TradePrice"] > 0:
        #     continue
        time_str = f"{d[5]}"
        if time_str.startswith("9"):
            time_str = f"0{time_str}"
        # print(d)
        # if d[7] > 3389325 and d[7] < 3389759:
        count += 1
        print(f"{time_str[0:2]}:{time_str[2:4]}:{time_str[4:6]}", d[2] // 100, d)
    print("总数", count)
 
 
if __name__ == '__main__1':
    analyse_l2()
 
 
def order():
    ip_port = ("111.230.16.67", 10008)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(
        json.dumps({"type": "test_buy",
                    "data": {"code": "002426", "price": 2.49, "volume": 100}}).encode(
            "utf-8"))
    # rec = client.recv(1024000)
    # result = rec.decode("utf-8")
    # print(result)
    client.close()
 
 
def sell():
    ip_port = ("111.230.16.67", 10008)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(
        json.dumps({"type": "test_sell",
                    "data": {"code": "600578", "price": 3.85, "volume": 100, "price_type": 5}}).encode(
            "utf-8"))
 
    client.close()
 
 
def cancel():
    ip_port = ("111.230.16.67", 10008)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(
        json.dumps({"type": "test_cancel",
                    "data": {"code": "002426", "orderSysID": "12002A190000782"}}).encode(
            "utf-8"))
    # rec = client.recv(1024000)
    # result = rec.decode("utf-8")
    # print(result)
    client.close()
 
 
def query():
    ip_port = ("111.230.16.67", 10009)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(
        json.dumps({"type": "test", "sign": ''}).encode(
            "utf-8"))
    # rec = client.recv(1024000)
    # result = rec.decode("utf-8")
    # print(result)
    client.close()
 
 
def update():
    ip_port = ("111.230.16.67", 10009)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(
        json.dumps({"type": "sync_trade_data", "data": {"type": "delegate_list"}, "sign": ''}).encode(
            "utf-8"))
    # rec = client.recv(1024000)
    # result = rec.decode("utf-8")
    # print(result)
    client.close()
 
 
#
 
 
if __name__ == '__main__':
    # sell()
    # order()
 
    # cancel()
    update()
 
if __name__ == '__main__1':
    # ip_port = ("111.230.16.67", 10008)  # server地址和端口号(最好是10000以后)
    ip_port = ("111.230.16.67", 10008)
    client = socket.socket()  # 生成socket,连接server
    client.connect(ip_port)
    client.send(
        json.dumps({"type": "test_l2",
                    "data": [("000570", 80000, 6.11)]}).encode(
            "utf-8"))
    # rec = client.recv(1024000)
    # result = rec.decode("utf-8")
    # print(result)
    client.close()
 
    # __buy()
    # __cancel_buy()
    # __list_delegate()
    # __list_traded()
    # __list_position()
    # if 1>0:
    #     return;
 
    # print("初始化交易服务器")
    # api = traderapi.CTORATstpTraderApi.CreateTstpTraderApi('./flow', False)
    # # 创建回调对象
    # spi = TraderSpi(api)
    # # 注册回调接口
    # api.RegisterSpi(spi)
    #
    # # 注册多个交易前置服务地址,用逗号隔开
    # # api.RegisterFront('tcp://10.0.1.101:6500,tcp://10.0.1.101:26500')
    # # 注册名字服务器地址,支持多服务地址逗号隔开
    # # api.RegisterNameServer('tcp://10.0.1.101:52370')
    # # api.RegisterNameServer('tcp://10.0.1.101:52370,tcp://10.0.1.101:62370')
    #
    # if 1:  # 模拟环境,TCP 直连Front方式
    #     # 注册单个交易前置服务地址
    #     TD_TCP_FrontAddress = "tcp://210.14.72.21:4400"  # 仿真交易环境
    #     # TD_TCP_FrontAddress = "tcp://210.14.72.15:4400"  # 24小时环境A套
    #     # TD_TCP_FrontAddress="tcp://210.14.72.16:9500" #24小时环境B套
    #     api.RegisterFront(TD_TCP_FrontAddress)
    #     # 注册多个交易前置服务地址,用逗号隔开 形如: api.RegisterFront("tcp://10.0.1.101:6500,tcp://10.0.1.101:26500")
    #     print("TD_TCP_FensAddress[sim or 24H]::%s\n" % TD_TCP_FrontAddress)
    #
    # else:  # 模拟环境,FENS名字服务器方式
    #     TD_TCP_FensAddress = "tcp://210.14.72.21:42370";  # 模拟环境通用fens地址
    #     '''********************************************************************************
    #         * 注册 fens 地址前还需注册 fens 用户信息,包括环境编号、节点编号、Fens 用户代码等信息
    #         * 使用名字服务器的好处是当券商系统部署方式发生调整时外围终端无需做任何前置地址修改
    #         * *****************************************************************************'''
    #     fens_user_info_field = traderapi.CTORATstpFensUserInfoField()
    #     fens_user_info_field.FensEnvID = "stock"  # 必填项,暂时固定为“stock”表示普通现货柜台
    #     fens_user_info_field.FensNodeID = "sim"  # 必填项,生产环境需按实际填写,仿真环境为sim
    #     fens_user_info_field.FensNodeID, = "24a"  # 必填项,生产环境需按实际填写,24小时A套环境为24a
    #     # fens_user_info_field.FensNodeID="24b" #必填项,生产环境需按实际填写,24小时B套环境为24b
    #     api.RegisterFensUserInfo(fens_user_info_field)
    #     api.RegisterNameServer(TD_TCP_FensAddress)
    #     # 注册名字服务器地址,支持多服务地址逗号隔开 形如:api.RegisterNameServer('tcp://10.0.1.101:52370,tcp://10.0.1.101:62370')
    #     print("TD_TCP_FensAddress[%s]::%s\n" % (fens_user_info_field.FensNodeID, TD_TCP_FensAddress))
    #
    # # 订阅私有流
    # api.SubscribePrivateTopic(traderapi.TORA_TERT_QUICK)
    # # 订阅公有流
    # api.SubscribePublicTopic(traderapi.TORA_TERT_QUICK)
    # # 启动接口
    # api.Init()
    # input()