/// <summary>
/// 获取当前子类实体集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="whereStr"></param>
/// <returns></returns>
public List <T> GetList(string whereStr = "", IDbTransaction dbTransaction = null)
{
var sqlCondition = string.IsNullOrWhiteSpace(whereStr) ? "" : $" where {whereStr}";
return(DBContext.Query <T>($@"SELECT * FROM {typeof(T).Name} {sqlCondition}", transaction: dbTransaction).ToList());
}
/// <summary> /// 可通过业务实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="whereStr"></param> /// <returns></returns> public List <S> GetListFromSql <S>(string sql, IDbTransaction dbTransaction = null) => DBContext.Query <S>(sql, transaction: dbTransaction).ToList();
/// <summary>
/// Model
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="whereStr"></param>
/// <returns></returns>
public static T GetModel <T>(string whereStr = "")
{
var sqlCondition = string.IsNullOrWhiteSpace(whereStr) ? "" : $" where {whereStr}";
return(DBContext.Query <T>($@"SELECT * FROM {typeof(T).Name} {sqlCondition}").FirstOrDefault());
}
/// <summary>
/// List
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="whereStr"></param>
/// <returns></returns>
public static List <T> GetList <T>(string whereStr = "")
{
var sqlCondition = string.IsNullOrWhiteSpace(whereStr) ? "" : $" where {whereStr}";
return(DBContext.Query <T>($@"SELECT * FROM {typeof(T).Name} {sqlCondition}").ToList());
}
/// <summary> /// 可通过业务实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="whereStr"></param> /// <returns></returns> public List <S> GetListFromSql <S>(string sql) => DBContext.Query <S>(sql).ToList();
