as.net MVC模式 导入EXCEL文档

<%  using (Html.BeginForm("XXX", "Account", FormMethod.Post, new { enctype = "multipart/form-data" }))
        {%>
        <div class="content">
        <label  >请选择要导入的数据文件:</label> <input type="file" name="FileUpload1" /> 
        <input type="submit" name="Submit" id="Submit" value="确定" />
    </div>
    
    <% }%>
    <%if (ViewData["ErrorMsg"] != null)
      { %>
      <div class="content" style="color:Red"><%=ViewData["ErrorMsg"].ToString()%></div>
      <%} %>
        <table class="content">
            <tr>
                <td style="border-bottom:1px solid #bdd2ed; border-right:1px solid #bdd2ed;border-top:1px solid #bdd2ed;">
                    XX名
                </td>
                <td style="border-bottom:1px solid #bdd2ed; border-right:1px solid #bdd2ed;border-top:1px solid #bdd2ed;">
                    是否成功
                </td>
                <td style="border-bottom:1px solid #bdd2ed; border-right:1px solid #bdd2ed;border-top:1px solid #bdd2ed;">
                    说明
                </td>
            </tr>
            <% if (ViewData["returnUserInfo"] != null)
               {
                   List<GTA.MS.NNU.Web.XH.Models.BatchOpenUM_UserInfo> retnInfo = (List<GTA.MS.NNU.Web.XH.Models.BatchOpenUM_UserInfo>)ViewData["returnUserInfo"];
                   foreach (var item in retnInfo)
                   { 
            %>
            <tr>
                <td  style="border-bottom:1px solid #bdd2ed; border-right:1px solid #bdd2ed;">
                    <%: Html.Label( item.LoginName) %>
                </td>
                <td  style="border-bottom:1px solid #bdd2ed; border-right:1px solid #bdd2ed;">
                    <%: Html.Label( item.IsSuccess?"成功":"失败")%>
                </td>
                <td  style="border-bottom:1px solid #bdd2ed; border-right:1px solid #bdd2ed;">
                    <%: Html.Label( item.Message)%>
                </td>
            </tr>
            <%  }%>
            <%  } %>
        </table> 

        #region Oledb方式读取EXCEL
        /// <summary>
        /// Oledb方式读取EXCEL
        /// </summary>
        /// <param name="fileNamePath">文件路径</param>
        /// <returns></returns>
        private DataTable ReadExcelByOledb(string fileNamePath)
        {
            string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;data source=" + fileNamePath;
//只读第一个表
            OleDbConnection oledbconn1 = new OleDbConnection(connStr);
            oledbconn1.Open();
            DataTable _table = oledbconn1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

            string strTableName = string.Empty;
            if (_table.Rows.Count > 0)
            {
                strTableName = _table.Rows[0]["TABLE_NAME"].ToString().Trim();
                string sql = string.Format("SELECT * FROM [{0}]", strTableName);
                _table = new DataTable();
                OleDbDataAdapter da = new OleDbDataAdapter(sql, oledbconn1);
                da.Fill(_table);
            }
            oledbconn1.Close();
            return _table;
        }
        #endregion

  
        public ActionResult BatchAddAccount()
        {
            return View();
        }

        [RequiresAuthenticationAttribute]
        [HttpPost]
        public ActionResult BatchAddAccount(object obj)
        {
            string error = string.Empty;
            List<BatchOpenUserInfo> returnUserInfo = new List<BatchOpenUserInfo>();
            ViewData["returnUserInfo"] = returnUserInfo;
            ViewData["ErrorMsg"] = "";
            DataTable contactTable; 
            try
            {
                foreach (string upload in Request.Files)
                {
                    if (upload != null && upload.Trim() != "")
                    {
                        string path = AppDomain.CurrentDomain.BaseDirectory + "TempData\\";
                        if (!Directory.Exists(path))
                        {
                            Directory.CreateDirectory(path);
                        }
                        System.Web.HttpPostedFileBase postedFile = Request.Files[upload];
                        string filename = Path.GetFileName(postedFile.FileName);
                        if (filename.Length > 4)
                        {
                            string strExName = filename.Substring(filename.Length - 4, 4);
                            if (strExName.ToLower() != ".xls")
                            {
                                error = "文件类型不正确，请重新操作";
                                ViewData["ErrorMsg"] = error;
                                //return View();
                            }
                            else
                            {
                                //string filePath = Path.Combine(path, filename);
                                string fileNamePath = path + DateTime.Now.Ticks.ToString() + ".xls";
                                postedFile.SaveAs(fileNamePath);

                                string fileExtension;
                                fileExtension = System.IO.Path.GetExtension(filename);
                                string FileType = postedFile.ContentType.ToString();//获取要上传的文件类型,验证文件头  

                                //在上传文件不为空的情况下，验证文件名以及大小是否符合，如果不符合则不允许上传
                                if (postedFile.ContentLength / 1024 <= 5120)
                                { //在这里通过检查文件头与文件名是否匹配 从而限制了文件上传类型  注：可上传的类型有XLS，且大小只能为5M一下
                                     
                                    contactTable = ReadExcelByOledb(fileNamePath);
                                    int i = contactTable.Rows.Count;
                                    bool success = true;
                                    string msg = string.Empty;
                                    UserInfo userInfo;

                                    List<ProfessionClass> ProfessionList = GetAllProfession();
                                    List<ProfessionClass> ClassList =  GetAllProfession();
                                    if (contactTable.Rows.Count > 1000)
                                    {
                                        error = "导入数据不能大于1000条！";
                                        ViewData["ErrorMsg"] = error;
                                    }
                                    else
                                    {
                                        foreach (DataRow item in contactTable.Rows)
                                        {
                                            userInfo = new Management.BLL.Common.Model.UM_UserInfo();
                                            success = CheckValue(item[0], CheckType.StringEnChNumber, 20, 0, out msg, "登录名");
                                            if (success) { success = CheckValue(item[1], CheckType.StringEnNumber, 20, 0, out msg, "密码"); }
                                            if (success) { success = CheckValue(item[2], CheckType.StringEnChNumber, 16, 0, out msg, "专业"); }
                                            if (success) { success = CheckValue(item[3], CheckType.StringEnChNumber, 16, 0, out msg, "班级"); }
                                            
                                            userInfo.LoginName = item[0].ToString();
                                            if (success)
                                            {
                                                userInfo.Password = item[1].ToString();
                                                userInfo.ProfessionalID = FindProfessionIdByName(ProfessionList, item[2].ToString());
                                                userInfo.ClassID = FindClassIdByName(ClassList, item[3].ToString());
                                                if (userInfo.ProfessionalID == 0)
                                                {
                                                    msg = "系统中不存在此专业：" + item[2].ToString() + "！";
                                                    success = false;
                                                }
                                                else
                                                {
                                                    if (userInfo.ClassID == 0)
                                                    {
                                                        msg = "系统中不存在此班级：" + item[3].ToString() + "！";
                                                        success = false;
                                                    }
                                                    else
                                                    {
                                                        success = CreateAccount(userInfo, out msg);
                                                    }
                                                }
                                            }
                                            returnUserInfo.Add(new BatchOpenUserInfo()
                                            {
                                                LoginName = userInfo.LoginName,
                                                IsSuccess = success,
                                                Message = msg
                                            });
                                        }
                                    } 
                                }
                                else
                                {
                                    error = "数据文件过大，请重新操作";
                                    ViewData["ErrorMsg"] = error;
                                    //return View();
                                }
                            }
                        }
                        else
                        {
                            error = "请选择需要导入的文件！";
                            ViewData["ErrorMsg"] = error;
                            //return View();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ViewData["ErrorMsg"] = ex.Message;
            } 
            //return Json(returnUserInfo);
            ViewData["returnUserInfo"] = returnUserInfo;
            return View();
        }