business_office.java

电信的网厅的整站代码

package com.doone.fj1w.info_manage;

import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.fj1w.fj1w.login.app.CommitDate;
import com.doone.util.FileLogger;
//营业厅资料处理类（对TD_BUSINESSINFO表进行增、删、改、查）
public class Business_office {

	DacClient _dac=new DacClient();
	int pagecount=15;
	
	private String businessInfoId;
	private String areaCode;
	private String name;
	private String relationTel;
	private String businessTime;
	private String address;
	private String transact;
	private String sale;
	private String commission;
	private String mainTain;
	private String otherBusiness;
	
	private String fax;
	private String publicbus;
	private String business;
	
	private CommitDate cd = null;

	public String getBusinessInfoId() {
		return  businessInfoId;
	}
	public void setBusinessInfoId(String  businessInfoId) {
		this.businessInfoId =  businessInfoId;
	}
	public String getAreaCode() {
		return areaCode;
	}
	public void setAreaCode(String areaCode) {
		this.areaCode = areaCode;
	}
	public String getname() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getRelationTel() {
		return relationTel;
	}
	public void setRelationTel(String relationTel) {
		this.relationTel = relationTel;
	}
	public String getBusinessTime() {
		return businessTime;
	}
	public void setBusinessTime(String businessTime) {
		this.businessTime = businessTime;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getTransact() {
		return transact;
	}
	public void setTransact(String transact) {
		this.transact = transact;
	}
	public String getSale() {
		return sale;
	}
	public void setSale(String sale) {
		this.sale = sale;
	}
	public String getCommission() {
		return commission;
	}
	public void setCommission(String commission) {
		this.commission = commission;
	}
	public String getMainTain() {
		return mainTain;
	}
	public void setMainTain(String mainTain) {
		this.mainTain = mainTain;
	}
	public String getOtherBusiness() {
		return otherBusiness;
	}
	public void setOtherBusiness(String otherBusiness) {
		this.otherBusiness = otherBusiness;
	}
	
	
	public String getfax() {
		return fax;
	}
	public void setfax(String otherBusiness) {
		this.fax = otherBusiness;
	}
	public String getpublicbus() {
		return publicbus;
	}
	public void setpublicbus(String otherBusiness) {
		this.publicbus = otherBusiness;
	}
	public String getbusiness() {
		return business;
	}
	public void setbusiness(String otherBusiness) {
		this.business = otherBusiness;
	}
	

	public Business_office() {
		cd = CommitDate.getInstance();
	}


	public DataTable getInfo(String area,int row) //获得信息列表
	{
		DataTable dt=null;
		String sql="select * from (select a.businessinfoid,b.areaname,a.name ,a.relationtel,rownum num from "+
		"td_businessinfo a,td_area b where a.areacode=b.areacode and a.areacode = ?) a where a.num>"+
		(row-1)*pagecount+" and a.num<="+row*pagecount;
		Object[] _object=new Object[1];

		_object[0]=area;
		try {
			_dac.beginTransaction(10000);
			dt = _dac.executeQuery(sql, _object);
			_dac.endTransaction(true);
			FileLogger.getLogger().debug(_object[0]);
		}
		catch (Exception ex) {
			FileLogger.getLogger().debug(ex);
			try {
				_dac.endTransaction(false);
			}
			catch (Exception ex1) {
			}
		}
		return dt;
	}
	
	public DataTable getUnderCityInfo(String area,String  row) //获得地市信息列表
	{   
		DataTable dt=null;
		if(area==null||area.equals("null")||area.equals("")){area="";}
		else{area=" and b.citycode='"+area+"'";}
		StringBuffer sql=new StringBuffer();
		sql.append("select * from (");
		sql.append("select a.businessinfoid,b.areaname,a.name ,a.relationtel,a.ADDRESS,rownum num from ");
		sql.append(" td_businessinfo a,td_area b ");
		sql.append(" where a.areacode=b.areacode ");
        sql.append(area);
        sql.append(")a");
        sql.append(" where a.num>");
        sql.append((Integer.parseInt(row)-1)*pagecount);
        sql.append(" and a.num<=");
        sql.append(Integer.parseInt(row)*pagecount);
        //System.out.println("地市sql==>"+sql);
		
		
		try {
			_dac.beginTransaction(10000);
			dt = _dac.executeQuery(sql.toString());
			_dac.endTransaction(true);
			
		}
		catch (Exception ex) {
			FileLogger.getLogger().debug(ex);
			try {
				_dac.endTransaction(false);
			}
			catch (Exception ex1) {
			}
		}
		return dt;
	}
	
	
	public DataTable getUnderAreaInfo(String city,String area,String row) //获得地区信息列表
	{
		if(area==null||area.equals("null")||area.equals("")){area="";}
		else{area=" and b.areacode='"+area+"'";}
		if(city==null||city.equals("null")||city.equals("")){city="";}
		else{city=" and b.citycode='"+city+"'";}
		DataTable dt=null;
		StringBuffer sql=new StringBuffer();
		sql.append("select * from (");
		sql.append("select a.businessinfoid,b.areaname,a.name ,a.relationtel,a.ADDRESS,rownum num from ");
		sql.append("td_businessinfo a,td_area b");
		sql.append(" where a.areacode=b.areacode");
		sql.append(city);
		sql.append(area);
		sql.append(")a");
		sql.append(" where a.num>");
		sql.append((Integer.parseInt(row)-1)*pagecount);
		sql.append(" and a.num<=");
		sql.append(Integer.parseInt(row)*pagecount);
		//System.out.println("查询地区sql====>"+sql.toString()) ;

		try {
			_dac.beginTransaction(10000);
			dt = _dac.executeQuery(sql.toString());
			_dac.endTransaction(true);
			
		}
		catch (Exception ex) {
			FileLogger.getLogger().debug(ex);
			try {
				_dac.endTransaction(false);
			}
			catch (Exception ex1) {
			}
		}
		return dt;
	}
	//
	public int getBusinessinfoCount(String area,String city) {
		try {
			
			if(area==null||area.equals("null")||area.equals("")){area="";}
			else{ area="and b.areacode='"+area+"'";}
			if(city==null|city.equals("null")||city.equals("")){city="";}
			else{city=" and b.citycode='"+city+"'";}
			int count = 0;
			int pageNum = 0;
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select count(*) cnt from td_businessinfo a,td_area b " );
			sql.append(" where  a.areacode=b.areacode ");
			sql.append(city);
			sql.append(area);
			//System.out.println("页数sql==>"+sql.toString());
			dt = _dac.executeQuery(sql.toString());
			for(int i=0;i<dt.getRows().getCount();i++){
				count = Integer.parseInt(dt.getRow(i).getString("cnt"));
			}
			if((count%pagecount)==0){
				pageNum = count/pagecount;
			}
			else{
				pageNum = count/pagecount+1;
			}
			return pageNum;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}

	public DataTable getInfo(String city,String area,int row) //获得信息列表
	{
		DataTable dt=null;
		String sql="select * from (select a.businessinfoid,b.areaname,a.name ,a.relationtel,rownum num from "+
		"td_businessinfo a,td_area b where a.areacode=b.areacode";
		if (!area.equals("")&&area!=null)
			sql += " and b.citycode = ?";
		if (!city.equals("")&&city!=null)
			sql += " and a.areacode = ?";
		sql += ") a where a.num>"+(row-1)*pagecount+" and a.num<="+row*pagecount;
		Object[] _object= null;

		if (!city.equals("")&&city!=null&&!area.equals("")&&area!=null){
			_object = new Object[2];
			_object[0]=city;
			_object[1]=area;
		}
		else if (!city.equals("")&&city!=null){
			_object = new Object[1];
			_object[0]=city;
		}
		else if (!area.equals("")&&area!=null){
			_object = new Object[1];
			_object[0]=area;
		}

		try {
			FileLogger.getLogger().debug("dddddddddddddd:[ "+sql+" ]");
			_dac.beginTransaction(10000);
			dt = _dac.executeQuery(sql, _object);
			_dac.endTransaction(true);
			FileLogger.getLogger().debug(_object[0]);
		}
		catch (Exception ex) {
			FileLogger.getLogger().debug(ex);
			try {
				_dac.endTransaction(false);
			}
			catch (Exception ex1) {
			}
		}
		return dt;
	}
	public DataRow getparticularInfo(String id)//获得详细信息
	{
		DataTable dt=null;
		DataRow dr=null;
		String sql="select a.businessinfoid,a.businesstime,a.address,a.transact,a.sale,a.commission,a.maintain,a.otherbusiness,a.fax,a.publicbus,a.business "+
		",b.areaname,b.areacode,a.name ,a.relationtel from td_businessinfo a,td_area b "+
		"where a.areacode=b.areacode and a.businessinfoid=?";
		Object[] _object=new Object[1];
		_object[0]=id;
		try {
			_dac.beginTransaction(10000);
			dt = _dac.executeQuery(sql, _object);
			_dac.endTransaction(true);
			dr=dt.getRow(0);
		}
		catch (Exception ex) {
			FileLogger.getLogger().debug(ex);
			try {
				_dac.endTransaction(false);
			}
			catch (Exception ex1) {
			}
			return null;
		}

		return dr;
	}

	/**修改营业厅
	 * auther=张怡
	 * @return
	 */
	public String updateInfo()
	{
		String valiInfo = "0";
		try {
			/*StringBuffer sql = new StringBuffer();
			sql.append("update ");
			sql.append(" td_businessinfo ");
			sql.append(" set ");
			sql.append(" AREACODE=?,");
			sql.append(" NAME=?,");
			sql.append(" RELATIONTEL=?,");
			sql.append(" BUSINESSTIME=?,");
			sql.append(" ADDRESS=?,");
			sql.append(" TRANSACT=?,");
			sql.append(" SALE=?,");
			sql.append(" COMMISSION=?,");
			sql.append(" MAINTAIN=?,");
			sql.append(" OTHERBUSINESS=?,");
			sql.append(" FAX=?,");
			sql.append(" PUBLICBUS=?,");
			sql.append(" BUSINESS=?");			
			sql.append(" where BUSINESSINFOID=?");
			Object[] aParam = new Object[9];
                        String areacode = this.getAreaCode();
			aParam[0] = areacode;
			aParam[1] = this.getname();
			aParam[2] = this.getRelationTel();
			aParam[3] = this.getBusinessTime();
			aParam[4] = this.getAddress();
			aParam[5] = this.getTransact();
			aParam[6] = this.getSale();
			aParam[7] = this.getCommission();
			aParam[8] = this.getMainTain();
			aParam[9] = this.getOtherBusiness();
			aParam[5] = this.getfax();
			aParam[6] = this.getpublicbus();
			aParam[7] = this.getbusiness();