private static string GenCacheKey(SPClassContext context)
{
return(context.ClassName);
}
private static string CreatingFunBody(ParameterInfo[] allparam, Type returnType, string FuncName, string ProcedurName, SPClassContext Context)
{
StringBuilder FunB = new StringBuilder(256);
StringBuilder OutParamH = new StringBuilder();
FunB.Append("ExecutionContext Result=null;"); FunB.Append(Environment.NewLine);
FunB.Append("Dictionary<string, SpParameter> SpParam = null;"); FunB.Append(Environment.NewLine);
FunB.Append("ExecutionContext EContext=new ExecutionContext();"); FunB.Append(Environment.NewLine);
FunB.Append("EContext.SpName=\"" + ProcedurName + "\";");
if (allparam.Length == 1 && !BasicHelper.IsRemoveType(allparam[0].ParameterType))
{
FunB.Append("EContext.ParamDTO=" + allparam[0].Name + ";"); FunB.Append(Environment.NewLine);
}
else
{
FunB.Append("SpParam = new Dictionary<string, SpParameter>();");
foreach (var item in allparam)
{
//Handling out...
if (item.IsOut)
{
string OutPramatype = item.ParameterType.GetActualName();
FunB.Append(item.Name + " = default(" + OutPramatype + ");"); FunB.Append(Environment.NewLine);
OutParamH.Append(item.Name + "= (" + OutPramatype + ") EContext._params[\"" + item.Name + "\"].PValue;"); FunB.Append(Environment.NewLine);
}
string ParamVar = SpParameterVariable(item);
FunB.Append("SpParameter " + ParamVar + " = new SpParameter();"); FunB.Append(Environment.NewLine);
FunB.Append(ParamVar + ".PValue=" + item.Name + ";"); FunB.Append(Environment.NewLine);
FunB.Append(ParamVar + ".PropertyName=\"" + item.Name + "\";"); FunB.Append(Environment.NewLine);
FunB.Append(ParamVar + ".IsOutParam=bool.Parse(\"" + item.IsOut.ToString() + "\");");
FunB.Append("SpParam.Add(\"" + item.Name + "\"," + ParamVar + ");"); FunB.Append(Environment.NewLine);
}
FunB.Append("EContext._params=SpParam;");
}
FunB.Append("EContext.ReturnType=typeof(" + returnType.GetActualName() + ");"); FunB.Append(Environment.NewLine);
FunB.Append("EContext.ServerKey=\"" + Context.DBServerProductNameKey + "\";"); FunB.Append(Environment.NewLine);
FunB.Append("IRunSqlSp EObj=RunSpFactory.Create(\"" + Context.DBServerProductNameKey + "\");"); FunB.Append(Environment.NewLine);
FunB.Append("EObj.SetConnectionString(\"" + Context.ConnectionString + "\");"); FunB.Append(Environment.NewLine);
FunB.Append("Result = EObj.ExecuteSp(EContext);"); FunB.Append(Environment.NewLine);
FunB.Append(OutParamH);
FunB.Append("return (" + returnType.GetActualName() + ") Result.ReturnObject;"); FunB.Append(Environment.NewLine);
return(FunB.ToString());
}
