public static ActiveRecordBase GetEntityControlForm(Column column) { ActiveRecordBase entity = null; if (column == null) return null; Table selectedTable = column.Table; using (ISession session = ActiveRecordConfiguration.GetISession()) { IQueryable<KPMappingEntity> queryable = session.Query<KPMappingEntity>() .Where(x => x.OwnerSchema.Equals(selectedTable.OwnerSchema) && x.Database.Equals(selectedTable.DatabaseName) && x.Table.Equals(selectedTable.Name) && x.Column.Equals(column.Name)); KPMappingEntity mapEntity = queryable.FirstOrDefault(); if (mapEntity != null) { switch (column.ColumnTypeForm) { case KPComponentsFormsEnum.KPFormItemButton: entity = new KPFormItemButtonEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemCheckBox: entity = new KPFormItemCheckBoxEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemCombo: entity = new KPFormItemComboEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemEntity: entity = new KPFormItemEntityEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemGrid: entity = new KPFormItemGridEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemPassword: entity = new KPFormItemPasswordEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemText: entity = new KPFormItemTextEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemDateTime: entity = new KPFormItemDateTimeEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsFormsEnum.KPFormItemZoom: entity = new KPFormItemZoomEntity().GetEntityByMapping(mapEntity, column); break; } } } return entity; }
public static KPComponentsViewEnum GetKPComponentsView(Column column) { if (column.MappedDataType == typeof(bool) || column.MappedDataType == typeof(bool?)) { return KPComponentsViewEnum.KPBooleanModel; } else if (column.IsForeignKey) { return KPComponentsViewEnum.KPEntityModel; } return KPComponentsViewEnum.KPColumnModel; }
public static KPComponentsFormsEnum GetKPComponentsForms(Column column) { if (column.MappedDataType == typeof(bool) || column.MappedDataType == typeof(bool?)) { return KPComponentsFormsEnum.KPFormItemCheckBox; } else if (column.MappedDataType == typeof(DateTime) || column.MappedDataType == typeof(DateTime?)) { return KPComponentsFormsEnum.KPFormItemDateTime; } else if (column.IsForeignKey) { return KPComponentsFormsEnum.KPFormItemZoom; } else if (column.IsPrimaryKey) { return KPComponentsFormsEnum.KPFormItemKey; } return KPComponentsFormsEnum.KPFormItemText; }
public static ActiveRecordBase GetEntityControlView(Column column) { ActiveRecordBase entity = null; if (column == null) return null; Table selectedTable = column.Table; using (ISession session = ActiveRecordConfiguration.GetISession()) { IQueryable<KPMappingEntity> queryable = session.Query<KPMappingEntity>() .Where(x => x.OwnerSchema.Equals(selectedTable.OwnerSchema) && x.Database.Equals(selectedTable.DatabaseName) && x.Table.Equals(selectedTable.Name) && x.Column.Equals(column.Name)); KPMappingEntity mapEntity = queryable.FirstOrDefault(); if (mapEntity != null) { switch (column.ColumnTypeView) { case KPComponentsViewEnum.KPColumnModel: entity = new KPColumnModelEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsViewEnum.KPEnumModel: entity = new KPEnumModelEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsViewEnum.KPEntityModel: entity = new KPEntityModelEntity().GetEntityByMapping(mapEntity, column); break; case KPComponentsViewEnum.KPBooleanModel: entity = new KPBooleanModelEntity().GetEntityByMapping(mapEntity, column); break; } } } return entity; }
private string GetControlKPFormItemZoomEntity(Column column) { KPFormItemZoomEntity entity = column.EntityComponentForm as KPFormItemZoomEntity; StringBuilder sbEvent = new StringBuilder(); if (entity == null) return String.Empty; if (entity.KPEventZoomLostFocus) { sbEvent.AppendFormat(@"{0}{0}protected void {1}_KPEventZoomLostFocus()", UtilCharacter.TAB_SPACE, column.Name.GetFormattedText()).Append(UtilCharacter.NEW_LINE); sbEvent.AppendFormat(@"{0}{0}{{", UtilCharacter.TAB_SPACE).Append(UtilCharacter.NEW_LINE); sbEvent.AppendFormat(@"{0}{0}}}", UtilCharacter.TAB_SPACE).Append(UtilCharacter.NEW_LINE); } return sbEvent.ToString(); }
private string GetControlKPFormItemGridEntity(Column column) { KPFormItemGridEntity entity = column.EntityComponentForm as KPFormItemGridEntity; StringBuilder sbEvent = new StringBuilder(); if (entity == null) return String.Empty; if (entity.KPEventDeleteLine) { sbEvent.AppendFormat(@"{0}{0}protected void {1}_KPDeleteLine(object sender, GridViewDeleteEventArgs e)", UtilCharacter.TAB_SPACE, column.Name.GetFormattedText()).Append(UtilCharacter.NEW_LINE); sbEvent.AppendFormat(@"{0}{0}{{", UtilCharacter.TAB_SPACE).Append(UtilCharacter.NEW_LINE); sbEvent.AppendFormat(@"{0}{0}}}", UtilCharacter.TAB_SPACE).Append(UtilCharacter.NEW_LINE); } return sbEvent.ToString(); }
private int GetWidthComponent(KPMaskTypeClassEnum? markType, Column column) { int width = 100; if (column.IsPrimaryKey) return 100; if (Int32.TryParse(column.DataSize, out width)) width = width * 9; else width = 400; if (width > 400) width = 400; if (!markType.HasValue) return width; switch (markType.Value) { case KPMaskTypeClassEnum.CGC: case KPMaskTypeClassEnum.CNPJ: case KPMaskTypeClassEnum.CPF: return 135; case KPMaskTypeClassEnum.DATE: return 90; case KPMaskTypeClassEnum.DATEHOUR: return 110; case KPMaskTypeClassEnum.DATEMINUTE: return 130; case KPMaskTypeClassEnum.DATETIME: return 150; case KPMaskTypeClassEnum.INTEGER: return 70; case KPMaskTypeClassEnum.POSTCODE: return 70; case KPMaskTypeClassEnum.TELEPHONE: return 106; } return width; }
private string GetControlKPFormItemDateTimeEntity(Column column) { string propertyConcat = String.Empty; KPFormItemDateTimeEntity entity = column.EntityComponentForm as KPFormItemDateTimeEntity; if (entity == null) { entity = new KPFormItemDateTimeEntity() { Title = GlobalizationLanguage.GetString("KPEntity_Title"), IsRequired = !column.IsNullable }; } if (!String.IsNullOrWhiteSpace(entity.Title)) propertyConcat += String.Format(@" Title=""{0}""", entity.Title); if (entity.IsRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", entity.IsRequired.ToString().ToLower()); if (entity.Type.HasValue) propertyConcat += String.Format(@" Type=""{0}""", entity.Type.Value.ToString()); if (entity.KPEventTextLostFocus) propertyConcat += String.Format(@" OnKPEventTextLostFocus=""{0}_KPEventTextLostFocus""", column.Name.GetFormattedText()); return propertyConcat; }
public ZoomConfig(Column column, KPFormItemZoomEntity zoomEntity) { Column = column; ZoomEntity = zoomEntity; if (ZoomEntity == null) ZoomEntity = new KPFormItemZoomEntity(); }
private string GetControlKPFormItemTextEntity(Column column) { string propertyConcat = String.Empty; KPFormItemTextEntity entity = column.EntityComponentForm as KPFormItemTextEntity; if (entity == null) { entity = new KPFormItemTextEntity() { Title = GlobalizationLanguage.GetString("KPEntity_Title"), IsRequired = !column.IsNullable }; } var title = entity.Title; var isRequired = entity.IsRequired; var isMultiLine = entity.IsMultiline; var height = entity.Height; var eventLostFocus = entity.KPEventTextLostFocus; if (!String.IsNullOrWhiteSpace(title)) propertyConcat += String.Format(@" Title=""{0}""", title); if (isRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", isRequired.ToString().ToLower()); if (isMultiLine) propertyConcat += String.Format(@" MultiLine=""{0}""", isMultiLine.ToString().ToLower()); if (height > 0) propertyConcat += String.Format(@" Height=""{0}""", height); if (eventLostFocus) propertyConcat += String.Format(@" OnKPEventTextLostFocus=""{0}_KPEventTextLostFocus""", column.Name.GetFormattedText()); return propertyConcat; }
private string GetControlKPFormItemZoomEntity(Column column) { string propertyConcat = String.Empty; KPFormItemZoomEntity entity = column.EntityComponentForm as KPFormItemZoomEntity; if (entity == null) { entity = new KPFormItemZoomEntity() { Title = GlobalizationLanguage.GetString("KPEntity_Title"), IsRequired = !column.IsNullable }; } var title = entity.Title; var isRequired = entity.IsRequired; var descriptionWidth = entity.DescriptionWidth; var eventLostFocus = entity.KPEventZoomLostFocus; if (!String.IsNullOrWhiteSpace(title)) propertyConcat += String.Format(@" Title=""{0}""", title); if (isRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", isRequired.ToString().ToLower()); if (descriptionWidth > 0) propertyConcat += String.Format(@" DescriptionWidth=""{0}""", descriptionWidth); if (eventLostFocus) propertyConcat += String.Format(@" OnKPEventZoomLostFocus=""{0}_KPEventZoomLostFocus""", column.Name.GetFormattedText()); return propertyConcat; }
private string GetControlKPFormItemGridEntity(Column column) { string propertyConcat = String.Empty; KPFormItemGridEntity entity = column.EntityComponentForm as KPFormItemGridEntity; if (entity == null) entity = new KPFormItemGridEntity(); var isRequired = entity.IsRequired; var height = entity.Height; var eventDeleteLine = entity.KPEventDeleteLine; if (height > 0) propertyConcat += String.Format(@" Height=""{0}""", height); if (isRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", isRequired.ToString().ToLower()); if (eventDeleteLine) propertyConcat += String.Format(@" OnKPDeleteLine=""{0}_KPDeleteLine""", column.Name.GetFormattedText()); return propertyConcat; }
private string GetControlKPFormItemEntityEntity(Column column) { string propertyConcat = String.Empty; KPFormItemEntityEntity entity = column.EntityComponentForm as KPFormItemEntityEntity; if (entity == null) { entity = new KPFormItemEntityEntity() { Title = GlobalizationLanguage.GetString("KPEntity_Title"), IsRequired = !column.IsNullable }; } var isRequired = entity.IsRequired; var title = entity.Title; var fieldNameDescription = entity.FieldNameDescription; if (!String.IsNullOrWhiteSpace(title)) propertyConcat += String.Format(@" Title=""{0}""", title); if (!String.IsNullOrWhiteSpace(fieldNameDescription)) propertyConcat += String.Format(@" Description=""{0}""", fieldNameDescription); if (isRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", isRequired.ToString().ToLower()); return propertyConcat; }
private string GetControlKPFormItemComboEntity(Column column) { string propertyConcat = String.Empty; KPFormItemComboEntity entity = column.EntityComponentForm as KPFormItemComboEntity; if (entity == null) { entity = new KPFormItemComboEntity() { Title = GlobalizationLanguage.GetString("KPEntity_Title"), IsRequired = !column.IsNullable }; } var isRequired = entity.IsRequired; var title = entity.Title; var namespaceEnum = entity.NamespaceEnum; var dataName = entity.DataName; var dataValue = entity.DataValue; var eventSelectChange = entity.KPEventComboSelectChange; if (!String.IsNullOrWhiteSpace(title)) propertyConcat += String.Format(@" Title=""{0}""", title); if (!String.IsNullOrWhiteSpace(namespaceEnum)) propertyConcat += String.Format(@" NamespaceEnum=""{0}""", namespaceEnum); if (isRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", isRequired.ToString().ToLower()); if (!String.IsNullOrWhiteSpace(dataName) && !String.IsNullOrWhiteSpace(dataValue)) propertyConcat += String.Format(@" DataName=""{0}"" DataValue=""{1}""", dataName, dataValue); if (eventSelectChange) propertyConcat += String.Format(@" OnKPEventComboSelectChange=""{0}_KPEventComboSelectChange""", column.Name.GetFormattedText()); return propertyConcat; }
private string GetControlKPFormItemCheckBoxEntity(Column column) { string propertyConcat = String.Empty; KPFormItemCheckBoxEntity entity = column.EntityComponentForm as KPFormItemCheckBoxEntity; if (entity == null) { entity = new KPFormItemCheckBoxEntity() { Description = GlobalizationLanguage.GetString("KP_Description"), IsRequired = !column.IsNullable }; } var isRequired = entity.IsRequired; var isGroupStyleDisplay = entity.IsGroupStyleDisplay; var description = entity.Description; var eventSelect = entity.KPEventCheckBoxSelect; if (!String.IsNullOrWhiteSpace(description)) propertyConcat += String.Format(@" Description=""{0}""", description); if (isRequired) propertyConcat += String.Format(@" IsRequired=""{0}""", isRequired.ToString().ToLower()); if (isGroupStyleDisplay) propertyConcat += String.Format(@" IsGroupStyleDisplay=""{0}""", isGroupStyleDisplay.ToString().ToLower()); if (eventSelect) propertyConcat += String.Format(@" OnKPEventCheckBoxSelect=""{0}_KPEventCheckBoxSelect""", column.Name.GetFormattedText()); return propertyConcat; }
private string GetControlKPFormItemButtonEntity(Column column) { string propertyConcat = String.Empty; KPFormItemButtonEntity entity = column.EntityComponentForm as KPFormItemButtonEntity; if (entity == null) { entity = new KPFormItemButtonEntity() { Title = GlobalizationLanguage.GetString("KPEntity_Title") }; } var title = entity.Title; var eventClick = entity.KPEventClick; if (!String.IsNullOrWhiteSpace(title)) propertyConcat += String.Format(@" Title=""{0}""", title); if (eventClick) propertyConcat += String.Format(@" OnKPClick=""{0}_KPClick""", column.Name.GetFormattedText()); return propertyConcat; }