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;
}
