2025-03-28 09:08:13 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj001" } 2025-03-28 09:08: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='412328198205199090' 2025-03-28 09:08:23 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 09:08:23 --- 2001 2025-03-28 09:08:23 --- 412328198205199090 2025-03-28 09:08:23 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-03-28 10:05:33 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 10:05:33 --- 2001 2025-03-28 10:05:33 --- 412328198205199090 2025-03-28 10:05:33 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-03-28 10:05:44 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "412328198205199090", "CardType": "2", "PatientName": "陈志云", "Sex": "1", "Birthday": "1982-05-19", "Age": "42", "IDCardNo": "412328198205199090", "Address": "河南省永城市陈集镇双楼村后香阁西组087号", "Tel": "18439811425", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-03-28 10:04:43", "FlowNo": "zzj00120250328463382", "OpenID": "", "UserID": "zzj001" } 2025-03-28 10:05:44 --- 创建卡判断用户存在{"ResultCode":"1","ErrorMsg":"操作员zzj001不存在!"} 2025-03-28 10:18:43 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 10:18:43 --- 2001 2025-03-28 10:18:43 --- 412328198205199090 2025-03-28 10:18:44 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-03-28 10:18:53 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "412328198205199090", "CardType": "2", "PatientName": "陈志云", "Sex": "1", "Birthday": "1982-05-19", "Age": "42", "IDCardNo": "412328198205199090", "Address": "河南省永城市陈集镇双楼村后香阁西组087号", "Tel": "18439811425", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-03-28 10:17:51", "FlowNo": "zzj00120250328536787", "OpenID": "", "UserID": "zzj001" } 2025-03-28 10:18:53 --- 创建卡判断用户存在{"ResultCode":"1","ErrorMsg":"操作员zzj001不存在!"} 2025-03-28 10:20:11 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 10:20:11 --- 2001 2025-03-28 10:20:11 --- 412328198205199090 2025-03-28 10:20:11 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-03-28 10:20:23 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 10:20:23 --- 2001 2025-03-28 10:20:23 --- 412328198205199090 2025-03-28 10:20:23 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-03-28 10:20:30 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "412328198205199090", "CardType": "2", "PatientName": "陈志云", "Sex": "1", "Birthday": "1982-05-19", "Age": "42", "IDCardNo": "412328198205199090", "Address": "河南省永城市陈集镇双楼村后香阁西组087号", "Tel": "18439811425", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-03-28 10:19:29", "FlowNo": "zzj00120250328221540", "OpenID": "", "UserID": "zzj001" } 2025-03-28 10:20:30 --- 创建卡判断用户存在{"ResultCode":"1","ErrorMsg":"操作员zzj001不存在!"} 2025-03-28 10:20:46 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "412328198205199090", "CardType": "2", "PatientName": "陈志云", "Sex": "1", "Birthday": "1982-05-19", "Age": "42", "IDCardNo": "412328198205199090", "Address": "河南省永城市陈集镇双楼村后香阁西组087号", "Tel": "18439811425", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-03-28 10:19:45", "FlowNo": "ZZJ120250328856510", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:20:46 --- 创建卡判断用户存在0 2025-03-28 10:20:46 --- 创建卡开始循环 2025-03-28 10:20:47 --- 创建卡执行存储 2025-03-28 10:20:47 --- 创建卡输出 2025-03-28 10:22:34 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 10:22:34 --- 2001 2025-03-28 10:22:34 --- 412328198205199090 2025-03-28 10:22:34 --- {"ResultCode":"1","ErrorMsg":" 失败,存在卡信息","PatientID":"412328198205199090"} 2025-03-28 10:23:06 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-03-28 10:23:06 --- 2001 2025-03-28 10:23:06 --- 412328198205199090 2025-03-28 10:23:06 --- {"ResultCode":"1","ErrorMsg":" 失败,存在卡信息","PatientID":"412328198205199090"} 2025-03-28 10:25:29 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:25:29 --- 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-03-28 10:25:32 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-28" } 2025-03-28 10:25:49 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-28 10:26:00 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 10:26: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='412328198205199090' 2025-03-28 10:26:00 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "DepartCode": "0015", "DoctorCode": "1006", "DoctorName": "刘俊岭", "SearchType": "0", "RegisterDate": "2025-03-28", "RegisterTime": "14:00-15:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032810245869673", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 10:26:00 --- 5003jinru 2025-03-28 10:26:00 --- 5003....1 2025-03-28 10:26:00 --- 5003....yyh30 2025-03-28 10:26:00 --- 5003....用户查询到1105348 2025-03-28 10:26:00 --- 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-03-28 10:26:00 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"412328198205199090","PatientName":"陈志云","Balance":"0","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"??","HisFlowNo":""} 2025-03-28 10:34:26 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:34:26 --- 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-03-28 10:34:32 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-04" } 2025-03-28 10:34:42 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:34: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='412328198205199090' 2025-03-28 10:34:47 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-03-29" } 2025-03-28 10:34:50 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-03-29" } 2025-03-28 10:35:00 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 10:35: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='412328198205199090' 2025-03-28 10:35:00 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "DepartCode": "0015", "DoctorCode": "", "DoctorName": "石海亮", "SearchType": "1", "RegisterDate": "2025-03-29", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032810335771749", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 10:35:00 --- 5003jinru 2025-03-28 10:35:00 --- 5003....1 2025-03-28 10:35:00 --- 5003....yyh30 2025-03-28 10:35:00 --- 5003....用户查询到1105348 2025-03-28 10:35:00 --- 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-03-28 10:35:00 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"412328198205199090","PatientName":"陈志云","Balance":"0","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"??","HisFlowNo":""} 2025-03-28 10:36:03 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:36:03 --- 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-03-28 10:36:05 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "DateEndTime": "2025-04-04", "UserID": "ZZJ1" } 2025-03-28 10:36:28 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 10:36:28 --- 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-03-28 10:36:28 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105348", "YYNo": "20250328103500494", "PatientName": "陈志云", "UserID": "ZZJ1" } 2025-03-28 10:40:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:40: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='412328198205199090' 2025-03-28 10:40:08 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "DateEndTime": "2025-04-04", "UserID": "ZZJ1" } 2025-03-28 10:40:24 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250328102600853", "UserID": "ZZJ1" } 2025-03-28 10:40:24 --- 删除预约delete from IN_XsReserveTB where PatientID='21675' and DoctorID='3302' and XsReserveTime='2025-03-28 14:00-15:00' and CONVERT(varchar,XsReserveDate,112)='20250328' 2025-03-28 10:40:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:40: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-03-28 10:40:33 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "DateEndTime": "2025-04-04", "UserID": "ZZJ1" } 2025-03-28 10:41:02 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:41:02 --- 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-03-28 10:41:50 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105348", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032810401365972", "ActTime": "2025-03-28 10:41:47", "FlowNo": "4200002630202503288427231334", "UserID": "ZZJ1" } 2025-03-28 10:41:50 --- 1:4123281982051990902:0.013:24:14DL250328104013659725:2025-03-28 10:41:476:42000026302025032884272313347:ZZJ18: 2025-03-28 10:41:50 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 10:41:50 --- 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-03-28 10:44:39 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:44:39 --- 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-03-28 10:45:05 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105348", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "0.01", "PayType": "1", "BankCard": "", "ReferenceFlowNo": "14DL25032810434629098", "ActTime": "2025-03-28 10:45:02", "FlowNo": "2025032822001483521431950431", "UserID": "ZZJ1" } 2025-03-28 10:45:05 --- 1:4123281982051990902:0.013:14:14DL250328104346290985:2025-03-28 10:45:026:20250328220014835214319504317:ZZJ18: 2025-03-28 10:45:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 10:45: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='412328198205199090' 2025-03-28 10:46:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:46: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='412328198205199090' 2025-03-28 10:46:25 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:46: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='412328198205199090' 2025-03-28 10:46:32 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105348", "startDate": "2025-03-21", "endDate": "2025-03-28" } 2025-03-28 10:46:51 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "amxl", "SearchType": "0" } 2025-03-28 10:47:05 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "am", "SearchType": "5" } 2025-03-28 10:47:24 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "ss", "SearchType": "5" } 2025-03-28 10:50:08 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-28 10:50:18 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "PatientName": "席林达", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 10:51:02 --- 接收到的参数{ "TranCode": "6002", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104260", "PatientName": "席林达", "Reg_No": "20250318-014", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032810492668360", "ActTime": "2025-03-28 10:49:59", "FlowNo": "4200002624202503286157401932", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 10:53:06 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-28 10:53:10 --- 接收到的参数{ "TranCode": "6004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "Reg_No": "20250318-014", "PatientName": "席林达", "StartTime": "2025-03-28", "EndTime": "2025-03-28", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:53:19 --- 接收到的参数{ "TranCode": "6004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "Reg_No": "20250318-014", "PatientName": "席林达", "StartTime": "2025-03-01", "EndTime": "2025-03-28", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:53:45 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-28 10:53:47 --- 接收到的参数{ "TranCode": "6003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "Reg_No": "20250318-014", "PatientName": "席林达", "StartTime": "2025-03-21", "EndTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 10:57:00 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 10:57: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='412328198205199090' 2025-03-28 10:57:47 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-28 10:57:50 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "PatientName": "席林达", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 10:58:14 --- 接收到的参数{ "TranCode": "6002", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104260", "PatientName": "席林达", "Reg_No": "20250318-014", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032810565867170", "ActTime": "2025-03-28 10:57:11", "FlowNo": "4200002693202503283052702002", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 11:03:46 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:03:46 --- 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-03-28 11:03:48 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:03:52 --- 接收到的参数{ "TranCode": "7002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "VisitNo": "20250328_0107", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:04:19 --- 接收到的参数{ "TranCode": "7004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "OrderNoList": "495845", "OrderAmt": "0.09", "PayChannel": "02", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032811025937843", "FlowNo": "4200002620202503283967141076", "ALLCARDANDEXP": "", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:04:21 --- 调用PROC_SAVE_ZZAP_REC_YKT返回0:{"ye":"","chrg":"324879"} 2025-03-28 11:04:21 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=324879&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1 2025-03-28 11:04:25 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=324879&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1返回:{"status":"0","EInvoiceNumber":"0975173687","EInvoiceCode":"41060125","RandomNumber":"14264e","SerialNumber":"20250328110427000"} 2025-03-28 11:04:25 --- 查询明细select distinct reg_no,(select dept_name from code_department where dept_code=cl_recipe.dept_code) as dept,(select sum(total) from cl_recentry where trim(rec_no) in ('495845')) as totalamt from cl_recipe where trim(rec_no) in ('495845') 2025-03-28 11:04:25 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 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='412328198205199090' 2025-03-28 11:06:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:06: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-03-28 11:06:46 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "StartTime": "2025-03-21", "EndTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:07:10 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:07: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='412328198205199090' 2025-03-28 11:08:38 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:08:38 --- 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-03-28 11:09:50 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:09:50 --- 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-03-28 11:09:52 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-28" } 2025-03-28 11:09:56 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0019", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-28 11:10:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj001" } 2025-03-28 11:10: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='412328198205199090' 2025-03-28 11:10:06 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "DepartCode": "0019", "DoctorCode": "1059", "DoctorName": "卢红敏", "SearchType": "0", "RegisterDate": "2025-03-28", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032811090199921", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 11:10:06 --- 5003jinru 2025-03-28 11:10:06 --- 5003....1 2025-03-28 11:10:06 --- 5003....yyh30 2025-03-28 11:10:06 --- 5003....用户查询到1105348 2025-03-28 11:10:06 --- 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-03-28 11:10:06 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"412328198205199090","PatientName":"陈志云","Balance":"0.02","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"??","HisFlowNo":""} 2025-03-28 11:10:27 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:10: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='412328198205199090' 2025-03-28 11:10:29 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-28" } 2025-03-28 11:10:34 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0019", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-28 11:18:22 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:18: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='412328198205199090' 2025-03-28 11:19:29 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105348", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "1", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032811181175810", "ActTime": "2025-03-28 11:19:26", "FlowNo": "4200002620202503288318609142", "UserID": "ZZJ1" } 2025-03-28 11:19:29 --- 1:4123281982051990902:13:24:14DL250328111811758105:2025-03-28 11:19:266:42000026202025032883186091427:ZZJ18: 2025-03-28 11:19:30 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 11:19: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='412328198205199090' 2025-03-28 11:19:53 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:19: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='412328198205199090' 2025-03-28 11:19:54 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-28" } 2025-03-28 11:20:01 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0024", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-28 11:20:09 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 11:20: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='412328198205199090' 2025-03-28 11:20:10 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "DepartCode": "0024", "DoctorCode": "1052", "DoctorName": "吴建军", "SearchType": "0", "RegisterDate": "2025-03-28", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032811190494327", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 11:20:10 --- 5003jinru 2025-03-28 11:20:10 --- 5003....1 2025-03-28 11:20:10 --- 5003....yyh30 2025-03-28 11:20:10 --- 5003....用户查询到1105348 2025-03-28 11:20:10 --- 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-03-28 11:20:10 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"412328198205199090","PatientName":"陈志云","Balance":"1.02","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"????","HisFlowNo":""} 2025-03-28 11:31:21 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:31:21 --- 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-03-28 11:31:23 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:31:42 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:31: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='412328198205199090' 2025-03-28 11:31:45 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:34:18 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:34:18 --- 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-03-28 11:34:20 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:34:23 --- 接收到的参数{ "TranCode": "7002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "VisitNo": "20250328_0107", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:34:28 --- 接收到的参数{ "TranCode": "7004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "OrderNoList": "495866", "OrderAmt": "0.09", "PayChannel": "01", "PayType": "01", "BankCard": "", "ReferenceFlowNo": "14DL25032811332266953", "FlowNo": "", "ALLCARDANDEXP": "", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:34:29 --- 调用PROC_SAVE_ZZAP_REC_YKT返回0:{"ye":".93","chrg":""} 2025-03-28 11:34:29 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1 2025-03-28 11:34:29 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1返回:{"ret":"-1","message":"结算信息不存在"} 2025-03-28 11:34:29 --- System.NullReferenceException: 未将对象引用设置到对象的实例。 在 ZZAYwebservice.DB.HisPatient.dzfpKp(String chrg_no) 位置 D:\lx\有关我做的接口和报表\开封口腔自助机\APZZJ\ZZAYwebservice\DB\HisPatient.cs:行号 1267 2025-03-28 11:34:29 --- 查询明细select distinct reg_no,(select dept_name from code_department where dept_code=cl_recipe.dept_code) as dept,(select sum(total) from cl_recentry where trim(rec_no) in ('495866')) as totalamt from cl_recipe where trim(rec_no) in ('495866') 2025-03-28 11:34:30 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj002" } 2025-03-28 11:34: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='412328198205199090' 2025-03-28 11:35:14 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 11:35:14 --- 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-03-28 11:59:19 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-28 11:59:22 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "PatientName": "席林达", "DateTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-28 11:59:40 --- 接收到的参数{ "TranCode": "6002", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104260", "PatientName": "席林达", "Reg_No": "20250318-014", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032811582308395", "ActTime": "2025-03-28 11:58:33", "FlowNo": "4200002699202503285812070424", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-28 13:43:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 13:43: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='2112062681' 2025-03-28 13:43:26 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 13:43:26 --- 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='2112062681' 2025-03-28 13:53:52 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 13:53: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='2112062681' 2025-03-28 13:54:01 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "812593", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 13:54:01 --- 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='812593' 2025-03-28 13:56:24 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "68938399", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 13:56:24 --- 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='68938399' 2025-03-28 13:57:48 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "7DE384D9", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 13:57: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='7DE384D9' 2025-03-28 14:02:41 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "0000709", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:02:41 --- 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='0000709' 2025-03-28 14:02:47 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "00000709", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:02:47 --- 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='00000709' 2025-03-28 14:02:50 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "000000709", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:02:50 --- 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='000000709' 2025-03-28 14:02:55 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "0000000709", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:02: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='0000000709' 2025-03-28 14:02:59 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "00000000709", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:02: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='00000000709' 2025-03-28 14:03:16 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:03:16 --- 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='078069' 2025-03-28 14:03:20 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "0078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:03: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='0078069' 2025-03-28 14:03:24 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "00078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:03:24 --- 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='00078069' 2025-03-28 14:03:28 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "000078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:03:28 --- 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='000078069' 2025-03-28 14:03:32 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "0000078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:03: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='0000078069' 2025-03-28 14:03:36 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "00000078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:03:36 --- 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='00000078069' 2025-03-28 14:04:52 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "00000010078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:04: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='00000010078069' 2025-03-28 14:05:00 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "010078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:05: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='010078069' 2025-03-28 14:05:05 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "10078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:05:05 --- 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='10078069' 2025-03-28 14:05:20 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "010078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:05: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='010078069' 2025-03-28 14:05:24 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "0010078069", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:05:24 --- 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='0010078069' 2025-03-28 14:29:00 --- 接收到的参数 { "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-28 14:29: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'