2025-03-31 10:55:15 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 10:55:15 --- 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-31 10:55:18 --- 接收到的参数{ "TranCode": "3002", "PatientID": "105348", "startDate": "2025-03-24", "endDate": "2025-03-31" } 2025-03-31 10:57:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 10:57: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='3649364861' 2025-03-31 10:58:51 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 10:58:51 --- 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-03-31 10:59:06 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 10:59: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='3649364861' 2025-03-31 11:01:51 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 11:01:51 --- 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-03-31 11:02:20 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 11:02: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-03-31 11:02:31 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-31" } 2025-03-31 11:02:45 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 11:02: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='412328198205199090' 2025-03-31 11:02:58 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 11:02: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-03-31 11:03:20 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 11: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='412328198205199090' 2025-03-31 11:03:49 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 11:03:49 --- 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-31 13:49:55 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 13:49: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='3649364861' 2025-03-31 13:49:57 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-31" } 2025-03-31 13:50:17 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 13:50: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-03-31 13:50:21 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-02" } 2025-03-31 13:50:45 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 13:50: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='412328198205199090' 2025-03-31 13:50:46 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-31" } 2025-03-31 16:02:16 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410622201805088037", "Uid": "" } 2025-03-31 16:02:16 --- 2001 2025-03-31 16:02:16 --- 410622201805088037 2025-03-31 16:02:17 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-03-31 16:02:27 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410622201805088037", "CardType": "", "PatientName": "经智宸", "Sex": "1", "Birthday": "2018-05-08", "Age": "6", "IDCardNo": "410622201805088037", "Address": "", "Tel": "18439811425", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-03-31 16:01:26", "FlowNo": "ZZJ120250331483919", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 16:02:27 --- 创建卡判断用户存在0 2025-03-31 16:02:27 --- 创建卡开始循环 2025-03-31 16:02:27 --- 创建卡执行存储 2025-03-31 16:02:27 --- 创建卡输出 2025-03-31 16:52:09 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 16:52: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='2112062681' 2025-03-31 16:55:10 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 16:55: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-31 16:55:14 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-31" } 2025-03-31 17:03:41 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:03: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='412328198205199090' 2025-03-31 17:04:02 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:04: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-31 17:04:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:04: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-31 17:04:42 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-31" } 2025-03-31 17:17:08 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:17: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='2112062681' 2025-03-31 17:20:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:20: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='2112062681' 2025-03-31 17:21:19 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:21: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='412328198205199090' 2025-03-31 17:21:25 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-06" } 2025-03-31 17:21:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:21: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-31 17:21:47 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-01" } 2025-03-31 17:24:09 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:24: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='2112062681' 2025-03-31 17:30:24 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "2112062681", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:30: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='2112062681' 2025-03-31 17:31:53 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-03-31 17:31: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-03-31 17:32:04 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-31" }