public virtual int Fill_Limit(dsSight.vSightNear50DataTable dataTable, short?SchYears, short?SchYearsPre, short SemPre, short Sem, short Limit) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (SchYears.HasValue) { this.Adapter.SelectCommand.Parameters[0].Value = SchYears.Value; } else { this.Adapter.SelectCommand.Parameters[0].Value = DBNull.Value; } if (SchYearsPre.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = SchYearsPre.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } this.Adapter.SelectCommand.Parameters[2].Value = SemPre; this.Adapter.SelectCommand.Parameters[3].Value = Sem; this.Adapter.SelectCommand.Parameters[4].Value = Limit; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
public virtual int Fill(dsSight.vSightNear50DataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }