private bool ImportCore(ImportFile file, ImportMap map, List <dynamic> data, Action <int, object, string, int, Guid> itemProcceed)
{
var mappings = new List <ColumnMapping>().DeserializeFromJson(map.MapCustomizations);
var columns = new List <string>().DeserializeFromJson(file.HeaderRow);
var attributes = _attributeFinder.FindByEntityName(file.TargetEntityName);
//更新记录时，根据哪些字段查询已存在的记录
var updatePrimaryFields = new List <string> {
attributes.Find(x => x.IsPrimaryField).Name
};
updatePrimaryFields.AddRange(mappings.Where(x => x.IsUpdatePrimaryField).Select(x => x.Mapping.Attribute));
int rowIndex = 0, failureCount = 0;
foreach (var d in data)
{
rowIndex++;
StringBuilder rowError = new StringBuilder();
var entity = new Entity(file.TargetEntityName);
var retrieveFilter = new Dictionary <string, object>();
for (int i = 0; i < columns.Count; i++)
{
var value = d[i];
var mapping = mappings[i].Mapping;
//字段
var attr = attributes.Find(x => x.Name.IsCaseInsensitiveEqual(mapping.Attribute));
//是否类型
if (attr.TypeIsBit() || attr.TypeIsState())
{
if (value == null)
{
if (mapping.NullHandle == "ignore")
{
}
else if (mapping.NullHandle == "defaultvalue")
{
value = attr.DefaultValue;
}
else if (mapping.NullHandle.IsInteger())
{
var item = _stringMapFinder.Find(x => x.AttributeId == attr.AttributeId && x.Value == int.Parse(mapping.NullHandle));
if (item != null)
{
value = item.Value;
}
else
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"不存在");
}
}
}
else
{
var v = (string)value;
var item = _stringMapFinder.Find(x => x.AttributeId == attr.AttributeId && x.Name == v);
if (item != null)
{
value = item.Value;
}
else
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"不存在");
}
}
}
//选项集类型
else if (attr.TypeIsPickList() || attr.TypeIsStatus())
{
if (value == null)
{
if (mapping.NullHandle == "ignore")
{
}
else if (mapping.NullHandle == "defaultvalue")
{
value = attr.DefaultValue;
}
else if (((string)value).IsInteger())
{
var item = attr.PickLists.Find(x => x.Value == (int)value);
if (item != null)
{
value = new OptionSetValue(item.Value);
}
else
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"不存在");
}
}
}
else
{
var v = (string)value;
var item = _optionSetDetailServiceFinder.Find(x => x.OptionSetId == attr.OptionSetId && x.Name == v);
if (item != null)
{
value = new OptionSetValue(item.Value);
}
else
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"不存在");
}
}
}
//引用类型
else if (attr.TypeIsLookUp() || attr.TypeIsOwner() || attr.TypeIsCustomer())
{
if (value != null)
{
var criteria = new Dictionary <string, object>();
if (((string)value).IsGuid())
{
criteria.Add(entity.IdName, value);
}
if (mapping.LookupName.IsNotEmpty())
{
criteria.Add(mapping.LookupName, value);
}
else
{
var primaryField = _attributeFinder.Find(x => x.EntityId == attr.ReferencedEntityId && x.IsPrimaryField == true);
criteria.Add(primaryField.Name, value);
}
var filter = new Sdk.Abstractions.Query.FilterExpression();
foreach (var c in criteria)
{
filter.AddCondition(c.Key, Sdk.Abstractions.Query.ConditionOperator.Equal, c.Value);
}
var matchedCount = _aggregateService.Count(attr.ReferencedEntityName, filter);
if (matchedCount > 1)
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"不唯一");
}
else
{
var referenced = _dataFinder.RetrieveByAttribute(attr.ReferencedEntityName, criteria, new List <string> {
attr.ReferencedEntityName + "Id"
});
if (referenced.NotEmpty())
{
if (attr.TypeIsOwner())
{
value = new OwnerObject(OwnerTypes.SystemUser, referenced.Id);
}
else
{
value = new EntityReference(attr.ReferencedEntityName, referenced.Id);
}
}
else
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"不存在");
}
}
}
}
//金额类型
else if (attr.TypeIsMoney() || attr.TypeIsSmallMoney())
{
if (value != null)
{
if (decimal.TryParse((string)value, out decimal v))
{
value = new Money(v);
}
else
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"格式错误");
}
}
}
//浮点型类型
else if (attr.TypeIsDecimal() || attr.TypeIsFloat())
{
if (value != null)
{
if (!decimal.TryParse((string)value, out _))
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"格式错误");
}
}
}
//整型类型
else if (attr.TypeIsInt())
{
if (value != null)
{
if (!((string)value).IsInteger())
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"格式错误");
}
}
}
//日期类型
else if (attr.TypeIsDateTime() || attr.TypeIsSmallDateTime())
{
if (value != null)
{
if (!((string)value).IsDateTime())
{
//失败记录
rowError.AppendLine($"\"{columns[i]}\"的值\"{value}\"格式错误");
}
}
}
else if (value != null)
{
value = (string)value;
}
if (rowError.Length == 0 && value != null)
{
entity.SetAttributeValue(attr.Name, value);
if (updatePrimaryFields.Exists(x => x.IsCaseInsensitiveEqual(attr.Name)))
{
retrieveFilter.Add(attr.Name, value);
}
}
}
int errorType = rowError.Length > 0 ? 2 : 0;//错误类型：数据=2
//重复数据的操作
if (retrieveFilter.Count > 0)
{
var existsEntity = _dataFinder.RetrieveByAttribute(file.TargetEntityName, retrieveFilter, updatePrimaryFields, true);
//不导入重复数据
if (file.DuplicateDetection == 1 && existsEntity.NotEmpty())
{
rowError.AppendLine("记录已存在");
}
//覆盖导入
else if (file.DuplicateDetection == 2 && existsEntity.NotEmpty())
{
entity.SetIdValue(existsEntity.Id);
}
//仅覆盖重复数据
else if (file.DuplicateDetection == 3)
{
if (existsEntity.NotEmpty())
{
entity.SetIdValue(existsEntity.Id);
}
else
{
rowError.AppendLine("记录不存在");
}
}
}
Guid recordId = entity.Id;
//本行数据验证通过
if (rowError.Length == 0)
{
try
{
if (recordId.IsEmpty())
{
recordId = _dataCreater.Create(entity);
}
else
{
_dataUpdater.Update(entity);
}
}
catch (Exception e)
{
errorType = 1;//错误类型：系统
rowError.AppendLine(e.Message);
}
}
if (rowError.Length > 0)
{
failureCount++;
}
//每行导入结果
itemProcceed(rowIndex, d, rowError.ToString(), errorType, recordId);
}
//文件导入结果
file.SuccessCount = data.Count - failureCount;
file.FailureCount = failureCount;
_importFileService.Update(file);
return(true);
}
private bool DeleteCore(Schema.Domain.Entity entityMetadata, List <Schema.Domain.Attribute> attributeMetadatas, Entity record, bool ignorePermissions = false)
{
if (!ignorePermissions)
{
VerifyEntityPermission(record, AccessRightValue.Delete, entityMetadata);
}
//cascade relationship, 1: N
var relationships = _relationShipFinder.Query(n => n
.Where(f => f.ReferencedEntityId == entityMetadata.EntityId)
);
//check referenced
var cascadeDeleteRestrict = relationships.Where(n => n.ReferencedEntityId == entityMetadata.EntityId && n.CascadeDelete == (int)CascadeDeleteType.Restrict && n.RelationshipType == RelationShipType.ManyToOne);
var primaryAttr = attributeMetadatas.Find(n => n.TypeIsPrimaryKey());
var primarykey = primaryAttr.Name;
record.IdName = primarykey;
var recordId = record.GetIdValue();
foreach (var cdr in cascadeDeleteRestrict)
{
var referencingRecord = _aggregateService.Count(cdr.ReferencingEntityName, new FilterExpression(LogicalOperator.And).AddCondition(cdr.ReferencingAttributeName, ConditionOperator.Equal, recordId));
if (referencingRecord > 0)
{
_relationShipFinder.WrapLocalizedLabel(cdr);
return(OnException(_loc["referenced"] + ": " + cdr.ReferencingEntityLocalizedName));
}
}
var result = false;
try
{
_organizationDataProvider.BeginTransaction();
InternalOnDelete(record, OperationStage.PreOperation, entityMetadata, attributeMetadatas);
//delete related records
var cascadeDelete = relationships.Where(n => n.ReferencedEntityId == entityMetadata.EntityId && n.CascadeDelete == (int)CascadeDeleteType.All && n.RelationshipType == RelationShipType.ManyToOne).ToList();
if (cascadeDelete.NotEmpty())
{
DeleteRelatedRecords(entityMetadata, attributeMetadatas, cascadeDelete, recordId);
}
//delete main record
result = _organizationDataProvider.Delete(record.Name, recordId, primarykey);
if (result)
{
//update maps
_mapUpdater.Update(entityMetadata, record, true);
_formulaUpdater.Update(entityMetadata, record);
_organizationDataProvider.CommitTransaction();
InternalOnDelete(record, OperationStage.PostOperation, entityMetadata, attributeMetadatas);
}
else
{
_organizationDataProvider.RollBackTransaction();
}
}
catch (Exception e)
{
_organizationDataProvider.RollBackTransaction();
OnException(e);
}
return(result);
}
