App_Code/SqlHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
using System.Data;


    public class SqlHelper
    {
      static   public string connstr = WebConfigurationManager.ConnectionStrings["xxjsConnectionString"].ConnectionString;

      #region 执行一条sql语句,执行SQL语句，返回记录数
      public static int GetSqlCount(string sql, SqlParameter[] p)
      {

          using (SqlConnection conn = new SqlConnection(connstr))
          {
              using (SqlCommand cmd = new SqlCommand(sql, conn))
              {
                  try
                  {
                      PrepareCommand(cmd, conn, null, sql, p);
                      int rows =Convert .ToInt32 ( cmd.ExecuteScalar());
                      cmd.Parameters.Clear();
                      return rows;
                      //if (rows > 0)
                      //{
                      //    return true;
                      //}
                      //else
                      //{
                      //    return false;
                      //}
                  }
                  catch (Exception e)
                  {
                      conn.Close();
                      throw new Exception(e.Message);
                  }
              }
          }

      }
      #endregion

      #region 执行一条sql语句,执行SQL语句，返回影响的记录数  insert,delete,update语句

      public static bool ExecuteNonQuery(string sql, SqlParameter[] p)
        {
            
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    try
                    {
                        PrepareCommand(cmd, conn, null, sql, p);
                        int rows = cmd.ExecuteNonQuery();