示例#1
0
        private void AddLine(Order order, int row)
        {
            Line line = new Line();

            if (ErrorUtil.IsInvoiceNumberOk(monthlyExcelFile.linesRange, row, ColumnsLines.InvoiceNumber))
            {
                line.InvoiceNumber = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.InvoiceNumber);
            }

            if (ErrorUtil.CheckRecordType(monthlyExcelFile.linesRange, row, RecordType.line))
            {
                line.RecordType = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.RecordType);
            }

            if (LineUtil.CheckUnitPrice(monthlyExcelFile.linesRange, row))
            {
                line.UnitPriceTI = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.UnitPriceTI);
            }

            if (LineUtil.CheckQuantity(monthlyExcelFile.linesRange, row))
            {
                line.Quantity = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.Quantity);
            }

            if (LineUtil.CheckProductTypeExist(monthlyExcelFile.linesRange, row, catalogExcelFile.range))
            {
                line.ProductCode = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.Product);
            }

            line.AMZProductCode             = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.AMZProductCode);
            line.SaleUnitType               = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.SaleUnitType);
            line.BoxesQuantity              = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.BoxesQuantity);
            line.PackageQuantity            = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.PackageQuantity);
            line.Discount                   = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.Discount);
            line.DiscountPrecent            = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.DiscountPrecent);
            line.SaleDiscount               = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.SaleDiscount);
            line.SaleDiscountPrecent        = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.SaleDiscountPrecent);
            line.DistrbutionDiscount        = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.DistrbutionDiscount);
            line.DistrbutionDiscountPrecent = ExcelUtil.GetStringValue(monthlyExcelFile.linesRange, row, ColumnsLines.DistrbutionDiscountPrecent);

            order.Lines.Add(line);
            recordsToBeDeleted.Add(new RecordToBeDeleted {
                Record = row, Sheet = Sheets.LinesSheetNumber
            });
        }
示例#2
0
        private void PassLinesLeft()
        {
            Excel.Range range  = monthlyExcelFile.linesRange;
            int         length = ExcelUtil.GetLastRow(range.Worksheet);

            for (int row = 2; row < length; row++)
            {
                if (IsAnyCellContainsValue(range, row))
                {
                    ErrorUtil.IsInvoiceNumberOk(range, row, ColumnsLines.InvoiceNumber);

                    ErrorUtil.CheckRecordType(range, row, RecordType.line);

                    LineUtil.CheckUnitPrice(range, row);

                    LineUtil.CheckQuantity(range, row);

                    LineUtil.CheckProductTypeExist(range, row, catalogExcelFile.range);
                }
            }
        }