DA/SqlDB.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DA
{
    class SqlDB
    {
        public static string sConn = System.Configuration.ConfigurationManager.ConnectionStrings["TeaManageConnectionString"].ConnectionString;
        public static SqlConnection con = new SqlConnection(sConn);
        /// <summary>
        /// 返回SqlCommand
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static SqlCommand sqlCom(string sql)
        {
            SqlCommand com = new SqlCommand(sql, con);
            return com;
        }

        /// <summary>
        /// 返回SqlDataAdapter
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static SqlDataAdapter sqlDa(string sql)
        {
            SqlDataAdapter da = new SqlDataAdapter(sqlCom(sql));
            return da;
        }
        /// <summary>
        /// 增删改方法
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static bool ExcuteSql(string sql)
        {
            SqlConnection conn = new SqlConnection(sConn);
            SqlCommand com = new SqlCommand();
            com.Connection = conn;
            com.CommandText = sql;

            int result = -1;

            conn.Open();
            try
            {
                result = com.ExecuteNonQuery();
                return true;

            }
            catch
            {

                return false;

            }