/// <summary> /// 留言信息分布查询 /// </summary> /// <param name="model">输入查询参数对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-7-27</remarks> public ResultModel Select(SearchMessageModel model) { var message = _database.Db.Message; #region 查询参数条件 //查询参数条件 var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //留言人 if (!string.IsNullOrEmpty(model.MsgPerson)) { whereParam = new SimpleExpression(whereParam, message.MsgPerson.Like("%" + model.MsgPerson + "%"), SimpleExpressionType.And); } //留言主题 if (!string.IsNullOrEmpty(model.subject)) { whereParam = new SimpleExpression(whereParam, message.subject.Like("%" + model.subject + "%"), SimpleExpressionType.And); } #endregion var query = message.All().Where(whereParam).OrderByCreateDT(); var result = new ResultModel() { Data = new SimpleDataPagedList <MessageModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }
/// <summary> /// 查询留言信息列表 /// </summary> /// <param name="model">搜索实体对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-7-16</remarks> public JsonResult List(SearchMessageModel model) { model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; var list = _messageService.Select(model); var data = new { rows = list.Data, total = list.Data.TotalCount }; return(Json(data, JsonRequestBehavior.AllowGet)); }