//Добавление подпараметров в SysTabl
public void AddSysSubParam(string templatePath, //Файл с шаблонным SysTabl
string paramName, //Имя параметра
string subParamName) //Имя подпараметра
{
int paramId;
using (var sysTablRs = new DaoRec(templatePath, "SELECT ParamId,ParamName FROM SysTabl WHERE ParamName='" + paramName + "'"))
paramId = sysTablRs.GetInt("ParamId");
Execute("INSERT INTO SysSubTabl " +
"SELECT ParamId, SubParamNum, SubParamName,SubParamType, SubParamValue, SubParamDescription, SubParamTag, SubParamRowSource " +
"FROM [" + templatePath + "].SysSubTabl t1 WHERE t1.ParamId=" + paramId + " AND t1.SubParamName='" + subParamName +
"' AND NOT EXISTS(SELECT * FROM SysSubTabl t2 WHERE t1.SubParamName = t2.SubParamName)");
}
public void WriteStart(LogCommand command)
{
LogEventTime = DateTime.Now;
RunHistoryOperation(_history, () =>
{
_history.AddNew();
if (ProgressCommand != null)
{
_history.Put("SuperHistoryId", _superHistoryId);
}
_history.Put("Command", command.Name);
_history.Put("Params", command.Params);
_history.Put("Status", command.Status);
_history.Put("Time", command.StartTime);
_history.Put("Context", command.Context, true);
_historyId = _history.GetInt("HistoryId");
});
}
public void WriteStartSuper(ProgressCommand command)
{
RunHistoryOperation(_superHistory, () =>
{
_superHistory.AddNew();
_superHistory.Put("Command", command.Name);
_superHistory.Put("Params", command.Params);
_superHistory.Put("Context", command.Context, true);
if (Logger.PeriodCommand != null)
{
_superHistory.Put("PeriodBegin", Logger.PeriodBegin);
_superHistory.Put("PeriodEnd", Logger.PeriodEnd);
_superHistory.Put("PeriodMode", Logger.PeriodMode);
}
_superHistory.Put("Status", command.Status);
_superHistory.Put("Time", command.StartTime);
_superHistoryId = _superHistory.GetInt("SuperHistoryId");
});
}
