◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 01:48:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18831695560</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_妇科李广太</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150105200505257861</patientidcard><patientname>刘凝</patientname><patientsex>女</patientsex><patientbirthday>2005-05-25</patientbirthday><medicalrecord></medicalrecord><contactphone>18831695560</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 01:48:24
记录内容：select * from  pat_master_index where id_no='150105200505257861' and name='刘凝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/5/25 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 01:48:24
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '妇科李广太' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 01:48:24
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),4932,'妇科李广太','上午','1','Z00366270','刘凝','LIU NING','女','20','一般人员','自费','','知名专家','1','0316','LGT01','1',to_date('2025/11/02 01:48:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511034932','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 01:48: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('2025/11/03','YYYY/MM/DD'),4932,'妇科李广太','上午','1','Z00366270','刘凝','LIU NING','女','20','一般人员','自费','','知名专家','1','0316','LGT01','1',to_date('2025/11/02 01:48:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511034932','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科李广太' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),4932,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '妇科李广太' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511034932</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511034932</pinkey><ordertime>2025-11-02 01:48:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 04:35:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13661306310</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/10 0:00:00_上午_神经内科王卫</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132626195305170511</patientidcard><patientname>闫文桂</patientname><patientsex>男</patientsex><patientbirthday>1953-05-17</patientbirthday><medicalrecord></medicalrecord><contactphone>13661306310</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 04:35:16
记录内容：select * from  pat_master_index where id_no='132626195305170511' and name='闫文桂' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1953/5/17 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 04:35:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 04:35:16
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/10','YYYY/MM/DD'),4983,'神经内科王卫','上午','1','100515555','闫文桂',' WEN GUI ','男','72','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/11/02 04:35:20','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511104983','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 04:35:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/10','YYYY/MM/DD'),4983,'神经内科王卫','上午','1','100515555','闫文桂',' WEN GUI ','男','72','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/11/02 04:35:20','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511104983','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科王卫' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/10','YYYY/MM/DD'),4983,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511104983</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511104983</pinkey><ordertime>2025-11-02 04:35:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 08:09:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18511637685</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/15 0:00:00_上午_眼科刘淑琴</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>310112197209090074</patientidcard><patientname>兰威</patientname><patientsex>男</patientsex><patientbirthday>1972-09-09</patientbirthday><medicalrecord></medicalrecord><contactphone>18511637685</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 08:09:05
记录内容：select * from  pat_master_index where id_no='310112197209090074' and name='兰威' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1972/9/9 0:00:0053
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 08:09:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/15','yyyy/mm/dd')
                    and clinic_label = '眼科刘淑琴' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 08:09:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/15','YYYY/MM/DD'),5411,'眼科刘淑琴','上午','1','100154140','兰威','LAN WEI ','男','53','一般人员','自费','','知名专家','1','0327','LSQ','1',to_date('2025/11/02 08:09:09','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511155411','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 08:09:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/15','YYYY/MM/DD'),5411,'眼科刘淑琴','上午','1','100154140','兰威','LAN WEI ','男','53','一般人员','自费','','知名专家','1','0327','LSQ','1',to_date('2025/11/02 08:09:09','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511155411','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/15', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科刘淑琴' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/15','YYYY/MM/DD'),5411,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/15','yyyy/mm/dd')
                    and clinic_label = '眼科刘淑琴' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511155411</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511155411</pinkey><ordertime>2025-11-02 08:09:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 08:23:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13261676477</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/13 0:00:00_上午_骨质疏松张国栋</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23040419791226022X</patientidcard><patientname>朱燕</patientname><patientsex>女</patientsex><patientbirthday>1979-12-26</patientbirthday><medicalrecord></medicalrecord><contactphone>13261676477</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 08:23:46
记录内容：select * from  pat_master_index where id_no='23040419791226022X' and name='朱燕' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/12/26 0:00:0046
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 08:23:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/13','yyyy/mm/dd')
                    and clinic_label = '骨质疏松张国栋' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 08:23:46
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/13','YYYY/MM/DD'),5797,'骨质疏松张国栋','上午','1','00442901','朱燕','ZHU YAN','女','46','一般人员','自费','','副主任号','1','0312','ZGD','1',to_date('2025/11/02 08:23:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511135797','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 08:23:46
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/13','YYYY/MM/DD'),5797,'骨质疏松张国栋','上午','1','00442901','朱燕','ZHU YAN','女','46','一般人员','自费','','副主任号','1','0312','ZGD','1',to_date('2025/11/02 08:23:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511135797','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨质疏松张国栋' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/13','YYYY/MM/DD'),5797,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/13','yyyy/mm/dd')
                    and clinic_label = '骨质疏松张国栋' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511135797</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511135797</pinkey><ordertime>2025-11-02 08:23:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 09:01:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13722033162</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_心血管内郭晓光普</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152103197108118010</patientidcard><patientname>张立文</patientname><patientsex>男</patientsex><patientbirthday>1971-08-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13722033162</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 09:01:27
记录内容：select * from  pat_master_index where id_no='152103197108118010' and name='张立文' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/8/11 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 09:01:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 09:01:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),6864,'心血管内郭晓光普','下午','1','100434155','张立文','ZHANG LI WEN ','男','54','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/11/02 09:01:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511026864','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 09:01:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),6864,'心血管内郭晓光普','下午','1','100434155','张立文','ZHANG LI WEN ','男','54','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/11/02 09:01:31','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511026864','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内郭晓光普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),6864,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '心血管内郭晓光普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511026864</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511026864</pinkey><ordertime>2025-11-02 09:01:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 09:18:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15100721907</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/9 0:00:00_上午_肛肠门诊孟庆成</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230204198301170720</patientidcard><patientname>闫瑾</patientname><patientsex>女</patientsex><patientbirthday>1983-01-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15100721907</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 09:18:05
记录内容：select * from  pat_master_index where id_no='230204198301170720' and name='闫瑾' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1983/1/17 0:00:0042
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 09:18:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/09','yyyy/mm/dd')
                    and clinic_label = '肛肠门诊孟庆成' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 09:18:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/09','YYYY/MM/DD'),7368,'肛肠门诊孟庆成','上午','1','Z00248239','闫瑾','','女','42','一般人员','自费','','主任号','1','0335','MQC','1',to_date('2025/11/02 09:18:09','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511097368','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 09:18:06
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/09','YYYY/MM/DD'),7368,'肛肠门诊孟庆成','上午','1','Z00248239','闫瑾','','女','42','一般人员','自费','','主任号','1','0335','MQC','1',to_date('2025/11/02 09:18:09','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511097368','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/09', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '肛肠门诊孟庆成' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/09','YYYY/MM/DD'),7368,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/09','yyyy/mm/dd')
                    and clinic_label = '肛肠门诊孟庆成' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511097368</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511097368</pinkey><ordertime>2025-11-02 09:18:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 09:45:41
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18800009840</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_下午_泌尿外科杨云波</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130802198206240811</patientidcard><patientname>薛承林</patientname><patientsex>男</patientsex><patientbirthday>1982-06-24</patientbirthday><medicalrecord></medicalrecord><contactphone>18800009840</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 09:45:41
记录内容：select * from  pat_master_index where id_no='130802198206240811' and name='薛承林' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/6/24 0:00:0043
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 09:45:41
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 09:45: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('2025/11/03','YYYY/MM/DD'),8229,'泌尿外科杨云波','下午','2','10332638','薛承林','','男','43','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2025/11/02 09:45:44','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511038229','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 09:45: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('2025/11/03','YYYY/MM/DD'),8229,'泌尿外科杨云波','下午','2','10332638','薛承林','','男','43','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2025/11/02 09:45:44','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511038229','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科杨云波' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),8229,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511038229</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511038229</pinkey><ordertime>2025-11-02 09:45:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 10:18:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15811550042</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/5 0:00:00_白天_妇科邓宏文</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>231026199510155220</patientidcard><patientname>李鑫媛</patientname><patientsex>女</patientsex><patientbirthday>1995-10-15</patientbirthday><medicalrecord></medicalrecord><contactphone>15811550042</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 10:18:00
记录内容：select * from  pat_master_index where id_no='231026199510155220' and name='李鑫媛' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/10/15 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:18:00
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/05','yyyy/mm/dd')
                    and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:18:00
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/05','YYYY/MM/DD'),9308,'妇科邓宏文','白天','2','10698995','李鑫媛','LI XIN YUAN','女','30','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2025/11/02 10:18:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511059308','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 10:18:00
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/05','YYYY/MM/DD'),9308,'妇科邓宏文','白天','2','10698995','李鑫媛','LI XIN YUAN','女','30','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2025/11/02 10:18:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511059308','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科邓宏文' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/05','YYYY/MM/DD'),9308,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/05','yyyy/mm/dd')
                    and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511059308</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511059308</pinkey><ordertime>2025-11-02 10:18:00</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 10:21:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13718452238</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_儿科刘婕</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220105202304090249</patientidcard><patientname>高乐潼</patientname><patientsex>女</patientsex><patientbirthday>2023-04-09</patientbirthday><medicalrecord></medicalrecord><contactphone>13718452238</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 10:21:32
记录内容：select * from  pat_master_index where id_no='220105202304090249' and name='高乐潼' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2023/4/9 0:00:002
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:21:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:21:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),9417,'儿科刘婕','下午','1','100366122','高乐潼','GAO LE  ','女','2','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/02 10:21:35','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511029417','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 10:21:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),9417,'儿科刘婕','下午','1','100366122','高乐潼','GAO LE  ','女','2','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/02 10:21:35','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511029417','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),9417,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511029417</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511029417</pinkey><ordertime>2025-11-02 10:21:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 10:38:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18931477526</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_消化内科李颖飞</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130227200501160026</patientidcard><patientname>何南春</patientname><patientsex>女</patientsex><patientbirthday>2005-01-16</patientbirthday><medicalrecord></medicalrecord><contactphone>18931477526</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 10:38:03
记录内容：select * from  pat_master_index where id_no='130227200501160026' and name='何南春' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/1/16 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:38:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '消化内科李颖飞' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:38: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('2025/11/02','YYYY/MM/DD'),9871,'消化内科李颖飞','下午','1','100492633','何南春','HE NAN CHUN ','女','20','一般人员','自费','','普通号','1','0302','LIYF','1',to_date('2025/11/02 10:38:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511029871','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 10:38:04
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),9871,'消化内科李颖飞','下午','1','100492633','何南春','HE NAN CHUN ','女','20','一般人员','自费','','普通号','1','0302','LIYF','1',to_date('2025/11/02 10:38:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511029871','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科李颖飞' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),9871,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '消化内科李颖飞' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511029871</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511029871</pinkey><ordertime>2025-11-02 10:38:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 10:44:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13930683072</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/6 0:00:00_上午_心血管内科谭琛</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>622701194210190819</patientidcard><patientname>王向贤</patientname><patientsex>男</patientsex><patientbirthday>1942-10-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13930683072</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 10:44:15
记录内容：select * from  pat_master_index where id_no='622701194210190819' and name='王向贤' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1942/10/19 0:00:0083
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:44:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:44:15
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/06','YYYY/MM/DD'),90,'心血管内科谭琛','上午','3','10642362','王向贤','WANG XIANG XIAN','男','83','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 10:44:19','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511060090','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 10:44:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/06','YYYY/MM/DD'),90,'心血管内科谭琛','上午','3','10642362','王向贤','WANG XIANG XIAN','男','83','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 10:44:19','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511060090','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/06','YYYY/MM/DD'),90,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/06','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>2025110690</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>2025110690</pinkey><ordertime>2025-11-02 10:44:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 10:52:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13303915222</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_神经内科李宛宸</scheduleid><parttimeid>16:30-17:00</parttimeid><certtypeno>1</certtypeno><patientidcard>410882200306018635</patientidcard><patientname>陈李文</patientname><patientsex>男</patientsex><patientbirthday>2003-06-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13303915222</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 10:52:21
记录内容：select * from  pat_master_index where id_no='410882200306018635' and name='陈李文' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2003/6/1 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:52:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '神经内科李宛宸' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:52:21
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),296,'神经内科李宛宸','下午','1','100445723','陈李文','CHEN LI WEN ','男','22','一般人员','自费','','普通号','1','0303','LIWANCHEN','1',to_date('2025/11/02 10:52:24','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511020296','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 10:52:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),296,'神经内科李宛宸','下午','1','100445723','陈李文','CHEN LI WEN ','男','22','一般人员','自费','','普通号','1','0303','LIWANCHEN','1',to_date('2025/11/02 10:52:24','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511020296','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科李宛宸' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),296,'16:30-17:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '神经内科李宛宸' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>20251102296</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>20251102296</pinkey><ordertime>2025-11-02 10:52:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 10:54:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15732696900</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_白天_病理科王跃</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028198807080017</patientidcard><patientname>李岩杰</patientname><patientsex>男</patientsex><patientbirthday>1988-07-08</patientbirthday><medicalrecord></medicalrecord><contactphone>15732696900</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 10:54:33
记录内容：select * from  pat_master_index where id_no='131028198807080017' and name='李岩杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/7/8 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:54:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '病理科王跃' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 10:54:33
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),361,'病理科王跃','白天','1','100517604','李岩杰','LI YAN JIE ','男','37','一般人员','自费','','副主任号','1','0346','WANGYUE','1',to_date('2025/11/02 10:54:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511030361','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 10:54:33
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),361,'病理科王跃','白天','1','100517604','李岩杰','LI YAN JIE ','男','37','一般人员','自费','','副主任号','1','0346','WANGYUE','1',to_date('2025/11/02 10:54:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511030361','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '病理科王跃' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),361,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '病理科王跃' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>20251103361</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>20251103361</pinkey><ordertime>2025-11-02 10:54:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 11:39:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15611111444</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_下午_心理咨询张晶晶</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028198311252014</patientidcard><patientname>杨宁</patientname><patientsex>男</patientsex><patientbirthday>1983-11-25</patientbirthday><medicalrecord></medicalrecord><contactphone>15611111444</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 11:39:11
记录内容：select * from  pat_master_index where id_no='131028198311252014' and name='杨宁' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1983/11/25 0:00:0042
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 11:39:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 11:39:11
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),1308,'心理咨询张晶晶','下午','1','10065305','杨宁','YANG NING','男','42','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/02 11:39:14','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511031308','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 11:39:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),1308,'心理咨询张晶晶','下午','1','10065305','杨宁','YANG NING','男','42','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/02 11:39:14','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511031308','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),1308,'15:30-16:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511031308</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511031308</pinkey><ordertime>2025-11-02 11:39:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 11:44:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13931417066</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_儿科刘婕</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13082620220817001x</patientidcard><patientname>庞云骞</patientname><patientsex>男</patientsex><patientbirthday>2022-08-17</patientbirthday><medicalrecord></medicalrecord><contactphone>13931417066</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 11:44:09
记录内容：select * from  pat_master_index where id_no='13082620220817001x' and name='庞云骞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2022/8/17 0:00:003
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 11:44:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 11:44:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),1393,'儿科刘婕','下午','2','100517609','庞云骞','PANG YUN  ','男','3','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/02 11:44:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511021393','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 11:44:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),1393,'儿科刘婕','下午','2','100517609','庞云骞','PANG YUN  ','男','3','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/02 11:44:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511021393','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),1393,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511021393</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511021393</pinkey><ordertime>2025-11-02 11:44:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 12:40:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17374447543</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/4 0:00:00_白天_妇科陈海霞</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>23210119930412502X</patientidcard><patientname>张佳</patientname><patientsex>女</patientsex><patientbirthday>1993-04-12</patientbirthday><medicalrecord></medicalrecord><contactphone>17374447543</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 12:40:45
记录内容：select * from  pat_master_index where id_no='23210119930412502X' and name='张佳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/4/12 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 12:40:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 12:40:45
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),1717,'妇科陈海霞','白天','4','100517651','张佳','ZHANG JIA ','女','32','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2025/11/02 12:40:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511041717','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 12:40:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),1717,'妇科陈海霞','白天','4','100517651','张佳','ZHANG JIA ','女','32','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2025/11/02 12:40:48','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511041717','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/04','YYYY/MM/DD'),1717,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511041717</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511041717</pinkey><ordertime>2025-11-02 12:40:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 12:49:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17611222297</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_血管外科侯国峰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232326197008073244</patientidcard><patientname>纪青艳</patientname><patientsex>女</patientsex><patientbirthday>1970-08-07</patientbirthday><medicalrecord></medicalrecord><contactphone>17611222297</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 12:49:15
记录内容：select * from  pat_master_index where id_no='232326197008073244' and name='纪青艳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/8/7 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 12:49:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '血管外科侯国峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 12:49:15
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),1737,'血管外科侯国峰','上午','4','100455136','纪青艳','JI QING YAN ','女','55','一般人员','自费','','副主任号','1','0394','HOUGF','1',to_date('2025/11/02 12:49:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511031737','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 12:49:15
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),1737,'血管外科侯国峰','上午','4','100455136','纪青艳','JI QING YAN ','女','55','一般人员','自费','','副主任号','1','0394','HOUGF','1',to_date('2025/11/02 12:49:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511031737','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '血管外科侯国峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),1737,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '血管外科侯国峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511031737</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511031737</pinkey><ordertime>2025-11-02 12:49:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 13:08:26
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18644007759</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_儿科刘婕</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>231224202012170041</patientidcard><patientname>魏铭悦</patientname><patientsex>女</patientsex><patientbirthday>2020-12-17</patientbirthday><medicalrecord></medicalrecord><contactphone>18644007759</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 13:08:26
记录内容：select * from  pat_master_index where id_no='231224202012170041' and name='魏铭悦' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2020/12/17 0:00:005
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:08:26
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:08:26
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),1866,'儿科刘婕','下午','8','100517608','魏铭悦','WEI MING YUE ','女','5','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/02 13:08:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511021866','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','49') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 13:08:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),1866,'儿科刘婕','下午','8','100517608','魏铭悦','WEI MING YUE ','女','5','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2025/11/02 13:08:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511021866','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','49') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),1866,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511021866</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511021866</pinkey><ordertime>2025-11-02 13:08:26</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 13:40:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18231619136</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_皮肤科杨维玲</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821193909218408</patientidcard><patientname>左瑞兰</patientname><patientsex>女</patientsex><patientbirthday>1939-09-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18231619136</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 13:40:36
记录内容：select * from  pat_master_index where id_no='132821193909218408' and name='左瑞兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1939/9/21 0:00:0086
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:40:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:40:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2354,'皮肤科杨维玲','下午','4','10558628','左瑞兰','','女','86','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/11/02 13:40:39','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511022354','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 13:40:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2354,'皮肤科杨维玲','下午','4','10558628','左瑞兰','','女','86','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/11/02 13:40:39','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511022354','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2354,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511022354</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511022354</pinkey><ordertime>2025-11-02 13:40:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 13:54:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210524172</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_产科辛俊英</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131023199009270847</patientidcard><patientname>杨立平</patientname><patientsex>女</patientsex><patientbirthday>1990-09-27</patientbirthday><medicalrecord></medicalrecord><contactphone>15210524172</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 13:54:04
记录内容：select * from  pat_master_index where id_no='131023199009270847' and name='杨立平' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/9/27 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:54:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:54:04
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2571,'产科辛俊英','下午','6','Z00372330','杨立平','','女','35','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/11/02 13:54:07','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511022571','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','36') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 13:54:04
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2571,'产科辛俊英','下午','6','Z00372330','杨立平','','女','35','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/11/02 13:54:07','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511022571','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','36') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2571,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511022571</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511022571</pinkey><ordertime>2025-11-02 13:54:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 13:58:51
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17374447543</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/4 0:00:00_白天_妇科王兰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23210119930412502X</patientidcard><patientname>张佳</patientname><patientsex>女</patientsex><patientbirthday>1993-04-12</patientbirthday><medicalrecord></medicalrecord><contactphone>17374447543</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 13:58:51
记录内容：select * from  pat_master_index where id_no='23210119930412502X' and name='张佳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/4/12 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:58:51
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 13:58:51
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),2667,'妇科王兰','白天','3','100517651','张佳','ZHANG JIA ','女','32','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/11/02 13:58:53','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511042667','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 13:58:51
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),2667,'妇科王兰','白天','3','100517651','张佳','ZHANG JIA ','女','32','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/11/02 13:58:53','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511042667','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/04','YYYY/MM/DD'),2667,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511042667</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511042667</pinkey><ordertime>2025-11-02 13:58:51</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 14:16:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17330138213</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_中医科潘嘉玲</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130731200408155822</patientidcard><patientname>王月洁</patientname><patientsex>女</patientsex><patientbirthday>2004-08-15</patientbirthday><medicalrecord></medicalrecord><contactphone>17330138213</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 14:16:29
记录内容：select * from  pat_master_index where id_no='130731200408155822' and name='王月洁' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/8/15 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 14:16:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '中医科潘嘉玲' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 14:16:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2966,'中医科潘嘉玲','下午','4','Z00514365','王月洁','','女','21','一般人员','自费','','中普通号','1','0301','PANJL','1',to_date('2025/11/02 14:16:31','yyyy/mm/dd hh24:mi:ss'),'0','25','0.00','25','202511022966','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','19') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 14:16:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2966,'中医科潘嘉玲','下午','4','Z00514365','王月洁','','女','21','一般人员','自费','','中普通号','1','0301','PANJL','1',to_date('2025/11/02 14:16:31','yyyy/mm/dd hh24:mi:ss'),'0','25','0.00','25','202511022966','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','19') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医科潘嘉玲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),2966,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '中医科潘嘉玲' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511022966</orderid><reservefee>0.00</reservefee><clinicfee>25</clinicfee><registrationfee>0</registrationfee><pinkey>202511022966</pinkey><ordertime>2025-11-02 14:16:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 14:29:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15103498380</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_下午_呼吸内科芮萌</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>140624200105280020</patientidcard><patientname>史嘉慧</patientname><patientsex>女</patientsex><patientbirthday>2001-05-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15103498380</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 14:29:16
记录内容：select * from  pat_master_index where id_no='140624200105280020' and name='史嘉慧' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/5/28 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 14:29:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '呼吸内科芮萌' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 14:29:16
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),3150,'呼吸内科芮萌','下午','4','100517671','史嘉慧','SHI JIA HUI ','女','24','一般人员','自费','','副主任号','1','0317','RM','1',to_date('2025/11/02 14:29:19','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511033150','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 14:29:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),3150,'呼吸内科芮萌','下午','4','100517671','史嘉慧','SHI JIA HUI ','女','24','一般人员','自费','','副主任号','1','0317','RM','1',to_date('2025/11/02 14:29:19','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511033150','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科芮萌' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),3150,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '呼吸内科芮萌' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511033150</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511033150</pinkey><ordertime>2025-11-02 14:29:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 15:22:10
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18631601753</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/2 0:00:00_下午_心理咨询失眠李文</scheduleid><parttimeid>15:30-16:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198711227123</patientidcard><patientname>安东芳</patientname><patientsex>女</patientsex><patientbirthday>1987-11-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18631601753</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 15:22:10
记录内容：select * from  pat_master_index where id_no='131082198711227123' and name='安东芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/11/22 0:00:0038
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 15:22:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 15:22:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),4015,'心理咨询失眠李文','下午','9','100517684','安东芳','AN DONG FANG ','女','38','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/11/02 15:22:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511024015','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','24') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 15:22:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/02','YYYY/MM/DD'),4015,'心理咨询失眠李文','下午','9','100517684','安东芳','AN DONG FANG ','女','38','一般人员','自费','','副主任号','1','0360','CYLW','1',to_date('2025/11/02 15:22:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511024015','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','24') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/02', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询失眠李文' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/02','YYYY/MM/DD'),4015,'15:30-16:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/02','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511024015</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511024015</pinkey><ordertime>2025-11-02 15:22:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 15:43:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13164220399</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_眼科张仲臣</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130684196808132070</patientidcard><patientname>李云文</patientname><patientsex>男</patientsex><patientbirthday>1968-08-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13164220399</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 15:43:53
记录内容：select * from  pat_master_index where id_no='130684196808132070' and name='李云文' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/8/13 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 15:43:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '眼科张仲臣' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 15:43:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),4342,'眼科张仲臣','上午','12','DP027768','李云文','LI YUN WEN','男','57','一般人员','自费','','知名专家','1','0327','ZHANGZC','1',to_date('2025/11/02 15:43:54','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511034342','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 15:43:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),4342,'眼科张仲臣','上午','12','DP027768','李云文','LI YUN WEN','男','57','一般人员','自费','','知名专家','1','0327','ZHANGZC','1',to_date('2025/11/02 15:43:54','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511034342','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科张仲臣' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),4342,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '眼科张仲臣' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511034342</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511034342</pinkey><ordertime>2025-11-02 15:43:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 17:28:10
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13323268305</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_心慌门诊谭琛</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198607035527</patientidcard><patientname>李银峰</patientname><patientsex>女</patientsex><patientbirthday>1986-07-03</patientbirthday><medicalrecord></medicalrecord><contactphone>13323268305</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 17:28:11
记录内容：select * from  pat_master_index where id_no='131082198607035527' and name='李银峰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/7/3 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 17:28:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 17:28:11
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5391,'心慌门诊谭琛','上午','1','00388501','李银峰','LI YIN FENG','女','39','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 17:28:12','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511035391','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 17:28:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5391,'心慌门诊谭琛','上午','1','00388501','李银峰','LI YIN FENG','女','39','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 17:28:12','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511035391','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心慌门诊谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5391,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035391</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511035391</pinkey><ordertime>2025-11-02 17:28:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 17:30:23
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18031626831</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/5 0:00:00_白天_妇科李二雷</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622824199204080464</patientidcard><patientname>高海燕</patientname><patientsex>女</patientsex><patientbirthday>1992-04-08</patientbirthday><medicalrecord></medicalrecord><contactphone>18031626831</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 17:30:23
记录内容：select * from  pat_master_index where id_no='622824199204080464' and name='高海燕' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/4/8 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 17:30:23
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/05','yyyy/mm/dd')
                    and clinic_label = '妇科李二雷' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 17:30:23
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/05','YYYY/MM/DD'),5397,'妇科李二雷','白天','1','Z00498071','高海燕','','女','33','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2025/11/02 17:30:25','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511055397','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 17:30:23
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/05','YYYY/MM/DD'),5397,'妇科李二雷','白天','1','Z00498071','高海燕','','女','33','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2025/11/02 17:30:25','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511055397','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科李二雷' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/05','YYYY/MM/DD'),5397,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/05','yyyy/mm/dd')
                    and clinic_label = '妇科李二雷' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511055397</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511055397</pinkey><ordertime>2025-11-02 17:30:23</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 17:58:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15175683617</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/7 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198912181088</patientidcard><patientname>张兵</patientname><patientsex>女</patientsex><patientbirthday>1989-12-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15175683617</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 17:58:08
记录内容：select * from  pat_master_index where id_no='131082198912181088' and name='张兵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/12/18 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 17:58:08
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 17:58:08
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/07','YYYY/MM/DD'),5450,'骨科刘兴超','上午','1','10567216','张兵','','女','36','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/11/02 17:58:09','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511075450','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 17:58:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/07','YYYY/MM/DD'),5450,'骨科刘兴超','上午','1','10567216','张兵','','女','36','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/11/02 17:58:09','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511075450','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/07','YYYY/MM/DD'),5450,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/07','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511075450</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511075450</pinkey><ordertime>2025-11-02 17:58:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 18:24:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18633785570</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/4 0:00:00_上午_颈肩腰腿痛刘海峰</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082196511051048</patientidcard><patientname>王同</patientname><patientsex>女</patientsex><patientbirthday>1965-11-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18633785570</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 18:24:22
记录内容：select * from  pat_master_index where id_no='131082196511051048' and name='王同' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/11/5 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 18:24:22
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 18:24:22
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5487,'颈肩腰腿痛刘海峰','上午','2','10564358','王同','','女','60','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2025/11/02 18:24:23','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511045487','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 18:24:22
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5487,'颈肩腰腿痛刘海峰','上午','2','10564358','王同','','女','60','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2025/11/02 18:24:23','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511045487','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '颈肩腰腿痛刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5487,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511045487</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511045487</pinkey><ordertime>2025-11-02 18:24:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 18:53:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15613635621</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_肛肠门诊赵磊</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028197109184914</patientidcard><patientname>杨思建</patientname><patientsex>男</patientsex><patientbirthday>1971-09-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15613635621</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 18:53:50
记录内容：select * from  pat_master_index where id_no='131028197109184914' and name='杨思建' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/9/18 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 18:53:50
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '肛肠门诊赵磊' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 18:53:50
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5529,'肛肠门诊赵磊','上午','5','100517743','杨思建','YANG SI JIAN ','男','54','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2025/11/02 18:53:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035529','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 18:53:50
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5529,'肛肠门诊赵磊','上午','5','100517743','杨思建','YANG SI JIAN ','男','54','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2025/11/02 18:53:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035529','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '肛肠门诊赵磊' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5529,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '肛肠门诊赵磊' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035529</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511035529</pinkey><ordertime>2025-11-02 18:53:50</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 19:35:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15631695691</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_心慌门诊谭琛</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130435197707252715</patientidcard><patientname>杨智山</patientname><patientsex>男</patientsex><patientbirthday>1977-07-25</patientbirthday><medicalrecord></medicalrecord><contactphone>15631695691</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 19:35:03
记录内容：select * from  pat_master_index where id_no='130435197707252715' and name='杨智山' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1977/7/25 0:00:0048
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 19:35:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 19:35: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('2025/11/03','YYYY/MM/DD'),5619,'心慌门诊谭琛','上午','2','100457479','杨智山','YANG ZHI SHAN ','男','48','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 19:35:04','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511035619','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 19:35: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('2025/11/03','YYYY/MM/DD'),5619,'心慌门诊谭琛','上午','2','100457479','杨智山','YANG ZHI SHAN ','男','48','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 19:35:04','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511035619','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心慌门诊谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5619,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035619</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511035619</pinkey><ordertime>2025-11-02 19:35:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 19:51:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18911309893</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13108220240605881X</patientidcard><patientname>吴珺一</patientname><patientsex>男</patientsex><patientbirthday>2024-06-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18911309893</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 19:51:47
记录内容：select * from  pat_master_index where id_no='13108220240605881X' and name='吴珺一' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2024/6/5 0:00:001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 19:51:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 19:51:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5648,'儿科陈云平','上午','1','10703125','吴珺一','','男','1','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/11/02 19:51:48','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511035648','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 19:51:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5648,'儿科陈云平','上午','1','10703125','吴珺一','','男','1','一般人员','自费','','主任号','1','0304','CYP11','1',to_date('2025/11/02 19:51:48','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202511035648','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5648,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035648</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202511035648</pinkey><ordertime>2025-11-02 19:51:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 20:01:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18601278217</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_心血管内科赵京涛</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132902195511050460</patientidcard><patientname>张俊梅</patientname><patientsex>女</patientsex><patientbirthday>1955-11-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18601278217</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 20:01:36
记录内容：select * from  pat_master_index where id_no='132902195511050460' and name='张俊梅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/11/5 0:00:0070
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:01:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心血管内科赵京涛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:01:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5675,'心血管内科赵京涛','上午','3','10584163','张俊梅','ZHANG JUN MEI','女','70','一般人员','自费','','副主任号','1','0359','ZJT','1',to_date('2025/11/02 20:01:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035675','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 20:01: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('2025/11/03','YYYY/MM/DD'),5675,'心血管内科赵京涛','上午','3','10584163','张俊梅','ZHANG JUN MEI','女','70','一般人员','自费','','副主任号','1','0359','ZJT','1',to_date('2025/11/02 20:01:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035675','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科赵京涛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5675,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心血管内科赵京涛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035675</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511035675</pinkey><ordertime>2025-11-02 20:01:36</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 20:46:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18732667925</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_心血管内科郭晓光</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082197912210569</patientidcard><patientname>陈苹</patientname><patientsex>女</patientsex><patientbirthday>1979-12-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18732667925</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 20:46:05
记录内容：select * from  pat_master_index where id_no='131082197912210569' and name='陈苹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/12/21 0:00:0046
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:46:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心血管内科郭晓光' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:46:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5774,'心血管内科郭晓光','上午','3','Z00064793','陈苹','','女','46','一般人员','自费','','副主任号','1','0359','GXG','1',to_date('2025/11/02 20:46:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035774','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 20:46:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5774,'心血管内科郭晓光','上午','3','Z00064793','陈苹','','女','46','一般人员','自费','','副主任号','1','0359','GXG','1',to_date('2025/11/02 20:46:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035774','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科郭晓光' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5774,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心血管内科郭晓光' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035774</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511035774</pinkey><ordertime>2025-11-02 20:46:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 20:57:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18331651500</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_内分泌科张金环普</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131022200508081126</patientidcard><patientname>王烨</patientname><patientsex>女</patientsex><patientbirthday>2005-08-08</patientbirthday><medicalrecord></medicalrecord><contactphone>18331651500</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 20:57:13
记录内容：select * from  pat_master_index where id_no='131022200508081126' and name='王烨' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/8/8 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:57:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:57:13
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5797,'内分泌科张金环普','上午','1','100517757','王烨','WANG  ','女','20','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/11/02 20:57:13','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035797','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 20:57:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5797,'内分泌科张金环普','上午','1','100517757','王烨','WANG  ','女','20','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2025/11/02 20:57:13','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035797','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5797,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035797</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511035797</pinkey><ordertime>2025-11-02 20:57:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 20:59:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13671185171</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/4 0:00:00_下午_消化内科王玲</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152104199409064111</patientidcard><patientname>安万夫</patientname><patientsex>男</patientsex><patientbirthday>1994-09-06</patientbirthday><medicalrecord></medicalrecord><contactphone>13671185171</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 20:59:42
记录内容：select * from  pat_master_index where id_no='152104199409064111' and name='安万夫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/9/6 0:00:0031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:59:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '消化内科王玲' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 20:59:42
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5805,'消化内科王玲','下午','1','100517752','安万夫','AN WAN FU ','男','31','一般人员','自费','','副主任号','1','0302','WL01','1',to_date('2025/11/02 20:59:42','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511045805','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 20:59:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5805,'消化内科王玲','下午','1','100517752','安万夫','AN WAN FU ','男','31','一般人员','自费','','副主任号','1','0302','WL01','1',to_date('2025/11/02 20:59:42','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511045805','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科王玲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5805,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '消化内科王玲' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511045805</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511045805</pinkey><ordertime>2025-11-02 20:59:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 21:23:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18713639374</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/10 0:00:00_上午_神经内科王卫</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130929198408234722</patientidcard><patientname>吕艳</patientname><patientsex>女</patientsex><patientbirthday>1984-08-23</patientbirthday><medicalrecord></medicalrecord><contactphone>18713639374</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 21:23:13
记录内容：select * from  pat_master_index where id_no='130929198408234722' and name='吕艳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1984/8/23 0:00:0041
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:23:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:23:13
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/10','YYYY/MM/DD'),5833,'神经内科王卫','上午','2','100502523','吕艳','LV YAN ','女','41','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/11/02 21:23:13','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511105833','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 21:23:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/10','YYYY/MM/DD'),5833,'神经内科王卫','上午','2','100502523','吕艳','LV YAN ','女','41','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/11/02 21:23:13','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511105833','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/10', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科王卫' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/10','YYYY/MM/DD'),5833,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/10','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511105833</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511105833</pinkey><ordertime>2025-11-02 21:23:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 21:40:10
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13903163258</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_心慌门诊谭琛</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082196807294612</patientidcard><patientname>田爱民</patientname><patientsex>男</patientsex><patientbirthday>1968-07-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13903163258</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 21:40:10
记录内容：select * from  pat_master_index where id_no='131082196807294612' and name='田爱民' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/7/29 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:40:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:40:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5850,'心慌门诊谭琛','上午','3','10729796','田爱民','TIAN AI MIN','男','57','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 21:40:11','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511035850','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 21:40:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5850,'心慌门诊谭琛','上午','3','10729796','田爱民','TIAN AI MIN','男','57','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/11/02 21:40:11','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202511035850','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心慌门诊谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5850,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035850</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202511035850</pinkey><ordertime>2025-11-02 21:40:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 21:54:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13383252291</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/4 0:00:00_白天_妇科王兰</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>120221200408290109</patientidcard><patientname>马红杰</patientname><patientsex>女</patientsex><patientbirthday>2004-08-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13383252291</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 21:54:28
记录内容：select * from  pat_master_index where id_no='120221200408290109' and name='马红杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/8/29 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:54:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:54:28
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5871,'妇科王兰','白天','4','100517763','马红杰','MA HONG JIE ','女','21','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/11/02 21:54:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511045871','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 21:54:28
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5871,'妇科王兰','白天','4','100517763','马红杰','MA HONG JIE ','女','21','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/11/02 21:54:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511045871','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/04','YYYY/MM/DD'),5871,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/04','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202511045871</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511045871</pinkey><ordertime>2025-11-02 21:54:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 21:56:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18310302580</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_心理咨询张晶晶</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150424199810073663</patientidcard><patientname>贾伟娜</patientname><patientsex>女</patientsex><patientbirthday>1998-10-07</patientbirthday><medicalrecord></medicalrecord><contactphone>18310302580</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 21:56:44
记录内容：select * from  pat_master_index where id_no='150424199810073663' and name='贾伟娜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1998/10/7 0:00:0027
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:56:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 21:56:44
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5873,'心理咨询张晶晶','上午','3','Z00505641','贾伟娜','','女','27','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/02 21:56:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035873','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 21:56:44
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5873,'心理咨询张晶晶','上午','3','Z00505641','贾伟娜','','女','27','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/02 21:56:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035873','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5873,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035873</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511035873</pinkey><ordertime>2025-11-02 21:56:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 22:37:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15230603988</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_下午_心理咨询张晶晶</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199402172944</patientidcard><patientname>杨涛</patientname><patientsex>女</patientsex><patientbirthday>1994-02-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15230603988</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 22:37:46
记录内容：select * from  pat_master_index where id_no='131082199402172944' and name='杨涛' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/2/17 0:00:0031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 22:37:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 22:37:46
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5945,'心理咨询张晶晶','下午','2','100231262','杨涛','YANG TAO ','女','31','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/02 22:37:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035945','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 22:37:46
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5945,'心理咨询张晶晶','下午','2','100231262','杨涛','YANG TAO ','女','31','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2025/11/02 22:37:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035945','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5945,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511035945</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511035945</pinkey><ordertime>2025-11-02 22:37:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 22:54:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13161535618</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_消化内科张然</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>412727198908170716</patientidcard><patientname>朱想想</patientname><patientsex>男</patientsex><patientbirthday>1989-08-17</patientbirthday><medicalrecord></medicalrecord><contactphone>13161535618</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 22:54:58
记录内容：select * from  pat_master_index where id_no='412727198908170716' and name='朱想想' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/8/17 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 22:54:58
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '消化内科张然' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 22:54:58
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5946,'消化内科张然','上午','2','100374728','朱想想','ZHU XIANG XIANG ','男','36','一般人员','自费','','普通号','1','0302','ZHANGR2','1',to_date('2025/11/02 22:54:58','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035946','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 22:54:58
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5946,'消化内科张然','上午','2','100374728','朱想想','ZHU XIANG XIANG ','男','36','一般人员','自费','','普通号','1','0302','ZHANGR2','1',to_date('2025/11/02 22:54:58','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202511035946','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科张然' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5946,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '消化内科张然' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035946</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202511035946</pinkey><ordertime>2025-11-02 22:54:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 23:45:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15933360477</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_上午_中医骨伤祖亚利</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>411525200403017834</patientidcard><patientname>邵传波</patientname><patientsex>男</patientsex><patientbirthday>2004-03-01</patientbirthday><medicalrecord></medicalrecord><contactphone>15933360477</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 23:45:17
记录内容：select * from  pat_master_index where id_no='411525200403017834' and name='邵传波' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/3/1 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 23:45:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '中医骨伤祖亚利' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 23:45:17
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5973,'中医骨伤祖亚利','上午','1','100250212','邵传波','SHAO CHUAN BO ','男','21','一般人员','自费','','中普通号','1','0301','ZUYL','1',to_date('2025/11/02 23:45:17','yyyy/mm/dd hh24:mi:ss'),'0','25','0.00','25','202511035973','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 23:45:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5973,'中医骨伤祖亚利','上午','1','100250212','邵传波','SHAO CHUAN BO ','男','21','一般人员','自费','','中普通号','1','0301','ZUYL','1',to_date('2025/11/02 23:45:17','yyyy/mm/dd hh24:mi:ss'),'0','25','0.00','25','202511035973','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医骨伤祖亚利' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5973,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '中医骨伤祖亚利' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202511035973</orderid><reservefee>0.00</reservefee><clinicfee>25</clinicfee><registrationfee>0</registrationfee><pinkey>202511035973</pinkey><ordertime>2025-11-02 23:45:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-11-02 23:47:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18831091816</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/11/3 0:00:00_下午_呼吸内科高立静</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130433200412312313</patientidcard><patientname>陈宏恩</patientname><patientsex>男</patientsex><patientbirthday>2004-12-31</patientbirthday><medicalrecord></medicalrecord><contactphone>18831091816</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-11-02 23:47:18
记录内容：select * from  pat_master_index where id_no='130433200412312313' and name='陈宏恩' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/12/31 0:00:0021
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 23:47:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-11-02 23:47:18
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5976,'呼吸内科高立静','下午','2','100515968','陈宏恩','CHEN HONG EN ','男','21','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/11/02 23:47:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035976','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-11-02 23:47:19
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5976,'呼吸内科高立静','下午','2','100515968','陈宏恩','CHEN HONG EN ','男','21','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/11/02 23:47:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202511035976','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/11/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/11/03','YYYY/MM/DD'),5976,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/11/03','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202511035976</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202511035976</pinkey><ordertime>2025-11-02 23:47:19</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆