public static int JudgeValueForXCG(DataTable dttv, xuechangguiBean xcg) { int flag = 1; if (rangeJudgeForXCGInfo.dttv != null) { rangeJudgeForXCGInfo.dttv.Clear(); } rangeJudgeForXCGInfo.dttv = dttv.Copy(); flag = rangeJudgeForXCGInfo.GetResultXCG("WBC", xcg.WBC); if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("RBC", xcg.RBC); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("PCT", xcg.PCT); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("PLT", xcg.PLT); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("HGB", xcg.HGB); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("HCT", xcg.HCT); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MCV", xcg.MCV); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MCH", xcg.MCH); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MCHC", xcg.MCHC); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("RDWCV", xcg.RDW_CV); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("RDWSD", xcg.RDW_SD); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("NEUT", xcg.NEUT); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("NEUTP", xcg.NEUTP); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("LYM", xcg.LYM); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("LYMP", xcg.LYMP); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MPV", xcg.MPV); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("PDW", xcg.PDW); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MXD", xcg.MXD); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MXDP", xcg.MXDP); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("P-LCR", xcg.PLCR); if (a > flag) { flag = a; } } if (Common._deviceModel.Contains("XCG_KBE_003")) { if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MONC", xcg.MONO); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("MONP", xcg.MONOP); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("GRAC", xcg.GRAN); if (a > flag) { flag = a; } } if (flag <= 2) { int a = rangeJudgeForXCGInfo.GetResultXCG("GRAP", xcg.GRANP); if (a > flag) { flag = a; } } } return(flag); }
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(""); } }