public virtual int Fill(RetailTradeClDataSet.ProductSelectByIdDataTable dataTable, System.Nullable<int> ProductRef) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((ProductRef.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ProductRef.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(RetailTradeClDataSet.ProductRemainsByDateDataTable dataTable, System.Nullable<System.DateTime> StartDate, System.Nullable<System.DateTime> EndDate, System.Nullable<int> productRef) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((StartDate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(StartDate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((EndDate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(EndDate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
}
if ((productRef.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((int)(productRef.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}