/// <summary>
/// 改变时候触发
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
/// <remarks>创建人员(日期): ★刘腾飞★(100202 18:16)</remarks>
public static void OnChangedForXinDianTu(object source, FileSystemEventArgs e)
{
//if (e.ChangeType == WatcherChangeTypes.Changed)
//{
// List<string> orderIdList = new List<string>();
try
{
//1.由于客户机器首次读取时乱码，故先修改该文件后再读取内容
//m_watcherAoup.EnableRaisingEvents = false;
try
{
File.SetLastWriteTime(e.FullPath, DateTime.Now); //修改txt文件的时间
#region 心电图
XmlDocument doc = new XmlDocument();
doc.Load(e.FullPath);
XmlNode xNode = doc.SelectSingleNode("zqecg/base/time");
string time = xNode.InnerText;
time = DateTime.Parse(time).ToString("yyyyMMddHHmmss");
XmlNode id = doc.SelectSingleNode("zqecg/patient/id");
string ids = id.InnerText;
XmlNode baseline_drift = doc.SelectSingleNode("zqecg/record/baseline_drift");
string baseline_drifts = baseline_drift.InnerText;
XmlNode myoelectricity = doc.SelectSingleNode("zqecg/record/myoelectricity");
string myoelectricitys = myoelectricity.InnerText;
XmlNode frequency = doc.SelectSingleNode("zqecg/record/frequency");
string frequencys = frequency.InnerText;
XmlNode hr = doc.SelectSingleNode("zqecg/measure/hr");
string hrs = hr.InnerText;
XmlNode pr = doc.SelectSingleNode("zqecg/measure/pr");
string prs = pr.InnerText;
XmlNode qrs = doc.SelectSingleNode("zqecg/measure/qrs");
string qrss = qrs.InnerText;
XmlNode qt_ = doc.SelectSingleNode("zqecg/measure/qt_");
string qt_s = qt_.InnerText;
XmlNode qtc = doc.SelectSingleNode("zqecg/measure/qtc");
string qtcs = qtc.InnerText;
XmlNode p_ = doc.SelectSingleNode("zqecg/measure/p_");
string p_s = p_.InnerText;
XmlNode qrs_ = doc.SelectSingleNode("zqecg/measure/qrs_");
string qrs_s = qrs_.InnerText;
XmlNode t = doc.SelectSingleNode("zqecg/measure/t");
string ts = t.InnerText;
XmlNode rv5 = doc.SelectSingleNode("zqecg/measure/rv5");
string rv5s = rv5.InnerText;
XmlNode sv1 = doc.SelectSingleNode("zqecg/measure/sv1");
string sv1s = sv1.InnerText;
XmlNode diagnosis = doc.SelectSingleNode("zqecg/result/diagnosis");
string diagnosiss = diagnosis.InnerText;
XmlNode advicetext = doc.SelectSingleNode("zqecg/result/advicetext");
string advicetexts = advicetext.InnerText;
jkInfoDao jkInfoDao = new jkInfoDao();
DataTable data = jkInfoDao.selectjkInfoBybarcode(ids);
if (data != null && data.Rows.Count > 0)
{
string aichive_no = data.Rows[0]["aichive_no"].ToString();
string barcode = data.Rows[0]["bar_code"].ToString();
string id_number = data.Rows[0]["id_number"].ToString();
DataTable dtnum = jkInfoDao.queryChongfuXdtData(aichive_no, barcode);
advicetexts = advicetexts.Replace("在不知道病人的性别/年龄情况下做的诊断结论", "").Replace("---", "").Replace("***", "").Replace("~", "");
string issql = "";
MySqlParameter[] args = null;
string imgurl = id_number + "_" + time + ".jpg";
if (dtnum.Rows.Count < 1)
{
issql = "insert into zkhw_tj_xdt(id,aichive_no,id_number,bar_code,XdtResult,XdtDesc,XdtDoctor,PR,QRS,QT,QTc,hr,p,pqrs,t,rv5,sv1,baseline_drift,myoelectricity,frequency,createtime,imageUrl) values(@id,@aichive_no,@id_number,@bar_code,@XdtResult,@XdtDesc,@XdtDoctor,@PR,@QRS,@QT,@QTc,@hr,@p,@pqrs,@t,@rv5,@sv1,@baseline_drift,@myoelectricity,@frequency,@createtime,@imageUrl)";
args = new MySqlParameter[] {
new MySqlParameter("@id", Result.GetNewId()),
new MySqlParameter("@aichive_no", data.Rows[0]["aichive_no"].ToString()),
new MySqlParameter("@id_number", data.Rows[0]["id_number"].ToString()),
new MySqlParameter("@bar_code", data.Rows[0]["bar_code"].ToString()),
new MySqlParameter("@XdtResult", diagnosiss),
new MySqlParameter("@XdtDesc", advicetexts),
new MySqlParameter("@XdtDoctor", basicInfoSettings.xdt),
new MySqlParameter("@PR", prs),
new MySqlParameter("@QRS", qrss),
new MySqlParameter("@QT", qt_s),
new MySqlParameter("@QTc", qtcs),
new MySqlParameter("@hr", hrs),
new MySqlParameter("@p", p_s),
new MySqlParameter("@pqrs", qrs_s),
new MySqlParameter("@t", ts),
new MySqlParameter("@rv5", rv5s),
new MySqlParameter("@sv1", sv1s),
new MySqlParameter("@baseline_drift", baseline_drifts),
new MySqlParameter("@myoelectricity", myoelectricitys),
new MySqlParameter("@frequency", frequencys),
new MySqlParameter("@createtime", time),
new MySqlParameter("@imageUrl", imgurl)
};
}
else
{
string issql1 = "update zkhw_tj_xdt set XdtResult='" + diagnosiss + "',XdtDesc='" + advicetexts + "',PR='" + prs + "',QRS='" + qrss + "',QT='" + qt_s + "',QTc='" + qtcs + "',hr='" + hrs + "',p='" + p_s + "',pqrs='" + qrs_s + "',t='" + ts + "',rv5='" + rv5s + "',sv1='" + sv1s + "',baseline_drift='" + baseline_drifts + "',myoelectricity='" + myoelectricitys + "',frequency='" + frequencys + "',createtime='" + time + "',imageUrl='" + imgurl + "' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(issql1);
}
string pName = e.FullPath.Replace("xml", "jpg");
FileInfo inf = new FileInfo(pName);
try
{
if (File.Exists(str + "\\xdtImg\\" + imgurl))
{
File.Delete(str + "\\xdtImg\\" + imgurl);
GC.Collect();
}
}
catch {
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Application.StartupPath + "/log.txt", true))
{
sw.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + "\r\n" + "心电2次上传删除报错：" + imgurl);
}
}
inf.MoveTo(str + "\\xdtImg\\" + imgurl);
//inf.CopyTo(str + "\\xdtImg\\" + data.Rows[0]["aichive_no"].ToString() + "_" + ids + ".jpg");
string hxpl = (Int32.Parse(hrs) / 4).ToString().Trim();//计算呼吸频率
if (advicetexts.IndexOf("正常") > -1)
{
int run = DbHelperMySQL.ExecuteSql($"update physical_examination_record set cardiogram='1',cardiogram_img='{imgurl}',base_heartbeat='{hrs}',base_respiratory='{hxpl} ',examination_heart_rate='{hrs}' where aichive_no='{data.Rows[0]["aichive_no"].ToString()}'and bar_code= '{data.Rows[0]["bar_code"].ToString()}'");
string istruedgbc = "update zkhw_tj_bgdc set XinDian='1' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(istruedgbc);
}
else
{
if (advicetexts.Length >= 50)//限制健康体检表心电图检查结果长度50
{
advicetexts = advicetexts.Replace("异常心电图", "").Replace("窦性心律", "");
}
int run = DbHelperMySQL.ExecuteSql($"update physical_examination_record set cardiogram='2',cardiogram_memo='{advicetexts}',cardiogram_img='{imgurl}',base_heartbeat='{hrs}',base_respiratory='{hxpl} ',examination_heart_rate='{hrs}' where aichive_no='{data.Rows[0]["aichive_no"].ToString()}'and bar_code= '{data.Rows[0]["bar_code"].ToString()}'");
string issqdgbc = "update zkhw_tj_bgdc set XinDian='3' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(issqdgbc);
}
if (issql != "")
{
int rue = DbHelperMySQL.ExecuteSql(issql, args);
}
}
#endregion
}
catch (Exception ex)
{
// RegisterAoupTrackLog("文件被占用！正在请求重试 ... ");
MessageBox.Show(ex.StackTrace);
//进程阻塞2秒钟
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.StackTrace);
}
//}
}
public static void OnChangedForBChao1(object e)
{
int innum = 0;
try
{
selectXmlBcJudge(); //获取B超检查结果是否正常
//1.由于客户机器首次读取时乱码，故先修改该文件后再读取内容
//m_watcherAoup.EnableRaisingEvents = false;
File.SetLastWriteTime(e.ToString(), DateTime.Now); //修改txt文件的时间
#region B超
XmlDocument doc = new XmlDocument();
doc.Load(e.ToString());
XmlNodeList xNode = doc.SelectNodes("//Report[@Index='图片信息']/图片信息");
string id = doc.SelectSingleNode("//Report[@Index='病人信息']/ID").InnerText.Trim();
string nam = doc.SelectSingleNode("//Report[@Index='基本信息']/报告名称").InnerText.Trim();
string cs = doc.SelectSingleNode("//Report[@Index='超声诊断']/超声诊断").InnerText.Trim();
string csresult = "";
if (cs.Length > 0)
{
cs = cs.Replace("|", "").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "");
int num = cs.IndexOf("诊断结果");
if (num >= 0)
{
csresult = cs.Substring(num);
}
else
{
csresult = cs;
}
}
string BuPic01 = string.Empty;
string BuPic02 = string.Empty;
string BuPic03 = string.Empty;
string BuPic04 = string.Empty;
Thread.Sleep(5000);
GC.Collect();
innum = e.ToString().LastIndexOf("\\");
jkInfoDao jkInfoDao = new jkInfoDao();
DataTable data = jkInfoDao.selectjkInfoBybarcode(id);
if (data != null && data.Rows.Count > 0)
{
string aichive_no = data.Rows[0]["aichive_no"].ToString();
string barcode = data.Rows[0]["bar_code"].ToString();
string id_number = data.Rows[0]["id_number"].ToString();
if (xNode != null && xNode.Count > 0)
{
string fullPath = e.ToString().Substring(0, innum + 1);
for (int i = 0; i < xNode.Count; i++)
{
if (i == 0)
{
BuPic01 = xNode[i].InnerText;
string pName = fullPath + BuPic01;
FileInfo inf = new FileInfo(pName);
if (File.Exists(str + "\\bcImg\\" + id_number + "_" + BuPic01))
{
File.Delete(str + "\\bcImg\\" + id_number + "_" + BuPic01);
}
inf.MoveTo(str + "\\bcImg\\" + id_number + "_" + BuPic01);
}
else if (i == 1)
{
BuPic02 = xNode[i].InnerText;
string pName = fullPath + BuPic02;
FileInfo inf = new FileInfo(pName);
if (File.Exists(str + "\\bcImg\\" + id_number + "_" + BuPic02))
{
File.Delete(str + "\\bcImg\\" + id_number + "_" + BuPic02);
}
inf.MoveTo(str + "\\bcImg\\" + id_number + "_" + BuPic02);
}
else if (i == 2)
{
BuPic03 = xNode[i].InnerText;
string pName = fullPath + BuPic03;
FileInfo inf = new FileInfo(pName);
if (File.Exists(str + "\\bcImg\\" + id_number + "_" + BuPic03))
{
File.Delete(str + "\\bcImg\\" + id_number + "_" + BuPic03);
}
inf.MoveTo(str + "\\bcImg\\" + id_number + "_" + BuPic03);
}
else if (i == 3)
{
BuPic04 = xNode[i].InnerText;
string pName = fullPath + BuPic04;
FileInfo inf = new FileInfo(pName);
if (File.Exists(str + "\\bcImg\\" + id_number + "_" + BuPic04))
{
File.Delete(str + "\\bcImg\\" + id_number + "_" + BuPic04);
}
inf.MoveTo(str + "\\bcImg\\" + id_number + "_" + BuPic04);
}
}
}
DataTable dtnum = jkInfoDao.queryChongfuBcData(aichive_no, barcode);
string issql = "";
MySqlParameter[] args = null;
if (!string.IsNullOrWhiteSpace(BuPic01))
{
BuPic01 = id_number + "_" + BuPic01;
}
if (!string.IsNullOrWhiteSpace(BuPic02))
{
BuPic02 = id_number + "_" + BuPic02;
}
if (dtnum.Rows.Count < 1)
{
issql = "insert into zkhw_tj_bc(id,aichive_no,id_number,bar_code,FubuResult,FubuBC,BuPic01,BuPic02,createtime,ZrysBC) values(@id,@aichive_no,@id_number,@bar_code,@FubuResult,@FubuBC,@BuPic01,@BuPic02,@createtime,@ZrysBC)";
args = new MySqlParameter[] {
new MySqlParameter("@id", Result.GetNewId()),
new MySqlParameter("@aichive_no", data.Rows[0]["aichive_no"].ToString()),
new MySqlParameter("@id_number", data.Rows[0]["id_number"].ToString()),
new MySqlParameter("@bar_code", data.Rows[0]["bar_code"].ToString()),
new MySqlParameter("@FubuResult", cs),
new MySqlParameter("@FubuBC", nam),
new MySqlParameter("@BuPic01", BuPic01),
new MySqlParameter("@BuPic02", BuPic02),
new MySqlParameter("@createtime", DateTime.Now),
new MySqlParameter("@ZrysBC", basicInfoSettings.bc)
};
}
else
{
string issql1 = "update zkhw_tj_bc set FubuResult= '" + cs + "',FubuBC= '" + nam + "',BuPic01= '" + BuPic01 + "',BuPic02= '" + BuPic02 + "' where aichive_no = '" + data.Rows[0]["aichive_no"].ToString() + "' and bar_code='" + data.Rows[0]["bar_code"].ToString() + "'";
DbHelperMySQL.ExecuteSql(issql1);
}
if (!string.IsNullOrWhiteSpace(BuPic01))
{
BuPic01 = id_number + "_" + BuPic01;
}
if (bcJudge != "" && bcJudge.Length >= 10)
{
string[] bcJudgeArray = bcJudge.Split('#');
if (bcJudgeArray.Length > 0)
{
bool istrue = false;
for (int i = 0; i < bcJudgeArray.Length; i++)
{
if (cs.IndexOf(bcJudgeArray[i]) > -1)
{
istrue = true;
break;
}
}
if (istrue)
{
int run = DbHelperMySQL.ExecuteSql($"update physical_examination_record set ultrasound_abdomen='1',abdomenB_img='{BuPic01}' where aichive_no='{data.Rows[0]["aichive_no"].ToString()}'");
string issqdgbc = "update zkhw_tj_bgdc set BChao='1' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(issqdgbc);
}
else
{
int run = DbHelperMySQL.ExecuteSql($"update physical_examination_record set ultrasound_abdomen='2',ultrasound_memo='{csresult}',abdomenB_img='{BuPic01}' where aichive_no='{data.Rows[0]["aichive_no"].ToString()}'");
string issqdgbc = "update zkhw_tj_bgdc set BChao='3' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(issqdgbc);
}
}
}
else
{
if (cs.IndexOf("肝,胆,胰,脾未见异常") > -1 || cs.IndexOf("未见明显异常") > -1)
{
int run = DbHelperMySQL.ExecuteSql($"update physical_examination_record set ultrasound_abdomen='1',abdomenB_img='{BuPic01}' where aichive_no='{data.Rows[0]["aichive_no"].ToString()}'");
string issqdgbc = "update zkhw_tj_bgdc set BChao='1' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(issqdgbc);
}
else
{
int run = DbHelperMySQL.ExecuteSql($"update physical_examination_record set ultrasound_abdomen='2',ultrasound_memo='{csresult}',abdomenB_img='{BuPic01}' where aichive_no='{data.Rows[0]["aichive_no"].ToString()}'");
string issqdgbc = "update zkhw_tj_bgdc set BChao='3' where aichive_no = '" + aichive_no + "' and bar_code='" + barcode + "'";
DbHelperMySQL.ExecuteSql(issqdgbc);
}
}
if (issql != "")
{
int rue = DbHelperMySQL.ExecuteSql(issql, args);
}
Thread.Sleep(400);
string filepath = e.ToString().Substring(0, innum);
DeleteDir1(filepath);
//插入数据库
}
else
{
Thread.Sleep(400);
innum = e.ToString().LastIndexOf("\\");
string filepath = e.ToString().Substring(0, innum);
DeleteDir1(filepath);
}
#endregion
}
catch (Exception ex)
{
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Application.StartupPath + "/log.txt", true))
{
sw.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + ex.Message + "\r\n" + ex.StackTrace);
}
innum = e.ToString().LastIndexOf("\\");
string filepath = e.ToString().Substring(0, innum);
DeleteDir1(filepath);
}
}
public static void OnChangedForxcg(object source, FileSystemEventArgs e)
{
xmlDoc.Load(path);
node = xmlDoc.SelectSingleNode("config/xuechangguiPath");
xuechangguipath = node.InnerText;
xmlDoc.Load(path);
node = xmlDoc.SelectSingleNode("config/xcglasttime");
lasttime = node.InnerText;
// string sql1 = "select lop.patient_id,lop.send_time,lopr.* from LisOutput lop, LisOutputResult lopr where lop.sample_id=lopr.sample_id and lop.sample_id=(select top 1 l.sample_id from LisOutput l order by l.sample_id desc)";
string sql1 = "select sample_id,patient_id,send_time from LisOutput where send_time > cdate('" + lasttime + "')";
DataTable arr_dt1 = getXuechanggui(sql1).Tables[0];
if (arr_dt1.Rows.Count > 0)
{
for (int j = 0; j < arr_dt1.Rows.Count; j++)
{
string sql2 = "select lop.patient_id,lop.send_time,lopr.* from LisOutput lop, LisOutputResult lopr where lop.sample_id=lopr.sample_id and lop.sample_id='" + arr_dt1.Rows[j]["sample_id"].ToString() + "'";
DataTable arr_dt2 = getXuechanggui(sql2).Tables[0];
if (arr_dt2.Rows.Count > 0)
{
xuechangguiBean xcg = new xuechangguiBean();
xcg.bar_code = arr_dt1.Rows[0]["patient_id"].ToString();
DataTable dtjkinfo = jkdao.selectjkInfoBybarcode(xcg.bar_code);
if (dtjkinfo != null && dtjkinfo.Rows.Count > 0)
{
xcg.aichive_no = dtjkinfo.Rows[0]["aichive_no"].ToString();
xcg.id_number = dtjkinfo.Rows[0]["id_number"].ToString();
}
else
{
return;
}
DateTime newtime = Convert.ToDateTime(arr_dt1.Rows[0]["send_time"].ToString());
DateTime oldtime = Convert.ToDateTime(lasttime);
if (newtime <= oldtime)
{
return;
}
xcg.createTime = newtime.ToString("yyyy-MM-dd HH:mm:ss");
for (int i = 0; i < arr_dt2.Rows.Count; i++)
{
string item = arr_dt2.Rows[i]["item"].ToString();
switch (item)
{
case "HCT": xcg.HCT = arr_dt2.Rows[i]["result"].ToString(); break;
case "HGB": xcg.HGB = arr_dt2.Rows[i]["result"].ToString(); break;
case "LYM#": xcg.LYM = arr_dt2.Rows[i]["result"].ToString(); break;
case "LYM%": xcg.LYMP = arr_dt2.Rows[i]["result"].ToString(); break;
case "MCH": xcg.MCH = arr_dt2.Rows[i]["result"].ToString(); break;
case "MCHC": xcg.MCHC = arr_dt2.Rows[i]["result"].ToString(); break;
case "MCV": xcg.MCV = arr_dt2.Rows[i]["result"].ToString(); break;
case "MPV": xcg.MPV = arr_dt2.Rows[i]["result"].ToString(); break;
case "MXD#": xcg.MXD = arr_dt2.Rows[i]["result"].ToString(); break;
case "MXD%": xcg.MXDP = arr_dt2.Rows[i]["result"].ToString(); break;
case "NEUT#": xcg.NEUT = arr_dt2.Rows[i]["result"].ToString(); break;
case "NEUT%": xcg.NEUTP = arr_dt2.Rows[i]["result"].ToString(); break;
case "PCT": xcg.PCT = arr_dt2.Rows[i]["result"].ToString(); break;
case "PDW": xcg.PDW = arr_dt2.Rows[i]["result"].ToString(); break;
case "PLT": xcg.PLT = arr_dt2.Rows[i]["result"].ToString(); break;
case "RBC": xcg.RBC = arr_dt2.Rows[i]["result"].ToString(); break;
case "RDW_CV": xcg.RDW_CV = arr_dt2.Rows[i]["result"].ToString(); break;
case "RDW_SD": xcg.RDW_SD = arr_dt2.Rows[i]["result"].ToString(); break;
case "WBC": xcg.WBC = arr_dt2.Rows[i]["result"].ToString(); break;
default: break;
}
}
bool istrue = tjdao.insertXuechangguiInfo(xcg);
if (istrue)
{
xmlDoc.Load(path);
XmlNode node;
node = xmlDoc.SelectSingleNode("config/xcglasttime");
node.InnerText = xcg.createTime;
xmlDoc.Save(path);
tjdao.updateTJbgdcXuechanggui(xcg.aichive_no, xcg.bar_code, 1);
tjdao.updatePEXcgInfo(xcg.aichive_no, xcg.bar_code, xcg.HGB, xcg.WBC, xcg.PLT);
}
}
}
}
else
{
//MessageBox.Show("");
}
}