public JsonResult ImportFootprint()
{
HttpPostedFileBase file = Request.Files["file-footprint"];
Stream inputStream = file.InputStream;
t_contactground footprint = new t_contactground();
t_condition condition = new t_condition();
try
{
XSSFWorkbook xSSFWorkbook = new XSSFWorkbook(inputStream);
ISheet sheet = xSSFWorkbook.GetSheetAt(0);
condition.FacilityID = sheet.GetRow(10).GetCell(3).ToString(); //设备编号
condition.TestStandard = sheet.GetRow(15).GetCell(3).ToString(); //试验标准
condition.Pressure = Convert.ToDecimal(sheet.GetRow(15).GetCell(11).NumericCellValue); //气压
condition.Loaded = Convert.ToDecimal(sheet.GetRow(15).GetCell(19).NumericCellValue); //载荷
footprint.t_condition = condition;
footprint.ID = sheet.GetRow(8).GetCell(19).ToString(); //试验编号
footprint.ContactLength = Convert.ToDecimal(sheet.GetRow(23).GetCell(0).NumericCellValue); //接触长度
footprint.ContactWidth = Convert.ToDecimal(sheet.GetRow(23).GetCell(3).NumericCellValue); //接触宽带
footprint.ContactArea = Convert.ToDecimal(sheet.GetRow(23).GetCell(6).NumericCellValue); //接触面积
footprint.NetContactArea = Convert.ToDecimal(sheet.GetRow(23).GetCell(9).NumericCellValue); //净接触面积
footprint.LeftRectangularity = Convert.ToDecimal(sheet.GetRow(23).GetCell(15).NumericCellValue); //左侧矩形率
footprint.RightRectangularity = Convert.ToDecimal(sheet.GetRow(23).GetCell(18).NumericCellValue); //右侧矩形率
//footprintService.Add(footprint);
}
finally
{
inputStream.Close();
}
return(Json(footprint, JsonRequestBehavior.AllowGet));
}
public void FootprintSubmit(t_contactground fp, t_condition cdt)
{
fp.t_condition = cdt;
bool isAdd = footprintService.Add(fp);
}