/// <summary>
/// 批量更新记录 Dictionary[条件,表]
/// </summary>
public static int Update(IEnumerable <KeyValuePair <string, T> > tables)
{
var tabs = tables.Select(a => new KeyValuePair <string, Table2 <T, TK> >(a.Key, a.Value as Table2 <T, TK>));
var updateTabs = tabs.Where(a => a.Value.__EditColumns.Count > 0).ToArray();
if (updateTabs.Length == 0)
{
return(0);
}
var sw = Stopwatch.StartNew();
var result = -1;
var sqls = new List <KeyValuePair <string, List <DbParameter> > >();
try
{
var sb = new StringBuilder();
var paraIndex = 0;
var parameters = new List <DbParameter>();
foreach (var table in updateTabs)
{
if (table.Value.__EditColumns.Count > 0)
{
sb.Append("\nupdate ").Append(table.Value.TableName).Append(" set ");
foreach (var column in table.Value.__EditColumns)
{
sb.Append("[").Append(column.Key).Append("]=@p").Append(parameters.Count.ToString()).Append(",");
parameters.Add(DbBase2 <TK> .CreateDbParameter("@p" + parameters.Count, column.Value));
paraIndex += 2;
}
sb.Remove(sb.Length - 1, 1);
sb.Append(" where ").Append(table.Key);
if (paraIndex > 1500)
{
sqls.Add(new KeyValuePair <string, List <DbParameter> >(sb.ToString(), parameters));
sb = new StringBuilder();
paraIndex = 0;
parameters = new List <DbParameter>();
}
}
}
if (sb.Length > 0)
{
sqls.Add(new KeyValuePair <string, List <DbParameter> >(sb.ToString(), parameters));
}
var option = new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted,
Timeout = new TimeSpan(0, 2, 0)
};
using (var trans = new TransactionScope(TransactionScopeOption.Required, option))
{
using (var conn = DbBase2 <TK> .GetSqlConnection(false))
{
foreach (var sql in sqls)
{
var cmd = new SqlCommand(sql.Key, conn)
{
CommandType = CommandType.Text
};
cmd.Parameters.AddRange(sql.Value.ToArray());
result += cmd.ExecuteNonQuery();
}
trans.Complete();
}
}
}
catch (Exception e)
{
Log.Error(e.Message + e.StackTrace);
}
var useTime = sw.ElapsedMilliseconds;
var logStr = "Table.Update({0}) 执行时间 {1} 毫秒".Formats(sqls.Join("\n"), useTime.ToString("F0"));
if (useTime > DbBase2 <TK> .WornigMilliseconds)
{
Log.Warn(logStr);
}
Log.Debug(logStr);
return(result);
}
