Save RML Extensions parameters in excel file.

4 files changed, 258 insertions, 0 deletions

diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorDataExcelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorDataExcelModel.cs
new file mode 100644
index 000000000..da7471e16
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorDataExcelModel.cs
@@ -0,0 +1,39 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using Tango.Documents;
+
+namespace Tango.MachineStudio.ThreadExtensions.Models
+{
+    public class ColorDataExcelModel
+    {
+        public int NlCm { get; set; }
+        public double L { get; set; }
+        public double A { get; set; }
+        public double B { get; set; }
+
+        public ColorDataExcelModel()
+        {
+            NlCm = 0;
+            L = A = B = 0.0;
+        }
+
+        public static void GetDataFromFile(string fileName, out List<ColorDataExcelModel> items, ref string errors)
+        {
+            items = null;
+            try
+            {
+                using (ExcelReader reader = new ExcelReader(fileName))
+                {
+                    items = reader.GetDataByIndex<ColorDataExcelModel>("Sheet1", 1);
+                }
+            }
+            catch (Exception ex)
+            {
+                errors = ex.Message;
+            }
+        }
+    }
+}
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorParametrsExcelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorParametrsExcelModel.cs
new file mode 100644
index 000000000..72e31b3d7
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorParametrsExcelModel.cs
@@ -0,0 +1,59 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.MachineStudio.ThreadExtensions.Models
+{
+    public class ColorParametrsExcelModel
+    {
+        public String Thread_name { get; set; }
+        public String MachineNumber { get; set; }
+        public double White_point_L { get; set; }
+        public double White_point_a { get; set; }
+        public double White_point_B { get; set; }
+        public double Factor_100__C { get; set; }
+        public double Factor_100__Cyan_L { get; set; }
+        public double Factor_100__Cyan_A { get; set; }
+        public double Factor_100__Cyan_B { get; set; }
+        public double Factor_100__M { get; set; }
+        public double Factor_100__Magenta_L { get; set; }
+        public double Factor_100__Magenta_A { get; set; }
+        public double Factor_100__Magenta_B { get; set; }
+
+        public double Factor_100__Y { get; set; }
+        public double Factor_100__Yellow_L { get; set; }
+        public double Factor_100__Yellow_A { get; set; }
+        public double Factor_100__Yellow_B { get; set; }
+        public double Factor_100_K { get; set; }
+        public double Factor_100__Key_L { get; set; }
+        public double Factor_100__Key_A { get; set; }
+        public double Factor_100__Key_B { get; set; }
+        public double Factor_200_C { get; set; }
+        public double Factor_200__Cyan_L { get; set; }
+        public double Factor_200__Cyan_A { get; set; }
+        public double Factor_200__Cyan_B { get; set; }
+
+        public double Factor_200__Magenta { get; set; }
+        public double Factor_200__Magenta_L { get; set; }
+        public double Factor_200__Magenta_A { get; set; }
+        public double Factor_200__Magenta_B { get; set; }
+
+        public double Factor_200__Yellow { get; set; }
+        public double Factor_200__Yellow_L { get; set; }
+        public double Factor_200__Yellow_A { get; set; }
+        public double Factor_200__Yellow_B { get; set; }
+
+        public double Factor_200__Key { get; set; }
+        public double Factor_200__Key_L { get; set; }
+        public double Factor_200__Key_A { get; set; }
+        public double Factor_200__Key_B { get; set; }
+
+        public int Min_Ink_Uptake_Zone1 { get; set; }
+        public int Min_Ink_Uptake_Zone2 { get; set; }
+        public int Max_Ink_Uptake_Zone1 { get; set; }
+        public int Max_ink_uptake__Zone2 { get; set; }
+
+    }
+}
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/TestResultsExcelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/TestResultsExcelModel.cs
new file mode 100644
index 000000000..58d48f62e
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/TestResultsExcelModel.cs
@@ -0,0 +1,123 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.MachineStudio.ThreadExtensions.Models
+{
+    public class TestResultsExcelModel
+    {
+        public String Thread_name_test_results { get; set; }
+        public String Machine_number { get; set; }
+        public String Test_results_name__tab { get; set; }
+
+        public int Dryer_temp { get; set; }
+        public int Dryer_flow { get; set; }
+        public int Tunnel_temp { get; set; }
+        public int Tunnel_flow { get; set; }
+
+        public String Tension_in_head { get; set; }
+        public String Tension_after_dryer { get; set; }
+        public String Tension_in_winder { get; set; }
+        public String BTSR { get; set; }
+        public String Puller_tension { get; set; }
+        public String Winder_tension { get; set; }
+        
+        public double Rubbing_K_100___DE { get; set; }
+        public double Rubbing_K_100___GS { get; set; }
+        public double Rubbing_K_200___DE { get; set; }
+        public double Rubbing_K_200___GS { get; set; }
+        public double Rubbing_C_100___DE { get; set; }
+        public double Rubbing_C_100___GS { get; set; }
+        public double Rubbing_C_200___DE { get; set; }
+        public double Rubbing_C_200___GS { get; set; }
+        public double Rubbing_Y_100___DE { get; set; }
+        public double Rubbing_Y_100___GS { get; set; }
+        public double Rubbing_Y_200___DE { get; set; }
+        public double Rubbing_Y_200___GS { get; set; }
+        public double Rubbing_M_100___DE { get; set; }
+        public double Rubbing_M_100___GS { get; set; }
+        public double Rubbing_M_200___DE { get; set; }
+        public double Rubbing_M_200___GS { get; set; }
+
+        public String Color_REF { get; set; }
+        public double Load__N_REF { get; set; }
+        public double STDEV_REF { get; set; }
+        public double REF_Strain { get; set; }
+        public double STDEV_Strain_REF { get; set; }
+
+        public int Color_100_C { get; set; }
+        public String C_color_100_C { get; set; }
+        public double Load_N_100_C { get; set; }
+        public double STDEV_100_C { get; set; }
+        public double Change_100_C { get; set; }
+        public double Strain_100_C { get; set; }
+        public double STDEV_100_C_2 { get; set; }
+        public double Change_100_C_2 { get; set; }
+
+        public int Color_100_K { get; set; }
+        public String C_color_100_K { get; set; }
+        public double Load__N_100_K { get; set; }
+        public double STDEV_100_K { get; set; }
+        public double Change__100_K { get; set; }
+        public double Strain_100_K { get; set; }
+        public double STDEV_100_K_2 { get; set; }
+        public double Change_100_K_2 { get; set; }
+
+        public int Color_200_C { get; set; }
+        public String C_color_200_C { get; set; }
+        public double Load__N_200_C { get; set; }
+        public double STDEV_200_C { get; set; }
+        public double Change_200_C { get; set; }
+        public double Strain_200_C { get; set; }
+        public double STDEV_200_C_2 { get; set; }
+        public double Change_200_C_2 { get; set; }
+
+        public int Color_200_K { get; set; }
+        public String C_color_200_K { get; set; }
+        public double Load__N_200_K { get; set; }
+        public double STDEV_200_K { get; set; }
+        public double Change_200_K { get; set; }
+        public double Strain_200_K { get; set; }
+        public double STDEV_200_K_2 { get; set; }
+        public double Change_200_K_2 { get; set; }
+        
+        public String Uniformity_Zone_1 { get; set; }
+        public String Uniformity_Zone_2 { get; set; }
+        
+        public double COF_REF { get; set; }
+        public double CV_REF { get; set; }
+        public double COF_Black { get; set; }
+        public double CV_Black { get; set; }
+        //for twine inly
+        public double lub_amount { get; set; }
+        
+        public String Comments { get; set; }
+        public String Conclusion { get; set; }
+
+        public TestResultsExcelModel()
+        {
+            Comments = Conclusion = "";
+            C_color_100_C = "Cyan";
+            Color_100_C = 100;
+            Load__N_100_K = STDEV_100_K = Change__100_K = Strain_100_K = STDEV_100_K_2 = Change_100_K_2 = 0.0;
+
+            C_color_200_C = "Cyan";
+            Color_200_C = 200;
+            Load__N_200_C = STDEV_200_C = Change_200_C = Strain_200_C = STDEV_200_C_2 = Change_200_C_2 = 0.0;
+
+            C_color_100_K = "Black";
+            Color_100_K = 100;
+            Load__N_100_K = STDEV_100_K = Change__100_K = Strain_100_K = STDEV_100_K_2 = Change_100_K_2 = 0.0;
+
+            C_color_200_K = "Black";
+            Color_200_K = 200;
+            Load__N_200_K = STDEV_200_K = Change_200_K = Strain_200_K = STDEV_200_K_2 = Change_200_K_2 = 0.0;
+
+            Color_REF = "REF";
+            Load__N_REF = STDEV_REF = REF_Strain = STDEV_Strain_REF = 0;
+        }
+
+    }
+}
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ThreadCharacteristicsExelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ThreadCharacteristicsExelModel.cs
new file mode 100644
index 000000000..1f894d70b
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ThreadCharacteristicsExelModel.cs
@@ -0,0 +1,37 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.MachineStudio.ThreadExtensions.Models
+{
+    public class ThreadCharacteristicsExcelModel
+    {
+        public String ThreadName { get; set; }
+        public String Manufacturer { get; set; }
+        public String Brand { get; set; }
+        public String Country { get; set; }
+        public String EndUse { get; set; }
+        public String Applications { get; set; }
+        public String IndustrySector { get; set; }
+        public String Material { get; set; }
+        public String Type { get; set; }
+        public String SubFamily  { get; set; }
+        public String Family { get; set; }
+        public String Group { get; set; }
+        public String Texturing { get; set; }
+        public String Geometry { get; set; }
+        public String Color { get; set; }
+        public String GlossLevel { get; set; }
+        public double LinearDensity  { get; set; }
+        public String Unit { get; set; }
+        public int Plies { get; set; }
+        public int FilamentCountPerPlie  { get; set; }
+        public int LinearDensityCount { get; set; }
+        public int CountDen { get; set; }
+        public String FiberCount  { get; set; }
+        public int Twist { get; set; }
+        public String TwistDirection { get; set; }
+    }
+}