/// <summary> /// 条件 /// </summary> /// <typeparam name="T">实体类</typeparam> /// <param name="t"></param> /// <param name="Exp">条件</param> /// <param name="Sort">排序</param> /// <returns></returns> public GDModel.MergerModel GDCodition <T, TRuslt>(T t, Expression <Func <T, bool> > Exp = null, Expression <Func <T, TRuslt> > OrderBy = null, SQLEnum.SortType SType = SQLEnum.SortType.Desc) where T : new() { string TableName = typeof(T).Name; string Where = Exp.DealExpress(); string Sort = $" {OrderBy.DealExpress()} {Enum.GetName(typeof(SQLEnum.SortType), SType)}"; Where = $"select * from {TableName} where 1=1 " + (string.IsNullOrEmpty(Where) ? "" : (" and " + Where)) + (string.IsNullOrEmpty(Sort) ? "" : (" Order By " + Sort)); return(new GDModel.MergerModel() { SQLStr = Where, Entity = t, EntityName = TableName }); }
/// <summary> /// 获取多条数据排序 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="Exp">查询条件</param> /// <param name="OrderBy">排序</param> /// <param name="SType">排序类型</param> /// <returns></returns> public List <T> GDList <T, TRuslt>(T Source, Expression <Func <T, bool> > Exp, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType) where T : new() { string Where = Exp.DealExpress(); string[] Sort = OrderBy.DealExpress().Split(','); for (int i = 0; i < Sort.Length; i++) { Sort[i] = $" {Sort[i]} {Enum.GetName(typeof(SQLEnum.SortType), SType)}"; } DataTable dt = BsDataTable($"select * from {typeof(T).Name} where 1=1 {Where} ORDER BY {string.Join(",", Sort)}"); return(dt.ToModel <T>()); }
/// <summary> /// 分页 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="Exp">查询条件</param> /// <param name="OrderBy">排序字段</param> /// <param name="SType">排序类型</param> /// <param name="ThisPage"></param> /// <param name="PageSize"></param> /// <returns></returns> public GDPaging <T> GDPaging <T, TRuslt>(T Source, Expression <Func <T, bool> > Exp, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType, int ThisPage = 1, int PageSize = 10) where T : new() { string Where = Exp.DealExpress(); string[] Sort = OrderBy.DealExpress().Split(','); for (int i = 0; i < Sort.Length; i++) { Sort[i] = $" {Sort[i]} {Enum.GetName(typeof(SQLEnum.SortType), SType)}"; } GDPaging <T> GDModel = new GDPaging <T>(); List <T> lt = new List <T>(); SqlParameter[] parameter = { new SqlParameter("@ThisPage", ThisPage), new SqlParameter("@PageSize", PageSize), new SqlParameter("@TableName", typeof(T).Name), new SqlParameter("@Condition", (string.IsNullOrEmpty(Where)?"":(" and " + Where))), new SqlParameter("@Sorting", string.Join(",", Sort)) }; DataSet ds = BsStorageDs("GT_Paging", parameter); if (ds == null || ds.Tables.Count < 2 || ds.Tables[0].Rows.Count == 0) { GDModel.GDModel = new List <T>(); return(GDModel); } else { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { lt.Add(ds.Tables[0].Rows[i].ToModel <T>()); } GDModel.GDModel = lt; GDModel.Count = Convert.ToInt32(ds.Tables[1].Rows[0][0]); } return(GDModel); }
/// <summary> /// 分页 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="OrderBy">排序字段</param> /// <param name="SType">排序类型</param> /// <param name="ThisPage"></param> /// <param name="PageSize"></param> /// <returns></returns> public GDPaging <T> GDPaging <T, TRuslt>(IEnumerable <T> Source, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType, int ThisPage = 1, int PageSize = 10) where T : new() { string Where = Source.ToString().Contains("Where") ? (Source.AsQueryable().Expression).DealExpress() : ""; string[] Sort = OrderBy.DealExpress().Split(','); for (int i = 0; i < Sort.Length; i++) { Sort[i] = $" {Sort[i]} {Enum.GetName(typeof(SQLEnum.SortType), SType)}"; } GDPaging <T> GDModel = new GDPaging <T>(); List <T> lt = new List <T>(); MySqlParameter[] parameter = { new MySqlParameter("@ThisPage", ThisPage), new MySqlParameter("@PageSize", PageSize), new MySqlParameter("@TableName", typeof(T).Name), new MySqlParameter("@Condition", Where), new MySqlParameter("@Sorting", string.Join(",", Sort)) }; DataSet ds = BsStorageDs("GT_Paging", parameter); if (ds == null || ds.Tables.Count < 2 || ds.Tables[0].Rows.Count == 0) { GDModel.GDModel = new List <T>(); return(GDModel); } else { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { lt.Add(ds.Tables[0].Rows[i].ToModel <T>()); } GDModel.GDModel = lt; GDModel.Count = Convert.ToInt32(ds.Tables[1].Rows[0][0]); } return(GDModel); }
/// <summary> /// 获取多条数据排序 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="OrderBy">排序</param> /// <param name="SType">排序类型</param> /// <returns></returns> public List <T> GDList <T, TRuslt>(IEnumerable <T> Source, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType) where T : new() { string Where = Source.ToString().Contains("Where") ? (Source.AsQueryable().Expression).DealExpress() : ""; string[] Sort = OrderBy.DealExpress().Split(','); for (int i = 0; i < Sort.Length; i++) { Sort[i] = $" {Sort[i]} {Enum.GetName(typeof(SQLEnum.SortType), SType)}"; } DataTable dt = BsDataTable($"select * from {typeof(T).Name} where 1=1 {Where} ORDER BY {string.Join(",", Sort)}"); return(dt.ToModel <T>()); }
/// <summary> /// 条件 /// </summary> /// <typeparam name="T">实体类</typeparam> /// <param name="t"></param> /// <param name="Exp">条件</param> /// <param name="Sort">排序</param> /// <returns></returns> public static GDModel.MergerModel GDCodition <T, TRuslt>(this T t, Expression <Func <T, bool> > Exp = null, Expression <Func <T, TRuslt> > OrderBy = null, SQLEnum.SortType SType = SQLEnum.SortType.Desc) where T : new() { SQLServerBSHelper Bs = new SQLServerBSHelper(ConnectName); return(Bs.GDCodition(t, Exp, OrderBy, SType)); }
/// <summary> /// 分页 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="Exp">查询条件</param> /// <param name="OrderBy">排序字段</param> /// <param name="SType">排序类型</param> /// <param name="ThisPage"></param> /// <param name="PageSize"></param> /// <returns></returns> public static GDPaging <T> GDPaging <T, TRuslt>(this T Source, Expression <Func <T, bool> > Exp, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType, int ThisPage = 1, int PageSize = 10) where T : new() { SQLServerBSHelper Bs = new SQLServerBSHelper(ConnectName); return(Bs.GDPaging(Source, Exp, OrderBy, SType, ThisPage, PageSize)); }
/// <summary> /// 获取多条数据排序 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="Exp">查询条件</param> /// <param name="OrderBy">排序</param> /// <param name="SType">排序类型</param> /// <returns></returns> public static List <T> GDList <T, TRuslt>(this T Source, Expression <Func <T, bool> > Exp, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType) where T : new() { SQLServerBSHelper Bs = new SQLServerBSHelper(ConnectName); return(Bs.GDList(Source, Exp, OrderBy, SType)); }
/// <summary> /// 分页 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="OrderBy">排序字段</param> /// <param name="SType">排序类型</param> /// <param name="ThisPage"></param> /// <param name="PageSize"></param> /// <returns></returns> public static GDPaging <T> GDPaging <T, TRuslt>(this IEnumerable <T> Source, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType, int ThisPage = 1, int PageSize = 10) where T : new() { MySQLBSHelper Bs = new MySQLBSHelper(ConnectName); return(Bs.GDPaging(Source, OrderBy, SType, ThisPage, PageSize)); }
/// <summary> /// 获取多条数据排序 /// </summary> /// <typeparam name="T">对象</typeparam> /// <typeparam name="TRuslt">对象</typeparam> /// <param name="Source">List</param> /// <param name="OrderBy">排序</param> /// <param name="SType">排序类型</param> /// <returns></returns> public static List <T> GDList <T, TRuslt>(this IEnumerable <T> Source, Expression <Func <T, TRuslt> > OrderBy, SQLEnum.SortType SType) where T : new() { MySQLBSHelper Bs = new MySQLBSHelper(ConnectName); return(Bs.GDList(Source, OrderBy, SType)); }