《C#书店管理系统》由会员分享，可在线阅读，更多相关《C#书店管理系统（6页珍藏版）》请在金锄头文库上搜索。
1、页眉内容数据库课程设计班级软件 0601学号22姓名指导老师二零零八年 7月一、概述1、项目背景：数据库原理课程设计2、编写目的：掌握数据库设计原理及相关软件的使用3、软件定义：书店管理系统4、开发环境：语言： C Sharp ；平台： Visual Studio 2005 + Microsoft .Net 2.0数据库： Microsoft SQL Server 2000；二、需求分析1、问题的提出2、完成的功能1. 售书管理：销售订单和销售统计；2订购管理；3. 库存管理；4. 信息查询；5. 推出系统。3、E-R 图页眉内容三 数据表Book(isbn,title,author,publ
2、isher,price,totalnum,comment,dtime)Inlist(isbn,title,price,provider,buynum,dtime)Outlist(isbn,username,buyip,price,buynum,title)四、表、视图、索引、存储过程、触发器的创建Book 表：Inlist：Outlist:五、软件功能设计1. 主界面：负责调出资界面；2. 销售订单界面：将销售订单的信息加入销售订单列表outlist ；3. 进货单界面：将进货单的信息加入进货单信息表 inlist ；4.bookinput界面：将新录入的图书信息家入book 表；5.stor
3、age界面：从 book 表中查询图书信息；6. 退出按钮：退出界面。主界面：销售订单界面：进货单界面bookinput界面：storage界面六、程序代码及控件描述/form1.csusingSystem.Drawing;usingSystem;usingSystem.Text;using;using;usingSystem.ComponentModel;namespace bookmanagesysusingSystem.Data;页眉内容publicpartialclassForm1 : FormpublicForm1()InitializeComponent();private voi
4、d 信息查询 ToolStripMenuItem_Click( object sender, EventArgs e)storage sg =new storage();sg.Show();privatevoid Form1_Load( objectsender,EventArgs e)Global.Con =new DataSource=JD-6B3825650DEA;InitialCatalog=Booksale;Integrated Security=True);privatevoid销售订单ToolStripMenuItem_Click(objectsender,EventArgs e
5、)SaleOrder so =new SaleOrder();so.Show();privatevoid进书定单ToolStripMenuItem_Click(objectsender,EventArgs e)stocktablest= new stocktable();st.Show();privatevoid新书入库ToolStripMenuItem_Click(objectsender,/saleorderusing System;using ;using System.ComponentModel;using System.Data;using System.Drawing;Event
6、Args e)bookInput bi =new bookInput();bi.Show();privatevoid退出系统ToolStripMenuItem_Click( object sender, EventArgs e)this .Close();privatevoidtextBox1_TextChanged(objectsender,EventArgs e)private void Form1_FormClosed( object sender, FormClosedEventArgs e)try;catch ( Exception )return;privatevoid销售统计To
7、olStripMenuItem_Click( object sender, EventArgs e)salestatic sat =newsalestatic();sat.Show();using System.Text;using ;using ;namespace bookmanagesys页眉内容publicpartialclassSaleOrder :FormpublicSaleOrder()InitializeComponent();privatevoidbutton_cancel_Click(objectsender,EventArgse)this .Close();private
8、void button_ok_Click(objectsender,EventArgs e)stringusername =textBox_consumer.Text;stringbuyip = textBox_ip.Text;stringisbn = textBox_isbn.Text;stringprice =textBox_price.Text;stringbuynum = textBox_num.Text;stringtitle =textBox_title.Text;SqlCommandjincommand =newSqlCommand();jincommand.Connection
9、 =/stocktableusing System;using ;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using ;using ;namespace bookmanagesyspublicpartialclassstocktable:Formpublicstocktable()InitializeComponent();Global .Con;jincommand.CommandText =INSERT INTOoutlist(username ,buyip,i
10、sbn,price,buynum,title) VALUES(+ textBox_consumer.Text +,+ textBox_ip.Text +,+textBox_isbn.Text +,+textBox_price.Text+ ,+ textBox_num.Text+,+ textBox_title.Text+);intjin =jincommand.ExecuteNonQuery();if(jin 0)label_show.Text = 提交成功;elselabel_show.Text = 提交失败！ ;privatevoid SaleOrder_Load(objectsender
11、,EventArgs e)privatevoid button_ok_Click(objectsender,EventArgs e)stringtitle =textBox_title.Text;stringprovider =textBox_provider.Text;stringbuynum = textBox_num.Text;stringprice =textBox_price.Text;stringdtime = textBox_date.Text;stringisbn = textBox_isbn.Text;SqlCommandjinCommand =newSqlCommand()
12、;jinCommand.Connection =Global .Con;页眉内容jinCommand.CommandText =INSERTINTOinlist(isbn,title ,provider,buynum,price,dtime) VALUES(+ textBox_isbn.Text +,+textBox_title.Text +,+textBox_provider.Text +,+textBox_num.Text+ ,+ textBox_price.Text+ ,+ textBox_date.Text +);intjin =jinCommand.ExecuteNonQuery();if
