/// <summary>
/// 收藏产品
/// </summary>
public void Collect()
{
string result = string.Empty;
int productID = RequestHelper.GetQueryString <int>("ProductID");
if (productID > 0)
{
if (base.UserId == 0)
{
result = "还未登录";
}
else
{
if (ProductCollectBLL.Read(productID, base.UserId).Id > 0)
{
result = "您已经收藏了该产品";
}
else
{
ProductCollectInfo productCollect = new ProductCollectInfo();
productCollect.ProductId = productID;
productCollect.Tm = RequestHelper.DateNow;
productCollect.UserId = base.UserId;
ProductCollectBLL.Add(productCollect);
result = "成功收藏";
}
}
}
else
{
result = "请选择产品";
}
ResponseHelper.Write(result);
ResponseHelper.End();
}
/// <summary>
/// 移到我的收藏
/// </summary>
private void Collect()
{
string strCartId = StringHelper.SearchSafe(RequestHelper.GetQueryString <string>("StrProductId"));
if (string.IsNullOrEmpty(strCartId))
{
ResponseHelper.Write("error|请选择商品！");
ResponseHelper.End();
}
if (base.UserId == 0)
{
ResponseHelper.Write("error|还未登录！");
ResponseHelper.End();
}
int[] ids = Array.ConvertAll <string, int>(strCartId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), k => Convert.ToInt32(k));
foreach (var id in ids)
{
if (ProductCollectBLL.Read(id, base.UserId).Id < 1)
{
ProductCollectInfo productCollect = new ProductCollectInfo();
productCollect.ProductId = id;
productCollect.Tm = RequestHelper.DateNow;
productCollect.UserId = base.UserId;
ProductCollectBLL.Add(productCollect);
}
}
ResponseHelper.Write("error|成功收藏！");
ResponseHelper.End();
}
public void UpdateProductCollect(ProductCollectInfo productCollect)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@productID", SqlDbType.Int) };
pt[0].Value = productCollect.ID;
pt[1].Value = productCollect.ProductID;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateProductCollect", pt);
}
public int AddProductCollect(ProductCollectInfo productCollect)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@date", SqlDbType.DateTime), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) };
pt[0].Value = productCollect.ProductID;
pt[1].Value = productCollect.Date;
pt[2].Value = productCollect.UserID;
pt[3].Value = productCollect.UserName;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddProductCollect", pt)));
}
public int Add(ProductCollectInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO ProductCollect( ProductId,Tm,UserId) VALUES(@ProductId,@Tm,@UserId);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
public void PrepareProductCollectModel(SqlDataReader dr, List <ProductCollectInfo> productCollectList)
{
while (dr.Read())
{
ProductCollectInfo item = new ProductCollectInfo();
item.ID = dr.GetInt32(0);
item.ProductID = dr.GetInt32(1);
item.Date = dr.GetDateTime(2);
item.UserID = dr.GetInt32(3);
item.UserName = dr[4].ToString();
productCollectList.Add(item);
}
}
public ProductCollectInfo ReadProductCollectByProductID(int productID, int userID)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@userID", SqlDbType.Int) };
pt[0].Value = productID;
pt[1].Value = userID;
ProductCollectInfo info = new ProductCollectInfo();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadProductCollectByProductID", pt))
{
if (reader.Read())
{
info.ID = reader.GetInt32(0);
info.ProductID = reader.GetInt32(1);
info.Date = reader.GetDateTime(2);
info.UserID = reader.GetInt32(3);
info.UserName = reader[4].ToString();
}
}
return(info);
}
public static int Add(ProductCollectInfo entity)
{
entity.Id = dal.Add(entity);
ProductBLL.ChangeProductCollectCount(entity.ProductId, ChangeAction.Plus);
return(entity.Id);
}
public static void UpdateProductCollect(ProductCollectInfo productCollect)
{
dal.UpdateProductCollect(productCollect);
}
public static int AddProductCollect(ProductCollectInfo productCollect)
{
productCollect.ID = dal.AddProductCollect(productCollect);
ProductBLL.ChangeProductCollectCount(productCollect.ProductID, ChangeAction.Plus);
return(productCollect.ID);
}
