myyjlistpage.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 MyyjListPage extends ActionInstance {

	@Override
	public int execute(ActionForm af) throws Exception {
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE")
				.toString();
		String YJTS = af.getHttpRequest().getParameter("YJTS");
		int num = 0;
		try {
			num = Integer.parseInt(YJTS);

			int currentpage = 0;
			int pagesize = 15;

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

			sbsql
					.append("select *,convert(varchar(10),(CSRQ+HSTS),23) as XJZSJ \n from ( \n");

			// 拼凑SQL语句和PATH路径
			sbsql
					.append("select a.ID as MYKID,b.ID as JHMYID,c.ID as YFJZID,d.ID as RKXZLID, \n");
			sbsql
					.append(" a.MYKBH,d.JMJKDAH,d.JMXM,d.XB,b.SL,b.YL,b.MYZPMC,b.ZC,b.YXTS, \n");
			sbsql
					.append("((year(getdate())-year(d.CSRQ))+1) as NL,d.CSRQ,b.HSTS,getdate() as DATA");
			sbsql.append(" 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("WHERE 1=1 and a.CORP_CODE='" + corp_code + "' \n");
			sbsql.append(" and a.ZT=0 ");

			sbsql.append(") as temp \n");
			sbsql.append("where (YFJZID is null or YFJZID ='') \n");
			if (!(YJTS == null) && !YJTS.equals("")) {
				sbsql.append(" and datediff(d,CSRQ,getdate()) >=HSTS-" + num
						+ " \n");
			}

			sbsql.append("  order by JHMYID 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("YJTS", YJTS);
			af.getHttpRequest().setAttribute("yfjz_list", list);
			af.getHttpRequest().setAttribute("num",
					pageUtil.getContext().size());
			af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
			return 1;
		} catch (Exception e) {
			af.getHttpRequest().setAttribute("result", "预警天数只能为数字");
			return 0;
		}
	}

}