public async Task <IActionResult> Upload(IFormFile file, Guid projectId)
        {
            var fileStream = file.OpenReadStream();
            var excel      = new ExcelStream();

            excel.Load(fileStream);
            var sheet1 = excel.LoadSheetHDR(excel.WorkBook.First().Name);
            var slots  = new List <OnCallSlot>(sheet1.Count);

            foreach (var x in sheet1)
            {
                var primary = await User.Manager.FindByNameAsync(x[2]);

                var backup = await User.Manager.FindByNameAsync(x[3]);

                var incidentManager = await User.Manager.FindByNameAsync(x[4]);

                slots.Add(new OnCallSlot
                {
                    Begin     = Convert.ToDateTime(x[0]),
                    End       = Convert.ToDateTime(x[1]),
                    ProjectId = projectId,
                    Role      = SlotRole.Primary,
                    UserId    = primary.Id
                });
                slots.Add(new OnCallSlot
                {
                    Begin     = Convert.ToDateTime(x[0]),
                    End       = Convert.ToDateTime(x[1]),
                    ProjectId = projectId,
                    Role      = SlotRole.Backup,
                    UserId    = backup.Id
                });
                slots.Add(new OnCallSlot
                {
                    Begin     = Convert.ToDateTime(x[0]),
                    End       = Convert.ToDateTime(x[1]),
                    ProjectId = projectId,
                    Role      = SlotRole.IncidentManager,
                    UserId    = incidentManager.Id
                });
            }
            DB.AddRange(slots);
            await DB.SaveChangesAsync();

            return(Prompt(x =>
            {
                x.Title = "导入成功";
                x.Details = "On-Call日程表已经成功导入";
                x.HideBack = true;
                x.RedirectUrl = Url.Action("Index", "OnCall", new { project = projectId });
                x.RedirectText = "查看On-Call时间表";
            }));
        }
 public void Test_Load_Excel()
 {
     Test_Creat_Excel();
     using (var x = _ExcelStream.Load(_ExcelPath))
     {
         using (var sheet = x.LoadSheet(1))
         {
             // Reading the data from sheet
             foreach (var a in sheet)
             {
                 foreach (var b in a)
                 {
                     Assert.Equal(b, "Create test");
                 }
             }
         }
     }
 }
Example #3
0
        private async Task SaveCoupons(string fileName, string userId)
        {
            using (var x = _excelStream.Load(fileName))
            {
                using (var sheet = x.LoadSheet(1))
                {
                    // Reading the data from sheet
                    var index = 1;
                    int baseUrlIndex = 0, priceIndex = 0,
                        titleIndex = 0, shopNameIndex = 0, productNameIndex = 0,
                        startIndex = 0, endIndex = 0, productTypeIndex = 0,
                        pictureUrlIndex = 0, productUrlIndex = 0;
                    IList <Coupon> coupons = new List <Coupon>();
                    foreach (var item in sheet)
                    {
                        if (index == 1)
                        {
                            for (var childIndex = 0; childIndex < item.Count; childIndex++)
                            {
                                switch (item[childIndex].Trim())
                                {
                                case "商品名称":
                                    productNameIndex = childIndex;
                                    break;

                                case "商品主图":
                                    pictureUrlIndex = childIndex;
                                    break;

                                case "商品一级类目":
                                    productTypeIndex = childIndex;
                                    break;

                                case "淘宝客链接":
                                    productUrlIndex = childIndex;
                                    break;

                                case "商品价格":
                                    priceIndex = childIndex;
                                    break;

                                case "店铺名称":
                                    shopNameIndex = childIndex;
                                    break;

                                case "优惠券面额":
                                    titleIndex = childIndex;
                                    break;

                                case "优惠券开始时间":
                                    startIndex = childIndex;
                                    break;

                                case "优惠券结束时间":
                                    endIndex = childIndex;
                                    break;

                                case "商品优惠券推广链接":
                                    baseUrlIndex = childIndex;
                                    break;
                                }
                            }

                            index++;
                            continue;
                        }
                        var coupon = new Coupon();
                        //Spider(item[10]);
                        coupon.BaseUrl     = item[baseUrlIndex];
                        coupon.Title       = item[titleIndex];
                        coupon.ShopName    = item[shopNameIndex];
                        coupon.ProductUrl  = item[productUrlIndex];
                        coupon.PictureUrl  = item[pictureUrlIndex];
                        coupon.ProductName = item[productNameIndex];
                        coupon.ProductType = item[productTypeIndex];
                        double price = 0;
                        double.TryParse(item[priceIndex], out price);
                        coupon.Price = price;
                        DateTime startDate;
                        DateTime.TryParse(item[startIndex], out startDate);
                        coupon.StartDate = startDate;
                        DateTime endDate;
                        DateTime.TryParse(item[endIndex], out endDate);
                        coupon.EndDate = endDate;
                        coupon.UserId  = userId;
                        coupon.Id      = Guid.NewGuid().ToString();
                        coupon.AddTime = DateTime.Now;
                        coupon.Version = 0;
                        coupons.Add(coupon);
                    }
                    await _service.AddAsync(coupons);
                }
            }
        }