项目人员分工明细及考核（表七）.txt

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

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 ,
      [bdcyr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmdw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmmc] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmzj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [gczj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmdd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [lcdd] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmzl] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmjl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
      [sj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [qy] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
      [fzr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [gznr] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [yqsj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [sjsj] [char] (20)  COLLATE Chinese_PRC_CI_AS NULL ,
      [ccgz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [ccqk] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [gznr2] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [wcqk] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [cd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [zt] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [zzps] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [zhsz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [xljm] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [gzzt] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
      [zhdf] [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 char (20) ,
      @bdcyr char (20) ,
      @xmdw char (10) ,
      @xmmc char (80) ,
      @xmzj char (20) ,
      @gczj char (20) ,
      @xmdd char (100) ,
      @lcdd char (20) ,
      @xmzl char (20) ,
      @xmjl char (10) ,
      @sj char (20) ,
      @qy char (60) ,
      @fzr char (20) ,
      @gznr char (200) ,
      @yqsj char (20) ,
      @sjsj char (20) ,
      @ccgz char (200) ,
      @ccqk char (200) ,
      @gznr2 char (200) ,
      @wcqk char (200) ,
      @cd char (100) ,
      @zt char (100) ,
      @zzps char (100) ,
      @zhsz char (100) ,
      @xljm char (100) ,
      @gzzt char (200) ,
      @zhdf char (10)
)

AS
insert 项目人员分工明细及考核
(
      xmbh ,
      bdbh ,
      hdsj ,
      bdcyr ,
      xmdw ,
      xmmc ,
      xmzj ,
      gczj ,
      xmdd ,
      lcdd ,
      xmzl ,
      xmjl ,
      sj ,
      qy ,
      fzr ,
      gznr ,
      yqsj ,
      sjsj ,
      ccgz ,
      ccqk ,
      gznr2 ,
      wcqk ,
      cd ,
      zt ,
      zzps ,
      zhsz ,
      xljm ,
      gzzt ,
      zhdf
)

values
(
      @xmbh ,
      @bdbh ,
      @hdsj ,
      @bdcyr ,
      @xmdw ,
      @xmmc ,
      @xmzj ,
      @gczj ,
      @xmdd ,
      @lcdd ,
      @xmzl ,
      @xmjl ,
      @sj ,
      @qy ,
      @fzr ,
      @gznr ,
      @yqsj ,
      @sjsj ,
      @ccgz ,
      @ccqk ,
      @gznr2 ,
      @wcqk ,
      @cd ,
      @zt ,
      @zzps ,
      @zhsz ,
      @xljm ,
      @gzzt ,
      @zhdf
)