public virtual dsSight.vSightNear50DataTable Get_Limit(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; dsSight.vSightNear50DataTable dataTable = new dsSight.vSightNear50DataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
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 dsSight.vSightNear50DataTable Get() { this.Adapter.SelectCommand = this.CommandCollection[0]; dsSight.vSightNear50DataTable dataTable = new dsSight.vSightNear50DataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(dsSight.vSightNear50DataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }