C#程序超市管理系統(tǒng)

1、.河南機(jī)電高等?？茖W(xué)校學(xué)生課程設(shè)計(jì)報(bào)告實(shí)驗(yàn)課程名稱c#程序設(shè)計(jì)及應(yīng)用教程開課實(shí)驗(yàn)室實(shí)字 3 號(hào)樓 301系、部計(jì)科系年級(jí)11 專業(yè)班軟件 111（對(duì)口學(xué)生姓名胡玉祥學(xué)號(hào)開課時(shí)間2012至2013學(xué)年第一學(xué)期總 成 績教師簽名.C#程序設(shè)計(jì)課程設(shè)計(jì)報(bào)告2013年 1 月15 日系部計(jì)科系年級(jí)、專業(yè)、班軟件 111姓名課程項(xiàng)目指導(dǎo)C#程序設(shè)計(jì)超市管理系統(tǒng)名稱名稱教師教師評(píng)教師簽名：語年月日一、 課程設(shè)計(jì)目的經(jīng)過一學(xué)期對(duì) c#開發(fā)語言的學(xué)習(xí)， 利用本學(xué)期所學(xué)的知識(shí)進(jìn)行一次簡單的檢測，因此做了本系統(tǒng)。二、實(shí)驗(yàn)環(huán)境裝有 Visual studio 2010和 sql 數(shù)據(jù)庫的計(jì)算機(jī)一臺(tái)。三、實(shí)驗(yàn)過程及內(nèi)

2、容1、課題分析及要求：利用C#編程語言，結(jié)合數(shù)據(jù)庫完成本系統(tǒng)開發(fā)。需包含模塊：進(jìn)貨登記、銷售記錄管理、庫存管理、商品查詢、人員管理。2、程序分析：本系統(tǒng)根據(jù)要求可分為：登錄模塊，管理員模塊和普通用戶模塊，其開始數(shù)據(jù)庫用戶登錄管理員用戶是否管理員普通用戶人銷商庫銷盈商品出售進(jìn)員售品存售利貨管情查管記狀理況詢理錄況結(jié)束.中，管理員模塊中又可分為：進(jìn)貨登記、銷售記錄管理、庫存管理、商品查詢、人員管理。3、程序流程圖（如上圖所示）4、程序代碼：連接數(shù)據(jù)庫的類Sjk 的代碼using System;using System.Linq;using System.Text;using System.Data

3、;namespace chaoshiguanlixitongclass Sjkpublic string s = ""public SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=csgl; Integrated Security=SSPI");public string cx(string sql)DataTable dt = new DataTable();using (SqlDataAdapter adapter = new SqlDataAda

4、pter(sql, conn)s = ""tryadapter.Fill(dt);foreach (DataRow dr in dt.Rows) s = dr0.ToString();catch (Exception ex)s = ex.ToString();return s;public string cx(string sql, int i)s = ""DataTable dt = new DataTable();using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conn).tryadap

5、ter.Fill(dt);foreach (DataRow dr in dt.Rows)for (int k = 0; k < i; k+)s += drk.ToString() + ","catch (Exception ex) s = ex.ToString(); return s;public string tj(string sql)s = ""SqlCommand myupdater = new SqlCommand(sql, conn); tryconn.Open();myupdater.ExecuteNonQuery();conn.C

6、lose();catch (Exception ex)s = ex.ToString ();conn.Close();return s;public int qh(string sql)int i = 0;DataTable dt1 = new DataTable();using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conn)tryadapter.Fill(dt1);foreach (DataRow dr1 in dt1.Rows)i += int.Parse(dr10.ToString();.finally return i;p

7、ublic int xg(string sql)int i=-1;using (SqlCommand cmd = new SqlCommand(sql, conn)tryconn.Open();i = cmd.ExecuteNonQuery();conn.Close();catch (Exception ) conn.Close(); return i;登錄窗體 Form1 的代碼 :using System;using System.ComponentModel;using System.Drawing;using System.Linq;using System.Text;namespac

8、e chaoshiguanlixitongpublic partial class Form1 : Formpublic static string yhm;public Form1() InitializeComponent();private void button1_Click(object sender, EventArgs e)if (textBox1.Text = "" | textBox2.Text = "") label3.Text = " 賬號(hào)或密碼不能為空！ " else.stringm ="select

9、密 碼fromdengluwhere賬 號(hào) ='"+textBox1.Text + "'"stringg = "select管 理員fromdengluwhere 賬號(hào) ='"+textBox1.Text + "'"Sjk d = new Sjk();if (d.cx(m).Trim() = textBox2.Text)yhm = textBox1.Text;if (d.cx(g).Trim() = "t")Form2 f2 = new Form2();f2.Show();

10、elseForm3 f3 = new Form3();f3.Show();this.Hide();else label3.Text = "賬號(hào)或密碼錯(cuò)誤，請(qǐng)重新輸入！" 管理員窗口 Form2 的代碼：using System;using System.ComponentModel;using System.Drawing;using System.Linq;using System.Text;namespace chaoshiguanlixitongpublic partial class Form2 : FormSjk shujuku = new Sjk();/定義一個(gè)

11、數(shù)據(jù)庫的對(duì)象public static string hh, hl;/想 xinhuo 窗體傳遞參數(shù)public Form2()InitializeComponent();.private void Form2_Load(object sender, EventArgs e)/ TODO:這行代碼將數(shù)據(jù)加載到表“csglDataSet1.xsb”中。您可以根據(jù)需要移動(dòng)或刪除它。/TODO: 這行代碼將數(shù)據(jù)加載到表“csglDataSet1.spxx”中。您可以根據(jù)需要移動(dòng)或刪除它。/ TODO:這行代碼將數(shù)據(jù)加載到表“csglDataSet.denglu”中。您可以根據(jù)需要移動(dòng)或刪除它。/ T

12、ODO:這行代碼將數(shù)據(jù)加載到表“csglDataSet.spxx”中。您可以根據(jù)需要移動(dòng)或刪除它。string h= "select用戶名 from denglu where賬號(hào) ='" + Form1.yhm+ "'"label2.Text = Form1.yhm ;this.Text = shujuku .cx(h)+ "（管理員用戶） "private void button1_Click(object sender, EventArgs e)DialogResult k1 = MessageBox.Show(&

13、quot;你確定要退出當(dāng)前用戶切換到另一用戶？ ", "", MessageBoxButtons.YesNo);if (k1 = DialogResult.Yes)this.Close();Form1 f1 = new Form1();f1.Show();private void button2_Click(object sender, EventArgs e)DialogResult k1 = MessageBox.Show("你確定要退出當(dāng)前用戶？ ", "", MessageBoxButtons.YesNo);if (

14、k1 = DialogResult.Yes) Application.Exit();private void button3_Click(object sender, EventArgs e)int sl=0;if (jhspbh.Text = "" | jhsl.Text = "") MessageBox.Show(" 商品編號(hào)或數(shù)量不能為空！ "); else.try/判斷輸入的進(jìn)貨數(shù)量是否為數(shù)字 sl = int.Parse(jhsl.Text); catchMessageBox.Show("請(qǐng)輸入正確的商品數(shù)量！ (

15、 商品數(shù)量必須為大于 0 的數(shù)字 )");jhsl.Text = ""if (sl > 0)string sql = "update spxx set數(shù)量 =數(shù)量 +" + jhsl.Text +"where 商品編號(hào) ='" + jhspbh.Text + "'"int i=shujuku.xg(sql);if (i>=0)if (i = 0)hh = jhspbh.Text; hl = jhsl.Text;xinhuo xh = new xinhuo();xh.Show()

16、;xh.Visible = false;if (xh.ShowDialog() = DialogResult.OK) MessageBox.Show(" 商品添加成功！ "); jhspbh.Text = ""jhsl.Text = ""else MessageBox.Show("打開數(shù)據(jù)庫失敗，請(qǐng)重試！");private void button4_Click(object sender, EventArgs e)/商品查詢中的“查詢”按鈕if(spcx.Text ="") MessageBo

17、x.Show(" 你還沒輸入要查詢的商品編號(hào)呢！ "); elsestringsql = "select* from spxx where 商品編號(hào) ='"+ spcx.Text.+ "'"string j = shujuku.cx(sql, 7).Split(',');label12 . Text = j0.ToString();label13 . Text = j1.ToString();label15 . Text = j2.ToString();label17 . Text = j3.ToStr

18、ing();label19 . Text = j4.ToString();label21 . Text = j5.ToString();label23 . Text = j6.ToString();sql= "select出 售 數(shù)量fromxsbwhere商 品 編 號(hào) ='"+spcx.Text + "'"label25.Text = shujuku.qh(sql).ToString();private void button7_Click(object sender, EventArgs e) /人員管理中的刪除按鈕if(ryglx

19、m.Text ="") MessageBox.Show(" 你還沒輸入要?jiǎng)h除的賬號(hào)呢，不能刪除！ "); elseif (ryglxm.Text = label2.Text) /判斷要?jiǎng)h除的是不是當(dāng)前登陸用戶MessageBox.Show("你不能刪除當(dāng)前登陸的賬號(hào)哦！"); elsestringsql="deletefromdengluwhere賬號(hào)='"+ryglxm.Text +"'"shujuku.cx(sql);private void button8_Click(ob

20、ject sender, EventArgs e) /人員管理中的提交按鈕char s='f'if (radioButton1.Checked) s='t' if (textBox1.Text = "" | textBox2.Text = "" | textBox3.Text= "" | textBox4.Text = "") MessageBox.Show(" 用戶名，賬號(hào)和密碼不能為空哦！ "); else.if (textBox3.Text != textB

21、ox4.Text) MessageBox.Show("確認(rèn)密碼和密碼不一樣哦！");elsestring sql = "insert into denglu (用戶名 , 賬號(hào) , 密碼 , 管理員 )values('"+textBox1.Text+ "','"+ textBox2.Text+ "','"+textBox3.Text + "','" +s + "')"string i=shujuku.tj(sql

22、);if (i = "") MessageBox.Show(" 添 加 用 戶 成 功 ！else MessageBox.Show(i); privatevoid button5_Click(objectsender,EventArgs e)/新貨上架if (tjhh.Text = "") MessageBox.Show("貨號(hào)不能為空！ ");elsestringsql ="select* from spxx where 商品編號(hào) ='"+ tjhh.Text+"'"

23、string s1 = shujuku.cx(sql);if(s1!="") MessageBox.Show(" 這件貨物存在了哦！ "); elsehh = tjhh.Text ;xinhuo xh = new xinhuo();xh.Show();xh.Visible = false;if (xh.ShowDialog() = DialogResult.OK)MessageBox.Show("添加新貨成功！ ");.privatevoidbutton6_Click(objectsender,EventArgse)/ 貨物下架if

24、(xjhh.Text = "")MessageBox.Show("貨號(hào)不能為空！ ");elsestringsql = "select* from spxx where 商品編號(hào) ='"+ xjhh.Text+ "'"string s1 = shujuku.cx(sql);if (s1 = "")MessageBox.Show("這個(gè)貨物不存在哦！不能刪除！");elseDialogResult xh=MessageBox .Show (" 你確定要

25、刪除這件貨物？ n 如果是請(qǐng)點(diǎn)擊確定按鈕。 ","",MessageBoxButtons .YesNo );if (xh = DialogResult.OK)sql="deletefromspxxwhere商 品編 號(hào)='"+ryglxm.Texti +"'"shujuku.cx(sql);private void dataGridView4_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)Intnumber=Convert.ToIn

26、t32(dataGridView4.Rowse.RowIndex.Cells" 數(shù) 量 DataGridViewTextBoxColumn2".Value);if (number >100)dataGridView4.Rowse.RowIndex.DefaultCellStyle.BackColor= Color.Red;.else if (number<50)dataGridView4.Rowse.RowIndex.DefaultCellStyle.BackColor= Color.Blue;elsedataGridView4.Rowse.RowIndex.D

27、efaultCellStyle.BackColor= Color.White;private void button9_Click(object sender, EventArgs e)string sql = "select sum(銷售量 ) from spxx "label39.Text =shujuku.cx(sql);sql = "select sum(銷售金額 ) from spxx"label40.Text = shujuku.cx(sql);普通用戶的窗口Form3的代碼：using System;using System.Compone

28、ntModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;namespace chaoshiguanlixitongpublic partial class Form3 : Formpublic static string whe=""string s=new string 50;public int k=0;Sjk shujuku = new Sjk();public Form3()InitializeComponent();private void Form3_L

29、oad(object sender, EventArgs e).SqlConnectionconn=newSqlConnection("DataSource=(local);Initial Catalog=csgl; Integrated Security=SSPI"); /連接對(duì)象string sql = "select用戶名 , 賬號(hào) from denglu where賬號(hào) ='" +Form1.yhm + "'"DataTable dt = new DataTable();using (SqlDataAdapte

30、r adapter = new SqlDataAdapter(sql, conn)tryadapter.Fill(dt);foreach (DataRow dr in dt.Rows)label2.Text = dr1.ToString();this.Text = dr0.ToString()+"(普通用戶 )"finally private void button1_Click(object sender, EventArgs e)DialogResult k1 = MessageBox.Show("你確定要退出當(dāng)前用戶切換到另一用戶？ ", &quo

31、t;", MessageBoxButtons.YesNo);if (k1 = DialogResult.Yes)this.Hide();Form1 f1 = new Form1();f1.Show();private void button2_Click(object sender, EventArgs e)DialogResult k1 = MessageBox.Show("你確定要退出當(dāng)前用戶？ ", "", MessageBoxButtons.YesNo);if (k1 = DialogResult.Yes)Application.Exi

32、t();private void button3_Click(object sender, EventArgs e).sk = textBox1.Text;whe+="商品編號(hào) ='"+textBox1.Text +"' "SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=csgl; Integrated Security=SSPI");stringsql = "select商品編號(hào) , 商品名 , 價(jià)格 f

33、rom spxx where "+whe ;whe += "OR"SqlCommand cmd = new SqlCommand(sql, conn);conn.Open();SqlDataReader temp = cmd.ExecuteReader();BindingSource bs = new BindingSource();bs.DataSource = temp;dataGridView1.DataSource = bs;temp.Close();private void button4_Click(object sender, EventArgs e

34、)string sql;char y = 'O', 'R' ;whe = whe.Trim(y);for (int i = 0; i <= k; i+)sql = "insert into xsb (商品編號(hào) , 出售賬號(hào) , 出售數(shù)量 , 出售時(shí)間 )values('"+ si + "','" + Form1.yhm + "','1','" +shujuku.tj(sql);sql = "update spxx set數(shù)量 =數(shù)量

35、 -1 where " + whe;shujuku.cx(sql);jiesuan xh = new jiesuan ();xh.Show();xh.Visible = false;if (xh.ShowDialog() = DialogResult.OK) whe = ""進(jìn)貨時(shí)發(fā)現(xiàn)新貨時(shí)彈出的自定義對(duì)話框xinhuo 的代碼：using System;using System.ComponentModel;using System.Drawing;using System.Linq;.using System.Text;namespace chaoshigua

36、nlixitongpublic partial class xinhuo : Formpublic xinhuo()InitializeComponent();private void button1_Click(object sender, EventArgs e)if (textBox1.Text = "" | textBox2.Text = "" | textBox3.Text= "" | textBox4.Text = "" | textBox5.Text = "" | textBox6

37、.Text = "")MessageBox.Show("商品名，價(jià)格，生產(chǎn)廠 n 家或保質(zhì)期不能為空！"); elsestring sql = "insert into spxx (商品編號(hào) , 商品名 , 價(jià)格 , 數(shù)量 ,商品生產(chǎn)廠家 , 保質(zhì)期 )values('"+textBox1.Text+ "','"+ textBox2.Text+ "','"+textBox3.Text + "','" +textBox4.Text+"','"+textBox5.Text+"','"+textBox6.Text+"')"Sjk s=new Sjk ();string i =s.tj(sql);if (i="")this.DialogResult = DialogResult.OK;else MessageBox.Show(i); private void xin