if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg2审核采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg2审核采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg5订货合同计划登记]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg5订货合同计划登记]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采购订单审核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采购订单审核]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp计算old]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mrp计算old]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_KF2批次调拨单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_KF2批次调拨单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1删除全部未用项]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1删除全部未用项]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1取得采购项]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1取得采购项]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1填写采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1填写采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg3修改采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg3修改采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj1填生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj1填生产订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj2审生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj2审生产订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5填完工报告单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5填完工报告单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5由MRP生成生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5由MRP生成生产订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_kf1填成品入库单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_kf1填成品入库单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生产计划审核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生产计划审核]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生产计划预排]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生产计划预排]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps填需求计划]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps填需求计划]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpMpsTest]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpMpsTest]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest子项毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest子项毛需求]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest计算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest计算]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpmps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpmps]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp子项毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp子项毛需求]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp生产件资源负荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp生产件资源负荷]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp计算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp计算]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp试算生产件资源负荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp试算生产件资源负荷]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_sc生成领料单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_sc生成领料单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_加入进销存卡片]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_加入进销存卡片]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sys生成资源日程表]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sys生成资源日程表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[低层码]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[低层码]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[V物料主文件]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V物料主文件]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v商品库存明细]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v商品库存明细]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v资源清单]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v资源清单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v资源负荷报表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v资源负荷报表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bom信息状态]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bom信息状态]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bom状态]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bom状态]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jzh每月结转日期表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jzh每月结转日期表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp0]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrpcalcd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrpcalcd]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrpcalcm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrpcalcm]
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].[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 = obje
03 生产管理系统.rar （68个子文件） 
03 生产管理系统 Icon 
计算.bmp 246B 新增.bmp 246B 删除.bmp 246B 下记录.bmp 246B 尾记录.bmp 246B 上记录.bmp 246B 取消.bmp 246B
mrp.ico 766B 搜索.bmp 246B 保存.bmp 246B 查询选择.bmp 246B 首记录.bmp 246B 修改.bmp 246B 代码 生产管理系统 生产管理系统.csproj 10KB DataSet1.xsx 165B BomForm.cs 39KB ProducePlan.resx 52KB DataSet2.xsx 165B Form1.cs 1KB DataSet1.cs 161KB bin Debug 生产管理系统.pdb 638KB
生产管理系统.exe 504KB MRPCal.cs 15KB DataSet1.xsd 9KB obj Debug 生产管理系统.FactorySchedule.resources 27KB 生产管理系统.MaterialsForm.resources 54KB 生产管理系统.MRPCal.resources 15KB 生产管理系统.BomForm.resources 28KB 生产管理系统.mainForm.resources 10KB temp 生产管理系统.pdb 638KB TempPE DataSet2.cs.dll 48KB DataSet3.cs.dll 48KB DataSet1.cs.dll 80KB 生产管理系统.SelectMaterial.resources 11KB 生产管理系统.exe 504KB 生产管理系统.ProducePlan.resources 46KB 生产管理系统.MRPHistory.resources 22KB 生产管理系统.RequirePlan.resources 37KB SelectMaterial.resx 14KB DataSet2.cs 82KB DataSet3.xsd 4KB DataSet3.cs 84KB MaterialsForm.cs 90KB FactorySchedule.resx 32KB MaterialsForm.resx 60KB ProducePlan.cs 59KB RequirePlan.resx 42KB MainForm.resx 12KB Icon1.ico 1KB MainForm.cs 10KB 生产管理系统.csproj.user 2KB App.ico 1KB Form1.resx 2KB DataSet2.xsd 5KB MRPCal.resx 19KB RequirePlan.cs 44KB BomForm.resx 33KB MRPHistory.resx 26KB MRPHistory.cs 18KB SelectMaterial.cs 13KB AssemblyInfo.cs 2KB FactorySchedule.cs 27KB 生产管理系统.sln 922B 建库脚本 mrpbook_Log.LDF 1024KB 生产管理系统.sql 153KB mrpbook.bak 2.78MB 生产管理系统实例程序.sql 21KB mrpbook_Data.MDF 1.38MB资源评论
润物wu声
- 粉丝: 50
- 资源: 11
