/// <summary>
/// 美图的评论数据加载
/// </summary>
/// <returns></returns>
public ActionResult LoadGirleaveMsg()
{
int girlsId = int.Parse(Request["girlId"]);
int pageIndex = int.Parse(Request["pageIndex"] ?? "1");
int pageSize = int.Parse(Request["pageSize"] ?? "20");
int total = 0;
var msg = LeaveMsgBll.LoadEntities(m => true);
var girl = BeautifulGirlsBll.LoadEntities(n => n.Id > 0).Select(n => new { n.Id });
var user = PersonalUserBll.LoadEntities(u => u.Id > 0).Select(u => new { u.UName, u.Id, u.Head });
//-------------请求发布的评论----------------------------------
var data = from m in msg
join u in user on m.PersonalUserId equals u.Id into um
from umi in um.DefaultIfEmpty()
join n in girl on m.GirlId equals n.Id
where m.GirlId == girlsId
where m.ReplyId == null || m.ReplyId == 0
select new Publish()
{
Id = m.Id,
Msg = m.Msg,
City = m.City,
UserName = umi != null ? umi.UName : "" + m.Id + "" + "爽赞网友", //用户名
UserNameImg = umi.Head != null ? ("/Content/Img/" + umi.Head) : null, //用户头像
InTime = m.InTime,
Tip = m.Tip == null ? 0 : m.Tip,
Stamp = m.Stamp == null ? 0 : m.Stamp,
};
total = data.Count();
var alldata = data.AsNoTracking().OrderByDescending(d => d.InTime).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();
List <Publish> list = WebHelper.ToListTimeSpan(alldata);
//-------------------------- //回复的数据---------------------------------------------
string pubStrNav = LaomaPager.ShowPageNavigate(pageSize, pageIndex, total);
//回复的数据
var replyData = LeaveMsgBll.GetGirlLeaveMsgData(girlsId).Select(n => new Reply
{
SelfId = n.SelfId,
ReplyId = n.ReplyId,
ReplyContent = n.ReplyContent,
ReplyCity = n.ReplyCity,
ReplyName = n.ReplyName,
ReplyUserImg = n.ReplyUserImg,//用户头像
ReplyInTime = n.ReplyInTime,
ReplyTip = n.ReplyTip,
ReplyStamp = n.ReplyStamp,
}).ToList();
List <Reply> replyList = WebHelper.ToReplyStrTimeSpan(replyData);
var result = new { Data = list, replyData = replyList, PubStrNav = pubStrNav, Total = total };
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 美图局部分类搜索数据
/// </summary>
/// <returns></returns>
public JsonResult GetGirlsData()
{
string type = Request["type"];
string game = Request["game"];
int pageIndex = int.Parse(Request["pageIndex"] ?? "1");
int pageSize = int.Parse(Request["pageSize"] ?? "10");
var list = BeautifulGirlsBll.GetAllGirlsInfo(type, game, pageIndex, pageSize).Select(g => new {
g.Id,
g.Imgs,
g.Tags,
g.Title
}).ToList();
var ressult = new { Data = list };
return(Json(ressult, JsonRequestBehavior.AllowGet));
}
public ActionResult Views(int id)
{
var girl = BeautifulGirlsBll.LoadEntities(n => n.Id == id).FirstOrDefault();
if (girl != null)
{
girl.Views = girl.Views + 1;
if (BeautifulGirlsBll.Update(girl))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
else
{
return(Content("noExist"));
}
}
public ActionResult Index()
{
ViewData["smallImg"] = AdvertisementBll.GetAllTypeAdvert("2", 9);
ViewData["advert"] = AdvertisementBll.GetAllTypeAdvert("3", 2);
ViewBag.IndexBigImg = AdvertisementBll.GetAllTypeAdvert("1", 1);
ViewBag.SiYe = AdvertisementBll.GetAllTypeAdvert("4", 1);
ViewData["recGame"] = HomePageBll.GetAllTypeHomePage("11", 11);
ViewData["joinCpy"] = HomePageBll.GetAllTypeHomePage("12", 13);
ViewData["SlideShow"] = HomePageBll.GetAllTypeHomePage("7", 10);
ViewData["TenTopArea"] = HomePageBll.GetAllTypeHomePage("10", 10);
//网站首页所有新闻类型
ViewData["allTypeNews"] = NewsBll.GetAllNewsIndex();
//开测
ViewData["TestInfo"] = TestBll.TestDataTen();
//最爽礼包
ViewData["NewestCoolPackage"] = PackageBll.NewestCoolPackage();
//最热游戏
ViewData["NewestHotGame"] = HomePageBll.GetAllTypeHomePage("13", 5);
// 最强福利
ViewBag.NewsetGameDemo = GameDemoBll.GetNewestGameDemo();
//直播热点
ViewData["DirectHot"] = HomePageBll.GetAllTypeHomePage("5", 1);
ViewData["threeDirectHot"] = NewsBll.AccondingTypeGetNews("5");
//手游
ViewData["MobileGame"] = HomePageBll.GetAllTypeHomePage("6", 1);
ViewData["threeMobileGame"] = NewsBll.AccondingTypeGetNews("6");
//最赞攻略结合游戏库拿游戏的logo图
ViewData["MostGreatRaiders"] = UserRaidersBll.GetMostGreatRaiders(10);
//福利美图
ViewData["NewestIndexRecGirls"] = BeautifulGirlsBll.NewestIndexRecGirls();
//热游排行
ViewBag.InLikeNumHotGame = GameBll.InLikeNumHotGame();
//开服
ViewBag.sevenData = OpenServiceBll.WillSevenDayService();
//资讯排行
ViewBag.LikeNumNews = NewsBll.InLikeNumNews();
ViewBag.RecCpy = CompanyBll.RecCompany();
return(View());
}
public ActionResult GirlDetails(int id)
{
var data = BeautifulGirlsBll.GetGirlDetails(id).Select(t => new GirlsViewModel()
{
Id = t.Id,
Title = t.Title,
Tags = t.Tags,
LeaveMsgCount = t.LeaveMsgCount,
LeadTxt = t.LeadTxt,
Image = t.Image,
InTime = t.InTime,
Views = t.Views,
}).FirstOrDefault();
ViewData.Model = data as GirlsViewModel;
string[] arryImg = data.Image.Split(',');
List <GirlsViewModel> list = new List <GirlsViewModel>();
GirlsViewModel model = null;
for (int n = 0; n < arryImg.Length; n++)
{
model = new GirlsViewModel();
model.Image = arryImg[n];
list.Add(model);
}
ViewBag.arryImg = list;
//根据标签推荐
ViewBag.InTags = BeautifulGirlsBll.LoadEntities(g => g.Tags.Contains(data.Tags)).Select(g => new GirlsViewModel
{
Id = g.Id,
Tags = g.Tags,
Title = g.Title,
InTime = g.InTime
}).AsNoTracking().OrderByDescending(g => g.InTime).Take(6).ToList();;
#region 一篇、下一篇
//-上一篇、下一篇
//用pre和next变量分别存放上一篇文章和下一篇文章的id号
int pre = 0, next = 0, i = 0, j;
//计算总记录数
int num = BeautifulGirlsBll.LoadEntities(n => true).Count();
int[] a = new int[num];
var query = BeautifulGirlsBll.LoadEntities(n => true).Select(n => n.Id).ToArray();
//将所有的文章id号全部放入一个数组中
foreach (var item in query)
{
a[i] = Convert.ToInt32(item);
i++;
}
//循环，获取上一篇和下一篇文章的ID号，分别放入变量pre和next中
for (j = 0; j < num; j++)
{
if (a[j] == id)
{
if (j != 0)
{
pre = a[j - 1]; //上一篇id
}
if (j != num - 1)
{
next = a[j + 1]; //下一篇文章id
}
}
}
//获取上一篇文章的标题
if (pre == 0)
{
ViewBag.preTags = "没有了";
ViewBag.pre = id;
}
else
{
ViewBag.preTags = BeautifulGirlsBll.LoadEntities(n => n.Id == pre).Single().Tags;
ViewBag.pre = pre;
}
//获取下一篇文章的标题
if (next == 0)
{
ViewBag.nextTags = "没有了";
ViewBag.next = id;
}
else
{
ViewBag.nextTags = BeautifulGirlsBll.LoadEntities(n => n.Id == next).Single().Tags;
ViewBag.next = next;
}
#endregion
return(View());
}
