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"));
}
}
