Beispiel #1
0
        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);
        }
Beispiel #2
0
        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("");
            }
        }