/// <summary>
        /// 根据接收到的数据添加到数据库
        /// </summary>
        /// <param name="objPatientBodyInfo"></param>
        /// <returns></returns>
        public int  AddPatientBodyInfo(PatientBodyInfo objPatientBodyInfo)
        {
            if (objPatientBodyInfo == null)
            {
                return(0);
            }
            string sql = "insert into PatientBodyInfo(PatientBodyInfotime,PatientBednum,BloodO2,Pluse,GetO2time,Flux,Model,Error,GetO2totaltime,UseFlag)";

            sql += "values('{0}',{1},'{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9})";
            sql  = string.Format(sql, objPatientBodyInfo.PatientBodyInfotime, objPatientBodyInfo.PatientBednum, objPatientBodyInfo.BloodO2,
                                 objPatientBodyInfo.Pluse, objPatientBodyInfo.GetO2time, objPatientBodyInfo.Flux, objPatientBodyInfo.Model, objPatientBodyInfo.Error,
                                 objPatientBodyInfo.GetO2totaltime, objPatientBodyInfo.UseFlag);
            try
            {
                // SQLiteHelper.WriteLog("    public int  AddPatientBodyInfo(PatientBodyInfo objPatientBodyInfo)", ex.Message);
                return(SQLiteHelper.Update(sql));
            }
            catch (Exception ex)
            {
                SQLiteHelper.WriteLog("    public int  AddPatientBodyInfo(PatientBodyInfo objPatientBodyInfo)", ex.Message);
                throw new Exception("添加数据出错!" + ex.Message);
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 封装要存入数据库的信息
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public static PatientBodyInfo ProtocolaSqldata(int[] data)
        {
            string          str = "";
            PatientBodyInfo objPatientBodyInfo = new PatientBodyInfo();

            if ((data[0] == 0xff) && (data[1] == 0xff) && (data[2] == 0xff) & (data[3] == 0xff))
            {
                str = "连接断开,";
            }
            if ((data[6] & 2) == 2)
            {
                objPatientBodyInfo.PatientBednum  = Convert.ToInt16(data[4]);
                objPatientBodyInfo.BloodO2        = data[0].ToString();
                objPatientBodyInfo.Flux           = (data[2] / 10.0).ToString();
                objPatientBodyInfo.Pluse          = (data[1]).ToString();
                objPatientBodyInfo.GetO2time      = (data[7] / 10.0).ToString();
                objPatientBodyInfo.GetO2totaltime = (data[3] / 10.0).ToString();

                if ((data[6] & 1) == 1)
                {
                    objPatientBodyInfo.Model = "智能模式";
                }
                else
                {
                    objPatientBodyInfo.Model = "人工模式";
                }
                //if ((data[6] & 4) == 4)
                //{
                //    str += "吸氧时间到,";
                //}
                if ((data[6] & 8) == 8)
                {
                    str += "电池电压低,";
                }
                //if ((data[6] & 16) == 16)
                //{
                //    str += "湿化瓶错误,";
                //}
                if ((data[6] & 32) == 32)
                {
                    str += "压力异常,";
                }
                if ((data[6] & 64) == 64)
                {
                    str += "血氧饱和度异常,";
                }
                if ((data[6] & 128) == 128)
                {
                    str += "血氧探头脱落,";
                }
                if ((data[6] & 256) == 256)
                {
                    str += "运动干扰,";
                }
                if ((data[6] & 512) == 512)
                {
                    str += "低灌注";
                }
                if (str.Length == 0)
                {
                    str = "正常";
                }
            }
            else
            {
                if ((data[6] & 4) == 4)
                {
                    str += "吸氧时间到,";
                }
                if ((data[6] & 16) == 16)
                {
                    str += "湿化瓶错误,";
                }
                str += "手动暂停";
            }
            objPatientBodyInfo.Error               = str;
            objPatientBodyInfo.PatientBednum       = Convert.ToInt16(data[4]);
            objPatientBodyInfo.PatientBodyInfotime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm"));
            objPatientBodyInfo.UseFlag             = 0;
            return(objPatientBodyInfo);
        }