// GET: 客戶資料
public ActionResult Index(客戶資料篩選條件ViewModel filter, 升降冪排序ViewModel orderfilter)
{
var data = repo客戶資料.get客戶資料_包含篩選條件(filter);
data = repo客戶資料.get客戶資料_升冪降冪排序排序(data, orderfilter);
return(View(data));
}
public IQueryable <客戶資料> Get客戶資料(客戶資料篩選條件ViewModel filte)
{
var result = this.Where(c => c.是否已刪除 == false).OrderByDescending(c => c.Id).AsQueryable();
if (!String.IsNullOrEmpty(filte.keyword))
{
result = result.Where(c => c.客戶名稱.Contains(filte.keyword));
}
if (!String.IsNullOrEmpty(filte.type))
{
result = result.Where(c => c.客戶分類 == filte.type);
}
return(result);
}
public IQueryable <客戶資料> get客戶資料_包含篩選條件(客戶資料篩選條件ViewModel filter)
{
var data = this.All();
if (!string.IsNullOrEmpty(filter.keyword))
{
data = data.Where(p => p.客戶名稱.Contains(filter.keyword));
}
if (!string.IsNullOrEmpty(filter.type))
{
data = data.Where(p => p.客戶分類 == filter.type);
}
return(data);
}
public IQueryable <客戶資料> Get客戶資料_含篩選排序條件(客戶資料篩選條件ViewModel filter, string sortBy = "客戶名稱", bool ascent = true)
{
var data = this.All();
if (!string.IsNullOrEmpty(filter.keyword))
{
data = data.Where(p => p.客戶名稱.Contains(filter.keyword));
}
if (!string.IsNullOrEmpty(filter.Type))
{
data = data.Where(p => p.客戶分類 == filter.Type);
}
data = SortBy(sortBy, ascent, data);
return(data);
}
public ActionResult Index(客戶資料篩選條件ViewModel filter, string sort, bool desc = false)
{
var data = repo.Get客戶資料(filter);
switch (sort)
{
case "客戶名稱":
if (desc)
{
data = data.OrderByDescending(c => c.客戶名稱);
}
else
{
data = data.OrderBy(c => c.客戶名稱);
}
break;
case "統一編號":
if (desc)
{
data = data.OrderByDescending(c => c.統一編號);
}
else
{
data = data.OrderBy(c => c.統一編號);
}
break;
case "電話":
if (desc)
{
data = data.OrderByDescending(c => c.電話);
}
else
{
data = data.OrderBy(c => c.電話);
}
break;
}
return(View(data.ToList()));
}
public ActionResult Index(客戶資料篩選條件ViewModel filter, string sortBy = "CustomerName", bool ascent = true)
{
var data = repo.Get客戶資料_含篩選排序條件(filter, sortBy, ascent);
return(View(data.ToList()));
}
