.NET例(简单控件)(赚积分...)

if exists (select name from master.dbo.sysdatabases where name = N'chjh') DROP DATABASE [chjh] go create database [chjh] go use [chjh] go go --客户表 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[client]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[client] go create table [dbo].[client] ( [UserID] int identity constraint [PK_client_UserID] primary key clustered, [UserName] [varchar](50) not null constraint [UK_client_UserName] Unique , [Password] [varchar] (60) not null, [Email] [varchar] (100) , [Question] [varchar] (40) not null, [Tell] varchar(30) null, [Added] varchar(50) null, [YB] varchar(10) null, [AddedDate] [datetime] not null constraint [DF_client_AddedDate] DEFAULT (getdate()) ) on [primary] go --商户表 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[boss]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[boss] go create table [dbo].[boss] ( [BossID] int identity constraint [PK_Boss_BossID] primary key clustered, [Bname] varchar(50) not null constraint [UK_boss_Bname] Unique, [Bpwd] varchar(60) not null, [From] varchar(20) not null, [paperwork]varchar(30)not null constraint [UK_boss_paperwork] Unique, [tell] varchar(30) not null, [Mail]varchar(100)not null, [AddedDate] [datetime] not null constraint [DF_Boss_AddedDate] DEFAULT (getdate()) )on [primary] go -- --删除用户 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DeleteUser] GO CREATE PROCEDURE DeleteUser @UserID int AS DELETE FROM client WHERE UserID = @UserID GO --返回所有可用用户信息 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetUsers]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GetUsers] GO CREATE PROCEDURE [dbo].[GetUsers] AS SELECT * FROM client GO -- --返回所有可用用户信息 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetBoss]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[GetBoss] GO CREATE PROCEDURE [dbo].[GetBoss] AS SELECT * FROM boss GO --删除用户 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteBOSS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DeleteBOSS] GO CREATE PROCEDURE DeleteBOSS @BossID int AS DELETE FROM BOSS WHERE BossID = @BossID GO --货品类别 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Type]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Type] go create table [dbo].[Type] ( [Tid] int identity constraint [PK_Type_Tid] primary key clustered, [Tname] varchar(20) not null ) go --加类 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertType]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[InsertType] GO CREATE PROCEDURE InsertType @Tid int output, @Tname varchar(20) as INSERT INTO Type ([Tname]) VALUES (@Tname) SET @Tid = @@IDENTITY RETURN 1 go --删类 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteType]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DeleteType] GO CREATE PROCEDURE DeleteType @Tid int AS DELETE FROM Type WHERE Tid = @Tid go --插商 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertC]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[InsertC] GO CREATE PROCEDURE InsertC @Bname varchar(16), @Bpwd varchar(60), @Mail varchar(100), @From varchar(20), @tell varchar(30), @paperwork varchar(30), @Bid int output AS INSERT INTO Users ([Bname], [Bpwd], [Mail], [From], [tell],[paperwork] , [AddedDate]) VALUES (@Bname, @Bpwd, @Mail, @From, @tell,@paperwork, getdate()) SET @Bid = @@IDENTITY RETURN 1 go --产品 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[merchandise]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[merchandise] go create table [dbo].[merchandise] ( [Tid] int , [Mid] int identity constraint [PK_merchandise_Mid] primary key clustered, [Mname] varchar(40) not null, [Mimageurl] varchar(100) not null constraint [DF_merchandise_MimageUrl] DEFAULT (''), [introduction] text not null, --商品描述 [Money] float not null, [remen] varchar(10) not null, [remenMoney] float null, [xinpin] varchar(10) not null, [tuijian] varchar(10) not null constraint [FK_merchandise_Type] foreign key ([Tid]) references [dbo].[Type] ([Tid]) ) go --订购单 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Buy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Buy] go create table [dbo].[Buy] ( [Bid] int identity constraint [PK_Buy_Bid] primary key clustered, [Mid] int, [UserID] int, [Bname] varchar(50) not null, [Btell] varchar(50) not null, [BAdd] varchar(500) not null, [ShowMoney]varchar(30) constraint [DF_Buy_Show] default '货到付款', constraint [FK_Buy_merchandise] foreign key ([Mid]) references [dbo].[merchandise] ([Mid]), constraint [FK_Buy_client] foreign key ([UserID]) references [dbo].[client] ([UserID]) ) go --订购单 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Job]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Job] go create table [dbo].[Job] ( [Zid] int identity constraint [PK_Job_Bid] primary key clustered, [Zname] varchar(100), [Zaddess]varchar(100), [Znumber] varchar(100), [Zyaoqiu] varchar(500), ) go --留言 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LiuYan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[LiuYan] go create table [dbo].[LiuYan] ( [Lid] int identity constraint [PK_LiuYan_Lid] primary key clustered, [Ltb] varchar(30), [UserID] int, constraint [FK_LiuYan_client] foreign key ([UserID]) references [dbo].[client] ([UserID]), [Lxx] varchar(500) ) go select * from LiuYan