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.
75 lines
3.4 KiB
75 lines
3.4 KiB
|
|
/****** Object: StoredProcedure [dbo].[SP_UPDATE_XJ_STUDENT] Script Date: 03/23/2017 14:28:43 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[SP_UPDATE_XJ_STUDENT]
|
|
@user_id as varchar(36), --学生ID
|
|
@parent_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) --学校ID
|
|
declare @class_id varchar(36) --班级ID
|
|
|
|
set @now = GETDATE()
|
|
select @org_id = ORG_ID,@class_id = DEPT_ID from T_BASE_USER where ID = @user_id;
|
|
--插入家长User
|
|
--insert into T_BASE_USER (ID,LOGIN_NAME,LOGIN_PWD,USE_FLAG,SORT_NO,USER_REALNAME,LINK_ID,ORG_ID,DEPT_ID,DELETE_FLAG,CREATE_TIME)
|
|
--select @parent_id,LOGIN_NAME+'_jz',LOGIN_PWD,1,0,USER_REALNAME+'_家长',LINK_ID,ORG_ID,DEPT_ID,0,GETDATE() from T_BASE_USER where ID = @user_id;
|
|
--插入家长UserDetail
|
|
--insert into T_BASE_USER_DETAIL(ID,USER_ID,USER_SOURCE_TYPE,USER_MANAGE_TYPE,USER_ACCESS_TYPE,DELETE_FLAG,CREATE_TIME)
|
|
--select NEWID(),@parent_id,1,1,1,0,GETDATE() from T_BASE_USER_DETAIL where USER_ID = @user_id;
|
|
--插入学生身份
|
|
--insert into T_BASE_USER_IDENTITY ([ID],[USER_ID],[IDENTITY_ID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
--values(NEWID(),@user_id,'8a8a87a13c42898b013c428aa6c40001',0,GETDATE(),NULL);
|
|
--插入家长身份
|
|
--insert into T_BASE_USER_IDENTITY ([ID],[USER_ID],[IDENTITY_ID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
--values(NEWID(),@parent_id,'8a8a87a13c4b3633013c4b4144d10000',0,GETDATE(),NULL);
|
|
|
|
--插入学生学校对应关系
|
|
UPDATE T_BASE_USER_ORG SET DELETE_FLAG = 1 WHERE USER_ID = @user_id;
|
|
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 @class_id is not null or @class_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])
|
|
values(NEWID(),@user_id,@class_id,3,0,'',0,GETDATE(),NULL);
|
|
end;
|
|
--插入家长学校对应关系
|
|
--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(),@parent_id,ORG_ID,ORG_TYPE,0,ORG_CATID,0,GETDATE(),NULL from T_BASE_ORGTREE where ORG_ID = @org_id;
|
|
--插入家长班级对应关系(如果学生有)
|
|
--IF @class_id is not null or @class_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])
|
|
--values(NEWID(),@parent_id,@class_id,3,0,'',0,GETDATE(),NULL);
|
|
--end;
|
|
--插入学生角色
|
|
--insert into T_SYS_USER_ROLE([ID],[USER_ID],[ROLE_ID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
--values (NEWID(),@user_id,'8a8a87a13d110929013d111001810001',0,GETDATE(),NULL);
|
|
--插入家长角色
|
|
--insert into T_SYS_USER_ROLE([ID],[USER_ID],[ROLE_ID],[DELETE_FLAG],[CREATE_TIME],[MODIFY_TIME])
|
|
--values (NEWID(),@parent_id,'8a8a87a13d110929013d11102ee70002',0,GETDATE(),NULL);
|
|
--插入学生家长关系
|
|
--insert into T_BASE_USER_PARENT ([ID],[USER_ID],[PARENT_ID],[PARENT_TYPE],[DELETE_FLAG],[CREATE_TIME])
|
|
--values(NEWID(),@user_id,@parent_id,2,0,GETDATE());
|
|
|
|
SET @result=1;
|
|
SET @runtime = RIGHT(CONVERT(VARCHAR(23),GETDATE() - @now,21),12);
|
|
END
|
|
|
|
|
|
|
|
GO
|
|
|
|
|