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));
}
