outstate.sql

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

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-002', 1, '待审', '取消', 2, 99, '待审', '取消', NULL, 1, NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-002', 2, '知道', '没时间', 99, 99, '知道', '没时间', NULL, 1, NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-002', 99, '完成', '未完', 0, 0, '完成', '未完', NULL, 1, NULL)
GO

--
-- 7 record(s) inserted to [dbo].[File_db_Condition_Body]
--



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

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-001', 1, '自己', '自己', NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-001', 2, 'XZ1', 'XZGL1', NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-001', 2, 'XZ2', 'XZGL2', NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-001', 3, '全部', 'XZGL3', 'XZGL4')
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-001', 99, '自己', '自己', NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-002', 1, '1', '1', NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-002', 2, '自己', '相关人员', NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Relation] ([ISO_Docnum], [Item], [FromUserID], [ToUserID], [StoreUserID])
VALUES 
  ('ISO-002', 99, '自己', '全部', NULL)
GO

--
-- 8 record(s) inserted to [dbo].[File_db_Condition_Relation]
--



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

--
-- 0 record(s) inserted to [dbo].[File_db_Doc_OtherFile]
--



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

INSERT INTO [dbo].[File_db_Doc_QingJia] ([ISO_Docnum], [DocnumNo], [Doc_Title], [Doc_ReMark], [CreateUser], [CreateDate])
VALUES 
  ('ISO-001', '200706000001', '布什请假', '2007-01-05请假', 'XZ1', '20070201 16:37:00')
GO

--
-- 1 record(s) inserted to [dbo].[File_db_Doc_QingJia]
--



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

INSERT INTO [dbo].[File_db_Docnum_Type] ([ISO_Docnum], [DocTitle], [CustomTable], [IsWork], [ReMark])
VALUES 
  ('ISO-001', '请假单', 1, 1, '请假单需部门主管审批')
GO

INSERT INTO [dbo].[File_db_Docnum_Type] ([ISO_Docnum], [DocTitle], [CustomTable], [IsWork], [ReMark])
VALUES 
  ('ISO-002', '会议通知', 0, 1, '要召开会议请添此单')
GO

--
-- 2 record(s) inserted to [dbo].[File_db_Docnum_Type]
--



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

--
-- 0 record(s) inserted to [dbo].[File_db_Relation]
--



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

INSERT INTO [dbo].[File_db_WorkFlow_All] ([ISO_Docnum], [DocnumNo], [Item], [ToUserID], [FromUserID], [MyResult], [StateOK], [StateNo], [OkGoTo], [NoGoTo], [OkMan], [IsWork], [MyReason], [CreateDate])
VALUES 
  ('ISO-001', '200706000001', 1, 'XZ1', 'XZ1', '登记', '登记', '取消', 2, 0, 1, 0, '', '20070203 09:35:00')
GO

INSERT INTO [dbo].[File_db_WorkFlow_All] ([ISO_Docnum], [DocnumNo], [Item], [ToUserID], [FromUserID], [MyResult], [StateOK], [StateNo], [OkGoTo], [NoGoTo], [OkMan], [IsWork], [MyReason], [CreateDate])
VALUES 
  ('ISO-001', '200706000001', 2, 'XZGL1', 'XZ1', '', '批准', '不批准', 3, 99, 1, 1, '', '20070203 09:35:00')
GO

INSERT INTO [dbo].[File_db_WorkFlow_All] ([ISO_Docnum], [DocnumNo], [Item], [ToUserID], [FromUserID], [MyResult], [StateOK], [StateNo], [OkGoTo], [NoGoTo], [OkMan], [IsWork], [MyReason], [CreateDate])
VALUES 
  ('ISO-001', '200706000001', 3, 'XZGL3', '全部', '', '接受', '不接受', 99, 99, 1, 0, '', '20070203 09:35:00')
GO

INSERT INTO [dbo].[File_db_WorkFlow_All] ([ISO_Docnum], [DocnumNo], [Item], [ToUserID], [FromUserID], [MyResult], [StateOK], [StateNo], [OkGoTo], [NoGoTo], [OkMan], [IsWork], [MyReason], [CreateDate])
VALUES 
  ('ISO-001', '200706000001', 99, 'XZ1', 'XZ1', '', '完成', '未完', 0, 0, 1, 0, '', '20070203 09:35:00')
GO

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



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

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (1, '101岗出', 0)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (2, '101岗入', 1)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (3, '103岗出', 0)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (4, '103岗入', 1)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (5, '繁星出', 0)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (6, '繁星入', 1)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (7, '沙井出', 0)
GO

INSERT INTO [dbo].[Out_db_Clock] ([ClockID], [ClockAddr], [DoorState])
VALUES 
  (8, '沙井入', 1)
GO

--
-- 8 record(s) inserted to [dbo].[Out_db_Clock]
--



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

SET IDENTITY_INSERT [dbo].[Out_db_Company] ON
GO

INSERT INTO [dbo].[Out_db_Company] ([CompanyNum], [CompanyCode], [CompanyName])
VALUES 
  (1, 'GME', '长安誉铭')
GO

INSERT INTO [dbo].[Out_db_Company] ([CompanyNum], [CompanyCode], [CompanyName])
VALUES 
  (2, 'GM', '沙井誉铭')
GO

INSERT INTO [dbo].[Out_db_Company] ([CompanyNum], [CompanyCode], [CompanyName])
VALUES 
  (3, 'MS', '繁星')
GO

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



SET IDENTITY_INSERT [dbo].[Out_db_Company] OFF
GO

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

SET IDENTITY_INSERT [dbo].[Out_db_CompanyTelephone] ON
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (1, 'GM', '董事办', 'as2', '1245212', '52452152477')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (2, 'MS', 'IT课', '981', '441', '4478521')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (3, 'GM', 'IT课', '2', '2', '2')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (4, 'GME', '行政课', '2', '1', '1')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (5, 'GME', '行政课', '77', '77', '77')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (6, 'GME', '行政课', '88', '88', '88')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (10, 'GME', '行政课', '7', '78', '78')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (21, 'GME', '行政课', '8', '8', '8')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (22, 'GME', '行政课', '3', '3', '3')
GO

INSERT INTO [dbo].[Out_db_CompanyTelephone] ([SEQ], [CompanyCode], [DeptName], [PSNName], [CompanyTel], [PSNTel])
VALUES 
  (27, 'GME', '行政课', '1234', '1234', '1234')
GO

--
-- 10 record(s) inserted to [dbo].[Out_db_CompanyTelephone]
--



SET IDENTITY_INSERT [dbo].[Out_db_CompanyTelephone] OFF
GO

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

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 1, 101, 202, '654321', '请假', '111', '20070122 12:06:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 1, 444, 404, '654321', '请假', '44', '20070122 15:22:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 1, 707, 909, '654321', '请假', '', '20070122 10:56:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 1, 909, 1010, '654321', '请假', 'asasas', '20070122 15:10:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 101, 1508, '555555', '请假', '', '20070122 11:12:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 202, 404, '555555', '休假', '', '20070122 15:12:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 505, 508, '555555', '请假', '4', '20070122 12:15:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 707, 708, '555555', '请假', '8', '20070122 11:20:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 807, 707, '555555', '请假', '45', '20070122 15:20:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 808, 909, '555555', '请假', '', '20070122 12:05:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 1010, 1515, '555555', '请假', '', '20070122 11:33:00', '', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070122', 2, 1101, 101, '555555', '请假', '2', '20070122 15:32:00', 'as', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070123', 2, 700, 701, '555555', '请假', '', '20070123 18:13:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070123', 2, 1000, 2000, '555555', '请假', '', '20070123 18:13:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070123', 2, 1530, 1300, '555555', '请假', '', '20070123 16:48:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070124', 2, 900, 1300, '555555', '出差', '', '20070123 16:47:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070323', 1, 1300, 1500, '654321', '请假', '', '20070323 13:51:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070510', 1, 900, 1200, '654321', '请假', '123', '20070510 15:06:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GM', '20070510', 2, 1300, 1700, '555555', '请假', 'www', '20070510 15:08:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070121', 1, 709, 707, '123456', '请假', '5', '20070122 15:11:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070122', 1, 101, 909, '123456', '请假', '12', '20070122 15:10:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070122', 1, 404, 808, '123456', '请假', '', '20070122 12:47:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070122', 1, 407, 1523, '123456', '请假', '78', '20070122 12:47:00', '系统管理员', 1)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070122', 1, 445, 445, '123456', '出差', '', '20070122 15:20:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070122', 1, 808, 808, '123456', '请假', '8', '20070122 12:48:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070122', 1, 856, 808, '123456', '请假', '4', '20070122 15:23:00', '系统管理员', 0)
GO

INSERT INTO [dbo].[Out_db_Day_Input] ([CompanyCode], [AbnDate], [gno], [T1], [T2], [CardNo], [StateName], [Remark], [CreateDate], [CreateUser], [IsDel])
VALUES 
  ('GME', '20070124', 1, 1300, 1301, '123456', '请假', '', '20070124 08:19:00', '系统管理员', 0)
GO

--
-- 27 record(s) inserted to [dbo].[Out_db_Day_Input]
--