You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
61 lines
2.1 KiB
Transact-SQL
61 lines
2.1 KiB
Transact-SQL
begin
|
|
delete from sys_module where gid='AF472CBA-81C5-40EB-9231-1AD700FB2DB3'
|
|
INSERT INTO [sys_module]([GID],[NAME],[DESCRIPTION], [MODULEURL],
|
|
[MODULEICON],[STATE],[SORT], [PARENTID],[CREATEUSER],[CREATETIME],[SHOWROOTSTATE],[TYPE])
|
|
VALUES('AF472CBA-81C5-40EB-9231-1AD700FB2DB3', 'modOA', '办公审批',
|
|
'#', 'Module.gif',0,0, '0',
|
|
'1BEC90E1-9780-472F-90C2-0C6390C044A4', getdate(),0,0)
|
|
---
|
|
delete from [action] where gid='9C77A86B-D1F7-4FCF-8163-96A351C664DB'
|
|
INSERT INTO [action]([GID],[NAME],[DESCRIPTION],[MODULEID],[CREATEUSER],[CREATETIME],[STATE],[SORT])
|
|
VALUES('9C77A86B-D1F7-4FCF-8163-96A351C664DB','modOA','进口贸易',
|
|
'AF472CBA-81C5-40EB-9231-1AD700FB2DB3','1BEC90E1-9780-472F-90C2-0C6390C044A4',getdate(),0,0)
|
|
end;
|
|
go
|
|
|
|
begin
|
|
delete from sys_module where gid='1696928C-A852-4D50-AE4C-CE99C96A9FEE'
|
|
INSERT INTO [sys_module]([GID],[NAME],[DESCRIPTION], [MODULEURL],
|
|
[MODULEICON],[STATE],[SORT], [PARENTID],[CREATEUSER],[CREATETIME],[SHOWROOTSTATE],[TYPE])
|
|
VALUES('1696928C-A852-4D50-AE4C-CE99C96A9FEE', 'mod_Baoxiao', '报销单管理',
|
|
'OA/Baoxiao', 'Module.gif',0,2, 'AF472CBA-81C5-40EB-9231-1AD700FB2DB3',
|
|
'1BEC90E1-9780-472F-90C2-0C6390C044A4', getdate(),0,2)
|
|
---
|
|
delete from [action] where gid='679EEC76-5F1D-4698-ACED-490839922026'
|
|
INSERT INTO [action]([GID],[NAME],[DESCRIPTION],[MODULEID],[CREATEUSER],[CREATETIME],[STATE],[SORT])
|
|
VALUES('679EEC76-5F1D-4698-ACED-490839922026','mod_Baoxiao','报销单管理',
|
|
'1696928C-A852-4D50-AE4C-CE99C96A9FEE','1BEC90E1-9780-472F-90C2-0C6390C044A4',getdate(),0,0)
|
|
end;
|
|
go
|
|
|
|
insert tSysbilltype
|
|
(BillCode,BillName,BillGrp,IsRule,NoLength,IsPrefix,PrefixLen,PrefixNo,[IsDate],DateFmt,SerialLen,
|
|
YearNo,MonthNo,DayNo,MaxSerial,BillHeadTbl,IsOrgPrefix)
|
|
values( '0401' , '报销单号' , '办公审批' , '1' ,
|
|
6 , '1' , 2 , 'BX' , '1' ,
|
|
'YYYYMMDD' , 4 , '2013' , '01' ,
|
|
'01' , 57 , 'OA_Baoxiao' , '0' )
|
|
|
|
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[tSys_OA_Baoxiao](
|
|
[SerialNo] [numeric](27, 0) IDENTITY(1,1) NOT NULL,
|
|
[Data_Null] [varchar](1) NULL
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
SET ANSI_PADDING OFF
|
|
GO
|
|
|
|
|
|
select * from tSysbilltype
|