public ActionResult Import(string id) { try { HttpFileCollectionBase files = Request.Files; DataTable dt = CommClass.CreateTB("UserName:System.String,UserID:System.String,UserPwd:System.String,UserPermission:System.String,UserState:System.Int32,Remark:System.String"); string str = NPOIExcel.ImportExcelFile(files, dt, 1, 0); List <M_User> lstUser = new JavaScriptSerializer().Deserialize <List <M_User> >(str); bool iSucc = SQLDBHelperClient.CreateUser().Add(lstUser); if (iSucc) { ViewBag.Succ = "1"; ViewBag.Msg = "数据添加成功!"; return(View()); } else { ViewBag.Succ = "0"; ViewBag.Msg = "数据添加失败!"; return(View()); } } catch (Exception ex) { ViewBag.Succ = "0"; ViewBag.Msg = "数据添加失败!"; return(View()); } }