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