32 lines
2.1 KiB
Transact-SQL
32 lines
2.1 KiB
Transact-SQL
delete Sys_Menu where MenuId='EE7E37CA-384F-41B3-BAEE-89CBD9954AB3'
|
|
delete Sys_Menu where MenuId='E9EF7C6D-7F0A-4FBA-8A79-474D4E61AF27'
|
|
delete Sys_Menu where MenuId='9ACDF513-BD63-48F5-BFA3-B9B1B7FA19E1'
|
|
delete Sys_Menu where MenuId='3D554109-D95F-4051-8A6C-5616A7A95C94'
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('EE7E37CA-384F-41B3-BAEE-89CBD9954AB3','预试车进度',null,'TestRun/Report/PreRunSchedule.aspx',1,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('E9EF7C6D-7F0A-4FBA-8A79-474D4E61AF27','三查四定进度',null,'TestRun/Report/FourDecisionSchedule.aspx',2,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('9ACDF513-BD63-48F5-BFA3-B9B1B7FA19E1','试车进度',null,'TestRun/Report/TestRunSchedule.aspx',3,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('3D554109-D95F-4051-8A6C-5616A7A95C94','首页进度设置',null,'TestRun/Report/ScheduleSetUp.aspx',4,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
|
go
|
|
|
|
--==预试车/试车/三查四定参数设置
|
|
if object_id(N'Run_ScheduleSetUp',N'U') is not null
|
|
drop table dbo.Run_ScheduleSetUp
|
|
CREATE TABLE dbo.Run_ScheduleSetUp(
|
|
ScheduleId varchar(50) NOT NULL,--主键
|
|
WorkPackId varchar(50) NULL,--工作包主键
|
|
LevelName varchar(50) NULL,--三查四定类别名称
|
|
ProjectId varchar(50) NULL,--项目主键
|
|
States int null,--类型1:预试车2:试车3:三查四定
|
|
AllNum int null,--全部数量
|
|
ProgressNum int NULL,--进行中数量
|
|
CompleteNum int NULL,--完成数量
|
|
CompleteRate decimal(18,2) NULL,--完成率
|
|
AddUser varchar(50) NULL,--添加人
|
|
AddTime datetime NULL,--添加日期
|
|
Sort int NULL,--排序
|
|
CONSTRAINT PK_Run_ScheduleSetUp PRIMARY KEY CLUSTERED
|
|
(
|
|
ScheduleId 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 |