◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 00:29:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19864587458</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_下午_神经内科徐金静</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>350321197704115210</patientidcard><patientname>赵建新</patientname><patientsex>男</patientsex><patientbirthday>1977-04-11</patientbirthday><medicalrecord></medicalrecord><contactphone>19864587458</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 00:29:53
记录内容：select * from  pat_master_index where id_no='350321197704115210' and name='赵建新' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1977/4/11 0:00:0049
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 00:29:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 00:29: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/02/20','YYYY/MM/DD'),2649,'神经内科徐金静','下午','1','100538578','赵建新','ZHAO JIAN XIN ','男','49','一般人员','自费','','副主任号','1','0303','XUJJ','1',to_date('2026/02/19 00:29:54','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602202649','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 00:29: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/02/20','YYYY/MM/DD'),2649,'神经内科徐金静','下午','1','100538578','赵建新','ZHAO JIAN XIN ','男','49','一般人员','自费','','副主任号','1','0303','XUJJ','1',to_date('2026/02/19 00:29:54','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602202649','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科徐金静' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),2649,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602202649</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602202649</pinkey><ordertime>2026-02-19 00:29:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 00:32:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19864587458</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>350321197704115210</patientidcard><patientname>赵建新</patientname><patientsex>男</patientsex><patientbirthday>1977-04-11</patientbirthday><medicalrecord></medicalrecord><contactphone>19864587458</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 00:32:58
记录内容：select * from  pat_master_index where id_no='350321197704115210' and name='赵建新' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1977/4/11 0:00:0049
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 00:32:58
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 00:32: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/02/19','YYYY/MM/DD'),2652,'皮肤科常庆华','下午','4','100538578','赵建新','ZHAO JIAN XIN ','男','49','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 00:33:00','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192652','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 00:32: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/02/19','YYYY/MM/DD'),2652,'皮肤科常庆华','下午','4','100538578','赵建新','ZHAO JIAN XIN ','男','49','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 00:33:00','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192652','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2652,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602192652</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602192652</pinkey><ordertime>2026-02-19 00:32:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 00:37:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13230672916</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_产科丁慧副主任</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>232103198301231749</patientidcard><patientname>纪春晶</patientname><patientsex>女</patientsex><patientbirthday>1983-01-23</patientbirthday><medicalrecord></medicalrecord><contactphone>13230672916</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 00:37:37
记录内容：select * from  pat_master_index where id_no='232103198301231749' and name='纪春晶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1983/1/23 0:00:0043
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 00:37:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '产科丁慧副主任' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 00:37: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/02/19','YYYY/MM/DD'),2659,'产科丁慧副主任','上午','2','100538579','纪春晶','JI CHUN JING ','女','43','一般人员','自费','','副主任号','1','0330','DINGH','1',to_date('2026/02/19 00:37:39','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192659','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 00:37:38
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2659,'产科丁慧副主任','上午','2','100538579','纪春晶','JI CHUN JING ','女','43','一般人员','自费','','副主任号','1','0330','DINGH','1',to_date('2026/02/19 00:37:39','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192659','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科丁慧副主任' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2659,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '产科丁慧副主任' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192659</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602192659</pinkey><ordertime>2026-02-19 00:37:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 02:32:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13931649776</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>13108219851111102X</patientidcard><patientname>兰金凤</patientname><patientsex>女</patientsex><patientbirthday>1985-11-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13931649776</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 02:32:09
记录内容：select * from  pat_master_index where id_no='13108219851111102X' and name='兰金凤' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1985/11/11 0:00:0041
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 02:32:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 02:32: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/02/19','YYYY/MM/DD'),2689,'骨科刘海峰','上午','3','100538576','兰金凤','LAN JIN FENG ','女','41','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 02:32:18','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602192689','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 02:32: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/02/19','YYYY/MM/DD'),2689,'骨科刘海峰','上午','3','100538576','兰金凤','LAN JIN FENG ','女','41','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 02:32:18','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602192689','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2689,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192689</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602192689</pinkey><ordertime>2026-02-19 02:32:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 05:51:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13703262649</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_耳鼻喉科郭庆  普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200301100787</patientidcard><patientname>钟媛媛</patientname><patientsex>女</patientsex><patientbirthday>2003-01-10</patientbirthday><medicalrecord></medicalrecord><contactphone>13703262649</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 05:51:48
记录内容：select * from  pat_master_index where id_no='131082200301100787' and name='钟媛媛' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2003/1/10 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 05:51:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 05:51:48
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2720,'耳鼻喉科郭庆  普','上午','9','10568474','钟媛媛','','女','23','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 05:51:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192720','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 05:51:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2720,'耳鼻喉科郭庆  普','上午','9','10568474','钟媛媛','','女','23','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 05:51:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192720','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2720,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192720</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192720</pinkey><ordertime>2026-02-19 05:51:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 07:03:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15545498356</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_骨科杜志强</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>231027196609207222</patientidcard><patientname>刘翠玲</patientname><patientsex>女</patientsex><patientbirthday>1966-09-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15545498356</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 07:03:37
记录内容：select * from  pat_master_index where id_no='231027196609207222' and name='刘翠玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1966/9/20 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 07:03:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科杜志强' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 07:03:37
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2742,'骨科杜志强','上午','1','10785548','刘翠玲','LIU CUI LING','女','60','一般人员','自费','','普通号','1','0312','DUZHIQ','1',to_date('2026/02/19 07:03:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192742','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 07:03:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2742,'骨科杜志强','上午','1','10785548','刘翠玲','LIU CUI LING','女','60','一般人员','自费','','普通号','1','0312','DUZHIQ','1',to_date('2026/02/19 07:03:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192742','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科杜志强' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2742,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科杜志强' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192742</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192742</pinkey><ordertime>2026-02-19 07:03:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 07:18:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13932676264</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_消化内科李颖飞</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082197103167281</patientidcard><patientname>杨秀娟</patientname><patientsex>女</patientsex><patientbirthday>1971-03-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13932676264</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 07:18:18
记录内容：select * from  pat_master_index where id_no='131082197103167281' and name='杨秀娟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/3/16 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 07:18:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '消化内科李颖飞' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 07:18:18
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2753,'消化内科李颖飞','上午','2','00310144','杨秀娟','','女','55','一般人员','自费','','普通号','1','0302','LIYF','1',to_date('2026/02/19 07:18:25','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192753','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 07:18:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2753,'消化内科李颖飞','上午','2','00310144','杨秀娟','','女','55','一般人员','自费','','普通号','1','0302','LIYF','1',to_date('2026/02/19 07:18:25','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192753','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科李颖飞' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2753,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '消化内科李颖飞' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192753</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192753</pinkey><ordertime>2026-02-19 07:18:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:09:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210817666</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>140225197303160847</patientidcard><patientname>毛慧杰</patientname><patientsex>女</patientsex><patientbirthday>1973-03-16</patientbirthday><medicalrecord></medicalrecord><contactphone>15210817666</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:09:29
记录内容：select * from  pat_master_index where id_no='140225197303160847' and name='毛慧杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1973/3/16 0:00:0053
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:09:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:09: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/02/19','YYYY/MM/DD'),3678,'骨科刘海峰','上午','9','100538587','毛慧杰','MAO HUI JIE ','女','53','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 09:09:35','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602193678','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:09: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/02/19','YYYY/MM/DD'),3678,'骨科刘海峰','上午','9','100538587','毛慧杰','MAO HUI JIE ','女','53','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 09:09:35','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602193678','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),3678,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602193678</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602193678</pinkey><ordertime>2026-02-19 09:09:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:14:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15647672888</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/26 0:00:00_上午_神经外科杨明琪</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>150421197809063013</patientidcard><patientname>姜彦波</patientname><patientsex>男</patientsex><patientbirthday>1978-09-06</patientbirthday><medicalrecord></medicalrecord><contactphone>15647672888</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:14:25
记录内容：select * from  pat_master_index where id_no='150421197809063013' and name='姜彦波' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/9/6 0:00:0048
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:14:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '神经外科杨明琪' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:14: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/02/26','YYYY/MM/DD'),3756,'神经外科杨明琪','上午','1','100538588','姜彦波','JIANG YAN BO ','男','48','一般人员','自费','','主任号','1','0313','TTYMQ','1',to_date('2026/02/19 09:14:31','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602263756','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:14: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/02/26','YYYY/MM/DD'),3756,'神经外科杨明琪','上午','1','100538588','姜彦波','JIANG YAN BO ','男','48','一般人员','自费','','主任号','1','0313','TTYMQ','1',to_date('2026/02/19 09:14:31','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602263756','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/02/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经外科杨明琪' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/26','YYYY/MM/DD'),3756,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '神经外科杨明琪' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602263756</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602263756</pinkey><ordertime>2026-02-19 09:14:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:17:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15146691520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_呼吸内科刘景娇</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230230197012172322</patientidcard><patientname>孔祥杰</patientname><patientsex>女</patientsex><patientbirthday>1970-12-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15146691520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:17:17
记录内容：select * from  pat_master_index where id_no='230230197012172322' and name='孔祥杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/12/17 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:17:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '呼吸内科刘景娇' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:17:17
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),3800,'呼吸内科刘景娇','上午','3','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0317','LIUJJ1','1',to_date('2026/02/19 09:17:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602193800','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:17:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>失败，插入订单表失败1 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),3800,'呼吸内科刘景娇','上午','3','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0317','LIUJJ1','1',to_date('2026/02/19 09:17:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602193800','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科刘景娇' AND TIME_DESC = '上午'select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '呼吸内科刘景娇' and visit_time_desc = '上午'</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:20:07
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15146691520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_呼吸内科刘景娇</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230230197012172322</patientidcard><patientname>孔祥杰</patientname><patientsex>女</patientsex><patientbirthday>1970-12-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15146691520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:20:07
记录内容：select * from  pat_master_index where id_no='230230197012172322' and name='孔祥杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/12/17 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:20:07
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '呼吸内科刘景娇' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:20:07
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),3835,'呼吸内科刘景娇','上午','4','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0317','LIUJJ1','1',to_date('2026/02/19 09:20:14','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602193835','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:20:07
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),3835,'呼吸内科刘景娇','上午','4','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0317','LIUJJ1','1',to_date('2026/02/19 09:20:14','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602193835','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科刘景娇' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),3835,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '呼吸内科刘景娇' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602193835</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602193835</pinkey><ordertime>2026-02-19 09:20:07</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:34:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15831637695</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150425201002080423</patientidcard><patientname>张冉</patientname><patientsex>女</patientsex><patientbirthday>2010-02-08</patientbirthday><medicalrecord></medicalrecord><contactphone>15831637695</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:34:57
记录内容：select * from  pat_master_index where id_no='150425201002080423' and name='张冉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2010/2/8 0:00:0016
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:34:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:34:57
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),4025,'皮肤科常庆华','上午','16','10574201','张冉','','女','16','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 09:35:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602194025','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','15') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:34:57
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),4025,'皮肤科常庆华','上午','16','10574201','张冉','','女','16','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 09:35:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602194025','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','15') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),4025,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602194025</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602194025</pinkey><ordertime>2026-02-19 09:34:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:41:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13199463691</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_心脏康复安立敏</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230281197506030025</patientidcard><patientname>张淑艳</patientname><patientsex>女</patientsex><patientbirthday>1975-06-03</patientbirthday><medicalrecord></medicalrecord><contactphone>13199463691</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:41:03
记录内容：select * from  pat_master_index where id_no='230281197506030025' and name='张淑艳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1975/6/3 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:41:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '心脏康复安立敏' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:41:03
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),4106,'心脏康复安立敏','上午','2','10285111','张淑艳','','女','51','一般人员','自费','','主任号','1','0359','ALM','1',to_date('2026/02/19 09:41:09','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602204106','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09: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/02/20','YYYY/MM/DD'),4106,'心脏康复安立敏','上午','2','10285111','张淑艳','','女','51','一般人员','自费','','主任号','1','0359','ALM','1',to_date('2026/02/19 09:41:09','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602204106','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心脏康复安立敏' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),4106,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '心脏康复安立敏' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602204106</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602204106</pinkey><ordertime>2026-02-19 09:41:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:42:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13733267636</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/23 0:00:00_白天_妇科刘冬梅</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822196503214941</patientidcard><patientname>马秀环</patientname><patientsex>女</patientsex><patientbirthday>1965-03-21</patientbirthday><medicalrecord></medicalrecord><contactphone>13733267636</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:42:47
记录内容：select * from  pat_master_index where id_no='132822196503214941' and name='马秀环' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/3/21 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:42:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:42: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/02/23','YYYY/MM/DD'),4138,'妇科刘冬梅','白天','1','Z00228491','马秀环','','女','61','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2026/02/19 09:42:54','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602234138','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:42:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),4138,'妇科刘冬梅','白天','1','Z00228491','马秀环','','女','61','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2026/02/19 09:42:54','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602234138','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/02/23', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科刘冬梅' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/23','YYYY/MM/DD'),4138,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602234138</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602234138</pinkey><ordertime>2026-02-19 09:42:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:43:01
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13045215732</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_耳鼻喉科吴胜杰</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>23022219731002001X</patientidcard><patientname>李永伟</patientname><patientsex>男</patientsex><patientbirthday>1973-10-02</patientbirthday><medicalrecord></medicalrecord><contactphone>13045215732</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:43:01
记录内容：select * from  pat_master_index where id_no='23022219731002001X' and name='李永伟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1973/10/2 0:00:0053
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:43:01
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:43:01
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),4140,'耳鼻喉科吴胜杰','上午','10','Z00369526','李永伟','','男','53','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/02/19 09:43:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602204140','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:43:01
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),4140,'耳鼻喉科吴胜杰','上午','10','Z00369526','李永伟','','男','53','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/02/19 09:43:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602204140','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科吴胜杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),4140,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602204140</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602204140</pinkey><ordertime>2026-02-19 09:43:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:44:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15076628662</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_泌尿外科唐伟</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198901200511</patientidcard><patientname>李享</patientname><patientsex>男</patientsex><patientbirthday>1989-01-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15076628662</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:44:40
记录内容：select * from  pat_master_index where id_no='131082198901200511' and name='李享' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/1/20 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:44:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:44: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/02/19','YYYY/MM/DD'),4154,'泌尿外科唐伟','上午','12','00117532','李享','','男','37','一般人员','自费','','主任号','1','0311','TW','1',to_date('2026/02/19 09:44:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602194154','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','11') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:44: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/02/19','YYYY/MM/DD'),4154,'泌尿外科唐伟','上午','12','00117532','李享','','男','37','一般人员','自费','','主任号','1','0311','TW','1',to_date('2026/02/19 09:44:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602194154','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','11') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科唐伟' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),4154,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '泌尿外科唐伟' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602194154</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602194154</pinkey><ordertime>2026-02-19 09:44:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 09:49:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13733267636</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/23 0:00:00_白天_妇科薛利娟副主任</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822196503214941</patientidcard><patientname>马秀环</patientname><patientsex>女</patientsex><patientbirthday>1965-03-21</patientbirthday><medicalrecord></medicalrecord><contactphone>13733267636</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 09:49:36
记录内容：select * from  pat_master_index where id_no='132822196503214941' and name='马秀环' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/3/21 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:49:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '妇科薛利娟副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 09:49:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),4249,'妇科薛利娟副主任','白天','3','Z00228491','马秀环','','女','61','一般人员','自费','','副主任号','1','0316','XUELJ','1',to_date('2026/02/19 09:49:43','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602234249','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 09:49:36
记录内容：<?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/02/23','YYYY/MM/DD'),4249,'妇科薛利娟副主任','白天','3','Z00228491','马秀环','','女','61','一般人员','自费','','副主任号','1','0316','XUELJ','1',to_date('2026/02/19 09:49:43','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602234249','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/02/23', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科薛利娟副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/23','YYYY/MM/DD'),4249,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '妇科薛利娟副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602234249</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602234249</pinkey><ordertime>2026-02-19 09:49:36</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 10:08:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18731686807</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821196901218626</patientidcard><patientname>张春雪</patientname><patientsex>女</patientsex><patientbirthday>1969-01-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18731686807</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 10:08:44
记录内容：select * from  pat_master_index where id_no='132821196901218626' and name='张春雪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/1/21 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:08:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:08: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/02/19','YYYY/MM/DD'),4539,'骨科刘海峰','上午','13','10437731','张春雪','','女','57','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 10:08:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602194539','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','13') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 10:08:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),4539,'骨科刘海峰','上午','13','10437731','张春雪','','女','57','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 10:08:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602194539','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','13') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),4539,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602194539</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602194539</pinkey><ordertime>2026-02-19 10:08:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 10:42:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18730661631</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_内分泌科马伟杰普</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>360122200405137817</patientidcard><patientname>刘之煦</patientname><patientsex>男</patientsex><patientbirthday>2004-05-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18730661631</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 10:42:25
记录内容：select * from  pat_master_index where id_no='360122200405137817' and name='刘之煦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/5/13 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:42:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:42: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/02/19','YYYY/MM/DD'),5077,'内分泌科马伟杰普','下午','1','100538601','刘之煦','LIU ZHI  ','男','22','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/19 10:42:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195077','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 10:42: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/02/19','YYYY/MM/DD'),5077,'内分泌科马伟杰普','下午','1','100538601','刘之煦','LIU ZHI  ','男','22','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/19 10:42:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195077','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5077,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195077</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602195077</pinkey><ordertime>2026-02-19 10:42:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 10:42:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17774913200</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/26 0:00:00_上午_骨科刘清和</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152122195504110328</patientidcard><patientname>孙秀红</patientname><patientsex>女</patientsex><patientbirthday>1955-04-11</patientbirthday><medicalrecord></medicalrecord><contactphone>17774913200</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 10:42:33
记录内容：select * from  pat_master_index where id_no='152122195504110328' and name='孙秀红' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/4/11 0:00:0071
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:42:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '骨科刘清和' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:42:33
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/26','YYYY/MM/DD'),5079,'骨科刘清和','上午','1','Z00487792','孙秀红','','女','71','一般人员','自费','','知名专家','1','0312','CYLQH','1',to_date('2026/02/19 10:42:39','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602265079','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 10:42:33
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/26','YYYY/MM/DD'),5079,'骨科刘清和','上午','1','Z00487792','孙秀红','','女','71','一般人员','自费','','知名专家','1','0312','CYLQH','1',to_date('2026/02/19 10:42:39','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602265079','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/02/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘清和' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/26','YYYY/MM/DD'),5079,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '骨科刘清和' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602265079</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602265079</pinkey><ordertime>2026-02-19 10:42:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 10:48:30
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13722641935</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_胸外科李博文</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821195903210543</patientidcard><patientname>钱丽云</patientname><patientsex>女</patientsex><patientbirthday>1959-03-21</patientbirthday><medicalrecord></medicalrecord><contactphone>13722641935</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 10:48:30
记录内容：select * from  pat_master_index where id_no='132821195903210543' and name='钱丽云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1959/3/21 0:00:0067
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:48:30
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '胸外科李博文' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:48:30
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),5154,'胸外科李博文','上午','1','100538097','钱丽云','QIAN LI YUN ','女','67','一般人员','自费','','普通号','1','0366','LIBOW1','1',to_date('2026/02/19 10:48:36','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602225154','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 10:48:30
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),5154,'胸外科李博文','上午','1','100538097','钱丽云','QIAN LI YUN ','女','67','一般人员','自费','','普通号','1','0366','LIBOW1','1',to_date('2026/02/19 10:48:36','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602225154','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/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胸外科李博文' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),5154,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '胸外科李博文' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602225154</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602225154</pinkey><ordertime>2026-02-19 10:48:30</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 10:48:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17774913200</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152122195504110328</patientidcard><patientname>孙秀红</patientname><patientsex>女</patientsex><patientbirthday>1955-04-11</patientbirthday><medicalrecord></medicalrecord><contactphone>17774913200</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 10:48:32
记录内容：select * from  pat_master_index where id_no='152122195504110328' and name='孙秀红' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/4/11 0:00:0071
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:48:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 10:48:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5156,'骨科刘海峰','上午','18','Z00487792','孙秀红','','女','71','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 10:48:38','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602195156','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','18') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 10:48:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5156,'骨科刘海峰','上午','18','Z00487792','孙秀红','','女','71','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/19 10:48:38','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602195156','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','18') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5156,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602195156</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602195156</pinkey><ordertime>2026-02-19 10:48:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 11:01:54
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13106690219</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411524200511162725</patientidcard><patientname>黄悦</patientname><patientsex>女</patientsex><patientbirthday>2005-11-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13106690219</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 11:01:54
记录内容：select * from  pat_master_index where id_no='411524200511162725' and name='黄悦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/11/16 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:01:54
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:01:54
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,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/02/19','YYYY/MM/DD'),5305,'皮肤科常庆华','下午','6','10142742','黄悦','HUANG YUE','女','21','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 11:02:00','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602195305','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','30') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 11:01:54
记录内容：<?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/02/19','YYYY/MM/DD'),5305,'皮肤科常庆华','下午','6','10142742','黄悦','HUANG YUE','女','21','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 11:02:00','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602195305','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','30') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5305,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195305</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602195305</pinkey><ordertime>2026-02-19 11:01:54</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 11:03:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13106690219</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_耳鼻喉科郭庆  普</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>411524200511162725</patientidcard><patientname>黄悦</patientname><patientsex>女</patientsex><patientbirthday>2005-11-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13106690219</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 11:03:40
记录内容：select * from  pat_master_index where id_no='411524200511162725' and name='黄悦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/11/16 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:03:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:03: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/02/19','YYYY/MM/DD'),5334,'耳鼻喉科郭庆  普','下午','1','10142742','黄悦','HUANG YUE','女','21','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 11:03:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195334','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 11:03: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/02/19','YYYY/MM/DD'),5334,'耳鼻喉科郭庆  普','下午','1','10142742','黄悦','HUANG YUE','女','21','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 11:03:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195334','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5334,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195334</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602195334</pinkey><ordertime>2026-02-19 11:03:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 11:04:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13126964826</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_高压氧科王倩</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132526195511280812</patientidcard><patientname>申密</patientname><patientsex>男</patientsex><patientbirthday>1955-11-28</patientbirthday><medicalrecord></medicalrecord><contactphone>13126964826</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 11:04:47
记录内容：select * from  pat_master_index where id_no='132526195511280812' and name='申密' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/11/28 0:00:0071
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:04:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '高压氧科王倩' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:04: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/02/19','YYYY/MM/DD'),5343,'高压氧科王倩','下午','3','100538584','申密','SHEN MI ','男','71','一般人员','自费','','普通号','1','0340','WQ01','1',to_date('2026/02/19 11:04:54','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195343','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 11:04:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5343,'高压氧科王倩','下午','3','100538584','申密','SHEN MI ','男','71','一般人员','自费','','普通号','1','0340','WQ01','1',to_date('2026/02/19 11:04:54','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195343','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '高压氧科王倩' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5343,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '高压氧科王倩' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195343</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602195343</pinkey><ordertime>2026-02-19 11:04:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 11:17:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15931453538</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130229195808181226</patientidcard><patientname>王秀清</patientname><patientsex>女</patientsex><patientbirthday>1958-08-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15931453538</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 11:17:33
记录内容：select * from  pat_master_index where id_no='130229195808181226' and name='王秀清' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1958/8/18 0:00:0068
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:17:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 11:17:33
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5484,'皮肤科常庆华','下午','7','Z00445189','王秀清','','女','68','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 11:17:40','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602195484','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','31') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 11:17:33
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5484,'皮肤科常庆华','下午','7','Z00445189','王秀清','','女','68','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 11:17:40','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602195484','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','31') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5484,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195484</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602195484</pinkey><ordertime>2026-02-19 11:17:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 12:06:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13701369613</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_神经内科杨志华</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>110102197012203020</patientidcard><patientname>蒋燕</patientname><patientsex>女</patientsex><patientbirthday>1970-12-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13701369613</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 12:06:14
记录内容：select * from  pat_master_index where id_no='110102197012203020' and name='蒋燕' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/12/20 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 12:06:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 12:06:14
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5775,'神经内科杨志华','下午','1','Z00340962','蒋燕','','女','56','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/19 12:06:20','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195775','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 12:06:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5775,'神经内科杨志华','下午','1','Z00340962','蒋燕','','女','56','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/19 12:06:20','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195775','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科杨志华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5775,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195775</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602195775</pinkey><ordertime>2026-02-19 12:06:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 13:12:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13911968867</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_耳鼻喉科郭庆  普</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210624196801023051</patientidcard><patientname>祝兆海</patientname><patientsex>男</patientsex><patientbirthday>1968-01-02</patientbirthday><medicalrecord></medicalrecord><contactphone>13911968867</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 13:12:27
记录内容：select * from  pat_master_index where id_no='210624196801023051' and name='祝兆海' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/1/2 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:12:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:12: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/02/19','YYYY/MM/DD'),5908,'耳鼻喉科郭庆  普','下午','3','100538612','祝兆海','ZHU ZHAO HAI ','男','58','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 13:12:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195908','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 13:12: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/02/19','YYYY/MM/DD'),5908,'耳鼻喉科郭庆  普','下午','3','100538612','祝兆海','ZHU ZHAO HAI ','男','58','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 13:12:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602195908','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),5908,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602195908</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602195908</pinkey><ordertime>2026-02-19 13:12:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 13:12:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13104578377</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>23272219710614222X</patientidcard><patientname>王晓萍</patientname><patientsex>女</patientsex><patientbirthday>1971-06-14</patientbirthday><medicalrecord></medicalrecord><contactphone>13104578377</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 13:12:42
记录内容：select * from  pat_master_index where id_no='23272219710614222X' and name='王晓萍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/6/14 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:12:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:12:42
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),5910,'皮肤科常庆华','上午','1','100295152','王晓萍','WANG XIAO PING ','女','55','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 13:12:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602205910','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 13:12:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),5910,'皮肤科常庆华','上午','1','100295152','王晓萍','WANG XIAO PING ','女','55','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 13:12:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602205910','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),5910,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602205910</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602205910</pinkey><ordertime>2026-02-19 13:12:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 13:25:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13784820465</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_中医科闫晋升</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132530197206163218</patientidcard><patientname>段春林</patientname><patientsex>男</patientsex><patientbirthday>1972-06-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13784820465</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 13:25:40
记录内容：select * from  pat_master_index where id_no='132530197206163218' and name='段春林' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1972/6/16 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:25:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '中医科闫晋升' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:25: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/02/22','YYYY/MM/DD'),5994,'中医科闫晋升','上午','1','100538614','段春林','DUAN CHUN LIN ','男','54','一般人员','自费','','中副主任','1','0301','YJS','1',to_date('2026/02/19 13:25:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602225994','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 13:25: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/02/22','YYYY/MM/DD'),5994,'中医科闫晋升','上午','1','100538614','段春林','DUAN CHUN LIN ','男','54','一般人员','自费','','中副主任','1','0301','YJS','1',to_date('2026/02/19 13:25:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602225994','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/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医科闫晋升' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),5994,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '中医科闫晋升' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602225994</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602225994</pinkey><ordertime>2026-02-19 13:25:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 13:52:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17703361869</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_白天_妇科杨芳</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>13108220060904104X</patientidcard><patientname>薄凯元</patientname><patientsex>女</patientsex><patientbirthday>2006-09-04</patientbirthday><medicalrecord></medicalrecord><contactphone>17703361869</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 13:52:47
记录内容：select * from  pat_master_index where id_no='13108220060904104X' and name='薄凯元' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/9/4 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:52:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 13:52: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/02/20','YYYY/MM/DD'),6239,'妇科杨芳','白天','1','100538636','薄凯元','BAO KAI YUAN ','女','20','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2026/02/19 13:52:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602206239','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 13:52: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/02/20','YYYY/MM/DD'),6239,'妇科杨芳','白天','1','100538636','薄凯元','BAO KAI YUAN ','女','20','一般人员','自费','','副主任号','1','0316','YANGF1','1',to_date('2026/02/19 13:52:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602206239','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科杨芳' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),6239,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '妇科杨芳' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602206239</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602206239</pinkey><ordertime>2026-02-19 13:52:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 14:14:41
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17778029286</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_耳鼻喉科郭庆  普</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230221200402205212</patientidcard><patientname>胡名芳</patientname><patientsex>男</patientsex><patientbirthday>2004-02-20</patientbirthday><medicalrecord></medicalrecord><contactphone>17778029286</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 14:14:41
记录内容：select * from  pat_master_index where id_no='230221200402205212' and name='胡名芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/2/20 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 14:14:41
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 14:14:41
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,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/02/19','YYYY/MM/DD'),6393,'耳鼻喉科郭庆  普','下午','5','100537753','胡名芳','HU MING FANG ','男','22','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 14:14:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602196393','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 14:14:41
记录内容：<?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/02/19','YYYY/MM/DD'),6393,'耳鼻喉科郭庆  普','下午','5','100537753','胡名芳','HU MING FANG ','男','22','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/19 14:14:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602196393','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),6393,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602196393</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602196393</pinkey><ordertime>2026-02-19 14:14:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 14:38:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18519248666</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_下午_皮肤科杨维玲</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370829199605133529</patientidcard><patientname>刘飞</patientname><patientsex>女</patientsex><patientbirthday>1996-05-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18519248666</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 14:38:37
记录内容：select * from  pat_master_index where id_no='370829199605133529' and name='刘飞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/5/13 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 14:38:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 14:38: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/02/22','YYYY/MM/DD'),6584,'皮肤科杨维玲','下午','2','100385868','刘飞','LIU FEI ','女','30','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/02/19 14:38:43','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602226584','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 14:38: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/02/22','YYYY/MM/DD'),6584,'皮肤科杨维玲','下午','2','100385868','刘飞','LIU FEI ','女','30','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/02/19 14:38:43','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602226584','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/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),6584,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602226584</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602226584</pinkey><ordertime>2026-02-19 14:38:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 15:41:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17778029286</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_神经内科杨志华</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230221200402205212</patientidcard><patientname>胡名芳</patientname><patientsex>男</patientsex><patientbirthday>2004-02-20</patientbirthday><medicalrecord></medicalrecord><contactphone>17778029286</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 15:41:18
记录内容：select * from  pat_master_index where id_no='230221200402205212' and name='胡名芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/2/20 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 15:41:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 15:41:18
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),7062,'神经内科杨志华','下午','21','100537753','胡名芳','HU MING FANG ','男','22','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/19 15:41:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602197062','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','56') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 15:41:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/19','YYYY/MM/DD'),7062,'神经内科杨志华','下午','21','100537753','胡名芳','HU MING FANG ','男','22','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/19 15:41:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602197062','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','56') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科杨志华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),7062,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602197062</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602197062</pinkey><ordertime>2026-02-19 15:41:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 15:53:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13311567511</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_普通外科赵磊</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370811197911030031</patientidcard><patientname>彭兆前</patientname><patientsex>男</patientsex><patientbirthday>1979-11-03</patientbirthday><medicalrecord></medicalrecord><contactphone>13311567511</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 15:53:24
记录内容：select * from  pat_master_index where id_no='370811197911030031' and name='彭兆前' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/11/3 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 15:53:24
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '普通外科赵磊' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 15:53: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/02/20','YYYY/MM/DD'),7144,'普通外科赵磊','上午','4','10456134','彭兆前','','男','47','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2026/02/19 15:53:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207144','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 15:53: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/02/20','YYYY/MM/DD'),7144,'普通外科赵磊','上午','4','10456134','彭兆前','','男','47','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2026/02/19 15:53:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207144','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科赵磊' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7144,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '普通外科赵磊' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207144</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207144</pinkey><ordertime>2026-02-19 15:53:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 18:19:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13910128268</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_下午_便民门诊周静</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230103194409014228</patientidcard><patientname>龚玫玉</patientname><patientsex>女</patientsex><patientbirthday>1944-09-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13910128268</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 18:19:49
记录内容：select * from  pat_master_index where id_no='230103194409014228' and name='龚玫玉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1944/9/1 0:00:0082
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 18:19:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '便民门诊周静' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 18:19:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7548,'便民门诊周静','下午','1','100538648','龚玫玉','GONG MEI YU ','女','82','一般人员','自费','','便民号','1','0396','ZJ5','1',to_date('2026/02/19 18:19:53','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202602207548','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 18:19:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7548,'便民门诊周静','下午','1','100538648','龚玫玉','GONG MEI YU ','女','82','一般人员','自费','','便民号','1','0396','ZJ5','1',to_date('2026/02/19 18:19:53','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202602207548','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '便民门诊周静' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7548,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '便民门诊周静' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602207548</orderid><reservefee>0.00</reservefee><clinicfee>1</clinicfee><registrationfee>0</registrationfee><pinkey>202602207548</pinkey><ordertime>2026-02-19 18:19:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 18:44:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13288870103</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_神经内科徐金静</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23070219620503162X</patientidcard><patientname>周玉珍</patientname><patientsex>女</patientsex><patientbirthday>1962-05-03</patientbirthday><medicalrecord></medicalrecord><contactphone>13288870103</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 18:44:19
记录内容：select * from  pat_master_index where id_no='23070219620503162X' and name='周玉珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1962/5/3 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 18:44:19
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 18:44: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/02/20','YYYY/MM/DD'),7577,'神经内科徐金静','上午','3','100538649','周玉珍','ZHOU YU ZHEN ','女','64','一般人员','自费','','副主任号','1','0303','XUJJ','1',to_date('2026/02/19 18:44:24','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207577','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 18:44: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/02/20','YYYY/MM/DD'),7577,'神经内科徐金静','上午','3','100538649','周玉珍','ZHOU YU ZHEN ','女','64','一般人员','自费','','副主任号','1','0303','XUJJ','1',to_date('2026/02/19 18:44:24','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207577','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科徐金静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7577,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '神经内科徐金静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207577</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207577</pinkey><ordertime>2026-02-19 18:44:20</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 19:12:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16631619985</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_白天_妇科韩卫灵副主任</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>32108119970120604X</patientidcard><patientname>朱雅</patientname><patientsex>女</patientsex><patientbirthday>1997-01-20</patientbirthday><medicalrecord></medicalrecord><contactphone>16631619985</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 19:12:20
记录内容：select * from  pat_master_index where id_no='32108119970120604X' and name='朱雅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/1/20 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:12:20
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:12: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/02/21','YYYY/MM/DD'),7591,'妇科韩卫灵副主任','白天','1','Z00243034','朱雅','ZHU YA','女','29','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/19 19:12:25','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602217591','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 19:12:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),7591,'妇科韩卫灵副主任','白天','1','Z00243034','朱雅','ZHU YA','女','29','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/19 19:12:25','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602217591','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/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科韩卫灵副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),7591,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602217591</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602217591</pinkey><ordertime>2026-02-19 19:12:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 19:22:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13552526786</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_泌尿外科陈博闻</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230830196210202017</patientidcard><patientname>于光明</patientname><patientsex>男</patientsex><patientbirthday>1962-10-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13552526786</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 19:22:56
记录内容：select * from  pat_master_index where id_no='230830196210202017' and name='于光明' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1962/10/20 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:22:56
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '泌尿外科陈博闻' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:22:56
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,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/02/20','YYYY/MM/DD'),7601,'泌尿外科陈博闻','上午','1','100538652','于光明','YU GUANG MING ','男','64','一般人员','自费','','普通号','1','0311','CBW','1',to_date('2026/02/19 19:23:00','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602207601','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 19:22:56
记录内容：<?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/02/20','YYYY/MM/DD'),7601,'泌尿外科陈博闻','上午','1','100538652','于光明','YU GUANG MING ','男','64','一般人员','自费','','普通号','1','0311','CBW','1',to_date('2026/02/19 19:23:00','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602207601','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科陈博闻' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7601,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '泌尿外科陈博闻' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207601</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602207601</pinkey><ordertime>2026-02-19 19:22:56</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 19:40:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13638920286</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_白天_妇科邓宏文</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>511023197410200601</patientidcard><patientname>刘红梅</patientname><patientsex>女</patientsex><patientbirthday>1974-10-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13638920286</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 19:40:03
记录内容：select * from  pat_master_index where id_no='511023197410200601' and name='刘红梅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/10/20 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:40:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:40:03
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7621,'妇科邓宏文','白天','1','100538653','刘红梅','LIU HONG MEI ','女','52','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2026/02/19 19:40:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602207621','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 19:40: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/02/20','YYYY/MM/DD'),7621,'妇科邓宏文','白天','1','100538653','刘红梅','LIU HONG MEI ','女','52','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2026/02/19 19:40:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602207621','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科邓宏文' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7621,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602207621</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602207621</pinkey><ordertime>2026-02-19 19:40:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 19:47:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17770878418</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>362523199005093610</patientidcard><patientname>陈伟</patientname><patientsex>男</patientsex><patientbirthday>1990-05-09</patientbirthday><medicalrecord></medicalrecord><contactphone>17770878418</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 19:47:17
记录内容：select * from  pat_master_index where id_no='362523199005093610' and name='陈伟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/5/9 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:47:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:47:17
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7628,'皮肤科常庆华','上午','2','100538022','陈伟','CHEN WEI ','男','36','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 19:47:21','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207628','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 19:47:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7628,'皮肤科常庆华','上午','2','100538022','陈伟','CHEN WEI ','男','36','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 19:47:21','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207628','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7628,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207628</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207628</pinkey><ordertime>2026-02-19 19:47:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 19:52:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13638920286</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_下午_内分泌科张金环</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>511023197410200601</patientidcard><patientname>刘红梅</patientname><patientsex>女</patientsex><patientbirthday>1974-10-20</patientbirthday><medicalrecord></medicalrecord><contactphone>13638920286</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 19:52:00
记录内容：select * from  pat_master_index where id_no='511023197410200601' and name='刘红梅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/10/20 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:52:01
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 19:52:01
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7634,'内分泌科张金环','下午','1','100538653','刘红梅','LIU HONG MEI ','女','52','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/02/19 19:52:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207634','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 19:52:01
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7634,'内分泌科张金环','下午','1','100538653','刘红梅','LIU HONG MEI ','女','52','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/02/19 19:52:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207634','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7634,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602207634</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207634</pinkey><ordertime>2026-02-19 19:52:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 20:30:10
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15075668109</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_疼痛科王佳璐</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132821196808182518</patientidcard><patientname>林福辰</patientname><patientsex>男</patientsex><patientbirthday>1968-08-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15075668109</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 20:30:10
记录内容：select * from  pat_master_index where id_no='132821196808182518' and name='林福辰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/8/18 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 20:30:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '疼痛科王佳璐' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 20:30:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7654,'疼痛科王佳璐','上午','3','100410317','林福辰','LIN FU CHEN ','男','58','一般人员','自费','','副主任号','1','0332','WJL1','1',to_date('2026/02/19 20:30:13','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207654','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 20:30:10
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7654,'疼痛科王佳璐','上午','3','100410317','林福辰','LIN FU CHEN ','男','58','一般人员','自费','','副主任号','1','0332','WJL1','1',to_date('2026/02/19 20:30:13','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207654','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '疼痛科王佳璐' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7654,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '疼痛科王佳璐' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207654</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207654</pinkey><ordertime>2026-02-19 20:30:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 20:59:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18519248666</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>370829199605133529</patientidcard><patientname>刘飞</patientname><patientsex>女</patientsex><patientbirthday>1996-05-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18519248666</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 20:59:25
记录内容：select * from  pat_master_index where id_no='370829199605133529' and name='刘飞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/5/13 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 20:59:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 20:59: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/02/20','YYYY/MM/DD'),7671,'皮肤科常庆华','上午','3','100385868','刘飞','LIU FEI ','女','30','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 20:59:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207671','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 20:59: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/02/20','YYYY/MM/DD'),7671,'皮肤科常庆华','上午','3','100385868','刘飞','LIU FEI ','女','30','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 20:59:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207671','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7671,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207671</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207671</pinkey><ordertime>2026-02-19 20:59:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 21:58:41
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19322566447</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/24 0:00:00_白天_妇科王兰</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210902199004015026</patientidcard><patientname>陈晨</patientname><patientsex>女</patientsex><patientbirthday>1990-04-01</patientbirthday><medicalrecord></medicalrecord><contactphone>19322566447</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 21:58:41
记录内容：select * from  pat_master_index where id_no='210902199004015026' and name='陈晨' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/4/1 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 21:58:41
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 21:58:41
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,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/02/24','YYYY/MM/DD'),7714,'妇科王兰','白天','1','100311298','陈晨','CHEN CHEN','女','36','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/02/19 21:58:44','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602247714','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 21:58:41
记录内容：<?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/02/24','YYYY/MM/DD'),7714,'妇科王兰','白天','1','100311298','陈晨','CHEN CHEN','女','36','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/02/19 21:58:44','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602247714','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/02/24', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/24','YYYY/MM/DD'),7714,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602247714</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602247714</pinkey><ordertime>2026-02-19 21:58:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 22:05:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15100617756</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_下午_普通外科赵磊</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199205252937</patientidcard><patientname>刘博臣</patientname><patientsex>男</patientsex><patientbirthday>1992-05-25</patientbirthday><medicalrecord></medicalrecord><contactphone>15100617756</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 22:05:02
记录内容：select * from  pat_master_index where id_no='131082199205252937' and name='刘博臣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/5/25 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 22:05:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '普通外科赵磊' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 22:05: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/02/20','YYYY/MM/DD'),7719,'普通外科赵磊','下午','1','10604412','刘博臣','','男','34','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2026/02/19 22:05:06','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207719','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 22:05:02
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7719,'普通外科赵磊','下午','1','10604412','刘博臣','','男','34','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2026/02/19 22:05:06','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207719','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科赵磊' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7719,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '普通外科赵磊' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602207719</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207719</pinkey><ordertime>2026-02-19 22:05:02</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 22:31:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17612319244</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200207242019</patientidcard><patientname>何晨晨</patientname><patientsex>男</patientsex><patientbirthday>2002-07-24</patientbirthday><medicalrecord></medicalrecord><contactphone>17612319244</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 22:31:14
记录内容：select * from  pat_master_index where id_no='131028200207242019' and name='何晨晨' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/7/24 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 22:31:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 22:31:14
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7733,'皮肤科常庆华','上午','4','10397516','何晨晨','','男','24','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 22:31:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207733','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 22:31:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7733,'皮肤科常庆华','上午','4','10397516','何晨晨','','男','24','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/19 22:31:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602207733','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7733,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207733</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602207733</pinkey><ordertime>2026-02-19 22:31:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-19 22:34:19
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18601072785</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_呼吸内科王君 普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152104197609274202</patientidcard><patientname>王疆</patientname><patientsex>女</patientsex><patientbirthday>1976-09-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18601072785</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-19 22:34:20
记录内容：select * from  pat_master_index where id_no='152104197609274202' and name='王疆' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1976/9/27 0:00:0050
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 22:34:20
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王君 普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-19 22:34: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/02/20','YYYY/MM/DD'),7735,'呼吸内科王君 普','上午','1','00313809','王疆','','女','50','一般人员','自费','','普通号','1','0317','WANGJ','1',to_date('2026/02/19 22:34:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602207735','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-19 22:34: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/02/20','YYYY/MM/DD'),7735,'呼吸内科王君 普','上午','1','00313809','王疆','','女','50','一般人员','自费','','普通号','1','0317','WANGJ','1',to_date('2026/02/19 22:34:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602207735','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/02/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王君 普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),7735,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王君 普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602207735</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602207735</pinkey><ordertime>2026-02-19 22:34:20</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆