◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 00:35:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18210983470</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_上午_心血管内科郭晓光</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>110104197202021212</patientidcard><patientname>梁建军</patientname><patientsex>男</patientsex><patientbirthday>1972-02-02</patientbirthday><medicalrecord></medicalrecord><contactphone>18210983470</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 00:35:05
记录内容：select * from  pat_master_index where id_no='110104197202021212' and name='梁建军' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1972/2/2 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 00:35:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '心血管内科郭晓光' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 00:35:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/13','YYYY/MM/DD'),3454,'心血管内科郭晓光','上午','2','100484252','梁建军','LIANG JIAN JUN ','男','54','一般人员','自费','','副主任号','1','0359','GXG','1',to_date('2026/04/12 00:35:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604133454','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 00:35:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/13','YYYY/MM/DD'),3454,'心血管内科郭晓光','上午','2','100484252','梁建军','LIANG JIAN JUN ','男','54','一般人员','自费','','副主任号','1','0359','GXG','1',to_date('2026/04/12 00:35:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604133454','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科郭晓光' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),3454,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '心血管内科郭晓光' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604133454</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604133454</pinkey><ordertime>2026-04-12 00:35:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 01:05:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15227587736</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_白天_妇科陈海霞</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130929200402294249</patientidcard><patientname>刘一诺</patientname><patientsex>女</patientsex><patientbirthday>2004-02-29</patientbirthday><medicalrecord></medicalrecord><contactphone>15227587736</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 01:05:44
记录内容：select * from  pat_master_index where id_no='130929200402294249' and name='刘一诺' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/2/29 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 01:05:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 01:05: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('2026/04/12','YYYY/MM/DD'),3475,'妇科陈海霞','白天','6','100553788','刘一诺','LIU YI NUO ','女','22','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/04/12 01:05:42','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604123475','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 01:05: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('2026/04/12','YYYY/MM/DD'),3475,'妇科陈海霞','白天','6','100553788','刘一诺','LIU YI NUO ','女','22','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/04/12 01:05:42','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604123475','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('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3475,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202604123475</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604123475</pinkey><ordertime>2026-04-12 01:05:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 03:03:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18234852957</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_上午_耳鼻喉科郭庆  普</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>141125200410270099</patientidcard><patientname>马瑞江</patientname><patientsex>男</patientsex><patientbirthday>2004-10-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18234852957</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 03:03:43
记录内容：select * from  pat_master_index where id_no='141125200410270099' and name='马瑞江' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/10/27 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 03:03:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 03:03: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('2026/04/13','YYYY/MM/DD'),3535,'耳鼻喉科郭庆  普','上午','1','100547560','马瑞江','MA RUI JIANG ','男','22','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/04/12 03:03:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604133535','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 03:03: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('2026/04/13','YYYY/MM/DD'),3535,'耳鼻喉科郭庆  普','上午','1','100547560','马瑞江','MA RUI JIANG ','男','22','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/04/12 03:03:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604133535','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),3535,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604133535</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604133535</pinkey><ordertime>2026-04-12 03:03:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 05:56:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18600488180</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>320703201809070074</patientidcard><patientname>王子羿</patientname><patientsex>男</patientsex><patientbirthday>2018-09-07</patientbirthday><medicalrecord></medicalrecord><contactphone>18600488180</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 05:56:43
记录内容：select * from  pat_master_index where id_no='320703201809070074' and name='王子羿' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2018/9/7 0:00:008
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 05:56:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 05: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('2026/04/12','YYYY/MM/DD'),3601,'儿科刘婕','上午','3','10371205','王子羿','WANG ZI YI','男','8','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/04/12 05:56:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604123601','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 05: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('2026/04/12','YYYY/MM/DD'),3601,'儿科刘婕','上午','3','10371205','王子羿','WANG ZI YI','男','8','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/04/12 05:56:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604123601','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('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3601,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604123601</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604123601</pinkey><ordertime>2026-04-12 05:56:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 06:02:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17703353172</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_上午_皮肤科杨维玲</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130321200609140622</patientidcard><patientname>高晶晶</patientname><patientsex>女</patientsex><patientbirthday>2006-09-14</patientbirthday><medicalrecord></medicalrecord><contactphone>17703353172</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 06:02:40
记录内容：select * from  pat_master_index where id_no='130321200609140622' and name='高晶晶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/9/14 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:02:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:02: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('2026/04/13','YYYY/MM/DD'),3602,'皮肤科杨维玲','上午','3','100514389','高晶晶','GAO JING JING','女','20','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/04/12 06:02:45','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202604133602','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 06:02: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('2026/04/13','YYYY/MM/DD'),3602,'皮肤科杨维玲','上午','3','100514389','高晶晶','GAO JING JING','女','20','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/04/12 06:02:45','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202604133602','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),3602,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604133602</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202604133602</pinkey><ordertime>2026-04-12 06:02:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 06:17:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19151150402</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_皮肤科杨维玲</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23070719940402003X</patientidcard><patientname>王明宇</patientname><patientsex>男</patientsex><patientbirthday>1994-04-02</patientbirthday><medicalrecord></medicalrecord><contactphone>19151150402</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 06:17:37
记录内容：select * from  pat_master_index where id_no='23070719940402003X' and name='王明宇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/4/2 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:17:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:17:37
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3606,'皮肤科杨维玲','上午','5','100552406','王明宇','WANG MING YU ','男','32','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/04/12 06:17:41','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202604123606','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 06:17:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3606,'皮肤科杨维玲','上午','5','100552406','王明宇','WANG MING YU ','男','32','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/04/12 06:17:41','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202604123606','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3606,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604123606</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202604123606</pinkey><ordertime>2026-04-12 06:17:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 06:41:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18745138139</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_全科医学科周静</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230121199002262217</patientidcard><patientname>王志强</patientname><patientsex>男</patientsex><patientbirthday>1990-02-26</patientbirthday><medicalrecord></medicalrecord><contactphone>18745138139</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 06:41:02
记录内容：select * from  pat_master_index where id_no='230121199002262217' and name='王志强' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/2/26 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:41:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '全科医学科周静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:41:02
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3609,'全科医学科周静','上午','2','00361711','王志强','WANG ZHI QIANG','男','36','一般人员','自费','','普通号','1','0396','ZJ5','1',to_date('2026/04/12 06:41:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604123609','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 06:41:03
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3609,'全科医学科周静','上午','2','00361711','王志强','WANG ZHI QIANG','男','36','一般人员','自费','','普通号','1','0396','ZJ5','1',to_date('2026/04/12 06:41:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604123609','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '全科医学科周静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3609,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '全科医学科周静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604123609</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604123609</pinkey><ordertime>2026-04-12 06:41:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 06:51:30
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18617710109</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/14 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130983200402095010</patientidcard><patientname>张熙炎</patientname><patientsex>男</patientsex><patientbirthday>2004-02-09</patientbirthday><medicalrecord></medicalrecord><contactphone>18617710109</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 06:51:30
记录内容：select * from  pat_master_index where id_no='130983200402095010' and name='张熙炎' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/2/9 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:51:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/14','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 06:51:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/14','YYYY/MM/DD'),3614,'皮肤科常庆华','上午','6','100324621','张熙炎','ZHANG XI YAN ','男','22','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/04/12 06:51:35','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604143614','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 06:51:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/14','YYYY/MM/DD'),3614,'皮肤科常庆华','上午','6','100324621','张熙炎','ZHANG XI YAN ','男','22','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/04/12 06:51:35','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604143614','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/14','YYYY/MM/DD'),3614,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/14','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604143614</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604143614</pinkey><ordertime>2026-04-12 06:51:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 07:38:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15230605609</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/14 0:00:00_白天_糖尿病足朱广昌</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210402195712232042</patientidcard><patientname>刘丽荣</patientname><patientsex>女</patientsex><patientbirthday>1957-12-23</patientbirthday><medicalrecord></medicalrecord><contactphone>15230605609</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 07:38:25
记录内容：select * from  pat_master_index where id_no='210402195712232042' and name='刘丽荣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1957/12/23 0:00:0069
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:38:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/14','yyyy/mm/dd')
                    and clinic_label = '糖尿病足朱广昌' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:38:25
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/14','YYYY/MM/DD'),3703,'糖尿病足朱广昌','白天','1','100553803','刘丽荣','LIU LI RONG ','女','69','一般人员','自费','','主任号','1','0394','ZGC1','1',to_date('2026/04/12 07:38:29','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604143703','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 07:38:25
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/14','YYYY/MM/DD'),3703,'糖尿病足朱广昌','白天','1','100553803','刘丽荣','LIU LI RONG ','女','69','一般人员','自费','','主任号','1','0394','ZGC1','1',to_date('2026/04/12 07:38:29','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604143703','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '糖尿病足朱广昌' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/14','YYYY/MM/DD'),3703,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/14','yyyy/mm/dd')
                    and clinic_label = '糖尿病足朱广昌' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202604143703</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202604143703</pinkey><ordertime>2026-04-12 07:38:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 07:49:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15230605609</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_白天_糖尿病足侯国峰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210402195712232042</patientidcard><patientname>刘丽荣</patientname><patientsex>女</patientsex><patientbirthday>1957-12-23</patientbirthday><medicalrecord></medicalrecord><contactphone>15230605609</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 07:49:58
记录内容：select * from  pat_master_index where id_no='210402195712232042' and name='刘丽荣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1957/12/23 0:00:0069
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:49:58
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '糖尿病足侯国峰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:49: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('2026/04/13','YYYY/MM/DD'),3800,'糖尿病足侯国峰','白天','1','100553803','刘丽荣','LIU LI RONG ','女','69','一般人员','自费','','副主任号','1','0394','HOUGF','1',to_date('2026/04/12 07:50:02','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604133800','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 07:49: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('2026/04/13','YYYY/MM/DD'),3800,'糖尿病足侯国峰','白天','1','100553803','刘丽荣','LIU LI RONG ','女','69','一般人员','自费','','副主任号','1','0394','HOUGF','1',to_date('2026/04/12 07:50:02','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604133800','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '糖尿病足侯国峰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),3800,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '糖尿病足侯国峰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202604133800</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604133800</pinkey><ordertime>2026-04-12 07:49:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 07:53:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19933466458</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_心血管内郭晓光普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130132198909191323</patientidcard><patientname>王美娟</patientname><patientsex>女</patientsex><patientbirthday>1989-09-19</patientbirthday><medicalrecord></medicalrecord><contactphone>19933466458</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 07:53:19
记录内容：select * from  pat_master_index where id_no='130132198909191323' and name='王美娟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/9/19 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:53:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:53:19
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3829,'心血管内郭晓光普','上午','7','10794659','王美娟','','女','37','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2026/04/12 07:53:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604123829','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 07:53:19
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3829,'心血管内郭晓光普','上午','7','10794659','王美娟','','女','37','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2026/04/12 07:53:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604123829','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内郭晓光普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3829,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604123829</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604123829</pinkey><ordertime>2026-04-12 07:53:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 07:54:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13520870466</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_心血管内陶林森普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>222326196211060047</patientidcard><patientname>樊秀芬</patientname><patientsex>女</patientsex><patientbirthday>1962-11-06</patientbirthday><medicalrecord></medicalrecord><contactphone>13520870466</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 07:54:13
记录内容：select * from  pat_master_index where id_no='222326196211060047' and name='樊秀芬' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1962/11/6 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:54:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 07:54:13
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3841,'心血管内陶林森普','上午','18','100538688','樊秀芬','FAN XIU FEN ','女','64','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2026/04/12 07:54:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604123841','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','17') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 07:54:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3841,'心血管内陶林森普','上午','18','100538688','樊秀芬','FAN XIU FEN ','女','64','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2026/04/12 07:54:17','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604123841','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('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内陶林森普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),3841,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604123841</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604123841</pinkey><ordertime>2026-04-12 07:54:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 08:07:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18234852957</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_下午_肾病科刘航</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>141125200410270099</patientidcard><patientname>马瑞江</patientname><patientsex>男</patientsex><patientbirthday>2004-10-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18234852957</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 08:07:43
记录内容：select * from  pat_master_index where id_no='141125200410270099' and name='马瑞江' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/10/27 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:07:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '肾病科刘航' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:07: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('2026/04/13','YYYY/MM/DD'),4097,'肾病科刘航','下午','3','100547560','马瑞江','MA RUI JIANG ','男','22','一般人员','自费','','主任号','1','0333','LIUH','1',to_date('2026/04/12 08:07:47','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604134097','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 08:07: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('2026/04/13','YYYY/MM/DD'),4097,'肾病科刘航','下午','3','100547560','马瑞江','MA RUI JIANG ','男','22','一般人员','自费','','主任号','1','0333','LIUH','1',to_date('2026/04/12 08:07:47','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604134097','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '肾病科刘航' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),4097,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '肾病科刘航' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202604134097</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202604134097</pinkey><ordertime>2026-04-12 08:07:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 08:10:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15233461895</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_心血管内郭晓光普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132622196902281438</patientidcard><patientname>王会东</patientname><patientsex>男</patientsex><patientbirthday>1969-02-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15233461895</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 08:10:29
记录内容：select * from  pat_master_index where id_no='132622196902281438' and name='王会东' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/2/28 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:10:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:10:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),4181,'心血管内郭晓光普','上午','11','Z00377808','王会东','','男','57','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2026/04/12 08:10:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604124181','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 08:10:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),4181,'心血管内郭晓光普','上午','11','Z00377808','王会东','','男','57','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2026/04/12 08:10:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604124181','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('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内郭晓光普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),4181,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604124181</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604124181</pinkey><ordertime>2026-04-12 08:10:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 08:18:34
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18710082716</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/25 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150122196202124516</patientidcard><patientname>石拴拴</patientname><patientsex>男</patientsex><patientbirthday>1962-02-12</patientbirthday><medicalrecord></medicalrecord><contactphone>18710082716</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 08:18:34
记录内容：select * from  pat_master_index where id_no='150122196202124516' and name='石拴拴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1962/2/12 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:18:34
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/25','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:18:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/25','YYYY/MM/DD'),4438,'骨科刘海峰','上午','1','100540045','石拴拴','SHI SHUAN SHUAN','男','64','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/04/12 08:18:38','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604254438','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 08:18: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('2026/04/25','YYYY/MM/DD'),4438,'骨科刘海峰','上午','1','100540045','石拴拴','SHI SHUAN SHUAN','男','64','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/04/12 08:18:38','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604254438','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/25','YYYY/MM/DD'),4438,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/25','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604254438</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202604254438</pinkey><ordertime>2026-04-12 08:18:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 08:19:34
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18347754327</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/15 0:00:00_下午_男科门诊杨云波</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>142325199410168234</patientidcard><patientname>王顺顺</patientname><patientsex>男</patientsex><patientbirthday>1994-10-16</patientbirthday><medicalrecord></medicalrecord><contactphone>18347754327</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 08:19:34
记录内容：select * from  pat_master_index where id_no='142325199410168234' and name='王顺顺' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/10/16 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:19:34
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/15','yyyy/mm/dd')
                    and clinic_label = '男科门诊杨云波' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:19:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/15','YYYY/MM/DD'),4480,'男科门诊杨云波','下午','1','100553806','王顺顺','WANG SHUN SHUN ','男','32','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/04/12 08:19:37','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604154480','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 08:19:34
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/15','YYYY/MM/DD'),4480,'男科门诊杨云波','下午','1','100553806','王顺顺','WANG SHUN SHUN ','男','32','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/04/12 08:19:37','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202604154480','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/15', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '男科门诊杨云波' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/15','YYYY/MM/DD'),4480,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/15','yyyy/mm/dd')
                    and clinic_label = '男科门诊杨云波' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202604154480</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202604154480</pinkey><ordertime>2026-04-12 08:19:34</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 08:30:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17630659066</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_神经内科徐金静普</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>412929196206158303</patientidcard><patientname>牛付秀</patientname><patientsex>女</patientsex><patientbirthday>1962-06-15</patientbirthday><medicalrecord></medicalrecord><contactphone>17630659066</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 08:30:11
记录内容：select * from  pat_master_index where id_no='412929196206158303' and name='牛付秀' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1962/6/15 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:30:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:30:11
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),4826,'神经内科徐金静普','上午','20','100553216','牛付秀','NIU FU XIU ','女','64','一般人员','自费','','普通号','1','0303','XUJJ','1',to_date('2026/04/12 08:30:15','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604124826','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','21') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 08:30:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),4826,'神经内科徐金静普','上午','20','100553216','牛付秀','NIU FU XIU ','女','64','一般人员','自费','','普通号','1','0303','XUJJ','1',to_date('2026/04/12 08:30:15','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604124826','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','21') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科徐金静普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),4826,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604124826</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604124826</pinkey><ordertime>2026-04-12 08:30:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 08:44:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18231473209</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_上午_生殖男科富鹤普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13082219990501037X</patientidcard><patientname>齐焱辉</patientname><patientsex>男</patientsex><patientbirthday>1999-05-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18231473209</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 08:44:24
记录内容：select * from  pat_master_index where id_no='13082219990501037X' and name='齐焱辉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1999/5/1 0:00:0027
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:44:24
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 08:44: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('2026/04/13','YYYY/MM/DD'),5583,'生殖男科富鹤普','上午','1','100553674','齐焱辉','QI  HUI ','男','27','一般人员','自费','','普通号','1','0371','FH','1',to_date('2026/04/12 08:44:28','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604135583','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 08:44: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('2026/04/13','YYYY/MM/DD'),5583,'生殖男科富鹤普','上午','1','100553674','齐焱辉','QI  HUI ','男','27','一般人员','自费','','普通号','1','0371','FH','1',to_date('2026/04/12 08:44:28','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604135583','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '生殖男科富鹤普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),5583,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604135583</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604135583</pinkey><ordertime>2026-04-12 08:44:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:03:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18801187927</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_神经内科徐金静普</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230183198901154863</patientidcard><patientname>吴琪</patientname><patientsex>女</patientsex><patientbirthday>1989-01-15</patientbirthday><medicalrecord></medicalrecord><contactphone>18801187927</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:03:27
记录内容：select * from  pat_master_index where id_no='230183198901154863' and name='吴琪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/1/15 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:03:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:03:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6196,'神经内科徐金静普','上午','25','100553811','吴琪','WU  ','女','37','一般人员','自费','','普通号','1','0303','XUJJ','1',to_date('2026/04/12 09:03:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604126196','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','27') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:03:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6196,'神经内科徐金静普','上午','25','100553811','吴琪','WU  ','女','37','一般人员','自费','','普通号','1','0303','XUJJ','1',to_date('2026/04/12 09:03:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604126196','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','27') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科徐金静普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6196,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604126196</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604126196</pinkey><ordertime>2026-04-12 09:03:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:06:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13933930887</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028202010046814</patientidcard><patientname>王宝峰</patientname><patientsex>男</patientsex><patientbirthday>2020-10-04</patientbirthday><medicalrecord></medicalrecord><contactphone>13933930887</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:06:20
记录内容：select * from  pat_master_index where id_no='131028202010046814' and name='王宝峰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2020/10/4 0:00:006
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:06:20
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:06:20
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6294,'儿科刘婕','上午','5','100553812','王宝峰','WANG BAO FENG ','男','6','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/04/12 09:06:23','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604126294','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:06:20
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6294,'儿科刘婕','上午','5','100553812','王宝峰','WANG BAO FENG ','男','6','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/04/12 09:06:23','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604126294','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6294,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604126294</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604126294</pinkey><ordertime>2026-04-12 09:06:20</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:14:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15826092464</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_耳鼻喉科王慎祥</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>500222199105113115</patientidcard><patientname>金雷</patientname><patientsex>男</patientsex><patientbirthday>1991-05-11</patientbirthday><medicalrecord></medicalrecord><contactphone>15826092464</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:14:09
记录内容：select * from  pat_master_index where id_no='500222199105113115' and name='金雷' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/5/11 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:14:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:14:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6508,'耳鼻喉科王慎祥','上午','9','100553814','金雷','JIN LEI ','男','35','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/04/12 09:14:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604126508','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:14:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6508,'耳鼻喉科王慎祥','上午','9','100553814','金雷','JIN LEI ','男','35','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/04/12 09:14:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604126508','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6508,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604126508</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604126508</pinkey><ordertime>2026-04-12 09:14:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:26:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18026588020</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_下午_骨科徐卫东</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>421221201101190724</patientidcard><patientname>杨淇玉</patientname><patientsex>女</patientsex><patientbirthday>2011-01-19</patientbirthday><medicalrecord></medicalrecord><contactphone>18026588020</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:26:13
记录内容：select * from  pat_master_index where id_no='421221201101190724' and name='杨淇玉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2011/1/19 0:00:0015
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:26:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '骨科徐卫东' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:26:13
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6833,'骨科徐卫东','下午','1','100547773','杨淇玉','YANG  YU ','女','15','一般人员','自费','','副主任号','1','0312','XUWD','1',to_date('2026/04/12 09:26:16','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604126833','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:26:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6833,'骨科徐卫东','下午','1','100547773','杨淇玉','YANG  YU ','女','15','一般人员','自费','','副主任号','1','0312','XUWD','1',to_date('2026/04/12 09:26:16','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604126833','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科徐卫东' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),6833,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '骨科徐卫东' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202604126833</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604126833</pinkey><ordertime>2026-04-12 09:26:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:38:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13111289567</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_生殖男科富鹤</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>140224199402180010</patientidcard><patientname>李锦河</patientname><patientsex>男</patientsex><patientbirthday>1994-02-18</patientbirthday><medicalrecord></medicalrecord><contactphone>13111289567</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:38:53
记录内容：select * from  pat_master_index where id_no='140224199402180010' and name='李锦河' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/2/18 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:38:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:38:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),7229,'生殖男科富鹤','上午','7','10017802','李锦河','LI JIN HE','男','32','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2026/04/12 09:38:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604127229','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:38:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),7229,'生殖男科富鹤','上午','7','10017802','李锦河','LI JIN HE','男','32','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2026/04/12 09:38:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604127229','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '生殖男科富鹤' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),7229,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604127229</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604127229</pinkey><ordertime>2026-04-12 09:38:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:41:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13833652947</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_白天_妇科杨芳</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198708190040</patientidcard><patientname>李辉</patientname><patientsex>女</patientsex><patientbirthday>1987-08-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13833652947</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:41:47
记录内容：select * from  pat_master_index where id_no='131082198708190040' and name='李辉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/8/19 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:41:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:41:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/13','YYYY/MM/DD'),7316,'妇科杨芳','白天','3','10112430','李辉','LI HUI','女','39','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2026/04/12 09:41:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604137316','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:41:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/13','YYYY/MM/DD'),7316,'妇科杨芳','白天','3','10112430','李辉','LI HUI','女','39','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2026/04/12 09:41:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604137316','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科杨芳' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),7316,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202604137316</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604137316</pinkey><ordertime>2026-04-12 09:41:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:55:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15011495205</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>371726202003115738</patientidcard><patientname>于艺澄</patientname><patientsex>男</patientsex><patientbirthday>2020-03-11</patientbirthday><medicalrecord></medicalrecord><contactphone>15011495205</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:55:27
记录内容：select * from  pat_master_index where id_no='371726202003115738' and name='于艺澄' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2020/3/11 0:00:006
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:55:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:55:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),7696,'儿科刘婕','上午','10','10671004','于艺澄','','男','6','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/04/12 09:55:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604127696','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:55:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),7696,'儿科刘婕','上午','10','10671004','于艺澄','','男','6','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/04/12 09:55:30','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604127696','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),7696,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202604127696</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604127696</pinkey><ordertime>2026-04-12 09:55:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 09:57:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18764792005</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/13 0:00:00_白天_胃肠肿瘤钱海龙</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>370832197902240944</patientidcard><patientname>李春爱</patientname><patientsex>女</patientsex><patientbirthday>1979-02-24</patientbirthday><medicalrecord></medicalrecord><contactphone>18764792005</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 09:57:12
记录内容：select * from  pat_master_index where id_no='370832197902240944' and name='李春爱' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/2/24 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:57:12
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '胃肠肿瘤钱海龙' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 09:57: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('2026/04/13','YYYY/MM/DD'),7761,'胃肠肿瘤钱海龙','白天','1','10704362','李春爱','LI CHUN AI','女','47','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2026/04/12 09:57:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604137761','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 09:57: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('2026/04/13','YYYY/MM/DD'),7761,'胃肠肿瘤钱海龙','白天','1','10704362','李春爱','LI CHUN AI','女','47','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2026/04/12 09:57:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604137761','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胃肠肿瘤钱海龙' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/13','YYYY/MM/DD'),7761,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/13','yyyy/mm/dd')
                    and clinic_label = '胃肠肿瘤钱海龙' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202604137761</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604137761</pinkey><ordertime>2026-04-12 09:57:12</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-12 13:53:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19312563270</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/12 0:00:00_白天_妇科陈海霞</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232331199203181646</patientidcard><patientname>李淼</patientname><patientsex>女</patientsex><patientbirthday>1992-03-18</patientbirthday><medicalrecord></medicalrecord><contactphone>19312563270</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-12 13:53:29
记录内容：select * from  pat_master_index where id_no='232331199203181646' and name='李淼' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/3/18 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 13:53:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-12 13:53:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),1361,'妇科陈海霞','白天','37','10375959','李淼','','女','34','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/04/12 13:53:31','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604121361','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','35') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-12 13:53:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/04/12','YYYY/MM/DD'),1361,'妇科陈海霞','白天','37','10375959','李淼','','女','34','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/04/12 13:53:31','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202604121361','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','35') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/12','YYYY/MM/DD'),1361,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/12','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202604121361</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202604121361</pinkey><ordertime>2026-04-12 13:53:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆