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 = CustomerContactRepo.All().Select(p => new { p.職稱, p.姓名, p.Email, 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 = "Email"; 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) { 客戶聯絡人 客戶聯絡人 = CustomerContactRepo.Find(id); CustomerContactRepo.Delete(客戶聯絡人); CustomerContactRepo.UnitOfWork.Commit(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人) { if (ModelState.IsValid) { CustomerContactRepo.Add(客戶聯絡人); CustomerContactRepo.UnitOfWork.Commit(); return(RedirectToAction("Index")); } ViewBag.客戶Id = new SelectList(CustomerRepo.All(), "Id", "客戶名稱", 客戶聯絡人.客戶Id); return(View(客戶聯絡人)); }
// GET: CustomerContact/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } 客戶聯絡人 客戶聯絡人 = CustomerContactRepo.Find(id.Value); if (客戶聯絡人 == null) { return(HttpNotFound()); } return(View(客戶聯絡人)); }
// GET: CustomerContact/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } 客戶聯絡人 客戶聯絡人 = CustomerContactRepo.Find(id.Value); if (客戶聯絡人 == null) { return(HttpNotFound()); } ViewBag.客戶Id = new SelectList(CustomerRepo.All(), "Id", "客戶名稱", 客戶聯絡人.客戶Id); return(View(客戶聯絡人)); }
public ActionResult BatchUpdate(BatchUpdateContactVM[] data) { if (ModelState.IsValid) { foreach (var vm in data) { var Contact = CustomerContactRepo.Find(vm.Id); Contact.職稱 = vm.職稱; Contact.手機 = vm.手機; Contact.電話 = vm.電話; } CustomerContactRepo.UnitOfWork.Commit(); return(RedirectToAction("Index")); } ViewData.Model = CustomerContactRepo.All(); return(View("Index")); }
public ActionResult Search(string Keyword) { var data = CustomerContactRepo.Search(Keyword); return(View("Index", data)); }
// GET: CustomerContact public ActionResult Index() { var data = CustomerContactRepo.All().Include(p => p.客戶資料); return(View(data)); }