问基于另一个表值MVC ASP.NET在表上打印数据

EN

[Login Controller]
Session["PID"] = userDetails.Name;

[Data Controller]
public List<ViblyyKeyy> UserGetKeys(string search, string sort, string sortdir, int skip, int pageSize)
        {

            pidusername = (string)Session["PID"];
            using (LoginDataBaseEntities dc = new LoginDataBaseEntities())
            {
                var v = (from a in dc.ViblyyKeyies
                         where 
                                 a.PIDName == pidusername &&
                                 a.Name.Contains(search) ||
                                 a.PIDName.Contains(search) ||
                                 a.Value.Contains(search) ||
                                 a.ExpirationDate.Contains(search) ||
                                 a.Application.Contains(search) ||
                                 a.Type.Contains(search) ||
                                 a.Environment.Contains(search) ||
                                 a.Comments.Contains(search) &&
                                 a.PIDName == pidusername

                         select a
                                );
                int totalRecord = v.Count();
                v = v.OrderBy(sort + " " + sortdir);
                if (pageSize > 0)
                {
                    v = v.Skip(skip).Take(pageSize);
                }
                return v.ToList();
            }
        }

  public ActionResult UserIndex(int page = 1, string sort = "Id", string sortdir = "desc", string search = "")
        {
            int pageSize = 10;
            int totalRecord = 0;
            if (page < 1) page = 1;
            int skip = (page * pageSize) - pageSize;
            var data = UserGetKeys(search, sort, sortdir, skip, pageSize);
            ViewBag.TotalRows = totalRecord;
            ViewBag.search = search;
            return View(data);
        }