数据库增加、更新、插入与读取（以及返回多个值out的使用——处理报错：控制离开当前方法之前必须对输出参数“XXX”赋值）

本文链接：https://blog.csdn.net/Lynn_said/article/details/104145814

public static void getPreData(string workId, out string first_pressure, out string circle_wave, out string first_wave, out string circle_pressure)
        {
            try
            {
                //conn.Open();
                sql = "SELECT * FROM working_face where id=@id";
                cmd.Parameters.Add("@id", MySqlDbType.VarChar).Value = workId;
                dr = cmd.ExecuteReader();
                ==first_pressure = ""; first_wave = ""; circle_pressure = ""; circle_wave==
                if (dr == null) return;**//out输出返回前要带着初定义**
                dr.Read();
                string mine_height = dr.GetValue(32).ToString();
                string inclination = dr.GetValue(7).ToString();
                string mine_stratification = dr.GetValue(33).ToString();
                string layer_number = dr.GetValue(34).ToString();
                string bottom = dr.GetValue(35).ToString();
                string face_length = dr.GetValue(5).ToString();
                *此处涉及部分内部代码不可外漏*
                String content = dim.Result;
                String[] str = content.Split(',');//划分字符串
                first_pressure = str[9].ToString();
                first_wave = str[10].ToString();
                circle_pressure = str[11].ToString();
                circle_wave = str[12].ToString();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                first_pressure = ""; first_wave = ""; circle_pressure = ""; circle_wave = "";//out输出返回前要带着初定义
            }
            finally
            {
                myConn.Close();
            }
        }
        public static void afterReadSql(string workId, out string check)
        {
            try
            {
                check = "";
                //conn.Open();
                cmd = myConn.CreateCommand();
                cmd.CommandText = "select * from temporary_storage where workId=@workId";
                cmd.Parameters.Add("@workId", MySqlDbType.VarChar).Value = workId;
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    check = dr.GetValue(4).ToString();

                }
                else
                    Console.WriteLine("3333");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                check = "";
            }
            finally
            {
                myConn.Close();

            }
        }
        public static void thenUpdataData(string workId, string first_pressure, string first_wave, string circle_pressure, string circle_wave)
        {
            try
            {
                cmd = myConn.CreateCommand();
                cmd.CommandText = "update temporary_storage set first_pressure=@first_pressure,first_wave=@first_wave," +
                "circle_pressure=@circle_pressure,circle_wave=@circle_wave  where workId=@workId";
                cmd.Parameters.Add("@workId", MySqlDbType.VarChar).Value = workId;
                cmd.Parameters.Add("@first_pressure", MySqlDbType.VarChar).Value = first_pressure;
                cmd.Parameters.Add("@first_wave", MySqlDbType.VarChar).Value = first_wave;
                cmd.Parameters.Add("@circle_pressure", MySqlDbType.VarChar).Value = circle_pressure;
                cmd.Parameters.Add("@circle_wave", MySqlDbType.VarChar).Value = circle_wave;
                myConn.Open();//打开连接
                cmd.ExecuteNonQuery();//执行不是查询的sql语句  
                MessageBox.Show("更新成功!");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                myConn.Close();//不管打开成功还是失败，都能关闭连接
            }
        }
        public static void thenInsertData(string workId, string first_pressure, string first_wave, string circle_pressure, string circle_wave)
        {
            try
            {
                cmd = myConn.CreateCommand();
                cmd.CommandText = "insert into temporary_storage values(@first_pressure,@first_wave,@circle_pressure,@circle_wave,@workId)";

                cmd.Parameters.Add("@first_pressure", MySqlDbType.VarChar).Value = first_pressure;
                cmd.Parameters.Add("@first_wave", MySqlDbType.VarChar).Value = first_wave;
                cmd.Parameters.Add("@circle_pressure", MySqlDbType.VarChar).Value = circle_pressure;
                cmd.Parameters.Add("@circle_wave", MySqlDbType.VarChar).Value = circle_wave;
                cmd.Parameters.Add("@workId", MySqlDbType.VarChar).Value = workId;
                myConn.Open();//打开连接
                cmd.ExecuteNonQuery();//执行不是查询的sql语句
                MessageBox.Show("存入数据成功!");

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                myConn.Close();//不管打开成功还是失败，都能关闭连接
            }
        }
        public static void beforeDrawRead(string workId, out string pressure1, out string wave1, out string pressure_n, out string wave_n)
        {
            try
            {
                cmd = myConn.CreateCommand();
                cmd.CommandText = "select * from temporary_storage where workId=@workId";
                cmd.Parameters.Add("@workId", MySqlDbType.VarChar).Value = workId;
                myConn.Open();
                dr = cmd.ExecuteReader();
                pressure1 = ""; wave1 = ""; pressure_n = ""; wave_n = "";
                if (dr == null) return;
                dr.Read();
                pressure1 = dr.GetValue(0).ToString();
                wave1 = dr.GetValue(1).ToString();
                pressure_n = dr.GetValue(2).ToString();
                wave_n = dr.GetValue(3).ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                pressure1 = ""; wave1 = ""; pressure_n = ""; wave_n = "";
            }
            finally
            {
                myConn.Close();//不管打开成功还是失败，都能关闭连接
            }
        }