进销存管理系统基于VB.NET，sql数据库资源-CSDN文库

共54个文件

vb：18个

resx：13个

bmp：6个

4星 · 超过85%的资源需积分: 18 178 浏览量 2008-12-26 23:03:20 上传评论 4 收藏 493KB RAR 举报

进销存管理系统是一种用于企业管理日常业务流程的软件工具，它涵盖了采购、销售和库存管理等核心环节。在VB.NET和SQL数据库环境下开发这样的系统，可以实现高效的数据存储和处理，同时利用面向对象的编程特性来简化开发过程。标题中提到的“基于VB.NET，sql数据库”是指使用微软的Visual Basic .NET（VB.NET）编程语言，结合SQL Server或类似的SQL数据库系统进行系统开发。VB.NET是.NET框架的一部分，提供了丰富的类库和强大的开发环境，适合构建企业级应用。SQL数据库则负责存储和管理进销存数据，提供数据查询、更新和事务处理等功能。描述中的“完整的vb.net下进销存系统”意味着这个项目是一个完整的解决方案，包括了所有必要的模块，如采购管理、销售管理、库存管理、报表生成等。这些模块通常会涉及以下功能： 1. **采购管理**：记录供应商信息，管理采购订单，跟踪采购进度，处理退货和入库操作。 2. **销售管理**：管理客户信息，处理销售订单，跟踪发货状态，提供销售分析报告。 3. **库存管理**：实时更新库存数量，预警库存短缺，支持库存盘点和调拨，确保库存的准确性。 4. **报表生成**：根据业务数据自动生成各类统计报表，如销售报表、库存报表、利润报表等，帮助企业决策。 5. **用户权限管理**：设置不同角色的权限，保障数据安全，避免误操作。标签中的“电脑编程实例”表明这是一个实际的编程项目，适合学习和参考。而“毕业设计”意味着这可能是一个学生完成的项目，适用于锻炼编程和项目管理能力。压缩包子文件的“chap1”可能表示项目源代码的章节或部分，通常包含项目的起始文件或框架，比如主程序、数据库连接代码、基础类库等。进一步分析这个文件，可以深入理解系统的架构和设计思路。这个进销存管理系统利用VB.NET的编程能力和SQL数据库的存储优势，实现了企业的关键业务流程自动化，对于学习者来说，可以从中学习到数据库设计、面向对象编程、GUI界面设计以及业务逻辑实现等多个方面的知识。通过实际运行和修改代码，能够提升编程技能和解决实际问题的能力。

资源推荐

资源详情

资源评论

收起资源包目录

chap1.rar （54个子文件）

chap1

代码

frmGoodsInfo.resx 21KB

DataSet1.xsx 165B

frmDepotSelect.vb 5KB

AssemblyInfo.vb 809B

frmManage.vb 8KB

bin

进销存管理.exe 372KB

OrderReport.rpt 16KB

进销存管理.pdb 692KB

DataSet1.xsd 6KB

DataSet1.vb 101KB

frmMain.vb 12KB

进销存管理.suo 10KB

frmDepotSearch.vb 9KB

进销存管理.sln 905B

frmDepotSelect.resx 7KB

frmOrderList.vb 41KB

image

SAVE.BMP 246B

Del.ICO 1KB

NEW.BMP 246B

SPELL.BMP 1KB

PRINT.BMP 246B

DELETE.BMP 246B

CHECK.BMP 246B

frmSellList.vb 40KB

frmGoodsInfo.vb 33KB

frmOrderList.resx 35KB

frmLogin.resx 11KB

frmSellList.resx 36KB

OrderReport.vb 5KB

进销存管理.vbproj 13KB

OrderList.vb 22KB

OrderReport.rpt 16KB

frmClientInfo.resx 21KB

frmPrint.resx 7KB

进销存管理.vbproj.user 2KB

frmManage.resx 8KB

frmSupplyInfo.vb 38KB

OrderList.xsx 370B

frmPrint.vb 3KB

OrderList.xsd 1KB

frmSupplyInfo.resx 21KB

frmDepotSearch.resx 12KB

frmMain.resx 12KB

frmClientInfo.vb 40KB

Component

DataGridNoActiveCellColumn.vb 641B

DataGridComboBox.vb 9KB

DataGridNoActiveCellColumn.resx 2KB

DataBase.vb 2KB

DataGridComboBox.resx 2KB

frmLogin.vb 8KB

建库脚本

jxcbook_Log.LDF 1024KB

进销存管理.sql 41KB

jxcbook_Data.MDF 1.56MB

jxcbook.bak 1.52MB

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购订单_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购订单] DROP CONSTRAINT 采购订单_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购订单历史_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购订单历史] DROP CONSTRAINT 采购订单历史_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购合同_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购合同] DROP CONSTRAINT 采购合同_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[进货单_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[进货单] DROP CONSTRAINT 进货单_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[进货单历史_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[进货单历史] DROP CONSTRAINT 进货单历史_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[应付款_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[应付款] DROP CONSTRAINT 应付款_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[预付款_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[预付款] DROP CONSTRAINT 预付款_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[预收款_供货商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[预收款] DROP CONSTRAINT 预收款_供货商_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[报损报溢_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[报损报溢] DROP CONSTRAINT 报损报溢_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[报损报溢历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[报损报溢历史] DROP CONSTRAINT 报损报溢历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购订单明细_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购订单明细] DROP CONSTRAINT 采购订单明细_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购订单明细历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购订单明细历史] DROP CONSTRAINT 采购订单明细历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购合同_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购合同] DROP CONSTRAINT 采购合同_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[调拨单_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[调拨单] DROP CONSTRAINT 调拨单_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[调拨单历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[调拨单历史] DROP CONSTRAINT 调拨单历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[调货申请_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[调货申请] DROP CONSTRAINT 调货申请_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[进货单明细_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[进货单明细] DROP CONSTRAINT 进货单明细_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[进货单明细历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[进货单明细历史] DROP CONSTRAINT 进货单明细历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[进销存汇总表_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[进销存汇总表] DROP CONSTRAINT 进销存汇总表_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[库存库_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[库存库] DROP CONSTRAINT 库存库_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[盘点单_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[盘点单] DROP CONSTRAINT 盘点单_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[盘点单历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[盘点单历史] DROP CONSTRAINT 盘点单历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[上下限对照表_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[上下限对照表] DROP CONSTRAINT 上下限对照表_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售单明细_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单明细] DROP CONSTRAINT 销售单明细_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售单明细历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单明细历史] DROP CONSTRAINT 销售单明细历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售订单明细_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售订单明细] DROP CONSTRAINT 销售订单明细_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售订单明细历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售订单明细历史] DROP CONSTRAINT 销售订单明细历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售合同_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售合同] DROP CONSTRAINT 销售合同_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售日报_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售日报] DROP CONSTRAINT 销售日报_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销退货单_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销退货单] DROP CONSTRAINT 销退货单_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销退货单历史_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销退货单历史] DROP CONSTRAINT 销退货单历史_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[应付款_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[应付款] DROP CONSTRAINT 应付款_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[应收款_货号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[应收款] DROP CONSTRAINT 应收款_货号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售单_客户编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单] DROP CONSTRAINT 销售单_客户编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售单历史_客户编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单历史] DROP CONSTRAINT 销售单历史_客户编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售订单_客户编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售订单] DROP CONSTRAINT 销售订单_客户编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售订单历史_客户编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售订单历史] DROP CONSTRAINT 销售订单历史_客户编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售合同_客户编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售合同] DROP CONSTRAINT 销售合同_客

评论收藏

内容反馈