private void bg_DoWork(object sender, DoWorkEventArgs e) { try { Models.DataSource.ConnectionString = Settings.Default.ConnectionString; Console.Write(new UnitOfWork().ObligationsRepo.Fetch().Count()); MachineTime.UpdateTime(); } catch (Exception exception) { Invoke(new Action(() => { ConnectionDialog.ShowDialog(); })); } }
public static void Main(string[] param) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); BonusSkins.Register(); // var res = Cryptography.Decrypt("LQzNKovDgd5lrVJO1gypjDqxF4cqbri6uKOYkra19ko="); MachineTime.SetSystemTimeZone("Taipei Standard Time"); MachineTime.SetFormat(); const string appName = "Win"; bool createdNew; var mutex = new Mutex(true, appName, out createdNew); if (!createdNew) { //app is already running! Exiting the application return; } Application.Run(new Main(param)); //Application.Run(new frmConfirmationTemplates(new Models.Templates(), Models.MethodType.Add)); }
public static void Main(string[] param) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); BonusSkins.Register(); // var res = Cryptography.Decrypt("LQzNKovDgd5lrVJO1gypjDqxF4cqbri6uKOYkra19ko="); MachineTime.SetSystemTimeZone("Taipei Standard Time"); MachineTime.SetFormat(); //Application.Run(new Main(param)); //Application.Run(new frmConfirmationTemplates(new Models.Templates(), Models.MethodType.Add)); ModelDb db = new ModelDb(); db.Database.Log = (s) => { Debug.WriteLine(s); }; var res = db.Obligations.Select(x => new { TotalAmount = db.ORDetails.Sum(m => m.Amount) }); Debug.WriteLine(res.Sum(x => x.TotalAmount)); }
private MachineTime getModeTimings(int MachineID, DateTime correctedDate) { decimal OperatingTime = 0; decimal LossTime = 0; decimal MinorLossTime = 0; decimal MntTime = 0; decimal SetupTime = 0; decimal SetupMinorTime = 0; decimal PowerOffTime = 0; decimal PowerONTime = 0; MachineTime objmachine = new MachineTime(); var GetModeDurations = db.tblmodes.Where(m => m.MachineID == MachineID && m.CorrectedDate == correctedDate.Date && m.IsCompleted == 1 && m.ModeTypeEnd == 1).ToList(); foreach (var ModeRow in GetModeDurations) { if (ModeRow.ModeType == "PROD") { OperatingTime += (decimal)(ModeRow.DurationInSec / 60.00); } else if (ModeRow.ModeType == "IDLE" && ModeRow.DurationInSec > 600) { LossTime += (decimal)(ModeRow.DurationInSec / 60.00); decimal LossDuration = (decimal)(ModeRow.DurationInSec / 60.00); //if (ModeRow.LossCodeID != null) // insertProdlosses(ProdRow.HMIID, (int)ModeRow.LossCodeID, LossDuration, CorrectedDate, MachineID); } else if (ModeRow.ModeType == "IDLE" && ModeRow.DurationInSec < 600) { MinorLossTime += (decimal)(ModeRow.DurationInSec / 60.00); } else if (ModeRow.ModeType == "MNT") { MntTime += (decimal)(ModeRow.DurationInSec / 60.00); } else if (ModeRow.ModeType == "POWEROFF") { PowerOffTime += (decimal)(ModeRow.DurationInSec / 60.00); } else if (ModeRow.ModeType == "SETUP") { try { SetupTime += (decimal)Convert.ToDateTime(ModeRow.LossCodeEnteredTime).Subtract(Convert.ToDateTime(ModeRow.StartTime)).TotalMinutes; SetupMinorTime += (decimal)(db.tblSetupMaints.Where(m => m.ModeID == ModeRow.ModeID).Select(m => m.MinorLossTime).First() / 60.00); } catch { } } else if (ModeRow.ModeType == "POWERON") { PowerONTime += (decimal)(ModeRow.DurationInSec / 60.00); } } objmachine.RunningTime = OperatingTime; objmachine.IDLETime = LossTime + MinorLossTime; objmachine.BreakDownTime = PowerOffTime + MntTime; objmachine.PowerON = PowerONTime; objmachine.RunningTimePerc = (OperatingTime / 1440) * 100; objmachine.IDLETimePerc = (objmachine.IDLETime / 1440) * 100; objmachine.BreakDownTimePerc = (objmachine.BreakDownTime / 1440) * 100; objmachine.PowerONPerc = (objmachine.PowerON / 1440) * 100; return(objmachine); }