航班表格数据的初始化

开发工具与关键技术：Visual Studio 2015
作者：杨镇虹
撰写时间：2019.06.23
一、航班表格数据的初始化
public ActionResult selectFlight()//控制器名称selectFlight
{
// 嵌套子查询 航班表 自定义名称list from 航班表tbPlaneFlights in 数据库myModel里面的航班表HB_PlaneFlights
List list = (from tbPlaneFlights in myModel.HB_PlaneFlights
// join 航班ID tbPlaneFlightsID in 数据库myModel的航班表HB_PlaneFlights on 航班表tbPlaneFlights的航班ID PlaneFlightsID 等于equals 这个表tbPlaneFlightsID的航班ID PlaneFlightsID
join tbPlaneFlightsID in myModel.HB_PlaneFlights on tbPlaneFlights.PlaneFlightsID equals tbPlaneFlightsID.PlaneFlightsID
// join 自定义的机型表tbAircraftType in 数据库myModel里面的机型表HB_AircraftType on 航班表tbPlaneFlights的机型ID AircraftTypeID 等于equals 机型表tbAircraftType的机型ID AircraftTypeID
join tbAircraftType in myModel.HB_AircraftType on tbPlaneFlights.AircraftTypeID equals tbAircraftType.AircraftTypeID
// join 自定义的出了城市tbDepartureCity in 数据库myModel里面的城市表HB_CityTable on 航班表tbPlaneFlights的出发城市ID DepartureCityID 等于equals 出发城市tbDepartureCity的城市ID CityID
join tbDepartureCity in myModel.HB_CityTable on tbPlaneFlights.DepartureCityID equals tbDepartureCity.CityID
// join 自定义的到达城市tbArrivalCity in 数据库myModel里面的城市表HB_CityTable on 航班表tbPlaneFlights的 到达城市ArrivalCityID 等于equals 到达城市tbArrivalCity的城市ID CityID
join tbArrivalCity in myModel.HB_CityTable on tbPlaneFlights.ArrivalCityID equals tbArrivalCity.CityID
//orderby 排序 按航班表tbPlaneFlights的航班ID PlaneFlightsID排序
orderby tbPlaneFlights.PlaneFlightsID
//查询select new 航班表的实体类PlaneFlightsVo
select new PlaneFlightsVo
{
PlaneFlightsID = tbPlaneFlights.PlaneFlightsID,//航班ID
AircraftTypeID = tbPlaneFlights.AircraftTypeID,//机型ID
ArrivalCityID = tbPlaneFlights.ArrivalCityID,//到达城市ID
DepartureCityID = tbPlaneFlights.DepartureCityID,//出发城市ID
DepartureCity = tbDepartureCity.CityName,//出发城市
ArrivalCity = tbArrivalCity.CityName,//到达城市
AircraftName = tbAircraftType.AircraftName,//机型
ServeMeals = tbPlaneFlights.ServeMeals,//配餐
DepartureTime = tbPlaneFlights.DepartureTime,//出发时间
ArrivalTime = tbPlaneFlights.ArrivalTime,//到达时间
//查询飞机舱位人数表 from 自定义的名称这个代表飞机舱位人数表tbAircraftCabinNumber in 数据库myModel里面的 飞机舱位人数表HB_AircraftCabinNumber
AircraftCabinNumber = (from tbAircraftCabinNumber in myModel.HB_AircraftCabinNumber
// join 自定义的舱位类型表tbCabinType in 数据库myModel里面的舱位类型表HB_CabinType on 飞机舱位人数表HB_AircraftCabinNumber的舱位类型ID CabinTypeID 等于equals 舱位类型表tbCabinType的舱位类型ID CabinTypeID
join tbCabinType in myModel.HB_CabinType on tbAircraftCabinNumber.CabinTypeID equals tbCabinType.CabinTypeID
//where条件查询 飞机舱位人数表tbAircraftCabinNumber 的航班ID PlaneFlightsID 等于 航班表tbPlaneFlights的航班ID PlaneFlightsID
where tbAircraftCabinNumber.PlaneFlightsID == tbPlaneFlights.PlaneFlightsID
// orderby列表排序 跟据飞机舱位人数表tbAircraftCabinNumber的舱位类型ID CabinTypeID排序
orderby tbAircraftCabinNumber.CabinTypeID
// select查询 new 飞机舱位人数表的实体类AircraftCabinNumberVo
select new AircraftCabinNumberVo
{
AircraftCabinNumberID = tbAircraftCabinNumber.AircraftCabinNumberID,//飞机舱位人数ID
PlaneFlightsID = tbAircraftCabinNumber.PlaneFlightsID,//航班ID
CabinTypeID = tbAircraftCabinNumber.CabinTypeID,//舱位类型ID
CabinName = tbCabinType.CabinName,//舱位名称
}).ToList(),
//查询票价表Fares from 自定义的票价表tbFares in 数据库myModel里面的票价表HB_Fares
Fares = (from tbFares in myModel.HB_Fares
// join 自定义的舱位类型表tbCabinType in 数据库myModel里面的 舱位类型表HB_CabinType on 票价表tbFares的舱位类型ID CabinTypeID 等于equals 舱位类型表tbCabinType的舱位类型ID CabinTypeID
join tbCabinType in myModel.HB_CabinType on tbFares.CabinTypeID equals tbCabinType.CabinTypeID
//where条件查询 票价表tbFares的航班ID PlaneFlightsID 等于 航班表tbPlaneFlights的航班ID PlaneFlightsID
where tbFares.PlaneFlightsID == tbPlaneFlights.PlaneFlightsID
select new FaresVo {
PlaneFlightsID = tbFares.PlaneFlightsID,//航班ID
CabinTypeID = tbFares.CabinTypeID,//舱位类型ID
FaresID = tbFares.FaresID,//票价ID
Fares = tbFares.Fares,//票价
}).ToList(),
}).ToList();
//封装数据
LayuiTableData layuiTableDate = new LayuiTableData
{
count = list.Count(),
data = list,
};
//返回数据
return Json(layuiTableDate, JsonRequestBehavior.AllowGet);
}