private List <MaterialCategoryDefinition> SetMaterialCategoryOption(MaterialQueryOptions queryOptions, List <Material> materialList)
{
var materialCategoryDefinitionList = new List <MaterialCategoryDefinition>();
if (queryOptions.IncludeMaterialCategory)
{
var materialCategoryList =
materialList.Where(x => x.MaterialCategoryCode != null)
.Select(x => (object)x.MaterialCategoryCode)
.Distinct()
.ToList();
List <object>[] materialCategoryParts = materialCategoryList.Partition(PartitionCount);
foreach (List <object> part in materialCategoryParts)
{
List <string> queryList = new AbapQuery()
.Set(QueryOperator.In("ZZEXTWG", part))
.GetQuery();
using var connection = _serviceProvider.GetService <IRfcConnection>();
connection.Connect();
using var tableFunction = _serviceProvider.GetService <IReadTable <MaterialCategoryDefinition> >();
var definitions = tableFunction.GetTable(connection, queryList);
if (definitions.Any())
{
materialCategoryDefinitionList.AddRange(definitions);
}
}
}
return(materialCategoryDefinitionList);
}
private List <MaterialDefinition> SetMaterialDefinitionOption(MaterialQueryOptions queryOptions, List <Material> materialList)
{
var definitionList = new List <MaterialDefinition>();
if (queryOptions.IncludeDefinition)
{
var list = materialList.Where(x => x.Code != null).Select(x => (object)x.Code).ToList();
List <object>[] parts = list.Partition(PartitionCount);
foreach (List <object> part in parts)
{
List <string> query = new AbapQuery()
.Set(QueryOperator.In("MATNR", part))
.GetQuery();
using IRfcConnection connection = _serviceProvider.GetService <IRfcConnection>();
connection.Connect();
using IReadTable <MaterialDefinition> tableFunction = _serviceProvider.GetService <IReadTable <MaterialDefinition> >();
List <MaterialDefinition> definitions = tableFunction.GetTable(connection, query);
if (definitions.Any())
{
definitionList.AddRange(definitions);
}
}
}
return(definitionList);
}
private List <Material> SetOptions(List <Material> materialList,
MaterialQueryOptions queryOptions, bool getUnsafeFields = true)
{
if (!materialList.Any())
{
return(materialList);
}
var definitionList = SetMaterialDefinitionOption(queryOptions, materialList);
var materialCategoryDefinitionList = SetMaterialCategoryOption(queryOptions, materialList);
ILookup <string, MaterialDefinition> materialDefinitionLookup = definitionList.ToLookup(x => x.Code);
ILookup <string, MaterialCategoryDefinition> materialCategoryLookup =
materialCategoryDefinitionList.ToLookup(x => x.Code);
foreach (Material material in materialList)
{
material.Definition = materialDefinitionLookup.Contains(material.Code)
? materialDefinitionLookup[material.Code].FirstOrDefault()
: null;
material.MaterialCategory = materialCategoryLookup.Contains(material.MaterialCategoryCode)
? materialCategoryLookup[material.MaterialCategoryCode].FirstOrDefault()
: null;
}
return(materialList);
}
private List <Task> SetMaterialDefinitionOptionAsync(MaterialQueryOptions queryOptions, List <Material> materialList,
ConcurrentQueue <MaterialDefinition> definitionList)
{
var taskList = new List <Task>();
if (queryOptions.IncludeDefinition)
{
var list = materialList.Where(x => x.Code != null).Select(x => (object)x.Code).ToList();
List <object>[] parts = list.Partition(PartitionCount);
foreach (List <object> part in parts)
{
List <string> query = new AbapQuery()
.Set(QueryOperator.In("MATNR", part))
.GetQuery();
taskList.Add(Task.Run(() =>
{
using var connection = _serviceProvider.GetService <IRfcConnection>();
connection.Connect();
using var tableFunction = _serviceProvider.GetService <IReadTable <MaterialDefinition> >();
var definitions = tableFunction.GetTable(connection, query);
foreach (MaterialDefinition definition in definitions)
{
definitionList.Enqueue(definition);
}
}));
}
}
return(taskList);
}
private async Task <List <Material> > SetOptionsAsync(List <Material> materialList,
MaterialQueryOptions queryOptions, bool getUnsafeFields = true)
{
if (!materialList.Any())
{
return(materialList);
}
var taskList = new List <Task>();
var definitionList = new ConcurrentQueue <MaterialDefinition>();
var materialCategoryDefinitionList = new ConcurrentQueue <MaterialCategoryDefinition>();
List <Task> materialDefinitionTaskList = SetMaterialDefinitionOptionAsync(queryOptions, materialList, definitionList);
if (materialDefinitionTaskList.Any())
{
taskList.AddRange(materialDefinitionTaskList);
}
List <Task> materialCategoryTaskList =
SetMaterialCategoryOptionAsync(queryOptions, materialList, materialCategoryDefinitionList);
if (materialCategoryTaskList.Any())
{
taskList.AddRange(materialCategoryTaskList);
}
if (!taskList.Any())
{
return(materialList);
}
await Task.WhenAll(taskList).ConfigureAwait(false);
ILookup <string, MaterialDefinition> materialDefinitionLookup = definitionList.ToLookup(x => x.Code);
ILookup <string, MaterialCategoryDefinition> materialCategoryLookup =
materialCategoryDefinitionList.ToLookup(x => x.Code);
foreach (Material material in materialList)
{
material.Definition = materialDefinitionLookup.Contains(material.Code)
? materialDefinitionLookup[material.Code].FirstOrDefault()
: null;
material.MaterialCategory = materialCategoryLookup.Contains(material.MaterialCategoryCode)
? materialCategoryLookup[material.MaterialCategoryCode].FirstOrDefault()
: null;
}
return(materialList);
}
public List <Material> GetMaterialsByPrefix(string materialCodePrefix,
MaterialQueryOptions options = null, bool getUnsafeFields = true, int rowCount = 0)
{
options ??= new MaterialQueryOptions();
var query = new AbapQuery().Set(QueryOperator.StartsWith("MATNR", materialCodePrefix))
.And(QueryOperator.NotEqual("LVORM", true, RfcTablePropertySapTypes.BOOLEAN_X)).GetQuery();
using IRfcConnection connection = _serviceProvider.GetService <IRfcConnection>();
connection.Connect();
using IReadTable <Material> tableFunction = _serviceProvider.GetService <IReadTable <Material> >();
List <Material> result = tableFunction.GetTable(connection, query, rowCount: rowCount, getUnsafeFields: getUnsafeFields);
return(SetOptions(result, options, getUnsafeFields));
}
