/// <summary>
/// Возвращает условие того деталь принадлежит базовому агрегату
/// </summary>
/// <param name="directiveType"></param>
/// <returns></returns>
public static ICommonFilter GetWhereStatement(DirectiveType directiveType)
{
if (directiveType == null)
{
throw new ArgumentNullException("directiveType", "must be not null");
}
if (DirectiveType.GetDirectiveTypeById(directiveType.ItemId) == DirectiveType.Unknown)
{
throw new ArgumentException("unknown directive type", "directiveType");
}
ICommonFilter state;
if (directiveType == DirectiveType.All)
{
DirectiveType[] s =
{ DirectiveType.AirworthenessDirectives,
DirectiveType.DamagesRequiring,
DirectiveType.EngineeringOrders,
DirectiveType.OutOfPhase,
DirectiveType.SB };
state = new CommonFilter <DirectiveType>(Directive.DirectiveTypeProperty, FilterType.In, s);
}
else if (directiveType == DirectiveType.EngineeringOrders)
{
state =
new CommonFilter <string>($@" (directives.EngineeringOrders <> ''
or directives.EngineeringOrderFileID > 0
or directives.DirectiveType = {directiveType.ItemId})");
}
else if (directiveType == DirectiveType.ModificationStatus)
{
state = new CommonFilter <DirectiveWorkType>(Directive.WorkTypeProperty, DirectiveWorkType.Modification);
}
else if (directiveType == DirectiveType.SB)
{
//state =
// new CommonFilter<string>(string.Format(@"((directives.ServiceBulletinNo <> ''
// or directives.ServiceBulletinFileID > 0 )
// and directives.DirectiveType = {0})", directiveType.ItemId));
//TODO: Было так но потом захотели sb в ad перемещать
state = new CommonFilter <string>($@"(directives.ServiceBulletinNo <> ''
or directives.ServiceBulletinFileID > 0
or directives.DirectiveType = {directiveType.ItemId})" );
}
else
{
//state = new CommonFilter<DirectiveType>(Directive.DirectiveTypeProperty, directiveType);
state =
new CommonFilter <string>($@"(directives.Title != 'N/A'
and directives.DirectiveType = {directiveType.ItemId})");
}
return(state);
}
public static ICommonFilter GetWhereStatementForAll(DirectiveType directiveType, string text, string paragraph)
{
if (directiveType == null)
{
throw new ArgumentNullException("directiveType", "must be not null");
}
if (DirectiveType.GetDirectiveTypeById(directiveType.ItemId) == DirectiveType.Unknown)
{
throw new ArgumentException("unknown directive type", "directiveType");
}
ICommonFilter state;
state =
new CommonFilter <string>(string.Format($@"(directives.Title != 'N/A' and directives.Title like '%{text}%' and directives.Paragraph like '%{paragraph}%'
and directives.DirectiveType = {directiveType.ItemId})"));
return(state);
}
public async Task <IActionResult> Sb([FromRoute] int aircraftId, int directiveType)
{
var view = await _directiveRepository.GetDirectives(aircraftId, DirectiveType.GetDirectiveTypeById(directiveType));
return(View(view));
}
