public ActionResult SaveAndReadFile()
        {
            Result <int> result = new Result <int>();
            List <int>   list   = new List <int>();

            try
            {
                List <Epm_TzSupMatManagement> supList = new List <Epm_TzSupMatManagement>();

                HttpPostedFileBase file = Request.Files[0];
                var fileName            = file.FileName;
                //判断目录是否存在,不存在创建
                if (!Directory.Exists(ImportOrExportPath))
                {
                    DirectoryInfo directoryInfo = new DirectoryInfo(ImportOrExportPath);
                    directoryInfo.Create();
                }
                //将文件重新命名,保证唯一性
                string pathFile = ImportOrExportPath + "success_" + DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetExtension(fileName);
                //将上传的文件保存
                file.SaveAs(pathFile);
                //方式一:创建数据表
                DataTable dt = ExcelHelperNew.ExcelToTable(pathFile);
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    //供应商名称、电话、联系人、地址
                    string supplierName = dt.Rows[i]["供应商名称*"].ToString();
                    if (string.IsNullOrEmpty(supplierName))
                    {
                        list.Add(i);
                        continue;
                    }
                    string supplierTel      = dt.Rows[i]["供应商电话"].ToString();
                    string supplierContacts = dt.Rows[i]["供应商联系人"].ToString();
                    string supplierAddress  = dt.Rows[i]["供应商地址*"].ToString();
                    if (string.IsNullOrEmpty(supplierAddress))
                    {
                        list.Add(i);
                        continue;
                    }
                    //甲供物资种类、规格、品名、单价
                    string materialCategory = dt.Rows[i]["物资种类*"].ToString();
                    if (string.IsNullOrEmpty(materialCategory))
                    {
                        list.Add(i);
                        continue;
                    }
                    string specification = dt.Rows[i]["规格*"].ToString();
                    if (string.IsNullOrEmpty(specification))
                    {
                        list.Add(i);
                        continue;
                    }
                    string productName = dt.Rows[i]["品名*"].ToString();
                    if (string.IsNullOrEmpty(productName))
                    {
                        list.Add(i);
                        continue;
                    }
                    string unitePrice = dt.Rows[i]["单价*"].ToString();
                    if (string.IsNullOrEmpty(unitePrice))
                    {
                        list.Add(i);
                        continue;
                    }
                    //数据转换model
                    Epm_TzSupMatManagement model = new Epm_TzSupMatManagement();
                    model.SupplierName     = supplierName;
                    model.SupplierTel      = supplierTel;
                    model.SupplierContacts = supplierContacts;
                    model.SupplierAddress  = supplierAddress;
                    model.MaterialCategory = materialCategory;
                    model.Specification    = specification;
                    model.ProductName      = productName;
                    model.UnitePrice       = unitePrice.ToDecimalReq();
                    using (ClientSiteClientProxy proxy = new ClientSiteClientProxy(ProxyEx(Request)))
                    {
                        //根据供应商名称查询对应供应商,获取ID
                        Result <Base_Company> resultModel = proxy.GetCompanyByName(supplierName);
                        //关联供应商ID
                        if (resultModel.Flag == EResultFlag.Success && resultModel.Data != null)
                        {
                            var supplierId = resultModel.Data.Id;

                            //批量做重复物资判断(同一供应商、同一物资、同一规格、同一品名的物资只能存在一条数据)
                            var modelInfo = proxy.GetTzSupMatManagementModelBy(supplierId, model.MaterialCategory, model.ProductName, model.Specification);
                            if (modelInfo.Flag == EResultFlag.Success && modelInfo.Data != null)
                            {
                                list.Add(i);
                                continue;
                            }
                            else
                            {
                                model.SupplierId = supplierId;
                                supList.Add(model);
                            }
                        }
                        else
                        {
                            list.Add(i);
                            continue;
                        }
                    }
                }

                if (supList.Count > 0)
                {
                    using (ClientSiteClientProxy proxy = new ClientSiteClientProxy(ProxyEx(Request)))
                    {
                        var rows = proxy.AddRangeTzSupMatManagement(supList);

                        result.Data = rows.Data;
                        result.Flag = EResultFlag.Success;
                    }
                }
                string errorPath = "";
                //导入数据异常时,记录错误信息进行导出,方便客户下次修改,再次执行导入。
                if (list.Count > 0)
                {
                    //待导出文件路径,将文件重新命名,保证唯一性
                    errorPath = ImportOrExportPath + "failure_" + DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetExtension(fileName);
                    //导出失败的Excel文档
                    ExcelHelperNew.TableToExcel(dt, errorPath, list);
                }

                return(Json(new
                {
                    Data = result.Data,
                    Flag = result.Flag,
                    failureCount = list.Count,                 //导入失败条数
                    successCount = dt.Rows.Count - list.Count, //导入成功条数
                    download = errorPath,                      //失败文件下载链接
                    fileName = Path.GetFileName(errorPath)
                }));
            }
            catch (Exception ex)
            {
                result.Data      = -1;
                result.Flag      = EResultFlag.Failure;
                result.Exception = new ExceptionEx(ex, "导入程序异常:" + ex.Message);
            }
            return(Json(result.ToResultView()));
        }