Ticket/Controllers/TrainNumberController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Ticket.Model.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.IO;
using Gym.Model.Tools;
using System.Data;

namespace Ticket.Model.Controllers
{
    public class TrainNumberController : Controller
    {
        public ActionResult Index()
        {
            return View();
        }

        public ActionResult UserIndex()
        {
            return View();
        }

        public JsonResult GetData(int page, int rows, string sort, string order,
            string departure, string arrvial, DateTime? offTime)
        {
            int skip = (page - 1) * rows;
            var ctx = new TicketContext();
            var records = ctx.TrainNumbers.AsEnumerable();

            var result = from p in ctx.TrainTickets.AsEnumerable()
                         group p by p.TrainNumberId into g
                         select new
                         {
                             g.Key,
                             SumValue = g.Sum(p => p.OrderNum)
                         };
            if (!string.IsNullOrEmpty(departure))
            {
                records = records.Where(c => c.Departure.Contains(departure));
            }
            if (!string.IsNullOrEmpty(arrvial))
            {
                records = records.Where(c => c.Arrival.Contains(arrvial));
            }
            if (offTime != null)
            {
                records = records.Where(c => c.GoOff >=
                Convert.ToDateTime(offTime.Value.ToString("yyyy-MM-dd 00:00:00"))
                &&
                c.GoOff < Convert.ToDateTime(offTime.Value.AddDays(1).ToString("yyyy-MM-dd 00:00:00")));
            }
            if (string.IsNullOrEmpty(sort))
            {
                sort = "GoOff";
                order = "desc";
            }
            var total = records.Count();
            records = records.OrderBy(c => c.Id).Skip(skip).Take(rows).ToList();