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