internal static void SetParameters( IDbCommand cmd, String action, IEntity obj, EntityInfo entityInfo ) { for (int i = 0; i < entityInfo.SavedPropertyList.Count; i++) { EntityPropertyInfo info = entityInfo.SavedPropertyList[i]; if (isContinue( action, info, entityInfo )) continue; Object paramVal = obj.get( info.Name ); if (paramVal == null && info.DefaultAttribute != null) { paramVal = info.DefaultAttribute.Value; } if (paramVal == null) { setDefaultValue( cmd, info, entityInfo ); } else if (info.Type.IsSubclassOf( typeof( IEntity ) ) || MappingClass.Instance.ClassList.Contains( info.Type.FullName )) { setEntityId( cmd, info, paramVal ); } else { paramVal = DataFactory.SetParameter( cmd, info.ColumnName, paramVal ); obj.set( info.Name, paramVal ); } } }
private void addColumnSingle( EntityInfo entity, StringBuilder sb, EntityPropertyInfo ep, String columnName ) { if (ep.Type == typeof( int )) { addColumn_Int( sb, ep, columnName ); } else if (ep.Type == typeof( long )) { addColumn_Long( sb, columnName ); } else if (ep.Type == typeof( DateTime )) { addColumn_Time( sb, columnName ); } else if (ep.Type == typeof( decimal )) { addColumn_Decimal( entity, sb, ep, columnName ); } else if (ep.Type == typeof( double )) { addColumn_Double( entity, sb, columnName ); } else if (ep.Type == typeof( float )) { addColumn_Single( entity, sb, columnName ); } else if (ep.Type == typeof( String )) { addColumn_String( entity, sb, ep, columnName ); } else if (ep.IsEntity) { addColumn_entity( sb, columnName ); } }
/// <summary> /// 获取数据库连接,返回的连接已经打开(open);在 mvc 框架中不用关闭,框架会自动关闭连接。 /// 之所以要传入 EntityInfo,因为 ORM 支持多个数据库,不同的类型有可能映射到不同的数据库。 /// </summary> /// <param name="et"></param> /// <returns></returns> public static IDbConnection getConnection( EntityInfo et ) { String db = et.Database; String connectionString = DbConfig.GetConnectionString( db ); IDbConnection connection; getConnectionAll().TryGetValue( db, out connection ); if (connection == null) { connection = DataFactory.GetConnection( connectionString, et.DbType ); connection.Open(); setConnection( db, connection ); if (shouldTransaction()) { IDbTransaction trans = connection.BeginTransaction(); setTransaction( db, trans ); } return connection; } if (connection.State == ConnectionState.Closed) { connection.ConnectionString = connectionString; connection.Open(); } return connection; }
protected override void addColumn_PrimaryKey( EntityInfo entity, StringBuilder sb, Dictionary<String, EntityInfo> clsList ) { if (isAddIdentityKey( entity.Type ) == false) { sb.Append( " Id int primary key default 0, " ); } else { sb.Append( " Id int identity(1,1) primary key, " ); } }
private void makeOneController( EntityInfo ei ) { String[] arrTypeItem = ei.FullName.Split( '.' ); String domainNamespace = strUtil.TrimEnd( ei.FullName, "." + arrTypeItem[arrTypeItem.Length - 1] ); string codeList = this.getListCode( ei ); string codeAdd = this.getAddCode( ei ); string codeCreate = this.getCreateCode( ei ); string codeEdit = this.getEditCode( ei ); string codeUpdate = this.getUpdateCode( ei ); string codeDel = this.getDeleteCode( ei ); Template template = new Template(); template.InitContent( CrudActionTemplate.GetController() ); template.Set( "domainNamespace", domainNamespace ); template.Set( "namespace", this.namespaceName ); template.Set( "controllerName", ei.Name ); template.Set( "domainCamelName", strUtil.GetCamelCase( ei.Name ) ); IBlock setList = template.GetBlock( "setList" ); foreach (EntityPropertyInfo ep in ei.SavedPropertyList) { setList.Set( "propertyName", ep.Name ); if (ep.IsLongText) { if (rft.GetAttribute( ep.Property, typeof( HtmlTextAttribute ) ) == null) { setList.Set( "propertyValue", "strUtil.CutString( data." + ep.Name + ", 30 )" ); } else { setList.Set( "propertyValue", "strUtil.ParseHtml( data." + ep.Name + ", 50 )" ); } } else if (ep.IsEntity) { String entityName = getEntityName( ep ); setList.Set( "propertyValue", "data." + entityName ); } else { setList.Set( "propertyValue", "data." + ep.Name ); } setList.Next(); } template.Set( "listCode", codeList ); template.Set( "addCode", codeAdd ); template.Set( "createCode", codeCreate ); template.Set( "editCode", codeEdit ); template.Set( "updateCode", codeUpdate ); template.Set( "deleteCode", codeDel ); wojilu.IO.File.Write( Path.Combine( this.controllerPath, string.Format( "{0}Controller.cs", ei.Name ) ), template.ToString() ); }
private void addColumns( EntityInfo entity, StringBuilder sb ) { for (int i = 0; i < entity.SavedPropertyList.Count; i++) { EntityPropertyInfo ep = entity.SavedPropertyList[i]; String columnName = getFullName( ep.ColumnName, entity ); if ((ep.SaveToDB && !ep.IsList) && !(ep.Name == "Id")) { addColumnSingle( entity, sb, ep, columnName ); } } }
protected virtual void addColumn_ByColumnAttribute( EntityInfo entity, StringBuilder sb, EntityPropertyInfo ep, String columnName ) { if (ep.SaveAttribute.Length < 255) { addColumn_ShortText( sb, columnName, ep.SaveAttribute.Length ); } else if ((ep.SaveAttribute.Length > 255) && (ep.SaveAttribute.Length < 4000)) { addColumn_MiddleText( entity, sb, ep, columnName ); } else { addColumn_LongText( entity, sb, columnName ); } }
protected override void addColumn_Decimal( EntityInfo entity, StringBuilder sb, EntityPropertyInfo ep, String columnName ) { if (ep.MoneyAttribute != null) { sb.Append( columnName ); sb.Append( " currency default 0, " ); } else { DecimalAttribute da = ep.DecimalAttribute; if (da == null) throw new Exception( "DecimalAttribute not found=" + entity.FullName + "_" + ep.Name ); sb.Append( columnName ); sb.Append( " decimal(" + da.Precision + "," + da.Scale + ") default 0, " ); } }
private static Boolean isContinue( String action, EntityPropertyInfo info, EntityInfo entityInfo ) { if (info.SaveToDB == false) return true; if (info.IsList) return true; if (info.Name.Equals( "Id" )) { if (action.Equals( "update" )) return true; if (action.Equals( "insert" ) && entityInfo.Parent == null) return true; } return false; }
private static int getCount( String action, IEntity target, EntityInfo entityInfo, EntityPropertyInfo info, Object obj ) { if (obj == null) return 1; String usql; IDatabaseDialect dialect = entityInfo.Dialect; if (action.Equals( "update" )) { usql = String.Format( "select count(Id) from {0} where Id<>{3} and {1}={2}", entityInfo.TableName, info.ColumnName, dialect.GetParameter( info.Name ), target.Id ); } else { usql = String.Format( "select count(Id) from {0} where {1}={2}", entityInfo.TableName, info.ColumnName, dialect.GetParameter( info.Name ) ); } logger.Info( LoggerUtil.SqlPrefix + " validate unique sql : " + usql ); IDbCommand cmd = DataFactory.GetCommand( usql, DbContext.getConnection( entityInfo ) ); DataFactory.SetParameter( cmd, info.ColumnName, obj ); return cvt.ToInt( cmd.ExecuteScalar() ); }
private static Boolean isContinue( String action, EntityPropertyInfo info, EntityInfo entityInfo ) { if (info.SaveToDB == false) return true; if (info.IsList) return true; if (info.Name.Equals( "Id" )) { if (action.Equals( "update" )) return true; // ����ʵ�������ʶ�� if (/**/DbConfig.Instance.IsAutoId && action.Equals("insert") && entityInfo.Parent == null ) return true; } return false; }
public static void CheckCountCache( String action, IEntity obj, EntityInfo entityInfo ) { for (int i = 0; i < entityInfo.SavedPropertyList.Count; i++) { IEntity container = null; String propertyName = null; EntityPropertyInfo info = entityInfo.SavedPropertyList[i]; if ((info.Name != "Id") && !(info.Name == "OID")) { ICacheAttribute attribute = ReflectionUtil.GetAttribute( info.Property, typeof( CacheCountAttribute ) ) as ICacheAttribute; if (attribute != null) { container = ReflectionUtil.GetPropertyValue( obj, info.Name ) as IEntity; propertyName = attribute.TargetPropertyName.Replace( " ", "" ); } if (container != null) { String columnName = Entity.GetInfo( container ).GetColumnName( propertyName ); setCountCacheBySql( container, columnName, action ); } } } }
private List<String> createTable( EntityInfo entity, IDbCommand cmd, List<String> existTables, Dictionary<String, EntityInfo> clsList ) { StringBuilder sb = new StringBuilder(); sb.AppendFormat( "Create Table {0} (", getFullName( entity.TableName, entity ) ); addColumn_PrimaryKey( entity, sb, clsList ); addColumns( entity, sb ); String str = sb.ToString().Trim().TrimEnd( new char[] { ',' } ) + " )"; cmd.CommandText = str; logger.Info( "create table:" + str ); if (cmd.Connection == null) throw new Exception( "connection is null" ); if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.ExecuteNonQuery(); existTables.Add( entity.TableName ); logger.Info( LoggerUtil.SqlPrefix + String.Format( "create table {0} ({1})", entity.TableName, entity.FullName ) ); return existTables; }
public Includer( EntityInfo _entityInfo ) { _selectedProperty = "*"; entityInfo = _entityInfo; }
private static void checkCustomMapping( EntityInfo info ) { Dictionary<String, MappingInfo> map = DbConfig.Instance.GetMappingInfo(); if (map.ContainsKey( info.Type.FullName )) { MappingInfo mi = map[info.Type.FullName]; if (strUtil.HasText( mi.table )) info.TableName = mi.table; if (strUtil.HasText( mi.database )) info.Database = mi.database; } }
/// <summary> /// 根据类型Type,初始化EntityInfo;注意:因为不是从缓存中取,所以速度较慢 /// </summary> /// <param name="t"></param> /// <returns></returns> internal static EntityInfo GetByType( Type t ) { EntityInfo info = new EntityInfo(); info.Type = t; info.Name = t.Name; info.FullName = t.FullName; info.TableName = addPrefixToTableName( GetTableName( t ) ); info.Database = getDatabase( t ); checkCustomMapping( info ); info.Label = getTypeLabel( t ); IList propertyList = ReflectionUtil.GetPropertyList( t ); for (int i = 0; i < propertyList.Count; i++) { PropertyInfo property = propertyList[i] as PropertyInfo; EntityPropertyInfo ep = EntityPropertyInfo.Get( property ); ep.ParentEntityInfo = info; if (!(!ep.SaveToDB || ep.IsList)) { info.SavedPropertyList.Add( ep ); } info.PropertyListAll.Add( ep ); } if (info.SavedPropertyList.Count == 1) { throw new Exception( "class's properties have not been setted '[save]' attribute." ); } return info; }
protected virtual void addColumn_Double( EntityInfo entity, StringBuilder sb, string columnName ) { sb.Append( columnName ); sb.Append( " float default 0, " ); }
private Boolean isTableCreated( IList existTables, EntityInfo entity ) { for (int i = 0; i < existTables.Count; i++) { if (string.Compare( existTables[i].ToString(), entity.TableName.Replace( "[", "" ).Replace( "]", "" ), true ) == 0) { logger.Info( "table map : " + entity.FullName + " => " + existTables[i] ); return true; } } return false; }
//------------------------------------------------------------------------------------------------------------------------ private String getFullName( String name, EntityInfo entity ) { if (DbConst.SqlKeyWords.Contains( name.ToLower() )) { String message = String.Format( "'{0}' is reserved word. Entity:{1}, Table:{2}", name, entity.FullName, entity.TableName ); logger.Info( message ); throw new Exception( message ); } return name; }
protected virtual void addColumn_String( EntityInfo entity, StringBuilder sb, EntityPropertyInfo ep, String columnName ) { if (ep.LongTextAttribute != null) { addColumn_LongText( entity, sb, columnName ); } else if (ep.SaveAttribute != null) { addColumn_ByColumnAttribute( entity, sb, ep, columnName ); } else { addColumn_ShortText( sb, columnName, 250 ); } }
protected virtual void addColumn_MiddleText( EntityInfo entity, StringBuilder sb, EntityPropertyInfo ep, String columnName ) { addColumn_ShortText( sb, columnName, ep.SaveAttribute.Length ); }
protected virtual void addColumn_LongText( EntityInfo entity, StringBuilder sb, String columnName ) { sb.Append( columnName ); sb.Append( " ntext, " ); }
public SqlBuilder(EntityInfo entityInfo) { _entityInfo = entityInfo; _propertyList = _entityInfo.SavedPropertyList; }
protected override void addColumn_LongText( EntityInfo entity, StringBuilder sb, String columnName ) { sb.Append( columnName ); sb.Append( " text, " ); }
//1029 private static Boolean updateParentInfo( EntityInfo info ) { if (info.Type.BaseType == typeof( Object )) return false; if (OrmHelper.IsEntityBase( info.Type.BaseType )) return false; if (info.Type.BaseType.IsAbstract) return false; return true; }
public Includer( Type t ) { _selectedProperty = "*"; entityInfo = Entity.GetInfo( t ); }
internal static void SetParameters(IDbCommand cmd, String action, IEntity obj, EntityInfo entityInfo) { for (int i = 0; i < entityInfo.SavedPropertyList.Count; i++) { EntityPropertyInfo info = entityInfo.SavedPropertyList[i]; if (isContinue(action, info, entityInfo)) { continue; } Object paramVal = obj.get(info.Name); if (paramVal == null && info.DefaultAttribute != null) { paramVal = info.DefaultAttribute.Value; } if (paramVal == null) { setDefaultValue(cmd, info, entityInfo); } else if (info.Type.IsSubclassOf(typeof(IEntity)) || MappingClass.Instance.ClassList.ContainsKey(info.Type.FullName)) { setEntityId(cmd, info, paramVal); } else { paramVal = DataFactory.SetParameter(cmd, info.ColumnName, paramVal); obj.set(info.Name, paramVal); } } }
private string getDataSummary( IAppData obj, EntityInfo ei ) { IEntity data = obj as IEntity; if (data == null) return ""; String summary = getPropertyValue( data, ei, "Summary" ); if (strUtil.HasText( summary )) return summary; return strUtil.ParseHtml( getPropertyValue( data, ei, "Content" ), 150 ); }
protected override void addColumn_PrimaryKey( EntityInfo entity, StringBuilder sb, Dictionary<String, EntityInfo> clsList ) { sb.Append( " Id int unsigned not null auto_increment primary key, " ); }
private string getPropertyValue( IEntity data, EntityInfo ei, String propertyName ) { if (ei.GetProperty( propertyName ) == null) return ""; Object summary = data.get( propertyName ); return summary == null ? "" : summary.ToString(); }
protected override void addColumn_Single( EntityInfo entity, StringBuilder sb, string columnName ) { sb.Append( columnName ); sb.Append( " float default 0, " ); }
public SqlBuilder(Type type) { _entityInfo = Entity.GetInfo(type); _propertyList = _entityInfo.SavedPropertyList; }