2025-03-27 09:18:33 --- 接收到的参数{"TranCode":"6002","SourceID":"ZZ","AreaID":"null","PatientID":"104260","PatientName":"席林达","Reg_No":"20250318-014","Amt":"0.01","PayType":"2","BankCard":"","ReferenceFlowNo":"14DL25032617395132412","ActTime":"2025-03-26 17:40:10","FlowNo":"4200002681202503267707281648","ALLCARDANDEXP":"","UserID":"ZZJ1"} 2025-03-27 09:20:20 --- 接收到的参数{"TranCode":"6002","SourceID":"ZZ","AreaID":"null","PatientID":"104260","PatientName":"席林达","Reg_No":"20250318-014","Amt":"0.01","PayType":"2","BankCard":"","ReferenceFlowNo":"14DL25032617395132412","ActTime":"2025-03-26 17:40:10","FlowNo":"4200002681202503267707281648","ALLCARDANDEXP":"","UserID":"ZZJ1"} 2025-03-27 09:22:18 --- 接收到的参数{"TranCode":"6002","SourceID":"ZZ","AreaID":"null","PatientID":"104260","PatientName":"席林达","Reg_No":"20250318-014","Amt":"0.01","PayType":"2","BankCard":"","ReferenceFlowNo":"14DL25032617395132412","ActTime":"2025-03-26 17:40:10","FlowNo":"4200002681202503267707281648","ALLCARDANDEXP":"","UserID":"ZZJ1"} 2025-03-27 09:58:52 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 09:58: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='410923199606070013' 2025-03-27 09:58:55 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 09:58:57 --- 接收到的参数{ "TranCode": "7002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "VisitNo": "20250327_0073", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 09:59:22 --- 接收到的参数{ "TranCode": "7004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "OrderNoList": "495433|495441", "OrderAmt": "11.3", "PayChannel": "02", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032709583136958", "FlowNo": "4200002628202503275589975177", "ALLCARDANDEXP": "", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 09:59:24 --- 调用PROC_SAVE_ZZAP_REC_YKT返回0:{"ye":"","chrg":"324635"} 2025-03-27 09:59:24 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=324635&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1 2025-03-27 09:59:28 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=324635&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1返回:{"status":"0","EInvoiceNumber":"0975173467","EInvoiceCode":"41060125","RandomNumber":"286f4e","SerialNumber":"20250327095930000"} 2025-03-27 09:59:28 --- 查询明细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 ('495433','495441')) as totalamt from cl_recipe where trim(rec_no) in ('495433','495441') 2025-03-27 09:59:29 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 09:59: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='410923199606070013' 2025-03-27 10:08:29 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 10:08: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='410923199606070013' 2025-03-27 10:08:31 --- 接收到的参数{ "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-27" } 2025-03-27 10:08:33 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0013", "SearchType": "", "DateTime": "2025-03-27" } 2025-03-27 10:08:42 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 10:08: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='410923199606070013' 2025-03-27 10:08:42 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "DepartCode": "0013", "DoctorCode": "1072", "DoctorName": "孙羽霞", "SearchType": "0", "RegisterDate": "2025-03-27", "RegisterTime": "09:00-10:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032710080939882", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-27 10:08:42 --- 5003jinru 2025-03-27 10:08:42 --- 5003....1 2025-03-27 10:08:42 --- 5003....yyh30 2025-03-27 10:08:42 --- 5003....用户查询到1104995 2025-03-27 10:08:42 --- 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='410923199606070013' 2025-03-27 10:08:42 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"410923199606070013","PatientName":"席林达","Balance":"0.03","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"???","HisFlowNo":""} 2025-03-27 10:55:01 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-27 10:55:05 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 10:55:31 --- 接收到的参数{ "TranCode": "6002", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104260", "PatientName": "席林达", "Reg_No": "20250318-014", "Amt": "0.01", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032710543620458", "ActTime": "2025-03-27 10:54:55", "FlowNo": "4200002621202503271577884220", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-27 10:57:52 --- 接收到的参数{ "TranCode":"6001", "SourceID":"ZZ", "HosNum":"250540", "OpenID":"", "UserID":"ZZJ1" } 2025-03-27 10:57:55 --- 接收到的参数{ "TranCode": "6004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104260", "Reg_No": "20250318-014", "PatientName": "席林达", "StartTime": "2025-03-27", "EndTime": "2025-03-27", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 11:14:43 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 11:14: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='410923199606070013' 2025-03-27 11:14:46 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 11:21:39 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 11:21: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='410923199606070013' 2025-03-27 11:21:42 --- 接收到的参数{ "TranCode": "7001", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 11:21:44 --- 接收到的参数{ "TranCode": "7002", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "VisitNo": "20250327_0073", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 11:22:13 --- 接收到的参数{ "TranCode": "7004", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "PatientName": "席林达", "OrderNoList": "495520", "OrderAmt": "5", "PayChannel": "02", "PayType": "2", "BankCard": "", "ReferenceFlowNo": "14DL25032711211449859", "FlowNo": "4200002708202503270614401604", "ALLCARDANDEXP": "", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 11:22:14 --- 调用PROC_SAVE_ZZAP_REC_YKT返回0:{"ye":"","chrg":"324675"} 2025-03-27 11:22:14 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=324675&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1 2025-03-27 11:22:18 --- (调用发票)http://192.168.100.62:8080/lxdzfpprocess.ashxhttp://192.168.100.62:8080/lxdzfpprocess.ashx?jylx=dzfp_bs&ywbm=cq9102&Type=1&chrg_no=324675&PayerPartyType=1&PayerPartyCode=&Email=&EInvoiceCode=&EInvoiceNumber=&Reason=1&PInvoiceCode=&PInvoiceNumber=&PRandomNumber=&oper_code=ZZJ1返回:{"status":"0","EInvoiceNumber":"0975173538","EInvoiceCode":"41060125","RandomNumber":"52f44e","SerialNumber":"20250327112221000"} 2025-03-27 11:22:18 --- 查询明细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 ('495520')) as totalamt from cl_recipe where trim(rec_no) in ('495520') 2025-03-27 11:22:19 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 11:22: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='410923199606070013' 2025-03-27 13:36:04 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 13:36:04 --- 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='410923199606070013' 2025-03-27 13:36:07 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 13:36:18 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 13:36: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='410923199606070013' 2025-03-27 13:36:22 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-03-28" } 2025-03-27 13:36:25 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0015", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-27 13:36:32 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 13:36: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='410923199606070013' 2025-03-27 13:36:32 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "DepartCode": "0015", "DoctorCode": "1064", "DoctorName": "袁红健", "SearchType": "1", "RegisterDate": "2025-03-28", "RegisterTime": "15:00-16:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032713354612867", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-27 13:36:32 --- 5003jinru 2025-03-27 13:36:32 --- 5003....1 2025-03-27 13:36:32 --- 5003....yyh30 2025-03-27 13:36:32 --- 5003....用户查询到1104995 2025-03-27 13:36:32 --- 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='410923199606070013' 2025-03-27 13:36:32 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"410923199606070013","PatientName":"席林达","Balance":"0.03","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"??","HisFlowNo":""} 2025-03-27 13:37:04 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 13:37:04 --- 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='410923199606070013' 2025-03-27 13:37:06 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 13:39:22 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 13:39: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='410923199606070013' 2025-03-27 13:39:24 --- 接收到的参数{ "TranCode": "3002", "PatientID": "104995", "startDate": "2025-03-20", "endDate": "2025-03-27" } 2025-03-27 14:29:44 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 14:29:44 --- 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='410923199606070013' 2025-03-27 14:29:48 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "UserID": "ZZJ1" } 2025-03-27 15:45:23 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 15:45: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='410923199606070013' 2025-03-27 15:45:26 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 15:57:24 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "zzj001" } 2025-03-27 15:57: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='410923199606070013' 2025-03-27 15:57:31 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "zzj001" } 2025-03-27 16:04:57 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 16:04: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='410923199606070013' 2025-03-27 16:05:03 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 16:49:30 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 16:49: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='410923199606070013' 2025-03-27 16:49:32 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 16:49:39 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 16:49: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='410923199606070013' 2025-03-27 16:49:39 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104995", "YYNo": "null", "PatientName": "席林达", "UserID": "ZZJ1" } 2025-03-27 16:52:51 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 16:52: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='410923199606070013' 2025-03-27 16:52:53 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 16:52:57 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 16:52: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='410923199606070013' 2025-03-27 16:52:58 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104995", "YYNo": "null", "PatientName": "席林达", "UserID": "ZZJ1" } 2025-03-27 16:56:40 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 16:56: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='410923199606070013' 2025-03-27 16:56:42 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 16:56:45 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250327133632527", "UserID": "ZZJ1" } 2025-03-27 16:56:45 --- 删除预约delete from IN_XsReserveTB where PatientID='21671' and DoctorID='3305' and XsReserveTime='2025-03-28 15:00-16:00' and CONVERT(varchar,XsReserveDate,112)='20250328' 2025-03-27 16:57:03 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 18:35:50 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:35: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='410923199606070013' 2025-03-27 18:35:54 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-03-28" } 2025-03-27 18:35:57 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0018", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-27 18:36:01 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:36: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='410923199606070013' 2025-03-27 18:36:02 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "DepartCode": "0018", "DoctorCode": "1028", "DoctorName": "赵炳灿", "SearchType": "1", "RegisterDate": "2025-03-28", "RegisterTime": "16:00-17:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032718345733067", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-27 18:36:02 --- 5003jinru 2025-03-27 18:36:02 --- 5003....1 2025-03-27 18:36:02 --- 5003....yyh30 2025-03-27 18:36:02 --- 5003....用户查询到1104995 2025-03-27 18:36:02 --- 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='410923199606070013' 2025-03-27 18:36:02 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"410923199606070013","PatientName":"席林达","Balance":"0.03","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"???","HisFlowNo":""} 2025-03-27 18:36:13 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:36: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='410923199606070013' 2025-03-27 18:36:14 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 18:36:20 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:36: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='410923199606070013' 2025-03-27 18:36:20 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104995", "YYNo": "", "PatientName": "席林达", "UserID": "ZZJ1" } 2025-03-27 18:36:49 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18: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='410923199606070013' 2025-03-27 18:36:50 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 18:36:53 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250327183602308", "UserID": "ZZJ1" } 2025-03-27 18:36:53 --- 删除预约delete from IN_XsReserveTB where PatientID='21671' and DoctorID='3319' and XsReserveTime='2025-03-28 16:00-17:00' and CONVERT(varchar,XsReserveDate,112)='20250328' 2025-03-27 18:36:56 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250327100842839", "UserID": "ZZJ1" } 2025-03-27 18:36:56 --- 删除预约delete from IN_XsReserveTB where PatientID='21671' and DoctorID='3294' and XsReserveTime='2025-03-27 09:00-10:00' and CONVERT(varchar,XsReserveDate,112)='20250327' 2025-03-27 18:36:58 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250326092456596", "UserID": "ZZJ1" } 2025-03-27 18:36:58 --- 删除预约delete from IN_XsReserveTB where PatientID='21671' and DoctorID='3319' and XsReserveTime='2025-03-27 ' and CONVERT(varchar,XsReserveDate,112)='20250327' 2025-03-27 18:37:03 --- 接收到的参数{ "TranCode": "5006", "SourceID": "ZZ", "AreaID": "0101", "YYNo": "20250326100858799", "UserID": "ZZJ1" } 2025-03-27 18:37:03 --- 删除预约delete from IN_XsReserveTB where PatientID='21671' and DoctorID='4286' and XsReserveTime='2025-03-27 ' and CONVERT(varchar,XsReserveDate,112)='20250327' 2025-03-27 18:37:06 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 18:37:18 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:37: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='410923199606070013' 2025-03-27 18:37:21 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-03-28" } 2025-03-27 18:37:24 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0017", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-27 18:39:44 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:39:44 --- 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='410923199606070013' 2025-03-27 18:39:48 --- 接收到的参数{ "TranCode": "5001", "SearchType": "1", "DateTime": "2025-03-28" } 2025-03-27 18:39:50 --- 接收到的参数{ "TranCode": "5002", "SourceID": "ZZ", "DepartCode": "0017", "SearchType": "", "DateTime": "2025-03-28" } 2025-03-27 18:39:54 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:39:54 --- 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='410923199606070013' 2025-03-27 18:39:55 --- 接收到的参数{ "TranCode": "5003", "SourceID": "ZZ", "AreaID": "0101", "PatientID": "104995", "DepartCode": "0017", "DoctorCode": "1088", "DoctorName": "王泽慧", "SearchType": "1", "RegisterDate": "2025-03-28", "RegisterTime": "15:00-16:00", "PayChannel": "", "PayType": "", "PayAmt": "0", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "14DL25032718385020587", "ALLCARDANDEXP": "", "UserID": "ZZJ1" } 2025-03-27 18:39:55 --- 5003jinru 2025-03-27 18:39:55 --- 5003....1 2025-03-27 18:39:55 --- 5003....yyh30 2025-03-27 18:39:55 --- 5003....用户查询到1104995 2025-03-27 18:39:55 --- 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='410923199606070013' 2025-03-27 18:39:55 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"410923199606070013","PatientName":"席林达","Balance":"0.03","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"?????","HisFlowNo":""} 2025-03-27 18:40:05 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:40: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='410923199606070013' 2025-03-27 18:40:16 --- 接收到的参数{ "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-04-03", "UserID": "ZZJ1" } 2025-03-27 18:40:26 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:40: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='410923199606070013' 2025-03-27 18:40:26 --- 接收到的参数{ "TranCode": "5005", "SourceID": "ZZ", "AreaID": "null", "PatientID": "104995", "YYNo": "20250327183955401", "PatientName": "席林达", "UserID": "ZZJ1" } 2025-03-27 18:43:31 --- 接收到的参数{ "TranCode": "4001", "SourceID": "ZZ", "CardNo": "410923199606070013", "CardType": "2", "OpenID": "", "UserID": "ZZJ1" } 2025-03-27 18:43: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='410923199606070013' 2025-03-27 18:43:34 --- 接收到的参数{ "TranCode": "3002", "PatientID": "104995", "startDate": "2025-03-20", "endDate": "2025-03-27" } 2025-03-27 19:03:38 --- 接收到的参数 { "TranCode": "5001", "SearchType": "0", "DateTime": "2025-03-28" } 2025-03-27 19:04:16 --- 接收到的参数 { "TranCode": "5002", "DepartCode": "0014", "SearchType": "0", "DateTime": "2025-03-28" } 2025-03-27 19:09:02 --- 接收到的参数 { "TranCode": "5003", "SourceID": "ZZ", "AreaID": "1", "PatientID": "104131", "DepartCode": "0014", "DoctorCode": "1017", "DoctorName": "王建国", "SearchType": "1", "RegisterDate": "2025-03-28", "RegisterTime": "08:00-09:00", "PayChannel": "", "PayType": "", "PayAmt": "0.00", "BankCard": "", "ReferenceFlowNo": "", "FlowNo": "ZZ00012019022025032889", "ALLCARDANDEXP":"", "UserID": "ZZJ1" } 2025-03-27 19:09:02 --- 5003jinru 2025-03-27 19:09:02 --- 5003....1 2025-03-27 19:09:02 --- 5003....yyh30 2025-03-27 19:09:02 --- 5003....用户查询到1104131 2025-03-27 19:09:02 --- 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='689741326' 2025-03-27 19:09:02 --- 5003....用户查询到3{"ResultCode":"0","ErrorMsg":"??","CardNo":"689741326","PatientName":"席林达","Balance":"0.04","DoctorName":"???","SessionType":"??","RegisterFee":"0.50","HJH":"","WaitCount":"","JZAddress":"???","HisFlowNo":""} 2025-03-27 19:10:13 --- 接收到的参数 { "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-03-28", "UserID": "ZZJ1" } 2025-03-27 19:10:20 --- 接收到的参数 { "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-27", "DateEndTime": "2025-03-29", "UserID": "ZZJ1" } 2025-03-27 19:10:41 --- 接收到的参数 { "TranCode": "5004", "PatientID": "104995", "PatientName": "席林达", "DateTime": "2025-03-20", "DateEndTime": "2025-03-29", "UserID": "ZZJ1" }