protected void btnCol_Click(object sender, EventArgs e)
{
if (Session["user_name"] != null)
{
trrecord_col trcol = new trrecord_col();//创建表对象
int id = int.Parse(Request.QueryString["id"]);
string sql = "select * from trrecord_col where trrecord_id=@trrecord_id and user_id=@user_id";
SqlParameter[] sp = { new SqlParameter("@trrecord_id", id),
new SqlParameter("@user_id", Session["user_id"]), };
SqlDataReader dr = DBHelper.GetDataReader(sql, sp);
if (dr.Read())
{
ScriptManager.RegisterClientScriptBlock(UpdateLike, this.GetType(), "click", "alert('您已收藏过该游记！')", true);
}
else
{
trcol.user_id = int.Parse(Session["user_id"].ToString());
trcol.trrecord_id = id;
trcol.col_time = DateTime.Now;
int result = Trrecord_colManager.InsertTrrecord(trcol);
if (result >= 1)
{
ScriptManager.RegisterClientScriptBlock(UpdateLike, this.GetType(), "click", "alert('收藏成功！')", true);
Travel_recordManager.UpdateCol(id);
BindTravel();
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(UpdateLike, this.GetType(), "click", "alert('请先登录');location='Login1.aspx'", true);
}
}
protected void pubbtn_Click(object sender, EventArgs e)
{
try
{
travel_record record = new travel_record();
record.user_id = 3;
record.record_author = "11";
record.record_title = title.Text.Trim();
record.record_cont = "11";
record.pub_time = DateTime.Now.ToLocalTime();
record.col_count = 0;
record.comt_count = 0;
record.like_count = 0;
record.record_cover = "ww";
int result = Travel_recordManager.InsertTravel_record(record);
if (result >= 1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('游记发表成功！');</script>");
}
}
catch (Exception)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('发布失败！请仔细检查');</script>");
}
}
protected void btnLike_Click(object sender, EventArgs e)
{
if (Session["user_name"] != null)
{
if (ViewState["like_count"] == null)
{
int trrecord_id = int.Parse(Request.QueryString["id"]);
Travel_recordManager.UpdateLike(trrecord_id);
//ScriptManager.RegisterClientScriptBlock(UpdateLike, this.GetType(), "click", "alert('点赞成功！')", true);
BindTravel();
ViewState["like_count"] = true;
}
else
{
int trrecord_id = int.Parse(Request.QueryString["id"]);
int dt = Travel_recordManager.getLikecount(trrecord_id);
if (dt > 0)
{
Travel_recordManager.UpdateDislike(trrecord_id);
//ScriptManager.RegisterClientScriptBlock(UpdateLike, this.GetType(), "click", "alert('取消点赞！')", true);
BindTravel();
ViewState["like_count"] = null;
}
//}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(UpdateLike, this.GetType(), "click", "alert('请先登录');location='Login1.aspx'", true);
}
}
public void BindTravel1()
{
DataTable dt = Travel_recordManager.SelectTop(5);
if (dt != null && dt.Rows.Count != 0)
{
LVTravel1.DataSource = dt;
LVTravel1.DataBind();
}
}
public void BindTravel()
{
int trrecord_id = int.Parse(Request.QueryString["id"]);
DataTable dt = Travel_recordManager.SelectTravel_record(trrecord_id);
if (dt != null && dt.Rows.Count > 0)
{
LVTravel1.DataSource = dt;
LVTravel1.DataBind();
}
}
protected void gettrrecord()
{
string userid = Session["user_id"].ToString();
DataTable dt = Travel_recordManager.SelectUserTravel_record(userid);
if (dt != null && dt.Rows.Count != 0)
{
trrecords.DataSource = dt;
trrecords.DataBind();
}
}
protected void getreocrd_col()
{
int userid = (int)Session["user_id"];
DataTable dts = Travel_recordManager.SelectUserrecord_col(userid);
if (dts != null && dts.Rows.Count != 0)
{
record_col.DataSource = dts;
record_col.DataBind();
}
}
