private void AddCollection(out string msg) { int userId; int refId; int type; if (int.TryParse(CollectRefId, out refId) && int.TryParse(CollectType, out type)) { Entities.QueryKLFavorites query = new Entities.QueryKLFavorites(); query.UserId = BLL.Util.GetLoginUserID(); query.KLRefId = refId; query.Type = type; bool isCollected = BLL.Personalization.Instance.IsCollected(query); if (isCollected) { msg = "您已收藏了该条数据!"; } else { query.CreateTime = DateTime.Now; msg = BLL.Personalization.Instance.Insert(query) > 0 ? "success" : "收藏失败!"; } } else { msg = "数据格式有误!"; } }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.QueryKLFavorites model) { SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int), new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@KLRefId", SqlDbType.Int), new SqlParameter("@Type", SqlDbType.Int) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.UserId; parameters[2].Value = model.KLRefId; parameters[3].Value = model.Type; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PersonalCollection_Insert, parameters); return((int)parameters[0].Value); }
/// <summary> /// 判断此本人是否已经收藏了该条数据 /// </summary> /// <param name="model"></param> /// <returns>true:已经收藏;false:未收藏</returns> public bool IsCollected(Entities.QueryKLFavorites model) { string sqlStr = "SELECT COUNT(*) FROM dbo.KLFavorites WHERE UserId=@UserId AND KLRefId=@KLRefId AND Type=@Type"; SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@KLRefId", SqlDbType.Int), new SqlParameter("@Type", SqlDbType.Int), }; parameters[0].Value = model.UserId; parameters[1].Value = model.KLRefId; parameters[2].Value = model.Type; string objValue = SqlHelper.ExecuteScalar(CONNECTIONSTRINGS, CommandType.Text, sqlStr, parameters).ToString(); if (int.Parse(objValue) == 0) { return(false); } else { return(true); } }
public bool IsCollected(Entities.QueryKLFavorites model) { return(Dal.Personalization.Instance.IsCollected(model)); }
public int Insert(Entities.QueryKLFavorites model) { return(Dal.Personalization.Instance.Insert(model)); }