public static Dictionary <TimeType, List <TimeRecorder> > QueryAll(DateTime startTime, DateTime endTime)
{
DateTime endTime2 = endTime.AddHours(1);
timeRecorders.Clear();
try
{
using (afmdbEntities ctx = new afmdbEntities())
{
IQueryable <tbtimerecorder> downTimes = from dt in ctx.tbtimerecorder
where (dt.startTime <startTime && dt.endTime> endTime) ||
(dt.startTime >= startTime && dt.startTime < endTime2) &&
dt.span != null
select dt;
foreach (var item in downTimes)
{
TimeRecorder timeRec = new TimeRecorder((WorkState)item.workState, (TimeType)item.subType);
timeRec.StartTime = (DateTime)item.startTime;
timeRec.EndTime = (DateTime)item.endTime;
timeRec.span = (double)item.span;
AddTimeRecorder((TimeType)item.subType, timeRec);
}
return(timeRecorders);
}
}
catch
{
return(default(Dictionary <TimeType, List <TimeRecorder> >));
}
}
private void writeToDB()
{
int result = 0;
afmdbEntities ctx = new afmdbEntities();
workpiece workpiece = new workpiece();
workpiece.Name = "work";
workpiece.RunMode = 1;
workpiece.LotNum = "2019-09-07";
workpiece.Operator = "xiao";
workpiece.Barcode = "2019-09-07 16:55";
workpiece.StartTime = this.dateTimePickerInputStart.Value;
workpiece.EndTime = this.dateTimePickerInputEnd.Value;
if (!int.TryParse(this.txtOkNg.Text, out result))
{
result = 0;
}
workpiece.Result = result;
workpiece.Mark1X = 21;
workpiece.Mark1Y = 32;
workpiece.Mark2X = 45;
workpiece.Mark2Y = 65;
ctx.workpiece.Add(workpiece);
ctx.SaveChangesAsync();
}
private static bool queryValve(afmdbEntities ctx, ValveType type)
{
var valves = from v in ctx.valve where v.ValveType == (int)type select v;
valve vFind = valves.First();
return(vFind != null);
}
public static void InitValveTb()
{
using (afmdbEntities ctx = new afmdbEntities())
{
//查询
if (!queryValve(ctx, ValveType.Valve1))
{
valve valve1 = new valve();
valve1.Name = ValveType.Valve1.ToString();
valve1.ValveType = (int)ValveType.Valve1;
valve1.MachineId = 1;
valve1.ValveSeries = (int)Machine.Instance.Valve1.Prm.ValveSeires;
ctx.valve.Add(valve1);
}
if (!queryValve(ctx, ValveType.Valve2))
{
valve valve2 = new valve();
valve2.Name = ValveType.Valve2.ToString();
valve2.ValveType = (int)ValveType.Valve2;
valve2.MachineId = 1;
valve2.ValveSeries = (int)Machine.Instance.Valve2.Prm.ValveSeires;
ctx.valve.Add(valve2);
}
}
}
public override void WriteToDb()
{
using (afmdbEntities ctx = new afmdbEntities())
{
tbtimerecorder timeRecorder = new tbtimerecorder();
timeRecorder.workState = (int)this.workState;
timeRecorder.startTime = this.StartTime;
timeRecorder.endTime = this.EndTime;
timeRecorder.subType = (int)this.abNormalType;
ctx.tbtimerecorder.Add(timeRecorder);
}
}
public void WriteToDb()
{
try
{
using (afmdbEntities ctx = new afmdbEntities())
{
tbtimerecorder timeRecorder = new tbtimerecorder();
timeRecorder.workState = (int)this.workState;
timeRecorder.startTime = this.StartTime;
timeRecorder.endTime = this.EndTime;
timeRecorder.span = this.span;
timeRecorder.subType = (int)this.timeType;
ctx.tbtimerecorder.Add(timeRecorder);
ctx.SaveChangesAsync();
}
}
catch
{
}
}
