/// <summary>
/// 执行多条sql语句
/// </summary>
/// <param name="has"></param>
public static void ExecuteSqlTranSortedList(SortHashTable SQLStringList)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
SqlCommand cmd = new SqlCommand();
try
{
ICollection keys = SQLStringList.Keys;
//将键集合转换为ArrayList类
ArrayList al = new ArrayList(keys);
foreach (object key in al)
{
string cmdText = key.ToString();
SqlParameter[] cmdParms = (SqlParameter[])SQLStringList[key];
PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
}
public class TranAttribute : Attribute
{
public TranAttribute(bool isNeedTran)
{
this.isNeedTran = isNeedTran;
}
private bool isNeedTran;
public bool IsNeedTran
{
get { return isNeedTran; }
}
public string DefaultValue { get; set; }
}
