public MobilePlantDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType)
        {
            RowNumber = rowNumber;
            WorkSheetName = workSheetName;

            Hirer = string.Empty;
            Owner = string.Empty;
            Registration = string.Empty;

            Tag = dr.SafeString((int)MobilePlantColumn.Tag).Trim();
            EquipmentType = dr.SafeString((int)MobilePlantColumn.Type).Trim();
            Description = dr.SafeString((int)MobilePlantColumn.Description).Trim();
            Notes = dr.SafeString((int)MobilePlantColumn.Notes);
            Hirer = dr.SafeString((int)MobilePlantColumn.Hirer);
            Owner = dr.SafeString((int)MobilePlantColumn.Owner);
            AreaNumber = dr.SafeString((int)MobilePlantColumn.Area).Trim();
            Registration = dr.SafeString((int)MobilePlantColumn.Registration).Trim();
            Expiry = dr.SafeNullableDate((int)MobilePlantColumn.Expiry);
            Classified = dr.SafeNullableBool((int)MobilePlantColumn.Classified);
            MaintSysId = dr.SafeString((int)MobilePlantColumn.MaintSysId);
            IsActive = dr.SafeNullableBool((int)MobilePlantColumn.IsActive);

            Validate(importType == CommonUtils.ImportType.CreateMobilePlant);
        }
Exemple #2
0
        public AlarmDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType)
        {
            RowNumber = rowNumber;
            WorkSheetName = workSheetName;

            ControlSystemName = dr.SafeString((int)AlarmColumn.ControlSystemName).Trim();
            ComponentName = dr.SafeString((int)AlarmColumn.ComponentName).Trim();
            AlarmPropertyName = dr.SafeString((int)AlarmColumn.AlarmPropertyName).Trim();

            Enabled = dr.SafeNullableBool((int)AlarmColumn.Enabled);

            OnDelay = dr.SafeNullableInt((int)AlarmColumn.OnDelay);
            OffDelay = dr.SafeNullableInt((int)AlarmColumn.OffDelay);

            ActivationExpr = dr.SafeString((int)AlarmColumn.ActivationExpr).Trim();
            MaskingExpr = dr.SafeString((int)AlarmColumn.MaskingExpr).Trim();

            AlarmCalcExprEnabled = dr.SafeNullableBool((int)AlarmColumn.AlarmCalcExprEnabled);
            AlarmCalcExpr = dr.SafeString((int)AlarmColumn.AlarmCalcExpr).Trim();

            Purpose = dr.SafeString((int)AlarmColumn.Purpose).Trim();
            Consequence = dr.SafeString((int)AlarmColumn.Consequence).Trim();
            Response = dr.SafeString((int)AlarmColumn.Response).Trim();

            Notes = dr.SafeString((int)AlarmColumn.Notes).Trim();
            Guidance = dr.SafeString((int)AlarmColumn.Guidance).Trim();

            Tested = dr.SafeNullableBool((int)AlarmColumn.Tested);
            TestedDate = dr.SafeNullableDate((int)AlarmColumn.TestedDate);
            TestedUser = dr.SafeString((int)AlarmColumn.TestedUser).Trim();

            Reviewed = dr.SafeNullableBool((int)AlarmColumn.Reviewed);
            ReviewedDate = dr.SafeNullableDate((int)AlarmColumn.ReviewedDate);
            ReviewedUser = dr.SafeString((int)AlarmColumn.ReviewedUser).Trim();

            Reportable = dr.SafeNullableBool((int)AlarmColumn.Reportable);
            ReportableDate = dr.SafeNullableDate((int)AlarmColumn.ReportableDate);
            ReportableUser = dr.SafeString((int)AlarmColumn.ReportableUser).Trim();

            PurposeIsIndendedNull = dr.IntendedNull((int)AlarmColumn.Purpose);
            ConsequenceIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Consequence);
            ResponseTimeIsIndendedNull = dr.IntendedNull((int)AlarmColumn.Response);

            AlarmCalcExprIsIntendedNull = dr.IntendedNull((int)AlarmColumn.AlarmCalcExpr);
            ActivationExprIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ActivationExpr);
            MaskingExprIsIntendedNull = dr.IntendedNull((int)AlarmColumn.MaskingExpr);
            GuidanceIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Guidance);

            OnDelayIsIntendedNull = dr.IntendedNull((int)AlarmColumn.OnDelay);
            OffDelayIsIntendedNull = dr.IntendedNull((int)AlarmColumn.OffDelay);
            NotesIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Notes);

            TestedDateIsIntendedNull = dr.IntendedNull((int)AlarmColumn.TestedDate);
            TestedUserIsIntendedNull = dr.IntendedNull((int)AlarmColumn.TestedUser);

            ReviewedIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Reviewed);
            ReviewedDateIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReviewedDate);
            ReviewedUserIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReviewedUser);

            ReportabledIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Reportable);
            ReportabledDateIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReportableDate);
            ReportableUserIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReportableUser);
        }