// GET: 客戶銀行資訊
public ActionResult Index()
{
var model = new CustomerBankInfoListViewModel
{
SearchParameter = new SearchParameterViewModel(),
//CustomerBankInfo = db.客戶銀行資訊.Include(客 => 客.客戶資料).Where(c => c.是否已刪除 == false).OrderBy(x => x.銀行名稱)
CustomerBankInfo = customerBankInfoRepo.All()
};
return(View(model));
}
public ActionResult Index(CustomerBankInfoListViewModel model)
{
//var query = db.客戶銀行資訊.Include(客 => 客.客戶資料).Where(c => c.是否已刪除 == false).AsQueryable();
var query = customerBankInfoRepo.All();
if (!string.IsNullOrWhiteSpace(model.SearchParameter.帳戶名稱))
{
query = query.Where(
x => x.帳戶名稱.Contains(model.SearchParameter.帳戶名稱));
}
if (!string.IsNullOrWhiteSpace(model.SearchParameter.帳戶號碼))
{
query = query.Where(
x => x.帳戶號碼.Contains(model.SearchParameter.帳戶號碼));
}
if (!string.IsNullOrWhiteSpace(model.SearchParameter.銀行名稱))
{
query = query.Where(
x => x.銀行名稱.Contains(model.SearchParameter.銀行名稱));
}
if (model.SearchParameter.銀行代碼 != 0)
{
query = query.Where(
x => x.銀行代碼 == model.SearchParameter.銀行代碼);
}
query = query.OrderBy(x => x.銀行名稱);
var result = new CustomerBankInfoListViewModel
{
SearchParameter = model.SearchParameter,
CustomerBankInfo = query
};
return(View(result));
}
