コード例 #1
0
ファイル: HotelBll.cs プロジェクト: nankede/hotelbase_api
        /// <summary>
        /// 酒店图片
        /// </summary>
        /// <param name="request"></param>
        public static List <H_HotelPictureModel> GetPicList(HotelPicSearchRequest request)
        {
            var db = new H_HotelPictureAccess();

            return(db.Query().Where(x => x.HIId == request.HotelId)?.ToList());

            //  return db.GetList(request);
        }
コード例 #2
0
        /// <summary>
        /// 酒店查询
        /// </summary>
        /// <param name="request"></param>
        public BasePageResponse <H_HotelPictureModel> GetList(HotelPicSearchRequest request)
        {
            var response = new BasePageResponse <H_HotelPictureModel>();

            response.Total = Query().Count(x => x.HIId == request.HotelId);
            if (response.Total > 0)
            {
                response.IsSuccess = 1;
                var sql = "SELECT * FROM H_HotelPicture   ";
                sql          += MysqlHelper.GetPageSql(request.PageIndex, request.PageSize);
                response.List = MysqlHelper.GetList <H_HotelPictureModel>(sql) ?? new List <H_HotelPictureModel>();
            }
            return(response);
        }