.NET Core C#系列之XiaoFeng.Data.IQueryableX ORM框架( 二 ) _生活百科

文章插图

文章插图
接着我们讲 B 方案用法

//创建一个带数据库的 IQueryableX 对象，下边所有的操作都是基于当前对象来操作 。var data = https://www.huyubaike.com/biancheng/new DataHelperX(Conn);//查询下边三种写法 运行后 结果是一样的var userModel1 = data.Where(a => a.Account =="jacky" && a.Password == "admin123").ToEntity();var userModel2 = data.Where(a => a.Account == "jacky").Where(a => a.Password == "admin123").ToEntity();var userModel3 = data.First(a => a.Account == "jacky" && a.Password == "admin123");//列表var userList1 = data.Where(a => a.Sex == 1 || a.Account == "jacky").ToList();//关联查询var userList2 = data.Where(a => a.Sex == 1).Join<UserModel, object[]>((a, b) => new object[] { a.Account == b.Password }).Select((a, b) => new{a.Account,a.Password,ParentName = b.Account}).ToList();//插入var userModel4 = new UserModel { Account = "jacky", Password = "admin" };var insert1 = data.Insert(userModel4);//如果想返回自增长ID则后边输入接收参数即可如下var insert2 = data.Insert(userModel4, out var ID);//批量插入var insert3 = data.Inserts(new List<UserModel> { userModel4,userModel4 });//更新var update1 = data.Where(a => a.Id == 1).Update(a => a.Password == "adminadmin");//删除var delete1 = data.Where(a => a.Id == 1).Delete();

文章插图

文章插图
下边我们说一下内部函数用法，函数扩展了基本上SQL中用到的函数，以及C#语言中的字符串处理函数的大部分，内部函数扩展方法如下：

/// <summary>/// 扩展SQL语法/// Version : 2.0.0/// Author : jacky/// Email : jacky@zhuovi.com/// QQ : 7092734/// Site : www.zhuovi.com/// Create Time : 2017/12/20 9:40:00/// Update Time : 2018/01/19 13:40:00/// </summary>public static partial class PrototypeHelper{#region 扩展SQL 语法#region 扩展SQL 字段加值+/// <summary>/// 字段加值/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="value">值</param>/// <returns></returns>public static T AddSQL<T>(this T obj, T value) { return obj; }#endregion#region 扩展SQL 字段减值-/// <summary>/// 字段减值/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="value">值</param>/// <returns></returns>public static T SubtractSQL<T>(this T obj, T value) { return obj; }#endregion#region 扩展SQL 字段乘值*/// <summary>/// 字段乘值/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static T MultiplySQL<T>(this T obj, T value) { return obj; }#endregion#region 扩展SQL 字段除值//// <summary>/// 字段除值/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static T DivideSQL<T>(this T obj, T value) { return obj; }#endregion#region 扩展SQL Between/// <summary>/// 扩展SQL Between/// </summary>/// <param name="obj">对象</param>/// <param name="startValue">开始值</param>/// <param name="endValue">结束值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Boolean BetweenSQL(this object obj, object startValue, object endValue) { return true; }#endregion#region 扩展SQL ISNULL/// <summary>/// 扩展SQL ISNULL/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="defaultValue">默认值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static T IsNullSQL<T>(this T obj, T defaultValue) { return defaultValue; }#endregion#region 扩展SQL in 语法/// <summary>/// 扩展SQL in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="array">数组织</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool InSQL<T>(this T obj, IEnumerable<T> array) { return true; }/// <summary>/// 扩展SQL in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="array">数组织</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool InSQL<T>(this T obj, T[] array) { return true; }/// <summary>/// 扩展SQL in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <typeparam name="T1">类型</typeparam>/// <param name="obj">对象</param>/// <param name="queryableX">IQueryableX对象</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Boolean InSQL<T, T1>(this T obj, IQueryableX<T1> queryableX) { return true; }/// <summary>/// 扩展SQL in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="array">数组</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool InSQL<T>(this T obj, object[] array) { return true; }/// <summary>/// 扩展SQL not in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="array">数组</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool NotInSQL<T>(this T obj, IEnumerable<T> array) { return true; }/// <summary>/// 扩展SQL not in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="array">数组</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool NotInSQL<T>(this T obj, T[] array) { return true; }/// <summary>/// 扩展SQL not in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <typeparam name="T1">类型</typeparam>/// <param name="obj">对象</param>/// <param name="queryableX">IQueryableX对象</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Boolean NotInSQL<T, T1>(this T obj, IQueryableX<T1> queryableX) { return true; }/// <summary>/// 扩展SQL not in语法/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="array">数组</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool NotInSQL<T>(this T obj, object[] array) { return true; }#endregion#region 扩展SQL like 语法/// <summary>/// 扩展SQL like 语法/// </summary>/// <param name="str">字符串</param>/// <param name="likeStr">子串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool LikeSQL(this object str, string likeStr) { return true; }/// <summary>/// 扩展SQL not like 语法/// </summary>/// <param name="str">字符串</param>/// <param name="likeStr">子串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool NotLikeSQL(this string str, string likeStr) { return true; }/// <summary>/// 扩展SQL like 语法/// </summary>/// <param name="str">字符串</param>/// <param name="likeStr">子串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool LikeSQLX(this object str, string likeStr) { return true; }/// <summary>/// 扩展SQL not like 语法/// </summary>/// <param name="str">字符串</param>/// <param name="likeStr">子串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static bool NotLikeSQLX(this string str, string likeStr) { return true; }#endregion#region 扩展SQL DateAdd 语法/// <summary>/// 扩展SQL DateAdd 语法/// </summary>/// <param name="date">日期</param>/// <param name="val">值</param>/// <param name="format">格式 年yy,yyyy 季度qq,q 月mm,m 年中的日dy,y 日dd,d 周wk,ww 星期dw,w 小时hh 分钟mi,n 秒ss,s 毫秒ms 微秒mcs 纳秒ns</param>/// <returns></returns>public static DateTime DateAddSQL(this DateTime date, long val, string format){return date;}/// <summary>/// 扩展SQL DateAdd 语法/// </summary>/// <param name="date">日期</param>/// <param name="val">值</param>/// <param name="format">格式 年yy,yyyy 季度qq,q 月mm,m 年中的日dy,y 日dd,d 周wk,ww 星期dw,w 小时hh 分钟mi,n 秒ss,s 毫秒ms 微秒mcs 纳秒ns</param>/// <returns></returns>public static DateTime DateAddSQL(this DateTime? date, long val, string format){return date.GetValueOrDefault();}#endregion#region 扩展SQL DateDiff 语法/// <summary>/// 扩展SQL DateDiff 语法/// </summary>/// <param name="firstDate">第一个时间</param>/// <param name="SecondDate">第二个时间</param>/// <param name="format">格式 年yy,yyyy 季度qq,q 月mm,m 年中的日dy,y 日dd,d 周wk,ww 星期dw,w 小时hh 分钟mi,n 秒ss,s 毫秒ms 微秒mcs 纳秒ns</param>/// <returns></returns>public static int DateDiffSQL(this DateTime? firstDate, DateTime? SecondDate, string format) { return 1; }/// <summary>/// 扩展SQL DateDiff 语法/// </summary>/// <param name="firstDate">第一个时间</param>/// <param name="SecondDate">第二个时间</param>/// <param name="format">格式 年yy,yyyy 季度qq,q 月mm,m 年中的日dy,y 日dd,d 周wk,ww 星期dw,w 小时hh 分钟mi,n 秒ss,s 毫秒ms 微秒mcs 纳秒ns</param>/// <returns></returns>public static int DateDiffSQL(this DateTime firstDate, DateTime SecondDate, string format) { return 1; }#endregion#region 扩展SQL DatePart 语法/// <summary>/// 扩展SQL DatePart 语法/// </summary>/// <param name="Date">当前时间</param>/// <param name="format">格式 年yy,yyyy 季度qq,q 月mm,m 年中的日dy,y 日dd,d 周wk,ww 星期dw,w 小时hh 分钟mi,n 秒ss,s 毫秒ms 微秒mcs 纳秒ns</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int DatePartSQL(this DateTime? Date, string format) { return 0; }/// <summary>/// 扩展SQL DatePart 语法/// </summary>/// <param name="Date">当前时间</param>/// <param name="format">格式 年yy,yyyy 季度qq,q 月mm,m 年中的日dy,y 日dd,d 周wk,ww 星期dw,w 小时hh 分钟mi,n 秒ss,s 毫秒ms 微秒mcs 纳秒ns</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int DatePartSQL(this DateTime Date, string format) { return 0; }#endregion#region 扩展SQL DateFormat 语法/// <summary>/// 扩展SQL DateFormat 语法/// </summary>/// <param name="Date">当前时间</param>/// <param name="format"></param>/// <returns></returns>public static string DateFormatSQL(this DateTime? Date, string format) { return string.Empty; }/// <summary>/// 扩展SQL DateFormat 语法/// </summary>/// <param name="Date">当前时间</param>/// <param name="format"></param>/// <returns></returns>public static string DateFormatSQL(this DateTime Date, string format) { return string.Empty; }#endregion#region 扩展SQL Charindex 语法/// <summary>/// 扩展SQL Charindex 语法/// </summary>/// <param name="str">字符串</param>/// <param name="IndexStr">子串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int CharIndexSQL(this string str, string IndexStr) { return 1; }#endregion#region 扩展SQL Patindex语法/// <summary>/// 扩展SQL Patindex语法/// </summary>/// <param name="str">字符串</param>/// <param name="IndexStr">子串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int PatindexSQL(this string str, string IndexStr) { return 1; }#endregion#region 扩展SQL Abs 算法/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int AbsSQL(this int value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int AbsSQL(this int? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Int16 AbsSQL(this Int16? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Int16 AbsSQL(this Int16 value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Int64 AbsSQL(this Int64? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Int64 AbsSQL(this Int64 value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double AbsSQL(this Double? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double AbsSQL(this Double value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal AbsSQL(this decimal? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal AbsSQL(this decimal value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float AbsSQL(this float? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float AbsSQL(this float value) { return 1; }#endregion#region 扩展SQL Floor 算法/// <summary>/// 扩展SQL Floor 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double FloorSQL(this Double? value) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double FloorSQL(this Double value) { return 1; }/// <summary>/// 扩展SQL Floor 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal FloorSQL(this decimal? value) { return 1; }/// <summary>/// 扩展SQL Floor 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal FloorSQL(this decimal value) { return 1; }/// <summary>/// 扩展SQL Floor 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float FloorSQL(this float? value) { return 1; }/// <summary>/// 扩展SQL Floor 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float FloorSQL(this float value) { return 1; }#endregion#region 扩展SQL Ceiling 算法/// <summary>/// 扩展SQL Ceiling 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double CeilingSQL(this Double? value) { return 1; }/// <summary>/// 扩展SQL Ceiling 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double CeilingSQL(this Double value) { return 1; }/// <summary>/// 扩展SQL Ceiling 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal CeilingSQL(this decimal? value) { return 1; }/// <summary>/// 扩展SQL Ceiling 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal CeilingSQL(this decimal value) { return 1; }/// <summary>/// 扩展SQL Ceiling 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float CeilingSQL(this float? value) { return 1; }/// <summary>/// 扩展SQL Ceiling 算法/// </summary>/// <param name="value">值</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float CeilingSQL(this float value) { return 1; }#endregion#region 扩展SQL Round 算法/// <summary>/// 扩展SQL Round 算法/// </summary>/// <param name="value">值</param>/// <param name="len">小数点保留长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double RoundSQL(this Double? value, int len) { return 1; }/// <summary>/// 扩展SQL Round 算法/// </summary>/// <param name="value">值</param>/// <param name="len">小数点保留长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static Double RoundSQL(this Double value, int len) { return 1; }/// <summary>/// 扩展SQL Round 算法/// </summary>/// <param name="value">值</param>/// <param name="len">小数点保留长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal RoundSQL(this decimal? value, int len) { return 1; }/// <summary>/// 扩展SQL Round 算法/// </summary>/// <param name="value">值</param>/// <param name="len">小数点保留长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static decimal RoundSQL(this decimal value, int len) { return 1; }/// <summary>/// 扩展SQL Abs 算法/// </summary>/// <param name="value">值</param>/// <param name="len">小数点保留长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float RoundSQL(this float? value, int len) { return 1; }/// <summary>/// 扩展SQL Round 算法/// </summary>/// <param name="value">值</param>/// <param name="len">小数点保留长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static float RoundSQL(this float value, int len) { return 1; }#endregion#region 扩展SQL Left/// <summary>/// 扩展SQL Left/// </summary>/// <param name="str">字符串</param>/// <param name="num">第几位</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string LeftSQL(this string str, int num) { return ""; }#endregion#region 扩展SQL Right/// <summary>/// 扩展SQL Right/// </summary>/// <param name="str">字符串</param>/// <param name="num">第几位</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string RightSQL(this string str, int num) { return ""; }#endregion#region 扩展SQL Len/// <summary>/// 扩展SQL Len/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int LengthSQL(this string str) { return 1; }#endregion#region 扩展SQL Replace/// <summary>/// 扩展SQL Replace/// </summary>/// <param name="str">字符串</param>/// <param name="oldString">原字符串</param>/// <param name="replaceString">新字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string ReplaceSQL(this string str, string oldString, string replaceString) { return ""; }#endregion#region 扩展SQL Replicate/// <summary>/// 扩展SQL Replicate/// </summary>/// <param name="str">字符串</param>/// <param name="num">重复次数</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string ReplicateSQL(this string str, int num) { return ""; }#endregion#region 扩展SQL Reverse/// <summary>/// 扩展SQL Reverse/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string ReverseSQL(this string str) { return ""; }#endregion#region 扩展SQL Stuff/// <summary>/// 扩展SQL Stuff/// </summary>/// <param name="str">字符串</param>/// <param name="strat">开始位置</param>/// <param name="length">长度</param>/// <param name="replaceString">替换字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string StuffSQL(this string str, int strat, int length, string replaceString) { return ""; }#endregion#region 扩展SQL Substring/// <summary>/// 扩展SQL Substring/// </summary>/// <param name="str">字符串</param>/// <param name="start">开始位置</param>/// <param name="length">长度</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string SubstringSQL(this string str, int start, int length) { return ""; }#endregion#region 扩展SQL Trim/// <summary>/// 扩展SQL Ltrim/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string LTrimSQL(this string str) { return ""; }/// <summary>/// 扩展SQL Rtrim/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string RTrimSQL(this string str) { return ""; }/// <summary>/// 扩展SQL Trim/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string TrimSQL(this string str) { return ""; }#endregion#region 扩展SQL Lower/// <summary>/// 扩展SQL Lower/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string LowerSQL(this string str) { return ""; }#endregion#region 扩展SQL Upper/// <summary>/// 扩展SQL Upper/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static string UpperSQL(this string str) { return ""; }#endregion#region 扩展SQL Count/// <summary>/// 扩展SQL Count/// </summary>/// <param name="str">字符串</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static int CountSQL(this object str) { return 0; }#endregion#region 扩展SQL MAX/// <summary>/// 扩展SQL MAX/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">字符串</param>/// <returns></returns>public static T MaxSQL<T>(this T obj) { return obj; }#endregion#region 扩展SQL MIN/// <summary>/// 扩展SQL MIN/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">字符串</param>/// <returns></returns>public static T MinSQL<T>(this T obj) { return obj; }#endregion#region 扩展SQL SUM/// <summary>/// 扩展SQL SUM/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">字符串</param>/// <returns></returns>public static T SumSQL<T>(this T obj) { return obj; }#endregion#region 扩展SQL AVG/// <summary>/// 扩展SQL AVG/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">字符串</param>/// <returns></returns>public static T AvgSQL<T>(this T obj) { return obj; }#endregion#region 设置字段别名/// <summary>/// 设置字段别名/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="ColumnName">别名</param>/// <returns></returns>[System.Diagnostics.CodeAnalysis.SuppressMessage("Style", "IDE0060:删除未使用的参数", Justification = "<挂起>")]public static T As<T>(this T obj, string ColumnName) { return obj; }#endregion#region 转换类型/// <summary>/// 转换类型/// </summary>/// <typeparam name="T">类型</typeparam>/// <param name="obj">对象</param>/// <param name="dataType">目标类型</param>/// <returns></returns>public static T CastSQL<T>(this T obj,string dataType) { return obj; }#endregion#region SQL参数化调整/// <summary>/// SQL参数化调整/// </summary>/// <param name="_">SQL语句</param>/// <param name="dbProvider">数据库驱动</param>/// <returns></returns>public static string SQLFormat(this string _, DbProviderType dbProvider){switch (dbProvider){case DbProviderType.Dameng:return _.ReplacePattern(@"@((Sub_(\d+_)?)?ParamName\d+)", "?");case DbProviderType.Oracle:return _.ReplacePattern(@"@((Sub_(\d+_)?)?ParamName\d+)", ":$1");}return _;}#endregion#endregion}
上一页
1
2
3
下一页
		  	

    
    




    
    
    


推荐阅读

           
                  
              
                  崂山特产都有什么，青岛崂山的特产与介绍 
                
                   
                
              
            

                  
              
                  钟原赵欣是什么电视剧啊 钟原赵欣是什么电视剧啊? 
                
                   
                
              
            

                  
              
                  铁锈水滴在车上怎么洗 锈水滴在车上怎么清洗 
                
                   
                
              
            

                  
              
                  观香看事可信吗 观香是什么意思 
                
                   
                
              
            

                  
              
                  苹果13激活时间查看技巧 苹果如何查询手机激活时间 
                
                   
                
              
            

                  
              
                  长沙市毕业生档案存放地址 长沙高校毕业生档案信息查询指南 
                
                   
                
              
            

                  
              
                  四大民间故事分别指什么 
                
                   
                
              
            

                  
              
                  伶人是男是女 
                
                   
                
              
            

                  
              
                  健康平安的名字 新生儿取名方法 
                
                   
                
              
            

                  
              
                  客来福衣柜与好莱客衣柜哪个质量好 好莱客衣柜怎么样 
                
                   
                
              
            

                  
              
                  铁线莲的种子播种 *** 和注意事项  铁线莲种子播种前的处理 *** 
                
                   
                
              
            

                  
              
                  天天酷跑五星宠物哪个比较好一些[多图] 
                
                   
                
              
            

                  
              
                  新宝马5果断黑色 宝马5系黑色 
                
                   
                
              
            

                  
              
                  2020疫情期间蓝梦海洋王国开园时间 
                
                   
                
              
            

                  
              
                  古风诗意的句子 古风诗意的句子是什么 
                
                   
                
              
            

                  
              
                  小伤痕容易导致车体生锈 车身容易生锈 
                
                   
                
              
            

                  
              
                  2021一2022女排超级联赛时间表 2021一2022女排超级联赛时间 
                
                   
                
              
            

                  
              
                  炒茄子怎么做好吃窍门 炒茄子怎么做好吃窍门图片 
                
                   
                
              
            

                  
              
                  让天蝎男疯狂的水瓶女 天蝎男一生难忘的水瓶女 
                
                   
                
              
            

                  
              
                  男女初次见面送的花 第一次约会送什么礼物好 
                
                   
                
              
            

          

flutter系列之:永远不用担心组件溢出的Wrap 

荣耀x20评测_荣耀x20评测表现 

抛砖系列之redis监控命令 

.NET性能系列文章一：.NET7的性能改进 

dubbo的一系列配置与搭建 

记一次 .NET 某娱乐聊天流平台 CPU 爆高分析 

vivox60充电时间_vivox60充电快吗 

MassTransit | .NET 分布式应用框架 

使用 Windows Core Audio APs 进行 Loopback Recording 并生成 WAV 文件 

基于PL022 SPI 控制器 海思3516系列芯片SPI速率慢问题深入分析与优化