コード例 #1
0
        public List <CameraTable> GetByCondition(RequestCamera camera)
        {
            List <CameraTable> list = _dbcontext.CameraTable.WhereIf(!string.IsNullOrWhiteSpace(camera.IpAddr), t => t.IpAddr.Contains(camera.IpAddr))
                                      .WhereIf(!string.IsNullOrWhiteSpace(camera.CameraName), t => t.CameraName.Contains(camera.CameraName))
                                      .WhereIf(camera.CameraTypeTableId.HasValue, t => t.CameraTypeTableId == camera.CameraTypeTableId).ToList();

            return(list);
        }
コード例 #2
0
 public IActionResult SelectCondition([FromBody] RequestCamera camera)
 {
     try
     {
         List <CameraTable> list = _repository.GetByCondition(camera);
         return(Json(new
         {
             table = list,
             state = "0",
             msg = "获取数据成功"
         }));
     }
     catch (Exception ex)
     {
         return(Json(new
         {
             state = "-1",
             msg = "获取数据出现错误",
             error = ex.Message
         }));
     }
 }