/*
 * Created on 2006-7-30
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.ug.sztz.webview.structs.actions.oa;

import java.util.HashMap;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.ug.sztz.domain.oa.StudentBaseInfo;
import org.ug.sztz.domain.oa.ZYTZ;
import org.ug.sztz.webview.structs.forms.ZytzForm;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class AddZytz1Action extends BaseAction {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub
		ZytzForm workform = (ZytzForm) form;

		String sql = workform.getSql();
		String work =request.getParameter("submit2");
		
		if (work != null && work.equals("添加篩選條件")) {
			
			String tjz = workform.getTjz();
			int tjzd = Integer.parseInt(workform.getTjzd());
			int tj = Integer.parseInt(workform.getTj());
			int tjgx = Integer.parseInt(workform.getTjgx());
			if (sql == null || sql.length() < 1) {
				sql = "select bysbase.* from bysbase,bysjy where bysbase.xh=bysjy.xh and";
				switch (tjzd) {
				case 0:
					request.setAttribute("info","請選擇字段！");
				    return mapping.findForward("failure");
				case 1:
					sql = sql + " bysbase.xh";
					break;
				case 2:
					sql = sql + " bysbase.xm";
					break;
				case 3:
					sql = sql + " bysbase.zy";
					break;
				case 4:
					sql = sql + " bysbase.xb";
					break;
				case 5:
					sql = sql + " bysbase.mz";
					break;
				case 6:
					sql = sql + " bysbase.zzmm";
					break;
				case 7:
					sql = sql + " bysbase.pyfs";
					break;
				case 8:
					sql = sql + " bysbase.xz";
					break;
				case 9:
					sql = sql + " bysbase.xl";
					break;
				case 10:
					sql = sql + " bysbase.syszd";
					break;
				case 11:
					sql = sql + " bysbase.xjbd";
					break;
				case 12:
					sql = sql + " bysbase.bj";
					break;
				case 13:
					sql = sql + " bysbase.xy";
					break;
				case 14:
					sql = sql + " bysbase.xslb";
					break;
				case 15:
					sql = sql + " bysbase.wyyz";
					break;
				case 16:
					sql = sql + " bysjy.byqx";
					break;
				case 17:
					sql = sql + " bysjy.jyxs";
					break;
				case 18:
					sql = sql + " bysjy.lcnr";
					break;
				case 19:
					sql = sql + " bysjy.dwmc";
					break;
				case 20:
					sql = sql + " bysjy.dwszd";
					break;
				case 21:
					sql = sql + " bysjy.dwxz";
					break;
				case 22:
					sql = sql + " bysjy.ljdlbz";
					break;
				case 23:
					sql = sql + " bysjy.jyzt";
					break;
				case 24:
					sql = sql + " bysjy.xysh";
					break;
				case 25:
					sql = sql + " bysjy.jlsd";
					break;
				default:
					request.setAttribute("info","請選擇字段！");
				    return mapping.findForward("failure");
				}
				switch (tj) {
				case 1:
					sql = sql + " = '" + tjz + "'";
					break;
				case 2:
					sql = sql + " like '%" + tjz + "%'";
					break;
				case 3:
					sql = sql + " <> '" + tjz + "'";
					break;
				case 4:
					sql = sql + " not like '%" + tjz + "%'";
					break;
				case 5:
					sql = sql + " like '" + tjz + "%'";
					break;
				case 6:
					sql = sql + " not like '" + tjz + "%'";
					break;
				}
			} else {
				switch (tjgx) {
				case 0:
					request.setAttribute("info","請選擇字段！");
				    return mapping.findForward("failure");
				case 1:
					sql = sql + " and";
					break;
				case 2:
					sql = sql + " or";
					break;
				}
				switch (tjzd) {
				case 1:
					sql = sql + " bysbase.xh";
					break;
				case 2:
					sql = sql + " bysbase.xm";
					break;
				case 3:
					sql = sql + " bysbase.zy";
					break;
				case 4:
					sql = sql + " bysbase.xb";
					break;
				case 5:
					sql = sql + " bysbase.mz";
					break;
				case 6:
					sql = sql + " bysbase.zzmm";
					break;
				case 7:
					sql = sql + " bysbase.pyfs";
					break;
				case 8:
					sql = sql + " bysbase.xz";
					break;
				case 9:
					sql = sql + " bysbase.xl";
					break;
				case 10:
					sql = sql + " bysbase.syszd";
					break;
				case 11:
					sql = sql + " bysbase.xjbd";
					break;
				case 12:
					sql = sql + " bysbase.bj";
					break;
				case 13:
					sql = sql + " bysbase.xy";
					break;
				case 14:
					sql = sql + " bysbase.xslb";
					break;
				case 15:
					sql = sql + " bysbase.wyyz";
					break;
				case 16:
					sql = sql + " bysjy.byqx";
					break;
				case 17:
					sql = sql + " bysjy.jyxs";
					break;
				case 18:
					sql = sql + " bysjy.lcnr";
					break;
				case 19:
					sql = sql + " bysjy.dwmc";
					break;
				case 20:
					sql = sql + " bysjy.dwszd";
					break;
				case 21:
					sql = sql + " bysjy.dwxz";
					break;
				case 22:
					sql = sql + " bysjy.ljdlbz";
					break;
				case 23:
					sql = sql + " bysjy.jyzt";
					break;
				case 24:
					sql = sql + " bysjy.xysh";
					break;
				case 25:
					sql = sql + " bysjy.jlsd";
					break;
				default:
					request.setAttribute("info","請選擇字段！");
				    return mapping.findForward("failure");
				}
				switch (tj) {
				case 1:
					sql = sql + " = '" + tjz + "'";
					break;
				case 2:
					sql = sql + " like '%" + tjz + "%'";
					break;
				case 3:
					sql = sql + " <> '" + tjz + "'";
					break;
				case 4:
					sql = sql + " not like '%" + tjz + "%'";
					break;
				case 5:
					sql = sql + " like '" + tjz + "%'";
					break;
				case 6:
					sql = sql + " not like '" + tjz + "%'";
					break;
				}
			}
			request.setAttribute("sql", sql);
			return mapping.findForward("continue");
		} else {
			if(sql==null||sql.equals(""))
			{
				
				request.setAttribute("info", "請輸入SQL語句！");
				return mapping.findForward("failure");
			}
			
			
			
			List list = this.zytzDao.geZYTZList();
			ZYTZ zytz = (ZYTZ)list.get(0);
			int id = zytz.getId();
			zytz.setCxtj(sql);
			HashMap map = new HashMap();
			map.put("sql", sql);
			try {
				this.zytzDao.updateZYTZ(zytz);
				List studentList = this.stuBaseDao.getSQLBaseInfoList(map);
				/*Vector vector = new Vector();
				for (int i = 0; i < studentList.size(); i++) {
					String xh = ((StudentBaseInfo) studentList.get(i)).getXh();
					StudentJYInfo info = this.stuJYDao.getStudentJYInfoByXh(xh);
					vector.add(info);
				}
				request.getSession().setAttribute("studentlist", studentList);
				request.getSession().setAttribute("infolist", vector);*/
				for(int i=0;i<studentList.size();i++){
					StudentBaseInfo info = (StudentBaseInfo)studentList.get(i);
					map.put("xh",info.getXh());
					map.put("xsfl1",String.valueOf(id));
					this.stuBaseDao.updateStudentZYTZ(map);
				}
				return mapping.findForward("success");
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				request.setAttribute("info", "數據庫操作失敗！");
				return mapping.findForward("failure");
			}
		}
	}

}