/// <summary>
/// 使用Natasha根据参数数组信息生成Command高速构建缓存
/// </summary>
/// <typeparam name="T">实际执行函数返回的类型</typeparam>
/// <param name="sql">SQL语句</param>
/// <param name="values">object参数数组</param>
/// <returns>动态方法</returns>
private static SqlDelegate <T> .GetCommandByObject GetEmitCommandCache <T>(string sql, object[] values)
{
Type returnType = typeof(T);
if (!Cache.SqlCache.ContainsKey(returnType))
{
ModelAnalyser.Initialization(returnType);
}
Delegate newMethod = EHandler.CreateMethod <ERef <IDbCommand>, object[], ENull>((il) =>
{
EModel idbCommand = EModel.CreateModelFromParameter <IDbCommand>(0);
idbCommand.UseRef();
idbCommand.Set("CommandText", sql);
EArray arrayArg = EArray.CreateArrayFromParameter(1, typeof(object));
EModel copyParameters = idbCommand.Load("Parameters");
MatchCollection collection = ParameterRegex.Matches(sql);
int length = collection.Count;
for (int i = 0; i < length; i += 1)
{
Type type = values[i].GetType();
string memberName = collection[i].Groups[1].Value;
copyParameters.Dup();
EModel copyParameter = EMethod.Load(idbCommand).ExecuteMethod("CreateParameter").Dup();
copyParameter.Set("ParameterName", "@".Append(memberName));
copyParameter.Dup().Set("DbType", (int)SqlTypes[type]);
if (type.IsPrimitive)
{
copyParameter.Dup().Set("Value", () => { arrayArg.LoadArray(i); });
}
else
{
EJudge.If(ENull.IsNull(() => { arrayArg.LoadArray(i); }))(() =>
{
copyParameter.Dup().Set("Value", EDBNull.LoadValue);
}).Else(() =>
{
copyParameter.Dup().Set("Value", () => { arrayArg.LoadArray(i); });
});
}
EMethod.Load <IList>().ExecuteMethod <object>("Add").Pop();
}
copyParameters.Pop();
}).Compile(typeof(SqlDelegate <T> .GetCommandByObject));
return((SqlDelegate <T> .GetCommandByObject)newMethod);
}
/// <summary>
/// 使用Natasha根据实例信息生成Command高速构建缓存，由参数类型以及SQL字符串决定缓存存储
/// </summary>
/// <typeparam name="T">Command缓存方法中需要传入实例类型</typeparam>
/// <param name="sql">SQL语句</param>
/// <param name="value">实例</param>
/// <returns>动态方法</returns>
private static SqlDelegate <T> .GetGenericCommand GetEmitCommandGenericCache <T>(string sql, T value)
{
Type returnType = typeof(T);
if (!Cache.SqlCache.ContainsKey(returnType))
{
ModelAnalyser.Initialization(returnType);
}
Delegate newMethod = EHandler.CreateMethod <ERef <IDbCommand>, T, ENull>((il) =>
{
EModel idbCommand = EModel.CreateModelFromParameter <IDbCommand>(0);
idbCommand.UseRef();
idbCommand.Set("CommandText", sql);
MatchCollection collection = ParameterRegex.Matches(sql);
int i_length = collection.Count;
if (i_length > 0)
{
Type type = value.GetType();
EModel valueDate = EModel.CreateModelFromParameter <T>(1);
if (!Cache.SqlCache.ContainsKey(type))
{
ModelAnalyser.Initialization(type);
}
EModel copyParameters = idbCommand.Load("Parameters");
IDictionary <string, Type> typeCache = Cache.StructionCache[type].ModelTypeCache;
for (int i = 0; i < i_length; i += 1)
{
string memberName = collection[i].Groups[1].Value;
Type tempType = typeCache[memberName];
copyParameters.Dup(); //+ Stack:[IDbCommand.Parameters] [IDbCommand.Parameters]
EModel copyParameter = EMethod.Load(idbCommand).ExecuteMethod("CreateParameter").Dup(); //+ Stack:[IDbCommand.Parameters] [IDbCommand.Parameters] [IDbParameter] [IDbParameter]
copyParameter.Set("ParameterName", "@".Append(memberName)); //+ Stack:[IDbCommand.Parameters] [IDbCommand.Parameters] [IDbParameter] Deal:([IDbParameter].ParameterName=@XXX)
copyParameter.Dup().Set("DbType", (int)SqlTypes[tempType]); //+ Stack:[IDbCommand.Parameters] [IDbCommand.Parameters] [IDbParameter] Deal:([IDbParameter].DbType=XXX)
copyParameter.Dup().Set("Value", () =>
{
if (il.IsNullable(tempType))
{
EJudge.If(valueDate.DLoad(memberName).DLoadValue("HasValue").DelayAction)(() =>
{
valueDate.Load(memberName).LoadValue("Value").Packet();
}).Else(() =>
{
EDBNull.LoadValue();
});
}
else if (tempType.IsValueType)
{
valueDate.Load(memberName).Packet();
}
else
{
EJudge.If(ENull.IsNull(valueDate.DLoad(memberName).DelayAction))(() =>
{
EDBNull.LoadValue();
}).Else(() =>
{
valueDate.Load(memberName).Packet();
});
}
}); //+ Stack:[IDbCommand.Parameters] [IDbCommand.Parameters] [IDbParameter] Deal:([IDbParameter].Value=XXX)
EMethod.Load <IList>().ExecuteMethod <object>("Add").Pop(); //+ Stack:[IDbCommand.Parameters] Deal:Add([IDbCommand.Parameters] [IDbParameter])
}
copyParameters.Pop();
}
}).Compile(typeof(SqlDelegate <T> .GetGenericCommand));
return((SqlDelegate <T> .GetGenericCommand)newMethod);
}
