连接名字和姓氏MVC5

本文关键字：MVC5 连接 | 更新日期: 2023-09-27 18:12:24

我是c#和MVC的新手，我试图将姓和名一起显示为"全名"。下面的代码试图显示病人的全名(他是一个用户)

public class ApplicationUser : IdentityUser
{
    [Display(Name = "First Name")]
    public string FirstName { get; set; }
    [Display(Name = "Last Name")]
    public string LastName { get; set; }
     public string FullName
        {
      get
      {
           return FirstName + " " + LastName;
      }

My Booking Model:

public class Booking
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public Guid BookingId { get; set; }
    [ForeignKey("Patient")]
    public Guid PatientId { get; set; }
    public virtual Patient Patient { get; set; }
    }

订票视图模型:

public class BookingViewModel
{
    [Display (Name = "Select Patient")]
    public Guid PatientId { get; set; }
    public IEnumerable<SelectListItem> PatientList { get; set; }
}

控制器:

 public ActionResult Create()
    {
        // Creates a new booking
        BookingViewModel bookingViewModel = new BookingViewModel();
        // Initilises Select List
        ConfigureCreateViewModel(bookingViewModel);
        return View(bookingViewModel);
    }
    
    // Initilises Select List 
    public void ConfigureCreateViewModel(BookingViewModel bookingViewModel)
    {
       
        // Displays Patients name 
        bookingViewModel.PatientList = db.Patients.Select(p => new SelectListItem()
        {
            Value = p.PatientId.ToString(),
            Text = p.User.FullName
        });
        }
     
    // Allows Admin to create booking for patient 
    // POST: Bookings1/Create
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult Create(BookingViewModel bookingViewModel)
    {
                  
        // if model state is not valid
        if (!ModelState.IsValid)
        {
            // Initilises Select lists
            ConfigureCreateViewModel(bookingViewModel);
            return View(bookingViewModel); // returns user to booking page

        }
        else // if model state is Valid
        {
            
            
            booking.PatientId = bookingViewModel.PatientId;
           
            booking.BookingId = Guid.NewGuid();
            // Adds booking to database
            db.Bookings.Add(booking);
            // Saves changes to Database
            db.SaveChanges();
            // Redirects User to Booking Index
            return RedirectToAction("Index");
        }
    }

我的观点:

 <div class="form-group">
        @Html.LabelFor(model => model.PatientId, new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.DropDownListFor(model => model.PatientId, Model.PatientList, "-Please select-", new { @class = "form-control" })
            @Html.ValidationMessageFor(model => model.PatientId, "", new { @class = "text-danger" })
        </div>
    </div>

但是会抛出以下错误:

类型为'System '的异常。在EntityFramework.SqlServer.dll中发生NotSupportedException'，但未在用户代码中处理

附加信息:在LINQ to Entities中不支持指定的类型成员'FullName'。只支持初始化式、实体成员和实体导航属性。

任何帮助都将非常感激，谢谢

连接名字和姓氏MVC5

我相信你需要修改你的代码:

bookingViewModel.PatientList = db.Patients.Select(p => new SelectListItem()
        {
            Value = p.PatientId.ToString(),
            Text = p.User.FirstName + " " + p.User.LastName
        });

这种类型的错误的原因是，实体框架不知道如何映射"FullName"时，它是建立SQL查询。更详细的描述请参见以下答案:

指定类型成员'UsersCount'

尝试将[NotMapped]属性添加到您的计算属性中以避免此问题。

       string Employee=a.EmployeeId!=null ? UowObj.EmployeeRepository.GetAllDate().where(x=>x.ID==a.EmployeeId).
Select(c=>c.FirstName+" "+c.MiddleName+" "+c.LastName).FirstOrDefault():"",
相关文章：