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);
}
