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));
}
