//返回SqlDataReader对象方法 public static SqlDataReader ExecuteReader(string sql, CommandType cmdType, params SqlParameter[] pms) { DecryptAndEncryptionHelper dec = new DecryptAndEncryptionHelper(); string d = dec.Decrypto(ConnStr); SqlConnection conn = new SqlConnection(dec.Decrypto(ConnStr)); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } try { conn.Open(); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception) { conn.Close(); conn.Dispose(); throw; } } }
//封装一个返回DataTable的方法 public static DataTable ExecuteDataTable(string sql, CommandType cmdType, params SqlParameter[] pms) { DecryptAndEncryptionHelper dec = new DecryptAndEncryptionHelper(); DataTable dt = new DataTable(); var a = dec.Decrypto(ConnStr); using (SqlDataAdapter adapter = new SqlDataAdapter(sql,ConnStr)) { adapter.SelectCommand.CommandType = cmdType; if (pms != null) { adapter.SelectCommand.Parameters.AddRange(pms); } adapter.Fill(dt); } return dt; }
//Server=.;database=xgxDB;uid=sa;pwd=123456 //执行增删改 public static int ExecuteNonQury(string sql, CommandType cmdType, params SqlParameter[] pms) { DecryptAndEncryptionHelper dec = new DecryptAndEncryptionHelper(); using (SqlConnection conn = new SqlConnection(dec.Decrypto(ConnStr))) { using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } conn.Open(); return cmd.ExecuteNonQuery(); } } }
private static void ConfigLogConnection() { if (String.IsNullOrEmpty(ConfigInformation.Connectiong)) { string connstr = ConfigurationManager.AppSettings.Get("Connection"); var helper = new DecryptAndEncryptionHelper(ConfigInformation.Key, ConfigInformation.Vector); connstr = helper.Decrypto(connstr); ConfigInformation.Connectiong = connstr; } IAppender[] appenders = log4net.LogManager.GetRepository().GetAppenders(); foreach (IAppender appender in appenders) { if (appender.GetType() == typeof(AdoNetAppender)) { ((AdoNetAppender)appender).ConnectionString = ConfigInformation.Connectiong; ((AdoNetAppender)appender).ActivateOptions(); } } }