package com.chis.model.person;

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

/**
 * 健康問題描述修改、查看
 * 
 * @author 翟昌強
 * 
 */ 
public class JkwtmsInfo extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
		String id = af.getHttpRequest().getParameter("jkwtmsid");
		int jkwtms = Integer.parseInt(af.getHttpRequest().getParameter("jkwtms"));
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE").toString();
		
		StringBuffer sql = new StringBuffer();
		sql.append(" select a.* \n"); 
		sql.append(" from DA_JKWTMS a  \n");
		sql.append(" where 1=1 \n");
		sql.append(" and ID ='"+id+"'\n");
		sql.append(" and JMJKDAH ='"+JMJKDAH+"' and CORP_CODE='"+corp_code+"'\n");
		DataForm df = (DataForm)DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_JKWTMS")).get(0);
		af.getHttpRequest().setAttribute("jkwtmsinfo", df);
		return jkwtms;
	}

}