多条件查询

文献种类：专题技术文献；
开发工具与关键技术：Visual Studio 多条件查询
撰写时间：2020年 8月 17日

多条件查询

//全局变量
var tabTicketHistory;//旅客电子票证历史记录表
var layer,laydate,layuiTable;//保存layui模块以便全局使用
//1. 页面DOM文档加载完成后加载执行
$(function () {
layui.use([‘table’, ‘laydate’, ‘layer’],
function () {
layuiTable = layui.table;
laydate = layui.laydate;
layer = layui.layer;

//初始化日期控件
laydate.render({
elem: “#flightDateStr”,
type: “date”,
btns: [‘now’, ‘confirm’],
trigger: ‘click’ //解决Laydate一闪而过的问题
});
进行表格渲染

//2连表查询

条件筛选
//3.条件筛选
//票号
if (!string.IsNullOrEmpty(strTicketNo))
{listETicket = listETicket.Where(m => m.ticketNo.Contains(strTicketNo));}

//旅客姓名
if (!string.IsNullOrEmpty(passengerName))
{listETicket=listETicket.Where(m=>m.passengerName.Contains(passengrName));}

//航班号
if (!string.IsNullOrEmpty(flightCode))
{listETicket=listETicket.Where(m=>m.flightCode.Contains(flightCode));}

//起始日期和结束日期不为空
if (!string.IsNullOrEmpty(flightDateStr))
{
try
{
DateTimedetStarTime = Convert.ToDateTime(flightDateStr);listETicket = listETicket.Where(p => p.flightDate == detStarTime);}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//起飞机场ID
if (orangeId > 0)
{ listETicket = listETicket.Where(m => m.orangeId == orangeId);}

//到达机场ID
if (destinationId > 0){listETicket = listETicket.Where(m => m.destinationId == destinationId);}

//获取总数
var intTotalRow = listETicket.Count();

//4. 进行多条件查询并判断
function tabTicketHistorySearch() {
//获取input内容并判断
//票号
var ticketNo = $("#ticketNo").val();
if (ticketNo == undefined || ticketNo == null || ticketNo == “”) {ticketNo = “”;
}
//旅客姓名
var passengerName = $("#passengerName").val();
if (passengerName == undefined || passengerName == null || passengerName == “”) {passengerName = “”;
}
//航班号
var flightCode = $("#flightCode").val();
if (flightCode == undefined || flightCode == null || flightCode == “”) {flightCode = “”;
}
//航班日期
var flightDateStr = $("#flightDateStr").val();
if (flightDateStr == undefined || flightDateStr == null || flightDateStr == “”) { flightDateStr = “”;
}
//起飞机场
var orangeId = $("#orange").val();
if (orangeId == undefined || orangeId == null) {orangeId = 0;
}

//到达机场
var destinationId = $("#destination").val();
if (destinationId == undefined || destinationId == null) {destinationId = 0;
}

//数据验证
if (orangeId != 0 && destinationId != 0 && orangeId == destinationId) { myAlert(“出发机场和到达机场一样，请检查！”);
return;
}