private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
//string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
Func.WriteLog("backgroundWorker1_DoWork", "\\interface_his_log\\");
Func func1 = new Func();
StringBuilder msg = new StringBuilder();
if (dt_zysf.Rows.Count > 0)
{
for (int i = 0; i < dt_zysf.Rows.Count; i++)
{
string rcpt_no = dt_zysf.Rows[i][0].ToString();
string health_evn_id = dt_zysf.Rows[i][1].ToString();
int ret = func1.DC_Payment("4", rcpt_no, health_evn_id, msg);
if (1 == ret)
{
string sql_update5 = string.Format("update pat_visit set flag = '5' where health_evn_id = '{0}'", health_evn_id);
BaseDB.spExecuteNonQuery(sql_update5);
Func.WriteLog("住院收费确认信息：" + health_evn_id, "\\interface_his_log\\");
}
else
{
string sql_update1 = string.Format("update pat_visit set flag = '1' where health_evn_id = '{0}'", health_evn_id);
BaseDB.spExecuteNonQuery(sql_update1);
Func.WriteLog("住院收费确认发送给舒心就医平台时出错！ " + health_evn_id, "\\interface_his_log\\");
}
}
}
}
private void bgw_opconfirm_DoWork(object sender, DoWorkEventArgs e)
{
string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
StringBuilder msg = new StringBuilder();
string sql_opconfirm = string.Format("select '0' in_type,clinic_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)", dt_datetime);
dt_opconfirm = BaseDB.textExecuteDataset(sql_opconfirm);
#region 门诊就诊确认
if (dt_opconfirm.Rows.Count > 0)
{
foreach (DataRow dr in dt_opconfirm.Rows)
{
string in_type = dr[0].ToString();
string in_patientstrno = dr[1].ToString();
int ret = new Func().DC_opconfirm(in_type, in_patientstrno, msg);
if (1 == ret)
{
string sql = string.Format("update clinic_master a set a.flag = '5' where clinic_no = '{0}'", in_patientstrno);
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("门诊就诊确认信息：" + in_patientstrno, "\\interface_his_log\\");
}
else
{
Func.WriteLog("门诊就诊确认发送给舒心就医平台时出错！" + in_patientstrno, "\\interface_his_log\\");
}
}
}
else
{
Thread.Sleep(3000);
}
#endregion
}
private void bgw_ipconfirm_DoWork(object sender, DoWorkEventArgs e)
{
string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
StringBuilder msg = new StringBuilder();
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'", dt_datetime);
dt_ipconfirm = BaseDB.textExecuteDataset(sql_ipconfirm);
#region 住院就诊确认
if (dt_ipconfirm.Rows.Count > 0)
{
foreach (DataRow dr in dt_ipconfirm.Rows)
{
string in_patientstrno = dr[0].ToString();
int ret = new Func().DC_ipconfirm(in_patientstrno, msg);
if (1 == ret)
{
string sql = string.Format("update pat_visit a set a.flag = '5' where 'P'||a.patient_id||'V'||a.visit_id = '{0}'", in_patientstrno);
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("住院就诊确认信息：" + in_patientstrno, "\\interface_his_log\\");
}
else
{
Func.WriteLog("住院就诊确认发送给舒心就医平台时出错！" + in_patientstrno, "\\interface_his_log\\");
}
}
}
else
{
Thread.Sleep(3000);
}
#endregion
}
private void bgw_checkin_DoWork(object sender, DoWorkEventArgs e)
{
string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
StringBuilder msg = new StringBuilder();
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 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);
#region 就诊登记
if (dt_checkin.Rows.Count > 0)
{
foreach (DataRow dr in dt_checkin.Rows)
{
string in_type = dr[0].ToString();
string in_patientstrno = dr[1].ToString();
int ret = new Func().DC_CheckIn(in_type, in_patientstrno, msg);
if (1 == ret)
{
string sql = string.Empty;
if ("0" == in_type)
{
sql = string.Format("update clinic_master a set a.flag = '1' where to_char(a.visit_date,'yyyymmdd')||a.visit_no = '{0}'", in_patientstrno);
}
else
{
sql = string.Format("update pat_visit a set a.flag = '1' where 'P'||a.patient_id||'V'||a.visit_id = '{0}'", in_patientstrno);
}
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("就诊登记信息：" + in_patientstrno, "\\interface_his_log\\");
}
else
{
string sql = string.Empty;
if ("0" == in_type)
{
sql = string.Format("update clinic_master a set a.flag = '2' where to_char(a.visit_date,'yyyymmdd')||a.visit_no = '{0}'", in_patientstrno);
}
else
{
sql = string.Format("update pat_visit a set a.flag = '2' where 'P'||a.patient_id||'V'||a.visit_id = '{0}'", in_patientstrno);
}
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("就诊登记信息发送给舒心就医平台时出错！" + in_patientstrno, "\\interface_his_log\\");
}
}
}
else
{
Thread.Sleep(3000);
}
#endregion
}
/*
* private void load_fileinfo()
* {
* 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);
* dgv_fileinfo.DataSource = dt_fileinfo;
* }
* private void load_checkin()
* {
* string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
*
* 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 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 and rownum <10", dt_datetime);
* dt_checkin = BaseDB.textExecuteDataset(sql_checkin);
* dgv_checkin.DataSource = dt_checkin;
* }
* private void load_ipconfirm()
* {
* string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
*
* 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);
* dgv_ipconfirm.DataSource = dt_ipconfirm;
* }
* private void load_opconfirm()
* {
* string dt_datetime = inifile.IniReadValue("setting", "start_date", System.DateTime.Now.ToString("yyyy-MM-dd"));
*
* 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);
* dgv_opconfirm.DataSource = dt_opconfirm;
* }
*/
private void bgw_fileinfo_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", dt_datetime);
dt_fileinfo = BaseDB.textExecuteDataset(sql_fileinfo);
#region 个人档案
Func func1 = new Func();
StringBuilder msg = new StringBuilder();
if (dt_fileinfo.Rows.Count > 0)
{
foreach (DataRow dr in dt_fileinfo.Rows)
{
string pid = dr[0].ToString();
string op_name = dr[1].ToString();
string id_no = dr[2].ToString();
// 查询建档信息
int is_addfile = func1.DC_File_Query(id_no, msg);
if (1 == is_addfile)
{
string sql = string.Format("update pat_master_index a set a.flag = '1' where a.patient_id = '{0}'", pid);
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("已建档：" + pid, "\\interface_his_log\\");
}
else
{
int ret = func1.DC_File_Add(pid, op_name, msg);
if (1 == ret)
{
string sql = string.Format("update pat_master_index a set a.flag = '1' where a.patient_id = '{0}'", pid);
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("个人档案信息：" + pid, "\\interface_his_log\\");
}
else
{
string sql = string.Format("update pat_master_index a set a.flag = '2' where a.patient_id = '{0}'", pid);
BaseDB.spExecuteNonQuery(sql);
Func.WriteLog("个人档案信息发送给舒心就医平台时出错！" + pid, "\\interface_his_log\\");
}
}
}
}
else
{
Thread.Sleep(3000);
}
#endregion
}
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
}
