public string DeleteFlightMsg(int detailflight_id)
{
FlightListModels flightList = new FlightListModels();
//建立Flight Model列表
List <FlightModels> flightArray = new List <FlightModels>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取detail_airline数据表中的所有数据
string delete = String.Format("delete from detail_airline where id = \'{0}\'", detailflight_id);
MySqlCommand comm = new MySqlCommand(delete, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return("数据删除成功");
}
public string ChangeFlightMsg(int flight_id, int detailflight_id, DateTime departure_time, DateTime arrive_time)
{
FlightListModels flightList = new FlightListModels();
//建立Flight Model列表
List <FlightModels> flightArray = new List <FlightModels>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取detail_airline数据表中的所有数据
string change = String.Format("update Flightinfo1 set departure_time = \'{2}\',arrive_time=\'{3}\' where id=\'{0}\' and id1 = \'{1}\'", flight_id, detailflight_id, departure_time, arrive_time);
MySqlCommand comm = new MySqlCommand(change, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return("数据修改成功");
}
public string AddFlightMsg(int flight_id, int detail_airlineid, DateTime departure_time, DateTime arrive_time, int total_airlineid)
{
FlightListModels flightList = new FlightListModels();
//建立Flight Model列表
List <FlightModels> flightArray = new List <FlightModels>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取detail_airline数据表中的所有数据
// string select = String.Format("select flight_num from Flightinfo1 where id=\'{0}\'",flight_id);
string add = String.Format("insert into detail_airline(id,departure_time,arrive_time,flight_id,total_airline_id) values (\'{0}\', \'{1}\',\'{2}\',\'{3}\',\'{4}\')", detail_airlineid, departure_time, arrive_time, flight_id, total_airlineid);
MySqlCommand comm = new MySqlCommand(add, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return("数据新增成功");
}
// GET: 绑定航班信息管理页面的视图
public ActionResult FlightInfo()
{
FlightListModels flightList = new FlightListModels();
//建立FlightModel列表
List <FlightModels> flightArray = new List <FlightModels>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取flight、detail_airline、plane、company、total_airline、city数据表中的相关数据
// String flightMsg = String.Format("SELECT flight.id,flight_num,departure_time,arrive_time,city1.city_name,city2.city_name,company.company_name FROM flight, detail_airline, city city1, city city2, company, plane, total_airline WHERE flight.id = detail_airline.flight_id AND detail_airline.total_airline_id = total_airline.id AND total_airline.set_out_city_id = city1.id AND total_airline.arrive_city_id = city2.id AND flight.plane_id = plane.id AND plane.company_id = company.id; ");
String flightMsg = String.Format("select * from Flightinfo1");
MySqlCommand comm = new MySqlCommand(flightMsg, conn);
//创建和初始化数据适配器DataAdapter
MySqlDataAdapter flightAdapter = new MySqlDataAdapter(flightMsg, conn);
//创建DataSet对象
DataSet flightDataSet = new DataSet();
try
{
conn.Open();
flightAdapter.Fill(flightDataSet, "flight"); //将DataSet起名为flight
//使用DataTable来提取DataSet表中的数据
DataTable flightDataTable = flightDataSet.Tables["flight"];
foreach (DataRow dr in flightDataTable.Rows)
{
foreach (DataColumn dc in flightDataTable.Columns)
{
Console.WriteLine("{0}\t", dr[dc]);
}
Console.WriteLine();
}
//将DataTable中的数据赋值到List之中
for (int row = 0; row < flightDataTable.Rows.Count; row++)
{
FlightModels flight = new FlightModels();
flight.Flight_id = Convert.ToInt16(flightDataTable.Rows[row]["id"]); //航班ID
flight.detail_airlineid = Convert.ToInt16(flightDataTable.Rows[row]["id1"]); //ID1
flight.Flight_num = flightDataTable.Rows[row]["flight_num"].ToString(); //航班号
flight.Departure_time = Convert.ToDateTime(flightDataTable.Rows[row]["departure_time"]); //出发时间
flight.Arrive_time = Convert.ToDateTime(flightDataTable.Rows[row]["arrive_time"]); //到达时间
flight.Departure_city = flightDataTable.Rows[row]["departureCity_name"].ToString(); //出发城市
flight.Arrive_city = flightDataTable.Rows[row]["arriveCity_name"].ToString(); //到达城市
flight.FlightCompany_name = flightDataTable.Rows[row]["companyName"].ToString(); //公司名称
flightArray.Add(flight);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
ViewData["error"] = ex.Message;
}
finally
{
flightList.FlightModelsArray = flightArray;
conn.Close();
}
return(View(flightList));
}
