Beispiel #1
0
        /// <summary>
        /// 根根据查询字段、查询条件、查询参数查询实体对应数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="queryColumns"></param>
        /// <param name="whereSql"></param>
        /// <param name="whereObjParams"></param>
        /// <returns></returns>
        public virtual List <T> Query <T>(string queryColumns, string whereSql, object whereObjParams)
        {
            List <T> result   = null;
            var      dbEntity = DbBuilder.QueryByParam <T>(queryColumns, whereSql, whereObjParams);

            if (dbEntity == null)
            {
                return(result);
            }
            using (var reader = DbHelper.ExecuteReader(dbEntity.CommandText, dbEntity.DbParams))
            {
                result = DataReaderToEntityList <T>(reader);
            }
            return(result);
        }