项目监理对演艺中心沟通单（表六）.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 ,
      [xmdw] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmdd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [bdsj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [bddd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [kssj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [jssj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [xycp] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [sm] [char] (200)  COLLATE Chinese_PRC_CI_AS NULL ,
      [hzsrs] [char] (10) NULL ,
      [xm] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
      [gzap] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [hzx1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
      [hzx2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
      [tsx] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
      [clap] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [yrss] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [xm2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [lb] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [sl] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [bysj] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
      [yqsm] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
      [jsfs] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [mc] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [sl2] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
      [bh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [bz] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
      [bzsm] [char] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [kfzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [cwzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [zjl] [char] (10) 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 datetime ,
      @xmdw char (60) ,
      @xmdd char (100) ,
      @bdsj datetime ,
      @bddd char (100) ,
      @kssj datetime ,
      @jssj datetime ,
      @xycp char (10) ,
      @sm char (200) ,
      @hzsrs char (10) ,
      @xm char (60) ,
      @gzap char (200) ,
      @hzx1 char (50) ,
      @hzx2 char (50) ,
      @tsx char (50) ,
      @clap char (200) ,
      @yrss char (200) ,
      @xm2 char (20) ,
      @lb char (20) ,
      @sl char (20) ,
      @bysj char (50) ,
      @yqsm char (500) ,
      @jsfs char (200) ,
      @mc char (100) ,
      @sl2 char (40) ,
      @bh char (20) ,
      @bz char (500) ,
      @bzsm char (1000) ,
      @xmzj char (10) ,
      @kfzj char (10) ,
      @cwzj char (10) ,
      @zjl char (10)
)

AS
insert 项目监理对演艺中心沟通单
(
      xmbh ,
      bdbh ,
      hdsj ,
      xmdw ,
      xmdd ,
      bdsj ,
      bddd ,
      kssj ,
      jssj ,
      xycp ,
      sm ,
      hzsrs ,
      xm ,
      gzap ,
      hzx1 ,
      hzx2 ,
      tsx ,
      clap ,
      yrss ,
      xm2 ,
      lb ,
      sl ,
      bysj ,
      yqsm ,
      jsfs ,
      mc ,
      sl2 ,
      bh ,
      bz ,
      bzsm ,
      xmzj ,
      kfzj ,
      cwzj ,
      zjl
)

values
(
      @xmbh ,
      @bdbh ,
      @hdsj ,
      @xmdw ,
      @xmdd ,
      @bdsj ,
      @bddd ,
      @kssj ,
      @jssj ,
      @xycp ,
      @sm ,
      @hzsrs ,
      @xm ,
      @gzap ,
      @hzx1 ,
      @hzx2 ,
      @tsx ,
      @clap ,
      @yrss ,
      @xm2 ,
      @lb ,
      @sl ,
      @bysj ,
      @yqsm ,
      @jsfs ,
      @mc ,
      @sl2 ,
      @bh ,
      @bz ,
      @bzsm ,
      @xmzj ,
      @kfzj ,
      @cwzj ,
      @zjl
)