Пример #1
0
        private void button5_Click(object sender, EventArgs e)
        {
            string WBC    = this.textBox5.Text;
            string RBC    = this.textBox6.Text;
            string PCT    = this.textBox8.Text;
            string PLT    = this.textBox7.Text;
            string HGB    = this.textBox11.Text;
            string HCT    = this.textBox10.Text;
            string MCV    = this.textBox13.Text;
            string MCH    = this.textBox12.Text;
            string MCHC   = this.textBox15.Text;
            string RDWCV  = this.textBox14.Text;
            string RDWSD  = this.textBox17.Text;
            string MONO   = this.textBox16.Text;
            string MONOP  = this.textBox19.Text;
            string GRAN   = this.textBox18.Text;
            string GRANP  = this.textBox21.Text;
            string NEUT   = this.textBox20.Text;
            string NEUTP  = this.textBox23.Text;
            string EO     = this.textBox22.Text;
            string EOP    = this.textBox25.Text;
            string BASO   = this.textBox24.Text;
            string BASOP  = this.textBox29.Text;
            string LYM    = this.textBox28.Text;
            string LYMP   = this.textBox31.Text;
            string MPV    = this.textBox30.Text;
            string PDW    = this.textBox33.Text;
            string MXD    = this.textBox32.Text;
            string MXDP   = this.textBox35.Text;
            string PLCR   = this.textBox34.Text;
            string OTHERS = this.textBox36.Text;
            //1:判断有没有,有就更新 否则就插入 DataTable selectXuechangguiInfo
            bool istrue = false;

            if (_isHaveData == true)
            {
                istrue = tjdao.updateXuechangguiInfo(aichive_no, bar_code, WBC, RBC, PCT, PLT, HGB, HCT, MCV, MCH, MCHC, RDWCV, RDWSD, MONO, MONOP, GRAN, GRANP, NEUT, NEUTP, EO, EOP, BASO, BASOP, LYM, LYMP, MPV, PDW, MXD, MXDP, PLCR, OTHERS, _currentdevno, setting.basicInfoSettings.xcg);
            }
            else
            {
                string[]        deviceno = Common._deviceModel.Split(',');
                xuechangguiBean obj      = new xuechangguiBean();
                obj.deviceModel = deviceno[1].ToString().Trim();
                obj.aichive_no  = aichive_no;
                obj.bar_code    = bar_code;
                obj.id_number   = textBox4.Text;
                obj.HCT         = HCT;
                obj.HGB         = HGB;
                obj.LYM         = LYM;
                obj.LYMP        = LYMP;
                obj.MCH         = MCH;
                obj.MCHC        = MCHC;
                obj.MCV         = MCV;
                obj.MPV         = MPV;
                obj.MXD         = MXD;
                obj.MXDP        = MXDP;
                obj.NEUT        = NEUT;
                obj.NEUTP       = NEUTP;
                obj.PCT         = PCT;
                obj.PDW         = PDW;
                obj.PLT         = PLT;
                obj.RBC         = RBC;
                obj.RDWCV       = RDWCV;
                obj.RDWSD       = RDWSD;
                obj.WBC         = WBC;
                obj.MONO        = MONO;
                obj.MONOP       = MONOP;
                obj.GRAN        = GRAN;
                obj.GRANP       = GRANP;
                obj.PLCR        = PLCR;
                obj.createTime  = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                obj.ZrysXCG     = setting.basicInfoSettings.xcg;
                //obj.timeCodeUnique = obj.bar_code + "_" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                istrue = tjdao.insertXuechangguiInfo(obj);
            }

            if (istrue)
            {
                #region 处理下数据判断

                int r0 = 1;
                if (WBC != "" && WBC != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(WBC, out a);
                    if (b == true)
                    {
                        r0 = GetJudgeResultForWBC(a);
                    }
                }
                int r1 = 1;
                if (RBC != "" && RBC != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(RBC, out a);
                    if (b == true)
                    {
                        r1 = GetJudgeResultForRBC(a);
                    }
                }
                int r2 = 1;
                if (PCT != "" && PCT != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(PCT, out a);
                    if (b == true)
                    {
                        r2 = GetJudgeResultForPCT(a);
                    }
                }
                int r3 = 1;
                if (PLT != "" && PLT != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(PLT, out a);
                    if (b == true)
                    {
                        r3 = GetJudgeResultForPLT(a);
                    }
                }
                int r4 = 1;
                if (HGB != "" && HGB != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(HGB, out a);
                    if (b == true)
                    {
                        r4 = GetJudgeResultForHGB(a);
                    }
                }
                int r5 = 1;
                if (HCT != "" && HCT != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(HCT, out a);
                    if (b == true)
                    {
                        r5 = GetJudgeResultForHCT(a);
                    }
                }
                int r6 = 1;
                if (MCV != "" && MCV != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(MCV, out a);
                    if (b == true)
                    {
                        r6 = GetJudgeResultForMCV(a);
                    }
                }
                int r7 = 1;
                if (MCH != "" && MCH != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(MCH, out a);
                    if (b == true)
                    {
                        r7 = GetJudgeResultForMCH(a);
                    }
                }
                int r8 = 1;
                if (MCHC != "" && MCHC != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(MCHC, out a);
                    if (b == true)
                    {
                        r8 = GetJudgeResultForMCHC(a);
                    }
                }
                int r9 = 1;
                if (RDWCV != "" && RDWCV != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(RDWCV, out a);
                    if (b == true)
                    {
                        r9 = GetJudgeResultForRDWCV(a);
                    }
                }
                int r10 = 1;
                if (RDWSD != "" && RDWSD != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(RDWSD, out a);
                    if (b == true)
                    {
                        r10 = GetJudgeResultForRDWSD(a);
                    }
                }
                int r11 = 1;
                if (NEUT != "" && NEUT != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(NEUT, out a);
                    if (b == true)
                    {
                        r11 = GetJudgeResultForNEUT(a);
                    }
                }
                int r12 = 1;
                if (NEUTP != "" && NEUTP != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(NEUTP, out a);
                    if (b == true)
                    {
                        r12 = GetJudgeResultForNEUTP(a);
                    }
                }
                int r13 = 1;
                if (LYM != "" && LYM != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(LYM, out a);
                    if (b == true)
                    {
                        r13 = GetJudgeResultForLYM(a);
                    }
                }
                int r14 = 1;
                if (LYMP != "" && LYMP != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(LYMP, out a);
                    if (b == true)
                    {
                        r14 = GetJudgeResultForLYMP(a);
                    }
                }
                int r15 = 1;
                if (MPV != "" && MPV != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(MPV, out a);
                    if (b == true)
                    {
                        r15 = GetJudgeResultForMPV(a);
                    }
                }
                int r16 = 1;
                if (PDW != "" && PDW != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(PDW, out a);
                    if (b == true)
                    {
                        r16 = GetJudgeResultForPDW(a);
                    }
                }
                int r17 = 1;
                if (MXD != "" && MXD != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(MXD, out a);
                    if (b == true)
                    {
                        r17 = GetJudgeResultForMXD(a);
                    }
                }
                int r18 = 1;
                if (MXDP != "" && MXDP != "*")
                {
                    double a = 0;
                    bool   b = double.TryParse(MXDP, out a);
                    if (b == true)
                    {
                        r18 = GetJudgeResultForMXDP(a);
                    }
                }
                int r = 1;
                r = r0;
                if (r < r1)
                {
                    r = r1;
                }
                if (r < r2)
                {
                    r = r2;
                }
                if (r < r3)
                {
                    r = r3;
                }
                if (r < r4)
                {
                    r = r4;
                }
                if (r < r5)
                {
                    r = r5;
                }
                if (r < r6)
                {
                    r = r6;
                }
                if (r < r7)
                {
                    r = r7;
                }
                if (r < r8)
                {
                    r = r8;
                }
                if (r < r9)
                {
                    r = r9;
                }
                if (r < r10)
                {
                    r = r10;
                }
                if (r < r11)
                {
                    r = r11;
                }
                if (r < r12)
                {
                    r = r12;
                }
                if (r < r13)
                {
                    r = r13;
                }
                if (r < r14)
                {
                    r = r14;
                }
                if (r < r15)
                {
                    r = r15;
                }
                if (r < r16)
                {
                    r = r16;
                }
                if (r < r17)
                {
                    r = r17;
                }
                if (r < r18)
                {
                    r = r18;
                }
                #endregion
                tjdao.updateTJbgdcXuechanggui(aichive_no, bar_code, r);
                tjdao.updatePEXcgInfo(aichive_no, bar_code, HGB, WBC, PLT);
                testFunDelegate(r, 8, rowIndex);
                MessageBox.Show("数据保存成功!");
            }
            else
            {
                MessageBox.Show("数据保存失败!");
            }
        }
Пример #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("");
            }
        }