private void InitClass() { this.DataSetName = "MDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/MDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableCash = new CashDataTable(); base.Tables.Add(this.tableCash); this.tableDocumentType = new DocumentTypeDataTable(); base.Tables.Add(this.tableDocumentType); this.tableInvoiceMaster = new InvoiceMasterDataTable(); base.Tables.Add(this.tableInvoiceMaster); this.tableInvoiceDetail = new InvoiceDetailDataTable(false); base.Tables.Add(this.tableInvoiceDetail); this.tablePeriods = new PeriodsDataTable(); base.Tables.Add(this.tablePeriods); this.tableReceiptDetail = new ReceiptDetailDataTable(false); base.Tables.Add(this.tableReceiptDetail); this.tableReceiptMaster = new ReceiptMasterDataTable(); base.Tables.Add(this.tableReceiptMaster); this.tableReceiptRemains = new ReceiptRemainsDataTable(); base.Tables.Add(this.tableReceiptRemains); this.tableProduct = new ProductDataTable(); base.Tables.Add(this.tableProduct); this.tableRemains = new RemainsDataTable(false); base.Tables.Add(this.tableRemains); this.tableStock = new StockDataTable(); base.Tables.Add(this.tableStock); this.tableLocalSetting = new LocalSettingDataTable(); base.Tables.Add(this.tableLocalSetting); this.tableOrders = new OrdersDataTable(); base.Tables.Add(this.tableOrders); this.tableinventoryMaster = new inventoryMasterDataTable(); base.Tables.Add(this.tableinventoryMaster); this.tableinventoryDetails = new inventoryDetailsDataTable(false); base.Tables.Add(this.tableinventoryDetails); System.Data.ForeignKeyConstraint fkc; fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] { this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.InvoiceMasterRefColumn}); this.tableInvoiceDetail.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("Remains_InvoiceDetail", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}); this.tableInvoiceDetail.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.None; fkc = new System.Data.ForeignKeyConstraint("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] { this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] { this.tableinventoryDetails.inventoryMasterRefColumn}); this.tableinventoryDetails.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] { this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.InvoiceMasterRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster); this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false); this.Relations.Add(this.relationRemains_InvoiceDetail); this.relationFK_inventoryMaster_inventoryDetails = new System.Data.DataRelation("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] { this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] { this.tableinventoryDetails.inventoryMasterRefColumn}, false); this.Relations.Add(this.relationFK_inventoryMaster_inventoryDetails); this.relationFK_ReceiptDetail_ReceiptMaster = new System.Data.DataRelation("FK_ReceiptDetail_ReceiptMaster", new System.Data.DataColumn[] { this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ReceiptMasterRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptDetail_ReceiptMaster); this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] { this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.DocumentTypeRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType); this.relationFK_InvoiceDetail_ReceiptRemains = new System.Data.DataRelation("FK_InvoiceDetail_ReceiptRemains", new System.Data.DataColumn[] { this.tableReceiptRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceDetail_ReceiptRemains); this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.MainStockRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_Stock); this.relationFK_ReceiptMaster_Stock1 = new System.Data.DataRelation("FK_ReceiptMaster_Stock1", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.SenderStockRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_Stock1); this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, false); this.Relations.Add(this.relationReceiptDetail_Remains); this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_ReceiptDetail); this.relationInvoiceDetail_Product = new System.Data.DataRelation("InvoiceDetail_Product", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.ProductRefColumn}, false); this.Relations.Add(this.relationInvoiceDetail_Product); this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableOrders.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_Orders); this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableRemains.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_Remains); }
internal InvoiceDetailRow(System.Data.DataRowBuilder rb) : base(rb) { this.tableInvoiceDetail = ((InvoiceDetailDataTable)(this.Table)); }
internal void InitVars(bool initTable) { this.tableCash = ((CashDataTable)(base.Tables["Cash"])); if ((initTable == true)) { if ((this.tableCash != null)) { this.tableCash.InitVars(); } } this.tableDocumentType = ((DocumentTypeDataTable)(base.Tables["DocumentType"])); if ((initTable == true)) { if ((this.tableDocumentType != null)) { this.tableDocumentType.InitVars(); } } this.tableInvoiceMaster = ((InvoiceMasterDataTable)(base.Tables["InvoiceMaster"])); if ((initTable == true)) { if ((this.tableInvoiceMaster != null)) { this.tableInvoiceMaster.InitVars(); } } this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"])); if ((initTable == true)) { if ((this.tableInvoiceDetail != null)) { this.tableInvoiceDetail.InitVars(); } } this.tablePeriods = ((PeriodsDataTable)(base.Tables["Periods"])); if ((initTable == true)) { if ((this.tablePeriods != null)) { this.tablePeriods.InitVars(); } } this.tableReceiptDetail = ((ReceiptDetailDataTable)(base.Tables["ReceiptDetail"])); if ((initTable == true)) { if ((this.tableReceiptDetail != null)) { this.tableReceiptDetail.InitVars(); } } this.tableReceiptMaster = ((ReceiptMasterDataTable)(base.Tables["ReceiptMaster"])); if ((initTable == true)) { if ((this.tableReceiptMaster != null)) { this.tableReceiptMaster.InitVars(); } } this.tableReceiptRemains = ((ReceiptRemainsDataTable)(base.Tables["ReceiptRemains"])); if ((initTable == true)) { if ((this.tableReceiptRemains != null)) { this.tableReceiptRemains.InitVars(); } } this.tableProduct = ((ProductDataTable)(base.Tables["Product"])); if ((initTable == true)) { if ((this.tableProduct != null)) { this.tableProduct.InitVars(); } } this.tableRemains = ((RemainsDataTable)(base.Tables["Remains"])); if ((initTable == true)) { if ((this.tableRemains != null)) { this.tableRemains.InitVars(); } } this.tableStock = ((StockDataTable)(base.Tables["Stock"])); if ((initTable == true)) { if ((this.tableStock != null)) { this.tableStock.InitVars(); } } this.tableLocalSetting = ((LocalSettingDataTable)(base.Tables["LocalSetting"])); if ((initTable == true)) { if ((this.tableLocalSetting != null)) { this.tableLocalSetting.InitVars(); } } this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"])); if ((initTable == true)) { if ((this.tableOrders != null)) { this.tableOrders.InitVars(); } } this.tableinventoryMaster = ((inventoryMasterDataTable)(base.Tables["inventoryMaster"])); if ((initTable == true)) { if ((this.tableinventoryMaster != null)) { this.tableinventoryMaster.InitVars(); } } this.tableinventoryDetails = ((inventoryDetailsDataTable)(base.Tables["inventoryDetails"])); if ((initTable == true)) { if ((this.tableinventoryDetails != null)) { this.tableinventoryDetails.InitVars(); } } this.relationFK_InvoiceDetail_InvoiceMaster = this.Relations["FK_InvoiceDetail_InvoiceMaster"]; this.relationRemains_InvoiceDetail = this.Relations["Remains_InvoiceDetail"]; this.relationFK_inventoryMaster_inventoryDetails = this.Relations["FK_inventoryMaster_inventoryDetails"]; this.relationFK_ReceiptDetail_ReceiptMaster = this.Relations["FK_ReceiptDetail_ReceiptMaster"]; this.relationFK_ReceiptMaster_DocumentType = this.Relations["FK_ReceiptMaster_DocumentType"]; this.relationFK_InvoiceDetail_ReceiptRemains = this.Relations["FK_InvoiceDetail_ReceiptRemains"]; this.relationFK_ReceiptMaster_Stock = this.Relations["FK_ReceiptMaster_Stock"]; this.relationFK_ReceiptMaster_Stock1 = this.Relations["FK_ReceiptMaster_Stock1"]; this.relationReceiptDetail_Remains = this.Relations["ReceiptDetail_Remains"]; this.relationProduct_ReceiptDetail = this.Relations["Product_ReceiptDetail"]; this.relationInvoiceDetail_Product = this.Relations["InvoiceDetail_Product"]; this.relationProduct_Orders = this.Relations["Product_Orders"]; this.relationProduct_Remains = this.Relations["Product_Remains"]; }
private void InitClass() { this.DataSetName = "DS_AgentInvoice"; this.Prefix = ""; this.Namespace = "http://tempuri.org/DS_AgentInvoice.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableAgentInvoices = new AgentInvoicesDataTable(); base.Tables.Add(this.tableAgentInvoices); this.tableInvoiceDetail = new InvoiceDetailDataTable(); base.Tables.Add(this.tableInvoiceDetail); this.tableAgentInvoiceSum = new AgentInvoiceSumDataTable(); base.Tables.Add(this.tableAgentInvoiceSum); }
internal void InitVars(bool initTable) { this.tableAgentInvoices = ((AgentInvoicesDataTable)(base.Tables["AgentInvoices"])); if ((initTable == true)) { if ((this.tableAgentInvoices != null)) { this.tableAgentInvoices.InitVars(); } } this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"])); if ((initTable == true)) { if ((this.tableInvoiceDetail != null)) { this.tableInvoiceDetail.InitVars(); } } this.tableAgentInvoiceSum = ((AgentInvoiceSumDataTable)(base.Tables["AgentInvoiceSum"])); if ((initTable == true)) { if ((this.tableAgentInvoiceSum != null)) { this.tableAgentInvoiceSum.InitVars(); } } }
private void InitClass() { this.DataSetName = "MDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/MDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableCountry = new CountryDataTable(); base.Tables.Add(this.tableCountry); this.tableDocumentType = new DocumentTypeDataTable(); base.Tables.Add(this.tableDocumentType); this.tableInvoiceDetail = new InvoiceDetailDataTable(false); base.Tables.Add(this.tableInvoiceDetail); this.tableInvoiceMaster = new InvoiceMasterDataTable(false); base.Tables.Add(this.tableInvoiceMaster); this.tableOrganization = new OrganizationDataTable(false); base.Tables.Add(this.tableOrganization); this.tableReceiptRemains = new ReceiptRemainsDataTable(); base.Tables.Add(this.tableReceiptRemains); this.tableStock = new StockDataTable(false); base.Tables.Add(this.tableStock); this.tableTradePutlet = new TradePutletDataTable(); base.Tables.Add(this.tableTradePutlet); this.tableReceiptMaster = new ReceiptMasterDataTable(false); base.Tables.Add(this.tableReceiptMaster); this.tableReceiptDetail = new ReceiptDetailDataTable(false); base.Tables.Add(this.tableReceiptDetail); this.tableStorageCondition = new StorageConditionDataTable(false); base.Tables.Add(this.tableStorageCondition); this.tableProduct = new ProductDataTable(false); base.Tables.Add(this.tableProduct); this.tableFarmGroup = new FarmGroupDataTable(); base.Tables.Add(this.tableFarmGroup); this.tablePacking = new PackingDataTable(); base.Tables.Add(this.tablePacking); this.tableSubstance = new SubstanceDataTable(); base.Tables.Add(this.tableSubstance); this.tableUnit = new UnitDataTable(); base.Tables.Add(this.tableUnit); this.tableManufacturer = new ManufacturerDataTable(false); base.Tables.Add(this.tableManufacturer); this.tableFarmGroupLevel2 = new FarmGroupLevel2DataTable(false); base.Tables.Add(this.tableFarmGroupLevel2); this.tableOrders = new OrdersDataTable(); base.Tables.Add(this.tableOrders); this.tableRemains = new RemainsDataTable(false); base.Tables.Add(this.tableRemains); this.tablePricesPurchase = new PricesPurchaseDataTable(false); base.Tables.Add(this.tablePricesPurchase); this.tablePeriods = new PeriodsDataTable(false); base.Tables.Add(this.tablePeriods); this.tableLinkedInvoiceDetail = new LinkedInvoiceDetailDataTable(); base.Tables.Add(this.tableLinkedInvoiceDetail); this.tableLinkedInvoiceMaster = new LinkedInvoiceMasterDataTable(); base.Tables.Add(this.tableLinkedInvoiceMaster); this.tableReceiptDetailAdding = new ReceiptDetailAddingDataTable(); base.Tables.Add(this.tableReceiptDetailAdding); System.Data.ForeignKeyConstraint fkc; fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceMaster_StockMain", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceMaster.MainStockRefColumn}); this.tableInvoiceMaster.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_Stock_InvoiceMaster", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceMaster.RemoteStockRefColumn}); this.tableInvoiceMaster.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_ReceiptRemains_ReceiptDetail", new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptRemains.ReceiptDetailRefColumn}); this.tableReceiptRemains.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("ReceiptMaster_ReceiptDetail", new System.Data.DataColumn[] { this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ReceiptMasterRefColumn}); this.tableReceiptDetail.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_Substance_Product", new System.Data.DataColumn[] { this.tableSubstance.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.SubstanceRefColumn}); this.tableProduct.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_Unit_Product", new System.Data.DataColumn[] { this.tableUnit.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.UnitRefColumn}); this.tableProduct.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_FarmGroupLevel2_Product", new System.Data.DataColumn[] { this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.FarmGrouplevel2RefColumn}); this.tableProduct.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_FarmGroup_FarmGroupLevel2", new System.Data.DataColumn[] { this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] { this.tableFarmGroupLevel2.FarmGroupRefColumn}); this.tableFarmGroupLevel2.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_ReceiptDetailAdding_ReceiptDetail", new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetailAdding.ReceiptDetailRefColumn}); this.tableReceiptDetailAdding.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.relationFK_InvoiceMaster_StockMain = new System.Data.DataRelation("FK_InvoiceMaster_StockMain", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceMaster.MainStockRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceMaster_StockMain); this.relationFK_Stock_InvoiceMaster = new System.Data.DataRelation("FK_Stock_InvoiceMaster", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceMaster.RemoteStockRefColumn}, false); this.Relations.Add(this.relationFK_Stock_InvoiceMaster); this.relationFK_ReceiptRemains_ReceiptDetail = new System.Data.DataRelation("FK_ReceiptRemains_ReceiptDetail", new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptRemains.ReceiptDetailRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptRemains_ReceiptDetail); this.relationReceiptMaster_ReceiptDetail = new System.Data.DataRelation("ReceiptMaster_ReceiptDetail", new System.Data.DataColumn[] { this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ReceiptMasterRefColumn}, false); this.Relations.Add(this.relationReceiptMaster_ReceiptDetail); this.relationFK_Substance_Product = new System.Data.DataRelation("FK_Substance_Product", new System.Data.DataColumn[] { this.tableSubstance.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.SubstanceRefColumn}, false); this.Relations.Add(this.relationFK_Substance_Product); this.relationFK_Unit_Product = new System.Data.DataRelation("FK_Unit_Product", new System.Data.DataColumn[] { this.tableUnit.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.UnitRefColumn}, false); this.Relations.Add(this.relationFK_Unit_Product); this.relationFK_FarmGroupLevel2_Product = new System.Data.DataRelation("FK_FarmGroupLevel2_Product", new System.Data.DataColumn[] { this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.FarmGrouplevel2RefColumn}, false); this.Relations.Add(this.relationFK_FarmGroupLevel2_Product); this.relationFK_FarmGroup_FarmGroupLevel2 = new System.Data.DataRelation("FK_FarmGroup_FarmGroupLevel2", new System.Data.DataColumn[] { this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] { this.tableFarmGroupLevel2.FarmGroupRefColumn}, false); this.Relations.Add(this.relationFK_FarmGroup_FarmGroupLevel2); this.relationFK_ReceiptDetailAdding_ReceiptDetail = new System.Data.DataRelation("FK_ReceiptDetailAdding_ReceiptDetail", new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetailAdding.ReceiptDetailRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptDetailAdding_ReceiptDetail); this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] { this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.InvoiceMasterRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster); this.relationFK_InvoiceMaster_Organization = new System.Data.DataRelation("FK_InvoiceMaster_Organization", new System.Data.DataColumn[] { this.tableOrganization.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceMaster.OrganisationRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceMaster_Organization); this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] { this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.DocumentTypeRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType); this.relationFK_ReceiptMaster_Organization = new System.Data.DataRelation("FK_ReceiptMaster_Organization", new System.Data.DataColumn[] { this.tableOrganization.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.OrganizationRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_Organization); this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.MainStockRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_Stock); this.relationStorageCondition_Product = new System.Data.DataRelation("StorageCondition_Product", new System.Data.DataColumn[] { this.tableStorageCondition.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.StorageConditionRefColumn}, false); this.Relations.Add(this.relationStorageCondition_Product); this.relationFK_Packing_Product = new System.Data.DataRelation("FK_Packing_Product", new System.Data.DataColumn[] { this.tablePacking.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.PackingRefColumn}, false); this.Relations.Add(this.relationFK_Packing_Product); this.relationReceiptDetail_Orders = new System.Data.DataRelation("ReceiptDetail_Orders", new System.Data.DataColumn[] { this.tableReceiptDetail.ProductRefColumn}, new System.Data.DataColumn[] { this.tableOrders.ProductRefColumn}, false); this.Relations.Add(this.relationReceiptDetail_Orders); this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableRemains.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_Remains); this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableOrders.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_Orders); this.relationTradePutlet_Orders = new System.Data.DataRelation("TradePutlet_Orders", new System.Data.DataColumn[] { this.tableTradePutlet.IDColumn}, new System.Data.DataColumn[] { this.tableOrders.TradePupletRefColumn}, false); this.Relations.Add(this.relationTradePutlet_Orders); this.relationOrganization_PricesPurchase = new System.Data.DataRelation("Organization_PricesPurchase", new System.Data.DataColumn[] { this.tableOrganization.IDColumn}, new System.Data.DataColumn[] { this.tablePricesPurchase.OrganizationRefColumn}, false); this.Relations.Add(this.relationOrganization_PricesPurchase); this.relationProduct_PricesPurchase = new System.Data.DataRelation("Product_PricesPurchase", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tablePricesPurchase.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_PricesPurchase); this.relationReceiptDetail_PricesPurchase = new System.Data.DataRelation("ReceiptDetail_PricesPurchase", new System.Data.DataColumn[] { this.tableReceiptDetail.ProductRefColumn}, new System.Data.DataColumn[] { this.tablePricesPurchase.ProductRefColumn}, false); this.Relations.Add(this.relationReceiptDetail_PricesPurchase); this.relationReceiptDetail_InvoiceDetail = new System.Data.DataRelation("ReceiptDetail_InvoiceDetail", new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false); this.Relations.Add(this.relationReceiptDetail_InvoiceDetail); this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, false); this.Relations.Add(this.relationReceiptDetail_Remains); this.relationTradePutlet_Stock = new System.Data.DataRelation("TradePutlet_Stock", new System.Data.DataColumn[] { this.tableTradePutlet.IDColumn}, new System.Data.DataColumn[] { this.tableStock.TradePutletRefColumn}, false); this.Relations.Add(this.relationTradePutlet_Stock); this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_ReceiptDetail); this.relationFK_Manufacturer_ReceiptDetail = new System.Data.DataRelation("FK_Manufacturer_ReceiptDetail", new System.Data.DataColumn[] { this.tableManufacturer.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ManufacturerRefColumn}, false); this.Relations.Add(this.relationFK_Manufacturer_ReceiptDetail); this.relationLinkedInvoiceMaster_LinkedInvoiceDetail = new System.Data.DataRelation("LinkedInvoiceMaster_LinkedInvoiceDetail", new System.Data.DataColumn[] { this.tableLinkedInvoiceMaster.TradePutletRefColumn, this.tableLinkedInvoiceMaster.IDColumn}, new System.Data.DataColumn[] { this.tableLinkedInvoiceDetail.TradePutletRefColumn, this.tableLinkedInvoiceDetail.InvoiceMasterRefColumn}, false); this.Relations.Add(this.relationLinkedInvoiceMaster_LinkedInvoiceDetail); this.relationFK_Country_Manufacturer = new System.Data.DataRelation("FK_Country_Manufacturer", new System.Data.DataColumn[] { this.tableCountry.IDColumn}, new System.Data.DataColumn[] { this.tableManufacturer.CounrtyRefColumn}, false); this.Relations.Add(this.relationFK_Country_Manufacturer); this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false); this.Relations.Add(this.relationRemains_InvoiceDetail); }
internal void InitVars(bool initTable) { this.tableCountry = ((CountryDataTable)(base.Tables["Country"])); if ((initTable == true)) { if ((this.tableCountry != null)) { this.tableCountry.InitVars(); } } this.tableDocumentType = ((DocumentTypeDataTable)(base.Tables["DocumentType"])); if ((initTable == true)) { if ((this.tableDocumentType != null)) { this.tableDocumentType.InitVars(); } } this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"])); if ((initTable == true)) { if ((this.tableInvoiceDetail != null)) { this.tableInvoiceDetail.InitVars(); } } this.tableInvoiceMaster = ((InvoiceMasterDataTable)(base.Tables["InvoiceMaster"])); if ((initTable == true)) { if ((this.tableInvoiceMaster != null)) { this.tableInvoiceMaster.InitVars(); } } this.tableOrganization = ((OrganizationDataTable)(base.Tables["Organization"])); if ((initTable == true)) { if ((this.tableOrganization != null)) { this.tableOrganization.InitVars(); } } this.tableReceiptRemains = ((ReceiptRemainsDataTable)(base.Tables["ReceiptRemains"])); if ((initTable == true)) { if ((this.tableReceiptRemains != null)) { this.tableReceiptRemains.InitVars(); } } this.tableStock = ((StockDataTable)(base.Tables["Stock"])); if ((initTable == true)) { if ((this.tableStock != null)) { this.tableStock.InitVars(); } } this.tableTradePutlet = ((TradePutletDataTable)(base.Tables["TradePutlet"])); if ((initTable == true)) { if ((this.tableTradePutlet != null)) { this.tableTradePutlet.InitVars(); } } this.tableReceiptMaster = ((ReceiptMasterDataTable)(base.Tables["ReceiptMaster"])); if ((initTable == true)) { if ((this.tableReceiptMaster != null)) { this.tableReceiptMaster.InitVars(); } } this.tableReceiptDetail = ((ReceiptDetailDataTable)(base.Tables["ReceiptDetail"])); if ((initTable == true)) { if ((this.tableReceiptDetail != null)) { this.tableReceiptDetail.InitVars(); } } this.tableStorageCondition = ((StorageConditionDataTable)(base.Tables["StorageCondition"])); if ((initTable == true)) { if ((this.tableStorageCondition != null)) { this.tableStorageCondition.InitVars(); } } this.tableProduct = ((ProductDataTable)(base.Tables["Product"])); if ((initTable == true)) { if ((this.tableProduct != null)) { this.tableProduct.InitVars(); } } this.tableFarmGroup = ((FarmGroupDataTable)(base.Tables["FarmGroup"])); if ((initTable == true)) { if ((this.tableFarmGroup != null)) { this.tableFarmGroup.InitVars(); } } this.tablePacking = ((PackingDataTable)(base.Tables["Packing"])); if ((initTable == true)) { if ((this.tablePacking != null)) { this.tablePacking.InitVars(); } } this.tableSubstance = ((SubstanceDataTable)(base.Tables["Substance"])); if ((initTable == true)) { if ((this.tableSubstance != null)) { this.tableSubstance.InitVars(); } } this.tableUnit = ((UnitDataTable)(base.Tables["Unit"])); if ((initTable == true)) { if ((this.tableUnit != null)) { this.tableUnit.InitVars(); } } this.tableManufacturer = ((ManufacturerDataTable)(base.Tables["Manufacturer"])); if ((initTable == true)) { if ((this.tableManufacturer != null)) { this.tableManufacturer.InitVars(); } } this.tableFarmGroupLevel2 = ((FarmGroupLevel2DataTable)(base.Tables["FarmGroupLevel2"])); if ((initTable == true)) { if ((this.tableFarmGroupLevel2 != null)) { this.tableFarmGroupLevel2.InitVars(); } } this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"])); if ((initTable == true)) { if ((this.tableOrders != null)) { this.tableOrders.InitVars(); } } this.tableRemains = ((RemainsDataTable)(base.Tables["Remains"])); if ((initTable == true)) { if ((this.tableRemains != null)) { this.tableRemains.InitVars(); } } this.tablePricesPurchase = ((PricesPurchaseDataTable)(base.Tables["PricesPurchase"])); if ((initTable == true)) { if ((this.tablePricesPurchase != null)) { this.tablePricesPurchase.InitVars(); } } this.tablePeriods = ((PeriodsDataTable)(base.Tables["Periods"])); if ((initTable == true)) { if ((this.tablePeriods != null)) { this.tablePeriods.InitVars(); } } this.tableLinkedInvoiceDetail = ((LinkedInvoiceDetailDataTable)(base.Tables["LinkedInvoiceDetail"])); if ((initTable == true)) { if ((this.tableLinkedInvoiceDetail != null)) { this.tableLinkedInvoiceDetail.InitVars(); } } this.tableLinkedInvoiceMaster = ((LinkedInvoiceMasterDataTable)(base.Tables["LinkedInvoiceMaster"])); if ((initTable == true)) { if ((this.tableLinkedInvoiceMaster != null)) { this.tableLinkedInvoiceMaster.InitVars(); } } this.tableReceiptDetailAdding = ((ReceiptDetailAddingDataTable)(base.Tables["ReceiptDetailAdding"])); if ((initTable == true)) { if ((this.tableReceiptDetailAdding != null)) { this.tableReceiptDetailAdding.InitVars(); } } this.relationFK_InvoiceMaster_StockMain = this.Relations["FK_InvoiceMaster_StockMain"]; this.relationFK_Stock_InvoiceMaster = this.Relations["FK_Stock_InvoiceMaster"]; this.relationFK_ReceiptRemains_ReceiptDetail = this.Relations["FK_ReceiptRemains_ReceiptDetail"]; this.relationReceiptMaster_ReceiptDetail = this.Relations["ReceiptMaster_ReceiptDetail"]; this.relationFK_Substance_Product = this.Relations["FK_Substance_Product"]; this.relationFK_Unit_Product = this.Relations["FK_Unit_Product"]; this.relationFK_FarmGroupLevel2_Product = this.Relations["FK_FarmGroupLevel2_Product"]; this.relationFK_FarmGroup_FarmGroupLevel2 = this.Relations["FK_FarmGroup_FarmGroupLevel2"]; this.relationFK_ReceiptDetailAdding_ReceiptDetail = this.Relations["FK_ReceiptDetailAdding_ReceiptDetail"]; this.relationFK_InvoiceDetail_InvoiceMaster = this.Relations["FK_InvoiceDetail_InvoiceMaster"]; this.relationFK_InvoiceMaster_Organization = this.Relations["FK_InvoiceMaster_Organization"]; this.relationFK_ReceiptMaster_DocumentType = this.Relations["FK_ReceiptMaster_DocumentType"]; this.relationFK_ReceiptMaster_Organization = this.Relations["FK_ReceiptMaster_Organization"]; this.relationFK_ReceiptMaster_Stock = this.Relations["FK_ReceiptMaster_Stock"]; this.relationStorageCondition_Product = this.Relations["StorageCondition_Product"]; this.relationFK_Packing_Product = this.Relations["FK_Packing_Product"]; this.relationReceiptDetail_Orders = this.Relations["ReceiptDetail_Orders"]; this.relationProduct_Remains = this.Relations["Product_Remains"]; this.relationProduct_Orders = this.Relations["Product_Orders"]; this.relationTradePutlet_Orders = this.Relations["TradePutlet_Orders"]; this.relationOrganization_PricesPurchase = this.Relations["Organization_PricesPurchase"]; this.relationProduct_PricesPurchase = this.Relations["Product_PricesPurchase"]; this.relationReceiptDetail_PricesPurchase = this.Relations["ReceiptDetail_PricesPurchase"]; this.relationReceiptDetail_InvoiceDetail = this.Relations["ReceiptDetail_InvoiceDetail"]; this.relationReceiptDetail_Remains = this.Relations["ReceiptDetail_Remains"]; this.relationTradePutlet_Stock = this.Relations["TradePutlet_Stock"]; this.relationProduct_ReceiptDetail = this.Relations["Product_ReceiptDetail"]; this.relationFK_Manufacturer_ReceiptDetail = this.Relations["FK_Manufacturer_ReceiptDetail"]; this.relationLinkedInvoiceMaster_LinkedInvoiceDetail = this.Relations["LinkedInvoiceMaster_LinkedInvoiceDetail"]; this.relationFK_Country_Manufacturer = this.Relations["FK_Country_Manufacturer"]; this.relationRemains_InvoiceDetail = this.Relations["Remains_InvoiceDetail"]; }