//////連接數據庫字符串 ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// private static string connectionString; ////// /// static DBHelper() { DataSetingConfig dbconnection = new DataSetingConfig(); dbconnection.GetConString();//讀文件內空中的連按字符串 connectionString = DataSetingConfig.conStr;//@"Data Source=.;Initial Catalog=GeovinDuHr;User ID=sa;Password=8888888"; } ////// /// /// ///public static SqlConnection GetConnection(bool hasOpen) { SqlConnection conn = new SqlConnection(connectionString); if (hasOpen) conn.Open(); return conn; } /// /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// /// /// /// ///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); } /// /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// /// /// /// ///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; } /// /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// /// /// /// ///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; } /// /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// /// /// /// ///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; } /// /// ///塗聚文 2011-09-25 ///締友計算機信息技術有限公司 /// /// /// /// ///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; }
參考: