Ejemplo n.º 1
0
        protected TaxRegionMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.StoreId, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = TaxRegionMetadata.PropertyNames.StoreId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.CountryCode, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = TaxRegionMetadata.PropertyNames.CountryCode;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 2;
            m_columns.Add(c);

            c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.Region, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = TaxRegionMetadata.PropertyNames.Region;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 150;
            m_columns.Add(c);

            c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.TaxRate, 3, typeof(System.Decimal), esSystemType.Decimal);
            c.PropertyName     = TaxRegionMetadata.PropertyNames.TaxRate;
            c.NumericPrecision = 10;
            c.NumericScale     = 6;
            c.IsNullable       = true;
            m_columns.Add(c);
        }
Ejemplo n.º 2
0
        protected OrderItemMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(OrderItemMetadata.ColumnNames.OrderID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = OrderItemMetadata.PropertyNames.OrderID;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(OrderItemMetadata.ColumnNames.ProductID, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = OrderItemMetadata.PropertyNames.ProductID;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(OrderItemMetadata.ColumnNames.UnitPrice, 2, typeof(System.Decimal), esSystemType.Decimal);
            c.PropertyName     = OrderItemMetadata.PropertyNames.UnitPrice;
            c.NumericPrecision = 19;
            m_columns.Add(c);

            c = new esColumnMetadata(OrderItemMetadata.ColumnNames.Quantity, 3, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = OrderItemMetadata.PropertyNames.Quantity;
            c.NumericPrecision = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(OrderItemMetadata.ColumnNames.Discount, 4, typeof(System.Single), esSystemType.Single);
            c.PropertyName     = OrderItemMetadata.PropertyNames.Discount;
            c.NumericPrecision = 7;
            c.IsNullable       = true;
            m_columns.Add(c);
        }
Ejemplo n.º 3
0
        public override void SetProperty(string name, object value)
        {
            esColumnMetadata col = this.Meta.Columns.FindByPropertyName(name);

            if (col != null)
            {
                if (value == null || value is System.String)
                {
                    // Use the strongly typed property
                    switch (name)
                    {
                    case "VersionNumber": this.str().VersionNumber = (string)value; break;
                    }
                }
                else
                {
                    switch (name)
                    {
                    default:
                        break;
                    }
                }
            }
            else if (this.ContainsColumn(name))
            {
                this.SetColumn(name, value);
            }
            else
            {
                throw new Exception("SetProperty Error: '" + name + "' not found");
            }
        }
Ejemplo n.º 4
0
        protected ProductMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ProductMetadata.ColumnNames.ProductID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ProductMetadata.PropertyNames.ProductID;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductMetadata.ColumnNames.ProductName, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = ProductMetadata.PropertyNames.ProductName;
            c.CharacterMaxLength = 50;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductMetadata.ColumnNames.UnitPrice, 2, typeof(System.Decimal), esSystemType.Decimal);
            c.PropertyName     = ProductMetadata.PropertyNames.UnitPrice;
            c.NumericPrecision = 19;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductMetadata.ColumnNames.Discontinued, 3, typeof(System.Boolean), esSystemType.Boolean);
            c.PropertyName = ProductMetadata.PropertyNames.Discontinued;
            m_columns.Add(c);
        }
        protected FullNameViewMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.FullName, 0, typeof(System.String), esSystemType.String);
            c.PropertyName       = FullNameViewMetadata.PropertyNames.FullName;
            c.CharacterMaxLength = 42;
            c.IsNullable         = true;
            m_columns.Add(c);

            c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.DepartmentID, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = FullNameViewMetadata.PropertyNames.DepartmentID;
            c.NumericPrecision = 10;
            c.IsNullable       = true;
            m_columns.Add(c);

            c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.HireDate, 2, typeof(System.DateTime), esSystemType.DateTime);
            c.PropertyName = FullNameViewMetadata.PropertyNames.HireDate;
            c.IsNullable   = true;
            m_columns.Add(c);

            c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.Salary, 3, typeof(System.Decimal), esSystemType.Decimal);
            c.PropertyName     = FullNameViewMetadata.PropertyNames.Salary;
            c.NumericPrecision = 8;
            c.NumericScale     = 4;
            c.IsNullable       = true;
            m_columns.Add(c);

            c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.IsActive, 4, typeof(System.Boolean), esSystemType.Boolean);
            c.PropertyName = FullNameViewMetadata.PropertyNames.IsActive;
            c.IsNullable   = true;
            m_columns.Add(c);
        }
        protected ReverseCompositeChildMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.ChildId, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ReverseCompositeChildMetadata.PropertyNames.ChildId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.ParentKeyId, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ReverseCompositeChildMetadata.PropertyNames.ParentKeyId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.ParentKeySub, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = ReverseCompositeChildMetadata.PropertyNames.ParentKeySub;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 3;
            m_columns.Add(c);

            c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.Description, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = ReverseCompositeChildMetadata.PropertyNames.Description;
            c.CharacterMaxLength = 50;
            c.IsNullable         = true;
            m_columns.Add(c);
        }
Ejemplo n.º 7
0
        protected ADefHelpDeskSettingsMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.SettingID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ADefHelpDeskSettingsMetadata.PropertyNames.SettingID;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.PortalID, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ADefHelpDeskSettingsMetadata.PropertyNames.PortalID;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.SettingName, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = ADefHelpDeskSettingsMetadata.PropertyNames.SettingName;
            c.CharacterMaxLength = 150;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.SettingValue, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = ADefHelpDeskSettingsMetadata.PropertyNames.SettingValue;
            c.CharacterMaxLength = 250;
            m_columns.Add(c);
        }
        protected AnnotationPlotAxisDataMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = AnnotationPlotAxisDataMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.AxisId, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = AnnotationPlotAxisDataMetadata.PropertyNames.AxisId;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.SeriesId, 2, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = AnnotationPlotAxisDataMetadata.PropertyNames.SeriesId;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.DataBin, 3, typeof(System.Byte[]), esSystemType.ByteArray);
            c.PropertyName       = AnnotationPlotAxisDataMetadata.PropertyNames.DataBin;
            c.CharacterMaxLength = 2147483647;
            c.IsNullable         = true;
            m_columns.Add(c);
        }
Ejemplo n.º 9
0
        protected EmailTemplateMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.Id, 0, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = EmailTemplateMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.NameKey, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = EmailTemplateMetadata.PropertyNames.NameKey;
            c.CharacterMaxLength = 75;
            m_columns.Add(c);

            c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.Description, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = EmailTemplateMetadata.PropertyNames.Description;
            c.CharacterMaxLength = 1073741823;
            m_columns.Add(c);

            c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.DefaultSubject, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = EmailTemplateMetadata.PropertyNames.DefaultSubject;
            c.CharacterMaxLength = 300;
            c.HasDefault         = true;
            c.Default            = @"('')";
            m_columns.Add(c);

            c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.DefaultBody, 4, typeof(System.String), esSystemType.String);
            c.PropertyName       = EmailTemplateMetadata.PropertyNames.DefaultBody;
            c.CharacterMaxLength = 1073741823;
            c.HasDefault         = true;
            c.Default            = @"('')";
            m_columns.Add(c);
        }
Ejemplo n.º 10
0
        protected ProductPhotoMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ProductPhotoMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.ProductId, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ProductPhotoMetadata.PropertyNames.ProductId;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.DisplayName, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = ProductPhotoMetadata.PropertyNames.DisplayName;
            c.CharacterMaxLength = 250;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.Filename, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = ProductPhotoMetadata.PropertyNames.Filename;
            c.CharacterMaxLength = 500;
            m_columns.Add(c);

            c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.SortOrder, 4, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = ProductPhotoMetadata.PropertyNames.SortOrder;
            c.NumericPrecision = 5;
            c.HasDefault       = true;
            c.Default          = @"((1))";
            m_columns.Add(c);
        }
Ejemplo n.º 11
0
        protected ClientesMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ClientesMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ClientesMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ClientesMetadata.ColumnNames.Nombre, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = ClientesMetadata.PropertyNames.Nombre;
            c.CharacterMaxLength = 150;
            m_columns.Add(c);

            c = new esColumnMetadata(ClientesMetadata.ColumnNames.Direccion, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = ClientesMetadata.PropertyNames.Direccion;
            c.CharacterMaxLength = 150;
            m_columns.Add(c);

            c = new esColumnMetadata(ClientesMetadata.ColumnNames.Telefono, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = ClientesMetadata.PropertyNames.Telefono;
            c.CharacterMaxLength = 23;
            m_columns.Add(c);

            c = new esColumnMetadata(ClientesMetadata.ColumnNames.Email, 4, typeof(System.String), esSystemType.String);
            c.PropertyName       = ClientesMetadata.PropertyNames.Email;
            c.CharacterMaxLength = 75;
            m_columns.Add(c);
        }
Ejemplo n.º 12
0
        protected ADefHelpDeskLogMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.LogID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ADefHelpDeskLogMetadata.PropertyNames.LogID;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.TaskID, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ADefHelpDeskLogMetadata.PropertyNames.TaskID;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.LogDescription, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = ADefHelpDeskLogMetadata.PropertyNames.LogDescription;
            c.CharacterMaxLength = 500;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.DateCreated, 3, typeof(System.DateTime), esSystemType.DateTime);
            c.PropertyName = ADefHelpDeskLogMetadata.PropertyNames.DateCreated;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.UserID, 4, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ADefHelpDeskLogMetadata.PropertyNames.UserID;
            c.NumericPrecision = 10;
            m_columns.Add(c);
        }
        protected StorePaymentProviderSettingMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.StoreId, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = StorePaymentProviderSettingMetadata.PropertyNames.StoreId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.PaymentProviderId, 1, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = StorePaymentProviderSettingMetadata.PropertyNames.PaymentProviderId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.Name, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = StorePaymentProviderSettingMetadata.PropertyNames.Name;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 500;
            m_columns.Add(c);

            c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.Value, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = StorePaymentProviderSettingMetadata.PropertyNames.Value;
            c.CharacterMaxLength = 1000;
            m_columns.Add(c);
        }
        protected SqlCeDataTypesMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = SqlCeDataTypesMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.NumericType, 1, typeof(System.Decimal), esSystemType.Decimal);
            c.PropertyName     = SqlCeDataTypesMetadata.PropertyNames.NumericType;
            c.NumericPrecision = 18;
            c.IsNullable       = true;
            m_columns.Add(c);

            c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.RealType, 2, typeof(System.Single), esSystemType.Single);
            c.PropertyName     = SqlCeDataTypesMetadata.PropertyNames.RealType;
            c.NumericPrecision = 24;
            c.IsNullable       = true;
            m_columns.Add(c);

            c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.FloatType, 3, typeof(System.Double), esSystemType.Double);
            c.PropertyName     = SqlCeDataTypesMetadata.PropertyNames.FloatType;
            c.NumericPrecision = 53;
            c.IsNullable       = true;
            m_columns.Add(c);
        }
Ejemplo n.º 15
0
        protected PeriodeAnggaranMetadata()
        {
            _columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.Id, 0, typeof(System.Int64), esSystemType.Int64);
            c.PropertyName     = PeriodeAnggaranMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 19;
            _columns.Add(c);

            c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.StartPeriod, 1, typeof(System.DateTime), esSystemType.DateTime);
            c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.StartPeriod;
            _columns.Add(c);

            c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.EndPeriod, 2, typeof(System.DateTime), esSystemType.DateTime);
            c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.EndPeriod;
            c.IsNullable   = true;
            _columns.Add(c);

            c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.IsClosed, 3, typeof(System.Boolean), esSystemType.Boolean);
            c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.IsClosed;
            _columns.Add(c);
        }
Ejemplo n.º 16
0
        protected AccountInfoMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Name, 0, typeof(System.String), esSystemType.String);
            c.PropertyName       = AccountInfoMetadata.PropertyNames.Name;
            c.CharacterMaxLength = 50;
            m_columns.Add(c);

            c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Id, 1, typeof(System.Guid), esSystemType.Guid);
            c.PropertyName   = AccountInfoMetadata.PropertyNames.Id;
            c.IsInPrimaryKey = true;
            m_columns.Add(c);

            c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Age, 2, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = AccountInfoMetadata.PropertyNames.Age;
            c.NumericPrecision = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Address, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = AccountInfoMetadata.PropertyNames.Address;
            c.CharacterMaxLength = 256;
            c.IsNullable         = true;
            m_columns.Add(c);
        }
Ejemplo n.º 17
0
        protected KasMetadata()
        {
            _columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(KasMetadata.ColumnNames.Id, 0, typeof(System.Int64), esSystemType.Int64);
            c.PropertyName     = KasMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 19;
            _columns.Add(c);

            c = new esColumnMetadata(KasMetadata.ColumnNames.KaCode, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = KasMetadata.PropertyNames.KaCode;
            c.CharacterMaxLength = 15;
            _columns.Add(c);

            c = new esColumnMetadata(KasMetadata.ColumnNames.KaName, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = KasMetadata.PropertyNames.KaName;
            c.CharacterMaxLength = 256;
            _columns.Add(c);

            c = new esColumnMetadata(KasMetadata.ColumnNames.SaldoAwal, 3, typeof(System.Decimal), esSystemType.Decimal);
            c.PropertyName     = KasMetadata.PropertyNames.SaldoAwal;
            c.NumericPrecision = 15;
            c.NumericScale     = 2;
            _columns.Add(c);

            c = new esColumnMetadata(KasMetadata.ColumnNames.PeriodeId, 4, typeof(System.Int64), esSystemType.Int64);
            c.PropertyName     = KasMetadata.PropertyNames.PeriodeId;
            c.NumericPrecision = 19;
            _columns.Add(c);
        }
Ejemplo n.º 18
0
        protected NewTableMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(NewTableMetadata.ColumnNames.Id, 0, typeof(System.Int64), esSystemType.Int64);
            c.PropertyName     = NewTableMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 19;
            m_columns.Add(c);

            c = new esColumnMetadata(NewTableMetadata.ColumnNames.CustomerName, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = NewTableMetadata.PropertyNames.CustomerName;
            c.CharacterMaxLength = 25;
            m_columns.Add(c);

            c = new esColumnMetadata(NewTableMetadata.ColumnNames.LastName, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = NewTableMetadata.PropertyNames.LastName;
            c.CharacterMaxLength = 25;
            m_columns.Add(c);

            c = new esColumnMetadata(NewTableMetadata.ColumnNames.FirstName, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = NewTableMetadata.PropertyNames.FirstName;
            c.CharacterMaxLength = 25;
            m_columns.Add(c);
        }
        protected DefaultTestMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(DefaultTestMetadata.ColumnNames.TestId, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = DefaultTestMetadata.PropertyNames.TestId;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(DefaultTestMetadata.ColumnNames.DefaultNotNullInt, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = DefaultTestMetadata.PropertyNames.DefaultNotNullInt;
            c.NumericPrecision = 10;
            c.HasDefault       = true;
            c.Default          = @"((0))";
            m_columns.Add(c);

            c = new esColumnMetadata(DefaultTestMetadata.ColumnNames.DefaultNotNullBool, 2, typeof(System.Boolean), esSystemType.Boolean);
            c.PropertyName = DefaultTestMetadata.PropertyNames.DefaultNotNullBool;
            c.HasDefault   = true;
            c.Default      = @"((0))";
            m_columns.Add(c);
        }
Ejemplo n.º 20
0
        public override IEnumerable GetDesignTimeData(int minimumRows, out bool isSampleData)
        {
            isSampleData = false;
            if (this.SelectedColumns != null)
            {
                DataTable table = new DataTable();
                foreach (string columnName in this.SelectedColumns)
                {
                    esColumnMetadata col = this.esColumnCollection.FindByPropertyName(columnName);

                    if (!col.IsConcurrency)
                    {
                        DataColumn dc = table.Columns.Add(col.PropertyName, col.Type);

                        if (col.IsInPrimaryKey)
                        {
                            dc.Unique = true;
                        }
                    }
                }

                if (table != null)
                {
                    isSampleData = true;
                    return(DesignTimeData.GetDesignTimeDataSource(DesignTimeData.CreateSampleDataTable(new DataView(table), true), minimumRows));
                }
                return(base.GetDesignTimeData(minimumRows, out isSampleData));
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 21
0
        int IComparer <T> .Compare(T obj1, T obj2)
        {
            esEntity         obj      = obj1 as esEntity;
            esColumnMetadata esColumn = obj.es.Meta.Columns.FindByPropertyName(sortProperty.Name);

            return(obj1.OnSort(obj2, esColumn, sortProperty.Name));
        }
Ejemplo n.º 22
0
        protected StoreEmailTemplateMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.StoreId, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = StoreEmailTemplateMetadata.PropertyNames.StoreId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.EmailTemplateId, 1, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = StoreEmailTemplateMetadata.PropertyNames.EmailTemplateId;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.SubjectTemplate, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = StoreEmailTemplateMetadata.PropertyNames.SubjectTemplate;
            c.CharacterMaxLength = 300;
            m_columns.Add(c);

            c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.BodyTemplate, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = StoreEmailTemplateMetadata.PropertyNames.BodyTemplate;
            c.CharacterMaxLength = 1073741823;
            m_columns.Add(c);
        }
        protected NamingTest2Metadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.IdentityKey, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = NamingTest2Metadata.PropertyNames.IdentityKey;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.ItemDescription, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = NamingTest2Metadata.PropertyNames.ItemDescription;
            c.CharacterMaxLength = 50;
            c.IsNullable         = true;
            m_columns.Add(c);

            c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.ConcurrencyCheck, 2, typeof(System.Byte[]), esSystemType.ByteArray);
            c.PropertyName       = NamingTest2Metadata.PropertyNames.ConcurrencyCheck;
            c.CharacterMaxLength = 8;
            c.IsComputed         = true;
            c.IsConcurrency      = true;
            m_columns.Add(c);

            c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.GuidNewid, 3, typeof(System.Guid), esSystemType.Guid);
            c.PropertyName = NamingTest2Metadata.PropertyNames.GuidNewid;
            c.HasDefault   = true;
            c.Default      = @"(newid())";
            m_columns.Add(c);
        }
Ejemplo n.º 24
0
        protected EmployeeMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(EmployeeMetadata.ColumnNames.EmployeeID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = EmployeeMetadata.PropertyNames.EmployeeID;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(EmployeeMetadata.ColumnNames.LastName, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = EmployeeMetadata.PropertyNames.LastName;
            c.CharacterMaxLength = 25;
            m_columns.Add(c);

            c = new esColumnMetadata(EmployeeMetadata.ColumnNames.FirstName, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = EmployeeMetadata.PropertyNames.FirstName;
            c.CharacterMaxLength = 25;
            m_columns.Add(c);

            c = new esColumnMetadata(EmployeeMetadata.ColumnNames.Supervisor, 3, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = EmployeeMetadata.PropertyNames.Supervisor;
            c.NumericPrecision = 10;
            c.IsNullable       = true;
            m_columns.Add(c);

            c = new esColumnMetadata(EmployeeMetadata.ColumnNames.Age, 4, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = EmployeeMetadata.PropertyNames.Age;
            c.NumericPrecision = 10;
            c.IsNullable       = true;
            m_columns.Add(c);
        }
Ejemplo n.º 25
0
        protected vStoreEmailTemplateMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.NameKey, 0, typeof(System.String), esSystemType.String);
            c.PropertyName       = vStoreEmailTemplateMetadata.PropertyNames.NameKey;
            c.CharacterMaxLength = 75;
            m_columns.Add(c);

            c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.Description, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = vStoreEmailTemplateMetadata.PropertyNames.Description;
            c.CharacterMaxLength = 1073741823;
            m_columns.Add(c);

            c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.StoreId, 2, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = vStoreEmailTemplateMetadata.PropertyNames.StoreId;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.EmailTemplateId, 3, typeof(System.Int16), esSystemType.Int16);
            c.PropertyName     = vStoreEmailTemplateMetadata.PropertyNames.EmailTemplateId;
            c.NumericPrecision = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.SubjectTemplate, 4, typeof(System.String), esSystemType.String);
            c.PropertyName       = vStoreEmailTemplateMetadata.PropertyNames.SubjectTemplate;
            c.CharacterMaxLength = 300;
            m_columns.Add(c);

            c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.BodyTemplate, 5, typeof(System.String), esSystemType.String);
            c.PropertyName       = vStoreEmailTemplateMetadata.PropertyNames.BodyTemplate;
            c.CharacterMaxLength = 1073741823;
            m_columns.Add(c);
        }
Ejemplo n.º 26
0
        protected OffShoreFundPricesMetadata()
        {
            _columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = OffShoreFundPricesMetadata.PropertyNames.Id;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            _columns.Add(c);

            c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.OMAMFundId, 1, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = OffShoreFundPricesMetadata.PropertyNames.OMAMFundId;
            c.NumericPrecision = 10;
            _columns.Add(c);

            c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.Price, 2, typeof(System.Double), esSystemType.Double);
            c.PropertyName     = OffShoreFundPricesMetadata.PropertyNames.Price;
            c.NumericPrecision = 15;
            _columns.Add(c);

            c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.CreatedDate, 3, typeof(System.DateTime), esSystemType.DateTime);
            c.PropertyName = OffShoreFundPricesMetadata.PropertyNames.CreatedDate;
            _columns.Add(c);

            c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.CreatedBy, 4, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = OffShoreFundPricesMetadata.PropertyNames.CreatedBy;
            c.NumericPrecision = 10;
            _columns.Add(c);
        }
        protected StudentClassMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Sid1, 0, typeof(System.String), esSystemType.String);
            c.PropertyName       = StudentClassMetadata.PropertyNames.Sid1;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 5;
            m_columns.Add(c);

            c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Sid2, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = StudentClassMetadata.PropertyNames.Sid2;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 3;
            m_columns.Add(c);

            c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Cid1, 2, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = StudentClassMetadata.PropertyNames.Cid1;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Cid2, 3, typeof(System.String), esSystemType.String);
            c.PropertyName       = StudentClassMetadata.PropertyNames.Cid2;
            c.IsInPrimaryKey     = true;
            c.CharacterMaxLength = 10;
            m_columns.Add(c);
        }
Ejemplo n.º 28
0
        protected ADefHelpDeskRIAUsersMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.UserID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = ADefHelpDeskRIAUsersMetadata.PropertyNames.UserID;
            c.IsInPrimaryKey   = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.RIAPassword, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = ADefHelpDeskRIAUsersMetadata.PropertyNames.RIAPassword;
            c.CharacterMaxLength = 50;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.IPAddress, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = ADefHelpDeskRIAUsersMetadata.PropertyNames.IPAddress;
            c.CharacterMaxLength = 50;
            m_columns.Add(c);

            c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.CreatedDate, 3, typeof(System.DateTime), esSystemType.DateTime);
            c.PropertyName = ADefHelpDeskRIAUsersMetadata.PropertyNames.CreatedDate;
            m_columns.Add(c);
        }
        protected CategoriesMetadata()
        {
            m_columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(CategoriesMetadata.ColumnNames.CategoryID, 0, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = CategoriesMetadata.PropertyNames.CategoryID;
            c.IsInPrimaryKey   = true;
            c.IsAutoIncrement  = true;
            c.NumericPrecision = 10;
            m_columns.Add(c);

            c = new esColumnMetadata(CategoriesMetadata.ColumnNames.CategoryName, 1, typeof(System.String), esSystemType.String);
            c.PropertyName       = CategoriesMetadata.PropertyNames.CategoryName;
            c.CharacterMaxLength = 15;
            m_columns.Add(c);

            c = new esColumnMetadata(CategoriesMetadata.ColumnNames.Description, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = CategoriesMetadata.PropertyNames.Description;
            c.CharacterMaxLength = 1073741823;
            c.IsNullable         = true;
            m_columns.Add(c);

            c = new esColumnMetadata(CategoriesMetadata.ColumnNames.Picture, 3, typeof(System.Byte[]), esSystemType.ByteArray);
            c.PropertyName       = CategoriesMetadata.PropertyNames.Picture;
            c.CharacterMaxLength = 2147483647;
            c.IsNullable         = true;
            m_columns.Add(c);
        }
        protected VwLatestOffShoreFundPricesMetadata()
        {
            _columns = new esColumnMetadataCollection();
            esColumnMetadata c;

            c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.FundName, 0, typeof(System.String), esSystemType.String);
            c.PropertyName       = VwLatestOffShoreFundPricesMetadata.PropertyNames.FundName;
            c.CharacterMaxLength = 100;
            _columns.Add(c);

            c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.Price, 1, typeof(System.Double), esSystemType.Double);
            c.PropertyName     = VwLatestOffShoreFundPricesMetadata.PropertyNames.Price;
            c.NumericPrecision = 15;
            c.IsNullable       = true;
            _columns.Add(c);

            c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.Currency, 2, typeof(System.String), esSystemType.String);
            c.PropertyName       = VwLatestOffShoreFundPricesMetadata.PropertyNames.Currency;
            c.CharacterMaxLength = 5;
            _columns.Add(c);

            c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.OMAMFundId, 3, typeof(System.Int32), esSystemType.Int32);
            c.PropertyName     = VwLatestOffShoreFundPricesMetadata.PropertyNames.OMAMFundId;
            c.NumericPrecision = 10;
            c.IsNullable       = true;
            _columns.Add(c);
        }