private void btProductReport_Click(object sender, EventArgs e)
{
MDataSet.OrdersRow _ordsRow = this.gridViewOrdersAll.GetDataRow(this.gridViewOrdersAll.FocusedRowHandle) as MDataSet.OrdersRow;
if (_ordsRow != null)
{
(this.ParentForm as MainForm).ProductReport(_ordsRow.ProductRef);
}
}
private void btAddOrders_Click(object sender, EventArgs e)
{
int Ref;
this.ordersBindingSource.EndEdit();
MDataSet.OrdersRow ordrow = (this.ordersBindingSource.Current as DataRowView).Row as MDataSet.OrdersRow;
if (ordrow != null)
{
Ref = ordrow.TradePupletRef;
}
else
{
Ref = 1;
}
this.btSave_Click(sender, e);
this.grid.EmbeddedNavigator.Buttons.Append.DoClick();
MDataSet.OrdersRow row = (this.ordersBindingSource.Current as DataRowView).Row as MDataSet.OrdersRow;
row.TradePupletRef = Ref;
row.Reserved = 0;
FormDialog formDialog = new FormDialog();
formDialog.Text = "Добавить новый заказ ";
formDialog.AcceptButton = null;
OrderAdd orderAdd = new OrderAdd(row, this.ParentForm as MainForm);
formDialog.panel.Controls.Add(orderAdd);
if (formDialog.ShowDialog(this) == DialogResult.OK)
{
this.grid.EmbeddedNavigator.Buttons.EndEdit.DoClick();
this.ordersBindingSource.EndEdit();
this.btSave_Click(sender, e);
}
else
{
this.ordersBindingSource.CancelEdit();
this.mDataSet.Orders.RejectChanges();
}
this.grid.Refresh();
}
private void gridViewOrders_DoubleClick(object sender, EventArgs e)
{
try
{
MDataSet.OrdersRow _ordsRow = this.gridViewOrders.GetDataRow(this.gridViewOrders.FocusedRowHandle) as MDataSet.OrdersRow;
if (_ordsRow == null)
{
return;
}
if (_ordsRow.Reserved > 0)
{
MessageBox.Show("Этот товар уже для вас зарезервирован: " + _ordsRow.Reserved.ToString());
return;
}
if (_ordsRow.QuantityNow > 0)
{
MessageBox.Show("Этот товар вам уже отгружен! ");
return;
}
if (_ordsRow.isClose)
{
MessageBox.Show("Заявка была закрыта : " + _ordsRow.AuthorLastModif);
return;
}
DialogQuantityOrder _DialogQuantityOrder = new DialogQuantityOrder(_ordsRow.ProductRow, _ordsRow);
if (_DialogQuantityOrder.ShowDialog(this) == DialogResult.OK)
{
this.SaveOrdersRow(_ordsRow);
}
else
{
_ordsRow.RejectChanges();
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log("gridViewOrders_DoubleClick" + err.Message);
}
}
private void gridViewOrdersAll_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
{
try
{
MDataSet.OrdersRow _ordsRow = (sender as GridView).GetDataRow(e.RowHandle) as MDataSet.OrdersRow;
if (_ordsRow == null)
{
return;
}
if (((_ordsRow.QuantityNow > 0) | (_ordsRow.Reserved > 0)) & !(_ordsRow.QuantityNow == _ordsRow.Quantity))
{
e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Italic);
e.Appearance.BackColor = Color.LightGreen;
}
else
{
if ((_ordsRow.QuantityNow == _ordsRow.Quantity) | (_ordsRow.isClose))
{
e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Italic);
e.Appearance.ForeColor = Color.Gray;
}
}
if (((_ordsRow.Quantity > _ordsRow.QuantityNow)) & _ordsRow.isClose)
{
e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Strikeout);
e.Appearance.BackColor = Color.LightGray;
}
if (_ordsRow.RowState != DataRowState.Unchanged)
{
e.Appearance.BackColor = Color.LightCoral;
}
}
catch
{
MessageBox.Show("Ошибка прорисовки!");
}
}
private void btAdd_Click(object sender, EventArgs e)
{
MDataSet.ProductRow _prod = this.gridViewProd.GetDataRow(this.gridViewProd.FocusedRowHandle) as MDataSet.ProductRow;
if (_prod != null)
{
try
{
MDataSet.OrdersRow _ord = (this.ordersBindingSource.AddNew() as DataRowView).Row as MDataSet.OrdersRow;
DialogQuantityOrder _DialogQuantityOrder = new DialogQuantityOrder(_prod, _ord);
if (_DialogQuantityOrder.ShowDialog(this) == DialogResult.OK)
{
try
{
this.ordersBindingSource.EndEdit();
this.ordersBindingSource.ResetBindings(false);
MainForm.Log(" this.ordersBindingSource.EndEdit успешно");
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log(err.Message);
}
}
else
{
this.ordersBindingSource.CancelEdit();
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log("btAdd_Click" + err.Message);
}
}
}
private bool SaveOrdersRow(MDataSet.OrdersRow row)
{
try
{
this.ordersTableAdapter.Update(row);
}
catch (Exception err)
{
MessageBox.Show("Не удалось сохранить данные!");
MessageBox.Show(err.Message);
return(false);
}
finally
{
}
return(true);
}
private void ordersBindingSource_PositionChanged(object sender, EventArgs e)
{
try
{
if (productBindingSource.Current == null)
{
return;
}
MDataSet.ProductRow _product = (productBindingSource.Current as DataRowView).Row as MDataSet.ProductRow;
if (ordersBindingSource.Current == null)
{
return;
}
MDataSet.OrdersRow _orders = (ordersBindingSource.Current as DataRowView).Row as MDataSet.OrdersRow;
if (_orders.ProductRow == null)
{
return;
}
if ((_orders == null) | (_product == null))
{
return;
}
if (_product.ID != _orders.ProductRef)
{
this.productBindingSource.Position = this.productBindingSource.Find("Id", _orders.ProductRef);
}
MainForm.Log(" rdersBindingSource_PositionChanged успешно");
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log(err.Message);
}
}
private void gridViewOrders_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
{
try
{
MDataSet.OrdersRow _ordsRow = this.gridViewOrders.GetDataRow(e.RowHandle) as MDataSet.OrdersRow;
if (_ordsRow == null)
{
return;
}
;
if ((_ordsRow.QuantityNow > 0) | (_ordsRow.Reserved > 0))
{
e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Italic);
e.Appearance.BackColor = Color.LightGreen;
}
else
{
if (_ordsRow.isClose)
{
e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Italic);
e.Appearance.ForeColor = Color.Gray;
}
}
if (((_ordsRow.Quantity > _ordsRow.QuantityNow)) & _ordsRow.isClose)
{
e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Strikeout);
e.Appearance.BackColor = Color.LightGray;
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
MainForm.Log("gridViewOrders_CustomDrawCell" + err.Message);
return;
}
}
public OrderAdd(MDataSet.OrdersRow source, MainForm mainForm)
{
InitializeComponent();
_mainForm = mainForm;
this.mDataSet = source.Table.DataSet as MDataSet;
this.ordersBindingSource.DataSource = source;
this.errorProvider1.DataSource = this.ordersBindingSource.DataSource;
this.tradePutletBindingSource.DataSource = new DataView(this.mDataSet.TradePutlet, "ID>0", null, DataViewRowState.CurrentRows);
this.tradePutletBindingSource.ResetBindings(false);
_product = _mainForm.fullDataSet.Product;
this.productBindingSource.DataSource = _mainForm.fullDataSet.Product;
this.productBindingSource.ResetBindings(false);
}
public DialogQuantityOrder(MDataSet.ProductRow source, MDataSet.OrdersRow newRow)
{
InitializeComponent();
newRow.ProductRef = source.ID;
this.productBindingSource.DataSource = source;
if (source.GetRemainsRows().Length != 0)
{
foreach (MDataSet.RemainsRow row in source.GetRemainsRows())
{
_QauntityRemains += row.QuantityRemains;
}
}
this.ordersBindingSource.DataSource = newRow;
this.labelRem.DataBindings.Add(new Binding("Text", this, "QauntityRemains"));
}
private void btDelete_Click(object sender, EventArgs e)
{
MDataSet.OrdersRow _ordsRow = this.gridViewOrders.GetDataRow(this.gridViewOrders.FocusedRowHandle) as MDataSet.OrdersRow;
if (_ordsRow == null)
{
return;
}
if (_ordsRow.Reserved > 0)
{
MessageBox.Show("Этот товар уже для вас зарезервирован: " + _ordsRow.Reserved.ToString());
return;
}
if (_ordsRow.QuantityNow > 0)
{
MessageBox.Show("Этот товар вам уже отгружен");
return;
}
if (_ordsRow.isClose)
{
MessageBox.Show("Заявка была закрыта : " + _ordsRow.AuthorLastModif);
return;
}
if (MessageBox.Show("Удалить : " + _ordsRow.ProductRow.Name + " ?") == DialogResult.OK)
{
_ordsRow.Delete();
this.SaveOrdersRow(_ordsRow);
}
}