public void SetTemplate(string alias) { TT = ConfigMemory.Templates[alias]; TemplateBody = TT.ElementTemplate; TemplateContent = TT.ItemsTemplate; // why do this? //T.View = config.SelectedView; }
void PushState(TableTemplate template) { Model.LastViewMode = ViewMode.TemplatePreview; Model.LastTemplate = template; cbTemplateGroups.Text = (template).Group; cbTemplateRow.SelectedValue = template; }
public IHttpActionResult PutTableTemplate(int id, TableTemplate tableTemplate) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { service.PutTableTemplate(id, tableTemplate); return(StatusCode(HttpStatusCode.NoContent)); } catch (NotFoundException) { return(NotFound()); } catch (BadRequestException ex) { return(BadRequest(ex.Message)); } catch { throw; } }
public static string SQLGenerateAlterTable(this TableTemplate template, string tableName) { SqlServerMigrationSqlGenerator gen = new SqlServerMigrationSqlGenerator(); ColumnBuilder columnBuilder = new ColumnBuilder(); //columnBuilder.Int(name:"sysid",identity:true); //System.Data.Entity.Migrations.DbMigration var operations = new List <MigrationOperation>(); var dict = new Dictionary <string, AnnotationValues>(); dict.Add("dddddd", new AnnotationValues(1, 2)); var alter = new AlterTableOperation("dddd", dict); //alter.Columns.Add(new ColumnModel(PrimitiveTypeKind.String) { Name="dd" }); //operations.Add(alter); operations.Add(new AddColumnOperation(tableName, columnBuilder.String(name: "dd"))); operations.Add(new AlterColumnOperation(tableName, new ColumnModel(PrimitiveTypeKind.String) { Name = "dd3", MaxLength = 20 }, false)); operations.Add(new AlterColumnOperation(tableName, new ColumnModel(PrimitiveTypeKind.String) { Name = "dd2", MaxLength = 50 }, false)); operations.Add(new RenameColumnOperation(tableName, "dd3", "ee3")); var sqls = gen.Generate(operations, "2008").Select <MigrationStatement, string>(ms => ms.Sql).ToArray(); var sql = string.Join("\r\n\r\n", sqls); return(sql); }
/// <exception cref="BadRequestException"></exception> public void PutTableTemplate(int id, TableTemplate tableTemplate) { if (id != tableTemplate.Id) { throw new BadRequestException(); } db.Entry(tableTemplate).State = EntityState.Modified; db.Entry(tableTemplate).Property("IsDelete").IsModified = false; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TableTemplateExists(id)) { throw new BadRequestException(); } else { throw; } } }
protected override void Render(HtmlTextWriter output) { var operationsPart = new TableTemplate { Title = "Operations:", Items = this.OperationNames, ForEachItem = RenderRow }.ToString(); var xsdsPart = new ListTemplate { Title = "XSDS:", ListItemsIntMap = this.Xsds, ListItemTemplate = @"<li><a href=""?xsd={0}"">{1}</a></li>" }.ToString(); var wsdlTemplate = new StringBuilder(); var soap11Config = MetadataConfig.GetMetadataConfig("soap11") as SoapMetadataConfig; var soap12Config = MetadataConfig.GetMetadataConfig("soap12") as SoapMetadataConfig; if (soap11Config != null || soap12Config != null) { wsdlTemplate.AppendLine("<h3>WSDLS:</h3>"); wsdlTemplate.AppendLine("<ul>"); if (soap11Config != null) { wsdlTemplate.AppendFormat( @"<li><a href=""{0}"">{0}</a></li>", soap11Config.WsdlMetadataUri); } if (soap12Config != null) { wsdlTemplate.AppendFormat( @"<li><a href=""{0}"">{0}</a></li>", soap12Config.WsdlMetadataUri); } wsdlTemplate.AppendLine("</ul>"); } var debugOnlyInfo = new StringBuilder(); if (EndpointHost.DebugMode) { debugOnlyInfo.Append("<h3>Debug Info:</h3>"); debugOnlyInfo.AppendLine("<ul>"); debugOnlyInfo.AppendLine("<li><a href=\"operations/metadata\">Operations Metadata</a></li>"); debugOnlyInfo.AppendLine("</ul>"); } var renderedTemplate = string.Format( PageTemplate, this.Title, this.MetadataPageBodyHtml, this.XsdServiceTypesIndex, operationsPart, xsdsPart, wsdlTemplate, debugOnlyInfo); output.Write(renderedTemplate); }
protected override void Render(HtmlTextWriter output) { var operationsPart = new TableTemplate { Title = "Operations:", Items = this.OperationNames, ForEachItem = RenderRow }.ToString(); var xsdsPart = new ListTemplate { Title = "XSDS:", ListItemsIntMap = this.Xsds, ListItemTemplate = @"<li><a href=""?xsd={0}"">{1}</a></li>" }.ToString(); var wsdlTemplate = new StringBuilder(); var soap11Config = MetadataConfig.GetMetadataConfig("soap11") as SoapMetadataConfig; var soap12Config = MetadataConfig.GetMetadataConfig("soap12") as SoapMetadataConfig; if (soap11Config != null || soap12Config != null) { wsdlTemplate.AppendLine("<h3>WSDLS:</h3>"); wsdlTemplate.AppendLine("<ul>"); if (soap11Config != null) { wsdlTemplate.AppendFormat( @"<li><a href=""{0}"">{0}</a></li>", soap11Config.WsdlMetadataUri); } if (soap12Config != null) { wsdlTemplate.AppendFormat( @"<li><a href=""{0}"">{0}</a></li>", soap12Config.WsdlMetadataUri); } wsdlTemplate.AppendLine("</ul>"); } var debugOnlyInfo = new StringBuilder(); if (EndpointHost.DebugMode) { debugOnlyInfo.Append("<h3>Debug Info:</h3>"); debugOnlyInfo.AppendLine("<ul>"); debugOnlyInfo.AppendLine("<li><a href=\"operations/metadata\">Operations Metadata</a></li>"); debugOnlyInfo.AppendLine("</ul>"); } var renderedTemplate = HtmlTemplates.Format( HtmlTemplates.IndexOperationsTemplate, this.Title, this.MetadataPageBodyHtml, this.XsdServiceTypesIndex, operationsPart, xsdsPart, wsdlTemplate, debugOnlyInfo); output.Write(renderedTemplate); }
private void btnAddField_Click(object sender, EventArgs e) { var tableRowTemplate = new TableTemplate(MainPanel, containerPanel_Click); listOfColumnTemplates.Add(tableRowTemplate); tableRowTemplate.Show(); MainPanel.Refresh(); }
public static UserSettings getInstance(TableTemplate template = null, int id = 0) { if (instance == null) { instance = new UserSettings(template, id); } return(instance); }
public void PostTableTemplate(TableTemplate tableTemplate) { if (db.TableTemplates.Where(p => p.Name == tableTemplate.Name).Count() > 0) { throw new BadRequestException("此名称已存在"); } db.TableTemplates.Add(tableTemplate); db.SaveChanges(); }
/// <exception cref="BadRequestException"></exception> public void PutTableTemplateFields(int id, List <TableTemplateField[]> fields) { using (var tran = db.Database.BeginTransaction()) { try { TableTemplate tableTemplate = db.TableTemplates.Find(id); if (tableTemplate == null) { throw new BadRequestException("无效数据"); } if (fields[0] != null) { fields[0].ToList().ForEach(p => { tableTemplate.Fields.Add(p); }); } db.SaveChanges(); if (fields[1] != null) { fields[1].ToList().ForEach(p => { var field = tableTemplate.Fields.FirstOrDefault(q => q.Id == p.Id); if (field == null) { throw new BadRequestException(string.Format("无效删除数据:{0},{1}", p.Name, p.Title)); } tableTemplate.Fields.Remove(field); db.TableTemplateFields.Remove(field); }); } db.SaveChanges(); if (fields[2] != null) { fields[2].ToList().ForEach(p => { var field = tableTemplate.Fields.FirstOrDefault(q => q.Id == p.Id); if (field == null) { throw new BadRequestException("无效数据"); } db.Entry(field).State = EntityState.Detached; db.Entry(p).State = EntityState.Modified; }); } db.SaveChanges(); tran.Commit(); } catch (Exception) { tran.Rollback(); throw; } } }
public IActionResult Edit(TableTemplate model) { if (ModelState.IsValid) { dataManager.TableTemplates.SaveTableItem(model); return(RedirectToAction(nameof(HomeController.Index), nameof(HomeController).CutController())); } return(View(model)); }
/// <exception cref="NotFoundException"></exception> public IEnumerable <TableTemplateField> GetTableTemplateFields(int id) { TableTemplate tableTemplate = db.TableTemplates.Find(id); if (tableTemplate == null) { throw new NotFoundException(); } return(tableTemplate.Fields); }
public string Generate(TableElement tableName, TableTemplate templateName) { Generator.Export.Intrinsic.IDbConfiguration4 config = GetConfig(tableName, templateName); GeneratedTemplate = Model.Databases.ConvertInput(config, config.SelectedTable.Name); if (TemplateGeneratedAction != null) { TemplateGeneratedAction.Invoke(GeneratedTemplate); } config = null; return(GeneratedTemplate); }
public IHttpActionResult GetTableTemplate(int id) { TableTemplate tableTemplate = service.GetTableTemplate(id);// db.TableTemplates.Find(id); if (tableTemplate == null) { return(NotFound()); } return(Ok(tableTemplate)); }
public IHttpActionResult PostTableTemplate(TableTemplate tableTemplate) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } service.PostTableTemplate(tableTemplate); return(CreatedAtRoute("DefaultApi", new { id = tableTemplate.Id }, tableTemplate)); }
public void SaveTableItem(TableTemplate entity) { if (entity.id == default) { context.Entry(entity).State = EntityState.Added; } else { context.Entry(entity).State = EntityState.Modified; } context.SaveChanges(); }
private void btnDeleteRow_Click(object sender, EventArgs e) { foreach (TableTemplate dbRow in listOfColumnTemplates) { if (dbRow.IsControlPanelClicked == true) { dbRow.Dispose(); listOfColumnTemplates.Remove(dbRow); break; } } TableTemplate.ReGenerateIndexes(listOfColumnTemplates); }
public IHttpActionResult DeleteTableTemplate(int id) { try { TableTemplate tableTemplate = service.DeleteTableTemplate(id); return(Ok(tableTemplate)); } catch (NotFoundException) { return(NotFound()); } catch (BadRequestException ex) { return(BadRequest(ex.Message)); } }
protected override void Render(HtmlTextWriter output) { var servicesPart = new TableTemplate { Title = "Services:", Items = ServiceData.Keys.ToList(), ForEachItem = RenderRow }.ToString(); var renderedTemplate = string.Format( HtmlTemplates.IndexServicesTemplate, servicesPart, AntServiceStackVersion); output.Write(renderedTemplate); }
public static TableTemplate ToTemplate(this Type type, string name = null) { var table = new TableTemplate() { Name = type.Name }; if (name != null) { table.Name = name; } foreach (var property in type.GetProperties()) { table.Fields.Add(property.ToTemplateField()); } return(table); }
public void Init(int tid) { if (tempDict.ContainsKey(tid)) { template = tempDict[tid]; } else { using (TemplateModel db = new TemplateModel()) { template = db.TableTemplates.Find(tid); template.Fields.ToList(); } tempDict.Add(tid, template); } type = template.CreateType(); }
public static string SQLGenerateCreateTable(this TableTemplate template, string tableName) { SqlServerMigrationSqlGenerator gen = new SqlServerMigrationSqlGenerator(); var operations = new List <MigrationOperation>(); var table = new CreateTableOperation(tableName); table.PrimaryKey = new AddPrimaryKeyOperation(); foreach (var field in template.Fields) { PrimitiveTypeKind typeKind; if (field.Type == TableTemplateFieldType.Int) { typeKind = PrimitiveTypeKind.Int32; } else if (field.Type == TableTemplateFieldType.String) { typeKind = PrimitiveTypeKind.String; } else { typeKind = PrimitiveTypeKind.String; } var column = new ColumnModel(typeKind); column.Name = field.Name; if (column.Type == PrimitiveTypeKind.String) { column.MaxLength = field.Length; } if (field.IsKey) { table.PrimaryKey.Columns.Add(field.Name); } if (field.Name.ToLower() == "sys_id") { column.IsIdentity = true; } table.Columns.Add(column); } operations.Add(table); var sql = gen.Generate(operations, "2008").FirstOrDefault(); return(sql.Sql); }
static public string Parse( DatabaseCollection databases, DatabaseElement database, TemplateCollection templates, TableElement table, TableTemplate template ) { return(Parse( new DataCfg() { Databases = databases, Database = database, Table = table, Templates = templates, Template = template })); }
/// <exception cref="BadRequestException"></exception> /// <exception cref="NotFoundException"></exception> public TableTemplate DeleteTableTemplate(int id) { TableTemplate tableTemplate = db.TableTemplates.Find(id); if (tableTemplate == null) { throw new NotFoundException(); } if (tableTemplate.Fields.Count() > 0) { throw new BadRequestException("非空无法删除。"); } //db.TableTemplates.Remove(tableTemplate); tableTemplate.IsDelete = true; db.SaveChanges(); return(tableTemplate); }
void Event_CreateTemplate(object sender, RoutedEventArgs e) { control = new CreateTemplateDialog() { Title = "New Template", ResizeMode = ResizeMode.CanResizeWithGrip, }; control.cbGroup.ItemsSource = Model.TemplateGroups; control.cbGroup.DisplayMemberPath = "Group"; TableTemplate element = null; var rc = new RelayCommand((x) => { control.DialogResult = true; element = new TableTemplate() { Alias = control.tbName.Text, Group = control.cbGroup.Text, ElementTemplate = "", ItemsTemplate = "" }; control.Close(); }); control.Buttons = new[] { control.CancelButton, new Button() { Content = "okay", Command = rc, IsDefault = true } }; restart: var value = control.ShowDialog(); if (!(value.HasValue && value.Value)) { return; } if (string.IsNullOrEmpty(element.Alias)) { control.Title = "supply a name for your template!"; goto restart; } Model.Reader.Model.Templates.Add(element); Model.Reader.Model.Templates = Model.Reader.Model.Templates; RefreshTemplates(); PushState(element); }
public void ApplyTemplate(TableTemplate template) { if (null == template) { throw new ArgumentNullException(nameof(template)); } Height = TableTemplate.Height; var listTemplate = new TunableListTemplate { HeaderClickable = template.HeaderClickable, CommandMenu = template.CommandMenu }; listTemplate.Columns.AddRange(template.Columns); listTemplate.Icons.AddRange(template.Icons); listTemplate.SetTemplateInternals(template.TemplateName, template.BaseDirectory); ApplyTemplate(listTemplate); }
protected override void Render(HtmlTextWriter output) { var operationsPart = new TableTemplate { Title = "Operations:", Items = this.OperationNames, ForEachItem = RenderRow }.ToString(); var metadata = EndpointHost.AppHost.GetPlugin <MetadataFeature>(); var pluginLinks = metadata != null && metadata.PluginLinks.Count > 0 ? new ListTemplate { Title = metadata.PluginLinksTitle, ListItemsMap = metadata.PluginLinks, ListItemTemplate = @"<li><a href=""{0}"">{1}</a></li>" }.ToString() : ""; var debugOnlyInfo = new StringBuilder(); if (EndpointHost.DebugMode) { debugOnlyInfo.Append("<h3>Debug Info:</h3>"); debugOnlyInfo.AppendLine("<ul>"); debugOnlyInfo.AppendLine("<li><a href=\"operations/metadata\">Operations Metadata</a></li>"); debugOnlyInfo.AppendLine("</ul>"); } var renderedTemplate = string.Format( HtmlTemplates.IndexOperationsTemplate, this.Title, operationsPart, debugOnlyInfo, AntServiceStackVersion, AntCodeGenVersion, pluginLinks); output.Write(renderedTemplate); }
public static Type CreateType(this TableTemplate template, string typeName, string tableName, Type parent = null, Type[] interfaces = null) { if (entityTypes.ContainsKey(typeName)) { return(entityTypes[typeName]); } if (interfaces == null) { interfaces = Type.EmptyTypes; } //应用程序域 AppDomain currentDomain = System.Threading.Thread.GetDomain(); //AppDomain.CurrentDomain; //运行并创建类的新实例 TypeBuilder typeBuilder = null; //定义和表示动态程序集的模块 ModuleBuilder moduleBuilder = null; //定义表示动态程序集 AssemblyBuilder assemblyBuilder = null; MethodBuilder methodBuilder = null; //表示类型属性 PropertyBuilder propertyBuilder = null; //定义表示字段 FieldBuilder fieldBuilder = null; //生成中间语言指令 ILGenerator ilGenerator = null; //帮助生成自定义属性 CustomAttributeBuilder cab = null; //指定方法属性的标志 MethodAttributes methodAttrs; //Define a Dynamic Assembly //指定名称,访问模式 assemblyBuilder = currentDomain.DefineDynamicAssembly(new AssemblyName("TableTemplate"), AssemblyBuilderAccess.Run); //Define a Dynamic Module动态模块名称 moduleBuilder = assemblyBuilder.DefineDynamicModule(string.Format("Module{0}", typeName), true); //Define a runtime class with specified name and attributes. typeBuilder = moduleBuilder.DefineType( typeName, TypeAttributes.Public | TypeAttributes.Class | TypeAttributes.BeforeFieldInit | TypeAttributes.Serializable, parent, interfaces ); typeBuilder.SetCustomAttribute(new CustomAttributeBuilder(typeof(System.ComponentModel.DataAnnotations.Schema.TableAttribute).GetConstructor(new Type[] { typeof(string) }), new object[] { tableName })); foreach (var type in interfaces) { var properties = type.GetProperties(); foreach (var property in properties) { int length = 0; var attribute = property.GetCustomAttribute(typeof(MaxLengthAttribute)) as MaxLengthAttribute; if (attribute != null) { length = attribute.Length; } typeBuilder.CreateProperty(property.Name, property.PropertyType, length, property.IsDefined(typeof(KeyAttribute)), true); } } foreach (var field in template.Fields) { Type t; if (field.Type == TableTemplateFieldType.Int) { t = typeof(int); } else if (field.Type == TableTemplateFieldType.String) { t = typeof(string); } else if (field.Type == TableTemplateFieldType.Boolean) { t = typeof(bool); } else { t = typeof(string); } typeBuilder.CreateProperty(field.Name, t, field.Length, field.IsKey); } var newtype = typeBuilder.CreateType(); entityTypes.Add(typeName, newtype); return(newtype); }
public static Type CreateType(this TableTemplate template, string typeName, Type parent = null, Type[] interfaces = null) { return(CreateType(template, typeName, typeName, parent, interfaces)); }
public static Type CreateType(this TableTemplate template, Type[] interfaces = null) { return(CreateType(template, template.Name, template.Name, null, interfaces)); }