日期筛选

很多时候，我们根据日期来查数据的时候，一般是输入一个时间范围，来查出你所需要的范围数据
当数据在数据库的时间是string 类型时，查出你选中的范围，这时就要转换类型，转成DateTime 类型
现在就来实现查询时间范围
你要选择时间的输入框

<label for="greaterEqual">大于等于：</label>
<input type="date" class="rounded p-0 pl-1" style="width:150px;height:25px;outline:none;border:1px solid #808080;" autocomplete=off id="greaterEqual" /><br />
<label for="lessEqual">小于等于：</label>
<input type="date" class="rounded p-0 pl-1" style="width:150px;height:25px;outline:none;border:1px solid #808080;" autocomplete=off id="lessEqual" /><br />

获取到你选择的日期

var greaterEqual = $("#greaterEqual").val();
var lessEqual = $("#lessEqual").val();
判断有没有输入或选择日期，就为空
if (greaterEqual == undefined) {
greaterEqual = "";
}
if (lessEqual == undefined) {
lessEqual = "";
}

通过重载把数据传到控制器

//方法级渲染重载
tabIncomeLine.reload({
url: "TabIncomeLine",
where: {
greaterEqual: greaterEqual,
lessEqual: lessEqual
},
page: {
curr: 1
}
});

//控制器
public ActionResult TabIncomeLine(LayuiTablePage layuiTablePage,string greaterEqual, string lessEqual)
{
List< TabIncomelistVo> listIncomeLine = (from tbIncomeLine in myModels.B_Incomelist
orderby tbIncomeLine.IncomeListID descending
select new TabIncomelistVo
{
ServerPeriod = tbIncomeLine.ServerPeriod
}).ToList();
//条件筛选 Lambda表达式
if (!string.IsNullOrEmpty(greaterEqual))
{
listIncomeLine = listIncomeLine.Where(m => Convert.ToDateTime(m.ServerPeriod) >= Convert.ToDateTime(greaterEqual)).ToList();
}
if (!string.IsNullOrEmpty(lessEqual))
{
listIncomeLine = listIncomeLine.Where(m => Convert.ToDateTime(m.ServerPeriod) <= Convert.ToDateTime(lessEqual)).ToList();
}
//计算数据总条数
int totalRow = listIncomeLine.Count();
//分页数据
List< TabIncomelistVo> dbIncomeLine = listIncomeLine
.Skip(layuiTablePage.GetStartIndex())
.Take(layuiTablePage.limit)
.ToList();
//
LayuiTableData< TabIncomelistVo> layuiTableData = new LayuiTableData< TabIncomelistVo>
{
count = totalRow,
data = dbIncomeLine
};
return Json(layuiTableData, JsonRequestBehavior.AllowGet);
}

查询出来的结果