Terraria v1.4.4.9
Terraria source code documentation
Loading...
Searching...
No Matches

◆ Aggregate()

override object System.Data.Common.SqlDecimalStorage.Aggregate ( int[] records,
AggregateType kind )
inlinevirtual

Reimplemented from System.Data.Common.DataStorage.

Definition at line 19 of file SqlDecimalStorage.cs.

20 {
21 bool flag = false;
22 try
23 {
24 switch (kind)
25 {
26 case AggregateType.Sum:
27 {
28 SqlDecimal sqlDecimal2 = 0L;
29 foreach (int num3 in records)
30 {
31 if (!IsNull(num3))
32 {
33 sqlDecimal2 += _values[num3];
34 flag = true;
35 }
36 }
37 if (flag)
38 {
39 return sqlDecimal2;
40 }
41 return _nullValue;
42 }
43 case AggregateType.Mean:
44 {
45 SqlDecimal sqlDecimal3 = 0L;
46 int num5 = 0;
47 foreach (int num6 in records)
48 {
49 if (!IsNull(num6))
50 {
51 sqlDecimal3 += _values[num6];
52 num5++;
53 flag = true;
54 }
55 }
56 if (flag)
57 {
58 SqlDecimal sqlDecimal4 = 0L;
59 sqlDecimal4 = sqlDecimal3 / num5;
60 return sqlDecimal4;
61 }
62 return _nullValue;
63 }
64 case AggregateType.Var:
65 case AggregateType.StDev:
66 {
67 int num = 0;
68 SqlDouble sqlDouble = 0.0;
69 SqlDouble sqlDouble2 = 0.0;
70 SqlDouble sqlDouble3 = 0.0;
71 SqlDouble sqlDouble4 = 0.0;
72 foreach (int num4 in records)
73 {
74 if (!IsNull(num4))
75 {
76 sqlDouble3 += _values[num4].ToSqlDouble();
77 sqlDouble4 += _values[num4].ToSqlDouble() * _values[num4].ToSqlDouble();
78 num++;
79 }
80 }
81 if (num > 1)
82 {
83 sqlDouble = num * sqlDouble4 - sqlDouble3 * sqlDouble3;
84 sqlDouble2 = sqlDouble / (sqlDouble3 * sqlDouble3);
85 if (sqlDouble2 < 1E-15 || sqlDouble < 0.0)
86 {
87 sqlDouble = 0.0;
88 }
89 else
90 {
91 sqlDouble /= (SqlDouble)(num * (num - 1));
92 }
93 if (kind == AggregateType.StDev)
94 {
95 return Math.Sqrt(sqlDouble.Value);
96 }
97 return sqlDouble;
98 }
99 return _nullValue;
100 }
101 case AggregateType.Min:
102 {
103 SqlDecimal sqlDecimal = SqlDecimal.MaxValue;
104 foreach (int num2 in records)
105 {
106 if (!IsNull(num2))
107 {
108 if (SqlDecimal.LessThan(_values[num2], sqlDecimal).IsTrue)
109 {
110 sqlDecimal = _values[num2];
111 }
112 flag = true;
113 }
114 }
115 if (flag)
116 {
117 return sqlDecimal;
118 }
119 return _nullValue;
120 }
121 case AggregateType.Max:
122 {
123 SqlDecimal sqlDecimal5 = SqlDecimal.MinValue;
124 foreach (int num7 in records)
125 {
126 if (!IsNull(num7))
127 {
128 if (SqlDecimal.GreaterThan(_values[num7], sqlDecimal5).IsTrue)
129 {
130 sqlDecimal5 = _values[num7];
131 }
132 flag = true;
133 }
134 }
135 if (flag)
136 {
137 return sqlDecimal5;
138 }
139 return _nullValue;
140 }
141 case AggregateType.First:
142 if (records.Length != 0)
143 {
144 return _values[records[0]];
145 }
146 return null;
147 case AggregateType.Count:
148 {
149 int num = 0;
150 for (int i = 0; i < records.Length; i++)
151 {
152 if (!IsNull(records[i]))
153 {
154 num++;
155 }
156 }
157 return num;
158 }
159 }
160 }
161 catch (OverflowException)
162 {
163 throw ExprException.Overflow(typeof(SqlDecimal));
164 }
165 throw ExceptionBuilder.AggregateException(kind, _dataType);
166 }
System.Data.SqlTypes.SqlDecimal.GreaterThan
static SqlBoolean GreaterThan(SqlDecimal x, SqlDecimal y)
Definition SqlDecimal.cs:1846
System.Data.SqlTypes.SqlDecimal.LessThan
static SqlBoolean LessThan(SqlDecimal x, SqlDecimal y)
Definition SqlDecimal.cs:1841
System.Data.SqlTypes.SqlDecimal.MinValue
static readonly SqlDecimal MinValue
Definition SqlDecimal.cs:68
System.Data.SqlTypes.SqlDecimal.MaxValue
static readonly SqlDecimal MaxValue
Definition SqlDecimal.cs:70

References System.Data.Common.DataStorage._dataType, System.Data.Common.DataStorage._nullValue, System.Data.Common.SqlDecimalStorage._values, System.Data.ExceptionBuilder.AggregateException(), System.Xml.Dictionary, System.E, System.Data.SqlTypes.SqlDecimal.GreaterThan(), System.Data.IsNull, System.L, System.Data.SqlTypes.SqlDecimal.LessThan(), System.Data.SqlTypes.SqlDecimal.MaxValue, System.Data.SqlTypes.SqlDecimal.MinValue, System.Data.ExprException.Overflow(), System.Data.Common.SqlDouble, System.Math.Sqrt(), and System.Data.SqlTypes.SqlDecimal.ToSqlDouble().