//Добавление подпараметров в SysTabl
public void AddSysSubParam(string templatePath, string paramName, string subParamName)
{
int paramId;
using (var sysTablRS = new RecDao(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)");
}
