旅行社管理系统实训C#

1、C#程序设计实训报告（ 2012 2013 ）学年第 2 学期）姓 名： 学 号： 专 业： 计算机科学与技术 班 级： 计科1101 指导教师： C#程序设计实训报告日 期 201371-201275地 点 67#206项目名称 旅行社管理系统实训目的能力目标 1、理解C#WinForm程序设计的风格，能设计合理的C#项目文件夹结构和公共类，注重代码的重用性，养成良好的标识符命名和代码编写习惯；2、熟练掌握各种常见的控件属性和事件方法；3、积累项目开发中常采用的设计模式和比较经典代码片段，并能在以后的项目开发中熟练地运用。实训要求：1、实训期间每天登记考勤，作为实训成绩的一部分。2、实训期间

2、不能玩游戏、看电影、小说等做与学习无关的事。如果有不遵守的同学将取消当天成绩。3、每天必须按照指导教师实训安排完成当天的实训项目，并经过老师的检查。4、完成整个实训以后，要求每人写出实训报告。5、实训报告要求有插图，模块关键代码及注释。实训内容-旅行社管理系统（过程及步骤）一、系统功能分析与设计 二、数据库设计在电脑中找到access 用access建立数据库（1）操作员信息表（编号，姓名，密码，类别）（2）景点信息表(编号，景点名称，地址，门票价格，简介，级别) (3)用到连接access数据库知识using System.Data.OleDb; string str = "Pro

3、vider=Microsoft.Jet.OLEDB.4.0;" str += "access数据库地址" OleDbConnection myConn = new OleDbConnection(str); myConn.Open();三、项目文件夹及公共类的设计四、模块设计、编码与调试1. 登录模块： 1.1获取本地时间 private void timer1_Tick(object sender, EventArgs e)/添¬¨ª加¨®的Ì?动¡¥态¬?时º&

4、#161;À钟¨® this.toolStripStatusLabel1.Text = DateTime.Now.ToString(); private void statusStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e) this.statusStrip1.Text = System.DateTime.Now.ToString(); 1.2设置背景音乐 public static uint SND_ASYNC = 0x0001; / play asynchronously pu

5、blic static uint SND_FILENAME = 0x00020000; / name is file name DllImport("winmm.dll") public static extern uint mciSendString(string lpstrCommand, string lpstrReturnString, uint uReturnLength, uint hWndCallback);private void Form1_Load(object sender, EventArgs e)/添¬¨ª加¨

6、;®背À3景¡ã音°?乐¤? mciSendString("close temp_alias", null, 0, 0); mciSendString("open ""郭¨´采¨¦洁¨¤ - 我¨°的Ì?未¡ä来¤¡ä式º?.mp3"" alias temp_alias",null, 0, 0); mciSe

7、ndString("play temp_alias repeat", null, 0, 0); 1.2登录（此时需要连接数据库，从数据库中得到用户名和密码） private void button1_Click(object sender, EventArgs e) string str = "Provider=Microsoft.Jet.OLEDB.4.0;" str += "Data Source=liuhedongtravel.mdb" OleDbConnection myConn = new OleDbConnection(s

8、tr); myConn.Open(); if (textBox1.Text != "" && textBox2.Text != "") string sql = "select * from login where userName= '" + textBox1.Text.Trim() + "'and userPass='" + textBox2.Text.Trim() + "'" adapter = new OleDbDataAdapter(sq

9、l, str); OleDbCommandBuilder buider = new OleDbCommandBuilder(adapter); adapter.InsertCommand = buider.GetInsertCommand(); table.Clear(); adapter.Fill(table); if (table.Rows.Count > 0) Form3 f3 = new Form3(); f3.Show(); else MessageBox.Show("登Ì?录?失º¡ì败㨹&q

10、uot;); 登录密码为空或错误时显示最后设计的界面为：2、注册界面 private void button1_Click(object sender, EventArgs e) string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=liuhedongtravel.mdb" if (textBox1.Text.Trim() = "" | textBox2.Text.Trim() = "" | textBox3.Text.Trim() = "") Mes

11、sageBox.Show("请?将?信?息¡é填¬?写¡ä完ª¨º整?！ê?"); else if (textBox2.Text.Trim() != textBox3.Text.Trim() MessageBox.Show("两¢?次ä?输º?入¨?的Ì?密¨¹码?不?一°?致?！ê?"); else OleDbConnection myConn = new OleDbConn

12、ection(str); myConn.Open(); string sqll = "INSERT INTO login(userName,userPass) values ('" + textBox1.Text + "','" + textBox2.Text + "') " OleDbCommand com = new OleDbCommand(sqll, myConn); com.CommandText = sqll; com.ExecuteNonQuery(); MessageBox.Show(&

13、quot;注Á¡é册¨¢成¨¦功|！ê?点Ì?击¡Â确¨¡¤定¡§，ê?返¤¦Ì回?登Ì?录?界?面?。¡ê"); Form1 f1 = new Form1(); f1.Show(); this.Hide(); private void button2_Click(object sender, EventArgs e) this.Close(); *如果密码

14、输入错误*如果输入正确*3、旅行社管理系统主界面（注册成功，在登陆界面中登录） 4、景点信息管理系统 5、操作员管理系统 private void button1_Click(object sender, EventArgs e) string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=liuhedongtravel.mdb" OleDbConnection myConn = new OleDbConnection(str); myConn.Open(); string sqll = "INSERT I

15、NTO login(userName,userPass) values ('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "') " OleDbCommand com = new OleDbCommand(sqll, myConn); com.CommandText = sqll; com.ExecuteNonQuery(); MessageBox.Show("添¬¨ª加¨®用

16、4;?户¡ì成¨¦功|！ê?"); this.Hide(); Form9 f99 = new Form9(); f99.Show(); 6、景点图片浏览单击景点图片浏览实现代码：private void driveListBox1_SelectedIndexChanged(object sender, EventArgs e) dirListBox1.Path = driveListBox1.Text; private void dirListBox1_Change(object sender, EventArgs e) fileLi

17、stBox1.Path = dirListBox1.Path; private void fileListBox1_SelectedIndexChanged(object sender, EventArgs e) String s; if (fileListBox1.FileName != null) s = dirListBox1.Path + "" + fileListBox1.FileName; pictureBox1.Image = System.Drawing.Image.FromFile(s); if (pictureBox1.Image.Width >

18、pictureBox1.Size.Width) button2.Enabled = true; else button2.Enabled = false; private void fileListBox1_PathChange(object sender, EventArgs e) button2.Enabled = false; pictureBox1.Image = null; private void radioButton1_CheckedChanged(object sender, EventArgs e) if (fileListBox1.Pattern != "*.g

19、if") fileListBox1_PathChange(sender, e); fileListBox1.Pattern = "*.gif" private void radioButton2_CheckedChanged(object sender, EventArgs e) if (fileListBox1.Pattern != "*.jpg") fileListBox1_PathChange(sender, e); fileListBox1.Pattern = "*.jpg" private void radioBu

20、tton3_CheckedChanged(object sender, EventArgs e) if (fileListBox1.Pattern != "*.bmp") fileListBox1_PathChange(sender, e); fileListBox1.Pattern = "*.bmp" private void radioButton4_CheckedChanged(object sender, EventArgs e) if (fileListBox1.Pattern != "*.ico") fileListBox

21、1_PathChange(sender, e); fileListBox1.Pattern = "*.ico" private void button2_Click(object sender, EventArgs e) Form11 myform = new Form11(); String s; s = dirListBox1.Path + "" + fileListBox1.FileName; myform.pictureBox1.Image = System.Drawing.Image.FromFile(s); myform.Show(); pr

22、ivate void button1_Click(object sender, EventArgs e) Application.Exit(); 7、添加景点信息 private void button1_Click(object sender, EventArgs e) string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=liuhedongtravel.mdb" OleDbConnection myConn = new OleDbConnection(str); myConn.Open(); string sqll = "INSERT INTO sportInfo(id,sportName,address,price,introduce,grade) values ('" + textBox6.Text.Trim() + &qu