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);
}
}
