2025-07-16 07:41:00 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410523197303102582", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:41: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='410523197303102582' 2025-07-16 07:41:20 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410523197303102582", "Uid": "" } 2025-07-16 07:41:20 --- 2001 2025-07-16 07:41:20 --- 410523197303102582 2025-07-16 07:41:20 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-07-16 07:41:32 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410523197303102582", "CardType": "2", "PatientName": "莫玉青", "Sex": "2", "Birthday": "1973-03-10", "Age": "52", "IDCardNo": "410523197303102582", "Address": "河南省汤阴县铁东路东1巷1排13号", "Tel": "15037210312", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-07-16 07:40:52", "FlowNo": "ZZJ120250716126711", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:41:32 --- 创建卡判断用户存在0 2025-07-16 07:41:32 --- 创建卡开始循环 2025-07-16 07:41:32 --- 创建卡执行存储 2025-07-16 07:41:32 --- 创建卡输出 2025-07-16 07:41:52 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410523197303102582", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:41: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='410523197303102582' 2025-07-16 07:41:55 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-07-16" } 2025-07-16 07:42:23 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410523197303102582", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:42:23 --- 4001:select '0' as "ResultCode", '成功' as "ErrorMsg", KID as "CardNo",I_ZT as "CardStatus",n_jine as "Balance", hymc as "PatientName", (select max(pid) from patientinfo where card_no = KID) as "PatientID", (select distinct id from patientinfo where card_no = KID) as "IDCardNo",'' as "AreaID",(select (select oper_name from code_operator where oper_code=t_zkxx.v_zkr) from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KName",(select v_zksj from t_zkxx where t_zkxx.kid=t_kxx.kid) as "KDate", decode(sex,'1','男','2','女') as "Sex", i_nl as "Age" from t_kxx where KID='410523197303102582' 2025-07-16 07:42:25 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-07-16" } 2025-07-16 07:42:38 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410523197303102582", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:42: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='410523197303102582' 2025-07-16 07:42:41 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-07-16" } 2025-07-16 07:43:08 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410523197303102582", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:43: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='410523197303102582' 2025-07-16 07:43:19 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118152", "PatientName": "莫玉青", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 07:51:37 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410621196303154057", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:51: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='410621196303154057' 2025-07-16 07:51:58 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410621196303154057", "Uid": "" } 2025-07-16 07:51:58 --- 2001 2025-07-16 07:51:58 --- 410621196303154057 2025-07-16 07:51:58 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-07-16 07:52:22 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410621196303154057", "CardType": "2", "PatientName": "张顺堂", "Sex": "1", "Birthday": "1963-03-15", "Age": "62", "IDCardNo": "410621196303154057", "Address": "河南省浚县卫贤镇后交卸村120号", "Tel": "13273924904", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-07-16 07:51:43", "FlowNo": "ZZJ120250716612375", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:52:22 --- 创建卡判断用户存在0 2025-07-16 07:52:22 --- 创建卡开始循环 2025-07-16 07:52:23 --- 创建卡执行存储 2025-07-16 07:52:23 --- 创建卡输出 2025-07-16 07:53:00 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410621197004094044", "Uid": "" } 2025-07-16 07:53:00 --- 2001 2025-07-16 07:53:00 --- 410621197004094044 2025-07-16 07:53:00 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-07-16 07:53:10 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410621197004094044", "CardType": "2", "PatientName": "崔秀花", "Sex": "2", "Birthday": "1970-04-09", "Age": "55", "IDCardNo": "410621197004094044", "Address": "河南省浚县卫贤镇中交卸村106号", "Tel": "15039269678", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-07-16 07:52:30", "FlowNo": "ZZJ120250716003157", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:53:10 --- 创建卡判断用户存在0 2025-07-16 07:53:10 --- 创建卡开始循环 2025-07-16 07:53:10 --- 创建卡执行存储 2025-07-16 07:53:10 --- 创建卡输出 2025-07-16 07:53:35 --- 接收到的参数{ "TranCode": "2001", "IDCardNo": "410621197301150663", "Uid": "" } 2025-07-16 07:53:35 --- 2001 2025-07-16 07:53:35 --- 410621197301150663 2025-07-16 07:53:35 --- {"ResultCode":"0","ErrorMsg":" 成功","PatientID":""} 2025-07-16 07:54:02 --- 接收到的参数{ "TranCode": "2002", "SourceID": "ZZ", "AreaID": "0101", "CreateType": "0", "CardNo": "410621197301150663", "CardType": "2", "PatientName": "崔衬香", "Sex": "2", "Birthday": "1973-01-15", "Age": "52", "IDCardNo": "410621197301150663", "Address": "河南省浚县黎阳镇西王桥村", "Tel": "15939258459", "Amt": "0", "PayType": "null", "BankCard": "", "ReferenceFlowNo": "", "ActTime": "2025-07-16 07:53:22", "FlowNo": "ZZJ120250716216696", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:54:02 --- 创建卡判断用户存在0 2025-07-16 07:54:02 --- 创建卡开始循环 2025-07-16 07:54:02 --- 创建卡执行存储 2025-07-16 07:54:02 --- 创建卡输出 2025-07-16 07:54:26 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410621197301150663", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:54: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='410621197301150663' 2025-07-16 07:54:31 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118157", "PatientName": "崔衬香", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 07:54:48 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410621197301150663", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 07:54: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='410621197301150663' 2025-07-16 07:54:55 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118157", "PatientName": "崔衬香", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 08:25:58 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410523197303102582", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 08:25: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='410523197303102582' 2025-07-16 08:26:00 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118152", "PatientName": "莫玉青", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 12:12:41 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198012300021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 12:12: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='410622198012300021' 2025-07-16 12:13:19 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198012300021", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 12:13: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='410622198012300021' 2025-07-16 12:13:23 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118245", "PatientName": "王志红", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 12:13:34 --- 接收到的参数{ "TranCode": "7002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118245", "PatientName": "王志红", "VisitNo": "20250716_0141", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 12:14:00 --- 接收到的参数{ "TranCode": "7004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "118245", "PatientName": "王志红", "OrderNoList": "536665|536666", "OrderAmt": "256.03", "PayChannel": "02", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25071612125349082", "FlowNo": "4200002804202507162854925757", "ALLCARDANDEXP": "", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 12:14:03 --- 调用PROC_SAVE_ZZAP_REC_YKT返回0:{"ye":"","chrg":"346010"} 2025-07-16 12:14:03 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=346010&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1 2025-07-16 12:14:07 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=346010&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1返回:{"status":"0","EInvoiceNumber":"0975189045","EInvoiceCode":"41060125","RandomNumber":"7b2a4e","SerialNumber":"20250716121338000"} 2025-07-16 12:14:07 --- 查询明细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 ('536665','536666')) as totalamt from cl_recipe where trim(rec_no) in ('536665','536666') 2025-07-16 12:14:08 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622198012300021", "CardType": "2", "OpenID": "", "UserID": "zzj01" } 2025-07-16 12:14: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='410622198012300021' 2025-07-16 16:27:56 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622199904270037", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-07-16 16:27: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='410622199904270037' 2025-07-16 16:27:59 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104394", "PatientName": "申超", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 16:28:07 --- 接收到的参数{ "TranCode": "7002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104394", "PatientName": "申超", "VisitNo": "20250716_0181", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 16:28:31 --- 接收到的参数{ "TranCode": "7004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104394", "PatientName": "申超", "OrderNoList": "536754", "OrderAmt": "158", "PayChannel": "02", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25071616280860906", "FlowNo": "4200002757202507161541206161", "ALLCARDANDEXP": "", "DateTime": "2025-07-16", "UserID": "ZZJ1" } 2025-07-16 16:28:33 --- 调用PROC_SAVE_ZZAP_REC_YKT返回0:{"ye":"","chrg":"346052"} 2025-07-16 16:28:33 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=346052&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1 2025-07-16 16:28:37 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=346052&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1返回:{"status":"0","EInvoiceNumber":"0975189079","EInvoiceCode":"41060125","RandomNumber":"238f4e","SerialNumber":"20250716162808000"} 2025-07-16 16:28:37 --- 查询明细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 ('536754')) as totalamt from cl_recipe where trim(rec_no) in ('536754') 2025-07-16 16:28:38 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410622199904270037", "CardType": "2", "OpenID": "", "UserID": "zzj01" } 2025-07-16 16:28: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='410622199904270037' 2025-07-16 18:40:43 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"58", "OpenID":"", "UserID":"ZZJ1" } 2025-07-16 18:40:59 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"13", "OpenID":"", "UserID":"ZZJ1" } 2025-07-16 18:41:21 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"13572398", "OpenID":"", "UserID":"ZZJ1" }