// GET: 绑定机场名称设置页面的视图
public ActionResult airportname_set()
{
CityListModels cityList = new CityListModels();
//建立City Model列表
List <City> cityArray = new List <City>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取City数据表中的所有数据
string cityMsg = String.Format("select * from city");
MySqlCommand comm = new MySqlCommand(cityMsg, conn);
//创建和初始化数据适配器DataAdapter
MySqlDataAdapter cityAdapter = new MySqlDataAdapter(cityMsg, conn);
//创建DataSet对象
DataSet cityDataSet = new DataSet();
try
{
conn.Open();
cityAdapter.Fill(cityDataSet, "city"); //将DataSet起名为city
//使用DataTable来提取DataSet表中的数据
DataTable cityDataTable = cityDataSet.Tables["city"];
//将DataTable中的数据赋值到List之中
for (int row = 0; row < cityDataTable.Rows.Count; row++)
{
City city = new City();
city.CityId = Convert.ToInt16(cityDataTable.Rows[row]["id"]);
city.CityName = cityDataTable.Rows[row]["city_name"].ToString();
city.AirportName = cityDataTable.Rows[row]["airport_name"].ToString();
cityArray.Add(city);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
cityList.CityArray = cityArray;
conn.Close();
}
return(View(cityList));
}
public string ChangeCityMsg(string airportID, string airportName)
{
CityListModels cityList = new CityListModels();
//建立City Model列表
List <City> cityArray = new List <City>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取City数据表中的所有数据
string change = String.Format("update city set airport_name = \'{1}\' where id = \'{0}\'", airportID, airportName);
MySqlCommand comm = new MySqlCommand(change, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return("数据修改成功");
}
public string AddCityMsg(string airportname, string cityname)
{
CityListModels cityList = new CityListModels();
//建立City Model列表
List <City> cityArray = new List <City>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取City数据表中的所有数据
string add = String.Format("insert into city (airport_name, city_name) values (\'{0}\', \'{1}\')", airportname, cityname);
MySqlCommand comm = new MySqlCommand(add, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return("数据新增成功");
}
public string DeleteCityMsg(string airportID)
{
CityListModels cityList = new CityListModels();
//建立City Model列表
List <City> cityArray = new List <City>();
//连接数据库
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "Server=localhost;Database=ticket;User ID=admin;Password=admin;port=3306;CharSet=utf8;pooling=true;SslMode=None;";
//获取City数据表中的所有数据
string delete = String.Format("delete from city where id = \'{0}\'", airportID);
MySqlCommand comm = new MySqlCommand(delete, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return("数据删除成功");
}
