Beispiel #1
0
        /// <summary>
        /// 执行SQL语句并返回数据表
        /// </summary>
        /// <param name="Sqlstr">SQL语句</param>
        /// <returns></returns>
        public static DataTable ExecuteDt(String Sqlstr)
        {
            String ConnStr = SQLDbHelper.GetSqlConnection();

            using (SqlConnection conn = new SqlConnection(ConnStr))
            {
                SqlDataAdapter da = new SqlDataAdapter(Sqlstr, conn);
                DataTable      dt = new DataTable();
                conn.Open();
                da.Fill(dt);
                conn.Close();
                return(dt);
            }
        }
Beispiel #2
0
        /// <summary>
        /// 根据SQL语句,取得SqlDataReader结果
        /// </summary>
        /// <param name="Sqlstr">SQL语句</param>
        /// <returns>SqlDataReader</returns>
        public static SqlDataReader ExecuteDr(string Sqlstr)
        {
            String ConnStr = SQLDbHelper.GetSqlConnection();

            using (SqlConnection conn = new SqlConnection(ConnStr))
            {
                SqlCommand cmd = new SqlCommand(Sqlstr, conn);
                //cmd.CommandText = Sqlstr;
                //cmd.Connection = conn;
                conn.Open();
                SqlDataReader dataReader = cmd.ExecuteReader();
                conn.Close();
                return(dataReader);
            }
        }
Beispiel #3
0
        /// <summary>
        /// 执行SQL语句并返回数据集
        /// </summary>
        /// <param name="Sqlstr">SQL语句</param>
        /// <returns>DataSet</returns>
        public static DataSet ExecuteDs(String Sqlstr)
        {
            String ConnStr = SQLDbHelper.GetSqlConnection();

            using (SqlConnection conn = new SqlConnection(ConnStr))
            {
                DataSet        ds  = new DataSet();
                SqlDataAdapter da  = new SqlDataAdapter();
                SqlCommand     cmd = new SqlCommand(Sqlstr, conn);
                //cmd.CommandText = Sqlstr;
                //cmd.Connection = conn;
                da.SelectCommand = cmd;
                conn.Open();
                da.Fill(ds);
                conn.Close();
                return(ds);
            }
        }
Beispiel #4
0
        /// <summary>
        /// 执行SQL语句并返回数据表
        /// </summary>
        /// <param name="Sqlstr">SQL语句</param>
        /// <param name="param">参数对象列表</param>
        /// <returns></returns>
        public static DataTable ExecuteDt(String Sqlstr, SqlParameter[] param)
        {
            String ConnStr = SQLDbHelper.GetSqlConnection();

            using (SqlConnection conn = new SqlConnection(ConnStr))
            {
                DataTable      dt  = new DataTable();
                SqlDataAdapter da  = new SqlDataAdapter();
                SqlCommand     cmd = new SqlCommand(Sqlstr, conn);
                //cmd.CommandText = Sqlstr;
                //cmd.Connection = conn;
                cmd.Parameters.AddRange(param);
                da.SelectCommand = cmd;
                conn.Open();
                da.Fill(dt);
                conn.Close();
                return(dt);
            }
        }
Beispiel #5
0
        /// <summary>
        /// 批量执行SQL语句
        /// </summary>
        /// <param name="Sqlstr">SQL语句数组</param>
        /// <param name="param">SQL参数对象数组</param>
        /// <returns></returns>
        public static Boolean ExecuteSqls(String[] Sqlstr, List <SqlParameter[]> param)
        {
            String ConnStr = SQLDbHelper.GetSqlConnection();

            using (SqlConnection conn = new SqlConnection(ConnStr))
            {
                SqlCommand     cmd  = new SqlCommand();
                SqlTransaction tran = null;
                cmd.Transaction = tran;
                try
                {
                    conn.Open();
                    tran            = conn.BeginTransaction();
                    cmd.Connection  = conn;
                    cmd.Transaction = tran;

                    Int32 count = Sqlstr.Length;
                    for (Int32 i = 0; i < count; i++)
                    {
                        cmd.CommandText = Sqlstr[i];
                        cmd.Parameters.AddRange(param[i]);
                        cmd.ExecuteNonQuery();
                    }
                    tran.Commit();
                    return(true);
                }
                catch
                {
                    tran.Rollback();
                    return(false);
                }
                finally
                {
                    cmd.Dispose();
                    conn.Close();
                }
            }
        }
Beispiel #6
0
        /// <summary>
        /// 执行SQL语句
        /// </summary>
        /// <param name="Sqlstr">SQL语句</param>
        /// <param name="param">参数对象数组</param>
        /// <returns></returns>
        public static Boolean ExecuteSql(String Sqlstr, SqlParameter[] param)
        {
            String ConnStr = SQLDbHelper.GetSqlConnection();

            using (SqlConnection conn = new SqlConnection(ConnStr))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = Sqlstr;
                cmd.Parameters.AddRange(param);
                conn.Open();
                int AffectRows = cmd.ExecuteNonQuery(); //对于 UPDATE、INSERT 和 DELETE 语句,返回值为该命令所影响的行数。
                conn.Close();                           //对于所有其他类型的语句,返回值为 -1。如果发生回滚,返回值也为 -1。

                if (AffectRows > 0 || AffectRows == -1)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }