审查视图

.svn/pristine/a3/a3fc3bf1a6db9cacab105ecdd22884975fbc8a92.svn-base 3.4 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172
package yxy.timer.webservice.interfaces.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;

import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebResult;
import javax.jws.WebService;

import org.apache.commons.lang.StringUtils;

import yxy.timer.tool.DBUtil;
import yxy.timer.webservice.interfaces.LinkManWebservice;

@WebService(targetNamespace="http://LinkManWebservice.interfaces.webservice.timer.yxy/",serviceName="linkmanWebservice")
public class LinkManWebserviceImpl implements LinkManWebservice
{	
	@WebResult(name="result")
	@WebMethod
	public String updateLinkMan(@WebParam(name="id",targetNamespace="http://LinkManWebservice.interfaces.webservice.timer.yxy/")int id,
			@WebParam(name="full_name1",targetNamespace="http://LinkManWebservice.interfaces.webservice.timer.yxy/")String fullName1,
			@WebParam(name="email1",targetNamespace="http://LinkManWebservice.interfaces.webservice.timer.yxy/")String email1) 
	{
		Connection connection;
		
		PreparedStatement  pst;
		
		String result = "";
		
		int linkman_id = id;
		
		String full_name = fullName1;
		
		String email = email1;
		
		if(linkman_id == 0)
		{
			result = "error";
			
			return result;
		}
		
		if(null == full_name || full_name.equals(""))
		{
			result = "error";
			
			return result;
		}
		
		if(null == email || email.equals(""))
		{
			result = "error";
			
			return result;
		}
		
		try
		{
			//获取数据库的连接
			connection = DBUtil.getConnection("dataSource");
			
			String sql = "update yxy_customer_email set full_name='"+full_name+"',customer_email='"+email+"' where linkman_id="+linkman_id;
			
			pst = connection.prepareStatement(sql);
			
			pst.executeUpdate(sql);
			
			result = "success";
			
			return result;
		}
		
		catch(Exception e)
		{
			e.printStackTrace();
			
			result = "";
			
			return result;
		}
	}

	@WebResult(name="result")
	@WebMethod
	public String deleteLinkMan(@WebParam(name="id",targetNamespace="http://LinkManWebservice.interfaces.webservice.timer.yxy/")int id) 
	{
		Connection connection;
		
		PreparedStatement  pst;
		
		String result = "";
		
		int linkman_id = id;
		
		if(linkman_id == 0)
		{
			result = "error";
			
			return result;
		}
		
		try
		{
			//获取数据库的连接
			connection = DBUtil.getConnection("dataSource");
			
			String sql = "delete from yxy_customer_email where linkman_id="+linkman_id;
			
			pst = connection.prepareStatement(sql);
			
			pst.executeUpdate(sql);
			
			result = "success";
			
			return result;
		}
		
		catch(Exception e)
		{
			e.printStackTrace();
			
			result = "";
			
			return result;
		}
	}

	/**同步webmail的公海客户,多个以逗号隔开*/
	@WebResult(name="result")
	@WebMethod
	public String updateCustomerToPublic(@WebParam(name="customer_id",targetNamespace="http://LinkManWebservice.interfaces.webservice.timer.yxy/")String customer_id)
	{
		String result = "";
		
		if(StringUtils.isBlank(customer_id))
		{
			result = "error";
			
			return result;
		}
		
		try
		{
			Connection connection;
			
			PreparedStatement  pst;
			
			//获取数据库的连接
			connection = DBUtil.getConnection("dataSource");
			
			String sql = "update yxy_customer_email set customer_type=1 where customer_id in("+customer_id+")";
			
			pst = connection.prepareStatement(sql);
			
			pst.executeUpdate(sql);
			
			result = "success";
			
			return result;
		}
		
		catch(Exception e)
		{
			e.printStackTrace();
			
			result = "error";
			
			return result;
		}
	}
}