短信猫程序 就与c#开发的程序

CREATE TABLE [AddressBook] ( [AddressBookId] [int] IDENTITY (1, 1) NOT NULL , [OwnerUserId] [int] NOT NULL , [AddressBookName] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [Remark] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_AddressBook] PRIMARY KEY CLUSTERED ( [AddressBookId] ) ON [PRIMARY] , CONSTRAINT [FK_AddressBook_UserInfo] FOREIGN KEY ( [OwnerUserId] ) REFERENCES [UserInfo] ( [UserId] ) ) ON [PRIMARY] GO CREATE TABLE [AddressBookDetail] ( [AddressBookDetailId] [int] IDENTITY (1, 1) NOT NULL , [AddressBookId] [int] NOT NULL , [ContacterId] [int] NOT NULL , CONSTRAINT [PK_AddressBookDetail] PRIMARY KEY CLUSTERED ( [AddressBookDetailId] ) ON [PRIMARY] , CONSTRAINT [FK_AddressBookDetail_AddressBook] FOREIGN KEY ( [AddressBookId] ) REFERENCES [AddressBook] ( [AddressBookId] ) ) ON [PRIMARY] GO CREATE TABLE [InBox] ( [InBoxId] [int] IDENTITY (1, 1) NOT NULL , [SendUserId] [int] NOT NULL , [ReceiveUserId] [int] NOT NULL , [ReceiveTime] [datetime] NOT NULL , [Status] [int] NOT NULL , [Type] [int] NOT NULL , [Message] [varchar] (140) COLLATE Chinese_PRC_CI_AS NOT NULL , CONSTRAINT [PK_InBox] PRIMARY KEY CLUSTERED ( [InBoxId] ) ON [PRIMARY] , CONSTRAINT [FK_InBox_UserInfo] FOREIGN KEY ( [SendUserId] ) REFERENCES [UserInfo] ( [UserId] ), CONSTRAINT [FK_InBox_UserInfo1] FOREIGN KEY ( [SendUserId] ) REFERENCES [UserInfo] ( [UserId] ) ) ON [PRIMARY] GO CREATE TABLE [OutBox] ( [OutBoxId] [int] IDENTITY (1, 1) NOT NULL , [SendUserId] [int] NOT NULL , [SendTime] [datetime] NOT NULL , [Message] [varchar] (140) COLLATE Chinese_PRC_CI_AS NOT NULL , [Status] [int] NOT NULL , [Type] [int] NOT NULL , CONSTRAINT [PK_OutBox] PRIMARY KEY CLUSTERED ( [OutBoxId] ) ON [PRIMARY] , CONSTRAINT [FK_OutBox_UserInfo] FOREIGN KEY ( [SendUserId] ) REFERENCES [UserInfo] ( [UserId] ) ) ON [PRIMARY] GO CREATE TABLE [OutBoxDetail] ( [OutBoxDetailId] [int] IDENTITY (1, 1) NOT NULL , [OutBoxId] [int] NOT NULL , [ReceiverId] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [UserInfo] ( [UserId] [int] IDENTITY (1, 1) NOT NULL , [LoginName] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [Password] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserName] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [Gender] [int] NOT NULL , [Mobile] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [Remark] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED ( [UserId] ) ON [PRIMARY] ) ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO create procedure CreateInsertProcedure @TabName varchar(128) = 'Groups' as declare @id as int select @id = id from sysobjects where name = @TabName declare c1 cursor for select name, xtype, length, colstat from syscolumns where id = @id declare @name as varchar(128) declare @xtype as int declare @length as int declare @colstat as int declare @sp as varchar(2048) set @sp = ' CREATE procedure [Insert' + @TabName + ']' declare @Params as varchar(1024) declare @Insert as varchar(1024) declare @Values as varchar(1024) set @Params = '' set @Insert = ' INSERT ' + @TabName + '(' SET @Values = ' VALUES' + '(' open c1 fetch next from c1 into @name,@xtype,@length,@colstat while @@fetch_status = 0 begin if(@xtype = 56 and @colstat <> 1) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'int' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 35) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'text'+ ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype= 175) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'varchar' + '(' + ltrim(str(@length))+ ')' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 61) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'datetime' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 104) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'bit' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 62) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'float' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 167) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'varchar' + '(' + ltrim(str(@length))+ ')' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 60) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'money' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end else if(@xtype = 106) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'decimal' + ',' set @Insert = @Insert + @name + ', ' set @Values = @Values + '@' + @name + ', ' end fetch next from c1 into @name,@xtype,@length,@colstat end set @Params = substring(@params, 0,len(@Params)) set @Insert = substring(@Insert, 0,len(@Insert) -5) + ')' set @Values = substring(@Values, 0,len(@Values) -5) + ')' set @sp = @sp + @Params + ' ' + 'AS ' + @Insert + ' ' + @Values print @sp exec(@sp) close c1 deallocate c1 GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO create procedure CreateUpdateProcedure @TabName varchar(128) = '' as declare @id as int select @id = id from sysobjects where name = @TabName declare c1 cursor for select name, xtype, length, colstat from syscolumns where id = @id declare @name as varchar(128) declare @xtype as int declare @length as int declare @colstat as int declare @sp as varchar(8000) set @sp = ' CREATE procedure [Update' + @TabName + ']' declare @Params as varchar(8000) declare @update as varchar(8000) declare @Values as varchar(8000) declare @condition as varchar(1024) set @Params = '' set @update = ' UPDATE ' + @TabName + '' set @Values = ' SET ' set @condition = ' WHERE 1 = 1' open c1 fetch next from c1 into @name,@xtype,@length,@colstat while @@fetch_status = 0 begin if(@colstat = 1) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'int' + ',' set @condition = @condition + ' AND ' + @name + ' = ' + '@' + convert(char(24), @name) end else if(@xtype = 56 and @colstat <> 1) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'int' + ',' set @Values = @Values + @name + ' = @' + @name + ', ' end else if(@xtype = 35) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'text'+ ',' set @Values = @Values + @name + ' = @' + @name + ', ' end else if(@xtype= 175) begin set @Params = @Params + ' @' + convert(char(24), @name) + 'varchar' + '(' + ltrim(str(@length))+ ')' + ',' set @Values = @Values + @name