ModelUtil modelUtil; //model读写对象类
public Mapper(Type type)
{
//成员变量初始化
modelUtil = new ModelUtil(type);
relationModels = new Dictionary <string, RelationModel>();
List <RelationModel> relations = modelUtil.GetRelations();
foreach (var r in relations)
{
relationModels.Add(r.TbName, r);
}
columnMappings = new Dictionary <string, PropertyMappingInfo>();
foreach (var c in type.GetProperties())
{
columnMappings.Add(c.Name, modelUtil.GetPropertyMappingInfo(c.Name));
}
}
/// <summary>
/// 获取model所关联的所有关系模型
/// </summary>
/// <param name="flag">是否加载全部关系模型(此项为避免循环依赖造成的无限递归)</param>
/// <returns></returns>
public List <RelationModel> GetRelations(bool flag = true)
{
List <RelationModel> relations = new List <RelationModel>();
RelationModel mainRelation = new RelationModel(ModelType.Name);
relations.Add(mainRelation);
var propertys = ModelType.GetProperties();
foreach (var p in propertys)
{
RelationModelColumn r_column = null;
List <RelationModel> new_relations = null;
ModelUtil otherModel_util = null;
string dbType = null;
string typeSize = null;
string constraints = string.Empty;
foreach (var attr in GetPropertyDbAtttibutes(p.Name))
{
if (attr is ConstraintAttribute)
{
constraints += ((ConstraintAttribute)attr).GetConstraintStr() + " ";
}
}
var propertyMappingInfo = GetPropertyMappingInfo(p.Name);
switch (propertyMappingInfo.Property_TypeRole)
{
case PropertyMappingInfo.PropertyTypeRole.Value:
dbType = GetPropertyDbAttribute <TypeAttribute>(p.Name).DbTypeName;
typeSize = GetPropertyDbAttribute <TypeAttribute>(p.Name).Size;
r_column = new RelationModelColumn(p.Name, dbType, typeSize, constraints);
if (GetPropertyDbAttribute <IdentityAttribute>(p.Name) != null)
{
r_column.ReadOnly = true;
}
break;
case PropertyMappingInfo.PropertyTypeRole.Model:
otherModel_util = new ModelUtil(propertyMappingInfo.ReferenceModelType);
dbType = otherModel_util.GetPropertyDbAttribute <TypeAttribute>(otherModel_util.PrimaryKeyPropertyName).DbTypeName;
typeSize = otherModel_util.GetPropertyDbAttribute <TypeAttribute>(otherModel_util.PrimaryKeyPropertyName).Size;
r_column = new RelationModelColumn(p.Name, dbType, typeSize, "NOT NULL"); // 设置外键
new_relations = otherModel_util.GetRelations();
break;
case PropertyMappingInfo.PropertyTypeRole.ModelList_To_Obj:
otherModel_util = new ModelUtil(propertyMappingInfo.ReferenceModelType);
new_relations = otherModel_util.GetRelations();
dbType = GetPropertyDbAttribute <TypeAttribute>(PrimaryKeyPropertyName).DbTypeName;
typeSize = GetPropertyDbAttribute <TypeAttribute>(PrimaryKeyPropertyName).Size;
//被参照关系的主关系添加一列参照属性
new_relations[0].Columns.Add(new RelationModelColumn(PrimaryKeyPropertyName, dbType, typeSize, "NOT NULL"));
break;
case PropertyMappingInfo.PropertyTypeRole.ModelList_To_List:
if (flag == false)
{
break;
}
otherModel_util = new ModelUtil(propertyMappingInfo.ReferenceModelType);
//新建第三方参照relation
new_relations = new List <RelationModel>();
var _newRelation = new RelationModel(string.Format("{0}_{1}", ModelType.Name, otherModel_util.ModelType.Name));
//添加第一参照列
dbType = GetPropertyDbAttribute <TypeAttribute>(PrimaryKeyPropertyName).DbTypeName;
typeSize = GetPropertyDbAttribute <TypeAttribute>(PrimaryKeyPropertyName).Size;
_newRelation.Columns.Add(new RelationModelColumn(string.Format("{0}_{1}", ModelType.Name, PrimaryKeyPropertyName), dbType, typeSize, "NOT NULL"));
//添加第二参照列
dbType = GetPropertyDbAttribute <TypeAttribute>(otherModel_util.PrimaryKeyPropertyName).DbTypeName;
typeSize = GetPropertyDbAttribute <TypeAttribute>(otherModel_util.PrimaryKeyPropertyName).Size;
_newRelation.Columns.Add(new RelationModelColumn(string.Format("{0}_{1}", otherModel_util.ModelType.Name, otherModel_util.PrimaryKeyPropertyName), dbType, typeSize, "NOT NULL"));
//添加第三参照关系
new_relations.Add(_newRelation);
new_relations.AddRange(otherModel_util.GetRelations(false));
break;
}
if (r_column != null)
{
mainRelation.Columns.Add(r_column);
r_column = null;
}
if (new_relations != null)
{
relations.AddRange(new_relations);
}
new_relations = null; // 清空新建关系
}
return(relations);
}
/// <summary>
/// 获取属性映射信息
/// </summary>
/// <param name="propertyName">属性名</param>
/// <returns></returns>
public PropertyMappingInfo GetPropertyMappingInfo(string propertyName)
{
PropertyMappingInfo info = new PropertyMappingInfo();
info.DbColumnName = propertyName;
var property = ModelType.GetProperty(propertyName);
Type propertyType = property.PropertyType;
string propertyDbTypeName = GetPropertyDbAttribute <TypeAttribute>(property.Name).DbTypeName;
if (propertyDbTypeName == DbTypeMapping.List_UserType.TypeName)
{
//如果是集合,则验证是多对一，还是多对多关系。
var argTypes = propertyType.GetGenericArguments();//获取集合中的元素的数据类型
if (argTypes.Length == 1)
{
//若是合法集合，验证是多对一，还是多对多关系。
var referenceModelType = argTypes[0];
info.ReferenceModelType = referenceModelType;
//验证目标model是否包含关于自身的泛型集合，以确定是多对一还是多对多
bool isContainListOfSelf = false;
foreach (var p in referenceModelType.GetProperties())
{
if (p.PropertyType.GetInterface("IEnumerable`1") != null)
{
var other_argTypes = p.PropertyType.GetGenericArguments();
if (other_argTypes.Length == 1 && other_argTypes[0].Equals(ModelType))
{
isContainListOfSelf = true;
break;
}
}
}
if (!isContainListOfSelf)
{
//多对一关系，验证自身是否包含主键属性
if (PrimaryKeyPropertyName != null)
{
info.Property_TypeRole = PropertyMappingInfo.PropertyTypeRole.ModelList_To_Obj;
}
else
{
//否则抛出异常
}
}
else
{
//多对多关系，验证双方是否包含主键属性
string other_primaryKeyName = new ModelUtil(info.ReferenceModelType).PrimaryKeyPropertyName;
if (PrimaryKeyPropertyName != null && other_primaryKeyName != null)
{
info.Property_TypeRole = PropertyMappingInfo.PropertyTypeRole.ModelList_To_List;
}
else
{
//否则抛出异常
}
}
}
else
{
//不接受多类型泛型集合，抛出异常
}
}
else if (propertyDbTypeName == DbTypeMapping.UserType.TypeName)
{
//否则是单引用关系
//若是单引用关系,则目标关系必须包含主键(外键)
string other_primaryKeyName = new ModelUtil(propertyType).PrimaryKeyPropertyName;
if (other_primaryKeyName != null) // 验证外键
{
info.Property_TypeRole = PropertyMappingInfo.PropertyTypeRole.Model;
info.ReferenceModelType = propertyType;
}
else
{
//否则抛出异常
}
}
else
{
info.Property_TypeRole = PropertyMappingInfo.PropertyTypeRole.Value;
}
return(info);
}