⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 outstate.sql

📁 一套三层结构的文件管理OA系统源码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 

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

INSERT INTO [dbo].[Out_db_Day_Read] ([ClockData], [CompanyCode], [Gno], [ClockID], [AbnDate], [AbnTime], [CreateDate])
VALUES 
  ('1', 'GM', 1, 1, '20070115', 800, '20070116 12:13:00')
GO

INSERT INTO [dbo].[Out_db_Day_Read] ([ClockData], [CompanyCode], [Gno], [ClockID], [AbnDate], [AbnTime], [CreateDate])
VALUES 
  ('2', 'GM', 1, 2, '20070115', 900, '20070116 12:13:00')
GO

INSERT INTO [dbo].[Out_db_Day_Read] ([ClockData], [CompanyCode], [Gno], [ClockID], [AbnDate], [AbnTime], [CreateDate])
VALUES 
  ('3', 'GME', 1, 3, '20070115', 1301, '20070116 12:14:00')
GO

INSERT INTO [dbo].[Out_db_Day_Read] ([ClockData], [CompanyCode], [Gno], [ClockID], [AbnDate], [AbnTime], [CreateDate])
VALUES 
  ('4', 'GME', 1, 4, '20070115', 1423, '20070116 12:14:00')
GO

INSERT INTO [dbo].[Out_db_Day_Read] ([ClockData], [CompanyCode], [Gno], [ClockID], [AbnDate], [AbnTime], [CreateDate])
VALUES 
  ('5', 'GME', 1, 4, '20070115', 900, '20070116 12:15:00')
GO

INSERT INTO [dbo].[Out_db_Day_Read] ([ClockData], [CompanyCode], [Gno], [ClockID], [AbnDate], [AbnTime], [CreateDate])
VALUES 
  ('7', 'GM', 1, 3, '20070115', 1500, '20070116 14:59:00')
GO

--
-- 6 record(s) inserted to [dbo].[Out_db_Day_Read]
--



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

SET IDENTITY_INSERT [dbo].[Out_db_Dept] ON
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (1, '行政课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (2, 'IT课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (3, '注塑课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (4, '技术课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (5, '丝喷课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (6, '计划课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (7, '仓务课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (8, '品质课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (9, '财务课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (10, '报关课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (11, '采购课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (12, '营业课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (13, '文控课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (14, '模具课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (15, '制造课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (16, '营业（欧美）')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (17, '总经办')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (18, 'ISO')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (19, '管理课')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (20, '捷塑')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (21, '董事办')
GO

INSERT INTO [dbo].[Out_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (22, '管理委员会')
GO

--
-- 22 record(s) inserted to [dbo].[Out_db_Dept]
--



SET IDENTITY_INSERT [dbo].[Out_db_Dept] OFF
GO

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

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('10', 'Telephone', '电话管理')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1010', 'TelUpdate', '电话更改')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1020', 'TelAdd', '电话新增')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1030', 'TelDel', '电话删除')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('20', 'OutInput', '外出登记')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2010', 'OutInputAdd', '外出录入')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2020', 'OutInputDel', '外出删除')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2030', 'OutInputUpdate', '外出更改')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('30', 'Company', '公司管理')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('3010', 'CompanyUpdate', '公司修改')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('40', 'Depart', '部门管理')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('4010', 'DeptUpdate', '部门修改')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('50', 'User', '用户管理')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('5020', 'UserUpdate', '用户修改')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('90', '90', '管理公司')
GO

INSERT INTO [dbo].[Out_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('91', '91', '管理部门')
GO

--
-- 16 record(s) inserted to [dbo].[Out_db_Menu]
--



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

INSERT INTO [dbo].[Out_db_Personal] ([CompanyCode], [gno], [PsnName], [PsnDept], [PsnPosi], [PsnSex], [CardNo])
VALUES 
  ('GM', 1, '萨达姆', '伊拉克', '总统', '男', '654321')
GO

INSERT INTO [dbo].[Out_db_Personal] ([CompanyCode], [gno], [PsnName], [PsnDept], [PsnPosi], [PsnSex], [CardNo])
VALUES 
  ('GM', 2, '本拉登', '基地组织', '领导人', '男', '555555')
GO

INSERT INTO [dbo].[Out_db_Personal] ([CompanyCode], [gno], [PsnName], [PsnDept], [PsnPosi], [PsnSex], [CardNo])
VALUES 
  ('GME', 1, '布什', '美国', '总统', '女', '123456')
GO

--
-- 3 record(s) inserted to [dbo].[Out_db_Personal]
--



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

INSERT INTO [dbo].[Out_db_State] ([StateCode], [StateName])
VALUES 
  (1, '请假')
GO

INSERT INTO [dbo].[Out_db_State] ([StateCode], [StateName])
VALUES 
  (2, '出差')
GO

INSERT INTO [dbo].[Out_db_State] ([StateCode], [StateName])
VALUES 
  (3, '休假')
GO

--
-- 3 record(s) inserted to [dbo].[Out_db_State]
--



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

INSERT INTO [dbo].[Out_db_User] ([UserID], [UserName], [Psw], [UserType])
VALUES 
  ('24', '24', '24', '操作员')
GO

INSERT INTO [dbo].[Out_db_User] ([UserID], [UserName], [Psw], [UserType])
VALUES 
  ('as', 'as', 'as', '操作员')
GO

INSERT INTO [dbo].[Out_db_User] ([UserID], [UserName], [Psw], [UserType])
VALUES 
  ('System', '系统管理员', '8246', '管理员')
GO

INSERT INTO [dbo].[Out_db_User] ([UserID], [UserName], [Psw], [UserType])
VALUES 
  ('Test1', '测试员1', 'test1', '操作员')
GO

--
-- 4 record(s) inserted to [dbo].[Out_db_User]
--



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

INSERT INTO [dbo].[Out_db_UserGrant_Company] ([UserID], [Company])
VALUES 
  ('as', '长安誉铭')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Company] ([UserID], [Company])
VALUES 
  ('as', '沙井誉铭')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Company] ([UserID], [Company])
VALUES 
  ('System', '长安誉铭')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Company] ([UserID], [Company])
VALUES 
  ('System', '繁星')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Company] ([UserID], [Company])
VALUES 
  ('System', '沙井誉铭')
GO

INSERT INTO [dbo].[Out_db_UserGrant_Company] ([UserID], [Company])
VALUES 
  ('Test1', '长安誉铭')
GO

--
-- 6 record(s) inserted to [dbo].[Out_db_UserGrant_Company]
--



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

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

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

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

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

INSERT INTO [dbo].[Out_db_UserGrant_Dept] ([UserID], [DeptName])
VALUES 
  ('System', 'IT课')
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])
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -