Esempio n. 1
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(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 count(1) 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;

            return(DbHelperMySQL_Data.Exists(strSql.ToString(), parameters));
        }
Esempio n. 2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(ALS.Model.pump_speed_data model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into pump_speed_data(");
            strSql.Append("surgery_no,time_stamp,cumulative_time,blood_pump,separation_pump,dialysis_pump,tripe_pump,filtration_pump,circulating_pump,heparin_pump,warmer,blood_pump_t,separation_pump_t,dialysis_pump_t,tripe_pump_t,filtration_pump_t,circulating_pump_t,heparin_pump_t)");
            strSql.Append(" values (");
            strSql.Append("@surgery_no,@time_stamp,@cumulative_time,@blood_pump,@separation_pump,@dialysis_pump,@tripe_pump,@filtration_pump,@circulating_pump,@heparin_pump,@warmer,@blood_pump_t,@separation_pump_t,@dialysis_pump_t,@tripe_pump_t,@filtration_pump_t,@circulating_pump_t,@heparin_pump_t)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@time_stamp",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@cumulative_time",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@blood_pump",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@separation_pump",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@dialysis_pump",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@tripe_pump",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@filtration_pump",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@circulating_pump",   MySqlDbType.VarChar, 255),
                new MySqlParameter("@heparin_pump",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@warmer",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@blood_pump_t",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@separation_pump_t",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@dialysis_pump_t",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@tripe_pump_t",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@filtration_pump_t",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@circulating_pump_t", MySqlDbType.VarChar, 255),
                new MySqlParameter("@heparin_pump_t",     MySqlDbType.VarChar, 255)
            };
            parameters[0].Value  = model.surgery_no;
            parameters[1].Value  = model.time_stamp;
            parameters[2].Value  = model.cumulative_time;
            parameters[3].Value  = model.blood_pump;
            parameters[4].Value  = model.separation_pump;
            parameters[5].Value  = model.dialysis_pump;
            parameters[6].Value  = model.tripe_pump;
            parameters[7].Value  = model.filtration_pump;
            parameters[8].Value  = model.circulating_pump;
            parameters[9].Value  = model.heparin_pump;
            parameters[10].Value = model.warmer;
            parameters[11].Value = model.blood_pump_t;
            parameters[12].Value = model.separation_pump_t;
            parameters[13].Value = model.dialysis_pump_t;
            parameters[14].Value = model.tripe_pump_t;
            parameters[15].Value = model.filtration_pump_t;
            parameters[16].Value = model.circulating_pump_t;
            parameters[17].Value = model.heparin_pump_t;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 3
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select surgery_no,time_stamp,cumulative_time,blood_pump,separation_pump,dialysis_pump,tripe_pump,filtration_pump,circulating_pump,heparin_pump,warmer,blood_pump_t,separation_pump_t,dialysis_pump_t,tripe_pump_t,filtration_pump_t,circulating_pump_t,heparin_pump_t ");
            strSql.Append(" FROM pump_speed_data ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return(DbHelperMySQL_Data.Query(strSql.ToString()));
        }
Esempio n. 4
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            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 ");
            strSql.Append(" FROM pressure_data ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return(DbHelperMySQL_Data.Query(strSql.ToString()));
        }
Esempio n. 5
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string surgery_no)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from pump_speed_data");
            strSql.Append(" where surgery_no=@surgery_no ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no", MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = surgery_no;

            return(DbHelperMySQL_Data.Exists(strSql.ToString(), parameters));
        }
Esempio n. 6
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);
            }
        }
Esempio n. 7
0
        /// <summary>
        /// 批量删除数据
        /// </summary>
        public bool DeleteList(string surgery_nolist)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("delete from pump_speed_data ");
            strSql.Append(" where surgery_no in (" + surgery_nolist + ")  ");
            int rows = DbHelperMySQL_Data.ExecuteSql(strSql.ToString());

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 8
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);
            }
        }
Esempio n. 9
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);
            }
        }
Esempio n. 10
0
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(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("delete 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;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 11
0
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T." + orderby);
            }
            else
            {
                strSql.Append("order by T.surgery_no desc");
            }
            strSql.Append(")AS Row, T.*  from pump_speed_data T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
            return(DbHelperMySQL_Data.Query(strSql.ToString()));
        }
Esempio n. 12
0
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(string surgery_no)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("delete from pump_speed_data ");
            strSql.Append(" where surgery_no=@surgery_no ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no", MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = surgery_no;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 13
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ALS.Model.pump_speed_data GetModel(string surgery_no)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select surgery_no,time_stamp,cumulative_time,blood_pump,separation_pump,dialysis_pump,tripe_pump,filtration_pump,circulating_pump,heparin_pump,warmer,blood_pump_t,separation_pump_t,dialysis_pump_t,tripe_pump_t,filtration_pump_t,circulating_pump_t,heparin_pump_t from pump_speed_data ");
            strSql.Append(" where surgery_no=@surgery_no ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@surgery_no", MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = surgery_no;

            ALS.Model.pump_speed_data model = new ALS.Model.pump_speed_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);
            }
        }
Esempio n. 14
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);
            }
        }
Esempio n. 15
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(ALS.Model.pump_speed_data model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update pump_speed_data set ");
            strSql.Append("time_stamp=@time_stamp,");
            strSql.Append("cumulative_time=@cumulative_time,");
            strSql.Append("blood_pump=@blood_pump,");
            strSql.Append("separation_pump=@separation_pump,");
            strSql.Append("dialysis_pump=@dialysis_pump,");
            strSql.Append("tripe_pump=@tripe_pump,");
            strSql.Append("filtration_pump=@filtration_pump,");
            strSql.Append("circulating_pump=@circulating_pump,");
            strSql.Append("heparin_pump=@heparin_pump,");
            strSql.Append("warmer=@warmer,");
            strSql.Append("blood_pump_t=@blood_pump_t,");
            strSql.Append("separation_pump_t=@separation_pump_t,");
            strSql.Append("dialysis_pump_t=@dialysis_pump_t,");
            strSql.Append("tripe_pump_t=@tripe_pump_t,");
            strSql.Append("filtration_pump_t=@filtration_pump_t,");
            strSql.Append("circulating_pump_t=@circulating_pump_t,");
            strSql.Append("heparin_pump_t=@heparin_pump_t");
            strSql.Append(" where surgery_no=@surgery_no ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@time_stamp",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@cumulative_time",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@blood_pump",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@separation_pump",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@dialysis_pump",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@tripe_pump",         MySqlDbType.VarChar, 255),
                new MySqlParameter("@filtration_pump",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@circulating_pump",   MySqlDbType.VarChar, 255),
                new MySqlParameter("@heparin_pump",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@warmer",             MySqlDbType.VarChar, 255),
                new MySqlParameter("@blood_pump_t",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@separation_pump_t",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@dialysis_pump_t",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@tripe_pump_t",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@filtration_pump_t",  MySqlDbType.VarChar, 255),
                new MySqlParameter("@circulating_pump_t", MySqlDbType.VarChar, 255),
                new MySqlParameter("@heparin_pump_t",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@surgery_no",         MySqlDbType.VarChar, 255)
            };
            parameters[0].Value  = model.time_stamp;
            parameters[1].Value  = model.cumulative_time;
            parameters[2].Value  = model.blood_pump;
            parameters[3].Value  = model.separation_pump;
            parameters[4].Value  = model.dialysis_pump;
            parameters[5].Value  = model.tripe_pump;
            parameters[6].Value  = model.filtration_pump;
            parameters[7].Value  = model.circulating_pump;
            parameters[8].Value  = model.heparin_pump;
            parameters[9].Value  = model.warmer;
            parameters[10].Value = model.blood_pump_t;
            parameters[11].Value = model.separation_pump_t;
            parameters[12].Value = model.dialysis_pump_t;
            parameters[13].Value = model.tripe_pump_t;
            parameters[14].Value = model.filtration_pump_t;
            parameters[15].Value = model.circulating_pump_t;
            parameters[16].Value = model.heparin_pump_t;
            parameters[17].Value = model.surgery_no;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }