◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 07:09:01
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17374447543</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/7 0:00:00_上午_耳鼻喉科吴胜杰</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230182199303245894</patientidcard><patientname>冯永存</patientname><patientsex>男</patientsex><patientbirthday>1993-03-24</patientbirthday><medicalrecord></medicalrecord><contactphone>17374447543</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 07:09:01
记录内容：select * from  pat_master_index where id_no='230182199303245894' and name='冯永存' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/3/24 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 07:09:01
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 07:09:01
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/07','YYYY/MM/DD'),25,'耳鼻喉科吴胜杰','上午','2','100512413','冯永存','FENG YONG CUN ','男','32','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2025/10/05 07:09:05','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510070025','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 07:09:01
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/07','YYYY/MM/DD'),25,'耳鼻喉科吴胜杰','上午','2','100512413','冯永存','FENG YONG CUN ','男','32','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2025/10/05 07:09:05','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510070025','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科吴胜杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/07','YYYY/MM/DD'),25,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>2025100725</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>2025100725</pinkey><ordertime>2025-10-05 07:09:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 08:13:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15004627209</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/12 0:00:00_上午_皮肤科杨维玲</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230227199201090845</patientidcard><patientname>吴迪</patientname><patientsex>女</patientsex><patientbirthday>1992-01-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15004627209</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 08:13:16
记录内容：select * from  pat_master_index where id_no='230227199201090845' and name='吴迪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/1/9 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 08:13:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/12','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 08:13: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/10/12','YYYY/MM/DD'),478,'皮肤科杨维玲','上午','1','100512301','吴迪','WU DI ','女','33','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/10/05 08:13:20','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510120478','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 08:13: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/10/12','YYYY/MM/DD'),478,'皮肤科杨维玲','上午','1','100512301','吴迪','WU DI ','女','33','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/10/05 08:13:20','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510120478','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/12','YYYY/MM/DD'),478,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/12','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20251012478</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>20251012478</pinkey><ordertime>2025-10-05 08:13:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 08:41:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15230103800</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/8 0:00:00_上午_骨科张晓刚</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130121200003170084</patientidcard><patientname>谷子妤</patientname><patientsex>女</patientsex><patientbirthday>2000-03-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15230103800</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 08:41:32
记录内容：select * from  pat_master_index where id_no='130121200003170084' and name='谷子妤' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/3/17 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 08:41:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/08','yyyy/mm/dd')
                    and clinic_label = '骨科张晓刚' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 08:41:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/08','YYYY/MM/DD'),1231,'骨科张晓刚','上午','2','100405032','谷子妤','GU ZI  ','女','25','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2025/10/05 08:41:35','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510081231','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 08:41:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/08','YYYY/MM/DD'),1231,'骨科张晓刚','上午','2','100405032','谷子妤','GU ZI  ','女','25','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2025/10/05 08:41:35','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510081231','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/08', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科张晓刚' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/08','YYYY/MM/DD'),1231,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/08','yyyy/mm/dd')
                    and clinic_label = '骨科张晓刚' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510081231</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510081231</pinkey><ordertime>2025-10-05 08:41:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 08:43:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13944884731</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_下午_眼科郭苗苗</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>220102200701096320</patientidcard><patientname>代雯宇</patientname><patientsex>女</patientsex><patientbirthday>2007-01-09</patientbirthday><medicalrecord></medicalrecord><contactphone>13944884731</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 08:43:18
记录内容：select * from  pat_master_index where id_no='220102200701096320' and name='代雯宇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/1/9 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 08:43:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 08:43:18
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1287,'眼科郭苗苗','下午','1','100512416','代雯宇','DAI  YU ','女','18','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 08:43:22','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510061287','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 08:43:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1287,'眼科郭苗苗','下午','1','100512416','代雯宇','DAI  YU ','女','18','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 08:43:22','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510061287','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科郭苗苗' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1287,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510061287</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510061287</pinkey><ordertime>2025-10-05 08:43:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 09:03:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17333649988</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_心血管内科谭琛</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821196609103717</patientidcard><patientname>贾长华</patientname><patientsex>男</patientsex><patientbirthday>1966-09-10</patientbirthday><medicalrecord></medicalrecord><contactphone>17333649988</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 09:03:09
记录内容：select * from  pat_master_index where id_no='132821196609103717' and name='贾长华' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1966/9/10 0:00:0059
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 09:03:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 09:03: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/10/06','YYYY/MM/DD'),1814,'心血管内科谭琛','上午','13','100511982','贾长华','JIA CHANG HUA ','男','59','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/10/05 09:03:13','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510061814','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 09:03: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/10/06','YYYY/MM/DD'),1814,'心血管内科谭琛','上午','13','100511982','贾长华','JIA CHANG HUA ','男','59','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/10/05 09:03:13','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510061814','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1814,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510061814</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510061814</pinkey><ordertime>2025-10-05 09:03:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 09:07:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13363630893</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_内分泌科张金环普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>220122200205133124</patientidcard><patientname>王玉涵</patientname><patientsex>女</patientsex><patientbirthday>2002-05-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13363630893</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 09:07:19
记录内容：select * from  pat_master_index where id_no='220122200205133124' and name='王玉涵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/5/13 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 09:07:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 09:07:19
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1917,'内分泌科张金环普','上午','2','100512425','王玉涵','WANG YU HAN ','女','23','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/10/05 09:07:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510061917','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 09:07:19
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1917,'内分泌科张金环普','上午','2','100512425','王玉涵','WANG YU HAN ','女','23','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/10/05 09:07:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510061917','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),1917,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510061917</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510061917</pinkey><ordertime>2025-10-05 09:07:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 10:27:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17731606757</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_便秘门诊胡珉</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13042320020517172X</patientidcard><patientname>杨逸涵</patientname><patientsex>女</patientsex><patientbirthday>2002-05-17</patientbirthday><medicalrecord></medicalrecord><contactphone>17731606757</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 10:27:55
记录内容：select * from  pat_master_index where id_no='13042320020517172X' and name='杨逸涵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/5/17 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 10:27:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '便秘门诊胡珉' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 10:27:55
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),3735,'便秘门诊胡珉','下午','1','100512428','杨逸涵','YANG YI HAN ','女','23','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/05 10:27:59','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510053735','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 10:27:55
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),3735,'便秘门诊胡珉','下午','1','100512428','杨逸涵','YANG YI HAN ','女','23','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/05 10:27:59','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510053735','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '便秘门诊胡珉' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),3735,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '便秘门诊胡珉' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510053735</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510053735</pinkey><ordertime>2025-10-05 10:27:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 10:29:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15510577300</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_中医科陈光献</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23102519740731462X</patientidcard><patientname>姜玲</patientname><patientsex>女</patientsex><patientbirthday>1974-07-31</patientbirthday><medicalrecord></medicalrecord><contactphone>15510577300</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-05 10:29:01
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/05','YYYY-MM-DD')
            AND CLINIC_LABEL='中医科陈光献' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='23102519740731462X' and name='姜玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 10:29:01
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 10:31:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15510577300</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_中医科陈光献</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23102519740731462X</patientidcard><patientname>姜玲</patientname><patientsex>女</patientsex><patientbirthday>1974-07-31</patientbirthday><medicalrecord></medicalrecord><contactphone>15510577300</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-05 10:31:11
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/05','YYYY-MM-DD')
            AND CLINIC_LABEL='中医科陈光献' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='23102519740731462X' and name='姜玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 10:31:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 10:56:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19521529992</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_泌尿外科唐伟</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220702199705139612</patientidcard><patientname>马一阳</patientname><patientsex>男</patientsex><patientbirthday>1997-05-13</patientbirthday><medicalrecord></medicalrecord><contactphone>19521529992</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 10:56:14
记录内容：select * from  pat_master_index where id_no='220702199705139612' and name='马一阳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/5/13 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 10:56:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 10:56:14
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),4345,'泌尿外科唐伟','下午','1','100512456','马一阳','MA YI YANG ','男','28','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/05 10:56:18','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510054345','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 10:56:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),4345,'泌尿外科唐伟','下午','1','100512456','马一阳','MA YI YANG ','男','28','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/05 10:56:18','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510054345','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科唐伟' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),4345,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510054345</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510054345</pinkey><ordertime>2025-10-05 10:56:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 12:36:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18301587572</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_泌尿外科唐伟</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230306194903055316</patientidcard><patientname>马德胜</patientname><patientsex>男</patientsex><patientbirthday>1949-03-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18301587572</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 12:36:12
记录内容：select * from  pat_master_index where id_no='230306194903055316' and name='马德胜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/3/5 0:00:0076
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 12:36:12
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 12:36:12
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),5151,'泌尿外科唐伟','下午','2','100250276','马德胜','MA DE SHENG ','男','76','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/05 12:36:14','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510055151','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 12:36:12
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),5151,'泌尿外科唐伟','下午','2','100250276','马德胜','MA DE SHENG ','男','76','一般人员','自费','','主任号','1','0311','TW','1',to_date('2025/10/05 12:36:14','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510055151','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科唐伟' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),5151,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510055151</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510055151</pinkey><ordertime>2025-10-05 12:36:12</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 13:48:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18831682599</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/18 0:00:00_上午_眼科刘淑琴</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132624195609032043</patientidcard><patientname>侯春香</patientname><patientsex>女</patientsex><patientbirthday>1956-09-03</patientbirthday><medicalrecord></medicalrecord><contactphone>18831682599</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 13:48:34
记录内容：select * from  pat_master_index where id_no='132624195609032043' and name='侯春香' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1956/9/3 0:00:0069
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 13:48:34
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/18','yyyy/mm/dd')
                    and clinic_label = '眼科刘淑琴' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 13:48:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/18','YYYY/MM/DD'),5662,'眼科刘淑琴','上午','1','100402851','侯春香','HOU CHUN XIANG ','女','69','一般人员','自费','','知名专家','1','0327','LSQ','1',to_date('2025/10/05 13:48:36','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510185662','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 13:48:34
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/18','YYYY/MM/DD'),5662,'眼科刘淑琴','上午','1','100402851','侯春香','HOU CHUN XIANG ','女','69','一般人员','自费','','知名专家','1','0327','LSQ','1',to_date('2025/10/05 13:48:36','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510185662','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科刘淑琴' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/18','YYYY/MM/DD'),5662,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/18','yyyy/mm/dd')
                    and clinic_label = '眼科刘淑琴' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510185662</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510185662</pinkey><ordertime>2025-10-05 13:48:34</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 14:26:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13363607586</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_儿科刘婕</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082201308250854</patientidcard><patientname>程文昊</patientname><patientsex>男</patientsex><patientbirthday>2013-08-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13363607586</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 14:26:53
记录内容：select * from  pat_master_index where id_no='131082201308250854' and name='程文昊' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2013/8/25 0:00:0012
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 14:26:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 14:26:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6152,'儿科刘婕','下午','4','10752907','程文昊','','男','12','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/10/05 14:26:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510056152','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','22') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 14:26:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6152,'儿科刘婕','下午','4','10752907','程文昊','','男','12','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/10/05 14:26:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510056152','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','22') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6152,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510056152</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510056152</pinkey><ordertime>2025-10-05 14:26:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 14:27:41
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18614036970</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_消化内科刘正新</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>510902197105294564</patientidcard><patientname>伍利容</patientname><patientsex>女</patientsex><patientbirthday>1971-05-29</patientbirthday><medicalrecord></medicalrecord><contactphone>18614036970</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 14:27:42
记录内容：select * from  pat_master_index where id_no='510902197105294564' and name='伍利容' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/5/29 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 14:27:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '消化内科刘正新' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 14:27:42
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),6167,'消化内科刘正新','上午','3','100230200','伍利容','WU LI RONG','女','54','一般人员','自费','','知名专家','1','0302','CYLZX','1',to_date('2025/10/05 14:27:44','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510066167','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 14:27:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),6167,'消化内科刘正新','上午','3','100230200','伍利容','WU LI RONG','女','54','一般人员','自费','','知名专家','1','0302','CYLZX','1',to_date('2025/10/05 14:27:44','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510066167','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科刘正新' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),6167,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '消化内科刘正新' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510066167</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510066167</pinkey><ordertime>2025-10-05 14:27:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 14:30:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210034838</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/5 0:00:00_下午_眼科郭苗苗</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130637198207200327</patientidcard><patientname>刘博青</patientname><patientsex>女</patientsex><patientbirthday>1982-07-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15210034838</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 14:30:49
记录内容：select * from  pat_master_index where id_no='130637198207200327' and name='刘博青' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/7/20 0:00:0043
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 14:30:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 14:30:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6223,'眼科郭苗苗','下午','26','00427075','刘博青','LIU BO QING','女','43','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 14:30:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510056223','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','55') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 14:30:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6223,'眼科郭苗苗','下午','26','00427075','刘博青','LIU BO QING','女','43','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 14:30:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510056223','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','55') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科郭苗苗' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/05','YYYY/MM/DD'),6223,'15:30-16:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/05','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510056223</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510056223</pinkey><ordertime>2025-10-05 14:30:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 15:43:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18911763189</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_耳鼻喉科吴胜杰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132421196402141378</patientidcard><patientname>郝术彬</patientname><patientsex>男</patientsex><patientbirthday>1964-02-14</patientbirthday><medicalrecord></medicalrecord><contactphone>18911763189</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 15:43:18
记录内容：select * from  pat_master_index where id_no='132421196402141378' and name='郝术彬' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1964/2/14 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 15:43:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 15:43:18
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7054,'耳鼻喉科吴胜杰','上午','6','100512474','郝术彬','HAO SHU BIN ','男','61','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2025/10/05 15:43:20','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067054','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 15:43:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7054,'耳鼻喉科吴胜杰','上午','6','100512474','郝术彬','HAO SHU BIN ','男','61','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2025/10/05 15:43:20','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067054','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科吴胜杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7054,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510067054</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067054</pinkey><ordertime>2025-10-05 15:43:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 16:25:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15201422631</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_下午_心血管内科谭琛</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>420984199312243315</patientidcard><patientname>林鹏飞</patientname><patientsex>男</patientsex><patientbirthday>1993-12-24</patientbirthday><medicalrecord></medicalrecord><contactphone>15201422631</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 16:25:55
记录内容：select * from  pat_master_index where id_no='420984199312243315' and name='林鹏飞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/12/24 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 16:25:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 16:25:55
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7404,'心血管内科谭琛','下午','4','Z00276417','林鹏飞','','男','32','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/10/05 16:25:57','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510067404','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 16:25:55
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7404,'心血管内科谭琛','下午','4','Z00276417','林鹏飞','','男','32','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/10/05 16:25:57','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510067404','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科谭琛' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7404,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510067404</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510067404</pinkey><ordertime>2025-10-05 16:25:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 18:55:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15201422631</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_心血管内陶林森普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>420984199312243315</patientidcard><patientname>林鹏飞</patientname><patientsex>男</patientsex><patientbirthday>1993-12-24</patientbirthday><medicalrecord></medicalrecord><contactphone>15201422631</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 18:55:11
记录内容：select * from  pat_master_index where id_no='420984199312243315' and name='林鹏飞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/12/24 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 18:55:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 18:55: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/10/06','YYYY/MM/DD'),7687,'心血管内陶林森普','上午','3','Z00276417','林鹏飞','','男','32','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/10/05 18:55:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067687','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 18:55: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/10/06','YYYY/MM/DD'),7687,'心血管内陶林森普','上午','3','Z00276417','林鹏飞','','男','32','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/10/05 18:55:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067687','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内陶林森普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7687,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510067687</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067687</pinkey><ordertime>2025-10-05 18:55:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 21:07:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18189668979</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/7 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>620103200506242629</patientidcard><patientname>徐瑞</patientname><patientsex>女</patientsex><patientbirthday>2005-06-24</patientbirthday><medicalrecord></medicalrecord><contactphone>18189668979</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 21:07:36
记录内容：select * from  pat_master_index where id_no='620103200506242629' and name='徐瑞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/6/24 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 21:07:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 21:07:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/07','YYYY/MM/DD'),7782,'皮肤科常庆华','上午','1','Z00453838','徐瑞','XU RUI','女','20','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/05 21:07:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510077782','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 21:07:36
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>失败，插入订单表失败1 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/07','YYYY/MM/DD'),7782,'皮肤科常庆华','上午','1','Z00453838','徐瑞','XU RUI','女','20','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/05 21:07:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510077782','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午'select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 21:11:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18611368572</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/9 0:00:00_上午_消化内科吴东方</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>222302195501236228</patientidcard><patientname>张玉苹</patientname><patientsex>女</patientsex><patientbirthday>1955-01-23</patientbirthday><medicalrecord></medicalrecord><contactphone>18611368572</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 21:11:13
记录内容：select * from  pat_master_index where id_no='222302195501236228' and name='张玉苹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/1/23 0:00:0070
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 21:11:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/09','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 21:11: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/10/09','YYYY/MM/DD'),7785,'消化内科吴东方','上午','2','00443474','张玉苹','','女','70','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2025/10/05 21:11:14','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510097785','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 21:11: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/10/09','YYYY/MM/DD'),7785,'消化内科吴东方','上午','2','00443474','张玉苹','','女','70','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2025/10/05 21:11:14','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510097785','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/09', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科吴东方' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/09','YYYY/MM/DD'),7785,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/09','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510097785</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510097785</pinkey><ordertime>2025-10-05 21:11:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 21:56:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15030626308</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/7 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199307186813</patientidcard><patientname>杨宇</patientname><patientsex>男</patientsex><patientbirthday>1993-07-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15030626308</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 21:56:05
记录内容：select * from  pat_master_index where id_no='131028199307186813' and name='杨宇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/7/18 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 21:56:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 21:56: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/10/07','YYYY/MM/DD'),7807,'皮肤科常庆华','上午','2','100512558','杨宇','YANG YU ','男','32','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/05 21:56:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510077807','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 21:56: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/10/07','YYYY/MM/DD'),7807,'皮肤科常庆华','上午','2','100512558','杨宇','YANG YU ','男','32','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/05 21:56:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510077807','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/07','YYYY/MM/DD'),7807,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/07','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510077807</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510077807</pinkey><ordertime>2025-10-05 21:56:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:25:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18245676727</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_白天_妇科刘冬梅</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>231181199504211628</patientidcard><patientname>全慧颖</patientname><patientsex>女</patientsex><patientbirthday>1995-04-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18245676727</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:25:44
记录内容：select * from  pat_master_index where id_no='231181199504211628' and name='全慧颖' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/4/21 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:25:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:25: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/10/06','YYYY/MM/DD'),7823,'妇科刘冬梅','白天','1','100512561','全慧颖','QUAN HUI YING ','女','30','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2025/10/05 22:25:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067823','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:25: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/10/06','YYYY/MM/DD'),7823,'妇科刘冬梅','白天','1','100512561','全慧颖','QUAN HUI YING ','女','30','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2025/10/05 22:25:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067823','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科刘冬梅' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7823,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202510067823</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067823</pinkey><ordertime>2025-10-05 22:25:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:29:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15600017789</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_生殖男科富鹤普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232126199702253956</patientidcard><patientname>李春双</patientname><patientsex>男</patientsex><patientbirthday>1997-02-25</patientbirthday><medicalrecord></medicalrecord><contactphone>15600017789</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:29:13
记录内容：select * from  pat_master_index where id_no='232126199702253956' and name='李春双' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/2/25 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:29:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:29: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/10/06','YYYY/MM/DD'),7824,'生殖男科富鹤普','上午','1','100512562','李春双','LI CHUN SHUANG ','男','28','一般人员','自费','','普通号','1','0371','FH','1',to_date('2025/10/05 22:29:13','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067824','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:29: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/10/06','YYYY/MM/DD'),7824,'生殖男科富鹤普','上午','1','100512562','李春双','LI CHUN SHUANG ','男','28','一般人员','自费','','普通号','1','0371','FH','1',to_date('2025/10/05 22:29:13','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067824','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '生殖男科富鹤普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7824,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510067824</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067824</pinkey><ordertime>2025-10-05 22:29:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:31:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932622833</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_骨科张晓刚</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200006070011</patientidcard><patientname>海嘉鑫</patientname><patientsex>男</patientsex><patientbirthday>2000-06-07</patientbirthday><medicalrecord></medicalrecord><contactphone>15932622833</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-05 22:31:36
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/06','YYYY-MM-DD')
            AND CLINIC_LABEL='骨科张晓刚' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='131028200006070011' and name='海嘉鑫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:31:36
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:31:51
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15101578931</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_眼科郭苗苗</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232330198907154426</patientidcard><patientname>姚凤影</patientname><patientsex>女</patientsex><patientbirthday>1989-07-15</patientbirthday><medicalrecord></medicalrecord><contactphone>15101578931</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:31:51
记录内容：select * from  pat_master_index where id_no='232330198907154426' and name='姚凤影' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/7/15 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:31:51
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:31:51
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7825,'眼科郭苗苗','上午','1','100308558','姚凤影','YAO FENG YING ','女','36','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 22:31:51','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067825','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:31:51
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7825,'眼科郭苗苗','上午','1','100308558','姚凤影','YAO FENG YING ','女','36','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 22:31:51','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067825','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科郭苗苗' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7825,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510067825</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067825</pinkey><ordertime>2025-10-05 22:31:51</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:32:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15101578931</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_眼科郭苗苗</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230621198506063652</patientidcard><patientname>毕广瑞</patientname><patientsex>男</patientsex><patientbirthday>1985-06-06</patientbirthday><medicalrecord></medicalrecord><contactphone>15101578931</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:32:57
记录内容：select * from  pat_master_index where id_no='230621198506063652' and name='毕广瑞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1985/6/6 0:00:0040
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:32:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:32:57
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7826,'眼科郭苗苗','上午','2','Z00369369','毕广瑞','','男','40','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 22:32:58','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067826','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:32:57
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7826,'眼科郭苗苗','上午','2','Z00369369','毕广瑞','','男','40','一般人员','自费','','普通号','1','0327','GMM01','1',to_date('2025/10/05 22:32:58','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067826','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科郭苗苗' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7826,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '眼科郭苗苗' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510067826</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067826</pinkey><ordertime>2025-10-05 22:32:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:33:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932622833</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_骨科张晓刚</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200006070011</patientidcard><patientname>海嘉鑫</patientname><patientsex>男</patientsex><patientbirthday>2000-06-07</patientbirthday><medicalrecord></medicalrecord><contactphone>15932622833</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-05 22:33:27
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/06','YYYY-MM-DD')
            AND CLINIC_LABEL='骨科张晓刚' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='131028200006070011' and name='海嘉鑫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:33:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:33:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18911515166</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/9 0:00:00_上午_神经内科夏德雨</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132828196805256512</patientidcard><patientname>薛铜山</patientname><patientsex>男</patientsex><patientbirthday>1968-05-25</patientbirthday><medicalrecord></medicalrecord><contactphone>18911515166</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:33:29
记录内容：select * from  pat_master_index where id_no='132828196805256512' and name='薛铜山' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/5/25 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:33:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/09','yyyy/mm/dd')
                    and clinic_label = '神经内科夏德雨' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:33:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/09','YYYY/MM/DD'),7828,'神经内科夏德雨','上午','1','10567137','薛铜山','','男','57','一般人员','自费','','副主任号','1','0303','XDY1','1',to_date('2025/10/05 22:33:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510097828','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:33:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/09','YYYY/MM/DD'),7828,'神经内科夏德雨','上午','1','10567137','薛铜山','','男','57','一般人员','自费','','副主任号','1','0303','XDY1','1',to_date('2025/10/05 22:33:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510097828','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/09', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科夏德雨' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/09','YYYY/MM/DD'),7828,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/09','yyyy/mm/dd')
                    and clinic_label = '神经内科夏德雨' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510097828</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510097828</pinkey><ordertime>2025-10-05 22:33:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:36:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932622833</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_下午_骨科刘海峰</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200006070011</patientidcard><patientname>海嘉鑫</patientname><patientsex>男</patientsex><patientbirthday>2000-06-07</patientbirthday><medicalrecord></medicalrecord><contactphone>15932622833</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-05 22:36:03
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/06','YYYY-MM-DD')
            AND CLINIC_LABEL='骨科刘海峰' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='131028200006070011' and name='海嘉鑫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:36: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-10-05 22:37:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18731602534</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_下午_消化内科李颖飞</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>371421197805204212</patientidcard><patientname>王树豹</patientname><patientsex>男</patientsex><patientbirthday>1978-05-20</patientbirthday><medicalrecord></medicalrecord><contactphone>18731602534</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:37:31
记录内容：select * from  pat_master_index where id_no='371421197805204212' and name='王树豹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/5/20 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:37:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '消化内科李颖飞' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:37:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7832,'消化内科李颖飞','下午','1','Z00302318','王树豹','','男','47','一般人员','自费','','普通号','1','0302','LIYF','1',to_date('2025/10/05 22:37:32','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067832','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:37:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7832,'消化内科李颖飞','下午','1','Z00302318','王树豹','','男','47','一般人员','自费','','普通号','1','0302','LIYF','1',to_date('2025/10/05 22:37:32','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067832','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科李颖飞' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7832,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '消化内科李颖飞' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510067832</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067832</pinkey><ordertime>2025-10-05 22:37:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 22:51:51
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19554478875</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_白天_妇科刘冬梅</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13063320021126212x</patientidcard><patientname>范嘉伟</patientname><patientsex>女</patientsex><patientbirthday>2002-11-26</patientbirthday><medicalrecord></medicalrecord><contactphone>19554478875</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 22:51:51
记录内容：select * from  pat_master_index where id_no='13063320021126212x' and name='范嘉伟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/11/26 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:51:51
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 22:51:51
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7844,'妇科刘冬梅','白天','2','100512400','范嘉伟','FAN JIA WEI ','女','23','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2025/10/05 22:51:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067844','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 22:51:51
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7844,'妇科刘冬梅','白天','2','100512400','范嘉伟','FAN JIA WEI ','女','23','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2025/10/05 22:51:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067844','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科刘冬梅' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7844,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202510067844</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067844</pinkey><ordertime>2025-10-05 22:51:51</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 23:15:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15128457559</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_上午_普通外科牛朋军</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230223200410081638</patientidcard><patientname>孟令麒</patientname><patientsex>男</patientsex><patientbirthday>2004-10-08</patientbirthday><medicalrecord></medicalrecord><contactphone>15128457559</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 23:15:38
记录内容：select * from  pat_master_index where id_no='230223200410081638' and name='孟令麒' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/10/8 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 23:15:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '普通外科牛朋军' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 23:15:38
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7859,'普通外科牛朋军','上午','1','100380891','孟令麒','MENG LING  ','男','21','一般人员','自费','','普通号','1','0335','NPJ','1',to_date('2025/10/05 23:15:38','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067859','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 23:15:38
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7859,'普通外科牛朋军','上午','1','100380891','孟令麒','MENG LING  ','男','21','一般人员','自费','','普通号','1','0335','NPJ','1',to_date('2025/10/05 23:15:38','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510067859','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科牛朋军' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7859,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '普通外科牛朋军' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510067859</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510067859</pinkey><ordertime>2025-10-05 23:15:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-05 23:30:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15288779356</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/6 0:00:00_白天_妇科薛利娟副主任</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370683200110019225</patientidcard><patientname>尼汶冉</patientname><patientsex>女</patientsex><patientbirthday>2001-10-01</patientbirthday><medicalrecord></medicalrecord><contactphone>15288779356</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-05 23:30:53
记录内容：select * from  pat_master_index where id_no='370683200110019225' and name='尼汶冉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/10/1 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 23:30:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '妇科薛利娟副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-05 23:30:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7874,'妇科薛利娟副主任','白天','3','100290236','尼汶冉','NI  RAN ','女','24','一般人员','自费','','副主任号','1','0316','XUELJ','1',to_date('2025/10/05 23:30:53','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510067874','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-05 23:30:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7874,'妇科薛利娟副主任','白天','3','100290236','尼汶冉','NI  RAN ','女','24','一般人员','自费','','副主任号','1','0316','XUELJ','1',to_date('2025/10/05 23:30:53','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510067874','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科薛利娟副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/06','YYYY/MM/DD'),7874,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/06','yyyy/mm/dd')
                    and clinic_label = '妇科薛利娟副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202510067874</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510067874</pinkey><ordertime>2025-10-05 23:30:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆