示例#1
0
        static void Main(string[] args)
        {
            using (SPCSConnection c = new SPCSConnection())
            {
                c.Open();

                if (c.IsConnected)
                {
                    SPCSInvoice i = new SPCSInvoice();
                    {
                        i.InvoiceCustomerNr = "101";
                        i.InvoiceDate = DateTime.Parse("2007-01-01");

                        SPCSInvoiceRow r = new SPCSInvoiceRow();
                        {
                            r.InvoiceRowArticleNr = "101";
                            r.InvoiceRowArticleText = "Artikel1";
                            r.InvoiceRowQuantity = 20;
                            //r.PriceEach = 50;
                            r.InvoiceRowUnit = "St";
                        }

                        i.InvoiceRows.Add(r);

                        i.Save();

                    }
                    c.Close();
                }
                else
                {
                    Console.WriteLine("NOT CONNECTED");
                }
            }

            Console.Read();
        }
        private List<SPCSInvoice> TestInvoices()
        {
            List<SPCSInvoice> invoices = new List<SPCSInvoice>();

            SPCSConnection connection = new SPCSConnection();
            {
                connection.Open();

                if (connection.IsConnected)
                {
                    SPCSCustomer c = new SPCSCustomer();
                    {
                        c.CustomerName = "FooBar AB";
                        c.CustomerNr = c.GetId();
                        c.CustomerReference = "Jonas Grimfelt";
                        c.SaveIfNotAvailable();
                        Console.WriteLine("Customer-nr: " + c.CustomerNr);
                    }

                    SPCSProject p = new SPCSProject();
                    {
                        p.ProjectName = "ABC-123";
                        p.ProjectNr = p.GetId();
                        p.ProjectCustomerNr = c.CustomerNr;
                        p.ProjectStartTime = DateTime.Today;
                        p.ProjectEndTime = DateTime.Today;
                        p.SaveIfNotAvailable();
                        Console.WriteLine("Project-nr: " + p.ProjectNr);
                    }

                    SPCSInvoice i = new SPCSInvoice();
                    {
                        i.InvoiceDate = DateTime.ParseExact("2007-07-14", "yyyy-MM-dd", null);

                        //i.InvoiceCustomerNr = c.CustomerNr;
                        i.Customer = c;
                        i.InvoiceCustomerOrderNr = "123AABB1234";

                        //i.InvoiceOurProject = p.ProjectNr;
                        i.Project = p;
                        i.InvoiceOurReferenceName = "Foo Bar";

                        SPCSInvoiceRow r1 = new SPCSInvoiceRow();
                        {
                            r1.InvoiceRowArticleText = "Lorem ipsum A";
                            r1.InvoiceRowPriceEach = 3.51;
                            r1.InvoiceRowQuantity = 425;
                            r1.InvoiceRowUnit = "Pieces";
                        }
                        SPCSInvoiceRow r2 = new SPCSInvoiceRow();
                        {
                            r2.InvoiceRowArticleText = "Lorem ipsum B";
                            r2.InvoiceRowPriceEach = 3.51;
                            r2.InvoiceRowQuantity = 300;
                            r2.InvoiceRowUnit = "Hr";
                        }
                        i.InvoiceRows.Add(r1);
                        i.InvoiceRows.Add(r2);
                    }

                    invoices.Add(i);
                }

                connection.Close();
                connection.Dispose();
            }

            return invoices;
        }
        private void ReadInvoiceRows(Connection connection, SPCSInvoice invoice, int invoiceId)
        {
            using (TypedDataReader reader = connection.GetInvoiceRowReader(invoiceId))
            {
                SPCSInvoiceRow invoiceRow = null;

                // For each invoice-row
                while (reader.Read())
                {
                    invoiceRow = new SPCSInvoiceRow();
                    {
                        invoiceRow.InvoiceRowArticleText = reader.GetString(DataBase.InvoiceRowColumnNameArticleText);
                        invoiceRow.InvoiceRowPriceEach = reader.GetDouble(DataBase.InvoiceRowColumnNamePriceEach);
                        invoiceRow.InvoiceRowQuantity = reader.GetDouble(DataBase.InvoiceRowColumnNameQuantity);
                        invoiceRow.InvoiceRowUnit = "TimAnt";
                    }

                    invoice.InvoiceRows.Add(invoiceRow);
                }
            }
        }
        private List<SPCSInvoice> ReadInvoices(Connection connection)
        {
            int rowCount = connection.GetInvoiceCount();
            int rowNr = 0;

            List<SPCSInvoice> invoices = new List<SPCSInvoice>(rowCount);

            using (TypedDataReader reader = connection.GetInvoiceReader())
            {
                 using (SPCSConnection c = new SPCSConnection())
                {
                    c.Open();

                    if (c.IsConnected)
                    {
                        SPCSInvoice invoice = null;
                        SPCSCustomer customer = null;
                        SPCSProject project = null;

                        int invoiceId = 0;

                        // For each invoice
                        while (reader.Read())
                        {
                            customer = new SPCSCustomer();
                            {
                                customer.CustomerName = reader.GetString(DataBase.InvoiceColumnNameCustomerName);
                                customer.CustomerNr = customer.GetId();
                                customer.CustomerReference = string.Format("{0} {1}", reader.GetString(DataBase.InvoiceColumnNameCustomerReferenceFirstName),
                                                                    reader.GetString(DataBase.InvoiceColumnNameCustomerReferenceLastName));
                            }

                            project = new SPCSProject();
                            {
                                project.ProjectName = reader.GetString(DataBase.InvoiceColumnNameOurProject);
                                project.ProjectNr = project.GetId();
                                project.ProjectCustomerNr = customer.CustomerNr;
                                project.ProjectStartTime = DateTime.Today;
                                project.ProjectEndTime = DateTime.Today;
                            }

                            // Get invoice-head
                            invoice = new SPCSInvoice();
                            {
                                invoice.Customer = customer;
                                invoice.Project = project;

                                string date = reader.GetString(DataBase.InvoiceColumnNameDate);
                                if (!string.IsNullOrEmpty(date))
                                    invoice.InvoiceDate = DateTime.Parse(date);

                                invoiceId = reader.GetInt(DataBase.InvoiceRowColumnNameInvoiceId);
                                invoice.InvoiceCustomerOrderNr = reader.GetString(DataBase.InvoiceColumnNameCustomerOrderNr);
                                invoice.InvoiceOurReferenceName = string.Format("{0} {1}", reader.GetString(DataBase.InvoiceColumnNameOurReferenceFirstName),
                                                                    reader.GetString(DataBase.InvoiceColumnNameOurReferenceLastName));
                            }

                            // Get all invoice-rows
                            this.ReadInvoiceRows(connection, invoice, invoiceId);

                            invoices.Add(invoice);

                            Console.WriteLine(invoice.ToString());
                            this.OnProcessValueChanged(++rowNr, rowCount, ProcressAction.ReadFromDB);
                        }
                    }
                }
            }
            return invoices;
        }
        private SPCSInvoice ReadInvoice(Connection connection, string invoiceId)
        {
            SPCSInvoice invoice = null;
            SPCSCustomer customer = null;
            SPCSProject project = null;

            using (TypedDataReader reader = connection.GetInvoiceReader(int.Parse(invoiceId)))
            {
                using (SPCSConnection c = new SPCSConnection())
                {
                    c.LibraryPath = this.SPCSLibraryPath;
                    c.DatabasePath = string.Format("{0}{1}{2}", this.SPCSDatabasePath.TrimEnd('\\'), '\\', this.SPCSDatabaseName);
                    c.Open();

                    if (c.IsConnected)
                    {
                        bool result = reader.Read();

                        if (result)
                        {

                            customer = new SPCSCustomer();
                            {
                                customer.CustomerName = reader.GetString(DataBase.InvoiceColumnNameCustomerName);
                                customer.CustomerNr = customer.GetId();
                                customer.CustomerReference = string.Format("{0} {1}", reader.GetString(DataBase.InvoiceColumnNameCustomerReferenceFirstName),
                                                                    reader.GetString(DataBase.InvoiceColumnNameCustomerReferenceLastName));

                            }

                            project = new SPCSProject();
                            {
                                project.ProjectName = reader.GetString(DataBase.InvoiceColumnNameOurProject);
                                project.ProjectNr = project.GetId();
                                project.ProjectCustomerNr = customer.CustomerNr;
                                project.ProjectStartTime = DateTime.Today;
                                project.ProjectEndTime = DateTime.Today;
                            }

                            invoice = new SPCSInvoice();
                            {
                                invoice.Customer = customer;
                                invoice.Project = project;

                                invoice.InvoiceDate = reader.GetDateTime(DataBase.InvoiceColumnNameDate);

                                invoiceId = reader.GetString(DataBase.InvoiceRowColumnNameInvoiceId);
                                invoice.InvoiceCustomerOrderNr = reader.GetString(DataBase.InvoiceColumnNameCustomerOrderNr);
                                invoice.InvoiceOurReferenceName = string.Format("{0} {1}", reader.GetString(DataBase.InvoiceColumnNameOurReferenceFirstName),
                                                                    reader.GetString(DataBase.InvoiceColumnNameOurReferenceLastName));
                            }

                            this.ReadInvoiceRows(connection, invoice, int.Parse(invoiceId));
                            Console.WriteLine(invoice.ToString());

                            MessageBox.Show(invoice.ToString());
                        }
                    }
                }
            }
            return invoice;
        }