优化SQL

czt

2025-06-12 930d29f39d115fe76c305af4320c2acbcb30c445

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
Êþº¾4ê
8qr    st
suv
w
xy
xz    6{|
}~€
‚
ƒ
„…
}†
6‡    ˆ‰Š
ˆ‹Œ    6
Ž    ‘
q
’
“”
•–—˜    s™
 š
›œ
›zž
Ÿ 
Ÿ¡¢
£‚
£ƒ¤
£Ž
£’
¥¦
¥§
¨‚
¨ƒ
¨Ž
¨©ª«
¬­®¯
log
Lorg/slf4j/Logger;
BEAN_ID
Ljava/lang/String;
 ConstantValuep
notifyWebInvoker
(Lcom/ld/igds/io/notify/NotifyWebInvoker;
RuntimeVisibleAnnotations
8Lorg/springframework/beans/factory/annotation/Autowired;
<init>
()V
Code
LineNumberTable
LocalVariableTable
this
4Lcom/ld/igds/protocol/fzzy/command/RemoteCommonImpl;
checkTh
O(Lcom/ld/igds/io/request/CheckThRequest;)Lcom/ld/igds/io/response/BaseResponse;
request
'Lcom/ld/igds/io/request/CheckThRequest;

pullDevice
L(Lcom/ld/igds/io/request/BaseRequest;)Lcom/ld/igds/io/response/BaseResponse;
$Lcom/ld/igds/io/request/BaseRequest;
message
+Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
result
Lcom/ld/io/api/InvokeResult;
 StackMapTable°±
    pullDepot

pullAccess
N(Lcom/ld/igds/io/request/AccessRequest;)Lcom/ld/igds/io/response/BaseResponse;
&Lcom/ld/igds/io/request/AccessRequest;
pullDepotStatus
S(Lcom/ld/igds/io/request/DepotStatusRequest;)Lcom/ld/igds/io/response/BaseResponse;
+Lcom/ld/igds/io/request/DepotStatusRequest;
    heartBeat
readConf
T(Lcom/ld/igds/io/request/GrainSerConfRequest;)Lcom/ld/igds/io/response/BaseResponse;
,Lcom/ld/igds/io/request/GrainSerConfRequest;
    writeConf
    initCable
updateGrainSerCable

destroyCon
checkGrainSerCable
sumGrainSerCable
updateSysDepotConf
<clinit>

SourceFile
RemoteCommonImpl.java
*Lorg/springframework/stereotype/Component;
value
fzzy.remoteCommonServiceDE
$com/ld/igds/io/response/BaseResponse²³´µ¶
协议不支持D·¸¹º»¼:;
:平台------>>>>控制柜：获取控制柜设备信息-{}°½¶¾¿ÀÁ¶ÃÄÅÆÇÈÉÊ˱ÌU
I平台------>>>>控制柜：获取控制柜设备信息-执行失败：{}ͶÎÀ@A϶ÐÑÒ
java/lang/StringBuilderÓ¶ÔÕ
9　远程同步控制柜设备信息，命令执行失败Ö¶×ØÙ
-com/ld/igds/io/response/DeviceControlResponseÚ´DÛÜ¹Ý
:平台------>>>>控制柜：获取控制柜仓库信息-{}
@平台------>>>>控制柜：获取控制柜仓库信息-失败{}Þ¹ß»à
1平台------>>>>控制柜：执行命令发送-{}á
8平台------>>>>控制柜：执行命令发送-失败-{}â¹ã»äåæ¶
. è¿œç¨‹æŽ¨é€ä»“库状态，命令执行失败
2com/ld/igds/protocol/fzzy/command/RemoteCommonImplçèé
0com/ld/igds/protocol/fzzy/command/BaseRemoteImpl
"com/ld/igds/io/RemoteCommonService
)com/ld/igds/protocol/fzzy/dto/SendMessage
com/ld/io/api/InvokeResult
%com/ld/igds/io/constant/OrderRespEnum
ORDER_ERROR
'Lcom/ld/igds/io/constant/OrderRespEnum;
getCode
()Ljava/lang/String;
'(Ljava/lang/String;Ljava/lang/String;)V
:com/ld/igds/protocol/fzzy/builder/PullDeviceCommandBuilder
getInstance
>()Lcom/ld/igds/protocol/fzzy/builder/PullDeviceCommandBuilder;
buildMessage
Q(Lcom/ld/igds/io/request/BaseRequest;)Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
    getStrMsg
org/slf4j/Logger
info
'(Ljava/lang/String;Ljava/lang/Object;)V
"com/ld/igds/io/request/BaseRequest
getIp
getPort
()Ljava/lang/Integer;
java/lang/Integer
intValue
()I

getByteMsg
()[B
send
3(Ljava/lang/String;I[B)Lcom/ld/io/api/InvokeResult;
SUCCESS

getMessage
error
getCompanyId
com/ld/igds/constant/BizType
SYS
Lcom/ld/igds/constant/BizType;

getSerName
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
toString
&com/ld/igds/io/notify/NotifyWebInvoker
    notifyWeb
l(Ljava/lang/String;Lcom/ld/igds/io/constant/OrderRespEnum;Lcom/ld/igds/constant/BizType;Ljava/lang/String;)V
 ORDER_SUCCESS
*(Lcom/ld/igds/io/constant/OrderRespEnum;)V
9com/ld/igds/protocol/fzzy/builder/PullDepotCommandBuilder
=()Lcom/ld/igds/protocol/fzzy/builder/PullDepotCommandBuilder;
:com/ld/igds/protocol/fzzy/builder/PullAccessCommandBuilder
>()Lcom/ld/igds/protocol/fzzy/builder/PullAccessCommandBuilder;
S(Lcom/ld/igds/io/request/AccessRequest;)Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
$com/ld/igds/io/request/AccessRequest
?com/ld/igds/protocol/fzzy/builder/PullDepotStatusCommandBuilder
C()Lcom/ld/igds/protocol/fzzy/builder/PullDepotStatusCommandBuilder;
X(Lcom/ld/igds/io/request/DepotStatusRequest;)Lcom/ld/igds/protocol/fzzy/dto/SendMessage;
)com/ld/igds/io/request/DepotStatusRequest
getDepotName
org/slf4j/LoggerFactory
    getLogger
%(Ljava/lang/Class;)Lorg/slf4j/Logger;!68
9:;<=
>?@A
B
C
DE
F/

*·
±G
H
IJ
KL
FD»Y²¶·°G
&HIJMN

OP
Fäs¸+¶M²    
,¶¹*+¶ +¶¶,¶¶N²-¥:²    -¶¹*´+¶²²»Y·+¶¶¶¶¹» Y²!·"°G+-/*213?4h6H*sIJsMQ
kRS*ITUV
ýhWX
YP
Fäs¸#+¶$M²    %,¶¹*+¶ +¶¶,¶¶N²-¥:²    &-¶¹*´+¶²²»Y·+¶¶¶¶¹» Y²!·"°G<>@*C1D?EhGH*sIJsMQ
kRS*ITUV
ýhWX
Z[
Fäs¸'+¶(M²    ),¶¹*+¶*+¶+¶,¶¶N²-¥:²    ,-¶¹*´+¶-²²»Y·+¶.¶¶¶¹» Y²!·"°GLOQ*T1U?VhXH*sIJsM\
kRS*ITUV
ýhWX
]^
Fäs¸/+¶0M²    ),¶¹*+¶1+¶2¶,¶¶N²-¥:²    ,-¶¹*´+¶3²²»Y·+¶4¶5¶¶¹» Y²!·"°G^`b*e1f?ghjH*sIJsM_
kRS*ITUV
ýhWX
`P
FD»Y²¶·°G
oHIJMQ

ab
FD»Y²¶·°G
tHIJMc

db
FD»Y²¶·°G
yHIJMc

eP
FD»Y²¶·°G
~HIJMQ

fb
FD»Y²¶·°G
ƒHIJMc

gP
FD»Y²¶·°G
ˆHIJMQ

hb
FD»Y²¶·°G
HIJMc

ib
FD»Y²¶·°G
’HIJMc

jP
F6

°G
—HIJMQ
kE
F!
    6¸7³    ±
G
lmB
n
osp