餐厅管理摘要.docx

《餐厅管理摘要.docx》由会员分享，可在线阅读，更多相关《餐厅管理摘要.docx（51页珍藏版）》请在三一办公上搜索。

1、餐厅消费管理系统民以食为天，学生餐厅就餐，在人流的高峰期拿着钱去就餐的话服务员忙着找零钱都非常不方便，再一点每个人吃饭时手里拿着钱也是不卫生的，餐厅管理系统是为方便管理学生就餐而设计的。首先餐厅只需一个收银员管理充钱和办理餐卡的信息管理，而不需要每个餐厅都自己配备一个专门找零钱工，并且也方便学校对学生在校的就餐情况的了解。本系统主要用 C#语言为基础编程语言，运用Microsoft Visual Studio 2005设计前台界面，运用Microsoft Office Access 2003作为后台数据库，运用c#设计与数据库连接的接口，方便简洁的操作就能很好的管理数据库系统。一、 建立一个类

2、：建立数据库库连接和数据库读取方法。public OleDbConnection conn() OleDbConnection myco = new OleDbConnection(); string mystr = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|学生信息.mdb; myco.ConnectionString = mystr; myco.Open(); return myco; public bool sread(string sql) conn(); OleDbCommand mycmd = new O

3、leDbCommand(sql,conn (); OleDbDataReader myreader = mycmd.ExecuteReader(); if (myreader.Read() return true; else return false; 二、建设登陆界面：账号和登录密码：登陆界面中的账号和密码都要和事先前建立的数据库相连接，要建立许多messagebox信息提示确保解决用户在登录所遇到的问题。public partial class 登陆界面 : Form public 登陆界面() InitializeComponent(); data da = new data(); pr

4、ivate void 登陆_Click(object sender, EventArgs e) try da.conn(); string pass; pass = select * from 登陆 where 卡号= + 账号.Text + and 密码= + 密码.Text + ; if (da.sread(pass) this.DialogResult = DialogResult.OK; this.Close(); else MessageBox.Show(用户名或密码错误，请重新输入！); 密码.Clear(); 密码.Clear(); 密码.Focus(); catch (Exce

5、ption error) MessageBox.Show(error.Message); ; private void 退出_Click(object sender, EventArgs e) this.Close(); private void groupBox2_Enter(object sender, EventArgs e) private void timer1_Tick(object sender, EventArgs e) label3.Left = label3.Left - 3; if (label3.Right 0) label3.Left = this.Width; pr

6、ivate void 账号_KeyPress(object sender, KeyPressEventArgs e) if (e.KeyChar=13) 密码.Focus(); private void 密码_KeyPress(object sender, KeyPressEventArgs e) if (e.KeyChar = 13) 登陆.Focus(); 三、主页面：输入卡号就能查询用户的余额状况，和进行对用户充值和消费金额public partial class index : Form public index() InitializeComponent(); data da = n

7、ew data(); private void 信息查询ToolStripMenuItem_Click(object sender, EventArgs e) Form f1 = new 信息查询(); f1.ShowDialog(); private void 信息管理ToolStripMenuItem_Click(object sender, EventArgs e) Form f2 = new 信息管理(); f2.ShowDialog(); private void f_Load(object sender, EventArgs e) Form f1 = new 登陆界面 (); f1

8、.ShowDialog(); if (f1.DialogResult = DialogResult.OK) else this.Close(); private void button3_Click(object sender, EventArgs e) if (textBox3.Text = ) MessageBox.Show(卡号为空请输入卡号！, 信息提示！); else da.conn(); string sql = select 卡号 From 信息 where 卡号= + textBox3.Text + ; OleDbCommand mycmd = new OleDbCommand

9、(); mycmd.CommandText = sql; mycmd.Connection = da.conn(); OleDbDataReader myreader = mycmd.ExecuteReader(); if (myreader.Read() try da.conn(); string mysql; mysql = select * from 信息 where 卡号 = + textBox3.Text + ; OleDbCommand mycomd = new OleDbCommand(); mycomd.CommandText = mysql; mycomd.Connectio

10、n = da.conn(); OleDbDataReader myreaderq = mycomd.ExecuteReader(); while (myreaderq.Read() textBox1.Text = myreaderq8.ToString(); catch (Exception error) MessageBox.Show(error.Message); else textBox1.Clear(); textBox3.Clear(); MessageBox.Show(请核对一下没有此人！, 信息提示！); private void button1_Click_1(object s

11、ender, EventArgs e) if (comboBox1 .Text = ) MessageBox.Show(请输入充值金额！, 信息提示提示！, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else try OleDbCommand mycomd = new OleDbCommand(); da.conn(); string mysql; mysql = UPDATE 信息 SET 余额=余额 + + Convert.ToInt32(comboBox1.Text) + where 卡号= + textBox3.Text +

12、; mycomd.CommandText = mysql; mycomd.Connection = da.conn(); mycomd.ExecuteNonQuery(); MessageBox.Show(是否充值？, 信息提示！, MessageBoxButtons.OKCancel, MessageBoxIcon.Question); catch (Exception error) MessageBox.Show(error.Message); private void 信息修改ToolStripMenuItem_Click(object sender, EventArgs e) Form

13、 f3 = new 修改(); f3.ShowDialog(); private void 帮助ToolStripMenuItem1_Click(object sender, EventArgs e) Form f4 = new 帮助(); f4.ShowDialog(); this.Close(); private void button2_Click(object sender, EventArgs e) if (comboBox2.Text = ) MessageBox.Show(请输入消费金额！, 信息提示提示！, MessageBoxButtons.OK, MessageBoxIco

14、n.Exclamation); else try da.conn(); OleDbCommand mycomd = new OleDbCommand(); string mysql; mysql = UPDATE 信息 SET 余额=余额 - + Convert.ToInt32(comboBox2.Text) + where 卡号= + textBox3.Text + ; mycomd.CommandText = mysql; mycomd.Connection = da.conn(); mycomd.ExecuteNonQuery(); MessageBox.Show(是否消费？, 信息提示

15、！, MessageBoxButtons.YesNo, MessageBoxIcon.Question); catch (Exception error) MessageBox.Show(error.Message); 四、信息查询：可以更具体更详细的查询学生的信息情况， public partial class 信息查询 : Form public 信息查询() InitializeComponent(); data da = new data(); private void button1_Click(object sender, EventArgs e) try if (textBox1

16、.Text = ) MessageBox.Show(卡号为空请输入卡号！, 信息提示提示！, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else da.conn(); string sql = select 卡号 From 信息 where 卡号= + textBox1.Text + ; if (da.sread (sql) da.conn(); string mysql1; mysql1 = SELECT * FROM 信息 where 卡号 = + textBox1.Text + ; OleDbDataAdapter myda =

17、 new OleDbDataAdapter(mysql1, da.conn(); DataSet myds = new DataSet(); myda.Fill(myds, 信息); dataGridView1.DataSource = myds.Tables信息; dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGrid

18、View1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode = DataGridViewAutoSizeColumnMode.Al

19、lCells; dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns8.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; da.conn().Close(); else MessageBox.Show(请核对一下没有此卡号！, 信息

20、提示！, MessageBoxButtons.OK, MessageBoxIcon.Warning); ; ; catch (Exception err) MessageBox.Show(err.Message); private void 信息查询ToolStripMenuItem_Click_1(object sender, EventArgs e) private void 信息管理ToolStripMenuItem_Click(object sender, EventArgs e) Form f2 = new 信息管理(); f2.ShowDialog(); private void

21、显示全部ToolStripMenuItem_Click(object sender, EventArgs e) try da.conn(); string mysql; mysql = SELECT * FROM 信息 ; OleDbDataAdapter myda = new OleDbDataAdapter(mysql, da.conn(); DataSet myds = new DataSet(); myda.Fill(myds, 信息); dataGridView1.DataSource = myds.Tables信息; dataGridView1.Columns0.AutoSizeM

22、ode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Co

23、lumns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode =DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; d

24、ataGridView1.Columns8.AutoSizeMode =DataGridViewAutoSizeColumnMode.AllCells; da.conn().Close(); catch (Exception err) MessageBox.Show(err.Message); private void 显示男生ToolStripMenuItem_Click(object sender, EventArgs e) try da.conn(); string mysql; mysql = SELECT * FROM 信息 where 性别=男 ; OleDbDataAdapter

25、 myda = new OleDbDataAdapter(mysql, da.conn(); DataSet myds = new DataSet(); myda.Fill(myds, 信息); dataGridView1.DataSource = myds.Tables信息; dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; da

26、taGridView1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode = DataGridViewAutoSizeColumnM

27、ode.AllCells; dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns8.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; da.conn().Close(); catch (Exception err) MessageB

28、ox.Show(err.Message); private void 显示女生ToolStripMenuItem_Click(object sender, EventArgs e) try da.conn(); string mysql; mysql = SELECT * FROM 信息 where 性别=女 ; OleDbDataAdapter myda = new OleDbDataAdapter(mysql, da.conn(); DataSet myds = new DataSet(); myda.Fill(myds, 信息); dataGridView1.DataSource = m

29、yds.Tables信息; dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;