项目采买单(表八).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 ,
      [xmsj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
      [sl] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [dj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [hj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [sjzc] [char] (30) NULL ,
      [xxsm] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
      [wcqr] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
      [sfyfp] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [xmzj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [kffz] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [cwfz] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
      [zjl] [char] (20) 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),
      @xmsj char (20),
      @mc char (40),
      @sl char (20),
      @dj char (20),
      @hj char (20),
      @sjzc char (30),
      @xxsm char (100),
      @wcqr char (30),
      @sfyfp char (20),
      @xmzj char (20),
      @kffz char (20),
      @cwfz char (20),
      @zjl char (20)
)

AS
insert 项目采买单
(
      xmbh,
      xmsj,
      mc,
      sl,
      dj,
      hj,
      sjzc,
      xxsm,
      wcqr,
      sfyfp,
      xmzj,
      kffz,
      cwfz,
      zjl
)

values
(
      @xmbh,
      @xmsj,
      @mc,
      @sl,
      @dj,
      @hj,
      @sjzc,
      @xxsm,
      @wcqr,
      @sfyfp,
      @xmzj,
      @kffz,
      @cwfz,
      @zjl
)