WagepayController.java

package net.loyin.controller;

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

import net.loyin.interceptor.ManagerPowerInterceptor;
import net.loyin.jFinal.anatation.RouteBind;
import net.loyin.model.Organization;
import net.loyin.model.Partment;
import net.loyin.model.Wagepay;

import com.jfinal.aop.Before;
import com.jfinal.plugin.activerecord.Db;

/**
 * 员工工资发放
 * @author loyin
 * 2012-10-1
 */
@RouteBind(path = "/wagepay")
@Before({ ManagerPowerInterceptor.class })
public class WagepayController extends BaseController {
	private static String navTabId="wagepay";
	private boolean f;
	public void index() {
		f = true;
		list();
		setAttr("org",Organization.dao.find("select id, name,num from Organization order by id"));
		setAttr("part",Partment.dao.find("select id, name,num from Partment order by id"));
		render("index.html");
	}

	public void list() {
		StringBuffer whee=new StringBuffer(" where 1=1 ");
		List<Object> param=new ArrayList<Object>();
		String name=getPara("name");
		if(name!=null&&!"".equals(name.trim())){
			whee.append(" and name like ?");
			param.add("%"+name+"%");
		}
		String type=getPara("type");
		if(type!=null&&!"".equals(type.trim())){
			whee.append(" and type = ?");
			param.add("%"+type+"%");
		}
		setAttr("type", type);
		setAttr("name", name);
		setAttr("page", Db.paginate(getParaToInt("pageNum", 1),
							getParaToInt("numPerPage", 20),
				"select w.id,concat(e.fullname,'[',e.userno,']') 员工,w.amount 实发工资金额（元）,concat(w.sdate,'至',w.edate) 工资结算日期,w.paydate 发放日期,concat(e1.fullname,'[',e1.userno,']') 操作员 ",
				" from  wagepay w join employee e join employee e1 on w.empid=e.id and e1.id=w.operater "+whee.toString()+" order by w.id desc",param.toArray()));
		setAttr("collist", new String[]{"员工","实发工资金额（元）","工资结算日期","发放日期","操作员 "});
		if (f == false)
			render("list.html");
	}
	public void add() {
		Long id = getParaToLong(0, 0L);
		Wagepay systemparam=new Wagepay();
		if(id!=null&&id!=0){
			systemparam=Wagepay.dao.findById(id);
		}
		setAttr("pojo",systemparam);
		render("add.html");
	}
	public void save() {
		
		try{
			Wagepay m=getModel(Wagepay.class);
			if(m.getLong("id")!=null){
				m.update();
			}else{
				m.save();
			}
			toDwzJson(200, "保存成功！", navTabId);
		}catch(Exception e){
			toDwzJson( 300, "保存异常！");
		}
		
	}
	
	public void del() {
		Wagepay.dao.deleteById(getParaToLong(0, 0L));
		toDwzJson( 200, "删除成功！", navTabId);
	}
}