Esempio n. 1
0
        private void SaveSkuGenerateHistory(Dictionary <string, ulong> index)
        {
            var existingHistory = GetSkuIndicesFromHistory();

            foreach (KeyValuePair <string, ulong> keyValuePair in index)
            {
                SkuIndex newIndex = new SkuIndex()
                {
                    Sku            = keyValuePair.Key,
                    EndIndex       = keyValuePair.Value,
                    CreateDateTime = DateTime.Now
                };

                existingHistory.Add(newIndex);
            }

            File.WriteAllText(indexFilename, JsonConvert.SerializeObject(existingHistory));
        }
Esempio n. 2
0
        private void btnBatchGenerate_Click(object sender, EventArgs e)
        {
            try
            {
                List <OrderInfo> orderItems = new List <OrderInfo>();
                ISheet           sheet;
                using (var stream = new FileStream(txtOrderFileName.Text, FileMode.Open))
                {
                    stream.Position = 0;
                    XSSFWorkbook xssWorkbook = new XSSFWorkbook(stream);
                    sheet = xssWorkbook.GetSheetAt(0);
                    IRow headerRow = sheet.GetRow(0);
                    int  cellCount = headerRow.LastCellNum;

                    /*for (int j = 0; j < cellCount; j++)
                     * {
                     *  ICell cell = headerRow.GetCell(j);
                     *  if (cell == null || string.IsNullOrWhiteSpace(cell.ToString())) continue;
                     *  {
                     *      dtTable.Columns.Add(cell.ToString());
                     *  }
                     * }*/

                    for (int i = (sheet.FirstRowNum + 1); i <= sheet.LastRowNum; i++)
                    {
                        IRow row = sheet.GetRow(i);
                        if (row == null)
                        {
                            continue;
                        }
                        if (row.Cells.All(d => d.CellType == CellType.Blank))
                        {
                            continue;
                        }
                        OrderInfo item = new OrderInfo();
                        item.GO          = row.GetCell(0).ToString();
                        item.ProductCode = row.GetCell(1).ToString();
                        item.Sku         = row.GetCell(2).ToString();
                        item.Style       = row.GetCell(7).ToString();                   //H
                        item.Size        = row.GetCell(9).ToString();                   //J
                        item.Color       = row.GetCell(11).ToString();                  //L
                        item.Qty         = Convert.ToInt32(row.GetCell(21).ToString()); //L
                        orderItems.Add(item);
                    }

                    List <SkuIndex>            skuIndices = GetSkuIndicesFromHistory();
                    Dictionary <string, ulong> Index      = skuIndices.GroupBy(c => c.Sku).Select(g => new
                    {
                        Sku   = g.Key,
                        Index = g.Max(row => row.EndIndex) + 1
                    }).ToDictionary(x => x.Sku, x => x.Index);
                    StringBuilder sb     = new StringBuilder();
                    string        header = "GO,Product Code,SKU,Style,Size,Color,Human Readable,Unique ID, Url, EPC";
                    sb.AppendLine(header);
                    foreach (OrderInfo orderItem in orderItems)
                    {
                        ulong startIndex = 1;
                        // if(skuIndices.Any(c=>c.Sku==orderItem.Sku))
                        if (Index.ContainsKey(orderItem.Sku))
                        {
                            startIndex = Index[orderItem.Sku];
                        }

                        uint   orderItemQty = (uint)orderItem.Qty;
                        string csv          = GenerateSampleDataV2(orderItem, orderItem.Sku, startIndex, orderItemQty);
                        sb.Append(csv);

                        ulong itemQty = startIndex + orderItemQty - 1;
                        if (Index.ContainsKey(orderItem.Sku))
                        {
                            Index[orderItem.Sku] = itemQty;
                        }
                        else
                        {
                            Index.Add(orderItem.Sku, itemQty);
                        }
                    }

                    DialogResult dialogResult = saveFileDialog1.ShowDialog();
                    if (dialogResult == DialogResult.OK)
                    {
                        string csvFilename = saveFileDialog1.FileName;
                        using (var sw = File.CreateText(csvFilename))
                        {
                            sw.WriteLine(sb.ToString());
                            sw.Close();
                        }

                        MessageBox.Show("Data is generated successfully!");
                    }
                    //Save back to index file
                    foreach (KeyValuePair <string, ulong> keyValuePair in Index)
                    {
                        SkuIndex newSkuIndex = new SkuIndex()
                        {
                            CreateDateTime = DateTime.Now,
                            EndIndex       = keyValuePair.Value,
                            Sku            = keyValuePair.Key
                        };
                        skuIndices.Add(newSkuIndex);
                    }

                    SaveSkuGenerateHistory(Index);
                    //Process data
                    int a = 1;
                }
            }
            catch (Exception exception)
            {
                MessageBox.Show(exception.Message);
            }
        }