public void UpdateProductReply(ProductReplyInfo productReply)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@content", SqlDbType.NText) };
pt[0].Value = productReply.ID;
pt[1].Value = productReply.Content;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateProductReply", pt);
}
/// <summary>
/// 添加回复
/// </summary>
/// <param name="result"></param>
public void AddProductReply(ref string result)
{
int productID = RequestHelper.GetQueryString <int>("ProductID");
int commentID = RequestHelper.GetQueryString <int>("CommentID");
string replytCookies = CookiesHelper.ReadCookieValue("ReplytCookies" + commentID.ToString());
if (ShopConfig.ReadConfigInfo().ReplyRestrictTime > 0 && replytCookies != string.Empty)
{
result = "请不要频繁提交";
}
else
{
ProductReplyInfo productReply = new ProductReplyInfo();
productReply.ProductID = productID;
productReply.CommentID = commentID;
productReply.Content = StringHelper.AddSafe(RequestHelper.GetQueryString <string>("Content"));
productReply.UserIP = ClientHelper.IP;
productReply.PostDate = RequestHelper.DateNow;
productReply.UserID = base.UserID;
productReply.UserName = base.UserName;
ProductReplyBLL.AddProductReply(productReply);
if (ShopConfig.ReadConfigInfo().ReplyRestrictTime > 0)
{
CookiesHelper.AddCookie("ReplytCookies" + commentID.ToString(), "ReplytCookies" + commentID.ToString(), ShopConfig.ReadConfigInfo().ReplyRestrictTime, TimeType.Second);
}
}
}
/// <summary>
/// 读取一条商品回复数据
/// </summary>
/// <param name="id">商品回复的主键值</param>
/// <param name="userID">用户ID</param>
/// <returns>商品回复数据模型</returns>
public ProductReplyInfo ReadProductReply(int id, int userID)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.NVarChar),
new SqlParameter("@userID", SqlDbType.Int)
};
parameters[0].Value = id;
parameters[1].Value = userID;
ProductReplyInfo productReply = new ProductReplyInfo();
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadProductReply", parameters))
{
if (dr.Read())
{
productReply.ID = dr.GetInt32(0);
productReply.ProductID = dr.GetInt32(1);
productReply.CommentID = dr.GetInt32(2);
productReply.Content = dr[3].ToString();
productReply.UserIP = dr[4].ToString();
productReply.PostDate = dr.GetDateTime(5);
productReply.UserID = dr.GetInt32(6);
productReply.UserName = dr[7].ToString();
}
}
return(productReply);
}
public void AddProductReply(ref string result)
{
int queryString = RequestHelper.GetQueryString <int>("ProductID");
int num2 = RequestHelper.GetQueryString <int>("CommentID");
string str = CookiesHelper.ReadCookieValue("ReplytCookies" + num2.ToString());
if ((ShopConfig.ReadConfigInfo().ReplyRestrictTime > 0) && (str != string.Empty))
{
result = "Ç벻ҪƵ·±Ìá½»";
}
else
{
ProductReplyInfo productReply = new ProductReplyInfo();
productReply.ProductID = queryString;
productReply.CommentID = num2;
productReply.Content = StringHelper.AddSafe(RequestHelper.GetQueryString <string>("Content"));
productReply.UserIP = ClientHelper.IP;
productReply.PostDate = RequestHelper.DateNow;
productReply.UserID = base.UserID;
productReply.UserName = base.UserName;
ProductReplyBLL.AddProductReply(productReply);
if (ShopConfig.ReadConfigInfo().ReplyRestrictTime > 0)
{
CookiesHelper.AddCookie("ReplytCookies" + num2.ToString(), "ReplytCookies" + num2.ToString(), ShopConfig.ReadConfigInfo().ReplyRestrictTime, TimeType.Second);
}
}
}
public static void UpdateProductReply(ProductReplyInfo productReply)
{
ProductReplyInfo info = ReadProductReply(productReply.ID, 0);
dal.UpdateProductReply(productReply);
if (productReply.CommentID != info.CommentID)
{
ProductCommentBLL.ChangeProductCommentCount(info.CommentID, ChangeAction.Minus);
ProductCommentBLL.ChangeProductCommentCount(productReply.CommentID, ChangeAction.Plus);
}
}
public int AddProductReply(ProductReplyInfo productReply)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@commentID", SqlDbType.Int), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@userIP", SqlDbType.NVarChar), new SqlParameter("@postDate", SqlDbType.DateTime), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) };
pt[0].Value = productReply.ProductID;
pt[1].Value = productReply.CommentID;
pt[2].Value = productReply.Content;
pt[3].Value = productReply.UserIP;
pt[4].Value = productReply.PostDate;
pt[5].Value = productReply.UserID;
pt[6].Value = productReply.UserName;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddProductReply", pt)));
}
public void PrepareProductReplyModel(SqlDataReader dr, List <ProductReplyInfo> productReplyList)
{
while (dr.Read())
{
ProductReplyInfo item = new ProductReplyInfo();
item.ID = dr.GetInt32(0);
item.ProductID = dr.GetInt32(1);
item.CommentID = dr.GetInt32(2);
item.Content = dr[3].ToString();
item.UserIP = dr[4].ToString();
item.PostDate = dr.GetDateTime(5);
item.UserID = dr.GetInt32(6);
item.UserName = dr[7].ToString();
productReplyList.Add(item);
}
}
public ProductReplyInfo ReadProductReply(int id, int userID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int) };
pt[0].Value = id;
pt[1].Value = userID;
ProductReplyInfo info = new ProductReplyInfo();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadProductReply", pt))
{
if (reader.Read())
{
info.ID = reader.GetInt32(0);
info.ProductID = reader.GetInt32(1);
info.CommentID = reader.GetInt32(2);
info.Content = reader[3].ToString();
info.UserIP = reader[4].ToString();
info.PostDate = reader.GetDateTime(5);
info.UserID = reader.GetInt32(6);
info.UserName = reader[7].ToString();
}
}
return(info);
}
public static int AddProductReply(ProductReplyInfo productReply)
{
productReply.ID = dal.AddProductReply(productReply);
ProductCommentBLL.ChangeProductCommentCount(productReply.CommentID, ChangeAction.Plus);
return(productReply.ID);
}
