SQLHelper.cs

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166

/// <summary> ///連接數據庫字符串 ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// </summary> private static string connectionString;   /// <summary> /// /// </summary> static DBHelper() {     DataSetingConfig dbconnection = new DataSetingConfig();     dbconnection.GetConString();//讀文件內空中的連按字符串     connectionString = DataSetingConfig.conStr;//@"Data Source=.;Initial Catalog=GeovinDuHr;User ID=sa;Password=8888888"; } /// <summary> /// /// </summary> /// <param name="hasOpen"></param> /// <returns></returns> public static SqlConnection GetConnection(bool hasOpen) {     SqlConnection conn = new SqlConnection(connectionString);     if (hasOpen)         conn.Open();     return conn; } /// <summary> /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static SqlDataReader GetReader(string sql, CommandType cmdType, params SqlParameter[] sqlParams) {     SqlCommand cmd = new SqlCommand();     cmd.CommandType = cmdType;     cmd.CommandText = sql;     if (sqlParams != null)         cmd.Parameters.AddRange(sqlParams);     SqlConnection conn = GetConnection(true);     cmd.Connection = conn;     return cmd.ExecuteReader(CommandBehavior.CloseConnection); } /// <summary> /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static Object GetObject(string sql, CommandType cmdType, params SqlParameter[] sqlParams) {     object ret = null;     SqlCommand cmd = new SqlCommand();     cmd.CommandType = cmdType;     cmd.CommandText = sql;     if (sqlParams != null)         cmd.Parameters.AddRange(sqlParams);     SqlConnection conn = GetConnection(true);     cmd.Connection = conn;     try     {         ret = cmd.ExecuteScalar();     }     finally     {         conn.Close();     }     return ret; } /// <summary> /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static int ExecuteSql(string sql, CommandType cmdType, params SqlParameter[] sqlParams) {     int ret = 0;     SqlCommand cmd = new SqlCommand();     cmd.CommandType = cmdType;     cmd.CommandText = sql;     if (sqlParams != null)         cmd.Parameters.AddRange(sqlParams);     SqlConnection conn = GetConnection(true);     cmd.Connection = conn;     try     {         ret = cmd.ExecuteNonQuery();     }     finally     {         conn.Close();     }     return ret; } /// <summary> /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static DataTable GetTable(string sql, CommandType cmdType, params SqlParameter[] sqlParams) {     DataTable dt = new DataTable();     SqlCommand cmd = new SqlCommand();     cmd.CommandType = cmdType;     cmd.CommandText = sql;     if (sqlParams != null)         cmd.Parameters.AddRange(sqlParams);     SqlConnection conn = GetConnection(true);     cmd.Connection = conn;     SqlDataAdapter da = new SqlDataAdapter(cmd);     try     {         da.Fill(dt);     }     finally     {         conn.Close();     }     return dt; } /// <summary> /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="sqlParams"></param> /// <returns></returns> public static DataSet GetDataSet(string sql, CommandType cmdType, params SqlParameter[] sqlParams) {     DataSet dt = new DataSet();     SqlCommand cmd = new SqlCommand();     cmd.CommandType = cmdType;     cmd.CommandText = sql;     if (sqlParams != null)         cmd.Parameters.AddRange(sqlParams);     SqlConnection conn = GetConnection(true);     cmd.Connection = conn;     SqlDataAdapter da = new SqlDataAdapter(cmd);     try     {         da.Fill(dt);     }     finally     {         conn.Close();     }     return dt; }

參考： http://www.koders.com/csharp/fidD4121D6E4BCA2DAB656D770903FECBFF7427D242.aspx