browers.aspx.cs

1。使用ASP.NET+C# VS.NET 2003制作

					CurrentPage=Convert.ToInt32(Request.QueryString["Page"]);
				if (PageCount<CurrentPage)
					CurrentPage=PageCount;
				if (CurrentPage<=0)
					CurrentPage=1;
				if (CurrentPage<=1)
					this.DataList_Q.DataBind();

				//设定导入的起终地址
				int StartIndex = (CurrentPage-1)*PageSize;
				this.Datalist_A.DataSource=DBOperate.SelectFormForum("SELECT Ans_ID, Question_ID, Ans_Man, Ans_Content, Ans_Time, ImageName FROM Answers WHERE (Question_ID = "+QS+")",StartIndex,PageSize,"Answers");
				this.Datalist_A.DataBind();

				lnkNext.Enabled = true;
				lnkNext2.Enabled = true;
				lnkPrev.Enabled = true;
				lnkPrev2.Enabled = true;
				if(CurrentPage==(PageCount))
				{
					lnkNext.Enabled = false;
					lnkNext2.Enabled = false;
				}
				else
				{
					lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+"?QID="+QS+"&Page=" + Convert.ToString(CurrentPage+1);
					lnkNext2.NavigateUrl=Request.CurrentExecutionFilePath+"?QID="+QS+"&Page=" + Convert.ToString(CurrentPage+1);
				}
				if(CurrentPage==1)
				{
					lnkPrev.Enabled = false;
					lnkPrev2.Enabled = false;
				}
				else
				{
					lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath+"?QID="+QS+"&Page=" + Convert.ToString(CurrentPage-1);
					lnkPrev2.NavigateUrl=Request.CurrentExecutionFilePath+"?QID="+QS+"&Page=" + Convert.ToString(CurrentPage-1);
				}
				lblCurrentPage.Text = CurrentPage.ToString();
				lblCurrentPage2.Text = CurrentPage.ToString(); 

				//右侧帖子列表
				this.DList1.DataSource= DBOperate.SelectFormForum("SELECT Q_ID, CASE WHEN len(Q_Note) < 14 THEN Q_Note ELSE substring(Q_Note, 0, 14) + '...' END AS Q_Note, pith, BigClass_ID, HiteCounter, SmallClass_ID, kind FROM Questions WHERE (pith=1)and(Q_ID<"+QS+") AND(BigClass_ID = "+BID+") AND (SmallClass_ID ="+SID+") AND(kind > 0) ORDER BY Q_ID DESC",0,10,"Questions");
				this.DList1.DataBind();

				this.DList2.DataSource= DBOperate.SelectFormForum("SELECT Q_ID, CASE WHEN len(Q_Note) < 14 THEN Q_Note ELSE substring(Q_Note, 0, 14) + '...' END AS Q_Note, pith, BigClass_ID, HiteCounter, SmallClass_ID, kind FROM Questions WHERE (pith=1) AND(kind > 0) ORDER BY Q_ID DESC",0,10,"Questions");
				this.DList2.DataBind();
			}
			catch (Exception) 
			{
				this.Response.Redirect("Logon.aspx?url="+this.Request.Url.ToString());
			}
		}

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

		}
		#endregion

		public string ImgShow(string Imgname)
		{
			if ((Imgname==null)||(Imgname=="default.gif"))
				return "";
			else
                return "<a href='ImageView.aspx?IMG=followUpImage/"+Imgname+"' target='_blank'><img src='followUpImage/"+Imgname+"'onload='javascript:if(this.width>screen.width-220)this.width=screen.width-220' border=0 alt='点击放大看原图'></a><br>";
		}
		
		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			//转向登录页面
			this.Response.Redirect("Logon.aspx?url="+this.Request.Url.ToString());
		}

		private void BtnPut_Click(object sender, System.EventArgs e)
		{
			string ext;
			string fn="";
			int id;
			string  imgpath="followUpImage/";

			//提交输入的内容
			if (TB_Content.Text=="") 
			{
				Span1.Text="评论内容不能为空。";
				return;  
			}
			if (User.Identity.Name=="") 
			{
				Span1.Text="用户未登录。";
				return;  
			}

			ext=Path.GetExtension(Files1.PostedFile.FileName);
			if (Files1.PostedFile.ContentLength>1107200) 
			{ 
				Span1.Text="上传的文件不能超过1M"; 
				return;  
			} 
			else 
			{
				if(Files1.PostedFile != null)
				{
					try
					{  
						id=CommonFuntion.getNewTableID("followUpImage");
						if (Files1.PostedFile.FileName.ToString()=="") 
						{
							fn="default.gif";
						}
						else
						{
							if (!((ext.ToLower()==".gif")||(ext.ToLower()==".bmp")||(ext.ToLower()==".png")||(ext.ToLower()==".ico")||(ext.ToLower()==".jpg")||(ext.ToLower()==".wmf")))
							{
								Span1.Text="上传图片格式错误！（JPG/GIF/ICO/BMP/WMF/PNG）";
								return;
							}
							fn=Path.GetFileName(Files1.PostedFile.FileName);
							if (fn.Length>20)
								fn=fn.Substring(fn.Length-20,20);
							fn=id.ToString()+"_"+fn;
							if (File.Exists(Server.MapPath(imgpath+fn))) 
							{ 
								Span1.Text="上传文件重名，请改名后再上传！";
								return;  
							} 
							Files1.PostedFile.SaveAs( Server.MapPath(imgpath+fn));  
						}

						SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DBConnection"]);
						try
						{
							string s=("INSERT INTO Answers (Question_ID,Ans_Man,Ans_Content, Ans_Time, Ans_IPAddress, ImageName) VALUES ("+Request.QueryString["QID"]
								+",'"+User.Identity.Name.ToString()+"',@Ans_Content,GETDATE(),'"+this.Request.UserHostAddress+"',@ImageName)");
						
							SqlCommand sqlCmd =new SqlCommand(s,sqlConnection);
							sqlCmd.Parameters.Add("@Ans_Content", System.Data.SqlDbType.Text);
							sqlCmd.Parameters.Add("@ImageName", System.Data.SqlDbType.Text);
							sqlCmd.Parameters["@Ans_Content"].Value=TB_Content.Text;
							sqlCmd.Parameters["@ImageName"].Value=fn;
							sqlConnection.Open();
							sqlCmd.ExecuteNonQuery();
						}
						finally
						{
							sqlConnection.Close();
						}
						DBOperate.ExcSQL("UPDATE Questions SET AnsCounter = AnsCounter + 1, ReleaseTime = GETDATE() WHERE (Q_ID = "+Request.QueryString["QID"]+")");
						DBOperateSite.ExcSQL("update users set jifen=jifen+1 where User_name='"+User.Identity.Name.ToString()+"'");

						this.Response.Redirect(this.Request.Url.ToString());
					}			
					catch(Exception exception)
					{
						Span1.Text =exception.ToString();
					}
				}
			}
		}

		private void gotonext(int x)
		{
			string QID;
			if (Request.QueryString["QID"]==null)
			{
				QID="1";
			}
			else
			{
				QID=Request.QueryString["QID"];
			}
			string s=Request.CurrentExecutionFilePath+"?QID="+QID+"&Page="+Convert.ToString(x);
			this.Response.Redirect(s);
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			try
			{
				int x = System.Convert.ToInt32(TextBox1.Text.ToString());
				gotonext(x);
			}
			catch(Exception) 
			{
			}
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			try
			{
				int x = System.Convert.ToInt32(TextBox2.Text.ToString());
				gotonext(x);		
			}
			catch(Exception) 
			{
			}
		}
	}
}