if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求计算_物料编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求计算] DROP CONSTRAINT mrp物料需求计算_物料编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求计算结果_物料编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求计算结果] DROP CONSTRAINT mrp物料需求计算结果_物料编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求历史_物料编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求历史] DROP CONSTRAINT mrp物料需求历史_物料编号_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].[物料主文件]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料主文件]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料清单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工厂日历]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工厂日历]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主需求计划]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主需求计划]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主需求计划历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主需求计划历史]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生产计划]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生产计划]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生产计划历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生产计划历史]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求计算]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp物料需求计算]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求计算结果]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp物料需求计算结果]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp物料需求历史]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料状态类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料状态类别]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料计划类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料计划类别]
GO
-------------------------------------------
CREATE TABLE [dbo].[物料主文件] (
[物料编号] [char] (14) NOT NULL ,
[条码] [char] (14) NULL ,
[物料名称] [varchar] (50) NOT NULL ,
[拼音编码] [char] (10) NULL ,
[计量单位] [char] (10) NOT NULL ,
[规格型号] [char] (20) NULL ,
[计划类别] [char] (5) NULL ,
[状态类别] [char] (5) NULL ,
[归属类别] [char] (5) NULL ,
[价值类别] [char] (1) NULL ,
[物料特性a] [varchar] (40) NULL ,
[物料特性b] [varchar] (40) NULL ,
[物料特性c] [varchar] (40) NULL ,
[物料特性d] [varchar] (40) NULL ,
[长] [decimal](18, 3) NULL ,
[宽] [decimal](18, 3) NULL ,
[高] [decimal](18, 3) NULL ,
[净重] [decimal](18, 3) NULL ,
[品牌] [char] (10) NULL ,
[颜色] [char] (10) NULL ,
[等级] [char] (10) NULL ,
[进货提前期] [int] NULL ,
[准备周期] [int] NULL ,
[生产周期] [int] NULL ,
[最小包装量] [decimal](18, 3) NULL ,
[最低销售量] [decimal](18, 3) NULL ,
[批量] [decimal](18, 4) NULL ,
[最高库存] [decimal](18, 3) NULL ,
[最低库存] [decimal](18, 3) NULL ,
[库存期限] [int] NULL ,
[录入者] [char] (8) NULL ,
[录入日期] [int] NULL ,
[低层码] [int] NULL ,
[指定供货商] [char] (10) NULL ,
[定货策略] [char] (10) NULL ,
[生产车间] [char] (10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[物料清单] (
[父项编号] [char] (14) NOT NULL ,
[物料编号] [char] (14) NOT NULL ,
[需要数量] [decimal](18, 4) NOT NULL ,
[领料车间] [char] (10) NULL ,
[领料库房] [char] (10) NULL ,
[损耗率] [decimal](5, 4) NULL ,
[bom状态] [char] (1) NULL ,
[bom信息状态] [char] (1) NULL ,
[审核者] [char] (8) NULL ,
[审核日期] [int] NULL ,
[其它事项] [text] NULL ,
[低层码] [int] NULL ,
[展开标记] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[工厂日历] (
[年份] [int] NOT NULL ,
[计划期] [int] NOT NULL ,
[开始日期] [int] NOT NULL ,
[结束日期] [int] NOT NULL ,
[备注] [varchar] (255) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[主需求计划] (
[编号] [char] (14) NULL ,
[物料编号] [char] (14) NOT NULL ,
[年份] [int] NOT NULL ,
[计划期] [int] NOT NULL ,
[开始日期] [int] NULL ,
[结束日期] [int] NULL ,
[需求数量] [decimal] (15,2) NOT NULL ,
[记帐人] [varchar] (10) NULL ,
[修改日期] [int] NULL ,
[状态] [char] (10) NULL default '有效',
[备注] [varchar] (40) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[主需求计划历史] (
[编号] [char] (14) NULL ,
[物料编号] [char] (14) NOT NULL ,
[年份] [int] NOT NULL ,
[计划期] [int] NOT NULL ,
[开始日期] [int] NULL ,
[结束日期] [int] NULL ,
[需求数量] [decimal] (15,2) NULL ,
[记帐人] [varchar] (10) NULL ,
[修改日期] [int] NULL ,
[状态] [char] (10) NULL ,
[备注] [varchar] (40) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[主生产计划] (
[物料编号] [char] (14) NOT NULL ,
[编号] [char] (14) NULL ,
[年份] [int] NOT NULL ,
[计划期] [int] NOT NULL ,
[开始日期] [int] NULL ,
[结束日期] [int] NULL ,
[期初库存] [decimal] (15,2) NULL ,
[需求数量] [decimal] (15,2) NULL ,
[MPS数量] [decimal] (15,2) NOT NULL ,
[生产单数量] [decimal] (15,2) NULL ,
[预计库存] [decimal] (15,2) NULL ,
[记帐人] [varchar] (10) NULL ,
[修改日期] [int] NULL ,
[审核人] [varchar] (10) NULL ,
[审核日期] [int] NULL ,
[状态] [char] (10) NULL default '有效',
[备注] [varchar] (40) NULL
) ON [PRIMARY]
GO
-- 对主生产计划进行编号
CREATE trigger INSERT_主生产计划
on 主生产计划
for INSERT
AS
declare @bh1 varchar(16)
declare @bh2 varchar(16)
select @bh1 = isnull(max(编号),'MPS0000000000') from 主生产计划
select @bh2 = isnull(max(编号),'MPS0000000000') from 主生产计划历史
if(@bh2>@bh1) select @bh1 = @bh2
declare @no varchar(10)
select @no = substring(@bh1,4,10)
select @no = convert(char(10),convert(int,@no)+1)
select @no = REPLICATE('0',10-LEN(@no))+@no
update 主生产计划 set 编号='MPS' + @no where 编号 is null
GO
CREATE TABLE [dbo].[主生产计划历史] (
[物料编号] [char] (14) NOT NULL ,
[编号] [char] (14) NULL ,
[年份] [int] NOT NULL ,
[计划期] [int] NOT NULL ,
[开始日期] [int] NULL ,
[结束日期] [int] NULL ,
[期初库存] [d
没有合适的资源?快使用搜索试试~ 我知道了~
MRP.rar_DelPhi SQl_MRP
共102个文件
bmp:15个
dcu:11个
~dfm:10个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 18 浏览量
2022-09-24
06:20:13
上传
评论
收藏 1.71MB RAR 举报
温馨提示
Delphi SQL Server MRP
资源推荐
资源详情
资源评论
收起资源包目录
MRP.rar_DelPhi SQl_MRP (102个子文件)
mrpbook.bak 1.39MB
取消 (2).bmp 822B
登录.bmp 822B
删除.bmp 246B
上记录.bmp 246B
搜索.bmp 246B
关闭.bmp 246B
尾记录.bmp 246B
查询选择.bmp 246B
保存.bmp 246B
取消.bmp 246B
下记录.bmp 246B
首记录.bmp 246B
修改.bmp 246B
计算.bmp 246B
新增.bmp 246B
mrp.cfg 446B
Thumbs.db 21KB
BomForm.dcu 20KB
MaterialsForm.dcu 16KB
MainProduceForm.dcu 14KB
MainRequireForm.dcu 13KB
CalendarForm.dcu 11KB
MainForm.dcu 11KB
mrphistoryForm.dcu 7KB
ChooseForm.dcu 7KB
MRPCalForm.dcu 7KB
LoginForm.dcu 7KB
Unit1.dcu 6KB
mrphistoryForm.ddp 51B
MainRequireForm.ddp 51B
BomForm.ddp 51B
LoginForm.ddp 51B
MRPCalForm.ddp 51B
MaterialsForm.ddp 51B
CalendarForm.ddp 51B
MainForm.ddp 51B
ChooseForm.ddp 51B
MainProduceForm.ddp 51B
LoginForm.dfm 255KB
MainForm.dfm 255KB
MaterialsForm.dfm 26KB
MainProduceForm.dfm 24KB
BomForm.dfm 21KB
MainRequireForm.dfm 20KB
CalendarForm.dfm 16KB
mrphistoryForm.dfm 9KB
ChooseForm.dfm 8KB
MRPCalForm.dfm 7KB
mrp.dof 2KB
mrp.dpr 721B
mrp.dsk 5KB
mrp.exe 1.39MB
mrp.ico 766B
流水线.jpg 112KB
登入图1.jpg 111KB
登入图.jpg 39KB
mrpbook_Log.LDF 1024KB
mrpbook_Data.MDF 1.38MB
BomForm.pas 16KB
MaterialsForm.pas 13KB
MainProduceForm.pas 10KB
MainRequireForm.pas 9KB
CalendarForm.pas 7KB
MainForm.pas 7KB
ChooseForm.pas 3KB
MRPCalForm.pas 3KB
mrphistoryForm.pas 3KB
LoginForm.pas 2KB
mrp.res 876B
生产管理系统实例程序.sql 21KB
CalendarForm.~ddp 51B
MainProduceForm.~ddp 51B
BomForm.~ddp 51B
mrphistoryForm.~ddp 51B
MainRequireForm.~ddp 51B
MRPCalForm.~ddp 51B
MainForm.~ddp 51B
ChooseForm.~ddp 51B
MaterialsForm.~ddp 51B
LoginForm.~ddp 51B
LoginForm.~dfm 255KB
MainForm.~dfm 254KB
MaterialsForm.~dfm 26KB
MainProduceForm.~dfm 24KB
BomForm.~dfm 21KB
MainRequireForm.~dfm 20KB
CalendarForm.~dfm 16KB
mrphistoryForm.~dfm 9KB
ChooseForm.~dfm 8KB
MRPCalForm.~dfm 7KB
mrp.~dpr 626B
BomForm.~pas 16KB
MaterialsForm.~pas 13KB
MainProduceForm.~pas 10KB
MainRequireForm.~pas 9KB
CalendarForm.~pas 7KB
MainForm.~pas 6KB
ChooseForm.~pas 3KB
MRPCalForm.~pas 3KB
共 102 条
- 1
- 2
资源评论
JaniceLu
- 粉丝: 79
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- TG-2024-05-23-204718255.mp4
- 候志强@181 5428 8938_20240420112107.amr
- spispispispispi
- 实验二:IP协议分析.zip
- 驱动代码驱动代码驱动代码驱动代码
- SVID_20240523_141155_1.mp4
- Code for the complete guide to tkinter tutorial
- 关于百货中心供应链管理系统.zip
- SimpleFolderIcon-master 修改Unity的Project下的文件夹图标
- A python Tkinter widget to display tile based maps
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功