2025-05-12 09:18:13 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250829", "OpenID":"", "UserID":"ZZJ1" } 2025-05-12 09:18:19 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "108960", "PatientName": "朱子航", "DateTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 09:18:44 --- 接收到的参数{ "TranCode": "6002", "SourceID": "ZZ", "AreaID": "null", "PatientID": "108960", "PatientName": "朱子航", "Reg_No": "20250429-002", "Amt": "200", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25051209175720460", "ActTime": "2025-05-12 09:18:17", "FlowNo": "4200002689202505126395808218", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-05-12 09:19:05 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250829", "OpenID":"", "UserID":"ZZJ1" } 2025-05-12 13:44:40 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "ejsgngljp", "SearchType": "0" } 2025-05-12 14:25:40 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198906061023", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:25:40 --- 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='410622198906061023' 2025-05-12 14:25:44 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "110599", "StartTime": "2025-05-05", "EndTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 14:33:45 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410381199602053014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:33: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='410381199602053014' 2025-05-12 14:33:58 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410381199602053014", "Uid": "" } 2025-05-12 14:33:58 --- 2001 2025-05-12 14:33:58 --- 410381199602053014 2025-05-12 14:33:58 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-05-12 14:34:05 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410381199602053014", "CardType": "2", "PatientName": "徐石磊", "Sex": "1", "Birthday": "1996-02-05", "Age": "29", "IDCardNo": "410381199602053014", "Address": "河南省偃师市翟镇四角楼村10组", "Tel": "15225967818", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-05-12 14:33:22", "FlowNo": "ZZJ120250512001449", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:34:05 --- 创建卡判断用户存在0 2025-05-12 14:34:05 --- 创建卡开始循环 2025-05-12 14:34:06 --- 创建卡执行存储 2025-05-12 14:34:06 --- 创建卡输出 2025-05-12 14:34:20 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410381199602053014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:34: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='410381199602053014' 2025-05-12 14:34:30 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" } 2025-05-12 14:35:00 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410381199602053014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14: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='410381199602053014' 2025-05-12 14:35:03 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" } 2025-05-12 14:35:03 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198906061023", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:35: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='410622198906061023' 2025-05-12 14:35:05 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "110599", "StartTime": "2025-05-05", "EndTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 14:35:13 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "110599", "StartTime": "2025-05-05", "EndTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 14:35:15 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410381199602053014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:35: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='410381199602053014' 2025-05-12 14:35:16 --- 接收到的参数{ "TranCode": "5004", "PatientID": "110605", "PatientName": "徐石磊", "DateTime": "2025-05-12", "DateEndTime": "2025-05-19", "UserID": "ZZJ1" } 2025-05-12 14:35:26 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410381199602053014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:35: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='410381199602053014' 2025-05-12 14:35:47 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410381199602053014", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:35: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='410381199602053014' 2025-05-12 14:35:57 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:35:57 --- 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='410622200410253021' 2025-05-12 14:36:09 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410622200410253021", "Uid": "" } 2025-05-12 14:36:09 --- 2001 2025-05-12 14:36:09 --- 410622200410253021 2025-05-12 14:36:09 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-05-12 14:36:12 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198906061023", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:36: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='410622198906061023' 2025-05-12 14:36:14 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "110599", "StartTime": "2025-05-05", "EndTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 14:36:18 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410622200410253021", "CardType": "2", "PatientName": "李倩倩", "Sex": "2", "Birthday": "2004-10-25", "Age": "20", "IDCardNo": "410622200410253021", "Address": "河南省淇县庙口乡东杨铁庄村3号", "Tel": "17772867242", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-05-12 14:35:35", "FlowNo": "ZZJ120250512941262", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:36:18 --- 创建卡判断用户存在0 2025-05-12 14:36:18 --- 创建卡开始循环 2025-05-12 14:36:18 --- 创建卡执行存储 2025-05-12 14:36:18 --- 创建卡输出 2025-05-12 14:36:28 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198906061023", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14: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='410622198906061023' 2025-05-12 14:36:30 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "110599", "StartTime": "2025-05-05", "EndTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 14:36:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:36: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='410622200410253021' 2025-05-12 14:36:33 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" } 2025-05-12 14:36:35 --- 接收到的参数{ "TranCode": "4002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "110599", "StartTime": "2025-05-05", "EndTime": "2025-05-12", "UserID": "ZZJ1" } 2025-05-12 14:36:47 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198906061023", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:36: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='410622198906061023' 2025-05-12 14:36:49 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:36: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='410622200410253021' 2025-05-12 14:36:52 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" } 2025-05-12 14:37:19 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:37: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='410622200410253021' 2025-05-12 14:37:20 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" } 2025-05-12 14:37:34 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:37:34 --- 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='410622200410253021' 2025-05-12 14:37:51 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:37: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='410622200410253021' 2025-05-12 14:38:18 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:38: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='410622200410253021' 2025-05-12 14:38:21 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" } 2025-05-12 14:39:00 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410622200410253021", "Uid": "" } 2025-05-12 14:39:00 --- 2001 2025-05-12 14:39:00 --- 410622200410253021 2025-05-12 14:39:00 --- {"ResultCode":"1","ErrorMsg":" 失败,存在卡信息","PatientID":"410622200410253021"} 2025-05-12 14:39:10 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622200410253021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-05-12 14:39: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='410622200410253021' 2025-05-12 14:39:12 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-05-12" }