FJDPXT202002/Areas/OthersMaintenance/Controllers/FlightMaintainController.cs

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

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

using FJDPXT202002.EntityClass;
using FJDPXT202002.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Transactions;
using System.Web;
using System.Web.Mvc;

namespace FJDPXT202002.Areas.OthersMaintenance.Controllers
{
    public class FlightMaintainController : Controller
    {
        // GET: OthersMaintenance/FlightMaintain
        //其他：航班维护
        Models.FJDPXTEntities myModel = new Models.FJDPXTEntities();
        public ActionResult Index()
        {
            List<S_Airport> airports = myModel.S_Airport.ToList();
            List<S_CabinType> cabinTypes = myModel.S_CabinType.OrderByDescending(o => o.discountRate).ToList();
            List<S_PlanType> planTypes = myModel.S_PlanType.ToList();
            ViewBag.airports = airports;
            ViewBag.cabinTypes = cabinTypes;
            ViewBag.planTypes = planTypes;
            return View();
        }
        public ActionResult CreateFlightAuto()
        {
            //清除session记录
            Session.Remove("flightCreateResults");
            Session.Remove("insertFlights");
            return View();
        }
        /// <summary>
        ///  多条件分页查询航班数据
        /// </summary>
        /// <param name="layuiTablePage"></param>
        /// <param name="orangeAirportID"></param>
        /// <param name="destinationAirportID"></param>
        /// <param name="flightDateLimit"></param>
        /// <returns></returns>
        public ActionResult SelectFlight(LayuiTablePage layuiTablePage,int? orangeAirportID, int? destinationAirportID,string flightDateLimit)
        {
            var queryLinq = from tbFlight in myModel.S_Flight
                            join orangeAirport in myModel.S_Airport on tbFlight.orangeID equals orangeAirport.airportID
                            join destinationAirport in myModel.S_Airport on tbFlight.destinationID equals destinationAirport.airportID
                            join tbPlanType in myModel.S_PlanType on tbFlight.planTypeID equals tbPlanType.planTypeID
                            select new FlightVo
                            {
                                flightID=tbFlight.flightID,//航班ID
                                orangeID=tbFlight.orangeID,////起飞机场ID
                                destinationID =tbFlight.destinationID,
                                flightCode=tbFlight.flightCode, //航班号
                                flightDate =tbFlight.flightDate,//起飞日期
                                flightDateStr=tbFlight.flightDate.ToString(),
                                departureTime =tbFlight.departureTime,//起飞时间
                                arrivalTime =tbFlight.arrivalTime,//降落时间
                                planTypeID =tbFlight.planTypeID,//飞机机型ID
                                standardPrice =tbFlight.standardPrice,//标准价格