public static Type BuildDynamicObjectType(Relation relation)
{
Type baseType = null;
if (!_cache.ContainsKey(relation.Identification))
{
IDbConnection connection = DblHelper.CreateConnection();
Dictionary <string, Type> properties = GetProprties(relation.Name);
if (relation.Items != null)
{
foreach (Relation item in relation.Items)
{
Dictionary <string, Type> subProperties = GetProprties(item.Name);;
Type subType = TypeCreator.Creator(item.Name, subProperties);
Type genericType = typeof(List <>);
properties[item.Name] = genericType.MakeGenericType(subType);
}
}
baseType = TypeCreator.Creator(relation.Name + "Proxy", properties);
_cache[relation.Identification] = baseType;
}
else
{
baseType = _cache[relation.Identification];
}
return(baseType);
}
private static Dictionary <string, Type> GetProprties(string identity)
{
IDbConnection connection = DblHelper.CreateConnection();
string fieldSQL = string.Format(" SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='{0}' ", identity);
List <FieldInfo> fields = connection.Query <FieldInfo>(fieldSQL).ToList();
Dictionary <string, Type> properties = new Dictionary <string, Type>();
foreach (FieldInfo field in fields)
{
SqlDbType dbType = (SqlDbType)Enum.Parse(typeof(SqlDbType), field.DATA_TYPE, true);
properties.Add(field.COLUMN_NAME, DbTypeCsharpType(dbType));
}
return(properties);
}
public static object GetInstance(string instanceID, Relation relation)
{
IDbConnection connection = DblHelper.CreateConnection();
string sql = string.Format(" select * from {0} where instanceID='{0}'", relation.Name, instanceID);
Dictionary <string, Type> properties = GetProprties(relation.Name);
foreach (Relation item in relation.Items)
{
Dictionary <string, Type> subProperties = GetProprties(item.Name);
Type genericType = typeof(List <>);
if (!_cache.ContainsKey(item.Identification))
{
Type subType = TypeCreator.Creator(item.Name + "Proxy", subProperties);
properties[item.Name] = genericType.MakeGenericType(subType);
_cache[item.Identification] = subType;
}
else
{
properties[item.Name] = genericType.MakeGenericType(_cache[item.Identification]);
}
}
Type baseType = null;
if (!_cache.ContainsKey(relation.Identification))
{
baseType = TypeCreator.Creator(relation.Name + "Proxy", properties);
_cache[relation.Identification] = baseType;
}
else
{
baseType = _cache[relation.Identification];
}
Object dataObject = connection.Query(baseType, sql);
foreach (Relation item in relation.Items)
{
sql = string.Format(" select * from {0} where instanceID='{0}'", item.Name, instanceID);
dataObject.SetValue(item.Name, connection.Query(_cache[item.Name], sql));
}
return(dataObject);
}
private static string InsertCommand(string identity)
{
IDbConnection connection = DblHelper.CreateConnection();
string fieldSQL = string.Format(" SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='{0}' ", identity);
List <string> fields = connection.Query <string>(fieldSQL).ToList();
StringBuilder command = new StringBuilder();
command.Append(" INSERT INTO ")
.Append(identity)
.Append(" ( ")
.Append(string.Join(",", fields))
.Append(" ) ")
.Append(" VALUES ")
.Append(" ( ")
.Append("@" + string.Join(",@", fields))
.Append(" ) ");
return(command.ToString());
}
public static void Persistent(Object proxy, Relation relation)
{
IDbConnection connection = DblHelper.CreateConnection();
connection.Execute(InsertCommand(relation.Name), proxy);
if (relation.Items != null)
{
foreach (Relation item in relation.Items)
{
if (proxy.Value(item.Name) is System.Collections.IEnumerable)
{
var collection = proxy.Value(item.Name) as System.Collections.IEnumerable;
foreach (var subProxy in collection)
{
connection.Execute(InsertCommand(item.Name), subProxy);
}
}
}
}
}
