blob: 055f02474f4233d581d7ca7c95da94ac616c9b17 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.BL.Entities;
using System.Data.Entity;
namespace Tango.BL.Builders
{
public class RmlsCollectionBuilder : EntityCollectionBuilderBase<Rml, RmlsCollectionBuilder>
{
public RmlsCollectionBuilder(ObservablesContext context) : base(context)
{
}
public virtual RmlsCollectionBuilder WithCCT()
{
return AddQueryStep(1, (query) =>
{
return query.Include(x => x.Cct);
});
}
public virtual RmlsCollectionBuilder WithAllParametersGroup()
{
return AddStep(1, () =>
{
foreach (var rml in Entities.ToList())
{
var groups = Context.ProcessParametersTablesGroups.Where(x => x.RmlGuid == rml.Guid).ToList();
foreach (var group in groups)
{
Context.ProcessParametersTables.Where(x => x.ProcessParametersTablesGroupGuid == group.Guid).OrderBy(x => x.TableIndex).ToList();
}
}
});
}
public virtual RmlsCollectionBuilder WithActiveParametersGroup()
{
return AddStep(2, () =>
{
foreach (var rml in Entities.ToList())
{
Context.ProcessParametersTablesGroups.Where(x => x.RmlGuid == rml.Guid && x.Active).Include(x => x.ProcessParametersTables).FirstOrDefault();
}
});
}
public virtual RmlsCollectionBuilder WithCAT(String machineGuid)
{
return AddStep(4, () =>
{
foreach (var rml in Entities.ToList())
{
Context.Cats.Where(x => x.MachineGuid == machineGuid && x.RmlGuid == rml.Guid).ToList();
}
});
}
public virtual RmlsCollectionBuilder WithLiquidFactors()
{
return AddStep(5, () =>
{
foreach (var rml in Entities.ToList())
{
Context.LiquidTypesRmls.Where(x => x.RmlGuid == rml.Guid).Include(x => x.LiquidType).OrderBy(x => x.LiquidType.Code).ToList();
}
});
}
public virtual RmlsCollectionBuilder WithMediaProperties()
{
return AddStep(6, () =>
{
Context.MediaMaterials.ToList();
Context.MediaPurposes.ToList();
Context.MediaConditions.ToList();
Context.LinearMassDensityUnits.ToList();
Context.FiberShapes.ToList();
Context.FiberSynths.ToList();
});
}
}
}
|
