public ExamineViewPage ExamineDetail(string id) { Examine ExamineInfo = new Examine(); ExamineViewPage xx = new ExamineViewPage(); ExamineInfo = db.Examine.Find(id); xx.ExamineID = ExamineInfo.ExamineID; xx.CompanyName = ExamineInfo.CompanyName; xx.ExamineName = ExamineInfo.ExamineName; xx.PayCard = ExamineInfo.PayCard; xx.BusinessCard = ExamineInfo.BusinessCard; xx.ExamineState = ExamineInfo.ExamineState; xx.ExamineTime = ExamineInfo.ExamineTime; return(xx); }
public void Add(ExamineViewPage ExamineAdd, string id) { Examine ExamineInfo = new Examine(); var UserInfo = (from b1 in db.UsersInfo where b1.UserID == id select b1.CompanyName).FirstOrDefault();//寻找当前id的数据 ExamineInfo.ExamineID = DateTime.Now.ToString("yyyyMMddHHmmss"); ExamineInfo.ExamineName = ExamineAdd.ExamineName; ExamineInfo.CompanyName = UserInfo.FirstOrDefault().ToString(); ExamineInfo.ExamineState = ExamineState1.ExamineAccept; ExamineInfo.ExamineTime = DateTime.Now; db.Examine.Add(ExamineInfo); db.SaveChanges(); }
public ExamineViewPage Index(string searchString, string Year, int?page) { ExamineViewPage xx = new ExamineViewPage(); var Examine = db.Examine.ToList(); int pageNumber; int pageSizeNum; int ItemNum; int pageNum; if (!String.IsNullOrEmpty(searchString)) { Examine = Examine.Where(s => s.CompanyName.Contains(searchString)).ToList(); } if (!String.IsNullOrEmpty(Year)) { Examine = Examine.Where(s => s.ExamineTime.Value.Year == Convert.ToInt32(Year)).ToList(); } pageSizeNum = 5; //每页显示多少条 ItemNum = Examine.Count(); //数据总数 pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数 if (page == 4) { pageNumber = pageNum; } else { pageNumber = page ?? 1; } Examine = Examine.OrderBy(x => x.ExamineID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList(); xx.aa = Examine; xx.pageNumber = pageNumber; xx.pageNumx = pageNum; xx.ItemNum = ItemNum.ToString(); xx.searchstring = searchString; xx.Year = Year; return(xx); }