public bool BatchInsert(List <TEntity> entityList, int flushSize = 10000, IUnitOfWork uow = null, string tableName = null)
{
if (entityList == null || !entityList.Any())
{
return(false);
}
//判断有没有事务
var hasTran = true;
if (uow == null)
{
uow = DbContext.NewUnitOfWork();
hasTran = false;
}
try
{
if (_sqlAdapter.SqlDialect == SqlDialect.SQLite)
{
#region ==SQLite使用Dapper的官方方法==
if (EntityDescriptor.PrimaryKey.IsGuid())
{
entityList.ForEach(entity =>
{
SetCreatedBy(entity);
SetTenant(entity);
var value = EntityDescriptor.PrimaryKey.PropertyInfo.GetValue(entity);
if ((Guid)value == Guid.Empty)
{
value = _sqlAdapter.GenerateSequentialGuid();
EntityDescriptor.PrimaryKey.PropertyInfo.SetValue(entity, value);
}
});
}
Execute(_sql.Insert(tableName), entityList);
#endregion
}
else
{
#region ==自定义==
var sqlBuilder = new StringBuilder();
for (var t = 0; t < entityList.Count; t++)
{
var mod = (t + 1) % flushSize;
if (mod == 1)
{
sqlBuilder.Clear();
sqlBuilder.Append(_sql.BatchInsert(tableName));
}
var entity = entityList[t];
SetCreatedBy(entity);
SetTenant(entity);
sqlBuilder.Append("(");
for (var i = 0; i < _sql.BatchInsertColumnList.Count; i++)
{
var col = _sql.BatchInsertColumnList[i];
var value = col.PropertyInfo.GetValue(entity);
var type = col.PropertyInfo.PropertyType;
if (col.IsPrimaryKey && EntityDescriptor.PrimaryKey.IsGuid())
{
if ((Guid)value == Guid.Empty)
{
value = _sqlAdapter.GenerateSequentialGuid();
EntityDescriptor.PrimaryKey.PropertyInfo.SetValue(entity, value);
}
}
AppendValue(sqlBuilder, type, value);
if (i < _sql.BatchInsertColumnList.Count - 1)
{
sqlBuilder.Append(",");
}
}
sqlBuilder.Append(")");
if (mod > 0 && t < entityList.Count - 1)
{
sqlBuilder.Append(",");
}
else if (mod == 0 || t == entityList.Count - 1)
{
sqlBuilder.Append(";");
Execute(sqlBuilder.ToString(), uow: uow);
}
}
#endregion
}
if (!hasTran)
{
uow.Commit();
}
return(true);
}
catch
{
if (!hasTran)
{
uow.Rollback();
}
throw;
}
}
