//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);
}
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);
}
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);
}
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);
}
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);
}