public void Sys_UpdateReviewApplication() { ProductReviewConfigInfo entity = MyReviewconfig.GetProductReviewConfig(pub.CreateUserPrivilege("b948d76d-944c-4a97-82dc-a3917ce6dcd9")); if (entity == null) { pub.Msg("error", "错误信息", "评论设置记录不存在", true, "/index.aspx"); Response.End(); } else { Application["Product_Review_Config_ID"] = entity.Product_Review_Config_ID; Application["Product_Review_Config_IsActive"] = entity.Product_Review_Config_IsActive; Application["Product_Review_Config_ListCount"] = entity.Product_Review_Config_ListCount; Application["Product_Review_Config_ManagerReply_Show"] = entity.Product_Review_Config_ManagerReply_Show; Application["Product_Review_Config_NoRecordTip"] = entity.Product_Review_Config_NoRecordTip; Application["Product_Review_Config_Power"] = entity.Product_Review_Config_Power; Application["Product_Review_Config_ProductCount"] = entity.Product_Review_Config_ProductCount; Application["Product_Review_Config_Show_SuccessTip"] = entity.Product_Review_Config_Show_SuccessTip; Application["Product_Review_Config_Site"] = entity.Product_Review_Config_Site; Application["Product_Review_Config_VerifyCode_IsOpen"] = entity.Product_Review_Config_VerifyCode_IsOpen; Application["Product_Review_giftcoin"] = entity.Product_Review_giftcoin; Application["Product_Review_Recommendcoin"] = entity.Product_Review_Recommendcoin; } }
public virtual bool EditProductReviewConfig(ProductReviewConfigInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "b948d76d-944c-4a97-82dc-a3917ce6dcd9")) { return(MyDAL.EditProductReviewConfig(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:b948d76d-944c-4a97-82dc-a3917ce6dcd9错误"); } }
public virtual ProductReviewConfigInfo GetProductReviewConfig() { ProductReviewConfigInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT Top 1 * FROM Product_Review_Config"; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ProductReviewConfigInfo(); entity.Product_Review_Config_ID = Tools.NullInt(RdrList["Product_Review_Config_ID"]); entity.Product_Review_Config_ProductCount = Tools.NullInt(RdrList["Product_Review_Config_ProductCount"]); entity.Product_Review_Config_ListCount = Tools.NullInt(RdrList["Product_Review_Config_ListCount"]); entity.Product_Review_Config_Power = Tools.NullInt(RdrList["Product_Review_Config_Power"]); entity.Product_Review_giftcoin = Tools.NullInt(RdrList["Product_Review_giftcoin"]); entity.Product_Review_Recommendcoin = Tools.NullInt(RdrList["Product_Review_Recommendcoin"]); entity.Product_Review_Config_NoRecordTip = Tools.NullStr(RdrList["Product_Review_Config_NoRecordTip"]); entity.Product_Review_Config_VerifyCode_IsOpen = Tools.NullInt(RdrList["Product_Review_Config_VerifyCode_IsOpen"]); entity.Product_Review_Config_ManagerReply_Show = Tools.NullInt(RdrList["Product_Review_Config_ManagerReply_Show"]); entity.Product_Review_Config_Show_SuccessTip = Tools.NullStr(RdrList["Product_Review_Config_Show_SuccessTip"]); entity.Product_Review_Config_IsActive = Tools.NullInt(RdrList["Product_Review_Config_IsActive"]); entity.Product_Review_Config_Site = Tools.NullStr(RdrList["Product_Review_Config_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool EditProductReviewConfig(ProductReviewConfigInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Product_Review_Config WHERE Product_Review_Config_ID = " + entity.Product_Review_Config_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Product_Review_Config_ID"] = entity.Product_Review_Config_ID; DrAdd["Product_Review_Config_ProductCount"] = entity.Product_Review_Config_ProductCount; DrAdd["Product_Review_Config_ListCount"] = entity.Product_Review_Config_ListCount; DrAdd["Product_Review_Config_Power"] = entity.Product_Review_Config_Power; DrAdd["Product_Review_giftcoin"] = entity.Product_Review_giftcoin; DrAdd["Product_Review_Recommendcoin"] = entity.Product_Review_Recommendcoin; DrAdd["Product_Review_Config_NoRecordTip"] = entity.Product_Review_Config_NoRecordTip; DrAdd["Product_Review_Config_VerifyCode_IsOpen"] = entity.Product_Review_Config_VerifyCode_IsOpen; DrAdd["Product_Review_Config_ManagerReply_Show"] = entity.Product_Review_Config_ManagerReply_Show; DrAdd["Product_Review_Config_Show_SuccessTip"] = entity.Product_Review_Config_Show_SuccessTip; DrAdd["Product_Review_Config_IsActive"] = entity.Product_Review_Config_IsActive; DrAdd["Product_Review_Config_Site"] = entity.Product_Review_Config_Site; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }
//编辑评论设置信息 public void EditProductReviewConfig() { int Product_Review_Config_ID = tools.CheckInt(Request.Form["Product_Review_Config_ID"]); int Product_Review_Config_ProductCount = tools.CheckInt(Request.Form["Product_Review_Config_ProductCount"]); int Product_Review_Config_ListCount = tools.CheckInt(Request.Form["Product_Review_Config_ListCount"]); int Product_Review_Config_Power = tools.CheckInt(Request.Form["Product_Review_Config_Power"]); int Product_Review_giftcoin = tools.CheckInt(Request.Form["Product_Review_giftcoin"]); int Product_Review_Recommendcoin = tools.CheckInt(Request.Form["Product_Review_Recommendcoin"]); string Product_Review_Config_NoRecordTip = tools.CheckStr(Request.Form["Product_Review_Config_NoRecordTip"]); int Product_Review_Config_VerifyCode_IsOpen = tools.CheckInt(Request.Form["Product_Review_Config_VerifyCode_IsOpen"]); int Product_Review_Config_ManagerReply_Show = tools.CheckInt(Request.Form["Product_Review_Config_ManagerReply_Show"]); string Product_Review_Config_Show_SuccessTip = tools.CheckStr(Request.Form["Product_Review_Config_Show_SuccessTip"]); int Product_Review_Config_IsActive = tools.CheckInt(Request.Form["Product_Review_Config_IsActive"]); string Product_Review_Config_Site = tools.CheckStr(Request.Form["Product_Review_Config_Site"]); ProductReviewConfigInfo entity = new ProductReviewConfigInfo(); entity.Product_Review_Config_ID = Product_Review_Config_ID; entity.Product_Review_Config_ProductCount = Product_Review_Config_ProductCount; entity.Product_Review_Config_ListCount = Product_Review_Config_ListCount; entity.Product_Review_Config_Power = Product_Review_Config_Power; entity.Product_Review_giftcoin = Product_Review_giftcoin; entity.Product_Review_Recommendcoin = Product_Review_Recommendcoin; entity.Product_Review_Config_NoRecordTip = Product_Review_Config_NoRecordTip; entity.Product_Review_Config_VerifyCode_IsOpen = Product_Review_Config_VerifyCode_IsOpen; entity.Product_Review_Config_ManagerReply_Show = Product_Review_Config_ManagerReply_Show; entity.Product_Review_Config_Show_SuccessTip = Product_Review_Config_Show_SuccessTip; entity.Product_Review_Config_IsActive = Product_Review_Config_IsActive; entity.Product_Review_Config_Site = Product_Review_Config_Site; if (Myconfig.EditProductReviewConfig(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "/shop/shop_evaluate_set.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void EditProductReview(string action) { int review_id = tools.CheckInt(Request.QueryString["review_id"]); int Review_count = 0; int Star_count = 0; int reviews_count = 0; double Review_Average = 0; if (review_id > 0) { ProductReviewInfo review = Myreview.GetProductReviewByID(review_id, Public.GetUserPrivilege()); if (review != null) { int Product_Review_ID = review.Product_Review_ID; int Product_Review_MemberID = review.Product_Review_MemberID; int Product_Review_ProductID = review.Product_Review_ProductID; DateTime Product_Review_Addtime = review.Product_Review_Addtime; string Product_Review_Content = review.Product_Review_Content; int Product_Review_IsBuy = review.Product_Review_IsBuy; int Product_Review_IsRecommend = review.Product_Review_IsRecommend; int Product_Review_IsShow = review.Product_Review_IsShow; int Product_Review_Star = review.Product_Review_Star; string Product_Review_Subject = review.Product_Review_Subject; int Product_Review_Useful = review.Product_Review_Useful; int Product_Review_Useless = review.Product_Review_Useless; int Product_Review_IsGift = review.Product_Review_IsGift; int Product_Review_IsView = review.Product_Review_IsView; switch (action) { case "recommend": Product_Review_IsRecommend = 1; break; case "recommendcancel": Product_Review_IsRecommend = 0; break; case "show": Product_Review_IsShow = 1; break; case "showcancel": Product_Review_IsShow = 0; break; case "reviewview": Product_Review_IsView = 1; break; } ProductReviewInfo entity = new ProductReviewInfo(); entity.Product_Review_ID = Product_Review_ID; entity.Product_Review_ProductID = Product_Review_ProductID; entity.Product_Review_MemberID = Product_Review_MemberID; entity.Product_Review_Star = Product_Review_Star; entity.Product_Review_Subject = Product_Review_Subject; entity.Product_Review_Content = Product_Review_Content; entity.Product_Review_Useful = Product_Review_Useful; entity.Product_Review_Useless = Product_Review_Useless; entity.Product_Review_Addtime = Product_Review_Addtime; entity.Product_Review_IsShow = Product_Review_IsShow; entity.Product_Review_IsBuy = Product_Review_IsBuy; entity.Product_Review_IsRecommend = Product_Review_IsRecommend; if (action == "show") { entity.Product_Review_IsGift = 1; } else { entity.Product_Review_IsGift = Product_Review_IsGift; } entity.Product_Review_Site = Public.GetCurrentSite(); if (Myreview.EditProductReview(entity, Public.GetUserPrivilege())) { ProductInfo productinfo = Myproduct.GetProductByID(Product_Review_ProductID, Public.GetUserPrivilege()); if (productinfo != null) { Review_Average = productinfo.Product_Review_Average; reviews_count = productinfo.Product_Review_Count; } switch (action) { case "show": Review_count = Myreview.GetProductReviewValidCount(Product_Review_ProductID); if (Review_count > 0) { Review_Average = ((Review_Average * (Review_count - 1)) + Product_Review_Star) / Review_count; Myreview.UpdateProductReviewINfo(Product_Review_ProductID, Review_Average, reviews_count, Review_count); } ProductReviewConfigInfo config = GetProductReviewConfig(); if (config != null) { if (config.Product_Review_giftcoin > 0 && Product_Review_MemberID > 0 && Product_Review_IsGift == 0) { member.Member_Coin_AddConsume(config.Product_Review_giftcoin, "发表评论赠送积分", Product_Review_MemberID, true); } } break; case "showcancel": Review_count = Myreview.GetProductReviewValidCount(Product_Review_ProductID); Star_count = Myreview.GetProductStarCount(Product_Review_ProductID); if (Review_count > 0) { Review_Average = Star_count / Review_count; Myreview.UpdateProductReviewINfo(Product_Review_ProductID, Review_Average, reviews_count, Review_count); } else { Myreview.UpdateProductReviewINfo(Product_Review_ProductID, 0, reviews_count, 0); } break; case "recommend": ProductReviewConfigInfo configreview = GetProductReviewConfig(); if (configreview != null) { if (configreview.Product_Review_Recommendcoin > 0 && Product_Review_MemberID > 0) { member.Member_Coin_AddConsume(configreview.Product_Review_Recommendcoin, "评论推荐赠送积分", Product_Review_MemberID, true); } } break; } Response.Redirect("Product_Review_list.aspx"); } else { Response.Redirect("Product_Review_list.aspx"); } } } }