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.
103 lines
3.1 KiB
Transact-SQL
103 lines
3.1 KiB
Transact-SQL
select * from sys_module where [PARENTID]='04F127A9-0D24-4C39-BDA5-7E3F002EE060'
|
|
|
|
select newid()
|
|
begin
|
|
delete from sys_module where gid='5BDF8972-EE56-4858-9FEE-4580488AD337'
|
|
INSERT INTO [sys_module]([GID],[NAME],[DESCRIPTION], [MODULEURL],
|
|
[MODULEICON],[STATE],[SORT], [PARENTID],[CREATEUSER],[CREATETIME],[SHOWROOTSTATE],[TYPE])
|
|
VALUES('5BDF8972-EE56-4858-9FEE-4580488AD337', 'modWms_StockTake', '¿â´æ×ۺϲéѯ',
|
|
'OA/Wms_StockTake', 'Module.gif',0,5, '04F127A9-0D24-4C39-BDA5-7E3F002EE060',
|
|
'1BEC90E1-9780-472F-90C2-0C6390C044A4', getdate(),0,0)
|
|
---
|
|
delete from [action] where gid='ED846422-B7C4-43D9-B028-0999E87602A5'
|
|
INSERT INTO [action]([GID],[NAME],[DESCRIPTION],[MODULEID],[CREATEUSER],[CREATETIME],[STATE],[SORT])
|
|
VALUES('ED846422-B7C4-43D9-B028-0999E87602A5','modWms_StockTake','¿â´æ×ۺϲéѯ',
|
|
'5BDF8972-EE56-4858-9FEE-4580488AD337','1BEC90E1-9780-472F-90C2-0C6390C044A4',getdate(),0,0)
|
|
end;
|
|
go
|
|
|
|
|
|
/****** Object: View [dbo].[vMsTruckUser] Script Date: 03/27/2014 15:50:05 ******/
|
|
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vMsTruckUser]'))
|
|
DROP VIEW [dbo].[vMsTruckUser]
|
|
GO
|
|
|
|
/****** Object: View [dbo].[vMsTruckUser] Script Date: 03/27/2014 15:50:06 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
CREATE VIEW [dbo].[vMsTruckUser]
|
|
AS
|
|
SELECT GID GID,CodeName as UserCode, ShowName as UserName, CodeName+'-' + ShowName as CodeAndName
|
|
FROM dbo.[user]
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_IMPORT_TableCustomize_hidden]') AND type = 'D')
|
|
BEGIN
|
|
ALTER TABLE [dbo].[IMPORT_TableCustomize] DROP CONSTRAINT [DF_IMPORT_TableCustomize_hidden]
|
|
END
|
|
|
|
GO
|
|
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_IMPORT_TableCustomize_sortable]') AND type = 'D')
|
|
BEGIN
|
|
ALTER TABLE [dbo].[IMPORT_TableCustomize] DROP CONSTRAINT [DF_IMPORT_TableCustomize_sortable]
|
|
END
|
|
|
|
GO
|
|
|
|
/****** Object: Table [dbo].[IMPORT_TableCustomize] Script Date: 04/01/2014 16:26:06 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IMPORT_TableCustomize]') AND type in (N'U'))
|
|
DROP TABLE [dbo].[IMPORT_TableCustomize]
|
|
GO
|
|
|
|
|
|
/****** Object: Table [dbo].[IMPORT_TableCustomize] Script Date: 04/01/2014 16:26:06 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
SET ANSI_PADDING ON
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[IMPORT_TableCustomize](
|
|
[id] [int] IDENTITY(1,1) NOT NULL,
|
|
[USERID] [varchar](50) NOT NULL,
|
|
[FORMNAME] [varchar](50) NOT NULL,
|
|
[DATAORDER] [int] NOT NULL,
|
|
[dataIndex] [varchar](50) NOT NULL,
|
|
[header] [varchar](50) NOT NULL,
|
|
[width] [varchar](50) NOT NULL,
|
|
[hidden] [bit] NULL,
|
|
[sortable] [bit] NULL,
|
|
CONSTRAINT [PK_IMPORT_TableCustomize] PRIMARY KEY CLUSTERED
|
|
(
|
|
[id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
SET ANSI_PADDING OFF
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[IMPORT_TableCustomize] ADD CONSTRAINT [DF_IMPORT_TableCustomize_hidden] DEFAULT ((0)) FOR [hidden]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[IMPORT_TableCustomize] ADD CONSTRAINT [DF_IMPORT_TableCustomize_sortable] DEFAULT ((1)) FOR [sortable]
|
|
GO
|
|
|
|
|