/// <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));
}
