namespace DTS.Common.Storage { public partial class DbOperations { public abstract class TestSetups { public const string HardwareTable = "tblTestSetupHardware"; public enum HardwareFields { TestSetupName, HardwareId, AddOrRemove //0=remove,1=add } public const string DASSettingsTable = "tblTestSetupDASSettings"; public const string ChannelSettingsTable = "tblTestChannelSettings"; public enum ChannelSettingFields { TestName, TestObjectName, ChannelId, Setting, SensorSerial, Disabled } public enum ChannelFields { ISOChannelName, ISOCode, UserChannelName, UserCode, Disabled, Settings, SensorId, //version 3 DASId, //version 3 DASChannelIdx, //version 3 TestSetupOrder, //version 3 GroupOrder, //version 3 Id //version 3 } public enum SettingsFields { //Version 3 and earlier Range, CFC, Polarity, //Version 2 and earlier LimitDuration, Duration, Delay, OutputMode, SQMode, DIMode, DefaultValue, ActiveValue, //version 4 (DataPRO 2.1) SquibLimitDuration, SquibDuration, SquibDelay, DigitalOutLimitDuration, DigitalOutDuration, DigitalOutDelay, SquibCurrent, UserValue1, UserValue2, UserValue3, //Version 5? (DataPRO 2.4) [noticed these issues during testing of 3.0] //15270 Sensor Import does not import most channel settings ZeroMethod, ZeroMethodStart, ZeroMethodEnd, //Version 6? (DataPRO 3.0) //15270 Sensor Import does not import most channel settings InitialOffset, FilterClass, //Version ?? (DataPRO 4.0) //18363 Uart Channels UartBaudRate, UartDataBits, UartStopBits, UartParity, UartFlowControl, UartDataFormat, //18364 Stream Out Channels StreamOutUDPProfile, StreamOutUDPAddress, StreamOutUDPTimeChannelId, StreamOutUDPDataChannelId, StreamOutUDPTmNSConfig, StreamOutIRIGTimeDataPacketIntervalMs, //http://manuscript.dts.local/f/cases/29760/Implement-ACCoupleEnable-for-TSR-AIR ACCouplingEnabled, StreamOutTMATSIntervalMs, //33415 Voltage insertion channel should be half bridge BridgeType } public const string TestSetupsTable = "tblTestSetups"; public enum Fields { SetupName, SetupDescription, AutomaticTestProgression, AutomaticProgressionDelayMS, InvertTrigger, InvertStart, IgnoreShortedStart, IgnoreShortedTrigger, ViewDiagnostics, VerifyChannels, AutoVerifyChannels, VerifyChannelsDelayMS, RecordingMode, SamplesPerSecond, PreTriggerSeconds, PostTriggerSeconds, NumberOfEvents, WakeUpMotionTimeout, ScheduledStartDateTime, IntervalBetweenEventStartsMinutes, StartWithEvent, WakeUpWithMotion, StrictDiagnostics, RequireConfirmationOnErrors, ROIDownload, ViewROIDownload, DownloadAll, ViewRealtime, RealtimePlotCount, RegionsOfInterest, ROIStart, ROIEnd, ViewDownloadAll, Export, ExportFormat, LabDetails, UseLabDetails, CustomerDetails, UseCustomerDetails, AllowMissingSensors, AllowSensorIdToBlankChannel, LocalOnly, LastModified, LastModifiedBy, TurnOffExcitation, TriggerCheckRealtime, TriggerCheckStep, PostTestDiagnostics, ExportFolder, DownloadFolder, CommonStatusLine, SameAsDownloadFolder, UploadData, UploadDataFolder, UploadExportsOnly, Settings, WarnOnBatteryFail, Dirty, Complete, ErrorMessage, TestEngineerDetails, UseTestEngineerDetails, UserTags, DoAutoArm, DoEnableRepeat, DoStreaming, CheckoutMode, QuitTestWithoutWarning, SuppressMissingSensorsWarning, ISFFile, NotAllChannelsRealTime, NotAllChannelsViewer, CalibrationBehavior, ClockSyncProfileMaster, ClockSyncProfileSlave, ExtraProperties, MeasureSquibResistancesStep, TestSetupUniqueId, AlignUDPToPPS } public const string TestSetupObjectsTable = "tblTestSetupObjects"; public enum TestSetupObjectFields { TestObjectSerialNumber, TestObjectName, //TestObjectSerialNumber was changed to TestObjectName in a later version TestSetupName, TargetSampleRate, ExcitationWarmupTimeMS, LocalOnly, TestObjectType, TestObjectPosition, DisplayOrder } public enum TestSetupDASHardwareFields { SerialNumber, SamplesPerSecond, AntiAliasFilterRate, IsClockMaster, PTPDomainID } public enum TestSetupGroupFields { SerialNumber, Name, DisplayName, Description, TestSetupName, DisplayOrder, Position, TestObjectType, Id, StaticGroupId } public const string TestObjectMetaDataTable = "tblTestSetupObjectMetaData"; public enum TestObjectMetaDataFields { TestObject, ISOTestObject, SetupName, TestSetupName, PropName, PropValue, Optional, Version, } public const string TestObjectTemplatesTable = "tblTestObjectTemplates"; public enum TestObjectTemplatesFields { TemplateName, Icon, Description, LocalOnly, Version, LastModifiedBy, CRC32, TestObject, LastModified, ParentTemplate, SysBuilt } public const string TestObjectsTable = "tblTestObjects"; public enum TestObjectsFields { SerialNumber, LastModifiedBy, LastModified, Template, LocalOnly, ParentObject, SysBuilt, Embedded, OriginalTemplate, OriginalSerialNumber } public enum GroupsGroupFields { Name, LastModifiedBy, LastModified, Id, Tags } public enum GroupsGroupChannelFields { IsoCode, IsoChannelName, UserCode, UserChannelName, DASId, DASChannelIndex, GroupChannelOrder, Sensor, SensorId, Disabled, LastModified, LastModifiedBy } public enum GroupsGroupHardwareListFields { Hardware } public const string TestGraphsTable = "tblTestGraphs"; public enum GraphFields { GraphName, GraphDescription, TemplateName, Channels, UseDomainMin, DomainMin, UseDomainMax, DomainMax, UseRangeMin, RangeMin, UseRangeMax, RangeMax, Thresholds, LocalOnly, TestSetupName } } } }