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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
| private void Obrabotka()
{
int num = 3;
int num2 = 0;
int num3 = 0;
string[,] array = new string[100, 3];
<>o__7.<>p__0 ??= CallSite<Func<CallSite, object, Worksheet>>.Create(Binder.Convert(CSharpBinderFlags.ConvertExplicit, typeof(Worksheet), typeof(Form1)));
Worksheet worksheet = <>o__7.<>p__0.Target(<>o__7.<>p__0, this.excelApp.Worksheets.get_Item(1));
if (<>o__7.<>p__1 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.NamedArgument, "After") };
<>o__7.<>p__1 = CallSite<Func<CallSite, Sheets, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "Add", null, typeof(Form1), argumentInfo));
}
object obj2 = <>o__7.<>p__1.Target(<>o__7.<>p__1, this.excelApp.Worksheets, this.excelApp.ActiveSheet);
if (<>o__7.<>p__2 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.Constant | CSharpArgumentInfoFlags.UseCompileTimeType, null) };
<>o__7.<>p__2 = CallSite<Func<CallSite, object, string, object>>.Create(Binder.SetMember(CSharpBinderFlags.None, "Name", typeof(Form1), argumentInfo));
}
<>o__7.<>p__2.Target(<>o__7.<>p__2, obj2, "Result");
while (true)
{
if (<>o__7.<>p__4 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__4 = CallSite<Func<CallSite, object, bool>>.Create(Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.IsTrue, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__3 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.Constant, null) };
<>o__7.<>p__3 = CallSite<Func<CallSite, object, object, object>>.Create(Binder.BinaryOperation(CSharpBinderFlags.None, ExpressionType.NotEqual, typeof(Form1), argumentInfo));
}
if (!<>o__7.<>p__4.Target(<>o__7.<>p__4, <>o__7.<>p__3.Target(<>o__7.<>p__3, worksheet.get_Range("A" + num, Type.Missing).get_Value(Type.Missing), null)))
{
if (<>o__7.<>p__26 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__26 = CallSite<Action<CallSite, Form1, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.ResultDiscarded | CSharpBinderFlags.InvokeSimpleName, "Result", null, typeof(Form1), argumentInfo));
}
<>o__7.<>p__26.Target(<>o__7.<>p__26, this, obj2);
this.excelApp.Visible = true;
this.button3.Enabled = false;
this.brend_list.Clear();
return;
}
num2 = num;
if (this.checkBox1.Checked)
{
object local1;
if (<>o__7.<>p__12 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__12 = CallSite<Func<CallSite, object, bool>>.Create(Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.IsTrue, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__11 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__11 = CallSite<Func<CallSite, object, object>>.Create(Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.Not, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__6 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, null) };
<>o__7.<>p__6 = CallSite<Func<CallSite, object, DateTime, object>>.Create(Binder.BinaryOperation(CSharpBinderFlags.None, ExpressionType.GreaterThanOrEqual, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__5 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.IsStaticType | CSharpArgumentInfoFlags.UseCompileTimeType, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__5 = CallSite<Func<CallSite, Type, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToDateTime", null, typeof(Form1), argumentInfo));
}
object obj3 = <>o__7.<>p__6.Target(<>o__7.<>p__6, <>o__7.<>p__5.Target(<>o__7.<>p__5, typeof(Convert), worksheet.get_Range('C'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)), Convert.ToDateTime(this.dateTimePicker1.Value.ToShortDateString()));
if (<>o__7.<>p__10 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__10 = CallSite<Func<CallSite, object, bool>>.Create(Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.IsFalse, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__10.Target(<>o__7.<>p__10, obj3))
{
local1 = obj3;
}
else
{
if (<>o__7.<>p__9 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__9 = CallSite<Func<CallSite, object, object, object>>.Create(Binder.BinaryOperation(CSharpBinderFlags.BinaryOperationLogical, ExpressionType.And, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__8 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, null) };
<>o__7.<>p__8 = CallSite<Func<CallSite, object, DateTime, object>>.Create(Binder.BinaryOperation(CSharpBinderFlags.None, ExpressionType.LessThanOrEqual, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__7 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.IsStaticType | CSharpArgumentInfoFlags.UseCompileTimeType, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__7 = CallSite<Func<CallSite, Type, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToDateTime", null, typeof(Form1), argumentInfo));
}
local1 = <>o__7.<>p__9.Target(<>o__7.<>p__9, obj3, <>o__7.<>p__8.Target(<>o__7.<>p__8, <>o__7.<>p__7.Target(<>o__7.<>p__7, typeof(Convert), worksheet.get_Range('C'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)), Convert.ToDateTime(this.dateTimePicker2.Value.ToShortDateString())));
}
if (<>o__7.<>p__12.Target(<>o__7.<>p__12, <>o__7.<>p__11.Target(<>o__7.<>p__11, local1)))
{
num = num2 + 1;
continue;
}
}
while (true)
{
if (<>o__7.<>p__15 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__15 = CallSite<Func<CallSite, object, bool>>.Create(Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.IsTrue, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__14 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.Constant | CSharpArgumentInfoFlags.UseCompileTimeType, null) };
<>o__7.<>p__14 = CallSite<Func<CallSite, object, string, object>>.Create(Binder.BinaryOperation(CSharpBinderFlags.None, ExpressionType.NotEqual, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__13 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__13 = CallSite<Func<CallSite, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToString", null, typeof(Form1), argumentInfo));
}
char ch = 'D';
if (!<>o__7.<>p__15.Target(<>o__7.<>p__15, <>o__7.<>p__14.Target(<>o__7.<>p__14, <>o__7.<>p__13.Target(<>o__7.<>p__13, worksheet.get_Range(ch.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)), "Итого чек")))
{
this.Analysis(array, num3);
num = num2 + 1;
num3 = 0;
Array.Clear(array, 0, 200);
break;
}
if (<>o__7.<>p__17 == null)
{
<>o__7.<>p__17 = CallSite<Func<CallSite, object, string>>.Create(Binder.Convert(CSharpBinderFlags.None, typeof(string), typeof(Form1)));
}
if (<>o__7.<>p__16 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__16 = CallSite<Func<CallSite, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToString", null, typeof(Form1), argumentInfo));
}
array[num3, 0] = <>o__7.<>p__17.Target(<>o__7.<>p__17, <>o__7.<>p__16.Target(<>o__7.<>p__16, worksheet.get_Range('E'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)));
if (<>o__7.<>p__19 == null)
{
<>o__7.<>p__19 = CallSite<Func<CallSite, object, string>>.Create(Binder.Convert(CSharpBinderFlags.None, typeof(string), typeof(Form1)));
}
if (<>o__7.<>p__18 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__18 = CallSite<Func<CallSite, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToString", null, typeof(Form1), argumentInfo));
}
array[num3, 1] = <>o__7.<>p__19.Target(<>o__7.<>p__19, <>o__7.<>p__18.Target(<>o__7.<>p__18, worksheet.get_Range('F'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)));
if (<>o__7.<>p__21 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__21 = CallSite<Func<CallSite, object, bool>>.Create(Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.IsTrue, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__20 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.Constant, null) };
<>o__7.<>p__20 = CallSite<Func<CallSite, object, object, object>>.Create(Binder.BinaryOperation(CSharpBinderFlags.None, ExpressionType.NotEqual, typeof(Form1), argumentInfo));
}
if (<>o__7.<>p__21.Target(<>o__7.<>p__21, <>o__7.<>p__20.Target(<>o__7.<>p__20, worksheet.get_Range('H'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing), null)))
{
if (<>o__7.<>p__23 == null)
{
<>o__7.<>p__23 = CallSite<Func<CallSite, object, string>>.Create(Binder.Convert(CSharpBinderFlags.None, typeof(string), typeof(Form1)));
}
if (<>o__7.<>p__22 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__22 = CallSite<Func<CallSite, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToString", null, typeof(Form1), argumentInfo));
}
array[num3, 2] = <>o__7.<>p__23.Target(<>o__7.<>p__23, <>o__7.<>p__22.Target(<>o__7.<>p__22, worksheet.get_Range('H'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)));
}
else
{
if (<>o__7.<>p__25 == null)
{
<>o__7.<>p__25 = CallSite<Func<CallSite, object, string>>.Create(Binder.Convert(CSharpBinderFlags.None, typeof(string), typeof(Form1)));
}
if (<>o__7.<>p__24 == null)
{
CSharpArgumentInfo[] argumentInfo = new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) };
<>o__7.<>p__24 = CallSite<Func<CallSite, object, object>>.Create(Binder.InvokeMember(CSharpBinderFlags.None, "ToString", null, typeof(Form1), argumentInfo));
}
array[num3, 2] = <>o__7.<>p__25.Target(<>o__7.<>p__25, <>o__7.<>p__24.Target(<>o__7.<>p__24, worksheet.get_Range('I'.ToString() + num2.ToString(), Type.Missing).get_Value(Type.Missing)));
}
num3++;
num2++;
}
}
} |