◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 09:47:34
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13932653650</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_白天_妇科丁圆</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199707130761</patientidcard><patientname>李艺苑</patientname><patientsex>女</patientsex><patientbirthday>1997-07-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13932653650</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 09:47:35
记录内容：select * from  pat_master_index where id_no='131082199707130761' and name='李艺苑' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/7/13 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 09:47:35
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 09:47:35
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),4970,'妇科丁圆','白天','1','100208022','李艺苑','LI YI YUAN ','女','28','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 09:47:34','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501304970','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 09:47:35
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),4970,'妇科丁圆','白天','1','100208022','李艺苑','LI YI YUAN ','女','28','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 09:47:34','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501304970','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科丁圆' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),4970,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501304970</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501304970</pinkey><ordertime>2025-01-29 09:47:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 13:02:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15100700898</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/7 0:00:00_上午_心血管内科雷警输</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230231196107125221</patientidcard><patientname>李桂香</patientname><patientsex>女</patientsex><patientbirthday>1961-07-12</patientbirthday><medicalrecord></medicalrecord><contactphone>15100700898</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 13:02:58
记录内容：select * from  pat_master_index where id_no='230231196107125221' and name='李桂香' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1961/7/12 0:00:0064
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 13:02:58
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/07','yyyy/mm/dd')
                    and clinic_label = '心血管内科雷警输' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 13:02:58
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/07','YYYY/MM/DD'),5548,'心血管内科雷警输','上午','1','100466953','李桂香','LI GUI XIANG ','女','64','一般人员','自费','','副主任号','1','0359','LJS','1',to_date('2025/01/29 13:02:57','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502075548','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 13:02:58
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/07','YYYY/MM/DD'),5548,'心血管内科雷警输','上午','1','100466953','李桂香','LI GUI XIANG ','女','64','一般人员','自费','','副主任号','1','0359','LJS','1',to_date('2025/01/29 13:02:57','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502075548','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/02/07', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科雷警输' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/07','YYYY/MM/DD'),5548,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/07','yyyy/mm/dd')
                    and clinic_label = '心血管内科雷警输' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202502075548</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202502075548</pinkey><ordertime>2025-01-29 13:02:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 14:33:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15733665128</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/31 0:00:00_上午_中医骨伤祖亚利</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821196605038727</patientidcard><patientname>贾宝英</patientname><patientsex>女</patientsex><patientbirthday>1966-05-03</patientbirthday><medicalrecord></medicalrecord><contactphone>15733665128</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 14:33:52
记录内容：select * from  pat_master_index where id_no='132821196605038727' and name='贾宝英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1966/5/3 0:00:0059
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 14:33:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '中医骨伤祖亚利' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 14:33:52
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),5922,'中医骨伤祖亚利','上午','1','100466956','贾宝英','JIA BAO YING ','女','59','一般人员','自费','','普通号','1','0301','ZUYL','1',to_date('2025/01/29 14:33:51','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501315922','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 14:33:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),5922,'中医骨伤祖亚利','上午','1','100466956','贾宝英','JIA BAO YING ','女','59','一般人员','自费','','普通号','1','0301','ZUYL','1',to_date('2025/01/29 14:33:51','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501315922','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/31', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医骨伤祖亚利' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/31','YYYY/MM/DD'),5922,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '中医骨伤祖亚利' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501315922</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501315922</pinkey><ordertime>2025-01-29 14:33:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 16:23:26
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13722668209</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/6 0:00:00_上午_骨质疏松张国栋</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082197407100801</patientidcard><patientname>李艳侠</patientname><patientsex>女</patientsex><patientbirthday>1974-07-10</patientbirthday><medicalrecord></medicalrecord><contactphone>13722668209</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 16:23:26
记录内容：select * from  pat_master_index where id_no='131082197407100801' and name='李艳侠' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/7/10 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 16:23:26
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/06','yyyy/mm/dd')
                    and clinic_label = '骨质疏松张国栋' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 16:23:26
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/06','YYYY/MM/DD'),6279,'骨质疏松张国栋','上午','1','M00068553','李艳侠','LI YAN XIA','女','51','一般人员','自费','','副主任号','1','0312','ZGD','1',to_date('2025/01/29 16:23:24','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502066279','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 16:23:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/06','YYYY/MM/DD'),6279,'骨质疏松张国栋','上午','1','M00068553','李艳侠','LI YAN XIA','女','51','一般人员','自费','','副主任号','1','0312','ZGD','1',to_date('2025/01/29 16:23:24','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502066279','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/02/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨质疏松张国栋' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/06','YYYY/MM/DD'),6279,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/06','yyyy/mm/dd')
                    and clinic_label = '骨质疏松张国栋' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202502066279</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202502066279</pinkey><ordertime>2025-01-29 16:23:26</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 17:16:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13911416620</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_上午_泌尿外科普通号</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>110105195208254815</patientidcard><patientname>冯建洪</patientname><patientsex>男</patientsex><patientbirthday>1952-08-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13911416620</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 17:16:53
记录内容：select * from  pat_master_index where id_no='110105195208254815' and name='冯建洪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1952/8/25 0:00:0073
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 17:16:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '泌尿外科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 17:16:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6357,'泌尿外科普通号','上午','1','100466959','冯建洪','FENG JIAN HONG ','男','73','一般人员','自费','','普通号','1','0311','','1',to_date('2025/01/29 17:16:50','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306357','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 17:16:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6357,'泌尿外科普通号','上午','1','100466959','冯建洪','FENG JIAN HONG ','男','73','一般人员','自费','','普通号','1','0311','','1',to_date('2025/01/29 17:16:50','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306357','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6357,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '泌尿外科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501306357</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306357</pinkey><ordertime>2025-01-29 17:16:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 17:31:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13676710877</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_白天_妇科丁圆</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>412828200008161867</patientidcard><patientname>李晗</patientname><patientsex>女</patientsex><patientbirthday>2000-08-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13676710877</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 17:31:48
记录内容：select * from  pat_master_index where id_no='412828200008161867' and name='李晗' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/8/16 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 17:31:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 17:31: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('2025/01/30','YYYY/MM/DD'),6369,'妇科丁圆','白天','2','100452505','李晗','LI  ','女','25','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 17:31:45','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306369','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 17:31: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('2025/01/30','YYYY/MM/DD'),6369,'妇科丁圆','白天','2','100452505','李晗','LI  ','女','25','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 17:31:45','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306369','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科丁圆' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6369,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501306369</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306369</pinkey><ordertime>2025-01-29 17:31:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 17:52:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17600567313</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/3 0:00:00_上午_产科张洪英</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230221199103293042</patientidcard><patientname>张晓秋</patientname><patientsex>女</patientsex><patientbirthday>1991-03-29</patientbirthday><medicalrecord></medicalrecord><contactphone>17600567313</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 17:52:00
记录内容：select * from  pat_master_index where id_no='230221199103293042' and name='张晓秋' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/3/29 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 17:52:00
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/03','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 17:52:00
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/03','YYYY/MM/DD'),6404,'产科张洪英','上午','1','100406708','张晓秋','ZHANG XIAO QIU ','女','34','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2025/01/29 17:51:58','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502036404','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 17:52:01
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/03','YYYY/MM/DD'),6404,'产科张洪英','上午','1','100406708','张晓秋','ZHANG XIAO QIU ','女','34','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2025/01/29 17:51:58','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502036404','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/02/03', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科张洪英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/03','YYYY/MM/DD'),6404,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/03','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202502036404</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202502036404</pinkey><ordertime>2025-01-29 17:52:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 18:03:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18366630177</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370830201811124741</patientidcard><patientname>张芮琳</patientname><patientsex>女</patientsex><patientbirthday>2018-11-12</patientbirthday><medicalrecord></medicalrecord><contactphone>18366630177</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 18:03:52
记录内容：select * from  pat_master_index where id_no='370830201811124741' and name='张芮琳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2018/11/12 0:00:007
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:03:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:03:52
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6411,'儿科陈云平','上午','1','100274231','张芮琳','ZHANG  LIN ','女','7','一般人员','自费','','知名专家','1','0304','CYP11','1',to_date('2025/01/29 18:03:49','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501306411','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 18:03:52
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6411,'儿科陈云平','上午','1','100274231','张芮琳','ZHANG  LIN ','女','7','一般人员','自费','','知名专家','1','0304','CYP11','1',to_date('2025/01/29 18:03:49','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501306411','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6411,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501306411</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501306411</pinkey><ordertime>2025-01-29 18:03:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 18:09:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13463608001</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_上午_神经内科李晓宁</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197009102033</patientidcard><patientname>杨华杰</patientname><patientsex>男</patientsex><patientbirthday>1970-09-10</patientbirthday><medicalrecord></medicalrecord><contactphone>13463608001</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 18:09:43
记录内容：select * from  pat_master_index where id_no='132822197009102033' and name='杨华杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/9/10 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:09:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '神经内科李晓宁' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:09:43
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6422,'神经内科李晓宁','上午','1','10502231','杨华杰','','男','55','一般人员','自费','','普通号','1','0303','LIXN','1',to_date('2025/01/29 18:09:41','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306422','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 18:09:43
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6422,'神经内科李晓宁','上午','1','10502231','杨华杰','','男','55','一般人员','自费','','普通号','1','0303','LIXN','1',to_date('2025/01/29 18:09:41','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306422','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科李晓宁' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6422,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '神经内科李晓宁' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501306422</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306422</pinkey><ordertime>2025-01-29 18:09:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 18:38:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19982069231</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_白天_妇科丁圆</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>430702200108213049</patientidcard><patientname>张梓溪</patientname><patientsex>女</patientsex><patientbirthday>2001-08-21</patientbirthday><medicalrecord></medicalrecord><contactphone>19982069231</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 18:38:20
记录内容：select * from  pat_master_index where id_no='430702200108213049' and name='张梓溪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/8/21 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:38:20
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:38:20
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6485,'妇科丁圆','白天','3','100466962','张梓溪','ZHANG  XI ','女','24','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 18:38:18','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306485','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 18:38:20
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6485,'妇科丁圆','白天','3','100466962','张梓溪','ZHANG  XI ','女','24','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 18:38:18','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306485','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科丁圆' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6485,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501306485</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306485</pinkey><ordertime>2025-01-29 18:38:20</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 18:43:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13811494689</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_白天_妇科丁圆</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>430723197402222226</patientidcard><patientname>詹春芳</patientname><patientsex>女</patientsex><patientbirthday>1974-02-22</patientbirthday><medicalrecord></medicalrecord><contactphone>13811494689</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 18:43:38
记录内容：select * from  pat_master_index where id_no='430723197402222226' and name='詹春芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/2/22 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:43:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 18:43: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('2025/01/30','YYYY/MM/DD'),6499,'妇科丁圆','白天','4','00089573','詹春芳','','女','51','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 18:43:35','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306499','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 18:43: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('2025/01/30','YYYY/MM/DD'),6499,'妇科丁圆','白天','4','00089573','詹春芳','','女','51','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 18:43:35','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306499','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科丁圆' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6499,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501306499</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306499</pinkey><ordertime>2025-01-29 18:43:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 19:08:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13582791871</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_上午_神经内科李晓宁</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>239005197601271565</patientidcard><patientname>王春丽</patientname><patientsex>女</patientsex><patientbirthday>1976-01-27</patientbirthday><medicalrecord></medicalrecord><contactphone>13582791871</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 19:08:46
记录内容：select * from  pat_master_index where id_no='239005197601271565' and name='王春丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1976/1/27 0:00:0049
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:08:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '神经内科李晓宁' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:08:46
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6531,'神经内科李晓宁','上午','2','10291726','王春丽','WANG CHUN LI','女','49','一般人员','自费','','普通号','1','0303','LIXN','1',to_date('2025/01/29 19:08:43','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306531','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 19:08:46
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6531,'神经内科李晓宁','上午','2','10291726','王春丽','WANG CHUN LI','女','49','一般人员','自费','','普通号','1','0303','LIXN','1',to_date('2025/01/29 19:08:43','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306531','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科李晓宁' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6531,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '神经内科李晓宁' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501306531</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306531</pinkey><ordertime>2025-01-29 19:08:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 19:09:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13582791871</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/31 0:00:00_上午_心血管内陶林森普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>239005197601271565</patientidcard><patientname>王春丽</patientname><patientsex>女</patientsex><patientbirthday>1976-01-27</patientbirthday><medicalrecord></medicalrecord><contactphone>13582791871</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 19:09:43
记录内容：select * from  pat_master_index where id_no='239005197601271565' and name='王春丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1976/1/27 0:00:0049
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:09:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:09:43
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6534,'心血管内陶林森普','上午','2','10291726','王春丽','WANG CHUN LI','女','49','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/01/29 19:09:41','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501316534','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 19:09:44
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6534,'心血管内陶林森普','上午','2','10291726','王春丽','WANG CHUN LI','女','49','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/01/29 19:09:41','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501316534','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/31', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内陶林森普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6534,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501316534</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501316534</pinkey><ordertime>2025-01-29 19:09:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 19:10:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18633617108</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/31 0:00:00_上午_产科张洪英</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130223199304060041</patientidcard><patientname>吴佳璇</patientname><patientsex>女</patientsex><patientbirthday>1993-04-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18633617108</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 19:10:40
记录内容：select * from  pat_master_index where id_no='130223199304060041' and name='吴佳璇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/4/6 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:10:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:10:40
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6535,'产科张洪英','上午','1','10288306','吴佳璇','WU JIA XUAN','女','32','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2025/01/29 19:10:37','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501316535','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 19:10:40
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6535,'产科张洪英','上午','1','10288306','吴佳璇','WU JIA XUAN','女','32','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2025/01/29 19:10:37','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501316535','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/31', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科张洪英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6535,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501316535</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501316535</pinkey><ordertime>2025-01-29 19:10:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 19:23:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15659397818</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_上午_普通外科普通号</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>350321196506226433</patientidcard><patientname>林金美</patientname><patientsex>男</patientsex><patientbirthday>1965-06-22</patientbirthday><medicalrecord></medicalrecord><contactphone>15659397818</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 19:23:06
记录内容：select * from  pat_master_index where id_no='350321196506226433' and name='林金美' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/6/22 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:23:06
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '普通外科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 19:23: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('2025/01/30','YYYY/MM/DD'),6540,'普通外科普通号','上午','1','10040663','林金美','','男','60','一般人员','自费','','普通号','1','0335','','1',to_date('2025/01/29 19:23:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306540','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 19:23:06
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6540,'普通外科普通号','上午','1','10040663','林金美','','男','60','一般人员','自费','','普通号','1','0335','','1',to_date('2025/01/29 19:23:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306540','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6540,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '普通外科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501306540</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306540</pinkey><ordertime>2025-01-29 19:23:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 20:09:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18683297059</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_白天_痤疮门诊普通号</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220722200610082423</patientidcard><patientname>崔冉</patientname><patientsex>女</patientsex><patientbirthday>2006-10-08</patientbirthday><medicalrecord></medicalrecord><contactphone>18683297059</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 20:09:38
记录内容：select * from  pat_master_index where id_no='220722200610082423' and name='崔冉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/10/8 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 20:09:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '痤疮门诊普通号' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 20:09: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('2025/01/30','YYYY/MM/DD'),6590,'痤疮门诊普通号','白天','3','10613949','崔冉','','女','19','一般人员','自费','','普通号','1','0318','','1',to_date('2025/01/29 20:09:35','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306590','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 20:09:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6590,'痤疮门诊普通号','白天','3','10613949','崔冉','','女','19','一般人员','自费','','普通号','1','0318','','1',to_date('2025/01/29 20:09:35','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306590','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '痤疮门诊普通号' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6590,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '痤疮门诊普通号' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501306590</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306590</pinkey><ordertime>2025-01-29 20:09:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 20:13:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18251602200</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_上午_普通外科王进</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>320322200011222238</patientidcard><patientname>李忍</patientname><patientsex>男</patientsex><patientbirthday>2000-11-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18251602200</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 20:13:43
记录内容：select * from  pat_master_index where id_no='320322200011222238' and name='李忍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/11/22 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 20:13:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '普通外科王进' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 20:13:43
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6591,'普通外科王进','上午','1','100466966','李忍','LI REN ','男','25','一般人员','自费','','副主任号','1','0335','WJ01','1',to_date('2025/01/29 20:13:40','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501306591','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 20:13:44
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6591,'普通外科王进','上午','1','100466966','李忍','LI REN ','男','25','一般人员','自费','','副主任号','1','0335','WJ01','1',to_date('2025/01/29 20:13:40','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501306591','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科王进' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6591,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '普通外科王进' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501306591</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501306591</pinkey><ordertime>2025-01-29 20:13:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 20:52:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18713036056</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/4 0:00:00_上午_消化内科吴东方</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199608162014</patientidcard><patientname>李强</patientname><patientsex>男</patientsex><patientbirthday>1996-08-16</patientbirthday><medicalrecord></medicalrecord><contactphone>18713036056</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 20:52:04
记录内容：select * from  pat_master_index where id_no='131028199608162014' and name='李强' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/8/16 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 20:52:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/04','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 20:52:04
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/04','YYYY/MM/DD'),6634,'消化内科吴东方','上午','2','100426526','李强','LI QIANG ','男','29','一般人员','自费','','CY知名专','1','0302','CYWDF','1',to_date('2025/01/29 20:52:01','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202502046634','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 20:52:04
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/04','YYYY/MM/DD'),6634,'消化内科吴东方','上午','2','100426526','李强','LI QIANG ','男','29','一般人员','自费','','CY知名专','1','0302','CYWDF','1',to_date('2025/01/29 20:52:01','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202502046634','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/02/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科吴东方' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/04','YYYY/MM/DD'),6634,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/04','yyyy/mm/dd')
                    and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202502046634</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202502046634</pinkey><ordertime>2025-01-29 20:52:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 21:15:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18611841315</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/31 0:00:00_上午_心血管内陶林森普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152827196004223021</patientidcard><patientname>郭凤珍</patientname><patientsex>女</patientsex><patientbirthday>1960-04-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18611841315</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 21:15:08
记录内容：select * from  pat_master_index where id_no='152827196004223021' and name='郭凤珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1960/4/22 0:00:0065
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 21:15:08
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 21:15:08
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6671,'心血管内陶林森普','上午','3','00336301','郭凤珍','GUO FENG ZHEN','女','65','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/01/29 21:15:04','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501316671','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 21:15:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6671,'心血管内陶林森普','上午','3','00336301','郭凤珍','GUO FENG ZHEN','女','65','一般人员','自费','','普通号','1','0359','TAOLS','1',to_date('2025/01/29 21:15:04','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501316671','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/31', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内陶林森普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/31','YYYY/MM/DD'),6671,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/31','yyyy/mm/dd')
                    and clinic_label = '心血管内陶林森普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501316671</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501316671</pinkey><ordertime>2025-01-29 21:15:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-29 23:37:23
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18730609262</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/30 0:00:00_白天_妇科丁圆</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200506103545</patientidcard><patientname>董欣然</patientname><patientsex>女</patientsex><patientbirthday>2005-06-10</patientbirthday><medicalrecord></medicalrecord><contactphone>18730609262</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-29 23:37:23
记录内容：select * from  pat_master_index where id_no='131028200506103545' and name='董欣然' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/6/10 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 23:37:23
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-29 23:37:23
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6804,'妇科丁圆','白天','5','100466970','董欣然','DONG XIN RAN ','女','20','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 23:37:19','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306804','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-29 23:37:23
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6804,'妇科丁圆','白天','5','100466970','董欣然','DONG XIN RAN ','女','20','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2025/01/29 23:37:19','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501306804','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('2025/01/30', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科丁圆' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/30','YYYY/MM/DD'),6804,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/30','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501306804</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501306804</pinkey><ordertime>2025-01-29 23:37:23</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆