private static M_Favorite GetInfoFromReader(SqlDataReader rdr)
{
M_Favorite info = new M_Favorite();
info.FavoriteID = DataConverter.CLng(rdr["FavoriteID"]);
info.Owner = DataConverter.CLng(rdr["Owner"]);
info.InfoID = DataConverter.CLng(rdr["InfoID"]);
info.AddDate = DataConverter.CDate(rdr["FavoriteDate"]);
rdr.Close();
return info;
}
private static SqlParameter[] GetParameters(M_Favorite Info)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@FavoriteID", SqlDbType.Int),
new SqlParameter("@Owner",SqlDbType.Int),
new SqlParameter("@InfoID",SqlDbType.Int),
new SqlParameter("@FavoriteDate",SqlDbType.DateTime)
};
parameter[0].Value = Info.FavoriteID;
parameter[1].Value = Info.Owner;
parameter[2].Value = Info.InfoID;
parameter[3].Value = Info.AddDate;
return parameter;
}
public M_Favorite GetModelFromReader(DbDataReader rdr)
{
M_Favorite model = new M_Favorite();
model.FavoriteID = Convert.ToInt32(rdr["FavoriteID"]);
model.Owner = ConvertToInt(rdr["Owner"]);
model.InfoID = ConvertToInt(rdr["InfoID"]);
model.AddDate = ConvertToDate(rdr["FavoriteDate"]);
model.FavoriType = ConvertToInt(rdr["FavoriType"]);
model.FavUrl = ConverToStr(rdr["FavUrl"]);
model.FavItemID = ConverToStr(rdr["FavItemID"]);
model.Title = ConverToStr(rdr["Title"]);
rdr.Close();
rdr.Dispose();
return(model);
}
public override SqlParameter[] GetParameters()
{
M_Favorite model = this;
if (model.AddDate <= DateTime.MinValue)
{
model.AddDate = DateTime.Now;
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.FavoriteID;
sp[1].Value = model.Owner;
sp[2].Value = model.InfoID;
sp[3].Value = model.AddDate;
sp[4].Value = model.FavoriType;
sp[5].Value = model.FavUrl;
sp[6].Value = model.FavItemID;
sp[7].Value = model.Title;
return(sp);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
buser.CheckIsLogin();
string uname = HttpContext.Current.Request.Cookies["UserState"]["LoginName"];
this.UserInfo = buser.GetUserByName(uname);
if (string.IsNullOrEmpty(base.Request.QueryString["InfoID"]))
{
function.WriteErrMsg("没有指定要添加到收藏夹的内容ID!");
}
else
{
int InfoID = DataConverter.CLng(base.Request.QueryString["InfoID"]);
M_Favorite fav = new M_Favorite();
fav.FavoriteID = 0;
fav.InfoID = InfoID;
fav.Owner = this.UserInfo.UserID;
fav.AddDate = DateTime.Now;
this.bfav.AddFavorite(fav);
function.WriteSuccessMsg("该内容成功添加到你的收藏夹了！<br/> 10秒后该页自动关闭...也可手工【<a href=\"javascript:window.close();\">关闭</a>】");
}
}
}
/// <summary>
/// 添加收藏信息到收藏夹
/// </summary>
/// <param name="favorite">收藏信息实例</param>
public void AddFavorite(M_Favorite favorite)
{
dal.AddFavorite(favorite);
}
void ID_Favorite.AddFavorite(M_Favorite favorite)
{
string strSql = "PR_Favorite_Add";
SqlParameter[] cmdParams = GetParameters(favorite);
SqlHelper.ExecuteProc(strSql, cmdParams);
}
