254 lines
15 KiB
Transact-SQL
254 lines
15 KiB
Transact-SQL
alter table [dbo].[Person_TestRunMonthSummary] add Major nvarchar(50) null
|
||
GO
|
||
|
||
|
||
ALTER PROCEDURE [dbo].[Sp_GJSX_getlist]
|
||
-- Add the parameters for the stored procedure here
|
||
@ProjectId nvarchar(max),
|
||
@sql_where varchar(max)
|
||
AS
|
||
BEGIN
|
||
--IF EXISTS(select * from tempdb..sysobjects where id=object_id('tempdb..#GJSX_List'))
|
||
--BEGIN
|
||
-- DROP TABLE #GJSX_List
|
||
--END
|
||
--DECLARE @Sql NVARCHAR(200)
|
||
--select * into #GJSX_List from(
|
||
-- select
|
||
--a.GJSXID
|
||
--,a.ProjectId
|
||
--,a.detail
|
||
--,b.username
|
||
--,a.createDate
|
||
--,User_ReceiveID=STUFF(( SELECT ',' + p2.UserName FROM dbo.Sys_User as p2 where PATINDEX('%,' + RTRIM(p2.UserId) + ',%',',' +a.User_ReceiveID + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
--, CNProfessionalId=STUFF(( SELECT ',' + Base_CNProfessional.ProfessionalName FROM dbo.Base_CNProfessional where PATINDEX('%,' + RTRIM(Base_CNProfessional.CNProfessionalId) + ',%',',' +a.CNProfessional_ID + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
--,Base_Project.ProjectName
|
||
--,Base_Unit.unitname
|
||
--,a.CloseDate
|
||
--,case a.state when 2 then 'ÕýÔÚ½øÐÐ' when 0 then '¹Ø±Õ' when 1 then '¿ª·Å' end as state
|
||
--,QuestionTypeName=STUFF(( SELECT ',' + Base_QuestionType.QuestionTypeName FROM dbo.Base_QuestionType where PATINDEX('%,' + RTRIM(Base_QuestionType.QuestionTypeID) + ',%',',' +a.QuestionTypeID + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
--,a.IsManypeople
|
||
--,a.CompleteDate
|
||
--,a.AttachUrl
|
||
--,user_Acceptance =STUFF(( SELECT ',' + p2.UserName FROM dbo.Sys_User as p2 where PATINDEX('%,' + RTRIM(p2.UserId) + ',%',',' +a.user_Acceptance + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
--from GJSX as a left join Sys_User as b on a.UserId=b.UserId
|
||
--left join [dbo].[Base_Project] on a.ProjectId =Base_Project.ProjectId
|
||
--left join [dbo].[Base_Unit] on a.UnitId=Base_Unit.UnitId
|
||
--left join [dbo].[Base_QuestionType] on a.QuestionTypeID=Base_QuestionType.QuestionTypeID ) as a
|
||
|
||
--set @Sql ='select * from #GJSX_List where ProjectId='''+@ProjectId+''' ' +@sql_where
|
||
|
||
--exec(@Sql)
|
||
|
||
select
|
||
a.GJSXID
|
||
,a.ProjectId
|
||
,a.detail
|
||
,b.username
|
||
,a.createDate
|
||
,User_ReceiveID=STUFF(( SELECT ',' + p2.UserName FROM dbo.Sys_User as p2 where PATINDEX('%,' + RTRIM(p2.UserId) + ',%',',' +a.User_ReceiveID + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
, CNProfessionalId=STUFF(( SELECT ',' + Base_CNProfessional.ProfessionalName FROM dbo.Base_CNProfessional where PATINDEX('%,' + RTRIM(Base_CNProfessional.CNProfessionalId) + ',%',',' +a.CNProfessional_ID + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
,Base_Project.ProjectName
|
||
,Base_Unit.unitname
|
||
,a.CloseDate
|
||
,case a.state when 2 then 'ÕýÔÚ½øÐÐ' when 0 then '¹Ø±Õ' when 1 then '¿ª·Å' end as state
|
||
,QuestionTypeName=STUFF(( SELECT ',' + Base_QuestionType.QuestionTypeName FROM dbo.Base_QuestionType where PATINDEX('%,' + RTRIM(Base_QuestionType.QuestionTypeID) + ',%',',' +a.QuestionTypeID + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
,a.IsManypeople
|
||
,a.CompleteDate
|
||
,a.AttachUrl
|
||
,user_Acceptance =STUFF(( SELECT ',' + p2.UserName FROM dbo.Sys_User as p2 where PATINDEX('%,' + RTRIM(p2.UserId) + ',%',',' +a.user_Acceptance + ',') >0 FOR XML PATH('')), 1, 1,'')
|
||
from GJSX as a left join Sys_User as b on a.UserId=b.UserId
|
||
left join [dbo].[Base_Project] on a.ProjectId =Base_Project.ProjectId
|
||
left join [dbo].[Base_Unit] on a.UnitId=Base_Unit.UnitId
|
||
left join [dbo].[Base_QuestionType] on a.QuestionTypeID=Base_QuestionType.QuestionTypeID
|
||
where a.ProjectId=@ProjectId
|
||
END
|
||
|
||
|
||
|
||
GO
|
||
|
||
|
||
--cd C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools
|
||
--SqlMetal /views /server:wq /database:SGGLDB_WH /code:C:\Model.cs /namespace:Model
|
||
|
||
delete Sys_Menu where MenuId='AC5BC922-FA5E-4141-8458-7DE89434A8E7'
|
||
delete Sys_Menu where MenuId='BEAE1E66-5783-489B-A268-F46491AE1257'
|
||
delete Sys_Menu where MenuId='D8DF6DDB-3CDD-41C0-B374-1AAE40802B68'
|
||
delete Sys_Menu where MenuId='C2E827C4-6E04-4EB6-8E51-B43FCBD3753F'
|
||
delete Sys_Menu where MenuId='AF4EEC31-73E9-4F36-BEA7-2A92468F324E'
|
||
delete Sys_Menu where MenuId='7400F47B-3F45-4142-B21F-3BECCABBB202'
|
||
delete Sys_Menu where MenuId='F2D170C3-6CA5-439D-8CC7-81E4FB906B1F'
|
||
delete Sys_Menu where MenuId='A7BBF5F1-F145-43D1-9227-7EC24099BBEC'
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AC5BC922-FA5E-4141-8458-7DE89434A8E7','¼ì²é±íÄ£°å',null,'TestRun/Produce/InspectTemplate.aspx',2,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('BEAE1E66-5783-489B-A268-F46491AE1257','ͶÁÏÊÔ³µ¹ÜÀí',null,'TestRun/Produce/SubInspectTerm.aspx',3,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('D8DF6DDB-3CDD-41C0-B374-1AAE40802B68','ͶÁÏÊÔ³µÈ·ÈÏ',null,'TestRun/Produce/SubWorkInspect.aspx',4,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('C2E827C4-6E04-4EB6-8E51-B43FCBD3753F','¼ì²é±íβÏî¹ÜÀí',null,'TestRun/Produce/InspectTailTermList.aspx',5,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AF4EEC31-73E9-4F36-BEA7-2A92468F324E','βÏî´¦Àí',null,'TestRun/Produce/TailTermHandleList.aspx',6,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('7400F47B-3F45-4142-B21F-3BECCABBB202','βÏîÉóºË',null,'TestRun/Produce/TailTermApproveList.aspx',7,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('F2D170C3-6CA5-439D-8CC7-81E4FB906B1F','¼ì²é±í»áÇ©',null,'TestRun/Produce/InspectWanderAboutList.aspx',8,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('A7BBF5F1-F145-43D1-9227-7EC24099BBEC','¼ì²é±íÁ÷תȫ²¿Í¨¹ý',null,'TestRun/Produce/InspectWanderAboutAllPassList.aspx',9,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
||
go
|
||
|
||
--==Éú²úÐÔÄÜ¿¼ºËÌõ¼þ¼ì²éÄ£°åÐÅÏ¢±í
|
||
if object_id(N'ProduceRun_WorkInspectTemplate',N'U') is not null
|
||
drop table dbo.ProduceRun_WorkInspectTemplate
|
||
CREATE TABLE dbo.ProduceRun_WorkInspectTemplate(
|
||
WorkInspectId varchar(50) NOT NULL,--Ö÷¼ü
|
||
WorkInspectName varchar(500) NULL,--¼ì²éÊÂÏîÃû³Æ
|
||
Remark nvarchar(150) NULL,--±¸×¢
|
||
AddUser varchar(50) NULL,--Ìí¼ÓÈË
|
||
AddTime datetime NULL,--Ìí¼ÓÈÕÆÚ
|
||
Sort int NULL,--ÅÅÐò
|
||
CONSTRAINT PK_ProduceRun_WorkInspectTemplate PRIMARY KEY CLUSTERED
|
||
(
|
||
WorkInspectId 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
|
||
|
||
--==Éú²úÐÔÄÜ¿¼ºËÌõ¼þ¼ì²é±í
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='A95825BD-709E-46DB-AEFD-1E7C9C1BF524'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='55CB964B-A82A-4BBC-BC2D-040E31C7CC36'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='EE35FF88-6E30-4797-AE46-0623B9BD3E81'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='C679A7B8-4244-42E5-96C8-B5A941FF5130'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='30470FF1-0BA2-4DE0-8CDB-DF812C0AC4B8'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='E369582C-25FB-49EF-B3ED-4A7EDF8CA61C'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='2255D8C6-B12D-4035-B56A-11A5815B7C4F'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='015D647D-ECB4-4252-BA9E-C60190D63F0A'
|
||
delete ProduceRun_WorkInspectTemplate where WorkInspectId='6CDFE6DD-E113-4A07-B5F4-083343672A9E'
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('A95825BD-709E-46DB-AEFD-1E7C9C1BF524','Ôڹ涨µÄ¸ººÉÌõ¼þϱ©Â¶³öµÄÎÊÌâÒѾ½â¾ö£¬¸÷ÏÒÕÖ¸±êÒÑ´¦ÓÚÎȶ¨×´Ì¬¡£','','',GETDATE(),1)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('55CB964B-A82A-4BBC-BC2D-040E31C7CC36','È«³§Ïà¹Ø×°Öô¦ÓÚÎȶ¨ÔËÐÐ״̬¡£','','',GETDATE(),2)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('EE35FF88-6E30-4797-AE46-0623B9BD3E81','Éú²ú¿¼ºË·½°¸ÒÑÖƶ¨£¬²¢¾ÉóºËÅú×¼¡£','','',GETDATE(),3)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('C679A7B8-4244-42E5-96C8-B5A941FF5130','²âÊÔרÓù¤¾ßºÍÒDZíÆ뱸£¬µ÷УºÏ¸ñ£¬´¦ÓÚÓÐЧÆÚÄÚ¡£','','',GETDATE(),4)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('30470FF1-0BA2-4DE0-8CDB-DF812C0AC4B8','²âÊÔÈËÔ±µÄ×éÖ¯¡¢ÈÎÎñÒÑÃ÷È·¡¢Âäʵ¡£','','',GETDATE(),5)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('E369582C-25FB-49EF-B3ED-4A7EDF8CA61C','²âÊÔÏîÄ¿¡¢·ÖÎöÏîÄ¿¡¢·ÖÎö·½·¨ÒÑÈ·¶¨¡£','','',GETDATE(),6)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('2255D8C6-B12D-4035-B56A-11A5815B7C4F','ÔÁÏ¡¢È¼ÁÏ¡¢»¯Ñ§Ò©Æ·µÈÎïÖÊÊýÁ¿¡¢¹æ¸ñ¡¢ÖÊÁ¿·ûºÏÉè¼ÆÎļþµÄÒªÇó¡£','','',GETDATE(),7)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('015D647D-ECB4-4252-BA9E-C60190D63F0A','Ë®¡¢µç¡¢Æø£¨Æû£©¡¢ÔÁÏ¡¢È¼ÁÏ¡¢»¯Ñ§Ò©Æ·µÈÈ·±£Á¬ÐøÎȶ¨¹©Ó¦¡£','','',GETDATE(),8)
|
||
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('6CDFE6DD-E113-4A07-B5F4-083343672A9E','×Ô¿ØÒÇ±í¡¢±¨¾¯ºÍÁªËø×°ÖÃÒÑͶÈëÎȶ¨ÔËÐС£','','',GETDATE(),9)
|
||
go
|
||
|
||
--==¹¤×÷°ü¼ì²é±í
|
||
if object_id(N'ProduceRun_SubInspectTerm',N'U') is not null
|
||
drop table dbo.ProduceRun_SubInspectTerm
|
||
CREATE TABLE dbo.ProduceRun_SubInspectTerm(
|
||
SubInspectId varchar(50) NOT NULL,--Ö÷¼ü
|
||
ProjectId varchar(50) NULL,--ÏîÄ¿Ö÷¼ü
|
||
Contractor varchar(50) null,--³Ð°üÉÌ
|
||
Owner varchar(50) null,--ÒµÖ÷
|
||
ProcessPatent varchar(50) null,--¹¤ÒÕרÀûÉÌ
|
||
ContractorIsAllPass int NULL,--³Ð°üÉÌÊÇ·ñͨ¹ý0/null:δͨ¹ý 1:ͨ¹ý
|
||
OwnerIsAllPass int NULL,--ÒµÖ÷ÊÇ·ñͨ¹ý0/null:δͨ¹ý 1:ͨ¹ý
|
||
ProcessPatentIsAllPass int NULL,--¹¤ÒÕרÀûÉÌÊÇ·ñͨ¹ý0/null:δͨ¹ý 1:ͨ¹ý
|
||
ContractorAllPassData datetime null,--³Ð°üÉÌͨ¹ýÈÕÆÚ
|
||
OwnerAllPassData datetime null,--ÒµÖ÷ͨ¹ýÈÕÆÚ
|
||
ProcessPatentAllPassData datetime null,--¹¤ÒÕרÀûÉÌͨ¹ýÈÕÆÚ
|
||
InspectionIsAllPass int NULL,--¼ì²é½á¹û0/null:δͨ¹ý 1:ͨ¹ý
|
||
WanderIsComplete int null,--¼ì²é±íÁ÷תÊÇ·ñÈ«²¿Í¨¹ý0:δͨ¹ý1:ͨ¹ý
|
||
WanderCompleteData datetime null,--¼ì²é±íÁ÷תÍê³ÉÈÕÆÚ
|
||
IsUnifyWanderAbout int null,--ÊÇ·ñͳһÁ÷ת0:·ñ1:ÊÇ
|
||
UnifyWanderAboutData datetime null,--ͳһÁ÷תʱ¼ä
|
||
UnifyWanderAboutOpinion varchar(max) null,--ͳһÁ÷ת±¸×¢
|
||
InspectIsClose int null,--ÈÎÎñµ¥ÊÇ·ñ¹Ø±Õ0:δ¹Ø±Õ1:ÒѹرÕ
|
||
InspectCloseData datetime null,--ÈÎÎñµ¥¹Ø±ÕÈÕÆÚ
|
||
InspectTime datetime NULL,--¼ì²éʱ¼ä
|
||
AddUser varchar(50) NULL,--Ìí¼ÓÈË
|
||
AddTime datetime NULL,--Ìí¼ÓÈÕÆÚ
|
||
CONSTRAINT PK_ProduceRun_SubInspectTerm PRIMARY KEY CLUSTERED
|
||
(
|
||
SubInspectId 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
|
||
|
||
--==¹¤×÷°ü¼ì²éÏî±í
|
||
if object_id(N'ProduceRun_SubInspectTermItem',N'U') is not null
|
||
drop table dbo.ProduceRun_SubInspectTermItem
|
||
CREATE TABLE dbo.ProduceRun_SubInspectTermItem(
|
||
TermItemId varchar(50) NOT NULL,--Ö÷¼ü
|
||
ProjectId varchar(50) NULL,--ÏîÄ¿Ö÷¼ü
|
||
SubInspectId varchar(50) NULL,--¼ì²é±íÖ÷¼ü
|
||
GroupName varchar(50) NULL,--·Ö×éÃû³Æ
|
||
WorkInspectId varchar(50) NOT NULL,--¹¤×÷°üÄ£°åÏîÖ÷¼ü
|
||
WorkInspectName varchar(500) NULL,--¼ì²éÊÂÏîÃû³Æ
|
||
InspectedUser varchar(50) NULL,--¼ì²éÈËÖ÷¼ü
|
||
InspectionResults int NULL,--¼ì²é½á¹û0:δͨ¹ý 1:ͨ¹ý
|
||
InspectionIllustrate varchar(200) NULL,--¼ì²é˵Ã÷
|
||
Contractor varchar(50) null,--³Ð°üÉÌ
|
||
Owner varchar(50) null,--ÒµÖ÷
|
||
ProcessPatent varchar(50) null,--¹¤ÒÕרÀûÉÌ
|
||
ContractorIsPass int NULL,--³Ð°üÉÌÊÇ·ñͨ¹ý0/null:δͨ¹ý 1:ͨ¹ý
|
||
OwnerIsPass int NULL,--ÒµÖ÷ÊÇ·ñͨ¹ý0/null:δͨ¹ý 1:ͨ¹ý
|
||
ProcessPatentIsPass int NULL,--¹¤ÒÕרÀûÉÌÊÇ·ñͨ¹ý0/null:δͨ¹ý 1:ͨ¹ý
|
||
ContractorRemark varchar(1000) NULL,--³Ð°üÉ̱¸×¢
|
||
OwnerRemark varchar(1000) NULL,--ÒµÖ÷±¸×¢
|
||
ProcessPatentRemark varchar(1000) NULL,--¹¤ÒÕרÀûÉ̱¸×¢
|
||
Remark varchar(200) NULL,--±¸×¢
|
||
AddUser varchar(50) NULL,--Ìí¼ÓÈË
|
||
AddTime datetime NULL,--Ìí¼ÓÈÕÆÚ
|
||
Sort int NULL,--ÅÅÐò
|
||
CONSTRAINT PK_ProduceRun_SubInspectTermItem PRIMARY KEY CLUSTERED
|
||
(
|
||
TermItemId 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
|
||
|
||
--==¼ì²é±íβÏî¹ÜÀí
|
||
if object_id(N'ProduceRun_InspectTailTerm',N'U') is not null
|
||
drop table dbo.ProduceRun_InspectTailTerm
|
||
CREATE TABLE dbo.ProduceRun_InspectTailTerm(
|
||
TailTermId varchar(50) NOT NULL,--Ö÷¼ü
|
||
ProjectId varchar(50) NULL,--ÏîÄ¿Ö÷¼ü
|
||
ProjectName varchar(50) NULL,--ÏîÄ¿Ãû³Æ
|
||
TailTermCode varchar(50) NULL,--Ѳ¼ì±àºÅ
|
||
ConstructionUnit varchar(50) NULL,--Ê©¹¤µ¥Î»
|
||
SubInspectId varchar(50) NULL,--¹¤×÷°ü¼ì²é±íÖ÷¼ü
|
||
TermItemId varchar(50) NULL,--¼ì²éÏîÖ÷¼ü
|
||
QuestionDesc varchar(max) NULL,--ÎÊÌâÃèÊö
|
||
RectifyOpinion varchar(max) NULL,--Õû¸ÄÒâ¼û
|
||
RectifyTime datetime NULL,--βÏîÌá³öʱ¼ä
|
||
InspectUser varchar(50) NULL,--¼ì²éÈË
|
||
HandleUser varchar(50) NULL,--´¦ÀíÈË
|
||
ApproveUser varchar(50) NULL,--ÉóºËÈË
|
||
AdjustCompleteTime datetime NULL,--ÒªÇóÕû¸ÄÍê³Éʱ¼ä
|
||
ApproveState int NULL,--0:´ýÌá½»´¦Àí1:´ý´¦Àí2:´¦ÀíÍË»Ø3:ÉóºËÍË»Ø4:´ýÉóºË5:ÉóºËͨ¹ý
|
||
AddUser varchar(50) NULL,--Ìí¼ÓÈË
|
||
AddTime datetime NULL,--Ìí¼ÓÈÕÆÚ
|
||
CONSTRAINT PK_ProduceRun_InspectTailTerm PRIMARY KEY CLUSTERED
|
||
(
|
||
TailTermId 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
|
||
|
||
--==¼ì²éÏî´¦Àí/ÉóºË¼Ç¼
|
||
if object_id(N'ProduceRun_InspectTermApproveRecords',N'U') is not null
|
||
drop table dbo.ProduceRun_InspectTermApproveRecords
|
||
CREATE TABLE dbo.ProduceRun_InspectTermApproveRecords(
|
||
InspectTermId varchar(50) NOT NULL,--Ö÷¼ü
|
||
ProjectId varchar(50) NULL,--ÏîÄ¿Ö÷¼ü
|
||
TermItemId varchar(50) NULL,--¼ì²éÏîÖ÷¼ü
|
||
TailTermId varchar(50) NULL,--βÏîÖ÷¼ü
|
||
ApproveOpinion varchar(max) NULL,--ÉóºËÒâ¼û
|
||
ApproveTime datetime NULL,--²Ù×÷ʱ¼ä
|
||
ApproveUser varchar(50) NULL,--²Ù×÷ÈË
|
||
ApproveType int NULL,--¼Ç¼ÀàÐÍ0:´¦Àí¼Ç¼1:ÉóºË¼Ç¼
|
||
ApproveState int NULL,--0:ÍË»Ø1:ͨ¹ý
|
||
AddUser varchar(50) NULL,--Ìí¼ÓÈË
|
||
AddTime datetime NULL,--Ìí¼ÓÈÕÆÚ
|
||
CONSTRAINT PK_ProduceRun_InspectTermApproveRecords PRIMARY KEY CLUSTERED
|
||
(
|
||
InspectTermId 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 |