/// <summary> ///楼层显示分类分页查询 /// </summary> /// <param name="model">输入查询参数对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-7-13</remarks> public ResultModel Select(SearchFloorCategoryModel model) { var floorCategory = _database.Db.FloorCategory; var categoryLang = _database.Db.Category_Lang; var category = _database.Db.Category; var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal); if (model.ParentID != 0) { whereParam = new SimpleExpression(whereParam, floorCategory.CategoryId == model.ParentID || floorCategory.DCategoryId == model.ParentID, SimpleExpressionType.And); } dynamic c; dynamic cl; dynamic cl3; var query = floorCategory.All(). Join(categoryLang.As("categoryLang1"), out cl).On(floorCategory.DCategoryId == cl.CategoryId && cl.LanguageID == model.LanguageID). Join(categoryLang.As("categoryLang3"), out cl3).On(floorCategory.CategoryId == cl3.CategoryId && cl.LanguageID == model.LanguageID). Join(category.As("c"), out c).On(floorCategory.CategoryId == c.CategoryId). Where(cl.LanguageID == model.LanguageID). Where(cl3.LanguageID == model.LanguageID). Where(c.AuditState == true). Select(floorCategory.FloorCategoryId, cl.CategoryName.As("CategoryNameFirst"), cl3.CategoryName.As("CategoryNameThree"), floorCategory.Place, floorCategory.AddUsers, floorCategory.AddTime).OrderByPlace().Where(whereParam); var result = new ResultModel { Data = new SimpleDataPagedList <FloorCategoryModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }
/// <summary> /// 查询楼层显示分类列表 /// </summary> /// <param name="model">搜索实体对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-7-3</remarks> public JsonResult List(SearchFloorCategoryModel model) { model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; var paramList = _floorCategoryService.GetFloorCategoryList(new SearchFloorCategoryModel { PagedIndex = model.PagedIndex, PagedSize = model.PagedSize, LanguageID = ACultureHelper.GetLanguageID, }); 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-15</remarks> public ResultModel GetFloorCategoryList(SearchFloorCategoryModel model) { var floorCategory = _database.Db.FloorCategory; var categoryLang = _database.Db.Category_Lang; var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal); if (model.ParentID != 0) { whereParam = new SimpleExpression(whereParam, floorCategory.CategoryId == model.ParentID || floorCategory.DCategoryId == model.ParentID, SimpleExpressionType.And); } dynamic cl; // var query = floorCategory.FindAll(floorCategory.DCategoryId == 0).OrderByPlace(); var query = floorCategory. Query(). LeftJoin(categoryLang, out cl). On(floorCategory.CategoryId == cl.CategoryId). Where(cl.LanguageID == model.LanguageID && floorCategory.DCategoryId == 0). Select( floorCategory.FloorCategoryId, cl.CategoryName.As("navigationName"), floorCategory.Place, floorCategory.AddUsers, floorCategory.AddTime). Where(whereParam). OrderByPlace(); var result = new ResultModel { Data = new SimpleDataPagedList <FloorCategoryModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }