/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="par"></param>
/// <param name="splits"></param>
/// <returns></returns>
public static string CmdInFromListForSimplePar <T>(SimpleProcedureParameter ps, List <T> splits, string inparam)
{
int index = 0;
StringBuilder sb = new StringBuilder();
foreach (var s in splits)
{
string param = string.Format("@{0}{1}", inparam, index);
sb.AppendFormat(param + ",");
ps.Add(param, s);
index++;
}
return(sb.ToString().Trim(','));
}
/// <summary>
/// sql访问拦截器
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="action"></param>
/// <returns></returns>
public static T Visit <T>(Func <SimpleProcedureParameter, T> action)
{
try
{
var dicparams = new SimpleProcedureParameter();
var r = action.Invoke(dicparams);
return(r);
}
catch (Exception exp)
{
//ErrorLog.Write("dal层sql调用出错:", exp);
throw exp;
}
}
