package?com.yxq.action;

import?java.util.List;

import?com.yxq.actionSuper.AdminSuperAction;
import?com.yxq.dao.OpDB;
import?com.yxq.model.CreatePage;

public?class?AdminAction?extends?AdminSuperAction?{

	/**?功能：管理員操作-進行列表顯示信息?*/
	public?String?ListShow（）{
		request.setAttribute（“mainPage““../info/listshow.jsp“）;
		session.remove（“adminOP“）;	
		
		int?infoType=showType.getInfoType（）;
		String?stateType=showType.getStateType（）;
		String?payforType=showType.getPayforType（）;

		session.put（“infoType“Integer.valueOf（infoType））;??				//保存已選擇的“信息類別”的選項
		session.put（“payforType“payforType）;								//保存已選擇的“付費狀態”的選項
		session.put（“stateType“stateType）;									//保存已選擇的“審核狀態”的選項		
		
		String?sqlall=““;
		String?sqlsub=““;
		object[]?params=null;
		String?mark=““;		
		int?perR=8;
		
		if（!stateType.equals（“all“）&&!payforType.equals（“all“））{			//沒有同時選擇“付費狀態”與“審核狀態”中的“全部”選項
			mark=“1“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;			
			params=new?object[3];
			params[0]=Integer.valueOf（infoType）;
			params[1]=stateType;
			params[2]=payforType;					
		}else?if（stateType.equals（“all“）&&payforType.equals（“all“））{		//同時選擇了“付費狀態”與“審核狀態”中的“全部”選項
			mark=“2“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?ORDER?BY?info_date?DESC“;			
			params=new?object[1];
			params[0]=Integer.valueOf（infoType）;
		}else?if（payforType.equals（“all“））{									//選擇了“付費狀態”中的“全部”選項，“審核狀態”選項任意
			mark=“3“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?ORDER?BY?info_date?DESC“;
			params=new?object[2];
			params[0]=Integer.valueOf（infoType）;
			params[1]=stateType;
		}
		else?if（stateType.equals（“all“））{??									//選擇了“審核狀態”中的“全部”選項，“付費狀態”選項任意
			mark=“4“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;
			params=new?object[2];
			params[0]=Integer.valueOf（infoType）;
			params[1]=payforType;
		}		
		
		String?strCurrentP=request.getParameter（“showpage“）;
		String?gowhich=“admin_ListShow.action“;
		
		OpDB?myOp=new?OpDB（）;
		CreatePage?createPage=myOp.OpCreatePage（sqlall?paramsperRstrCurrentPgowhich）;			//調用OpDB類中的OpCreatePage（）方法計算出總記錄數、總頁數，并且設置當前頁碼，這些信息都封裝到了createPage對象中
		
		int?currentP=createPage.getCurrentP（）;		
		if（currentP>1）{
			int?top=（currentP-1）*perR;
			if（mark.equals（“1“））{
				sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?i?WHERE?（info_type?=??）?AND?（info_payfor?=??）?AND?（info_state?=??）?AND?（info_da

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????104??2007-12-18?17:15??JSP項目開發全程實錄（完整源代碼）\01\index.jsp

?????文件?????580608??2008-01-11?21:39??JSP項目開發全程實錄（完整源代碼）\01\readme.doc

?????文件????????582??2007-11-23?19:15??JSP項目開發全程實錄（完整源代碼）\01\css\style.css

?????文件????1441792??2008-01-10?23:36??JSP項目開發全程實錄（完整源代碼）\01\Database\db_CityInfo_Data.MDF

?????文件?????516096??2008-01-10?23:36??JSP項目開發全程實錄（完整源代碼）\01\Database\db_CityInfo_log.LDF

?????文件???????1626??2007-11-23?17:00??JSP項目開發全程實錄（完整源代碼）\01\images\admin_exit.gif

?????文件???????1563??2007-11-23?17:00??JSP項目開發全程實錄（完整源代碼）\01\images\admin_index.gif

?????文件??????19278??2007-11-23?18:33??JSP項目開發全程實錄（完整源代碼）\01\images\admin_menu.jpg

?????文件??????69806??2007-11-23?16:50??JSP項目開發全程實錄（完整源代碼）\01\images\admin_top.jpg

?????文件?????????51??2007-11-22?22:23??JSP項目開發全程實錄（完整源代碼）\01\images\back.gif

?????文件???????2120??2007-11-23?03:37??JSP項目開發全程實錄（完整源代碼）\01\images\b_logon.gif

?????文件???????2021??2007-11-23?03:37??JSP項目開發全程實錄（完整源代碼）\01\images\b_reset.gif

?????文件??????16039??2007-11-23?17:44??JSP項目開發全程實錄（完整源代碼）\01\images\default_e.jpg

?????文件??????24241??2007-11-23?17:47??JSP項目開發全程實錄（完整源代碼）\01\images\default_m.jpg

?????文件???????1407??2007-11-23?17:42??JSP項目開發全程實錄（完整源代碼）\01\images\default_t.jpg

?????文件??????27423??2007-11-30?23:43??JSP項目開發全程實錄（完整源代碼）\01\images\end.jpg

?????文件???????1490??2007-12-25?21:51??JSP項目開發全程實錄（完整源代碼）\01\images\leftD.jpg

?????文件????????937??2007-12-25?21:02??JSP項目開發全程實錄（完整源代碼）\01\images\leftS.jpg

?????文件???????6718??2007-11-22?23:54??JSP項目開發全程實錄（完整源代碼）\01\images\logo.gif

?????文件????????262??2007-11-23?03:37??JSP項目開發全程實錄（完整源代碼）\01\images\logon_end.gif

?????文件????????574??2007-11-23?03:37??JSP項目開發全程實錄（完整源代碼）\01\images\logon_middle.gif

?????文件??????32680??2007-11-23?03:37??JSP項目開發全程實錄（完整源代碼）\01\images\logon_top.gif

?????文件???????5677??2007-11-22?21:39??JSP項目開發全程實錄（完整源代碼）\01\images\menu.gif

?????文件???????1111??2007-11-22?21:44??JSP項目開發全程實錄（完整源代碼）\01\images\m_index.gif

?????文件??????63920??2007-11-23?00:26??JSP項目開發全程實錄（完整源代碼）\01\images\pcard1.jpg

?????文件??????23611??2007-11-23?00:06??JSP項目開發全程實錄（完整源代碼）\01\images\pcard2.jpg

?????文件?????????68??2007-11-18?19:03??JSP項目開發全程實錄（完整源代碼）\01\js\DeleteCheck.js

?????文件????????367??2007-11-17?19:54??JSP項目開發全程實錄（完整源代碼）\01\js\InputCheck.js

?????文件???????3204??2007-12-25?21:53??JSP項目開發全程實錄（完整源代碼）\01\pages\calendar.jsp

?????文件????????529??2007-11-30?16:52??JSP項目開發全程實錄（完整源代碼）\01\pages\error.jsp

............此處省略1806個文件信息