资料查看下载交界面

班级名称: Label

课程名称: net框架程序设计 173 CK3R02A

标题：employee数据库sql2008版

employee数据库sql2008版，大家也可以创建employee以后再运行以下脚本


	脚本：


	USE [employee] 
GO 
/****** Object:&nbsp; Table [dbo].[表1]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[表1]( 
&nbsp;&nbsp; &nbsp;[编号] [int] NOT NULL, 
&nbsp;&nbsp; &nbsp;[aa] [int] NULL, 
&nbsp;&nbsp; &nbsp;[ww] [nvarchar](50) NULL 
) ON [PRIMARY] 
GO 
/****** Object:&nbsp; Table [dbo].[T_页面表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_页面表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[功能名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[功能编号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[窗体名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[模块名称] [varchar](50) NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_页面表] ON 
INSERT [dbo].[T_页面表] ([id], [功能名称], [功能编号], [窗体名称], [模块名称]) VALUES (1, N'产品库存', N'11', N'chanpinkucun', N'库存管理') 
INSERT [dbo].[T_页面表] ([id], [功能名称], [功能编号], [窗体名称], [模块名称]) VALUES (2, N'产品入库', N'12', N'chanpinruku', N'库存管理') 
INSERT [dbo].[T_页面表] ([id], [功能名称], [功能编号], [窗体名称], [模块名称]) VALUES (3, N'产品出库', N'13', N'chanpinchukuZhujiemian', N'库存管理') 
INSERT [dbo].[T_页面表] ([id], [功能名称], [功能编号], [窗体名称], [模块名称]) VALUES (5, N'产品出库明细', N'14', N'chanpinchuku', N'库存管理') 
SET IDENTITY_INSERT [dbo].[T_页面表] OFF 
/****** Object:&nbsp; Table [dbo].[T_权限表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_权限表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[角色名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[角色内容] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[创建时间] [datetime] NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_权限表] ON 
INSERT [dbo].[T_权限表] ([id], [角色名称], [角色内容], [创建时间]) VALUES (2, N'test2', N'12,13,14', CAST(0x00009E9F017BCAF4 AS DateTime)) 
INSERT [dbo].[T_权限表] ([id], [角色名称], [角色内容], [创建时间]) VALUES (3, N'库存管理', N'11,12,13,14', CAST(0x00009E9F0187F248 AS DateTime)) 
INSERT [dbo].[T_权限表] ([id], [角色名称], [角色内容], [创建时间]) VALUES (4, N'pop', N'11,12,13,14', CAST(0x0000A245008F3748 AS DateTime)) 
INSERT [dbo].[T_权限表] ([id], [角色名称], [角色内容], [创建时间]) VALUES (6, N'test', N'12,13,14,11', CAST(0x0000A24500997BCC AS DateTime)) 
SET IDENTITY_INSERT [dbo].[T_权限表] OFF 
/****** Object:&nbsp; Table [dbo].[T_管理员表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_管理员表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[登录名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[密码] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[真实姓名] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[电话] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[部门] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[角色名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[权限] [varchar](50) NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_管理员表] ON 
INSERT [dbo].[T_管理员表] ([id], [登录名称], [密码], [真实姓名], [电话], [部门], [角色名称], [权限]) VALUES (1, N'aa', N'aa', N'aa', N'', N'aa', N'test', N'12,13,14,11') 
INSERT [dbo].[T_管理员表] ([id], [登录名称], [密码], [真实姓名], [电话], [部门], [角色名称], [权限]) VALUES (2, N'kk', N'kk', N'kk', N'', N'kk', N'库存管理', N'11,12,13,14') 
INSERT [dbo].[T_管理员表] ([id], [登录名称], [密码], [真实姓名], [电话], [部门], [角色名称], [权限]) VALUES (3, N'pp', N'pp', N'pp', N'pp', N'pp', N'test', N'12,13') 
INSERT [dbo].[T_管理员表] ([id], [登录名称], [密码], [真实姓名], [电话], [部门], [角色名称], [权限]) VALUES (4, N'qq', N'qq', N'qq', N'q', N'qqq', N'pop', N'11,12,13,14') 
INSERT [dbo].[T_管理员表] ([id], [登录名称], [密码], [真实姓名], [电话], [部门], [角色名称], [权限]) VALUES (7, N'11', N'11', N'11', N'11', N'11', N'test', N'12,13,14,11') 
SET IDENTITY_INSERT [dbo].[T_管理员表] OFF 
/****** Object:&nbsp; Table [dbo].[T_产品入库表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_产品入库表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[产品名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[产品编号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[规格型号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[类别] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[产品数量] [decimal](18, 2) NULL, 
&nbsp;&nbsp; &nbsp;[单位名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[入库时间] [datetime] NULL, 
&nbsp;&nbsp; &nbsp;[入库人] [varchar](50) NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_产品入库表] ON 
INSERT [dbo].[T_产品入库表] ([id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称], [入库时间], [入库人]) VALUES (3, N'juzi', N'002', N'xx_101', N'机械类', CAST(11.00 AS Decimal(18, 2)), N'公斤', CAST(0x00009E9800000000 AS DateTime), N'dd') 
INSERT [dbo].[T_产品入库表] ([id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称], [入库时间], [入库人]) VALUES (4, N'bangbangtang', N'003', N'xxyy66', N'食品类', CAST(500.00 AS Decimal(18, 2)), N'吨', CAST(0x00009E9800000000 AS DateTime), N'dd') 
INSERT [dbo].[T_产品入库表] ([id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称], [入库时间], [入库人]) VALUES (5, N'juzi', N'', N'xx_101', N'机械类', CAST(11.00 AS Decimal(18, 2)), N'公斤', CAST(0x00009E9800000000 AS DateTime), N'dd') 
SET IDENTITY_INSERT [dbo].[T_产品入库表] OFF 
/****** Object:&nbsp; Table [dbo].[T_产品库存表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_产品库存表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[产品名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[产品编号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[规格型号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[类别] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[产品数量] [decimal](18, 2) NULL, 
&nbsp;&nbsp; &nbsp;[单位名称] [varchar](50) NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_产品库存表] ON 
INSERT [dbo].[T_产品库存表] ([id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (1, N'pingguo', N'001', N'xx_100', N'机械类', CAST(34.00 AS Decimal(18, 2)), N'公斤') 
INSERT [dbo].[T_产品库存表] ([id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (2, N'juzi', N'002', N'xx_101', N'机械类', CAST(-64.00 AS Decimal(18, 2)), N'公斤') 
INSERT [dbo].[T_产品库存表] ([id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (3, N'bangbangtang', N'003', N'xxyy66', N'食品类', CAST(2400.00 AS Decimal(18, 2)), N'吨') 
SET IDENTITY_INSERT [dbo].[T_产品库存表] OFF 
/****** Object:&nbsp; Table [dbo].[T_产品出库主表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_产品出库主表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[商家名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[总金额] [decimal](18, 2) NULL, 
&nbsp;&nbsp; &nbsp;[送货地址] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[出库时间] [datetime] NULL, 
&nbsp;&nbsp; &nbsp;[出库人] [varchar](50) NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_产品出库主表] ON 
INSERT [dbo].[T_产品出库主表] ([id], [商家名称], [总金额], [送货地址], [出库时间], [出库人]) VALUES (1, N'sdfsdf', CAST(233.00 AS Decimal(18, 2)), N'sdfsdf', CAST(0x00009E9800000000 AS DateTime), N'lizi') 
INSERT [dbo].[T_产品出库主表] ([id], [商家名称], [总金额], [送货地址], [出库时间], [出库人]) VALUES (2, N'mmmmmmm', CAST(66.00 AS Decimal(18, 2)), N'555fgh', CAST(0x00009E9800000000 AS DateTime), N'sdf') 
SET IDENTITY_INSERT [dbo].[T_产品出库主表] OFF 
/****** Object:&nbsp; Table [dbo].[T_产品出库明细表]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[T_产品出库明细表]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[主表id] [int] NULL, 
&nbsp;&nbsp; &nbsp;[产品名称] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[产品编号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[规格型号] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[类别] [varchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[产品数量] [decimal](18, 2) NULL, 
&nbsp;&nbsp; &nbsp;[单位名称] [varchar](50) NULL 
) ON [PRIMARY] 
GO 
SET ANSI_PADDING OFF 
GO 
SET IDENTITY_INSERT [dbo].[T_产品出库明细表] ON 
INSERT [dbo].[T_产品出库明细表] ([id], [主表id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (1, NULL, N'juzi', N'002', N'xx_101', N'机械类', CAST(56.00 AS Decimal(18, 2)), N'公斤') 
INSERT [dbo].[T_产品出库明细表] ([id], [主表id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (2, 1, N'juzi', N'002', N'xx_101', N'机械类', CAST(32.00 AS Decimal(18, 2)), N'公斤') 
INSERT [dbo].[T_产品出库明细表] ([id], [主表id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (3, 1, N'pingguo', N'001', N'xx_100', N'机械类', CAST(66.00 AS Decimal(18, 2)), N'公斤') 
INSERT [dbo].[T_产品出库明细表] ([id], [主表id], [产品名称], [产品编号], [规格型号], [类别], [产品数量], [单位名称]) VALUES (4, 2, N'bangbangtang', N'003', N'xxyy66', N'食品类', CAST(100.00 AS Decimal(18, 2)), N'吨') 
SET IDENTITY_INSERT [dbo].[T_产品出库明细表] OFF 
/****** Object:&nbsp; Table [dbo].[employee]&nbsp;&nbsp;&nbsp; Script Date: 10/12/2016 18:15:22 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[employee]( 
&nbsp;&nbsp; &nbsp;[id] [int] IDENTITY(1,1) NOT NULL, 
&nbsp;&nbsp; &nbsp;[学号] [nvarchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[姓名] [nvarchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[性别] [nvarchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[年龄] [smallint] NULL, 
&nbsp;&nbsp; &nbsp;[部门] [nvarchar](50) NULL, 
&nbsp;&nbsp; &nbsp;[职务] [nvarchar](50) NULL 
) ON [PRIMARY] 
GO 
SET IDENTITY_INSERT [dbo].[employee] ON 
INSERT [dbo].[employee] ([id], [学号], [姓名], [性别], [年龄], [部门], [职务]) VALUES (1, N'0001', N'张三', N'男', 30, N'办公室', N'主任') 
INSERT [dbo].[employee] ([id], [学号], [姓名], [性别], [年龄], [部门], [职务]) VALUES (2, N'0002', N'李四', N'女', 28, N'办公室', N'副主任') 
INSERT [dbo].[employee] ([id], [学号], [姓名], [性别], [年龄], [部门], [职务]) VALUES (3, N'0003', N'王五113', N'男', 24, N'财务处', N'科员') 
INSERT [dbo].[employee] ([id], [学号], [姓名], [性别], [年龄], [部门], [职务]) VALUES (4, N'0004', N'赵六', N'女', 21, N'教务处', N'科员') 
SET IDENTITY_INSERT [dbo].[employee] OFF