◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 09:03:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19832625321</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_呼吸内科高立静</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130621200607020340</patientidcard><patientname>张语嫣</patientname><patientsex>女</patientsex><patientbirthday>2006-07-02</patientbirthday><medicalrecord></medicalrecord><contactphone>19832625321</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 09:03:37
记录内容：select * from  pat_master_index where id_no='130621200607020340' and name='张语嫣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/7/2 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:03:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:03: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/11/08','YYYY/MM/DD'),3937,'呼吸内科高立静','上午','2','100518284','张语嫣','ZHANG YU  ','女','19','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/11/06 09:03:38','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511083937','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 09:03: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/11/08','YYYY/MM/DD'),3937,'呼吸内科高立静','上午','2','100518284','张语嫣','ZHANG YU  ','女','19','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/11/06 09:03:38','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511083937','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),3937,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511083937</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511083937</pinkey><ordertime>2025-11-06 09:03:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 09:04:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13102650801</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130230200708012328</patientidcard><patientname>王楚迦</patientname><patientsex>女</patientsex><patientbirthday>2007-08-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13102650801</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 09:04:48
记录内容：select * from  pat_master_index where id_no='130230200708012328' and name='王楚迦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/8/1 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:04:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:04: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/11/06','YYYY/MM/DD'),3979,'皮肤科常庆华','下午','5','100514027','王楚迦','WANG CHU  ','女','18','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/11/06 09:04:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511063979','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 09:04: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/11/06','YYYY/MM/DD'),3979,'皮肤科常庆华','下午','5','100514027','王楚迦','WANG CHU  ','女','18','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/11/06 09:04:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511063979','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/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),3979,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511063979</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511063979</pinkey><ordertime>2025-11-06 09:04:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 09:08:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15731097080</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_内分泌科张金环普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130481199708041810</patientidcard><patientname>高莆</patientname><patientsex>男</patientsex><patientbirthday>1997-08-04</patientbirthday><medicalrecord></medicalrecord><contactphone>15731097080</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 09:08:37
记录内容：select * from  pat_master_index where id_no='130481199708041810' and name='高莆' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/8/4 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:08:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:08: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/11/08','YYYY/MM/DD'),4127,'内分泌科张金环普','上午','3','100518291','高莆','GAO PU ','男','28','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/11/06 09:08:38','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511084127','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 09:08: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/11/08','YYYY/MM/DD'),4127,'内分泌科张金环普','上午','3','100518291','高莆','GAO PU ','男','28','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/11/06 09:08:38','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511084127','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),4127,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511084127</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511084127</pinkey><ordertime>2025-11-06 09:08:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 09:13:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17632830128</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_下午_妇科王阳</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131125199501281626</patientidcard><patientname>戎亚静</patientname><patientsex>女</patientsex><patientbirthday>1995-01-28</patientbirthday><medicalrecord></medicalrecord><contactphone>17632830128</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 09:13:27
记录内容：select * from  pat_master_index where id_no='131125199501281626' and name='戎亚静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/1/28 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:13:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '妇科王阳' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:13:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/08','YYYY/MM/DD'),4266,'妇科王阳','下午','3','100518294','戎亚静','RONG YA JING ','女','30','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/11/06 09:13:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511084266','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 09:13:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/08','YYYY/MM/DD'),4266,'妇科王阳','下午','3','100518294','戎亚静','RONG YA JING ','女','30','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/11/06 09:13:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511084266','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王阳' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),4266,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '妇科王阳' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511084266</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511084266</pinkey><ordertime>2025-11-06 09:13:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 09:20:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17632830128</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_下午_妇科王阳</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131125199501281626</patientidcard><patientname>戎亚静</patientname><patientsex>女</patientsex><patientbirthday>1995-01-28</patientbirthday><medicalrecord></medicalrecord><contactphone>17632830128</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 09:20:11
记录内容：select * from  pat_master_index where id_no='131125199501281626' and name='戎亚静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/1/28 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:20:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '妇科王阳' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:20:11
记录内容： 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/11/08','YYYY/MM/DD'),4483,'妇科王阳','下午','4','100518294','戎亚静','RONG YA JING ','女','30','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/11/06 09:20:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511084483','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 09:20:11
记录内容：<?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/11/08','YYYY/MM/DD'),4483,'妇科王阳','下午','4','100518294','戎亚静','RONG YA JING ','女','30','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/11/06 09:20:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511084483','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王阳' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),4483,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '妇科王阳' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511084483</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511084483</pinkey><ordertime>2025-11-06 09:20:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 09:36:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18648043178</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_儿科刘婕</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028202307030020</patientidcard><patientname>郝奕萱</patientname><patientsex>女</patientsex><patientbirthday>2023-07-03</patientbirthday><medicalrecord></medicalrecord><contactphone>18648043178</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 09:36:45
记录内容：select * from  pat_master_index where id_no='131028202307030020' and name='郝奕萱' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2023/7/3 0:00:002
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:36:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 09:36: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/11/06','YYYY/MM/DD'),4928,'儿科刘婕','下午','2','100518317','郝奕萱','HAO   ','女','2','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/06 09:36:46','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511064928','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 09:36: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/11/06','YYYY/MM/DD'),4928,'儿科刘婕','下午','2','100518317','郝奕萱','HAO   ','女','2','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/06 09:36:46','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511064928','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/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),4928,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511064928</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511064928</pinkey><ordertime>2025-11-06 09:36:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 10:01:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19930238558</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_下午_心理咨询失眠李文</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200708090779</patientidcard><patientname>魏子聪</patientname><patientsex>男</patientsex><patientbirthday>2007-08-09</patientbirthday><medicalrecord></medicalrecord><contactphone>19930238558</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 10:01:05
记录内容：select * from  pat_master_index where id_no='131082200708090779' and name='魏子聪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/8/9 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 10:01:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 10:01:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/08','YYYY/MM/DD'),5674,'心理咨询失眠李文','下午','1','100518320','魏子聪','WEI ZI CONG ','男','18','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/11/06 10:01:06','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511085674','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 10:01:05
记录内容：<?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/11/08','YYYY/MM/DD'),5674,'心理咨询失眠李文','下午','1','100518320','魏子聪','WEI ZI CONG ','男','18','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/11/06 10:01:06','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511085674','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询失眠李文' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),5674,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511085674</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511085674</pinkey><ordertime>2025-11-06 10:01:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 10:36:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18703138813</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_下午_妇科王阳</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210111198611204265</patientidcard><patientname>李佳奇</patientname><patientsex>女</patientsex><patientbirthday>1986-11-20</patientbirthday><medicalrecord></medicalrecord><contactphone>18703138813</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 10:36:28
记录内容：select * from  pat_master_index where id_no='210111198611204265' and name='李佳奇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/11/20 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 10:36:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '妇科王阳' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 10:36: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/11/08','YYYY/MM/DD'),6571,'妇科王阳','下午','5','Z00511465','李佳奇','','女','39','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/11/06 10:36:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511086571','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 10:36: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/11/08','YYYY/MM/DD'),6571,'妇科王阳','下午','5','Z00511465','李佳奇','','女','39','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/11/06 10:36:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511086571','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王阳' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),6571,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '妇科王阳' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511086571</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511086571</pinkey><ordertime>2025-11-06 10:36:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 11:06:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18331695999</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_消化内科黄婷婷</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132821196902055558</patientidcard><patientname>程洪云</patientname><patientsex>男</patientsex><patientbirthday>1969-02-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18331695999</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 11:06:16
记录内容：select * from  pat_master_index where id_no='132821196902055558' and name='程洪云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/2/5 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 11:06:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '消化内科黄婷婷' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 11:06:16
记录内容： 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/11/06','YYYY/MM/DD'),7259,'消化内科黄婷婷','下午','2','100518332','程洪云','CHENG HONG YUN ','男','56','一般人员','自费','','普通号','1','0302','HTT','1',to_date('2025/11/06 11:06:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511067259','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 11:06:16
记录内容：<?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/11/06','YYYY/MM/DD'),7259,'消化内科黄婷婷','下午','2','100518332','程洪云','CHENG HONG YUN ','男','56','一般人员','自费','','普通号','1','0302','HTT','1',to_date('2025/11/06 11:06:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511067259','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/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科黄婷婷' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),7259,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '消化内科黄婷婷' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511067259</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511067259</pinkey><ordertime>2025-11-06 11:06:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 11:23:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17601636454</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_消化内科梁毅</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230121199302070217</patientidcard><patientname>王麒然</patientname><patientsex>男</patientsex><patientbirthday>1993-02-07</patientbirthday><medicalrecord></medicalrecord><contactphone>17601636454</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 11:23:43
记录内容：select * from  pat_master_index where id_no='230121199302070217' and name='王麒然' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/2/7 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 11:23:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 11:23:43
记录内容： 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/11/08','YYYY/MM/DD'),7592,'消化内科梁毅','上午','3','100518364','王麒然','WANG  RAN ','男','32','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/11/06 11:23:43','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511087592','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 11:23:43
记录内容：<?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/11/08','YYYY/MM/DD'),7592,'消化内科梁毅','上午','3','100518364','王麒然','WANG  RAN ','男','32','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/11/06 11:23:43','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511087592','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科梁毅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),7592,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511087592</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511087592</pinkey><ordertime>2025-11-06 11:23:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 11:27:51
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15166235929</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_内分泌科张金环普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>372927196901064119</patientidcard><patientname>王合宽</patientname><patientsex>男</patientsex><patientbirthday>1969-01-06</patientbirthday><medicalrecord></medicalrecord><contactphone>15166235929</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 11:27:52
记录内容：select * from  pat_master_index where id_no='372927196901064119' and name='王合宽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/1/6 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 11:27:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 11:27: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/11/07','YYYY/MM/DD'),7656,'内分泌科张金环普','上午','1','DP029106','王合宽','WANG HE KUAN','男','56','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/11/06 11:27:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511077656','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 11:27: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/11/07','YYYY/MM/DD'),7656,'内分泌科张金环普','上午','1','DP029106','王合宽','WANG HE KUAN','男','56','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/11/06 11:27:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511077656','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),7656,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511077656</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511077656</pinkey><ordertime>2025-11-06 11:27:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 12:02:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18804623023</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130203202505064523</patientidcard><patientname>张宋伊</patientname><patientsex>女</patientsex><patientbirthday>2025-05-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18804623023</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 12:02:45
记录内容：select * from  pat_master_index where id_no='130203202505064523' and name='张宋伊' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2025/5/6 0:00:000
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 12:02:45
记录内容：select * from  pat_master_index where id_no='130203202505064523' and name='张宋伊' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc实体获取的生日2025/5/6 0:00:000
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 12:02:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 12:02: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/11/08','YYYY/MM/DD'),7945,'儿科陈云平','上午','1','100518365','张宋伊','ZHANG SONG YI ','女','0','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/11/06 12:02:45','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511087945','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 12:02: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/11/08','YYYY/MM/DD'),7945,'儿科陈云平','上午','1','100518365','张宋伊','ZHANG SONG YI ','女','0','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/11/06 12:02:45','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511087945','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),7945,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511087945</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511087945</pinkey><ordertime>2025-11-06 12:02:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 12:16:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18793671187</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_心理咨询失眠李文</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622201200010110029</patientidcard><patientname>雷雅婷</patientname><patientsex>女</patientsex><patientbirthday>2000-10-11</patientbirthday><medicalrecord></medicalrecord><contactphone>18793671187</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 12:16:14
记录内容：select * from  pat_master_index where id_no='622201200010110029' and name='雷雅婷' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/10/11 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 12:16:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 12:16: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/11/08','YYYY/MM/DD'),8002,'心理咨询失眠李文','上午','1','100518366','雷雅婷','LEI YA  ','女','25','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/11/06 12:16:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511088002','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 12:16: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/11/08','YYYY/MM/DD'),8002,'心理咨询失眠李文','上午','1','100518366','雷雅婷','LEI YA  ','女','25','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/11/06 12:16:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511088002','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询失眠李文' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),8002,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511088002</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511088002</pinkey><ordertime>2025-11-06 12:16:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 12:20:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18102669161</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>46002719921129662X</patientidcard><patientname>王祺蕾</patientname><patientsex>女</patientsex><patientbirthday>1992-11-29</patientbirthday><medicalrecord></medicalrecord><contactphone>18102669161</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-11-06 12:20:39
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/11/06','YYYY-MM-DD')
            AND CLINIC_LABEL='皮肤科常庆华' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='46002719921129662X' and name='王祺蕾' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 12:20:39
记录内容：<?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-11-06 12:31:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15711324115</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>16:30-17:00</parttimeid><certtypeno>1</certtypeno><patientidcard>210727199608294827</patientidcard><patientname>郭雨桐</patientname><patientsex>女</patientsex><patientbirthday>1996-08-29</patientbirthday><medicalrecord></medicalrecord><contactphone>15711324115</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 12:31:30
记录内容：select * from  pat_master_index where id_no='210727199608294827' and name='郭雨桐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/8/29 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 12:31:30
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 12:31:30
记录内容： 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/11/06','YYYY/MM/DD'),8030,'皮肤科常庆华','下午','6','Z00043135','郭雨桐','','女','29','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/11/06 12:31:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511068030','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 12:31:30
记录内容：<?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/11/06','YYYY/MM/DD'),8030,'皮肤科常庆华','下午','6','Z00043135','郭雨桐','','女','29','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/11/06 12:31:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511068030','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/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),8030,'16:30-17:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511068030</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511068030</pinkey><ordertime>2025-11-06 12:31:30</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 13:17:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13833629760</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200501215861</patientidcard><patientname>华雪静</patientname><patientsex>女</patientsex><patientbirthday>2005-01-21</patientbirthday><medicalrecord></medicalrecord><contactphone>13833629760</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 13:17:13
记录内容：select * from  pat_master_index where id_no='131082200501215861' and name='华雪静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/1/21 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:17:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:17:13
记录内容： 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/11/08','YYYY/MM/DD'),8340,'内分泌科马伟杰普','上午','1','Z00255760','华雪静','HUA XUE JING','女','20','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/11/06 13:17:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511088340','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 13:17:13
记录内容：<?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/11/08','YYYY/MM/DD'),8340,'内分泌科马伟杰普','上午','1','Z00255760','华雪静','HUA XUE JING','女','20','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/11/06 13:17:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511088340','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),8340,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511088340</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511088340</pinkey><ordertime>2025-11-06 13:17:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 13:26:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13521411871</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/10 0:00:00_上午_儿童保健李梅</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150404202304270137</patientidcard><patientname>李昭懿</patientname><patientsex>男</patientsex><patientbirthday>2023-04-27</patientbirthday><medicalrecord></medicalrecord><contactphone>13521411871</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 13:26:05
记录内容：select * from  pat_master_index where id_no='150404202304270137' and name='李昭懿' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2023/4/27 0:00:002
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:26:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '儿童保健李梅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:26:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/10','YYYY/MM/DD'),8477,'儿童保健李梅','上午','1','100448665','李昭懿','LI ZHAO  ','男','2','一般人员','自费','','知名专家','1','0304','LIM','1',to_date('2025/11/06 13:26:05','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511108477','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 13:26:05
记录内容：<?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/11/10','YYYY/MM/DD'),8477,'儿童保健李梅','上午','1','100448665','李昭懿','LI ZHAO  ','男','2','一般人员','自费','','知名专家','1','0304','LIM','1',to_date('2025/11/06 13:26:05','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511108477','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/11/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿童保健李梅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/10','YYYY/MM/DD'),8477,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '儿童保健李梅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511108477</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511108477</pinkey><ordertime>2025-11-06 13:26:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 13:47:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16601134693</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_产科辛俊英</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>150430199511224262</patientidcard><patientname>刘海新</patientname><patientsex>女</patientsex><patientbirthday>1995-11-22</patientbirthday><medicalrecord></medicalrecord><contactphone>16601134693</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 13:47:21
记录内容：select * from  pat_master_index where id_no='150430199511224262' and name='刘海新' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/11/22 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:47:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:47: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/11/06','YYYY/MM/DD'),8819,'产科辛俊英','下午','8','100498538','刘海新','LIU HAI XIN ','女','30','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/11/06 13:47:21','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511068819','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','45') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 13:47: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/11/06','YYYY/MM/DD'),8819,'产科辛俊英','下午','8','100498538','刘海新','LIU HAI XIN ','女','30','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/11/06 13:47:21','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511068819','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','45') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),8819,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511068819</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511068819</pinkey><ordertime>2025-11-06 13:47:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 13:53:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18511511898</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_耳鼻喉科冯培习</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>239005200710294015</patientidcard><patientname>王语桐</patientname><patientsex>男</patientsex><patientbirthday>2007-10-29</patientbirthday><medicalrecord></medicalrecord><contactphone>18511511898</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 13:53:31
记录内容：select * from  pat_master_index where id_no='239005200710294015' and name='王语桐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/10/29 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:53:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科冯培习' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 13:53: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/11/06','YYYY/MM/DD'),8932,'耳鼻喉科冯培习','下午','9','10677501','王语桐','','男','18','一般人员','自费','','普通号','1','0306','FENGPX','1',to_date('2025/11/06 13:53:30','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511068932','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','30') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 13:53: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/11/06','YYYY/MM/DD'),8932,'耳鼻喉科冯培习','下午','9','10677501','王语桐','','男','18','一般人员','自费','','普通号','1','0306','FENGPX','1',to_date('2025/11/06 13:53:30','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511068932','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','30') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科冯培习' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),8932,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科冯培习' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511068932</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511068932</pinkey><ordertime>2025-11-06 13:53:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 14:32:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15234364294</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_中医科闫晋升</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>140825200503200062</patientidcard><patientname>吴帆茹</patientname><patientsex>女</patientsex><patientbirthday>2005-03-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15234364294</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 14:32:48
记录内容：select * from  pat_master_index where id_no='140825200503200062' and name='吴帆茹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/3/20 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:32:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '中医科闫晋升' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:32: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/11/06','YYYY/MM/DD'),9550,'中医科闫晋升','下午','6','100516458','吴帆茹','WU FAN RU ','女','20','一般人员','自费','','中副主任','1','0301','YJS','1',to_date('2025/11/06 14:32:47','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511069550','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','16') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 14:32: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/11/06','YYYY/MM/DD'),9550,'中医科闫晋升','下午','6','100516458','吴帆茹','WU FAN RU ','女','20','一般人员','自费','','中副主任','1','0301','YJS','1',to_date('2025/11/06 14:32:47','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511069550','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','16') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医科闫晋升' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),9550,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '中医科闫晋升' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511069550</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511069550</pinkey><ordertime>2025-11-06 14:32:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 14:37:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17310223520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_心理咨询张晶晶</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>511781200502188060</patientidcard><patientname>卢玲</patientname><patientsex>女</patientsex><patientbirthday>2005-02-18</patientbirthday><medicalrecord></medicalrecord><contactphone>17310223520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 14:37:55
记录内容：select * from  pat_master_index where id_no='511781200502188060' and name='卢玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/2/18 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:37:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:37: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/11/06','YYYY/MM/DD'),9627,'心理咨询张晶晶','下午','5','10653479','卢玲','','女','20','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/06 14:37:54','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511069627','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','15') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 14:37: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/11/06','YYYY/MM/DD'),9627,'心理咨询张晶晶','下午','5','10653479','卢玲','','女','20','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/06 14:37:54','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511069627','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','15') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),9627,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511069627</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511069627</pinkey><ordertime>2025-11-06 14:37:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 14:45:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19906741072</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_康复医学科昝海峰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>330283199009130557</patientidcard><patientname>邬威威</patientname><patientsex>男</patientsex><patientbirthday>1990-09-13</patientbirthday><medicalrecord></medicalrecord><contactphone>19906741072</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 14:45:30
记录内容：select * from  pat_master_index where id_no='330283199009130557' and name='邬威威' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/9/13 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:45:30
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '康复医学科昝海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:45:30
记录内容： 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/11/07','YYYY/MM/DD'),9729,'康复医学科昝海峰','上午','1','10686418','邬威威','WU WEI WEI','男','35','一般人员','自费','','普通号','1','0314','ZHF','1',to_date('2025/11/06 14:45:29','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511079729','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 14:45:30
记录内容：<?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/11/07','YYYY/MM/DD'),9729,'康复医学科昝海峰','上午','1','10686418','邬威威','WU WEI WEI','男','35','一般人员','自费','','普通号','1','0314','ZHF','1',to_date('2025/11/06 14:45:29','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511079729','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '康复医学科昝海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),9729,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '康复医学科昝海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511079729</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511079729</pinkey><ordertime>2025-11-06 14:45:30</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 14:53:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13693590420</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_骨科刘海峰</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130828199004202022</patientidcard><patientname>高海若</patientname><patientsex>女</patientsex><patientbirthday>1990-04-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13693590420</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 14:53:40
记录内容：select * from  pat_master_index where id_no='130828199004202022' and name='高海若' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/4/20 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:53:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 14:53: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/11/06','YYYY/MM/DD'),9837,'骨科刘海峰','下午','14','100287139','高海若','GAO HAI RUO ','女','35','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2025/11/06 14:53:39','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511069837','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','35') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 14:53: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/11/06','YYYY/MM/DD'),9837,'骨科刘海峰','下午','14','100287139','高海若','GAO HAI RUO ','女','35','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2025/11/06 14:53:39','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511069837','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','35') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),9837,'15:30-16:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511069837</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511069837</pinkey><ordertime>2025-11-06 14:53:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 15:29:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18500255876</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_下午_疼痛科王佳璐</scheduleid><parttimeid>16:30-17:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230403199311210529</patientidcard><patientname>王聪</patientname><patientsex>女</patientsex><patientbirthday>1993-11-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18500255876</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 15:29:21
记录内容：select * from  pat_master_index where id_no='230403199311210529' and name='王聪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/11/21 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 15:29:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '疼痛科王佳璐' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 15:29: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/11/06','YYYY/MM/DD'),392,'疼痛科王佳璐','下午','9','00361320','王聪','WANG CONG','女','32','一般人员','自费','','副主任号','1','0332','WJL1','1',to_date('2025/11/06 15:29:20','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511060392','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','23') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 15:29: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/11/06','YYYY/MM/DD'),392,'疼痛科王佳璐','下午','9','00361320','王聪','WANG CONG','女','32','一般人员','自费','','副主任号','1','0332','WJL1','1',to_date('2025/11/06 15:29:20','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511060392','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','23') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '疼痛科王佳璐' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),392,'16:30-17:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '疼痛科王佳璐' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>20251106392</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>20251106392</pinkey><ordertime>2025-11-06 15:29:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 15:56:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13699173525</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_甲乳门诊王新远普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>413023197308194813</patientidcard><patientname>王厚金</patientname><patientsex>男</patientsex><patientbirthday>1973-08-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13699173525</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 15:56:44
记录内容：select * from  pat_master_index where id_no='413023197308194813' and name='王厚金' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1973/8/19 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 15:56:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '甲乳门诊王新远普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 15:56:44
记录内容： 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/11/07','YYYY/MM/DD'),801,'甲乳门诊王新远普','上午','2','100518389','王厚金','WANG HOU JIN ','男','52','一般人员','自费','','普通号','1','0335','WXY001','1',to_date('2025/11/06 15:56:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511070801','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 15:56:44
记录内容：<?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/11/07','YYYY/MM/DD'),801,'甲乳门诊王新远普','上午','2','100518389','王厚金','WANG HOU JIN ','男','52','一般人员','自费','','普通号','1','0335','WXY001','1',to_date('2025/11/06 15:56:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511070801','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '甲乳门诊王新远普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),801,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '甲乳门诊王新远普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20251107801</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>20251107801</pinkey><ordertime>2025-11-06 15:56:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 16:43:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15933061859</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/10 0:00:00_下午_骨科李刚</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200105240774</patientidcard><patientname>闫长乐</patientname><patientsex>男</patientsex><patientbirthday>2001-05-24</patientbirthday><medicalrecord></medicalrecord><contactphone>15933061859</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 16:43:04
记录内容：select * from  pat_master_index where id_no='131082200105240774' and name='闫长乐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/5/24 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 16:43:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '骨科李刚' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 16:43: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/11/10','YYYY/MM/DD'),1376,'骨科李刚','下午','1','10435349','闫长乐','YAN CHANG LE','男','24','一般人员','自费','','副主任号','1','0312','LIG','1',to_date('2025/11/06 16:43:03','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511101376','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 16:43:05
记录内容：<?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/11/10','YYYY/MM/DD'),1376,'骨科李刚','下午','1','10435349','闫长乐','YAN CHANG LE','男','24','一般人员','自费','','副主任号','1','0312','LIG','1',to_date('2025/11/06 16:43:03','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511101376','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/11/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科李刚' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/10','YYYY/MM/DD'),1376,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '骨科李刚' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511101376</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511101376</pinkey><ordertime>2025-11-06 16:43:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 16:55:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18732629238</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/10 0:00:00_上午_神经内科王卫</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>513027197412040717</patientidcard><patientname>秦全德</patientname><patientsex>男</patientsex><patientbirthday>1974-12-04</patientbirthday><medicalrecord></medicalrecord><contactphone>18732629238</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 16:55:19
记录内容：select * from  pat_master_index where id_no='513027197412040717' and name='秦全德' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/12/4 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 16:55:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 16:55: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/11/10','YYYY/MM/DD'),1494,'神经内科王卫','上午','12','100254910','秦全德','QIN QUAN DE ','男','51','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/11/06 16:55:18','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511101494','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 16:55: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/11/10','YYYY/MM/DD'),1494,'神经内科王卫','上午','12','100254910','秦全德','QIN QUAN DE ','男','51','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/11/06 16:55:18','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511101494','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科王卫' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/10','YYYY/MM/DD'),1494,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511101494</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511101494</pinkey><ordertime>2025-11-06 16:55:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 17:10:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522760448</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_白天_头晕门诊杨春景</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>422801198904301436</patientidcard><patientname>赵波</patientname><patientsex>男</patientsex><patientbirthday>1989-04-30</patientbirthday><medicalrecord></medicalrecord><contactphone>13522760448</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 17:10:38
记录内容：select * from  pat_master_index where id_no='422801198904301436' and name='赵波' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/4/30 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 17:10:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '头晕门诊杨春景' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 17:10: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/11/07','YYYY/MM/DD'),1543,'头晕门诊杨春景','白天','1','100518394','赵波','ZHAO BO ','男','36','一般人员','自费','','副主任号','1','0303','YCJ','1',to_date('2025/11/06 17:10:37','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071543','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 17:10: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/11/07','YYYY/MM/DD'),1543,'头晕门诊杨春景','白天','1','100518394','赵波','ZHAO BO ','男','36','一般人员','自费','','副主任号','1','0303','YCJ','1',to_date('2025/11/06 17:10:37','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071543','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '头晕门诊杨春景' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1543,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '头晕门诊杨春景' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511071543</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511071543</pinkey><ordertime>2025-11-06 17:10:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 17:21:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18646533626</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_眼科张仲凯</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>232324198609090623</patientidcard><patientname>米兰</patientname><patientsex>女</patientsex><patientbirthday>1986-09-09</patientbirthday><medicalrecord></medicalrecord><contactphone>18646533626</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 17:21:15
记录内容：select * from  pat_master_index where id_no='232324198609090623' and name='米兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/9/9 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 17:21:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '眼科张仲凯' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 17:21:15
记录内容： 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/11/08','YYYY/MM/DD'),1577,'眼科张仲凯','上午','2','100366880','米兰','MI LAN','女','39','一般人员','自费','','普通号','1','0327','ZHANGZK','1',to_date('2025/11/06 17:21:14','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511081577','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 17:21:15
记录内容：<?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/11/08','YYYY/MM/DD'),1577,'眼科张仲凯','上午','2','100366880','米兰','MI LAN','女','39','一般人员','自费','','普通号','1','0327','ZHANGZK','1',to_date('2025/11/06 17:21:14','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511081577','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科张仲凯' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),1577,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '眼科张仲凯' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511081577</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511081577</pinkey><ordertime>2025-11-06 17:21:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 18:02:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15201539522</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_白天_头晕门诊杨春景</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132821194810130515</patientidcard><patientname>孙吉先</patientname><patientsex>男</patientsex><patientbirthday>1948-10-13</patientbirthday><medicalrecord></medicalrecord><contactphone>15201539522</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 18:02:44
记录内容：select * from  pat_master_index where id_no='132821194810130515' and name='孙吉先' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1948/10/13 0:00:0077
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:02:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '头晕门诊杨春景' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:02:44
记录内容： 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/11/07','YYYY/MM/DD'),1639,'头晕门诊杨春景','白天','2','Z00446978','孙吉先','SUN JI XIAN','男','77','一般人员','自费','','副主任号','1','0303','YCJ','1',to_date('2025/11/06 18:02:42','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071639','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 18:02:44
记录内容：<?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/11/07','YYYY/MM/DD'),1639,'头晕门诊杨春景','白天','2','Z00446978','孙吉先','SUN JI XIAN','男','77','一般人员','自费','','副主任号','1','0303','YCJ','1',to_date('2025/11/06 18:02:42','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071639','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '头晕门诊杨春景' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1639,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '头晕门诊杨春景' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511071639</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511071639</pinkey><ordertime>2025-11-06 18:02:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 18:05:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15201539522</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_呼吸内科王莉</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132821194810130515</patientidcard><patientname>孙吉先</patientname><patientsex>男</patientsex><patientbirthday>1948-10-13</patientbirthday><medicalrecord></medicalrecord><contactphone>15201539522</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 18:05:52
记录内容：select * from  pat_master_index where id_no='132821194810130515' and name='孙吉先' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1948/10/13 0:00:0077
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:05:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:05: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/11/07','YYYY/MM/DD'),1641,'呼吸内科王莉','上午','5','Z00446978','孙吉先','SUN JI XIAN','男','77','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2025/11/06 18:05:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511071641','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 18:05: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/11/07','YYYY/MM/DD'),1641,'呼吸内科王莉','上午','5','Z00446978','孙吉先','SUN JI XIAN','男','77','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2025/11/06 18:05:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511071641','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王莉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1641,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511071641</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511071641</pinkey><ordertime>2025-11-06 18:05:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 18:17:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15831637695</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>150425201002080423</patientidcard><patientname>张冉</patientname><patientsex>女</patientsex><patientbirthday>2010-02-08</patientbirthday><medicalrecord></medicalrecord><contactphone>15831637695</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 18:17:50
记录内容：select * from  pat_master_index where id_no='150425201002080423' and name='张冉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2010/2/8 0:00:0015
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:17:50
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:17:50
记录内容： 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/11/08','YYYY/MM/DD'),1654,'内分泌科马伟杰普','上午','2','10574201','张冉','','女','15','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/11/06 18:17:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511081654','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 18:17:50
记录内容：<?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/11/08','YYYY/MM/DD'),1654,'内分泌科马伟杰普','上午','2','10574201','张冉','','女','15','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/11/06 18:17:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511081654','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),1654,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511081654</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511081654</pinkey><ordertime>2025-11-06 18:17:50</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 18:44:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18033615828</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082201507270444</patientidcard><patientname>王钦熠</patientname><patientsex>女</patientsex><patientbirthday>2015-07-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18033615828</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 18:44:52
记录内容：select * from  pat_master_index where id_no='131082201507270444' and name='王钦熠' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2015/7/27 0:00:0010
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:44:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 18:44: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/11/08','YYYY/MM/DD'),1709,'儿科陈云平','上午','2','100518450','王钦熠','WANG QIN  ','女','10','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/11/06 18:44:50','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511081709','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 18:44: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/11/08','YYYY/MM/DD'),1709,'儿科陈云平','上午','2','100518450','王钦熠','WANG QIN  ','女','10','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/11/06 18:44:50','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511081709','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),1709,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511081709</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511081709</pinkey><ordertime>2025-11-06 18:44:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 19:15:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13871106417</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>420983198501062440</patientidcard><patientname>吴福霞</patientname><patientsex>女</patientsex><patientbirthday>1985-01-06</patientbirthday><medicalrecord></medicalrecord><contactphone>13871106417</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 19:15:18
记录内容：select * from  pat_master_index where id_no='420983198501062440' and name='吴福霞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1985/1/6 0:00:0040
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 19:15:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 19:15: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/11/07','YYYY/MM/DD'),1746,'骨科刘兴超','上午','8','100439174','吴福霞','WU FU XIA ','女','40','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/11/06 19:15:16','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071746','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 19:15: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/11/07','YYYY/MM/DD'),1746,'骨科刘兴超','上午','8','100439174','吴福霞','WU FU XIA ','女','40','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/11/06 19:15:16','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071746','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1746,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511071746</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511071746</pinkey><ordertime>2025-11-06 19:15:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 19:37:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18903913598</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_心血管内陶林森普</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>35032219690302513x</patientidcard><patientname>陈燕战</patientname><patientsex>男</patientsex><patientbirthday>1969-03-02</patientbirthday><medicalrecord></medicalrecord><contactphone>18903913598</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 19:37:11
记录内容：select * from  pat_master_index where id_no='35032219690302513x' and name='陈燕战' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/3/2 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 19:37:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 19:37:11
记录内容： 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/11/07','YYYY/MM/DD'),1785,'心血管内陶林森普','上午','1','100518452','陈燕战','CHEN YAN ZHAN ','男','56','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/11/06 19:37:09','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511071785','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 19:37:11
记录内容：<?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/11/07','YYYY/MM/DD'),1785,'心血管内陶林森普','上午','1','100518452','陈燕战','CHEN YAN ZHAN ','男','56','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/11/06 19:37:09','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511071785','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内陶林森普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1785,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511071785</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511071785</pinkey><ordertime>2025-11-06 19:37:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 20:05:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15100625377</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_下午_风湿免疫科罗昆</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197112270027</patientidcard><patientname>海艳丽</patientname><patientsex>女</patientsex><patientbirthday>1971-12-27</patientbirthday><medicalrecord></medicalrecord><contactphone>15100625377</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 20:05:16
记录内容：select * from  pat_master_index where id_no='132822197112270027' and name='海艳丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/12/27 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:05:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科罗昆' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:05:16
记录内容： 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/11/08','YYYY/MM/DD'),1849,'风湿免疫科罗昆','下午','1','100517882','海艳丽','HAI YAN LI ','女','54','一般人员','自费','','副主任号','1','0337','LK','1',to_date('2025/11/06 20:05:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511081849','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 20:05:16
记录内容：<?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/11/08','YYYY/MM/DD'),1849,'风湿免疫科罗昆','下午','1','100517882','海艳丽','HAI YAN LI ','女','54','一般人员','自费','','副主任号','1','0337','LK','1',to_date('2025/11/06 20:05:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511081849','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '风湿免疫科罗昆' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),1849,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科罗昆' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511081849</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511081849</pinkey><ordertime>2025-11-06 20:05:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 20:08:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13716331880</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/9 0:00:00_上午_胸外科苏广</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>321088196811136725</patientidcard><patientname>韩如芳</patientname><patientsex>女</patientsex><patientbirthday>1968-11-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13716331880</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 20:08:08
记录内容：select * from  pat_master_index where id_no='321088196811136725' and name='韩如芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/11/13 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:08:08
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/09','yyyy/mm/dd')
                    and clinic_label = '胸外科苏广' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:08:08
记录内容： 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/11/09','YYYY/MM/DD'),1856,'胸外科苏广','上午','1','10763039','韩如芳','','女','57','一般人员','自费','','普通号','1','0366','SUG','1',to_date('2025/11/06 20:08:06','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511091856','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 20:08:08
记录内容：<?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/11/09','YYYY/MM/DD'),1856,'胸外科苏广','上午','1','10763039','韩如芳','','女','57','一般人员','自费','','普通号','1','0366','SUG','1',to_date('2025/11/06 20:08:06','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511091856','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/11/09', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胸外科苏广' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/09','YYYY/MM/DD'),1856,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/09','yyyy/mm/dd')
                    and clinic_label = '胸外科苏广' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511091856</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511091856</pinkey><ordertime>2025-11-06 20:08:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 20:26:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13910094120</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_妇科王兰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>211382199005137121</patientidcard><patientname>张娜</patientname><patientsex>女</patientsex><patientbirthday>1990-05-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13910094120</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 20:26:08
记录内容：select * from  pat_master_index where id_no='211382199005137121' and name='张娜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/5/13 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:26:08
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:26:08
记录内容： 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/11/07','YYYY/MM/DD'),1896,'妇科王兰','上午','2','Z00515855','张娜','','女','35','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/11/06 20:26:06','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071896','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 20:26:08
记录内容：<?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/11/07','YYYY/MM/DD'),1896,'妇科王兰','上午','2','Z00515855','张娜','','女','35','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/11/06 20:26:06','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511071896','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1896,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511071896</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511071896</pinkey><ordertime>2025-11-06 20:26:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 20:36:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18611253062</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_呼吸内科王莉</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370724195502235172</patientidcard><patientname>刘之胜</patientname><patientsex>男</patientsex><patientbirthday>1955-02-23</patientbirthday><medicalrecord></medicalrecord><contactphone>18611253062</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 20:36:44
记录内容：select * from  pat_master_index where id_no='370724195502235172' and name='刘之胜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/2/23 0:00:0070
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:36:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:36:44
记录内容： 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/11/07','YYYY/MM/DD'),1917,'呼吸内科王莉','上午','6','00403185','刘之胜','LIU ZHI SHENG','男','70','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2025/11/06 20:36:41','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511071917','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 20:36:44
记录内容：<?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/11/07','YYYY/MM/DD'),1917,'呼吸内科王莉','上午','6','00403185','刘之胜','LIU ZHI SHENG','男','70','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2025/11/06 20:36:41','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511071917','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王莉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),1917,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511071917</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511071917</pinkey><ordertime>2025-11-06 20:36:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 20:47:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18612902767</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/14 0:00:00_下午_儿童保健李梅</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230221201708215231</patientidcard><patientname>张哲瀚</patientname><patientsex>男</patientsex><patientbirthday>2017-08-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18612902767</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 20:47:09
记录内容：select * from  pat_master_index where id_no='230221201708215231' and name='张哲瀚' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2017/8/21 0:00:008
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:47:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/14','yyyy/mm/dd')
                    and clinic_label = '儿童保健李梅' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 20:47:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/14','YYYY/MM/DD'),1941,'儿童保健李梅','下午','1','10567381','张哲瀚','','男','8','一般人员','自费','','知名专家','1','0304','LIM','1',to_date('2025/11/06 20:47:07','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511141941','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 20:47:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/14','YYYY/MM/DD'),1941,'儿童保健李梅','下午','1','10567381','张哲瀚','','男','8','一般人员','自费','','知名专家','1','0304','LIM','1',to_date('2025/11/06 20:47:07','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511141941','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/11/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿童保健李梅' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/14','YYYY/MM/DD'),1941,'15:30-16:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/14','yyyy/mm/dd')
                    and clinic_label = '儿童保健李梅' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511141941</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511141941</pinkey><ordertime>2025-11-06 20:47:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 21:12:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17812207273</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/8 0:00:00_下午_心血管内郭晓光普</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>410928196304154682</patientidcard><patientname>尚凤美</patientname><patientsex>女</patientsex><patientbirthday>1963-04-15</patientbirthday><medicalrecord></medicalrecord><contactphone>17812207273</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 21:12:45
记录内容：select * from  pat_master_index where id_no='410928196304154682' and name='尚凤美' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1963/4/15 0:00:0062
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 21:12:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 21:12: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/11/08','YYYY/MM/DD'),1970,'心血管内郭晓光普','下午','1','100518477','尚凤美','SHANG FENG MEI ','女','62','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/11/06 21:12:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511081970','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 21:12:46
记录内容：<?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/11/08','YYYY/MM/DD'),1970,'心血管内郭晓光普','下午','1','100518477','尚凤美','SHANG FENG MEI ','女','62','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/11/06 21:12:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511081970','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/11/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内郭晓光普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/08','YYYY/MM/DD'),1970,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/08','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511081970</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511081970</pinkey><ordertime>2025-11-06 21:12:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 21:46:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18611693298</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/11 0:00:00_上午_消化内科吴东方</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230122195310080819</patientidcard><patientname>綦亚平</patientname><patientsex>男</patientsex><patientbirthday>1953-10-08</patientbirthday><medicalrecord></medicalrecord><contactphone>18611693298</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 21:46:25
记录内容：select * from  pat_master_index where id_no='230122195310080819' and name='綦亚平' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1953/10/8 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 21:46:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/11','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 21:46: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/11/11','YYYY/MM/DD'),2011,'消化内科吴东方','上午','2','100402943','綦亚平',' YA PING ','男','72','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2025/11/06 21:46:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511112011','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 21:46:26
记录内容：<?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/11/11','YYYY/MM/DD'),2011,'消化内科吴东方','上午','2','100402943','綦亚平',' YA PING ','男','72','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2025/11/06 21:46:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511112011','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/11/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科吴东方' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/11','YYYY/MM/DD'),2011,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/11','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511112011</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511112011</pinkey><ordertime>2025-11-06 21:46:26</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 22:57:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18447052653</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/9 0:00:00_上午_口腔科赵子墨</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>15282219950420542X</patientidcard><patientname>赵烜赫</patientname><patientsex>女</patientsex><patientbirthday>1995-04-20</patientbirthday><medicalrecord></medicalrecord><contactphone>18447052653</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 22:57:21
记录内容：select * from  pat_master_index where id_no='15282219950420542X' and name='赵烜赫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/4/20 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 22:57:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/09','yyyy/mm/dd')
                    and clinic_label = '口腔科赵子墨' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 22: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/11/09','YYYY/MM/DD'),2089,'口腔科赵子墨','上午','2','100518514','赵烜赫','ZHAO  @HE ','女','30','一般人员','自费','','普通号','1','0319','ZZM','1',to_date('2025/11/06 22:57:19','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511092089','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 22:57:22
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/09','YYYY/MM/DD'),2089,'口腔科赵子墨','上午','2','100518514','赵烜赫','ZHAO  @HE ','女','30','一般人员','自费','','普通号','1','0319','ZZM','1',to_date('2025/11/06 22:57:19','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511092089','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/11/09', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '口腔科赵子墨' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/09','YYYY/MM/DD'),2089,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/09','yyyy/mm/dd')
                    and clinic_label = '口腔科赵子墨' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511092089</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511092089</pinkey><ordertime>2025-11-06 22:57:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 23:06:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19118214345</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_下午_眼科陈璞</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411323200110016375</patientidcard><patientname>杨钊</patientname><patientsex>男</patientsex><patientbirthday>2001-10-01</patientbirthday><medicalrecord></medicalrecord><contactphone>19118214345</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 23:06:18
记录内容：select * from  pat_master_index where id_no='411323200110016375' and name='杨钊' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/10/1 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 23:06:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 23:06: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/11/07','YYYY/MM/DD'),2097,'眼科陈璞','下午','1','00424016','杨钊','YANG ZHAO','男','24','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/11/06 23:06:15','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511072097','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:06: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/11/07','YYYY/MM/DD'),2097,'眼科陈璞','下午','1','00424016','杨钊','YANG ZHAO','男','24','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/11/06 23:06:15','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511072097','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科陈璞' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),2097,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511072097</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511072097</pinkey><ordertime>2025-11-06 23:06:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 23:18:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13131650729</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_产科董建宇副主任</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200008280029</patientidcard><patientname>刘添宇</patientname><patientsex>女</patientsex><patientbirthday>2000-08-28</patientbirthday><medicalrecord></medicalrecord><contactphone>13131650729</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-06 23:18:37
记录内容：select * from  pat_master_index where id_no='131082200008280029' and name='刘添宇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/8/28 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 23:18:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '产科董建宇副主任' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-06 23:18: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/11/07','YYYY/MM/DD'),2106,'产科董建宇副主任','上午','1','100409043','刘添宇','LIU TIAN YU','女','25','一般人员','自费','','副主任号','1','0330','DJY','1',to_date('2025/11/06 23:18:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511072106','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:18: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/11/07','YYYY/MM/DD'),2106,'产科董建宇副主任','上午','1','100409043','刘添宇','LIU TIAN YU','女','25','一般人员','自费','','副主任号','1','0330','DJY','1',to_date('2025/11/06 23:18:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511072106','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/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科董建宇副主任' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),2106,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '产科董建宇副主任' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511072106</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511072106</pinkey><ordertime>2025-11-06 23:18:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-06 23:24:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13436448405</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_妇科王兰</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130229199306117222</patientidcard><patientname>郑美静</patientname><patientsex>女</patientsex><patientbirthday>1993-06-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13436448405</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-11-06 23:24:03
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/11/07','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科王兰' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='130229199306117222' and name='郑美静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:24:03
记录内容：<?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-11-06 23:27:54
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13436448405</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_妇科王兰</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130229199306117222</patientidcard><patientname>郑美静</patientname><patientsex>女</patientsex><patientbirthday>1993-06-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13436448405</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-11-06 23:27:54
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/11/07','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科王兰' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='130229199306117222' and name='郑美静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:27:54
记录内容：<?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-11-06 23:29:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13436448405</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_妇科王兰</scheduleid><parttimeid>11.30-12:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130229199306117222</patientidcard><patientname>郑美静</patientname><patientsex>女</patientsex><patientbirthday>1993-06-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13436448405</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-11-06 23:29:28
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/11/07','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科王兰' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='130229199306117222' and name='郑美静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:29:28
记录内容：<?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-11-06 23:31:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13436448405</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_妇科王兰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130229199306117222</patientidcard><patientname>郑美静</patientname><patientsex>女</patientsex><patientbirthday>1993-06-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13436448405</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-11-06 23:31:15
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/11/07','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科王兰' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='130229199306117222' and name='郑美静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:31:15
记录内容：<?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-11-06 23:32:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13436448405</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_白天_妇科李二雷</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130229199306117222</patientidcard><patientname>郑美静</patientname><patientsex>女</patientsex><patientbirthday>1993-06-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13436448405</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-11-06 23:32:31
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/11/07','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科李二雷' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='130229199306117222' and name='郑美静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-06 23:32:31
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆