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