customerdisposedao.java.svn-base

本例使用Java + Jsp 实现选择树的过程,主要使用Struts+JDBC/hibernate架构

/*
 * $Workfile: CustomerDisposeDAO.java$ 
 * Copyright (c) 2007 Jama, International.
 * All rights reserved.
 * Creator kay
 * Last Changed by: $Author: kay$ 
 * On: $Date: 2007-8-29 上午09:05:59$ 
 * $Revision: 1$ 
 */

package com.jama.rcrm.service.dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;

import com.jama.common.base.BaseDAO;
import com.jama.common.taglib.QueryInfo;
import com.jama.rcrm.service.ServiceConstants;
import com.jama.rcrm.service.business.dto.CustomDisposeDTO;
import com.jama.rcrm.service.dao.pojo.TSerTasks;

public class CustomerDisposeDAO
		extends BaseDAO
{
	/**
	 * 添加任务分解记录
	 * @param customDisposerdto
	 * @throws Exception
	 */
	public void addTask(CustomDisposeDTO customDisposerdto) throws Exception
	{
		TSerTasks tsertasks = new TSerTasks();
		//	由DTO转换为POJO
		this.customDisposeDtoTOTSerTasks(customDisposerdto, tsertasks);
		super.getSession().save(tsertasks);
	}
	/**
	 * 修改任务分解记录
	 * @param customDisposerdto
	 * @throws Exception
	 */
	public void updateTask(CustomDisposeDTO customDisposerdto) throws Exception
	{
		TSerTasks tsertasks = new TSerTasks();
		//	由DTO转换为POJO
		this.customDisposeDtoTOTSerTasks(customDisposerdto, tsertasks);
		super.getSession().update(tsertasks);
	}
	/**
	 * 根据投诉处理id获得该记录被分解次数
	 * @param taskGuid 投诉处理ID
	 * @return
	 */
	public int getLevelNo(String taskGuid) throws Exception
	{
		String sql = "select tt.level_no from t_ser_tasks tt where tt.task_guid = '"+ taskGuid +"'";
		Object obj = this.getSession().createSQLQuery(sql).uniqueResult();
		return Integer.parseInt(obj.toString());
	}
	/**
	 * 根据投诉处理Guid获得记录
	 * @param task_guid 投诉处理Guid
	 * @return
	 * @throws Exception
	 */
	public CustomDisposeDTO getTasksById(String task_guid) throws Exception
	{
		
		String sql = " select " 
			+" tser.task_guid, tser.advise_guid, "
			+" tser.task_description,"
			+" tser.org_guid,o.name,"
			+" tser.duty_user_guid,p.name as person,"
			+" tser.tel_phone,tser.date_limit,"
		    +" tser.process,tser.dispose_mind,"
			+" tser.parent_task_guid,tser.level_no,"
			+" tser.dispose_result,tser.dispose_date_type,"
			+" tser.dispose_date,tser.use_material,"
			+" tser.material_amount,tser.reason,"
			+" tser.customer_return "
			+" from t_ser_tasks tser "
			+" left join t_sys_orgnization o on tser.org_guid = o.id "
			+" left join t_sys_orgnization p on tser.duty_user_guid = p.id "
			+" where tser.task_guid = '"+ task_guid +"'";
		Query query = super.getSession().createSQLQuery(sql);
		List tempList = query.list();
		Object[] obj = null;
		CustomDisposeDTO dto = new CustomDisposeDTO();
		for(int i = 0; i < tempList.size() ; i++)
		{
			obj = (Object[]) tempList.get(i);
			dto.setTaskGuid(obj[0] != null ? obj[0].toString() : "");
			dto.setAdviceGuid(obj[1] != null ? obj[1].toString() : "");
			dto.setTaskDescription(obj[2] != null ? obj[2].toString() : "");
			dto.setOrgGuid(obj[3] != null ? obj[3].toString() : "");
			dto.setOrgName(obj[4] != null ? obj[4].toString() : "");
			dto.setDutyUserGuid(obj[5] != null ? obj[5].toString() : "");
			dto.setDutyUserName(obj[6] != null ? obj[6].toString() : "");
			dto.setTelPhone(obj[7] != null ? obj[7].toString() : "");
			dto.setDateLimit(obj[8] != null ? Long.parseLong(obj[8].toString()) : 0);
			dto.setProcess(obj[9] != null ? Long.parseLong(obj[9].toString()) : 0);
			//设置任务处理状态
			if(obj[9] != null)
			{
				dto.setProcessStatus(ServiceConstants.STATUS_STRING[Integer.parseInt(obj[9].toString())]);
			}
			else
			{
				dto.setProcessStatus("");
			}
			dto.setDisposeMind(obj[10] != null ? obj[10].toString() : "");
			dto.setParentTaskGuid(obj[11] != null ? obj[11].toString() : "");
			dto.setLevelNo(obj[12] != null ? Long.parseLong(obj[12].toString()) : 0);
			dto.setDisposeResult(obj[13] != null ? obj[13].toString() : "");
			dto.setDisposeDateType(obj[14] != null ? Long.parseLong(obj[14].toString()) : 0);
			//设置处理时间分类
			if(obj[14]!=null)
			{
				dto.setDisposeDateTypeString(ServiceConstants.DATE_TYPE[Integer.parseInt(obj[14].toString())]);
			}
			else
			{
				dto.setDisposeDateTypeString("");
			}
			dto.setDisposeDate(obj[15] != null ? Long.parseLong(obj[15].toString()) : 0);
			dto.setUseMaterial(obj[16] != null ? obj[16].toString() : "");
			dto.setMaterialAmount(obj[17] != null ? Double.parseDouble(obj[17].toString()) : 0);
			dto.setReason(obj[18] != null ? obj[18].toString() : "");
			dto.setCustomerReturn(obj[19]!= null ? obj[19].toString() : "");
		}
		
		return dto;
	}
	
	/**
	 * 根据投诉登记Guid获得记录
	 * @param adviseguid 投诉登记 adbise_Guid
	 * @return
	 * @throws Exception
	 */
	public List findByAdviseGuid(String adviseguid) throws Exception
	{
		List<CustomDisposeDTO> dtoList = new ArrayList<CustomDisposeDTO>();
		String sql = " select " 
			+" tser.task_guid, tser.advise_guid, "
			+" tser.task_description,"
			+" tser.org_guid,o.name,"
			+" tser.duty_user_guid,p.name as person,"
			+" tser.tel_phone,tser.date_limit,"
		  +" tser.process,tser.dispose_mind,"
			+" tser.parent_task_guid,tser.level_no,"
			+" tser.dispose_result,tser.dispose_date_type,"
			+" tser.dispose_date,tser.use_material,"
			+" tser.material_amount,tser.reason,"
			+" tser.customer_return "
			+" from t_ser_tasks tser "
			+" left join t_sys_orgnization o on tser.org_guid = o.id "
			+" left join t_sys_orgnization p on tser.duty_user_guid = p.id "
			+" where tser.advise_guid = '"+ adviseguid +"'"
			+" start with (tser.task_guid = '0') "
			+" connect by prior tser.task_guid = tser.parent_task_guid ";
		Query query = super.getSession().createSQLQuery(sql);
		List tempList = query.list();
		Object[] obj = null;
		
		dtoList.clear();
		for(int i = 0; i < tempList.size() ; i++)
		{
			obj = (Object[]) tempList.get(i);
			CustomDisposeDTO dto = new CustomDisposeDTO();
			dto.setTaskGuid(obj[0] != null ? obj[0].toString() : "");
			dto.setAdviceGuid(obj[1] != null ? obj[1].toString() : "");
			dto.setTaskDescription(obj[2] != null ? obj[2].toString() : "");
			dto.setOrgGuid(obj[3] != null ? obj[3].toString() : "");
			dto.setOrgName(obj[4] != null ? obj[4].toString() : "");
			dto.setDutyUserGuid(obj[5] != null ? obj[5].toString() : "");
			dto.setDutyUserName(obj[6] != null ? obj[6].toString() : "");
			dto.setTelPhone(obj[7] != null ? obj[7].toString() : "");
			dto.setDateLimit(obj[8] != null ? Long.parseLong(obj[8].toString()) : 0);
			dto.setProcess(obj[9] != null ? Long.parseLong(obj[9].toString()) : 0);
			//设置任务处理状态
			if(obj[9] != null)
			{
				dto.setProcessStatus(ServiceConstants.STATUS_STRING[Integer.parseInt(obj[9].toString())]);
			}
			else
			{
				dto.setProcessStatus("");
			}
			dto.setDisposeMind(obj[10] != null ? obj[10].toString() : "");
			dto.setParentTaskGuid(obj[11] != null ? obj[11].toString() : "");
			dto.setLevelNo(obj[12] != null ? Long.parseLong(obj[12].toString()) : 0);
			dto.setDisposeResult(obj[13] != null ? obj[13].toString() : "");
			dto.setDisposeDateType(obj[14] != null ? Long.parseLong(obj[14].toString()) : 0);
			//设置处理时间分类
			if(obj[14]!=null)
			{
				dto.setDisposeDateTypeString(ServiceConstants.DATE_TYPE[Integer.parseInt(obj[14].toString())]);
			}
			else
			{
				dto.setDisposeDateTypeString("");
			}
			dto.setDisposeDate(obj[15] != null ? Long.parseLong(obj[15].toString()) : 0);
			dto.setUseMaterial(obj[16] != null ? obj[16].toString() : "");
			dto.setMaterialAmount(obj[17] != null ? Double.parseDouble(obj[17].toString()) : 0);
			dto.setReason(obj[18] != null ? obj[18].toString() : "");
			dto.setCustomerReturn(obj[19]!= null ? obj[19].toString() : "");
			dtoList.add(dto);
		}
		
		return dtoList;
	}
	/**
	 * 删除任务分解记录
	 * @param customDisposerdto
	 * @throws Exception
	 */
	public void delTask(CustomDisposeDTO customDisposerdto) throws Exception
	{
		TSerTasks tsertasks = new TSerTasks();
		//由DTO转换为POJO
		this.customDisposeDtoTOTSerTasks(customDisposerdto, tsertasks);
		super.getSession().delete(tsertasks);
	}
	/**
	 * 根据问题ID获得投诉ID
	 * @param task_guid
	 * @return
	 */
	public String getAdviseGuid(String task_guid) throws Exception
	{
		String sql = "select ser.advise_guid from t_ser_tasks ser where ser.task_guid='"+ task_guid +"'";
		Object result = super.getSession().createSQLQuery(sql).uniqueResult();
		return result.toString();
	}
	/**
	 * 获得记录总条数
	 * @return
	 * @throws Exception