public JsonResult PackageList() { int pageIndex = int.Parse(Request["pageIndex"] ?? "1"); int pageSize = int.Parse(Request["pageSize"] ?? "30"); int total = 0; string type = Request["type"]; string key = Request["key"]; string systemname = Request["systemname"]; PackageParam param = new PackageParam() { PageIndex = pageIndex, PageSize = pageSize, Total = total, Type = type, Key = key, Systemname = systemname }; var list = PackageBll.LoadPackageData(param).Select(p => new PackageViewModel() { Id = p.Id, GameName = p.GameName, SystemName = p.SystemName, GiftName = p.GiftName, InTime = p.InTime, StartTime = p.StartTime, EndTime = p.EndTime, Used = p.Used, Type = p.Type }).ToList(); var NavStr = Common.LaomaPager.ShowPageNavigate(param.PageSize, param.PageIndex, param.Total); var result = new { Data = list, NavStr = NavStr }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult CpyPackageEdit(int id, int companyId) { string type = Request["type"]; string state; Package package = PackageBll.LoadEntities(p => p.Id == id && p.CompanyId == companyId).FirstOrDefault(); if (type == "3") { state = "2"; } else { state = "3";//无需审核 } package.GameName = Request["gamename"]; package.ServerName = Request["servername"]; package.Type = Request["type"]; package.GiftName = Request["name"]; package.StartDate = DateTime.Parse(Request["startdate"]); package.EndDate = DateTime.Parse(Request["enddate"]); package.Url = Request["url"]; package.Memo = Request["memo"]; package.Msg = Request["msg"]; package.State = state; if (PackageBll.Update(package)) { return(Content("ok")); } else { return(Content("no")); } }
public ActionResult Get_CpyPackage(int limit, int offset, string gameName, DateTime?startday, DateTime?endday) { var currentCpy = GetCurrentUser(); var allCpy = CompanyBll.LoadEntities(c => c.Id > 0).Select(c => new { c.Id, c.CompanyName }); var allPackage = PackageBll.LoadEntities(p => p.Id > 0).Select(p => new { p.CompanyId, p.Type, p.EndDate, p.StartDate, p.State, p.GameName, p.GiftName, p.ServerName, p.Id }); var data = from c in allCpy join p in allPackage on c.Id equals p.CompanyId where p.CompanyId == currentCpy.Id select new { p.EndDate, p.StartDate, p.State, p.GameName, p.GiftName, p.ServerName, p.Id, c.CompanyName, p.Type }; if (!string.IsNullOrEmpty(gameName)) { data = data.Where(d => d.GameName.Contains(gameName)); } if (startday.HasValue || endday.HasValue) { endday = endday.Value.AddDays(1); data = data.Where(d => d.StartDate >= startday && d.EndDate <= endday); } var total = data.Count(); var rows = data.OrderByDescending(d => d.Id) .Skip(offset).Take(limit).ToList(); return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet)); }
public ActionResult Get_CpyOpenService(int limit, int offset, string gameName, DateTime?startday, DateTime?endday) { var currentCpy = GetCurrentUser(); var allService = OpenServiceBll.LoadEntities(s => s.Id > 0).Select(s => new { s.Id, s.PackageId, s.StartTime, s.GameName, s.State, s.ServerName, s.CompanyId, s.Rec_Hot, s.InTime }); var allpackage = PackageBll.LoadEntities(p => p.Id > 0).Select(p => new { p.Id, p.GiftName }); var data = from s in allService join p in allpackage on s.PackageId equals p.Id into ps from psi in ps.DefaultIfEmpty() where s.CompanyId == currentCpy.Id select new { s.Id, s.StartTime, s.GameName, s.State, s.ServerName, GiftName = psi != null?psi.GiftName:null, s.Rec_Hot, s.InTime }; if (!string.IsNullOrEmpty(gameName)) { data = data.Where(d => d.GameName.Contains(gameName)); } if (startday.HasValue || endday.HasValue) { endday = endday.Value.AddHours(23).AddMinutes(59).AddSeconds(59).AddMilliseconds(00); // startday = startday.Value.AddSeconds(-1); data = data.Where(d => d.StartTime >= startday && d.StartTime <= endday); } var total = data.Count(); var rows = data.OrderByDescending(d => d.InTime) .Skip(offset).Take(limit).ToList(); return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetPackage(string gameName, DateTime?startday) { var cpy = GetCurrentUser(); var data = PackageBll.LoadEntities(p => p.CompanyId == cpy.Id && p.GameName == gameName && p.StartDate <= startday && p.EndDate >= startday && (p.State == "1" || p.State == "3")).Select(p => new{ p.Id, p.GameName, p.StartDate, p.EndDate, p.ServerName, p.Type, p.GiftName }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult GetGiftBox() { int pageIndex = int.Parse(Request["pageIndex"] ?? "1"); int pageSize = int.Parse(Request["pageSize"] ?? "20"); int totalCount = 0; string type = Request["type"]; var user = GetCurrentUser(); var data = PackageBll.GerMyPackage(user, type, pageIndex, pageSize, out totalCount) .Select(p => new Package_Card() { EndDate = p.EndDate, StartDate = p.StartDate, State = p.State, GameName = p.GameName, InTime = p.InTime, Id = p.Id, Url = p.Url, Card = p.Card, GiftType = p.GiftType, GiftName = p.GiftName, }) .ToList(); var NavStr = Common.LaomaPager.ShowPageNavigate(pageSize, pageIndex, totalCount); var result = new { Data = data, NavStr = NavStr }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetpackageNumberTwo(int packageId, int userId) { Sql_PackageCode code; var result = PackageBll.GetPackageNumber(packageId, userId, out code); var data = new { data = result, code = code }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult PackageIndex() { //独家礼包 ViewData["alonePackage"] = PackageBll.PackageRecommend(6, 3); //开服礼包最新4条 ViewData["OpenServicePackage"] = PackageBll.PackageRecommend(10, 1); ViewData["ActivityCodePackage"] = PackageBll.PackageRecommend(10, 2); return(View()); }
public ActionResult PackageDetails(int id) { //礼包详情 var data = PackageBll.GetPackageDetails(id); ViewData.Model = data as PackageViewModel2; //礼包游戏同名的今天开服 ViewData["SameGameService"] = OpenServiceBll.RelatedGameService(id); ViewData["SameGamePackage"] = PackageBll.SameGamePackage(id); //同游戏的礼包 return(View()); }
public ActionResult CpyPackageDel(int id) { var currentCpy = GetCurrentUser(); if (PackageBll.CpyPackageDelete(id) > 0) { return(Content("ok")); } else { return(Content("no")); } }
public ActionResult CpyPackageEdit(int id) { // 除了卡号不能修改,其他的都可以改,提交之后,该重新审核的就重新审核,不用审核的直接过,按照原有的规则来。 var currentCpy = GetCurrentUser(); ViewData.Model = PackageBll.CpyPackageDetails(id, currentCpy) .Select(p => new Package_Card() { GiftType = p.GiftType, EndDate = p.EndDate, StartDate = p.StartDate, State = p.State, GameName = p.GameName, GiftName = p.GiftName, ServerName = p.ServerName, CompanyId = p.CompanyId, Id = p.Id, Url = p.Url, Memo = p.Memo, Msg = p.Msg, Card = p.Card }).FirstOrDefault(); List <Package_Card> list = PackageBll.CpyPackageDetails(id, currentCpy) .Select(p => new Package_Card() { GiftType = p.GiftType, EndDate = p.EndDate, StartDate = p.StartDate, State = p.State, GameName = p.GameName, GiftName = p.GiftName, ServerName = p.ServerName, CompanyId = p.CompanyId, Id = p.Id, Url = p.Url, Memo = p.Memo, Msg = p.Msg, Card = p.Card }).ToList(); ViewData["currentAllCode"] = list; ViewBag.allCountCode = list.Count(); return(View()); }
public ActionResult SeeCpyPackageDetail(int id) { // 礼包表和礼包卡号表连接查询、并且礼包不仅对应自己的id,也要对应当前厂商的id var currentCpy = GetCurrentUser(); ViewData.Model = PackageBll.CpyPackageDetails(id, currentCpy) .Select(p => new Package_Card() { GiftType = p.GiftType, EndDate = p.EndDate, StartDate = p.StartDate, State = p.State, GameName = p.GameName, GiftName = p.GiftName, ServerName = p.ServerName, CompanyId = p.CompanyId, Id = p.Id, Url = p.Url, Memo = p.Memo, Msg = p.Msg, Card = p.Card }).FirstOrDefault(); List <Package_Card> list = PackageBll.CpyPackageDetails(id, currentCpy) .Select(p => new Package_Card() { GiftType = p.GiftType, EndDate = p.EndDate, StartDate = p.StartDate, State = p.State, GameName = p.GameName, GiftName = p.GiftName, ServerName = p.ServerName, CompanyId = p.CompanyId, Id = p.Id, Url = p.Url, Memo = p.Memo, Msg = p.Msg, Card = p.Card }).ToList(); ViewData["currentAllCode"] = list; ViewBag.allCountCode = list.Count(); return(View()); }
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 PackageHot() { var data = PackageBll.PackageHot(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult GetpackageNumber(int packageId, int userId) { var data = PackageBll.GetPackageNumber(packageId, userId); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult AddPackage() { var currentCpy = GetCurrentUser(); string type = Request["type"]; string state; if (type == "3")//独家礼包要审核的 { state = "2"; } else { state = "3"; } Package package = new Package(); package.CompanyId = currentCpy.Id; package.GameName = Request["gamename"]; package.ServerName = Request["servername"]; package.Type = Request["type"]; package.GiftName = Request["name"]; package.StartDate = DateTime.Parse(Request["startdate"]); package.EndDate = DateTime.Parse(Request["enddate"]); package.Url = Request["url"]; package.Memo = Request["memo"]; package.Msg = Request["msg"]; package.State = state; package.Rec = "0"; package.Rec_Hot = "0"; package.Rec_Index = "0"; package.Rec_Hot_Time = DateTime.Now; package.Rec_Time = DateTime.Now; package.Rec_Index_Time = DateTime.Now; package.InTime = DateTime.Now; if (PackageBll.Add(package) != null) { //如果不为空、拿到其添加的id 据研究db.saveChange()后、EF会返回最新的自增id //拆分字符串、拆分成一个一个逐个添加。 string code = Request["code"]; string[] splitCode = code.Trim().Split('\n'); PackageCard card = null; for (int i = 0; i < splitCode.Length; i++) { card = new PackageCard(); card.PackageId = package.Id; card.UserId = 0; card.InTime = DateTime.Now; if (splitCode[i] == "" || splitCode[i] == null) { continue; } card.Code = splitCode[i]; PackageCardBll.Add(card); } return(Content("ok")); } else { return(Content("no")); } }