yfjzadd.java.svn-base

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

package com.chis.model.etjz;

import com.chis.util.Dao;
import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 儿童计划预防接种添加初始化
 * @author zxh
 *
 */
public class YfjzAdd extends ActionInstance{

	@Override
	public int execute(ActionForm af) throws Exception {
		String corp_code =af.getHttpSession().getAttribute("CORP_CODE").toString();
		String jhmyid =af.getHttpRequest().getParameter("jhmyid").toString();
		String mykid =af.getHttpRequest().getParameter("mykid").toString();
		StringBuffer sbsql = new StringBuffer();
		DataForm df=new DataForm("MY_MYK","ID");
		//拼凑SQL语句和PATH路径
		sbsql.append("select b.ID as ETJHMY_ID,*,c.PTJZXM as PTJZXM,((year(getdate())-year(d.CSRQ))+1) as NL from MY_MYK a \n");
		sbsql.append(" join MY_JHMY b on 1=1  \n");
		sbsql.append(" left join MY_YFJZ c on a.JMJKDAH=c.JMJKDAH  \n");
		sbsql.append(" join DA_RKXZL d on a.JMJKDAH=d.JMJKDAH \n");
		sbsql.append("WHERE 1=1 and \n a.CORP_CODE='"+corp_code+"' and b.ID='"+jhmyid+"' and a.ID='"+mykid+"' ");
		af.getHttpRequest().setAttribute("yfjz",new Dao().daoSelectAll(af, sbsql.toString(), df).get(0));
		return 1;
	}

}