◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 06:53:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13311567511</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_白天_胃肠肿瘤钱海龙</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370811197911030031</patientidcard><patientname>彭兆前</patientname><patientsex>男</patientsex><patientbirthday>1979-11-03</patientbirthday><medicalrecord></medicalrecord><contactphone>13311567511</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 06:53:00
记录内容：select * from  pat_master_index where id_no='370811197911030031' and name='彭兆前' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/11/3 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 06:53:00
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '胃肠肿瘤钱海龙' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 06:53: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('2026/02/22','YYYY/MM/DD'),4759,'胃肠肿瘤钱海龙','白天','1','10456134','彭兆前','','男','47','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2026/02/21 06:53:09','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602224759','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 06:53: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('2026/02/22','YYYY/MM/DD'),4759,'胃肠肿瘤钱海龙','白天','1','10456134','彭兆前','','男','47','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2026/02/21 06:53:09','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602224759','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '胃肠肿瘤钱海龙' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),4759,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '胃肠肿瘤钱海龙' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602224759</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602224759</pinkey><ordertime>2026-02-21 06:53:00</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 07:38:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15810862528</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/24 0:00:00_上午_颈肩腰腿痛刘海峰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>612323195401240849</patientidcard><patientname>田水珍</patientname><patientsex>女</patientsex><patientbirthday>1954-01-24</patientbirthday><medicalrecord></medicalrecord><contactphone>15810862528</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 07:38:37
记录内容：select * from  pat_master_index where id_no='612323195401240849' and name='田水珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/1/24 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:38:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:38:37
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/24','YYYY/MM/DD'),4791,'颈肩腰腿痛刘海峰','上午','2','100538861','田水珍','TIAN SHUI ZHEN ','女','72','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/21 07:38:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602244791','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 07:38:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/24','YYYY/MM/DD'),4791,'颈肩腰腿痛刘海峰','上午','2','100538861','田水珍','TIAN SHUI ZHEN ','女','72','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/21 07:38:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602244791','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/24', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '颈肩腰腿痛刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/24','YYYY/MM/DD'),4791,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602244791</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602244791</pinkey><ordertime>2026-02-21 07:38:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 07:44:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13700349815</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_泌尿外科杨云波</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082196903170767</patientidcard><patientname>蒋晓欣</patientname><patientsex>女</patientsex><patientbirthday>1969-03-17</patientbirthday><medicalrecord></medicalrecord><contactphone>13700349815</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 07:44:38
记录内容：select * from  pat_master_index where id_no='131082196903170767' and name='蒋晓欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/3/17 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:44:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:44:38
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4808,'泌尿外科杨云波','上午','8','00381558','蒋晓欣','JIANG XIAO XIN','女','57','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/02/21 07:44:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602214808','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 07:44:38
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4808,'泌尿外科杨云波','上午','8','00381558','蒋晓欣','JIANG XIAO XIN','女','57','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/02/21 07:44:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602214808','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科杨云波' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4808,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602214808</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602214808</pinkey><ordertime>2026-02-21 07:44:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 07:49:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13644026552</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>210114202601140614</patientidcard><patientname>潘承泽</patientname><patientsex>男</patientsex><patientbirthday>2026-01-14</patientbirthday><medicalrecord></medicalrecord><contactphone>13644026552</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 07:49:12
记录内容：select * from  pat_master_index where id_no='210114202601140614' and name='潘承泽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2026/1/14 0:00:000
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 07:49:12
记录内容：select * from  pat_master_index where id_no='210114202601140614' and name='潘承泽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc实体获取的生日2026/1/14 0:00:000
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:49:12
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:49:12
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4821,'儿科刘婕','上午','1','100538862','潘承泽','PAN CHENG ZE ','男','0','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/02/21 07:49:21','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602214821','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 07:49:12
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4821,'儿科刘婕','上午','1','100538862','潘承泽','PAN CHENG ZE ','男','0','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/02/21 07:49:21','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602214821','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4821,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602214821</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602214821</pinkey><ordertime>2026-02-21 07:49:12</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 07:56:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19993817974</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_消化内科胡珉 普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>620502196808146858</patientidcard><patientname>汪虽新</patientname><patientsex>男</patientsex><patientbirthday>1968-08-14</patientbirthday><medicalrecord></medicalrecord><contactphone>19993817974</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 07:56:06
记录内容：select * from  pat_master_index where id_no='620502196808146858' and name='汪虽新' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/8/14 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:56:06
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉 普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 07:56:06
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4851,'消化内科胡珉 普','上午','4','100538776','汪虽新','WANG SUI XIN ','男','58','一般人员','自费','','普通号','1','0302','HUMIN01','1',to_date('2026/02/21 07:56:15','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602214851','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 07:56: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('2026/02/21','YYYY/MM/DD'),4851,'消化内科胡珉 普','上午','4','100538776','汪虽新','WANG SUI XIN ','男','58','一般人员','自费','','普通号','1','0302','HUMIN01','1',to_date('2026/02/21 07:56:15','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602214851','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科胡珉 普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),4851,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '消化内科胡珉 普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602214851</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602214851</pinkey><ordertime>2026-02-21 07:56:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 08:23:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19131667377</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/24 0:00:00_上午_内分泌科姚合斌</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210423196604162012</patientidcard><patientname>祝志山</patientname><patientsex>男</patientsex><patientbirthday>1966-04-16</patientbirthday><medicalrecord></medicalrecord><contactphone>19131667377</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 08:23:38
记录内容：select * from  pat_master_index where id_no='210423196604162012' and name='祝志山' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1966/4/16 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:23:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '内分泌科姚合斌' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:23:38
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/24','YYYY/MM/DD'),5330,'内分泌科姚合斌','上午','1','100538691','祝志山','ZHU ZHI SHAN ','男','60','一般人员','自费','','知名专家','1','0315','YHB','1',to_date('2026/02/21 08:23:47','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602245330','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 08:23:38
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/24','YYYY/MM/DD'),5330,'内分泌科姚合斌','上午','1','100538691','祝志山','ZHU ZHI SHAN ','男','60','一般人员','自费','','知名专家','1','0315','YHB','1',to_date('2026/02/21 08:23:47','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602245330','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/24', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科姚合斌' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/24','YYYY/MM/DD'),5330,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '内分泌科姚合斌' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602245330</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602245330</pinkey><ordertime>2026-02-21 08:23:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 08:29:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18911466637</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13098120140714133X</patientidcard><patientname>赵明旭</patientname><patientsex>男</patientsex><patientbirthday>2014-07-14</patientbirthday><medicalrecord></medicalrecord><contactphone>18911466637</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 08:29:47
记录内容：select * from  pat_master_index where id_no='13098120140714133X' and name='赵明旭' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2014/7/14 0:00:0012
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:29:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:29:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5469,'儿科刘婕','上午','3','100538868','赵明旭','ZHAO MING XU ','男','12','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/02/21 08:29:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602215469','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 08:29:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5469,'儿科刘婕','上午','3','100538868','赵明旭','ZHAO MING XU ','男','12','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/02/21 08:29:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602215469','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5469,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602215469</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602215469</pinkey><ordertime>2026-02-21 08:29:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 08:30:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15030674213</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197807260028</patientidcard><patientname>海伶</patientname><patientsex>女</patientsex><patientbirthday>1978-07-26</patientbirthday><medicalrecord></medicalrecord><contactphone>15030674213</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 08:30:08
记录内容：select * from  pat_master_index where id_no='132822197807260028' and name='海伶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/7/26 0:00:0048
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:30:08
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:30: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('2026/02/21','YYYY/MM/DD'),5472,'骨科刘兴超','上午','12','10717658','海伶','HAI LING','女','48','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/21 08:30:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602215472','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 08:30: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('2026/02/21','YYYY/MM/DD'),5472,'骨科刘兴超','上午','12','10717658','海伶','HAI LING','女','48','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/21 08:30:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602215472','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5472,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602215472</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602215472</pinkey><ordertime>2026-02-21 08:30:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 08:42:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15243305222</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_心血管内安立敏普</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>13108219971224101X</patientidcard><patientname>李思成</patientname><patientsex>男</patientsex><patientbirthday>1997-12-24</patientbirthday><medicalrecord></medicalrecord><contactphone>15243305222</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-02-21 08:42:06
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/02/21','YYYY-MM-DD')
            AND CLINIC_LABEL='心血管内安立敏普' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='13108219971224101X' and name='李思成' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 08:42:06
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 08:46:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18932434988</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>43010319870525351X</patientidcard><patientname>王海军</patientname><patientsex>男</patientsex><patientbirthday>1987-05-25</patientbirthday><medicalrecord></medicalrecord><contactphone>18932434988</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-02-21 08:46:17
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/02/21','YYYY-MM-DD')
            AND CLINIC_LABEL='皮肤科常庆华' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='43010319870525351X' and name='王海军' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 08:46:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 08:50:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13359528888</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_呼吸内科王君 普</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230229199307085713</patientidcard><patientname>胡冠铭</patientname><patientsex>男</patientsex><patientbirthday>1993-07-08</patientbirthday><medicalrecord></medicalrecord><contactphone>13359528888</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 08:50:53
记录内容：select * from  pat_master_index where id_no='230229199307085713' and name='胡冠铭' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/7/8 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:50:54
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王君 普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 08:50:54
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5849,'呼吸内科王君 普','上午','7','10634041','胡冠铭','','男','33','一般人员','自费','','普通号','1','0317','WANGJ','1',to_date('2026/02/21 08:51:02','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602215849','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','8') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 08:50:54
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5849,'呼吸内科王君 普','上午','7','10634041','胡冠铭','','男','33','一般人员','自费','','普通号','1','0317','WANGJ','1',to_date('2026/02/21 08:51:02','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602215849','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','8') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王君 普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),5849,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王君 普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602215849</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602215849</pinkey><ordertime>2026-02-21 08:50:54</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 09:19:23
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13956338291</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_耳鼻喉科冯培习</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>34030320110224452X</patientidcard><patientname>李慕凝</patientname><patientsex>女</patientsex><patientbirthday>2011-02-24</patientbirthday><medicalrecord></medicalrecord><contactphone>13956338291</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 09:19:23
记录内容：select * from  pat_master_index where id_no='34030320110224452X' and name='李慕凝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2011/2/24 0:00:0015
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 09:19:23
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科冯培习' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 09:19: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('2026/02/21','YYYY/MM/DD'),6478,'耳鼻喉科冯培习','上午','12','100538873','李慕凝','LI MU NING ','女','15','一般人员','自费','','普通号','1','0306','FENGPX','1',to_date('2026/02/21 09:19:32','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602216478','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 09:19: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('2026/02/21','YYYY/MM/DD'),6478,'耳鼻喉科冯培习','上午','12','100538873','李慕凝','LI MU NING ','女','15','一般人员','自费','','普通号','1','0306','FENGPX','1',to_date('2026/02/21 09:19:32','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602216478','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','12') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科冯培习' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),6478,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科冯培习' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602216478</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602216478</pinkey><ordertime>2026-02-21 09:19:23</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 09:29:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18325365221</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_白天_妇科韩卫灵副主任</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>342623200002281461</patientidcard><patientname>贾芳琴</patientname><patientsex>女</patientsex><patientbirthday>2000-02-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18325365221</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 09:29:21
记录内容：select * from  pat_master_index where id_no='342623200002281461' and name='贾芳琴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/2/28 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 09:29:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 09:29: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('2026/02/21','YYYY/MM/DD'),6647,'妇科韩卫灵副主任','白天','16','Z00138629','贾芳琴','','女','26','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/21 09:29:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602216647','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','16') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 09:29:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),6647,'妇科韩卫灵副主任','白天','16','Z00138629','贾芳琴','','女','26','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/21 09:29:29','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602216647','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','16') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科韩卫灵副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),6647,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602216647</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602216647</pinkey><ordertime>2026-02-21 09:29:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 10:03:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13910812590</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082202512118820</patientidcard><patientname>王序安</patientname><patientsex>女</patientsex><patientbirthday>2025-12-11</patientbirthday><medicalrecord></medicalrecord><contactphone>13910812590</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-02-21 10:03:25
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/02/21','YYYY-MM-DD')
            AND CLINIC_LABEL='儿科刘婕' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='131082202512118820' and name='王序安' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 10:03:25
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 10:12:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13503161770</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_泌尿外科杨云波</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132822196106014911</patientidcard><patientname>王立民</patientname><patientsex>男</patientsex><patientbirthday>1961-06-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13503161770</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 10:12:42
记录内容：select * from  pat_master_index where id_no='132822196106014911' and name='王立民' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1961/6/1 0:00:0065
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:12:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:12:42
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),7541,'泌尿外科杨云波','上午','4','100538827','王立民','WANG LI MIN ','男','65','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/02/21 10:12:50','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602227541','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 10:12:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),7541,'泌尿外科杨云波','上午','4','100538827','王立民','WANG LI MIN ','男','65','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/02/21 10:12:50','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602227541','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科杨云波' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),7541,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602227541</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602227541</pinkey><ordertime>2026-02-21 10:12:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 10:25:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18296366989</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_白天_妇科韩卫灵副主任</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>362330198106225481</patientidcard><patientname>邵红娥</patientname><patientsex>女</patientsex><patientbirthday>1981-06-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18296366989</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 10:25:25
记录内容：select * from  pat_master_index where id_no='362330198106225481' and name='邵红娥' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/6/22 0:00:0045
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:25:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:25:25
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),7798,'妇科韩卫灵副主任','白天','23','100538898','邵红娥','SHAO HONG E ','女','45','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/21 10:25:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602217798','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','24') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 10:25:25
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),7798,'妇科韩卫灵副主任','白天','23','100538898','邵红娥','SHAO HONG E ','女','45','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/21 10:25:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602217798','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('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科韩卫灵副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),7798,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602217798</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602217798</pinkey><ordertime>2026-02-21 10:25:25</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 10:25:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15832674540</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/27 0:00:00_下午_骨科刘兴超</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200301090523</patientidcard><patientname>孟祥宏羿</patientname><patientsex>女</patientsex><patientbirthday>2003-01-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15832674540</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 10:25:48
记录内容：select * from  pat_master_index where id_no='131082200301090523' and name='孟祥宏羿' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2003/1/9 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:25:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/27','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:25:48
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/27','YYYY/MM/DD'),7805,'骨科刘兴超','下午','1','00283378','孟祥宏羿','','女','23','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/21 10:25:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602277805','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 10:25:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/27','YYYY/MM/DD'),7805,'骨科刘兴超','下午','1','00283378','孟祥宏羿','','女','23','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/21 10:25:56','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602277805','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/27','YYYY/MM/DD'),7805,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/27','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602277805</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602277805</pinkey><ordertime>2026-02-21 10:25:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 10:38:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531600685</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_白天_妇科韩卫灵副主任</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131002199003060644</patientidcard><patientname>杨伟兰</patientname><patientsex>女</patientsex><patientbirthday>1990-03-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18531600685</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 10:38:36
记录内容：select * from  pat_master_index where id_no='131002199003060644' and name='杨伟兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/3/6 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:38:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:38:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),8022,'妇科韩卫灵副主任','白天','25','10776666','杨伟兰','','女','36','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/21 10:38:44','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602218022','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','26') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 10:38:36
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/21','YYYY/MM/DD'),8022,'妇科韩卫灵副主任','白天','25','10776666','杨伟兰','','女','36','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2026/02/21 10:38:44','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602218022','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','26') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科韩卫灵副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),8022,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602218022</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602218022</pinkey><ordertime>2026-02-21 10:38:36</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 10:42:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18731666690</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/26 0:00:00_上午_消化内科吴东方</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822196502012029</patientidcard><patientname>耿国利</patientname><patientsex>女</patientsex><patientbirthday>1965-02-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18731666690</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 10:42:49
记录内容：select * from  pat_master_index where id_no='132822196502012029' and name='耿国利' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/2/1 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:42:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 10:42:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/26','YYYY/MM/DD'),8083,'消化内科吴东方','上午','1','100283874','耿国利','GENG GUO LI','女','61','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2026/02/21 10:42:57','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602268083','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 10:42:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/26','YYYY/MM/DD'),8083,'消化内科吴东方','上午','1','100283874','耿国利','GENG GUO LI','女','61','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2026/02/21 10:42:57','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602268083','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科吴东方' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/26','YYYY/MM/DD'),8083,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602268083</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602268083</pinkey><ordertime>2026-02-21 10:42:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 13:04:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17718578971</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_下午_骨科刘兴超</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370421195406171249</patientidcard><patientname>于新千</patientname><patientsex>女</patientsex><patientbirthday>1954-06-17</patientbirthday><medicalrecord></medicalrecord><contactphone>17718578971</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 13:04:50
记录内容：select * from  pat_master_index where id_no='370421195406171249' and name='于新千' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/6/17 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 13:04:50
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 13:04: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('2026/02/22','YYYY/MM/DD'),9227,'骨科刘兴超','下午','1','M00091583','于新千','YU XIN QIAN','女','72','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/21 13:04:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602229227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 13:04: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('2026/02/22','YYYY/MM/DD'),9227,'骨科刘兴超','下午','1','M00091583','于新千','YU XIN QIAN','女','72','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/21 13:04:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602229227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9227,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602229227</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602229227</pinkey><ordertime>2026-02-21 13:04:50</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 13:06:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17718578971</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_下午_呼吸内科王君 普</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>370421195406171249</patientidcard><patientname>于新千</patientname><patientsex>女</patientsex><patientbirthday>1954-06-17</patientbirthday><medicalrecord></medicalrecord><contactphone>17718578971</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 13:06:33
记录内容：select * from  pat_master_index where id_no='370421195406171249' and name='于新千' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/6/17 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 13:06:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王君 普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 13:06:33
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9240,'呼吸内科王君 普','下午','1','M00091583','于新千','YU XIN QIAN','女','72','一般人员','自费','','普通号','1','0317','WANGJ','1',to_date('2026/02/21 13:06:41','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602229240','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 13:06:33
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9240,'呼吸内科王君 普','下午','1','M00091583','于新千','YU XIN QIAN','女','72','一般人员','自费','','普通号','1','0317','WANGJ','1',to_date('2026/02/21 13:06:41','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602229240','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王君 普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9240,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王君 普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602229240</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602229240</pinkey><ordertime>2026-02-21 13:06:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 14:09:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17718578971</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_下午_耳鼻喉科吴胜杰</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370421195406171249</patientidcard><patientname>于新千</patientname><patientsex>女</patientsex><patientbirthday>1954-06-17</patientbirthday><medicalrecord></medicalrecord><contactphone>17718578971</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 14:09:16
记录内容：select * from  pat_master_index where id_no='370421195406171249' and name='于新千' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/6/17 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 14:09:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 14:09: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('2026/02/22','YYYY/MM/DD'),9863,'耳鼻喉科吴胜杰','下午','1','M00091583','于新千','YU XIN QIAN','女','72','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/02/21 14:09:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602229863','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 14:09: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('2026/02/22','YYYY/MM/DD'),9863,'耳鼻喉科吴胜杰','下午','1','M00091583','于新千','YU XIN QIAN','女','72','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/02/21 14:09:23','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602229863','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科吴胜杰' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9863,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602229863</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602229863</pinkey><ordertime>2026-02-21 14:09:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 14:19:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15244621061</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_内分泌科张金环普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230705198808090010</patientidcard><patientname>马旭光</patientname><patientsex>男</patientsex><patientbirthday>1988-08-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15244621061</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 14:19:40
记录内容：select * from  pat_master_index where id_no='230705198808090010' and name='马旭光' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/8/9 0:00:0038
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 14:19:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 14:19:40
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9964,'内分泌科张金环普','上午','1','100409105','马旭光','MA XU GUANG ','男','38','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2026/02/21 14:19:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602229964','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 14:19:41
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9964,'内分泌科张金环普','上午','1','100409105','马旭光','MA XU GUANG ','男','38','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2026/02/21 14:19:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602229964','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9964,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602229964</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602229964</pinkey><ordertime>2026-02-21 14:19:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 15:52:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15843957276</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_呼吸内科王莉</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220602194904210022</patientidcard><patientname>邢振玲</patientname><patientsex>女</patientsex><patientbirthday>1949-04-21</patientbirthday><medicalrecord></medicalrecord><contactphone>15843957276</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 15:52:44
记录内容：select * from  pat_master_index where id_no='220602194904210022' and name='邢振玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1949/4/21 0:00:0077
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 15:52:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 15:52:44
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),932,'呼吸内科王莉','上午','3','100054074','邢振玲','','女','77','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/02/21 15:52:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602220932','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 15:52:44
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),932,'呼吸内科王莉','上午','3','100054074','邢振玲','','女','77','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/02/21 15:52:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602220932','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王莉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),932,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20260222932</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>20260222932</pinkey><ordertime>2026-02-21 15:52:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 15:53:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15832899493</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/26 0:00:00_上午_心血管内科谭琛</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13262819700327312X</patientidcard><patientname>邵艳华</patientname><patientsex>女</patientsex><patientbirthday>1970-03-27</patientbirthday><medicalrecord></medicalrecord><contactphone>15832899493</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 15:53:15
记录内容：select * from  pat_master_index where id_no='13262819700327312X' and name='邵艳华' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/3/27 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 15:53:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 15:53: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('2026/02/26','YYYY/MM/DD'),933,'心血管内科谭琛','上午','14','100538686','邵艳华','SHAO YAN HUA ','女','56','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2026/02/21 15:53:22','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602260933','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 15:53: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('2026/02/26','YYYY/MM/DD'),933,'心血管内科谭琛','上午','14','100538686','邵艳华','SHAO YAN HUA ','女','56','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2026/02/21 15:53:22','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602260933','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/26','YYYY/MM/DD'),933,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '心血管内科谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20260226933</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>20260226933</pinkey><ordertime>2026-02-21 15:53:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 17:23:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13581733689</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/25 0:00:00_上午_头晕门诊徐金静</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152527198702163612</patientidcard><patientname>韩兵</patientname><patientsex>男</patientsex><patientbirthday>1987-02-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13581733689</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 17:23:45
记录内容：select * from  pat_master_index where id_no='152527198702163612' and name='韩兵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/2/16 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 17:23:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/25','yyyy/mm/dd')
                    and clinic_label = '头晕门诊徐金静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 17:23: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('2026/02/25','YYYY/MM/DD'),1617,'头晕门诊徐金静','上午','1','100532301','韩兵','HAN BING ','男','39','一般人员','自费','','副主任号','1','0303','XUJJ','1',to_date('2026/02/21 17:23:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602251617','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 17:23:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/25','YYYY/MM/DD'),1617,'头晕门诊徐金静','上午','1','100532301','韩兵','HAN BING ','男','39','一般人员','自费','','副主任号','1','0303','XUJJ','1',to_date('2026/02/21 17:23:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602251617','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '头晕门诊徐金静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/25','YYYY/MM/DD'),1617,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/25','yyyy/mm/dd')
                    and clinic_label = '头晕门诊徐金静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602251617</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602251617</pinkey><ordertime>2026-02-21 17:23:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 17:46:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18811452466</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_内分泌科张金环普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220221196805255627</patientidcard><patientname>张桂芝</patientname><patientsex>女</patientsex><patientbirthday>1968-05-25</patientbirthday><medicalrecord></medicalrecord><contactphone>18811452466</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 17:46:58
记录内容：select * from  pat_master_index where id_no='220221196805255627' and name='张桂芝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/5/25 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 17:46:58
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 17:46:58
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1653,'内分泌科张金环普','上午','3','100392667','张桂芝','ZHANG GUI ZHI ','女','58','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2026/02/21 17:47:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221653','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 17:46:58
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1653,'内分泌科张金环普','上午','3','100392667','张桂芝','ZHANG GUI ZHI ','女','58','一般人员','自费','','普通号','1','0315','ZJH01','1',to_date('2026/02/21 17:47:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221653','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1653,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221653</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221653</pinkey><ordertime>2026-02-21 17:46:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:15:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18611138291</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_甲乳门诊王新远普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>372502195502014508</patientidcard><patientname>路凤莲</patientname><patientsex>女</patientsex><patientbirthday>1955-02-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18611138291</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:15:37
记录内容：select * from  pat_master_index where id_no='372502195502014508' and name='路凤莲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/2/1 0:00:0071
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:15:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '甲乳门诊王新远普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:15:37
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1704,'甲乳门诊王新远普','上午','1','100538998','路凤莲','LU FENG LIAN ','女','71','一般人员','自费','','普通号','1','0335','WXY001','1',to_date('2026/02/21 18:15:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221704','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:15:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1704,'甲乳门诊王新远普','上午','1','100538998','路凤莲','LU FENG LIAN ','女','71','一般人员','自费','','普通号','1','0335','WXY001','1',to_date('2026/02/21 18:15:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221704','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '甲乳门诊王新远普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1704,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '甲乳门诊王新远普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221704</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221704</pinkey><ordertime>2026-02-21 18:15:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:15:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13703168304</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_心血管内安立敏普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028198204170056</patientidcard><patientname>周振兴</patientname><patientsex>男</patientsex><patientbirthday>1982-04-17</patientbirthday><medicalrecord></medicalrecord><contactphone>13703168304</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:15:40
记录内容：select * from  pat_master_index where id_no='131028198204170056' and name='周振兴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/4/17 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:15:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '心血管内安立敏普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:15:40
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1705,'心血管内安立敏普','上午','2','10384269','周振兴','','男','44','一般人员','自费','','普通号','1','0359','ALM','1',to_date('2026/02/21 18:15:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221705','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:15:40
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1705,'心血管内安立敏普','上午','2','10384269','周振兴','','男','44','一般人员','自费','','普通号','1','0359','ALM','1',to_date('2026/02/21 18:15:46','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221705','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内安立敏普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1705,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '心血管内安立敏普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221705</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221705</pinkey><ordertime>2026-02-21 18:15:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:17:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17835392155</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_皮肤科杨维玲</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>140723197407250067</patientidcard><patientname>赵秀英</patientname><patientsex>女</patientsex><patientbirthday>1974-07-25</patientbirthday><medicalrecord></medicalrecord><contactphone>17835392155</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:17:07
记录内容：select * from  pat_master_index where id_no='140723197407250067' and name='赵秀英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/7/25 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:17:07
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:17:07
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1710,'皮肤科杨维玲','上午','4','100501690','赵秀英','ZHAO XIU YING ','女','52','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/02/21 18:17:13','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602221710','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:17:07
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1710,'皮肤科杨维玲','上午','4','100501690','赵秀英','ZHAO XIU YING ','女','52','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/02/21 18:17:13','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602221710','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1710,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221710</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602221710</pinkey><ordertime>2026-02-21 18:17:07</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:25:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15910691812</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_下午_心血管内安立敏普</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>500102198908127101</patientidcard><patientname>江婷毓</patientname><patientsex>女</patientsex><patientbirthday>1989-08-12</patientbirthday><medicalrecord></medicalrecord><contactphone>15910691812</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:25:47
记录内容：select * from  pat_master_index where id_no='500102198908127101' and name='江婷毓' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/8/12 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:25:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '心血管内安立敏普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:25:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1725,'心血管内安立敏普','下午','1','100538999','江婷毓','JIANG   ','女','37','一般人员','自费','','普通号','1','0359','ALM','1',to_date('2026/02/21 18:25:53','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221725','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:25:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1725,'心血管内安立敏普','下午','1','100538999','江婷毓','JIANG   ','女','37','一般人员','自费','','普通号','1','0359','ALM','1',to_date('2026/02/21 18:25:53','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221725','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内安立敏普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1725,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '心血管内安立敏普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602221725</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221725</pinkey><ordertime>2026-02-21 18:25:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:49:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13840230190</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_白天_妇科李二雷</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>440523200706060049</patientidcard><patientname>黄杨渝</patientname><patientsex>女</patientsex><patientbirthday>2007-06-06</patientbirthday><medicalrecord></medicalrecord><contactphone>13840230190</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:49:45
记录内容：select * from  pat_master_index where id_no='440523200706060049' and name='黄杨渝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/6/6 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:49:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '妇科李二雷' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:49: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('2026/02/22','YYYY/MM/DD'),1756,'妇科李二雷','白天','4','DP029898','黄杨渝','HUANG YANG YU','女','19','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2026/02/21 18:49:50','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602221756','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:49:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1756,'妇科李二雷','白天','4','DP029898','黄杨渝','HUANG YANG YU','女','19','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2026/02/21 18:49:50','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602221756','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科李二雷' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1756,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '妇科李二雷' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602221756</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602221756</pinkey><ordertime>2026-02-21 18:49:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:55:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19931845446</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_神经内科潘瑞春</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082196911015521</patientidcard><patientname>李静芝</patientname><patientsex>女</patientsex><patientbirthday>1969-11-01</patientbirthday><medicalrecord></medicalrecord><contactphone>19931845446</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:55:46
记录内容：select * from  pat_master_index where id_no='131082196911015521' and name='李静芝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/11/1 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:55:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科潘瑞春' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:55: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('2026/02/22','YYYY/MM/DD'),1761,'神经内科潘瑞春','上午','2','100539005','李静芝','LI JING ZHI ','女','57','一般人员','自费','','副主任号','1','0303','PANRC','1',to_date('2026/02/21 18:55:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602221761','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:55: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('2026/02/22','YYYY/MM/DD'),1761,'神经内科潘瑞春','上午','2','100539005','李静芝','LI JING ZHI ','女','57','一般人员','自费','','副主任号','1','0303','PANRC','1',to_date('2026/02/21 18:55:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602221761','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科潘瑞春' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1761,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科潘瑞春' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221761</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602221761</pinkey><ordertime>2026-02-21 18:55:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 18:59:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15103368593</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/23 0:00:00_上午_心血管内陶林森普</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132629196709045323</patientidcard><patientname>刘桂兰</patientname><patientsex>女</patientsex><patientbirthday>1967-09-04</patientbirthday><medicalrecord></medicalrecord><contactphone>15103368593</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 18:59:36
记录内容：select * from  pat_master_index where id_no='132629196709045323' and name='刘桂兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1967/9/4 0:00:0059
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:59:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 18:59:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1764,'心血管内陶林森普','上午','1','100539006','刘桂兰','LIU GUI LAN ','女','59','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2026/02/21 18:59:42','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602231764','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 18:59:36
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1764,'心血管内陶林森普','上午','1','100539006','刘桂兰','LIU GUI LAN ','女','59','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2026/02/21 18:59:42','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602231764','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/23', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内陶林森普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1764,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602231764</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602231764</pinkey><ordertime>2026-02-21 18:59:36</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:00:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15244621061</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/23 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230705198808090010</patientidcard><patientname>马旭光</patientname><patientsex>男</patientsex><patientbirthday>1988-08-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15244621061</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:00:09
记录内容：select * from  pat_master_index where id_no='230705198808090010' and name='马旭光' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/8/9 0:00:0038
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:00:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:00:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1766,'内分泌科马伟杰','上午','1','100409105','马旭光','MA XU GUANG ','男','38','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2026/02/21 19:00:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602231766','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:00:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1766,'内分泌科马伟杰','上午','1','100409105','马旭光','MA XU GUANG ','男','38','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2026/02/21 19:00:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602231766','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/23', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1766,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602231766</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602231766</pinkey><ordertime>2026-02-21 19:00:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:02:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15698571885</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/23 0:00:00_上午_中医骨伤李国强</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>142226196806180317</patientidcard><patientname>郑玉清</patientname><patientsex>男</patientsex><patientbirthday>1968-06-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15698571885</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:02:07
记录内容：select * from  pat_master_index where id_no='142226196806180317' and name='郑玉清' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/6/18 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:02:07
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '中医骨伤李国强' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:02:07
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1768,'中医骨伤李国强','上午','1','100539007','郑玉清','ZHENG YU QING ','男','58','一般人员','自费','','中主任号','1','0301','LIGQ','1',to_date('2026/02/21 19:02:12','yyyy/mm/dd hh24:mi:ss'),'0','40','0.00','40','202602231768','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:02:07
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1768,'中医骨伤李国强','上午','1','100539007','郑玉清','ZHENG YU QING ','男','58','一般人员','自费','','中主任号','1','0301','LIGQ','1',to_date('2026/02/21 19:02:12','yyyy/mm/dd hh24:mi:ss'),'0','40','0.00','40','202602231768','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/23', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医骨伤李国强' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/23','YYYY/MM/DD'),1768,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '中医骨伤李国强' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602231768</orderid><reservefee>0.00</reservefee><clinicfee>40</clinicfee><registrationfee>0</registrationfee><pinkey>202602231768</pinkey><ordertime>2026-02-21 19:02:07</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:05:54
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18511584989</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_神经内科潘瑞春</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>222425195305292644</patientidcard><patientname>金粉善</patientname><patientsex>女</patientsex><patientbirthday>1953-05-29</patientbirthday><medicalrecord></medicalrecord><contactphone>18511584989</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:05:54
记录内容：select * from  pat_master_index where id_no='222425195305292644' and name='金粉善' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1953/5/29 0:00:0073
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:05:54
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科潘瑞春' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:05:54
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1772,'神经内科潘瑞春','上午','3','00358627','金粉善','JIN FEN SHAN','女','73','一般人员','自费','','副主任号','1','0303','PANRC','1',to_date('2026/02/21 19:06:00','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602221772','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:05:54
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1772,'神经内科潘瑞春','上午','3','00358627','金粉善','JIN FEN SHAN','女','73','一般人员','自费','','副主任号','1','0303','PANRC','1',to_date('2026/02/21 19:06:00','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602221772','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科潘瑞春' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1772,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科潘瑞春' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221772</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602221772</pinkey><ordertime>2026-02-21 19:05:54</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:08:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19931314387</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_消化内科王玲 普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200108250513</patientidcard><patientname>王一霖</patientname><patientsex>男</patientsex><patientbirthday>2001-08-25</patientbirthday><medicalrecord></medicalrecord><contactphone>19931314387</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:08:42
记录内容：select * from  pat_master_index where id_no='131082200108250513' and name='王一霖' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/8/25 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:08:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '消化内科王玲 普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:08:42
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1777,'消化内科王玲 普','上午','3','10509471','王一霖','','男','25','一般人员','自费','','普通号','1','0302','WL01','1',to_date('2026/02/21 19:08:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221777','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:08:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1777,'消化内科王玲 普','上午','3','10509471','王一霖','','男','25','一般人员','自费','','普通号','1','0302','WL01','1',to_date('2026/02/21 19:08:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221777','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科王玲 普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1777,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '消化内科王玲 普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221777</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221777</pinkey><ordertime>2026-02-21 19:08:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:16:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13520870466</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_心血管内科陶林森</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>222326196211060047</patientidcard><patientname>樊秀芬</patientname><patientsex>女</patientsex><patientbirthday>1962-11-06</patientbirthday><medicalrecord></medicalrecord><contactphone>13520870466</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:16:37
记录内容：select * from  pat_master_index where id_no='222326196211060047' and name='樊秀芬' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1962/11/6 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:16:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '心血管内科陶林森' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:16:37
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1795,'心血管内科陶林森','上午','4','100538688','樊秀芬','FAN XIU FEN ','女','64','一般人员','自费','','主任号','1','0359','TAOLS','1',to_date('2026/02/21 19:16:42','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602221795','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:16:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1795,'心血管内科陶林森','上午','4','100538688','樊秀芬','FAN XIU FEN ','女','64','一般人员','自费','','主任号','1','0359','TAOLS','1',to_date('2026/02/21 19:16:42','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602221795','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科陶林森' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1795,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '心血管内科陶林森' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221795</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602221795</pinkey><ordertime>2026-02-21 19:16:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:25:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18010052172</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/26 0:00:00_下午_产科辛俊英</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130681199309193842</patientidcard><patientname>吴佳秋</patientname><patientsex>女</patientsex><patientbirthday>1993-09-19</patientbirthday><medicalrecord></medicalrecord><contactphone>18010052172</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:25:40
记录内容：select * from  pat_master_index where id_no='130681199309193842' and name='吴佳秋' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/9/19 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:25:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:25:40
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/26','YYYY/MM/DD'),1808,'产科辛俊英','下午','1','100198414','吴佳秋','WU JIA QIU ','女','33','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2026/02/21 19:25:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602261808','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:25:40
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/26','YYYY/MM/DD'),1808,'产科辛俊英','下午','1','100198414','吴佳秋','WU JIA QIU ','女','33','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2026/02/21 19:25:46','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602261808','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/26','YYYY/MM/DD'),1808,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/26','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602261808</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602261808</pinkey><ordertime>2026-02-21 19:25:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 19:43:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18910122637</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_耳鼻喉科吴胜杰</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>210624196801023051</patientidcard><patientname>祝兆海</patientname><patientsex>男</patientsex><patientbirthday>1968-01-02</patientbirthday><medicalrecord></medicalrecord><contactphone>18910122637</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 19:43:44
记录内容：select * from  pat_master_index where id_no='210624196801023051' and name='祝兆海' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/1/2 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:43:44
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 19:43:44
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1831,'耳鼻喉科吴胜杰','上午','2','100538612','祝兆海','ZHU ZHAO HAI ','男','58','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/02/21 19:43:50','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221831','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 19:43:44
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1831,'耳鼻喉科吴胜杰','上午','2','100538612','祝兆海','ZHU ZHAO HAI ','男','58','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/02/21 19:43:50','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221831','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科吴胜杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1831,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221831</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221831</pinkey><ordertime>2026-02-21 19:43:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 21:50:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13439366678</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_儿科刘婕</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>220103201812040611</patientidcard><patientname>姚思成</patientname><patientsex>男</patientsex><patientbirthday>2018-12-04</patientbirthday><medicalrecord></medicalrecord><contactphone>13439366678</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 21:50:27
记录内容：select * from  pat_master_index where id_no='220103201812040611' and name='姚思成' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2018/12/4 0:00:008
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 21:50:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 21:50:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1937,'儿科刘婕','上午','1','10387891','姚思成','YAO SI CHENG','男','8','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/02/21 21:50:32','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602221937','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 21:50:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1937,'儿科刘婕','上午','1','10387891','姚思成','YAO SI CHENG','男','8','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/02/21 21:50:32','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602221937','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1937,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221937</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602221937</pinkey><ordertime>2026-02-21 21:50:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 21:56:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15632387750</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_肾病科崔金乔</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230503199412190219</patientidcard><patientname>刘旭东</patientname><patientsex>男</patientsex><patientbirthday>1994-12-19</patientbirthday><medicalrecord></medicalrecord><contactphone>15632387750</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 21:56:28
记录内容：select * from  pat_master_index where id_no='230503199412190219' and name='刘旭东' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/12/19 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 21:56:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '肾病科崔金乔' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 21:56: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('2026/02/22','YYYY/MM/DD'),1942,'肾病科崔金乔','上午','1','100539025','刘旭东','LIU XU DONG ','男','32','一般人员','自费','','普通号','1','0333','CJQ1','1',to_date('2026/02/21 21:56:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221942','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 21:56: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('2026/02/22','YYYY/MM/DD'),1942,'肾病科崔金乔','上午','1','100539025','刘旭东','LIU XU DONG ','男','32','一般人员','自费','','普通号','1','0333','CJQ1','1',to_date('2026/02/21 21:56:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221942','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '肾病科崔金乔' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1942,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '肾病科崔金乔' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221942</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221942</pinkey><ordertime>2026-02-21 21:56:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 22:52:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13911396882</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_呼吸内科王莉</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132421196804132511</patientidcard><patientname>韩世杰</patientname><patientsex>男</patientsex><patientbirthday>1968-04-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13911396882</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 22:52:22
记录内容：select * from  pat_master_index where id_no='132421196804132511' and name='韩世杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/4/13 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 22:52:22
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 22:52: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('2026/02/22','YYYY/MM/DD'),1968,'呼吸内科王莉','上午','4','100539030','韩世杰','HAN SHI JIE ','男','58','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/02/21 22:52:27','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602221968','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 22:52: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('2026/02/22','YYYY/MM/DD'),1968,'呼吸内科王莉','上午','4','100539030','韩世杰','HAN SHI JIE ','男','58','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/02/21 22:52:27','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602221968','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王莉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1968,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221968</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602221968</pinkey><ordertime>2026-02-21 22:52:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-21 23:45:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18733632352</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_神经内科杨志华</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>510107200205260049</patientidcard><patientname>赵雨晴</patientname><patientsex>女</patientsex><patientbirthday>2002-05-26</patientbirthday><medicalrecord></medicalrecord><contactphone>18733632352</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-21 23:45:37
记录内容：select * from  pat_master_index where id_no='510107200205260049' and name='赵雨晴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/5/26 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 23:45:37
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-21 23:45:37
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1985,'神经内科杨志华','上午','2','100345368','赵雨晴','ZHAO YU QING ','女','24','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/21 23:45:42','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221985','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-21 23:45:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1985,'神经内科杨志华','上午','2','100345368','赵雨晴','ZHAO YU QING ','女','24','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/02/21 23:45:42','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602221985','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科杨志华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),1985,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科杨志华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602221985</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602221985</pinkey><ordertime>2026-02-21 23:45:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆