//對客戶銀行資訊增加搜尋功能
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));
}