项目客户档案单(表三).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] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[hdsj] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
        [xmmc] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[hzsj] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[hzxg] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[xb] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[bm] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
        [sr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[zj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ys] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[jtdz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[dwdz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[yb] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[grms] [char] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[hzms] [char] (800) 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),
	@bdbh char (40),
	@hdsj char (40),
        @xmmc char (50),
	@dw char (40),
	@hzsj char (40),
	@hzxg char (40),
	@xm char (10),
	@xb char (8),
	@bm char (40),
        @sr char (40),
	@sj char (15),
	@zj char (10),
	@ys char (40),
	@qq char (40),
	@jtdz char (100),
	@dwdz char (100),
	@yb char (10),
	@grms char (300),
	@hzms char (800),
	@xmzj char (20),
	@kffz char (20),
	@cwfz char (20),
	@zjl char (20)
)

 AS
insert 项目客户档案单
(
        xmbh,
	bdbh,
	hdsj,
        xmmc,
	dw,
	hzsj,
	hzxg,
	xm,
	xb,
	bm,
        sr,
	sj,
	zj,
	ys,
	qq,
	jtdz,
	dwdz,
	yb,
	grms,
	hzms,
	xmzj,
	kffz,
	cwfz,
	zjl
)

values
(
        @xmbh,
	@bdbh,
	@hdsj,
        @xmmc,
	@dw,
	@hzsj,
	@hzxg,
	@xm,
	@xb,
	@bm,
        @sr,
	@sj,
	@zj,
	@ys,
	@qq,
	@jtdz,
	@dwdz,
	@yb,
	@grms,
	@hzms,
	@xmzj,
	@kffz,
	@cwfz,
	@zjl
)