1. 首頁 > 生活百科 > >

.NET Core C#系列之XiaoFeng.Data.IQueryableX ORM框架( 二 )

生活百科


.NET Core C#系列之XiaoFeng.Data.IQueryableX ORM框架

文章插圖
.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();
.NET Core C#系列之XiaoFeng.Data.IQueryableX ORM框架

文章插圖
.NET Core C#系列之XiaoFeng.Data.IQueryableX ORM框架

文章插圖
下邊我們說一下 內部函數用法，函數擴展了基本上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}

推薦閱讀