| private ExecuteNoQuery ( string cmdText ) : int | ||
| cmdText | string | |
| return | int | |
/// <summary>
/// 执行Transaction，完成后关闭连接
/// </summary>
/// <param name="sqls">sql数组</param>
/// <returns>总影响条数，返回0为事务执行失败</returns>
public static int ExecuteTransaction(string[] sqls)
{
int i = 0;
DBHelperBase _DBHelper = null;
try
{
_DBHelper = CreateHelper();
_DBHelper.BeginTransaction();
foreach (string sql in sqls)
{
_DBHelper.ExecuteNoQuery(sql);
i++;
}
_DBHelper.CommitTransaction();
return(i);
}
catch (Exception ex)
{
_DBHelper.RollbackTransaction();
throw ex;
}
finally
{
if (_DBHelper != null)
{
_DBHelper.Close();
}
}
}
/// <summary>
/// 非查询操作
/// </summary>
/// <param name="sql">sql字符串</param>
/// <param name="parameters">参数集合</param>
/// <returns></returns>
public static int ExecuteNoQuery(string sql, DBHelperParmCollection parameters)
{
DBHelperBase _DBHelper = null;
try
{
_DBHelper = CreateHelper();
return(_DBHelper.ExecuteNoQuery(sql, parameters));
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (_DBHelper != null)
{
_DBHelper.Close();
}
}
}
/// <summary>
/// 非查询操作
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static int ExecuteNoQuery(StringBuilder sbsql)
{
DBHelperBase _DBHelper = null;
try
{
_DBHelper = CreateHelper();
return(_DBHelper.ExecuteNoQuery(sbsql.ToString()));
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (_DBHelper != null)
{
_DBHelper.Close();
}
}
}
