//Запись в SysTabl ведомости
private void WriteSysTabl()
{
using (var sys = new SysTabl(_vedDb))
{
sys.PutSubValue("ProjectOptions", "Project", _project.Code);
sys.PutSubValue("ProjectOptions", "ProjectName", _project.Name);
sys.PutSubValue("ProjectOptions", "ProjectDescription", _project.Description);
sys.PutSubValue("ProjectOptions", "ProjectFile", _project.File);
sys.PutSubValue("TaskOptions", "Task", _task);
sys.PutSubValue("TaskOptions", "TaskDescription", _taskDescription);
sys.PutSubValue("VedOptions", "VedName", _task.IsEmpty() ? _project.Name : _task);
sys.PutSubValue("VedOptions", "VedDescription", _task.IsEmpty() ? _project.Description : _taskDescription);
sys.PutSubValue("VedOptions", "PeriodBegin", _project.ThreadCalc.PeriodBegin.ToString());
sys.PutSubValue("VedOptions", "PeriodEnd", _project.ThreadCalc.PeriodEnd.ToString());
sys.PutSubValue("VedOptions", "CreationTime", DateTime.Now.ToString());
string tag = _project.VedTag;
if (!tag.IsEmpty() && !tag.EndsWith(";"))
{
tag += ";";
}
sys.PutTag("VedTag", tag + _taskTag);
}
}
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();
}
