//Конструктор public ReadAllSelect(string beginDate, string endDate) { var tagsList = new Tags(); Messur = new List <DataRoad>();; var hdas = Connect.ServerHdaConnect(); //var listTag = tagsList.GetMassurm().Select(tags => Convert.ToString(tags.Value)).ToList(); var listTag = new List <string>(); foreach (var tag in tagsList.GetMassurm()) { switch (tag.Name) { case "MeasuringNum": listTag.Add(tag.Value); break; case "NameRoad": listTag.Add(tag.Value); break; } } Signal nummess = null; Signal name = null; var di = new SignalDict(hdas, listTag, null, beginDate, endDate); foreach (var tag in tagsList.GetMassurm()) { switch (tag.Name) { case "MeasuringNum": nummess = di.Dictionary[tag.Value]; break; case "NameRoad": name = di.Dictionary[tag.Value]; break; } } for (var sec = 0; sec <= (nummess.DtEnd - nummess.DtBegin).TotalSeconds - 1; sec += 25) { var nm = nummess.DtBegin.AddSeconds(sec); var nume = Seconds.GetValue(nummess, nm).OpcRec; var nam = Seconds.GetValue(name, nm).OpcRec; var alarms = new DataRoad { NumMess = Convert.ToUInt16(nume.Value), RoadName = Convert.ToString(nam.Value) }; if (nume.Value != null && nume.Value.ToString() != string.Empty && nam.Value != null && nam.Value.ToString() != string.Empty) { var flag = true; foreach (var way in Messur) { if (way.NumMess == alarms.NumMess && way.RoadName == alarms.RoadName) { flag = false; } } if (flag) { Messur.Add(alarms); } } } }
//public List<DataRoad> Messur; public ReadAllBand(string beginDate, string endDate) { var tagsList = new Tags(); //Messur = new List<DataRoad>(); var hdas = Connect.ServerHdaConnect(); //var listTag = tagsList.GetMassurm().Select(tags => Convert.ToString(tags.Value)).ToList(); var listTag = new List <string>(); foreach (var tag in tagsList.GetMassurm()) { switch (tag.Name) { case "MeasuringNum": listTag.Add(tag.Value); break; case "Direction": listTag.Add(tag.Value); break; case "Band": listTag.Add(tag.Value); break; //case "Coating": // listTag.Add(tag.Value); // break; //case "DesignCount": // listTag.Add(tag.Value); // break; //case "DesignLayer1": // listTag.Add(tag.Value); // break; //case "DesignLayer2": // listTag.Add(tag.Value); // break; //case "DesignLayer3": // listTag.Add(tag.Value); // break; //case "Customer": // listTag.Add(tag.Value); // break; //case "Builder": // listTag.Add(tag.Value); // break; //case "StandartsDensity": // listTag.Add(tag.Value); // break; //case "StandartsDepth": // listTag.Add(tag.Value); // break; //case "StandartsIRI": // listTag.Add(tag.Value); // break; //case "StandartsLenght": // listTag.Add(tag.Value); // break; //case "StandartsRut": // listTag.Add(tag.Value); // break; //case "StandartsWidth": // listTag.Add(tag.Value); // break; //case "CoefficientTF": // listTag.Add(tag.Value); // break; //case "CoefficientB": // listTag.Add(tag.Value); // break; //case "CoefficientK": // listTag.Add(tag.Value); // break; } } Signal nummess = null; Signal direction = null; Signal band = null; //Signal coating = null; //Signal designcount = null; //Signal designlayer1 = null; //Signal designlayer2 = null; //Signal designlayer3 = null; //Signal customer = null; //Signal builder = null; //Signal standartsDensity = null; //Signal standartsDepth = null; //Signal standartsIRI = null; //Signal standartsLenght = null; //Signal standartsRut = null; //Signal standartsWidth = null; //Signal coefficientTF = null; //Signal koefficB = null; //Signal koefficK = null; var di = new SignalDict(hdas, listTag, null, beginDate, endDate); foreach (var tag in tagsList.GetMassurm()) { switch (tag.Name) { case "MeasuringNum": nummess = di.Dictionary[tag.Value]; break; case "Direction": direction = di.Dictionary[tag.Value]; break; case "Band": band = di.Dictionary[tag.Value]; break; //case "Coating": // coating = di.Dictionary[tag.Value]; // break; //case "DesignCount": // designcount = di.Dictionary[tag.Value]; // break; //case "DesignLayer1": // designlayer1 = di.Dictionary[tag.Value]; // break; //case "DesignLayer2": // designlayer2 = di.Dictionary[tag.Value]; // break; //case "DesignLayer3": // designlayer3 = di.Dictionary[tag.Value]; // break; //case "Customer": // customer = di.Dictionary[tag.Value]; // break; //case "Builder": // builder = di.Dictionary[tag.Value]; // break; //case "StandartsDensity": // standartsDensity = di.Dictionary[tag.Value]; // break; //case "StandartsDepth": // standartsDepth = di.Dictionary[tag.Value]; // break; //case "StandartsIRI": // standartsIRI = di.Dictionary[tag.Value]; // break; //case "StandartsLenght": // standartsLenght = di.Dictionary[tag.Value]; // break; //case "StandartsRut": // standartsRut = di.Dictionary[tag.Value]; // break; //case "StandartsWidth": // standartsWidth = di.Dictionary[tag.Value]; // break; //case "CoefficientTF": // coefficientTF = di.Dictionary[tag.Value]; // break; //case "CoefficientB": // koefficB = di.Dictionary[tag.Value]; // break; //case "CoefficientK": // koefficK = di.Dictionary[tag.Value]; // break; } } //for (var sec = 0; sec <= (nummess.DtEnd - nummess.DtBegin).TotalSeconds - 1; sec += 25) //{ var nm = nummess.DtBegin.AddSeconds(1); var nume = Seconds.GetValue(nummess, nm).OpcRec; var dct = Seconds.GetValue(direction, nm).OpcRec; var bnd = Seconds.GetValue(band, nm).OpcRec; //var coa = Seconds.GetValue(coating, nm).OpcRec; //var dc = Seconds.GetValue(designcount, nm).OpcRec; //var dl1 = Seconds.GetValue(designlayer1, nm).OpcRec; //var dl2 = Seconds.GetValue(designlayer2, nm).OpcRec; //var dl3 = Seconds.GetValue(designlayer3, nm).OpcRec; //var cr = Seconds.GetValue(customer, nm).OpcRec; //var br = Seconds.GetValue(builder, nm).OpcRec; //var kfb = Seconds.GetValue(koefficB, nm).OpcRec; //var kfk = Seconds.GetValue(koefficK, nm).OpcRec; //var stndrtDensity = Seconds.GetValue(standartsDensity, nm).OpcRec; //var stndrtDepth = Seconds.GetValue(standartsDepth, nm).OpcRec; //var stndrtIRI = Seconds.GetValue(standartsIRI, nm).OpcRec; //var stndrtLenght = Seconds.GetValue(standartsLenght, nm).OpcRec; //var stndrtRut = Seconds.GetValue(standartsRut, nm).OpcRec; //var stndrtWidth = Seconds.GetValue(standartsWidth, nm).OpcRec; //var ctf = Seconds.GetValue(coefficientTF, nm).OpcRec; //if (coa.Value == null) //{ // coa.Value = "Не задано"; //} //if (dc.Value == null) //{ // dc.Value = "Не задано"; //} //if (dl1.Value == null) //{ // dl1.Value = "Не задано"; //} //if (cr.Value == null) //{ // cr.Value = "Не задано"; //} //if (br.Value == null) //{ // br.Value = "Не задано"; //} if (dct.Value == null) { dct.Value = "Не задано"; } alarms = new DataRoad { NumMess = Convert.ToUInt16(nume.Value), Direction = Convert.ToString(dct.Value), Band = Convert.ToInt16(bnd.Value), TimeStart = Convert.ToString(nume.Timestamp) //Coating = Convert.ToString(coa.Value), //DesignCount = Convert.ToInt16(dc.Value), //DesignLayer1 = Convert.ToDouble(dl1.Value), //DesignLayer2 = Convert.ToDouble(dl2.Value), //DesignLayer3 = Convert.ToDouble(dl3.Value), //Builder = Convert.ToString(br.Value), //Customer = Convert.ToString(cr.Value), //StandartsDensity = Convert.ToDouble(stndrtDensity.Value), //StandartsDepth = Convert.ToDouble(stndrtDepth.Value), //StandartsIRI = Convert.ToDouble(stndrtIRI.Value), //StandartsLenght = Convert.ToDouble(stndrtLenght.Value), //StandartsRut = Convert.ToDouble(stndrtRut.Value), //StandartsWidth = Convert.ToDouble(stndrtWidth.Value), //CoefficientTF = Convert.ToBoolean(ctf.Value), //KoefficB = Convert.ToByte(kfb.Value), //KoefficK = Convert.ToByte(kfk.Value), }; //Messur.Add(alarms); //} }
public ReadAllGraffics(string beginDate, string endDate) { var tagsList = new Tags(); Messur = new List <Graphics>(); var hdas = Connect.ServerHdaConnect(); var listTag = new List <string>(); foreach (var tag in tagsList.GetMassurm()) { switch (tag.Name) { case "CountLayers": listTag.Add(tag.Value); break; case "Distance": listTag.Add(tag.Value); break; case "OverallAssessment": listTag.Add(tag.Value); break; case "Layer1": listTag.Add(tag.Value); break; case "Layer2": listTag.Add(tag.Value); break; case "Layer3": listTag.Add(tag.Value); break; case "Sensor1": listTag.Add(tag.Value); break; case "Sensor2": listTag.Add(tag.Value); break; case "Rut": listTag.Add(tag.Value); break; case "Band": listTag.Add(tag.Value); break; case "IRI": listTag.Add(tag.Value); break; case "Latitude": listTag.Add(tag.Value); break; case "Longitude": listTag.Add(tag.Value); break; } } Signal distance = null; Signal countLayer = null; Signal generalState = null; Signal layer1 = null; Signal layer2 = null; Signal layer3 = null; Signal n1 = null; Signal n2 = null; Signal rut = null; Signal band = null; Signal iri = null; Signal latitude = null; Signal longitude = null; var di = new SignalDict(hdas, listTag, null, beginDate, endDate); foreach (var tag in tagsList.GetMassurm()) { switch (tag.Name) { case "CountLayers": countLayer = di.Dictionary[tag.Value]; break; case "Distance": distance = di.Dictionary[tag.Value]; break; case "OverallAssessment": generalState = di.Dictionary[tag.Value]; break; case "Layer1": layer1 = di.Dictionary[tag.Value]; break; case "Layer2": layer2 = di.Dictionary[tag.Value]; break; case "Layer3": layer3 = di.Dictionary[tag.Value]; break; case "Sensor1": n1 = di.Dictionary[tag.Value]; break; case "Sensor2": n2 = di.Dictionary[tag.Value]; break; case "Rut": rut = di.Dictionary[tag.Value]; break; case "Band": band = di.Dictionary[tag.Value]; break; case "IRI": iri = di.Dictionary[tag.Value]; break; case "Latitude": latitude = di.Dictionary[tag.Value]; break; case "Longitude": longitude = di.Dictionary[tag.Value]; break; } } for (var sec = 0; sec <= (countLayer.DtEnd - countLayer.DtBegin).TotalSeconds - 1; sec++) { var middle = new Graphics(); var ct = countLayer.DtBegin.AddSeconds(sec); var countl = Seconds.GetValue(countLayer, ct).OpcRec; var general = Seconds.GetValue(generalState, ct).OpcRec; var lr1 = Seconds.GetValue(layer1, ct).OpcRec; var lr2 = Seconds.GetValue(layer2, ct).OpcRec; var lr3 = Seconds.GetValue(layer3, ct).OpcRec; var int1 = Seconds.GetValue(n1, ct).OpcRec; var int2 = Seconds.GetValue(n2, ct).OpcRec; var dse = Seconds.GetValue(distance, ct).OpcRec; var rt = Seconds.GetValue(rut, ct).OpcRec; var bd = Seconds.GetValue(band, ct).OpcRec; var ir = Seconds.GetValue(iri, ct).OpcRec; var lade = Seconds.GetValue(latitude, ct).OpcRec; var lode = Seconds.GetValue(longitude, ct).OpcRec; middle.CountLayer = Convert.ToByte(countl.Value); middle.GeneralState = Convert.ToBoolean(general.Value); middle.Layer1 = Convert.ToSingle(lr1.Value); middle.Layer2 = Convert.ToSingle(lr2.Value); middle.Layer3 = Convert.ToSingle(lr3.Value); middle.IntensityN1 = Convert.ToDouble(int1.Value); middle.IntensityN2 = Convert.ToDouble(int2.Value); middle.Distance = Convert.ToSingle(dse.Value); middle.Rut = Convert.ToByte(rt.Value); middle.Band = Convert.ToUInt16(bd.Value); middle.IRI = Convert.ToDouble(ir.Value); middle.Latitude = Convert.ToSingle(lade.Value); middle.Longitude = Convert.ToSingle(lode.Value); Messur.Add(middle); } }