VS中筛选当天、明天、当月、上月、当年、上年、全部。
控制器代码部分:
var Time = "";
if (Date == 1) {
Time = DateTime.Now.ToString("yyyy-MM-dd");
Linqs = Linqs.Where(S => Convert.ToDateTime(S.NumberDate).ToString("yyyy-MM-dd") == Time).ToList();
} else if (Date == 2) {
//昨天
Time = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
Linqs = Linqs.Where(S => Convert.ToDateTime(S.NumberDate).ToString("yyyy-MM-dd") == Time).ToList();
} else if (Date == 3) {
//本月
var Times = DateTime.Now.Year.ToString() + '-' + '0' + DateTime.Now.Month.ToString() + '-' + '0' + "1";//本月第一天
Time = DateTime.Parse(Times).AddMonths(1).AddDays(-1).ToString("yyyy-MM");//最后一天
Linqs = Linqs.Where(S => Convert.ToDateTime(S.NumberDate).ToString("yyyy-MM") == Time).ToList();
} else if (Date == 4) {
//上月
Time = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddDays(-1).ToString("yyyy-MM");
Linqs = Linqs.Where(S => Convert.ToDateTime(S.NumberDate).ToString("yyyy-MM") == Time).ToList();
} else if (Date == 5) {
//今年
Time = DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(1).AddDays(-1).ToString("yyyy");
Linqs = Linqs.Where(S => Convert.ToDateTime(S.NumberDate).ToString("yyyy") == Time).ToList();
} else if (Date == 6) {
//上年
Time = DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddDays(-1).ToString("yyyy");
Linqs = Linqs.Where(S => Convert.ToDateTime(S.NumberDate).ToString("yyyy") == Time).ToList();
} else {
//显示全部(不用查询)
Time = "";
}