餐廳管理摘要

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

2、：建立數(shù)據(jù)庫庫連接和數(shù)據(jù)庫讀取方法。public OleDbConnection conn() OleDbConnection myco = new OleDbConnection(); string mystr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|學(xué)生信息.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; 二、建設(shè)登陸界面：賬號(hào)和登錄密碼：登陸界面中的賬號(hào)和密碼都要和事先前建立的數(shù)據(jù)庫相連接，要建立許多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 卡號(hào)='" + 賬號(hào).Text + "' and 密碼='" + 密碼.Text + "'" if (da.sread(pass) this.DialogResult = DialogResult.OK; this.Close(); else MessageBox.Sho

5、w("用戶名或密碼錯(cuò)誤，請(qǐng)重新輸入！"); 密碼.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 賬號(hào)_KeyPress(object sender, KeyPressEventArgs e) if (e.KeyChar=13) 密碼.Focus(); private void 密碼_KeyPress(object sender, KeyPressEventArgs e) if (e.KeyChar = 13) 登陸.Focus(); 三、主頁面：輸入卡號(hào)就能查詢用戶的余額狀況，和進(jìn)行對(duì)用戶充值和消費(fèi)金

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("卡號(hào)為空請(qǐng)輸入卡號(hào)！", "信息提示！&qu

9、ot;); else da.conn(); string sql = "select 卡號(hào) From 信息 where 卡號(hào)='" + 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 卡號(hào) ='" + 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("請(qǐng)核對(duì)一下沒有此人！", "信息提示！"); private void button1_Click_1(object sender, EventArgs e) if (comboBox1 .Text = "") MessageBox.Show("請(qǐng)輸入充值金額！&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 卡號(hào)='" + 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ǐng)輸入消費(fèi)金額！&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 卡號(hào)='" + textBox3.Text + "'&

16、quot; mycomd.CommandText = mysql; mycomd.Connection = da.conn(); mycomd.ExecuteNonQuery(); MessageBox.Show("是否消費(fèi)？", "信息提示！", MessageBoxButtons.YesNo, MessageBoxIcon.Question); catch (Exception error) MessageBox.Show(error.Message); 四、信息查詢：可以更具體更詳細(xì)的查詢學(xué)生的信息情況， 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("卡號(hào)為空請(qǐng)輸入卡號(hào)！", "信息提示提示！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else da.conn(); string s

18、ql = "select 卡號(hào) From 信息 where 卡號(hào)='" + textBox1.Text + "'" if (da.sread (sql) da.conn(); string mysql1; mysql1 = "SELECT * FROM 信息 where 卡號(hào) ='" + 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("請(qǐng)核對(duì)一下沒有此卡號(hào)！", "信息提示！", 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 計(jì)算機(jī)與信息工程學(xué)院ToolStripMenuItem_Click(object sender, EventArgs e) try da.conn(); string mysql; mysql = "SELECT * FROM 信息 where 院系='計(jì)算機(jī)與信息工程學(xué)院' " 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 班級(jí)='軟件一班' " OleDbDataAdapter myda = new OleDbDataAdapter(mysql, da.conn(); DataSet myds = new DataSet(); myda.Fill(myds, "信息"); dataGridView1.DataSource = myds.Tables"信息" dataGridView1.Columns0.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGrid