private void BindRepeater() { int recordCount; DateTime startDate; if (!DateTime.TryParse(txtStartDate.Text, out startDate)) //如果没有填时间,就当前时间减一个星期 { startDate = DateTime.Now.AddDays(-7); } DateTime endDate; if (!DateTime.TryParse(txtEndDate.Text, out endDate)) { endDate = DateTime.Now.AddDays(7); } List <WeekPlanEntity> list = new App.WeekPlanApplication().GetList(int.Parse(ddlUsers.SelectedValue), startDate, endDate, UserInfo.Role, aspNetPager1.CurrentPageIndex, aspNetPager1.PageSize, out recordCount); if (recordCount == 0) { lblNoResult.Visible = true; lblNoResult.InnerHtml = "<span style='color: Red;'> No records</span>"; rptList.DataSource = null; rptList.DataBind(); } else { lblNoResult.Visible = false; rptList.DataSource = list; rptList.DataBind(); } aspNetPager1.RecordCount = recordCount; }
private void BindRepeater(string date) { int recordCount; DateTime startDate; DateTime endDate; if (!DateTime.TryParse(date, out startDate)) { int weekOfDay = (int)DateProvider.DayOfWeek; weekOfDay = weekOfDay == 0 ? 7 : weekOfDay; startDate = DateProvider.AddDays(1 - weekOfDay); } else { int weekOfDay = (int)startDate.DayOfWeek; weekOfDay = weekOfDay == 0 ? 7 : weekOfDay; startDate = startDate.AddDays(1 - weekOfDay); } endDate = startDate.AddDays(6); lblStartDate.Text = startDate.ToString("MM/dd/yyyy"); lblEndDate.Text = endDate.ToString("MM/dd/yyyy"); List <WeekPlanEntity> list = new App.WeekPlanApplication().GetList(QS("user", 0), startDate, endDate, UserInfo.Role, CurrentPageIndex, int.MaxValue, out recordCount); DateTime.Parse(DateProvider.ToShortDateString()); if (DateTime.Parse(DateProvider.ToShortDateString()) >= DateTime.Parse(startDate.ToShortDateString()) && DateTime.Parse(DateProvider.ToShortDateString()) <= DateTime.Parse(endDate.ToShortDateString())) { weekDay = (int)DateProvider.DayOfWeek; } StringBuilder headHtml = new StringBuilder(); headHtml.AppendFormat("<td > </td>"); headHtml.AppendFormat("<td width='10%'><strong>Total Remaining Hour</strong></td>"); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Monday</strong> {0}</td>", startDate.ToString("MM/dd"), weekDay == 1 ? "wpitemtoday" : ""); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Tuesday</strong> {0}</td>", startDate.AddDays(1).ToString("MM/dd"), weekDay == 2 ? "wpitemtoday" : ""); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Wednesday</strong> {0}</td>", startDate.AddDays(2).ToString("MM/dd"), weekDay == 3 ? "wpitemtoday" : ""); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Thursday</strong> {0}</td>", startDate.AddDays(3).ToString("MM/dd"), weekDay == 4 ? "wpitemtoday" : ""); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Friday</strong> {0}</td>", startDate.AddDays(4).ToString("MM/dd"), weekDay == 5 ? "wpitemtoday" : ""); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Saturday</strong> {0}</td>", startDate.AddDays(5).ToString("MM/dd"), weekDay == 6 ? "wpitemtoday" : ""); headHtml.AppendFormat("<td width='13%' class='{1}'><strong>Sunday</strong> {0}</td>", startDate.AddDays(6).ToString("MM/dd"), weekDay == 0 ? "wpitemtoday" : ""); dvHead.InnerHtml = headHtml.ToString(); if (recordCount == 0) { trNoRecords.Visible = true; rptList.DataSource = null; rptList.DataBind(); } else { trNoRecords.Visible = false; rptList.DataSource = list.OrderBy(e => e.FirstName); rptList.DataBind(); } }