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); }
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 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.invoiceDetailTableAdapter.Update(this.mDataSet.InvoiceDetail); this.RemainsTableAdapter.FillByInvoiceMasterID(_remainsDataTable, sourceRow.ID); this.invoiceMasterTableAdapter.FillNew(_invoiceMasterDataTable); this.invoiceDetailTableAdapter.FillNew(_invoiceDetailDataTable); } catch (DBConcurrencyException dbcx) { this.onInvoiceDetailDBCError(dbcx); this.LabelUser.Text = "Ошибка совмесного доступа"; MainForm.Log(dbcx.Message); RefreshData(sourceRow); return(false); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.InvoiceMasterRow sourceRow) " + err.Message + " " + err.Source); return(false); } finally { MergeRemains(_remainsDataTable); this.mDataSet.InvoiceMaster.Merge(_invoiceMasterDataTable); this.mDataSet.InvoiceDetail.Merge(_invoiceDetailDataTable); } 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 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); }
public bool RefreshData(MDataSet.InvoiceMasterRow sourceRow, bool isMerge) { MDataSet.InvoiceMasterDataTable _invoiceMasterDataTable = new MDataSet.InvoiceMasterDataTable(); try { this.invoiceMasterTableAdapter.FillNew(_invoiceMasterDataTable); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.InvoiceMasterRow sourceRow) " + err.Message + " " + err.Source + err.InnerException.Message); return(false); } finally { this.mDataSet.InvoiceMaster.Merge(_invoiceMasterDataTable); } return(true); }
private bool onInvoiceMasterDBCError(DBConcurrencyException dbcx) { try { MDataSet.InvoiceMasterDataTable _tmpTable = new MDataSet.InvoiceMasterDataTable(); this.invoiceMasterTableAdapter.FillByPeriodNum(_tmpTable, 0); this.mDataSet.InvoiceMaster.Merge(_tmpTable, true); this.invoiceMasterTableAdapter.Update(this.mDataSet.InvoiceMaster); } catch (Exception err) { MainForm.Log("onInvoiceMasterDBCError" + err.Message); return(false); } return(true); }
public virtual MDataSet.InvoiceMasterDataTable GetDataNew() { this.Adapter.SelectCommand = this.CommandCollection[3]; MDataSet.InvoiceMasterDataTable dataTable = new MDataSet.InvoiceMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual MDataSet.InvoiceMasterDataTable GetDataByPeriodNum(System.Nullable<int> num) { this.Adapter.SelectCommand = this.CommandCollection[2]; if ((num.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(num.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } MDataSet.InvoiceMasterDataTable dataTable = new MDataSet.InvoiceMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual MDataSet.InvoiceMasterDataTable GetDataByPeriod(System.Nullable<System.DateTime> Begin) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((Begin.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(Begin.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } MDataSet.InvoiceMasterDataTable dataTable = new MDataSet.InvoiceMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }