public sellReport()
{
InitializeComponent();
this.alert = new Alert();
comboBox2.DisplayMember = "Text";
comboBox2.ValueMember = "Value";
this.sdt = new StockDataTable();
dateTimePicker1.Hide();
sData = new SellReportData();
getData();
}
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();
}
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;
}
internal StockRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableStock = ((StockDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "MDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/MDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.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 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();
}
}
}
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"];
}