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