private void frmLineRUD_Load(object sender, EventArgs e) { lineList = agent.GetLines(); cityList = agent.GetCityList(); foreach (var line in lineList) { line.remainSeat = agent.GetLineRemainSeat(line.id); } dataView.Rows.Clear(); foreach (var line in lineList) { string depCity = string.Empty; string arrCity = string.Empty; foreach (var city in cityList) { if (city.cityId.Equals(line.depCity.ToString())) { depCity = city.cityName; } if (city.cityId.Equals(line.arrCity.ToString())) { arrCity = city.cityName; } } dataView.Rows.Add(line.id.ToString(), line.trainNum, depCity, arrCity, line.price.ToString(), line.depDate.ToString(), line.arrDate.ToString(), line.remainSeat.ToString()); } }
public frmLineModify(LineDataBean line) { InitializeComponent(); agent = SQLAgent.GetInstance(); cityList = agent.GetCityList(); foreach (var city in cityList) { cmbDep.Items.Add(city.cityName); cmbArr.Items.Add(city.cityName); if (city.cityId.Equals(line.depCity.ToString())) { cmbDep.Text = city.cityName; } if (city.cityId.Equals(line.arrCity.ToString())) { cmbArr.Text = city.cityName; } } id = line.id; txtNum.Text = line.trainNum; txtPrice.Text = line.price.ToString(); dateArr.Value = line.arrDate; dateDep.Value = line.depDate; }
private void frmModifyCity_Load(object sender, EventArgs e) { cityList = agent.GetCityList(); dataView.Rows.Clear(); for (int i = 0; i < cityList.Count; i++) { dataView.Rows.Add(cityList[i].cityId, cityList[i].cityName); } }
private void frmDeleteCity_Load(object sender, EventArgs e) { cityList = agent.GetCityList(); cmbCity.Items.Clear(); foreach (var i in cityList) { cmbCity.Items.Add(i.cityName); } }
private void frmAddCity_Load(object sender, EventArgs e) { try { cityList = agent.GetCityList(); } catch (Exception ex) { MessageBox.Show("FATAL Error\n" + ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void frmViewCity_Load(object sender, EventArgs e) { SQLAgent agent = SQLAgent.GetInstance(); List <CityDataBean> cityList = agent.GetCityList(); dataView.Columns.Add("city_id", "城市ID"); dataView.Columns.Add("city_name", "城市名称"); for (int i = 0; i < cityList.Count; i++) { dataView.Rows.Add(cityList[i].cityId, cityList[i].cityName); } }
private void frmAdd_Load(object sender, EventArgs e) { try { cityList = agent.GetCityList(); foreach (var bean in cityList) { cmbDep.Items.Add(bean.cityName); cmbArr.Items.Add(bean.cityName); } } catch (Exception ex) { MessageBox.Show("FATAL Error\n" + ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }