進(jìn)銷庫存商品管理系統(tǒng)

1、目 錄第一章 開發(fā)背景和環(huán)境3第二章 程序功能分析及描述3-4第三章 總體和詳細(xì)設(shè)計5-11第四章 實(shí)現(xiàn)源碼12-27第五章 總結(jié) 27第一章【開發(fā)背景】 隨著我國大小企業(yè)經(jīng)營規(guī)模越來越大，企業(yè)需要隨時更新產(chǎn)品的進(jìn)銷信息，不斷更改商品信息，并對商品進(jìn)行系統(tǒng)分析。因此企業(yè)商品的進(jìn)銷管理系統(tǒng)需要引進(jìn)新的管理軟件，實(shí)現(xiàn)企業(yè)龐大的進(jìn)銷商品的管理規(guī)范化，從而方便企業(yè)的進(jìn)銷商品的決策?！鹃_發(fā)環(huán)境】 開發(fā)平臺：Microsoft Visual Studio 2010開發(fā)語言：Visual C# 2010后臺數(shù)據(jù)庫管理系統(tǒng)軟件：Microsoft SQL Server運(yùn)行平臺：Windows 7 第二章 【程

2、序功能分析及描述】在對企業(yè)銷售管理系統(tǒng)有了深刻的認(rèn)識后，為了解決企業(yè)銷售人員在商品管理和日常銷售中所存在的不足，讓企業(yè)工作人員有更好的、更方便的使用計算機(jī)對企業(yè)有關(guān)數(shù)據(jù)進(jìn)行管理，以實(shí)現(xiàn)無紙化操作方面進(jìn)行分析，企業(yè)系統(tǒng)應(yīng)進(jìn)行以下功能的實(shí)現(xiàn)。登錄模塊登錄模塊根據(jù)用戶角色不同在登陸成功以后被賦予相應(yīng)的操作權(quán)限，對管理系統(tǒng)有對進(jìn)貨商品的錄入、銷售商品的錄入等一些操作權(quán)限。登陸主窗體模塊 進(jìn)入主窗口時，用戶可以依據(jù)自己的交易選擇不同的窗口進(jìn)行操作。商品進(jìn)貨信息模塊 商品進(jìn)貨信息模塊是對每筆進(jìn)貨業(yè)務(wù)的進(jìn)貨編號、商品名稱、進(jìn)貨單價和數(shù)量的錄入功能的實(shí)現(xiàn)。進(jìn)貨信息查詢模塊進(jìn)貨信息查詢模塊是操作人員對進(jìn)貨業(yè)務(wù)的

3、查詢功能，可以通過查詢條件，查找相應(yīng)的信息。商品銷售信息模塊商品銷售信息模塊是對每筆銷售業(yè)務(wù)的銷售編號、商品名稱、銷售單價和數(shù)量的錄入功能的實(shí)現(xiàn)。商品退貨信息模塊商品退貨信息模塊是針對顧客銷售退回業(yè)務(wù)的信息進(jìn)行查詢。供應(yīng)商信息模塊 供應(yīng)商信息模塊是對商品供應(yīng)商信息的錄入，以便查詢。退出提醒系統(tǒng)模塊當(dāng)用戶退出時，會提醒用戶是否決定退出系統(tǒng) 意見反饋模塊意見反饋模塊，是提供一個平臺，將使用者的使用意見反饋給系統(tǒng)程序員，對該系統(tǒng)的改進(jìn)和提高。 注冊登錄新用戶模塊注冊新用戶信息。第三章【總體和詳細(xì)設(shè)計】 企業(yè)進(jìn)銷庫存銷售管理管理系統(tǒng)功能結(jié)構(gòu)圖：請輸入留言供應(yīng)商電話供應(yīng)商名稱退貨編號銷售數(shù)量銷售單價商品

4、名稱銷售編號查詢條件進(jìn)貨數(shù)量進(jìn)貨單價商品名稱【邏輯設(shè)計】商品進(jìn)貨表：字段名數(shù)據(jù)類型是否為主鍵描述IDInt是bhnchar否進(jìn)貨編號mcnchar是商品名稱djnchar是訂貨單價slnchar是訂貨數(shù)量供應(yīng)商信息表：字段名數(shù)據(jù)類型是否為主鍵描述IDInt是mcnchar否供貨商名稱dhnchar否供貨商電話【窗體設(shè)計】 登錄窗口： 主窗口：商品進(jìn)貨信息窗口：進(jìn)貨信息查詢窗口：商品銷售信息窗口：退貨查詢窗口：供應(yīng)商信息窗口：退出系統(tǒng)提醒窗口：意見反饋窗口：注冊信息窗口：【源代碼的實(shí)現(xiàn)】登錄模塊登錄模塊根據(jù)用戶角色不同在登陸成功以后被賦予相應(yīng)的操作權(quán)限，對管理系統(tǒng)有對進(jìn)貨商品的錄入、銷售商品的錄

5、入等一些操作權(quán)限。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace csharp public partial class Form1 : Form public Form1() InitializeComponent()

6、; private void button2_Click(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) SqlConnection con = new SqlConnection("server=SDJS-20140220WP;database=CS;Integrated Security =true"); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from log

7、where name='" + textBox1.Text.Trim() + "'and psw='" + textBox2.Text.Trim() + "'", con); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables0.Rows.Count = 0) MessageBox.Show("用戶名和密碼有誤.請重新輸入", "系統(tǒng)提示", MessageBoxButtons.OK, MessageBoxIcon.

8、Error); return; else MessageBox.Show("登陸成功,歡迎進(jìn)入！", "系統(tǒng)提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Form2 f2= new Form2(); f2.Show(); this.Hide(); private void label3_Click(object sender, EventArgs e) Form10 f10 =new Form10(); f10.Show(); this.Hide(); private void Form1

9、_Load(object sender, EventArgs e) 登陸主窗體模塊進(jìn)入主窗口時，用戶可以依據(jù)自己的交易選擇不同的窗口進(jìn)行操作。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace csharp public partial class Form2 : Form pu

10、blic Form2() InitializeComponent(); private void label1_Click(object sender, EventArgs e) private void 基本檔案BToolStripMenuItem_Click(object sender, EventArgs e) Form3 f3 = new Form3(); f3.Show(); this.Hide(); private void 進(jìn)貨管理CToolStripMenuItem_Click(object sender, EventArgs e) Form4 f4 = new Form4()

11、; f4.Show(); this.Hide(); private void 銷售管理SToolStripMenuItem_Click(object sender, EventArgs e) Form5 f5= new Form5(); f5.Show(); this.Hide(); private void 庫存管理DToolStripMenuItem_Click(object sender, EventArgs e) Form6 f6 = new Form6(); f6.Show(); this.Hide(); private void 供應(yīng)商信息ToolStripMenuItem_Cli

12、ck(object sender, EventArgs e) Form8 f8 = new Form8(); f8.Show(); this.Hide(); private void 系統(tǒng)維護(hù)KToolStripMenuItem_Click_1(object sender, EventArgs e) Form6 f6 = new Form6(); f6.Show(); this.Hide(); private void label1_Click_1(object sender, EventArgs e) private void button1_Click(object sender, Eve

13、ntArgs e) Form9 f9 = new Form9(); f9.Show(); this.Hide(); private void button2_Click(object sender, EventArgs e) Form1 f1=new Form1(); f1.Show(); this.Hide(); private void 意見反饋ToolStripMenuItem_Click(object sender, EventArgs e) Form11 f11 = new Form11(); f11.Show(); this.Hide(); ; private void Form2

14、_Load(object sender, EventArgs e) 商品進(jìn)貨信息模塊商品進(jìn)貨信息模塊是對每筆進(jìn)貨業(yè)務(wù)的進(jìn)貨編號、商品名稱、進(jìn)貨單價和數(shù)量的錄入功能的實(shí)現(xiàn)。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace c

15、sharp public partial class Form3 : Form public Form3() InitializeComponent(); private void textBox3_TextChanged(object sender, EventArgs e) private void Form3_Load(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection("server=S

16、DJS-20140220WP;database=CS;Integrated Security =true"); string strsql = "insert into dd(bh,mc,dj,sl) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')" SqlCom

17、mand comm = new SqlCommand(strsql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); if (Convert.ToInt32(comm.ExecuteNonQuery() > 0) MessageBox.Show("添加成功O(_)O", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("對不起，失敗了:>_<: &

18、quot;, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); conn.Close(); private void button2_Click(object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); 進(jìn)貨信息查詢模塊進(jìn)貨信息查詢模塊是操作人員對進(jìn)貨業(yè)務(wù)的查詢功能，可以通過查詢條件，查找相應(yīng)的信息。using System;using System.Collections.Generic;using System.

19、ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace csharp public partial class Form4 : Form public Form4() InitializeComponent(); public static SqlConnection con = new SqlConnection("server=S

20、DJS-20140220WP;database=CS;Integrated Security =true"); public static RichTextBox rt = new RichTextBox(); private void button2_Click(object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); private void textBox1_TextChanged(object sender, EventArgs e) private void button1_Cl

21、ick(object sender, EventArgs e) rt.Size = new Size(457, 203); rt.Location = new Point(17, 45); rt.Font = new Font(FontFamily.GenericSerif, 13); this.Controls.Add(rt); con.Open(); string sql = "select * from dd " SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader sqldr = cmd.ExecuteRe

22、ader(); rt.Text = "序號 編號 名稱 單價 數(shù)量n" rt.Text += "-n" /把數(shù)據(jù)從sqldr記錄集中一行一行的讀取出來并賦值給富文本框 rt的屬性 text if (sqldr.HasRows) while (sqldr.Read() rt.Text += " " + sqldr"ID" + " " + sqldr"bh" + " " + sqldr"mc" + " " + sqldr

23、"dj" + " " + sqldr"sl" + "n" sqldr.Close(); con.Close(); private void Form4_Load(object sender, EventArgs e) 商品銷售信息模塊商品銷售信息模塊是對每筆銷售業(yè)務(wù)的銷售編號、商品名稱、銷售單價和數(shù)量的錄入功能的實(shí)現(xiàn)。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using Sy

24、stem.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace csharp public partial class Form5 : Form public Form5() InitializeComponent(); private void button2_Click(object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); pri

25、vate void button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection("server=SDJS-20140220WP;database=CS;Integrated Security =true"); string strsql = "insert into dd(bh,mc,dj,sl) values ('" + textBox1.Text + "','" + textBox2.Text + &quo

26、t;','" + textBox3.Text + "','" + textBox4.Text + "')" SqlCommand comm = new SqlCommand(strsql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); if (Convert.ToInt32(comm.ExecuteNonQuery() > 0) MessageBox.Show("添加成功O(_)O", "提示&

27、quot;, MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("對不起，失敗了:>_<: ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); conn.Close(); private void Form5_Load(object sender, EventArgs e) 商品退貨信息模塊商品退貨信息模塊是針對顧客銷售退回業(yè)務(wù)的信息進(jìn)行查詢。using System;using S

28、ystem.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace csharp public partial class Form6 : Form public Form6() InitializeComponent(); private void button2_Click(

29、object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); private void button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection("server=SDJS-20140220WP;database=CS;Integrated Security =true"); string strsql = "delete dd where ID=('"

30、+ textBox1.Text + "')" SqlCommand comm = new SqlCommand(strsql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); if (Convert.ToInt32(comm.ExecuteNonQuery() > 0) MessageBox.Show("退貨成功，信息已刪除，請返回O(_)O", "提示", MessageBoxButtons.OK, MessageBoxIcon.Informat

31、ion); else MessageBox.Show("對不起，刪除失敗了:>_<:請檢測用戶名 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); conn.Close(); private void button3_Click(object sender, EventArgs e) SqlConnection con = new SqlConnection("server=SDJS-20140220WP;database=CS;Integrated Securi

32、ty =true"); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from dd where ID='" + textBox1.Text.Trim() + "'", con); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables0.Rows.Count = 0) MessageBox.Show("單號不存在.請重新輸入", "系統(tǒng)提示", Message

33、BoxButtons.OK, MessageBoxIcon.Error); return; else MessageBox.Show("可以退貨，請繼續(xù)！", "系統(tǒng)提示", MessageBoxButtons.OK, MessageBoxIcon.Information); private void Form6_Load(object sender, EventArgs e) 供應(yīng)商信息模塊供應(yīng)商信息模塊是對商品供應(yīng)商信息的錄入，以便查詢。using System;using System.Collections.Generic;using Syste

34、m.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace csharp public partial class Form8 : Form public Form8() InitializeComponent(); private void menuStrip1_ItemClicked(object sender, ToolStripItem

35、ClickedEventArgs e) private void Form8_Load(object sender, EventArgs e) private void button2_Click(object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); private void button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection("server=SDJS-20140220WP;d

36、atabase=CS;Integrated Security =true"); string strsql = "insert into gys(mc,dh) values ('" + textBox1.Text + "','" + textBox2.Text + "')" SqlCommand comm = new SqlCommand(strsql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); if (Conve

37、rt.ToInt32(comm.ExecuteNonQuery() > 0) MessageBox.Show("添加成功O(_)O", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("對不起，失敗了:>_<: ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); conn.Close(); 退出系統(tǒng)提醒模塊當(dāng)用戶退出時，會提

38、醒用戶是否決定退出系統(tǒng)。 using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace csharp public partial class Form9 : Form public Form9() InitializeComponent(); private void button2_C

39、lick(object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); private void button1_Click(object sender, EventArgs e) Application.Exit(); private void Form9_Load(object sender, EventArgs e) 意見反饋模塊意見反饋模塊，是提供一個平臺，將使用者的使用意見反饋給系統(tǒng)程序員，對該系統(tǒng)的改進(jìn)和提高。using System;using System.Collections.Gen

40、eric;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace csharp public partial class Form11 : Form public Form11() InitializeComponent(); private void label1_Click(object sender, Event

41、Args e) private void button1_Click(object sender, EventArgs e) Form2 f2 = new Form2(); f2.Show(); this.Close(); private void button2_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection("server=SDJS-20140220WP;database=CS;Integrated Security =true"); string strsql = &qu

42、ot;insert into rep(rp) values ('" + richTextBox1 + "')" SqlCommand comm = new SqlCommand(strsql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); if (Convert.ToInt32(comm.ExecuteNonQuery() > 0) MessageBox.Show("留言成功O(_)O", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("對不起，失敗了，請稍后重試！