//Чтение списка параметров для записи в архив public void ReadArchiveParams() { try { AddEvent("Загрузка архивных параметров"); ArchiveProject = new ArchiveProject(Code, Name, ReportType.Calc, LastChange); ArchiveParams.Clear(); using (var db = new DaoDb(File)) { using (var rec = new ReaderAdo(db, "SELECT CalcParamsArchive.* FROM CalcParamsArchive INNER JOIN CalcParams ON CalcParams.CalcParamId = CalcParamsArchive.CalcParamId WHERE CalcParams.CalcOn=True")) while (rec.Read()) { var par = new CalcParamArchive(rec, this); ArchiveProject.AddParam(par.ArchiveParam); ArchiveParams.Add(par.ArchiveParam.FullCode, par); } PrevParams.Clear(); if (IsLastBase || IsLastHour || IsLastDay) { PrevLastReport = new ArchiveReport(Code + "_Last_" + ThreadCalc.FullThreadName, Name, ReportType.Calc, LastChange); } if (IsManyBase || IsManyHour || IsManyDay || IsManyMoments) { PrevManyReport = new ArchiveReport(Code + "_Many_" + ThreadCalc.FullThreadName, Name, ReportType.Calc, LastChange); } using (var rec = new ReaderAdo(db, "SELECT * FROM PrevParams")) while (rec.Read()) { var p = new Prev(rec, this); PrevParams.Add(p.Code, p); if (p.LastReportParam != null) { PrevLastReport.AddParam(p.LastReportParam); } if (p.ManyReportParam != null) { PrevManyReport.AddParam(p.ManyReportParam); } } } } catch (Exception ex) { AddError("Ошибка при чтении списка архивных параметров", ex); } }
public VedParam(CalcParamArchive param, VedSaver saver) { _vedSaver = saver; _param = param; _props.Add("Code", _param.ArchiveParam.FullCode); _props.Add("Name", _param.FirstParam.Name); _props.Add("DataType", _param.DataType.ToRussian()); _props.Add("Units", _param.ArchiveParam.Units); _props.Add("Comment", _param.FirstParam.Comment); _props.Add("Min", _param.ArchiveParam.Min != null ? _param.ArchiveParam.Min.ToString() : null); //12.04.2019 не был обработан случай null _props.Add("Max", _param.ArchiveParam.Max != null ? _param.ArchiveParam.Max.ToString() : null); //12.04.2019 не был обработан случай null //ab 20.02.2019 //if (_param.FirstParam.CodeSignal != null) //{ //var dic = _param.FirstParam.Project.SignalsSources[_param.FirstParam.CodeSignal].TagObject.ToPropertyDicS(); // _props.AddDic(dic); //} _props.Add("CodeSignal", _param.FirstParam.CodeSignal); //\ab }