public static BBSTopicMaster ChangeCommentStatusProcess(BBSTopicMaster entity)
{
// 经验：带脏词 经验可疑
//经验：不带脏词，普通
//经验：不带脏词，带询问词，普通询问
//讨论：
//带脏词 作废
//不带脏词，普通
//不带脏词，带询问词，普通询问
if (!CheckDirtyWords(entity.Title, entity.TopicContent))
{
if (CheckQuestionWords(entity.Title, entity.TopicContent))
{
entity.Status = (int)CommentStatus.Question;
}
else
{
entity.Status = (int)CommentStatus.Normal;
}
}
else
{
if (entity.TopicType == (int)CommentType.Experience)
{
entity.Status = (int)CommentStatus.OnLineNotShowWord;
}
else
{
entity.Status = (int)CommentStatus.Abandon;
}
}
return(entity);
}
public static void SetProductRemarkCountRemarkScore(BBSTopicMaster item)
{
DataCommand dc = DataCommandManager.GetDataCommand("SetProductRemarkCountRemarkScore");
dc.SetParameterValue("@ReferenceSysNo", item.ReferenceSysNo);
dc.SetParameterValue("@CompanyCode", CompanyCode);
dc.ExecuteNonQuery();
}
public static List <BBSTopicMaster> GetBBSMasterListBySysNo(BBSTopicMaster entity)
{
List <BBSTopicMaster> entitylist = null;
DataCommand command = DataCommandManager.GetDataCommand("GetBBSMasterListBySysNo");
command.SetParameterValue("@CommentSysNo", entity.CommentSysNo);
entitylist = command.ExecuteEntityList <BBSTopicMaster>();
return(entitylist);
}
public static int CheckPointLogByCommentSysNo(BBSTopicMaster entity)
{
DataCommand command = DataCommandManager.GetDataCommand("CheckPointLogByCommentSysNo");
command.SetParameterValue("@CustomerSysNo", entity.CreateCustomerSysNo);
command.SetParameterValue("@CommentSysNo", entity.CommentSysNo.ToString());
command.SetParameterValue("@CompanyCode", CompanyCode);
return(command.ExecuteScalar <int>());
}
public static void UpdateBBSTopicMaster(BBSTopicMaster entity)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateBBSTopicMaster");
command.SetParameterValue("@SysNo", entity.CommentSysNo);
command.SetParameterValue("@Status", entity.Status);
command.SetParameterValue("@IsAddPoint", entity.IsAddPoint);
command.SetParameterValue("@CompanyCode", CompanyCode);
command.ExecuteNonQuery();
}
private static void SendItemCommentFirstShowEmailToPM(BBSTopicMaster entity)
{
if (entity == null)
{
return;
}
//后台在评论在第一次显示时，发送email给相应的PM。
#region mail subject&body
string mailBody = @"<p>您好，@CustomerID</p><p>新蛋网商品（@ProductName）的评论已设置为展示：<br/>“@CommentContent”<br/>" +
"<br/>要查看全部的评论和回复，请访问以下的链接：<br/><a href='http://www.newegg.com.cn/Product/@ProductID.htm'>http://www.newegg.com.cn/Product/@ProductID.htm</a> <br/>谢谢" +
"!<br/>中国新蛋网<br/> @SendDateString <br/>备注:本邮件是由邮件系统发送，请勿直接回复。 </p>";
string mailSubject = "新蛋网商品（@ProductID）的评论(@Title)已设置为展示";
#endregion
try
{
List <BBSTopicMaster> list = ShowCommentDA.GetBBSMasterListBySysNo(entity);
if (list != null)
{
//没加过积分，没发过邮件
if (list[0].IsAddPoint != 1 && entity.IsAddPoint != 2)
{
mailSubject = mailSubject.Replace("@ProductID", entity.ProductID).
Replace("@Title", entity.Title);
mailBody = mailBody.Replace("@CustomerID", entity.PMUserName).
Replace("@ProductName", entity.ProductName).
Replace("@ProductID", entity.ProductID).
Replace("@SendDateString", System.DateTime.Now.ToString()).
Replace("@CommentContent", entity.TopicContent.Trim()
);
ShowCommentDA.SendEmail2MailDbWhenCommentShow(entity.PMEmailAddress,
mailSubject, mailBody, entity.CompanyCode);
}
}
}
catch (Exception er)
{
throw new Exception(er.Message);
}
}
public static void AddShowCommentPointForCustomersFromMKT(List <CustomerInfo> customersPoint, BBSTopicMaster comment)
{
if (customersPoint == null || customersPoint.Count == 0)
{
return;
}
List <ECCentral.BizEntity.Customer.CustomerPointsAddRequest> request = new List <ECCentral.BizEntity.Customer.CustomerPointsAddRequest>();
customersPoint.ForEach(c =>
{
request.Add(new ECCentral.BizEntity.Customer.CustomerPointsAddRequest()
{
CustomerSysNo = c.CustomerSystemNumber,
Point = c.CustomerGotPoint,
PointType = 16,
NewEggAccount = "MKT-topic",
Memo = comment.CommentSysNo.ToString(),
Note = "后台设置屏蔽的评论为展示"
});
});
string baseUrl = System.Configuration.ConfigurationManager.AppSettings["CustomerRestFulBaseUrl"];
string languageCode = System.Configuration.ConfigurationManager.AppSettings["LanguageCode"];
string companyCode = System.Configuration.ConfigurationManager.AppSettings["CompanyCode"];
ECCentral.Job.Utility.RestClient client = new ECCentral.Job.Utility.RestClient(baseUrl, languageCode);
ECCentral.Job.Utility.RestServiceError error;
var ar = client.Create("/Point/BatchAdjustPoint", request, out error);
if (error != null && error.Faults != null && error.Faults.Count > 0)
{
string errorMsg = "";
foreach (var errorItem in error.Faults)
{
errorMsg += errorItem.ErrorDescription;
}
ECCentral.Job.Utility.Logger.WriteLog(errorMsg, "IPP.MKT.AutoNewsReplyIsShow");
}
//IBatchAdjustPointV31 service = ServiceBroker.FindService<IBatchAdjustPointV31>();
//BatchMessageV31<AdjustPointRequestMsg> actionPara = new BatchMessageV31<AdjustPointRequestMsg>()
//{
// Messages = (from item in customersPoint
// select new AdjustPointRequestMsg()
// {
// CustomerSysNo = item.CustomerSystemNumber,
// Point = item.CustomerGotPoint,
// PointLogType = 16,
// NewEggAccount = "MKT-topic",
// Memo = comment.CommentSysNo.ToString(),
// Note = "后台设置屏蔽的评论为展示"
// }).ToList()
//};
//actionPara.Header = new MessageHeader();
//actionPara.Header.CompanyCode = CompanyCode;
//actionPara.Header.Language = "zh-CN";
//actionPara.Header.OperationUser = new OperationUser();
//actionPara.Header.OperationUser.CompanyCode = CompanyCode;
//actionPara.Header.OperationUser.LogUserName = "******";
//actionPara.Header.OperationUser.UniqueUserName = "******";
//actionPara.Header.OperationUser.SourceUserName = "******";
//actionPara.Header.OperationUser.FullName = "IPPSystemAdmin";
//actionPara.Header.OperationUser.SourceDirectoryKey = "bitkoo";
//DefaultDataContract result = service.BatchAdjustPoint(actionPara);
//ServiceAdapterHelper.DealServiceFault(result);
}
private static void ReplyIsFirstShowSendMail(BBSTopicReply entity)
{
//并发送email给相应的PM(topiclasteditsysno)，评论发起者(TopicCreateCustomerSysNo),所有评论回复者
string MailSubject = @"您关于@ProductName的评论被回复啦";
List <string> emailaddressList = new List <string>();
StringBuilder sb = new StringBuilder();
BBSTopicMaster master = new BBSTopicMaster();
master.CommentSysNo = entity.TopicSysNo;
//获取该回复的主题评论信息
List <BBSTopicMaster> Commentlist = ShowCommentDA.GetBBSMasterListBySysNo(master);
#region MailBody
string MailBody = @"<!DOCTYPE HTML PUBLIC \'-//W3C//DTD XHTML 1.0 Transitional//EN\'><html xmlns=\'http:" +
"//www.w3.org/1999/xhtml\'>\r\n<head><title>\r\n\tUntitled Page\r\n</title><link href=\'ht" +
"tp://www.newegg.com.cn/WebResources/css/MailCss.css\' rel=\'stylesheet\'\r\n t" +
"ype=\'text/css\' />\r\n\r\n \r\n\r\n</head>\r\n<body>\r\n\r\n<div id=\'outside1\'>\r\n " +
" <div id=\'outside2\'>\r\n <div id=\'head\'>\r\n <div " +
" style=\'background: url(http://img8.newegg.com.cn/neweggPic2/Marketing/hf/head_b" +
"g.jpg);height: 76px;width: 620px;margin: 0px 0px 20px 0px;\'>\r\n " +
" <div id=\'logo\'>\r\n <a href=\'http://www.newegg.co" +
"m.cn/\'>\r\n <img title=\'新蛋网\' height=\'51\' alt=\'新蛋网\' " +
"src=\'http://www.newegg.com.cn/WebResources/images/MailImages/logo.jpg\'\r\n " +
" width=\'258\' /></a></div>\r\n <d" +
"iv id=\'tel\'>\r\n 全国服务热线：400-820-4400</div>\r\n " +
" \r\n </div>\r\n </div>\r\n " +
" <div id=\'content\'>\r\n <table border=\'0\' cellpadding=\'0\' cells" +
"pacing=\'0\' class=\'table01\'>\r\n <tr class=\'table_col01\'>\r\n " +
" <td class=\'table_lt\'> \r\n " +
" </td>\r\n <td class=\'table_tb\'> \r\n " +
" </td>\r\n <td class=\'table_rt\'> \r\n " +
" </td>\r\n </tr>\r\n " +
" <tr class=\'table_col01\'>\r\n <td> \r\n " +
" </td>\r\n <td>\r\n " +
" <div id=\'status_forReply\'>\r\n </div>\r\n " +
" <div id=\'status_iconforReply\'>\r\n " +
" </div>\r\n </td>\r\n " +
" <td> \r\n </td>\r\n </tr>\r" +
"\n <tr>\r\n <td class=\'table_lb\'>" +
" \r\n </td>\r\n <td class=\'" +
"table_tb\'> \r\n </td>\r\n <" +
"td class=\'table_rb\'> \r\n </td>\r\n " +
" </tr>\r\n </table>\r\n <div class=\'subhea" +
"d\'>\r\n <span></span>\r\n <div>\r\n " +
" 评论详情</div>\r\n </div>\r\n " +
" <table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' class=\'table01\'>\r\n " +
" <tr class=\'table_col01\'>\r\n <td class=\'" +
"table_lt\'> \r\n </td>\r\n <" +
"td class=\'td_width02 table_tb\'> \r\n </td>\r\n " +
" <td class=\'table_tb\'> \r\n </td>" +
"\r\n <td class=\'td_width03 table_tb\'> \r\n " +
" </td>\r\n <td class=\'td_width03 table_t" +
"b\'> \r\n </td>\r\n <td clas" +
"s=\'td_width03 table_tb\'> \r\n </td>\r\n " +
" <td class=\'table_rt\'> \r\n </td>\r\n " +
" </tr>\r\n <tr>\r\n " +
" <td> \r\n </td>\r\n <td" +
" colspan=\'5\'>\r\n <ul>\r\n " +
" <li>相关评论内容及该评论下的所有回复</li>\r\n </ul>\r\n\r\n@AllT" +
"opicContent\r\n </td>\r\n <td>" +
" \r\n </td>\r\n </tr>\r\n " +
" <tr>\r\n <td class=\'table_lb\'> \r\n " +
" </td>\r\n\r\n <td class=\'table_t" +
"b\'> \r\n </td>\r\n <td clas" +
"s=\'table_tb\'> \r\n </td>\r\n " +
" <td class=\'table_tb\'> \r\n </td>\r\n " +
" <td class=\'table_tb\'> \r\n </td>\r\n " +
" <td class=\'table_tb\'> \r\n </t" +
"d>\r\n <td class=\'table_rb\'> \r\n " +
" </td>\r\n </tr>\r\n </table>\r\n " +
" <br />\r\n <table width=\'100%\' border=\'0\' cellpa" +
"dding=\'0\'>\r\n <tr>\r\n <td height=\'27\'>" +
" 您可以点击@TopicReplyLink，继续与其他的蛋友们分" +
"享您的心得和体会哦~</td>\r\n </tr>\r\n<tr>\r\n <td " +
"height=\'27\'>不想再收到此类邮件？点击<a href=\'http://www.newegg.com.cn/Favorite/ModifyPersona" +
"lData.aspx?SubItem=02&type=1\' target=\'_blank\'><span style=\'font-size: 12pt\'><i><" +
"u>这里</u></i></span></a>前往帐户中心进行设置</td>\r\n </tr>\r\n\r\n " +
" </table>\r\n \r\n <table border=\'0\' cel" +
"lpadding=\'0\' cellspacing=\'0\' class=\'table01\'>\r\n <tr>\r\n " +
" <td style=\'width: 5px\'>\r\n </" +
"td>\r\n <td id=\'Memo\' colspan=\'3\'></td>\r\n\r\n " +
" </tr>\r\n </table>\r\n \r\n " +
" <br>\r\n </div>\r\n <div id=\'foot\'>\r\n " +
" <div id=\'bar02\'>\r\n <div id=\'bar02_left\'>\r\n " +
" </div>\r\n <div id=\'bar02_right\'>\r\n " +
" </div>\r\n </div>\r\n <" +
"div id=\'foot_text\'>\r\n <div align=\'center\'>上海新蛋电子商务有限公司(<a" +
" href=\'http://www.newegg.com.cn\'>www.newegg.com.cn</a>) | 美国新蛋(<a href=\'http://w" +
"ww.newegg.com\'>www.newegg.com</a>)<br>\r\n 公司地址：上海延安西路号华敏翰尊" +
"国际楼<br>\r\n 公司邮编：<br>\r\n 订购电话：400-820-44" +
"00<br>\r\n 电子邮件：<a href=\'mailto:[email protected]\'>supp" +
"[email protected] </a> </div>\r\n </div>\r\n </div>\r" +
"\n </div>\r\n </div>\r\n</body>\r\n</html>";
#endregion
if (Commentlist != null && Commentlist.Count > 0)
{
BBSTopicMaster topicMaster = Commentlist[0];
#region 产品标题部分
string productLink = "http://www.newegg.com.cn/Products/ProductDetail.aspx?sysno=" + topicMaster.ReferenceSysNo;
sb = new StringBuilder(" <table cellpadding='0' cellspacing='0' width='80%' bordercolor='#cccccc' style='border-top: Silver 1px solid;word-break:break-all'>");
sb.Append("<tr><td colspan='2'><a href='" + productLink + "' target='_blank'><span style='font-size: 12pt'><b>商品：</b>" + topicMaster.ProductName + "</span></a><br/><hr border='1'/></td></tr>");
sb.Append("<tr><td style='padding-left: 5px; padding-top: 3px; height: 20px; width: 219px;'>");
sb.Append("<strong><span style='color: black'>" + topicMaster.Title + "</td><td align='right'> </td></tr>");
sb.Append("<tr><td colspan='2' style='padding-left: 10px;'>" + topicMaster.TopicContent.ToString().Replace("\r\n", "<br />") + "</td></tr>");
sb.Append("<tr style='height: 20px;'><td colspan='2' align='right' style='height: 20px'>");
sb.Append("<strong>" + topicMaster.CustomerName + "</strong> 评论于" + topicMaster.CreateDate.ToString("yyyy-MM-dd HH:mm") + " </td></tr>");
#endregion
#region 回复部分
sb.Append("<tr><td colspan='2' style='padding-left: 10px;'>");
sb.Append("<table width='100%' cellpadding='0' cellspacing='0' style='border-top: gainsboro 1px solid'><tr> <td style='width: 32px' valign='top'><span style='color: royalblue'><strong>回复</strong></span></td><td>");
//发邮件该商品的PM
if (!string.IsNullOrEmpty(Commentlist[0].PMEmailAddress))
{
emailaddressList.Add(Commentlist[0].PMEmailAddress);
}
if (Commentlist[0].IsSubscribe == 1)
{
emailaddressList.Add(Commentlist[0].CustomerEmail);
}
List <BBSTopicReply> replylist = ShowCommentDA.GetAllShowBBSTopicReplyByTopicSysNo(entity.TopicSysNo);
if (replylist != null && replylist.Count > 0)
{
foreach (BBSTopicReply repInfo in replylist)
{
sb.Append("<table width='100%' cellpadding='0' cellspacing='0'>");
sb.Append("<tr style='" + (repInfo == null ? "background-color:#FFFFCC;" : " ") + "'><td>");
sb.Append("<img src='http://www.newegg.com.cn/WebResources/Images/BBS/arrow_blue_right.gif' /> " + repInfo.ReplyContent.ToString().Replace("\r\n", "<br />"));
sb.Append(" " + (Convert.ToInt32(repInfo.WithAdditionalText) == 1 ? (repInfo == null ? "感谢您对新蛋网的关注与支持，祝您购物愉快！" : "") : "") + "</td></tr>");
sb.Append(" <tr><td align='right' valign='top' style='word-break: normal'><strong>");
sb.Append(repInfo.CreateUserType != 0 ? "新蛋网" : repInfo.ReplyCustomerName + "</strong>");
sb.Append(" 回复于 " + Convert.ToDateTime(repInfo.CreateDate).ToString("yyyy-MM-dd HH:mm") + " ");
sb.Append("</td></tr></table>");
if (repInfo.IsFirstShow == 1)
{
if (!string.IsNullOrEmpty(repInfo.ReplyCustomerEmail) &&
repInfo.CreateUserSysNo != entity.CreateUserSysNo &&
repInfo.IsSubscribe == 1 && repInfo.CreateUserType == 0 &&
!emailaddressList.Contains(repInfo.ReplyCustomerEmail))
{
emailaddressList.Add(repInfo.ReplyCustomerEmail); //所有评论回复已展示的回复者
}
}
}
sb.Append(" </td></tr></table>");
sb.Append("</td></tr>");
sb.Append("</table>");
string replyLink = "http://www.newegg.com.cn/Products/AddTopicReply.aspx?ReplyTopicSysNo="
+ entity.TopicSysNo + "&ProductSysNo=" + topicMaster.ReferenceSysNo;
MailBody = MailBody.Replace("@TopicReplyLink", "<a href='" + replyLink + "' target='_blank'><span style='font-size: 14pt'><i><u>回复</u></i></span></a>");
}
MailSubject = MailSubject.Replace("@ProductName", topicMaster.ProductName);
MailBody = MailBody.Replace("@AllTopicContent", sb.ToString())
.Replace("@ProductSysNo", topicMaster.ReferenceSysNo.ToString());
#endregion
}
emailaddressList.Distinct();
foreach (string emailAddress in emailaddressList)
{
bool mailstatus = ShowCommentDA.InsertReplyMail(emailAddress, string.Empty, MailSubject, MailBody);
if (!mailstatus)
{
throw new Exception(DateTime.Now + "对评论" + entity.TopicSysNo + "的回复"
+ entity.TopicReplySysNo + "第一次展示发邮件通知出错！");
}
}
WriteLog("评论" + Commentlist[0].CommentSysNo + "下的回复" + entity.TopicReplySysNo
+ "展示成功。并发送email给相应的PM，评论发起者,所有评论回复者。");
}
public static void AddExperienceCommentPoint(BBSTopicMaster item)
{
int addpoint = 0;
int rank = ShowCommentDA.GetCustomerRank(item.CreateCustomerSysNo);
CustomerInfo customer = new CustomerInfo();
customer.CustomerSystemNumber = item.CreateCustomerSysNo;
List <CustomerInfo> customerlist = new List <CustomerInfo>();
if (rank != -999)
{
switch (rank)
{
//初级会员：1个积分 --------------1
//<add key="JuniorMember" value="1" />
//<add key="BronzeMember" value="3" />
//<add key="GoldMember" value="5" />
//<add key="DiamondMember" value="10" />
//<add key="SuperEggMember" value="15" />
case 1:
customer.CustomerGotPoint = JuniorMemberScore;
addpoint = JuniorMemberScore;
break;
//青铜会员：3个积分 --------------2
case 2:
customer.CustomerGotPoint = BronzeMemberScore;
addpoint = BronzeMemberScore;
break;
//白银会员、黄金会员：5个积分 ----3,4
case 3:
case 4:
customer.CustomerGotPoint = GoldMemberScore;
addpoint = GoldMemberScore;
break;
//钻石会员、皇冠会员：10个积分 ----5,6
case 5:
case 6:
customer.CustomerGotPoint = DiamondMemberScore;
addpoint = DiamondMemberScore;
break;
//至尊蛋黄：15个积分 -------------7
case 7:
customer.CustomerGotPoint = SuperEggMemberScore;
addpoint = SuperEggMemberScore;
break;
}
customerlist.Add(customer);
try
{
AddShowCommentPointForCustomersFromMKT(customerlist, item);
}
catch (Exception er)
{
throw new BusinessException(er.Message);
}
}
item.IsAddPoint = 1;
WriteLog(DateTime.Now + " 该经验评论加积分" + addpoint);
}