using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Net;
using?System.Data.SqlClient;

public?partial?class?Comment?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
		if?（Session[“user_name“]?!=?null）
		{
			btnlogin.Enabled?=?false;
			this.txtName.Text?=?Session[“user_name“].ToString（）;
		}

????}
????protected?string?GetIP（）???//獲取本地IP地址??
????{
????????string?hostName?=?Dns.GetHostName（）;				//獲得主機名
????????IPAddress[]?me?=?Dns.GetHostAddresses（hostName）;	//獲取IP地址列表
????????IPAddress?HostIP?=?me[0];//取第一個IP地址

????????return?HostIP.ToString（）;//返回獲得的IP地址
????}
????protected?void?btnaddcommnet_Click（object?sender?EventArgs?e）//發表評論
????{
????????if?（Session[“user_name“]?==?null）//判斷用戶是否登錄
????????{
????????????Response.Write（“ript?language=javascript>alert（‘請登錄！‘）;ript>“）;
????????}
????????else
????????{
????????????if?（this.txtComment.Text.ToString（）?==?““）//判斷評論是否為空
????????????{
????????????????Response.Write（“ript>alert（‘你還沒說話呢！！！‘）;ript>“）;
????????????}
????????????else
????????????{
????????????????SqlConnection?con?=?conn.createconn（）;//創建連接對象con
????????????????con.Open（）;????????????????//打開連接
????????????????int?travelID?=?Convert.ToInt32（Request.QueryString[“travel_id“]）;//獲取傳過來的travel_id值
????????????????string?name?=?Session[“user_name“].ToString（）;//獲取用戶名
????????????????string?ip?=?GetIP（）;//調用獲取IP地址的方法
????????????????string?comment?=?this.txtComment.Text.Trim（）;//輸入的評論文本框內的信息
????????????????string?cmdtext?=?“insert?into?tb_comment“+
????????????????????“（comment_name?comment_newsid?comment_content?comment_ipcomment_time）?“+
????????????????????“values（‘“?+?name?+?“‘‘“?+?travelID?+?“‘‘“?+?comment?+?“‘‘“?+?ip?+?“‘getdate（））“;
????????????????SqlCommand?cmd?=?new?SqlCommand（cmdtext?con）;//創建SqlCommand對象
????????????????if?（travelID?!=?0）
????????????????{
????????????????????cmd.ExecuteNonQuery（）;//執行插入操作
????????????????????con.Close（）;//關閉連接
????????????????????Response.Redirect（“readnews.aspx?travel_id=“?+?travelID?+?““）;//跳轉到調用頁
????????????????}
????????????????else
????????????????{
????????????????????Response.Write（“ript>alert（‘請選擇某條新聞進行評論！‘）;ript>“）;
????????????????}
????????????}
????????}
????}
????protected?void?btnlogin_Click（object?sender?EventArgs?e）
????{
????????SqlConnection?con?=?conn.createconn（）;//創建連接對象con
????????con.Open（）;????????????????//打開連接
????????string?name?=?this.txtName.Text.Trim（）;//獲取從文本框中輸入的用戶名
????????string?pass?=?this.txtPass.Text.Trim（）;//獲取從文本框中輸入的密碼
????????string?cmdtext?=?“select?*?from?tb_users?where?user_name=‘“?+?name?+
????????????“‘?and?user_pass=‘“?+?pass?+?“‘“;
????????SqlCommand?cmd?=?new?SqlCommand（cmdtext?con

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-07-14?11:21??旅游網站系統\
?????文件???????10240??2012-07-14?11:11??旅游網站系統\ch17.suo
?????目錄???????????0??2012-07-14?14:28??旅游網站系統\TravelNews\
?????目錄???????????0??2012-07-14?12:20??旅游網站系統\TravelNews\Admin\
?????文件????????3013??2009-11-26?12:02??旅游網站系統\TravelNews\Admin\addTravelNews.aspx
?????文件????????4080??2009-11-26?12:25??旅游網站系統\TravelNews\Admin\addTravelNews.aspx.cs
?????文件????????2600??2009-11-20?09:57??旅游網站系統\TravelNews\Admin\addTravelType.aspx
?????文件????????3199??2009-11-20?09:57??旅游網站系統\TravelNews\Admin\addTravelType.aspx.cs
?????文件????????5102??2009-12-11?23:53??旅游網站系統\TravelNews\Admin\AdminMasterPages.master
?????文件?????????473??2009-11-09?22:17??旅游網站系統\TravelNews\Admin\AdminMasterPages.master.cs
?????文件?????????324??2009-11-10?11:11??旅游網站系統\TravelNews\Admin\Default.aspx
?????文件?????????415??2008-12-01?18:50??旅游網站系統\TravelNews\Admin\Default.aspx.cs
?????文件????????7494??2009-11-26?14:22??旅游網站系統\TravelNews\Admin\EditComment.aspx
?????文件????????3382??2009-11-19?10:36??旅游網站系統\TravelNews\Admin\EditComment.aspx.cs
?????文件????????6788??2009-11-19?21:19??旅游網站系統\TravelNews\Admin\editTravelNews.aspx
?????文件????????6931??2009-11-19?20:47??旅游網站系統\TravelNews\Admin\editTravelNews.aspx.cs
?????文件????????4252??2009-11-20?10:51??旅游網站系統\TravelNews\Admin\editTravelType.aspx
?????文件????????5046??2009-11-20?09:57??旅游網站系統\TravelNews\Admin\editTravelType.aspx.cs
?????文件????????4034??2009-11-21?21:07??旅游網站系統\TravelNews\Admin\EditUser.aspx
?????文件????????4590??2009-11-19?10:36??旅游網站系統\TravelNews\Admin\EditUser.aspx.cs
?????目錄???????????0??2012-07-14?12:20??旅游網站系統\TravelNews\Admin\images\
?????文件????????3213??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_02.gif
?????文件?????????996??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_03.gif
?????文件?????????207??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_04.gif
?????文件?????????278??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_05.gif
?????文件?????????518??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_06.gif
?????文件????????4264??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_08.gif
?????文件?????????522??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\index_09.gif
?????文件?????????373??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\login_01.gif
?????文件?????????155??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\login_02.gif
?????文件?????????399??2008-11-04?15:26??旅游網站系統\TravelNews\Admin\images\login_03.gif
............此處省略118個文件信息