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);
}
}
}
public SqlBuilder(EntityInfo entityInfo)
{
_entityInfo = entityInfo;
_propertyList = _entityInfo.SavedPropertyList;
}
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;
}
