private void btRefreshRepiod_Click(object sender, EventArgs e)
{
try
{
this.ordersTableAdapter.Update(this.mDataSet.Orders);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
MDataSet.OrdersDataTable tmpOrders = new MDataSet.OrdersDataTable();
//Перечитать за период
try
{
this.ordersTableAdapter.FillByStartDate(tmpOrders, this.dateEdit.Value);
this.mDataSet.Orders.Merge(tmpOrders);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
public OrdersAll(MDataSet.OrdersDataTable source)
{
InitializeComponent();
this.mDataSet = source.DataSet as MDataSet;
this.ordersBindingSource.DataSource = new DataView(source, "Quantity - Reserved- QuantityNow >0 and isClose=0", null, DataViewRowState.CurrentRows);
this.ordersBindingSource.ResetBindings(false);
this.ordersOldBindingSource.DataSource = new DataView(source, "Quantity - Reserved - QuantityNow <=0", null, DataViewRowState.CurrentRows);
this.ordersBindingSourceAll.DataSource = new DataView(source, null, null, DataViewRowState.CurrentRows);
this.tradePutletBindingSource.DataSource = this.mDataSet.TradePutlet;
this.tradePutletBindingSource.ResetBindings(false);
this.productBindingSource.DataSource = this.mDataSet.Product;
this.productBindingSource.ResetBindings(false);
this.dateEdit.Value = DateTime.Today;
//this.TradePutletLookUpEdit.DataSource =
}
public virtual MDataSet.OrdersDataTable GetDataByStartPeriod(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.OrdersDataTable dataTable = new MDataSet.OrdersDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
private void btRefreshRepiod_Click(object sender, EventArgs e)
{
try
{
this.ordersTableAdapter.Update(this.mDataSet.Orders);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
MDataSet.OrdersDataTable tmpOrders = new MDataSet.OrdersDataTable();
//Перечитать за период
try
{
this.ordersTableAdapter.FillByStartDate(tmpOrders, this.dateEdit.Value);
this.mDataSet.Orders.Merge(tmpOrders);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
public virtual MDataSet.OrdersDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
MDataSet.OrdersDataTable dataTable = new MDataSet.OrdersDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
