// GET: 客戶資料 public ActionResult Index(string keyword, string catego) { var data = repo.GetList(keyword, catego); /* * var data = db.客戶資料.Where(p => false == p.是否已刪除).AsQueryable(); * if (!String.IsNullOrEmpty(keyword)) * { * data = data.Where(p => p.客戶名稱.Contains(keyword)); * } */ var selectItemList = new List <SelectListItem>() { new SelectListItem() { Value = "", Text = "全部", Selected = true } }; var selectList = new SelectList(repoCatego.All(), "分類ID", "客戶分類名稱"); selectItemList.AddRange(selectList); ViewBag.客戶分類 = selectItemList; ViewBag.keyword = keyword; ViewBag.catego = catego; return(View(data.ToList())); }
public ActionResult Index(string search1, int?DPClass, int page = 1) { var options = ClassRepo.All().ToList(); ViewBag.DPClass = new SelectList(options, "Id", "ClassName"); int currentPage = page < 1 ? 1 : page; var data = repo.GetAllDataOrderById(search1, DPClass, page); var result = data.ToPagedList(currentPage, pageSize); return(View(result)); }
// GET: Customers public ActionResult Index() { var data = customerRepo.All().Include(x => x.客戶分類1).ToList(); ViewBag.Category = new SelectList(categoryRepo.All(), "Id", "分類名稱"); return(View(data)); }
public ActionResult Index(string searchString) { var datas = repo.All(); if (!String.IsNullOrEmpty(searchString)) { datas = datas.Where(p => p.客戶分類名稱.Contains(searchString)); } return(View(datas)); }
public ActionResult Index(string sortOrder, string searchString, int?客戶分類Id) { ViewData["sortOrder"] = sortOrder; ViewBag.客戶分類Id = new SelectList(repoCategory.All(), "Id", "客戶分類名稱"); var datas = repo.All(); if (!String.IsNullOrEmpty(searchString)) { datas = datas.Where(p => p.客戶名稱.Contains(searchString)); } if (客戶分類Id.HasValue) { datas = datas.Where(p => p.客戶分類Id == 客戶分類Id); } switch (sortOrder) { case "客戶名稱_desc": datas = datas.OrderByDescending(p => p.客戶名稱); break; case "統一編號_desc": datas = datas.OrderByDescending(p => p.統一編號); break; case "統一編號": datas = datas.OrderBy(p => p.統一編號); break; case "電話_desc": datas = datas.OrderByDescending(p => p.電話); break; case "電話": datas = datas.OrderBy(p => p.電話); break; case "傳真_desc": datas = datas.OrderByDescending(p => p.傳真); break; case "傳真": datas = datas.OrderBy(p => p.傳真); break; case "地址_desc": datas = datas.OrderByDescending(p => p.地址); break; case "地址": datas = datas.OrderBy(p => p.地址); break; case "Email_desc": datas = datas.OrderByDescending(p => p.Email); break; case "Email": datas = datas.OrderBy(p => p.Email); break; default: datas = datas.OrderBy(s => s.客戶名稱); break; } return(View(datas)); }
// GET: Categories public ActionResult Index() { return(View(categoryRepo.All().ToList())); }