Exemplo n.º 1
0
        //UPDATE Co2Db_Vare SET FG = Fragt, KPcur = KostprisCurrency, KPdkk = KostprisDKK, DB = DaekningsBidrag, DG = DaekningsGrad, SP = SalgsPris
        //,	@Fragt	float	= null
        //,	@KostPrisCUR	float	= null
        //,	@KostPrisDKK	float	= null
        //,	@DaekningsBidrag	float	= null
        //,	@DaekningsGrad float
        //,	@SalgsPris		float	= null

        private static void AddParms(ref DBAccess db, Vare rec)
        {
            var with_1 = rec;

            db.AddInt("VareGrpID", with_1.VareGrpID);
            db.AddNVarChar("VareNr", with_1.VareNr, 50);
            db.AddNVarChar("Navn", with_1.Navn, 255);
            db.AddNVarChar("Beskrivelse", with_1.Beskrivelse, -1);
            db.AddInt("CurrencyID", with_1.CurrencyID);
            db.AddDecimal("CurrencyRate", with_1.CurrencyRate);

            db.AddDecimal("Indkobspris", with_1.Indkobspris);
            db.AddDecimal("FragtPct", with_1.FragtPct);
            db.AddDecimal("Fragt", with_1.Fragt);

            db.AddDecimal("KostPrisCUR", with_1.KostprisCurrency);
            db.AddDecimal("KostPrisDKK", with_1.KostprisDKK);

            db.AddDecimal("DaekningsBidrag", with_1.DaekningsBidrag);
            db.AddDecimal("DaekningsGrad", with_1.DaekningsGrad);
            db.AddDecimal("SalgsPris", with_1.SalgsPris);

            db.AddInt("Status", (System.Int32)with_1.Status);
            db.AddInt("FragtID", with_1.FragtID);

            db.AddNVarChar("FaktaArkPath", with_1.FaktaArkPath, 250);

            db.AddNVarChar("SupplierItemNo", with_1.SupplierItemNo, 50);
            db.AddNVarChar("SupplierItemName", with_1.SupplierItemName, 255);

            AddParmsStandard(db, rec);
        }
Exemplo n.º 2
0
        private static void AddParms(ref DBAccess db, Invoiceline c)
        {
            var with_1 = c;

            db.AddInt("InvoiceID", with_1.InvoiceID);
            db.AddInt("Pos", with_1.Pos);
            db.AddInt("Status", (System.Int32)with_1.Status);

            db.AddInt("ItemID", with_1.ItemID);
            db.AddNVarChar("ItemNo", with_1.ItemNo, 50);
            db.AddNVarChar("ItemName", with_1.ItemName, 100);

            db.AddNVarChar("LineText", with_1.LineText, 250);
            db.AddNVarChar("SerialNo", with_1.SerialNo, 250);

            db.AddDecimal("ItemPrice", with_1.ItemPrice);
            db.AddDecimal("Discount", with_1.Discount);
            db.AddDecimal("SalesPrice", with_1.SalesPrice);
            db.AddDecimal("Quantity", with_1.Quantity);
            db.AddDecimal("LineTotal", with_1.LineTotal);

            db.AddBoolean("VAT", with_1.VAT);
            db.AddDecimal("Freight", with_1.Freight);

            db.AddDecimal("ProvisionRate", with_1.ProvisionRate);
            db.AddDecimal("Provision", with_1.Provision);
            db.AddDecimal("LineProvision", with_1.LineProvision);

            AddParmsStandard(db, c);
        }
        //  SET [KundeGrpID] = <KundeGrpID, int,>
        //     ,[VareID] = <VareID, int,>
        //     ,[status] = <status, int,>
        //     ,[Rabat] = <Rabat, float,>
        //     ,[FragtGebyr] = <FragtGebyr, float,>
        //     ,[Dato] = <Dato, datetime,>

        private static void AddParms(ref DBAccess db, KundeGrp_Pris c)
        {
            var with_1 = c;

            db.AddInt("KundeGrpID", with_1.KundeGrpID);
            db.AddInt("VareID", with_1.VareID);
            db.AddInt("Status", (System.Int32)with_1.Status);
            db.AddDecimal("Rabat", with_1.Rabat);
            db.AddDecimal("FragtGebyr", with_1.FragtGebyr);
            db.AddDateTime("Dato", with_1.Dato);
            db.AddDecimal("ProvisionRate", with_1.ProvisionRate);
            AddParmsStandard(db, c);
        }
        private static void AddParms(ref DBAccess db, TilbudsLinie c)
        {
            var with_1 = c;

            db.AddInt("TilbudID", with_1.TilbudID);
            db.AddInt("VareID", with_1.VareID);

            db.AddDecimal("Salgspris", with_1.Salgspris);
            db.AddDecimal("Rabat", with_1.Rabat);
            db.AddDecimal("Tilbudspris", with_1.Tilbudspris);

            db.AddInt("Status", (System.Int32)with_1.Status);
            db.AddInt("Pos", with_1.Pos);
            db.AddInt("Antal", with_1.Antal);
            AddParmsStandard(db, c);
        }
Exemplo n.º 5
0
        private static void AddParms(ref DBAccess db, Currency c)
        {
            var with_1 = c;

            db.AddVarChar("CurrencyCode", with_1.CurrencyCode, 10);
            db.AddNVarChar("CurrencyDesc", with_1.CurrencyDesc, 50);
            db.AddDecimal("CurrencyRate", with_1.CurrencyRate);
            db.AddDateTime("CurrencyDate", with_1.CurrencyDate);
            db.AddNVarChar("CurrencySymbol", with_1.CurrencySymbol, 50);
            AddParmsStandard(db, c);
        }
Exemplo n.º 6
0
 private static void AddParms(ref DBAccess db, tilbudHeader c)
 {
     db.AddInt("Status", (System.Int32)c.Status);
     db.AddInt("CompanyID", c.CompanyID);
     db.AddDateTime("Opretdato", c.Opretdato);
     db.AddDateTime("Udlobdato", c.Udlobdato);
     db.AddInt("AnsvarligID", c.AnsvarligID);
     db.AddGuid("AnsvarligGUID", c.AnsvarligGUID);
     db.AddNVarChar("KontaktEmail", c.KontaktEmail, 250);
     db.AddNVarChar("KontaktPerson", c.KontaktPerson, 50);
     db.AddNVarChar("Noter", c.Noter, -1);
     db.AddNVarChar("TilbudsTillaeg", c.TilbudsTillaeg, -1);
     db.AddDecimal("Transport", c.Transport);
     AddParmsStandard(db, c);
 }
        private static void AddParms(ref DBAccess db, PurchaseOrderItem rec)
        {
            var with_1 = rec;

            db.AddInt("PurchaseOrderID", with_1.PurchaseOrderID);
            db.AddInt("Pos", with_1.Pos);
            db.AddInt("Status", (System.Int32)with_1.Status);

            db.AddInt("ItemID", with_1.ItemID);
            db.AddNVarChar("ItemName", with_1.ItemName, 100);

            db.AddNVarChar("SupplierItemID", with_1.SupplierItemID, 50);
            db.AddNVarChar("SupplierItemName", with_1.SupplierItemName, 250);

            db.AddDecimal("Quantity", with_1.Quantity);
            db.AddMoney("ItemPrice", (double)with_1.ItemPrice);
            db.AddMoney("LinePrice", (double)with_1.LinePrice);

            db.AddDateTime("ExpectedReceiptDate", with_1.ExpectedReceiptDate);
            db.AddDateTime("ReceiptDate", with_1.ReceiptDate);

            AddParmsStandard(db, rec);
        }
Exemplo n.º 8
0
        private static void AddParms(ref DBAccess db, InvoiceHeader c)
        {
            db.AddInt("Status", (System.Int32)c.Status);
            db.AddInt("CompanyID", c.CompanyID);
            db.AddDateTime("InvoiceDate", c.InvoiceDate);

            db.AddInt("PaymentID", c.PaymentID);
            db.AddNVarChar("PaymentTerms", c.PaymentTerms, 50);
            db.AddDateTime("PaymentDate", c.PaymentDate);

            db.AddInt("ResponsibleID", c.ResponsibleID);
            db.AddNVarChar("ResponsibleName", c.ResponsibleName, 50);
            db.AddGuid("ResponsibleGUID", c.ResponsibleGUID);

            db.AddNVarChar("ContactName", c.ContactName, 50);
            db.AddNVarChar("ContactEmail", c.ContactEmail, 250);

            db.AddNVarChar("Notes", c.Notes, -1);

            db.AddNVarChar("InvoiceEANno", c.InvoiceEANno, 15);
            db.AddNVarChar("InvoiceName", c.InvoiceName, 100);
            db.AddNVarChar("InvoiceAddress1", c.InvoiceAddress1, 100);
            db.AddNVarChar("InvoiceAddress2", c.InvoiceAddress2, 100);
            db.AddNVarChar("InvoiceZipCode", c.InvoiceZipCode, 50);
            db.AddNVarChar("InvoiceCity", c.InvoiceCity, 50);
            db.AddNVarChar("InvoiceState", c.InvoiceState, 50);
            db.AddNVarChar("InvoiceCountry", c.InvoiceCountry, 50);
            db.AddNVarChar("InvoiceAtt", c.InvoiceAtt, 50);
            db.AddNVarChar("InvoiceRef", c.InvoiceRef, 50);

            db.AddNVarChar("DeleveryEANno", c.DeleveryEANno, 15);
            db.AddNVarChar("DeleveryName", c.DeleveryName, 100);
            db.AddNVarChar("DeleveryAddress1", c.DeleveryAddress1, 100);
            db.AddNVarChar("DeleveryAddress2", c.DeleveryAddress2, 100);
            db.AddNVarChar("DeleveryZipCode", c.DeleveryZipCode, 50);
            db.AddNVarChar("DeleveryCity", c.DeleveryCity, 50);
            db.AddNVarChar("DeleveryState", c.DeleveryState, 50);
            db.AddNVarChar("DeleveryCountry", c.DeleveryCountry, 50);
            db.AddNVarChar("DeleveryAtt", c.DeleveryAtt, 50);
            db.AddNVarChar("DeleveryRef", c.DeleveryRef, 50);

            db.AddInt("InvoiceLines", c.InvoiceLines);
            db.AddInt("InvoiceLineItems", c.InvoiceLineItems);

            db.AddDecimal("InvoiceLinesTotal", c.InvoiceLinesTotal);
            db.AddDecimal("InvoiceTransport", c.InvoiceTransport);
            db.AddDecimal("InvoiceTotal", c.InvoiceTotal);
            db.AddDecimal("InvoiceVAT", c.InvoiceVAT);
            db.AddDecimal("InvoiceTotalInclVAT", c.InvoiceTotalInclVAT);

            db.AddBit("Paid", c.Paid);
            db.AddDateTime("PaidDate", c.PaidDate);

            db.AddNVarChar("OrderNo", c.OrderNo, 50);
            db.AddNVarChar("YourRef", c.YourRef, 50);
            db.AddInt("CreditnoteID", c.CreditnoteID);

            db.AddBoolean("VATfree", c.VATfree);
            db.AddBoolean("EANInvoice", c.EANInvoice);

            db.AddInt("IncassoID", c.IncassoID);

            AddParmsStandard(db, c);
        }