C#书店管理系统.doc

数据库课程设计班 级 软件0601 学 号 3060605022 姓 名 指导老师 二零零八年 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.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;namespace bookmanagesys public partial class Form1 : Form public Form1() InitializeComponent(); private void 信息查询ToolStripMenuItem_Click(object sender, EventArgs e) storage sg = new storage(); sg.Show(); private void Form1_Load(object sender, EventArgs e) Global.Con = new System.Data.SqlClient.SqlConnection(Data Source=JD-6B3825650DEA;Initial Catalog=Booksale;Integrated Security=True); Global.Con.Open(); private void 销售订单ToolStripMenuItem_Click(object sender, EventArgs e) SaleOrder so = new SaleOrder(); so.Show(); private void 进书定单ToolStripMenuItem_Click(object sender, EventArgs e) stocktable st = new stocktable(); st.Show(); private void 新书入库ToolStripMenuItem_Click(object sender, EventArgs e) bookInput bi = new bookInput(); bi.Show(); private void 退出系统ToolStripMenuItem_Click(object sender, EventArgs e) this.Close(); private void textBox1_TextChanged(object sender, EventArgs e) private void Form1_FormClosed(object sender, FormClosedEventArgs e) try Global.Con.Close(); catch (Exception) return; private void 销售统计ToolStripMenuItem_Click(object sender, EventArgs e) salestatic sat = new salestatic(); sat.Show(); /saleorderusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace bookmanagesys public partial class SaleOrder : Form public SaleOrder() InitializeComponent(); private void button_cancel_Click(object sender, EventArgs e) this.Close(); private void button_ok_Click(object sender, EventArgs e) string username = textBox_consumer.Text; string buyip = textBox_ip.Text; string isbn = textBox_isbn.Text; string price = textBox_price.Text; string buynum = textBox_num.Text; string title = textBox_title.Text; SqlCommand jincommand = new SqlCommand(); jincommand.Connection = Global.Con; jincommand.CommandText = INSERT INTO outlist(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+ ); int jin = jincommand.ExecuteNonQuery(); if (jin 0) label_show.Text = 提交成功; else label_show.Text = 提交失败！; private void SaleOrder_Load(object sender, EventArgs e) /stocktableusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace bookmanagesys public partial class stocktable : Form public stocktable() InitializeComponent(); private void button_ok_Click(object sender, EventArgs e) string title = textBox_title.Text; string provider = textBox_provider.Text; string buynum = textBox_num.Text; string price = textBox_price.Text; string dtime = textBox_date.Text; string isbn = textBox_isbn.Text; SqlCommand jinCommand = new SqlCommand(); jinCommand.Connection = Global.Con; jinCommand.CommandText = INSERT INTO inlist(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 + ); int jin = jinCommand.ExecuteNonQuery(); if (jin 0) label_show.Text = 提交成功; else label_show.Text = 提交失败！; private void stocktable_Load_1(object sender, EventArgs e) private void button_cancel_Click(object sender, EventArgs e) this.Close(); /bookInput using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace bookmanagesys public partial class bookInput : Form public bookInput() InitializeComponent(); private void button_ok_Click(object sender, EventArgs e) string isbn = textBox_isbn.Text; string title = textBox_title.Text; string dtime = textBox_time.Text; string author = textBox_author.Text; string publisher = textBox_publisher.Text; string price = textBox_price.Text; string comment = textBox_comment.Text; SqlCommand jinCommand = new SqlCommand(); jinCommand.Connection = Global.Con; jinCommand.CommandText = INSERT INTO book(isbn ,title,dtime,author,publisher,price,comment) VALUES( + textBox_isbn.Text + , + textBox_title.Text + , + textBox_time.Text + , + textBox_author.Text + , + textBox_publisher.Text + , + textBox_price.Text + , + textBox_comment.Text + ); int jin = jinCommand.ExecuteNonQuery(); if( jin 0) label_show.Text = 入库成功; else label_show.Text = 入库失败！; private void button_cancel_Click(object sender, EventArgs e) this.Close(); private void bookInput_Load(object sender, EventArgs e) private void g