/// <summary>
/// 获取列类型和默认值
/// </summary>
/// <param name="info"></param>
/// <param name="defaultValue"></param>
/// <returns></returns>
public override string GetColumnType(Attribute.FieldInnerAttribute info, out string defaultValue)
{
Type propertyType = info.PropertyType;
//Dictionary<Type, string> dic = GetFieldMaping();
defaultValue = info.DefaultValue;
//int默认值
if (string.IsNullOrEmpty(defaultValue))
{
if (!info.IsPrimaryKey && propertyType == typeof(System.Int32))
{
defaultValue = "0";
}
//datetime默认值
if (propertyType == typeof(System.DateTime))
{
defaultValue = "TIMESTAMP";
}
}
string columnType;
columnType = GetDBColumnType(propertyType);
//超过3000设为ntext
if (propertyType == typeof(System.String) && info.Length > 3000)
{
columnType = "CLOB";
}
if (info.Length > 0)
{
columnType = string.Format(columnType, info.Length);
}
//if (info.IsPrimaryKey)
//{
// columnType = "NUMBER(4) Not Null Primary Key";
//}
if (info.IsPrimaryKey)
{
columnType = " " + columnType + " Primary Key ";
}
if (!string.IsNullOrEmpty(info.ColumnType))
{
columnType = info.ColumnType;
}
return(columnType);
}
/// <summary>
/// 解析选择的字段
/// </summary>
/// <param name="isSelect">查询字段时按属性名生成别名</param>
/// <param name="expressionBody"></param>
/// <param name="withTablePrefix">是否生按表生成前辍,关联时用 如Table__Name</param>
/// <param name="types"></param>
/// <returns></returns>
public SelectFieldInfo GetSelectField(bool isSelect, Expression expressionBody, bool withTablePrefix, params Type[] types)
{
var allFields = new Dictionary <Type, IgnoreCaseDictionary <Attribute.FieldInnerAttribute> >();
allFields.Add(__MainType, TypeCache.GetProperties(__MainType, true));
foreach (var t in types)
{
if (!allFields.ContainsKey(t))
{
allFields.Add(t, TypeCache.GetProperties(t, true));
}
}
if (expressionBody is ParameterExpression)//选择所有字段
{
var resultFields = new List <Attribute.FieldMapping>();
foreach (var item in allFields[expressionBody.Type].Values)
{
var item2 = item.GetFieldMapping(__DBAdapter, GetPrefix(item.ModelType), false, "");
resultFields.Add(item2);
}
var selectFieldItem = new SelectFieldInfo(resultFields);
return(selectFieldItem);
}
else if (expressionBody is MemberInitExpression)
{
var memberInitExp = (expressionBody as MemberInitExpression);
var members = new List <MemberBindingObj>();
foreach (MemberAssignment m in memberInitExp.Bindings)
{
members.Add(new MemberBindingObj()
{
Expression = m.Expression, Member = m.Member
});
}
return(GetNewExpressionMember(isSelect, allFields, withTablePrefix, members));
}
else if (expressionBody is NewExpression)//按匿名对象
{
var newExpression = expressionBody as NewExpression;
var members = new List <MemberBindingObj>();
for (int i = 0; i < newExpression.Arguments.Count(); i++)
{
var item = newExpression.Arguments[i];
members.Add(new MemberBindingObj()
{
Expression = item, Member = newExpression.Members[i]
});
}
return(GetNewExpressionMember(isSelect, allFields, withTablePrefix, members));
}
else if (expressionBody is MethodCallExpression)
{
#region 方法
var method = expressionBody as MethodCallExpression;
var f = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, MemberName = "", PropertyType = expressionBody.Type
};
string methodMember;
var methodQuery = getSelectMethodCall(expressionBody, out methodMember, 0);
var f2 = f.GetFieldMapping(__DBAdapter, "", withTablePrefix, "", methodQuery);
f2.MethodName = method.Method.Name;
#endregion
var selectFieldItem = new SelectFieldInfo(f2);
return(selectFieldItem);
}
else if (expressionBody is BinaryExpression)
{
var field = getSeletctBinary(expressionBody);
var f = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, MemberName = "", PropertyType = expressionBody.Type
};
var f2 = f.GetFieldMapping(__DBAdapter, "", withTablePrefix, "", field);
var selectFieldItem = new SelectFieldInfo(f2);
return(selectFieldItem);
}
else if (expressionBody is ConstantExpression)
{
var constant = (ConstantExpression)expressionBody;
var f = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, MemberName = "", PropertyType = expressionBody.Type
};
var f2 = f.GetFieldMapping(__DBAdapter, "", withTablePrefix, "", constant.Value + "");
var selectFieldItem = new SelectFieldInfo(f2);
return(selectFieldItem);
}
else if (expressionBody is UnaryExpression)
{
var unaryExpression = expressionBody as UnaryExpression;
return(GetSelectField(false, unaryExpression.Operand, withTablePrefix, types));
}
else if (expressionBody is MemberExpression)//按成员
{
#region MemberExpression
var mExp = (MemberExpression)expressionBody;
if (mExp.Expression.Type.BaseType == typeof(object))
{
//按匿名对象属性,视图关联时用
var _f = new Attribute.FieldInnerAttribute()
{
MemberName = mExp.Member.Name, PropertyType = mExp.Type
};
var f3 = _f.GetFieldMapping(__DBAdapter, GetPrefix(mExp.Expression.Type, true), withTablePrefix, mExp.Member.Name);
return(new SelectFieldInfo(f3));
}
CRL.Attribute.FieldInnerAttribute f;
var a = allFields[mExp.Expression.Type].TryGetValue(mExp.Member.Name, out f);
if (!a)
{
throw new CRLException("找不到可筛选的属性" + mExp.Member.Name + " 在" + mExp.Expression.Type);
}
var f2 = f.GetFieldMapping(__DBAdapter, GetPrefix(f.ModelType), withTablePrefix, "");
return(new SelectFieldInfo(f2));
#endregion
}
else
{
throw new CRLException("不支持此语法解析:" + expressionBody);
}
}
SelectFieldInfo GetNewExpressionMember(bool isSelect, Dictionary <Type, IgnoreCaseDictionary <Attribute.FieldInnerAttribute> > allFields, bool withTablePrefix, List <MemberBindingObj> members)
{
var resultFields = new List <Attribute.FieldMapping>();
var i = -1;
foreach (var args in members)
{
i += 1;
var item = args.Expression;
var memberName = args.Member.Name;
label1:
if (item is MethodCallExpression)//group用
{
var methodCallExpression = item as MethodCallExpression;
string methodMember;
var methodQuery = getSelectMethodCall(methodCallExpression, out methodMember, i);
var f = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, MemberName = memberName, PropertyType = item.Type
};
var f2 = f.GetFieldMapping(__DBAdapter, "", withTablePrefix, memberName, methodQuery);
f2.MethodName = methodCallExpression.Method.Name;
resultFields.Add(f2);
}
else if (item is BinaryExpression)
{
var field = getSeletctBinary(item);
var f = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, MemberName = "", PropertyType = item.Type
};
var f2 = f.GetFieldMapping(__DBAdapter, "", withTablePrefix, memberName, field);
resultFields.Add(f2);
}
else if (item is ConstantExpression)//常量
{
var constantExpression = item as ConstantExpression;
var f = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, MemberName = "", PropertyType = item.Type
};
var value = constantExpression.Value + "";
if (!StringHelper.IsDouble(value))
{
value = string.Format("'{0}'", value);
}
var f2 = f.GetFieldMapping(__DBAdapter, "", withTablePrefix, memberName, value);
//f.FieldQuery = new Attribute.FieldQuery() { MemberName = memberName, FieldName = value, MethodName = "" };
resultFields.Add(f2);
}
else if (item is MemberExpression)
{
var memberExpression = item as MemberExpression;//转换为属性访问表达式
if (memberExpression.Expression.NodeType == ExpressionType.Constant)
{
string parName = __DBAdapter.GetParamName("p", i);
//newExpressionParame.Add(parName, i);
var obj = ConstantValueVisitor.GetParameExpressionValue(item);
var f2 = new Attribute.FieldInnerAttribute()
{
ModelType = __MainType, PropertyType = item.Type
};
var f3 = f2.GetFieldMapping(__DBAdapter, "", withTablePrefix, memberName, parName);
//f2.FieldQuery = new Attribute.FieldQuery() { MemberName = memberName, FieldName = parName, MethodName = "" };
resultFields.Add(f3);
__Visitor.AddParame(parName, obj);
continue;
}
else if (memberExpression.Member.ReflectedType.Name.StartsWith("<>f__AnonymousType"))
{
//按匿名对象属性,视图关联时用
var f2 = new Attribute.FieldInnerAttribute()
{
MemberName = memberExpression.Member.Name, PropertyType = item.Type
};
var f3 = f2.GetFieldMapping(__DBAdapter, GetPrefix(memberExpression.Expression.Type), withTablePrefix, memberName);
resultFields.Add(f3);
continue;
}
//按属性
Attribute.FieldInnerAttribute f;
var a2 = allFields[memberExpression.Expression.Type].TryGetValue(memberExpression.Member.Name, out f);
if (!a2)
{
throw new CRLException("找不到可筛选的属性" + memberExpression.Member.Name + " 在" + memberExpression.Expression.Type);
}
Attribute.FieldMapping _f2;
if (memberName != memberExpression.Member.Name)//按有别名算
{
_f2 = f.GetFieldMapping(__DBAdapter, GetPrefix(f.ModelType), withTablePrefix, memberName);
}
else
{
//字段名和属性名不一样时才生成别名
//todo 属性别名不一样时,查询应返回属性名
string fieldName = "";
if (isSelect)//查询字段时按属性名生成别名
{
if (!string.IsNullOrEmpty(f.MapingName))
{
fieldName = f.MemberName;
}
}
_f2 = f.GetFieldMapping(__DBAdapter, GetPrefix(f.ModelType), withTablePrefix, fieldName);
}
//f.FieldQuery = new Attribute.FieldQuery() { MemberName = memberName, FieldName = f.MapingName, MethodName = "" };
resultFields.Add(_f2);
}
else if (item is UnaryExpression)
{
var unaryExpression = item as UnaryExpression;
item = unaryExpression.Operand;
goto label1;
}
else
{
throw new CRLException("不支持此语法解析:" + item);
}
}
var selectFieldItem = new SelectFieldInfo(resultFields);
return(selectFieldItem);
}
public override string GetCreateColumnScript(Attribute.FieldInnerAttribute field)
{
throw new NotImplementedException();
}
public override string GetColumnIndexScript(Attribute.FieldInnerAttribute filed)
{
throw new NotImplementedException();
}
public override string GetColumnType(Attribute.FieldInnerAttribute info, out string defaultValue)
{
defaultValue = "";
return(info.PropertyType.Name);
}
