2025-04-03 10:32:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:32:31 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-03 10:32:33 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-03" } 2025-04-03 10:34:05 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:34: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='412328198205199090' 2025-04-03 10:34:07 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-03" } 2025-04-03 10:34:18 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10: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-04-03 10:34:22 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-10" } 2025-04-03 10:34:33 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:34:33 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-03 10:34:44 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-05" } 2025-04-03 10:41:25 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "412328198205199090", "Uid": "" } 2025-04-03 10:41:25 --- 2001 2025-04-03 10:41:25 --- 412328198205199090 2025-04-03 10:41:25 --- {"ResultCode":"1","ErrorMsg":" 失败,存在卡信息","PatientID":"412328198205199090"} 2025-04-03 10:41:53 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410622197106140503", "Uid": "" } 2025-04-03 10:41:53 --- 2001 2025-04-03 10:41:53 --- 410622197106140503 2025-04-03 10:41:53 --- {"ResultCode":"1","ErrorMsg":" 失败,存在卡信息","PatientID":"410622197106140503"} 2025-04-03 10:44:20 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:44:20 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-03 10:44:31 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-03" } 2025-04-03 10:44:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:44:43 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-03 10:44:50 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-04-03" } 2025-04-03 10:44:56 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0065", "SearchType": "", "DateTime": "2025-04-03" } 2025-04-03 10:45:07 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "zzj01" } 2025-04-03 10:45:07 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-03 10:45:08 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105368", "DepartCode": "0065", "DoctorCode": "1073", "DoctorName": "杨洪云", "SearchType": "0", "RegisterDate": "2025-04-03", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040310441467468", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-03 10:45:08 --- 5003jinru 2025-04-03 10:45:08 --- 5003....1 2025-04-03 10:45:08 --- 5003....yyh30 2025-04-03 10:45:08 --- 5003....用户查询到1105368 2025-04-03 10:45:08 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'杨洪云' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'耳鼻喉科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='3649364861' 2025-04-03 10:45:08 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"3649364861","PatientName":"陈志云","Balance":"0.94","DoctorName":"杨洪云","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"耳鼻喉科","HisFlowNo":""} 2025-04-03 10:45:37 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:45:37 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-03 10:45:42 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-04-05" } 2025-04-03 10:45:44 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0018", "SearchType": "", "DateTime": "2025-04-05" } 2025-04-03 10:45:49 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj01" } 2025-04-03 10:45: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-04-03 10:45:49 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "DepartCode": "0018", "DoctorCode": "1028", "DoctorName": "赵炳灿", "SearchType": "1", "RegisterDate": "2025-04-05", "RegisterTime": "10:00-11:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25040310445634249", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-04-03 10:45:49 --- 5003jinru 2025-04-03 10:45:49 --- 5003....1 2025-04-03 10:45:49 --- 5003....yyh30 2025-04-03 10:45:49 --- 5003....用户查询到1105348 2025-04-03 10:45:49 --- 5003....用户查询到2select '0' as "ResultCode",'成功' as "ErrorMsg",kid as "CardNo",hymc as "PatientName",n_jine as "Balance",'赵炳灿' as "DoctorName",'医师' as "SessionType",0.5 as "RegisterFee",'' as "HJH",'' as "WaitCount",'皮肤科' as "JZAddress",'' as "HisFlowNo" from t_kxx where kid='412328198205199090' 2025-04-03 10:45:49 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"成功","CardNo":"412328198205199090","PatientName":"陈志云","Balance":"0.93","DoctorName":"赵炳灿","SessionType":"医师","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"皮肤科","HisFlowNo":""} 2025-04-03 10:46:16 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:46: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='412328198205199090' 2025-04-03 10:46:18 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-04-03", "DateEndTime": "2025-04-10", "UserID": "ZZJ1" } 2025-04-03 10:46:28 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj01" } 2025-04-03 10:46: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-04-03 10:46:29 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105348", "YYNo": "20250403104549722", "PatientName": "陈志云", "UserID": "ZZJ1" } 2025-04-03 10:46:49 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:46: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-04-03 10:46:52 --- 接收到的参数{ "TranCode": "5004", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-04-03", "DateEndTime": "2025-04-10", "UserID": "ZZJ1" } 2025-04-03 10:47:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:47: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='412328198205199090' 2025-04-03 10:47:58 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "105348", "PatientName": "陈志云", "DateTime": "2025-04-03", "UserID": "ZZJ1" } 2025-04-03 10:50:50 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:50: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='3649364861' 2025-04-03 10:51:13 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "amxl", "SearchType": "0" } 2025-04-03 10:51:14 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "amxl", "SearchType": "0" } 2025-04-03 10:51:28 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "xdt", "SearchType": "5" } 2025-04-03 10:51:48 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "xcg", "SearchType": "5" } 2025-04-03 10:52:24 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 10:52: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='412328198205199090' 2025-04-03 10:53:31 --- 接收到的参数{ "TranCode": "3001", "SourceID": "ZZ", "AreaID": "null", "PatientID": "105348", "PatientName": "陈志云", "ALLCARDANDEXP": "", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25040310515661011", "ActTime": "2025-04-03 10:53:29", "FlowNo": "4200002702202504036119557282", "UserID": "ZZJ1" } 2025-04-03 10:53:31 --- 1:4123281982051990902:0.013:24:14DL250403105156610115:2025-04-03 10:53:296:42000027022025040361195572827:ZZJ18: 2025-04-03 10:53:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "zzj01" } 2025-04-03 10:53:31 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='412328198205199090' 2025-04-03 10:53:57 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "tj", "SearchType": "5" } 2025-04-03 10:54:18 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "tb", "SearchType": "5" } 2025-04-03 10:54:26 --- 接收到的参数{ "TranCode": "4004", "Mnemonic": "tb", "SearchType": "0" } 2025-04-03 11:00:01 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410622201102250026", "Uid": "" } 2025-04-03 11:00:01 --- 2001 2025-04-03 11:00:01 --- 410622201102250026 2025-04-03 11:00:01 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-04-03 11:00:08 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410622201102250026", "CardType": "2", "PatientName": "侯文岚", "Sex": "2", "Birthday": "2011-02-25", "Age": "14", "IDCardNo": "410622201102250026", "Address": "", "Tel": "13783928695", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-04-03 10:59:15", "FlowNo": "ZZJ120250403066857", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 11:00:08 --- 创建卡判断用户存在0 2025-04-03 11:00:08 --- 创建卡开始循环 2025-04-03 11:00:08 --- 创建卡执行存储 2025-04-03 11:00:08 --- 创建卡输出 2025-04-03 11:16:41 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 11:16: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-04-03 11:16:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "3649364861", "CardType": "0", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 11:16:56 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='3649364861' 2025-04-03 11:17:07 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "412328198205199090", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-04-03 11:17:07 --- 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'