protected T AlbianObjectCreater <T>(PropertyInfo[] properties, IDataReader dr, Hashtable reader,
IDictionary <string, IMemberAttribute> members)
where T : class, IAlbianObject, new()
{
T target = AlbianObjectFactory.CreateInstance <T>();
foreach (PropertyInfo property in properties)
{
IMemberAttribute member = members[property.Name];
if (!member.IsSave)
{
if (property.Name == "IsNew") //define by interface)
{
property.SetValue(target, false, null); //load from databse
}
continue;
}
object value = dr.GetValue(int.Parse(reader[member.FieldName].ToString()));
if (null == value || DBNull.Value == value)
{
//property.SetValue(target, null, null);
continue;
}
property.SetValue(target, value, null);
}
return(target);
}
protected override IMemberAttribute ParserMember(string typeFullName, XmlNode memberNode)
{
if (string.IsNullOrEmpty(typeFullName))
{
throw new ArgumentNullException("typeFullName");
}
object target = MemberCache.Get(typeFullName);
if (null == target)
{
throw new Exception(string.Format("the member cache is null for {0} type.", typeFullName));
}
var members = (IDictionary <string, IMemberAttribute>)target;
object name;
XmlFileParser.TryGetAttributeValue(memberNode, "Name", out name);
if (null == name)
{
throw new Exception("there is no name in the member config item.");
}
IMemberAttribute member = members[name.ToString()];
member = members[member.Name] = GenerateMember(member, memberNode);
MemberCache.InsertOrUpdate(typeFullName, members);
return(member);
}
private static IMemberAttribute GenerateMember(IMemberAttribute member, XmlNode memberNode)
{
if (null == memberNode)
{
return(member);
}
object oFieldName;
object oAllowNull;
object oLength;
object oPrimaryKey;
object oDbType;
object oIsSave;
if (XmlFileParser.TryGetAttributeValue(memberNode, "FieldName", out oFieldName) && null != oFieldName)
{
member.FieldName = oFieldName.ToString().Trim();
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "AllowNull", out oAllowNull) && null != oAllowNull)
{
member.AllowNull = bool.Parse(oAllowNull.ToString().Trim());
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "Length", out oLength) && null != oLength)
{
member.Length = int.Parse(oLength.ToString().Trim());
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "PrimaryKey", out oPrimaryKey) && null != oPrimaryKey)
{
member.PrimaryKey = bool.Parse(oPrimaryKey.ToString().Trim());
if (member.PrimaryKey)
{
member.AllowNull = false;
}
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "DbType", out oDbType) && null != oDbType)
{
member.DBType = ConvertToDbType.Convert(oDbType.ToString());
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "IsSave", out oIsSave) && null != oIsSave)
{
member.IsSave = bool.Parse(oIsSave.ToString().Trim());
}
return(member);
}
public IDictionary <string, IMemberAttribute> ReflectMembers(string typeFullName, out string defaultTableName)
{
//string typeFullName = entity.Implement;
if (string.IsNullOrEmpty(typeFullName))
{
throw new ArgumentNullException("typeFullName");
}
Type type = Type.GetType(typeFullName, true);
defaultTableName = type.Name;
PropertyInfo[] propertyInfos =
type.GetProperties(BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic);
//the interface
Type itf = type.GetInterface("IAlbianObject"); //get the signature interface
PropertyInfo idInfo = itf.GetProperty("Id");
PropertyInfo isNewInfo = itf.GetProperty("IsNew");
if (null == propertyInfos || 0 == propertyInfos.Length)
{
throw new Exception(string.Format("Reflect the {0} property is error.", typeFullName));
}
IDictionary <string, IMemberAttribute> memberAttributes = new Dictionary <string, IMemberAttribute>();
foreach (PropertyInfo propertyInfo in propertyInfos)
{
IMemberAttribute memberAttribute = ReflectProperty(propertyInfo, idInfo, isNewInfo);
memberAttributes.Add(memberAttribute.Name, memberAttribute);
}
if (0 == memberAttributes.Count)
{
return(null);
}
PropertyCache.InsertOrUpdate(typeFullName, propertyInfos); //just only have property
MemberCache.InsertOrUpdate(typeFullName, memberAttributes); //parser object by member attributes
return(memberAttributes);
}
private static IMemberAttribute GenerateMember(IMemberAttribute member, XmlNode memberNode)
{
if (null == memberNode)
{
return member;
}
object oFieldName;
object oAllowNull;
object oLength;
object oPrimaryKey;
object oDbType;
object oIsSave;
if (XmlFileParser.TryGetAttributeValue(memberNode, "FieldName", out oFieldName) && null != oFieldName)
{
member.FieldName = oFieldName.ToString().Trim();
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "AllowNull", out oAllowNull) && null != oAllowNull)
{
member.AllowNull = bool.Parse(oAllowNull.ToString().Trim());
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "Length", out oLength) && null != oLength)
{
member.Length = int.Parse(oLength.ToString().Trim());
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "PrimaryKey", out oPrimaryKey) && null != oPrimaryKey)
{
member.PrimaryKey = bool.Parse(oPrimaryKey.ToString().Trim());
if (member.PrimaryKey) member.AllowNull = false;
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "DbType", out oDbType) && null != oDbType)
{
member.DBType = ConvertToDbType.Convert(oDbType.ToString());
}
if (XmlFileParser.TryGetAttributeValue(memberNode, "IsSave", out oIsSave) && null != oIsSave)
{
member.IsSave = bool.Parse(oIsSave.ToString().Trim());
}
return member;
}
public IFakeCommandAttribute BuildCreateFakeCommandByRouting <T>(PermissionMode permission, T target,
IRoutingAttribute routing,
IObjectAttribute objectAttribute,
PropertyInfo[] properties)
where T : IAlbianObject
{
if (null == routing)
{
throw new ArgumentNullException("routing");
}
if (null == properties || 0 == properties.Length)
{
throw new ArgumentNullException("properties");
}
if (null == objectAttribute)
{
throw new ArgumentNullException("objectAttribute");
}
if (0 == (permission & routing.Permission))
{
if (null != Logger)
{
Logger.WarnFormat("The routing permission {0} is no enough.", permission);
}
return(null);
}
//create the connection string
IStorageAttribute storageAttr = (IStorageAttribute)StorageCache.Get(routing.StorageName);
if (null == storageAttr)
{
if (null != Logger)
{
Logger.WarnFormat(
"No {0} rounting mapping storage attribute in the sotrage cache.Use default storage.",
routing.Name);
}
storageAttr = (IStorageAttribute)StorageCache.Get(StorageParser.DefaultStorageName);
}
if (!storageAttr.IsHealth)
{
if (null != Logger)
{
Logger.WarnFormat("Routing:{0},Storage:{1} is not health.", routing.Name, storageAttr.Name);
}
return(null);
}
var sbInsert = new StringBuilder();
var sbCols = new StringBuilder();
var sbValues = new StringBuilder();
IList <DbParameter> paras = new List <DbParameter>();
//create the hash table name
string tableFullName = Utils.GetTableFullName(routing, target);
//build the command text
IDictionary <string, IMemberAttribute> members = objectAttribute.MemberAttributes;
foreach (PropertyInfo property in properties)
{
object value = property.GetValue(target, null);
if (null == value)
{
continue;
}
IMemberAttribute member = members[property.Name];
if (!member.IsSave)
{
continue;
}
sbCols.AppendFormat("{0},", member.FieldName);
string paraName = DatabaseFactory.GetParameterName(storageAttr.DatabaseStyle, member.FieldName);
sbValues.AppendFormat("{0},", paraName);
paras.Add(DatabaseFactory.GetDbParameter(storageAttr.DatabaseStyle, paraName, member.DBType, value,
member.Length));
}
int colsLen = sbCols.Length;
if (0 < colsLen)
{
sbCols.Remove(colsLen - 1, 1);
}
int valLen = sbValues.Length;
if (0 < valLen)
{
sbValues.Remove(valLen - 1, 1);
}
sbInsert.AppendFormat("INSERT INTO {0} ({1}) VALUES({2}) ", tableFullName, sbCols, sbValues);
IFakeCommandAttribute fakeCmd = new FakeCommandAttribute
{
CommandText = sbInsert.ToString(),
Paras = ((List <DbParameter>)paras).ToArray(),
StorageName = routing.StorageName
};
return(fakeCmd);
}
public IFakeCommandAttribute GenerateQuery <T>(string rountingName, int top, IFilterCondition[] where,
IOrderByCondition[] orderby)
where T : class, IAlbianObject, new()
{
Type type = typeof(T);
string fullName = AssemblyManager.GetFullTypeName(type);
object oProperties = PropertyCache.Get(fullName);
PropertyInfo[] properties;
if (null == oProperties)
{
if (null != Logger)
{
Logger.Error("Get the object property info from cache is null.Reflection now and add to cache.");
}
throw new PersistenceException("object property is null in the cache.");
}
properties = (PropertyInfo[])oProperties;
object oAttribute = ObjectCache.Get(fullName);
if (null == oAttribute)
{
if (null != Logger)
{
Logger.ErrorFormat("The {0} object attribute is null in the object cache.", fullName);
}
throw new Exception("The object attribute is null");
}
StringBuilder sbSelect = new StringBuilder();
StringBuilder sbCols = new StringBuilder();
StringBuilder sbWhere = new StringBuilder();
StringBuilder sbOrderBy = new StringBuilder();
IObjectAttribute objectAttribute = (IObjectAttribute)oAttribute;
IRoutingAttribute routing;
if (!objectAttribute.RoutingAttributes.TryGetValue(rountingName, out routing))
{
if (null != Logger)
{
Logger.WarnFormat("There is not routing of the {} object.Albian use the default routing tempate.",
rountingName);
}
routing = objectAttribute.RountingTemplate;
}
if (0 == (PermissionMode.R & routing.Permission))
{
if (null != Logger)
{
Logger.WarnFormat("The routing permission {0} is no enough.", routing.Permission);
}
return(null);
}
IStorageAttribute storageAttr = (IStorageAttribute)StorageCache.Get(routing.StorageName);
if (null == storageAttr)
{
if (null != Logger)
{
Logger.WarnFormat(
"No {0} rounting mapping storage attribute in the sotrage cache.Use default storage.",
routing.Name);
}
storageAttr = (IStorageAttribute)StorageCache.Get(StorageParser.DefaultStorageName);
}
if (!storageAttr.IsHealth)
{
if (null != Logger)
{
Logger.WarnFormat("Routing:{0},Storage:{1} is not health.", routing.Name, storageAttr.Name);
}
return(null);
}
IDictionary <string, IMemberAttribute> members = objectAttribute.MemberAttributes;
T target = AlbianObjectFactory.CreateInstance <T>();
foreach (PropertyInfo property in properties)
{
IMemberAttribute member = members[property.Name];
if (!member.IsSave)
{
continue;
}
sbCols.AppendFormat("{0},", member.FieldName);
if (null != where)
{
foreach (IFilterCondition condition in where) //have better algorithm??
{
if (condition.PropertyName == property.Name)
{
property.SetValue(target, condition.Value, null); //Construct the splite object
break;
}
}
}
if (null != orderby)
{
foreach (IOrderByCondition order in orderby)
{
if (order.PropertyName == property.Name)
{
sbOrderBy.AppendFormat("{0} {1},", member.FieldName,
System.Enum.GetName(typeof(SortStyle), order.SortStyle));
break;
}
}
}
}
if (0 != sbOrderBy.Length)
{
sbOrderBy.Remove(sbOrderBy.Length - 1, 1);
}
if (0 != sbCols.Length)
{
sbCols.Remove(sbCols.Length - 1, 1);
}
IList <DbParameter> paras = new List <DbParameter>();
if (null != where && 0 != where.Length)
{
foreach (IFilterCondition condition in where)
{
IMemberAttribute member = members[condition.PropertyName];
if (!member.IsSave)
{
continue;
}
sbWhere.AppendFormat(" {0} {1} {2} {3} ", Utils.GetRelationalOperators(condition.Relational),
member.FieldName, Utils.GetLogicalOperation(condition.Logical),
DatabaseFactory.GetParameterName(storageAttr.DatabaseStyle, member.FieldName));
paras.Add(DatabaseFactory.GetDbParameter(storageAttr.DatabaseStyle, member.FieldName, member.DBType,
condition.Value, member.Length));
}
}
string tableFullName = Utils.GetTableFullName(routing, target);
switch (storageAttr.DatabaseStyle)
{
case DatabaseStyle.MySql:
{
sbSelect.AppendFormat("SELECT {0} FROM {1} WHERE 1=1 {2} {3} {4}",
sbCols, tableFullName, sbWhere,
0 == sbOrderBy.Length ? string.Empty : string.Format("ORDER BY {0}", sbOrderBy),
0 == top ? string.Empty : string.Format("LIMIT {0}", top)
);
break;
}
case DatabaseStyle.Oracle:
{
if (0 == top)
{
sbSelect.AppendFormat("SELECT {0} FROM {1} WHERE 1=1 {2} {3}",
sbCols, tableFullName, sbWhere,
0 == sbOrderBy.Length ? string.Empty : string.Format("ORDER BY {0}", sbOrderBy));
}
else
{
sbSelect.AppendFormat("SELECT A.* FROM (SELECT {0} FROM {1} WHERE 1=1 {2} {3})A WHERE ROWNUM <= {4}",
sbCols, tableFullName, sbWhere,
0 == sbOrderBy.Length ? string.Empty : string.Format("ORDER BY {0}", sbOrderBy),
top);
}
break;
}
case DatabaseStyle.SqlServer:
default:
{
sbSelect.AppendFormat("SELECT {0} {1} FROM {2} WHERE 1=1 {3} {4}",
0 == top ? string.Empty : string.Format("TOP {0}", top),
sbCols, tableFullName, sbWhere,
0 == sbOrderBy.Length ? string.Empty : string.Format("ORDER BY {0}", sbOrderBy));
break;
}
}
IFakeCommandAttribute fakeCommand = new FakeCommandAttribute
{
CommandText = sbSelect.ToString(),
Paras = ((List <DbParameter>)paras).ToArray(),
StorageName = storageAttr.Name,
};
return(fakeCommand);
}
