コード例 #1
0
        public async Task NewInvoice(Invoice invoice)
        {
            var rec = new InvoiceRecord {
                Date     = invoice.Date,
                Number   = await VerifyNumber(invoice.Number),
                Car      = invoice.CarId,
                Customer = invoice.Customer.CodeName,
                Notes    = invoice.Notes
            };

            rec = await InvoicesTable.CreateRecord(rec);

            invoice.RecordId = rec.Id;
            invoice.Seq      = rec.Seq;
            invoice.Number   = rec.Number;
            invoice.Ordinal  = AppScope.Instance.Invoices.Count + 1;

            foreach (var article in invoice.Articles)
            {
                var art = new ArticleRecord {
                    InvoiceSeq = invoice.Seq,
                    Produce    = article.Produce.Name,
                    Quantity   = article.Quantity,
                    Unit       = article.Unit,
                    UnitPrice  = article.UnitPrice,
                    TotalPrice = article.TotalPrice
                };

                art = await ArticlesTable.CreateRecord(art);

                article.RecordId = art.Id;
            }

            AppScope.Instance.Invoices.Add(invoice);
        }
コード例 #2
0
ファイル: MainBase.cs プロジェクト: Roman-Dementiev/Dwares
        //static ClassRef @class = new ClassRef(typeof(MainBase));

        public MainBase(string apiKey, string baseId) :
            base(apiKey, baseId)
        {
            //Debug.EnableTracing(@class);

            BasesTable      = new BasesTable(this);
            ProduceTable    = new ProduceTable(this);
            ContactsTable   = new ContactsTable(this);
            CustomersTable  = new CustomersTable(this);
            PlacesTable     = new PlacesTable(this);
            InvoicesTable   = new InvoicesTable(this);
            ArticlesTable   = new ArticlesTable(this);
            RouteTable      = new RouteTable(this);
            PropertiesTable = new PropertiesTable(this);
        }
コード例 #3
0
        public async Task LoadInvoices(string carId)
        {
            var query = new QyeryBuilder();

            query.SetSortByField(InvoiceRecord.SEQ);
            if (string.IsNullOrEmpty(carId))
            {
                query.FilterByFormula = "{Date} >= TODAY()";
            }
            else
            {
                query.FilterByFormula = $"And({{Date}} = TODAY(), {{Car}}=\"{carId}\")";
            }

            //var records = await InvoicesTable.ListRecords(sortField: InvoiceRecord.SEQ);
            var result = await InvoicesTable.List(query);

            var records = result?.Records;

            if (records == null)
            {
                Debug.Print("InvoicesTable.List() returned no records");
                return;
            }
            var invoices = AppScope.Instance.Invoices;
            int ord      = 0;

            foreach (var rec in records)
            {
                var customer = AppScope.GetCustomer(rec.Customer);
                if (customer == null)
                {
                    Debug.Print($"## AirStorage.LoadInvoices(): Unknown Customer {Dw.ToString(rec.Customer)}");
                    continue;
                }

                var invoice = new Invoice {
                    RecordId = rec.Id,
                    Seq      = rec.Seq,
                    Ordinal  = ++ord,
                    Date     = rec.Date,
                    CarId    = rec.Car,
                    Number   = rec.Number,
                    Customer = customer,
                    Notes    = rec.Notes
                };

                var list = await ArticlesTable.FilterRecords($"{{{ArticleRecord.INVOICE_SEQ}}} = {invoice.Seq}");

                foreach (var art in list.Records)
                {
                    var produce = AppScope.GetProduce(art.Produce);
                    if (produce == null)
                    {
                        Debug.Print($"## AirStorage.LoadInvoices(): Unknown Produce {Dw.ToString(art.Produce)}");
                        continue;
                    }

                    var article = new Article {
                        RecordId   = art.Id,
                        Produce    = produce,
                        Quantity   = art.Quantity,
                        Unit       = art.Unit,
                        UnitPrice  = art.UnitPrice,
                        TotalPrice = art.TotalPrice,
                        Note       = art.Note
                    };

                    invoice.Articles.Add(article);
                }

                invoices.Add(invoice);
            }
        }