2025-04-01 10:59:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 10:59:31 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 10:59:34 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 10:59:48 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 10:59:48 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 10:59:53 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:00:04 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:00:04 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:00:09 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:00:52 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:00:52 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 11:00:55 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:02:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:02:43 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 11:02:49 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-03" } 2025-04-01 11:04:25 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:04:25 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:28:38 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250520", "OpenID":"", "UserID":"ZZJ1" } 2025-04-01 11:29:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:29:56 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:29:59 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:30:42 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 11:30:52 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 11:30:52 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:30:53 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0015", "DoctorCode": "1053", "DoctorName": "袁顺利", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "11:00-12:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040111303834086", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 11:30:53 --- 5003jinru 2025-04-01 11:30:53 --- 5003....1 2025-04-01 11:30:53 --- 5003....yyh30 2025-04-01 11:30:53 --- 5003....用户查询到1105368 2025-04-01 11:30:53 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'袁顺利' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'外科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 11:30:53 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0","DoctorName":"袁顺利","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"外科","HisFlowNo":""} 2025-04-01 11:31:58 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:31:58 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:32:29 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105368", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25040111315386867", "ActTime": "2025-04-01 11:32:23", "FlowNo": "4200002676202504011527448874", "UserID": "ZZJ1" } 2025-04-01 11:32:29 --- 1:36493648612:0.013:24:14DL250401113153868675:2025-04-01 11:32:236:42000026762025040115274488747:ZZJ18: 2025-04-01 11:32:30 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 11:32:30 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:33:52 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:33:52 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:33:56 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105368", "startDate": "2025-03-25", "endDate": "2025-04-01" } 2025-04-01 11:34:19 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105368", "startDate": "2025-03-25", "endDate": "2025-04-01" } 2025-04-01 11:38:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:38:56 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:39:05 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "UserID": "ZZJ1" } 2025-04-01 11:40:17 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:40:17 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:40:19 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:40:22 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 11:40:27 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 11:40:27 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:40:27 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0015", "DoctorCode": "1064", "DoctorName": "袁红健", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040111401225119", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 11:40:27 --- 5003jinru 2025-04-01 11:40:27 --- 5003....1 2025-04-01 11:40:28 --- 5003....yyh30 2025-04-01 11:40:28 --- 5003....用户查询到1105368 2025-04-01 11:40:28 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'袁红健' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'外科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 11:40:28 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.01","DoctorName":"袁红健","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"外科","HisFlowNo":""} 2025-04-01 11:41:19 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:41:19 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:41:21 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:41:25 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 11:41:32 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 11:41:32 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:41:32 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0015", "DoctorCode": "1021", "DoctorName": "王瑞彬", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040111411692579", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 11:41:32 --- 5003jinru 2025-04-01 11:41:32 --- 5003....1 2025-04-01 11:41:32 --- 5003....yyh30 2025-04-01 11:41:32 --- 5003....用户查询到1105368 2025-04-01 11:41:32 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'王瑞彬' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'外科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 11:41:32 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.01","DoctorName":"王瑞彬","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"外科","HisFlowNo":""} 2025-04-01 11:42:59 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:42:59 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:43:03 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105368", "startDate": "2025-03-25", "endDate": "2025-04-01" } 2025-04-01 11:43:13 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105368", "startDate": "2025-03-17", "endDate": "2025-04-01" } 2025-04-01 11:47:09 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:47:09 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:47:41 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105368", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25040111470815201", "ActTime": "2025-04-01 11:47:34", "FlowNo": "4200002632202504018785002667", "UserID": "ZZJ1" } 2025-04-01 11:47:41 --- 1:36493648612:0.013:24:14DL250401114708152015:2025-04-01 11:47:346:42000026322025040187850026677:ZZJ18: 2025-04-01 11:47:42 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 11:47:42 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:53:11 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:53:11 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:53:14 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 11:53:20 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0064", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 11:53:25 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj02" } 2025-04-01 11:53:25 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:53:25 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0064", "DoctorCode": "2038", "DoctorName": "李秀君", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "15:00-16:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040111530988152", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 11:53:25 --- 5003jinru 2025-04-01 11:53:25 --- 5003....1 2025-04-01 11:53:26 --- 5003....yyh30 2025-04-01 11:53:26 --- 5003....用户查询到1105368 2025-04-01 11:53:26 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'李秀君' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'眼科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 11:53:26 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.02","DoctorName":"李秀君","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"眼科","HisFlowNo":""} 2025-04-01 11:54:30 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:54:30 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:54:58 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105368", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25040111542345715", "ActTime": "2025-04-01 11:54:53", "FlowNo": "4200002627202504013105064835", "UserID": "ZZJ1" } 2025-04-01 11:54:58 --- 1:36493648612:0.013:24:14DL250401115423457155:2025-04-01 11:54:536:42000026272025040131050648357:ZZJ18: 2025-04-01 11:54:58 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj02" } 2025-04-01 11:54:58 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:55:59 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:55:59 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 11:56:02 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105368", "startDate": "2025-03-25", "endDate": "2025-04-01" } 2025-04-01 11:56:23 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 11:56:23 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 11:56:25 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105348", "startDate": "2025-03-25", "endDate": "2025-04-01" } 2025-04-01 11:56:37 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105348", "startDate": "2025-03-25", "endDate": "2025-04-01" } 2025-04-01 15:00:58 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410521199310044030", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 15:00:58 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='410521199310044030' 2025-04-01 15:28:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200210204014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 15:28:06 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='410622200210204014' 2025-04-01 15:28:20 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410622200210204014", "Uid": "" } 2025-04-01 15:28:20 --- 2001 2025-04-01 15:28:20 --- 410622200210204014 2025-04-01 15:28:20 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-04-01 15:28:27 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410622200210204014", "CardType": "2", "PatientName": "付宇轩", "Sex": "1", "Birthday": "2002-10-20", "Age": "22", "IDCardNo": "410622200210204014", "Address": "河南省淇县黄洞乡烟岭沟村69号", "Tel": "15239293335", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-04-01 15:27:58", "FlowNo": "ZZJ120250401812631", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 15:28:27 --- 创建卡判断用户存在0 2025-04-01 15:28:27 --- 创建卡开始循环 2025-04-01 15:28:27 --- 创建卡执行存储 2025-04-01 15:28:27 --- 创建卡输出 2025-04-01 15:28:45 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200210204014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 15:28:45 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='410622200210204014' 2025-04-01 15:28:52 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-02" } 2025-04-01 15:32:58 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200210204014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 15:32:58 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='410622200210204014' 2025-04-01 15:33:00 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 15:33:26 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0024", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 15:33:36 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 17:24:59 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:24:59 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:25:03 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 17:25:07 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 17:25:13 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 17:25:13 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:25:14 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0015", "DoctorCode": "", "DoctorName": "石海亮", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "15:00-16:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040117243751863", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 17:25:14 --- 5003jinru 2025-04-01 17:25:14 --- 5003....1 2025-04-01 17:25:14 --- 5003....yyh30 2025-04-01 17:25:14 --- 5003....用户查询到1105368 2025-04-01 17:25:14 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'石海亮' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'外科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 17:25:14 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.03","DoctorName":"石海亮","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"外科","HisFlowNo":""} 2025-04-01 17:25:55 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:25:55 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 17:25:59 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 17:26:07 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "7011", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 17:26:12 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj03" } 2025-04-01 17:26:12 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-01 17:26:12 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "DepartCode": "7011", "DoctorCode": "2037", "DoctorName": "李银平", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "15:00-16:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040117253616372", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 17:26:12 --- 5003jinru 2025-04-01 17:26:12 --- 5003....1 2025-04-01 17:26:13 --- 5003....yyh30 2025-04-01 17:26:13 --- 5003....用户查询到1105348 2025-04-01 17:26:13 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'李银平' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'口腔科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='412328198205199090' 2025-04-01 17:26:13 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"412328198205199090","PatientName":"陈志云","Balance":"0.93","DoctorName":"李银平","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"口腔科","HisFlowNo":""} 2025-04-01 17:26:53 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:26:53 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:26:59 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-04" } 2025-04-01 17:27:08 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:27:08 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:27:13 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-02" } 2025-04-01 17:27:17 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0024", "SearchType": "", "DateTime": "2025-04-02" } 2025-04-01 17:27:22 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 17:27:22 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:27:22 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0024", "DoctorCode": "1037", "DoctorName": "冯英烈", "SearchType": "1", "RegisterDate": "2025-04-02", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040117264598941", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 17:27:22 --- 5003jinru 2025-04-01 17:27:22 --- 5003....1 2025-04-01 17:27:22 --- 5003....yyh30 2025-04-01 17:27:22 --- 5003....用户查询到1105368 2025-04-01 17:27:22 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'冯英烈' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'内科门诊' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 17:27:22 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.03","DoctorName":"冯英烈","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"内科门诊","HisFlowNo":""} 2025-04-01 17:30:12 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:30:12 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:30:15 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "DateEndTime": "2025-04-08", "UserID": "ZZJ1" } 2025-04-01 17:34:17 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:34:17 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:34:23 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "DateEndTime": "2025-04-08", "UserID": "ZZJ1" } 2025-04-01 17:35:23 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 17:35:23 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:35:23 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105368", "YYNo": "20250401115325994", "PatientName": "陈志云", "UserID": "ZZJ1" } 2025-04-01 17:35:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:35:56 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:36:00 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "DateEndTime": "2025-04-08", "UserID": "ZZJ1" } 2025-04-01 17:36:11 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250401172514244", "UserID": "ZZJ1" } 2025-04-01 17:36:11 --- 删除预约delete from IN_XsReserveTB where PatientID='21684' and DoctorID='4287' and XsReserveTime='2025-04-01 15:00-16:00' and CONVERT(varchar,XsReserveDate,112)='20250401' 2025-04-01 17:36:20 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:36:20 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:36:24 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "DateEndTime": "2025-04-08", "UserID": "ZZJ1" } 2025-04-01 17:36:37 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250401114132494", "UserID": "ZZJ1" } 2025-04-01 17:36:37 --- 删除预约delete from IN_XsReserveTB where PatientID='21684' and DoctorID='2293' and XsReserveTime='2025-04-01 09:00-10:00' and CONVERT(varchar,XsReserveDate,112)='20250401' 2025-04-01 17:36:41 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250401114028072", "UserID": "ZZJ1" } 2025-04-01 17:36:41 --- 删除预约delete from IN_XsReserveTB where PatientID='21684' and DoctorID='3305' and XsReserveTime='2025-04-01 09:00-10:00' and CONVERT(varchar,XsReserveDate,112)='20250401' 2025-04-01 17:36:45 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250401113053572", "UserID": "ZZJ1" } 2025-04-01 17:36:45 --- 删除预约delete from IN_XsReserveTB where PatientID='21684' and DoctorID='3304' and XsReserveTime='2025-04-01 11:00-12:00' and CONVERT(varchar,XsReserveDate,112)='20250401' 2025-04-01 17:36:52 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:36:52 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:36:55 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "DateEndTime": "2025-04-08", "UserID": "ZZJ1" } 2025-04-01 17:37:53 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:37:53 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:37:56 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-01" } 2025-04-01 17:38:05 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0016", "SearchType": "", "DateTime": "2025-04-01" } 2025-04-01 17:38:10 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 17:38:10 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:38:12 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0016", "DoctorCode": "1006", "DoctorName": "刘俊岭", "SearchType": "0", "RegisterDate": "2025-04-01", "RegisterTime": "08:00-09:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040117373398551", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-01 17:38:12 --- 5003jinru 2025-04-01 17:38:12 --- 5003....1 2025-04-01 17:38:12 --- 5003....yyh30 2025-04-01 17:38:12 --- 5003....用户查询到1105368 2025-04-01 17:38:12 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'刘俊岭' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'疼痛科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-01 17:38:12 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.03","DoctorName":"刘俊岭","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"疼痛科","HisFlowNo":""} 2025-04-01 17:39:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:39:43 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:41:30 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:41:30 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:42:00 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105368", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "1", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25040117410554885", "ActTime": "2025-04-01 17:41:54", "FlowNo": "4200002705202504015982380466", "UserID": "ZZJ1" } 2025-04-01 17:42:00 --- 1:36493648612:13:24:14DL250401174105548855:2025-04-01 17:41:546:42000027052025040159823804667:ZZJ18: 2025-04-01 17:42:00 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj03" } 2025-04-01 17:42:00 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:49:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-01 17:49:43 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-01 17:49:46 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105368", "PatientName": "陈志云", "DateTime": "2025-04-01", "DateEndTime": "2025-04-08", "UserID": "ZZJ1" }