blob: 82ccaf20d2a04c2a864d05c9260d3c4506e21d56 (
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
129
130
131
132
133
134
135
136
|
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).Include(x => x.RmlsSpools.Select(y => y.SpoolType));
});
}
public virtual RmlsCollectionBuilder WithGbdAndLub()
{
return AddQueryStep(5, (query) =>
{
return query.Include(x => x.Gbd).Include(x => x.Lub);
});
}
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();
});
}
}
}
|
