Exemple #1
0
        /// <summary>
        ///     查询关键字
        /// </summary>
        /// <param name="model">搜索实体对象</param>
        /// <returns></returns>
        /// <remarks>added by jimmy,2015-7-8</remarks>
        public JsonResult List(SearchFloorKeywordModel model)
        {
            model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
            var paramList =
                _floorKeywordService.Select(model);
            var data = new { rows = paramList.Data, total = paramList.Data.TotalCount };

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
Exemple #2
0
        /// <summary>
        ///     关键字分页查询
        /// </summary>
        /// <param name="model">输入查询参数对象</param>
        /// <returns></returns>
        /// <remarks>added by jimmy,2015-7-8</remarks>
        public ResultModel Select(SearchFloorKeywordModel model)
        {
            var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);

            if (!string.IsNullOrEmpty(model.KeyWordName))
            {
                whereParam = new SimpleExpression(whereParam, _database.Db.FloorKeyword.KeyWordName.Like("%" + model.KeyWordName + "%"), SimpleExpressionType.And);
            }
            if (model.LanguageID != 0)
            {
                whereParam = new SimpleExpression(whereParam, _database.Db.FloorKeyword.LanguageID == model.LanguageID, SimpleExpressionType.And);
            }
            var result = new ResultModel
            {
                Data =
                    new SimpleDataPagedList <FloorKeywordModel>(
                        _database.Db.FloorKeyword.FindAll(whereParam).OrderBy(_database.Db.FloorKeyword.Sorts),
                        model.PagedIndex, model.PagedSize)
            };

            return(result);
        }