public override DataTable Clone() { CountryDataTable cln = ((CountryDataTable)(base.Clone())); cln.InitVars(); return(cln); }
private void InitClass() { this.DataSetName = "AddressDictionary"; this.Prefix = ""; this.Namespace = "http://tempuri.org/Dataset1.xsd"; this.Locale = new System.Globalization.CultureInfo("en-US"); this.CaseSensitive = false; this.EnforceConstraints = true; this.tableStreetSuffix = new StreetSuffixDataTable(); this.Tables.Add(this.tableStreetSuffix); this.tableCountry = new CountryDataTable(); this.Tables.Add(this.tableCountry); this.tableCity = new CityDataTable(); this.Tables.Add(this.tableCity); this.tableStateProvince = new StateProvinceDataTable(); this.Tables.Add(this.tableStateProvince); }
internal void InitVars() { this.tableStreetSuffix = ((StreetSuffixDataTable)(this.Tables["StreetSuffix"])); if ((this.tableStreetSuffix != null)) { this.tableStreetSuffix.InitVars(); } this.tableCountry = ((CountryDataTable)(this.Tables["Country"])); if ((this.tableCountry != null)) { this.tableCountry.InitVars(); } this.tableCity = ((CityDataTable)(this.Tables["City"])); if ((this.tableCity != null)) { this.tableCity.InitVars(); } this.tableStateProvince = ((StateProvinceDataTable)(this.Tables["StateProvince"])); if ((this.tableStateProvince != null)) { this.tableStateProvince.InitVars(); } }
private void InitClass() { this.DataSetName = "Countries"; this.Prefix = ""; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableCountry = new CountryDataTable(); base.Tables.Add(this.tableCountry); this.tableRegion = new RegionDataTable(); base.Tables.Add(this.tableRegion); this.tableCity = new CityDataTable(); base.Tables.Add(this.tableCity); global::System.Data.ForeignKeyConstraint fkc; fkc = new global::System.Data.ForeignKeyConstraint("Country_Region", new global::System.Data.DataColumn[] { this.tableCountry.Country_IdColumn}, new global::System.Data.DataColumn[] { this.tableRegion.Country_IdColumn}); this.tableRegion.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.Cascade; fkc.UpdateRule = global::System.Data.Rule.Cascade; fkc = new global::System.Data.ForeignKeyConstraint("Region_City", new global::System.Data.DataColumn[] { this.tableRegion.Region_IdColumn}, new global::System.Data.DataColumn[] { this.tableCity.Region_IdColumn}); this.tableCity.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.Cascade; fkc.UpdateRule = global::System.Data.Rule.Cascade; this.relationCountry_Region = new global::System.Data.DataRelation("Country_Region", new global::System.Data.DataColumn[] { this.tableCountry.Country_IdColumn}, new global::System.Data.DataColumn[] { this.tableRegion.Country_IdColumn}, false); this.relationCountry_Region.Nested = true; this.Relations.Add(this.relationCountry_Region); this.relationRegion_City = new global::System.Data.DataRelation("Region_City", new global::System.Data.DataColumn[] { this.tableRegion.Region_IdColumn}, new global::System.Data.DataColumn[] { this.tableCity.Region_IdColumn}, false); this.relationRegion_City.Nested = true; this.Relations.Add(this.relationRegion_City); }
internal void InitVars(bool initTable) { this.tableCountry = ((CountryDataTable)(base.Tables["Country"])); if ((initTable == true)) { if ((this.tableCountry != null)) { this.tableCountry.InitVars(); } } this.tableRegion = ((RegionDataTable)(base.Tables["Region"])); if ((initTable == true)) { if ((this.tableRegion != null)) { this.tableRegion.InitVars(); } } this.tableCity = ((CityDataTable)(base.Tables["City"])); if ((initTable == true)) { if ((this.tableCity != null)) { this.tableCity.InitVars(); } } this.relationCountry_Region = this.Relations["Country_Region"]; this.relationRegion_City = this.Relations["Region_City"]; }
internal CountryRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableCountry = ((CountryDataTable)(this.Table)); }
private void InitClass() { this.DataSetName = "DS_Country"; this.Prefix = ""; this.Namespace = "http://tempuri.org/DS_Country.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableCountry = new CountryDataTable(); base.Tables.Add(this.tableCountry); }
internal void InitVars(bool initTable) { this.tableCountry = ((CountryDataTable)(base.Tables["Country"])); if ((initTable == true)) { if ((this.tableCountry != null)) { this.tableCountry.InitVars(); } } }
private void InitClass() { this.DataSetName = "FullDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/FullDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableProduct = new ProductDataTable(); base.Tables.Add(this.tableProduct); this.tableCountry = new CountryDataTable(); base.Tables.Add(this.tableCountry); this.tableFarmGroup = new FarmGroupDataTable(); base.Tables.Add(this.tableFarmGroup); this.tableFarmGroupLevel2 = new FarmGroupLevel2DataTable(false); base.Tables.Add(this.tableFarmGroupLevel2); this.tableManufacturer = new ManufacturerDataTable(false); base.Tables.Add(this.tableManufacturer); this.tablePacking = new PackingDataTable(); base.Tables.Add(this.tablePacking); this.tableStorageCondition = new StorageConditionDataTable(); base.Tables.Add(this.tableStorageCondition); this.tableUnit = new UnitDataTable(); base.Tables.Add(this.tableUnit); this.tableSubstance = new SubstanceDataTable(); base.Tables.Add(this.tableSubstance); this.relationFK_Product_FarmGroupLevel2 = new System.Data.DataRelation("FK_Product_FarmGroupLevel2", new System.Data.DataColumn[] { this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.FarmGrouplevel2RefColumn}, false); this.Relations.Add(this.relationFK_Product_FarmGroupLevel2); this.relationFK_FarmGroupLevel2_FarmGroup = new System.Data.DataRelation("FK_FarmGroupLevel2_FarmGroup", new System.Data.DataColumn[] { this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] { this.tableFarmGroupLevel2.FarmGroupRefColumn}, false); this.Relations.Add(this.relationFK_FarmGroupLevel2_FarmGroup); this.relationFK_Manufacturer_Country = new System.Data.DataRelation("FK_Manufacturer_Country", new System.Data.DataColumn[] { this.tableCountry.IDColumn}, new System.Data.DataColumn[] { this.tableManufacturer.CounrtyRefColumn}, false); this.Relations.Add(this.relationFK_Manufacturer_Country); this.relationFK_Product_Packing = new System.Data.DataRelation("FK_Product_Packing", new System.Data.DataColumn[] { this.tablePacking.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.PackingRefColumn}, false); this.Relations.Add(this.relationFK_Product_Packing); this.relationFK_Product_StorageCondition = new System.Data.DataRelation("FK_Product_StorageCondition", new System.Data.DataColumn[] { this.tableStorageCondition.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.StorageConditionRefColumn}, false); this.Relations.Add(this.relationFK_Product_StorageCondition); this.relationFK_Product_Unit = new System.Data.DataRelation("FK_Product_Unit", new System.Data.DataColumn[] { this.tableUnit.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.UnitRefColumn}, false); this.Relations.Add(this.relationFK_Product_Unit); this.relationFK_Product_Substance = new System.Data.DataRelation("FK_Product_Substance", new System.Data.DataColumn[] { this.tableSubstance.IDColumn}, new System.Data.DataColumn[] { this.tableProduct.SubstanceRefColumn}, false); this.Relations.Add(this.relationFK_Product_Substance); }
internal void InitVars(bool initTable) { this.tableProduct = ((ProductDataTable)(base.Tables["Product"])); if ((initTable == true)) { if ((this.tableProduct != null)) { this.tableProduct.InitVars(); } } this.tableCountry = ((CountryDataTable)(base.Tables["Country"])); if ((initTable == true)) { if ((this.tableCountry != null)) { this.tableCountry.InitVars(); } } this.tableFarmGroup = ((FarmGroupDataTable)(base.Tables["FarmGroup"])); if ((initTable == true)) { if ((this.tableFarmGroup != null)) { this.tableFarmGroup.InitVars(); } } this.tableFarmGroupLevel2 = ((FarmGroupLevel2DataTable)(base.Tables["FarmGroupLevel2"])); if ((initTable == true)) { if ((this.tableFarmGroupLevel2 != null)) { this.tableFarmGroupLevel2.InitVars(); } } this.tableManufacturer = ((ManufacturerDataTable)(base.Tables["Manufacturer"])); if ((initTable == true)) { if ((this.tableManufacturer != null)) { this.tableManufacturer.InitVars(); } } this.tablePacking = ((PackingDataTable)(base.Tables["Packing"])); if ((initTable == true)) { if ((this.tablePacking != null)) { this.tablePacking.InitVars(); } } this.tableStorageCondition = ((StorageConditionDataTable)(base.Tables["StorageCondition"])); if ((initTable == true)) { if ((this.tableStorageCondition != null)) { this.tableStorageCondition.InitVars(); } } this.tableUnit = ((UnitDataTable)(base.Tables["Unit"])); if ((initTable == true)) { if ((this.tableUnit != null)) { this.tableUnit.InitVars(); } } this.tableSubstance = ((SubstanceDataTable)(base.Tables["Substance"])); if ((initTable == true)) { if ((this.tableSubstance != null)) { this.tableSubstance.InitVars(); } } this.relationFK_Product_FarmGroupLevel2 = this.Relations["FK_Product_FarmGroupLevel2"]; this.relationFK_FarmGroupLevel2_FarmGroup = this.Relations["FK_FarmGroupLevel2_FarmGroup"]; this.relationFK_Manufacturer_Country = this.Relations["FK_Manufacturer_Country"]; this.relationFK_Product_Packing = this.Relations["FK_Product_Packing"]; this.relationFK_Product_StorageCondition = this.Relations["FK_Product_StorageCondition"]; this.relationFK_Product_Unit = this.Relations["FK_Product_Unit"]; this.relationFK_Product_Substance = this.Relations["FK_Product_Substance"]; }
internal CountryRow(DataRowBuilder rb) : base(rb) { this.tableCountry = ((CountryDataTable)(this.Table)); }
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"]; }
private void InitClass() { this.DataSetName = "dsWT"; this.Prefix = ""; this.Namespace = "http://tempuri.org/dsWT.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableCountry = new CountryDataTable(); base.Tables.Add(this.tableCountry); this.tableState = new StateDataTable(); base.Tables.Add(this.tableState); this.tableContinent = new ContinentDataTable(); base.Tables.Add(this.tableContinent); this.tableTimezone = new TimezoneDataTable(); base.Tables.Add(this.tableTimezone); this.tableCity = new CityDataTable(); base.Tables.Add(this.tableCity); System.Data.ForeignKeyConstraint fkc; fkc = new System.Data.ForeignKeyConstraint("FK_Continent_Country_Continent_ID", new System.Data.DataColumn[] { this.tableContinent.Continent_IDColumn}, new System.Data.DataColumn[] { this.tableCountry.Continent_IDColumn}); this.tableCountry.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_Country_State_Country_ID", new System.Data.DataColumn[] { this.tableCountry.Country_IDColumn}, new System.Data.DataColumn[] { this.tableState.Country_IDColumn}); this.tableState.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_Timezone_City_Timezone_ID", new System.Data.DataColumn[] { this.tableTimezone.Timezone_IDColumn}, new System.Data.DataColumn[] { this.tableCity.Timezone_IDColumn}); this.tableCity.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("FK_State_City_State_ID", new System.Data.DataColumn[] { this.tableState.State_IDColumn}, new System.Data.DataColumn[] { this.tableCity.State_IDColumn}); this.tableCity.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.relationFK_Continent_Country_Continent_ID = new System.Data.DataRelation("FK_Continent_Country_Continent_ID", new System.Data.DataColumn[] { this.tableContinent.Continent_IDColumn}, new System.Data.DataColumn[] { this.tableCountry.Continent_IDColumn}, false); this.Relations.Add(this.relationFK_Continent_Country_Continent_ID); this.relationFK_Country_State_Country_ID = new System.Data.DataRelation("FK_Country_State_Country_ID", new System.Data.DataColumn[] { this.tableCountry.Country_IDColumn}, new System.Data.DataColumn[] { this.tableState.Country_IDColumn}, false); this.Relations.Add(this.relationFK_Country_State_Country_ID); this.relationFK_Timezone_City_Timezone_ID = new System.Data.DataRelation("FK_Timezone_City_Timezone_ID", new System.Data.DataColumn[] { this.tableTimezone.Timezone_IDColumn}, new System.Data.DataColumn[] { this.tableCity.Timezone_IDColumn}, false); this.Relations.Add(this.relationFK_Timezone_City_Timezone_ID); this.relationFK_State_City_State_ID = new System.Data.DataRelation("FK_State_City_State_ID", new System.Data.DataColumn[] { this.tableState.State_IDColumn}, new System.Data.DataColumn[] { this.tableCity.State_IDColumn}, false); this.Relations.Add(this.relationFK_State_City_State_ID); }
internal void InitVars(bool initTable) { this.tableCountry = ((CountryDataTable)(base.Tables["Country"])); if ((initTable == true)) { if ((this.tableCountry != null)) { this.tableCountry.InitVars(); } } this.tableState = ((StateDataTable)(base.Tables["State"])); if ((initTable == true)) { if ((this.tableState != null)) { this.tableState.InitVars(); } } this.tableContinent = ((ContinentDataTable)(base.Tables["Continent"])); if ((initTable == true)) { if ((this.tableContinent != null)) { this.tableContinent.InitVars(); } } this.tableTimezone = ((TimezoneDataTable)(base.Tables["Timezone"])); if ((initTable == true)) { if ((this.tableTimezone != null)) { this.tableTimezone.InitVars(); } } this.tableCity = ((CityDataTable)(base.Tables["City"])); if ((initTable == true)) { if ((this.tableCity != null)) { this.tableCity.InitVars(); } } this.relationFK_Continent_Country_Continent_ID = this.Relations["FK_Continent_Country_Continent_ID"]; this.relationFK_Country_State_Country_ID = this.Relations["FK_Country_State_Country_ID"]; this.relationFK_Timezone_City_Timezone_ID = this.Relations["FK_Timezone_City_Timezone_ID"]; this.relationFK_State_City_State_ID = this.Relations["FK_State_City_State_ID"]; }