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 );
     }
 }

        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;
        }

        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 (/**/DbConfig.Instance.IsAutoId && 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() );
        }

 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;
        }

        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();
        }

        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;

            }
        }

 protected virtual void addColumn_Double( EntityInfo entity, StringBuilder sb, string columnName )
 {
     sb.Append( columnName );
     sb.Append( " float default 0, " );
 }

        /// <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;
        }

 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;
 }

 public SqlBuilder(EntityInfo entityInfo)
 {
     _entityInfo = entityInfo;
     _propertyList = _entityInfo.SavedPropertyList;
 }

 //------------------------------------------------------------------------------------------------------------------------
 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;
 }