筛选时间段的信息

系统管理员 2021-12-05 00:49 264阅读 0赞

筛选时间段的信息  
开发工具与关键技术： Visual Studio 2015 – Jquery  
作者：廖亚星  
撰写时间：2019年 7 月 13 日

在做积分统计的时候，会出现一个下拉框，里面有显示当天、显示昨天、显示当月、当年、全部等下拉框值，我们要根据这些值自动回填时间段然后查询这些时间段的信息  
![在这里插入图片描述][20190717154056960.PNG]  
首先这个下拉框里面的选项都会有value值，我们要根据value值来定义事件的改变事件，先要定义一个获取日期的方法  
//获取日期  
function getDateStr(AddDayCount) \{  
var dd = new Date();  
dd.setDate(dd.getDate() + AddDayCount);//获取AddDayCount天后的日期  
var y = dd.getFullYear();  
var m = dd.getMonth() + 1;//获取当前月份的日期  
var d = dd.getDate();  
return y + ‘-’ + (m < 10 ? ‘0’ + m : m) + ‘-’ + d;  
\}  
然后根据下拉框的值进行筛选，让后面的两个input框进行时间的改变，然后把刚才定义的方法引用到input框中  
//下拉框筛选，时间改变事件  
$("\#DateC").change(function () \{  
var Time = $("\#DateC").val();  
var date = new Date();  
var year = date.getFullYear();  
var years = date.getFullYear() - 1;  
var month = date.getMonth();  
var months = date.getMonth() + 1;  
if (Time == 1) \{  
$("\#MarketDateT").val(getDateStr(0));  
$("\#MarketDateE").val(getDateStr(0));  
\}  
if (Time == 2) \{  
$("\#MarketDateT").val(getDateStr(-1));  
$("\#MarketDateE").val(getDateStr(0));  
\}  
if (Time == 3) \{  
var firstdate = year + ‘-’ + months + ‘-01’  
var day = new Date(year, months, 0);  
var lastdate = year + ‘-’ + months + ‘-’ + day.getDate();  
$("\#MarketDateT").val(firstdate);//本月第一天  
$("\#MarketDateE").val(lastdate);//本月最后一天  
\}  
if (Time==……)  
if (Time == 7) \{  
var firstDayOfPreMonth = “1900” + “-” + “01” + “-” + “01”;  
var lastDayOfPreMonth = “2999” + “-” + “12” + “-” + “31”;  
$("\#MarketDateT").val(firstDayOfPreMonth);  
$("\#MarketDateE").val(lastDayOfPreMonth);  
\}  
\});  
然后我们做时间段的查询  
//积分调整统计查询  
function SalesInquiry() \{  
//查询条件  
var MarketDateT = $("\#MarketDateT").val();//从  
var MarketDateE = $("\#MarketDateE").val();//到  
var Time = $("\#DateC").val();  
if (MarketDateT == undefined) \{  
MarketDateT = “”;  
\}  
if (MarketDateE == undefined) \{  
MarketDateE = “”;  
\}  
//表格重载  
tabSalesList.reload(\{  
url: “/DailyRoutine/MembershipManagement/OpSalesList”,  
where: \{  
Time: Time,  
MarketDateT: MarketDateT,  
MarketDateE: MarketDateE,  
\},  
page: \{  
curr: 1  
\}  
\});  
\}  
在控制器中查询数据，并根据下拉框的时间段对积分信息进行筛选,方法都差不多，中间就省略几条筛选  
public ActionResult OpSalesList(LayuiTablePage layuiTablePage, string MarketDateT, string MarketDateE, int? Time)  
\{  
string DataTime = “”;  
List lisSalesList = (from tbVIP in myModel.B\_VIP//销售表  
join tbIntegral in myModel.B\_VIPIntegralAdjustment on  
tbVIP.VIPID equals s//用户表  
orderby tbIntegral.DayBreak descending  
select new Adjust  
\{  
DayBreak = tbIntegral.DayBreak,  
StrDayBreak = tbIntegral.DayBreak.ToString(),  
\}).ToList();  
if (MarketDateT != null && MarketDateE != null)  
\{  
DateTime startDate = Convert.ToDateTime(MarketDateT);  
DateTime endDate = Convert.ToDateTime(MarketDateE);  
lisSalesList = lisSalesList.Where(m => m.DayBreak >= startDate && m.DayBreak <= endDate).ToList();  
\}  
else  
if (Time == 1)  
\{  
DataTime = DateTime.Now.ToString(“yyyy-MM-dd”);  
lisSalesList = lisSalesList.Where(m => Convert.ToDateTime(m.StrDayBreak).ToString(“yyyy-MM-dd”).Trim() == DataTime.Trim()).ToList();  
\}  
if (Time == 2)  
\{  
DataTime = DateTime.Now.AddDays(-1).ToString(“yyyy-MM-dd”);//昨天  
lisSalesList = lisSalesList.Where(m => Convert.ToDateTime(m.StrDayBreak).ToString(“yyyy-MM-dd”).Trim() == DataTime.Trim()).ToList();  
\}  
if (Time == 3) //本月  
\{  
var Times = DateTime.Now.Year.ToString() + ‘-’ + ‘0’ + DateTime.Now.Month.ToString() + ‘-’ + ‘0’ + “1”;//第一天  
DataTime = DateTime.Parse(Times).AddMonths(1).AddDays(-1).ToString(“yyyy-MM”);//最后一天  
lisSalesList = lisSalesList.Where(m => Convert.ToDateTime(m.StrDayBreak).ToString(“yyyy-MM”) == DataTime).ToList();  
\}  
if (Time == 7)  
\{  
//显示全部(不用查询) DataTime = “”;  
\}  
int intTotalRow = lisSalesList.Count(); // 总行数  
List listNotices = lisSalesList //分页  
.Skip(layuiTablePage.GetStartIndex())  
.Take(layuiTablePage.limit)//页数  
.ToList();  
LayuiTableData layuiTableData = new LayuiTableData  
\{  
count = intTotalRow,  
data = listNotices  
\};  
return Json(layuiTableData, JsonRequestBehavior.AllowGet);  
\}  
最后我们就可以根据下拉框的值对时段进行数据的查询了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70]

[20190717154056960.PNG]: /images/20211205/253dd3a082a1403f86d7a24389f3896c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70]: /images/20211205/03362cd17bf146ea92deaa11a2286ff5.png