Common/SQLHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;
namespace Common
{
   public  class SQLHelper
    {
       public SQLHelper()
        {
        }
       public void DataCom(string sqlstr)
        {
            string constring = SQL.constr;
            SqlConnection str = new SqlConnection(constring);
            str.Open();            
            SqlCommand sqlcom = new SqlCommand(sqlstr, str);
            sqlcom.ExecuteNonQuery();
            str.Close();
        }
       public object GetSingle(string SQLString)
       {
           string constring = SQL.constr;
           using (SqlConnection connection = new SqlConnection(constring))
           {
               using (SqlCommand cmd = new SqlCommand(SQLString, connection))
               {
                   try
                   {
                       connection.Open();
                       object obj = cmd.ExecuteScalar();
                       if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
                       {
                           return null;
                       }
                       else
                       {
                           return obj;
                       }
                   }
                   catch (System.Data.SqlClient.SqlException e)
                   {
                       connection.Close();
                       throw e;
                   }
               }
           }
       }
       public bool Exists(string strSql)
       {