◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 00:25: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('2020/05/13','YYYY/MM/DD'),6090,'皮肤科普通号','白天','1','10344094','李丹丹','','女','35','一般人员','自费','','普通号','1','0318','','1',to_date('2020/05/12 00:25:09','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005136090','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 00:25: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('2020/05/13','YYYY/MM/DD'),6090,'皮肤科普通号','白天','1','10344094','李丹丹','','女','35','一般人员','自费','','普通号','1','0318','','1',to_date('2020/05/12 00:25:09','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005136090','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科普通号' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6090,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '皮肤科普通号' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005136090</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005136090</pinkey><ordertime>2020-05-12 00:25:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 07:48:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/18','YYYY/MM/DD'),6231,'心理咨询张庆彬','白天','5','100121427','贾丹','JIA DAN ','女','26','一般人员','自费','','副主任号','1','0360','ZHANGQB','1',to_date('2020/05/12 07:48:04','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005186231','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 07:48:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/18','YYYY/MM/DD'),6231,'心理咨询张庆彬','白天','5','100121427','贾丹','JIA DAN ','女','26','一般人员','自费','','副主任号','1','0360','ZHANGQB','1',to_date('2020/05/12 07:48:04','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005186231','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张庆彬' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/18','YYYY/MM/DD'),6231,'13:00-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/18','yyyy/mm/dd')
                    and clinic_label = '心理咨询张庆彬' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005186231</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005186231</pinkey><ordertime>2020-05-12 07:48:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 08:22:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6493,'儿科刘双英','上午','1','100121522','贾依宸','JIA YI  ','女','1','一般人员','自费','','知名专家','1','0304','LIUSY','1',to_date('2020/05/12 08:22:29','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005136493','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 08:22:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6493,'儿科刘双英','上午','1','100121522','贾依宸','JIA YI  ','女','1','一般人员','自费','','知名专家','1','0304','LIUSY','1',to_date('2020/05/12 08:22:29','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005136493','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘双英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6493,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '儿科刘双英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005136493</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202005136493</pinkey><ordertime>2020-05-12 08:22:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 08:24:14
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6537,'眼科张仲臣特需号','上午','6','100121523','吕以进','LV YI JIN ','男','-19','一般人员','自费','','特需号2','1','0327','ZHANGZC','1',to_date('2020/05/12 08:24:13','yyyy/mm/dd hh24:mi:ss'),'96','4','0.00','100','202005136537','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 08:24:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6537,'眼科张仲臣特需号','上午','6','100121523','吕以进','LV YI JIN ','男','-19','一般人员','自费','','特需号2','1','0327','ZHANGZC','1',to_date('2020/05/12 08:24:13','yyyy/mm/dd hh24:mi:ss'),'96','4','0.00','100','202005136537','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科张仲臣特需号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6537,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '眼科张仲臣特需号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005136537</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>96</registrationfee><pinkey>202005136537</pinkey><ordertime>2020-05-12 08:24:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 08:30:01
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/16','YYYY/MM/DD'),6638,'妇科董秀华','白天','6','10344094','李丹丹','','女','35','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/12 08:30:01','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005166638','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 08:30: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('2020/05/16','YYYY/MM/DD'),6638,'妇科董秀华','白天','6','10344094','李丹丹','','女','35','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/12 08:30:01','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005166638','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科董秀华' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/16','YYYY/MM/DD'),6638,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/16','yyyy/mm/dd')
                    and clinic_label = '妇科董秀华' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005166638</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005166638</pinkey><ordertime>2020-05-12 08:30:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 08:45:39
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/18','YYYY/MM/DD'),6946,'风湿免疫科王雁','白天','1','00369162','申银平','SHEN YIN PING','女','48','一般人员','自费','','知名专家','1','0337','WANGY1','1',to_date('2020/05/12 08:45:39','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005186946','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 08:45: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('2020/05/18','YYYY/MM/DD'),6946,'风湿免疫科王雁','白天','1','00369162','申银平','SHEN YIN PING','女','48','一般人员','自费','','知名专家','1','0337','WANGY1','1',to_date('2020/05/12 08:45:39','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005186946','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '风湿免疫科王雁' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/18','YYYY/MM/DD'),6946,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/18','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科王雁' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005186946</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202005186946</pinkey><ordertime>2020-05-12 08:45:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 08:59: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('2020/05/13','YYYY/MM/DD'),7238,'心血管一科卢长林','上午','1','100115693','王振成','WANG ZHEN CHENG ','男','67','一般人员','自费','','CY知名专','1','0307','CYLCL','1',to_date('2020/05/12 08:59:43','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005137238','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 08:59: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('2020/05/13','YYYY/MM/DD'),7238,'心血管一科卢长林','上午','1','100115693','王振成','WANG ZHEN CHENG ','男','67','一般人员','自费','','CY知名专','1','0307','CYLCL','1',to_date('2020/05/12 08:59:43','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005137238','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管一科卢长林' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),7238,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '心血管一科卢长林' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005137238</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202005137238</pinkey><ordertime>2020-05-12 08:59:44</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 09:06: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('2020/05/13','YYYY/MM/DD'),7387,'口腔科普通号','上午','2','10439798','付洛祺','','女','5','一般人员','自费','','普通号','1','0319','','1',to_date('2020/05/12 09:06:05','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005137387','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 09:06: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('2020/05/13','YYYY/MM/DD'),7387,'口腔科普通号','上午','2','10439798','付洛祺','','女','5','一般人员','自费','','普通号','1','0319','','1',to_date('2020/05/12 09:06:05','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005137387','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '口腔科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),7387,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '口腔科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005137387</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005137387</pinkey><ordertime>2020-05-12 09:06:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 09:15: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('2020/05/19','YYYY/MM/DD'),7609,'妇科王振燕','白天','1','10247520','王惠芳','WANG HUI FANG','女','43','一般人员','自费','','主任号','1','0316','WZY','1',to_date('2020/05/12 09:15:46','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005197609','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 09:15: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('2020/05/19','YYYY/MM/DD'),7609,'妇科王振燕','白天','1','10247520','王惠芳','WANG HUI FANG','女','43','一般人员','自费','','主任号','1','0316','WZY','1',to_date('2020/05/12 09:15:46','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005197609','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王振燕' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/19','YYYY/MM/DD'),7609,'13:00-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/19','yyyy/mm/dd')
                    and clinic_label = '妇科王振燕' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005197609</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005197609</pinkey><ordertime>2020-05-12 09:15:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-12 09:21:28
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/13','YYYY-MM-DD')
            AND CLINIC_LABEL='神经内科崔韬' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='130528198407256024' and name='张瑶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 09:21:28
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-12 09:22:24
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/13','YYYY-MM-DD')
            AND CLINIC_LABEL='神经内科崔韬' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='130528198407256024' and name='张瑶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 09:22:24
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-12 09:22:58
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/13','YYYY-MM-DD')
            AND CLINIC_LABEL='神经内科崔韬' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='130528198407256024' and name='张瑶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 09:22:58
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 10:15: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('2020/05/13','YYYY/MM/DD'),9075,'妇科赵咏梅','白天','1','100121588','张盼丽','ZHANG PAN LI ','女','23','一般人员','自费','','副主任号','1','0316','ZHAOYM','1',to_date('2020/05/12 10:15:14','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005139075','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 10:15: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('2020/05/13','YYYY/MM/DD'),9075,'妇科赵咏梅','白天','1','100121588','张盼丽','ZHANG PAN LI ','女','23','一般人员','自费','','副主任号','1','0316','ZHAOYM','1',to_date('2020/05/12 10:15:14','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005139075','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科赵咏梅' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),9075,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '妇科赵咏梅' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005139075</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005139075</pinkey><ordertime>2020-05-12 10:15:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-12 10:20:46
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/13','YYYY-MM-DD')
            AND CLINIC_LABEL='眼科张仲臣特需号' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='132822197510221212' and name='郭洪凯' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 10:20:46
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 10:46:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),9708,'耳鼻喉科普通号','白天','1','Z00121584','海明虎','','男','34','一般人员','自费','','普通号','1','0306','','1',to_date('2020/05/12 10:46:33','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005139708','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 10:46:34
记录内容：<?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('2020/05/13','YYYY/MM/DD'),9708,'耳鼻喉科普通号','白天','1','Z00121584','海明虎','','男','34','一般人员','自费','','普通号','1','0306','','1',to_date('2020/05/12 10:46:33','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005139708','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科普通号' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),9708,'10:30-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科普通号' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005139708</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005139708</pinkey><ordertime>2020-05-12 10:46:34</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 10:49:41
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),9757,'口腔科普通号','上午','5','Z00121584','海明虎','','男','34','一般人员','自费','','普通号','1','0319','','1',to_date('2020/05/12 10:49:40','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005139757','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 10:49: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('2020/05/13','YYYY/MM/DD'),9757,'口腔科普通号','上午','5','Z00121584','海明虎','','男','34','一般人员','自费','','普通号','1','0319','','1',to_date('2020/05/12 10:49:40','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005139757','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '口腔科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),9757,'10:30-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '口腔科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005139757</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005139757</pinkey><ordertime>2020-05-12 10:49:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 10:58: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('2020/05/14','YYYY/MM/DD'),9900,'心血管一科卢长林','上午','1','100121606','郭翯颐','GUO LONG YI ','女','20','一般人员','自费','','CY知名专','1','0307','CYLCL','1',to_date('2020/05/12 10:58:47','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005149900','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 10:58: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('2020/05/14','YYYY/MM/DD'),9900,'心血管一科卢长林','上午','1','100121606','郭翯颐','GUO LONG YI ','女','20','一般人员','自费','','CY知名专','1','0307','CYLCL','1',to_date('2020/05/12 10:58:47','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005149900','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管一科卢长林' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/14','YYYY/MM/DD'),9900,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/14','yyyy/mm/dd')
                    and clinic_label = '心血管一科卢长林' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005149900</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202005149900</pinkey><ordertime>2020-05-12 10:58:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 11:05: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('2020/05/16','YYYY/MM/DD'),10,'妇科董秀华','白天','7','10417703','吉祥','','女','51','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/12 11:05:37','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005160010','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 11:05: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('2020/05/16','YYYY/MM/DD'),10,'妇科董秀华','白天','7','10417703','吉祥','','女','51','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/12 11:05:37','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005160010','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科董秀华' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/16','YYYY/MM/DD'),10,'13:00-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/16','yyyy/mm/dd')
                    and clinic_label = '妇科董秀华' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>2020051610</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>2020051610</pinkey><ordertime>2020-05-12 11:05:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 11:49: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('2020/05/19','YYYY/MM/DD'),618,'口腔科王涵','白天','4','100117295','李欣欣','LI XIN XIN ','女','26','一般人员','自费','','副主任号','1','0319','WH1','1',to_date('2020/05/12 11:49:36','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005190618','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 11:49: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('2020/05/19','YYYY/MM/DD'),618,'口腔科王涵','白天','4','100117295','李欣欣','LI XIN XIN ','女','26','一般人员','自费','','副主任号','1','0319','WH1','1',to_date('2020/05/12 11:49:36','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005190618','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '口腔科王涵' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/19','YYYY/MM/DD'),618,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/19','yyyy/mm/dd')
                    and clinic_label = '口腔科王涵' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>20200519618</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>20200519618</pinkey><ordertime>2020-05-12 11:49:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 11:54: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('2020/05/13','YYYY/MM/DD'),644,'骨科张晓刚','白天','2','100121611','葛胜男','GE SHENG NAN ','女','56','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2020/05/12 11:54:44','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005130644','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 11:54: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('2020/05/13','YYYY/MM/DD'),644,'骨科张晓刚','白天','2','100121611','葛胜男','GE SHENG NAN ','女','56','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2020/05/12 11:54:44','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005130644','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科张晓刚' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),644,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '骨科张晓刚' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>20200513644</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>20200513644</pinkey><ordertime>2020-05-12 11:54:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 12:35:30
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),815,'耳鼻喉科胡琦','白天','5','100119166','李淑英','LI SHU YING ','女','62','一般人员','自费','','主任号','1','0306','HUQI01','1',to_date('2020/05/12 12:35:29','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005130815','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 12:35:31
记录内容：<?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('2020/05/13','YYYY/MM/DD'),815,'耳鼻喉科胡琦','白天','5','100119166','李淑英','LI SHU YING ','女','62','一般人员','自费','','主任号','1','0306','HUQI01','1',to_date('2020/05/12 12:35:29','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005130815','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科胡琦' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),815,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科胡琦' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>20200513815</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>20200513815</pinkey><ordertime>2020-05-12 12:35:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-12 13:08:12
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/13','YYYY-MM-DD')
            AND CLINIC_LABEL='肿瘤科王鸣' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='511323200102084021' and name='黄涵渝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 13:08:12
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-12 13:09:55
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/13','YYYY-MM-DD')
            AND CLINIC_LABEL='肿瘤科王鸣' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='511323200102084021' and name='黄涵渝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 13:09:55
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 14:15: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('2020/05/13','YYYY/MM/DD'),1519,'骨科张晓刚','白天','3','100121629','林锦耀','LIN JIN YAO ','男','26','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2020/05/12 14:15:33','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005131519','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 14:15: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('2020/05/13','YYYY/MM/DD'),1519,'骨科张晓刚','白天','3','100121629','林锦耀','LIN JIN YAO ','男','26','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2020/05/12 14:15:33','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005131519','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科张晓刚' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),1519,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '骨科张晓刚' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005131519</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005131519</pinkey><ordertime>2020-05-12 14:15:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 14:39: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('2020/05/13','YYYY/MM/DD'),1774,'心血管一科卢长林','上午','3','100114662','劳亚民','LAO YA MIN','男','38','一般人员','自费','','CY知名专','1','0307','CYLCL','1',to_date('2020/05/12 14:39:25','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005131774','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 14:39: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('2020/05/13','YYYY/MM/DD'),1774,'心血管一科卢长林','上午','3','100114662','劳亚民','LAO YA MIN','男','38','一般人员','自费','','CY知名专','1','0307','CYLCL','1',to_date('2020/05/12 14:39:25','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005131774','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管一科卢长林' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),1774,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '心血管一科卢长林' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005131774</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202005131774</pinkey><ordertime>2020-05-12 14:39:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 15: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('2020/05/13','YYYY/MM/DD'),2089,'中医骨伤李国强','白天','1','100121640','贾凤菊','JIA FENG JU ','女','46','一般人员','自费','','副主任号','1','0301','LIGQ','1',to_date('2020/05/12 15:09:36','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005132089','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 15:09: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('2020/05/13','YYYY/MM/DD'),2089,'中医骨伤李国强','白天','1','100121640','贾凤菊','JIA FENG JU ','女','46','一般人员','自费','','副主任号','1','0301','LIGQ','1',to_date('2020/05/12 15:09:36','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005132089','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医骨伤李国强' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),2089,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '中医骨伤李国强' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005132089</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005132089</pinkey><ordertime>2020-05-12 15:09:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-12 15:19:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),2181,'皮肤科普通号','白天','3','100121643','李冠萱','LI GUAN  ','男','6','一般人员','自费','','普通号','1','0318','','1',to_date('2020/05/12 15:19:31','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005132181','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-12 15:19:34
记录内容：<?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('2020/05/13','YYYY/MM/DD'),2181,'皮肤科普通号','白天','3','100121643','李冠萱','LI GUAN  ','男','6','一般人员','自费','','普通号','1','0318','','1',to_date('2020/05/12 15:19:31','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005132181','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科普通号' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),2181,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '皮肤科普通号' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005132181</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005132181</pinkey><ordertime>2020-05-12 15:19:34</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆