protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
//首先隐藏掉默认的日显示字符
e.Cell.Controls[0].Visible = false;
string dt = Server.UrlEncode(e.Day.Date.ToString());
string qq = e.Day.Date.ToString("yyyyMMdd");
string sql = string.Format("select * from ExOrganizers where CONVERT(varchar(100), ExStartData, 112)=" + qq);
DataSet ds = SqlHelper.ExecuteDataset(connstr, CommandType.Text, sql);
if (ds.Tables[0].Rows.Count > 0)
{
//自定义一个日显示格式,如果是一个月的第一天就加上月份,否则只显示日
HyperLink hlevent_add = new HyperLink();
if (e.Day.Date.Day == 1)
{
hlevent_add.Text = e.Day.Date.Month.ToString() + "月" + e.Day.Date.Day.ToString() + "<br>";
hlevent_add.NavigateUrl = "Default11.aspx?select_date=" + dt;
hlevent_add.Target = "_blank";
}
else
{
hlevent_add.Text = e.Day.Date.Day.ToString() + "<br>";
hlevent_add.NavigateUrl = "Default11.aspx?select_date=" + dt;
hlevent_add.Target = "_blank";
}
e.Cell.Controls.Add(hlevent_add);
}
else
{
//自定义一个日显示格式,如果是一个月的第一天就加上月份,否则只显示日
HyperLink hlevent_add = new HyperLink();
if (e.Day.Date.Day == 1)
{
hlevent_add.Text = e.Day.Date.Month.ToString() + "月" + e.Day.Date.Day.ToString() + "<br>";
}
else
{
hlevent_add.Text = e.Day.Date.Day.ToString() + "<br>";
}
e.Cell.Controls.Add(hlevent_add);
}
string sqll = string.Format("select * from ExOrganizers where CONVERT(varchar(100), ExStartData, 112)=" + e.Day.Date.ToString("yyyyMMdd"));
DataSet dss = SqlHelper.ExecuteDataset(connstr, CommandType.Text, sqll);
int a = dss.Tables[0].Rows.Count;
this.Label1.Text = System.DateTime.Now.ToString() + "共有" + a + "个展会";
}
转载于:https://www.cnblogs.com/VirtualLive/archive/2010/01/20/1652269.html