Adding 2 Changes to Statistics -MS

Related Work Items: #6962

1 files changed, 3 insertions, 1 deletions

diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.Statistics/ViewModels/JobRunsViewVM.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.Statistics/ViewModels/JobRunsViewVM.cs
index c8556960d..9dcce7d05 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.Statistics/ViewModels/JobRunsViewVM.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.Statistics/ViewModels/JobRunsViewVM.cs
@@ -300,7 +300,7 @@ namespace Tango.MachineStudio.Statistics.ViewModels
             JobRuns = new ObservableCollection<JobRunModel>();
             LoadJobRunsCommand = new RelayCommand(async () => await LoadJobRuns(), () => IsFree && SelectedMachines!= null && SelectedMachines.Source.Count >0);
             ExportToExcelCommand = new RelayCommand(ExportToExcel, () => IsFree);
-            LengthUpperValue = 10000.0;
+            LengthUpperValue = 100000.0;
             LengthLowerValue = 0.0;
             DateTime now = DateTime.Now;
             StartSelectedDate = now.AddMonths(-1);
@@ -646,6 +646,7 @@ namespace Tango.MachineStudio.Statistics.ViewModels
                              "Gradient Resolution",
                              "Status",
                              "End Date",
+                             "Total dyeing time",
                              "End Position",
                              "Cyan",
                              "Magenta",
@@ -677,6 +678,7 @@ namespace Tango.MachineStudio.Statistics.ViewModels
                         excel_model.GR = jobRunModel.JobRun.GradientResolutionCm.ToString();
                         excel_model.Status = jobRunModel.JobRun.JobRunStatus.ToString();
                         excel_model.EndTime = jobRunModel.JobRun.EndDate != null ? ((DateTime)jobRunModel.JobRun.EndDate).ToLocalTime().ToString("MM/dd/yy HH:mm"): "";
+                        excel_model.TotalDyeingTime = jobRunModel.JobRun.TotalDyeingTime != default(TimeSpan) ? ((TimeSpan)jobRunModel.JobRun.TotalDyeingTime).ToString(@"hh\:mm\:ss") : TimeSpan.FromSeconds(0).ToString(@"hh\:mm\:ss");
                         excel_model.EndPosition = String.Format("{0:0.##}", jobRunModel.JobRun.EndPosition);
                         excel_model.Cyan = jobRunModel.JobRun.CyanQuantity < 0 ? "" :jobRunModel.JobRun.CyanQuantity.ToString();
                         excel_model.Magenta = jobRunModel.JobRun.MagentaQuantity < 0 ? "" : jobRunModel.JobRun.MagentaQuantity.ToString();