protected void Page_Load(object sender, EventArgs e) { UserInfo usersByUserName = Users.GetUsersByUserName(PEContext.Current.User.UserName); this.m_UserId = usersByUserName.UserId; this.OdsFavorite.SelectParameters["userId"].DefaultValue = this.m_UserId.ToString(); if (!base.IsPostBack) { FavoriteInfo favoriteInfo = new FavoriteInfo(); favoriteInfo.FavoriteTime = DateTime.Now; favoriteInfo.InfoId = BasePage.RequestInt32("Id"); favoriteInfo.UserId = this.m_UserId; string str = BasePage.RequestStringToLower("Action"); if (str != null) { if (!(str == "add")) { if (!(str == "delete")) { return; } } else { if (favoriteInfo.InfoId <= 0) { DynamicPage.WriteErrMsg("你收藏的内容不存在!", "Index.aspx"); } UserPurviewInfo userPurview = usersByUserName.UserPurview; int maxSaveInfos = 0; if (!userPurview.IsNull) { maxSaveInfos = userPurview.MaxSaveInfos; } if (maxSaveInfos <= 0) { DynamicPage.WriteErrMsg("你没有收藏权限,请与网站管理员联系!", "Index.aspx"); } if (maxSaveInfos > Favorite.GetUserFavoiteCount(this.m_UserId)) { Favorite.Add(favoriteInfo); DynamicPage.WriteSuccessMsg("收藏成功", "~/Item/" + favoriteInfo.InfoId.ToString() + ".aspx"); return; } DynamicPage.WriteErrMsg("你收藏的内容已达到最大收藏数"); return; } if (favoriteInfo.InfoId <= 0) { DynamicPage.WriteUserErrMsg("你收藏的内容不存在!", "Favorite.aspx"); } if (!Favorite.Delete(this.m_UserId, BasePage.RequestInt32("Id"))) { DynamicPage.WriteUserErrMsg("取消失败"); } } } }
public static bool Add(FavoriteInfo favoriteInfo) { if (Exists(favoriteInfo.UserId, favoriteInfo.InfoId)) { return(false); } favoriteInfo.FavoriteId = GetMaxId() + 1; return(dal.Add(favoriteInfo)); }
// ------------------------------------------------------- // 查询 // ------------------------------------------------------- #region 函数:FindOne(string id) /// <summary>查询某条记录</summary> /// <param name="id">标识</param> /// <returns>返回实例<see cref="FavoriteInfo"/>的详细信息</returns> public FavoriteInfo FindOne(string id) { Dictionary <string, object> args = new Dictionary <string, object>(); args.Add("Id", StringHelper.ToSafeSQL(id)); FavoriteInfo param = this.ibatisMapper.QueryForObject <FavoriteInfo>(StringHelper.ToProcedurePrefix(string.Format("{0}_FindOne", this.tableName)), args); return(param); }
public bool Add(FavoriteInfo favoriteInfo) { string strSql = "INSERT INTO PE_Favorite (FavoriteId, UserId, InfoId, FavoriteTime) VALUES (@FavoriteId, @UserId, @InfoId, @FavoriteTime)"; Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@FavoriteId", DbType.Int32, favoriteInfo.FavoriteId); cmdParams.AddInParameter("@UserId", DbType.Int32, favoriteInfo.UserId); cmdParams.AddInParameter("@InfoId", DbType.Int32, favoriteInfo.InfoId); cmdParams.AddInParameter("@FavoriteTime", DbType.DateTime, favoriteInfo.FavoriteTime); return(DBHelper.ExecuteSql(strSql, cmdParams)); }
// ------------------------------------------------------- // 添加 删除 修改 // ------------------------------------------------------- #region 函数:Save(FavoriteInfo param) /// <summary>保存记录</summary> /// <param name="param">实例<see cref="FavoriteInfo"/>详细信息</param> /// <returns>实例<see cref="FavoriteInfo"/>详细信息</returns> public FavoriteInfo Save(FavoriteInfo param) { if (!this.IsExist(param.Id)) { this.Insert(param); } else { this.Update(param); } return(param); }
public string FindOne(XmlDocument doc) { StringBuilder outString = new StringBuilder(); string id = XmlHelper.Fetch("id", doc); FavoriteInfo param = this.service.FindOne(id); outString.Append("{\"ajaxStorage\":" + AjaxUtil.Parse <FavoriteInfo>(param) + ","); outString.Append(MessageObject.Stringify("0", I18n.Strings["msg_query_success"], true) + "}"); return(outString.ToString()); }
public string Save(XmlDocument doc) { FavoriteInfo param = new FavoriteInfo(); param = (FavoriteInfo)AjaxUtil.Deserialize(param, doc); param.Id = param.Id == "" ? DigitalNumberContext.Generate("Key_Guid") : param.Id; param.AccountId = KernelContext.Current.User.Id; param.Tags = string.Empty; param.IconPath = string.Empty; param.UpdateDate = System.DateTime.Now; this.service.Save(param); return(MessageObject.Stringify("0", I18n.Strings["msg_save_success"])); }
public static int AddProduct(int productId, int userId, int storeId = 0) { FavoriteDao favoriteDao = new FavoriteDao(); if (favoriteDao.ExistsProduct(productId, userId, storeId)) { return(1); } FavoriteInfo model = new FavoriteInfo { ProductId = productId, UserId = userId, StoreId = storeId, Tags = "" }; return((int)favoriteDao.Add(model, null)); }
public IList <FavoriteInfo> GetList(int startRowIndexId, int maxNumberRows, int userId, int nodeId) { Database database = DatabaseFactory.CreateDatabase(); List <FavoriteInfo> list = new List <FavoriteInfo>(); string str = "Favorite.UserId = " + userId.ToString() + " AND C.GeneralId IS NOT NULL"; if (nodeId > 0) { str = str + " AND C.NodeId = " + nodeId.ToString(); } DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList"); database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId); database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows); database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "FavoriteId"); database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "Favorite.*, C.Title"); database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC"); database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_Favorite Favorite LEFT JOIN PE_CommonModel C ON Favorite.InfoId = C.GeneralId"); database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str); database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows); using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand))) { while (reader.Read()) { FavoriteInfo item = new FavoriteInfo(); item.UserId = userId; item.InfoId = reader.GetInt32("InfoId"); item.FavoriteTime = reader.GetDateTime("FavoriteTime"); item.FavoriteId = reader.GetInt32("FavoriteId"); item.Title = reader.GetString("Title"); list.Add(item); } } this.m_TotalOfFavorite = (int)database.GetParameterValue(storedProcCommand, "@Total"); return(list); }
/// <summary>修改记录</summary> /// <param name="param">实例<see cref="FavoriteInfo"/>详细信息</param> public void Update(FavoriteInfo param) { this.ibatisMapper.Update(StringHelper.ToProcedurePrefix(string.Format("{0}_Update", this.tableName)), param); }
/// <summary>添加记录</summary> /// <param name="param">实例<see cref="FavoriteInfo"/>详细信息</param> public void Insert(FavoriteInfo param) { param.Click = 0; param.CreateDate = System.DateTime.Now; this.ibatisMapper.Insert(StringHelper.ToProcedurePrefix(string.Format("{0}_Insert", this.tableName)), param); }
// ------------------------------------------------------- // 保存 删除 // ------------------------------------------------------- #region 函数:Save(FavoriteInfo param) /// <summary>保存记录</summary> /// <param name="param">实例<see cref="FavoriteInfo"/>详细信息</param> /// <returns>实例<see cref="FavoriteInfo"/>详细信息</returns> public FavoriteInfo Save(FavoriteInfo param) { return(this.provider.Save(param)); }