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