/// <summary>
        /// 数据导入
        /// </summary>
        /// <param name="FileStram"></param>
        /// <returns></returns>
        public ActionResult DataImport(HttpPostedFileBase file)
        {
            var message = "";
            int Columns = 0;
            //判断是否提交excel文件
            var FileName = file.FileName.Split('.');

            if (file != null && file.ContentLength > 0)
            {
                if (FileName[1] == "xls" || FileName[1] == "xlsx")
                {
                    //首先我们需要导入数据的话第一步其实就是先把excel数据保存到本地中,然后通过Npoi封装的方法去读取已保存的Excel数据

                    string DictorysPath = Server.MapPath("~/Content/ExcelFiles/" + DateTime.Now.ToString("yyyyMMdd"));
                    if (!System.IO.Directory.Exists(DictorysPath))
                    {
                        System.IO.Directory.CreateDirectory(DictorysPath);
                    }

                    file.SaveAs(System.IO.Path.Combine(DictorysPath, file.FileName));

                    //将Excel数据转化为DataTable数据源
                    DataTable       Dt   = NpoiHelper.Import(System.IO.Path.Combine(DictorysPath, file.FileName), FileName[1]);
                    List <UserInfo> list = new List <UserInfo>();

                    for (int i = 0; i < Dt.Rows.Count; i++)
                    {
                        UserInfo U = new UserInfo();
                        //从行索引从1开始,标题除外
                        U.UserName = Dt.Rows[i][0].ToString();
                        U.Sex      = Dt.Rows[i][1].ToString();
                        U.Phone    = Dt.Rows[i][2].ToString();
                        U.Hobby    = Dt.Rows[i][3].ToString();
                        list.Add(U);
                    }

                    //数据全部添加
                    UserEntites.Set <UserInfo>().AddRange(list);
                    Columns = UserEntites.SaveChanges();
                    if (Columns > 0)
                    {
                        message = "导入成功";
                    }
                    else
                    {
                        message = "导入失败";
                    }
                }
                else
                {
                    message = "格式错误";
                }
            }
            else
            {
                message = "未找到需要导入的数据";
            }
            ViewBag.Columns = Columns;
            ViewBag.Message = message;
            return(View());
        }