溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
本篇內容介紹了“C#如何實現航班預訂系統”的有關知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓小編帶領大家學習一下如何處理這些情況吧！希望大家仔細閱讀，能夠學有所成！
連接數據庫
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace MyTickets
{
public class DBHelper
{
//數據庫連接字符串
public string connString = @"Data Source=.;Initial Catalog=MyTicket;Trusted_Connection=Yes;Connect Timeout=90";
/// <summary>
/// 數據庫連接對象
/// </summary>
private SqlConnection connction;
public SqlConnection Connction
{
get
{
if (connction == null)
{
connction = new SqlConnection(connString);
}
return connction;
}
}
/// <summary>
/// 打開數據庫連接
/// </summary>
public void OpenConnection()
{
if (connction.State == ConnectionState.Closed)
{
Connction.Open();
}
else if (connction.State == ConnectionState.Broken)
{
Connction.Close();
Connction.Open();
}
}
/// <summary>
/// 關閉數據庫連接
/// </summary>
public void CloseConnection()
{
if(connction.State==ConnectionState.Open|| connction.State == ConnectionState.Broken)
{
Connction.Close();
}
}
}
}開頭動畫代碼
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Threading;
namespace MyTickets
{
public partial class 開頭 : Form
{
public 開頭()
{
InitializeComponent();
timer1.Interval = 1000;
timer1.Start();
timer1.Tick += new EventHandler(timer1_Tick);
}
private void 開頭_Load(object sender, EventArgs e)
{
TransparencyKey = BackColor;
}
private void timer1_Tick(object sender, EventArgs e)
{
timer1.Stop();
初始界面 f0 = new 初始界面();
this.Hide();
f0.ShowDialog();
}
}
}機票預訂界面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace MyTickets
{
public partial class 機票預訂 : Form
{
#region 構造函數
public 機票預訂()
{
InitializeComponent();
}
public 機票預訂(string text)
{
InitializeComponent();
usename.Text = text;
}
#endregion
#region 方法
#region 綁定cbo
/// <summary>
/// 綁定cbo
/// </summary>
private void BindCbo()
{
DBHelper dbHelper = new DBHelper();
//sql語句
string sql = "select * from cityInfo";
//適配器adapter
SqlDataAdapter adapter = new SqlDataAdapter(sql, dbHelper.Connction);
//數據集
DataSet ds = new DataSet();
//填充數據集
adapter.FillSchema(ds, SchemaType.Source, "cityInfo");
adapter.Fill(ds, "cityInfo");
//新的一行
DataRow row = ds.Tables["cityInfo"].NewRow();
row[0] = -1;
row[1] = "請選擇";
//插入
ds.Tables["cityInfo"].Rows.InsertAt(row, 0);
//獲取視圖
DataView dv1 = new DataView(ds.Tables["cityInfo"]);
DataView dv2 = new DataView(ds.Tables["cityInfo"]);
//綁定
this.cboDestinationCity.DataSource = dv1;
this.cboDestinationCity.DisplayMember = "cityName";
this.cboDestinationCity.ValueMember = "id";
this.cboLeaveCity.DataSource = dv2;
this.cboLeaveCity.DisplayMember = "cityName";
this.cboLeaveCity.ValueMember = "id";
}
#endregion
#region 綁定dgv
/// <summary>
/// 綁定dgv
/// </summary>
private void BindDgv()
{
DBHelper dbHelper = new DBHelper();
string sql = string.Format(@"select flightNo,airways,leaveTime,landTime,price
from flightInfo,airwaysInfo
where flightInfo.airwaysId=airwaysInfo.id
and leaveCity={0}
and destinationCity={1}", cboLeaveCity.SelectedValue, cboDestinationCity.SelectedValue);
SqlDataAdapter adapter = new SqlDataAdapter(sql, dbHelper.Connction);
DataSet ds = new DataSet();
adapter.Fill(ds, "flightInfo");
this.dataGridView1.DataSource = ds.Tables["flightInfo"];
}
#endregion
#region 驗證預訂部分的用戶輸入
/// <summary>
/// 驗證預訂部分的用戶輸入
/// </summary>
/// <returns></returns>
private bool ValidateInput()
{
if (txtFlightNo.Text == string.Empty)
{
MessageBox.Show("請選擇一個航班！");
return false;
}
if (dateTimePicker1.Value < DateTime.Now)
{
MessageBox.Show("請選擇正確的出發日期！");
dateTimePicker1.Focus();
return false;
}
return true;
}
#endregion
#endregion
#region 事件
//加載事件
private void Form1_Load(object sender, EventArgs e)
{
BindCbo();
TransparencyKey = BackColor;
}
//查詢事件
private void tbnQuery_Click(object sender, EventArgs e)
{
if(cboLeaveCity.Text=="請選擇"||cboDestinationCity.Text=="請選擇")
{
MessageBox.Show("請選擇出發地與目的地！");
this.dataGridView1.DataSource = null;
return;
}
BindDgv();
//清空txt
foreach (Control c in groupBox2.Controls)
{
if(c is TextBox)
{
c.Text = string.Empty;
}
}
}
//單擊dgv
private void dataGridView1_Click(object sender, EventArgs e)
{
if(dataGridView1.Rows.Count>0)
{
this.txtFlightNo.Text = dataGridView1.CurrentRow.Cells["flightNo"].Value.ToString();
this.txtAirways.Text = dataGridView1.CurrentRow.Cells["airways"].Value.ToString();
this.txtFrom.Text = cboLeaveCity.Text;
this.txtTo.Text = cboDestinationCity.Text;
this.txtLeaveTime.Text = dataGridView1.CurrentRow.Cells["leaveTime"].Value.ToString();
this.txtLandTime.Text = dataGridView1.CurrentRow.Cells["landTime"].Value.ToString();
this.txtPrice.Text = dataGridView1.CurrentRow.Cells["price"].Value.ToString();
}
}
//點擊關閉
private void button2_Click(object sender, EventArgs e)
{
Application.Exit();
}
//點擊預定
private void button1_Click(object sender, EventArgs e)
{
if(ValidateInput())
{
Random random = new Random();
int orderId= random.Next(100000, 9999999);
string flightNo = this.txtFlightNo.Text;
string leaveDate = this.dateTimePicker1.Value.ToShortDateString();
string landTime = this.txtLandTime.Text;
string price = this.txtPrice.Text;
int num = (int)this.numNunber.Value;
string leavePlace = this.txtFrom.Text;
string landPlace = this.txtTo.Text;
string usename = this.usename.Text;
string sql = string.Format(@"insert into orderInfo(orderId,flightNo,leaveDate,landTime,price,Number,leavePlace,landPlace,useId)
values({0},'{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}')", orderId, flightNo, leaveDate,landTime,price,num, leavePlace, landPlace,usename);
DBHelper dbHelper = new DBHelper();
try
{
//執行工具
SqlCommand cmd = new SqlCommand(sql, dbHelper.Connction);
//打開數據庫
dbHelper.OpenConnection();
//執行
int result =cmd.ExecuteNonQuery();
//判斷
if(result>0)
{
MessageBox.Show("預訂成功！訂單編號是：" + orderId);
}
else
{
MessageBox.Show("預定失敗，請重試！");
}
}
catch(Exception ex)
{
MessageBox.Show("發生錯誤，請聯系管理員,錯誤原因是："+ex.Message);
}
finally
{
dbHelper.CloseConnection();
}
}
}
#endregion
#region 鼠標移動
Point mouseOff;//鼠標移動位置變量
bool leftFlag;//標簽是否為左鍵
private void 機票預訂_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{
mouseOff = new Point(-e.X, -e.Y); //得到變量的值
leftFlag = true; //點擊左鍵按下時標注為true;
}
}
private void 機票預訂_MouseMove(object sender, MouseEventArgs e)
{
if (leftFlag)
{
Point mouseSet = Control.MousePosition;
mouseSet.Offset(mouseOff.X, mouseOff.Y); //設置移動后的位置
Location = mouseSet;
}
}
private void 機票預訂_MouseUp(object sender, MouseEventArgs e)
{
if (leftFlag)
{
leftFlag = false;//釋放鼠標后標注為false;
}
}
#endregion
}
}訂單查詢界面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace MyTickets
{
public partial class 訂單查詢 : Form
{
public 訂單查詢(string text)
{
InitializeComponent();
usename.Text = text.ToString();
}
#region 鼠標移動
Point mouseOff;//鼠標移動位置變量
bool leftFlag;//標簽是否為左鍵
private void 訂單查詢_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{
mouseOff = new Point(-e.X, -e.Y); //得到變量的值
leftFlag = true; //點擊左鍵按下時標注為true;
}
}
private void 訂單查詢_MouseMove(object sender, MouseEventArgs e)
{
if (leftFlag)
{
Point mouseSet = Control.MousePosition;
mouseSet.Offset(mouseOff.X, mouseOff.Y); //設置移動后的位置
Location = mouseSet;
}
}
private void 訂單查詢_MouseUp(object sender, MouseEventArgs e)
{
if (leftFlag)
{
leftFlag = false;//釋放鼠標后標注為false;
}
}
#endregion
private void 訂單查詢_Load(object sender, EventArgs e)
{
DBHelper dbHelper = new DBHelper();
string sql = string.Format(@"select orderId,flightNo,leaveDate,landTime,leavePlace,landPlace from orderInfo where useId ='{0}'",usename);
SqlDataAdapter adapter = new SqlDataAdapter(sql, dbHelper.Connction);
DataSet ds = new DataSet();
adapter.Fill(ds, "orderInfo");
this.dataGridView1.DataSource = ds.Tables["orderInfo"];
}
private void button1_Click(object sender, EventArgs e)
{
Application.Exit();
}
}
}登錄界面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Threading;
using System.Data.SqlClient;
namespace MyTickets
{
public partial class 初始界面 : Form
{
public 初始界面()
{
InitializeComponent();
}
int count = 0;
#region 鼠標移動
Point mouseOff;//鼠標移動位置變量
bool leftFlag;//標簽是否為左鍵
private void 初始界面_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{
mouseOff = new Point(-e.X, -e.Y); //得到變量的值
leftFlag = true; //點擊左鍵按下時標注為true;
}
}
private void 初始界面_MouseMove(object sender, MouseEventArgs e)
{
if (leftFlag)
{
Point mouseSet = Control.MousePosition;
mouseSet.Offset(mouseOff.X, mouseOff.Y); //設置移動后的位置
Location = mouseSet;
}
}
private void 初始界面_MouseUp(object sender, MouseEventArgs e)
{
if (leftFlag)
{
leftFlag = false;//釋放鼠標后標注為false;
}
}
#endregion
#region 打開其他窗口
private void 查詢訂單btn_Click(object sender, EventArgs e)
{
string userid = this.用戶名TEXT.Text;
string psword = this.passwordtxt.Text;
if (userid.Equals("") || psword.Equals(""))//用戶名或密碼為空
{
MessageBox.Show("用戶名或密碼不能為空");
}
else
{
string sql = string.Format(@"select useId,psword from LoginIn where useId = '{0}' and psWord = '{1}'", userid, psword);
DBHelper dbHelper = new DBHelper();
SqlCommand cmd = new SqlCommand(sql, dbHelper.Connction);
dbHelper.OpenConnection();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
MessageBox.Show("信息驗證成功");
//跳轉到主頁面
訂單查詢 fd = new 訂單查詢(用戶名TEXT.Text);
fd.ShowDialog();
this.Hide();
}
else
{
MessageBox.Show("用戶名或密碼錯誤");
}
}
}
#endregion
#region 輪播
private void ChangeImage(Image img, int millisecondsTimeOut)
{
if (this.IsHandleCreated)
{
this.Invoke(new Action(() =>
{
輪播1.Image = img;
})
);
}
Thread.Sleep(millisecondsTimeOut);
}
private void 初始界面_Load(object sender, EventArgs e)
{
Thread th;
th = new Thread
(
delegate ()
{
// 3就是要循環輪數了
for (int i = 0; i < 100; i++)
{
//調用方法
ChangeImage(Properties.Resources.東方航空, 2000);
count++;
ChangeImage(Properties.Resources.南方航空, 2000);
count++;
ChangeImage(Properties.Resources.四川航空, 2000);
count++;
ChangeImage(Properties.Resources.海南航空, 2000);
count++;
}
}
);
th.IsBackground = true;
th.Start();
}
//關閉
private void label1_Click(object sender, EventArgs e)
{
Application.Exit();
}
//輪播
private void pictureBox1_Click(object sender, EventArgs e)
{
if (count % 4 == 0)
{
System.Diagnostics.Process.Start("http://www.ceair.com/");
}
if (count % 4 == 3)
{
System.Diagnostics.Process.Start("https://www.hnair.com/");
}
if (count % 4 == 1)
{
System.Diagnostics.Process.Start("https://www.csair.com/");
}
if (count % 4 == 2)
{
System.Diagnostics.Process.Start("http://www.sichuanair.com/");
}
}
#endregion
#region 綁定登錄
private void 登錄btn_Click(object sender, EventArgs e)
{
string userid = this.用戶名TEXT.Text;
string psword = this.passwordtxt.Text;
if (userid.Equals("") || psword.Equals(""))//用戶名或密碼為空
{
MessageBox.Show("用戶名或密碼不能為空");
}
else
{
string sql = string.Format(@"select useId,psword from LoginIn where useId = '{0}' and psWord = '{1}'",userid, psword);
DBHelper dbHelper = new DBHelper();
SqlCommand cmd = new SqlCommand(sql, dbHelper.Connction);
dbHelper.OpenConnection();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
MessageBox.Show("信息驗證成功");
//跳轉到主頁面
機票預訂 f2 = new 機票預訂(用戶名TEXT.Text);
this.Hide();
f2.ShowDialog();
}
else
{
MessageBox.Show("用戶名或密碼錯誤");
}
}
}
#endregion
#region 綁定注冊
private void 注冊btn_Click(object sender, EventArgs e)
{
string userid = this.用戶名TEXT.Text;
string psword = this.passwordtxt.Text;
string sql = string.Format(@"insert into LoginIn(useId,psWord)
values('{0}','{1}')", userid, psword);
DBHelper dbHelper = new DBHelper();
try
{
//執行工具
SqlCommand cmd = new SqlCommand(sql, dbHelper.Connction);
//打開數據庫
dbHelper.OpenConnection();
//執行
int result = cmd.ExecuteNonQuery();
//判斷
if (result > 0)
{
MessageBox.Show("注冊成功，請登錄！");
}
else
{
MessageBox.Show("注冊失敗，請重試！");
}
}
catch (Exception ex)
{
MessageBox.Show("發生錯誤，請聯系管理員,錯誤原因是：" + ex.Message);
}
}
#endregion
}
}下面是一些效果圖
“C#如何實現航班預訂系統”的內容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業相關的知識可以關注億速云網站，小編將為大家輸出更多高質量的實用文章！
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
