public void addProcess(PExpToshiba process, int index)
{
if (UpperWP != null)
{
process.Workpieces.Add(UpperWP.clone());
process.UpperWorkpiece = UpperWP.ID;
}
if (LowerWP != null)
{
process.Workpieces.Add(LowerWP.clone());
process.LowerWorkpiece = LowerWP.ID;
}
if (Glass != null)
{
process.GlassID = Glass.ID;
}
process.GlassName = LensName + "_" + index;
process.UserID = User.ID;
process.ProjectID = m_project.ID;
process.IssueID = m_issue.ID;
m_ProcessVms.Add(new PToshibaVM(process));
NotifyPropertyChanged("Processes");
}
private void bt_imoport_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.OpenFileDialog _ofd = new System.Windows.Forms.OpenFileDialog();
_ofd.Filter = "mon files (*.mon)|*.mon|Alle Deteien (*.*)|*.*";
_ofd.FilterIndex = 1;
_ofd.RestoreDirectory = true;
_ofd.Multiselect = true;
System.Windows.Forms.DialogResult result = _ofd.ShowDialog();
this.UpdateLayout();
if (result == System.Windows.Forms.DialogResult.OK)
{
Cursor = Cursors.Wait;
int id = m_vm.LensStartNumber;
foreach (var path in _ofd.FileNames)
{
var file = PDCore.ToshibaImport.IO.getMonFileData(path);
PExpToshiba process = PDCore.ToshibaImport.Analytics.AnalyseProcess(file);
process.File = file;
m_vm.addProcess(process, id);
id++;
}
Cursor = Cursors.Arrow;
new MainWindows.ToshibaProcessImport(m_vm).Show();
this.Close();
}
}
//Nur zu initialen Gebrauch!!! Keine Produktiv-Funktion
public void ImportToshibaMData()
{
List <string> _queries = new List <string>();
int PID = 0;
foreach (string path in System.IO.Directory.GetFiles(@"Data\Toshiba\"))
{
int idx = path.LastIndexOf('\\');
string PII = path.Remove(0, idx + 1);
PID = Convert.ToInt32(PII.Replace(".mon", ""));
//System.Windows.MessageBox.Show(PID.ToString());
var file = PDCore.ToshibaImport.IO.getMonFileData(path);
PExpToshiba Process = PDCore.ToshibaImport.Analytics.AnalyseProcess(file);
_queries.Add("INSERT INTO " + DBExpToshibaMachineData.Table + " (" + DBExpToshibaMachineData.PID + "," +
DBExpToshibaMachineData.G1_lower + "," +
DBExpToshibaMachineData.G1_lower_quali + "," +
DBExpToshibaMachineData.G1_upper + "," +
DBExpToshibaMachineData.G1_upper_quali + "," +
DBExpToshibaMachineData.G3_lower + "," +
DBExpToshibaMachineData.G3_lower_quali + "," +
DBExpToshibaMachineData.G3_upper + "," +
DBExpToshibaMachineData.G3_upper_quali + "," +
DBExpToshibaMachineData.G4_lower + "," +
DBExpToshibaMachineData.G4_lower_quali + "," +
DBExpToshibaMachineData.G4_upper + "," +
DBExpToshibaMachineData.G4_upper_quali + "," +
DBExpToshibaMachineData.Gv_lower + "," +
DBExpToshibaMachineData.Gv_lower_quali + "," +
DBExpToshibaMachineData.Gv_upper + "," +
DBExpToshibaMachineData.Gv_upper_quali + "," +
DBExpToshibaMachineData.P1 + "," +
DBExpToshibaMachineData.P2 + "," +
DBExpToshibaMachineData.P3 + "," +
DBExpToshibaMachineData.PT1 + "," +
DBExpToshibaMachineData.ST1 + "," +
DBExpToshibaMachineData.ST2 + "," +
DBExpToshibaMachineData.T_press_av + "," +
DBExpToshibaMachineData.T_press_G + "," +
DBExpToshibaMachineData.T_press_G_quali + "," +
DBExpToshibaMachineData.T_start_lower + "," +
DBExpToshibaMachineData.T_start_upper + "," +
DBExpToshibaMachineData.T1_lower + "," +
DBExpToshibaMachineData.T1_upper + "," +
DBExpToshibaMachineData.T1u_lower + "," +
DBExpToshibaMachineData.T1u_upper + "," +
DBExpToshibaMachineData.T2_lower + "," +
DBExpToshibaMachineData.T2_upper + "," +
DBExpToshibaMachineData.T3_lower + "," +
DBExpToshibaMachineData.T3_upper + "," +
DBExpToshibaMachineData.T4_lower + "," +
DBExpToshibaMachineData.T4_upper + "," +
DBExpToshibaMachineData.T5_lower + "," +
DBExpToshibaMachineData.T5_upper + "," +
DBExpToshibaMachineData.Tv_lower + "," +
DBExpToshibaMachineData.Tv_upper + "," +
DBExpToshibaMachineData.Tvu_lower + "," +
DBExpToshibaMachineData.Tvu_upper + ") Values (" +
PID + "," +
Process.MachinaData.G1_lower.ToDBObject() + "," +
Process.MachinaData.G1_lower_quali.ToDBObject() + "," +
Process.MachinaData.G1_upper.ToDBObject() + "," +
Process.MachinaData.G1_upper_quali.ToDBObject() + "," +
Process.MachinaData.G3_lower.ToDBObject() + "," +
Process.MachinaData.G3_lower_quali.ToDBObject() + "," +
Process.MachinaData.G3_upper.ToDBObject() + "," +
Process.MachinaData.G3_upper_quali.ToDBObject() + "," +
Process.MachinaData.G4_lower.ToDBObject() + "," +
Process.MachinaData.G4_lower_quali.ToDBObject() + "," +
Process.MachinaData.G4_upper.ToDBObject() + "," +
Process.MachinaData.G4_upper_quali.ToDBObject() + "," +
Process.MachinaData.Gv_lower.ToDBObject() + "," +
Process.MachinaData.Gv_lower_quali.ToDBObject() + "," +
Process.MachinaData.Gv_upper.ToDBObject() + "," +
Process.MachinaData.Gv_upper_quali.ToDBObject() + "," +
Process.MachinaData.P1.ToDBObject() + "," +
Process.MachinaData.P2.ToDBObject() + "," +
Process.MachinaData.P3.ToDBObject() + "," +
Process.MachinaData.PT1.ToDBObject() + "," +
Process.MachinaData.ST1.ToDBObject() + "," +
Process.MachinaData.ST2.ToDBObject() + "," +
Process.MachinaData.T_press_av.ToDBObject() + "," +
Process.MachinaData.T_press_G.ToDBObject() + "," +
Process.MachinaData.T_press_G_quali.ToDBObject() + "," +
Process.MachinaData.T_start_lower.ToDBObject() + "," +
Process.MachinaData.T_start_upper.ToDBObject() + "," +
Process.MachinaData.T1_lower.ToDBObject() + "," +
Process.MachinaData.T1_upper.ToDBObject() + "," +
Process.MachinaData.T1u_lower.ToDBObject() + "," +
Process.MachinaData.T1u_upper.ToDBObject() + "," +
Process.MachinaData.T2_lower.ToDBObject() + "," +
Process.MachinaData.T2_upper.ToDBObject() + "," +
Process.MachinaData.T3_lower.ToDBObject() + "," +
Process.MachinaData.T3_upper.ToDBObject() + "," +
Process.MachinaData.T4_lower.ToDBObject() + "," +
Process.MachinaData.T4_upper.ToDBObject() + "," +
Process.MachinaData.T5_lower.ToDBObject() + "," +
Process.MachinaData.T5_upper.ToDBObject() + "," +
Process.MachinaData.Tv_lower.ToDBObject() + "," +
Process.MachinaData.Tv_upper.ToDBObject() + "," +
Process.MachinaData.Tvu_lower.ToDBObject() + "," +
Process.MachinaData.Tvu_upper.ToDBObject() + ")");
_queries.Add("update " + DBExpToshiba.Table + " set " + DBExpToshiba.T4 + "=" + Process.MachinaData.T4_lower.ToDBObject() + " where " + DBExpToshiba.ID + "=" + PID);
}
bool success = _myCommunicator.executeTransactedQueries(_queries);
}
public static PExpToshiba AnalyseProcess(MonFile File)
{
AnalyseResults result;
PExpToshiba process = new PExpToshiba();
process.Date = File.StartTime;
foreach (var step in File.Steps)
{
switch (step.stepnumber)
{
case 1:
//result = analyse_123(step);
process.InputData.V1 = null;
break;
case 2:
result = analyse_123(step);
process.MachinaData.T_start_lower = result.TminLower;
process.MachinaData.T_start_upper = result.TminUpper;
process.MachinaData.Tv_lower = result.TmaxLower;
process.MachinaData.Tv_upper = result.TmaxUpper;
process.MachinaData.Gv_lower = result.TRateLower;
process.MachinaData.Gv_upper = result.TRateUpper;
process.MachinaData.Gv_lower_quali = result.TRateLowerQuality;
process.MachinaData.Gv_upper_quali = result.TRateUpperQuality;
process.InputData.Gv = Math.Round((((result.TUpper_Last + result.TLower_Last) / 2) - ((result.TUpper_First + result.TLower_First) / 2)) / result.Duration, 2);
process.InputData.Tv = ((result.TUpper_Last + result.TLower_Last) / 2);
process.InputData.Z1 = result.Posmax;
break;
case 3:
result = analyse_123(step);
process.MachinaData.Tvu_lower = result.TminLower;
process.MachinaData.Tvu_upper = result.TminUpper;
process.MachinaData.T1u_lower = result.TmaxLower;
process.MachinaData.T1u_upper = result.TmaxUpper;
process.MachinaData.G1_lower = result.TRateLower;
process.MachinaData.G1_upper = result.TRateUpper;
process.MachinaData.G1_lower_quali = result.TRateLowerQuality;
process.MachinaData.G1_upper_quali = result.TRateUpperQuality;
process.InputData.G1 = Math.Round((((result.TUpper_Last + result.TLower_Last) / 2) - ((result.TUpper_First + result.TLower_First) / 2)) / result.Duration, 2);
process.InputData.Tvu = ((result.TUpper_First + result.TLower_First) / 2);
process.InputData.T1u = ((result.TUpper_Last + result.TLower_Last) / 2);
break;
case 4:
result = analyse_4567(step);
process.MachinaData.T1_lower = result.TmaxLower;
process.MachinaData.T1_upper = result.TmaxUpper;
process.MachinaData.ST1 = result.Duration;
process.InputData.T1 = ((result.TUpper_Last + result.TLower_Last) / 2);
process.InputData.ST1 = result.Duration;
break;
case 5:
result = analyse_4567(step);
process.MachinaData.T_press_av = (result.TAverageUpper + result.TAverageLower) / 2;
process.MachinaData.T_press_G = (result.TRateUpper + result.TRateLower) / 2;
process.MachinaData.T_press_G_quali = (result.TRateUpperQuality + result.TRateLowerQuality) / 2;
process.MachinaData.P1 = result.PAverage;
process.MachinaData.PT1 = result.PressTime;
process.MachinaData.ST2 = result.Duration;
process.InputData.P1 = Math.Round(result.PAverage, PressRound);
process.InputData.PT1 = result.PressTime;
process.InputData.ST2 = result.Duration;
process.InputData.V2 = null;
process.InputData.Z2 = result.Posmax;
break;
case 6:
result = analyse_4567(step);
process.MachinaData.P2 = result.PAverage;
process.MachinaData.PT1 = result.PressTime;
process.MachinaData.G3_lower = result.TRateLower;
process.MachinaData.G3_upper = result.TRateUpper;
process.MachinaData.G3_lower_quali = result.TRateLowerQuality;
process.MachinaData.G3_upper_quali = result.TRateUpperQuality;
process.MachinaData.T2_lower = result.TChangeLower;
process.MachinaData.T2_upper = result.TChangeUpper;
process.InputData.G2 = Math.Round((((result.TUpper_Last + result.TLower_Last) / 2) - ((result.TUpper_First + result.TLower_First) / 2)) / result.Duration, 2);
process.InputData.T2 = (result.TChangeLower + result.TChangeUpper) / 2;
process.InputData.P2 = Math.Round(result.PAverage, PressRound);
break;
case 7:
result = analyse_7(step);
process.MachinaData.T5_lower = result.TminLower;
process.MachinaData.T5_upper = result.TminUpper;
process.MachinaData.T3_lower = result.TmaxLower;
process.MachinaData.T3_upper = result.TmaxLower;
process.MachinaData.T4_lower = result.TChangeLower;
process.MachinaData.T4_upper = result.TChangeUpper;
process.MachinaData.G4_lower = result.TRateLower;
process.MachinaData.G4_upper = result.TRateUpper;
process.MachinaData.G4_lower_quali = result.TRateLowerQuality;
process.MachinaData.G4_upper_quali = result.TRateUpperQuality;
process.MachinaData.P3 = result.PAverage;
process.InputData.T3 = (result.TLower_First + result.TUpper_First) / 2;
process.InputData.T4 = (result.TChangeUpper + result.TChangeLower) / 2;
process.InputData.T5 = (result.TLower_Last + result.TUpper_Last) / 2;
process.InputData.P3 = Math.Round(result.PAverage, 2);
break;
}
if (process.InputData.Tvu == null)
{
process.InputData.Tvu = process.InputData.Tv;
}
}
return(process);
}
public PToshibaVM(PExpToshiba process)
{
m_process = process;
plotModelT = new OxyPlot.PlotModel();
plotModelP = new OxyPlot.PlotModel();
//Inint QualityControls
if (m_process.UpperWorkpiece != null)
{
WP_UpperControl = new Controls.CQuality(process.Workpieces.Find(item => item.ID == m_process.UpperWorkpiece));
}
if (m_process.LowerWorkpiece != null)
{
WP_LowerControl = new Controls.CQuality(process.Workpieces.Find(item => item.ID == m_process.LowerWorkpiece));
}
PV_Control = new Controls.CPVControl(m_process);
ProcessQualityControl = new Controls.CProcessQuality(m_process);
#region Temp
LineSeries ls = new LineSeries();
foreach (var step in process.File.Steps)
{
ls.StrokeThickness = 0.8;
ls.Smooth = true;
ls.Color = OxyColors.Red;
for (int i = 0; i < step.MeasuringPoints.Count; i++)
{
ls.Points.Add(new DataPoint(step.MeasuringPoints[i].TimePass, step.MeasuringPoints[i].LTemp1));
}
}
Temperature.Series.Add(ls);
plotModelT.PlotMargins = new OxyThickness(3, 3, 3, 3);
plotModelT.Padding = new OxyThickness(3, 3, 3, 3);
plotModelT.TitleFontSize = 0;
plotModelT.SubtitleFontSize = 0;
plotModelT.TitlePadding = 0;
plotModelT.Axes.Clear();
plotModelT.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Bottom
});
plotModelT.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Left
});
#endregion
#region force
ls = new LineSeries();
foreach (var step in process.File.Steps)
{
ls.StrokeThickness = 0.8;
ls.Smooth = true;
ls.Color = OxyColors.Blue;
for (int i = 0; i < step.MeasuringPoints.Count; i += 1)
{
ls.Points.Add(new DataPoint(step.MeasuringPoints[i].TimePass, step.MeasuringPoints[i].PressZ));
}
}
Force.Series.Add(ls);
plotModelP.PlotMargins = new OxyThickness(3, 3, 3, 3);
plotModelP.Padding = new OxyThickness(3, 3, 3, 3);
plotModelP.TitleFontSize = 0;
plotModelP.SubtitleFontSize = 0;
plotModelP.TitlePadding = 0;
plotModelP.Axes.Clear();
plotModelP.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Bottom
});
plotModelP.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Left
});
#endregion
m_vm = new MonFileVM(process.File);
}
public PToshibaVM(int PID)
{
ObjectManager.Instance.update(PDCore.Database.DBGlasses.Table);
SaveProcess = new RelayCommand(Save, CanSave);
m_process = ProcessManager.Instance.getProcess(PID, 34) as PExpToshiba;
//try getting mon-file from local directory
try
{
m_process.File = PDCore.ToshibaImport.IO.getMonFileData(@"Data\Toshiba\" + PID + ".mon");
}
catch
{
m_process.File = new PDCore.ToshibaImport.MonFile();
}
plotModelT = new OxyPlot.PlotModel();
plotModelP = new OxyPlot.PlotModel();
//Inint QualityControls
if (m_process.UpperWorkpiece != null)
{
UpperWorkpiece = m_process.Workpieces.Find(item => item.ID == m_process.UpperWorkpiece);
}
if (m_process.LowerWorkpiece != null)
{
LowerWorkpiece = m_process.Workpieces.Find(item => item.ID == m_process.LowerWorkpiece);
}
PV_Control = new Controls.CPVControl(m_process);
ProcessQualityControl = new Controls.CProcessQuality(m_process);
#region Temp
LineSeries ls = new LineSeries();
foreach (var step in m_process.File.Steps)
{
ls.StrokeThickness = 0.8;
ls.Smooth = true;
ls.Color = OxyColors.Red;
for (int i = 0; i < step.MeasuringPoints.Count; i++)
{
ls.Points.Add(new DataPoint(step.MeasuringPoints[i].TimePass, step.MeasuringPoints[i].LTemp1));
}
}
Temperature.Series.Add(ls);
plotModelT.PlotMargins = new OxyThickness(3, 3, 3, 3);
plotModelT.Padding = new OxyThickness(3, 3, 3, 3);
plotModelT.TitleFontSize = 0;
plotModelT.SubtitleFontSize = 0;
plotModelT.TitlePadding = 0;
plotModelT.Axes.Clear();
plotModelT.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Bottom
});
plotModelT.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Left
});
#endregion
#region force
ls = new LineSeries();
foreach (var step in m_process.File.Steps)
{
ls.StrokeThickness = 0.8;
ls.Smooth = true;
ls.Color = OxyColors.Blue;
for (int i = 0; i < step.MeasuringPoints.Count; i += 1)
{
ls.Points.Add(new DataPoint(step.MeasuringPoints[i].TimePass, step.MeasuringPoints[i].PressZ));
}
}
Force.Series.Add(ls);
plotModelP.PlotMargins = new OxyThickness(3, 3, 3, 3);
plotModelP.Padding = new OxyThickness(3, 3, 3, 3);
plotModelP.TitleFontSize = 0;
plotModelP.SubtitleFontSize = 0;
plotModelP.TitlePadding = 0;
plotModelP.Axes.Clear();
plotModelP.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Bottom
});
plotModelP.Axes.Add(new InvisibleAxis {
Position = AxisPosition.Left
});
#endregion
m_vm = new MonFileVM(m_process.File);
}