/// <summary> /// 查询反馈信息列表 /// </summary> /// <param name="model">搜索实体对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-8-12</remarks> public JsonResult List(SearchFeedbackModel model) { model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; var list = _feedbackService.Select(model); var data = new { rows = list.Data, total = list.Data.TotalCount }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 用户反馈分页查询 /// </summary> /// <param name="model">输入查询参数对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-8-12</remarks> public ResultModel Select(SearchFeedbackModel model) { var feedback = _database.Db.Feedback; var feedbackType_lang = _database.Db.FeedbackType_lang; var user = _database.Db.YH_User; //查询参数条件 var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //用户名 if (!string.IsNullOrEmpty(model.Account)) { whereParam = new SimpleExpression(whereParam, user.Account.Like("%" + model.Account + "%"), SimpleExpressionType.And); } //反馈名称 if (!string.IsNullOrEmpty(model.FeedbackName)) { whereParam = new SimpleExpression(whereParam, feedbackType_lang.FeedbackName.Like("%" + model.FeedbackName + "%"), SimpleExpressionType.And); } //多语言 if (model.LanguageID != 0) { whereParam = new SimpleExpression(whereParam, feedbackType_lang.LanguageID == model.LanguageID, SimpleExpressionType.And); } //来源 if (model.Source != null) { whereParam = new SimpleExpression(whereParam, feedback.Source == model.Source.Value, SimpleExpressionType.And); } dynamic u; dynamic fl; var query = feedback.All(). LeftJoin(feedbackType_lang, out fl).On(feedback.FeedbackType == fl.FeedbackTypeId). LeftJoin(user, out u).On(feedback.UserID == u.UserID). Select( feedback.FeedbackId, feedback.FeedbackType, feedback.MsgContent, feedback.FeedbackDate, feedback.Source, fl.FeedbackName, fl.LanguageID, u.Account ). Where(whereParam).OrderByFeedbackDateDescending(); var result = new ResultModel() { Data = new SimpleDataPagedList <FeedbackModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }