public virtual bool AddMemberFavorites(MemberFavoritesInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Member_Favorites";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Member_Favorites_ID"] = entity.Member_Favorites_ID;
DrAdd["Member_Favorites_MemberID"] = entity.Member_Favorites_MemberID;
DrAdd["Member_Favorites_Type"] = entity.Member_Favorites_Type;
DrAdd["Member_Favorites_TargetID"] = entity.Member_Favorites_TargetID;
DrAdd["Member_Favorites_Addtime"] = entity.Member_Favorites_Addtime;
DrAdd["Member_Favorites_Site"] = entity.Member_Favorites_Site;
DtAdd.Rows.Add(DrAdd);
try
{
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
}
public virtual IList <MemberFavoritesInfo> GetMemberFavoritess(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <MemberFavoritesInfo> entitys = null;
MemberFavoritesInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Member_Favorites";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <MemberFavoritesInfo>();
while (RdrList.Read())
{
entity = new MemberFavoritesInfo();
entity.Member_Favorites_ID = Tools.NullInt(RdrList["Member_Favorites_ID"]);
entity.Member_Favorites_MemberID = Tools.NullInt(RdrList["Member_Favorites_MemberID"]);
entity.Member_Favorites_Type = Tools.NullInt(RdrList["Member_Favorites_Type"]);
entity.Member_Favorites_TargetID = Tools.NullInt(RdrList["Member_Favorites_TargetID"]);
entity.Member_Favorites_Addtime = Tools.NullDate(RdrList["Member_Favorites_Addtime"]);
entity.Member_Favorites_Site = Tools.NullStr(RdrList["Member_Favorites_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
//根据会员ID获取该会员收藏商品数量
public virtual IList <MemberFavoritesInfo> GetMemberFavoritesByMemberID(int Member_ID, int type_id)
{
IList <MemberFavoritesInfo> entitys = null;
MemberFavoritesInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Member_Favorites WHERE Member_Favorites_MemberID = " + Member_ID + " and Member_Favorites_Type=" + type_id;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <MemberFavoritesInfo>();
while (RdrList.Read())
{
entity = new MemberFavoritesInfo();
entity.Member_Favorites_ID = Tools.NullInt(RdrList["Member_Favorites_ID"]);
entity.Member_Favorites_MemberID = Tools.NullInt(RdrList["Member_Favorites_MemberID"]);
entity.Member_Favorites_Type = Tools.NullInt(RdrList["Member_Favorites_Type"]);
entity.Member_Favorites_TargetID = Tools.NullInt(RdrList["Member_Favorites_TargetID"]);
entity.Member_Favorites_Addtime = Tools.NullDate(RdrList["Member_Favorites_Addtime"]);
entity.Member_Favorites_Site = Tools.NullStr(RdrList["Member_Favorites_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual MemberFavoritesInfo GetMemberFavoritesByID(int ID)
{
MemberFavoritesInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Member_Favorites WHERE Member_Favorites_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new MemberFavoritesInfo();
entity.Member_Favorites_ID = Tools.NullInt(RdrList["Member_Favorites_ID"]);
entity.Member_Favorites_MemberID = Tools.NullInt(RdrList["Member_Favorites_MemberID"]);
entity.Member_Favorites_Type = Tools.NullInt(RdrList["Member_Favorites_Type"]);
entity.Member_Favorites_TargetID = Tools.NullInt(RdrList["Member_Favorites_TargetID"]);
entity.Member_Favorites_Addtime = Tools.NullDate(RdrList["Member_Favorites_Addtime"]);
entity.Member_Favorites_Site = Tools.NullStr(RdrList["Member_Favorites_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool AddMemberFavorites(MemberFavoritesInfo entity)
{
return(MyDAL.AddMemberFavorites(entity));
}
public void Member_Favorites_Add(string action, int targetid)
{
if (targetid == 0)
{
Response.Write("请选择要添加到收藏夹的内容");
Response.End();
}
if (tools.NullInt(Session["member_id"]) == 0)
{
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
int supplier_id = tools.NullInt(Session["member_id"]);
if (action == "product")
{
ProductInfo product = MyProduct.GetProductByID(targetid, pub.CreateUserPrivilege("ae7f5215-a21a-4af2-8d47-3cda2e1e2de8"));
if (product != null)
{
if (product.Product_IsInsale == 1 && product.Product_IsAudit == 1)
{
MemberFavoritesInfo favorcheck = MyFavor.GetMemberFavoritesByProductID(supplier_id, 0, targetid);
if (favorcheck != null)
{
//pub.Msg("info", "信息提示", "该商品已在您的收藏夹中！", true, "/member/member_favorites.aspx");
Response.Write("该商品已在您的收藏夹中");
Response.End();
}
MemberFavoritesInfo favor = new MemberFavoritesInfo();
favor.Member_Favorites_ID = 0;
favor.Member_Favorites_MemberID = supplier_id;
favor.Member_Favorites_Type = 0;
favor.Member_Favorites_TargetID = targetid;
favor.Member_Favorites_Addtime = DateTime.Now;
favor.Member_Favorites_Site = pub.GetCurrentSite();
if (MyFavor.AddMemberFavorites(favor))
{
//pub.Msg("positive", "信息提示", "信息收藏成功！", true, "/member/member_favorites.aspx");
Response.Write("success");
Response.End();
}
else
{
//pub.Msg("info", "信息提示", "收藏失败，请稍后再试！", false, "{back}");
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
}
else
{
//pub.Msg("info", "信息提示", "收藏失败，请稍后再试！", false, "{back}");
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
}
else
{
//pub.Msg("info", "信息提示", "收藏失败，请稍后再试！", false, "{back}");
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
}
else
{
SupplierShopInfo shopinfo = MyShop.GetSupplierShopByID(targetid);
if (shopinfo != null)
{
if (shopinfo.Shop_Status == 1)
{
MemberFavoritesInfo favorcheck = MyFavor.GetMemberFavoritesByProductID(supplier_id, 1, targetid);
if (favorcheck != null)
{
//pub.Msg("info", "信息提示", "该店铺已在您的收藏夹中！", true, "/member/member_shop_favorites.aspx");
Response.Write("该店铺已在您的收藏夹中！");
Response.End();
}
MemberFavoritesInfo favor = new MemberFavoritesInfo();
favor.Member_Favorites_ID = 0;
favor.Member_Favorites_MemberID = supplier_id;
favor.Member_Favorites_Type = 1;
favor.Member_Favorites_TargetID = targetid;
favor.Member_Favorites_Addtime = DateTime.Now;
favor.Member_Favorites_Site = pub.GetCurrentSite();
if (MyFavor.AddMemberFavorites(favor))
{
//pub.Msg("positive", "信息提示", "信息收藏成功！", true, "/member/member_shop_favorites.aspx");
Response.Write("success");
Response.End();
}
else
{
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
}
else
{
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
}
else
{
Response.Write("收藏失败，请稍后再试！");
Response.End();
}
}
}
