forked from chrisleo/RPA
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcalcdate.xaml
303 lines (303 loc) · 25.2 KB
/
calcdate.xaml
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
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
<Activity mc:Ignorable="sap sap2010" x:Class="calcdate" this:calcdate.in_SearchDirectory="C:\Work\RPAProject\RPAUtils\FileProcess\datadiff" this:calcdate.in_OutTimeDiffExcel="FileProcess\timediff.xlsx" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:d="clr-namespace:DirectorySearch;assembly=DirectorySearch" xmlns:maes="clr-namespace:Microsoft.Activities.Extensions.Statements;assembly=Microsoft.Activities.Extensions" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" xmlns:s="clr-namespace:System;assembly=mscorlib" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=mscorlib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data" xmlns:this="clr-namespace:" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<x:Members>
<x:Property Name="in_SearchDirectory" Type="InArgument(x:String)" />
<x:Property Name="in_OutTimeDiffExcel" Type="InArgument(x:String)" />
</x:Members>
<mva:VisualBasic.Settings>
<x:Null />
</mva:VisualBasic.Settings>
<sap:VirtualizedContainerService.HintSize>495.2,2169.6</sap:VirtualizedContainerService.HintSize>
<sap2010:WorkflowViewState.IdRef>calcdate_1</sap2010:WorkflowViewState.IdRef>
<TextExpression.NamespacesForImplementation>
<scg:List x:TypeArguments="x:String" Capacity="21">
<x:String>System.Activities</x:String>
<x:String>System.Activities.Statements</x:String>
<x:String>System.Activities.Expressions</x:String>
<x:String>System.Activities.Validation</x:String>
<x:String>System.Activities.XamlIntegration</x:String>
<x:String>Microsoft.VisualBasic</x:String>
<x:String>Microsoft.VisualBasic.Activities</x:String>
<x:String>System</x:String>
<x:String>System.Collections</x:String>
<x:String>System.Collections.Generic</x:String>
<x:String>System.Data</x:String>
<x:String>System.Diagnostics</x:String>
<x:String>System.Drawing</x:String>
<x:String>System.IO</x:String>
<x:String>System.Linq</x:String>
<x:String>System.Net.Mail</x:String>
<x:String>System.Xml</x:String>
<x:String>System.Xml.Linq</x:String>
<x:String>UiPath.Core</x:String>
<x:String>UiPath.Core.Activities</x:String>
<x:String>System.Windows.Markup</x:String>
</scg:List>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<scg:List x:TypeArguments="AssemblyReference" Capacity="16">
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>System.Data</AssemblyReference>
<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
<AssemblyReference>System</AssemblyReference>
<AssemblyReference>System.Drawing</AssemblyReference>
<AssemblyReference>System.Core</AssemblyReference>
<AssemblyReference>System.Xml</AssemblyReference>
<AssemblyReference>System.Xml.Linq</AssemblyReference>
<AssemblyReference>PresentationFramework</AssemblyReference>
<AssemblyReference>WindowsBase</AssemblyReference>
<AssemblyReference>PresentationCore</AssemblyReference>
<AssemblyReference>System.Xaml</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>UiPath.UiAutomation.Activities</AssemblyReference>
</scg:List>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="calcdate" sap:VirtualizedContainerService.HintSize="475.2,2109.6" sap2010:WorkflowViewState.IdRef="Sequence_1">
<Sequence.Variables>
<Variable x:TypeArguments="scg:List(x:String)" Name="filePaths" />
<Variable x:TypeArguments="scg:Dictionary(x:String, x:String)" Default="[New Dictionary(of String,string)]" Name="tableNameDic" />
<Variable x:TypeArguments="sd:DataTable" Name="timeDiffDt" />
<Variable x:TypeArguments="x:Int32" Name="index" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<d:GetFiles DisplayName="Get files" FilePaths="[filePaths]" Filter="*.*" sap:VirtualizedContainerService.HintSize="433.6,22.4" sap2010:WorkflowViewState.IdRef="GetFiles_1" SearchDirectory="[in_SearchDirectory]" SearchType="AllDirectories" />
<ui:ForEach x:TypeArguments="x:String" CurrentIndex="{x:Null}" DisplayName="For Each" sap:VirtualizedContainerService.HintSize="433.6,203.2" sap2010:WorkflowViewState.IdRef="ForEach`1_2" Values="[filePaths]">
<ui:ForEach.Body>
<ActivityAction x:TypeArguments="x:String">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="x:String" Name="item" />
</ActivityAction.Argument>
<Sequence DisplayName="Body" sap:VirtualizedContainerService.HintSize="200,68.8" sap2010:WorkflowViewState.IdRef="Sequence_2">
<Sequence.Variables>
<Variable x:TypeArguments="x:String" Name="tableName" />
<Variable x:TypeArguments="x:String" Name="createDate" />
<Variable x:TypeArguments="x:String" Name="createTime" />
<Variable x:TypeArguments="x:String" Name="createNo" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_2">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[tableName]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">[path.GetFileNameWithoutExtension(item).Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(0).ToString]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_3">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[createDate]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">[path.GetFileNameWithoutExtension(item).Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(1).ToString]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_4">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[createTime]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">[path.GetFileNameWithoutExtension(item).Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(2).ToString]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_5">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[createNo]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">[path.GetFileNameWithoutExtension(item).Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(3).ToString]</InArgument>
</Assign.Value>
</Assign>
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="333.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_1" Message="[tableName+" : "+createDate+" : "+createTime+" : "+createNo]" />
<If Condition="[not tableNameDic.ContainsKey(tableName)]" sap:VirtualizedContainerService.HintSize="333.6,52.8" sap2010:WorkflowViewState.IdRef="If_1">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<If.Then>
<Sequence sap:VirtualizedContainerService.HintSize="439.2,360.8" sap2010:WorkflowViewState.IdRef="Sequence_3">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="397.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_3" Message="["加入"+tableName+" "+createNo]" />
<maes:AddToDictionary x:TypeArguments="x:String, x:String" Dictionary="[tableNameDic]" DisplayName="Add to dictionary" sap:VirtualizedContainerService.HintSize="397.6,135.2" sap2010:WorkflowViewState.IdRef="AddToDictionary`2_2" Key="[tableName]" Value="[createNo+"-"+"0"]" />
</Sequence>
</If.Then>
<If.Else>
<If Condition="[createNo.Equals("0")]" sap:VirtualizedContainerService.HintSize="483.2,218.4" sap2010:WorkflowViewState.IdRef="If_2">
<If.Then>
<Sequence sap:VirtualizedContainerService.HintSize="200,68.8" sap2010:WorkflowViewState.IdRef="Sequence_4">
<Sequence.Variables>
<Variable x:TypeArguments="ui:GenericValue" Name="minNo" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="397.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_2" Level="Info" Message="["序号等于0，换顺序"+createNo+"--->"+createNo+"-"+tableNameDic(tableName).Split({"-"c},stringsplitoptions.RemoveEmptyEntries)(0).Trim]" />
<Assign sap:VirtualizedContainerService.HintSize="397.6,60" sap2010:WorkflowViewState.IdRef="Assign_9">
<Assign.To>
<OutArgument x:TypeArguments="ui:GenericValue">[minNo]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="ui:GenericValue">[tableNameDic(tableName).Split({"-"c},stringsplitoptions.RemoveEmptyEntries)(0).Trim]</InArgument>
</Assign.Value>
</Assign>
<maes:RemoveFromDictionary x:TypeArguments="x:String, x:String" Dictionary="[tableNameDic]" DisplayName="Remove from dictionary" sap:VirtualizedContainerService.HintSize="397.6,135.2" sap2010:WorkflowViewState.IdRef="RemoveFromDictionary`2_2" Key="[tableName]" />
<maes:AddToDictionary x:TypeArguments="x:String, x:String" Dictionary="[tableNameDic]" DisplayName="Add to dictionary" sap:VirtualizedContainerService.HintSize="397.6,135.2" sap2010:WorkflowViewState.IdRef="AddToDictionary`2_5" Key="[tableName]" Value="[createNo+"-"+minNo]" />
</Sequence>
</If.Then>
<If.Else>
<Sequence sap:VirtualizedContainerService.HintSize="200,68.8" sap2010:WorkflowViewState.IdRef="Sequence_5">
<Sequence.Variables>
<Variable x:TypeArguments="ui:GenericValue" Name="maxNo" />
<Variable x:TypeArguments="ui:GenericValue" Name="minNo" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<Assign sap:VirtualizedContainerService.HintSize="583.2,60" sap2010:WorkflowViewState.IdRef="Assign_10">
<Assign.To>
<OutArgument x:TypeArguments="ui:GenericValue">[minNo]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="ui:GenericValue">[tableNameDic(tableName).Split({"-"c},stringsplitoptions.RemoveEmptyEntries)(0).Trim]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="583.2,60" sap2010:WorkflowViewState.IdRef="Assign_8">
<Assign.To>
<OutArgument x:TypeArguments="ui:GenericValue">[maxNo]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="ui:GenericValue">[tableNameDic(tableName).Split({"-"c},stringsplitoptions.RemoveEmptyEntries)(1).Trim]</InArgument>
</Assign.Value>
</Assign>
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="583.2,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_5" Level="Info" Message="["序号不为0，比大小"]" />
<If Condition="[cint(createNo)>CInt(maxNo)]" sap:VirtualizedContainerService.HintSize="583.2,552.8" sap2010:WorkflowViewState.IdRef="If_3">
<If.Then>
<Sequence sap:VirtualizedContainerService.HintSize="439.2,403.2" sap2010:WorkflowViewState.IdRef="Sequence_6">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<maes:RemoveFromDictionary x:TypeArguments="x:String, x:String" Dictionary="[tableNameDic]" DisplayName="Remove from dictionary" sap:VirtualizedContainerService.HintSize="397.6,135.2" sap2010:WorkflowViewState.IdRef="RemoveFromDictionary`2_1" Key="[tableName]" />
<maes:AddToDictionary x:TypeArguments="x:String, x:String" Dictionary="[tableNameDic]" DisplayName="Add to dictionary" sap:VirtualizedContainerService.HintSize="397.6,135.2" sap2010:WorkflowViewState.IdRef="AddToDictionary`2_6" Key="[tableName]" Value="[minNo+"-"+createNo]" />
</Sequence>
</If.Then>
</If>
</Sequence>
</If.Else>
</If>
</If.Else>
</If>
</Sequence>
</ActivityAction>
</ui:ForEach.Body>
</ui:ForEach>
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="433.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_7" Message="["++++++++++++"]" />
<ui:BuildDataTable DataTable="[timeDiffDt]" DisplayName="Build Data Table" sap:VirtualizedContainerService.HintSize="433.6,60" sap2010:WorkflowViewState.IdRef="BuildDataTable_1" TableInfo="<NewDataSet>
 <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="TableName" msdata:UseCurrentLocale="true">
 <xs:complexType>
 <xs:choice minOccurs="0" maxOccurs="unbounded">
 <xs:element name="TableName">
 <xs:complexType>
 <xs:sequence>
 <xs:element name="No" type="xs:int" minOccurs="0" />
 <xs:element name="表名" type="xs:string" minOccurs="0" />
 <xs:element name="开始序号" type="xs:string" minOccurs="0" />
 <xs:element name="开始时间" type="xs:dateTime" minOccurs="0" />
 <xs:element name="结束序号" type="xs:string" minOccurs="0" />
 <xs:element name="结束时间" type="xs:dateTime" minOccurs="0" />
 <xs:element name="耗时" type="xs:string" minOccurs="0" />
 </xs:sequence>
 </xs:complexType>
 </xs:element>
 </xs:choice>
 </xs:complexType>
 </xs:element>
 </xs:schema>
</NewDataSet>" />
<ui:ForEach x:TypeArguments="scg:KeyValuePair(x:String, x:String)" CurrentIndex="[index]" DisplayName="For Each" sap:VirtualizedContainerService.HintSize="433.6,1148" sap2010:WorkflowViewState.IdRef="ForEach`1_4" Values="[tableNameDic]">
<ui:ForEach.Body>
<ActivityAction x:TypeArguments="scg:KeyValuePair(x:String, x:String)">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="scg:KeyValuePair(x:String, x:String)" Name="item" />
</ActivityAction.Argument>
<Sequence DisplayName="Body" sap:VirtualizedContainerService.HintSize="375.2,1013.6" sap2010:WorkflowViewState.IdRef="Sequence_7">
<Sequence.Variables>
<Variable x:TypeArguments="x:String" Name="minDateFileName" />
<Variable x:TypeArguments="x:String" Name="maxDateFileName" />
<Variable x:TypeArguments="s:DateTime" Name="startTime" />
<Variable x:TypeArguments="s:DateTime" Name="endTime" />
<Variable x:TypeArguments="x:TimeSpan" Name="elapsedTime" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_11">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[minDateFileName]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String" xml:space="preserve">[path.GetFileNameWithoutExtension(filePaths.Find(function(str) str.Contains(item.Key) and Path.GetFileNameWithoutExtension(str).EndsWith(item.Value.ToString.Split({"-"c},stringsplitoptions.RemoveEmptyEntries)(0))))]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_13">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[maxDateFileName]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String" xml:space="preserve">[path.GetFileNameWithoutExtension(filePaths.Find(function(str) str.Contains(item.Key) and Path.GetFileNameWithoutExtension(str).EndsWith(item.Value.ToString.Split({"-"c},stringsplitoptions.RemoveEmptyEntries)(1))))]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_16">
<Assign.To>
<OutArgument x:TypeArguments="s:DateTime">[startTime]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="s:DateTime">[Date.ParseExact(minDateFileName.Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(1)+" "+minDateFileName.Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(2),"yyyyMMdd HHmmss",System.Globalization.DateTimeFormatInfo.InvariantInfo)]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_17">
<Assign.To>
<OutArgument x:TypeArguments="s:DateTime">[endTime]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="s:DateTime">[Date.ParseExact(maxDateFileName.Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(1)+" "+maxDateFileName.Split({"_"c},stringsplitoptions.RemoveEmptyEntries)(2),"yyyyMMdd HHmmss",System.Globalization.DateTimeFormatInfo.InvariantInfo)]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="333.6,60" sap2010:WorkflowViewState.IdRef="Assign_18">
<Assign.To>
<OutArgument x:TypeArguments="x:TimeSpan">[elapsedTime]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:TimeSpan">[endTime-startTime]</InArgument>
</Assign.Value>
</Assign>
<ui:AddDataRow DataRow="{x:Null}" ArrayRow="[{index,item.Key,minDateFileName,starttime,maxDateFileName,endtime,elapsedTime.Minutes.ToString+"分"+elapsedTime.Seconds.ToString+"秒"}]" DataTable="[timeDiffDt]" DisplayName="Add Data Row" sap:VirtualizedContainerService.HintSize="333.6,22.4" sap2010:WorkflowViewState.IdRef="AddDataRow_1" />
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="333.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_11" Message="["====="+startTime.ToString+" "+endTime.ToString+" 耗时："+elapsedTime.Minutes.ToString+"分"+elapsedTime.Seconds.ToString+"秒"]" />
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="333.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_6" Level="Info" Message="[item.Key+" : "+item.Value+" --->"+minDateFileName]" />
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="333.6,92.8" sap2010:WorkflowViewState.IdRef="LogMessage_9" Level="Info" Message="[item.Key+" : "+item.Value+" --->"+maxDateFileName]" />
</Sequence>
</ActivityAction>
</ui:ForEach.Body>
</ui:ForEach>
<ui:ExcelApplicationScope Password="{x:Null}" DisplayName="Excel Application Scope" sap:VirtualizedContainerService.HintSize="433.6,290.4" sap2010:WorkflowViewState.IdRef="ExcelApplicationScope_2" Visible="False" WorkbookPath="[in_OutTimeDiffExcel]">
<ui:ExcelApplicationScope.Body>
<ActivityAction x:TypeArguments="ui:WorkbookApplication">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="ui:WorkbookApplication" Name="ExcelWorkbookScope" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="375.2,180.8" sap2010:WorkflowViewState.IdRef="Sequence_10">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:ExcelWriteRange AddHeaders="True" DataTable="[timeDiffDt]" DisplayName="Write Range" sap:VirtualizedContainerService.HintSize="333.6,88" sap2010:WorkflowViewState.IdRef="ExcelWriteRange_1" SheetName="Sheet1" StartingCell="A1" />
</Sequence>
</ActivityAction>
</ui:ExcelApplicationScope.Body>
</ui:ExcelApplicationScope>
</Sequence>
</Activity>