基于c#窗體航空訂票管理系統(tǒng)設(shè)計與實(shí)現(xiàn)

1、制作人：王曼董明欣 張杰網(wǎng)絡(luò)設(shè)計與開發(fā)二班 c#大作業(yè)指導(dǎo)老師：李海平基于c#窗體的航空訂票管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)系統(tǒng)分工需求分析進(jìn)入21世紀(jì)，人們計算機(jī)處理事情的需求有了進(jìn)一步的 要求。小到商店繳費(fèi)管理系統(tǒng)的快速運(yùn)行，大到國家航空航天 計算機(jī)的管理系統(tǒng)的進(jìn)一步提升。我們每時每刻都在追求著計 算機(jī)處理事情的快速，穩(wěn)定，運(yùn)算量大等一系列優(yōu)點(diǎn)。由于人 們?yōu)榱朔奖憧旖莸纳罘绞?，上網(wǎng)已經(jīng)成為潮流，這樣快速穩(wěn) 定的航空訂票系統(tǒng)應(yīng)運(yùn)而生。航空訂票系統(tǒng)需要滿足一般的查 詢航線，訂票，退票等一系列基本操作，當(dāng)然我們也可以設(shè)置 黑名單，以屏蔽違規(guī)用戶。當(dāng)然人人都追求美感，那么系統(tǒng)界 面的設(shè)計也要符合大眾的審美要

2、求。資料的安全與隱私性也是 至關(guān)重要的，我們每個人，都不想別人知道自己的一些隱私， 對自己資金的安全也格外重視。所以訂票系統(tǒng)對不同的角色賦 予不同的權(quán)限從而保證用戶資料的安全性與隱私性。三.系統(tǒng)功能(1)游客功能對游客我們系統(tǒng)只為其提供查詢航班信息的功能，不可進(jìn)行訂 票操作。當(dāng)游客點(diǎn)擊購票按鈕時，將提醒其注冊或登錄。(2)用戶注冊用戶只有注冊成為我們的會員，才可以進(jìn)行訂票操作。一旦注 冊，用戶名將不可修改。注冊時不可與數(shù)據(jù)庫中存在的用戶名 相同，即系統(tǒng)中只能存在唯一一個用戶名。(3)用戶中心提供用戶對自己的資料的查看與修改的功能。還可以對自己的 密碼進(jìn)行修改，在修改密碼時需要輸入原始密碼進(jìn)而進(jìn)

3、行驗(yàn)證。 由于時間問題，對個人錢包功能先暫停使用，默認(rèn)錢夠買票了(4)訂票功能用戶可根據(jù)航班時間，和航班號或航班價格進(jìn)行訂票。訂票時 系統(tǒng)會提醒確認(rèn)，訂票成功后系統(tǒng)會將用戶的信息加入訂票信息表。并改變航班的余票額。(5)退票功能用戶在不需要票的情況下進(jìn)行退票操作。退票時必須輸入訂票 時隨機(jī)生成的訂單號，與航班號。退票成功后，航班自動將余 票量加一操作。(6)本系統(tǒng)還添加了管理員界面。當(dāng)管理員進(jìn)入后，可對用戶 的信息進(jìn)行查看，但不能修改，也可將用戶加入黑名單，如果 用戶有訂單，則不允許管理員做加入黑名單操作。當(dāng)然加入黑 名單時，管理員需要說明理由，作為存檔。管理員，也可根據(jù) 實(shí)際情況對航班進(jìn)行管

4、理操作。增刪改查。他也可以對公告進(jìn) 行修改操作。(7)系統(tǒng)也實(shí)現(xiàn)了，對于不同的角色進(jìn)入，會產(chǎn)生不同的界面 效果。保證了數(shù)據(jù)的安全性，和保密性。數(shù)據(jù)庫設(shè)計(1)管理員表Ad main:尊司管拽兼輪HKDP.MDF)AdiYisinlriAnsimelaoihinihaonihaolaoshinihaoteacherteacherteacher米NULLNULLNULL(2)航班表Hangbsn:孤除thkdp身q小，口i用EirtT- WSI'KDP.MCFj，XchmJdodadiStaddatcEnddatrwrekdiiYspiicccontent上詼內(nèi)生2013/7/8 mm.Z

5、DUb/E 10a.星目38S.00加A41BB上有國點(diǎn)如犯州3m.Z013f7fB UOflU*吃LZSiOO05M199言商;涼2013/7/10 5W,20137/E 10;*三%口21Q.0Q婚焰8冷托用制第13/7州守！00.?013<7/8 WUhM1Z&0Q卻A59W_=w山再2019flOt.»13<7ZB LOflL-.ar-52S.OTJ5期11Sl?r3013/8 口加一201V7 用 U04t星鴕二72ftOC第B4788王國上由純1JP相斗：00-2013<?/B IOjOL"二62aoo圈CS46所內(nèi)學(xué)古2913/8 9

6、003013/7/8 lOrfJ.SMuaoo09fcrioi12'rk/H n jo n.jviTn-i-Jl/TfO -8 fl JI=- 由£ fW年-M1(3)黑名單表HMDllflbiao:里-營那里整HKDF.MDFl t,丐1n = w”-.總迎批,H-.Jk MlAdnuiiz2跋出一管星奈維十IKDPNDtXNumlUsemwne b«tzhu29無人告一發(fā)生法用戶名不等電.(4)訂單信息表ddhoUserniameHBidpricesmoweiii-aio漏NULLNULLNULLNULLPfULL(5)用戶信息表31rti hipUwnHvrd

7、UrnoTw展BlhQEdlBrpcta-TiErhtjilA3»Q»f解山砌.MfMjKJAMI加E2XAMIMW3AWUWitM4sMA1t四.運(yùn)行截圖五.源代碼using System;using System.Collections.Generic;using System.Linq;using System.Windows.Forms;namespace航空訂票管理系統(tǒng)staticclass Program/<summary>應(yīng)用程序的主入口點(diǎn)。/</summary>STAThreadstatic void Main()string dat

8、aDir = AppDomainCurrentDomain.BaseDirectory;if (dataDir.EndsWith(“binDebug")| dataDir.EndsWith("binRelease")dataDir = System.IO.Directory .GetParent(dataDir).Parent.Parent.FullName;AppDomainCurrentDomain.SetData( "DataDirectory" , dataDir);Application.EnableVisualStyles();Ap

9、plication.SetCompatibleTextRenderingDefault( false );Application.Run( new Form1();using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace航空訂票管

10、理系統(tǒng)public partial class Form1 : Formzhuce zc = new zhuce();Userlaunch lch= new Userlaunch ();public string status1 get; set; int label1x;public Form1()InitializeComponent();private void Form1_Load( object sender, EventArgs e)wizlabel1x = label1.Right;timer1.Enabled =true;timer2.Enabled =true;timer3.

11、Enabled =true;timer2.Start();novisible2();novisible1();textBox1.Focus();timer1.Start();/隱藏管理員可做的操作public void novisible1()falsefalse客戶彳B息 ToolStripMenuItem.Visible =航班信息 ToolStripMenuItem.Visible =修改公告 ToolStripMenuItem.Visible = false /隱藏用戶可做的操作public void novisible2() 用戶補(bǔ)全資料 ToolStripMenuItem.Visi

12、ble = false ;/ 個人中心用戶充值 ToolStripMenuItem.Visible = false ;/ 辦理業(yè)務(wù)/隱藏登陸前界面public void novisible3() 用戶登錄 ToolStripMenuItem.Visible =false ;瀏覽信息 ToolStripMenuItem.Visible =false ;管理員登陸 ToolStripMenuItem.Visible = false 控制公告字段private void timer1_Tick( object sender, EventArgs e) label1.Location =new Poi

13、nt (label1.Location.X-1,label1.Location.Y);if (label1.Right = 0)label1.Left = label1x;/當(dāng)點(diǎn)到按鈕時，進(jìn)行圖片變換private void button1_MouseEnter( object sender, EventArgs e)R Button bttn;timer2.Enabled =false ;bttn = (Button )sender;if (bttn = button1) picture1();else if (bttn = button2) picture2();else if (bttn

14、 = button3) picture3();else if (bttn = button4) picture4();else if (bttn = button5) picture5();private voidtextBox5.EnabledtextBox1.EnabledtextBox2.EnabledtextBox5.Text =textBox1.Focus();private voidtextBox5.EnabledtextBox1.Text =textBox2.Text =textBox1.EnabledtextBox2.Enabledprivate voidtextBox6.En

15、abledtextBox3.EnabledtextBox4.EnabledtextBox6.Text =textBox4.Focus();private voidtextBox6.EnabledtextBox4.Text =textBox3.Text =textBox3.EnabledtextBox4.EnabledtextBox6.Focus();/安全退出private voidradioButton1_CheckedChanged(false ;true ;true ;""radioButton2_CheckedChanged(true ;""&q

16、uot;"false ;false ;radioButton4_CheckedChanged(false ;true ;true ;""radioButton3_CheckedChanged(true ;""""false ;false ;objectobjectobjectobjectsender,sender,sender,sender,EventArgsEventArgsEventArgsEventArgse)e)e)e)用戶退出 ToolStripMenuItem_Click( object sender, Even

17、tArgs e)if (toolStripStatusLabel4.Text ="未登錄")MessageBoxShow（"當(dāng)前你未登錄，請登錄或注冊 "）; else);MessageBoxShow(toolStripStatusLabel4.Text+ "您已下線，謝謝使用！toolStripStatusLabel4.Text ="未登錄"statusl =""novisible2();novisible1();用戶登錄 ToolStripMenuItem.Visible =true ;瀏覽信息 To

18、olStripMenuItem.Visible =true ;管理員登陸 ToolStripMenuItem.Visible = true ;/注冊界面private void 瀏覽信息 ToolStripMenuItem_Click( object sender, EventArgs e) zhuce zc = new zhuce();zc.ShowDialog();/圖片變換private void timer2_Tick( object sender, EventArgs e) Randomrd = new Random);int r = rd.Next(1,6); switch (r)

19、 case 1: picture1();break ;case 2: picture2();break ;Xcase 3: picture3(); break;case 4: picture4();break ;case 5: picture5();break ; /圖片顯示方法 private void picture1() pictureBox1.Show();pictureBox2.Hide();pictureBox3.Hide();pictureBox4.Hide();pictureBox5.Hide();private void picture2()pictureBox2.Show(

20、);pictureBox1.Hide();pictureBox3.Hide();pictureBox4.Hide();pictureBox5.Hide();private void picture3()pictureBox3.Show();pictureBox2.Hide();pictureBox1.Hide();pictureBox4.Hide();pictureBox5.Hide();private void picture4()pictureBox4.Show();pictureBox2.Hide();pictureBox3.Hide();pictureBox1.Hide();濟(jì)priv

21、ate void picture5()pictureBox5.Show();pictureBox2.Hide();pictureBox3.Hide();pictureBox4.Hide();XpictureBox1.Hide();/當(dāng)不用手動控制圖片時，執(zhí)行private void button1_MouseLeave( object sender, EventArgs e) timer2.Enabled =true ; /用戶登陸private void 用戶登錄 ToolStripMenuItem_Click( object sender, EventArgs e)制作人：王曼董明欣 張杰

22、網(wǎng)絡(luò)設(shè)計與開發(fā)二班 c#大作業(yè)指導(dǎo)老師：李海平 Userlaunch uch = new Userlaunch (); if (uch.ShowDialog() = DialogResult .OK) status1 = uch.UserName;toolStripStatusLabel4.Text ="尊敬的用戶"+status1+ "你好！"；用戶補(bǔ)全資料 ToolStripMenuItem.Visible = true ; 用戶充值 ToolStripMenuItem.Visible =true ;novisible1(); novisible3(

23、); uch.Dispose(); /管理員登陸private void 管理員登陸 ToolStripMenuItem_Click( object sender, EventArgs e) Admain adn = new Admain();if (adn.ShowDialog() = DialogResult .OK) toolStripStatusLabel4.Text = adn.AdmainName;novisible2();novisible3();客戶彳B息 ToolStripMenuItem.Visible =true ;航班信息 ToolStripMenuItem.Visib

24、le =true ;修改公告 ToolStripMenuItem.Visible =true ; /機(jī)票預(yù)訂private void button6_Click( object sender, EventArgs e) if (toolStripStatusLabel4.Text ="未登錄")義MessageBoxShow("請先登錄");textBoxl.Text = textBox2.Text = textBox5.Text =""else if (toolStripStatusLabel4.Text.Substring(0,

25、3)="親愛的") MessageBoxShow("對不起，管理員，不能訂票的！")；textBoxl.Text = textBox2.Text = textBox5.Text =""elseif (textBoxl.Text !="" && textBox2.Text !="" | textBox5.Text !="")int n = 1;jipiaoyuding jyd = new jipiaoyuding (textBoxl.Text, textBox2

26、.Text, textBox5.Text, n, status1);jyd.ShowDialog();elseMessageBoxShow（"對不起，你輸入的信息不符合查詢條件，請重新輸入"）;_ 尸/系統(tǒng)時間private void timer3_Tick( object sender, EventArgs e) this .toolStripStatusLabel3.Text ="當(dāng)前系統(tǒng)時間："+DateTime .Now.ToString( "yyyy-MM-dd hh:mm:ss");/查詢航班動態(tài)private void

27、button7_Click( object sender, EventArgs e) if (textBox4.Text !="" && textBox3.Text !="" | textBox6.Text !="")int n = 2;jipiaoyuding jyd = new jipiaoyuding (textBox4.Text, textBox3.Text, textBox6.Text,n,status1);jyd.ShowDialog();textBox4.Text = textBox3.Text = te

28、xtBox6.Text =""elseMessageBoxShow("對不起，你輸入的信息不符合查詢條件，請重新輸入");textBox4.Text = textBox3.Text = textBox6.Text =private void 訂票信息 ToolStripMenuItem_Click( object sender, EventArgs e) 訂票信息 dp = new 訂票信息();dp.ShowDialog(); private void 用戶資料 ToolStripMenuItem_Click( object sender, Event

29、Args e) 用戶資料yz = new用戶資料()；yz.ShowDialog(); private void 訂票 ToolStripMenuItem_Click( object sender, EventArgs e) jipiaoyuding jyd = new jipiaoyuding ("" , "" , "" , 1, statusl);jyd.ShowDialog(); private void 查詢訂單 ToolStripMenuItem_Click( object sender, EventArgs e) 個人訂單

30、 gd = new 個人訂單(statusl);gd.ShowDialog(); private void 黑名單資料 ToolStripMenuItem_Click( object sender, EventArgs e) 黑名單表hm = new黑名單表();hm.ShowDialog(); private void 航班信息 ToolStripMenuItem_Click( object sender, EventArgs e) 航班信息hbx = new航班信息();hbx.ShowDialog();private void 修改公告 ToolStripMenuItem_Click(

31、object sender, EventArgs e) 修改公告xg= new修改公告();if (xg.ShowDialog() = DialogResult .OK) labell.Text = xg.gonggao;private void 查看自 己資料 ToolStripMenuItem_Click( object sender, EventArgs e) 個人資料gz = new個人資料(status1,1);gz.ShowDialog(); private void 修改個人資料 ToolStripMenuItem_Click( object sender, EventArgs

32、e) 個人資料gz1 = new個人資料(status1,2);gz1.ShowDialog(); private void 我想退票 ToolStripMenuItem_Click( object sender, EventArgs e) 退票系統(tǒng)tp = new退票系統(tǒng)(status1); if (tp.ShowDialog() = DialogResult .OK) MessageBoxShow("退票成功")； private void button8_Click( object sender, EventArgs e) if (toolStripStatusLab

33、el4.Text= "未登錄") MessageBoxShow("你還未登陸，請先登錄！")；textBox7.Text = textBox8.Text = textBox9.Text =""textBox1.Focus(); else if (toolStripStatusLabel4.Text.Substring(0,3)="親愛的") r MessageBoxShow("管理員,您是無權(quán)退票的啊！")；textBox7.Text = textBox8.Text = textBox9.Tex

34、t =""textBox1.Focus(); else 退票系統(tǒng)tp = new退票系統(tǒng)(status1);tp.tuibiao(textBox7.Text, textBox8.Text, textBox9.Text); if (tp.DialogResult =DialogResult .OK)MessageBoxShow("退票成功")； /取消退票private void button9_Click( object sender, EventArgs e) textBox7.Text =textBox8.Text=textBox9.Text=&qu

35、ot;"textBox7.Focus();using System;Asusing System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace航空訂票管理系統(tǒng)public partialclass zhuce : FormpublicstringUsernam

36、e get; set ; publicstringUserpassword1 get; set ; public publicstring Userpassword2 get; set ; int flag1,flag2,flag3;string publicconnectionString = Properties.Settings .Default.HKDPConnectionString;zhuce()InitializeComponent();flag1 = 1; flag2 = 1; flag3 = 1;toolTip1.InitialDelay = 0;toolTip1.Resho

37、wDelay = 0;toolTip1.SetToolTip(textBox1,"用戶名不能超過20個字符，而且只能用字母，數(shù)字！");toolTip1.SetToolTip(textBox2,"密碼不能少于 6個子");制作人：王曼董明欣 張杰網(wǎng)絡(luò)設(shè)計與開發(fā)二班 c#大作業(yè)指導(dǎo)老師：李海平toomp1.SetToomp(textBox3,"請再輸入一次密碼")；errorProvidelBlinkStyle =ErrorBlinkStyle .NeverBlink;private void button2_Click( object

38、 sender, EventArgs e) this .Dispose();/驗(yàn)證密碼是否大于6個字符private void textBox2_TextChanged( object sender, EventArgs e) if (textBox2.Text.Length <=6|textBox2.Text.Length > 20)errorProvider2.SetError(textBox2,"密碼非法！”)；flag1 = 0;.elseerrorProvider2.Clear();flagl = 1;/驗(yàn)證用戶名是否大于6個字符，并且必須是數(shù)字和字母的組合pr

39、ivate void textBox1_Enter( object sender, EventArgs e) int flag=1;for ( int i=0; i < textBoxl.Text.Length; i+)yif ( char .IsLetterOrDigit(textBox1.Texti) =false )flag = 0；Xelseflag = 1；if (textBoxl.Text.Length <= 6 | textBoxl.Text.Length > 20 | flag = 0) errorProvider1.SetError(textBox1,”用戶

40、名非法！”)；flag2 = 0;制作人：王曼董明欣 張杰網(wǎng)絡(luò)設(shè)計與開發(fā)二班 c#大作業(yè)指導(dǎo)老師：李海平elseerrorProvider1.Clear(); flag2 = 1;/驗(yàn)證確認(rèn)密碼是否正確private void textBox3_TextChanged( object sender, EventArgs e)矗if (textBox3.Text != textBox2.Text | textBox3.Text.Length <= 6)errorProvider3.SetError(textBox3,"密碼非法！");flag3 = 0; else50e

41、rrorProvider3.Clear(); flag3 = 1;/*開始添加數(shù)據(jù)*/ private void button1_Click( object sender, EventArgs e) Username = textBox1.Text;Userpassword1 = textBox2.Text; using ( SqlConnection conn = new SqlConnection (connectionString) conn.Open(); try if (flag1 = 1 && flag2 = 1 && flag3 = 1&&

42、amp;textBox2.Text=textBox3.Text) SqlCommanccmd = new SqlComman© cmd.Connection = conn;SqlDataAdapter adapter = new SqlDataAdapter ("select * from Usertable where Username='" +textBox1.Text+ ""' ,conn);DataTable table= new DataTable ();adapter.Fill(table);if (table.Ro

43、ws.Count=0)cmd.CommandText =insert into Usertable(Username,Upassword)values(Username,Username)"cmd.Parameters.Clear(); cmd.Parameters.Add( cmd.Parameters.Add( cmd.ExecuteNonQuery(); conn.Close();new SqlParameter ("Username", Username);newSqlParameter ("Upassword" , Userpassw

44、ord1);MessageBoxShow( "恭喜您，注冊成功")； this .Dispose();elseMessageBoxShow("對不起，此用戶名已被注冊！");textBox1.Text = textBox2.Text = textBox3.Text =textBox1.Focus();50flag1 = 1;elseMessageBoxShow("很遺憾，差一步就完成了！");textBox1.Text =textBox2.Text=textBox3.Text= textBox1.Focus();flag1 = 1;c

45、atch ( Exception err)MessageBoxShow(err.Message); Pusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;制作人：王曼董明欣 張杰網(wǎng)絡(luò)設(shè)計與開發(fā)二班 c#大作業(yè)指導(dǎo)老師：李海平using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace航

46、空訂票管理系統(tǒng) public partial class Userlaunch : Form public string UserName get; set ; string connection = Properties. Settings .Default.HKDPConnectionString;Qpublic Userlaunch() InitializeComponent(); /登陸開始private void button1_Click( object sender, EventArgs e) try SqlConnection conn = new SqlConnection

47、(connection);conn.Open();SqlCommanccmd = new SqlComman。；cmd.Connection = conn;cmd.CommandText ="select count(*) from Usertable where Username='"+textBoxl.Text +"' and Upassword='" +textBox2.Text+ ""'；if ( int )cmd.ExecuteScalar() = 1) UserName = textBoxl

48、.Text;this .DialogResult = DialogResult .OK; elseMessageBoxShow("登錄名或密碼錯誤！請重新輸入")；textBoxl.Text =""textBox2.Text =""textBox1.Focus();conn.Close();catch (Exception err)MessageBoxShow(err.Message);/關(guān)閉窗體private void button2_Click( object sender, EventArgs e) this .Dispose(

49、);using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;50using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace航空訂票管理系統(tǒng) public partial class Admain : Form /public string AdmainName 'get; set

50、; string connection = Properties. Settings .Default.HKDPConnectionString; public Admain()InitializeComponent();/釋放窗體private void button2_Click( object sender, EventArgs e) this .Dispose();/進(jìn)入密碼驗(yàn)證private void button1_Click( object sender, EventArgs e) try制作人：王曼董明欣 張杰網(wǎng)絡(luò)設(shè)計與開發(fā)二班 c#大作業(yè)指導(dǎo)老師：李海平SqlConnecti

51、on conn = new SqlConnection (connection); conn.Open(); SqlCommanccmd = new SqlComman。； cmd.Connection = conn; cmd.CommandText= "select count(*) from Admain where AdmainId='" + textBoxl.Text+ "' and Apassword='" + textBox2.Text +"”'if ( int )cmd.ExecuteScalar(

52、) = 1) AdmainName ="親愛的管理員"+ textBox1.Text +"你好！"；this .DialogResult = DialogResult .OK; else MessageBoxShow("登錄名或密碼錯誤！請重新輸入 ")； textBox1.Text =""textBox2.Text ="" ;textBox1.Focus();50 conn.Close();catch ( Exception err)MessageBoxShow(err.Message);us

53、ing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace航空訂票管理系統(tǒng)public partial class jipiaoyuding : FormSqlDataAdapter adapter;DataTable table;pu

54、blic string username get; set;int Q;string connectionstring = Properties. Settings .Default.HKDPConnectionString; public jipiaoyuding()InitializeComponent();dataGridView1.SelectionMode =DataGridViewSelectionMode .FullRowSelect;/在主窗體中指定的條件篩選出來的數(shù)據(jù) public jipiaoyuding( string a, string b, string c, int

55、 n, string q)InitializeComponent();dataGridView1.SelectionMode =DataGridViewSelectionMode .FullRowSelect;Q = n;username = q;try50SqlConnection conn = new SqlConnection (connectionString); if (c ="") conn.Open();adapter =new SqlDataAdapter ("select * from Hangban where chufadi= '"+ a+ "' and daodadi='" + b + "'" , conn);table =new DataTable ();adapter.Fill(table);dataGridViewl.DataSource = table;head();conn.Close(); els