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();
}
}
}
public virtual bool EditSupplierShop(SupplierShopInfo entity)
{
return(MyDAL.EditSupplierShop(entity));
}
public virtual bool AddSupplierShop(SupplierShopInfo entity)
{
return(MyDAL.AddSupplierShop(entity));
}
public virtual bool EditSupplierShop(SupplierShopInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Supplier_Shop WHERE Shop_ID = " + entity.Shop_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Shop_ID"] = entity.Shop_ID;
DrAdd["Shop_Code"] = entity.Shop_Code;
DrAdd["Shop_Type"] = entity.Shop_Type;
DrAdd["Shop_Name"] = entity.Shop_Name;
DrAdd["Shop_SupplierID"] = entity.Shop_SupplierID;
DrAdd["Shop_Img"] = entity.Shop_Img;
DrAdd["Shop_Css"] = entity.Shop_Css;
DrAdd["Shop_Banner"] = entity.Shop_Banner;
DrAdd["Shop_Banner_Title"] = entity.Shop_Banner_Title;
DrAdd["Shop_Banner_Title_Family"] = entity.Shop_Banner_Title_Family;
DrAdd["Shop_Banner_Title_Size"] = entity.Shop_Banner_Title_Size;
DrAdd["Shop_Banner_Title_LeftPadding"] = entity.Shop_Banner_Title_LeftPadding;
DrAdd["Shop_banner_Title_color"] = entity.Shop_banner_Title_color;
DrAdd["Shop_Banner_Img"] = entity.Shop_Banner_Img;
DrAdd["Shop_Domain"] = entity.Shop_Domain;
DrAdd["Shop_MainProduct"] = entity.Shop_MainProduct;
DrAdd["Shop_SEO_Title"] = entity.Shop_SEO_Title;
DrAdd["Shop_SEO_Keyword"] = entity.Shop_SEO_Keyword;
DrAdd["Shop_SEO_Description"] = entity.Shop_SEO_Description;
DrAdd["Shop_Addtime"] = entity.Shop_Addtime;
DrAdd["Shop_Evaluate"] = entity.Shop_Evaluate;
DrAdd["Shop_Recommend"] = entity.Shop_Recommend;
DrAdd["Shop_Status"] = entity.Shop_Status;
DrAdd["Shop_Hits"] = entity.Shop_Hits;
DrAdd["Shop_Site"] = entity.Shop_Site;
DrAdd["Shop_Banner_IsActive"] = entity.Shop_Banner_IsActive;
DrAdd["Shop_Top_IsActive"] = entity.Shop_Top_IsActive;
DrAdd["Shop_TopNav_IsActive"] = entity.Shop_TopNav_IsActive;
DrAdd["Shop_Info_IsActive"] = entity.Shop_Info_IsActive;
DrAdd["Shop_LeftSearch_IsActive"] = entity.Shop_LeftSearch_IsActive;
DrAdd["Shop_LeftCate_IsActive"] = entity.Shop_LeftCate_IsActive;
DrAdd["Shop_LeftSale_IsActive"] = entity.Shop_LeftSale_IsActive;
DrAdd["Shop_Left_IsActive"] = entity.Shop_Left_IsActive;
DrAdd["Shop_Right_IsActive"] = entity.Shop_Right_IsActive;
DrAdd["Shop_RightProduct_IsActive"] = entity.Shop_RightProduct_IsActive;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
public virtual IList <SupplierShopInfo> GetSupplierShops(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierShopInfo> entitys = null;
SupplierShopInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_Shop";
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 <SupplierShopInfo>();
while (RdrList.Read())
{
entity = new SupplierShopInfo();
entity.Shop_ID = Tools.NullInt(RdrList["Shop_ID"]);
entity.Shop_Code = Tools.NullStr(RdrList["Shop_Code"]);
entity.Shop_Type = Tools.NullInt(RdrList["Shop_Type"]);
entity.Shop_Name = Tools.NullStr(RdrList["Shop_Name"]);
entity.Shop_SupplierID = Tools.NullInt(RdrList["Shop_SupplierID"]);
entity.Shop_Img = Tools.NullStr(RdrList["Shop_Img"]);
entity.Shop_Css = Tools.NullInt(RdrList["Shop_Css"]);
entity.Shop_Banner = Tools.NullInt(RdrList["Shop_Banner"]);
entity.Shop_Banner_Title = Tools.NullStr(RdrList["Shop_Banner_Title"]);
entity.Shop_Banner_Title_Family = Tools.NullStr(RdrList["Shop_Banner_Title_Family"]);
entity.Shop_Banner_Title_Size = Tools.NullInt(RdrList["Shop_Banner_Title_Size"]);
entity.Shop_Banner_Title_LeftPadding = Tools.NullInt(RdrList["Shop_Banner_Title_LeftPadding"]);
entity.Shop_banner_Title_color = Tools.NullStr(RdrList["Shop_banner_Title_color"]);
entity.Shop_Banner_Img = Tools.NullStr(RdrList["Shop_Banner_Img"]);
entity.Shop_Domain = Tools.NullStr(RdrList["Shop_Domain"]);
entity.Shop_MainProduct = Tools.NullStr(RdrList["Shop_MainProduct"]);
entity.Shop_SEO_Title = Tools.NullStr(RdrList["Shop_SEO_Title"]);
entity.Shop_SEO_Keyword = Tools.NullStr(RdrList["Shop_SEO_Keyword"]);
entity.Shop_SEO_Description = Tools.NullStr(RdrList["Shop_SEO_Description"]);
entity.Shop_Addtime = Tools.NullDate(RdrList["Shop_Addtime"]);
entity.Shop_Evaluate = Tools.NullInt(RdrList["Shop_Evaluate"]);
entity.Shop_Recommend = Tools.NullInt(RdrList["Shop_Recommend"]);
entity.Shop_Status = Tools.NullInt(RdrList["Shop_Status"]);
entity.Shop_Hits = Tools.NullInt(RdrList["Shop_Hits"]);
entity.Shop_Site = Tools.NullStr(RdrList["Shop_Site"]);
entity.Shop_Banner_IsActive = Tools.NullInt(RdrList["Shop_Banner_IsActive"]);
entity.Shop_Top_IsActive = Tools.NullInt(RdrList["Shop_Top_IsActive"]);
entity.Shop_TopNav_IsActive = Tools.NullInt(RdrList["Shop_TopNav_IsActive"]);
entity.Shop_Info_IsActive = Tools.NullInt(RdrList["Shop_Info_IsActive"]);
entity.Shop_LeftSearch_IsActive = Tools.NullInt(RdrList["Shop_LeftSearch_IsActive"]);
entity.Shop_LeftCate_IsActive = Tools.NullInt(RdrList["Shop_LeftCate_IsActive"]);
entity.Shop_LeftSale_IsActive = Tools.NullInt(RdrList["Shop_LeftSale_IsActive"]);
entity.Shop_Left_IsActive = Tools.NullInt(RdrList["Shop_Left_IsActive"]);
entity.Shop_Right_IsActive = Tools.NullInt(RdrList["Shop_Right_IsActive"]);
entity.Shop_RightProduct_IsActive = Tools.NullInt(RdrList["Shop_RightProduct_IsActive"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual SupplierShopInfo GetSupplierShopByDomain(string Domain)
{
SupplierShopInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Supplier_Shop WHERE Shop_Domain = '" + Domain + "'";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new SupplierShopInfo();
entity.Shop_ID = Tools.NullInt(RdrList["Shop_ID"]);
entity.Shop_Code = Tools.NullStr(RdrList["Shop_Code"]);
entity.Shop_Type = Tools.NullInt(RdrList["Shop_Type"]);
entity.Shop_Name = Tools.NullStr(RdrList["Shop_Name"]);
entity.Shop_SupplierID = Tools.NullInt(RdrList["Shop_SupplierID"]);
entity.Shop_Img = Tools.NullStr(RdrList["Shop_Img"]);
entity.Shop_Css = Tools.NullInt(RdrList["Shop_Css"]);
entity.Shop_Banner = Tools.NullInt(RdrList["Shop_Banner"]);
entity.Shop_Banner_Title = Tools.NullStr(RdrList["Shop_Banner_Title"]);
entity.Shop_Banner_Title_Family = Tools.NullStr(RdrList["Shop_Banner_Title_Family"]);
entity.Shop_Banner_Title_Size = Tools.NullInt(RdrList["Shop_Banner_Title_Size"]);
entity.Shop_Banner_Title_LeftPadding = Tools.NullInt(RdrList["Shop_Banner_Title_LeftPadding"]);
entity.Shop_banner_Title_color = Tools.NullStr(RdrList["Shop_banner_Title_color"]);
entity.Shop_Banner_Img = Tools.NullStr(RdrList["Shop_Banner_Img"]);
entity.Shop_Domain = Tools.NullStr(RdrList["Shop_Domain"]);
entity.Shop_MainProduct = Tools.NullStr(RdrList["Shop_MainProduct"]);
entity.Shop_SEO_Title = Tools.NullStr(RdrList["Shop_SEO_Title"]);
entity.Shop_SEO_Keyword = Tools.NullStr(RdrList["Shop_SEO_Keyword"]);
entity.Shop_SEO_Description = Tools.NullStr(RdrList["Shop_SEO_Description"]);
entity.Shop_Addtime = Tools.NullDate(RdrList["Shop_Addtime"]);
entity.Shop_Evaluate = Tools.NullInt(RdrList["Shop_Evaluate"]);
entity.Shop_Recommend = Tools.NullInt(RdrList["Shop_Recommend"]);
entity.Shop_Status = Tools.NullInt(RdrList["Shop_Status"]);
entity.Shop_Hits = Tools.NullInt(RdrList["Shop_Hits"]);
entity.Shop_Site = Tools.NullStr(RdrList["Shop_Site"]);
entity.Shop_Banner_IsActive = Tools.NullInt(RdrList["Shop_Banner_IsActive"]);
entity.Shop_Top_IsActive = Tools.NullInt(RdrList["Shop_Top_IsActive"]);
entity.Shop_TopNav_IsActive = Tools.NullInt(RdrList["Shop_TopNav_IsActive"]);
entity.Shop_Info_IsActive = Tools.NullInt(RdrList["Shop_Info_IsActive"]);
entity.Shop_LeftSearch_IsActive = Tools.NullInt(RdrList["Shop_LeftSearch_IsActive"]);
entity.Shop_LeftCate_IsActive = Tools.NullInt(RdrList["Shop_LeftCate_IsActive"]);
entity.Shop_LeftSale_IsActive = Tools.NullInt(RdrList["Shop_LeftSale_IsActive"]);
entity.Shop_Left_IsActive = Tools.NullInt(RdrList["Shop_Left_IsActive"]);
entity.Shop_Right_IsActive = Tools.NullInt(RdrList["Shop_Right_IsActive"]);
entity.Shop_RightProduct_IsActive = Tools.NullInt(RdrList["Shop_RightProduct_IsActive"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
