public CouponCell(CouponUserViewModel coupon)
{
string productUrl = null;
switch (coupon.Platform)
{
case Enums.CouponPlatform.TaoBao:
productUrl = $"http://h5.m.taobao.com/awp/core/detail.htm?id={coupon.ProductID}";
break;
case Enums.CouponPlatform.TMall:
productUrl = $"https://detail.m.tmall.com/item.htm?id={coupon.ProductID}";
break;
case Enums.CouponPlatform.Jd:
productUrl = $"https://item.m.jd.com/product/{coupon.ProductID}.html";
break;
case Enums.CouponPlatform.MoGuJie:
productUrl = $"https://detail.m.tmall.com/item.htm?id={coupon.ProductID}";
break;
default:
break;
}
ID = coupon.ID.ToString();
Title = coupon.Name;
Image = Comm.ResizeImage(coupon.Image, image: null);
Action.Add(new KeyValuePair <string, string>("id", coupon.ID.ToString()));
Type = ActionType.ThirdPartyTicketDetail;
Platform = coupon.Platform;
Price = coupon.Price;
OriginalPrice = coupon.OriginalPrice;
Sale = coupon.OriginalPrice - coupon.Price;
Link = coupon.Link;
Sales = coupon.Sales;
Values = Bll.Coupons.GetValues(coupon);
StartDateTime = coupon.StartDateTime.ToString("yyyy-MM-dd HH:mm");
CreateDateTime = coupon.CreateDateTime.ToString("yyyy-MM-dd HH:mm");
EndDateTime = coupon.EndDateTime.ToString("yyyy-MM-dd HH:mm");
ProductID = coupon.ProductID;
ProductType = coupon.ProductType;
ShopName = coupon.ShopName;
Subtitle = coupon.Subtitle;
ShareUrl = Comm.ResizeImage($"~/Coupon/Details?id={coupon.ID}&cUserID={coupon.UserID}", image: null);
ProductUrl = productUrl;
Commission = coupon.Commission;
CommissionRate = coupon.CommissionRate;
IsFavorite = coupon.IsFavorite;
FavoriteID = coupon.FavoriteID;
}
public void Set(string path)
{
var models = new List <CouponUserViewModel>();
try
{
var dtable = new ExcelHelper(path).ExcelToDataTable(null, true);
foreach (System.Data.DataRow item in dtable.Rows)
{
var index = dtable.Rows.IndexOf(item);
try
{
var model = new CouponUserViewModel
{
EndDateTime = Convert.ToDateTime(item["优惠券结束时间"]).AddDays(1).AddSeconds(-1),
ProductID = item["商品id"].ToString(),
TypeID = Bll.Coupons.CheckType(item["商品一级类目"].ToString()),
Image = item["商品主图"].ToString(),
Link = item["商品优惠券推广链接"].ToString(),
Name = item["商品名称"].ToString(),
OriginalPrice = Convert.ToDecimal(item["商品价格(单位：元)"]),
ProductType = item["商品一级类目"].ToString(),
ShopName = item["店铺名称"].ToString(),
StartDateTime = Convert.ToDateTime(item["优惠券开始时间"].ToString()),
Subtitle = null,
Value = item["优惠券面额"].ToString(),
Platform = item["平台类型"].ToString() == "淘宝" ? Enums.CouponPlatform.TaoBao : Enums.CouponPlatform.TMall,
Sales = Convert.ToInt32(item["商品月销量"]),
Commission = Convert.ToDecimal(item["佣金"]),
CommissionRate = Convert.ToDecimal(item["收入比率(%)"]),
Left = Convert.ToInt32(item["优惠券剩余量"]),
Total = Convert.ToInt32(item["优惠券总量"])
};
try
{
model.Price = Taobao.GetAfterCouponPrice(model.OriginalPrice, model.Value);
}
catch (Exception)
{
continue;
}
if (model.EndDateTime < DateTime.Now || model.OriginalPrice <= model.Price)
{
continue;
}
if (model.Price < 0)
{
continue;
}
models.Add(model);
}
catch (Exception ex)//有异常的数据忽略
{
}
}
//分段添加到数据库
Bll.Coupons.DbAdd(models);
}
catch (Exception ex)
{
//Comm.WriteLog("excel", $"{ex.Message}", Enums.DebugLogLevel.Error);
}
}
