|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/c87b3efd/cc6243dc/ |
?#pragma checksum "D:\wwwroot\zgyzd233com\wwwroot\App_Code\SqlHelper.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "1A0428D9CA67A710282630D13F0E100D"
#line 1 "D:\wwwroot\zgyzd233com\wwwroot\App_Code\SqlHelper.cs"
using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
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.Data.SqlClient;
using System.Configuration;
using System.Data.OleDb;
public abstract class SqlHelper
{
protected static string connectionString = System.Configuration.ConfigurationManager.AppSettings["cn"].ToString() + HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["datasource"]);
// 执行SQL语句，返回影响的纪录数
public static int ExecuteSql(string SQLString)
{
using ( OleDbConnection connection = new OleDbConnection(connectionString))
{
using ( OleDbCommand cmd = new OleDbCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.OleDb.OleDbException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
//执行带一个存储过程参数的的SQL语句，参数内容,好比一个字段是体式复杂的文章，有特殊符号，能够通过这个方式增长
public static int ExecuteSql(string SQLString, string content)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbCommand cmd = new OleDbCommand(SQLString, connection);
System.Data.OleDb.OleDbParameter myParameter = new System.Data.OleDb.OleDbParameter("@content", OleDbType.LongVarChar);
myParameter.Value = content;
cmd.Parameters.Add(myParameter);
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.OleDb.OleDbException E)
{
throw new Exception(E.Message);
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
//执行一条推算查问了局语句，返回查问了局（object）
public static object GetSingle(string SQLString)
{
using ( OleDbConnection connection = new OleDbConnection(connectionString))
{
using ( OleDbCommand cmd = new OleDbCommand(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.OleDb.OleDbException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
//执行查问语句，返回SqlDataReader
public static OleDbDataReader ExecuteReader(string strSQL)
{
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(strSQL, connection);
try
{
connection.Open();
OleDbDataReader myReader = cmd.ExecuteReader();
return myReader;
}
catch (System.Data.OleDb.OleDbException E)
{
throw new Exception(E.Message);
}
}
//执行查问语句，返回DataSet
public static DataSet Query(string SQLString)
{
using ( OleDbConnection connection = new OleDbConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.OleDb.OleDbException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}
/// <summary>
/// 带参数的sql语句执行 ，返回数据集
/// </summary>
/// <param name="strsql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public static DataSet Query(string strsql, OleDbParameter[] parameters)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
OleDbDataAdapter sqlDA = new OleDbDataAdapter();
sqlDA.SelectCommand = BuildCmd(connection, strsql, parameters);
sqlDA.Fill(dataSet);
connection.Close();
return dataSet;
}
}
/// <summary>
/// 带参数的sql语句执行，返回int
/// </summary>
/// <param name="SQLString"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public static int ExecuteSql(string SQLString, OleDbParameter[] parameters)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
using (OleDbCommand cmd = new OleDbCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = BuildCmd(connection, SQLString, parameters).ExecuteNonQuery();
connection.Close();
return rows;
}
catch (System.Data.OleDb.OleDbException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
/// <summary>
/// 把数据赋值给参数
/// </summary>
/// <param name="connection"></param>
/// <param name="Strsql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
private static OleDbCommand BuildCmd(OleDbConnection connection, string Strsql, OleDbParameter[] parameters)
{
OleDbCommand cmd = new OleDbCommand(Strsql, connection);
cmd.CommandType = CommandType.Text;
foreach (OleDbParameter par in parameters)
{
cmd.Parameters.Add(par);
}
return cmd;
}
//谬误跳转
public static void MessageShow(Page page, string message)
{
string javamessage = "<script>alert('" + message + "');</script>";
page.ClientScript.RegisterStartupScript(page.GetType(), "SystemMessage", javamessage);
}
public static void MessageShow(Page page, string message, string url)
{
string javamessage = "<script>alert('" + message + "');location.href='" + url + "';</script>";
page.ClientScript.RegisterStartupScript(page.GetType(), "SystemMessage", javamessage);
}
public static void MessageShow2(Page page, string message, string url)
{
string javamessage = "<script>alert('" + message + "');parent.location.href='" + url + "';</script>";
page.ClientScript.RegisterStartupScript(page.GetType(), "SystemMessage", javamessage);
}
public static void MessageShow3(Page page, string message, string url)
{
string javamessage = "<script> if (window.confirm('" + message + "')) { window.open('" + url + "','_top');}</script> ";
page.ClientScript.RegisterStartupScript(page.GetType(), "SystemMessage", javamessage);
}
}
#line default
#line hidden