餐廳管理摘要

1、餐廳消費管理系統(tǒng)民以食為天，學生餐廳就餐，在人流的高峰期拿著錢去就餐的話服務員忙著找零錢都非常不方便，再一點每個人吃飯時手里拿著錢也是不衛(wèi)生的，餐廳管理系統(tǒng)是為方便管理學生就餐而設計的。首先餐廳只需一個收銀員管理充錢和辦理餐卡的信息管理，而不需要每個餐廳都自己配備一個專門找零錢工，并且也方便學校對學生在校的就餐情況的了解。本系統(tǒng)主要用 C#語言為基礎編程語言，運用Microsoft Visual Studio 2005設計前臺界面，運用Microsoft Office Access 2003作為后臺數據庫，運用c#設計與數據庫連接的接口，方便簡潔的操作就能很好的管理數據庫系統(tǒng)。一、 建立一個類

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 my

3、cmd = new OleDbCommand(sql,conn (); OleDbDataReader myreader = mycmd.ExecuteReader(); if (myreader.Read() return true; else return false; 二、建設登陸界面：賬號和登錄密碼：登陸界面中的賬號和密碼都要和事先前建立的數據庫相連接，要建立許多messagebox信息提示確保解決用戶在登錄所遇到的問題。public partial class 登陸界面 : Form public 登陸界面() InitializeComponent(); data da = new

4、 data(); private 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.Sho

5、w("用戶名或密碼錯誤，請重新輸入！"); 密碼.Clear(); 密碼.Clear(); 密碼.Focus(); catch (Exception 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)

6、label3.Left = label3.Left - 3; if (label3.Right < 0) label3.Left = this.Width; private void 賬號_KeyPress(object sender, KeyPressEventArgs e) if (e.KeyChar=13) 密碼.Focus(); private void 密碼_KeyPress(object sender, KeyPressEventArgs e) if (e.KeyChar = 13) 登陸.Focus(); 三、主頁面：輸入卡號就能查詢用戶的余額狀況，和進行對用戶充值和消費金

7、額public partial class index : Form public index() InitializeComponent(); data da = new 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.Sho

8、wDialog(); private void f_Load(object sender, EventArgs e) Form f1 = new 登陸界面 (); f1.ShowDialog(); if (f1.DialogResult = DialogResult.OK) else this.Close(); private void button3_Click(object sender, EventArgs e) if (textBox3.Text = "") MessageBox.Show("卡號為空請輸入卡號！", "信息提示！&qu

9、ot;); else da.conn(); string sql = "select 卡號 From 信息 where 卡號='" + textBox3.Text + "'" OleDbCommand mycmd = new OleDbCommand(); mycmd.CommandText = sql; mycmd.Connection = da.conn(); OleDbDataReader myreader = mycmd.ExecuteReader(); if (myreader.Read() try da.conn(); str

10、ing mysql; mysql = "select * from 信息 where 卡號 ='" + textBox3.Text + "'" OleDbCommand mycomd = new OleDbCommand(); mycomd.CommandText = mysql; mycomd.Connection = da.conn(); OleDbDataReader myreaderq = mycomd.ExecuteReader(); while (myreaderq.Read() textBox1.Text = myreade

11、rq8.ToString(); catch (Exception error) MessageBox.Show(error.Message); else textBox1.Clear(); textBox3.Clear(); MessageBox.Show("請核對一下沒有此人！", "信息提示！"); private void button1_Click_1(object sender, EventArgs e) if (comboBox1 .Text = "") MessageBox.Show("請輸入充值金額！&quo

12、t;, "信息提示提示！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else try OleDbCommand mycomd = new OleDbCommand(); da.conn(); string mysql; mysql = "UPDATE 信息 SET 余額=余額 +'" + Convert.ToInt32(comboBox1.Text) + "' where 卡號='" + textBox3.Text + "'&qu

13、ot; 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

14、 sender, EventArgs e) Form 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("請輸入消費金額！&q

15、uot;, "信息提示提示！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else try da.conn(); OleDbCommand mycomd = new OleDbCommand(); string mysql; mysql = "UPDATE 信息 SET 余額=余額 -'" + Convert.ToInt32(comboBox2.Text) + "' where 卡號='" + textBox3.Text + "'&

16、quot; mycomd.CommandText = mysql; mycomd.Connection = da.conn(); mycomd.ExecuteNonQuery(); MessageBox.Show("是否消費？", "信息提示！", MessageBoxButtons.YesNo, MessageBoxIcon.Question); catch (Exception error) MessageBox.Show(error.Message); 四、信息查詢：可以更具體更詳細的查詢學生的信息情況， public partial class

17、信息查詢 : Form public 信息查詢() InitializeComponent(); data da = new data(); private void button1_Click(object sender, EventArgs e) try if (textBox1.Text = "") MessageBox.Show("卡號為空請輸入卡號！", "信息提示提示！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else da.conn(); string s

18、ql = "select 卡號 From 信息 where 卡號='" + textBox1.Text + "'" if (da.sread (sql) da.conn(); string mysql1; mysql1 = "SELECT * FROM 信息 where 卡號 ='" + textBox1.Text + "'" OleDbDataAdapter myda = new OleDbDataAdapter(mysql1, da.conn(); DataSet myds =

19、new DataSet(); myda.Fill(myds, "信息"); dataGridView1.DataSource = myds.Tables"信息" dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns2.AutoSizeMode = Dat

20、aGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns6.Au

21、toSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns8.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; da.conn().Close(); else MessageBox.Show("請核對一下沒有此卡號！", "信息提示！", Mess

22、ageBoxButtons.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 顯示全部ToolS

23、tripMenuItem_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"信息" dataGri

24、dView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.A

25、llCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode =DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoS

26、izeColumnMode.AllCells; dataGridView1.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 信

27、息 where 性別='男' " OleDbDataAdapter myda = new OleDbDataAdapter(mysql, da.conn(); DataSet myds = new DataSet(); myda.Fill(myds, "信息"); dataGridView1.DataSource = myds.Tables"信息" dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView

28、1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCel

29、ls; dataGridView1.Columns5.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns8.AutoSizeMode = DataGridViewAutoSizeC

30、olumnMode.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 myda = new OleDbDataAdapter(mysql,

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

32、olumns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;

33、 dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns8.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; da.conn().Close(); catch (Exception err) MessageBox.Show(err.M

34、essage); 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, "信息&q

35、uot;); dataGridView1.DataSource = myds.Tables"信息" dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dat

36、aGridView1.Columns3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns5.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns6.AutoSizeMode = DataGridViewAutoSizeColumnMo

37、de.AllCells; dataGridView1.Columns7.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns8.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; da.conn().Close(); catch (Exception err) MessageBox.Show(err.Message); private void 軟件一班ToolStripMenuItem_Click(object sender, Ev

38、entArgs 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 = myds.Tables"信息" dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGrid