private void bgw_loaddata_DoWork(object sender, DoWorkEventArgs e) { string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd")); string sql_fileinfo = string.Format("select t.patient_id,t.operator operator_name, t.id_no from pat_master_index t where t.create_date >= date'{0}' and t.charge_type <> '新生儿' and t.flag is null and t.id_no is not null and rownum<100 and rownum <10", dt_datetime); dt_fileinfo = BaseDB.textExecuteDataset(sql_fileinfo); string sql_checkin = string.Format("select '0' in_type,t.clinic_no in_patientstrno from clinic_master t where t.visit_date >= date'{0}' and t.registration_status = 2 and t.health_evn_id is null and t.flag is null and rownum <10 union select '1', 'P' || t.patient_id || 'V' || t.visit_id from pat_visit t where t.admission_date_time >= date'{0}' and t.health_evn_id is null and t.flag is null", dt_datetime); dt_checkin = BaseDB.textExecuteDataset(sql_checkin); string sql_ipconfirm = string.Format("select 'P'||t.patient_id||'V'||t.visit_id in_patientstrno from pat_visit t where t.admission_date_time >= date'{0}' and t.discharge_date_time is not null and t.health_evn_id is null and t.flag = '1' and rownum <10", dt_datetime); dt_ipconfirm = BaseDB.textExecuteDataset(sql_ipconfirm); string sql_opconfirm = string.Format("select '0' in_type,to_char(t.visit_date,'yyyymmdd')||t.visit_no in_patientstrno from clinic_master t where t.visit_date >= date'{0}' and t.flag = '1' and (t.visit_date,t.visit_no) in (select a.visit_date,a.visit_no from outp_wait_queue a where a.worked_indicator = 3 and rownum <10)", dt_datetime); dt_opconfirm = BaseDB.textExecuteDataset(sql_opconfirm); }
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { Func.WriteLog("backgroundWorker2_DoWork", "\\interface_his_log\\"); #region 门诊收费确认 // 门诊收费确认 Func func1 = new Func(); StringBuilder msg = new StringBuilder(); if (dt_mzsf.Rows.Count > 0) { // #region 循环取值 for (int i = 0; i < dt_mzsf.Rows.Count; i++) { string rcpt_no = dt_mzsf.Rows[i][0].ToString(); string health_evn_id = dt_mzsf.Rows[i][1].ToString(); int ret = func1.DC_Payment("1", rcpt_no, health_evn_id, msg); if (1 == ret) { string sql_update5 = string.Format("update outp_rcpt_master a set a.sxjy_flag = '5' where a.rcpt_no = '{0}'", rcpt_no); BaseDB.spExecuteNonQuery(sql_update5); Func.WriteLog("门诊收费确认信息:" + health_evn_id, "\\interface_his_log\\"); } else { string sql_update1 = string.Format("update outp_rcpt_master a set a.sxjy_flag = '1' where a.rcpt_no = '{0}'", rcpt_no); BaseDB.spExecuteNonQuery(sql_update1); Func.WriteLog("门诊收费确认发送给舒心就医平台时出错! " + health_evn_id, "\\interface_his_log\\"); } } #endregion } else { Thread.Sleep(3000); } #endregion }