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