internal void InitVars()
{
this.tableCustomers = ((CustomersDataTable)(this.Tables["Customers"]));
if ((this.tableCustomers != null))
{
this.tableCustomers.InitVars();
}
this.tableEmployees = ((EmployeesDataTable)(this.Tables["Employees"]));
if ((this.tableEmployees != null))
{
this.tableEmployees.InitVars();
}
this.tableOrders = ((OrdersDataTable)(this.Tables["Orders"]));
if ((this.tableOrders != null))
{
this.tableOrders.InitVars();
}
}
internal OrdersRow(DataRowBuilder rb) :
base(rb)
{
this.tableOrders = ((OrdersDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "dsCore";
this.Prefix = "";
this.Namespace = "http://tempuri.org/dsCore.xsd";
this.Locale = new global::System.Globalization.CultureInfo("id-ID");
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCurrencies = new CurrenciesDataTable();
base.Tables.Add(this.tableCurrencies);
this.tableItems = new ItemsDataTable();
base.Tables.Add(this.tableItems);
this.tableUnitMeasures = new UnitMeasuresDataTable();
base.Tables.Add(this.tableUnitMeasures);
this.tableWarehouses = new WarehousesDataTable();
base.Tables.Add(this.tableWarehouses);
this.tableCompanies = new CompaniesDataTable();
base.Tables.Add(this.tableCompanies);
this.tableItemInventories = new ItemInventoriesDataTable();
base.Tables.Add(this.tableItemInventories);
this.tableOrderDetails = new OrderDetailsDataTable();
base.Tables.Add(this.tableOrderDetails);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableItemCategories = new ItemCategoriesDataTable();
base.Tables.Add(this.tableItemCategories);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Items_Categories", new global::System.Data.DataColumn[] {
this.tableItemCategories.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.CategoryIDColumn});
this.tableItems.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Items_UnitMeasures", new global::System.Data.DataColumn[] {
this.tableUnitMeasures.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.MeasureIDColumn});
this.tableItems.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_ItemInventories_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.ItemIDColumn});
this.tableItemInventories.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_ItemInventories_Warehouse", new global::System.Data.DataColumn[] {
this.tableWarehouses.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.WarehouseIDColumn});
this.tableItemInventories.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_OrderDetails_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.ItemIDColumn});
this.tableOrderDetails.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_OrderDetails_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn});
this.tableOrderDetails.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("FK_Orders_Companies", new global::System.Data.DataColumn[] {
this.tableCompanies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CompanyIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Orders_Parent", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ParentIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Orders_Currencies", new global::System.Data.DataColumn[] {
this.tableCurrencies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CurrencyIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.None;
fkc.UpdateRule = global::System.Data.Rule.None;
this.relationFK_Items_Categories = new global::System.Data.DataRelation("FK_Items_Categories", new global::System.Data.DataColumn[] {
this.tableItemCategories.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.CategoryIDColumn}, false);
this.Relations.Add(this.relationFK_Items_Categories);
this.relationFK_Items_UnitMeasures = new global::System.Data.DataRelation("FK_Items_UnitMeasures", new global::System.Data.DataColumn[] {
this.tableUnitMeasures.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.MeasureIDColumn}, false);
this.Relations.Add(this.relationFK_Items_UnitMeasures);
this.relationFK_ItemInventories_Items = new global::System.Data.DataRelation("FK_ItemInventories_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.ItemIDColumn}, false);
this.Relations.Add(this.relationFK_ItemInventories_Items);
this.relationFK_ItemInventories_Warehouse = new global::System.Data.DataRelation("FK_ItemInventories_Warehouse", new global::System.Data.DataColumn[] {
this.tableWarehouses.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItemInventories.WarehouseIDColumn}, false);
this.Relations.Add(this.relationFK_ItemInventories_Warehouse);
this.relationFK_OrderDetails_Items = new global::System.Data.DataRelation("FK_OrderDetails_Items", new global::System.Data.DataColumn[] {
this.tableItems.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.ItemIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Items);
this.relationFK_OrderDetails_Orders = new global::System.Data.DataRelation("FK_OrderDetails_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Orders);
this.relationFK_Orders_Companies = new global::System.Data.DataRelation("FK_Orders_Companies", new global::System.Data.DataColumn[] {
this.tableCompanies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CompanyIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Companies);
this.relationFK_Orders_Parent = new global::System.Data.DataRelation("FK_Orders_Parent", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ParentIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Parent);
this.relationFK_Orders_Currencies = new global::System.Data.DataRelation("FK_Orders_Currencies", new global::System.Data.DataColumn[] {
this.tableCurrencies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CurrencyIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Currencies);
this.relationFK_Items_Companies = new global::System.Data.DataRelation("FK_Items_Companies", new global::System.Data.DataColumn[] {
this.tableCompanies.IDColumn}, new global::System.Data.DataColumn[] {
this.tableItems.CompanyIDColumn}, false);
this.Relations.Add(this.relationFK_Items_Companies);
this.relationFK_OrderDetails_Reference = new global::System.Data.DataRelation("FK_OrderDetails_Reference", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.ReferenceIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Reference);
}
private void InitClass() {
this.DataSetName = "DataSet2";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/DataSet2.xsd";
this.Locale = new global::System.Globalization.CultureInfo("zh-CN");
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("CustomersOrders", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.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("OrdersOrder_x0020_Details", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.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.relationCustomersOrders = new global::System.Data.DataRelation("CustomersOrders", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustomersOrders);
this.relationOrdersOrder_x0020_Details = new global::System.Data.DataRelation("OrdersOrder_x0020_Details", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_x0020_Details);
}
private void InitClass() {
this.DataSetName = "NorthwindCustomerOrders";
this.Prefix = "";
this.EnforceConstraints = true;
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("CustOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationCustOrders = new System.Data.DataRelation("CustOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustOrders);
}
internal void InitVars(bool initTable) {
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableChangeLogs = ((ChangeLogsDataTable)(base.Tables["ChangeLogs"]));
if ((initTable == true)) {
if ((this.tableChangeLogs != null)) {
this.tableChangeLogs.InitVars();
}
}
this.tableCalculatedOrderDetails = ((CalculatedOrderDetailsDataTable)(base.Tables["CalculatedOrderDetails"]));
if ((initTable == true)) {
if ((this.tableCalculatedOrderDetails != null)) {
this.tableCalculatedOrderDetails.InitVars();
}
}
this.tableCalculatedOrders = ((CalculatedOrdersDataTable)(base.Tables["CalculatedOrders"]));
if ((initTable == true)) {
if ((this.tableCalculatedOrders != null)) {
this.tableCalculatedOrders.InitVars();
}
}
this.tableDeletedOrderDetails = ((DeletedOrderDetailsDataTable)(base.Tables["DeletedOrderDetails"]));
if ((initTable == true)) {
if ((this.tableDeletedOrderDetails != null)) {
this.tableDeletedOrderDetails.InitVars();
}
}
this.relationOrdersOrder_Details = this.Relations["OrdersOrder Details"];
this.relationCalculatedOrders_CalculatedOrderDetails = this.Relations["CalculatedOrders_CalculatedOrderDetails"];
}
private void InitClass()
{
this.DataSetName = "OrdersPendingData";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/OrdersPendingData.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableOrders = new OrdersDataTable();
this.Tables.Add(this.tableOrders);
}
private void InitClass() {
this.DataSetName = "dsOrderHistory";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/dsOrderHistory.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableCustomers = new CustomersDataTable();
this.Tables.Add(this.tableCustomers);
this.tableOrders = new OrdersDataTable();
this.Tables.Add(this.tableOrders);
ForeignKeyConstraint fkc;
fkc = new ForeignKeyConstraint("CustomersOrders", new DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = AcceptRejectRule.None;
fkc.DeleteRule = Rule.Cascade;
fkc.UpdateRule = Rule.Cascade;
this.relationCustomersOrders = new DataRelation("CustomersOrders", new DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustomersOrders);
}
internal OrdersRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableOrders = ((OrdersDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "NorthwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableCategories = new CategoriesDataTable();
base.Tables.Add(this.tableCategories);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("SuppliersProducts", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn});
this.tableProducts.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("CategoriesProducts", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn});
this.tableProducts.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("ShippersOrders", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn});
this.tableOrders.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("CustomersOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.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("EmployeesOrders", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn});
this.tableOrders.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("ProductsOrder Details", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn});
this.tableOrder_Details.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("OrdersOrder Details", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationSuppliersProducts = new System.Data.DataRelation("SuppliersProducts", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationSuppliersProducts);
this.relationCategoriesProducts = new System.Data.DataRelation("CategoriesProducts", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationCategoriesProducts);
this.relationShippersOrders = new System.Data.DataRelation("ShippersOrders", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationShippersOrders);
this.relationCustomersOrders = new System.Data.DataRelation("CustomersOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustomersOrders);
this.relationEmployeesOrders = new System.Data.DataRelation("EmployeesOrders", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationEmployeesOrders);
this.relationProductsOrder_Details = new System.Data.DataRelation("ProductsOrder Details", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationProductsOrder_Details);
this.relationOrdersOrder_Details = new System.Data.DataRelation("OrdersOrder Details", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_Details);
this.ExtendedProperties.Add("DSGenerator_DataSetName", "NorthwindDataSet");
this.ExtendedProperties.Add("User_DataSetName", "NorthwindDataSet");
}
internal void InitVars(bool initTable) {
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
if ((initTable == true)) {
if ((this.tableSuppliers != null)) {
this.tableSuppliers.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.relationSuppliersProducts = this.Relations["SuppliersProducts"];
this.relationCategoriesProducts = this.Relations["CategoriesProducts"];
this.relationShippersOrders = this.Relations["ShippersOrders"];
this.relationCustomersOrders = this.Relations["CustomersOrders"];
this.relationEmployeesOrders = this.Relations["EmployeesOrders"];
this.relationProductsOrder_Details = this.Relations["ProductsOrder Details"];
this.relationOrdersOrder_Details = this.Relations["OrdersOrder Details"];
}
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 = "NorthwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.relationFK_Orders_Customers = new System.Data.DataRelation("FK_Orders_Customers", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Customers);
}
internal void InitVars(bool initTable) {
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.relationFK_Orders_Customers = this.Relations["FK_Orders_Customers"];
}
internal void InitVars()
{
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Tables["Order Details"]));
if ((this.tableOrder_Details != null))
{
this.tableOrder_Details.InitVars();
}
this.tableOrders = ((OrdersDataTable)(this.Tables["Orders"]));
if ((this.tableOrders != null))
{
this.tableOrders.InitVars();
}
this.relationOrdersOrder_x0020_Details = this.Relations["OrdersOrder_x0020_Details"];
}
private void InitClass() {
this.DataSetName = "dsOrders";
this.Prefix = "";
this.Namespace = "http://tempuri.org/dsOrders.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableOrderDetails = new OrderDetailsDataTable();
base.Tables.Add(this.tableOrderDetails);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("FK_OrderDetails_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn});
this.tableOrderDetails.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.relationFK_OrderDetails_Orders = new global::System.Data.DataRelation("FK_OrderDetails_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.IDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_OrderDetails_Orders);
}
internal OrdersRow(DataRowBuilder rb) :
base(rb)
{
_tableOrders = ((OrdersDataTable)(Table));
}
public int AddOrder(string customerId,
DateTime orderDate,
DateTime requiredDate,
DateTime?shippedDate = null,
int?shipVia = null,
int?employeeId = null,
decimal?freight = null,
string shipName = null,
string shipAddress = null,
string shipCity = null,
string shipRegion = null,
string shipPostalCode = null)
{
var ordersDataTable = new OrdersDataTable();
var ordersRow = ordersDataTable.NewOrdersRow();
ordersRow.CustomerID = customerId;
ordersRow.OrderDate = orderDate;
ordersRow.RequiredDate = requiredDate;
ordersRow.EmployeeID = employeeId.HasValue == true ? employeeId.Value : 1;
ordersRow.ShippedDate = shippedDate.HasValue == true ? shippedDate.Value : DateTime.Today.AddMonths(1);
if (shipVia == null)
{
ordersRow.SetShipViaNull();
}
else
{
ordersRow.ShipVia = shipVia.Value;
}
if (freight == null)
{
ordersRow.SetFreightNull();
}
else
{
ordersRow.Freight = freight.Value;
}
if (shipName == null)
{
ordersRow.SetShipNameNull();
}
else
{
ordersRow.ShipName = shipName;
}
if (shipAddress == null)
{
ordersRow.SetShipAddressNull();
}
else
{
ordersRow.ShipAddress = shipAddress;
}
if (shipCity == null)
{
ordersRow.SetShipCityNull();
}
else
{
ordersRow.ShipCity = shipCity;
}
if (shipRegion == null)
{
ordersRow.SetShipRegionNull();
}
else
{
ordersRow.ShipRegion = shipRegion;
}
if (shipPostalCode == null)
{
ordersRow.SetShipPostalCodeNull();
}
else
{
ordersRow.ShipPostalCode = shipPostalCode;
}
ordersDataTable.AddOrdersRow(ordersRow);
var rowsAffected = OrdersTableAdapter.Update(ordersDataTable);
if (rowsAffected == 1)
{
return(ordersRow.OrderID);
}
else
{
return(-1);
}
}
internal void InitVars()
{
_tableOrder_Details = ((Order_DetailsDataTable)(Tables["Order Details"]));
if ((_tableOrder_Details != null))
{
_tableOrder_Details.InitVars();
}
_tableOrders = ((OrdersDataTable)(Tables["Orders"]));
if ((_tableOrders != null))
{
_tableOrders.InitVars();
}
_relationOrdersOrder_x0020_Details = Relations["OrdersOrder_x0020_Details"];
}
internal void InitVars()
{
this.tableOrders = ((OrdersDataTable)(this.Tables["Orders"]));
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
internal void InitVars(bool initTable) {
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.tableOrderDetails = ((OrderDetailsDataTable)(base.Tables["OrderDetails"]));
if ((initTable == true)) {
if ((this.tableOrderDetails != null)) {
this.tableOrderDetails.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.relationOrders_OrderDetails = this.Relations["Orders_OrderDetails"];
}
private void InitClass() {
this.DataSetName = "Order";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Order.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableChangeLogs = new ChangeLogsDataTable();
base.Tables.Add(this.tableChangeLogs);
this.tableCalculatedOrderDetails = new CalculatedOrderDetailsDataTable();
base.Tables.Add(this.tableCalculatedOrderDetails);
this.tableCalculatedOrders = new CalculatedOrdersDataTable();
base.Tables.Add(this.tableCalculatedOrders);
this.tableDeletedOrderDetails = new DeletedOrderDetailsDataTable();
base.Tables.Add(this.tableDeletedOrderDetails);
this.relationOrdersOrder_Details = new global::System.Data.DataRelation("OrdersOrder Details", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_Details);
this.relationCalculatedOrders_CalculatedOrderDetails = new global::System.Data.DataRelation("CalculatedOrders_CalculatedOrderDetails", new global::System.Data.DataColumn[] {
this.tableCalculatedOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableCalculatedOrderDetails.OrderIDColumn}, false);
this.Relations.Add(this.relationCalculatedOrders_CalculatedOrderDetails);
}
private void InitClass() {
this.DataSetName = "NorthwindDataSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/NorthwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
this.tableOrderDetails = new OrderDetailsDataTable();
base.Tables.Add(this.tableOrderDetails);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.relationOrders_OrderDetails = new global::System.Data.DataRelation("Orders_OrderDetails", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrderDetails.OrderIDColumn}, false);
this.Relations.Add(this.relationOrders_OrderDetails);
}
internal void InitVars(bool initTable) {
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.relationCustomersOrders = this.Relations["CustomersOrders"];
this.relationOrdersOrder_x0020_Details = this.Relations["OrdersOrder_x0020_Details"];
}
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"];
}
internal void InitVars(bool initTable) {
this.tableCurrencies = ((CurrenciesDataTable)(base.Tables["Currencies"]));
if ((initTable == true)) {
if ((this.tableCurrencies != null)) {
this.tableCurrencies.InitVars();
}
}
this.tableItems = ((ItemsDataTable)(base.Tables["Items"]));
if ((initTable == true)) {
if ((this.tableItems != null)) {
this.tableItems.InitVars();
}
}
this.tableUnitMeasures = ((UnitMeasuresDataTable)(base.Tables["UnitMeasures"]));
if ((initTable == true)) {
if ((this.tableUnitMeasures != null)) {
this.tableUnitMeasures.InitVars();
}
}
this.tableWarehouses = ((WarehousesDataTable)(base.Tables["Warehouses"]));
if ((initTable == true)) {
if ((this.tableWarehouses != null)) {
this.tableWarehouses.InitVars();
}
}
this.tableCompanies = ((CompaniesDataTable)(base.Tables["Companies"]));
if ((initTable == true)) {
if ((this.tableCompanies != null)) {
this.tableCompanies.InitVars();
}
}
this.tableItemInventories = ((ItemInventoriesDataTable)(base.Tables["ItemInventories"]));
if ((initTable == true)) {
if ((this.tableItemInventories != null)) {
this.tableItemInventories.InitVars();
}
}
this.tableOrderDetails = ((OrderDetailsDataTable)(base.Tables["OrderDetails"]));
if ((initTable == true)) {
if ((this.tableOrderDetails != null)) {
this.tableOrderDetails.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableItemCategories = ((ItemCategoriesDataTable)(base.Tables["ItemCategories"]));
if ((initTable == true)) {
if ((this.tableItemCategories != null)) {
this.tableItemCategories.InitVars();
}
}
this.relationFK_Items_Categories = this.Relations["FK_Items_Categories"];
this.relationFK_Items_UnitMeasures = this.Relations["FK_Items_UnitMeasures"];
this.relationFK_ItemInventories_Items = this.Relations["FK_ItemInventories_Items"];
this.relationFK_ItemInventories_Warehouse = this.Relations["FK_ItemInventories_Warehouse"];
this.relationFK_OrderDetails_Items = this.Relations["FK_OrderDetails_Items"];
this.relationFK_OrderDetails_Orders = this.Relations["FK_OrderDetails_Orders"];
this.relationFK_Orders_Companies = this.Relations["FK_Orders_Companies"];
this.relationFK_Orders_Parent = this.Relations["FK_Orders_Parent"];
this.relationFK_Orders_Currencies = this.Relations["FK_Orders_Currencies"];
this.relationFK_Items_Companies = this.Relations["FK_Items_Companies"];
this.relationFK_OrderDetails_Reference = this.Relations["FK_OrderDetails_Reference"];
}
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 OrdersRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableOrders = ((OrdersDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.InitVars();
}
}
this.tableCustomerCustomerDemo = ((CustomerCustomerDemoDataTable)(base.Tables["CustomerCustomerDemo"]));
if ((initTable == true)) {
if ((this.tableCustomerCustomerDemo != null)) {
this.tableCustomerCustomerDemo.InitVars();
}
}
this.tableCustomerDemographics = ((CustomerDemographicsDataTable)(base.Tables["CustomerDemographics"]));
if ((initTable == true)) {
if ((this.tableCustomerDemographics != null)) {
this.tableCustomerDemographics.InitVars();
}
}
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.tableEmployeeTerritories = ((EmployeeTerritoriesDataTable)(base.Tables["EmployeeTerritories"]));
if ((initTable == true)) {
if ((this.tableEmployeeTerritories != null)) {
this.tableEmployeeTerritories.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.tableRegion = ((RegionDataTable)(base.Tables["Region"]));
if ((initTable == true)) {
if ((this.tableRegion != null)) {
this.tableRegion.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
if ((initTable == true)) {
if ((this.tableSuppliers != null)) {
this.tableSuppliers.InitVars();
}
}
this.tableTerritories = ((TerritoriesDataTable)(base.Tables["Territories"]));
if ((initTable == true)) {
if ((this.tableTerritories != null)) {
this.tableTerritories.InitVars();
}
}
this.relationFK_CustomerCustomerDemo = this.Relations["FK_CustomerCustomerDemo"];
this.relationFK_CustomerCustomerDemo_Customers = this.Relations["FK_CustomerCustomerDemo_Customers"];
this.relationFK_Employees_Employees = this.Relations["FK_Employees_Employees"];
this.relationFK_EmployeeTerritories_Employees = this.Relations["FK_EmployeeTerritories_Employees"];
this.relationFK_EmployeeTerritories_Territories = this.Relations["FK_EmployeeTerritories_Territories"];
this.relationFK_Order_Details_Orders = this.Relations["FK_Order_Details_Orders"];
this.relationFK_Order_Details_Products = this.Relations["FK_Order_Details_Products"];
this.relationFK_Orders_Customers = this.Relations["FK_Orders_Customers"];
this.relationFK_Orders_Employees = this.Relations["FK_Orders_Employees"];
this.relationFK_Orders_Shippers = this.Relations["FK_Orders_Shippers"];
this.relationFK_Products_Categories = this.Relations["FK_Products_Categories"];
this.relationFK_Products_Suppliers = this.Relations["FK_Products_Suppliers"];
this.relationFK_Territories_Region = this.Relations["FK_Territories_Region"];
}
internal OrdersRow(DataRowBuilder rb) :
base(rb)
{
this.tableOrders = ((OrdersDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "northwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/northwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCategories = new CategoriesDataTable();
base.Tables.Add(this.tableCategories);
this.tableCustomerCustomerDemo = new CustomerCustomerDemoDataTable();
base.Tables.Add(this.tableCustomerCustomerDemo);
this.tableCustomerDemographics = new CustomerDemographicsDataTable();
base.Tables.Add(this.tableCustomerDemographics);
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
this.tableEmployeeTerritories = new EmployeeTerritoriesDataTable();
base.Tables.Add(this.tableEmployeeTerritories);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.tableRegion = new RegionDataTable();
base.Tables.Add(this.tableRegion);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.tableTerritories = new TerritoriesDataTable();
base.Tables.Add(this.tableTerritories);
this.relationFK_CustomerCustomerDemo = new global::System.Data.DataRelation("FK_CustomerCustomerDemo", new global::System.Data.DataColumn[] {
this.tableCustomerDemographics.CustomerTypeIDColumn}, new global::System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerTypeIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo);
this.relationFK_CustomerCustomerDemo_Customers = new global::System.Data.DataRelation("FK_CustomerCustomerDemo_Customers", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo_Customers);
this.relationFK_Employees_Employees = new global::System.Data.DataRelation("FK_Employees_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployees.ReportsToColumn}, false);
this.Relations.Add(this.relationFK_Employees_Employees);
this.relationFK_EmployeeTerritories_Employees = new global::System.Data.DataRelation("FK_EmployeeTerritories_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployeeTerritories.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Employees);
this.relationFK_EmployeeTerritories_Territories = new global::System.Data.DataRelation("FK_EmployeeTerritories_Territories", new global::System.Data.DataColumn[] {
this.tableTerritories.TerritoryIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployeeTerritories.TerritoryIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Territories);
this.relationFK_Order_Details_Orders = new global::System.Data.DataRelation("FK_Order_Details_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Orders);
this.relationFK_Order_Details_Products = new global::System.Data.DataRelation("FK_Order_Details_Products", new global::System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Products);
this.relationFK_Orders_Customers = new global::System.Data.DataRelation("FK_Orders_Customers", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Customers);
this.relationFK_Orders_Employees = new global::System.Data.DataRelation("FK_Orders_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Employees);
this.relationFK_Orders_Shippers = new global::System.Data.DataRelation("FK_Orders_Shippers", new global::System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationFK_Orders_Shippers);
this.relationFK_Products_Categories = new global::System.Data.DataRelation("FK_Products_Categories", new global::System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new global::System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Categories);
this.relationFK_Products_Suppliers = new global::System.Data.DataRelation("FK_Products_Suppliers", new global::System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Suppliers);
this.relationFK_Territories_Region = new global::System.Data.DataRelation("FK_Territories_Region", new global::System.Data.DataColumn[] {
this.tableRegion.RegionIDColumn}, new global::System.Data.DataColumn[] {
this.tableTerritories.RegionIDColumn}, false);
this.Relations.Add(this.relationFK_Territories_Region);
}
private void InitClass()
{
this.DataSetName = "myTypedDataSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/myTypedDataSet.xsd";
this.Locale = new CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableOrder_Details = new Order_DetailsDataTable();
this.Tables.Add(this.tableOrder_Details);
this.tableOrders = new OrdersDataTable();
this.Tables.Add(this.tableOrders);
ForeignKeyConstraint fkc;
fkc = new ForeignKeyConstraint("OrdersOrder_x0020_Details", new DataColumn[] {
this.tableOrders.OrderIDColumn}, new DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = AcceptRejectRule.None;
fkc.DeleteRule = Rule.Cascade;
fkc.UpdateRule = Rule.Cascade;
this.relationOrdersOrder_x0020_Details = new DataRelation("OrdersOrder_x0020_Details", new DataColumn[] {
this.tableOrders.OrderIDColumn}, new DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_x0020_Details);
}
internal void InitVars() {
this.tableCustomers = ((CustomersDataTable)(this.Tables["Customers"]));
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
this.tableOrders = ((OrdersDataTable)(this.Tables["Orders"]));
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
this.relationCustomersOrders = this.Relations["CustomersOrders"];
}
