admin_manageapply.aspx.cs

网上自动答疑系统(C#)

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;

namespace dayi
{
	/// <summary>
	/// admin_manageApply 的摘要说明。
	/// </summary>
	public class admin_manageApply : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblApplyList;
		dayi.controlDatabase cd=new controlDatabase();

		private string showApplyBoardList(string type,int pageCount,int curPage)
		{
			//显示申请栏目列表
			//type:显示类别,空为显示全部,agree为显示已验证,disagree为显示未验证,lock为锁定的,unlock为未锁定
			//pageCount:每页多少条记录
			//curPage:当前页
			//返回栏目字符串
			//-------------------------
			//初始化参数

			string viewMasterPage="<a href=admin_showMasterDetail.aspx?id=";

			if(pageCount<=0)
				pageCount=15;
			//--------------------------
			StringBuilder returnValue=new StringBuilder();


			string sql="select * from [master] order by agreed desc"; 
			if(type=="disagree")
			{
				sql="select * from [master] where agreed='0' order by masterName"; 
			}
			if(type=="agree")
			{
				sql="select * from [master] where agreed='1' order by masterName"; 
			}
			if(type=="lock")
			{
				sql="select * from [master] where agreed='1' and locked='1' order by masterName"; 
			}
			if(type=="unlock")
			{
				sql="select * from [master] where agreed='1' and locked='0' order by masterName"; 
			}

			int totalRecord=0;//总记录数
			int totalPage=0;//总页数
			try
			{
				DataTable dt=cd.getDataTable(sql);
				//得到总记录数
				totalRecord=dt.Rows.Count;
				//得到总页数
				totalPage=(totalRecord+pageCount-1)/pageCount;

				if(curPage<=0)
					curPage=1;
				else if(curPage>totalPage)
					curPage=totalPage;

				//SqlDataReader reader=(SqlDataReader)this.sqlDataReader(sql);
				if(totalPage>0)
				{
					returnValue.Append("<table width=\"600\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\" bgcolor=\"#003366\"><tr bgcolor=\"#0066CC\">");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">申请人</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">所教专业</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">申请时间</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">申请栏目名</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">操作</div></td></tr>");
					//实现分页
					int startLine=(curPage-1)*pageCount;

					DataRow row;
					for(int i=startLine;i<(pageCount+startLine);i++)
					{
						if(i<totalRecord)
						{
							row=dt.Rows[i];
							string manage="";
							if(row["agreed"].ToString()=="0")
							{
								manage="<a href=admin_manageMaster.aspx?type=agree&id="+row["id"].ToString()+">同意申请</a>|";
							}
							if(row["agreed"].ToString()=="1")
							{
								if(row["locked"].ToString()=="1")
									manage+="<a href=admin_manageMaster.aspx?type=unlock&id="+row["id"].ToString()+">解锁</a>|";
								else
									manage+="<a href=admin_manageMaster.aspx?type=lock&id="+row["id"].ToString()+">锁定</a>|";
							}
							manage+="<a href=admin_manageMaster.aspx?type=delete&id="+row["id"].ToString()+">删除</a>";

							returnValue.Append("<tr bgcolor=\"#FFFFFF\">");
							returnValue.Append("<td><div align=\"center\">"+viewMasterPage+row["id"].ToString()+">"+row["realName"].ToString()+"</a></div></td>");
							returnValue.Append("<td><div align=\"left\">"+row["className"].ToString().Trim()+"</div></td>");
							returnValue.Append("<td><div align=\"center\">"+row["regTime"].ToString().Trim()+"</div></td>");
							returnValue.Append("<td><div align=\"center\">"+row["boardName"].ToString().Trim()+"</div></td>");
							returnValue.Append("<td><div align=\"center\">"+manage+"</div></td></tr>");
						}
						else
						{
							break;
						}
					}
					returnValue.Append("</table>");
					if(totalPage>1)
					{
						returnValue.Append(cd.showPageString("<a href=admin_manageApply.aspx?type="+type,curPage,totalPage,pageCount,totalRecord));
					}
					return returnValue.ToString();
				}
				else
				{
					//返回空
					return "";
				}
			}
			catch(Exception)
			{
				throw new Exception();
			}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{
				if(Session["userType"].ToString()!="admin")
				{
					//确认身份
					Response.Redirect("err.aspx?err=没有权限");
				}
				try
				{
					if(Request.QueryString["type"]!=null)
					{
						string type=Request.QueryString["type"].ToString();
						int page=Convert.ToInt32(Request.QueryString["page"]);
						this.lblApplyList.Text=this.showApplyBoardList(type,20,page);
						if(this.lblApplyList.Text.Trim()=="")
						{
							this.lblApplyList.Text="没有任何记录";
						}
					}
					else
					{
						this.lblApplyList.Text=this.showApplyBoardList("",20,1);
						if(this.lblApplyList.Text.Trim()=="")
						{
							this.lblApplyList.Text="没有任何记录";
						}
					}
				}
				catch(Exception)
				{
					Response.Redirect("err.aspx?err=出现错误,请联系管理员");
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}