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