public List<MatExcel> InputMaterialByPurPriceAndLeadTimeExcel(HttpPostedFileBase ExcelFile, Guid LinkMainCID)
        {
            MyNormalUploadFile MF = new MyNormalUploadFile();
            //创建上传文件
            string ExcelFilePath = MF.NormalUpLoadFileProcess(ExcelFile, "Excel");

            //根据路径通过已存在的excel来创建HSSFWorkbook,即整个excel文档
            XSSFWorkbook workbook = new XSSFWorkbook(new FileStream(HttpRuntime.AppDomainAppPath.ToString() + ExcelFilePath, FileMode.Open, FileAccess.Read));

            //获取excel的第一个sheet
            ISheet sheet = workbook.GetSheetAt(0);

            List<MatExcel> ML = new List<MatExcel>();
            MatExcel M = new MatExcel();

            int Seconds = 0;

            for (int i = sheet.FirstRowNum; i <= sheet.LastRowNum; i++)
            {
                Seconds = Seconds + 1;
                IRow row = sheet.GetRow(i);
                M = M = new MatExcel();

                try
                {
                    M.MatID = new Guid(row.GetCell(0).ToString().Trim());
                }
                catch
                {
                    M.MatID = Guid.Empty;
                }

                try
                {
                    M.MatSn = row.GetCell(2).ToString().Trim();
                }
                catch
                {
                    M.MatSn = string.Empty;
                }

                try
                {
                    M.MatName = row.GetCell(3).ToString().Trim();
                }
                catch
                {
                    M.MatName = string.Empty;
                }

                try
                {
                    M.MatSpecifications = row.GetCell(4).ToString().Trim();
                }
                catch
                {
                    M.MatSpecifications = string.Empty;
                }

                try
                {
                    M.MatBrand = row.GetCell(5).ToString().Trim();
                }
                catch
                {
                    M.MatBrand = string.Empty;
                }

                try
                {
                    M.MatManufacturerSn = row.GetCell(6).ToString().Trim();
                }
                catch
                {
                    M.MatManufacturerSn = string.Empty;
                }

                try
                {
                    M.MatUnit = row.GetCell(7).ToString().Trim();
                }
                catch
                {
                    M.MatUnit = string.Empty;
                }

                try
                {
                    M.CostPrice = Convert.ToDecimal(row.GetCell(8).ToString().Trim());
                }
                catch
                {
                    M.CostPrice = 0;
                }

                try
                {
                    M.MarketPrice = Convert.ToDecimal(row.GetCell(9).ToString().Trim());
                }
                catch
                {
                    M.MarketPrice = 0;
                }

                try
                {
                    M.LeadTime = Convert.ToInt32(row.GetCell(10).ToString().Trim());
                }
                catch
                {
                    M.LeadTime = 0;
                }

                try
                {
                    M.SupplierName = row.GetCell(11).ToString().Trim();
                }
                catch
                {
                    M.SupplierName = string.Empty;
                }

                M.IsErrorMatInfo = 0;
                M.IsErrorMatSn = 0;

                if (Seconds > 1 && Seconds <= 4001 && M.MatID != Guid.Empty && !string.IsNullOrEmpty(M.MatName))
                {
                    ML.Add(M);
                }
            }
            return ML;
        }
        public void InputMaterialByExcel(HttpPostedFileBase ExcelFile, Guid LinkMainCID)
        {
            MyNormalUploadFile MF = new MyNormalUploadFile();
            //创建上传文件
            string ExcelFilePath = MF.NormalUpLoadFileProcess(ExcelFile, "Excel");

            //根据路径通过已存在的excel来创建HSSFWorkbook,即整个excel文档
            XSSFWorkbook workbook = new XSSFWorkbook(new FileStream(HttpRuntime.AppDomainAppPath.ToString() + ExcelFilePath, FileMode.Open, FileAccess.Read));

            //获取excel的第一个sheet
            ISheet sheet = workbook.GetSheetAt(0);

            List<MatExcel> ML = new List<MatExcel>();
            MatExcel M = new MatExcel();

            int Seconds = 0;

            for (int i = sheet.FirstRowNum; i <= sheet.LastRowNum; i++)
            {
                Seconds = Seconds + 1;
                IRow row = sheet.GetRow(i);
                M = M = new MatExcel();

                try
                {
                    M.MatSn = row.GetCell(0).ToString().Trim();
                }
                catch
                {
                    M.MatSn = string.Empty;
                }

                try
                {
                    M.MatName = row.GetCell(1).ToString().Trim();
                }
                catch
                {
                    M.MatName = string.Empty;
                }

                try
                {
                    M.MatSpecifications = row.GetCell(2).ToString().Trim();
                }
                catch
                {
                    M.MatSpecifications = string.Empty;
                }

                try
                {
                    M.MatManufacturerSn = row.GetCell(3).ToString().Trim();
                }
                catch
                {
                    M.MatManufacturerSn = string.Empty;
                }

                try
                {
                    M.MatBrand = row.GetCell(4).ToString().Trim();
                }
                catch
                {
                    M.MatBrand = string.Empty;
                }

                try
                {
                    M.MatBrandType = row.GetCell(5).ToString().Trim();
                }
                catch
                {
                    M.MatBrandType = string.Empty;
                }

                try
                {
                    M.MatUnit = row.GetCell(6).ToString().Trim();
                }
                catch
                {
                    M.MatUnit = string.Empty;
                }

                try
                {
                    M.CostPrice = Convert.ToDecimal(row.GetCell(7).ToString().Trim());
                }
                catch
                {
                    M.CostPrice = 0;
                }

                try
                {
                    M.MarketPrice = Convert.ToDecimal(row.GetCell(8).ToString().Trim());
                }
                catch
                {
                    M.MarketPrice = 0;
                }

                try
                {
                    M.LeadTime = Convert.ToInt32(row.GetCell(9).ToString().Trim());
                }
                catch
                {
                    M.LeadTime = 0;
                }

                try
                {
                    M.MatSummary = row.GetCell(10).ToString().Trim();
                }
                catch
                {
                    M.MatSummary = string.Empty;
                }

                if (Seconds > 1 && Seconds <= 1001 && !string.IsNullOrEmpty(M.MatName) && !string.IsNullOrEmpty(M.MatUnit) && !string.IsNullOrEmpty(M.MatBrand))
                {
                    ML.Add(M);
                }
            }

            ////删除持久化内容
            try {
                db.MatExcelDB.Remove(db.MatExcelDB.Find(LinkMainCID));
                db.SaveChanges();
            }
            catch
            {
                //Dothing
            }

            //存储进入持久化Json数据
            string JSONStr = JsonConvert.SerializeObject(ML);
            MatExcelDB MExcel = new MatExcelDB();
            MExcel.LinkMainCID = LinkMainCID;
            MExcel.MatListJson = JSONStr;
            db.MatExcelDB.Add(MExcel);
            db.SaveChanges();
        }