/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <returns></returns> public static int NonQueryUseModel(this ILuaSqlConfigExecutor configExecutor, object paramsModel, params string[] ignoreProptsForParamModel) { return(configExecutor.NonQueryUseDict( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel))); }
/// <summary> /// SqlScalar /// </summary> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static T ScalarUseDict <T>(this ILuaSqlConfigExecutor configExecutor, IDictionary <string, object> parameters, IDictionary <string, ISqlConfigPolicy> policies) where T : struct { return((T)typeof(T).ChangeValueType(configExecutor.ScalarUseDict(parameters, policies))); }
/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static int NonQueryUseModel(this ILuaSqlConfigExecutor configExecutor, object paramsModel, IEnumerable <string> ignoreProptsForParamModel, IDictionary <string, ISqlConfigPolicy> policies) { return(configExecutor.NonQueryUseDict( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel), policies)); }
/// <summary> /// SqlQuery /// </summary> /// <typeparam name="T">数据类型</typeparam> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <param name="ignoreProptsForRtnType">数据类型需要忽略的属性名</param> /// <returns></returns> public static IReadOnlyList <T> QueryUseModel <T>(this ILuaSqlConfigExecutor configExecutor, object paramsModel, IEnumerable <string> ignoreProptsForParamModel = null, params string[] ignoreProptsForRtnType) where T : new() { return(configExecutor.QueryUseDict <T>( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel), ignoreProptsForRtnType)); }
/// <summary> /// SqlScalar /// </summary> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <returns></returns> public static T ScalarUseModel <T>(this ILuaSqlConfigExecutor configExecutor, object paramsModel, params string[] ignoreProptsForParamModel) where T : struct { return((T)typeof(T).ChangeValueType( configExecutor.ScalarUseDict( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel)))); }
/// <summary> /// SqlScalar /// </summary> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static T ScalarUseModel <T>(this ILuaSqlConfigExecutor configExecutor, object paramsModel, IEnumerable <string> ignoreProptsForParamModel, IDictionary <string, ISqlConfigPolicy> policies) where T : struct { return((T)typeof(T).ChangeValueType( configExecutor.ScalarUseDict( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel), policies))); }
/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <returns></returns> public static int NonQuery(this ILuaSqlConfigExecutor configExecutor, params IDataParameter[] parameters) { if (parameters?.Length > 0) { return(configExecutor.NonQueryUseDict(parameters.ToDictionary(l => l.ParameterName, l => l.Value))); } else { return(configExecutor.NonQueryUseDict(null)); } }
/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static int NonQuery(this ILuaSqlConfigExecutor configExecutor, IDataParameter[] parameters, IDictionary <string, ISqlConfigPolicy> policies) { if (parameters?.Length > 0) { return(configExecutor.NonQueryUseDict(parameters.ToDictionary(l => l.ParameterName, l => l.Value), policies)); } else { return(configExecutor.NonQueryUseDict(null, policies)); } }
/// <summary> /// SqlScalar /// </summary> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <returns></returns> public static T Scalar <T>(this ILuaSqlConfigExecutor configExecutor, params IDataParameter[] parameters) where T : struct { if (parameters?.Length > 0) { return((T)typeof(T).ChangeValueType( configExecutor.ScalarUseDict(parameters.ToDictionary(l => l.ParameterName, l => l.Value)))); } else { return((T)typeof(T).ChangeValueType(configExecutor.ScalarUseDict(null))); } }
/// <summary> /// SqlQuery /// </summary> /// <typeparam name="T">数据类型</typeparam> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <param name="ignoreProptsForRtnType">数据类型需要忽略的属性名</param> /// <returns></returns> public static IReadOnlyList <T> Query <T>(this ILuaSqlConfigExecutor configExecutor, IDataParameter[] parameters = null, params string[] ignoreProptsForRtnType) where T : new() { if (parameters?.Length > 0) { return(configExecutor.QueryUseDict <T>(parameters.ToDictionary(l => l.ParameterName, l => l.Value), ignoreProptsForRtnType)); } else { return(configExecutor.QueryUseDict <T>(null, ignoreProptsForRtnType)); } }
/// <summary> /// SqlQuery /// </summary> /// <typeparam name="T">数据类型</typeparam> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <param name="ignoreProptsForRtnType">数据类型需要忽略的属性名</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static IReadOnlyList <T> Query <T>(this ILuaSqlConfigExecutor configExecutor, IDataParameter[] parameters, IEnumerable <string> ignoreProptsForRtnType, IDictionary <string, ISqlConfigPolicy> policies) where T : new() { if (parameters?.Length > 0) { return(configExecutor.QueryUseDict <T>(parameters.ToDictionary(l => l.ParameterName, l => l.Value), ignoreProptsForRtnType, policies)); } else { return(configExecutor.QueryUseDict <T>(null, ignoreProptsForRtnType, policies)); } }