有思俱乐部学习园地

删除团队


语法格式:


调用参数:
参数1:uid 用户id
参数2:tid 团队Id 

前端javascript调用数据库存储过程示例(可在编辑区域修改参数):

U.A.Request("http://cd.1473.cn/php", (["db.1473.cn", "UseStudio_Task", "Task_DelectTeam","e4a5b03b-febd-4ab4-bc6a-a74f02a8110d","6ff68add-c8e4-11e7-81ee-005056b350a4"]),AsynFun);

运行结果展示区域:

前端javascript调用示例:


SET @tid = (SELECT Task_Team.TeamId FROM Task_Team WHERE Task_Team.TeamCreatorId = uid AND Task_Team.TeamId = tid);
#SET @pid = (SELECT UserId FROM Task_Poject,Task_PojectPermiss WHERE Task_Poject.PojectId = Task_PojectPermiss.PermissId AND Task_PojectPermiss.UserId = uid AND Task_Poject.PojectTeamId = tid);
IF(@tid IS NULL) THEN
DELETE FROM Task_TeamMember where UserId = uid AND TeamId = tid;
# DELETE FROM Task_PojectPermiss WHERE UserId = @pid;
ELSE
DELETE FROM Task_Team WHERE TeamCreatorId = uid AND TeamId = tid;
DELETE FROM Task_TeamMember where TeamId = @tid;

工作人员

 
作者:傅昊
信息录入:刘伟杰
>