yfjzlistpage.java.svn-base

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

package com.chis.model.etjz;

import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.dao.PageUtil;
import com.stframe.form.ActionForm;
import com.stframe.servlet.ActionInstance;

/**
 * 儿童计划预防接种分页列表
 * 
 * @author zxh
 * 
 */
public class YfjzListPage extends ActionInstance {

	@Override
	public int execute(ActionForm af) throws Exception {
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE")
				.toString();
		String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
		String NAME = af.getHttpRequest().getParameter("NAME");
		String YMMC = af.getHttpRequest().getParameter("YMMC");
		String SFJZ = af.getHttpRequest().getParameter("SFJZ");
		String ZC = af.getHttpRequest().getParameter("ZC");
		String MYLX = af.getHttpRequest().getParameter("MYLX");
		int currentpage = 0;
		int pagesize = 15;

		StringBuffer sbsql = new StringBuffer();
		StringBuffer sbpath = new StringBuffer();

		// 拼凑SQL语句和PATH路径
		sbsql
				.append("select b.ID as JHMYID,a.ID as MYKID,((year(getdate())-year(d.CSRQ))+1) as NL,*, \n" +
						"c.ID as YFJZID,c.PTJZXM as PTJZXM,convert(varchar(10),c.SJJZSJ,23) as YFJZSJJZSJ,\n ");
		sbsql.append(" e.ID as YCFYID from MY_MYK a \n ");
		sbsql.append(" join MY_JHMY b on 1=1  \n");
		sbsql
				.append(" left join MY_YFJZ c on c.ETJHMY_ID=b.ID  and c.JMJKDAH=a.JMJKDAH   \n");
		sbsql.append(" join DA_RKXZL d on a.JMJKDAH=d.JMJKDAH \n");
		sbsql.append("left join MY_YCFYJL e on e.YFJZ_ID=c.ID \n");
		sbsql.append("WHERE 1=1 and a.CORP_CODE='" + corp_code + "' \n");
		sbsql.append(" and a.ZT=0 ");
		if (!(JMJKDAH == null) && !JMJKDAH.equals("")) {
			sbsql.append(" and d.JMJKDAH='" + JMJKDAH + "'");
		}
		if (NAME != null && !NAME.equals("")) {
			sbsql.append(" and d.JMXM like '%" + NAME + "%'");
		}
		if (YMMC != null && !YMMC.equals("")) {
			sbsql.append(" and b.MYZPMC like '%" + YMMC + "%'");
		}
		if (ZC != null && !ZC.equals("")) {
			sbsql.append(" and b.ZC like '" + ZC + "'");
		}
		if (MYLX != null && !MYLX.equals("")) {
			sbsql.append(" and b.MYLX like '" + MYLX + "'");
		}
//		if (SFJZ != null && !SFJZ.equals("")) {
//			sbsql.append(" and d.JMXM='" + SFJZ + "'");
//		}
		sbsql.append("  order by c.CREATE_DATE,b.MYZPMC asc");

		sbpath.append(af.getHttpRequest().getContextPath()
				+ "/Selevet.do?action=Selevet.do?action=YFJZ_LIST_PAGE");

		try {
			currentpage = Integer.parseInt(af.getHttpRequest().getParameter(
					"currentpage"));
		} catch (Exception e) {
			currentpage = 1;
		}

		PageUtil pageUtil = (PageUtil) DaoUtil.selectPage(af.getConnection(),
				sbsql.toString(), currentpage, pagesize);
		pageUtil.setPath(sbpath.toString());
		List list = pageUtil.getContext();

		af.getHttpRequest().setAttribute("ZC", ZC);
		af.getHttpRequest().setAttribute("MYLX", MYLX);
		af.getHttpRequest().setAttribute("NAME", NAME);
		af.getHttpRequest().setAttribute("YMMC", YMMC);
		af.getHttpRequest().setAttribute("SFJZ", SFJZ);
		af.getHttpRequest().setAttribute("JMJKDAH", JMJKDAH);
		af.getHttpRequest().setAttribute("yfjz_list", list);
		af.getHttpRequest().setAttribute("num", pageUtil.getContext().size());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
		return 1;
	}

}