在Control 中：
public ActionResult ImportExcel()
{
return View();
}
//客户导入
[HttpPost]
public ActionResult ImportExcel(HttpPostedFileBase importxls)
{
//获取文件和扩展名
var fileName = Path.GetFileName(importxls.FileName);
//获取文件路径地址
var path = Path.Combine(Server.MapPath("~/App_Data/"), fileName);
//获取文件的扩展名
var exname = Path.GetExtension(importxls.FileName).ToLower();
try
{
if (exname == ".xls" || exname == ".xlsx")
{
importxls.SaveAs(path);
var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Path.Combine(Server.MapPath("~/App_Data/"), fileName) + ";Extended Properties=Excel 12.0;");
var adapterbvandrev = new OleDbDataAdapter("select*from[Sheet1$]", connectionString);
var dsimport = new DataSet();
adapterbvandrev.Fill(dsimport);
DataTable dataimport = dsimport.Tables[0];
List<Customer> objectCustomerEntity = new List<Customer>();
for (int i = 0; i < dataimport.Rows.Count; i++)
{
objectCustomerEntity.Add(
new Customer
{
CustomerCode = dataimport.Rows[i]["用户编号"].ToString(),
Company = dataimport.Rows[i]["公司名称"].ToString(),
Contact = dataimport.Rows[i]["联系人"].ToString(),
Tel = dataimport.Rows[i]["联系电话"].ToString(),
Mobile = dataimport.Rows[i]["手机号码"].ToString(),
Address = dataimport.Rows[i]["客户地址"].ToString(),
});
}
SaveData(objectCustomerEntity);
return View();
}
else
{
return Content("<script>alert('请选择Excel文件！');history.go(-1);</script>");
}
}
catch(Exception ex)
{
this.TempData["Message"] = "错误：请检查所导入的Excel格式是否符合要求？" + ex.Message; ;
return View();
}
}
//public bool SaveData(List<Customer> objCustomer)
//{
// try
// {
// CMSContext _db = new CMSContext();
// foreach (var item in objCustomer)
// {
// Customer Customer = new Customer();
// Customer.CustomerCode = item.CustomerCode;
// Customer.Company = item.Company;
// Customer.Contact = item.Contact;
// Customer.Tel = item.Tel;
// Customer.Mobile = item.Mobile;
// Customer.Address = item.Address;
// _db.Customers.Add(Customer);
// _db.SaveChanges();
// }
// this.TempData["Message"] = "恭喜，" + objCustomer.Count().ToString() + "条数据导入成功！";
// return true;
// }
// catch (Exception ex)
// {
// this.TempData["Message"] = "错误：请检查客户编号是否有重复？" + ex.Message;
// return false;
// }
//}
public bool SaveData(List<Customer> customer)
{
try
{
string fmessage = "";
int i = 0;
foreach (var item in customer)
{
var sitem = _db.Customers.SingleOrDefault(s => s.CustomerCode == item.CustomerCode);
if (sitem != null)
{
fmessage += sitem.CustomerCode + " /";
i++;
}
else
{
Customer Customer= new Customer()
{
CustomerCode = item.CustomerCode,
Company = item.Company,
Contact = item.Contact,
Tel = item.Tel,
Mobile = item.Mobile,
Address = item.Address,
};
_db.Customers.Add(Customer);
_db.SaveChanges();
}
}
if (fmessage != "")
this.TempData["Message"] = (customer.Count() - i).ToString() + "条数据导入成功！" + fmessage + "因为编码重复而导入失败！如果不再导入请关闭窗口。";
else
this.TempData["Message"] = customer.Count().ToString() + "条数据导入成功！如果不再导入请关闭窗口。";
return true;
}
catch (Exception ex)
{
this.TempData["Message"] = "导入失败：请检查编码是否符合规范？" + ex.Message;
return false;
}
}
public ActionResult Import
