public ReceiptMasterNewAll(MDataSet source) { InitializeComponent(); _table = source.ReceiptMaster; mDataSet = source; this.receiptMasterBindingSource.DataSource = new DataView(_table, "DocumentTypeRef = 0", null, DataViewRowState.CurrentRows); this.productBindingSource.DataSource = source.Product; this.productBindingSource.ResetBindings(true); }
public bool RefreshData(MDataSet.InvoiceMasterRow sourceRow) { if (sourceRow == null) return false; MDataSet.InvoiceMasterDataTable _invoiceMasterDataTable=new MDataSet.InvoiceMasterDataTable(); MDataSet.InvoiceDetailDataTable _invoiceDetailDataTable = new MDataSet.InvoiceDetailDataTable(); MDataSet.RemainsDataTable _remainsDataTable = new MDataSet.RemainsDataTable(); try { this.RemainsTableAdapter.FillByInvoiceMasterID(_remainsDataTable, sourceRow.ID); this.invoiceMasterTableAdapter.FillNew(_invoiceMasterDataTable); this.invoiceDetailTableAdapter.FillByInvoiceMasterRef(_invoiceDetailDataTable,sourceRow.ID); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.InvoiceMasterRow sourceRow) " + err.Message + " " + err.Source); return false; } finally { this.mDataSet.Remains.Merge(_remainsDataTable); this.mDataSet.InvoiceMaster.Merge(_invoiceMasterDataTable); this.mDataSet.InvoiceDetail.Merge(_invoiceDetailDataTable); } return true; }
/*FillNew + Merge + FillDetailsById*/ public bool RefreshData(MDataSet.ReceiptMasterRow sourceRow) { MDataSet.ReceiptMasterDataTable _ReceiptMasterDataTable = new MDataSet.ReceiptMasterDataTable(); MDataSet.ReceiptDetailDataTable _ReceiptDetailDataTable = new MDataSet.ReceiptDetailDataTable(); MDataSet.ProductDataTable _productDataTable = new MDataSet.ProductDataTable(); try { this.receiptMasterTableAdapter.FillNew(_ReceiptMasterDataTable); this.receiptDetailTableAdapter.FillByReceiptMasterRef(_ReceiptDetailDataTable, sourceRow.ID); foreach (MDataSet.ReceiptDetailRow detrow in _ReceiptDetailDataTable) { if (detrow.ProductRow == null) { this.productTableAdapter.FillById(_productDataTable,detrow.ProductRef); } this.mDataSet.Product.Merge(_productDataTable); } } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.ReceiptMasterRow sourceRow) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { this.mDataSet.ReceiptMaster.Merge(_ReceiptMasterDataTable); this.mDataSet.ReceiptDetail.Merge(_ReceiptDetailDataTable); this.mDataSet.ReceiptMaster.AcceptChanges(); this.mDataSet.ReceiptDetail.AcceptChanges(); } return true; }
public bool FillTableStockDocuments(MDataSet.InvoiceMasterDataTable source, int numPeriods) { MDataSet.InvoiceMasterDataTable _tmpMaster = new MDataSet.InvoiceMasterDataTable(); MDataSet.InvoiceDetailDataTable _tmpDetail = new MDataSet.InvoiceDetailDataTable(); MDataSet.RemainsDataTable _rem = new MDataSet.RemainsDataTable(); MDataSet.ProductDataTable _prod = new MDataSet.ProductDataTable(); try { this.invoiceMasterTableAdapter.FillByPeriodNum(_tmpMaster, numPeriods); this.mDataSet.InvoiceMaster.Merge(_tmpMaster); foreach (MDataSet.InvoiceMasterRow mr in _tmpMaster) { this.invoiceDetailTableAdapter.FillByInvoiceMasterRef(_tmpDetail, mr.ID); this.RemainsTableAdapter.FillByInvoiceMasterID(_rem, mr.ID); foreach (MDataSet.RemainsRow _remrow in _rem) { if (_remrow.ProductRow == null) { this.productTableAdapter.FillById(_prod, _remrow.ProductRef); this.mDataSet.Product.Merge(_prod); } } this.mDataSet.Remains.Merge(_rem); this.mDataSet.InvoiceDetail.Merge(_tmpDetail); } } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else caughtGlobalError(sqlerr); Log("FillTableStockDocuments(MDataSet.InvoiceMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("FillTableStockDocuments(MDataSet.InvoiceMasterDataTable source) ERROR" + err.Message + " " + err.Source ); return false; } finally { } return true; }
public bool FillTableStockDocuments(MDataSet.InvoiceMasterDataTable source, DateTime begin) { MDataSet.InvoiceMasterDataTable _tmpMaster = new MDataSet.InvoiceMasterDataTable(); MDataSet.InvoiceDetailDataTable _tmpDetail = new MDataSet.InvoiceDetailDataTable(); try { this.invoiceMasterTableAdapter.FillByPeriod(_tmpMaster, begin); this.invoiceDetailTableAdapter.FillByPeriod(_tmpDetail, begin); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else caughtGlobalError(sqlerr); Log("FillTableStockDocuments(MDataSet.InvoiceMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("FillTableStockDocuments(MDataSet.InvoiceMasterDataTable source) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { this.mDataSet.InvoiceMaster.Merge(_tmpMaster); this.mDataSet.InvoiceDetail.Merge(_tmpDetail); } return true; }
/*MDataset, документы на складе по номеру периода, подгрузка построчно нужна*/ public bool FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source, int numPeriods) { MDataSet.ReceiptMasterDataTable _tmpMaster = new MDataSet.ReceiptMasterDataTable(); // MDataSet.ReceiptDetailDataTable _tmpDetail = new MDataSet.ReceiptDetailDataTable(); try { this.receiptMasterTableAdapter.FillByPeriodNum(_tmpMaster, numPeriods); // this.receiptDetailTableAdapter.FillByPeriodNum(_tmpDetail, numPeriods); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else caughtGlobalError(sqlerr); Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + err.Message + " " + err.Source +err.InnerException.Message); return false; } finally { this.mDataSet.ReceiptMaster.Merge(_tmpMaster); // this.mDataSet.ReceiptDetail.Merge(_tmpDetail); } return true; }
public bool RefreshData(MDataSet.RemainsDataTable table) { try { this.RemainsTableAdapter.Fill(table); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.RemainsDataTable table) " + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { } return true; }
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs) { MDataSet ds = new MDataSet(); System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType(); System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence(); xs.Add(ds.GetSchemaSerializable()); System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; return type; }
public bool SaveToBase(MDataSet.InvoiceDetailRow sourceRow) { if (sourceRow.HasErrors) return false; if ((sourceRow.RowState == DataRowState.Detached)|(sourceRow.RowState==DataRowState.Unchanged)) return true; if (_changesInvoiceDetail.Count == 0) return true; MDataSet.InvoiceMasterRow _invoiceMasterRow; _invoiceMasterRow = sourceRow.InvoiceMasterRow; /*если после Update полей на сервере*/ if ((sourceRow.RowState == DataRowState.Modified)&sourceRow.HasVersion(DataRowVersion.Current)) { if (Convert.ToInt32(sourceRow["ID", DataRowVersion.Original]) != Convert.ToInt32(sourceRow["ID", DataRowVersion.Current])) return true; } //*Если удаление *// if (sourceRow.RowState==DataRowState.Deleted) _invoiceMasterRow = this.mDataSet.InvoiceMaster.FindByID(Convert.ToInt32((sourceRow as MDataSet.InvoiceDetailRow)["InvoiceMasterRef", DataRowVersion.Original])); try { int res = this.invoiceDetailTableAdapter.Update(sourceRow); this.LabelUser.Text = "Успешно обновлена строка"; } catch (DBConcurrencyException dbcx) { this.onInvoiceDetailDBCError(dbcx); this.LabelUser.Text = "Ошибка совмесного доступа"; return false; } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { OnInvoiceDetailSQLError(sqlerr,sourceRow); } else caughtGlobalError(sqlerr); Log("SaveToBase(MDataSet.InvoiceDetailRow sourceRow) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("SaveToBase(MDataSet.InvoiceDetailRow sourceRow) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { this.RemainsTableAdapter.Fill(this.mDataSet.Remains); RefreshData(_invoiceMasterRow); } return true; }
public bool SaveToBase(MDataSet.InvoiceMasterRow sourceRow) { MDataSet.RemainsDataTable _rem = new MDataSet.RemainsDataTable(); try { int res = this.invoiceMasterTableAdapter.Update(sourceRow); int res1 = this.invoiceDetailTableAdapter.Update(this.mDataSet.InvoiceDetail); if (sourceRow.HasVersion(DataRowVersion.Current)) { this.RemainsTableAdapter.FillByInvoiceMasterID(_rem, sourceRow.ID); this.mDataSet.Remains.Merge(_rem); } } catch (DBConcurrencyException dbcx) { this.onInvoiceMasterDBCError(dbcx); return false; } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { OnInvoiceMasterSQLError(sqlerr,sourceRow); } else caughtGlobalError(sqlerr); Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + err.Message + " " + err.Source ); return false; } finally { RefreshData(sourceRow.Table as MDataSet.InvoiceMasterDataTable); } return true; }
public bool MakeToReturn(MDataSet.InvoiceMasterRow sourceRow) { int res; try { this.SaveToBase(sourceRow); res = this.invoiceMasterTableAdapter.InvoiceMasterMakeToReturn(sourceRow.ID); } catch (DBConcurrencyException dbcx) { this.onInvoiceMasterDBCError(dbcx); return false; } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { OnInvoiceMasterSQLError(sqlerr, sourceRow); } else caughtGlobalError(sqlerr); Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { RefreshData(sourceRow as MDataSet.InvoiceMasterRow); } return true; }
private void OnInvoiceMasterSQLError(SqlException sqlerr, MDataSet.InvoiceMasterRow sourceRow) { MessageBox.Show(sqlerr.Message); }
private bool OnInvoiceDetailSQLError(SqlException sqlerr,MDataSet.InvoiceDetailRow row) { decimal _oldQnt = row.Quantity; RefreshData(row.RemainsRow); // если нулевой остаток if (row.RemainsRow.QuantityRemains == 0) { MessageBox.Show("Уже нет товара на складе!"); row.RejectChanges(); return true; } else { // уменьшить до кол-ва остатка и снова сохранить try { row.ClearErrors(); row.Quantity = row.RemainsRow.QuantityRemains; } catch(Exception ex) { MessageBox.Show(ex.Message); row.RejectChanges(); return false; } finally { decimal ed = _oldQnt - row.Quantity; MessageBox.Show("Не удалось выписать: "+ed.ToString()); } return true; } }
private void OnReceiptMasterSQLError(SqlException sqlerr, MDataSet.ReceiptMasterRow sourceRow) { MessageBox.Show(sqlerr.Message, "SqlException"); }
public bool RefreshData(MDataSet.ProductDataTable dataTable, int id) { MDataSet.ProductDataTable _ProductDataTable = new MDataSet.ProductDataTable(); try { this.productTableAdapter.FillById(_ProductDataTable,id); } catch (Exception err) { MessageBox.Show(err.Message); Log("(RefreshData(MDataSet.ProductDataTable dataTable, int id)" + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { this.mDataSet.Product.Merge(_ProductDataTable); } return true; }
public bool RefreshData(MDataSet.InvoiceDetailRow sourceRow) { MDataSet.InvoiceDetailDataTable _invoiceDetailDataTable = new MDataSet.InvoiceDetailDataTable(); try { this.invoiceDetailTableAdapter.FillNew(_invoiceDetailDataTable); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData (MDataSet.InvoiceDetailRow sourceRow) " + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { this.mDataSet.InvoiceDetail.Merge(_invoiceDetailDataTable, true); } return true; }
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) { System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType(); System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence(); MDataSet ds = new MDataSet(); xs.Add(ds.GetSchemaSerializable()); System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "inventoryDetailsDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; return type; }
/*FullDataset*/ /*MDataset, новые приходные документы */ public bool FillTableNewDocuments(MDataSet.ReceiptMasterDataTable source) { /*MDataSet.ReceiptMasterDataTable _tmpMaster = new MDataSet.ReceiptMasterDataTable(); MDataSet.ReceiptDetailDataTable _tmpDetail = new MDataSet.ReceiptDetailDataTable(); */ try { this.receiptMasterTableAdapter.Fill(this.mDataSet.ReceiptMaster); this.receiptDetailTableAdapter.Fill(this.mDataSet.ReceiptDetail); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else caughtGlobalError(sqlerr); Log("FillTableNewDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("FillTableNewDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + err.Message); } finally { /*this.mDataSet.ReceiptMaster.Merge(_tmpMaster); this.mDataSet.ReceiptDetail.Merge(_tmpDetail); */ } return true; /* DataColumn[] _ercol = _tmpDetail.GetErrors()[0].GetColumnsInError(); if (_ercol.Length >= 0) return false; else return true;*/ }
public bool FillTableNewDocuments(MDataSet.InvoiceMasterDataTable source) { MDataSet.InvoiceMasterDataTable _tmpMaster = new MDataSet.InvoiceMasterDataTable(); MDataSet.InvoiceDetailDataTable _tmpDetail = new MDataSet.InvoiceDetailDataTable(); MDataSet.RemainsDataTable _tmpRemains = new MDataSet.RemainsDataTable(); try { this.RemainsTableAdapter.Fill(_tmpRemains); this.invoiceMasterTableAdapter.Fill(_tmpMaster); this.invoiceDetailTableAdapter.Fill(_tmpDetail); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { MessageBox.Show(sqlerr.Message); } else caughtGlobalError(sqlerr); Log("FillTableNewDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return false; } catch (Exception err) { MessageBox.Show(err.Message); Log("FillTableNewDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + err.Message + " " + err.Source ); return false; } finally { this.mDataSet.Remains.Merge(_tmpRemains); this.mDataSet.InvoiceMaster.Merge(_tmpMaster); this.mDataSet.InvoiceDetail.Merge(_tmpDetail); } return true; }
//При удалении вызвать public bool RefreshData(MDataSet.RemainsRow sourceRow) { MDataSet.RemainsDataTable _RemainsDataTable = new MDataSet.RemainsDataTable(); try { this.RemainsTableAdapter.FillByReceiptDetailRef(_RemainsDataTable, sourceRow.ReceiptDetailRef); } catch (Exception err) { MessageBox.Show(err.Message); Log("(MDataSet.RemainsRow sourceRow) " + err.Message + " " + err.Source + err.InnerException.Message); return false; } finally { this.mDataSet.Remains.Merge(_RemainsDataTable); } return true; }