asp.net基于Calendar实现blog日历功能示例

private int[] arrCurrentDays, arrPreDays, arrNextDays; //三个变量分别是当前月，前一月，和下一个月
private int intCurrentMonth, intPreMonth, intNextMonth; //三个整型数组存放相对月份写有blog的日期

CalendarDay d = ((DayRenderEventArgs)e).Day;
TableCell c = ((DayRenderEventArgs)e).Cell;
// 初始化当前月有Blog的日期数组
if (intPreMOnth== 0)
{
  intPreMOnth= d.Date.Month; // 注意：日历控件初始化时我们得到的第一个月并不是当前月，而是前一个月的月份
  intCurrentMOnth= intPreMonth + 1;
  if (intCurrentMonth > 12)
    intCurrentMOnth= 1;
  intNextMOnth= intCurrentMonth + 1;
  if (intNextMonth > 12)
    intNextMOnth= 1;
  arrPreDays = getArrayDay(d.Date.Year, intPreMonth); //得到前一个月有blog的日期数组
  arrCurrentDays = getArrayDay(d.Date.Year, intCurrentMonth);//得到当月有blog的日期数组
  arrNextDays = getArrayDay(d.Date.Year, intNextMonth);//得到下个月有blog的日期数组
}
int j = 0;
if (d.Date.Month.Equals(intPreMonth))
{
  while (!arrPreDays[j].Equals(0))
  {
    if (d.Date.Day.Equals(arrPreDays[j]))
    {
      c.Controls.Clear();
      c.Controls.Add(new LiteralControl("" + d.Date.Day + ""));
    }
    j++;
  }
}
else if (d.Date.Month.Equals(intCurrentMonth))
{
  while (!arrCurrentDays[j].Equals(0))
  {
    if (d.Date.Day.Equals(arrCurrentDays[j]))
    {
      c.Controls.Clear();
      c.Controls.Add(new LiteralControl("" + d.Date.Day + ""));
    }
    j++;
  }
}
else if (d.Date.Month.Equals(intNextMonth))
{
  while (!arrNextDays[j].Equals(0))
  {
    if (d.Date.Day.Equals(arrNextDays[j]))
    {
      c.Controls.Clear();
      c.Controls.Add(new LiteralControl("" + d.Date.Day + ""));
    }
    j++;
  }

public int[] getArrayDay(int intYear, int intMonth)
{
  int[] intArray = new int[31];
  //从数据库里选取符合要求的记录，将日期存入数组
  string strSql = "select data from test where year(data)=" + intYear +
  " and month(data)=" + intMonth;
  //调用DbHelperOleDb自定义类中的ExecuteReader方法,它返回的是一个OleDbDataReader型
  OleDbDataReader dr = dbAccess.DbHelperOleDb.ExecuteReader(strSql);
  int i = 0;
  while (dr.Read())
  {
    if (i == 0)
    {
      intArray[i] = Convert.ToDateTime(dr["data"].ToString()).Day;
      string a=Convert.ToString(intArray[i]);
      i++;
    }
    else if (Convert.ToDateTime(dr["data"].ToString()).Day != intArray[i - 1])
    {
      intArray[i] = Convert.ToDateTime(dr["data"].ToString()).Day;
      i++;
    }
  }
  return intArray;
}