Web.Code: protected void calSchedule_DayRender(object sender, DayRenderEventArgs e) { UserInfo user = (UserInfo)Session["CurrentUser"]; //自定义显示内容 CalendarDay calDay = ee ((DayRenderEventArgs)e).Day; //获取表示呈现在控件中的单元格 TableCell tc = ((DayRenderEventArgs)e).Cell; //农历转换对象 CNDate dt = new CNDate(calDay.Date); if (calDay.IsOtherMonth) { tc.Controls.Clear(); } else { try { int scheduleId = ScheduleManager.GetScheduleId(user.UserId,calDay.Date.ToShortDateString()); Schedule schedule = ScheduleManager.GetScheduleByScheduleId(scheduleId); HyperLink aHyperLink = new HyperLink(); aHyperLink.ImageUrl = "~/images/add_Schedule.gif"; aHyperLink.ToolTip = "新增个人日程"; aHyperLink.NavigateUrl = "SaveMySchedule.aspx?userid="+user.UserId+"&today=" + calDay.Date.ToShortDateString(); tc.Controls.Add(new LiteralControl(" " + " " + " ")); tc.Controls.Add(aHyperLink); tc.Controls.Add(new LiteralControl("<br>" + dt.GetLunarHolDay())); if (scheduleId != 0) { HtmlAnchor ha = new HtmlAnchor(); ha.HRef = "SaveMySchedule.aspx?userid=" + user.UserId + "&today=" + calDay.Date.ToShortDateString(); ha.InnerText = "◎" + schedule.BeginTime.Hour.ToString() + ":" + schedule.BeginTime.Minute.ToString() + " " + schedule.Title.Substring(0, 3) + "..."; tc.Controls.Add(new LiteralControl(" " + " " + " ")); tc.Controls.Add(new LiteralControl("<br>")); tc.Controls.Add(ha); tc.Controls.Add(new LiteralControl("<br>")); } } catch (Exception exc) { Response.Write(exc.ToString()); } e.Cell.Attributes["onmouseover"] = "javascript:this.style.backgroundColor='#fff7ce';cursor='hand';"; e.Cell.Attributes["onmouseout"] = "javascript:this.style.backgroundColor='#ffffff';"; } } DAL.Code: //根据登录用户和日程创建时间获得日程Id public static int GetScheduleId(string userId,string today) { DateTime dt = DateTime.Parse(today + " 00:00:00"); string day = dt.ToString("yyyy-MM-dd"); string sql = "select scheduleid from Schedule where CreateUser='" + userId + "' and convert(varchar(10),BeginTime,23)='" + day + "'"; return DBHelper.GetScalar(sql); } //根据日程Id获得日程信息 public static Schedule GetScheduleByScheduleId(int scheduleId) { string sql = "SELECT * FROM Schedule WHERE ScheduleId = @ScheduleId"; try { SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@ScheduleId", scheduleId)); if (reader.Read()) { Schedule schedule = new Schedule(); schedule.ScheduleId = (int)reader["ScheduleId"]; schedule.Title = (string)reader["Title"]; schedule.Address = (string)reader["Address"]; schedule.MeetingId = (int)reader["MeetingId"]; schedule.BeginTime = (DateTime)reader["BeginTime"]; schedule.EndTime = (DateTime)reader["EndTime"]; schedule.SchContent = (string)reader["SchContent"]; schedule.CreateUser = (string)reader["CreateUser"]; schedule.CreateTime = (DateTime)reader["CreateTime"]; schedule.IfPrivate = (int)reader["IfPrivate"]; reader.Close(); return schedule; } else { reader.Close(); return null; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }