页眉内容数据库课程设计班级软件 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,publisher,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.storage界面：从 book 表中查询图书信息；6. 退出按钮：退出界面。主界面：销售订单界面：进货单界面bookinput界面：storage界面六、程序代码及控件描述/form1.csusingSystem.Drawing;usingSystem;usingSystem.Text;using;using;usingSystem.ComponentModel;namespace bookmanagesysusingSystem.Data;页眉内容publicpartialclassForm1 : FormpublicForm1()InitializeComponent();private void 信息查询 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)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;EventArgs 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销售统计ToolStripMenuItem_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();privatevoid 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 =/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,isbn,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,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();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