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