dmlistserviceimpl.java

来自「本源码为教学管理信息系统」· Java 代码 · 共 53 行

/*
 * 创建日期 2005-9-29
 */
package com.wygl.dmwh.service;

import java.util.List;

import com.wygl.service.AbstractService;

/**
 * @author zmx
 * 
 * 显示下拉列表
 */
public class DmListServiceImpl extends AbstractService implements DmListService {
	//提取性别下拉列表
	public List getXbList() throws Exception{
		return dbDao.queryObjects("from SexCode as code where code.code <> '3' order by code.ct_id asc");
	}
	//	提取职务下拉列表
	public List getZwList() throws Exception{
		return dbDao.queryObjects("from Principalship as code order by code.ct_id asc");
	}
	//提取职权下拉列表
	public List getZqList() throws Exception{
		return dbDao.queryObjects("from Authority as code order by code.ct_id asc");
	}
	//提取级别下拉列表
	public List getJbList() throws Exception{
		return dbDao.queryObjects("from Level as code order by code.ct_id asc");
	}
	//提取状态下拉列表
	public List getZtList() throws Exception{
		return dbDao.queryObjects("from State as code order by code.ct_id asc");
	}
	//提取学历下拉列表
	public List getXlList() throws Exception{
		return dbDao.queryObjects("from SchoolAge as code order by code.ct_id asc");
	}
	//提取民族下拉列表
	public List getMzList() throws Exception{
		return dbDao.queryObjects("from Nation as code order by code.ct_id asc");
	}
    //提取储物柜类别下拉列表
	public List getCwgList() throws Exception{
		return dbDao.queryObjects("from BankType as code order by code.ct_id asc");
	}
	//通用获得下拉列表方法
	public List getxllb(String dmlb) throws Exception{	
		return  dbDao.queryObjects("from "+dmlb+" as code order by code.ct_id asc");
	}
}