public static string TemplateService(TableInfo Table, string ServiceNameSpace, string EntityNameSpace) { StringBuilder codestring = new StringBuilder(@"using System; using System.Collections.Generic; using System.Linq; using System.Text; using YiFen.Core; using YiFen.DataHelper; "); codestring.Append("using ").Append(EntityNameSpace).Append(";\r\n\r\n"); codestring.Append("namespace ").Append(ServiceNameSpace).Append("\r\n{\r\n"); codestring.Append("public class ").Append(Table.Name).Append("Service : YiFen.DataHelper.Service<").Append(Table.Name).Append("Entity>\r\n{"); codestring.Append("\r\n}\r\n}"); return codestring.ToString(); }
TableInfo GetTableInfo(string ConnectionString, string TableName) { TableInfo table = new TableInfo(); table.Name = TableName; string sql = "SELECT TOP 1 * FROM [" + TableName + "]"; using (SqlDataReader rd = SqlHelper.ExecuteReader(ConnectionString, CommandType.Text, sql)) { for (int i = 0; i < rd.FieldCount; i++) { FieldInfo field = new FieldInfo(); field.Name = rd.GetName(i); field.DbType = rd.GetFieldType(i); table.Fields.Add(field); } } return table; }
public static string TemplateEntity(TableInfo Table, string NameSpace) { StringBuilder codestring = new StringBuilder(@"using System; using System.Collections.Generic; using System.Text; using System.ComponentModel; using System.ComponentModel.DataAnnotations; using YiFen.DataHelper; "); codestring.Append("namespace ").Append(NameSpace).Append("\r\n{\r\n"); codestring.Append("public class ").Append(Table.Name).Append("Entity : YiFen.DataHelper.Entity\r\n{"); foreach (FieldInfo field in Table.Fields) { codestring.Append(TemplateEntity(field)); } codestring.Append("}\r\n}"); return codestring.ToString(); }