public int ImportMappingType(RowData data)
{
var db = _GeologyMappingType.GetDbContext();
var count = 0;
if (data.Rows != null && data.Rows.Any())
{
foreach (var row in data.Rows)
{
var model = new GeologyMappingType
{
ClassName = row.ClassName,
Id = row.Id,
Paths = row.Paths,
ParentID = row.ParentID
};
var sql = _GeologyMappingType.GenerateInsertSql(model);
try
{
var flag = db.Database.ExecuteSqlCommand(sql) > 0;
if (flag)
{
count++;
}
}
catch
{
}
}
}
return(count);
}
public Tuple <bool, GeologyMappingType> Insert(GeologyMappingTypeDto dto)
{
var id = Guid.NewGuid().ToString();
var db = _GeologyMappingType.GetDbContext();
if (string.IsNullOrEmpty(dto.ParentID))
{
var model = new GeologyMappingType
{
ClassName = dto.ClassName,
Id = id,
Paths = id
};
var sql = _GeologyMappingType.GenerateInsertSql(model);
var flag = db.Database.ExecuteSqlCommand(sql) > 0;
return(new Tuple <bool, GeologyMappingType>(flag, model));
}
else
{
//获取父级
var parent = GetGeologyMappingType(dto.ParentID);
if (parent == null)
{
return(new Tuple <bool, GeologyMappingType>(false, null));
}
var model = new GeologyMappingType
{
ClassName = dto.ClassName,
Id = id,
Paths = parent.Paths + "." + id,
ParentID = dto.ParentID
};
var sql = _GeologyMappingType.GenerateInsertSql(model);
var flag = db.Database.ExecuteSqlCommand(sql) > 0;
return(new Tuple <bool, GeologyMappingType>(flag, model));
}
}
