/// <summary> /// 关键字为空 日期为空 /// </summary> /// <returns></returns> public List <HistoryChatEntity> Query00(string fromuid, string touid, int pageSize, int pageNumber, int queryCount) { var query = unitOfWork.DIMMsg.Get( p => ((p.FromuID == fromuid && p.TouID == touid) || (p.FromuID == touid && p.TouID == fromuid)) && p.IsDel != 1) .OrderByDescending(p => p.CreateDate).Skip(pageSize * (pageNumber - 1)).Take(pageSize).OrderBy(p => p.CreateDate).ToList(); List <HistoryChatEntity> list = new List <HistoryChatEntity>(); foreach (var imMsg in query) { var entity = new HistoryChatEntity(); entity.TrueName = imMsg.fromusername; entity.Msg = imMsg.Msg; entity.ChatTime = imMsg.CreateDate.Value.ToString("G"); list.Add(entity); } return(list); }
/// <summary> /// 历史聊天记录(根据传入参数的不同 分为两种查询方式 一种是按照时间来查询 一种是按照聊天内容来查询) /// </summary> /// <returns></returns> public ActionResult HistoryChat(string touid, DateTime dateTime, int pageNumber = 1, string msg = "") { List <HistoryChatEntity> list = new List <HistoryChatEntity>(); if (msg == "") { //根据日期查询 /*聊天记录 根据当前日期 选取该日期的聊天就 然后执行翻页*/ dateTime = dateTime.Date; var fromuid = LoginUserService.ssoUserID; var dateTime2 = dateTime.AddDays(1); var query = unitOfWork.DIMMsg.Get( p => p.TouID == touid && (p.CreateDate.Value >= dateTime && p.CreateDate.Value <= dateTime2) && p.IsDel != 1) .OrderByDescending(p => p.CreateDate); Paging paging = new Paging(); paging.PageNumber = pageNumber; paging.PageSiz = 20; paging.Amount = query.Count(); ViewBag.pageNo = pageNumber; //当前页码 1 ViewBag.pageCount = paging.PageCount; var pageQuery2 = query.Skip(paging.PageSiz * paging.PageNumber).Take(paging.PageSiz).OrderBy(p => p.CreateDate).ToList(); foreach (var imMsg in pageQuery2) { var entity = new HistoryChatEntity(); entity.TrueName = imMsg.fromusername; entity.Msg = imMsg.Msg; entity.ChatTime = imMsg.CreateDate.Value.ToString("G"); list.Add(entity); } if (list.Any()) { return(Json(new { r = true, list = list, pageCount = paging.PageCount, pageNo = pageNumber }, JsonRequestBehavior.AllowGet)); } return(Json(new { r = false }, JsonRequestBehavior.AllowGet)); } else { //根据内容查询 var query = unitOfWork.DIMMsg.Get( p => p.TouID == touid && p.Msg.Contains(msg) && p.IsDel != 1).OrderByDescending(p => p.CreateDate); Paging paging = new Paging(); paging.PageNumber = pageNumber; paging.PageSiz = 20; paging.Amount = query.Count(); ViewBag.pageNo = pageNumber;//当前页码 1 ViewBag.pageCount = paging.PageCount; var pageQuery2 = query.Skip(paging.PageSiz * paging.PageNumber).Take(paging.PageSiz).OrderBy(p => p.CreateDate).ToList(); foreach (var imMsg in pageQuery2) { var entity = new HistoryChatEntity(); entity.TrueName = imMsg.fromusername; entity.Msg = imMsg.Msg; entity.ChatTime = imMsg.CreateDate.Value.ToString("G"); list.Add(entity); } if (list.Any()) { return(Json(new { r = true, list = list, pageCount = paging.PageCount, pageNo = pageNumber }, JsonRequestBehavior.AllowGet)); } return(Json(new { r = false }, JsonRequestBehavior.AllowGet)); } }