public static void RefreshPuskStopData(DateTime DateStart, DateTime DateEnd)
{
DiagDBEntities diagDB = new DiagDBEntities();
for (int gg = 1; gg <= 10; gg++)
{
if (gg == 8)
{
continue;
}
IEnumerable <PuskStopInfo> reqGG = from r in diagDB.PuskStopInfoes
where r.GG == gg && r.TypeData.StartsWith("GG_") &&
r.TimeOn <DateEnd && r.TimeOff> DateStart
select r;
Logger.Info(String.Format("GG {0} - {1}", gg, reqGG.Count()));
foreach (PuskStopInfo rec in reqGG)
{
IEnumerable <PuskStopInfo> reqPI = from r in diagDB.PuskStopInfoes
where r.GG == gg && (!r.TypeData.StartsWith("GG")) &&
r.TimeOn >= rec.TimeOn && r.TimeOff <= rec.TimeOff
select r;
Logger.Info(String.Format("GG {0} {1} - {2}", rec.TypeData, rec.TimeOn, reqPI.Count()));
foreach (PuskStopInfo pi in reqPI)
{
if (!pi.Comment.Contains(rec.TypeData))
{
pi.Comment += String.Format("{0}; ", rec.TypeData, rec.ID);
}
}
}
diagDB.SaveChanges();
}
}
public SortedList <DateTime, double> GetSerieDataAdd(DateTime dateStart, DateTime dateEnd)
{
DiagDBEntities diagDB = new DiagDBEntities();
IEnumerable <AnalogData> req = from a in diagDB.AnalogDatas where a.pointType.Contains(NasosType) &&
a.gg == GG && a.Date >= dateStart && a.Date <= dateEnd select a;
SortedList <DateTime, double> result = new SortedList <DateTime, double>();
foreach (AnalogData rec in req)
{
DateTime dt = rec.Date;
if (result.ContainsKey(dt))
{
while (result.ContainsKey(dt))
{
dt = dt.AddMilliseconds(1);
}
}
result.Add(dt, rec.value);
}
bool first = true;
foreach (PuskStopData nd in FullNasosData)
{
DateTime dt = nd.TimeOn;
if (result.ContainsKey(dt))
{
while (result.ContainsKey(dt))
{
dt = dt.AddMilliseconds(1);
}
}
result.Add(dt, nd.ValueStart);
if (first && nd.PrevRecord != null)
{
dt = nd.PrevRecord.TimeOff;
if (result.ContainsKey(dt))
{
while (result.ContainsKey(dt))
{
dt = dt.AddMilliseconds(1);
}
}
result.Add(dt, nd.PrevRecord.ValueEnd);
}
first = false;
dt = nd.TimeOff;
if (result.ContainsKey(dt))
{
while (result.ContainsKey(dt))
{
dt = dt.AddMilliseconds(1);
}
}
result.Add(dt, nd.ValueEnd);
}
return(result);
}
public static bool CheckCrossData(DateTime DateStart, DateTime DateEnd)
{
DiagDBEntities diagDB = new DiagDBEntities();
for (int gg = 1; gg <= 10; gg++)
{
if (gg == 8)
{
continue;
}
Logger.Info(String.Format("GG {0}", gg));
List <PuskStopInfo> data = (
from d in diagDB.PuskStopInfoes
where d.TimeOn <= DateEnd && d.TimeOff >= DateStart &&
d.GG == gg && d.TypeData.Contains("GG")
select d).ToList();
List <int> removedItems = new List <int>();
foreach (PuskStopInfo pi in data)
{
if (removedItems.Contains(pi.ID))
{
continue;
}
IEnumerable <PuskStopInfo> crossData = from d in data
where
d.GG == pi.GG && d.TypeData == pi.TypeData && d.ID != pi.ID &&
(d.TimeOff >= pi.TimeOn && d.TimeOff <= pi.TimeOff ||
d.TimeOn >= pi.TimeOn && d.TimeOn <= pi.TimeOff)
select d;
if (crossData.Count() > 0)
{
Logger.Info(String.Format("Delete {0}", crossData.Count()));
foreach (PuskStopInfo d in crossData)
{
removedItems.Add(d.ID);
pi.TimeOn = d.TimeOn < pi.TimeOn ? d.TimeOn : pi.TimeOn;
pi.TimeOff = d.TimeOff > pi.TimeOff ? d.TimeOff : pi.TimeOff;
pi.Length = (pi.TimeOff - pi.TimeOn).TotalSeconds;
diagDB.PuskStopInfoes.Remove(d);
}
}
diagDB.SaveChanges();
}
}
return(true);
}
protected void UpdateGGData(string typeGG, AnalizeNasosData nasosData)
{
DiagDBEntities diagDB = new DiagDBEntities();
IEnumerable <PuskStopData> ggData = from g in FullGGData where g.TypeData.Contains(typeGG) select g;
int sign = NasosType == "MNU" ? -1 : 1;
foreach (PuskStopData ggRec in ggData)
{
if ((ggRec.TimeOff - ggRec.TimeOn).TotalHours < 1)
{
continue;
}
SortedList <DateTime, double> vals = new SortedList <DateTime, double>();
IEnumerable <AnalogData> innerData = (from a in diagDB.AnalogDatas
where
a.Date >= ggRec.TimeOn && a.Date <= ggRec.TimeOff &&
a.pointType == NasosType && a.gg == GG
orderby a.Date
select a);
if (innerData.Count() > 0)
{
foreach (AnalogData ad in innerData)
{
if (!vals.ContainsKey(ad.Date))
{
vals.Add(ad.Date, ad.value);
}
}
}
IEnumerable <PuskStopData> req = from nd in FullNasosData
where
(nd.TimeOn > ggRec.TimeOn && nd.TimeOn < ggRec.TimeOff) ||
(nd.TimeOff > ggRec.TimeOn && nd.TimeOff < ggRec.TimeOff)
orderby nd.TimeOn
select nd;
if (req.Count() == 0)
{
if (vals.Count >= 2)
{
double v1 = vals.First().Value;
double v2 = vals.Last().Value;
DateTime d1 = vals.First().Key;
DateTime d2 = vals.Last().Key;
nasosData.VInfo.AddV(d1, d2, v1, v2, sign);
}
}
else
{
List <PuskStopData> list = req.ToList();
if (list.Count() > 0 && innerData.Count() > 0)
{
PuskStopData first = list.First();
if (first.TimeOn > vals.First().Key)
{
double v1 = vals.First().Value;
double v2 = first.ValueStart;
DateTime d1 = vals.First().Key;
DateTime d2 = first.TimeOn;
nasosData.VInfo.AddV(d1, d2, v1, v2, sign);
}
PuskStopData last = list.Last();
if (last.TimeOff < vals.Last().Key)
{
double v1 = last.ValueEnd;
double v2 = vals.Last().Value;
DateTime d1 = last.TimeOff;
DateTime d2 = vals.Last().Key;
double v = v2 - v1;
nasosData.VInfo.AddV(d1, d2, v1, v2, sign);
}
}
}
}
}
protected List <PuskStopData> createPuskStopData(string type_data, Dictionary <string, List <PuskStopData> > DiffData)
{
List <PuskStopData> result = new List <PuskStopData>();
DiagDBEntities diagDB = new DiagDBEntities();
IEnumerable <PuskStopInfo> req =
(from pi in diagDB.PuskStopInfoes
where
pi.GG == GG && pi.TypeData.Contains(type_data) &&
pi.TimeOff > DateStart && pi.TimeOn < DateEnd
orderby pi.TimeOn
select pi);
PuskStopData prevData = null;
PuskStopData last = null;
bool first = true;
foreach (PuskStopInfo pi in req)
{
if (first && pi.TimeOn > DateStart)
{
try
{
PuskStopInfo rf =
(from p in diagDB.PuskStopInfoes
where
p.GG == GG && p.TypeData.Contains(type_data) &&
p.TimeOff < DateStart
orderby p.TimeOff descending
select p).First();
prevData = new PuskStopData();
prevData.TimeOff = rf.TimeOff;
prevData.ValueStart = rf.ValueStart;
prevData.ValueEnd = rf.ValueEnd;
}
catch { }
}
first = false;
PuskStopData dat = new PuskStopData();
dat.Length = pi.Length;
dat.TimeOn = pi.TimeOn;
dat.TimeOff = pi.TimeOff;
dat.ValueEnd = pi.ValueEnd;
dat.ValueStart = pi.ValueStart;
dat.TypeData = pi.TypeData;
dat.Comment = "";
dat.PrevRecord = prevData;
prevData = dat;
result.Add(dat);
if (DiffData != null && !DiffData.ContainsKey(pi.TypeData))
{
DiffData.Add(pi.TypeData, new List <PuskStopData>());
}
DiffData[pi.TypeData].Add(dat);
last = dat;
}
return(result);
}
public static async Task <bool> FillAnalogData(DateTime DateStart, DateTime DateEnd, List <string> Types)
{
DiagDBEntities diagDB = new DiagDBEntities();
for (int gg = 1; gg <= 10; gg++)
{
if (gg == 8)
{
continue;
}
try
{
EDSClass.Disconnect();
}
catch { }
EDSClass.Connect();
Logger.Info(string.Format("GG{0}", gg));
List <PuskStopPoint> points = (from p in diagDB.PuskStopPoints
where p.gg == gg && p.analog == true && Types.Contains(p.pointType)
select p).ToList();
List <AnalogData> existData = (from a in diagDB.AnalogDatas
where
a.gg == gg && Types.Contains(a.pointType) &&
a.Date >= DateStart && a.Date <= DateEnd
select a).ToList();
Dictionary <string, string> pointsDict = new Dictionary <string, string>();
foreach (String type in Types)
{
try
{
PuskStopPoint pt = (from p in diagDB.PuskStopPoints where p.gg == gg && p.pointType == type select p).First();
pointsDict.Add(type, pt.point);
}
catch
{
pointsDict.Add(type, "");
}
}
List <PuskStopInfo> data = (
from d in diagDB.PuskStopInfoes
where d.TimeOn <= DateEnd && d.TimeOff >= DateStart &&
d.GG == gg && d.TypeData.Contains("GG_RUN")
select d).ToList();
foreach (PuskStopInfo ggRec in data)
{
Logger.Info(String.Format("GG {0} {1} -{2}", gg, ggRec.TimeOn, ggRec.TimeOff));
foreach (string type in Types)
{
if (string.IsNullOrEmpty(pointsDict[type]))
{
continue;
}
foreach (DateTime dt in new DateTime[] { ggRec.TimeOn, ggRec.TimeOff })
{
IEnumerable <AnalogData> datas = (from a in existData where a.Date == dt && a.pointType == type select a);
AnalogData dat = null;
if (datas.Count() == 0)
{
dat = new AnalogData();
diagDB.AnalogDatas.Add(dat);
dat.pointType = type;
dat.gg = gg;
dat.Date = dt;
dat.value = await EDSClass.getValFromServer(pointsDict[type], dt);
}
else
{
dat = datas.First();
}
}
}
diagDB.SaveChanges();
}
DateTime date = DateTime.Parse(DateStart.ToString("dd.MM.yyyy HH:00"));
while (date <= DateEnd)
{
Logger.Info(String.Format("GG {0} {1} ", gg, date));
if (gg == 5 && date < DateTime.Parse("01.06.2019"))
{
date = DateTime.Parse("01.06.2019");
continue;
}
if (gg == 3 && date < DateTime.Parse("07.05.2020"))
{
date = DateTime.Parse("07.05.2020");
continue;
}
if (gg == 1 && date < DateTime.Parse("21.04.2021"))
{
date = DateTime.Parse("21.04.2020");
continue;
}
foreach (string type in Types)
{
if (string.IsNullOrEmpty(pointsDict[type]))
{
continue;
}
IEnumerable <AnalogData> datas = (from a in existData where a.Date == date && a.pointType == type select a);
AnalogData dat = null;
if (datas.Count() == 0)
{
dat = new AnalogData();
diagDB.AnalogDatas.Add(dat);
dat.pointType = type;
dat.gg = gg;
dat.Date = date;
dat.value = await EDSClass.getValFromServer(pointsDict[type], date);
}
else
{
dat = datas.First();
}
}
date = date.AddHours(3);
}
}
return(true);
}
public async static Task <bool> FillPuskStopData(List <PuskStopReaderRecord> reqList, DateTime dateStart, DateTime dateEnd)
{
try
{
EDSClass.Disconnect();
}
catch { }
EDSClass.Connect();
if (!EDSClass.Connected)
{
return(false);
}
/*bool ok = await RefreshLevelsMNU(reqList, dateStart, dateEnd);
* return ok;*/
SortedList <int, List <PuskStopData> > FullResult = await AnalizePuskStopDataFull(reqList, dateStart, dateEnd);
for (int index = 0; index < reqList.Count; index++)
{
List <PuskStopData> data = FullResult[index];
PuskStopReaderRecord reqRecord = reqList[index];
int gg = reqRecord.gg;
string typeData = reqRecord.DBRecord;
if (data.Count > 0)
{
DiagDBEntities diagDB = new DiagDBEntities();
PuskStopData first = data.First();
PuskStopData last = data.Last();
IQueryable <PuskStopInfo> reqFirst = from pi in diagDB.PuskStopInfoes where pi.GG == gg && pi.TypeData == typeData && pi.TimeOff == first.TimeOn select pi;
if (reqFirst.Count() > 0)
{
PuskStopInfo firstDB = reqFirst.First();
firstDB.TimeOff = first.TimeOff;
firstDB.Length = (firstDB.TimeOff - firstDB.TimeOn).TotalSeconds;
firstDB.ValueEnd = first.ValueEnd;
diagDB.SaveChanges();
if (data.Count > 1)
{
data.RemoveAt(0);
}
else
{
continue;
}
}
IQueryable <PuskStopInfo> reqLast = from pi in diagDB.PuskStopInfoes where pi.GG == gg && pi.TypeData == typeData && pi.TimeOn == last.TimeOff select pi;
if (reqLast.Count() > 0)
{
PuskStopInfo lastDB = reqLast.First();
lastDB.TimeOn = last.TimeOn;
lastDB.Length = (lastDB.TimeOff - lastDB.TimeOn).TotalSeconds;
lastDB.ValueStart = last.ValueStart;
diagDB.SaveChanges();
if (data.Count > 0)
{
data.Remove(last);
}
else
{
continue;
}
}
IQueryable <PuskStopInfo> req = from pi in diagDB.PuskStopInfoes where pi.GG == gg && pi.TypeData == typeData && pi.TimeOn > dateStart && pi.TimeOn <= dateEnd select pi;
SortedList <DateTime, PuskStopInfo> dataDB = new SortedList <DateTime, PuskStopInfo>();
foreach (PuskStopInfo pi in req)
{
if (!dataDB.ContainsKey(pi.TimeOn))
{
dataDB.Add(pi.TimeOn, pi);
}
}
foreach (PuskStopData rec in data)
{
PuskStopInfo recDB = new PuskStopInfo();
if (dataDB.ContainsKey(rec.TimeOn))
{
recDB = dataDB[rec.TimeOn];
}
recDB.GG = gg;
recDB.TypeData = typeData;
recDB.TimeOn = rec.TimeOn;
recDB.TimeOff = rec.TimeOff;
recDB.Length = rec.Length;
recDB.ValueEnd = rec.ValueEnd;
recDB.ValueStart = rec.ValueStart;
recDB.Comment = "";
if (!dataDB.ContainsKey(rec.TimeOn))
{
diagDB.PuskStopInfoes.Add(recDB);
}
}
diagDB.SaveChanges();
}
}
return(true);
}
public static async void fillDBPoints()
{
List <PuskStopReader.PuskStopReaderRecord> request = new List <PuskStopReader.PuskStopReaderRecord>();
foreach (string gg in new string[] { "01", "04", "05", "07", "03" })
{
int ggInt = Int32.Parse(gg);
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "GG_RUN",
iess = gg + "VT_GC02D-45.MCR@GRARM",
inverted = true,
gg = ggInt
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "GG_STOP",
iess = gg + "VT_GC02D-45.MCR@GRARM",
inverted = false,
gg = ggInt
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "GG_UST",
iess = gg + "VT_GC03D-01.MCR@GRARM",
inverted = false,
gg = ggInt
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "MNU_1",
iess = gg + "VT_PS01DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00A-01.MCR@GRARM"
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "MNU_2",
iess = gg + "VT_PS02DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00A-01.MCR@GRARM"
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "MNU_3",
iess = gg + "VT_PS03DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00A-01.MCR@GRARM"
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "LN_1",
iess = gg + "VT_PS04DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00AI-07.MCR@GRARM"
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "LN_2",
iess = gg + "VT_PS05DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00AI-07.MCR@GRARM"
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "DN_1",
iess = gg + "VT_DS01DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_DS00AI-01.MCR@GRARM"
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "DN_2",
iess = gg + "VT_DS02DI-01.MCR@GRARM",
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_DS00AI-01.MCR@GRARM"
});
}
foreach (string gg in new string[] { "02", "06", "08", "09", "10" })
{
int ggInt = Int32.Parse(gg);
string suffix = "";
suffix = ggInt <= 2 ? ".UNIT01@BLOCK1" : ggInt <= 6 ? ".UNIT05@BLOCK3" : ggInt <= 8 ? ".UNIT07@BLOCK4" : ".UNIT09@BLOCK5";
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "GG_RUN",
iess = gg + "VT_GC00D-115" + suffix,
inverted = true,
gg = ggInt
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "GG_STOP",
iess = gg + "VT_GC00D-115" + suffix,
inverted = false,
gg = ggInt
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "GG_UST",
iess = gg + "VT_GC05D-01" + suffix,
inverted = false,
gg = ggInt
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "MNU_1",
iess = gg + "VT_PS01DI-03" + suffix,
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00A-11" + suffix
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "MNU_2",
iess = gg + "VT_PS02DI-03" + suffix,
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00A-11" + suffix
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "MNU_3",
iess = gg + "VT_PS03DI-03" + suffix,
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS00A-11" + suffix
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "LN_1",
iess = gg + "VT_PS04DI-03" + suffix,
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_PS04AI-01" + suffix
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "DN_1",
iess = gg + "VT_DS01DI-03" + suffix,
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_DS00AI-01" + suffix
});
request.Add(new PuskStopReader.PuskStopReaderRecord()
{
DBRecord = "DN_2",
iess = gg + "VT_DS02DI-03" + suffix,
inverted = false,
gg = ggInt,
ValueIess = gg + "VT_DS00AI-01" + suffix
});
}
DiagDBEntities diagDB = new DiagDBEntities();
foreach (PuskStopReader.PuskStopReaderRecord rec in request)
{
string ggStr = rec.iess.Substring(0, 2);
int gg = Int32.Parse(ggStr);
string typeAnalog = "---";
if (!string.IsNullOrEmpty(rec.ValueIess))
{
int pos = rec.DBRecord.IndexOf("_");
typeAnalog = rec.DBRecord.Substring(0, pos);
}
IEnumerable <PuskStopPoint> req = from p in diagDB.PuskStopPoints where p.gg == gg && (p.pointType == rec.DBRecord || p.pointType == typeAnalog) select p;
if (req.Count() > 0)
{
foreach (PuskStopPoint p in req)
{
diagDB.PuskStopPoints.Remove(p);
}
diagDB.SaveChanges();
}
PuskStopPoint pt = new PuskStopPoint();
pt.gg = gg;
pt.inverted = rec.inverted;
pt.pointType = rec.DBRecord;
pt.point = rec.iess;
pt.analog = false;
diagDB.PuskStopPoints.Add(pt);
if (!string.IsNullOrEmpty(rec.ValueIess))
{
int pos = rec.DBRecord.IndexOf("_");
typeAnalog = rec.DBRecord.Substring(0, pos);
pt = new PuskStopPoint();
pt.gg = gg;
pt.inverted = false;
pt.analog = true;
pt.pointType = typeAnalog;
pt.point = rec.ValueIess;
diagDB.PuskStopPoints.Add(pt);
}
diagDB.SaveChanges();
}
}
public static async Task <bool> process(DateTime dateStart, DateTime dateEnd)
{
DateTime date = dateStart.AddSeconds(0);;
DateTime start = DateTime.Now;
DiagDBEntities diagDB = new DiagDBEntities();
Dictionary <int, List <PuskStopReader.PuskStopReaderRecord> > requestsDict = new Dictionary <int, List <PuskStopReader.PuskStopReaderRecord> >();
for (int gg = 1; gg <= 10; gg++)
{
if (gg == 8)
{
continue;
}
List <PuskStopReader.PuskStopReaderRecord> request = new List <PuskStopReader.PuskStopReaderRecord>();
IEnumerable <PuskStopPoint> req = from p in diagDB.PuskStopPoints where p.gg == gg && p.analog == false select p;
foreach (PuskStopPoint pt in req)
{
PuskStopReader.PuskStopReaderRecord rec = new PuskStopReader.PuskStopReaderRecord();
rec.DBRecord = pt.pointType;
rec.iess = pt.point;
rec.inverted = pt.inverted;
rec.gg = pt.gg;
IEnumerable <PuskStopPoint> req2 = from p in diagDB.PuskStopPoints where p.gg == gg && p.analog == true && pt.pointType.Contains(p.pointType) select p;
if (req2.Count() > 0)
{
PuskStopPoint inner = req2.First();
rec.ValueIess = inner.point;
}
request.Add(rec);
}
requestsDict.Add(gg, request);
}
while (date < dateEnd)
{
Logger.Info(date.ToString());
for (int gg = 1; gg <= 10; gg++)
{
if (gg == 8)
{
continue;
}
if (gg == 3 && date < DateTime.Parse("07.05.2020"))
{
continue;
}
if (gg == 5 && date < DateTime.Parse("01.06.2019"))
{
continue;
}
if (gg == 1 && date < DateTime.Parse("21.04.2021"))
{
continue;
}
Logger.Info(String.Format("ГГ {0} Дата {1}", gg, date));
List <PuskStopReader.PuskStopReaderRecord> request = requestsDict[gg];
bool ok = await PuskStopReader.FillPuskStopData(request, date, date.AddHours(3));
}
date = date.AddHours(3);
}
DateTime end = DateTime.Now;
Logger.Info((end - start).TotalMinutes.ToString());
Logger.Info("Finish");
return(true);
}
