/// <summary>
/// 事务下操作多个sql返回true or false
/// </summary>
/// <returns></returns>
public static bool Execute(List <KeyValuePair <string, object> > vals)
{
//ar result = -1;
using (MySqlConnection conn = DapperFactory.CreateMySqlConnection())
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (var trans = conn.BeginTransaction())
{
foreach (var val in vals)
{
try
{
conn.Execute(val.Key, val.Value, trans, 30, CommandType.Text);
}
catch (Exception e)
{
//if (result <= 0)
trans.Rollback();
return(false);
}
}
trans.Commit();
}
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
return(true);
}