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
}
