DBherper类

vusing System;

using System.Data.SqlClient; using System.Configuration; using System.Data;

namespace B2CSYS.DAL {

public static class DBHelper {

//数据库连接属性

private static SqlConnection connection; public static SqlConnection Connection {

get {

string

connectionString

ConfigurationManager.ConnectionStrings[\ if (connection == null) {

connection = new SqlConnection(connectionString); connection.Open();

}

else if (connection.State == System.Data.ConnectionState.Closed) {

connection.Open();

}

else if (connection.State == System.Data.ConnectionState.Broken) {

connection.Close(); connection.Dispose(); connection.Open(); }

return connection; } }

///

public static void ExecProc(string strProName, SqlParameter[] para) {

//connection.Open();

try {

SqlCommand sqlcmd = connection.CreateCommand();

=

sqlcmd.CommandText = strProName;

sqlcmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter paras in para) {

sqlcmd.Parameters.Add(paras); }

sqlcmd.ExecuteNonQuery(); }

finally {

connection.Close(); } }

///

public static bool ExecNoQuery(string sql) {

//connection.Open(); try {

SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = sql; return true; } catch {

return false; }

//Connection.Close(); }

///

public static int ExecuteCommand(string safeSql) {

SqlCommand cmd = new SqlCommand(safeSql, Connection); int result = cmd.ExecuteNonQuery(); return result; }

///

public static int ExecuteCommand(string sql, params SqlParameter[] values)

{

SqlCommand cmd = new SqlCommand(sql, Connection); cmd.Parameters.AddRange(values); return cmd.ExecuteNonQuery(); }

///

public static int GetScalar(string safeSql) {

SqlCommand cmd = new SqlCommand(safeSql, Connection); int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; }

///

public static int GetScalar(string sql, params SqlParameter[] values) {

SqlCommand cmd = new SqlCommand(sql, Connection); cmd.Parameters.AddRange(values);

int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; }

///

public static SqlDataReader GetReader(string safeSql) {

SqlCommand cmd = new SqlCommand(safeSql, Connection); SqlDataReader reader = cmd.ExecuteReader(); return reader; }

///

public static SqlDataReader GetReader(string sql, params SqlParameter[] values) {

SqlCommand cmd = new SqlCommand(sql, Connection); cmd.Parameters.AddRange(values);

SqlDataReader reader = cmd.ExecuteReader(); return reader; }

public static DataTable GetDataSet(string safeSql)

{

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand(safeSql, Connection); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds);

return ds.Tables[0]; }

public static DataTable GetDataSet(string sql, params SqlParameter[] values) {

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand(sql, Connection); cmd.Parameters.AddRange(values);

SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); return ds.Tables[0]; }

///

public static string ReturnStringScalar(string sql) {

SqlCommand cmd = new SqlCommand(sql, Connection); try

{

string result = cmd.ExecuteScalar().ToString(); return result; }

catch (Exception e)

{

Console.WriteLine(e.Message); return \ }

connection.Close(); }

///

public static bool ExecTSQL(string[] sqls) {

connection.Open(); SqlTransaction trans connection.BeginTransaction(IsolationLevel.ReadCommitted);

=

try

{

for (int i = 0; i < sqls.Length; i++) {

if (sqls[i] == \ {

continue;

}

SqlCommand cmd = connection.CreateCommand();

} } }

cmd.Transaction = trans; cmd.CommandText = sqls[i]; cmd.ExecuteNonQuery(); }

trans.Commit(); return true; } catch { trans.Rollback(); return false; }

finally {

trans = null; connection.Close(); }

本文来源：https://www.bwwdw.com/article/d2v7.html