/// <summary> /// 添加收藏 /// </summary> /// <param name="collect"></param> /// <returns></returns> public int InsertTheme(CollectTheme collect) { string sql = "insert into Collect_theme values(@collect_id,@remark,@theme_id,@member_id)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("collect_id", collect.CollectId), new SqlParameter("remark", collect.Remark), new SqlParameter("theme_id", collect.ThemeId), new SqlParameter("member_id", collect.MemberId) }; return(SqlHelper.ExecuteNonQuery(sql, parameters)); }
protected void collect_ServerClick(object sender, EventArgs e)//收藏 { //判断是否登录 if (Session["role"] == null) { Response.Redirect("~/Login.aspx"); } //收藏,主题id通过Request.QueryString["themeId"]获取 CollectTheme col = new CollectTheme(); col.CollectId = CollectThemeManagement.CreatCollectId(); col.ThemeId = Request.QueryString["themeId"].ToString().Trim(); col.MemberId = Session["memberId"].ToString().Trim(); col.Remark = "备注"; Msg = CollectThemeManagement.CollectTheme(col); printMsgToClient(); }
/// <summary> /// 收藏主题 /// </summary> /// <returns></returns> public static string CollectTheme(CollectTheme collect) { if (collect.IsError) { return(collect.GetErrorMsg()); } if (ifExist(collect.MemberId, collect.ThemeId)) { return("收藏已存在"); } if (ICTS.InsertTheme(collect) > 0) { return("收藏成功"); } else { return("收藏失败"); } }
/// <summary> /// 查询主题是否已收藏 /// </summary> /// <param name="collectId"></param> /// <returns></returns> static bool ifExist(string memberId, string themeId) { Model.CollectTheme ct = new CollectTheme() { MemberId = memberId, ThemeId = themeId }; if (ct.IsError) { return(false); } if (ICTS.SelectNum(memberId, themeId) > 0) { return(true);//已收藏 } else { return(false);//未收藏 } }
/// <summary> /// 删除收藏 /// </summary> /// <param name="collect"></param> /// <returns>"未收藏" "删除收藏成功" "删除收藏失败"</returns> public static string UncollectTheme(string memberId, string themeId) { Model.CollectTheme ct = new CollectTheme() { MemberId = memberId, ThemeId = themeId }; if (ct.IsError) { return(ct.GetErrorMsg()); } if (!ifExist(memberId, themeId)) { return("您还未收藏该主题"); } if (ICTS.Delete(memberId, themeId) > 0) { return("删除收藏成功"); } else { return("删除收藏失败"); } }