bjll.zip

package com.topsuntech.gUnit.gUnit_bjll.gEU_jjylgl.service.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import org.jgroups.log.Format; import net.sf.hibernate.HibernateException; import com.opensymphony.util.DateUtil; import com.topsuntech.gOS.gPortal.page.Page; import com.topsuntech.gOS.query.DBWrapper; import com.topsuntech.gOS.query.TSDBException; import com.topsuntech.gUnit.gEU_util.dao.BJLLBaseDAO; import com.topsuntech.gUnit.gEU_util.dao.SJBaseDAO; import com.topsuntech.gUnit.gEU_util.tools.Constants; import com.topsuntech.gUnit.gEU_util.tools.Tools; import com.topsuntech.gUnit.gUnit_bjll.gEU_base.service.vo.AgBaOldBaseQueryBean; import com.topsuntech.gUnit.gUnit_bjll.gEU_jjylgl.entity.HomeFundSendInfo; import com.topsuntech.gUnit.gUnit_bjll.gEU_jjylgl.entity.HomeFundSendInfoHistory; import com.topsuntech.gUnit.gUnit_bjll.gEU_jjylgl.service.dao.HomeFundSendInfoDAO; import com.topsuntech.gUnit.gUnit_bjll.gEU_jjylgl.service.vo.HomeFundSendInfoQueryBean; public class HomeFundSendInfoDAOImpl extends BJLLBaseDAO implements HomeFundSendInfoDAO { static SJBaseDAO dao = new SJBaseDAO(); static DBWrapper db = dao.getDBWrapper(); public void addHomeFundSendInfo(HomeFundSendInfo homeFundSendInfo) throws TSDBException { addEntity(homeFundSendInfo); } public void updateHomeFundSendInfo(HomeFundSendInfo homeFundSendInfo) throws TSDBException { updateEntity(homeFundSendInfo); } public void deleteHomeFundSendInfo(HomeFundSendInfo homeFundSendInfo) throws TSDBException { deleteEntity(homeFundSendInfo); } public HomeFundSendInfo getHomeFundSendInfoById(Long id) throws TSDBException { return (HomeFundSendInfo) getEntity(HomeFundSendInfo.class, id); } public List queryHomeFundSendInfo(HomeFundSendInfoQueryBean homeFundSendInfoQueryBean, Page page) throws TSDBException { StringBuffer hql = new StringBuffer(); hql.append(" from HomeFundSendInfo t where 1 = 1"); if (homeFundSendInfoQueryBean != null) { if (homeFundSendInfoQueryBean.getId() != null && homeFundSendInfoQueryBean.getId().longValue() != 0) hql.append(" and t.id = ").append(homeFundSendInfoQueryBean.getId()); if (homeFundSendInfoQueryBean.getBaOldBaseInfoId() != null && homeFundSendInfoQueryBean.getBaOldBaseInfoId().longValue() != 0) hql.append(" and t.baOldBaseInfoId = ").append(homeFundSendInfoQueryBean.getBaOldBaseInfoId()); if (homeFundSendInfoQueryBean.getOpApOldHomeVouchersId() != null && homeFundSendInfoQueryBean.getOpApOldHomeVouchersId().longValue() != 0) hql.append(" and t.opApOldHomeVouchersId = ").append(homeFundSendInfoQueryBean.getOpApOldHomeVouchersId()); if (homeFundSendInfoQueryBean.getCityId() != null && homeFundSendInfoQueryBean.getCityId().longValue() != 0) hql.append(" and t.cityId = ").append(homeFundSendInfoQueryBean.getCityId()); if (homeFundSendInfoQueryBean.getCountyId() != null && homeFundSendInfoQueryBean.getCountyId().longValue() != 0) hql.append(" and t.countyId = ").append(homeFundSendInfoQueryBean.getCountyId()); if (homeFundSendInfoQueryBean.getStreetId() != null && homeFundSendInfoQueryBean.getStreetId().longValue() != 0) hql.append(" and t.streetId = ").append(homeFundSendInfoQueryBean.getStreetId()); if (homeFundSendInfoQueryBean.getCommunityId() != null && homeFundSendInfoQueryBean.getCommunityId().longValue() != 0) hql.append(" and t.communityId = ").append(homeFundSendInfoQueryBean.getCommunityId()); if (homeFundSendInfoQueryBean.getSendYear() != null && homeFundSendInfoQueryBean.getSendYear().longValue() != 0) hql.append(" and t.sendYear = ").append(homeFundSendInfoQueryBean.getSendYear()); if (homeFundSendInfoQueryBean.getSendQuarter() != null && homeFundSendInfoQueryBean.getSendQuarter().longValue() != 0) hql.append(" and t.sendQuarter =").append(homeFundSendInfoQueryBean.getSendQuarter()); if (homeFundSendInfoQueryBean.getSendMonth() != null && homeFundSendInfoQueryBean.getSendMonth().longValue() != 0) hql.append(" and t.sendMonth =").append(homeFundSendInfoQueryBean.getSendMonth()); if (homeFundSendInfoQueryBean.getSendCounty() != null && homeFundSendInfoQueryBean.getSendCounty().longValue() != 0) hql.append(" and t.sendCounty = ").append(homeFundSendInfoQueryBean.getSendCounty()); if (homeFundSendInfoQueryBean.getSenStreetId() != null && homeFundSendInfoQueryBean.getSenStreetId().longValue() != 0) hql.append(" and t.senStreetId = ").append(homeFundSendInfoQueryBean.getSenStreetId()); if (homeFundSendInfoQueryBean.getSenCommunityId() != null && homeFundSendInfoQueryBean.getSenCommunityId().longValue() != 0) hql.append(" and t.senCommunityId = ").append(homeFundSendInfoQueryBean.getSenCommunityId()); if (homeFundSendInfoQueryBean.getSubsidyType() != null && homeFundSendInfoQueryBean.getSubsidyType().longValue() != 0) hql.append(" and t.subsidyType = ").append(homeFundSendInfoQueryBean.getSubsidyType()); if (homeFundSendInfoQueryBean.getSendNumber() != null && homeFundSendInfoQueryBean.getSendNumber().longValue() != 0) hql.append(" and t.sendNumber = ").append(homeFundSendInfoQueryBean.getSendNumber()); if (homeFundSendInfoQueryBean.getSendMoney() != null && homeFundSendInfoQueryBean.getSendMoney().longValue() != 0) hql.append(" and t.sendMoney = ").append(homeFundSendInfoQueryBean.getSendMoney()); if (homeFundSendInfoQueryBean.getSendNextNumber() != null && homeFundSendInfoQueryBean.getSendNextNumber().longValue() != 0) hql.append(" and t.sendNextNumber = ").append(homeFundSendInfoQueryBean.getSendNextNumber()); if (homeFundSendInfoQueryBean.getSendNextMoney() != null && homeFundSendInfoQueryBean.getSendNextMoney().longValue() != 0) hql.append(" and t.sendNextMoney = ").append(homeFundSendInfoQueryBean.getSendNextMoney()); if (homeFundSendInfoQueryBean.getRemark() != null && !"".equals(homeFundSendInfoQueryBean.getRemark().trim())) hql.append(" and t.remark like '%").append(homeFundSendInfoQueryBean.getRemark()).append("%'"); if (homeFundSendInfoQueryBean.getTempSaveFlag() != null) hql.append(" and t.tempSaveFlag = ").append(homeFundSendInfoQueryBean.getTempSaveFlag()); if (homeFundSendInfoQueryBean.getModifyUserId() != null && homeFundSendInfoQueryBean.getModifyUserId().longValue() != 0) hql.append(" and t.modifyUserId = ").append(homeFundSendInfoQueryBean.getModifyUserId()); if (homeFundSendInfoQueryBean.getModifyDate() != null) hql.append(" and t.modifyDate = to_date('").append(homeFundSendInfoQueryBean.getModifyDate()).append("','yyyy-MM-dd')"); if (homeFundSendInfoQueryBean.getCreateDate() != null) hql.append(" and t.createDate = to_date('").append(homeFundSendInfoQueryBean.getCreateDate()).append("','yyyy-MM-dd')"); if (homeFundSendInfoQueryBean.getUseFlag() != null) hql.append(" and t.useFlag = ").append(homeFundSendInfoQueryBean.getUseFlag()); if (homeFundSendInfoQueryBean.getCreateUserId() != null && homeFundSendInfoQueryBean.getCreateUserId().longValue() != 0) hql.append(" and t.createUserId = ").append(homeFundSendInfoQueryBean.getCreateUserId()); if (homeFundSendInfoQueryBean.getReceiveState() != null && homeFundSendInfoQueryBean.getReceiveState().longValue() != 0) hql.append(" and t.receiveState = ").append(homeFundSendInfoQueryBean.getReceiveState()); if (homeFundSendInfoQueryBean.getReceiveDate() != null) hql.append(" and t.receiveDate = to_date('").append(homeFundSendInfoQueryBean.getReceiveDate()).append("','yyyy-MM-dd')"); if (homeFundSendInfoQueryBean.getSendName() != null && !"".equals(homeFundSendInfoQueryBean.getSendName().trim())) hql.append(" and t.sendName like '%").append(homeFundSendInfoQueryBean.getSendName()).append("%'"); if (homeFundSendInfoQueryBean.getSendIdCard() != null && !"".equals(homeFundSendInfoQueryBean.getSendIdCard(