/// <summary> /// 获取危险点类型列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public List <DangerZoneViewModel> GetDangerZone(GetDangerZone request) { using (var db = DbFactory.Open()) { var builder = db.From <DangerZone>(); builder.LeftJoin <DangerZone, ADCDInfo>((x, y) => x.adcd == y.adcd); if (!string.IsNullOrEmpty(request.adcd)) { builder.And(x => x.adcd == request.adcd); } if (!string.IsNullOrEmpty(request.name)) { builder.And(x => x.DangerZoneName.Contains(request.name)); } return(db.Select <DangerZoneViewModel>(builder)); } }
public List <DangerZoneViewModel> Get(GetDangerZone request) { return(DangerZoneManager.GetDangerZone(request)); }