◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 07:49:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13581800376</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/8 0:00:00_上午_耳鼻喉科赵学林</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130322197808290027</patientidcard><patientname>田林涛</patientname><patientsex>女</patientsex><patientbirthday>1978-08-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13581800376</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 07:49:19
记录内容：select * from  pat_master_index where id_no='130322197808290027' and name='田林涛' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/8/29 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 07:49:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/08','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科赵学林' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 07: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('2025/10/08','YYYY/MM/DD'),2118,'耳鼻喉科赵学林','上午','4','100143044','田林涛','TIAN LIN TAO','女','47','一般人员','自费','','主任号','1','0306','ZHAOXL01','1',to_date('2025/10/04 07:49:22','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510082118','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 07: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('2025/10/08','YYYY/MM/DD'),2118,'耳鼻喉科赵学林','上午','4','100143044','田林涛','TIAN LIN TAO','女','47','一般人员','自费','','主任号','1','0306','ZHAOXL01','1',to_date('2025/10/04 07:49:22','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510082118','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('2025/10/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科赵学林' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/08','YYYY/MM/DD'),2118,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/08','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科赵学林' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510082118</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510082118</pinkey><ordertime>2025-10-04 07:49:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 08:26:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15344654516</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_胸外科王敬</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23233119600519002X</patientidcard><patientname>林桂英</patientname><patientsex>女</patientsex><patientbirthday>1960-05-19</patientbirthday><medicalrecord></medicalrecord><contactphone>15344654516</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 08:26:14
记录内容：select * from  pat_master_index where id_no='23233119600519002X' and name='林桂英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1960/5/19 0:00:0065
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 08:26:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '胸外科王敬' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 08:26:14
记录内容： 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('2025/10/11','YYYY/MM/DD'),2735,'胸外科王敬','上午','1','100512247','林桂英','LIN GUI YING ','女','65','一般人员','自费','','普通号','1','0366','WANGJING','1',to_date('2025/10/04 08:26:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510112735','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 08:26:14
记录内容：<?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('2025/10/11','YYYY/MM/DD'),2735,'胸外科王敬','上午','1','100512247','林桂英','LIN GUI YING ','女','65','一般人员','自费','','普通号','1','0366','WANGJING','1',to_date('2025/10/04 08:26:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510112735','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('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胸外科王敬' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),2735,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '胸外科王敬' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510112735</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510112735</pinkey><ordertime>2025-10-04 08:26:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 08:32:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13836455828</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_胸外科王敬</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232331196509170022</patientidcard><patientname>林桂芝</patientname><patientsex>女</patientsex><patientbirthday>1965-09-17</patientbirthday><medicalrecord></medicalrecord><contactphone>13836455828</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 08:32:32
记录内容：select * from  pat_master_index where id_no='232331196509170022' and name='林桂芝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/9/17 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 08:32:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '胸外科王敬' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 08:32: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('2025/10/11','YYYY/MM/DD'),2895,'胸外科王敬','上午','2','100512250','林桂芝','LIN GUI ZHI ','女','60','一般人员','自费','','普通号','1','0366','WANGJING','1',to_date('2025/10/04 08:32:35','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510112895','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 08:32: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('2025/10/11','YYYY/MM/DD'),2895,'胸外科王敬','上午','2','100512250','林桂芝','LIN GUI ZHI ','女','60','一般人员','自费','','普通号','1','0366','WANGJING','1',to_date('2025/10/04 08:32:35','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510112895','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('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胸外科王敬' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),2895,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '胸外科王敬' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510112895</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510112895</pinkey><ordertime>2025-10-04 08:32:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 09:03:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15010642730</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/7 0:00:00_上午_产科周雪静副主任</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>360122199107183385</patientidcard><patientname>李婷婷</patientname><patientsex>女</patientsex><patientbirthday>1991-07-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15010642730</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 09:03:32
记录内容：select * from  pat_master_index where id_no='360122199107183385' and name='李婷婷' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/7/18 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:03:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '产科周雪静副主任' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:03: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('2025/10/07','YYYY/MM/DD'),3659,'产科周雪静副主任','上午','1','10479905','李婷婷','','女','34','一般人员','自费','','副主任号','1','0330','ZHOUXJ','1',to_date('2025/10/04 09:03:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510073659','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 09:03: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('2025/10/07','YYYY/MM/DD'),3659,'产科周雪静副主任','上午','1','10479905','李婷婷','','女','34','一般人员','自费','','副主任号','1','0330','ZHOUXJ','1',to_date('2025/10/04 09:03:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510073659','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('2025/10/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科周雪静副主任' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/07','YYYY/MM/DD'),3659,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '产科周雪静副主任' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510073659</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510073659</pinkey><ordertime>2025-10-04 09:03:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 09:41:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522737792</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_眼科郭苗苗</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230206201111250049</patientidcard><patientname>翟灵汐</patientname><patientsex>女</patientsex><patientbirthday>2011-11-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13522737792</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 09:41:02
记录内容：select * from  pat_master_index where id_no='230206201111250049' and name='翟灵汐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2011/11/25 0:00:0014
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:41:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:41:02
记录内容： 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('2025/10/05','YYYY/MM/DD'),4532,'眼科郭苗苗','下午','1','100512100','翟灵汐','DI LING XI ','女','14','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/04 09:41:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510054532','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 09:41:02
记录内容：<?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('2025/10/05','YYYY/MM/DD'),4532,'眼科郭苗苗','下午','1','100512100','翟灵汐','DI LING XI ','女','14','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/04 09:41:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510054532','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科郭苗苗' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),4532,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510054532</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510054532</pinkey><ordertime>2025-10-04 09:41:02</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 09:41:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522737792</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_心理咨询失眠李文</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230206201111250049</patientidcard><patientname>翟灵汐</patientname><patientsex>女</patientsex><patientbirthday>2011-11-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13522737792</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 09:41:45
记录内容：select * from  pat_master_index where id_no='230206201111250049' and name='翟灵汐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2011/11/25 0:00:0014
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:41:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:41:45
记录内容： 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('2025/10/05','YYYY/MM/DD'),4545,'心理咨询失眠李文','下午','1','100512100','翟灵汐','DI LING XI ','女','14','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/10/04 09:41:47','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510054545','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 09:41:45
记录内容：<?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('2025/10/05','YYYY/MM/DD'),4545,'心理咨询失眠李文','下午','1','100512100','翟灵汐','DI LING XI ','女','14','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/10/04 09:41:47','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510054545','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询失眠李文' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),4545,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510054545</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510054545</pinkey><ordertime>2025-10-04 09:41:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 09:58:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13845750298</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_呼吸内科高立静</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232700196403150610</patientidcard><patientname>梁卫忠</patientname><patientsex>男</patientsex><patientbirthday>1964-03-15</patientbirthday><medicalrecord></medicalrecord><contactphone>13845750298</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 09:58:47
记录内容：select * from  pat_master_index where id_no='232700196403150610' and name='梁卫忠' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1964/3/15 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:58:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 09:58: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('2025/10/05','YYYY/MM/DD'),4911,'呼吸内科高立静','上午','1','100378428','梁卫忠','LIANG WEI ZHONG ','男','61','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/10/04 09:58:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510054911','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 09:58: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('2025/10/05','YYYY/MM/DD'),4911,'呼吸内科高立静','上午','1','100378428','梁卫忠','LIANG WEI ZHONG ','男','61','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/10/04 09:58:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510054911','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),4911,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510054911</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510054911</pinkey><ordertime>2025-10-04 09:58:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 10:15:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15004627209</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230227199201090845</patientidcard><patientname>吴迪</patientname><patientsex>女</patientsex><patientbirthday>1992-01-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15004627209</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 10:15:52
记录内容：select * from  pat_master_index where id_no='230227199201090845' and name='吴迪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/1/9 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 10:15:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 10:15:52
记录内容： 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('2025/10/05','YYYY/MM/DD'),5276,'内分泌科马伟杰','上午','2','100512301','吴迪','WU DI ','女','33','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 10:15:54','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510055276','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 10:15:52
记录内容：<?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('2025/10/05','YYYY/MM/DD'),5276,'内分泌科马伟杰','上午','2','100512301','吴迪','WU DI ','女','33','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 10:15:54','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510055276','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),5276,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510055276</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510055276</pinkey><ordertime>2025-10-04 10:15:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 10:49:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13785816386</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_生殖男科富鹤</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130982198109097715</patientidcard><patientname>尹海良</patientname><patientsex>男</patientsex><patientbirthday>1981-09-09</patientbirthday><medicalrecord></medicalrecord><contactphone>13785816386</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 10:49:18
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/05','YYYY-MM-DD')
            AND CLINIC_LABEL='生殖男科富鹤' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='130982198109097715' and name='尹海良' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 10:49:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 11:39:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15101629117</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_医疗美容科张昉</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>450324200001050729</patientidcard><patientname>房芳</patientname><patientsex>女</patientsex><patientbirthday>2000-01-05</patientbirthday><medicalrecord></medicalrecord><contactphone>15101629117</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 11:39:37
记录内容：select * from  pat_master_index where id_no='450324200001050729' and name='房芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/1/5 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 11:39:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '医疗美容科张昉' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 11:39:37
记录内容： 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('2025/10/04','YYYY/MM/DD'),6733,'医疗美容科张昉','下午','1','100512310','房芳','FANG FANG ','女','25','一般人员','自费','','副主任号','1','03109','ZF','1',to_date('2025/10/04 11:39:39','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510046733','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 11:39:37
记录内容：<?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('2025/10/04','YYYY/MM/DD'),6733,'医疗美容科张昉','下午','1','100512310','房芳','FANG FANG ','女','25','一般人员','自费','','副主任号','1','03109','ZF','1',to_date('2025/10/04 11:39:39','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510046733','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('2025/10/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '医疗美容科张昉' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/04','YYYY/MM/DD'),6733,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '医疗美容科张昉' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510046733</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510046733</pinkey><ordertime>2025-10-04 11:39:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 11:44:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522951197</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_消化内科胡珉</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>37090219970208121X</patientidcard><patientname>刘逸飞</patientname><patientsex>男</patientsex><patientbirthday>1997-02-08</patientbirthday><medicalrecord></medicalrecord><contactphone>13522951197</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 11:44:02
记录内容：select * from  pat_master_index where id_no='37090219970208121X' and name='刘逸飞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/2/8 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 11:44:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 11:44:02
记录内容： 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('2025/10/04','YYYY/MM/DD'),6756,'消化内科胡珉','下午','1','Z00292848','刘逸飞','','男','28','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/04 11:44:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510046756','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 11:44:02
记录内容：<?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('2025/10/04','YYYY/MM/DD'),6756,'消化内科胡珉','下午','1','Z00292848','刘逸飞','','男','28','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/04 11:44:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510046756','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('2025/10/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科胡珉' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/04','YYYY/MM/DD'),6756,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510046756</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510046756</pinkey><ordertime>2025-10-04 11:44:02</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 12:46:07
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13810008111</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130203198111011526</patientidcard><patientname>王怡</patientname><patientsex>女</patientsex><patientbirthday>1981-11-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13810008111</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 12:46:07
记录内容：select * from  pat_master_index where id_no='130203198111011526' and name='王怡' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/11/1 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 12:46:07
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 12:46:07
记录内容： 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('2025/10/05','YYYY/MM/DD'),6962,'内分泌科马伟杰','上午','3','100512335','王怡','WANG  ','女','44','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 12:46:09','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510056962','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 12:46:07
记录内容：<?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('2025/10/05','YYYY/MM/DD'),6962,'内分泌科马伟杰','上午','3','100512335','王怡','WANG  ','女','44','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 12:46:09','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510056962','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6962,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510056962</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510056962</pinkey><ordertime>2025-10-04 12:46:07</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 13:18:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15354169867</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130425198802016341</patientidcard><patientname>秦景素</patientname><patientsex>女</patientsex><patientbirthday>1988-02-01</patientbirthday><medicalrecord></medicalrecord><contactphone>15354169867</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 13:18:28
记录内容：select * from  pat_master_index where id_no='130425198802016341' and name='秦景素' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/2/1 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 13:18:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 13:18:28
记录内容： 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('2025/10/05','YYYY/MM/DD'),7174,'内分泌科马伟杰','上午','4','00309260','秦景素','','女','37','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 13:18:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510057174','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 13:18:28
记录内容：<?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('2025/10/05','YYYY/MM/DD'),7174,'内分泌科马伟杰','上午','4','00309260','秦景素','','女','37','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 13:18:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510057174','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),7174,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510057174</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510057174</pinkey><ordertime>2025-10-04 13:18:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 13:22:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18247096036</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_心血管内科陶林森</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152122196403094810</patientidcard><patientname>陈喜</patientname><patientsex>男</patientsex><patientbirthday>1964-03-09</patientbirthday><medicalrecord></medicalrecord><contactphone>18247096036</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 13:22:00
记录内容：select * from  pat_master_index where id_no='152122196403094810' and name='陈喜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1964/3/9 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 13:22:00
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '心血管内科陶林森' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 13:22: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('2025/10/05','YYYY/MM/DD'),7210,'心血管内科陶林森','上午','1','100512338','陈喜','CHEN XI ','男','61','一般人员','自费','','主任号','1','0359','TAOLS','1',to_date('2025/10/04 13:22:02','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510057210','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 13:22: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('2025/10/05','YYYY/MM/DD'),7210,'心血管内科陶林森','上午','1','100512338','陈喜','CHEN XI ','男','61','一般人员','自费','','主任号','1','0359','TAOLS','1',to_date('2025/10/04 13:22:02','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510057210','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科陶林森' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),7210,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '心血管内科陶林森' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510057210</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510057210</pinkey><ordertime>2025-10-04 13:22:00</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 13:23:59
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18153807123</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_产科辛俊英</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>430682200008061523</patientidcard><patientname>程子璇</patientname><patientsex>女</patientsex><patientbirthday>2000-08-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18153807123</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 13:23:59
记录内容：select * from  pat_master_index where id_no='430682200008061523' and name='程子璇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/8/6 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 13:23:59
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 13:23:59
记录内容： 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('2025/10/04','YYYY/MM/DD'),7234,'产科辛俊英','下午','1','10579837','程子璇','','女','25','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/10/04 13:24:01','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510047234','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 13:23:59
记录内容：<?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('2025/10/04','YYYY/MM/DD'),7234,'产科辛俊英','下午','1','10579837','程子璇','','女','25','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/10/04 13:24:01','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510047234','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('2025/10/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/04','YYYY/MM/DD'),7234,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510047234</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510047234</pinkey><ordertime>2025-10-04 13:23:59</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 14:38:51
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531651868</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_风湿免疫科薛利敏</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822194812033520</patientidcard><patientname>詹秀兰</patientname><patientsex>女</patientsex><patientbirthday>1948-12-03</patientbirthday><medicalrecord></medicalrecord><contactphone>18531651868</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 14:38:51
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/04','YYYY-MM-DD')
            AND CLINIC_LABEL='风湿免疫科薛利敏' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='132822194812033520' and name='詹秀兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 14:38:51
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 15:00:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18532557275</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_耳鼻喉科王慎祥</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>210281199012277832</patientidcard><patientname>卫元章</patientname><patientsex>男</patientsex><patientbirthday>1990-12-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18532557275</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 15:00:40
记录内容：select * from  pat_master_index where id_no='210281199012277832' and name='卫元章' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/12/27 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 15:00:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 15:00:40
记录内容： 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('2025/10/05','YYYY/MM/DD'),8358,'耳鼻喉科王慎祥','上午','2','Z00203726','卫元章','','男','35','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2025/10/04 15:00:41','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510058358','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 15:00:40
记录内容：<?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('2025/10/05','YYYY/MM/DD'),8358,'耳鼻喉科王慎祥','上午','2','Z00203726','卫元章','','男','35','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2025/10/04 15:00:41','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510058358','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),8358,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510058358</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510058358</pinkey><ordertime>2025-10-04 15:00:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 15:03:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531651868</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_风湿免疫科薛利敏</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132822194812033520</patientidcard><patientname>詹秀兰</patientname><patientsex>女</patientsex><patientbirthday>1948-12-03</patientbirthday><medicalrecord></medicalrecord><contactphone>18531651868</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 15:03:49
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/04','YYYY-MM-DD')
            AND CLINIC_LABEL='风湿免疫科薛利敏' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='132822194812033520' and name='詹秀兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 15:03:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 15:11:26
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531651868</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_风湿免疫科薛利敏</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132822194812033520</patientidcard><patientname>詹秀兰</patientname><patientsex>女</patientsex><patientbirthday>1948-12-03</patientbirthday><medicalrecord></medicalrecord><contactphone>18531651868</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 15:11:26
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/04','YYYY-MM-DD')
            AND CLINIC_LABEL='风湿免疫科薛利敏' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='132822194812033520' and name='詹秀兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 15:11:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 15:54:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13520116223</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232101198606025249</patientidcard><patientname>何彦</patientname><patientsex>女</patientsex><patientbirthday>1986-06-02</patientbirthday><medicalrecord></medicalrecord><contactphone>13520116223</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 15:54:49
记录内容：select * from  pat_master_index where id_no='232101198606025249' and name='何彦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/6/2 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 15:54:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 15:54:49
记录内容： 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('2025/10/05','YYYY/MM/DD'),8983,'皮肤科常庆华','下午','6','100512351','何彦','HE YAN ','女','39','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/04 15:54:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510058983','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 15:54:49
记录内容：<?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('2025/10/05','YYYY/MM/DD'),8983,'皮肤科常庆华','下午','6','100512351','何彦','HE YAN ','女','39','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/04 15:54:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510058983','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),8983,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510058983</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510058983</pinkey><ordertime>2025-10-04 15:54:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 15:57:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19852921613</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_泌尿外科唐伟</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230523199603194015</patientidcard><patientname>王乐</patientname><patientsex>男</patientsex><patientbirthday>1996-03-19</patientbirthday><medicalrecord></medicalrecord><contactphone>19852921613</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 15:57:21
记录内容：select * from  pat_master_index where id_no='230523199603194015' and name='王乐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/3/19 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 15:57:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 15:57: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('2025/10/05','YYYY/MM/DD'),9006,'泌尿外科唐伟','上午','4','100512378','王乐','WANG LE ','男','29','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/04 15:57:22','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510059006','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 15:57: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('2025/10/05','YYYY/MM/DD'),9006,'泌尿外科唐伟','上午','4','100512378','王乐','WANG LE ','男','29','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/04 15:57:22','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510059006','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科唐伟' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9006,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059006</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510059006</pinkey><ordertime>2025-10-04 15:57:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 16:00:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13126568973</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/4 0:00:00_下午_眼科张仲凯</scheduleid><parttimeid>16:30-17:00</parttimeid><certtypeno>1</certtypeno><patientidcard>220602199502250315</patientidcard><patientname>吴健彰</patientname><patientsex>男</patientsex><patientbirthday>1995-02-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13126568973</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 16:00:38
记录内容：select * from  pat_master_index where id_no='220602199502250315' and name='吴健彰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/2/25 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 16:00:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '眼科张仲凯' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 16:00:38
记录内容： 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('2025/10/04','YYYY/MM/DD'),9037,'眼科张仲凯','下午','24','100369454','吴健彰','WU JIAN ZHANG ','男','30','一般人员','自费','','普通号','1','0327','ZHANGZK','1',to_date('2025/10/04 16:00:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510049037','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','57') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 16:00:38
记录内容：<?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('2025/10/04','YYYY/MM/DD'),9037,'眼科张仲凯','下午','24','100369454','吴健彰','WU JIAN ZHANG ','男','30','一般人员','自费','','普通号','1','0327','ZHANGZK','1',to_date('2025/10/04 16:00:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510049037','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','57') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科张仲凯' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/04','YYYY/MM/DD'),9037,'16:30-17:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/04','yyyy/mm/dd')
                    and clinic_label = '眼科张仲凯' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510049037</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510049037</pinkey><ordertime>2025-10-04 16:00:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 17:22:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18511585521</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132421195608166023</patientidcard><patientname>贺秀珍</patientname><patientsex>女</patientsex><patientbirthday>1956-08-16</patientbirthday><medicalrecord></medicalrecord><contactphone>18511585521</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 17:22:18
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/05','YYYY-MM-DD')
            AND CLINIC_LABEL='骨科刘兴超' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='132421195608166023' and name='贺秀珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 17:22:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 17:26:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18511585521</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132421195608166023</patientidcard><patientname>贺秀珍</patientname><patientsex>女</patientsex><patientbirthday>1956-08-16</patientbirthday><medicalrecord></medicalrecord><contactphone>18511585521</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 17:26:16
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/05','YYYY-MM-DD')
            AND CLINIC_LABEL='骨科刘兴超' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='132421195608166023' and name='贺秀珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 17:26:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 17:38:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13930687753</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_便民门诊吴春明</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197310206827</patientidcard><patientname>朱爱武</patientname><patientsex>女</patientsex><patientbirthday>1973-10-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13930687753</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 17:38:04
记录内容：select * from  pat_master_index where id_no='132822197310206827' and name='朱爱武' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1973/10/20 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 17:38:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '便民门诊吴春明' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 17:38: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('2025/10/05','YYYY/MM/DD'),9416,'便民门诊吴春明','上午','1','10467621','朱爱武','','女','52','一般人员','自费','','便民号','1','0396','WCM','1',to_date('2025/10/04 17:38:05','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202510059416','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 17:38: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('2025/10/05','YYYY/MM/DD'),9416,'便民门诊吴春明','上午','1','10467621','朱爱武','','女','52','一般人员','自费','','便民号','1','0396','WCM','1',to_date('2025/10/04 17:38:05','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202510059416','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '便民门诊吴春明' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9416,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '便民门诊吴春明' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059416</orderid><reservefee>0.00</reservefee><clinicfee>1</clinicfee><registrationfee>0</registrationfee><pinkey>202510059416</pinkey><ordertime>2025-10-04 17:38:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 18:27:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17310839554</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_消化内科胡珉</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>342626196808052668</patientidcard><patientname>丁红霞</patientname><patientsex>女</patientsex><patientbirthday>1968-08-05</patientbirthday><medicalrecord></medicalrecord><contactphone>17310839554</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 18:27:47
记录内容：select * from  pat_master_index where id_no='342626196808052668' and name='丁红霞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/8/5 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 18:27:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 18:27: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('2025/10/05','YYYY/MM/DD'),9483,'消化内科胡珉','上午','2','100483415','丁红霞','DING HONG XIA ','女','57','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/04 18:27:47','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059483','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 18:27: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('2025/10/05','YYYY/MM/DD'),9483,'消化内科胡珉','上午','2','100483415','丁红霞','DING HONG XIA ','女','57','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/04 18:27:47','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059483','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科胡珉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9483,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059483</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059483</pinkey><ordertime>2025-10-04 18:27:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 19:07:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18510981433</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/14 0:00:00_上午_妇科樊庆泊</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150430197102283609</patientidcard><patientname>柴素令</patientname><patientsex>女</patientsex><patientbirthday>1971-02-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18510981433</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 19:07:03
记录内容：select * from  pat_master_index where id_no='150430197102283609' and name='柴素令' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/2/28 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 19:07:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/14','yyyy/mm/dd')
                    and clinic_label = '妇科樊庆泊' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 19:07:03
记录内容： 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('2025/10/14','YYYY/MM/DD'),9504,'妇科樊庆泊','上午','2','100442944','柴素令','CHAI SU LING ','女','54','一般人员','自费','','知名专家','1','0316','XHFQB','1',to_date('2025/10/04 19:07:03','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510149504','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 19:07:03
记录内容：<?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('2025/10/14','YYYY/MM/DD'),9504,'妇科樊庆泊','上午','2','100442944','柴素令','CHAI SU LING ','女','54','一般人员','自费','','知名专家','1','0316','XHFQB','1',to_date('2025/10/04 19:07:03','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510149504','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('2025/10/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科樊庆泊' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/14','YYYY/MM/DD'),9504,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/14','yyyy/mm/dd')
                    and clinic_label = '妇科樊庆泊' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510149504</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510149504</pinkey><ordertime>2025-10-04 19:07:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 19:18:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13839599926</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_骨科张国栋 普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411102201001240126</patientidcard><patientname>郭肖雯</patientname><patientsex>女</patientsex><patientbirthday>2010-01-24</patientbirthday><medicalrecord></medicalrecord><contactphone>13839599926</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 19:18:47
记录内容：select * from  pat_master_index where id_no='411102201001240126' and name='郭肖雯' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2010/1/24 0:00:0015
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 19:18:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '骨科张国栋 普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 19:18: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('2025/10/05','YYYY/MM/DD'),9516,'骨科张国栋 普','上午','3','Z00438682','郭肖雯','','女','15','一般人员','自费','','普通号','1','0312','ZGD','1',to_date('2025/10/04 19:18:47','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510059516','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 19:18: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('2025/10/05','YYYY/MM/DD'),9516,'骨科张国栋 普','上午','3','Z00438682','郭肖雯','','女','15','一般人员','自费','','普通号','1','0312','ZGD','1',to_date('2025/10/04 19:18:47','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510059516','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科张国栋 普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9516,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '骨科张国栋 普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059516</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510059516</pinkey><ordertime>2025-10-04 19:18:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 19:18:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13290665422</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_产科辛俊英</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>34082219930920314X</patientidcard><patientname>黄晶晶</patientname><patientsex>女</patientsex><patientbirthday>1993-09-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13290665422</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 19:18:48
记录内容：select * from  pat_master_index where id_no='34082219930920314X' and name='黄晶晶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/9/20 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 19:18:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 19:18:48
记录内容： 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('2025/10/05','YYYY/MM/DD'),9517,'产科辛俊英','上午','2','10729773','黄晶晶','HUANG JING JING','女','32','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/10/04 19:18:48','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510059517','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 19:18:48
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9517,'产科辛俊英','上午','2','10729773','黄晶晶','HUANG JING JING','女','32','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/10/04 19:18:48','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510059517','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9517,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059517</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510059517</pinkey><ordertime>2025-10-04 19:18:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 20:47:10
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13911277768</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_泌尿外科唐伟</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132525195108280728</patientidcard><patientname>胡仲梅</patientname><patientsex>女</patientsex><patientbirthday>1951-08-28</patientbirthday><medicalrecord></medicalrecord><contactphone>13911277768</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 20:47:10
记录内容：select * from  pat_master_index where id_no='132525195108280728' and name='胡仲梅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1951/8/28 0:00:0074
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 20:47:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 20:47: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('2025/10/05','YYYY/MM/DD'),9641,'泌尿外科唐伟','上午','5','100512386','胡仲梅','HU ZHONG MEI ','女','74','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/04 20:47:10','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510059641','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 20:47: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('2025/10/05','YYYY/MM/DD'),9641,'泌尿外科唐伟','上午','5','100512386','胡仲梅','HU ZHONG MEI ','女','74','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/04 20:47:10','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510059641','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科唐伟' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9641,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059641</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510059641</pinkey><ordertime>2025-10-04 20:47:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 20:59:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13931641705</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_中医科潘嘉玲</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230302197511056713</patientidcard><patientname>石建军</patientname><patientsex>男</patientsex><patientbirthday>1975-11-05</patientbirthday><medicalrecord></medicalrecord><contactphone>13931641705</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 20:59:38
记录内容：select * from  pat_master_index where id_no='230302197511056713' and name='石建军' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1975/11/5 0:00:0050
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 20:59:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '中医科潘嘉玲' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 20:59:38
记录内容： 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('2025/10/05','YYYY/MM/DD'),9646,'中医科潘嘉玲','上午','1','00203529','石建军','','男','50','一般人员','自费','','中普通号','1','0301','PANJL','1',to_date('2025/10/04 20:59:37','yyyy/mm/dd hh24:mi:ss'),'0','25','0.00','25','202510059646','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 20:59:38
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9646,'中医科潘嘉玲','上午','1','00203529','石建军','','男','50','一般人员','自费','','中普通号','1','0301','PANJL','1',to_date('2025/10/04 20:59:37','yyyy/mm/dd hh24:mi:ss'),'0','25','0.00','25','202510059646','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医科潘嘉玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9646,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '中医科潘嘉玲' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059646</orderid><reservefee>0.00</reservefee><clinicfee>25</clinicfee><registrationfee>0</registrationfee><pinkey>202510059646</pinkey><ordertime>2025-10-04 20:59:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 21:10:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18911037932</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13053319880819331X</patientidcard><patientname>李晓龙</patientname><patientsex>男</patientsex><patientbirthday>1988-08-19</patientbirthday><medicalrecord></medicalrecord><contactphone>18911037932</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 21:10:28
记录内容：select * from  pat_master_index where id_no='13053319880819331X' and name='李晓龙' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/8/19 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:10:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:10:28
记录内容： 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('2025/10/05','YYYY/MM/DD'),9656,'皮肤科常庆华','上午','8','00204495','李晓龙','','男','37','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/04 21:10:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059656','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 21:10:28
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9656,'皮肤科常庆华','上午','8','00204495','李晓龙','','男','37','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/04 21:10:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059656','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9656,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059656</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059656</pinkey><ordertime>2025-10-04 21:10:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 21:10:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15733201250</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_白天_妇科杨芳</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199301041021</patientidcard><patientname>兰嘉欣</patientname><patientsex>女</patientsex><patientbirthday>1993-01-04</patientbirthday><medicalrecord></medicalrecord><contactphone>15733201250</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-04 21:10:42
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/05','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科杨芳' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='131082199301041021' and name='兰嘉欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 21:10:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 21:49:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18901188858</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_老年病科孙安龙</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411219194909280021</patientidcard><patientname>马庆云</patientname><patientsex>女</patientsex><patientbirthday>1949-09-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18901188858</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 21:49:18
记录内容：select * from  pat_master_index where id_no='411219194909280021' and name='马庆云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/9/28 0:00:0076
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:49:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '老年病科孙安龙' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:49:18
记录内容： 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('2025/10/05','YYYY/MM/DD'),9682,'老年病科孙安龙','上午','2','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','普通号','1','0354','SUNAL','1',to_date('2025/10/04 21:49:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510059682','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 21:49:18
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9682,'老年病科孙安龙','上午','2','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','普通号','1','0354','SUNAL','1',to_date('2025/10/04 21:49:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510059682','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '老年病科孙安龙' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9682,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '老年病科孙安龙' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059682</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510059682</pinkey><ordertime>2025-10-04 21:49:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 21:50:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18901188858</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411219194909280021</patientidcard><patientname>马庆云</patientname><patientsex>女</patientsex><patientbirthday>1949-09-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18901188858</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 21:50:28
记录内容：select * from  pat_master_index where id_no='411219194909280021' and name='马庆云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/9/28 0:00:0076
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:50:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:50:28
记录内容： 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('2025/10/05','YYYY/MM/DD'),9690,'骨科刘兴超','上午','1','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/10/04 21:50:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059690','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 21:50:28
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9690,'骨科刘兴超','上午','1','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/10/04 21:50:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059690','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9690,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059690</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059690</pinkey><ordertime>2025-10-04 21:50:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 21:52:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18901188858</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411219194909280021</patientidcard><patientname>马庆云</patientname><patientsex>女</patientsex><patientbirthday>1949-09-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18901188858</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 21:52:25
记录内容：select * from  pat_master_index where id_no='411219194909280021' and name='马庆云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/9/28 0:00:0076
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:52:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 21:52:25
记录内容： 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('2025/10/05','YYYY/MM/DD'),9694,'内分泌科马伟杰','上午','5','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 21:52:24','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059694','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 21:52:25
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9694,'内分泌科马伟杰','上午','5','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 21:52:24','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059694','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9694,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059694</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059694</pinkey><ordertime>2025-10-04 21:52:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 22:56:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15100667382</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/9 0:00:00_上午_内分泌科姚合斌</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>13108220101009027X</patientidcard><patientname>赵鹏博</patientname><patientsex>男</patientsex><patientbirthday>2010-10-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15100667382</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 22:56:55
记录内容：select * from  pat_master_index where id_no='13108220101009027X' and name='赵鹏博' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2010/10/9 0:00:0015
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 22:56:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/09','yyyy/mm/dd')
                    and clinic_label = '内分泌科姚合斌' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 22:56:55
记录内容： 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('2025/10/09','YYYY/MM/DD'),9788,'内分泌科姚合斌','上午','5','100512394','赵鹏博','ZHAO PENG BO ','男','15','一般人员','自费','','知名专家','1','0315','YHB','1',to_date('2025/10/04 22:56:54','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510099788','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 22:56:55
记录内容：<?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('2025/10/09','YYYY/MM/DD'),9788,'内分泌科姚合斌','上午','5','100512394','赵鹏博','ZHAO PENG BO ','男','15','一般人员','自费','','知名专家','1','0315','YHB','1',to_date('2025/10/04 22:56:54','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510099788','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('2025/10/09', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科姚合斌' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/09','YYYY/MM/DD'),9788,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/09','yyyy/mm/dd')
                    and clinic_label = '内分泌科姚合斌' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510099788</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510099788</pinkey><ordertime>2025-10-04 22:56:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 23:09:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18514678677</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/8 0:00:00_上午_内分泌科谭秋艳</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152201199406111521</patientidcard><patientname>齐书浛</patientname><patientsex>女</patientsex><patientbirthday>1994-06-11</patientbirthday><medicalrecord></medicalrecord><contactphone>18514678677</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 23:09:19
记录内容：select * from  pat_master_index where id_no='152201199406111521' and name='齐书浛' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/6/11 0:00:0031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:09:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科谭秋艳' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:09: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('2025/10/08','YYYY/MM/DD'),9809,'内分泌科谭秋艳','上午','1','100418120','齐书浛','','女','31','一般人员','自费','','普通号','1','0315','TQY','1',to_date('2025/10/04 23:09:18','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510089809','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 23:09: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('2025/10/08','YYYY/MM/DD'),9809,'内分泌科谭秋艳','上午','1','100418120','齐书浛','','女','31','一般人员','自费','','普通号','1','0315','TQY','1',to_date('2025/10/04 23:09:18','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510089809','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('2025/10/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科谭秋艳' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/08','YYYY/MM/DD'),9809,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科谭秋艳' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510089809</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510089809</pinkey><ordertime>2025-10-04 23:09:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 23:27:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15039838355</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411219194909280021</patientidcard><patientname>马庆云</patientname><patientsex>女</patientsex><patientbirthday>1949-09-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15039838355</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 23:27:31
记录内容：select * from  pat_master_index where id_no='411219194909280021' and name='马庆云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/9/28 0:00:0076
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:27:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:27:31
记录内容： 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('2025/10/05','YYYY/MM/DD'),9833,'骨科刘兴超','上午','2','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/10/04 23:27:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059833','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 23:27:31
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9833,'骨科刘兴超','上午','2','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/10/04 23:27:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059833','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9833,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059833</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059833</pinkey><ordertime>2025-10-04 23:27:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 23:29:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15039838355</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411219194909280021</patientidcard><patientname>马庆云</patientname><patientsex>女</patientsex><patientbirthday>1949-09-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15039838355</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 23:29:45
记录内容：select * from  pat_master_index where id_no='411219194909280021' and name='马庆云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/9/28 0:00:0076
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:29:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:29:45
记录内容： 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('2025/10/05','YYYY/MM/DD'),9835,'内分泌科马伟杰','上午','6','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 23:29:44','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059835','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 23:29:45
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9835,'内分泌科马伟杰','上午','6','100512390','马庆云','MA QING YUN ','女','76','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/10/04 23:29:44','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059835','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9835,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510059835</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059835</pinkey><ordertime>2025-10-04 23:29:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 23:37:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15117284617</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_白天_妇科杨芳</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>622627200111192022</patientidcard><patientname>刘蓉蓉</patientname><patientsex>女</patientsex><patientbirthday>2001-11-19</patientbirthday><medicalrecord></medicalrecord><contactphone>15117284617</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 23:37:42
记录内容：select * from  pat_master_index where id_no='622627200111192022' and name='刘蓉蓉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/11/19 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:37:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:37:42
记录内容： 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('2025/10/05','YYYY/MM/DD'),9842,'妇科杨芳','白天','6','100512410','刘蓉蓉','LIU RONG RONG ','女','24','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2025/10/04 23:37:41','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059842','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 23:37:42
记录内容：<?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('2025/10/05','YYYY/MM/DD'),9842,'妇科杨芳','白天','6','100512410','刘蓉蓉','LIU RONG RONG ','女','24','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2025/10/04 23:37:41','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059842','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科杨芳' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9842,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202510059842</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059842</pinkey><ordertime>2025-10-04 23:37:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-04 23:40:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19554478875</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_白天_妇科杨芳</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13063320021126212x</patientidcard><patientname>范嘉伟</patientname><patientsex>女</patientsex><patientbirthday>2002-11-26</patientbirthday><medicalrecord></medicalrecord><contactphone>19554478875</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-04 23:40:32
记录内容：select * from  pat_master_index where id_no='13063320021126212x' and name='范嘉伟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/11/26 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:40:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-04 23:40: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('2025/10/05','YYYY/MM/DD'),9846,'妇科杨芳','白天','7','100512400','范嘉伟','FAN JIA WEI ','女','23','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2025/10/04 23:40:31','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059846','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-04 23:40: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('2025/10/05','YYYY/MM/DD'),9846,'妇科杨芳','白天','7','100512400','范嘉伟','FAN JIA WEI ','女','23','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2025/10/04 23:40:31','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510059846','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('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科杨芳' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),9846,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202510059846</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510059846</pinkey><ordertime>2025-10-04 23:40:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆