进销存软件触发器。用于仓储型公司。库存量的变化。

				USE [xc]
				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].[项目工程执行中心出库单] (
				    [xmbh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL,
				    [bdbh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [hdsj] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [xmdw] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [xmdd] [char] (300) COLLATE Chinese_PRC_CI_AS NULL, 
				    [xmzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [xmzl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [gczj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [wpglr] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [xmjl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [jcsj] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [cpsj] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [kssj] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [ccsj] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [mc] [char] (30) COLLATE Chinese_PRC_CI_AS NULL, 
				    [bh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [gg] [char] (10) COLLATE Chinese_PRC_CI_AS NULL, 
				    [cksl] [numeric] (12) NULL, 
				    [ccsl] [numeric] (12) NULL,
				    [wpglrr] [char] (14) COLLATE Chinese_PRC_CI_AS NULL, 
				    [gksl] [numeric] (12) NULL,
				    [sl] [int] NULL, 
				    [kg] [char] (12) COLLATE Chinese_PRC_CI_AS NULL, 
				)
				ON [PRIMARY]
				GO
				
				
				SET QUOTED_IDENTIFIER ON 
				GO
				SET ANSI_NULLS ON 
				GO
				
				
				CREATE PROCEDURE 项目工程执行中心出库单_setup
				(
				    @xmbh char (30),
				    @bdbh char (30),
				    @hdsj char (30),
				    @xmdw char (30),
				    @xmdd char (300),
				    @xmzj char (10), 
				    @xmzl char (10), 
				    @gczj char (10), 
				    @wpglr char (10), 
				    @xmjl char (10), 
				    @jcsj char (30),
				    @cpsj char (30), 
				    @kssj char (30), 
				    @ccsj char (30), 
				    @mc char (30), 
				    @bh char (10), 
				    @gg char (10), 
				    @cksl numeric (12), 
				    @ccsl numeric (12),
				    @wpglrr char (14), 
				    @gksl numeric (12),
				    @sl int,
				    @kg char (12)
				)
				
				AS
				insert 项目工程执行中心出库单
				(
				    xmbh,
				    bdbh, 
				    hdsj, 
				    xmdw, 
				    xmdd, 
				    xmzj, 
				    xmzl, 
				    gczj, 
				    wpglr, 
				    xmjl, 
				    jcsj, 
				    cpsj,
				    kssj,
				    ccsj,
				    mc, 
				    bh, 
				    gg, 
				    cksl, 
				    ccsl,
				    wpglrr, 
				    gksl, 
				    sl,
				    kg
				)
				
				values
				(
				    @xmbh,
				    @bdbh, 
				    @hdsj, 
				    @xmdw, 
				    @xmdd, 
				    @xmzj, 
				    @xmzl, 
				    @gczj, 
				    @wpglr, 
				    @xmjl, 
				    @jcsj, 
				    @cpsj,
				    @kssj,
				    @ccsj,
				    @mc, 
				    @bh, 
				    @gg, 
				    @cksl, 
				    @ccsl,
				    @wpglrr, 
				    @gksl, 
				    @sl,
				    @kg
				)