◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-04-14 11:17:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18101342757</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/4/21 0:00:00_下午_消化内科黄婷婷</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>421023198601023479</patientidcard><patientname>黄佳</patientname><patientsex>男</patientsex><patientbirthday>1986-01-02</patientbirthday><medicalrecord></medicalrecord><contactphone>18101342757</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-04-14 11:17:50
记录内容：select * from  pat_master_index where id_no='421023198601023479' and name='黄佳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/1/2 0:00:0040
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-14 11:17:50
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/21','yyyy/mm/dd')
                    and clinic_label = '消化内科黄婷婷' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-04-14 11:17: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/04/21','YYYY/MM/DD'),6305,'消化内科黄婷婷','下午','1','100345346','黄佳','HUANG JIA ','男','40','一般人员','自费','','普通号','1','0302','HTT','1',to_date('2026/04/14 11:17:55','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604216305','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-04-14 11:17: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/04/21','YYYY/MM/DD'),6305,'消化内科黄婷婷','下午','1','100345346','黄佳','HUANG JIA ','男','40','一般人员','自费','','普通号','1','0302','HTT','1',to_date('2026/04/14 11:17:55','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202604216305','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/04/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科黄婷婷' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/04/21','YYYY/MM/DD'),6305,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/04/21','yyyy/mm/dd')
                    and clinic_label = '消化内科黄婷婷' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202604216305</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202604216305</pinkey><ordertime>2026-04-14 11:17:50</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆