DAL/SQLHelper.cs

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

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

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

namespace DAL
{
    public abstract class DBHelper
    {
        public SqlConnection Getconn()
        {
            string Strconn = ConfigurationManager.AppSettings["conn"].ToString();
            SqlConnection conn = new SqlConnection(Strconn);
            return conn;
        }
    }

    public class SQLHelper:DBHelper
    {

        private DataSet ds;
        private SqlConnection conn;
        private SqlCommand cmd;
        private SqlDataAdapter sda;

        //数据库操作类

        public int RunSQL(string sql)
        {
            int count = 0;
            try
            {
                conn = Getconn();
                conn.Open();
                cmd = new SqlCommand(sql, conn);
                count = cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally {
                conn.Close();
            }
            return count;
        }

        //返回首行首列
        public int ReturnSQL(string sql)
        {
            int count = 0;
            try
            {
                conn = Getconn();
                conn.Open();
                cmd = new SqlCommand(sql, conn);
                count = (int)cmd.ExecuteScalar();
            }