public static List <string> GetFirstRow(EmDbType dbType, string connString, CommandType cmdType, string cmdText,
params DbParameter[] commandParameters)
{
if (string.IsNullOrEmpty(connString))
{
throw new ArgumentNullException("connString");
}
if (string.IsNullOrEmpty(cmdText))
{
throw new ArgumentNullException("cmdText");
}
try
{
var conn = DBFactory.NewConnection(dbType, connString);
conn.Open();
return(GetFirstRow(conn, dbType, cmdType, cmdText, commandParameters));
}
catch (Exception ex)
{
EventLogger.Log("SqlHelper.GetFirstRow 【" + cmdText + "】", ex);
OpenConnection(dbType, connString); //重新刷新
return(null);
}
}
/// <summary>
/// 执行带参数的SQL语句
/// </summary>
/// <param name="dbType"></param>
/// <param name="connString"></param>
/// <param name="cmdType"></param>
/// <param name="cmdText"></param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public static string ExecuteNonQuery(EmDbType dbType, string connString, CommandType cmdType, string cmdText,
params DbParameter[] commandParameters)
{
if (string.IsNullOrEmpty(connString))
{
throw new ArgumentNullException("connString");
}
if (string.IsNullOrEmpty(cmdText))
{
throw new ArgumentNullException("cmdText");
}
try
{
DbConnection conn = DBFactory.NewConnection(dbType, connString);
return(ExecuteNonQuery(conn, dbType, cmdType, cmdText, commandParameters));
}
catch (Exception ex)
{
EventLogger.Log($"SqlServerHelper.ExecuteNonQuery SQL[{cmdText}] 错误.", ex);
OpenConnection(dbType, connString); //重新连接
return(ex.Message);
}
}
public static EmDbType MainDbType = EmDbType.None; //主 数据库类型
#endregion
#region 0.1 主数据初始化
/// <summary>
/// 初始化主连接
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="datasource">数据源</param>
/// <param name="database">数据库</param>
/// <param name="userid">用户名</param>
/// <param name="password">密码</param>
/// <returns></returns>
public static bool InitialMainConn(EmDbType dbType, string datasource, string database, string userid, string password)
{
string connnString = DBFactory.BuildConnStr(dbType, datasource, database, userid, password);
MainConnectionString = connnString;
MainDbType = dbType;
MainConn = DBFactory.NewConnection(dbType, connnString);
return(InitialMainConn(dbType, connnString));
}
/// <summary>
/// 初始化主连接
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <param name="connnString">连接字符串</param>
/// <returns></returns>
public static bool InitialMainConn(EmDbType dbType, string connnString)
{
if (string.IsNullOrEmpty(connnString))
{
throw new ArgumentNullException("connnString");
}
MainConnectionString = connnString;
MainDbType = dbType;
MainConn = DBFactory.NewConnection(dbType, connnString);
return(RefreshMainSqlConnection());
}
/// <summary>
/// 打开数据库连接
/// </summary>
/// <param name="dbType"></param>
/// <param name="connString">数据库连接语句</param>
/// <returns></returns>
public static bool OpenConnection(EmDbType dbType, string connString)
{
try
{
DbConnection conn = DBFactory.NewConnection(dbType, connString);
conn.Open();
return(true);
}
catch (Exception ex)
{
string error = $"打开链接失败，连接语句 [{connString}].";
EventLogger.Log(error, ex);
return(false);
}
}
public static string ExecuteNonQuerys(EmDbType dbType, string connString, List <string> sqlList)
{
if (string.IsNullOrEmpty(connString))
{
throw new ArgumentNullException("connString");
}
try
{
DbConnection conn = DBFactory.NewConnection(dbType, connString);
return(ExecuteNonQuerys(conn, dbType, sqlList));
}
catch (Exception ex)
{
EventLogger.Log("SqlHelper.ExecuteNonQuerys 错误.", ex);
OpenConnection(dbType, connString); //重新连接
return(ex.Message);
}
}
/// <summary>
/// 刷新连接
/// </summary>
/// <param name="connectionString"></param>
/// <returns></returns>
public static bool RefreshSqlConnection(string connectionString)
{
try
{
if (!string.IsNullOrEmpty(connectionString))
{
MainConnectionString = connectionString;
}
MainConn = DBFactory.NewConnection(MainConnectionString);
MainConn.Open();
return(true);
}
catch (Exception ex)
{
string error = $"打开链接失败，连接语句 [{connectionString}].";
EventLogger.Log(error, ex);
return(false);
}
}
public static DbDataReader ExecuterReader(string connectionString, CommandType cmdType, string cmdText,
params DbParameter[] commandParameters)
{
if (string.IsNullOrEmpty(connectionString))
{
throw new ArgumentNullException("connectionString");
}
if (string.IsNullOrEmpty(cmdText))
{
throw new ArgumentNullException("cmdText");
}
try
{
var conn = DBFactory.NewConnection(connectionString);
conn.Open();
var cmd = DBFactory.NewCommand(conn);
cmd.CommandType = cmdType;
cmd.CommandText = cmdText;
if (commandParameters != null)
{
foreach (var param in commandParameters)
{
cmd.Parameters.Add(param);
}
}
var dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return(dr);
}
catch (Exception ex)
{
EventLogger.Log("SqlHelper.ExecuterReader 【" + cmdText + "】", ex);
RefreshSqlConnection();
return(null);
}
}