/// <summary>
/// 根据SQL参数重复执行SQL语句
/// </summary>
/// <returns>受影响的行数</returns>
public virtual int ExecuteSql()
{
int rowsCount = -1;
Conn = new SqlConnection(this.ConnectionString);
Conn.Open();
connIsOpen = true;
Sqltrans = Conn.BeginTransaction(IsolationLevel.ReadCommitted, SqlTransactionName);
SqlCommand cmd = new SqlCommand();
cmd.Connection = Conn;
cmd.CommandText = CmdText;
cmd.Transaction = Sqltrans;
cmd.CommandType = CommandType.Text;//cmdType;
if (CmdParams != null)
{
cmd.Parameters.AddRange(CmdParams.ToArray());
rowsCount = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
//Sqltrans.Commit();
return(rowsCount);
}