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);
}
}
public int InsertTrrecord(trrecord_col trrecord_Col)
{
string sql = "insert into trrecord_col(user_id,trrecord_id,col_time) values(@user_id,@trrecord_id,@col_time)";
SqlParameter[] sp =
{
new SqlParameter("@user_id", trrecord_Col.user_id),
new SqlParameter("@trrecord_id", trrecord_Col.trrecord_id),
new SqlParameter("@col_time", trrecord_Col.col_time),
//new SqlParameter("@col_num",trrecord_Col.col_num),
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
public static int InsertTrrecord(trrecord_col trrecord_Col)
{
return(itrrecord_col.InsertTrrecord(trrecord_Col));
}