public ArrayList GetRate(int serverId)
{
SqlDataReader reader = null;
try
{
ArrayList arrryList = new ArrayList();
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@ServerID", serverId);
db.GetReader(ref reader, "SP_Rate", para);
while (reader.Read())
{
RateInfo info = new RateInfo();
info.ServerID = (int)reader["ServerID"];
info.Rate = (float)(decimal)reader["Rate"];
info.BeginDay = (DateTime)reader["BeginDay"];
info.EndDay = (DateTime)reader["EndDay"];
info.BeginTime = (DateTime)reader["BeginTime"];
info.EndTime = (DateTime)reader["EndTime"];
info.Type = (int)reader["Type"];
arrryList.Add(info);
}
arrryList.TrimToSize();
return arrryList;
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("GetRates", e);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
return null;
}
private static bool IsValid(RateInfo _RateInfo)
{
if (_RateInfo.BeginDay == null || _RateInfo.EndDay == null)
return false;
if (_RateInfo.BeginDay.Year > DateTime.Now.Year || DateTime.Now.Year > _RateInfo.EndDay.Year)
return false;
if (_RateInfo.BeginDay.DayOfYear > DateTime.Now.DayOfYear || DateTime.Now.DayOfYear > _RateInfo.EndDay.DayOfYear)
return false;
if (_RateInfo.BeginTime.TimeOfDay > DateTime.Now.TimeOfDay || DateTime.Now.TimeOfDay > _RateInfo.EndTime.TimeOfDay)
return false;
return true;
}
public RateInfo GetRateWithType(int serverId, int type)
{
SqlDataReader reader = null;
try
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@ServerID", serverId);
para[1] = new SqlParameter("@Type", type);
db.GetReader(ref reader, "SP_Rate_WithType", para);
if (reader.Read())
{
RateInfo info = new RateInfo();
info.ServerID = (int)reader["ServerID"];
info.Type = type;
info.Rate = (float)reader["Rate"];
info.BeginDay = (DateTime)reader["BeginDay"];
info.EndDay = (DateTime)reader["EndDay"];
info.BeginTime = (DateTime)reader["BeginTime"];
info.EndTime = (DateTime)reader["EndTime"];
return info;
}
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("GetRate type: " + type, e);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
return null;
}
