public IActionResult TicketQueryDetails(TicketQueryDetail ticketQuery) { var t = _ticketRepository.GetAllTiceketsByItems(ticketQuery).ToList(); foreach (var item in t) { switch (item.Paypath) { case "0": item.Paypath = TicketPaypath.微信.ToString(); break; case "1": item.Paypath = TicketPaypath.支付宝.ToString(); break; case "2": item.Paypath = TicketPaypath.现票.ToString(); break; } } ViewBag.number = t.Sum(n => n.Number).ToString(); ViewBag.summoeny = t.Sum(n => n.SumMoneny); TicketQueryDetail ticketQueryDetail = new TicketQueryDetail() { tickets = t, ticketQueries = ticketQuery.ticketQueries }; return(View(ticketQueryDetail)); }
public IActionResult Index() { TicketQueryDetail ticketQueryDetail = new TicketQueryDetail() { tickets = new List <Ticket>() { new Ticket() { } }, ticketQueries = null }; return(View(ticketQueryDetail)); }
public IEnumerable <Ticket> GetAllTiceketsByItems(TicketQueryDetail ticketQuery) { var reslut = (IEnumerable <Ticket>)_mycontext.Tickets; if (true) { reslut = reslut.Where(t => t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && t.CreateTime <= ticketQuery.ticketQueries[0].endTime); } if (!ticketQuery.ticketQueries[0].Colour.Contains("全部")) { reslut = reslut.Where(t => t.Colour == ticketQuery.ticketQueries[0].Colour); } if (!ticketQuery.ticketQueries[0].Paypath.Contains("全部")) { reslut = reslut.Where(t => t.Paypath == ticketQuery.ticketQueries[0].Paypath); } if (!ticketQuery.ticketQueries[0].Type.Contains("全部")) { reslut = reslut.Where(t => t.Type == ticketQuery.ticketQueries[0].Type); } return(reslut); //if (ticketQuery.ticketQueries[0].Colour.Contains("全部") && // ticketQuery.ticketQueries[0].Paypath.Contains("全部") && ticketQuery.ticketQueries[0].Type.Contains("全部")) //{ // return _mycontext.Tickets.Where(t => // t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && // t.CreateTime <= ticketQuery.ticketQueries[0].endTime); //} //else if (!ticketQuery.ticketQueries[0].Colour.Contains("全部") && // ticketQuery.ticketQueries[0].Paypath.Contains("全部") && // ticketQuery.ticketQueries[0].Type.Contains("全部")) //{ // return _mycontext.Tickets.Where(t => // t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && // t.CreateTime <= ticketQuery.ticketQueries[0].endTime && // t.Colour == ticketQuery.ticketQueries[0].Colour); //} //else if (!ticketQuery.ticketQueries[0].Colour.Contains("全部") && // !ticketQuery.ticketQueries[0].Paypath.Contains("全部") && // ticketQuery.ticketQueries[0].Type.Contains("全部")) //{ // return _mycontext.Tickets.Where(t => // t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && // t.CreateTime <= ticketQuery.ticketQueries[0].endTime && // t.Colour == ticketQuery.ticketQueries[0].Colour && // t.Paypath == ticketQuery.ticketQueries[0].Paypath); //} //else if (!ticketQuery.ticketQueries[0].Colour.Contains("全部") && // !ticketQuery.ticketQueries[0].Paypath.Contains("全部") && // !ticketQuery.ticketQueries[0].Type.Contains("全部")) //{ // return _mycontext.Tickets.Where(t => // t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && // t.CreateTime <= ticketQuery.ticketQueries[0].endTime && // t.Colour == ticketQuery.ticketQueries[0].Colour && // t.Paypath == ticketQuery.ticketQueries[0].Paypath && t.Type == ticketQuery.ticketQueries[0].Type); //} //else if (ticketQuery.ticketQueries[0].Colour.Contains("全部") && // !ticketQuery.ticketQueries[0].Paypath.Contains("全部") && // !ticketQuery.ticketQueries[0].Type.Contains("全部")) //{ // return _mycontext.Tickets.Where(t => // t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && // t.CreateTime <= ticketQuery.ticketQueries[0].endTime // && t.Paypath == ticketQuery.ticketQueries[0].Paypath && // t.Type == ticketQuery.ticketQueries[0].Type); //} //else if (ticketQuery.ticketQueries[0].Colour.Contains("全部") && // ticketQuery.ticketQueries[0].Paypath.Contains("全部") && // !ticketQuery.ticketQueries[0].Type.Contains("全部")) //{ // return _mycontext.Tickets.Where(t => // t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && // t.CreateTime <= ticketQuery.ticketQueries[0].endTime // && t.Type == ticketQuery.ticketQueries[0].Type); //} //else //{ //// return _mycontext.Tickets.Where(t => //// t.CreateTime >= ticketQuery.ticketQueries[0].StarTime && //// t.CreateTime <= ticketQuery.ticketQueries[0].endTime && //// t.Colour == ticketQuery.ticketQueries[0].Colour && t.Paypath == ticketQuery.ticketQueries[0].Paypath); ////} }