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