Tools/BaseDao.cs

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

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

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

namespace AgingTest.Tools
{
    class BaseDao
    {
        //public static string ConnectionString = "Data Source=115.28.208.24;Initial Catalog=Deqi;Persist Security Info=True;User ID=sa;Password=xxxx";
        //public static string ConnectionString = "Data Source=127.0.0.1;Initial Catalog=AgingTest;Persist Security Info=True;User ID=sa;Password=dyzn123456";
        public static string ConnectionString = "Data Source=.;Initial Catalog=AgingTest;Persist Security Info=True;User ID=sa;Password=51Aspx";

        public static SqlConnection getConnection()
        {
            SqlConnection conn = new SqlConnection(ConnectionString);
            return conn;
        }

        /***************直接执行一条sql，返回影响的行数***************/
        /// <summary>
        /// 运行sql
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <returns>返回影响的条数</returns>
        public static int execute(string sql)
        {
            SqlCommand command = new SqlCommand(sql);//SDFASDF
            SqlConnection sqlConn = getConnection();
            command.Connection = sqlConn;
            if (sqlConn.State != ConnectionState.Open)
            {
                sqlConn.Open();
            }
            SqlDataReader rd = command.ExecuteReader();
            //int count = command.ExecuteReader();//.ExecuteNonQuery();
            int i = 0;
            while (rd.Read())
            {
                i++;
            }
            rd.Close();
            rd.Dispose();
            sqlConn.Close();
            sqlConn.Dispose();
            return i;
        }

        public void CheckConnection()
        {
            //SqlCommand command = new SqlCommand();//SDFASDF
            SqlConnection sqlConn = getConnection();
            //command.Connection = sqlConn;
            if (sqlConn.State != ConnectionState.Open)