public ActionResult CustomerExcel(string sheetName, string fileName) { if (String.IsNullOrEmpty(sheetName)) { sheetName = "工作表1"; } if (String.IsNullOrEmpty(fileName)) { fileName = string.Concat(DateTime.Now.ToString("yyyyMMddHHmmss"), ".xlsx"); } var data = CustomerBankRepo.All().Select(p => new { p.銀行名稱, p.銀行代碼, p.分行代碼, p.帳戶名稱, p.帳戶號碼, p.客戶資料.客戶名稱 }); var workbook = new XLWorkbook(); var MymemoryStream = new MemoryStream(); //設置默認Style var style = workbook.Style; style.Font.FontName = "Microsoft YaHei"; style.Font.FontSize = 16; var worksheet = workbook.Worksheets.Add(sheetName); worksheet.Cell(1, 1).Value = "銀行名稱"; worksheet.Cell(1, 2).Value = "銀行代碼"; worksheet.Cell(1, 3).Value = "分行代碼"; worksheet.Cell(1, 4).Value = "帳戶名稱"; worksheet.Cell(1, 5).Value = "帳戶號碼"; worksheet.Cell(1, 6).Value = "客戶名稱"; worksheet.Cell(2, 1).InsertData(data); workbook.SaveAs(MymemoryStream); return(File(MymemoryStream.ToArray(), "application/vnd.ms-excel", fileName)); }
public ActionResult DeleteConfirmed(int id) { 客戶銀行資訊 客戶銀行資訊 = CustomerBankRepo.Find(id); CustomerBankRepo.Delete(客戶銀行資訊); CustomerBankRepo.UnitOfWork.Commit(); return(RedirectToAction("Index")); }
// GET: CustomerBankInformation public ActionResult Index(string Keyword, int page = 1) { var data = CustomerBankRepo.Search(Keyword).Include(p => p.客戶資料); ViewBag.Keyword = Keyword; var Result = data.ToPagedList(page, pageSize); return(View("Index2", Result)); }
public ActionResult Create([Bind(Include = "Id,客戶Id,銀行名稱,銀行代碼,分行代碼,帳戶名稱,帳戶號碼")] 客戶銀行資訊 客戶銀行資訊) { if (ModelState.IsValid) { CustomerBankRepo.Add(客戶銀行資訊); CustomerBankRepo.UnitOfWork.Commit(); return(RedirectToAction("Index")); } ViewBag.客戶Id = new SelectList(CustomerRepo.All(), "Id", "客戶名稱", 客戶銀行資訊.客戶Id); return(View(客戶銀行資訊)); }
// GET: CustomerBankInformation/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } 客戶銀行資訊 客戶銀行資訊 = CustomerBankRepo.Find(id.Value); if (客戶銀行資訊 == null) { return(HttpNotFound()); } return(View(客戶銀行資訊)); }
// GET: CustomerBankInformation/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } 客戶銀行資訊 客戶銀行資訊 = CustomerBankRepo.Find(id.Value); if (客戶銀行資訊 == null) { return(HttpNotFound()); } ViewBag.客戶Id = new SelectList(CustomerRepo.All(), "Id", "客戶名稱", 客戶銀行資訊.客戶Id); return(View(客戶銀行資訊)); }
public ActionResult Search(string Keyword) { var data = CustomerBankRepo.Search(Keyword); return(View("Index", data)); }