/*
 * 創(chuàng)建日期 2005-12-7
 *
 * TODO 要更改此生成的文件的模板，請(qǐng)轉(zhuǎn)至
 * 窗口 － 首選項(xiàng) － Java － 代碼樣式 － 代碼模板
 */
package bit.jeffy.business;


import java.sql.ResultSet;
import javax.servlet.jsp.JspWriter;
import bit.jeffy.db.DataStore;

/**
 * @author jeffy
 * 
 * TODO 要更改此生成的類型注釋的模板，請(qǐng)轉(zhuǎn)至 窗口 － 首選項(xiàng) － Java － 代碼樣式 － 代碼模板
 */
public class ClientRemind {

	private JspWriter out;

	private String ZH = null;

	private DataStore ds = null;
	
	private int page = 0;

	public ClientRemind(JspWriter jw, String user, String pg) {
		out = jw;
		ZH = user;
		
		if (ds == null)
			ds = DataStore.getInstance();
		
		if( pg != null )
			page = Integer.parseInt(pg);
	}

	public void doplay() throws Exception {

		ResultSet st_1 = null, st_2 = null;;
		String sql_1 = "select count(*) as c from ClientRemind where ZH='" + ZH + "'";
		String sql_2 = "select * from ClientRemind where ZH='" + ZH + "'";	
 		int total_count = 0, turn_count = 0, i, total_page = 0, left_count = 0;
 		int id = -1;
 		float itmp = 0;
 		boolean page_up = true, page_down = true;
 		
		if (ds != null){
			st_1 = ds.read(sql_1);
		}

		if(st_1 != null && st_1.next()) {
			total_count = st_1.getInt("c");
		}
		
		turn_count = 5*page;
		total_page = total_count/5;
		left_count = total_count%5;
		
		if( (turn_count>total_count) && (turn_count>(total_count-5)) ){
			page_down = false;
		}
		if( (turn_count-5 < 0) ){
			page_up = false;
		}
			
			
		if( ds != null )
			st_2 = ds.read(sql_2);
		
		for( i = 0; i < turn_count; i ++ ){
			if( !st_2.next() )
				break;
		}
	
		out.print("<table width=97% height=300 border=1 cellpadding=1 cellspacing=0 bordercolor=#0099FF>");
		out.print("<tr align=center><td colspan=4 class=BodyHeader_Middle>用戶備忘錄</td></tr>");
    	out.print("<tr><td width=25% height=25 class=bookText>主題</td>");
    	out.print("<td width=35% class=bookText>內(nèi)容簡(jiǎn)要</td>");
    	out.print("<td width=20% class=bookText>上傳日期</td>");
    	out.print("<td width=20% class=bookText>操作</td></tr>");
    	
    	String theme = null, content = null, makedate = null;
    	int tlength = 0;
    	
	    for( i = 0; i < 5; i ++ ){
	    	out.print("<tr>");
	    	if( st_2.next() ){
	    		id = st_2.getInt("ID");
	    		theme = st_2.getString("THEME");	    		
	    		content = st_2.getString("CONTENT"); 
	    		tlength = content.length()>6?6:content.length();
	    		makedate = st_2.getString("MAKEDATE");
	    		out.print("<td class=bookTest><a href=RemindContent.jsp?content="+content+">"+theme+"</a></td>");
	    		out.print("<td class=bookText>"+content.substring(0,tlength)+"...</td>");
	    		out.print("<td class=bookText>"+makedate+"</td>");
	    		out.print("<td class=bookText><a href=/PersonalPlatform/RemindDelete.do?d_page="+page+"&id="+id+">刪除</a></td></tr>");
	    	}
	    	else{
	    		out.print("<td>&nbsp</td><td>&nbsp</td><td>&nbsp</td><td>&nbsp</td>");
	    	}	
	    }
	    
	    out.print("<tr><td colspan=4><table width=756 border=0 cellspacing=0><tr>");
	    out.print("<td width=156 align=center valign=middle class=bookText>");
	    if( page > 0 ) {
	    	out.print("<a href=/PersonalPlatform/ChooseView.do?target=4&r_page=0>首頁(yè)</a></td>");
	    	out.print("<td width=160 align=center valign=middle class=bookText>");
		    out.print("<a href=/PersonalPlatform/ChooseView.do?target=4&r_page="+(page-1)+">");
		    out.print("上一頁(yè)</a></td>");
	    }else {
	    	out.print("首頁(yè)</td>");
	    	out.print("<td width=160 align=center valign=middle class=bookText>上一頁(yè)</td>");
	    }
	    
	    if( page < (total_page-1) || ( page == (total_page-1))&&left_count>0 ){
	    	out.print("<td width=179 align=center valign=middle class=bookText>");
	    	out.print("<a href=/PersonalPlatform/ChooseView.do?target=4&r_page="+(page+1)+">");
		    out.print("下一頁(yè)</a></td>");
		    out.print("<td width=108 align=center valign=middle class=bookText>");
		    out.print("<a href=/PersonalPlatform/ChooseView.do?target=4&r_page="+total_page+">末頁(yè)</a></td>");    
	    }
	    else{
	    	out.print("<td width=179 align=center valign=middle class=bookText>下一頁(yè)</td>");
	    	out.print("<td width=108 align=center valign=middle class=bookText>");
	    	out.print("末頁(yè)</td>");
	    }
	       	
	    out.print("<td width=143 align=center valign=middle class=bookText>");
	    out.print("<a href=/PersonalPlatform/AddRemind.jsp>添加新的備忘錄</a></td>");
	    out.print("</tr></table></td></tr></table>");  

	}
}