Example #1
0
        /// <summary>
        /// 执行ExecuteReader操作,返回DataTable读取的数据集
        /// </summary>
        /// <param name="ConnString">数据库连接字符串</param>
        /// <param name="dbname">表名</param>
        /// <param name="CmdType">指定如何解释命令字符串</param>
        /// <param name="CmdText">命令字符串</param>
        /// <param name="Parameter">参数列表</param>
        /// <returns></returns>yjyygyowxf207154


        public DataSet ExtcuteDataSet(string ConnString, string dbname, CommandType CmdType, string CmdText, MySqlParameter[] Parameter, int CommandTimeout)
        {
            DataSet         Ds   = new DataSet();
            MySqlConnection Conn = new MySqlConnection(ConnString);
            MySqlCommand    Comm = new MySqlCommand();

            if (CommandTimeout > 0)
            {
                Comm.CommandTimeout = CommandTimeout;
            }
            MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
            MySqlDataAdapter Ap = new MySqlDataAdapter();

            Ap.SelectCommand = Comm;
            try
            {
                if (!string.IsNullOrEmpty(dbname))
                {
                    Ap.Fill(Ds, dbname);
                }
                else
                {
                    Ap.Fill(Ds, "db");
                }
            }
            catch
            { }
            finally
            {
                Comm.Dispose();
                Conn.Close();
                Conn.Dispose();
            }
            return(Ds);
        }
Example #2
0
        public string ExecuteScalar(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter, bool isTran)
        {
            string           Sin = string.Empty;
            MySqlTransaction transaction;

            using (MySqlConnection Conn = new MySqlConnection(ConnString))
            {
                if (Conn.State != ConnectionState.Open)
                {
                    Conn.Open();
                }
                transaction = Conn.BeginTransaction();
                MySqlCommand Comm = new MySqlCommand();
                MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
                //Sin = Convert.ToString(Comm.ExecuteScalar());
                try
                {
                    Sin = Convert.ToString(Comm.ExecuteScalar());
                    transaction.Commit();//提交事务
                }
                catch (Exception ex)
                {
                    try
                    {
                        transaction.Rollback();//回滚事务
                    }
                    catch (Exception ex2)
                    {
                    }
                }
                Comm.Dispose();
            }
            return(Sin);
        }
Example #3
0
        public int ExecuteNonQuery(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter, bool isTran)
        {
            int Sin = 0;
            MySqlTransaction transaction;

            using (MySqlConnection Conn = new MySqlConnection(ConnString))
            {
                if (Conn.State != ConnectionState.Open)
                {
                    Conn.Open();
                }
                transaction = Conn.BeginTransaction();
                using (MySqlCommand Comm = new MySqlCommand())
                {
                    MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
                    try
                    {
                        Sin = Comm.ExecuteNonQuery();
                        transaction.Commit();//提交事务
                    }
                    catch (Exception ex)
                    {
                        try
                        {
                            transaction.Rollback();//回滚事务
                        }
                        catch (Exception ex2)
                        {
                        }
                    }
                }
            }
            return(Sin);
        }
Example #4
0
 /// <summary>
 /// 执行无返回ExecuteNonQuery操作
 /// </summary>
 /// <param name="ConnString">数据库连接字符串</param>
 /// <param name="CmdType">指定如何解释命令字符串</param>
 /// <param name="CmdText">命令字符串</param>
 /// <param name="Parameter">参数列表</param>
 /// <returns></returns>
 public void ExecuteNonQueryNull(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter)
 {
     using (MySqlConnection Conn = new MySqlConnection(ConnString))
     {
         using (MySqlCommand Comm = new MySqlCommand())
         {
             MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
             Comm.ExecuteNonQuery();
             Comm.Dispose();
         }
     }
 }
Example #5
0
        /// <summary>
        /// 执行ExecuteReader操作,返回SqlDataReader读取的数据集
        /// </summary>
        /// <param name="ConnString">数据库连接字符串</param>
        /// <param name="CmdType">指定如何解释命令字符串</param>
        /// <param name="CmdText">命令字符串</param>
        /// <param name="Parameter">参数列表</param>
        /// <returns></returns>
        public MySqlDataReader ExtcuteReader(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter)
        {
            MySqlConnection Conn = new MySqlConnection(ConnString);
            MySqlCommand    Comm = new MySqlCommand();

            MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
            MySqlDataReader Dr = Comm.ExecuteReader(CommandBehavior.CloseConnection);

            Comm.Dispose();
            //Conn.Close();
            //Conn.Dispose();
            return(Dr);
        }
Example #6
0
        public DataTable ExtcuteDataTable(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter, string dbname, bool isTran)
        {
            DataSet          Ds = new DataSet();
            MySqlTransaction transaction;
            MySqlConnection  Conn = new MySqlConnection(ConnString);

            transaction = Conn.BeginTransaction();
            MySqlCommand Comm = new MySqlCommand();

            MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
            MySqlDataAdapter Ap = new MySqlDataAdapter();

            Ap.SelectCommand = Comm;
            try
            {
                if (!string.IsNullOrEmpty(dbname))
                {
                    Ap.Fill(Ds, dbname);
                }
                else
                {
                    Ap.Fill(Ds, "db");
                }
                transaction.Commit();//提交事务
            }
            catch
            {
                try
                {
                    transaction.Rollback();//回滚事务
                }
                catch (Exception ex2)
                {
                }
            }
            finally
            {
                Comm.Dispose();
                Conn.Dispose();
                Conn.Close();
            }

            if (!string.IsNullOrEmpty(dbname))
            {
                return(Ds.Tables[dbname]);
            }
            else
            {
                return(Ds.Tables["db"]);
            }
        }
Example #7
0
        /// <summary>
        /// 执行ExecuteScalar操作,返回第一行第一列
        /// </summary>
        /// <param name="ConnString">数据库连接字符串</param>
        /// <param name="CmdType">指定如何解释命令字符串</param>
        /// <param name="CmdText">命令字符串</param>
        /// <param name="Parameter">参数列表</param>
        /// <returns></returns>
        public string ExecuteScalar(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter)
        {
            string Sin = string.Empty;

            using (MySqlConnection Conn = new MySqlConnection(ConnString))
            {
                MySqlCommand Comm = new MySqlCommand();
                MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
                Sin = Convert.ToString(Comm.ExecuteScalar());

                Comm.Dispose();
            }
            return(Sin);
        }
Example #8
0
        /// <summary>
        /// 执行ExecuteNonQuery操作,返回受影响的行数
        /// </summary>
        /// <param name="ConnString">数据库连接字符串</param>
        /// <param name="CmdType">指定如何解释命令字符串</param>
        /// <param name="CmdText">命令字符串</param>
        /// <param name="Parameter">参数列表</param>
        /// <returns></returns>
        public int ExecuteNonQuery(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter)
        {
            int Sin;

            using (MySqlConnection Conn = new MySqlConnection(ConnString))
            {
                using (MySqlCommand Comm = new MySqlCommand())
                {
                    MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
                    Sin = Comm.ExecuteNonQuery();
                }
            }
            return(Sin);
        }
Example #9
0
        /// <summary>
        /// 执行ExecuteReader操作,返回DataTable读取的数据集
        /// </summary>
        /// <param name="ConnString">数据库连接字符串</param>
        /// <param name="CmdType">指定如何解释命令字符串</param>
        /// <param name="CmdText">命令字符串</param>
        /// <param name="Parameter">参数列表</param>
        /// <returns></returns>
        public DataTable ExtcuteDataTable(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter, string dbname)
        {
            DataSet         Ds   = new DataSet();
            MySqlConnection Conn = new MySqlConnection(ConnString);
            MySqlCommand    Comm = new MySqlCommand();

            MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
            MySqlDataAdapter Ap = new MySqlDataAdapter();

            Ap.SelectCommand = Comm;
            try
            {
                if (!string.IsNullOrEmpty(dbname))
                {
                    Ap.Fill(Ds, dbname);
                }
                else
                {
                    Ap.Fill(Ds, "db");
                }
            }
            catch
            { }
            finally
            {
                Comm.Dispose();
                Conn.Dispose();
                Conn.Close();
            }

            if (!string.IsNullOrEmpty(dbname))
            {
                return(Ds.Tables[dbname]);
            }
            else
            {
                return(Ds.Tables["db"]);
            }
        }
Example #10
0
        public void ExecuteNonQueryNull(string ConnString, CommandType CmdType, string CmdText, MySqlParameter[] Parameter, bool isTran)
        {
            MySqlTransaction transaction;

            using (MySqlConnection Conn = new MySqlConnection(ConnString))
            {
                if (Conn.State != ConnectionState.Open)
                {
                    Conn.Open();
                }
                transaction = Conn.BeginTransaction();
                using (MySqlCommand Comm = new MySqlCommand())
                {
                    MySqlCmdHeader.CmdParameter(Comm, Conn, null, CmdType, CmdText, Parameter);
                    Comm.ExecuteNonQuery();
                    try
                    {
                        Comm.ExecuteNonQuery();
                        transaction.Commit();//提交事务
                    }
                    catch (Exception ex)
                    {
                        try
                        {
                            transaction.Rollback();//回滚事务
                        }
                        catch (Exception ex2)
                        {
                            //Response.Write("回滚错误类型:" + ex2.GetType());
                            //Response.Write("回滚错误信息:" + ex2.Message);
                        }
                    }
                    Comm.Dispose();
                }
            }
        }