开发工具与关键技术: Visual Studio bool值的查询条件
作者:黎凤焕
撰写时间:2019年 7 月 12 日
Bool值的查询条件和其它值的查询条件不同,多条件查询table时,bool值查询往往不简单,不同于其它值的查询,如果bool值的查询方法和其它的查询方法一样,将会报错。Bool值有自己的查询方法。
首先多条件查询table,在控制器上查询,1代表全部,2代表已停药,3代表未停药,当value值为1时,判断它为空,当value值为2时,判断它的值为true,当value值为3时,判断它的值为false。控制器的方法判断条件也是如此操作。
//多条件查询table
function tabPharmacyDrugSearch() {
var MedicineCode = $("#searchMedicineCode").val();
if (MedicineCode == null || MedicineCode == undefined) {
MedicineCode = “”;
}
var MedicineState = $("#searchMedicineState").val();
if (MedicineState == 1) {
MedicineState = “”;
}
if (MedicineState == 2) {
MedicineState = “true”;
}
if (MedicineState == 3) {
MedicineState = “false”;
}
var StairGroup = $("#searchStairGroup").val();
if (StairGroup == null || StairGroup == undefined) {
StairGroup = “”;
}
var SecondGroup = $("#searchSecondGroup").val();
if (SecondGroup == null || SecondGroup == undefined) {
SecondGroup = “”;
}
tabPharmacyDrug = layuiTable.reload(“tabPharmacyDrug”, {
url: “/PharmacyManagement/PharmacyDrug/SelectMedicine”,
page: {
curr: 1
},
where: {
MedicineCode: MedicineCode,
MedicineState: MedicineState,
StairGroup: StairGroup,
SecondGroup: SecondGroup,
}
});