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