C#版進(jìn)銷庫(kù)存商品管理系統(tǒng)

./目錄第一章開(kāi)發(fā)背景和環(huán)境………3第二章程序功能分析及描述………………3--4第三章總體和詳細(xì)設(shè)計(jì)……5--11第四章實(shí)現(xiàn)源碼……………12--27第五章總結(jié)……………………27第一章[開(kāi)發(fā)背景]隨著我國(guó)大小企業(yè)經(jīng)營(yíng)規(guī)模越來(lái)越大,企業(yè)需要隨時(shí)更新產(chǎn)品的進(jìn)銷信息,不斷更改商品信息,并對(duì)商品進(jìn)行系統(tǒng)分析。因此企業(yè)商品的進(jìn)銷管理系統(tǒng)需要引進(jìn)新的管理軟件,實(shí)現(xiàn)企業(yè)龐大的進(jìn)銷商品的管理規(guī)范化,從而方便企業(yè)的進(jìn)銷商品的決策。[開(kāi)發(fā)環(huán)境]開(kāi)發(fā)平臺(tái)：MicrosoftVisualStudio2010開(kāi)發(fā)語(yǔ)言：VisualC#2010后臺(tái)數(shù)據(jù)庫(kù)管理系統(tǒng)軟件：MicrosoftSQLServer運(yùn)行平臺(tái)：Windows7第二章[程序功能分析及描述]在對(duì)企業(yè)銷售管理系統(tǒng)有了深刻的認(rèn)識(shí)后,為了解決企業(yè)銷售人員在商品管理和日常銷售中所存在的不足,讓企業(yè)工作人員有更好的、更方便的使用計(jì)算機(jī)對(duì)企業(yè)有關(guān)數(shù)據(jù)進(jìn)行管理,以實(shí)現(xiàn)無(wú)紙化操作方面進(jìn)行分析,企業(yè)系統(tǒng)應(yīng)進(jìn)行以下功能的實(shí)現(xiàn)。登錄模塊登錄模塊根據(jù)用戶角色不同在登陸成功以后被賦予相應(yīng)的操作權(quán)限,對(duì)管理系統(tǒng)有對(duì)進(jìn)貨商品的錄入、銷售商品的錄入等一些操作權(quán)限。登陸主窗體模塊進(jìn)入主窗口時(shí),用戶可以依據(jù)自己的交易選擇不同的窗口進(jìn)行操作。商品進(jìn)貨信息模塊商品進(jìn)貨信息模塊是對(duì)每筆進(jìn)貨業(yè)務(wù)的進(jìn)貨編號(hào)、商品名稱、進(jìn)貨單價(jià)和數(shù)量的錄入功能的實(shí)現(xiàn)。進(jìn)貨信息查詢模塊進(jìn)貨信息查詢模塊是操作人員對(duì)進(jìn)貨業(yè)務(wù)的查詢功能,可以通過(guò)查詢條件,查找相應(yīng)的信息。商品銷售信息模塊商品銷售信息模塊是對(duì)每筆銷售業(yè)務(wù)的銷售編號(hào)、商品名稱、銷售單價(jià)和數(shù)量的錄入功能的實(shí)現(xiàn)。商品退貨信息模塊商品退貨信息模塊是針對(duì)顧客銷售退回業(yè)務(wù)的信息進(jìn)行查詢。供應(yīng)商信息模塊供應(yīng)商信息模塊是對(duì)商品供應(yīng)商信息的錄入,以便查詢。退出提醒系統(tǒng)模塊當(dāng)用戶退出時(shí),會(huì)提醒用戶是否決定退出系統(tǒng)意見(jiàn)反饋模塊意見(jiàn)反饋模塊,是提供一個(gè)平臺(tái),將使用者的使用意見(jiàn)反饋給系統(tǒng)程序員,對(duì)該系統(tǒng)的改進(jìn)和提高。注冊(cè)登錄新用戶模塊注冊(cè)新用戶信息。第三章[總體和詳細(xì)設(shè)計(jì)]企業(yè)進(jìn)銷庫(kù)存銷售管理管理系統(tǒng)功能結(jié)構(gòu)圖：請(qǐng)輸入留言供應(yīng)商電話供應(yīng)商名稱退貨編號(hào)銷售數(shù)量銷售單價(jià)商品名稱銷售編號(hào)查詢條件進(jìn)貨數(shù)量進(jìn)貨單價(jià)商品名稱[邏輯設(shè)計(jì)]商品進(jìn)貨表：字段名數(shù)據(jù)類型是否為主鍵描述IDInt是bhnchar否進(jìn)貨編號(hào)mcnchar是商品名稱djnchar是訂貨單價(jià)slnchar是訂貨數(shù)量供應(yīng)商信息表：字段名數(shù)據(jù)類型是否為主鍵描述IDInt是mcnchar否供貨商名稱dhnchar否供貨商電話[窗體設(shè)計(jì)]登錄窗口：主窗口：商品進(jìn)貨信息窗口：進(jìn)貨信息查詢窗口：商品銷售信息窗口：退貨查詢窗口：供應(yīng)商信息窗口：退出系統(tǒng)提醒窗口：意見(jiàn)反饋窗口：注冊(cè)信息窗口：[源代碼的實(shí)現(xiàn)]登錄模塊登錄模塊根據(jù)用戶角色不同在登陸成功以后被賦予相應(yīng)的操作權(quán)限,對(duì)管理系統(tǒng)有對(duì)進(jìn)貨商品的錄入、銷售商品的錄入等一些操作權(quán)限。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacecsharp{publicpartialclassForm1:Form{publicForm1<>{InitializeComponent<>;}privatevoidbutton2_Click<objectsender,EventArgse>{}privatevoidbutton1_Click<objectsender,EventArgse>{SqlConnectioncon=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;con.Open<>;SqlDataAdapterda=newSqlDataAdapter<"select*fromlogwherename='"+textBox1.Text.Trim<>+"'andpsw='"+textBox2.Text.Trim<>+"'",con>;DataSetds=newDataSet<>;da.Fill<ds>;if<ds.Tables[0].Rows.Count==0>{MessageBox.Show<"用戶名和密碼有誤.請(qǐng)重新輸入","系統(tǒng)提示",MessageBoxButtons.OK,MessageBoxIcon.Error>;return;}else{MessageBox.Show<"登陸成功,歡迎進(jìn)入！","系統(tǒng)提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;Form2f2=newForm2<>;f2.Show<>;this.Hide<>;}}privatevoidlabel3_Click<objectsender,EventArgse>{Form10f10=newForm10<>;f10.Show<>;this.Hide<>;}privatevoidForm1_Load<objectsender,EventArgse>{}}}登陸主窗體模塊進(jìn)入主窗口時(shí),用戶可以依據(jù)自己的交易選擇不同的窗口進(jìn)行操作。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespacecsharp{publicpartialclassForm2:Form{publicForm2<>{InitializeComponent<>;}privatevoidlabel1_Click<objectsender,EventArgse>{}privatevoid基本檔案BToolStripMenuItem_Click<objectsender,EventArgse>{Form3f3=newForm3<>;f3.Show<>;this.Hide<>;}privatevoid進(jìn)貨管理CToolStripMenuItem_Click<objectsender,EventArgse>{Form4f4=newForm4<>;f4.Show<>;this.Hide<>;}privatevoid銷售管理SToolStripMenuItem_Click<objectsender,EventArgse>{Form5f5=newForm5<>;f5.Show<>;this.Hide<>;}privatevoid庫(kù)存管理DToolStripMenuItem_Click<objectsender,EventArgse>{Form6f6=newForm6<>;f6.Show<>;this.Hide<>;}privatevoid供應(yīng)商信息ToolStripMenuItem_Click<objectsender,EventArgse>{Form8f8=newForm8<>;f8.Show<>;this.Hide<>;}privatevoid系統(tǒng)維護(hù)KToolStripMenuItem_Click_1<objectsender,EventArgse>{Form6f6=newForm6<>;f6.Show<>;this.Hide<>;}privatevoidlabel1_Click_1<objectsender,EventArgse>{}privatevoidbutton1_Click<objectsender,EventArgse>{Form9f9=newForm9<>;f9.Show<>;this.Hide<>;}privatevoidbutton2_Click<objectsender,EventArgse>{Form1f1=newForm1<>;f1.Show<>;this.Hide<>;}privatevoid意見(jiàn)反饋ToolStripMenuItem_Click<objectsender,EventArgse>{Form11f11=newForm11<>;f11.Show<>;this.Hide<>;;}privatevoidForm2_Load<objectsender,EventArgse>{}}}商品進(jìn)貨信息模塊商品進(jìn)貨信息模塊是對(duì)每筆進(jìn)貨業(yè)務(wù)的進(jìn)貨編號(hào)、商品名稱、進(jìn)貨單價(jià)和數(shù)量的錄入功能的實(shí)現(xiàn)。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacecsharp{publicpartialclassForm3:Form{publicForm3<>{InitializeComponent<>;}privatevoidtextBox3_TextChanged<objectsender,EventArgse>{}privatevoidForm3_Load<objectsender,EventArgse>{}privatevoidbutton1_Click<objectsender,EventArgse>{SqlConnectionconn=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;stringstrsql="insertintodd<bh,mc,dj,sl>values<'"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"'>";SqlCommandcomm=newSqlCommand<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<"對(duì)不起,失敗了::>_<::","提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;}conn.Close<>;}privatevoidbutton2_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}}}進(jìn)貨信息查詢模塊進(jìn)貨信息查詢模塊是操作人員對(duì)進(jìn)貨業(yè)務(wù)的查詢功能,可以通過(guò)查詢條件,查找相應(yīng)的信息。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacecsharp{publicpartialclassForm4:Form{publicForm4<>{InitializeComponent<>;}publicstaticSqlConnectioncon=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;publicstaticRichTextBoxrt=newRichTextBox<>;privatevoidbutton2_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}privatevoidtextBox1_TextChanged<objectsender,EventArgse>{}privatevoidbutton1_Click<objectsender,EventArgse>{rt.Size=newSize<457,203>;rt.Location=newPoint<17,45>;rt.Font=newFont<FontFamily.GenericSerif,13>;this.Controls.Add<rt>;con.Open<>;stringsql="select*fromdd";SqlCommandcmd=newSqlCommand<sql,con>;SqlDataReadersqldr=cmd.ExecuteReader<>;rt.Text="序號(hào)編號(hào)名稱單價(jià)數(shù)量\n";rt.Text+="\n";//把數(shù)據(jù)從sqldr記錄集中一行一行的讀取出來(lái)并賦值給富文本框rt的屬性textif<sqldr.HasRows>{while<sqldr.Read<>>rt.Text+=""+sqldr["ID"]+""+sqldr["bh"]+""+sqldr["mc"]+""+sqldr["dj"]+""+sqldr["sl"]+"\n";}sqldr.Close<>;con.Close<>;}privatevoidForm4_Load<objectsender,EventArgse>{}}}商品銷售信息模塊商品銷售信息模塊是對(duì)每筆銷售業(yè)務(wù)的銷售編號(hào)、商品名稱、銷售單價(jià)和數(shù)量的錄入功能的實(shí)現(xiàn)。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingqlClient;namespacecsharp{publicpartialclassForm5:Form{publicForm5<>{InitializeComponent<>;}privatevoidbutton2_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}privatevoidbutton1_Click<objectsender,EventArgse>{SqlConnectionconn=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;stringstrsql="insertintodd<bh,mc,dj,sl>values<'"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"'>";SqlCommandcomm=newSqlCommand<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<"對(duì)不起,失敗了::>_<::","提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;}conn.Close<>;}privatevoidForm5_Load<objectsender,EventArgse>{}}}商品退貨信息模塊商品退貨信息模塊是針對(duì)顧客銷售退回業(yè)務(wù)的信息進(jìn)行查詢。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacecsharp{publicpartialclassForm6:Form{publicForm6<>{InitializeComponent<>;}privatevoidbutton2_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}privatevoidbutton1_Click<objectsender,EventArgse>{SqlConnectionconn=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;stringstrsql="deleteddwhereID=<'"+textBox1.Text+"'>";SqlCommandcomm=newSqlCommand<strsql,conn>;if<conn.State==ConnectionState.Closed>{conn.Open<>;}if<Convert.ToInt32<comm.ExecuteNonQuery<>>>0>{MessageBox.Show<"退貨成功,信息已刪除,請(qǐng)返回O<∩_∩>O~","提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;}else{MessageBox.Show<"對(duì)不起,刪除失敗了::>_<::請(qǐng)檢測(cè)用戶名","提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;}conn.Close<>;}privatevoidbutton3_Click<objectsender,EventArgse>{SqlConnectioncon=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;con.Open<>;SqlDataAdapterda=newSqlDataAdapter<"select*fromddwhereID='"+textBox1.Text.Trim<>+"'",con>;DataSetds=newDataSet<>;da.Fill<ds>;if<ds.Tables[0].Rows.Count==0>{MessageBox.Show<"單號(hào)不存在.請(qǐng)重新輸入","系統(tǒng)提示",MessageBoxButtons.OK,MessageBoxIcon.Error>;return;}else{MessageBox.Show<"可以退貨,請(qǐng)繼續(xù)！","系統(tǒng)提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;}}privatevoidForm6_Load<objectsender,EventArgse>{}}}供應(yīng)商信息模塊供應(yīng)商信息模塊是對(duì)商品供應(yīng)商信息的錄入,以便查詢。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacecsharp{publicpartialclassForm8:Form{publicForm8<>{InitializeComponent<>;}privatevoidmenuStrip1_ItemClicked<objectsender,ToolStripItemClickedEventArgse>{}privatevoidForm8_Load<objectsender,EventArgse>{}privatevoidbutton2_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}privatevoidbutton1_Click<objectsender,EventArgse>{SqlConnectionconn=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;stringstrsql="insertintogys<mc,dh>values<'"+textBox1.Text+"','"+textBox2.Text+"'>";SqlCommandcomm=newSqlCommand<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<"對(duì)不起,失敗了::>_<::","提示",MessageBoxButtons.OK,MessageBoxIcon.Information>;}conn.Close<>;}}}退出系統(tǒng)提醒模塊當(dāng)用戶退出時(shí),會(huì)提醒用戶是否決定退出系統(tǒng)。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespacecsharp{publicpartialclassForm9:Form{publicForm9<>{InitializeComponent<>;}privatevoidbutton2_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}privatevoidbutton1_Click<objectsender,EventArgse>{Application.Exit<>;}privatevoidForm9_Load<objectsender,EventArgse>{}}}意見(jiàn)反饋模塊意見(jiàn)反饋模塊,是提供一個(gè)平臺(tái),將使用者的使用意見(jiàn)反饋給系統(tǒng)程序員,對(duì)該系統(tǒng)的改進(jìn)和提高。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacecsharp{publicpartialclassForm11:Form{publicForm11<>{InitializeComponent<>;}privatevoidlabel1_Click<objectsender,EventArgse>{}privatevoidbutton1_Click<objectsender,EventArgse>{Form2f2=newForm2<>;f2.Show<>;this.Close<>;}privatevoidbutton2_Click<objectsender,EventArgse>{SqlConnectionconn=newSqlConnection<"server=SDJS-20140220WP;database=CS;IntegratedSecurity=true">;stringstrsql="insertintorep<rp>values<'"+richTextBox1+"'>";SqlCommandcomm=newSqlCommand<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<"對(duì)不起,失敗了,請(qǐng)稍后重試！::>_<::","提示",