eUI.DAL/DBUtility/DBHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace eUI.DAL.DBUtility
{
    public class DBHelper
    {

        public static string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["conStr"].ToString();

        #region 执行sql语句
        /// <summary>
        /// 执行sql语句
        /// </summary>
        /// <param name="connStr">连接字符串</param>
        /// <param name="cmdText">sql语句</param>
        /// <returns>返回受影响的行数</returns>
        public static int ExcuteNoQuerySql(string cmdText)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                try
                {
                    SqlCommand cmd = new SqlCommand(cmdText, conn);
                    //执行返回结果   
                    int iResult = cmd.ExecuteNonQuery();
                    cmd.Dispose();
                    return iResult;
                }
                catch (Exception ex)
                {
                    //Response
                    return 0;
                }
            }
        }
        #endregion

        #region 查询数据库结果记录集
        /// <summary>
        /// 查询数据库结果记录集
        /// </summary>
        /// <param name="connStr">连接字符串</param>
        /// <param name="cmdText">sql语句</param>
        /// <returns>返回DataTable</returns>
        public static DataTable SearchSql(string cmdText)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                SqlDataAdapter sda = new SqlDataAdapter(cmdText, conn);
                DataSet ds = new DataSet();
                sda.Fill(ds);
                return ds.Tables[0];
            }