/// <summary>
        /// 执行一个(无参)增删改语句
        /// </summary>
        /// <param name="safeSql">语句</param>
        /// <returns>影响行数</returns>
        public static int ExecuteCommand(string safeSql)
        {
            MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
            int result = cmd.ExecuteNonQuery();

            return(result);
        }
        /// <summary>
        /// 执行多条SQL语句,实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList">多条SQL语句</param>
        public static void ExecuteSqlTran(ArrayList SQLStringList)
        {
            MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
            cmd.Connection = Connection;

            MySQLDriverCS.MySQLTransaction tx = (MySQLDriverCS.MySQLTransaction)Connection.BeginTransaction();
            cmd.Transaction = tx;
            try
            {
                for (int n = 0; n < SQLStringList.Count; n++)
                {
                    string strsql = SQLStringList[n].ToString();
                    if (strsql.Trim().Length > 1)
                    {
                        cmd.CommandText = strsql;
                        cmd.ExecuteNonQuery();
                    }
                }
                tx.Commit();
            }
            catch (System.Data.SqlClient.SqlException E)
            {
                tx.Rollback();
                throw new Exception(E.Message);
            }
        }
 /// <summary>
 /// 执行一个无参增删改存储过程
 /// </summary>
 /// <param name="procName">存储过程名字</param>
 /// <returns>影响行数</returns>
 public static int ExecuteProc(string procName)
 {
     MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
     cmd.Connection  = Connection;
     cmd.CommandText = procName;
     cmd.CommandType = CommandType.StoredProcedure;
     return(cmd.ExecuteNonQuery());
 }
 /// <summary>
 /// 执行一个增删改存储过程(有参)
 /// </summary>
 /// <param name="procName">存储过程名字</param>
 /// <param name="values">参数列表</param>
 /// <returns>影响行数</returns>
 public static int ExecuteProc(string procName, params MySQLDriverCS.MySQLParameter[] values)
 {
     MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
     cmd.Connection  = Connection;
     cmd.CommandText = procName;
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddRange(values);
     return(cmd.ExecuteNonQuery());
 }
        /// <summary>
        /// 返回一个Datatable(无参)
        /// </summary>
        /// <param name="safeSql">语句</param>
        /// <returns>DataTable</returns>
        public static DataTable GetDataSet(string safeSql)
        {
            DataSet ds = new DataSet();

            MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand("set names gbk", Connection);
            cmd.ExecuteNonQuery();
            cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
            MySQLDriverCS.MySQLDataAdapter da = new MySQLDriverCS.MySQLDataAdapter(cmd);
            da.Fill(ds);
            return(ds.Tables[0]);
        }
 /// <summary>
 /// 执行一个有参增删改操作
 /// </summary>
 /// <param name="sql">语句</param>
 /// <param name="values">参数</param>
 /// <returns>影响行数 </returns>
 public static int ExecuteCommand(string sql, params MySQLDriverCS.MySQLParameter[] values)
 {
     MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(sql, Connection);
     cmd.Parameters.AddRange(values);
     return(cmd.ExecuteNonQuery());
 }