public ActionResult OpenServiceDel(int id)
{
var cpy = GetCurrentUser();
OpenService op = new OpenService()
{
Id = id,
CompanyId = cpy.Id
};
//先删开服表
if (OpenServiceBll.Delete(op))
{
//归还条数
if (OpenServiceBll.ReturnServiceNum(id, cpy.Id))
{
return(Content("ok,恭喜：删除成功！条数已归还！"));
}
else
{
return(Content("no,提示：开服表删除成功！条数归还失败！"));
}
}
else
{
return(Content("no,开服表删除失败！"));
}
}
public ActionResult ServiceSearch(string key)
{
TempData["Key"] = key;
Guid serviceKey = Guid.NewGuid();
object obj = Common.CacheHelper.Get(serviceKey.ToString());
List <ServiceViewModel> list = null;
if (obj == null)
{
list = OpenServiceBll.GetServiceSearchData(key).Select(s => new ServiceViewModel()
{
Id = s.Id,
GameName = s.GameName,
ServerName = s.ServerName,
StartTime = s.StartTime,
GiftName = s.GiftName,
SystemName = s.SystemName,
Url = s.Url,
Type = s.Type,
PackageCardCount = s.PackageCardCount
}).ToList();
if (list != null)
{
Common.CacheHelper.WriteCache(serviceKey.ToString(), list, DateTime.Now.AddMinutes(10));
}
}
else
{
list = obj as List <ServiceViewModel>;
}
ViewBag.ServiceFind = list;
return(View());
}
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 JsonResult GetExpenseDetail(int limit, int offset, string gameName, DateTime?startday, DateTime?endday)
{
//
string guid = Request["cpyUserId"];
//从分布式缓存拿出来的对象不能进行延迟加载。
var currentCpy = Common.CacheHelper.Get(guid) as Company;
var Rused = RechargedUsedBll.LoadEntities(ru => true);
var recharge = RechargeBll.LoadEntities(r => r.Id > 0);
var service = OpenServiceBll.LoadEntities(s => s.Id > 0);
var data = from ru in Rused
join r in recharge on ru.RechargeId equals r.Id
join s in service on ru.OpenServiceId equals s.Id
where r.CompanyId == s.CompanyId && r.CompanyId == currentCpy.Id
//intime 消费日期 buytime购买日期, BuyTime = r.InTime
select new { InTime = ru.InTime, Id = s.Id, GameName = s.GameName, ServerName = s.ServerName, StartTime = s.StartTime, BuyTime = r.InTime, Rec_hot = s.Rec_Hot };
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.InTime >= startday && d.InTime <= endday);
}
var rows = data.OrderByDescending(d => d.InTime)
.Skip(offset).Take(limit).ToList();
return(Json(new { total = data.Count(), rows = rows }, JsonRequestBehavior.AllowGet));
}
public ActionResult ServiceIndex()
{
//当天开服总数
ViewBag.AllServiceCount = OpenServiceBll.allCount();
ViewBag.AllService = OpenServiceBll.GetAllServiceInfo(1, "2");
ViewBag.TopService = OpenServiceBll.GetAllServiceInfo(200, "1");
return(View());
}
public ActionResult SendPackage()
{
//-----------------查出当前厂商曾经发布过的礼包游戏---------------------------
var currentCpy = GetCurrentUser();
var goGame = OpenServiceBll.MyHistoryGameName(currentCpy.Id);
ViewBag.goGame = goGame;
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());
}
/// <summary>
/// 厂商详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult CpyDetails(int id)
{
int gameCount = 0;
ViewData.Model = CompanyBll.GetCpyDetails(id, out gameCount);
ViewBag.gameCount = gameCount;
//厂商相关的新游、热游、手游新闻
ViewBag.CurrentCpyNews = CompanyBll.CurrentCpyNews(id);
//当前厂商相关开服
ViewBag.CurrentCpyService = OpenServiceBll.CurrentCpyService(id);
//当前厂商礼包
ViewBag.Package = CompanyBll.CurrnetCpyPackage(id);
ViewData["advert"] = AdvertisementBll.GetAllTypeAdvert("3", 2);
return(View());
}
public ActionResult SeeCpyServersDetail(int id)
{
var currentCpy = GetCurrentUser();
ViewData.Model = OpenServiceBll.GetCpyServiceDetail(id, currentCpy)
.Select(s => new OpenService_Package
{
Id = s.Id,
companyId = s.companyId,
StartDate = s.StartDate,
GameName = s.GameName,
ServerName = s.ServerName,
GiftName = s.GiftName != null?s.GiftName:null,
Rec_Hot = s.Rec_Hot,
Url = s.Url
}).FirstOrDefault();
return(View());
}
public ActionResult ServiceEdit(int id, int companyId)
{
var op = OpenServiceBll.LoadEntities(s => s.Id == id && s.CompanyId == companyId).FirstOrDefault();
op.GameName = Request["gamename"];
op.ServerName = Request["serverName"];
op.Url = Request["url"];
op.PackageId = int.Parse(Request["packageId"].ToString());
op.Rec_Hot = Request["rec_hot"];
op.State = "2";
op.StartTime = DateTime.Parse(Request["starttime"]);
if (OpenServiceBll.Update(op))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
public ActionResult ServiceEdit(int id)
{
var currentCpy = GetCurrentUser();
var goGame = OpenServiceBll.MyHistoryGameName(currentCpy.Id);
ViewBag.goGame = goGame;
ViewData.Model = OpenServiceBll.GetCpyServiceDetail(id, currentCpy)
.Select(s => new OpenService_Package
{
Id = s.Id,
companyId = s.companyId,
StartDate = s.StartDate,
GameName = s.GameName,
ServerName = s.ServerName,
GiftName = s.GiftName,
Rec_Hot = s.Rec_Hot,
Url = s.Url
}).FirstOrDefault();
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 AddOpenService()
{
var currenCpy = GetCurrentUser();
string type = Request["rec_hot"];
OpenService service = new OpenService()
{
CompanyId = currenCpy.Id,
GameName = Request["gamename"],
ServerName = Request["serverName"],
Url = Request["url"],
PackageId = int.Parse(Request["packageId"].ToString()),
Rec_Hot = Request["rec_hot"],
InTime = DateTime.Now,
Rec_Datetime = DateTime.Now,
State = "2",
CheckName = null,
StartTime = DateTime.Parse(Request["starttime"])
};
Recharge recharge;
if (type == "2")//全天开服
{
recharge = RechargeBll.LoadEntities(r => r.CompanyId == currenCpy.Id && r.Num > r.Used && r.ComboName == "全天置顶").OrderBy(r => r.InTime).FirstOrDefault();
if (recharge == null)
{
return(Content("noNum,全天开服点数不足，请先充值"));
}
if (OpenServiceBll.Add(service) != null)
{
RechargedUsed ru = new RechargedUsed()
{
RechargeId = recharge.Id, OpenServiceId = service.Id, InTime = DateTime.Now
};
RechargedUsedBll.Add(ru);
recharge.Used = recharge.Used + 1;
RechargeBll.Update(recharge);
return(Content("ok"));
}
else
{
return(Content("no"));
}
}//置顶开服
else if (type == "1")
{
recharge = RechargeBll.LoadEntities(r => r.CompanyId == currenCpy.Id && r.Num > r.Used && r.ComboName != "全天置顶").OrderBy(r => r.InTime).FirstOrDefault();
if (recharge == null)
{
return(Content("noNum,点数不足，请先充值"));
}
if (OpenServiceBll.Add(service) != null)
{
RechargedUsed ru = new RechargedUsed()
{
RechargeId = recharge.Id, OpenServiceId = service.Id, InTime = DateTime.Now
};
RechargedUsedBll.Add(ru);
recharge.Used = recharge.Used + 1;
RechargeBll.Update(recharge);
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
else
{
return(Content("typeError,提示：请先选择开服类型"));
}
}
public List <Sql_OpenServer> _RightTopService()
{
var topService = OpenServiceBll.IndexCurrntService("1", 200);
return(topService);
}
public List <Sql_OpenServer> AllDayService()
{
var allDayservice = OpenServiceBll.IndexCurrntService("2", 50);
return(allDayservice == null?null:allDayservice);
}
