当前位置:文档之家› 数据库课程设计-仓库管理系统

数据库课程设计-仓库管理系统

任务书1、课程设计题目仓库管理系统2、设计任务和内容一个小型通用的仓库管理系统是实现企业对库存商品出库、入库进行高效的管理。

通过应用系统应能结合销售情况对库存商品进行录入、删除、修改等操作。

按照一定的条件,查询、统计符合条件的商品信息;并且对查询、统计的结果有一定的输出。

本课题任务是开发一个小型的仓库管理系统,并撰写符合规范的课程设计说明书以体现设计过程和设计结果。

3、设计步骤和要求设计步骤:首先进行相关资料查阅和学习,了解基本的业务流程和系统数据功能要求。

然后结合软件工程的理论和教材中数据库设计的六个阶段(重点是前三个阶段)完成设计任务,即系统结构设计(需求分析、概念结构设计、逻辑结构设计、物理结构设计)和系统功能设计。

设计要求:1、撰写课程设计说明书。

其要求如下:(1)基本要求:①能反映完成了上述设计内容要求。

②要求撰写不少于5000个文字(20页)的文档。

③文档中至少要包括:数据流图、数据字典、E-R图、数据库表的详细说明、系统功能结构图、主要功能模块说明。

④课程设计说明书一律用碳素墨水书写,其中用户界面设计可以附界面的计算机截图或手工绘图。

(2)文档格式要求(遵循数据库原理及应用课程设计大纲上的要求)其中,正文部分:①分章、层次等,每一章从新一页开始。

②章节安排可如下安排.概述:包括项目背景、编写目的、软件定义、开发环境等内容。

.需求分析:问题陈述、需完成的功能。

以数据流图和数据字典表达。

.概念结构设计:将上述需求分析的成果抽象为ER模型图。

.逻辑结构设计:把ER模型图转换为关系表;描述每一个基本表关系。

并进行规范化;定义视图、定义索引、主关键字、定义权限。

.软件功能设计:画出系统功能结构图,描述每个功能所完成的任务。

.代码设计和界面设计:给出主要功能的代码并有适当的说明;界面设计要合理,给出主要界面。

2、一个可运行的仓库管理系统原型。

(可选)教师签名:摘要随着计算机技术的飞速发展,计算机在企业管理中应用的普及,利用计算机实现管理企业势在必行。

而仓库管理系统是典型的信息管理系统,其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。

对前者要求建立起数据一致性和完整性强、数据安全性好的库。

而对于后者则要求应用程序功能完备,易使用等特点。

本文通过分析浏览器/服务器结构的特点并结合企业仓储管理的实际情况,提出了基于B/S结构中小型企业仓库管理系统的基本设计思想,简要介绍了系统各功能模块及数据库的设计,着重讨论了用技术和SQL Server 2005开发企业仓库管理系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。

通过该系统,使学生可以方便地在企业内部网上进行仓储管理。

该B/S 结构的系统在Windows XP系统和平台下开发完成,使用C#作为的开发语言,SQL Server 2005作为后台数据库,该数据库系统在安全性、准确性、运行速度方面均有绝对的优势,并且能够对容量较大的数据库进行处理,效率高。

系统有较高的安全性和较好的性能本文中除了有对程序的系统分析、总体设计、数据库设计、功能实现等主体部分外,在这之前还介绍了与企业仓库管理系统相关的信息、与SQL 的无缝链接技术等。

关键词仓库管理;信息管理系统;B/S结构;数据库管理目录第一章概述1.1项目背景1.2编写目的1.3软件定义1.4开发环境第二章需求分析2.1可行性分析2.2功能分析2.3数据流图2.4数据字典第三章概念结构设计3.1 E-R图第四章逻辑结构设计4.1关系表4.2基本表关系。

4.3规范化第五章软件功能设计5.1系统功能结构图5.2功能任务简介第六章代码设计和界面设计第一章概述1.1项目背景仓库存放的货物品种繁多,堆存方式以及处理过程也非常复杂,随着业务量的增加,仓库管理者需要处理的信息量会大幅上升,因此往往很难及时准确的掌握整个仓库的运作状态。

针对这一情况,本系统在满足仓库的基本管理功能基础上发挥信息系统的智能化,减轻仓库管理人员和操作人员的工作负担。

系统主要的实现目标是监控整个仓库的运转情况;提供完善的出入库登记功能且拥有便捷的查询功能。

1.2编写目的根据任务书要求,假想一小型企业拥有多个仓库,拥有多种物品,且物品在仓库中存在耗损情况。

开发数据库和系统平台解决此问题。

1.3软件介绍本系统包括一下几个模块。

1)货物管理提供入库登记、出库登记、损耗登记三个方面的登记功能方便的修改库存信息。

2)档案管理提供货物档案设置、仓库设置、分类设置三个方面的内容。

分别允许用户更改货物的属性,仓库的属性,分类的属性。

3)查询统计提供入库查询、出库查询、耗损查询、库存查询四个方面的内容。

允许用户随时查询仓库的现状。

4)系统维护提供货物档案设置、仓库设置、分类设置三个方面的内容。

分别允许用户更改货物的属性,仓库的属性,分类的属性。

5)系统信息提供用户管理,更改密码,系统说明,退出系统四项功能。

使软件功能更加完善。

1.4开发环境语言环境 C#语言平台环境 SQLServer2000,VisualStudio2005系统开发环境 Win7,处理器T8300,内存2G,显卡Geforce8600GT系统运行环境 WinXp/Vista/Win7,处理器Pentium II300以上,内存64M以上,硬盘空间3G以上,显卡普通VGA显卡第二章需求分析2.1可行性分析本软件所有处理流程内置,通过界面操作可以完成所有功能能,使用者无需具备SQL及C#语言知识,且软件所有功能完全可以达成编写目的,软件运行硬件要求不高,开发软件是完全可行的。

2.2功能分析本软件所有处理流程内置,通过界面操作可以完成所有功能能,使用者无需具备SQL及C#语言知识,且软件所有功能完全可以达成编写目的,软件运行硬件要求不高,开发软件是完全可行的。

2.3数据流图略2.4数据字典1.数据项第三章概念结构设计3.1 E-R图图略第四章逻辑结构设计4.1关系表4.库存信息5.入库信息6.出库信息7.入库信息UserPassword Varchar(8) 是用户密码UserLimit int 是用户权限4.2基本表关系4.3规范化create database Storeage--物品信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GoodsInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table GoodsInfoGOCREATE TABLE GoodsInfo(GoodsID int identity(1,1) primary key, --物品号编号主GoodsName varchar(20) not null, --物品名SortID int not null, --类别ID 外Spec varchar(10) --规格可空)--类别信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SortInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table SortInfoGOCREATE TABLE SortInfo(SortID int identity(1,1) primary key, --类别ID 主SortName varchar(10) not null, --类别名称SortLimit int not null --类别权限)--仓库信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StorageInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table StorageInfoGOCREATE TABLE StorageInfo(StorageID int identity(1,1) primary key, --仓库ID 主StorageName varchar(20) not null --仓库名称)--库存信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StoreInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table StoreInfoGOCREATE TABLE StoreInfo(SN int identity(1,1) primary key, --库存自动编号主StoreID int not null, --仓库号外GoodsID int not null, --物品号外SortID int not null, --类别ID 外GoodsNum int not null, --物品数量EditDate datetime --修改日期可空)--入库信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table InInfoGOCREATE TABLE InInfo(InOrder int identity(1,1) primary key, --入库单号主StorageID int references StorageInfo(StorageID) not null, --仓库号外GoodsID int references GoodsInfo(GoodsID) not null, --物品号外InNum int not null, --入库数量InUnit varchar(20), --入库单位可空InDate datetime, --入库日期可空InRemark varchar(100) --入库备注可空)--出库信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OutInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table OutInfoGOCREATE TABLE OutInfo(OutOrder int identity(1,1) primary key, --出库单号主StorageID int references StorageInfo(StorageID) not null, --仓库号外GoodsID int references GoodsInfo(GoodsID) not null, --物品号外OutNum int not null, --出库数量OutUnit varchar(20), --出库单位可空OutDate datetime, --出库日期可空OutRemark varchar(100) --出库备注可空)--损耗信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BreakInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table BreakInfoGOCREATE TABLE BreakInfo(BreakOrder int identity(1,1) primary key, --损耗单号主StorageID int references StorageInfo(StorageID) not null, --仓库号外GoodsID int references GoodsInfo(GoodsID) not null, --物品号外BreakNum int not null, --损耗数量BreakDate datetime, --损耗日期可空BreakRemark varchar(100) --损耗备注可空)--用户信息if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table UserInfoGOCREATE TABLE UserInfo(UserID int identity(1,1) primary key, --用户ID 主UserName varchar(20), --用户名UserPassword varchar(8), --用户密码UserLimit int --类别(权限))第五章软件功能设计5.1系统功能结构图图略5.2功能任务简介简述个部分功能代码设计1.主界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace XRX{public partial class Main : Form{public Main(){InitializeComponent();}private void入库登记(object sender, EventArgs e){GoodsManage.InManage Aa = new XRX.GoodsManage.InManage(); Aa.ShowDialog();}private void出库登记(object sender, EventArgs e){GoodsManage.OutManage Ab = new XRX.GoodsManage.OutManage();Ab.ShowDialog();}private void耗损登记(object sender, EventArgs e){GoodsManage.BreakManage Ac = new XRX.GoodsManage.BreakManage(); Ac.ShowDialog();}private void货物档案设置(object sender, EventArgs e){InfoManage.GoodsInfo Ba = new Manage.GoodsInfo();Ba.ShowDialog();}private void仓库档案设置(object sender, EventArgs e){InfoManage.StoreInfo Bb = new Manage.StoreInfo();Bb.ShowDialog();}private void分类档案设置(object sender, EventArgs e){InfoManage.SortInfo Bc = new Manage.SortInfo();Bc.ShowDialog();}private void入库查询(object sender, EventArgs e){QueryManage.InQuery Ca = new XRX.QueryManage.InQuery();Ca.ShowDialog();}private void出库查询(object sender, EventArgs e){QueryManage.OutQuery Cb = new XRX.QueryManage.OutQuery();Cb.ShowDialog();}{QueryManage.BreakQuery Cc = new XRX.QueryManage.BreakQuery();Cc.ShowDialog();}private void库存查询(object sender, EventArgs e){QueryManage.StoreQuery Cd = new XRX.QueryManage.StoreQuery();Cd.ShowDialog();}private void备份数据(object sender, EventArgs e){SysManage.DataStore Da = new XRX.SysManage.DataStore();Da.ShowDialog();}private void恢复数据(object sender, EventArgs e){SysManage.DataRevert Db = new XRX.SysManage.DataRevert();Db.ShowDialog();}private void用户管理(object sender, EventArgs e){erManage Ea = new erManage();Ea.ShowDialog();}private void更改密码(object sender, EventArgs e){OtherManage.EditPassword Eb = new XRX.OtherManage.EditPassword(); Eb.ShowDialog();}private void系统说明(object sender, EventArgs e){OtherManage.Help Ec = new XRX.OtherManage.Help();Ec.ShowDialog();}{Application.Exit();}private void Main_FormClosing(object sender, FormClosingEventArgs e) {if (MessageBox.Show("您真的要退出本系统吗?", "提示", MessageBoxButtons.OKCancel, rmation) == DialogResult.OK) Application.Exit();}private void Main_Load(object sender, EventArgs e){}}}2.登陆界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace XRX{public partial class Login : Form{public static string strUName = "";public static string strUPwd = "";public Login(){InitializeComponent();}private void Login_Load(object sender, EventArgs e){User u = new User();DataSet ds = u.showLogin();this.cboxUName.DataSource = ds.Tables[0].DefaultView;this.cboxUName.DisplayMember = "UserName";}private void Login_Click(object sender, EventArgs e){DataBase db = new DataBase();SqlParameter[] Pa = new SqlParameter[3];Pa[0] = db.MakeInParam("@UserName",SqlDbType.VarChar, 20,this.cboxUName.Text);Pa[1] = db.MakeInParam("@UserPassword", SqlDbType.VarChar, 20, this.txtPwd.Text);Pa[2] = db.MakeOutParam("@rtn", SqlDbType.Int, 20);db.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Login", Pa);string rtn = Pa[2].Value.ToString();if (rtn == "1"){Main main = new Main();strUName = this.cboxUName.Text;strUPwd = this.txtPwd.Text;this.Hide();main.Show();}elseMessageBox.Show("密码错误!", "登陆失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}private void Exit_Click(object sender, EventArgs e){Application.Exit();}private void cboxUName_SelectedValueChanged(object sender, EventArgs e) {DataBase db = new DataBase();SqlDataReader dr = db.ExecuteReader(CommandType.Text, "select UserLimit from UserInfo where UserName ='" + this.cboxUName.Text.Trim() + "'", null);if (dr.Read()){string a = dr["UserLimit"].ToString();if (a == "1")bURight.Text = "一级用户";if (a == "2")bURight.Text = "二级用户";if (a == "3")bURight.Text = "三级用户";if (a == "4")bURight.Text = "管理员";if (a == "5")bURight.Text = "超级管理员";}dr.Close();}private void cboxUName_SelectedIndexChanged(object sender, EventArgs e) {}private void Login_FormClosing(object sender, FormClosingEventArgs e) {Application.Exit();}}}3.1入库管理界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace XRX.GoodsManage{public partial class InManage : Form{int a = 0, aa = 0,bb=0;public InManage(){InitializeComponent();}private void InManage_Load(object sender, EventArgs e) {aaa();}private void aaa(){DataBase db = new DataBase();DataSet ds = db.GetDs(CommandType.StoredProcedure, "up_findStro", null);this.dgvISManage.DataSource = ds.Tables[0];this.cboxSName.DataSource = ds.Tables[0].DefaultView;this.cboxSName.DisplayMember = "StorageName";boBox1.DataSource = ds.Tables[0].DefaultView;boBox1.DisplayMember = "GoodsName";this.dgvISManage.Columns[0].Visible = false;this.dgvISManage.Columns[1].HeaderText = "仓库名";this.dgvISManage.Columns[2].HeaderText = "物品名";this.dgvISManage.Columns[3].HeaderText = "入库数量";this.dgvISManage.Columns[4].HeaderText = "入库单位";this.dgvISManage.Columns[5].HeaderText = "入库日期";this.dgvISManage.Columns[6].HeaderText = "备注";this.dgvISManage.Columns[1].Width = 100;this.dgvISManage.Columns[2].Width = 80;this.dgvISManage.Columns[3].Width = 80;this.dgvISManage.Columns[4].Width = 80;this.dgvISManage.Columns[5].Width = 80;this.dgvISManage.Columns[6].Width = 100;this.dgvISManage.ReadOnly = true;//只读dgvISManage.SelectionMode =DataGridViewSelectionMode.FullRowSelect;//选中行this.dgvISManage.AllowUserToResizeRows = false;this.dgvISManage.AllowUserToResizeColumns = false;//禁止拖动this.dgvISManage.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//文本居中this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//表头居中}private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e){try{a =Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString()) ;this.cboxSName.Text =this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString();this.textBox1.Text =this.dgvISManage.Rows[e.RowIndex].Cells[7].Value.ToString();boBox1.Text =this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString();this.txtGSpec.Text =this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString();this.dateTimePicker1.Value=Convert.ToDateTime( this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString());this.txtGIPrice.Text =this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString();this.txtISRemark.Text =this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString();}catch { }}private void btnAdd_Click(object sender, EventArgs e){DataBase db = new DataBase();SqlParameter[] Pa = new SqlParameter[6];Pa[0] = db.MakeInParam("@StorageID", SqlDbType.Int, 4, aa);Pa[1] = db.MakeInParam("@GoodsID", SqlDbType.Int, 4, bb);Pa[2] = db.MakeInParam("@InNum", SqlDbType.Int, 4,Convert.ToInt32(this.txtGSpec.Text));Pa[3] = db.MakeInParam("@InUnit", SqlDbType.VarChar, 20,this.txtGIPrice.Text);Pa[4] = db.MakeInParam("@InDate", SqlDbType.VarChar, 20,this.dateTimePicker1.Value);Pa[5] = db.MakeInParam("@InRemark", SqlDbType.VarChar, 20,this.txtISRemark.Text);int b=db.ExecuteNonQuery(CommandType.StoredProcedure, "up_InStore", Pa);int Add = db.ExecuteNonQuery(CommandType.Text, "insert into InInfo (StorageID,GoodsID,InNum,InUnit,InDate,InRemark) values ('" + aa + "','" + bb + "','" + this.txtGSpec.Text + "','" + this.txtGIPrice + "','" +this.dateTimePicker1.Value + "','" + this.txtISRemark.Text + "')", null);if (Add == 1){MessageBox.Show("添加入库信息成功", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);aaa();else{MessageBox.Show("添加入库信息失败", "添加失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) {DataBase db = new DataBase();SqlDataReader dr = db.ExecuteReader(CommandType.Text, "select StorageID from StorageInfo where StorageName ='"+this.cboxSName.Text+"'", null);if(dr.Read())aa = Convert.ToInt32(dr["StorageID"].ToString());dr.Close();SqlDataReader dr2 = db.ExecuteReader(CommandType.Text, "select GoodsID from GoodsInfo where GoodsName='" + boBox1.Text+ "'", null);if (dr2.Read())bb = Convert.ToInt32(dr2["GoodsID"].ToString());dr2.Close();}private void btnExit_Click(object sender, EventArgs e){this.Close();}private void btnDel_Click(object sender, EventArgs e){DataBase db = new DataBase();int Delete = db.ExecuteNonQuery(CommandType.Text, "delete from InInfo where InOrder='" + a + "' ", null);if (Delete == 1){MessageBox.Show("删除入库信息成功", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("删除入库信息失败", "修改失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}}3.2出库管理界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace XRX.GoodsManage{public partial class OutManage : Form {int a = 0, aa = 0, bb = 0;public OutManage(){InitializeComponent();}private void btnAdd_Click(object sender, EventArgs e){DataBase db = new DataBase();SqlParameter[] Pa = new SqlParameter[6];Pa[0] = db.MakeInParam("@StorageID", SqlDbType.Int, 4, aa);Pa[1] = db.MakeInParam("@GoodsID", SqlDbType.Int, 4, bb);Pa[2] = db.MakeInParam("@OutNum", SqlDbType.Int, 4,Convert.ToInt32(this.txtGSpec.Text));Pa[3] = db.MakeInParam("@OutUnit", SqlDbType.VarChar, 20,this.txtGIPrice.Text);Pa[4] = db.MakeInParam("@OutDate", SqlDbType.VarChar, 20,this.dateTimePicker1.Value);Pa[5] = db.MakeInParam("@OutRemark", SqlDbType.VarChar, 20,this.txtISRemark.Text);int b = db.ExecuteNonQuery(CommandType.StoredProcedure, "up_OutStore", Pa);int Add = db.ExecuteNonQuery(CommandType.Text, "insert into OutInfo (StorageID,GoodsID,OutNum,OutUnit,OutDate,OutRemark) values ('" + aa + "','" + bb + "','" + this.txtGSpec.Text + "','" + this.txtGIPrice + "','" +this.dateTimePicker1.Value + "','" + this.txtISRemark.Text + "')", null);if (Add == 1){MessageBox.Show("添加出库信息成功", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("添加出库信息失败", "添加失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}private void btnDel_Click(object sender, EventArgs e){DataBase db = new DataBase();int Delete = db.ExecuteNonQuery(CommandType.Text, "delete from OutInfo where OutOrder='" + a + "' ", null);if (Delete == 1){MessageBox.Show("删除入库信息成功", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("删除入库信息失败", "修改失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}private void btnExit_Click(object sender, EventArgs e){this.Close();}private void OutManage_Load(object sender, EventArgs e){aaa();}private void aaa(){DataBase db = new DataBase();DataSet ds = db.GetDs(CommandType.StoredProcedure, "up_findStrob", null);this.dgvISManage.DataSource = ds.Tables[0];this.cboxSName.DataSource = ds.Tables[0].DefaultView;this.cboxSName.DisplayMember = "StorageName";boBox1.DataSource = ds.Tables[0].DefaultView;boBox1.DisplayMember = "GoodsName";this.dgvISManage.Columns[0].Visible = false;this.dgvISManage.Columns[1].HeaderText = "仓库名";this.dgvISManage.Columns[2].HeaderText = "物品名";this.dgvISManage.Columns[3].HeaderText = "出库数量";this.dgvISManage.Columns[4].HeaderText = "出库单位";this.dgvISManage.Columns[5].HeaderText = "出库日期";this.dgvISManage.Columns[6].HeaderText = "备注";this.dgvISManage.Columns[1].Width = 100;this.dgvISManage.Columns[2].Width = 80;this.dgvISManage.Columns[3].Width = 80;this.dgvISManage.Columns[4].Width = 80;this.dgvISManage.Columns[5].Width = 80;this.dgvISManage.Columns[6].Width = 100;this.dgvISManage.ReadOnly = true;//只读dgvISManage.SelectionMode =DataGridViewSelectionMode.FullRowSelect;//选中行this.dgvISManage.AllowUserToResizeRows = false;this.dgvISManage.AllowUserToResizeColumns = false;//禁止拖动this.dgvISManage.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//文本居中this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//表头居中}private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e){try{a =Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString());this.cboxSName.Text =this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString();this.textBox1.Text =this.dgvISManage.Rows[e.RowIndex].Cells[7].Value.ToString();boBox1.Text =this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString();this.txtGSpec.Text =this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString();this.dateTimePicker1.Value =Convert.ToDateTime(this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString ());this.txtGIPrice.Text =this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString();this.txtISRemark.Text =this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString();}catch { }}private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) {DataBase db = new DataBase();SqlDataReader dr = db.ExecuteReader(CommandType.Text, "select StorageID from StorageInfo where StorageName ='" + this.cboxSName.Text + "'", null);if (dr.Read())aa = Convert.ToInt32(dr["StorageID"].ToString());dr.Close();SqlDataReader dr2 = db.ExecuteReader(CommandType.Text, "selectGoodsID from GoodsInfo where GoodsName='" + boBox1.Text + "'", null);if (dr2.Read())bb = Convert.ToInt32(dr2["GoodsID"].ToString());dr2.Close();}}}3.3损耗管理界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace XRX.GoodsManage{public partial class BreakManage : Form{int a = 0, aa = 0, bb = 0;public BreakManage(){InitializeComponent();}private void btnAdd_Click(object sender, EventArgs e){DataBase db = new DataBase();SqlParameter[] Pa = new SqlParameter[6];Pa[0] = db.MakeInParam("@StorageID", SqlDbType.Int, 4, aa);Pa[1] = db.MakeInParam("@GoodsID", SqlDbType.Int, 4, bb);Pa[2] = db.MakeInParam("@BreakNum", SqlDbType.Int, 4,Convert.ToInt32(this.txtGSpec.Text));Pa[3] = db.MakeInParam("@BreakDate", SqlDbType.VarChar, 20,this.dateTimePicker1.Value);Pa[4] = db.MakeInParam("@BreakRemark", SqlDbType.VarChar, 20,this.txtISRemark.Text);int b = db.ExecuteNonQuery(CommandType.StoredProcedure,"up_BreakStore", Pa);int Add = db.ExecuteNonQuery(CommandType.Text, "insert into BreakInfo (StorageID,GoodsID,BreakNum,BreakDate,BreakRemark) values ('"+ aa + "','"+ bb + "','" + this.txtGSpec.Text + "','" + this.dateTimePicker1.Value + "','" + this.txtISRemark.Text + "')", null);if (Add == 1){MessageBox.Show("添加损耗信息成功", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("添加损耗信息失败", "添加失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}private void btnDel_Click(object sender, EventArgs e){DataBase db = new DataBase();int Delete = db.ExecuteNonQuery(CommandType.Text, "delete from BreakInfo where BreakOrder='" + a + "' ", null);if (Delete == 1){MessageBox.Show("删除入库信息成功", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("删除入库信息失败", "修改失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}private void btnExit_Click(object sender, EventArgs e){this.Close();}private void BreakManage_Load(object sender, EventArgs e){aaa();}private void aaa(){DataBase db = new DataBase();DataSet ds = db.GetDs(CommandType.StoredProcedure, "up_findStroc", null);this.dgvISManage.DataSource = ds.Tables[0];this.cboxSName.DataSource = ds.Tables[0].DefaultView;this.cboxSName.DisplayMember = "StorageName";boBox1.DataSource = ds.Tables[0].DefaultView;boBox1.DisplayMember = "GoodsName";this.dgvISManage.Columns[0].Visible = false;this.dgvISManage.Columns[1].HeaderText = "仓库名";this.dgvISManage.Columns[2].HeaderText = "物品名";this.dgvISManage.Columns[3].HeaderText = "损耗数量";this.dgvISManage.Columns[4].HeaderText = "损耗日期";this.dgvISManage.Columns[5].HeaderText = "备注";this.dgvISManage.Columns[1].Width = 100;this.dgvISManage.Columns[2].Width = 80;this.dgvISManage.Columns[3].Width = 80;this.dgvISManage.Columns[4].Width = 80;this.dgvISManage.Columns[5].Width = 100;this.dgvISManage.ReadOnly = true;//只读dgvISManage.SelectionMode =DataGridViewSelectionMode.FullRowSelect;//选中行this.dgvISManage.AllowUserToResizeRows = false;this.dgvISManage.AllowUserToResizeColumns = false;//禁止拖动this.dgvISManage.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//文本居中this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//表头居中}private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e){try{a =Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString());this.cboxSName.Text =this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString();this.textBox1.Text =this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString();boBox1.Text =this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString();this.dateTimePicker1.Value =Convert.ToDateTime(this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString ());this.txtGSpec.Text =this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString();this.txtISRemark.Text =this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString();}catch { }}private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) {DataBase db = new DataBase();SqlDataReader dr = db.ExecuteReader(CommandType.Text, "select StorageID from StorageInfo where StorageName ='" + this.cboxSName.Text + "'", null);if (dr.Read())aa = Convert.ToInt32(dr["StorageID"].ToString());dr.Close();SqlDataReader dr2 = db.ExecuteReader(CommandType.Text, "select GoodsID from GoodsInfo where GoodsName='" + boBox1.Text + "'", null);if (dr2.Read())bb = Convert.ToInt32(dr2["GoodsID"].ToString());dr2.Close();}}}4.1货物信息管理using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace Manage{public partial class GoodsInfo : Form {public GoodsInfo(){InitializeComponent();}}}。

相关主题