【正文】 nghao] [varchar](50) NULL, [type] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_kehugongying] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO下單建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_order]( [id] [int] IDENTITY(1,1) NOT NULL, [bianhao] [varchar](50) NOT NULL, [riqi] [varchar](50) NULL, [jine] [int] NULL, [kehu_name] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_order] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO入庫(kù)建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_ruku]( [id] [int] IDENTITY(1,1) NOT NULL, [goodsId] [int] NULL, [gongyingshangId] [int] NULL, [shijian] [varchar](50) NULL, [shuliang] [int] NULL, [zongjiage] [int] NULL, [jingshouren] [varchar](50) NULL, [beizhu] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_churuku] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO收付款建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_shoufukuan]( [id] [int] IDENTITY(1,1) NOT NULL, [jine] [int] NULL, [shijian] [varchar](50) NULL, [danjuhao] [varchar](50) NULL, [kuanlaiyuan] [varchar](50) NULL, [beizhu] [varchar](50) NULL, [type] [int] NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_shoufukuan] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO配送建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_wuliu]( [id] [int] IDENTITY(1,1) NOT NULL, [chufadi] [varchar](50) NULL, [mudidi] [varchar](50) NULL, [facheshijian] [varchar](50) NULL, [fanhushijian] [varchar](50) NULL, [chepaihao] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_wuliu] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO1員工建表USE [db_cangchu]GO/****** Object: Table [dbo].[t_yuangong] Script Date: 05/06/2015 20:59:36 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_yuangong]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [sex] [varchar](50) NULL, [age] [varchar](50) NULL, [tel] [varchar](50) NULL, [address] [varchar](50) NULL, [zhiwei] [varchar](50) NULL, [quanxian] [int] NULL, [loginName] [varchar](50) NULL, [loginPw] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_yuangong] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO存儲(chǔ)過(guò)程USE [db_cangchu]GO/****** Object: StoredProcedure [dbo].[dt_addtosourcecontrol] Script Date: 05/07/2015 21:47:30 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[dt_addtosourcecontrol] vchSourceSafeINI varchar(255) = 39。, vchComment varchar(255) =39。, vchPassword varchar(255) =39。declare vchDatabaseName varchar(255)select vchDatabaseName = db_name()declare iReturnValue intselect iReturnValue = 0declare iPropertyObjectId intdeclare vchParentId varchar(255)declare iObjectCount intselect iObjectCount = 0 exec iReturn = sp_OACreate VSSGUID, iObjectId OUT if iReturn 0 GOTO E_OAError /* Create Project in SS */ exec iReturn = sp_OAMethod iObjectId, 39。, iStreamObjectId OUT if iReturn 0 GOTO E_OAError /* Set Database Properties */ begin tran SetProperties /* add high level object */ exec iPropertyObjectId = 39。, vchParentId , NULL exec iPropertyObjectId, 39。 , vchSourceSafeINI , NULL exec iPropertyObjectId, 39。, vchDatabaseName, NULL if error 0 GOTO E_General_Error mit tran SetProperties declare cursorProcNames cursor for select convert(varchar(255), name) from sysobjects where type = 39。 open cursorProcNames while 1 = 1 begin declare vchProcName varchar(255) fetch next from cursorProcNames into vchProcName if fetch_status 0 break select colid, text into ProcLines from sysments where id = object_id(vchProcName) order by colid declare iCurProcLine int declare iProcLines int select iCurProcLine = 1 select iProcLines = (select count(*) from ProcLines) while iCurProcLine = iProcLines begin declare pos int select pos = 1 declare iCurLineSize int select iCurLineSize = len((select text from ProcLines where colid = iCurProcLine)) while pos = iCurLineSize begin declare vchProcLinePiece varchar(255) select vchProcLinePiece = convert(varchar(255),