只执行SQL语句(不执行存储过程)

1. using System;
2. using System.Collections.Generic;
3. using System.Text;
4. using System.Data;
5. using System.Data.SqlClient;
7. namespace DBUtility
8. {
9.     public class DBHelper
10.     {
11.         private static SqlConnection connection;
12.         //连接数据库
13.         public static SqlConnection Connection
14.         {
15.             get
16.             {
17.                 string sqlCon = "server=lyylsoft-server,3668;database=crm;uid=sa;pwd=123;";
18.                 if (connection == null)
19.                 {
20.                     connection = new SqlConnection(sqlCon);
21.                     connection.Open();
22.                 }
23.                 else if (connection.State == ConnectionState.Closed)
24.                 {
25.                     connection.Open();
26.                 }
27.                 else if (connection.State == ConnectionState.Broken)
28.                 {
29.                     connection.Close();
30.                     connection.Open();
31.                 }
32.                 return connection;
33.             }
34.         }
36.         //执行不带参数的非查询语句
37.         public static int ExecuteCommand(string sql)
38.         {
39.             SqlCommand scmd = new SqlCommand(sql, Connection);
40.             int row = scmd.ExecuteNonQuery();
41.             return row;
42.         }
44.         //执行带参数的非查询语句
45.         public static int ExecuteCommand(string sql, params SqlParameter[] values)
46.         {
47.             SqlCommand scmd = new SqlCommand(sql, Connection);
48.             scmd.Parameters.AddRange(values);
49.             int row = scmd.ExecuteNonQuery();
50.             return row;
51.         }
53.         //执行不带参数的查询语句
54.         public static SqlDataReader GetReader(string sql)
55.         {
56.             SqlCommand scmd = new SqlCommand(sql, Connection);
57.             SqlDataReader reader = scmd.ExecuteReader();
58.             return reader;
59.         }
61.         //执行带参数的查询语句
62.         public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
63.         {
64.             SqlCommand scmd = new SqlCommand(sql, Connection);
65.             scmd.Parameters.AddRange(values);
66.             SqlDataReader reader = scmd.ExecuteReader();
67.             return reader;
68.         }
70.         //执行不带参数的判断是否有查询结果的语句
71.         public static int GetScalar(string safeSql)
72.         {
73.             SqlCommand cmd = new SqlCommand(safeSql, Connection);
74.             int result = Convert.ToInt32(cmd.ExecuteScalar());
75.             return result;
76.         }
78.         //执行带参数的判断是否有查询结果的语句
79.         public static int GetScalar(string safeSql, params SqlParameter[] values)
80.         {
81.             SqlCommand cmd = new SqlCommand(safeSql, Connection);
82.             cmd.Parameters.AddRange(values);
83.             int result = Convert.ToInt32(cmd.ExecuteScalar());
84.             return result;
85.         }
87.         //此方法用于以DataTable形式返回多条查询结果
88.         public static DataTable GetDataSet(string sql)
89.         {
90.             SqlDataAdapter sda = new SqlDataAdapter(sql, Connection);
91.             DataSet ds = new DataSet();
92.             sda.Fill(ds);
93.             return ds.Tables[0];
94.         }
95.     }
96. }