Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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));
        }