飞机航班管理系统论文

摘要近些年来，我国民航事业取得了飞速的发展，与此同时计算机软件技术、数据库技术、信息技术也取得到了长足的发展与广泛的应用。技术的进步一方面提高了机场信息化的要求、另外一方面也使得企业信息化的环境日益复杂。本次我的软件工程作业就是应对于机场信息化要求，探讨了在机场复杂的信息化环境下的航班信息管理系统的方法与过程。一个机场的航班信息，就是这个机场运营的所有航班的实时信息，包括值机信息、登机信息、到港信息、离港信息、行李转盘信息等等，它们为旅客登机转机、亲友接机和各类人员工作提供了必不可少的服务。而我设计的机场航班管理系统就是用于管理机场航班信息的。一个好的航班管理系统必须能够合理的规划航班信息，为高效有序地管理组织机场的生产与服务,有效提高机场的运营效率及服务质量,提高机场的赢利与竞争水平,以保证为旅客、航空公司以及机场自身的业务管理提供一致、及时、准确、系统、完整的信息服务功能。关键词：航班信息管理软件工程附录A程序代码由于代码较多只附录部分代码，下面只是用户登陆模块程序源代码：usingSystem;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;namespaceWindowsFormsApplication1{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();} //定义数据库连接字符串conninternalstaticstringconn; //定义变量用户名nameinternalstaticstringname; //定义变量密码mminternalstaticstringmm; //定义变量权限qxinternalstaticstringqx;privatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}privatevoidbutton1_Click(objectsender,EventArgse){opt.Constring=conn;if(textBox1.Text==""||textBox2.Text==""){MessageBox.Show("请输入正确的用户名和密码！");}else{stringsql=string.Format("select*fromDlbwhereYhm='{0}'andMm='{1}'",name,mm);DataSetds=opt.getDataSet(sql);if(ds.Tables[0].Rows.Count==0){MessageBox.Show("用户名或者密码错误，请输入正确的用户名和密码！");}else{if(ds.Tables[0].Rows[0][3].ToString()==qx){Form2F2=newForm2();F2.Show();this.Hide();}else{MessageBox.Show("用户名或者密码错误，请输入正确的用户名和密码！");}}}}OptDataBaseopt;privatevoidForm1_Load(objectsender,EventArgse){opt=newOptDataBase();conn=conn+Application.StartupPath;conn=conn+"\\"+"mdb.mdb";comboBox1.SelectedIndex=0;}privatevoidbutton1_KeyDown(objectsender,KeyEventArgse){if(e.KeyCode==Keys.Enter){button1_Click(this,e);}}}}下面是用户航班查询模块程序源代码usingSystem;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;namespaceWindowsFormsApplication1{publicpartialclassForm3:Form{publicForm3(){InitializeComponent();}internalstaticstringHbId;privatevoidtimer1_Tick(objectsender,EventArgse){}OptDataBaseopt;privatevoidForm3_Load(objectsender,EventArgse){opt=newOptDataBase();}///<summary>///时间查询///</summary>privatevoidbutton1_Click(objectsender,EventArgse){stringtime;stringsql=string.Format("selectHbId,QfId,MdId,QfTime,FjlxfromHbxbwhereQftime='{0}'",time);opt.Constring=Form1.conn;DataSetds=opt.getDataSet(sql);if(ds.Tables[0].Rows.Count==0){MessageBox.Show("对不起，没有您要查找的信息!");toolStripStatusLabel2.Text="没有您要查的信息！";}else{toolStripStatusLabel2.Text="查到了条信息！";for(inti=0;i<ds.Tables[0].Rows.Count;i++){ListViewItemlt=newListViewItem(ds.Tables[0].Rows[i][0].ToString());}}}privatevoidbutton2_Click(objectsender,EventArgse){stringsql=string.Format("selectHbId,QfId,MdId,QfTime,FjlxfromHbxbwhereHbId='{0}'",HbId);opt.Constring=Form1.conn;DataSetds=opt.getDataSet(sql);if(ds.Tables[0].Rows.Count==0){MessageBox.Show("对不起，没有您要查找的信息!");toolStripStatusLabel2.Text="没有您要查的信息！";}else{toolStripStatusLabel2.Text="查到了条信息！";for(inti=0;i<ds.Tables[0].Rows.Count;i++){ListViewItemlt=newListViewItem(ds.Tables[0].Rows[i][0].ToString());}}}}}下面是航班设置模块的代码：usingSystem;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;namespaceWindowsFormsApplication1{publicpartialclassForm6:Form{publicForm6(){InitializeComponent();}OptDataBaseopt;privatevoidtimer1_Tick(objectsender,EventArgse){}privatevoidbutton2_Click(objectsender,EventArgse){this.Close();}privatevoidbutton1_Click(objectsender,EventArgse){dateTimePicker1.Format=DateTimePickerFormat.Custom;dateTimePicker1.CustomFormat="yyyy-M-d";if(textBox1.Text==""||textBox2.Text==""||textBox3.Text==""||maskedTextBox1.Text==""){MessageBox.Show("请填写完整信息！");}else{stringsql=string.Format("insertintoHbxb(HbId,QfId,MdId,QfTime,Fjlx)values('{0}','{1}','{2}','{3}','{4}')",hdid,qfid,mdid,qftime,fjlx);opt.Constring=Form1.conn;boolb=opt.DataIED(sql);if(b){MessageBox.Show("添加成功！");listitadd();Form2f2=newForm2();f2=(Form2)this.Owner;f2.listitadd();this.Close();}else{MessageBox.Show("添加失败！");}}}privatevoidForm6_Load(objectsender,EventArgse){opt=newOptDataBase();opt.Constring=Form1.conn;comboBox1.SelectedIndex=0;comboBox2.SelectedIndex=0;listitadd();}publicvoidlistitadd(){DataSetds=opt.getDataSet(sql);if(ds.Tables[0].Rows.Count==0){toolStripStatusLabel2.Text="没有信息!";}else{toolStripStatusLabel2.Text="有条信息！";for(inti=0;i<ds.Tables[0].Rows.Count;i++){ListViewItemlt=newListViewItem(ds.Tables[0].Rows[i][0].ToString());}}}privatevoidbutton5_Click(objectsender,EventArgse){this.Close();}privatevoidbutton3_Click(objectsender,EventArgse){this.Close();}privatevoidlistView1_DoubleClick(objectsender,EventArgse){stringlt=listView1.SelectedItems[0].Text;stringtime2;textBox4.Text=lt;comboBox2.SelectedItem=listView1.SelectedItems[0].SubItems[4].Text;textBox6.Text=listView1.SelectedItems[0].SubItems[1].Text;stringtime1=listView1.SelectedItems[0].SubItems[3].Text;if(time1.Length==15){time2=time1.Substring(0,9);time1=time1.Substring(10,time1.Length-10);}else{time2=time1.Substring(0,10);time1=time1.Substring(11,time1.Length-11);}dateTimePicker2.Text=time2;maskedTextBox2.Text=time1;textBox5.Text=listView1.SelectedItems[0].SubItems[2].Text;textBox7.Text=lt;textBox12.Text=listView1.SelectedItems[0].SubItems[4].Text;textBox9.Text=listView1.SelectedItems[0].SubItems[1].Text;textBox11.Text=listView1.SelectedItems[0].SubItems[3].Text;textBox8.Text=listView1.SelectedItems[0].SubItems[2].Text;}privatevoidbutton6_Click(objectsender,EventArgse){stringhdid=listView1.SelectedItems[0].Text;stringsql=string.Format("deletefromHbxbwhereHbId='{0}'",hdid);boolb=opt.DataIED(sql);if(b){MessageBox.Show("删除成功！");listitadd();textBox4.Text="";comboBox2.SelectedIndex=0;textBox6.Text="";dateTimePicker2.Text="";maskedTextBox2.Text="";textBox5.Text="";textBox7.Text="";textBox12.Text="";textBox9.Text="";textBox11.Text="";textBox8.Text="";Form2f2=newForm2();f2=(Form2)this.Owner;f2.listitadd();this.Close();}el