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