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