blob: 630f434955e78122db631dd0e0ae40e4364a7951 (
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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.BL.Entities;
using System.Data.Entity;
using Tango.BL.Enumerations;
namespace Tango.BL.Builders
{
public class RmlsCollectionBuilder : EntityCollectionBuilderBase<Rml, RmlsCollectionBuilder>
{
public RmlsCollectionBuilder(ObservablesContext context) : base(context)
{
}
public virtual RmlsCollectionBuilder ForSite(String siteGuid)
{
return AddQueryStep(1, (query) =>
{
if (siteGuid != null)
{
var siteRmlsGuids = Context.SitesRmls.Where(x => x.SiteGuid == siteGuid).ToList().Select(x => x.RmlGuid).Where(x => x != null).Distinct().ToArray();
if (siteRmlsGuids.Length > 0)
{
return query.Where(x => siteRmlsGuids.Contains(x.Guid));
}
else
{
return query;
}
}
else
{
return query;
}
});
}
public virtual RmlsCollectionBuilder ForHeadType(HeadTypes headType)
{
return AddQueryStep(2, (query) =>
{
return query.Where(x => x.HeadType == (int)headType);
});
}
public virtual RmlsCollectionBuilder WithCCT()
{
return AddQueryStep(3, (query) =>
{
return query.Include(x => x.Cct);
});
}
public virtual RmlsCollectionBuilder WithSpools()
{
return AddQueryStep(4, (query) =>
{
return query.Include(x => x.RmlsSpools);
});
}
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();
});
}
}
}
|
