conferencemanageimpl.java

sso呵呵

package com.mdcl.mocha.jlcmcc.conferenceManager.dao.daoImpl;

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

import org.apache.log4j.Logger;

import com.mdcl.mocha.jlcmcc.conferenceManager.bean.BaseActionForm;
import com.mdcl.mocha.jlcmcc.conferenceManager.bean.MeetingInfo;
import com.mdcl.mocha.jlcmcc.conferenceManager.bean.MeetingUseInfoBean;
import com.mdcl.mocha.jlcmcc.conferenceManager.dao.IConferenceManage;
import com.mdcl.mocha.jlcmcc.conferenceManager.sqlConfig.ISqlConfig;
import com.mdcl.mocha.jlcmcc.conferenceManager.sqlConfig.sqlImpl.SqlConfigImpl;

public class ConferenceManageImpl implements IConferenceManage{

	/**
	 * Logger for this class
	 */
	private static final Logger S_LOGGER = Logger
			.getLogger(ConferenceManageImpl.class);


	/**查询所有会议室信息
	 * @param baseForm
	 * @return List
	 */
	public List queryMeetingInfo(){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfo()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append("select t.id,t.name,t.is_medium,t.hold_peoples,t.equipment,t.note ")
		.append("from meeting_info t");
		//数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		List re_List = isqlconfig.queryAllMeetingInfo(sql,null) == null ? new ArrayList():
			isqlconfig.queryAllMeetingInfo(sql,null);
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfo()<<<<<<<<<");
		}
		return re_List;
	}
	/**根据会议室名称查询会议室信息
	 * @param baseForm
	 * @return List
	 */
	public MeetingInfo queryMeetingInfoByName(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfoByName()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append("select t.id,t.name,t.is_medium,t.hold_peoples,t.equipment,t.note ")
		.append("from meeting_info t where t.name = ?");
		//参数设定
		List paramList = new ArrayList();
		paramList.add(baseForm.getName());
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfoByName()<<<<<<<<<");
		}
		return isqlconfig.queryAllMeetingInfoSingle(sql,paramList);
	}
	/**根据会议室id查询会议室信息
	 * @param baseForm
	 * @return List
	 */
	public MeetingInfo queryMeetingInfoById(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfoById()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append("select t.id,t.name,t.is_medium,t.hold_peoples,t.equipment,t.note ")
		.append("from meeting_info t where t.id = ?");
		//参数设定
		List paramList = new ArrayList();
		paramList.add(baseForm.getMetting_id());
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfoById()<<<<<<<<<");
		}
		return isqlconfig.queryAllMeetingInfoSingle(sql,paramList);
	}
	/**根据会议室名称查询会议室信息(排除指定id的会议室信息)
	 * @param baseForm
	 * @return List
	 */

	public MeetingInfo queryMeetingInfoByNameExpId(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfoByNameExpId()>>>>>>");
		}
		//sql 语句
		StringBuffer sql = new StringBuffer();
		sql.append("select t.id,t.name,t.is_medium,t.hold_peoples,t.equipment,t.note ")
		.append("from meeting_info t where t.name = ?");
		//参数设定
		List paramList = new ArrayList();
		paramList.add(baseForm.getName());
		if(baseForm.getMetting_id() != null && !"".equals(baseForm.getMetting_id())){
			sql.append(" and t.id <> ?");
			paramList.add(baseForm.getMetting_id());
		}
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.queryMeetingInfoByNameExpId()<<<<<<<<<");
		}
		return isqlconfig.queryAllMeetingInfoSingle(sql,paramList);
	}
	/** 新增会议室信息
	 * @param baseForm
	 */
	public void createNewMeetingInfo(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.createNewMeetingInfo()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append("insert into meeting_info(id,name,is_medium,hold_peoples,equipment,note)")
		.append("values(meeting_useinfo_sequence.nextval,?,?,?,?,?)");
		//参数设定
		List paramList = new ArrayList();
		paramList.add(baseForm.getName());
		paramList.add(baseForm.getIs_medium());
		paramList.add(baseForm.getHold_peoples());
		paramList.add(baseForm.getEquipment());
		paramList.add(baseForm.getMetting_note());
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		isqlconfig.changeInfo(sql,paramList );
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.createNewMeetingInfo()<<<<<<<<<");
		}

	}
	/** 更改会议室信息
	 * @param baseForm
	 */
	public void updateNewMeetingInfo(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.updateNewMeetingInfo()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append(" update meeting_info set name=?,is_medium =?,hold_peoples=?,equipment=?,note=?")
		.append("where id = ?");
		//参数设定
		List paramList = new ArrayList();
		paramList.add(baseForm.getName());
		paramList.add(baseForm.getIs_medium());
		paramList.add(baseForm.getHold_peoples());
		paramList.add(baseForm.getEquipment());
		paramList.add(baseForm.getMetting_note());
		paramList.add(baseForm.getMetting_id());
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		isqlconfig.changeInfo(sql,paramList );
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.updateNewMeetingInfo()<<<<<<<<<");
		}

	}

	/** 根据会议室id删除会议室信息
	 * @param baseForm
	 */
	public void deleteMeetingInfo(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.deleteMeetingInfo()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append(" delete from meeting_info where id=?");
		//参数设置
		List paramList = new ArrayList();
		paramList.add(baseForm.getMetting_id());
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		isqlconfig.changeInfo(sql,paramList );
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.deleteMeetingInfo()<<<<<<<<<");
		}
	}

	/** 新增会议使用信息
	 * @param baseForm
	 */
	public void createNewMeetingUseInfo(BaseActionForm baseForm){

		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.createNewMeetingUseInfo()>>>>>>");
		}
		//sql语句
		StringBuffer sql = new StringBuffer();
		sql.append("insert into meeting_useinfo(id, user_id , user_name , dept_id , dept_name,draft_time,")
		.append("contact_phone,exigency,start_time,end_time,present_num,meetingroom_id,meeting_content,note,flow_id)")
		.append("values(meeting_useinfo_sequence.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
		//参数设置
		List paramList = new ArrayList();
		paramList.add(baseForm.getUser_id());
		paramList.add(baseForm.getUser_name());
		paramList.add(baseForm.getDept_id());
		paramList.add(baseForm.getDept_name());
		paramList.add(baseForm.getDraft_time());
		paramList.add(baseForm.getContact_phone());
		paramList.add(baseForm.getExigency());
		paramList.add(baseForm.getStart_time());
		paramList.add(baseForm.getEnd_time());
		paramList.add(baseForm.getPresent_num());
		paramList.add(baseForm.getMetting_id());
		paramList.add(baseForm.getMeeting_content());
		paramList.add(baseForm.getNote());
		paramList.add(baseForm.getFlow_id());
//		数据库操作实体
		ISqlConfig isqlconfig = new SqlConfigImpl();
		isqlconfig.changeInfo(sql,paramList );
		if (S_LOGGER.isDebugEnabled()) {
			S_LOGGER.debug("ConferenceManageImpl.createNewMeetingUseInfo()<<<<<<<<<");
		}
	}
	/** 更改会议室使用信息