SET @BUILD_NAME= '中试';
    
    SET @ORG_CODE=(SELECT LPAD(MAX(wbd.ORG_CODE) +1 ,3,0) FROM `wwyt-sh-0317`.wwyt_bp_depart wbd INNER JOIN `wwyt-sh-0317`.wwyt_pod_license wpl ON wbd.TENENT_ID=wpl.TENENT_ID AND wpl.ORG_CODE='999' WHERE wbd.ORG_CODE!='999' AND wbd.type=1 AND wbd.DELETE_FLAG='0');
    SET @TENENT_ID= (SELECT TENENT_ID FROM `wwyt-sh-0317`.wwyt_pod_license WHERE ORG_CODE='999' LIMIT 1);
    SET @PARENT_ID=  (SELECT ORG_ID FROM `wwyt-sh-0317`.wwyt_pod_license WHERE ORG_CODE='999' LIMIT 1);
    
    SELECT IF(a.res_2 IS NOT NULL,a.res_2,a.res_1) AS result FROM (
     SELECT IF(@BUILD_NAME='','插入失败，请输入企业名称','插入成功') AS res_1,NULL AS res_2 FROM DUAL 
     UNION 
     SELECT NULL res_1,IF(@BUILD_NAME=wbd.name,'插入失败，企业名称已存在','插入成功') AS res_2 FROM `wwyt-sh-0317`.wwyt_bp_depart wbd INNER JOIN `wwyt-sh-0317`.wwyt_pod_license wpl ON wbd.TENENT_ID=wpl.TENENT_ID AND wpl.ORG_CODE='999' WHERE wbd.ORG_CODE!='999' AND wbd.type=1 AND wbd.DELETE_FLAG='0' AND @BUILD_NAME=wbd.name
    	) a ORDER BY LENGTH(result) DESC LIMIT 1;
     
    INSERT INTO `wwyt-sh-0317`.`wwyt_bp_depart` (`NAME`, `TENENT_ID`, `PARENT_ID`, `CREATE_BY`, `CREATE_TIME`, `UPDATE_BY`, `UPDATE_TIME`, `DELETE_FLAG`, `ORG_CODE`, `CODE`, `type`, `child_no`) 
    SELECT @BUILD_NAME, @TENENT_ID, @PARENT_ID, -1, NOW(), -1, NOW(), '0', @ORG_CODE,@ORG_CODE , 1, 1 FROM DUAL WHERE @BUILD_NAME!='' AND @BUILD_NAME NOT IN (SELECT wbd.name FROM `wwyt-sh-0317`.wwyt_bp_depart wbd INNER JOIN `wwyt-sh-0317`.wwyt_pod_license wpl ON wbd.TENENT_ID=wpl.TENENT_ID AND wpl.ORG_CODE='999' WHERE wbd.ORG_CODE!='999' AND wbd.type=1 AND wbd.DELETE_FLAG='0');