◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 06:15:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18513025711</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_上午_产科张洪英</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130684200207110027</patientidcard><patientname>徐薇</patientname><patientsex>女</patientsex><patientbirthday>2002-07-11</patientbirthday><medicalrecord></medicalrecord><contactphone>18513025711</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 06:15:05
记录内容：select * from  pat_master_index where id_no='130684200207110027' and name='徐薇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/7/11 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 06:15:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 06:15:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3794,'产科张洪英','上午','4','10326576','徐薇','','女','24','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2026/02/16 06:15:10','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602163794','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 06:15:06
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3794,'产科张洪英','上午','4','10326576','徐薇','','女','24','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2026/02/16 06:15:10','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602163794','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科张洪英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3794,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602163794</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602163794</pinkey><ordertime>2026-02-16 06:15:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 07:55:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18832689276</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_上午_骨科陈明梁</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131023199211232633</patientidcard><patientname>李永航</patientname><patientsex>男</patientsex><patientbirthday>1992-11-23</patientbirthday><medicalrecord></medicalrecord><contactphone>18832689276</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 07:55:22
记录内容：select * from  pat_master_index where id_no='131023199211232633' and name='李永航' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/11/23 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 07:55:22
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '骨科陈明梁' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 07:55:22
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3858,'骨科陈明梁','上午','1','100241404','李永航','LI YONG HANG ','男','34','一般人员','自费','','普通号','1','0312','CHENML','1',to_date('2026/02/16 07:55:27','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602163858','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 07:55:22
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3858,'骨科陈明梁','上午','1','100241404','李永航','LI YONG HANG ','男','34','一般人员','自费','','普通号','1','0312','CHENML','1',to_date('2026/02/16 07:55:27','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602163858','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科陈明梁' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3858,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '骨科陈明梁' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602163858</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602163858</pinkey><ordertime>2026-02-16 07:55:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 08:23:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15203480287</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_上午_心血管内科张英普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>142723195603210268</patientidcard><patientname>李转英</patientname><patientsex>女</patientsex><patientbirthday>1956-03-21</patientbirthday><medicalrecord></medicalrecord><contactphone>15203480287</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 08:23:47
记录内容：select * from  pat_master_index where id_no='142723195603210268' and name='李转英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1956/3/21 0:00:0070
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 08:23:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '心血管内科张英普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 08:23:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3993,'心血管内科张英普','上午','2','Z00088919','李转英','LI ZHUAN YING','女','70','一般人员','自费','','普通号','1','0359','ZY1','1',to_date('2026/02/16 08:23:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602163993','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 08:23:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3993,'心血管内科张英普','上午','2','Z00088919','李转英','LI ZHUAN YING','女','70','一般人员','自费','','普通号','1','0359','ZY1','1',to_date('2026/02/16 08:23:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602163993','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科张英普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),3993,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '心血管内科张英普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602163993</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602163993</pinkey><ordertime>2026-02-16 08:23:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 08:34:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13810925395</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_白天_妇科陈海霞</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130921197408063825</patientidcard><patientname>赵云俄</patientname><patientsex>女</patientsex><patientbirthday>1974-08-06</patientbirthday><medicalrecord></medicalrecord><contactphone>13810925395</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 08:34:10
记录内容：select * from  pat_master_index where id_no='130921197408063825' and name='赵云俄' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/8/6 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 08:34:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 08:34:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4068,'妇科陈海霞','白天','7','10518861','赵云俄','','女','52','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/02/16 08:34:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164068','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 08:34:10
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4068,'妇科陈海霞','白天','7','10518861','赵云俄','','女','52','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/02/16 08:34:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164068','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4068,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602164068</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602164068</pinkey><ordertime>2026-02-16 08:34:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 09:49:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13725521006</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_上午_普通外科景圆圆普</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>432501197911040108</patientidcard><patientname>隆岚</patientname><patientsex>女</patientsex><patientbirthday>1979-11-04</patientbirthday><medicalrecord></medicalrecord><contactphone>13725521006</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 09:49:19
记录内容：select * from  pat_master_index where id_no='432501197911040108' and name='隆岚' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/11/4 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 09:49:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '普通外科景圆圆普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 09:49:19
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4650,'普通外科景圆圆普','上午','12','100538374','隆岚','LONG  ','女','47','一般人员','自费','','普通号','1','0335','JINGYY','1',to_date('2026/02/16 09:49:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602164650','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','13') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 09:49:19
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4650,'普通外科景圆圆普','上午','12','100538374','隆岚','LONG  ','女','47','一般人员','自费','','普通号','1','0335','JINGYY','1',to_date('2026/02/16 09:49:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602164650','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','13') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科景圆圆普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4650,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '普通外科景圆圆普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602164650</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602164650</pinkey><ordertime>2026-02-16 09:49:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 09:50:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13703135185</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_下午_神经内科杨志华</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132532197205202361</patientidcard><patientname>赵秀荣</patientname><patientsex>女</patientsex><patientbirthday>1972-05-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13703135185</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 09:50:27
记录内容：select * from  pat_master_index where id_no='132532197205202361' and name='赵秀荣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1972/5/20 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 09:50:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 09:50:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4654,'神经内科杨志华','下午','1','100538361','赵秀荣','ZHAO XIU RONG ','女','54','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/16 09:50:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602164654','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 09:50:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4654,'神经内科杨志华','下午','1','100538361','赵秀荣','ZHAO XIU RONG ','女','54','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/16 09:50:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602164654','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科杨志华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4654,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602164654</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602164654</pinkey><ordertime>2026-02-16 09:50:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 10:05:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15081690903</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_下午_泌尿外科张家兴专</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200411151032</patientidcard><patientname>王梓铮</patientname><patientsex>男</patientsex><patientbirthday>2004-11-15</patientbirthday><medicalrecord></medicalrecord><contactphone>15081690903</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 10:05:00
记录内容：select * from  pat_master_index where id_no='131082200411151032' and name='王梓铮' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/11/15 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 10:05:00
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '泌尿外科张家兴专' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 10:05:00
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4746,'泌尿外科张家兴专','下午','2','100537783','王梓铮','WANG   ','男','22','一般人员','自费','','副主任号','1','0311','ZHANGJX','1',to_date('2026/02/16 10:05:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164746','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 10:05:00
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4746,'泌尿外科张家兴专','下午','2','100537783','王梓铮','WANG   ','男','22','一般人员','自费','','副主任号','1','0311','ZHANGJX','1',to_date('2026/02/16 10:05:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164746','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科张家兴专' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4746,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '泌尿外科张家兴专' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602164746</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602164746</pinkey><ordertime>2026-02-16 10:05:00</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 10:08:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13316024608</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_下午_骨科李刚</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230221194910053624</patientidcard><patientname>刘素珍</patientname><patientsex>女</patientsex><patientbirthday>1949-10-05</patientbirthday><medicalrecord></medicalrecord><contactphone>13316024608</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 10:08:19
记录内容：select * from  pat_master_index where id_no='230221194910053624' and name='刘素珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/10/5 0:00:0077
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 10:08:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '骨科李刚' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 10:08:19
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4763,'骨科李刚','下午','1','100532274','刘素珍','LIU SU ZHEN ','女','77','一般人员','自费','','副主任号','1','0312','LIG','1',to_date('2026/02/16 10:08:23','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164763','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 10:08:19
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4763,'骨科李刚','下午','1','100532274','刘素珍','LIU SU ZHEN ','女','77','一般人员','自费','','副主任号','1','0312','LIG','1',to_date('2026/02/16 10:08:23','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164763','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科李刚' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4763,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '骨科李刚' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602164763</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602164763</pinkey><ordertime>2026-02-16 10:08:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 10:12:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13316024608</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/16 0:00:00_下午_骨科李刚</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230221194910053624</patientidcard><patientname>刘素珍</patientname><patientsex>女</patientsex><patientbirthday>1949-10-05</patientbirthday><medicalrecord></medicalrecord><contactphone>13316024608</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 10:12:21
记录内容：select * from  pat_master_index where id_no='230221194910053624' and name='刘素珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/10/5 0:00:0077
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 10:12:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '骨科李刚' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 10:12:21
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4783,'骨科李刚','下午','2','100532274','刘素珍','LIU SU ZHEN ','女','77','一般人员','自费','','副主任号','1','0312','LIG','1',to_date('2026/02/16 10:12:25','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164783','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 10:12:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4783,'骨科李刚','下午','2','100532274','刘素珍','LIU SU ZHEN ','女','77','一般人员','自费','','副主任号','1','0312','LIG','1',to_date('2026/02/16 10:12:25','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602164783','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科李刚' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/16','YYYY/MM/DD'),4783,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/16','yyyy/mm/dd')
                    and clinic_label = '骨科李刚' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602164783</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602164783</pinkey><ordertime>2026-02-16 10:12:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 12:03:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13722641935</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_胸外科苏广</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821195903210543</patientidcard><patientname>钱丽云</patientname><patientsex>女</patientsex><patientbirthday>1959-03-21</patientbirthday><medicalrecord></medicalrecord><contactphone>13722641935</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 12:03:04
记录内容：select * from  pat_master_index where id_no='132821195903210543' and name='钱丽云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1959/3/21 0:00:0067
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 12:03:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '胸外科苏广' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 12:03:04
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5268,'胸外科苏广','上午','1','100538097','钱丽云','QIAN LI YUN ','女','67','一般人员','自费','','普通号','1','0366','SUG','1',to_date('2026/02/16 12:03:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195268','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 12:03:04
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5268,'胸外科苏广','上午','1','100538097','钱丽云','QIAN LI YUN ','女','67','一般人员','自费','','普通号','1','0366','SUG','1',to_date('2026/02/16 12:03:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195268','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胸外科苏广' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5268,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '胸外科苏广' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602195268</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602195268</pinkey><ordertime>2026-02-16 12:03:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 15:20:26
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15648857168</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/24 0:00:00_上午_呼吸内科芮萌</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152801195401230913</patientidcard><patientname>徐开金</patientname><patientsex>男</patientsex><patientbirthday>1954-01-23</patientbirthday><medicalrecord></medicalrecord><contactphone>15648857168</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 15:20:27
记录内容：select * from  pat_master_index where id_no='152801195401230913' and name='徐开金' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/1/23 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 15:20:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '呼吸内科芮萌' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 15:20:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/24','YYYY/MM/DD'),6020,'呼吸内科芮萌','上午','2','100538411','徐开金','XU KAI JIN ','男','72','一般人员','自费','','副主任号','1','0317','RM','1',to_date('2026/02/16 15:20:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602246020','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 15:20:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/24','YYYY/MM/DD'),6020,'呼吸内科芮萌','上午','2','100538411','徐开金','XU KAI JIN ','男','72','一般人员','自费','','副主任号','1','0317','RM','1',to_date('2026/02/16 15:20:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602246020','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/24', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科芮萌' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/24','YYYY/MM/DD'),6020,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '呼吸内科芮萌' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602246020</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602246020</pinkey><ordertime>2026-02-16 15:20:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 20:54:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18310247032</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/28 0:00:00_上午_产科王振燕</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130821199004257969</patientidcard><patientname>张明娜</patientname><patientsex>女</patientsex><patientbirthday>1990-04-25</patientbirthday><medicalrecord></medicalrecord><contactphone>18310247032</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 20:54:39
记录内容：select * from  pat_master_index where id_no='130821199004257969' and name='张明娜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/4/25 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 20:54:39
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/28','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 20:54:39
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/28','YYYY/MM/DD'),6440,'产科王振燕','上午','1','Z00238548','张明娜','ZHANG MING NA','女','36','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2026/02/16 20:54:40','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602286440','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 20:54:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/28','YYYY/MM/DD'),6440,'产科王振燕','上午','1','Z00238548','张明娜','ZHANG MING NA','女','36','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2026/02/16 20:54:40','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602286440','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/28','YYYY/MM/DD'),6440,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/28','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602286440</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602286440</pinkey><ordertime>2026-02-16 20:54:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 22:47:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522148924</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/17 0:00:00_上午_产科周雪静副主任</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>341221199503247324</patientidcard><patientname>王丽娜</patientname><patientsex>女</patientsex><patientbirthday>1995-03-24</patientbirthday><medicalrecord></medicalrecord><contactphone>13522148924</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 22:47:09
记录内容：select * from  pat_master_index where id_no='341221199503247324' and name='王丽娜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/3/24 0:00:0031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 22:47:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/17','yyyy/mm/dd')
                    and clinic_label = '产科周雪静副主任' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 22:47:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/17','YYYY/MM/DD'),6516,'产科周雪静副主任','上午','1','100535577','王丽娜','WANG LI NA ','女','31','一般人员','自费','','副主任号','1','0330','ZHOUXJ','1',to_date('2026/02/16 22:47:10','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602176516','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 22:47:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/17','YYYY/MM/DD'),6516,'产科周雪静副主任','上午','1','100535577','王丽娜','WANG LI NA ','女','31','一般人员','自费','','副主任号','1','0330','ZHOUXJ','1',to_date('2026/02/16 22:47:10','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602176516','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/17', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科周雪静副主任' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/17','YYYY/MM/DD'),6516,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/17','yyyy/mm/dd')
                    and clinic_label = '产科周雪静副主任' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602176516</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602176516</pinkey><ordertime>2026-02-16 22:47:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-16 23:36:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18733612530</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_耳鼻喉科郭庆  普</scheduleid><parttimeid>11:30-12:00</parttimeid><certtypeno>1</certtypeno><patientidcard>341221199510025471</patientidcard><patientname>李山林</patientname><patientsex>男</patientsex><patientbirthday>1995-10-02</patientbirthday><medicalrecord></medicalrecord><contactphone>18733612530</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-16 23:36:32
记录内容：select * from  pat_master_index where id_no='341221199510025471' and name='李山林' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/10/2 0:00:0031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 23:36:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-16 23:36:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),6564,'耳鼻喉科郭庆  普','上午','6','100261204','李山林','LI SHAN LIN ','男','31','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/16 23:36:32','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602196564','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-16 23:36:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),6564,'耳鼻喉科郭庆  普','上午','6','100261204','李山林','LI SHAN LIN ','男','31','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/16 23:36:32','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602196564','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),6564,'11:30-12:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602196564</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602196564</pinkey><ordertime>2026-02-16 23:36:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆