十、美化界面

BackColor—web—Transparent

数据库

USE [fiber_yy]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yy_user_record](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nchar](10) NOT NULL,
	[sex] [nchar](10) NOT NULL,
	[phone] [varchar](50) NOT NULL,
	[time] [datetime] NOT NULL,
 CONSTRAINT [PK_yy_user_record] 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]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yy_user](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nchar](10) NOT NULL,
	[password] [nchar](10) NOT NULL,
	[sex] [nchar](10) NOT NULL,
	[phone] [varchar](50) NOT NULL,
 CONSTRAINT [PK_yy_user] 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]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[yy_textile_record](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[number] [nchar](10) NOT NULL,
	[stock] [int] NOT NULL,
	[username] [nchar](10) NOT NULL,
	[time] [datetime] NOT NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yy_textile](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](50) NOT NULL,
	[number] [int] NOT NULL,
	[warp_density] [float] NOT NULL,
	[weft_density] [float] NOT NULL,
	[warp_linear_density] [float] NOT NULL,
	[weft_linear_density] [float] NOT NULL,
	[material] [varchar](50) NOT NULL,
	[square_meter_weight] [float] NOT NULL,
	[width_of_cloth] [float] NOT NULL,
	[horse_length] [float] NOT NULL,
	[picture] [image] NOT NULL,
	[organization] [varchar](50) NOT NULL,
	[stock] [int] NOT NULL,
 CONSTRAINT [PK_yy_textile] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[yy_admin](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nchar](10) NOT NULL,
	[password] [nchar](10) NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[yy_textile_record] ADD  CONSTRAINT [DF_yy_textile_record_time]  DEFAULT (getdate()) FOR [time]
GO

ALTER TABLE [dbo].[yy_user_record] ADD  CONSTRAINT [DF_yy_user_record_time]  DEFAULT (getdate()) FOR [time]
GO