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();
}
