// 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()));
}
