public Response <object> QueryInByFilter([FromBody] MailReceiverRequest reqMsg) { var result = new Response <object>(); //获取当前用户信息 var user = _authUtil.GetCurrentUser().User; reqMsg.userid = user.Id; var total = _mailReceiverapp.QueryInDataRecord(reqMsg); var list = _mailReceiverapp.QueryInByFilter(reqMsg); result.Result = new { count = total, data = list }; return(result); }
/// <summary> /// 根据条件查询收件信息 /// </summary> public List <OaMailReceiver> QueryInByFilter(MailReceiverRequest param) { var list = Repository.Find(t => t.mail_title.Contains(param.keyWords)).ToList(); if (param.insession == "0") { list = list.Where(t => t.receiver_id == param.userid).ToList(); } else { list = list.Where(t => t.sender_id == param.userid).ToList(); } if (param.status == "1") { list = list.Where(t => t.read_time > DateTime.MinValue).ToList(); } else { list = list.Where(t => t.read_time is null).ToList(); } return(list.Skip(param.offset).Take(param.limit).ToList()); }
/// <summary> /// 根据条件查询收件总数 /// </summary> public int QueryInDataRecord(MailReceiverRequest param) { var list = Repository.Find(t => t.mail_title.Contains(param.keyWords)).ToList(); if (param.insession == "0") { list = list.Where(t => t.receiver_id == param.userid).ToList(); } else { list = list.Where(t => t.sender_id == param.userid).ToList(); } if (param.status == "1") { list = list.Where(t => t.read_time > DateTime.MinValue).ToList(); } else { list = list.Where(t => t.read_time is null).ToList(); } return(list.Count); }