//對客戶銀行資訊增加搜尋功能 public ActionResult Search(string submit, string bankName, string account) { var data = custBankRepo.Search(bankName, account); if (submit.Equals("Search")) { return(View("Index", data)); } else { string outputsTime = DateTime.Now.ToString("yyyyMMdd_HHmmss"); ExcelExportHelper excelExportHelper = new ExcelExportHelper(); var exportData = data.Select(s => new 客戶銀行資訊ViewModel() { Id = s.Id, 客戶Id = s.客戶Id, 銀行名稱 = s.銀行名稱, 銀行代碼 = s.銀行代碼, 分行代碼 = s.分行代碼, 帳戶名稱 = s.帳戶名稱, 帳戶號碼 = s.帳戶號碼, 客戶名稱 = s.客戶資料.客戶名稱 }) .ToList(); var memoryStream = excelExportHelper.Stream(exportData); return(File( memoryStream.ToArray(), "application/vnd.ms-excel", $"Export_客戶銀行資訊_{outputsTime}.xlsx")); } }
// GET: 客戶銀行資訊 public ActionResult Index(string searchString) { var 客戶銀行資訊 = repo.Search(searchString); return(View(客戶銀行資訊.ToList())); }
public ActionResult Search(BankSearchViewModel filter) { var result = bankRepo.Search(filter.CustomerName).Include(客 => 客.客戶資料).ToList(); return(View("Index", result)); }
public ActionResult Index(string searchWord) { var list = repo客戶銀行資訊.Search(searchWord); return(View(list)); }
public ActionResult Search(string Keyword) { var data = repo.Search(Keyword); return(View("Index", data)); }
public ActionResult Index(string search) { return(View(repo.Search(search))); }
public ActionResult Search(string bankName) { var 客戶銀行資訊 = repo.Search(bankName); return(View("Index", 客戶銀行資訊)); }
public ActionResult Search(string keyword) { var data = CBIRepo.Search(keyword); return(View("Index", data)); }