You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
57 lines
1.9 KiB
57 lines
1.9 KiB
use system_manager_ssh
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[SP_INSERT_RS_TEACHER] Script Date: 03/23/2017 14:27:31 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[SP_INSERT_RS_TEACHER]
|
|
@user_id as varchar(36), --教工ID
|
|
@result int = 0 output, --执行结果标志，>0正确
|
|
@runtime varchar(12) = 0 output --执行时间
|
|
AS
|
|
BEGIN
|
|
declare @now datetime
|
|
declare @org_id varchar(36)
|
|
declare @dept_id varchar(36)
|
|
declare @org_type integer
|
|
declare @role_id varchar(36)
|
|
set @now = GETDATE()
|
|
select @org_id = ORG_ID,@dept_id = DEPT_ID from T_BASE_USER where ID = @user_id
|
|
select @org_type = ORG_TYPE from T_BASE_ORGTREE where ORG_ID = @org_id
|
|
--插入教工身份
|
|
insert into T_BASE_USER_IDENTITY ([ID],[USER_ID],[IDENTITY_ID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
values(NEWID(),@user_id,'8a8a87a13c42898b013c428a7c860000',0,GETDATE(),NULL);
|
|
--插入用户机构对应关系
|
|
insert into T_BASE_USER_ORG ([ID],[USER_ID],[ORG_ID],[ORG_TYPE],[ORG_SUBORDINATE],[ORG_CATID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
select NEWID(),@user_id,ORG_ID,ORG_TYPE,0,ORG_CATID,0,GETDATE(),NULL from T_BASE_ORGTREE where ORG_ID = @org_id;
|
|
--插入用户部门对应关系(如果有)
|
|
IF @dept_id is not null or @dept_id <> ''
|
|
begin
|
|
insert into T_BASE_USER_ORG ([ID],[USER_ID],[ORG_ID],[ORG_TYPE],[ORG_SUBORDINATE],[ORG_CATID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
select NEWID(),@user_id,ORG_ID,ORG_TYPE,0,ORG_CATID,0,GETDATE(),NULL from T_BASE_ORGTREE where ORG_ID = @dept_id;
|
|
end;
|
|
--判断教工角色
|
|
IF @org_type = 0
|
|
begin
|
|
set @role_id = 'E2C92B9D-EA6A-412B-BF12-F5496F97C569'; --机构教职工
|
|
end
|
|
else
|
|
begin
|
|
set @role_id = '45836DD6-D91D-4A76-8E40-65CEF93E147F'; --学校教职工
|
|
end
|
|
--插入教工角色
|
|
insert into T_SYS_USER_ROLE([ID],[USER_ID],[ROLE_ID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
values (NEWID(),@user_id,@role_id,0,GETDATE(),NULL);
|
|
|
|
SET @result=1;
|
|
SET @runtime = RIGHT(CONVERT(VARCHAR(23),GETDATE() - @now,21),12);
|
|
END
|
|
|
|
GO
|
|
|
|
|