yfjzinfo.java.svn-base

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

package com.chis.model.etjz;

import java.util.List;

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

/**
 * 儿童计划预防接种查看或修改初始化
 * 
 * @author zxh
 * 
 */
public class YfjzInfo extends ActionInstance {

	@Override
	public int execute(ActionForm af) throws Exception {
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE")
				.toString();
		String id = af.getHttpRequest().getParameter("id").toString();
		String CMD = af.getHttpRequest().getParameter("CMD").toString();

		DataForm df = new DataForm("MY_YFJZ", "ID");
		df.set("ID", id);
		StringBuffer sbsql = new StringBuffer();
		sbsql.append("select  a.*,b.MYZPDM,b.MYZPMC,b.ZC,b.ZC,b.MYLX,b.SL,b.YL, \n" +
				"c.JMJKDAH,c.JMXM,c.XB,(datediff(yy,c.CSRQ,getdate())+1) NL \n ");
		sbsql.append("from MY_YFJZ a  \n");
		sbsql.append("left join MY_JHMY b on a.ETJHMY_ID=b.ID \n");
		sbsql.append("left join DA_RKXZL c on a.JMJKDAH=c.JMJKDAH \n");
		sbsql.append("WHERE 1=1 and a.CORP_CODE='"+corp_code+"' \n" +
				" and a.ID='"+id+"' ");
		

		List yfjz_list = DaoUtil.select(af.getConnection(),sbsql.toString(),df);
		DataForm yfjz=(DataForm)yfjz_list.get(0);

		af.getHttpRequest().setAttribute("yfjz", yfjz);

		if (CMD.equals("L")) {
			return 0;
		} else {
			
			//查询 出接种种类  接种医生姓名
			
			return 1;
		}

	}

}