private void Update_1_0_8() { //PrevParams Добавлена таблица PrevParams //Добавлена связь с таблицей CalcParamsArchive: Включить каскадное удаление, каскдное обновление //CalcParamsArchive.Id=PrevParams.ArchiveParamId //SysTabl В параметр ArchiveOptions добавлены подпараметры //IsPrevAbs, IsLastBase, IsLastHour, IsLastDay, IsLastMoments, //IsManyBase, IsManyHour, IsManyDay, IsManyMoments _db.AddTable("PrevParams", "[" + _templatePath + "].PrevParams"); _db.Dispose(); _db.SetColumnIndex("PrevParams", "FullCode", IndexModes.UniqueIndex); //db.ExecuteAdo("ALTER TABLE PrevParams ADD CONSTRAINT CalcParamsArchivePrevParams FOREIGN KEY (ArchiveParamId) REFERENCES CalcParamsArchive(Id) ON DELETE CASCADE ON UPDATE CASCADE"); _db.AddForeignLink("PrevParams", "ArchiveParamId", "CalcParamsArchive", "Id"); //отдельно настраиваем отображение в виде чекбоксов _db.SetColumnBool("PrevParams", "PrevAbs"); _db.SetColumnBool("PrevParams", "LastBase"); _db.SetColumnBool("PrevParams", "LastHour"); _db.SetColumnBool("PrevParams", "LastDay"); _db.SetColumnBool("PrevParams", "LastMoments"); _db.SetColumnBool("PrevParams", "ManyBase"); _db.SetColumnBool("PrevParams", "ManyHour"); _db.SetColumnBool("PrevParams", "ManyDay"); _db.SetColumnBool("PrevParams", "ManyMoments"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsPrevAbs"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsLastBase"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsLastHour"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsLastDay"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsLastMoments"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsManyBase"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsManyHour"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsManyDay"); _db.AddSysSubParam(_templatePath, "ArchiveOptions", "IsManyMoments"); }
public void Dispose() { if (_daoDb != null) { _daoDb.Dispose(); } }
//Открытие и закрытие SysTabl файла Result private void OpenResult() { try { if (_sysResult != null) { _sysResult.Dispose(); } if (_dbResilt != null) { _dbResilt.Dispose(); } _dbResilt = new DaoDb(ResultFile); _sysResult = new SysTabl(_dbResilt); _lastErrorPos = 0; } catch (Exception ex) { AddError("Ошибка при открытии SysTabl файла Result", ex); } }
private void button8_Click(object sender, EventArgs e) { string s = @"d:\Calc\Projects\Курган\Electro.accdb"; string sql = "SELECT Objects.*, Signals.* FROM Objects INNER JOIN Signals ON Objects.ObjectId = Signals.ObjectId"; var db = new DaoDb(s); var recd = new RecDao(db, sql); var reca = new ReaderAdo(db, sql); DateTime d = DateTime.Now; while (recd.Read()) { string f = recd.GetString("FullCode"); f = recd.GetString("CodeSignal"); f = recd.GetString("NameSignal"); } recd.Dispose(); MessageBox.Show(DateTime.Now.Subtract(d).ToString()); reca.Dispose(); db.Dispose(); }
public void InstanceFuns() { using (var sys = new SysTabl(CopyFile(""), false)) { Assert.IsNotNull(sys); Assert.AreEqual("OptionsValue", sys.Value("FileOptions")); Assert.AreEqual("ParamValue", sys.Value("Param")); Assert.AreEqual("OptionsTag", sys.Tag("FileOptions")); Assert.AreEqual("ParamTag", sys.Tag("Param")); sys.PutValue("Param", "s1", "t1"); Assert.AreEqual("s1", sys.Value("Param")); Assert.AreEqual("t1", sys.Tag("Param")); sys.PutValue("Param", 22, "t2"); Assert.AreEqual("22", sys.Value("Param")); Assert.AreEqual("t2", sys.Tag("Param")); sys.PutValue("Param", 33.3, "t3"); Assert.AreEqual("33,3", sys.Value("Param")); Assert.AreEqual("t3", sys.Tag("Param")); sys.PutValue("Param", new DateTime(2000, 1, 1)); Assert.AreEqual("01.01.2000 0:00:00", sys.Value("Param")); Assert.AreEqual("t3", sys.Tag("Param")); sys.PutValue("Param", true, ""); Assert.AreEqual("True", sys.Value("Param")); Assert.AreEqual("", sys.Tag("Param")); sys.PutTag("Param", "Tag", "Value"); Assert.AreEqual("Value", sys.Value("Param")); Assert.AreEqual("Tag", sys.Tag("Param")); } var db = new DaoDb(CopyFile("")); using (var sys = new SysTabl(db)) { Assert.IsNotNull(sys); Assert.AreEqual("OptionsValue", sys.Value("FileOptions")); Assert.AreEqual("ParamValue", sys.Value("Param")); Assert.AreEqual("OptionsTag", sys.Tag("FileOptions")); Assert.AreEqual("ParamTag", sys.Tag("Param")); Assert.AreEqual("Тестовый файл", sys.SubValue("FileOptions", "FileDescription")); Assert.AreEqual("DaoTest", sys.SubValue("FileOptions", "FileType")); Assert.AreEqual("2.0.0", sys.SubValue("FileOptions", "FileVersion")); Assert.AreEqual("11.07.2016", sys.SubValue("FileOptions", "FileVersionDate")); Assert.AreEqual("SubValue", sys.SubValue("Param", "SubParam")); Assert.AreEqual(null, sys.SubTag("FileOptions", "FileDescription")); Assert.AreEqual("SubTag", sys.SubTag("Param", "SubParam")); sys.PutSubValue("Param", "SubParam", "s1", "t1"); Assert.AreEqual("s1", sys.SubValue("Param", "SubParam")); Assert.AreEqual("t1", sys.SubTag("Param", "SubParam")); sys.PutSubValue("Param", "SubParam", 22, "t2"); Assert.AreEqual("22", sys.SubValue("Param", "SubParam")); Assert.AreEqual("t2", sys.SubTag("Param", "SubParam")); sys.PutSubValue("Param", "SubParam", 33.3, "t3"); Assert.AreEqual("33,3", sys.SubValue("Param", "SubParam")); Assert.AreEqual("t3", sys.SubTag("Param", "SubParam")); sys.PutSubValue("Param", "SubParam", new DateTime(2000, 1, 1)); Assert.AreEqual("01.01.2000 0:00:00", sys.SubValue("Param", "SubParam")); Assert.AreEqual("t3", sys.SubTag("Param", "SubParam")); sys.PutSubValue("Param", "SubParam", true, ""); Assert.AreEqual("True", sys.SubValue("Param", "SubParam")); Assert.AreEqual("", sys.SubTag("Param", "SubParam")); sys.PutSubTag("Param", "SubParam", "Tag", "Value"); Assert.AreEqual("Value", sys.SubValue("Param", "SubParam")); Assert.AreEqual("Tag", sys.SubTag("Param", "SubParam")); } db.Dispose(); }