◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 08:31:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19293121334</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_眼科陈璞</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13068120060318474X</patientidcard><patientname>唐悦宁</patientname><patientsex>女</patientsex><patientbirthday>2006-03-18</patientbirthday><medicalrecord></medicalrecord><contactphone>19293121334</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 08:31:47
记录内容：select * from  pat_master_index where id_no='13068120060318474X' and name='唐悦宁' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/3/18 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:31:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:31:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),4867,'眼科陈璞','下午','1','100513290','唐悦宁','TANG YUE NING ','女','19','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 08:31:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510104867','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 08:31:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),4867,'眼科陈璞','下午','1','100513290','唐悦宁','TANG YUE NING ','女','19','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 08:31:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510104867','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/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科陈璞' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),4867,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510104867</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510104867</pinkey><ordertime>2025-10-10 08:31:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 08:36:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15795392773</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/15 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>640104200411272817</patientidcard><patientname>刘易</patientname><patientsex>男</patientsex><patientbirthday>2004-11-27</patientbirthday><medicalrecord></medicalrecord><contactphone>15795392773</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 08:36:21
记录内容：select * from  pat_master_index where id_no='640104200411272817' and name='刘易' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/11/27 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:36:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/15','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:36:21
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/15','YYYY/MM/DD'),5054,'皮肤科常庆华','下午','2','100513291','刘易','LIU YI ','男','21','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/10 08:36:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510155054','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 08:36:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/15','YYYY/MM/DD'),5054,'皮肤科常庆华','下午','2','100513291','刘易','LIU YI ','男','21','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2025/10/10 08:36:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510155054','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/15', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/15','YYYY/MM/DD'),5054,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/15','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510155054</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510155054</pinkey><ordertime>2025-10-10 08:36:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 08:40:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13845247158</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/13 0:00:00_上午_心慌门诊谭琛</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230231196909161822</patientidcard><patientname>杨立杰</patientname><patientsex>女</patientsex><patientbirthday>1969-09-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13845247158</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 08:40:15
记录内容：select * from  pat_master_index where id_no='230231196909161822' and name='杨立杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/9/16 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:40:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/13','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:40:15
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/13','YYYY/MM/DD'),5213,'心慌门诊谭琛','上午','2','100513284','杨立杰','YANG LI JIE ','女','56','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/10/10 08:40:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510135213','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 08:40:15
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/13','YYYY/MM/DD'),5213,'心慌门诊谭琛','上午','2','100513284','杨立杰','YANG LI JIE ','女','56','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/10/10 08:40:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510135213','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/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心慌门诊谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/13','YYYY/MM/DD'),5213,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/13','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510135213</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510135213</pinkey><ordertime>2025-10-10 08:40:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 08:56:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19339361010</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_医疗美容科张昉</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131002199806123442</patientidcard><patientname>孙建媛</patientname><patientsex>女</patientsex><patientbirthday>1998-06-12</patientbirthday><medicalrecord></medicalrecord><contactphone>19339361010</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 08:56:43
记录内容：select * from  pat_master_index where id_no='131002199806123442' and name='孙建媛' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1998/6/12 0:00:0027
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:56:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '医疗美容科张昉' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 08:56:43
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),5860,'医疗美容科张昉','下午','1','100513302','孙建媛','SUN JIAN  ','女','27','一般人员','自费','','副主任号','1','03109','ZF','1',to_date('2025/10/10 08:56:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510105860','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 08:56:43
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),5860,'医疗美容科张昉','下午','1','100513302','孙建媛','SUN JIAN  ','女','27','一般人员','自费','','副主任号','1','03109','ZF','1',to_date('2025/10/10 08:56:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510105860','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/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '医疗美容科张昉' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),5860,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '医疗美容科张昉' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510105860</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510105860</pinkey><ordertime>2025-10-10 08:56:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 09:00:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15510456527</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_产科王振燕</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130424199002161629</patientidcard><patientname>李贝贝</patientname><patientsex>女</patientsex><patientbirthday>1990-02-16</patientbirthday><medicalrecord></medicalrecord><contactphone>15510456527</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 09:00:55
记录内容：select * from  pat_master_index where id_no='130424199002161629' and name='李贝贝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/2/16 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 09:00:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 09:00: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/11','YYYY/MM/DD'),6017,'产科王振燕','上午','1','100117658','李贝贝','LI BEI BEI ','女','35','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/10/10 09:01:03','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510116017','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 09:00: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/11','YYYY/MM/DD'),6017,'产科王振燕','上午','1','100117658','李贝贝','LI BEI BEI ','女','35','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/10/10 09:01:03','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510116017','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),6017,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510116017</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510116017</pinkey><ordertime>2025-10-10 09:00:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 09:32:35
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13681360028</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_中医针灸马艾菲</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199002102068</patientidcard><patientname>李百会</patientname><patientsex>女</patientsex><patientbirthday>1990-02-10</patientbirthday><medicalrecord></medicalrecord><contactphone>13681360028</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 09:32:35
记录内容：select * from  pat_master_index where id_no='131028199002102068' and name='李百会' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/2/10 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 09:32:35
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '中医针灸马艾菲' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 09:32:35
记录内容： 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/10','YYYY/MM/DD'),7157,'中医针灸马艾菲','下午','1','100353881','李百会','LI BAI HUI ','女','35','一般人员','自费','','中副主任','1','0301','MAAF','1',to_date('2025/10/10 09:32:44','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510107157','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 09:32:35
记录内容：<?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/10','YYYY/MM/DD'),7157,'中医针灸马艾菲','下午','1','100353881','李百会','LI BAI HUI ','女','35','一般人员','自费','','中副主任','1','0301','MAAF','1',to_date('2025/10/10 09:32:44','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510107157','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/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医针灸马艾菲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),7157,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '中医针灸马艾菲' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510107157</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510107157</pinkey><ordertime>2025-10-10 09:32:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 09:36:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13501324426</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/14 0:00:00_上午_颈肩腰腿痛刘海峰</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>222402197505190612</patientidcard><patientname>崔承赫</patientname><patientsex>男</patientsex><patientbirthday>1975-05-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13501324426</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 09:36:16
记录内容：select * from  pat_master_index where id_no='222402197505190612' and name='崔承赫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1975/5/19 0:00:0050
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 09:36:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/14','yyyy/mm/dd')
                    and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 09:36: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/14','YYYY/MM/DD'),7293,'颈肩腰腿痛刘海峰','上午','1','Z00255048','崔承赫','CUI CHENG HE','男','50','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2025/10/10 09:36:25','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510147293','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 09:36: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/14','YYYY/MM/DD'),7293,'颈肩腰腿痛刘海峰','上午','1','Z00255048','崔承赫','CUI CHENG HE','男','50','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2025/10/10 09:36:25','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510147293','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '颈肩腰腿痛刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/14','YYYY/MM/DD'),7293,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/14','yyyy/mm/dd')
                    and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510147293</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510147293</pinkey><ordertime>2025-10-10 09:36:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 10:16:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13833629760</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200501215861</patientidcard><patientname>华雪静</patientname><patientsex>女</patientsex><patientbirthday>2005-01-21</patientbirthday><medicalrecord></medicalrecord><contactphone>13833629760</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 10:16:47
记录内容：select * from  pat_master_index where id_no='131082200501215861' and name='华雪静' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/1/21 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 10:16:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 10:16:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),8657,'内分泌科马伟杰普','上午','2','Z00255760','华雪静','HUA XUE JING','女','20','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/10/10 10:16:55','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510118657','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 10:16:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),8657,'内分泌科马伟杰普','上午','2','Z00255760','华雪静','HUA XUE JING','女','20','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/10/10 10:16:55','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510118657','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),8657,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510118657</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510118657</pinkey><ordertime>2025-10-10 10:16:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 11:54:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19286870724</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130206200407242314</patientidcard><patientname>徐浩凯</patientname><patientsex>男</patientsex><patientbirthday>2004-07-24</patientbirthday><medicalrecord></medicalrecord><contactphone>19286870724</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 11:54:18
记录内容：select * from  pat_master_index where id_no='130206200407242314' and name='徐浩凯' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/7/24 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 11:54:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 11:54: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/11','YYYY/MM/DD'),753,'内分泌科马伟杰普','上午','4','10764326','徐浩凯','','男','21','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/10/10 11:54:26','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510110753','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 11:54: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/11','YYYY/MM/DD'),753,'内分泌科马伟杰普','上午','4','10764326','徐浩凯','','男','21','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/10/10 11:54:26','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510110753','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),753,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20251011753</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>20251011753</pinkey><ordertime>2025-10-10 11:54:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 12:22:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15779192085</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_眼科陈璞</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>360802200406200016</patientidcard><patientname>喻鹏</patientname><patientsex>男</patientsex><patientbirthday>2004-06-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15779192085</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 12:22:01
记录内容：select * from  pat_master_index where id_no='360802200406200016' and name='喻鹏' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/6/20 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:22:01
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:22: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/11','YYYY/MM/DD'),905,'眼科陈璞','上午','1','DP029524','喻鹏','YU PENG','男','21','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 12:22:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510110905','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 12:22: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/11','YYYY/MM/DD'),905,'眼科陈璞','上午','1','DP029524','喻鹏','YU PENG','男','21','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 12:22:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510110905','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科陈璞' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),905,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20251011905</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>20251011905</pinkey><ordertime>2025-10-10 12:22:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 12:23:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17716521972</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_神经内科李宛宸</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230231200102124958</patientidcard><patientname>费宏坤</patientname><patientsex>男</patientsex><patientbirthday>2001-02-12</patientbirthday><medicalrecord></medicalrecord><contactphone>17716521972</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 12:23:10
记录内容：select * from  pat_master_index where id_no='230231200102124958' and name='费宏坤' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/2/12 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:23:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '神经内科李宛宸' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:23:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),906,'神经内科李宛宸','下午','2','100058874','费宏坤','FEI HONG KUN','男','24','一般人员','自费','','普通号','1','0303','LIWANCHEN','1',to_date('2025/10/10 12:23:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510100906','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','23') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 12:23:10
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),906,'神经内科李宛宸','下午','2','100058874','费宏坤','FEI HONG KUN','男','24','一般人员','自费','','普通号','1','0303','LIWANCHEN','1',to_date('2025/10/10 12:23:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510100906','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','23') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科李宛宸' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),906,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '神经内科李宛宸' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>20251010906</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>20251010906</pinkey><ordertime>2025-10-10 12:23:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 12:25:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19525617434</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_眼科陈璞</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232301200303233420</patientidcard><patientname>韩冬雪</patientname><patientsex>女</patientsex><patientbirthday>2003-03-23</patientbirthday><medicalrecord></medicalrecord><contactphone>19525617434</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 12:25:47
记录内容：select * from  pat_master_index where id_no='232301200303233420' and name='韩冬雪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2003/3/23 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:25:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:25:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),911,'眼科陈璞','下午','4','10732175','韩冬雪','','女','22','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 12:25:55','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510100911','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','25') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 12:25:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),911,'眼科陈璞','下午','4','10732175','韩冬雪','','女','22','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 12:25:55','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510100911','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','25') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科陈璞' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),911,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>20251010911</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>20251010911</pinkey><ordertime>2025-10-10 12:25:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 12:30:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13931606626</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028202110100048</patientidcard><patientname>王伊桐</patientname><patientsex>女</patientsex><patientbirthday>2021-10-10</patientbirthday><medicalrecord></medicalrecord><contactphone>13931606626</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 12:30:21
记录内容：select * from  pat_master_index where id_no='131028202110100048' and name='王伊桐' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2021/10/10 0:00:004
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:30:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 12:30:21
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),914,'儿科陈云平','上午','1','100306087','王伊桐','WANG YI TONG ','女','4','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/10/10 12:30:28','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510110914','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 12:30:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),914,'儿科陈云平','上午','1','100306087','王伊桐','WANG YI TONG ','女','4','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/10/10 12:30:28','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510110914','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),914,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20251011914</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>20251011914</pinkey><ordertime>2025-10-10 12:30:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 13:20:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932731787</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_疼痛科刘金龙</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130983200312055314</patientidcard><patientname>孙有宏</patientname><patientsex>男</patientsex><patientbirthday>2003-12-05</patientbirthday><medicalrecord></medicalrecord><contactphone>15932731787</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 13:20:39
记录内容：select * from  pat_master_index where id_no='130983200312055314' and name='孙有宏' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2003/12/5 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 13:20:39
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '疼痛科刘金龙' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 13:20:39
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),1246,'疼痛科刘金龙','下午','2','100512992','孙有宏','SUN YOU HONG ','男','22','一般人员','自费','','副主任号','1','0332','LJL1','1',to_date('2025/10/10 13:20:46','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510101246','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 13:20:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),1246,'疼痛科刘金龙','下午','2','100512992','孙有宏','SUN YOU HONG ','男','22','一般人员','自费','','副主任号','1','0332','LJL1','1',to_date('2025/10/10 13:20:46','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510101246','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '疼痛科刘金龙' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),1246,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '疼痛科刘金龙' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510101246</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510101246</pinkey><ordertime>2025-10-10 13:20:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 13:24:23
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15127688596</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_泌尿外科张家兴专</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200707055816</patientidcard><patientname>田粮硕</patientname><patientsex>男</patientsex><patientbirthday>2007-07-05</patientbirthday><medicalrecord></medicalrecord><contactphone>15127688596</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 13:24:23
记录内容：select * from  pat_master_index where id_no='131082200707055816' and name='田粮硕' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/7/5 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 13:24:23
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '泌尿外科张家兴专' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 13:24:23
记录内容： 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/10','YYYY/MM/DD'),1303,'泌尿外科张家兴专','下午','3','10565743','田粮硕','','男','18','一般人员','自费','','副主任号','1','0311','ZHANGJX','1',to_date('2025/10/10 13:24:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510101303','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 13:24:23
记录内容：<?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/10','YYYY/MM/DD'),1303,'泌尿外科张家兴专','下午','3','10565743','田粮硕','','男','18','一般人员','自费','','副主任号','1','0311','ZHANGJX','1',to_date('2025/10/10 13:24:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510101303','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/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科张家兴专' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),1303,'15:30-16:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '泌尿外科张家兴专' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510101303</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510101303</pinkey><ordertime>2025-10-10 13:24:23</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 13:29:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18633015325</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_呼吸内科任丹丹</scheduleid><parttimeid>16:30-17:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130108200708011867</patientidcard><patientname>闫照涵</patientname><patientsex>女</patientsex><patientbirthday>2007-08-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18633015325</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 13:29:17
记录内容：select * from  pat_master_index where id_no='130108200708011867' and name='闫照涵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/8/1 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 13:29:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '呼吸内科任丹丹' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 13:29:17
记录内容： 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/10','YYYY/MM/DD'),1402,'呼吸内科任丹丹','下午','4','100513366','闫照涵',' ZHAO HAN ','女','18','一般人员','自费','','普通号','1','0317','RDD','1',to_date('2025/10/10 13:29:24','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510101402','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 13:29:17
记录内容：<?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/10','YYYY/MM/DD'),1402,'呼吸内科任丹丹','下午','4','100513366','闫照涵',' ZHAO HAN ','女','18','一般人员','自费','','普通号','1','0317','RDD','1',to_date('2025/10/10 13:29:24','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510101402','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科任丹丹' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),1402,'16:30-17:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '呼吸内科任丹丹' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510101402</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510101402</pinkey><ordertime>2025-10-10 13:29:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 14:29:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15726659549</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_骨科刘兴超</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>620522199509101368</patientidcard><patientname>王亚亚</patientname><patientsex>女</patientsex><patientbirthday>1995-09-10</patientbirthday><medicalrecord></medicalrecord><contactphone>15726659549</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 14:29:44
记录内容：select * from  pat_master_index where id_no='620522199509101368' and name='王亚亚' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/9/10 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 14:29:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 14:29: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/10','YYYY/MM/DD'),2364,'骨科刘兴超','下午','6','100405981','王亚亚','WANG YA YA ','女','30','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/10/10 14:29:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510102364','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','42') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 14:29: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/10','YYYY/MM/DD'),2364,'骨科刘兴超','下午','6','100405981','王亚亚','WANG YA YA ','女','30','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/10/10 14:29:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510102364','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','42') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),2364,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510102364</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510102364</pinkey><ordertime>2025-10-10 14:29:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 15:54:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13723756171</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_中医科李国强</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370303200507294825</patientidcard><patientname>朱天资</patientname><patientsex>女</patientsex><patientbirthday>2005-07-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13723756171</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 15:54:49
记录内容：select * from  pat_master_index where id_no='370303200507294825' and name='朱天资' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/7/29 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 15:54:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '中医科李国强' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 15:54:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),3528,'中医科李国强','下午','3','100455184','朱天资','ZHU TIAN ZI ','女','20','一般人员','自费','','中主任号','1','0301','LIGQ','1',to_date('2025/10/10 15:54:55','yyyy/mm/dd hh24:mi:ss'),'0','40','0.00','40','202510103528','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','8') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 15:54:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),3528,'中医科李国强','下午','3','100455184','朱天资','ZHU TIAN ZI ','女','20','一般人员','自费','','中主任号','1','0301','LIGQ','1',to_date('2025/10/10 15:54:55','yyyy/mm/dd hh24:mi:ss'),'0','40','0.00','40','202510103528','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','8') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医科李国强' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),3528,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '中医科李国强' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510103528</orderid><reservefee>0.00</reservefee><clinicfee>40</clinicfee><registrationfee>0</registrationfee><pinkey>202510103528</pinkey><ordertime>2025-10-10 15:54:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 15:56:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13723756171</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/10 0:00:00_下午_心理咨询张晶晶</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370303200507294825</patientidcard><patientname>朱天资</patientname><patientsex>女</patientsex><patientbirthday>2005-07-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13723756171</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 15:56:10
记录内容：select * from  pat_master_index where id_no='370303200507294825' and name='朱天资' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/7/29 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 15:56:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 15:56:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),3541,'心理咨询张晶晶','下午','11','100455184','朱天资','ZHU TIAN ZI ','女','20','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/10/10 15:56:16','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510103541','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','17') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 15:56:10
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/10','YYYY/MM/DD'),3541,'心理咨询张晶晶','下午','11','100455184','朱天资','ZHU TIAN ZI ','女','20','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/10/10 15:56:16','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510103541','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','17') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/10','YYYY/MM/DD'),3541,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/10','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202510103541</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510103541</pinkey><ordertime>2025-10-10 15:56:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 16:33:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18601123651</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/12 0:00:00_上午_耳鼻喉科刘良发</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>231181198412253324</patientidcard><patientname>陈琳</patientname><patientsex>女</patientsex><patientbirthday>1984-12-25</patientbirthday><medicalrecord></medicalrecord><contactphone>18601123651</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 16:33:55
记录内容：select * from  pat_master_index where id_no='231181198412253324' and name='陈琳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1984/12/25 0:00:0041
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 16:33:55
记录内容：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-10 16:33: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/12','YYYY/MM/DD'),4002,'耳鼻喉科刘良发','上午','4','00281714','陈琳','CHEN LIN','女','41','一般人员','自费','','知名专家','1','0306','LLF','1',to_date('2025/10/10 16:34:01','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510124002','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 16:33: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/12','YYYY/MM/DD'),4002,'耳鼻喉科刘良发','上午','4','00281714','陈琳','CHEN LIN','女','41','一般人员','自费','','知名专家','1','0306','LLF','1',to_date('2025/10/10 16:34:01','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202510124002','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/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'),4002,'10:00-10:30') 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>202510124002</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202510124002</pinkey><ordertime>2025-10-10 16:33:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 16:52:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18733663295</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_心血管内郭晓光普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132523198110124426</patientidcard><patientname>刘忠峰</patientname><patientsex>女</patientsex><patientbirthday>1981-10-12</patientbirthday><medicalrecord></medicalrecord><contactphone>18733663295</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 16:52:24
记录内容：select * from  pat_master_index where id_no='132523198110124426' and name='刘忠峰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/10/12 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 16:52:24
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 16:52:24
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4140,'心血管内郭晓光普','上午','1','100121622','刘忠峰','LIU ZHONG FENG','女','44','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/10/10 16:52:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114140','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 16:52:24
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4140,'心血管内郭晓光普','上午','1','100121622','刘忠峰','LIU ZHONG FENG','女','44','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/10/10 16:52:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114140','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内郭晓光普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4140,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114140</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510114140</pinkey><ordertime>2025-10-10 16:52:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 16:57:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18846275926</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_眼科陈璞</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>231182200407017323</patientidcard><patientname>赵宇宵</patientname><patientsex>女</patientsex><patientbirthday>2004-07-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18846275926</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 16:57:32
记录内容：select * from  pat_master_index where id_no='231182200407017323' and name='赵宇宵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/7/1 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 16:57:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 16:57:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4168,'眼科陈璞','上午','2','100477093','赵宇宵','ZHAO YU XIAO ','女','21','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 16:57:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114168','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 16:57:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4168,'眼科陈璞','上午','2','100477093','赵宇宵','ZHAO YU XIAO ','女','21','一般人员','自费','','普通号','1','0327','CP1','1',to_date('2025/10/10 16:57:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114168','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科陈璞' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4168,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '眼科陈璞' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114168</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510114168</pinkey><ordertime>2025-10-10 16:57:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 17:07:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17710951859</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_心理咨询失眠李文</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>21078220090810161X</patientidcard><patientname>王子衡</patientname><patientsex>男</patientsex><patientbirthday>2009-08-10</patientbirthday><medicalrecord></medicalrecord><contactphone>17710951859</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 17:07:12
记录内容：select * from  pat_master_index where id_no='21078220090810161X' and name='王子衡' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2009/8/10 0:00:0016
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 17:07:12
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 17:07: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/11','YYYY/MM/DD'),4201,'心理咨询失眠李文','上午','2','10641268','王子衡','','男','16','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/10/10 17:07:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114201','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 17:07: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/11','YYYY/MM/DD'),4201,'心理咨询失眠李文','上午','2','10641268','王子衡','','男','16','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/10/10 17:07:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114201','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询失眠李文' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4201,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114201</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510114201</pinkey><ordertime>2025-10-10 17:07:12</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 17:17:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15311467317</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_儿科王小红</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>410602202305073516</patientidcard><patientname>袁锦澄</patientname><patientsex>男</patientsex><patientbirthday>2023-05-07</patientbirthday><medicalrecord></medicalrecord><contactphone>15311467317</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 17:17:40
记录内容：select * from  pat_master_index where id_no='410602202305073516' and name='袁锦澄' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2023/5/7 0:00:002
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 17:17:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科王小红' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 17:17:40
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4214,'儿科王小红','上午','1','100426171','袁锦澄','YUAN JIN CHENG ','男','2','一般人员','自费','','普通号','1','0304','WXH01','1',to_date('2025/10/10 17:17:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114214','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 17:17:40
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4214,'儿科王小红','上午','1','100426171','袁锦澄','YUAN JIN CHENG ','男','2','一般人员','自费','','普通号','1','0304','WXH01','1',to_date('2025/10/10 17:17:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114214','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科王小红' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4214,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科王小红' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114214</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510114214</pinkey><ordertime>2025-10-10 17:17:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 17:20:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13911873555</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/12 0:00:00_下午_妇科王阳</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230222196111190628</patientidcard><patientname>杨秀英</patientname><patientsex>女</patientsex><patientbirthday>1961-11-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13911873555</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 17:20:45
记录内容：select * from  pat_master_index where id_no='230222196111190628' and name='杨秀英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1961/11/19 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 17:20:45
记录内容：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-10 17:20:45
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/12','YYYY/MM/DD'),4215,'妇科王阳','下午','10','M00045596','杨秀英','YANG XIU YING','女','64','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/10/10 17:20:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510124215','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 17:20:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/12','YYYY/MM/DD'),4215,'妇科王阳','下午','10','M00045596','杨秀英','YANG XIU YING','女','64','一般人员','自费','','副主任号','1','0316','XHWY','1',to_date('2025/10/10 17:20:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510124215','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/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'),4215,'13:00-13:30') 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>202510124215</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510124215</pinkey><ordertime>2025-10-10 17:20:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 18:44:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13166594553</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/19 0:00:00_上午_耳鼻喉科郭庆  普</scheduleid><parttimeid>11.30-12:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130530200507040011</patientidcard><patientname>崔学超</patientname><patientsex>男</patientsex><patientbirthday>2005-07-04</patientbirthday><medicalrecord></medicalrecord><contactphone>13166594553</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 18:44:58
记录内容：select * from  pat_master_index where id_no='130530200507040011' and name='崔学超' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/7/4 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 18:44:58
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 18:44:58
记录内容： 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/19','YYYY/MM/DD'),4316,'耳鼻喉科郭庆  普','上午','1','100370194','崔学超','CUI XUE CHAO ','男','20','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2025/10/10 18:45:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510194316','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 18:44:58
记录内容：<?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/19','YYYY/MM/DD'),4316,'耳鼻喉科郭庆  普','上午','1','100370194','崔学超','CUI XUE CHAO ','男','20','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2025/10/10 18:45:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510194316','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/19','YYYY/MM/DD'),4316,'11.30-12:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510194316</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510194316</pinkey><ordertime>2025-10-10 18:44:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 18:47:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15300088373</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082202001110800</patientidcard><patientname>黄语杨</patientname><patientsex>女</patientsex><patientbirthday>2020-01-11</patientbirthday><medicalrecord></medicalrecord><contactphone>15300088373</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 18:47:19
记录内容：select * from  pat_master_index where id_no='131082202001110800' and name='黄语杨' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2020/1/11 0:00:005
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 18:47:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 18:47: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/11','YYYY/MM/DD'),4317,'儿科陈云平','上午','2','10436796','黄语杨','HUANG YU YANG','女','5','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/10/10 18:47:25','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510114317','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 18:47: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/11','YYYY/MM/DD'),4317,'儿科陈云平','上午','2','10436796','黄语杨','HUANG YU YANG','女','5','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/10/10 18:47:25','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510114317','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4317,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114317</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510114317</pinkey><ordertime>2025-10-10 18:47:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 19:04:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18210786367</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_下午_风湿免疫科罗昆</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230306195610265146</patientidcard><patientname>申顺玉</patientname><patientsex>女</patientsex><patientbirthday>1956-10-26</patientbirthday><medicalrecord></medicalrecord><contactphone>18210786367</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-10-10 19:04:39
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/10/11','YYYY-MM-DD')
            AND CLINIC_LABEL='风湿免疫科罗昆' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='230306195610265146' and name='申顺玉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 19:04:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 19:13:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13716174663</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/12 0:00:00_白天_妇科李二雷</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>330322200410090844</patientidcard><patientname>郭思瑜</patientname><patientsex>女</patientsex><patientbirthday>2004-10-09</patientbirthday><medicalrecord></medicalrecord><contactphone>13716174663</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 19:13:39
记录内容：select * from  pat_master_index where id_no='330322200410090844' and name='郭思瑜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/10/9 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 19:13:39
记录内容：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-10 19:13:39
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/12','YYYY/MM/DD'),4351,'妇科李二雷','白天','3','100513391','郭思瑜','GUO SI  ','女','21','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2025/10/10 19:13:45','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510124351','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 19:13:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/12','YYYY/MM/DD'),4351,'妇科李二雷','白天','3','100513391','郭思瑜','GUO SI  ','女','21','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2025/10/10 19:13:45','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510124351','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/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'),4351,'10:30-11: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>202510124351</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510124351</pinkey><ordertime>2025-10-10 19:13:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 19:24:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18519811758</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/13 0:00:00_上午_产科唐梅</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>231123199212120421</patientidcard><patientname>赵明</patientname><patientsex>女</patientsex><patientbirthday>1992-12-12</patientbirthday><medicalrecord></medicalrecord><contactphone>18519811758</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 19:24:57
记录内容：select * from  pat_master_index where id_no='231123199212120421' and name='赵明' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/12/12 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 19:24:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/13','yyyy/mm/dd')
                    and clinic_label = '产科唐梅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 19:24: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/13','YYYY/MM/DD'),4363,'产科唐梅','上午','9','100349093','赵明','ZHAO MING','女','33','一般人员','自费','','普通号','1','0330','TANGM','1',to_date('2025/10/10 19:25:02','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510134363','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 19:24: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/13','YYYY/MM/DD'),4363,'产科唐梅','上午','9','100349093','赵明','ZHAO MING','女','33','一般人员','自费','','普通号','1','0330','TANGM','1',to_date('2025/10/10 19:25:02','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510134363','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/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科唐梅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/13','YYYY/MM/DD'),4363,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/13','yyyy/mm/dd')
                    and clinic_label = '产科唐梅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510134363</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510134363</pinkey><ordertime>2025-10-10 19:24:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 19:55:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18519738739</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_呼吸内科高立静</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220204197807162115</patientidcard><patientname>姚望</patientname><patientsex>男</patientsex><patientbirthday>1978-07-16</patientbirthday><medicalrecord></medicalrecord><contactphone>18519738739</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 19:55:50
记录内容：select * from  pat_master_index where id_no='220204197807162115' and name='姚望' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/7/16 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 19:55:50
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 19:55:50
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4417,'呼吸内科高立静','上午','1','100513396','姚望','YAO WANG ','男','47','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/10/10 19:55:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114417','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 19:55: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/11','YYYY/MM/DD'),4417,'呼吸内科高立静','上午','1','100513396','姚望','YAO WANG ','男','47','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/10/10 19:55:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114417','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4417,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114417</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510114417</pinkey><ordertime>2025-10-10 19:55:51</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 20:31:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13363166271</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>44122519980419582X</patientidcard><patientname>梁诗雅</patientname><patientsex>女</patientsex><patientbirthday>1998-04-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13363166271</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 20:31:33
记录内容：select * from  pat_master_index where id_no='44122519980419582X' and name='梁诗雅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1998/4/19 0:00:0027
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:31:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:31:33
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4453,'内分泌科马伟杰普','上午','5','100191900','梁诗雅','LIANG SHI YA','女','27','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/10/10 20:31:38','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114453','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 20:31:33
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4453,'内分泌科马伟杰普','上午','5','100191900','梁诗雅','LIANG SHI YA','女','27','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2025/10/10 20:31:38','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114453','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/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4453,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114453</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510114453</pinkey><ordertime>2025-10-10 20:31:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 20:34:23
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13930687753</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_普通外科王进 普</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197310206827</patientidcard><patientname>朱爱武</patientname><patientsex>女</patientsex><patientbirthday>1973-10-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13930687753</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 20:34:23
记录内容：select * from  pat_master_index where id_no='132822197310206827' and name='朱爱武' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1973/10/20 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:34:23
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '普通外科王进 普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:34:23
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4457,'普通外科王进 普','上午','2','10467621','朱爱武','ZHU AI WU','女','52','一般人员','自费','','普通号','1','0335','WJ01','1',to_date('2025/10/10 20:34:28','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114457','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 20:34:23
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4457,'普通外科王进 普','上午','2','10467621','朱爱武','ZHU AI WU','女','52','一般人员','自费','','普通号','1','0335','WJ01','1',to_date('2025/10/10 20:34:28','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202510114457','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科王进 普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4457,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '普通外科王进 普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114457</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202510114457</pinkey><ordertime>2025-10-10 20:34:23</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 20:37:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17703266899</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/12 0:00:00_上午_神经内科夏德雨</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199009112015</patientidcard><patientname>左咏琦</patientname><patientsex>男</patientsex><patientbirthday>1990-09-11</patientbirthday><medicalrecord></medicalrecord><contactphone>17703266899</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 20:37:00
记录内容：select * from  pat_master_index where id_no='131028199009112015' and name='左咏琦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/9/11 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:37: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 = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:37:00
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/12','YYYY/MM/DD'),4459,'神经内科夏德雨','上午','2','100181831','左咏琦','ZUO YONG  ','男','35','一般人员','自费','','副主任号','1','0303','XDY1','1',to_date('2025/10/10 20:37:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510124459','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 20:37:00
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/12','YYYY/MM/DD'),4459,'神经内科夏德雨','上午','2','100181831','左咏琦','ZUO YONG  ','男','35','一般人员','自费','','副主任号','1','0303','XDY1','1',to_date('2025/10/10 20:37:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510124459','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'),4459,'8:00-8:30') 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>202510124459</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510124459</pinkey><ordertime>2025-10-10 20:37:00</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 20:52:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18041113959</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210283202506141924</patientidcard><patientname>吕婉宁</patientname><patientsex>女</patientsex><patientbirthday>2025-06-14</patientbirthday><medicalrecord></medicalrecord><contactphone>18041113959</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 20:52:18
记录内容：select * from  pat_master_index where id_no='210283202506141924' and name='吕婉宁' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2025/6/14 0:00:000
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 20:52:18
记录内容：select * from  pat_master_index where id_no='210283202506141924' and name='吕婉宁' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc实体获取的生日2025/6/14 0:00:000
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:52:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 20:52: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/11','YYYY/MM/DD'),4481,'儿科陈云平','上午','3','100513405','吕婉宁','LV WAN NING ','女','0','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/10/10 20:52:24','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510114481','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 20:52: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/11','YYYY/MM/DD'),4481,'儿科陈云平','上午','3','100513405','吕婉宁','LV WAN NING ','女','0','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/10/10 20:52:24','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510114481','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/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4481,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202510114481</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510114481</pinkey><ordertime>2025-10-10 20:52:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 22:46:10
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13914336519</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_下午_消化内科胡珉</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>320401200007252817</patientidcard><patientname>潘政</patientname><patientsex>男</patientsex><patientbirthday>2000-07-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13914336519</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 22:46:10
记录内容：select * from  pat_master_index where id_no='320401200007252817' and name='潘政' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/7/25 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 22:46:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 22:46:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4570,'消化内科胡珉','下午','1','100513416','潘政','PAN ZHENG ','男','25','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/10 22:46:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114570','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 22:46:10
记录内容：<?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/11','YYYY/MM/DD'),4570,'消化内科胡珉','下午','1','100513416','潘政','PAN ZHENG ','男','25','一般人员','自费','','副主任号','1','0302','HUMIN01','1',to_date('2025/10/10 22:46:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114570','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/10/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科胡珉' AND TIME_DESC = '下午'select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉' and visit_time_desc = '下午'</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 23:17:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15631350216</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/11 0:00:00_白天_妇科王兰</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13070320050216034X</patientidcard><patientname>穆妍冰</patientname><patientsex>女</patientsex><patientbirthday>2005-02-16</patientbirthday><medicalrecord></medicalrecord><contactphone>15631350216</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 23:17:32
记录内容：select * from  pat_master_index where id_no='13070320050216034X' and name='穆妍冰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/2/16 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 23:17:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 23:17:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4606,'妇科王兰','白天','5','100513418','穆妍冰','MU  BING ','女','20','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/10/10 23:17:37','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114606','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 23:17:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4606,'妇科王兰','白天','5','100513418','穆妍冰','MU  BING ','女','20','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/10/10 23:17:37','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202510114606','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/11', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/10/11','YYYY/MM/DD'),4606,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/10/11','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202510114606</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202510114606</pinkey><ordertime>2025-10-10 23:17:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-10-10 23:21:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15188789074</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/10/12 0:00:00_白天_妇科李二雷</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130625200601211221</patientidcard><patientname>梁曼玉</patientname><patientsex>女</patientsex><patientbirthday>2006-01-21</patientbirthday><medicalrecord></medicalrecord><contactphone>15188789074</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-10-10 23:21:24
记录内容：select * from  pat_master_index where id_no='130625200601211221' and name='梁曼玉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/1/21 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-10-10 23:21:24
记录内容：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-10 23:21:24
记录内容： 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'),4608,'妇科李二雷','白天','4','100513425','梁曼玉','LIANG MAN YU ','女','19','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2025/10/10 23:21:29','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510124608','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-10-10 23:21:24
记录内容：<?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'),4608,'妇科李二雷','白天','4','100513425','梁曼玉','LIANG MAN YU ','女','19','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2025/10/10 23:21:29','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202510124608','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/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'),4608,'10:30-11: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>202510124608</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202510124608</pinkey><ordertime>2025-10-10 23:21:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆