public static Page <CabinetA> GetCabinets(CabinetSearchModel search, List <int> departList) { var sql = "select * from Cabinet where DepartmentID in @DepartmentID "; if (!string.IsNullOrEmpty(search.CabinetName)) { sql += " and Name like '%" + search.CabinetName + "%'"; } if (search.CabinetCode != null) { sql += " and Code like '%" + search.CabinetCode + "%'"; } using (var cn = Database.GetDbConnection()) { return(cn.PagedQuery <CabinetA>(search.PageIndex, search.PageSize, sql, new { DepartmentID = departList })); } }
public IHttpActionResult QueryCabinet(CabinetSearchModel search) { try { if (search == null) { return(BadRequest()); } if (search.PageIndex == 0) { search.PageIndex = 1; } if (search.PageSize == 0) { search.PageSize = 20; } _logger.Info(JsonConvert.SerializeObject(UserController.LoginDictionary)); if (!UserController.LoginDictionary.ContainsKey(GetCookie("token"))) { return(Logout()); } UserInfo userCookie = UserController.LoginDictionary[GetCookie("token")]; if (userCookie == null) { return(Logout()); } //更新保险柜状态 //var cabinetList = Cabinet.GetAll().FindAll(m => (m.Status == 1 || m.Status == 4)); //foreach (var m in cabinetList) //{ // var log = CabinetLog.GetOpenLog(m.ID); // if (log == null || log.CreateTime.AddSeconds(60) < DateTime.Now) // { // m.Status = 3; // Cabinet.Update(m); // _logger.Info("自动重置关闭"); // } //} List <Department> departList = Department.GetAllChildren(userCookie.DepartmentID); if (!string.IsNullOrEmpty(search.DepartmentName)) { departList = departList.FindAll(m => m.Name.Contains(search.DepartmentName)); } var result = Cabinet.GetCabinets(search, departList.Select(m => m.ID).ToList()); if (result.Items.Count > 0) { var depart = Department.GetAll(result.Items.Select(m => m.DepartmentID).ToList()); result.Items.ForEach(m => { m.DepartmentName = depart.Find(n => n.ID == m.DepartmentID)?.Name; m.FirstContactPassword = string.IsNullOrEmpty(m.FirstContactPassword) ? "" : AESAlgorithm.Decrypto(m.FirstContactPassword); m.SecondContactPassword = string.IsNullOrEmpty(m.SecondContactPassword) ? "" : AESAlgorithm.Decrypto(m.SecondContactPassword); }); } return(Success(result)); } catch (Exception ex) { _logger.Error(ex); return(Failure("查询失败")); } }