public JsonResult UploadMaterialExcel(FormCollection formCtl) { try { HttpPostedFileBase file = Request.Files["dataFile"];//接收客户端传递过来的数据. if (file == null) { return(Json(new { Result = false, Msg = "请选择要上传的Excel文件" }, JsonRequestBehavior.AllowGet)); } else { string errorMsg = string.Empty; ISheet sheet = GetFileSheet(file, out errorMsg); if (errorMsg != string.Empty) { return(Json(new { Result = false, Msg = errorMsg }, JsonRequestBehavior.AllowGet)); } IRow headerRow = sheet.GetRow(1);//第一行为标题行 int rowCount = sheet.LastRowNum; string value = string.Empty; OnSaleEntity cus = new OnSaleEntity(); List <OnSaleList> salesList = new List <OnSaleList>(); for (int i = (sheet.FirstRowNum + 2); i <= rowCount; i++) { IRow row = sheet.GetRow(i); OnSaleList sales = new OnSaleList(); if (row != null) { for (int j = 0; j < headerRow.Cells.Count; j++) { if (row.GetCell(j) != null) { value = GetCellValue(row.GetCell(j)).Trim(); } sales = GetSalesData(sales, value, j); value = string.Empty; } salesList.Add(sales); } } cus.OnSaleList = salesList; string jsonStr = JsonConvert.SerializeObject(cus); return(Json(new { Result = true, Msg = "导入成功", Data = jsonStr }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { Result = false, Msg = ex.Message }, JsonRequestBehavior.AllowGet)); } }
private OnSaleList GetSalesData(OnSaleList sales, string value, int index) { int i = 0; if (index == i++) //门店物料编号 { sales.AppItemId = value; } if (index == i++) //上架名称 { sales.OnSaleName = value; } if (index == i++) //上架单位 { sales.OnSaleUnit = value; } if (index == i++) //上架类别 { sales.OnSaleType = value; } if (index == i++) //上架价格 { sales.OnSalePrice = value; } if (index == i++) //是否上架 { if (value == "是") { sales.IsOnSale = "true"; } else if (value == "否") { sales.IsOnSale = "false"; } else { sales.IsOnSale = value; } } if (index == i++) //备注 { sales.Remark = value; } return(sales); }