package com.vci.server.framework.systemConfig.specialcharclsf;


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

import org.hibernate.HibernateException;

import com.vci.server.base.persistence.dao.BaseService;
import com.vci.server.base.persistence.dao.HibernateCallback;
import com.vci.server.base.persistence.dao.HibernateTemplate;
import com.vci.server.base.persistence.dao.JDBCCallback;
import com.vci.server.base.persistence.dao.JDBCRunType;
import com.vci.server.base.persistence.dao.JDBCTemplate;
import com.vci.server.framework.systemConfig.specialchar.SpecialCharDAOImpl;


/**
 * 处理特殊字符分类的增、删、改、查操作
 * @author Administrator
 *
 */
public class SpecialCharClsfService extends BaseService{
	
	//特殊字符分类（操作模块）
	private final String SPECIALCHARCLSF = "com.vci.rmip.framework.client.systemConfig.specialCharacter.SpecialCharacterClsPanel";
	/**
	 * 
	 * <p>Description:保存特殊字符分类 </p>
	 * @author sunbo
	 * @time 2012-5-25
	 * @param clsf
	 */
	public void saveSpecialCharClsf(final SpecialCharClsf clsf) {
		new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				userEntity.setModule(SPECIALCHARCLSF);
				clsf.setUserEntity(userEntity);
				impl.save(clsf);
				return clsf;
			}
		});
	}
	/**
	 * 
	 * <p>Description:更新特殊字符分类</p>
	 * @author sunbo
	 * @time 2012-5-25
	 * @param clsf
	 */
	public void updateSpecialCharClsf(final SpecialCharClsf clsf) {
		new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				SpecialCharClsf curClsf = impl.loadById(clsf.getId());
				curClsf.setName(clsf.getName());
				curClsf.setDesc(clsf.getDesc());
				userEntity.setModule(SPECIALCHARCLSF);
				curClsf.setUserEntity(userEntity);
				impl.saveOrUpdate(curClsf);
				return clsf;
			}
		});
	}
	
	
	/**
	 * 获取所有特殊字符分类
	 * @return
	 */
	public List getSpecialCharClsfList(final int pageNo,final int pageSize) {
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				
				int V_PAGE_ROWNUM_START = (pageNo - 1) * pageSize;
		        int V_PAGE_ROWNUM_END = (pageNo ) * pageSize;
				
				StringBuffer sb = new StringBuffer();
				sb.append(" SELECT * ");
				sb.append("   FROM (SELECT ROW_.*, ROWNUM RN ");
				sb.append("      FROM (SELECT * FROM PLSPECCHARCLSF S ORDER BY S.PLNAME ");
				sb.append("  )ROW_)");
				sb.append("   WHERE RN <= ");
				sb.append( V_PAGE_ROWNUM_END);
				sb.append(" AND RN > ");
				sb.append(V_PAGE_ROWNUM_START);
				
				Object[] values = new Object[0];
				List<SpecialCharClsf> list = impl.findEntites(sb.toString(), values, "S", SpecialCharClsf.class);
				return list;
				
			}
		});
	}
	public List getbyChar(final String plscsfoId){
		
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				
				String sql = " from SpecialChar  s where s.parentId='"+plscsfoId+"'";
				return impl.findEntites(sql, new String[0]);
				
			}
		});
	}
	@SuppressWarnings("rawtypes")
	public List getSpecialCharClsfList() {
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				
				String sql = " from SpecialCharClsf S ORDER BY S.name";
				return impl.findEntites(sql, new String[0]);
				
			}
		});
	}
	
	/**
	 * 获取所有特殊字符分类总数
	 * @return
	 */
	public int getSpecialCharClsTotal() {
		int res = 0;
		String sql = "SELECT COUNT(*) FROM PLSPECCHARCLSF ";
		res = (Integer)new JDBCTemplate().run(new JDBCCallback(
				new HibernateTemplate().getSessionConnection(), 
				sql, JDBCRunType.SQL, 0, false, false,new Object[]{}) {
			@Override
			public Object execute(ResultSet rst) throws SQLException {
				int ress = 0;
				while(rst.next()){
					ress = rst.getInt(1);
					
				}
				return ress;
			}
		});
		return res;
	}

	
	/**
	 * 根据ID删除特殊字符分类
	 * @param id
	 * @return
	 */
	public boolean deleteSpecialCharClsfByHQL(final String id) {
		return (Boolean)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				SpecialCharClsf curClsf = impl.loadById(id);
				curClsf.setUserEntity(userEntity);
				impl.delete(curClsf);
				return true;
			}
		});
	}
	/**
	 * 
	 * <p>Description: 批量删除特殊字符分类</p>
	 * 
	 * @author sunbo
	 * @time 2012-5-25
	 * @param ids
	 * @return
	 */
	public boolean deleteSpecialCharClsfByHQL(final String[] ids) {
		return (Boolean)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				String hql = "delete SpecialCharClsf where PLOID in (";
				int len = ids.length;
				for (int i = 0; i < len; i++) {
					hql += "?";
					if (i != len - 1) {
						hql += ",";
					}
				}
				hql += ")";
				userEntity.setModule(SPECIALCHARCLSF);
				impl.createQuery(hql, ids);
				
				SpecialCharDAOImpl charImpl = new SpecialCharDAOImpl();
				String charHql = "delete SpecialChar sc where PLPARENTID in (";
				
				for (int i = 0; i < len; i++) {
					charHql += "?";
					if (i != len - 1) {
						charHql += ",";
					}
				}
				charHql += ")";
				charImpl.createQuery(charHql, ids);
				return true;
			}
		});
	}
	
	/**
	 * 根据指定ID获取对应的分类信息
	 * @param id
	 * @return
	 */
	public SpecialCharClsf selectSpecialCharClsfById(final String id) {
		return (SpecialCharClsf)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				return impl.loadById(id);
			}
		});
	}
	
//	/**
//	 * 根据指定ID，获取其子节点的分类信息
//	 * @param parentId
//	 * @return
//	 */
//	public List selectSpecialCharClsfByParent(final String parentId) {
//		return (List)new HibernateTemplate().run(new HibernateCallback() {
//			public Object execute() throws HibernateException {
//				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
//				String hsql = "from SpecialCharClsf clsf where PLPARENTID = :parentId order by clsf.name";
//				return impl.findEntities(hsql, "parentId", parentId);
//			}
//		});
//	}
	
	/**
	 * 获得指定名称的分类
	 * @param name
	 * @return
	 */
	public SpecialCharClsf selectSpecialCharClsfByName(final String name) {
		return (SpecialCharClsf)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				SpecialCharClsfDAOImpl impl = new SpecialCharClsfDAOImpl();
				String hsql = "from SpecialCharClsf clsf where clsf.name = ?";
				String[] values = new String[1];
				values[0] = name;
				return impl.findEntity(hsql, values);
			}
		});
	}
}