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.
213 lines
7.7 KiB
Plaintext
213 lines
7.7 KiB
Plaintext
|
|
INSERT [dbo].[CMS_PRMIS_TABLE] ([PRMISID], [PRMISNAME], [SYSID], [PRMISURL], [PARENTFLAG], [PRMISFLAG], [ENFLAG], [OPER], [REMARK], [ICON], [UNUSED], [PINDEXSTR]) VALUES (2021, N'突发事件管理', 2000, N'BaseMg/M_BT_TFFLAGRECORDMg.aspx', 2010, 3, 7, NULL, NULL, NULL, NULL, NULL)
|
|
INSERT [dbo].[CMS_PRMIS_TABLE] ([PRMISID], [PRMISNAME], [SYSID], [PRMISURL], [PARENTFLAG], [PRMISFLAG], [ENFLAG], [OPER], [REMARK], [ICON], [UNUSED], [PINDEXSTR]) VALUES (2022, N'投诉事件管理', 2000, N'CenterMg/MC_BT_ComplainRecordMg.aspx', 2010, 3, 7, NULL, NULL, NULL, NULL, NULL)
|
|
|
|
INSERT [dbo].[CMS_PRMIS_TABLE] ([PRMISID], [PRMISNAME], [SYSID], [PRMISURL], [PARENTFLAG], [PRMISFLAG], [ENFLAG], [OPER], [REMARK], [ICON], [UNUSED], [PINDEXSTR]) VALUES (2038, N'突发事件管理', 2000, N'BaseMg/M_BT_TFFLAGRECORDMg.aspx', 2030, 3, 7, NULL, NULL, NULL, NULL, NULL)
|
|
INSERT [dbo].[CMS_PRMIS_TABLE] ([PRMISID], [PRMISNAME], [SYSID], [PRMISURL], [PARENTFLAG], [PRMISFLAG], [ENFLAG], [OPER], [REMARK], [ICON], [UNUSED], [PINDEXSTR]) VALUES (2039, N'投诉事件管理', 2000, N'CenterMg/MC_BT_ComplainRecordMg.aspx', 2030, 3, 7, NULL, NULL, NULL, NULL, NULL)
|
|
|
|
|
|
insert into M_CODE values('MC_TFFLAG','突发事件类型',1,2,4);
|
|
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_TFFLAG',1,'车祸');
|
|
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_DEPART','投诉事件-被投诉单位',1,2,4);
|
|
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_DEPART',1,'养护集团');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_DEPART',2,'包头所下设的ETC办理点');
|
|
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) select 'MC_COMPLAIN_DEPART',STANO,STANAME from NAME_TABLE where STATYPE=1 and SUBCOMNO=4
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_INFO','投诉事件-投诉内容',1,2,4);
|
|
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_INFO',1,'多扣费');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_INFO',2,'重复扣费');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_INFO',3,'ETC车道未开');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_INFO',4,'服务质量');
|
|
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_CHECK','投诉事件-核实情况',1,2,4);
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_CHECK',1,'满意');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_CHECK',2,'解决');
|
|
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_CALLBACK','投诉事件-12345回访',1,2,4);
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_CALLBACK',1,'满意');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_CALLBACK',2,'解决');
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_HANDLE','投诉事件-解决措施',1,2,4);
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_HANDLE',1,'已流转');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_HANDLE',2,'已退回');
|
|
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_JKGROUP','投诉事件-监控组别',1,2,4);
|
|
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_JKGROUP',1,'一');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_JKGROUP',2,'二');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_JKGROUP',3,'三');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_JKGROUP',4,'四');
|
|
|
|
insert into M_CODE values('MC_COMPLAIN_OUTEQUP','投诉事件-导出设备',1,2,4);
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_OUTEQUP',1,'无');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_OUTEQUP',2,'内网通');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_OUTEQUP',3,'微信');
|
|
insert into M_CODEDICTIONARY(TYPENAME,ID,TEXT) values('MC_COMPLAIN_OUTEQUP',4,'U盘');
|
|
|
|
|
|
|
|
|
|
drop table MC_BT_JDEQPXJPORTRECORD
|
|
go
|
|
drop table MC_BT_JDEQPXJPORTRECORD_CENTER
|
|
go
|
|
CREATE TABLE [dbo].[MC_BT_JDEQPXJPORTRECORD](
|
|
[AREANO] [int] NOT NULL,
|
|
[ROADNO] [int] NOT NULL,
|
|
[SUBCOMNO] [int] NOT NULL,
|
|
[STANO] [int] NOT NULL,
|
|
[CLASSDATE] [datetime] NOT NULL,
|
|
[CLASSNO] [int] NOT NULL,
|
|
[SEQNO] [int] NOT NULL,
|
|
[PORTNO] [int] NOT NULL,
|
|
[MAKEDATE] [datetime] NOT NULL,
|
|
[PORTTYPE] [int] NULL,
|
|
[PORTKIND] [int] NULL,
|
|
[YXSTATUS] [int] NULL,
|
|
[PORTSTATUS] [int] NULL,
|
|
[REMARK] [varchar](500) NULL,
|
|
[EPAYTYPE] [int] NULL,
|
|
[EPAYLOCAL] [int] NULL,
|
|
[EPAYKIND] [int] NULL,
|
|
[EPAYHANDCT] [int] NULL,
|
|
[OPMANNO] [int] NULL,
|
|
[OPMAN] [varchar](16) NULL,
|
|
[USERTYPE] [int] NULL,
|
|
[DATEMARK] [datetime] NULL,
|
|
[BAK1] [int] NULL,
|
|
[BAK2] [int] NULL,
|
|
[BAK3] [int] NULL,
|
|
[BAK4] [varchar](20) NULL,
|
|
[BAK5] [varchar](1) NULL,
|
|
[BAK6] [varchar](1) NULL,
|
|
CONSTRAINT [PK_MC_BT_JDEQPXJPORTRECORD] PRIMARY KEY CLUSTERED
|
|
(
|
|
[SUBCOMNO] ASC,
|
|
[STANO] ASC,
|
|
[CLASSDATE] ASC,
|
|
[CLASSNO] ASC,
|
|
[SEQNO] ASC,
|
|
[PORTNO] 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
|
|
|
|
CREATE TABLE [dbo].[MC_BT_JDEQPXJPORTRECORD_CENTER](
|
|
[AREANO] [int] NOT NULL,
|
|
[ROADNO] [int] NOT NULL,
|
|
[SUBCOMNO] [int] NOT NULL,
|
|
[STANO] [int] NOT NULL,
|
|
[CLASSDATE] [datetime] NOT NULL,
|
|
[CLASSNO] [int] NOT NULL,
|
|
[SEQNO] [int] NOT NULL,
|
|
[PORTNO] [int] NOT NULL,
|
|
[MAKEDATE] [datetime] NOT NULL,
|
|
[PORTTYPE] [int] NULL,
|
|
[PORTKIND] [int] NULL,
|
|
[YXSTATUS] [int] NULL,
|
|
[PORTSTATUS] [int] NULL,
|
|
[REMARK] [varchar](500) NULL,
|
|
[EPAYTYPE] [int] NULL,
|
|
[EPAYLOCAL] [int] NULL,
|
|
[EPAYKIND] [int] NULL,
|
|
[EPAYHANDCT] [int] NULL,
|
|
[OPMANNO] [int] NULL,
|
|
[OPMAN] [varchar](16) NULL,
|
|
[USERTYPE] [int] NULL,
|
|
[DATEMARK] [datetime] NULL,
|
|
[BAK1] [int] NULL,
|
|
[BAK2] [int] NULL,
|
|
[BAK3] [int] NULL,
|
|
[BAK4] [varchar](20) NULL,
|
|
[BAK5] [varchar](1) NULL,
|
|
[BAK6] [varchar](1) NULL,
|
|
CONSTRAINT [PK_MC_BT_JDEQPXJPORTRECORD_CENTER] PRIMARY KEY CLUSTERED
|
|
(
|
|
[SUBCOMNO] ASC,
|
|
[STANO] ASC,
|
|
[CLASSDATE] ASC,
|
|
[CLASSNO] ASC,
|
|
[SEQNO] ASC,
|
|
[PORTNO] 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
|
|
|
|
go
|
|
|
|
|
|
create trigger [dbo].[ti_MC_BT_JDEQPXJPORTRECORD] on [dbo].[MC_BT_JDEQPXJPORTRECORD] for insert
|
|
as
|
|
begin
|
|
declare @SUBCOMNO INT
|
|
declare @STANO INT
|
|
declare @CLASSDATE DATETIME
|
|
declare @PORTNO INT
|
|
declare @CLASSNO INT
|
|
declare @SEQNO INT
|
|
select @SUBCOMNO=SUBCOMNO,@STANO=STANO,@CLASSDATE=CLASSDATE,@PORTNO=PORTNO,@CLASSNO=CLASSNO,@SEQNO=SEQNO from inserted i;
|
|
if exists(select * from MC_BT_JDEQPXJPORTRECORD_CENTER where SUBCOMNO=@SUBCOMNO and STANO=@STANO and CLASSDATE=@CLASSDATE and PORTNO=@PORTNO AND CLASSNO=@CLASSNO and SEQNO=@SEQNO)
|
|
begin
|
|
delete from MC_BT_JDEQPXJPORTRECORD_CENTER where SUBCOMNO=@SUBCOMNO and STANO=@STANO and CLASSDATE=@CLASSDATE and PORTNO=@PORTNO AND CLASSNO=@CLASSNO and SEQNO=@SEQNO
|
|
end
|
|
insert into MC_BT_JDEQPXJPORTRECORD_CENTER select * from inserted i;
|
|
end
|
|
|
|
|
|
go
|
|
|
|
create TRIGGER [dbo].[tu_MC_BT_JDEQPXJPORTRECORD] ON [dbo].[MC_BT_JDEQPXJPORTRECORD] FOR update AS
|
|
BEGIN
|
|
delete MC_BT_JDEQPXJPORTRECORD_CENTER from MC_BT_JDEQPXJPORTRECORD_CENTER cb,inserted i where cb.SUBCOMNO=i.SUBCOMNO and cb.STANO=i.STANO and cb.CLASSDATE=i.CLASSDATE and cb.PORTNO=i.PORTNO AND cb.CLASSNO=i.CLASSNO and cb.SEQNO=i.SEQNO;
|
|
insert into MC_BT_JDEQPXJPORTRECORD_CENTER select * from inserted;
|
|
end
|
|
|
|
go
|
|
|
|
create trigger [dbo].[td_MC_BT_JDEQPXJPORTRECORD] on [dbo].[MC_BT_JDEQPXJPORTRECORD] for delete
|
|
as
|
|
begin
|
|
delete MC_BT_JDEQPXJPORTRECORD_CENTER from MC_BT_JDEQPXJPORTRECORD_CENTER cb, deleted i where cb.SUBCOMNO=i.SUBCOMNO and cb.STANO=i.STANO and cb.CLASSDATE=i.CLASSDATE and cb.PORTNO=i.PORTNO AND cb.CLASSNO=i.CLASSNO and cb.SEQNO=i.SEQNO;
|
|
end
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
alter table MC_BT_SENDINFORRECORD alter column BAK5 varchar(1000)
|
|
|
|
alter table MC_BT_SENDINFORRECORD_center alter column BAK5 varchar(1000)
|
|
|
|
|