/// <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; } }