/// <summary>
/// 查询基础信息
/// </summary>
/// <param name="dataBaseTypeSearchViewModel"></param>
/// <returns></returns>
public List <DataBaseTypeSearchMiddle> DataBase_Search(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
List <DataBase_Type> database_type = _IDataBaseTypeRepository.SearchDataBaseWhere(dataBaseTypeSearchViewModel);
var result = _IMapper.Map <List <DataBase_Type>, List <DataBaseTypeSearchMiddle> >(database_type);
return(result);
}
public List <DataBase_Type> SearchDataBaseNum(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
var predicate = SearchDataBaseinfo(dataBaseTypeSearchViewModel);
var result = DbSet.Where(predicate).ToList();
return(result);
}
/// <summary>
/// 基础类型信息查询
/// </summary>
/// <param name="bookSearchViewModel"></param>
/// <returns></returns>
public List <DataBase_Type> SearchDataBaseWhere(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
var predicate = SearchDataBaseinfo(dataBaseTypeSearchViewModel);
var result = DbSet.Where(predicate).OrderByDescending(a => a.CreateDate).ToList();
return(result);
}
/// <summary>
/// 根据楼查区数量
/// </summary>
/// <param name="dataBaseTypeSearchViewModel"></param>
/// <returns></returns>
public int SearchAreaByFloorNum(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
List <DataBase_Type> database_type = _IDataBaseTypeRepository.SearchDataBaseWhere(dataBaseTypeSearchViewModel);
List <DataBase_Type> floor_searchArea = _IDataBaseTypeRepository.SearchAreaByFloorNum(database_type[0].Id.ToString());
return(floor_searchArea.Count);
}
/// <summary>
/// 根据楼查区
/// </summary>
/// <param name="dataBaseTypeSearchViewModel"></param>
/// <returns></returns>
public List <DataBaseTypeSearchMiddle> SearchAreaByFloor(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
List <DataBase_Type> database_type = _IDataBaseTypeRepository.SearchDataBaseWhere(dataBaseTypeSearchViewModel);
List <DataBase_Type> floor_searchArea = _IDataBaseTypeRepository.SearchAreaByFloor(database_type[0].Id.ToString());
var result = _IMapper.Map <List <DataBase_Type>, List <DataBaseTypeSearchMiddle> >(floor_searchArea);
return(result);
}
public ActionResult <DataBase_Type> Manage_SearchAll(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
DataBaseTypeSearchResModel databasetypeSearchResModel = new DataBaseTypeSearchResModel();
var Result = _DataBaseTypeService.DataBase_Search(dataBaseTypeSearchViewModel);
int count = _DataBaseTypeService.DataBase_SearchNum(dataBaseTypeSearchViewModel);
databasetypeSearchResModel.Room_info = Result;
databasetypeSearchResModel.TotalNum = count;
databasetypeSearchResModel.isSuccess = true;
databasetypeSearchResModel.baseViewModel.Message = "查询成功";
databasetypeSearchResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("根据会议室信息，查询成功");
return(Ok(databasetypeSearchResModel));
}
//根据条件查询会议室信息
private Expression <Func <DataBase_Type, bool> > SearchDataBaseinfo(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
var predicate = WhereExtension.True <DataBase_Type>();//初始化where表达式
predicate = predicate.And(a => a.IsDelete == "0");
predicate = predicate.And(a => a.Id.ToString().Contains(dataBaseTypeSearchViewModel.Id.ToString()));
predicate = predicate.And(a => a.Name.Contains(dataBaseTypeSearchViewModel.Name));
predicate = predicate.And(a => a.TypeName.Contains(dataBaseTypeSearchViewModel.TypeName));
predicate = predicate.And(a => a.Purview.Contains(dataBaseTypeSearchViewModel.Purview));
return(predicate);
}
/// <summary>
/// 查询基础信息数量
/// </summary>
/// <param name="dataBaseTypeSearchViewModel"></param>
/// <returns></returns>
public int DataBase_SearchNum(DataBaseTypeSearchViewModel dataBaseTypeSearchViewModel)
{
List <DataBase_Type> database_type = _IDataBaseTypeRepository.SearchDataBaseNum(dataBaseTypeSearchViewModel);
return(database_type.Count);
}
