public ActionResult FlightInformation()
{
List <TFlightTime> Flights = new List <TFlightTime>();
//TFlightTime obj = new TFlightTime();
//SelectReturn sr = DataBaseAccess.GetAllTInfo(obj);
//List<object> list = sr.list;//object
//List<string> value = sr.value;//值
Actions a = new Actions();
List <FLIGHTIME> flightTimes = a.GetFlightTime("东方航空公司");
foreach (FLIGHTIME item in flightTimes)
{
TFlightTime flight = new TFlightTime();
flight.f_id = item.F_ID;
flight.t_airport = item.T_AIRPORT;
flight.t_terminal = item.T_TERMINAL;
flight.ex_takeoff_time = item.EX_TAKEOFF_TIME.ToString();
flight.ex_land_time = item.EX_LAND_TIME.ToString();
flight.re_takeoff_time = null;
flight.re_land_time = null;
flight.l_airport = item.L_AIRPORT;
flight.l_termnal = item.L_TERMNAL;
Flights.Add(flight);
}
return(View("FlightInformation", Flights));
}
public ActionResult GetFlightInfo(string id, int capacity)
{
//需要在此函数中传回一个数组,为了方便先传递一个list
Seat obj = new Seat(id); //定义Flight_ID为id的航班上的一个座位
List <string> needs = new List <string>(); //查询的数据需求,此处时座位号
needs.Add("Seat_Number");
List <string> res = new List <string>(); //查询结果
res = DataBaseAccess.GetSingleInfo(obj, needs);
int[] SeatArray = new int[capacity];
for (int i = 0; i < capacity; i++) //初始化
{
SeatArray[i] = int.MinValue;
}
for (int i = 0; i < res.Count; i++)
{
if (res[i] != "")
{
SeatArray[int.Parse(res[i]) - 1] = 0;
}
}
//数组,航班号,出发地点(机场,航站楼),出发时间,票价
//机场,航站楼,出发时间
TFlightTime objsingle = new TFlightTime(id);
List <string> needssingle = new List <string>();
needssingle.Add("T_Airport");
needssingle.Add("T_Terminal");
needssingle.Add("Ex_TakeOff_Time");
List <string> ressingle = new List <string>();
ressingle = DataBaseAccess.GetSingleInfo(objsingle, needssingle);
//
//票价
Flight objflight = new Flight(id);
List <string> needvalue = new List <string>();
needvalue.Add("Value");
List <string> resvalue = new List <string>();
resvalue = DataBaseAccess.GetSingleInfo(objflight, needvalue);
//
List <string> all = new List <string>();
//
all.Add(id);
foreach (string str in ressingle)
{
all.Add(str);
}
all.Add(resvalue[0]);
//
FlightSelectReturn data = new FlightSelectReturn(SeatArray, all);
return(View("Flight", data));
}
