.net编程

开发平台：
C#

query_article.aspx.cs：源码内容
							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.Data.OleDb;
using System.Configuration;
using System.Text;
namespace kuangren
{
	/// <summary>
	/// query_article 的摘要说明。
	/// </summary>
	public class query_article : System.Web.UI.Page
	{
		protected DateTime dtStartTime = DateTime.Now;
		protected System.Web.UI.WebControls.Repeater parent;		
		protected System.Web.UI.WebControls.Repeater Repeater1;
		protected Wuqi.Webdiyer.AspNetPager AspNetPager1;
		protected System.Data.OleDb.OleDbCommand cmd;
		protected System.Data.OleDb.OleDbConnection conn;	
		public string usercookies;
		public string dotitle;
		public string message;
		public string str;
		public int titlejudge;
		public string GetReply(object o)
		{
			if (Convert.IsDBNull(o) || (string)o == "")
				return "尚未回复";
			else
				return "<a href='user_infor.aspx?u_user="+o+"' target='_blank'>"+o+"</a>";
		}
		public string JudgeImage(string s_1,string s_2,string s_3,int s_4)
		{
			if (s_1=="4")
				return "ztop.gif";
			if (s_1 == "3")
				return "istop.gif";
			if (s_1!= "3"&&s_1!="4"&&s_2=="1")
				return "isbest.gif";
			if (s_3 == "1")
				return "lockfolder.gif";
			if (s_4 >= 10)
				return "hotfolder.gif";
			else
				return "folder.gif";
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			string str=""+Request.QueryString["title"]+"";			
			titlejudge=System.Text.Encoding.Default.GetByteCount(str);			
			if (Request.Cookies["jusername"]!=null)
			{
				usercookies=Request.Cookies["jusername"].Value;
			}
			else
			{
				Response.Redirect("logine.aspx");				
			}	
			if (titlejudge==0&&Request.QueryString["type"]=="2")
			{Response.Redirect("announcerror.aspx");}
			conn = new OleDbConnection(ConfigurationSettings.AppSettings["cnFriends.ConnectionString"]);		
			if(!Page.IsPostBack)
			{
				if (Convert.ToString(Request.QueryString["type"])=="1")
				{   
					cmd=new OleDbCommand("select count(f3_id) from forum_3 where f3_sy="+Request.QueryString["f2_id"]+" and f3_state<>2 and f3_distillate=1 ",conn);
				    dotitle="精华文章";
				}
				if (Convert.ToString(Request.QueryString["type"])=="2")
				{
					cmd=new OleDbCommand("select count(f3_id) from forum_3 where f3_sy="+Request.QueryString["f2_id"]+" and f3_state<>2 and f3_motif like '%"+Request.QueryString["title"]+"%' ",conn);
				    dotitle="论坛搜索";
				}
				if (Convert.ToString(Request.QueryString["type"])=="3")
				{
					cmd=new OleDbCommand("select count(f3_id) from forum_3 where f3_sy="+Request.QueryString["f2_id"]+" and f3_state<>2 and f3_name='"+Request.QueryString["f3_name"]+"' ",conn);
					dotitle="论坛搜索";
				}
				conn.Open();
				AspNetPager1.RecordCount=(int)cmd.ExecuteScalar();
				if (AspNetPager1.RecordCount==0)
				{message="<tr align=center bgColor=#ffffff height=28><td colSpan=5>未搜索到任何记录</td></tr>";}				
				conn.Close();
				DataBind();
			}		
	
		}
		void DataBind()
		{  
			if (Convert.ToString(Request.QueryString["type"])=="1")
			{
				cmd=new OleDbCommand("SELECT f3_id, f3_motif, f3_count, f3_face, f3_sy, f3_state, f3_top,f3_distillate, f3_name, f3_now, f3_replynum, f3_replyname from forum_3 where f3_sy="+Request.QueryString["f2_id"]+" and f3_state<>2 and f3_distillate=1 ORDER BY f3_top DESC ,f3_now DESC",conn);
			}
			if (Convert.ToString(Request.QueryString["type"])=="2")
			{
				cmd=new OleDbCommand("SELECT f3_id, f3_motif, f3_count, f3_face, f3_sy, f3_state, f3_top,f3_distillate, f3_name, f3_now, f3_replynum, f3_replyname from forum_3 where f3_sy="+Request.QueryString["f2_id"]+" and f3_state<>2 and f3_motif like '%"+Request.QueryString["title"]+"%' ORDER BY f3_top DESC ,f3_now DESC",conn);
			}
			if (Convert.ToString(Request.QueryString["type"])=="3")
			{
				cmd=new OleDbCommand("SELECT f3_id, f3_motif, f3_count, f3_face, f3_sy, f3_state, f3_top,f3_distillate, f3_name, f3_now, f3_replynum, f3_replyname from forum_3 where f3_sy="+Request.QueryString["f2_id"]+" and f3_state<>2 and f3_name='"+Request.QueryString["f3_name"]+"' ORDER BY f3_top DESC ,f3_now DESC",conn);
			}
			OleDbDataAdapter adapter=new OleDbDataAdapter(cmd);
			DataSet ds=new DataSet();
			adapter.Fill(ds,AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"forum_3");
			Repeater1.DataSource=ds.Tables["forum_3"];
			Repeater1.DataBind();			
		
			//动态设置用户自定义文本内容
			AspNetPager1.CustomInfoText="记录总数：<b>"+AspNetPager1.RecordCount.ToString()+"</b>";
			AspNetPager1.CustomInfoText+=" 总页数：<b>"+AspNetPager1.PageCount.ToString()+"</b>";
			AspNetPager1.CustomInfoText+=" 当前页：<font color="red"><b>"+AspNetPager1.CurrentPageIndex.ToString()+"</b></font>";
		}
		
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.AspNetPager1.PageChanged += new Wuqi.Webdiyer.PageChangedEventHandler(this.AspNetPager1_PageChanged);
			this.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion
		private void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
		{
			AspNetPager1.CurrentPageIndex=e.NewPageIndex;
			DataBind();
		}
		
	}
}

						