80 lines
3.6 KiB
Transact-SQL
80 lines
3.6 KiB
Transact-SQL
|
|
create table dbo.HSSE_MaterPhyQuantity
|
|
(
|
|
MaterPhyQuantityId nvarchar(50)
|
|
constraint HSSE_MaterPhyQuantity_pk
|
|
primary key,
|
|
ProjectId nvarchar(50),
|
|
MaterPhyQuantityType nvarchar(50),
|
|
UnitOfMeasurement nvarchar(50),
|
|
Total decimal,
|
|
PlanCompletedNum decimal,
|
|
ActCompletedNum decimal,
|
|
ReportDate datetime,
|
|
Remark nvarchar(50),
|
|
CreateMan nvarchar(50),
|
|
CompleteDate datetime
|
|
)
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'实物工程量表', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'主键', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'MaterPhyQuantityId'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'项目id', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'ProjectId'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'类别', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'MaterPhyQuantityType'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'计量单位', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'UnitOfMeasurement'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'总量', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'Total'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'计划完成', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'PlanCompletedNum'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'实际完成', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'ActCompletedNum'
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'报告时间', 'SCHEMA', 'dbo', 'TABLE', 'HSSE_MaterPhyQuantity', 'COLUMN',
|
|
'ReportDate'
|
|
go
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('39EF18A8-BF38-4FD9-9DA4-3548C637B807','8285E5B1-CA08-42B5-BD0D-343EE0690BB7','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E8108F38-24FF-4509-803B-54B910059A99','8285E5B1-CA08-42B5-BD0D-343EE0690BB7','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B3DB56C8-1B4B-4EBC-8FAD-C1DA17566942','8285E5B1-CA08-42B5-BD0D-343EE0690BB7','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3A7FDAAA-8CFD-43C0-B6A2-F4CE49250AB6','8285E5B1-CA08-42B5-BD0D-343EE0690BB7','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E2C9819B-37A3-4A47-9592-7CB0F1BE78F3','8285E5B1-CA08-42B5-BD0D-343EE0690BB7','提交',5)
|
|
GO
|
|
|
|
insert into Sys_Const values (newid(),1,'混凝土',1,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),2,'钢筋',2,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),3,'钢结构',3,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),4,'工艺设备',4,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),5,'电气设备',5,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),6,'仪表设备',6,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),7,'工艺管道',7,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),8,'地下管网',8,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),9,'电气电缆',9,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),10,'仪表电缆',10,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),11,'单机试车',11,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),12,'管道试压包',12,'MaterPhyQuantityType','')
|
|
insert into Sys_Const values (newid(),13,'仪表调试',13,'MaterPhyQuantityType','')
|
|
|