outstate.sql

一套三层结构的文件管理OA系统源码

VALUES 
  ('System', '技术课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '捷塑')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '模具课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '品质课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '丝喷课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '文控课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '行政课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '营业（欧美）')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '营业课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '制造课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '注塑课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', '总经办')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('Test1', 'IT课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('Test1', '技术课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('Test1', '行政课')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('Test1', '注塑课')
GO

--
-- 29 record(s) inserted to [dbo].[Out_db_UserGrant_Dept]
--



--
-- Data for table Out_db_UserGrant_Menu  (LIMIT 0,500)
--

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('24', 'OutInput')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('24', 'Telephone')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'Company')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'CompanyUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'Depart')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'DeptUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'OutInput')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'TelAdd')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'TelDel')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'Telephone')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'TelUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'User')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('as', 'UserUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'Company')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'CompanyUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'Depart')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'DeptAdd')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'DeptDel')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'DeptUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'OutInput')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'OutInputAdd')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'OutInputDel')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'OutInputUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'TelAdd')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'TelDel')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'Telephone')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'TelUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'User')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'UserAdd')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'UserDel')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('System', 'UserUpdate')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('Test1', 'TelAdd')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('Test1', 'TelDel')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('Test1', 'Telephone')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('Test1', 'TelUpdate')
GO

--
-- 35 record(s) inserted to [dbo].[Out_db_UserGrant_Menu]
--



--
-- Data for table Pic_db_Folder  (LIMIT 0,500)
--

SET IDENTITY_INSERT [dbo].[Pic_db_Folder] ON
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('Kent', '\桌面\我的文档\', 'tttt.jpg', 'Picture', 'Remark', 21, '箭牌', '20070126 09:50:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '', '', '', '', 22, '系统管理员', '20070403 13:20:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', '999', 'Folder', '', 39, '系统管理员', '20070404 16:42:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', 'ad21', 'Folder', '', 47, '系统管理员', '20070404 17:09:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\', 'ADFDG', 'Folder', '', 40, '系统管理员', '20070404 16:43:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', 'dss', 'Folder', '', 44, '系统管理员', '20070404 16:52:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\', 'EPIEUT', 'Folder', '', 43, '系统管理员', '20070404 16:47:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', 'FAA', 'Folder', '', 37, '系统管理员', '20070404 16:32:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\', 'gjyur', 'PICTURE', '', 55, '系统管理员', '20070418 14:41:00', '系统管理员', '20070515 14:20:00')
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\', 'R5E', 'Folder', '', 42, '系统管理员', '20070404 16:45:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', 'TE5895', 'Folder', '', 46, '系统管理员', '20070404 17:05:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\', 'TEST111', 'Folder', '', 57, '系统管理员', '20070514 11:13:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', 'Unit2.~pas', 'OTHER', '', 62, '系统管理员', '20070515 14:19:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\', '共享文件', 'Folder', NULL, 1, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\', '我的文档', 'Folder', NULL, 2, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\231d', 'Changelog.txt', 'OTHER', '', 53, '系统管理员', '20070405 10:47:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\231d', 'tese', 'Folder', '', 49, '系统管理员', '20070404 17:12:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\231d', 'tew', 'Folder', '', 51, '系统管理员', '20070404 17:17:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\999', 'INSTALL.LOG', 'OTHER', '', 59, '系统管理员', '20070515 09:49:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\999', 'Unit2.ddp', 'OTHER', '', 61, '系统管理员', '20070515 10:13:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\ABC', 'aaa', 'Folder', '', 50, '系统管理员', '20070404 17:15:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\ad21', 'delins.txt', 'OTHER', '', 60, '系统管理员', '20070515 10:10:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\共享文件', 'test', 'Folder', '', 38, '系统管理员', '20070404 16:39:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('system', '\桌面\我的文档', 'adef', 'Folder', '', 41, '系统管理员', '20070404 16:44:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\我的文档', 'File.jpg', 'PICTURE', '', 52, '系统管理员', '20070405 09:22:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('SYSTEM', '\桌面\我的文档', 'notice.txt', 'OTHER', '', 54, '系统管理员', '20070405 10:57:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'DBA.cab', 'Other', 'Remark', 18, '系统管理员', '20070126 08:49:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'DBA11.cab', 'Other', 'Remark', 19, '系统管理员', '20070126 08:53:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'DBA22.cab', 'Other', 'Remark', 20, '系统管理员', '20070126 09:36:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'File123.jpg', 'Picture', 'Remark123', 10, '系统管理员', '20070124 19:29:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'File2.jpg', 'Picture', 'Remark', 8, '系统管理员', '20070124 16:22:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'File4.jpg', 'Picture', 'Remark44', 15, '系统管理员', '20070125 08:27:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'File456.jpg', 'Picture', 'Remark123', 11, '系统管理员', '20070124 19:31:00', NULL, NULL)
GO

INSERT INTO [dbo].[Pic_db_Folder] ([UserID], [ParentDir], [FileName], [FileType], [ReMark], [FileID], [CreateUser], [CreateDate], [UpdateUser], [UpdateDate])
VALUES 
  ('System', '\桌面\我的文档\', 'File777.jpg', 'Picture', 'Remark777', 12, '系统管理员', '20070124 19:34:00', NULL, N