项目工程执行中心出库单（表四）.txt

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

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
)