selectc.*,fn_getpy(c_name)||'@'|| (casewhennewoulike'%潮州%'then'cz.gd.csg.cn'when newoulike'%东莞%'then'dg.gd.csg.cn'whennewoulike'%佛山%'then'fs.gd.csg.cn'when newoulike'%河源%'then'hy.gd.csg.cn'whennewoulike'%惠州%'then'hz.gd.csg.cn'when newoulike'%江门%'then'jm.gd.csg.cn'whennewoulike'%揭阳%'then'jy.gd

selectcasewheni.name=d.deptthen1else0endfromisc_baseorgijoin资产数据确定映射表_电科院0403doni.sysdataid=d.hrdeptid

updateHR_USER_ZSJ_推广_oksetlogin_name=fn_getpy_1(名称)||'@'||(casewhennewoulike'%潮州供电局%'then'cz.gd.csg.cn'whennewoulike'%东莞供电局%'then'dg.gd.csg.cn'whennewoulike'%佛山供电局%'then'fs.gd.csg.cn'whennewoulike'%河源供电局%'then'hy.gd.csg.cn'whenn

vi/etc/init.d/tomcat-auth #tomcat自启动脚本 #!/bin/sh #chkconfig:3459910 #description:Auto-startstomcat #/etc/init.d/tomcatd #Tomcatauto-start #Sourcefunctionlibrary. #./etc/init.d/functions #sourcenetworkingconfiguration. #./etc/sysconfig/network RETVAL=0 exportJDK_HOME=/usr/java/jdk1.8