// 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("数据删除成功"); }