Example #1
0
 public sellReport()
 {
     InitializeComponent();
     this.alert = new Alert();
     comboBox2.DisplayMember = "Text";
     comboBox2.ValueMember   = "Value";
     this.sdt = new StockDataTable();
     dateTimePicker1.Hide();
     sData = new SellReportData();
     getData();
 }
Example #2
0
        public transectionReport()
        {
            InitializeComponent();

            this.alert = new Alert();
            sData      = new TransectionReportData();
            this.ds    = new DataSet();
            comboBox2.DisplayMember = "Text";
            comboBox2.ValueMember   = "Value";
            dateTimePicker1.Hide();
            button1.Hide();
            this.sdt = new StockDataTable();
            getData();
        }
Example #3
0
        private void refresh_Click(object sender, EventArgs e)
        {
            this.sData     = new TransectionReportData();
            this.sdt       = new StockDataTable();
            Cursor.Current = Cursors.WaitCursor;
            if (this.sData.listMaker("select * from transection"))
            {
                if (!addData(this.sData.Datatables))
                {
                    Cursor.Current = Cursors.Default;
                    alert.Show(this.alert.Warning, "No Data Found........ ");
                }
            }
            else
            {
                Cursor.Current = Cursors.Default;
                MessageBox.Show("check your internet connection");
            }

            Cursor.Current = Cursors.Default;
        }
Example #4
0
 internal StockRow(System.Data.DataRowBuilder rb) : 
         base(rb) {
     this.tableStock = ((StockDataTable)(this.Table));
 }
Example #5
0
 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);
 }
Example #6
0
 internal void InitVars(bool initTable) {
     this.tableCash = ((CashDataTable)(base.Tables["Cash"]));
     if ((initTable == true)) {
         if ((this.tableCash != null)) {
             this.tableCash.InitVars();
         }
     }
     this.tableDocumentType = ((DocumentTypeDataTable)(base.Tables["DocumentType"]));
     if ((initTable == true)) {
         if ((this.tableDocumentType != null)) {
             this.tableDocumentType.InitVars();
         }
     }
     this.tableInvoiceMaster = ((InvoiceMasterDataTable)(base.Tables["InvoiceMaster"]));
     if ((initTable == true)) {
         if ((this.tableInvoiceMaster != null)) {
             this.tableInvoiceMaster.InitVars();
         }
     }
     this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"]));
     if ((initTable == true)) {
         if ((this.tableInvoiceDetail != null)) {
             this.tableInvoiceDetail.InitVars();
         }
     }
     this.tablePeriods = ((PeriodsDataTable)(base.Tables["Periods"]));
     if ((initTable == true)) {
         if ((this.tablePeriods != null)) {
             this.tablePeriods.InitVars();
         }
     }
     this.tableReceiptDetail = ((ReceiptDetailDataTable)(base.Tables["ReceiptDetail"]));
     if ((initTable == true)) {
         if ((this.tableReceiptDetail != null)) {
             this.tableReceiptDetail.InitVars();
         }
     }
     this.tableReceiptMaster = ((ReceiptMasterDataTable)(base.Tables["ReceiptMaster"]));
     if ((initTable == true)) {
         if ((this.tableReceiptMaster != null)) {
             this.tableReceiptMaster.InitVars();
         }
     }
     this.tableReceiptRemains = ((ReceiptRemainsDataTable)(base.Tables["ReceiptRemains"]));
     if ((initTable == true)) {
         if ((this.tableReceiptRemains != null)) {
             this.tableReceiptRemains.InitVars();
         }
     }
     this.tableProduct = ((ProductDataTable)(base.Tables["Product"]));
     if ((initTable == true)) {
         if ((this.tableProduct != null)) {
             this.tableProduct.InitVars();
         }
     }
     this.tableRemains = ((RemainsDataTable)(base.Tables["Remains"]));
     if ((initTable == true)) {
         if ((this.tableRemains != null)) {
             this.tableRemains.InitVars();
         }
     }
     this.tableStock = ((StockDataTable)(base.Tables["Stock"]));
     if ((initTable == true)) {
         if ((this.tableStock != null)) {
             this.tableStock.InitVars();
         }
     }
     this.tableLocalSetting = ((LocalSettingDataTable)(base.Tables["LocalSetting"]));
     if ((initTable == true)) {
         if ((this.tableLocalSetting != null)) {
             this.tableLocalSetting.InitVars();
         }
     }
     this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
     if ((initTable == true)) {
         if ((this.tableOrders != null)) {
             this.tableOrders.InitVars();
         }
     }
     this.tableinventoryMaster = ((inventoryMasterDataTable)(base.Tables["inventoryMaster"]));
     if ((initTable == true)) {
         if ((this.tableinventoryMaster != null)) {
             this.tableinventoryMaster.InitVars();
         }
     }
     this.tableinventoryDetails = ((inventoryDetailsDataTable)(base.Tables["inventoryDetails"]));
     if ((initTable == true)) {
         if ((this.tableinventoryDetails != null)) {
             this.tableinventoryDetails.InitVars();
         }
     }
     this.relationFK_InvoiceDetail_InvoiceMaster = this.Relations["FK_InvoiceDetail_InvoiceMaster"];
     this.relationRemains_InvoiceDetail = this.Relations["Remains_InvoiceDetail"];
     this.relationFK_inventoryMaster_inventoryDetails = this.Relations["FK_inventoryMaster_inventoryDetails"];
     this.relationFK_ReceiptDetail_ReceiptMaster = this.Relations["FK_ReceiptDetail_ReceiptMaster"];
     this.relationFK_ReceiptMaster_DocumentType = this.Relations["FK_ReceiptMaster_DocumentType"];
     this.relationFK_InvoiceDetail_ReceiptRemains = this.Relations["FK_InvoiceDetail_ReceiptRemains"];
     this.relationFK_ReceiptMaster_Stock = this.Relations["FK_ReceiptMaster_Stock"];
     this.relationFK_ReceiptMaster_Stock1 = this.Relations["FK_ReceiptMaster_Stock1"];
     this.relationReceiptDetail_Remains = this.Relations["ReceiptDetail_Remains"];
     this.relationProduct_ReceiptDetail = this.Relations["Product_ReceiptDetail"];
     this.relationInvoiceDetail_Product = this.Relations["InvoiceDetail_Product"];
     this.relationProduct_Orders = this.Relations["Product_Orders"];
     this.relationProduct_Remains = this.Relations["Product_Remains"];
 }
 private void InitClass() {
     this.DataSetName = "datasetRetailStore";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/datasetRetailStore.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableWarehouse = new WarehouseDataTable();
     base.Tables.Add(this.tableWarehouse);
     this.tableStock = new StockDataTable();
     base.Tables.Add(this.tableStock);
     this.tableVendor = new VendorDataTable();
     base.Tables.Add(this.tableVendor);
     this.tablePurchase = new PurchaseDataTable();
     base.Tables.Add(this.tablePurchase);
     this.tableProduct = new ProductDataTable();
     base.Tables.Add(this.tableProduct);
     this.tableCustomer = new CustomerDataTable();
     base.Tables.Add(this.tableCustomer);
     this.tableSales = new SalesDataTable();
     base.Tables.Add(this.tableSales);
     this.tablePurchase_Reciept = new Purchase_RecieptDataTable();
     base.Tables.Add(this.tablePurchase_Reciept);
 }
 internal void InitVars(bool initTable) {
     this.tableWarehouse = ((WarehouseDataTable)(base.Tables["Warehouse"]));
     if ((initTable == true)) {
         if ((this.tableWarehouse != null)) {
             this.tableWarehouse.InitVars();
         }
     }
     this.tableStock = ((StockDataTable)(base.Tables["Stock"]));
     if ((initTable == true)) {
         if ((this.tableStock != null)) {
             this.tableStock.InitVars();
         }
     }
     this.tableVendor = ((VendorDataTable)(base.Tables["Vendor"]));
     if ((initTable == true)) {
         if ((this.tableVendor != null)) {
             this.tableVendor.InitVars();
         }
     }
     this.tablePurchase = ((PurchaseDataTable)(base.Tables["Purchase"]));
     if ((initTable == true)) {
         if ((this.tablePurchase != null)) {
             this.tablePurchase.InitVars();
         }
     }
     this.tableProduct = ((ProductDataTable)(base.Tables["Product"]));
     if ((initTable == true)) {
         if ((this.tableProduct != null)) {
             this.tableProduct.InitVars();
         }
     }
     this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
     if ((initTable == true)) {
         if ((this.tableCustomer != null)) {
             this.tableCustomer.InitVars();
         }
     }
     this.tableSales = ((SalesDataTable)(base.Tables["Sales"]));
     if ((initTable == true)) {
         if ((this.tableSales != null)) {
             this.tableSales.InitVars();
         }
     }
     this.tablePurchase_Reciept = ((Purchase_RecieptDataTable)(base.Tables["Purchase Reciept"]));
     if ((initTable == true)) {
         if ((this.tablePurchase_Reciept != null)) {
             this.tablePurchase_Reciept.InitVars();
         }
     }
 }
Example #9
0
 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);
 }
Example #10
0
 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"];
 }