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