项目监理对工程中心沟通单（表五）.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] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [hdsj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [xmmc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
      [khqc] [char] (60) 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 ,
      [jcsj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [kssj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [ccsj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [gcrs] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [wyrs] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [djfs] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [lsrs] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [xcgl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [nycc] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
      [tgcl] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
      [jkfs] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [sgt] [char] (100) 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 (20),
      @hdsj char (20),
      @xmmc char (40),
      @khqc char (60),
      @xmzj char (10),
      @xmzl char (10),
      @gczj char (10),
      @jcsj char (20),
      @kssj char (20),
      @ccsj char (20),
      @gcrs char (10), 
      @wyrs char (10),
      @djfs char (10),
      @lsrs char (10),
      @xcgl char (10),
      @nycc char (30),
      @tgcl char (30),
      @jkfs char (100),
      @sgt char (100)
)

AS
insert 项目监理对工程中心沟通单
(
      xmbh,
      bdbh,
      hdsj,
      xmmc,
      khqc,
      xmzj,
      xmzl,
      gczj,
      jcsj,
      kssj,
      ccsj,
      gcrs, 
      wyrs,
      djfs,
      lsrs,
      xcgl,
      nycc,
      tgcl,
      jkfs,
      sgt
)

values
(
      @xmbh ,
      @bdbh ,
      @hdsj ,
      @xmmc ,
      @khqc ,
      @xmzj ,
      @xmzl ,
      @gczj ,
      @jcsj ,
      @kssj ,
      @ccsj ,
      @gcrs , 
      @wyrs ,
      @djfs ,
      @lsrs ,
      @xcgl ,
      @nycc ,
      @tgcl ,
      @jkfs ,
      @sgt
)