DBUtility/SQLHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;

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

namespace ThreeTierTest.DBUtility
{
    /// <summary>
    /// 操作数据库的类
    /// </summary>
    public abstract class SQLHelper
    {
        private static readonly string connString = ConfigurationManager.ConnectionStrings["SQLStudentConnString"].ConnectionString;

        /// <summary>
        /// 预处理命令
        /// </summary>
        /// <param name="com">命令对象</param>
        /// <param name="con">连接对象</param>
        /// <param name="trans">事务对象</param>
        /// <param name="comType">命令类型</param>
        /// <param name="ComText">命令文本</param>
        /// <param name="paras">参数列表</param>
        private static void PrepareCommand(SqlCommand com, SqlConnection con, SqlTransaction trans, CommandType comType, string ComText, params SqlParameter[] paras)
        {
            com.Connection = con;
            com.CommandText = ComText;
            com.CommandType = comType;

            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }

            if (trans != null)
            {
                com.Transaction = trans;
            }

            if (paras != null)
            {
                foreach (SqlParameter  p in paras)
                {
                    if (p != null)
                    {
                        com.Parameters.Add(p);
                    }
                }
            }
        }

        /// <summary>
        /// 执行读取器操作
        /// </summary>
        /// <param name="comType">命令类型</param>
        /// <param name="ComText">命令文本</param>
        /// <param name="paras">参数列表</param>