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("<a href="day.aspx?year=" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" mce_href="day.aspx?year=" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" " + d.Date.Year + "&month=" +
d.Date.Month + "&day=" + d.Date.Day + ">" + d.Date.Day + "</a>"));
}
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("<a href="day.aspx?year=" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" mce_href="day.aspx?year=" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" " + d.Date.Year + "&month=" +
d.Date.Month + "&day=" + d.Date.Day + " title=查看"+d.Date.Day+"日日志>" + d.Date.Day + "</a>"));
}
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("<a href="day.aspx?year=" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" mce_href="day.aspx?year=" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" " + d.Date.Year + "&month=" +
d.Date.Month + "&day=" + d.Date.Day + ">" + d.Date.Day + "</a>"));
}
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;
}
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有