/// <summary> /// 根据药品Id获取药品信息 /// </summary> /// <param name="medicineId"></param> /// <returns></returns> public MedicineListDto GetMedicineInfoById(int medicineId) { var entity = new MedicineListDto(); try { using (var db = SugarDao.GetInstance()) { var list = db.Queryable <Domain.Model.Medicine>() .JoinTable <BasicDictionary>((m, jyfw) => m.JYFWId == jyfw.Id) .JoinTable <BasicDictionary>((m, dw) => m.UnitId == dw.Id) .JoinTable <BasicDictionary>((m, jgfl) => m.JGFLId == jgfl.Id) .JoinTable <BasicDictionary>((m, ypfl) => m.TypeId == ypfl.Id) .JoinTable <BasicDictionary>((m, gys) => m.SupplierId == gys.Id) .Where(" m.Id=" + medicineId) .Select <MedicineListDto>( "m.Id,m.Name,m.NameCode,jyfw.Name as jyfwName,m.CommonName,BZGG BzggName,dw.Name as UnitName,jgfl.Name JgflName,ypfl.Name ypflName,gys.Name gysName,m.CPZC,ypfl.Name as YpflName") .ToList(); if (list != null && list.Any()) { entity = list[0]; } } } catch (Exception) { throw; } return(entity); }
public async Task <IActionResult> GetMedicine(int id) { var medicine = await _medicineRepository.GetMedicine(id); if (medicine == null) { return(NotFound()); } var medicineResult = new MedicineListDto() { Id = medicine.Id, Name = medicine.Name, Description = medicine.Description, Manufacture = medicine.Manufacture, Supplier = medicine.Supplier }; return(Ok(medicineResult)); }