public InvoiceDetailEdit(MDataSet.InvoiceMasterRow source, MDataSet.ProductDataTable product, MainForm mainForm)
{
InitializeComponent();
_mainForm = mainForm;
this.mDataSet = source.Table.DataSet as MDataSet;
this.productBindingSource.DataSource = product;
this.productBindingSource.ResetBindings(false);
// this.RemainsBindingSource.DataSource = new DataView(this.mDataSet.Remains, "MainStockRef=" + source.MainStockRef.ToString(), null, DataViewRowState.CurrentRows);
this.RemainsBindingSource.DataSource = new DataView(this.mDataSet.Remains, "Quantityremains<>0 and MainStockRef=" + source.MainStockRef.ToString(), "ProductName", DataViewRowState.CurrentRows);
this.RemainsBindingSource.ResetBindings(true);
this.invoiceMasterBindingSource.DataSource = source;
this.invoiceMasterBindingSource.ResetBindings(true);
this.invoiceMasterBindingSourceView.DataSource = source.Table;
this.invoiceMasterBindingSourceView.ResetBindings(true);
this.invoiceMasterBindingSourceView.CurrencyManager.Position = this.invoiceMasterBindingSourceView.Find("ID", source.ID);
this.invoiceDetailBindingSource.DataSource = this.invoiceMasterBindingSourceView;
this.invoiceDetailBindingSource.DataMember = "FK_InvoiceDetail_InvoiceMaster";
this.invoiceDetailBindingSource.ResetBindings(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);
}
private void btProdAll_Click(object sender, EventArgs e)
{
MDataSet.ProductDataTable _prodTmp = new MDataSet.ProductDataTable();
this.productTableAdapter.FillAll(_prodTmp);
this.mDataSet.Product.Merge(_prodTmp);
this.productBindingSource.ResetBindings(false);
}
private void btRefreshData_Click(object sender, EventArgs e)
{
int res;
try
{
res = this.ordersTableAdapter.Update(this.mDataSet.Orders);
MessageBox.Show("Сохранено: " + res.ToString());
}
catch (DBConcurrencyException dbcx)
{
MessageBox.Show("Не удалось сохранить 1 строку!");
dbcx.Row.RejectChanges();
this.ordersTableAdapter.Update(this.mDataSet.Orders);
}
catch (Exception err)
{
MessageBox.Show("Не удалось сохранить данные!");
MessageBox.Show(err.Message);
return;
}
this.ordersBindingSource.ResetBindings(false);
try {
MDataSet.ProductDataTable _prodTmp = new MDataSet.ProductDataTable();
this.ordersTableAdapter.OrdersAuto();
this.productTableAdapter.FillOrders(_prodTmp);
this.mDataSet.Product.Merge(_prodTmp);
if (this.dateTimeEdit.Value.Date == DateTime.Today.Date)
{
this.ordersTableAdapter.Fill(this.mDataSet.Orders);
}
else
{
this.ordersTableAdapter.FillByStartPeriod(this.mDataSet.Orders, this.dateTimeEdit.Value.Date);
}
this.ordersBindingSource.ResetBindings(false);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log("btRefreshData_Click" + err.Message);
}
}
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);
}
/*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 virtual MDataSet.ProductDataTable GetDataOrders() {
this.Adapter.SelectCommand = this.CommandCollection[4];
MDataSet.ProductDataTable dataTable = new MDataSet.ProductDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual MDataSet.ProductDataTable GetDataById(System.Nullable<int> ProductRef) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((ProductRef.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ProductRef.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
MDataSet.ProductDataTable dataTable = new MDataSet.ProductDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
/*MDataset, документы на складе, из открытого периода, новые, X дней*/
public bool FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source, DateTime begin)
{
MDataSet.ReceiptMasterDataTable _tmpMaster = new MDataSet.ReceiptMasterDataTable();
MDataSet.ReceiptDetailDataTable _tmpDetail = new MDataSet.ReceiptDetailDataTable();
MDataSet.ProductDataTable _prod = new MDataSet.ProductDataTable();
try
{
this.receiptMasterTableAdapter.FillByPeriod(_tmpMaster, begin);
/* foreach(DataRow masRow in _tmpMaster )
* {
*
* MDataSet.ManufacturerDataTable _man = new MDataSet.ManufacturerDataTable();
*
*
* this.manufacturerTableAdapter.FillByReceiptMasterRef(_man, (masRow as MDataSet.ReceiptMasterRow).ID);
*
*
*
* this.productTableAdapter.FillByReceiptId(_prod, (masRow as MDataSet.ReceiptMasterRow).ID);
*
* // this.manufacturerTableAdapter.FillByReceiptMasterRef(_man , (masRow as MDataSet.ReceiptMasterRow).ID);
*
*
* this.mDataSet.Product.Merge(_prod);
* this.mDataSet.Manufacturer.Merge(_man);
*
* }
*
*
* this.receiptDetailTableAdapter.FillByPeriod(_tmpDetail, begin);
* this.mDataSet.ReceiptDetail.Merge(_tmpDetail);*/
this.mDataSet.ReceiptMaster.Merge(_tmpMaster);
}
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)
{
DataRow[] dr = this.mDataSet.Manufacturer.GetErrors();
DataColumn[] dc = dr[0].GetColumnsInError();
MessageBox.Show(err.Message);
Log("FillTableStockDocuments(MDataSet.ReceiptMasterDataTable source) ERROR" + err.Message + " " + err.Source);
return(false);
}
finally
{
}
return(true);
}
private void btRefreshData_Click(object sender, EventArgs e)
{
int res;
try
{
res = this.ordersTableAdapter.Update(this.mDataSet.Orders);
MessageBox.Show("Сохранено: " + res.ToString());
}
catch (DBConcurrencyException dbcx)
{
MessageBox.Show("Не удалось сохранить 1 строку!");
dbcx.Row.RejectChanges();
this.ordersTableAdapter.Update(this.mDataSet.Orders);
}
catch (Exception err)
{
MessageBox.Show("Не удалось сохранить данные!");
MessageBox.Show(err.Message);
return;
}
this.ordersBindingSource.ResetBindings(false);
try {
MDataSet.ProductDataTable _prodTmp = new MDataSet.ProductDataTable();
this.ordersTableAdapter.OrdersAuto();
this.productTableAdapter.FillOrders(_prodTmp);
this.mDataSet.Product.Merge(_prodTmp);
if (this.dateTimeEdit.Value.Date == DateTime.Today.Date)
{
this.ordersTableAdapter.Fill(this.mDataSet.Orders);
}
else
{
this.ordersTableAdapter.FillByStartPeriod(this.mDataSet.Orders, this.dateTimeEdit.Value.Date);
}
this.ordersBindingSource.ResetBindings(false);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log("btRefreshData_Click" + err.Message);
}
}
private void btProdAll_Click(object sender, EventArgs e)
{
MDataSet.ProductDataTable _prodTmp = new MDataSet.ProductDataTable();
this.productTableAdapter.FillAll(_prodTmp);
this.mDataSet.Product.Merge(_prodTmp);
this.productBindingSource.ResetBindings(false);
}
