C# (CSharp) SchedureEntities.SP_BacSi_GetByPhongBan_Id示例

示例#1

 public List <DoctorDTO> GetDoctorByPhongKham(int id)
 {
     return(db.SP_BacSi_GetByPhongBan_Id(id).Select(q => new DoctorDTO
     {
         FullName = q.TenNhanVien,
         IDDoctor = q.NhanVien_Id,
         LichLamViecs = null,
         PhongBan = new PhongBanDTO
         {
             ChuyenKhoa = new ChuyenKhoaDTO
             {
                 Name = q.Name,
                 IDChuyenKhoa = q.IDChuyenKhoa,
                 Status = q.ChuyenKhoa_Status,
             },
             IDChuyenKhoa = q.IDChuyenKhoa,
             PhongBan_Id = q.PhongBan_Id,
             Status = q.PhongBan_Status,
             IDPhongBan = q.IDPhongBan,
             TenPhongBan = q.TenPhongBan,
         }
     }).OrderBy(q => q.FullName).ToList());
 }