SqlServerClient

using System;
using System.Data;
using System.Data.SqlClient;

namespace UnitLibrary.DAL
...{
    /**//// <summary>
    /// 功能：用于执行Sql Server 的相关操作
    /// </summary>
    public class SqlServerClient
    ...{
        字段#region 字段
        /**//// <summary>
        /// 数据库连接字符串
        /// </summary>
        private string connString;
        #endregion

        公有方法#region 公有方法
        /**//// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="connString">Sql Server数据库连接字符串</param>
        public SqlServerClient(string connString)
        ...{
            this.connString = connString;
        }

        /**//// <summary>
        /// 执行Sql 语句，无返回植
        /// </summary>
        /// <param name="sql">sql 语句</param>
        public void ExecSqlWithOutResult(string sql)
        ...{
            SqlConnection conn = new SqlConnection(this.connString);
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.CommandTimeout = 0;
            try
            ...{
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            ...{
                throw ex;
            }
            finally
            ...{
                if (cmd.Connection.State == ConnectionState.Open)
                    cmd.Connection.Close();
            }
        }

        /**//// <summary>
        /// 执行n条Sql 语句，无返回植（事务）
        /// </summary>
        /// <param name="sqls">sql 语句</param>
        public void ExecSqlWithOutResult(string[] sqls)
        ...{
            SqlCommand[] cmds = new SqlCommand[sqls.Length];
            SqlConnection conn = new SqlConnection(this.connString);
            conn.Open();
            SqlTransaction tran = conn.BeginTransaction();

            try
            ...{
                for (int i = 0; i < sqls.Length; i++)
                ...{
                    cmds[i] = new SqlCommand(sqls[i], conn);
                    cmds[i].Transaction = tran;
                    cmds[i].ExecuteNonQuery();
                }
                tran.Commit();
            }
            catch (Exception ex)
            ...{
                tran.Rollback();
                throw ex;
            }
            finally
            ...{
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        /**//// <summary>
        /// 执行Sql 语句，返回一个结果
        /// </summary>
        /// <param name="sql">sql 语句</param>
        /// <returns>sql 语句执行结果</returns>
        public object ExecSqlWithResult(string sql)
        ...{
            object obj;
            SqlConnection conn = new SqlConnection(this.connString);
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.CommandTimeout = 0;
            try
            ...{
                cmd.Connection.Open();
                obj = cmd.ExecuteScalar();
            }
            catch (Exception ex)
            ...{
                throw ex;
            }
            finally
            ...{
                if (cmd.Connection.State == ConnectionState.Open)
                    cmd.Connection.Close();
            }

            return obj;
        }

        /**//// <summary>
        /// 执行Sql 语句，返回DataTable
        /// </summary>
        /// <param name="sql">sql 语句</param>
        /// <returns>sql 语句的执行结果</returns>
        public DataTable GetDataTable(string sql)
        ...{
            DataTable dt = new DataTable();
            SqlDataAdapter adp = new SqlDataAdapter(sql, this.connString);
            adp.SelectCommand.CommandTimeout = 0;
            adp.Fill(dt);
            CommonDAL.KillStringInDataTable(dt, new string[] ...{"'"});
            return dt;
        }
        #endregion
    }
}