Exemple #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(ALS.Model.pressure_data model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update pressure_data set ");
            strSql.Append("surgery_no=@surgery_no,");
            strSql.Append("time_stamp=@time_stamp,");
            strSql.Append("in_blood_pressure=@in_blood_pressure,");
            strSql.Append("plasma_inlet_pressure=@plasma_inlet_pressure,");
            strSql.Append("arterial_pressure=@arterial_pressure,");
            strSql.Append("venous_pressure=@venous_pressure,");
            strSql.Append("plasma_pressure=@plasma_pressure,");
            strSql.Append("transmembrane_pressure=@transmembrane_pressure,");
            strSql.Append("plasma2_pressure=@plasma2_pressure");
            strSql.Append(" where surgery_no=@surgery_no and time_stamp=@time_stamp and in_blood_pressure=@in_blood_pressure and plasma_inlet_pressure=@plasma_inlet_pressure and arterial_pressure=@arterial_pressure and venous_pressure=@venous_pressure and plasma_pressure=@plasma_pressure and transmembrane_pressure=@transmembrane_pressure and plasma2_pressure=@plasma2_pressure ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@time_stamp",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@in_blood_pressure",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma_inlet_pressure",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@arterial_pressure",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@venous_pressure",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma_pressure",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@transmembrane_pressure", MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma2_pressure",       MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = model.surgery_no;
            parameters[1].Value = model.time_stamp;
            parameters[2].Value = model.in_blood_pressure;
            parameters[3].Value = model.plasma_inlet_pressure;
            parameters[4].Value = model.arterial_pressure;
            parameters[5].Value = model.venous_pressure;
            parameters[6].Value = model.plasma_pressure;
            parameters[7].Value = model.transmembrane_pressure;
            parameters[8].Value = model.plasma2_pressure;

            int rows = DbHelperMySQL_Data.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemple #2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public ALS.Model.pressure_data DataRowToModel(DataRow row)
 {
     ALS.Model.pressure_data model = new ALS.Model.pressure_data();
     if (row != null)
     {
         if (row["surgery_no"] != null)
         {
             model.surgery_no = row["surgery_no"].ToString();
         }
         if (row["time_stamp"] != null)
         {
             model.time_stamp = row["time_stamp"].ToString();
         }
         if (row["in_blood_pressure"] != null)
         {
             model.in_blood_pressure = row["in_blood_pressure"].ToString();
         }
         if (row["plasma_inlet_pressure"] != null)
         {
             model.plasma_inlet_pressure = row["plasma_inlet_pressure"].ToString();
         }
         if (row["arterial_pressure"] != null)
         {
             model.arterial_pressure = row["arterial_pressure"].ToString();
         }
         if (row["venous_pressure"] != null)
         {
             model.venous_pressure = row["venous_pressure"].ToString();
         }
         if (row["plasma_pressure"] != null)
         {
             model.plasma_pressure = row["plasma_pressure"].ToString();
         }
         if (row["transmembrane_pressure"] != null)
         {
             model.transmembrane_pressure = row["transmembrane_pressure"].ToString();
         }
         if (row["plasma2_pressure"] != null)
         {
             model.plasma2_pressure = row["plasma2_pressure"].ToString();
         }
     }
     return(model);
 }
Exemple #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(ALS.Model.pressure_data model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into pressure_data(");
            strSql.Append("surgery_no,time_stamp,in_blood_pressure,plasma_inlet_pressure,arterial_pressure,venous_pressure,plasma_pressure,transmembrane_pressure,plasma2_pressure)");
            strSql.Append(" values (");
            strSql.Append("@surgery_no,@time_stamp,@in_blood_pressure,@plasma_inlet_pressure,@arterial_pressure,@venous_pressure,@plasma_pressure,@transmembrane_pressure,@plasma2_pressure)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@time_stamp",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@in_blood_pressure",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma_inlet_pressure",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@arterial_pressure",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@venous_pressure",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma_pressure",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@transmembrane_pressure", MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma2_pressure",       MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = model.surgery_no;
            parameters[1].Value = model.time_stamp;
            parameters[2].Value = model.in_blood_pressure;
            parameters[3].Value = model.plasma_inlet_pressure;
            parameters[4].Value = model.arterial_pressure;
            parameters[5].Value = model.venous_pressure;
            parameters[6].Value = model.plasma_pressure;
            parameters[7].Value = model.transmembrane_pressure;
            parameters[8].Value = model.plasma2_pressure;

            int rows = DbHelperMySQL_Data.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemple #4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ALS.Model.pressure_data GetModel(string surgery_no, string time_stamp, string in_blood_pressure, string plasma_inlet_pressure, string arterial_pressure, string venous_pressure, string plasma_pressure, string transmembrane_pressure, string plasma2_pressure)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select surgery_no,time_stamp,in_blood_pressure,plasma_inlet_pressure,arterial_pressure,venous_pressure,plasma_pressure,transmembrane_pressure,plasma2_pressure from pressure_data ");
            strSql.Append(" where surgery_no=@surgery_no and time_stamp=@time_stamp and in_blood_pressure=@in_blood_pressure and plasma_inlet_pressure=@plasma_inlet_pressure and arterial_pressure=@arterial_pressure and venous_pressure=@venous_pressure and plasma_pressure=@plasma_pressure and transmembrane_pressure=@transmembrane_pressure and plasma2_pressure=@plasma2_pressure ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@time_stamp",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@in_blood_pressure",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma_inlet_pressure",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@arterial_pressure",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@venous_pressure",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma_pressure",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@transmembrane_pressure", MySqlDbType.VarChar, 255),
                new MySqlParameter("@plasma2_pressure",       MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = surgery_no;
            parameters[1].Value = time_stamp;
            parameters[2].Value = in_blood_pressure;
            parameters[3].Value = plasma_inlet_pressure;
            parameters[4].Value = arterial_pressure;
            parameters[5].Value = venous_pressure;
            parameters[6].Value = plasma_pressure;
            parameters[7].Value = transmembrane_pressure;
            parameters[8].Value = plasma2_pressure;

            ALS.Model.pressure_data model = new ALS.Model.pressure_data();
            DataSet ds = DbHelperMySQL_Data.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Exemple #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ALS.Model.pressure_data GetModel(string surgery_no)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select surgery_no,time_stamp,in_blood_pressure,plasma_inlet_pressure,arterial_pressure,venous_pressure,plasma_pressure,transmembrane_pressure from pressure_data ");
            strSql.Append(" where surgery_no=@surgery_no ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no", MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = surgery_no;

            ALS.Model.pressure_data model = new ALS.Model.pressure_data();
            DataSet ds = DbHelperMySQL_Data.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }