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);
}
