/****** 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