companycarddaoimpl.java

oa办公系统

package cn.jx.ecjtu.oa.ps.dao.impl;
/**
 * @todo:Description
 * @author 谢睿文
 * @version $Revision: 1.44 $
 * @since 1.0
 */

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.wanczy.dbutil.IResultSetHandler;

import cn.jx.ecjtu.oa.ps.dao.BaseDao;
import cn.jx.ecjtu.oa.ps.dao.CompanyCardDao;
import cn.jx.ecjtu.oa.ps.pojo.CompanyCard;
import cn.jx.ecjtu.oa.ps.pojo.UserCard;


public class CompanyCardDaoImpl extends BaseDao implements CompanyCardDao {
	class ResultSet2CompanyCard implements IResultSetHandler {
		public Object handle(ResultSet rs) throws SQLException {
			return new CompanyCard(rs.getInt("user_id"),
					            rs.getInt("company_id"),
					            rs.getString("name"),
					            rs.getString("address"),
					            rs.getString("phone"),
					            rs.getString("post"));
		}
	}
	private ResultSet2CompanyCard resultSet2CompanyCard=new ResultSet2CompanyCard();

	
	
	  /**
	    *以按公司ID查找公司名片
	    * @author 邹勇
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public List<CompanyCard> findCompanyCardByCompanyId(int user_id ,int company_id) {
		String sql="select * from oa_contract_company where company_id=? and user_id=?";
		List list=dbAccess.executeQuery(sql,
				new Object[]{new Integer(company_id),new Integer(user_id),},
				resultSet2CompanyCard);
		if(list.size()>0) return list;
		else return null;
	}
	  /**
	    *以公司名称查找公司名片
	    * @author 邹勇
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public List<CompanyCard> findCompanyCardByCompanyName(int user_id,String name) {
		List list=dbAccess.executeQuery("select * from oa_contract_company where name=? and user_id=?",
				new Object[]{new String(name),new Integer(user_id),},
				resultSet2CompanyCard);
		if(list.size()>0) return list;
		else return null;
	}
	/**
	    *以ID模糊查找公司名片
	    * @author 邹勇
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public List<CompanyCard> findCompanyCardByLikeId(int user_id,String id,int offset,int num) {
		// TODO Auto-generated method stub
		List list=dbAccess.executeQuery("select top "+(offset+num)+ " * from oa_contract_company where company_id like ? and user_id=?",
				new Object[]{new String("%"+id+"%"),new Integer(user_id)},
				resultSet2CompanyCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		return list;
	}
	/**
	    *以phone模糊查找公司名片
	    * @author 邹勇
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public List<CompanyCard> findCompanyCardByLikePhone(int user_id,String phone,int offset,int num) {
		// TODO Auto-generated method stub
		List list=dbAccess.executeQuery("select top "+(offset+num)+ " * from oa_contract_company where phone like ? and user_id=?",
				new Object[]{"%"+phone+"%",new Integer(user_id)},
				resultSet2CompanyCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		return list;
	}
	/**
	    *以公司电话查找公司名片
	    * @author 黄宗建
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public List<CompanyCard> findCompanyCardByCompanyPhone(int user_id,String phone) {
		// TODO Auto-generated method stub
		List list=dbAccess.executeQuery("select * from oa_contract_company where phone=? and user_id=?",
				new Object[]{new String(phone),new Integer(user_id)},
				resultSet2CompanyCard);
		if(list.size()>0) return list;
		else return null;
	}
	/**
	    *以名称模糊查找公司名片
	    * @author 黄宗建
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public List<CompanyCard> findCompanyCardByLikeName(int user_id,String likecompanycard,int offset,int num) {
		// TODO Auto-generated method stub
		List list=dbAccess.executeQuery("select top "+(offset+num)+ " * from oa_contract_company where name like ? and user_id=?",
				new Object[]{"%"+likecompanycard+"%",new Integer(user_id)},
				resultSet2CompanyCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		return list;
	}
	

	/**
	    *删除公司名片
	    * @author 曹新星
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public int removeCompanyCard(int user_id,int company_id) {
		return dbAccess.executeUpdate("delete  from oa_contract_company where user_id=? and company_id=?",
				new Object[]{user_id,company_id});
		
			}
	
	/**
	    *添加公司名片
	    * @author 谢睿文
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public int saveCompanyCard(CompanyCard card) {
		return dbAccess.executeUpdate(
				"insert into oa_contract_company (user_id,name,address,phone,post) values (?,?,?,?,?)",
				new Object[]{card.getUser_id(),
					     card.getName(),
					     card.getAddress(),
					     card.getPhone(),
					     card.getPost()					     
			});
	}

	/**
	    *修改公司名片
	    * @author 吴春辉
	    * @version $Revision: 1.44 $
	    * @since 1.0
	    */
	public int updateCompanyCard(CompanyCard card) {
		return dbAccess.executeUpdate(
				"update oa_contract_company set name=?,phone=?,address=?,post=? where company_id=?",
				new Object[]{
						 
						 card.getName(),
						 card.getPhone(),
					     card.getAddress(),
					     card.getPost(),
					     card.getCompany_id()});	
		//user_id=?,card.getUser_id(),
	}
	
	/**
	    *列出公司名片信息
	    * @author 曹新星
	    * @version $Revision: 1.44 $
	    * @since 1.0
	 */
	public List<CompanyCard> findcompanycardByOwner(int ownerId){
		return dbAccess.executeQuery("select * from oa_contract_company where user_id=?",
				new Object[] { ownerId }, resultSet2CompanyCard);
	}
}