sysmodule.java

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

/** 
 *
 * @File name:  SysModule.java
 * @Description:   
 * @Create on:  2008-4-8
 * @Author   :  孙韬
 *
 * @ChangeList
 * ---------------------------------------------------
 * Date         Editor              ChangeReasons
 *
 *
 */

package com.chis.model.frame;

import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

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

public class SysModule extends ActionInstance {

	public int execute(ActionForm af) throws Exception {
		String userId = (String) af.getHttpSession().getAttribute("USER_ID");
		String sql = "select distinct * from VIEW_USER_MODULE where user_id='"
				+ userId + "'";
		sql = sql + " ORDER BY CODE ASC ";

		List list1 = DaoUtil.select(af.getConnection(), sql, new DataForm());
		af.getHttpRequest().setAttribute("MODULELIST", list1);
		
//		this.initMsg(af);
		return 1;
	}

	/**
	 * 初始小贴士
	 * 
	 * @param af
	 */
	private void initMsg(ActionForm af) {
		// 登陆人ID
		String USER_ID = (String) af.getHttpSession().getAttribute("USER_ID");
		if (USER_ID != null && !"".equals(USER_ID)) {
			// 邮件
			String emailMsg = "";
			StringBuffer emailsql = new StringBuffer();
			emailsql
					.append("select LOOKSTATUS from BY_OA.MAIL_USER where 1=1 ");
			emailsql.append(" and STATUS='1' ");
			emailsql.append(" and LOOKSTATUS='0' ");
			emailsql.append(" and USER_ID='" + USER_ID + "' ");
			List emaillist = DaoUtil.select(af.getConnection(), emailsql
					.toString(), new DataForm());
			if (emaillist != null && emaillist.size() > 0) {
				emailMsg = "您有" + emaillist.size() + "封未读邮件";
			}
			// 事务
			String eventMsg = "";
			StringBuffer eventsql = new StringBuffer();
			eventsql.append("select * from BY_OA.USER_EVENT where 1=1 ");
			eventsql.append(" and USER_ID='" + USER_ID + "' ");
			eventsql.append(" order by KIND ");
			List eventlist = DaoUtil.select(af.getConnection(), eventsql
					.toString(), new DataForm());
			if (eventlist != null && eventlist.size() > 0) {
				// 星期
				int tmp_week = Calendar.getInstance().get(Calendar.DAY_OF_WEEK) - 1;
				String week = String.valueOf(tmp_week);
				Date date = new Date();
				SimpleDateFormat format = new SimpleDateFormat("MM-dd");
				// 月-日
				String monthDay = format.format(date);
				String[] tmp_day = monthDay.split("-");
				// 日
				String day = tmp_day[1];

				int i = 1;
				for (Object o : eventlist) {
					boolean flag = false;

					DataForm df = (DataForm) o;
					String kind = (String) df.get("KIND");
					if ("1".equals(kind)) {
						// 判断是不是今天
						String WEEK_REMIND = (String) df.get("WEEK_REMIND");
						if (week.equals(WEEK_REMIND)) {
							flag = true;
						}
					} else if ("2".equals(kind)) {
						String MONTH_REMIND = (String) df.get("MONTH_REMIND");
						if (day.equals(MONTH_REMIND)) {
							flag = true;
						}
					} else if ("3".equals(kind)) {
						String YEAR_REMIND = (String) df.get("YEAR_REMIND");
						if (monthDay.equals(YEAR_REMIND)) {
							flag = true;
						}
					}
					if (flag) {
						// 是否已经显示过
						String STATUS = (String) df.get("STATUS");
						if ("1".equals(STATUS)) {
							// 已经显示过，再判断是否循环
							String CYC = (String) df.get("CYC");
							if ("1".equals(CYC)) {
								eventMsg = eventMsg + "事务" + i + ": "
										+ (String) df.get("NAME") + "<br><br>";
								i++;
							}
						} else {
							eventMsg = eventMsg + "事务" + i + ": "
									+ (String) df.get("NAME") + "<br><br>";
							i++;
						}
						flag = false;
					}
				}
			}

			// 标记
			String msgFlag = "";
			if (!"".equals(emailMsg) || !"".equals(eventMsg)) {
				msgFlag = "1";
			}
			if (msgFlag != null && !"".equals(msgFlag)) {
				af.getHttpRequest().setAttribute("emailMsg", emailMsg);
				af.getHttpRequest().setAttribute("eventMsg", eventMsg);
				af.getHttpRequest().setAttribute("msg", msgFlag);
			}
		}
	}
}