public void Add(MSDS_Substance_ExposureLimit entity)
{
if (_context.MSDS_Substance_ExposureLimit.Any(x => x.CASCode == entity.CASCode))
{
throw new Exception("该CAS号已经存在");
}
_context.MSDS_Substance_ExposureLimit.Add(entity);
}
public void Add(MSDS_Substance_ExposureLimit entity)
{
_repository.Add(entity);
}
private IList <MSDS_Substance_ExposureLimit> ReadExcel(Stream stream, Guid id)
{
try
{
List <MSDS_Substance_ExposureLimit> list = new List <MSDS_Substance_ExposureLimit>();
using (var xlPackage = new ExcelPackage(stream))
{
int k = 1;
for (char i = 'A'; i <= 'Z'; i++)
{
var worksheet = xlPackage.Workbook.Worksheets[i.ToString()];
if (worksheet == null)
{
continue;
}
int totalAmount = worksheet.Cells.Rows;
for (int rowIndex = 1; rowIndex <= totalAmount; rowIndex++)
{
if (rowIndex >= 4)
{
#region
MSDS_Substance_ExposureLimit item = new MSDS_Substance_ExposureLimit();
item.Id = Guid.NewGuid();
item.Substance_Name = worksheet.Cells[rowIndex, 1].Value?.ToString();
item.Substance_CN_Name = worksheet.Cells[rowIndex, 2].Value?.ToString();
item.CASCode = worksheet.Cells[rowIndex, 3].Value?.ToString();
if (string.IsNullOrEmpty(item.Substance_Name) && string.IsNullOrEmpty(item.CASCode) && string.IsNullOrEmpty(item.Substance_CN_Name))
{
break;
}
else if (string.IsNullOrEmpty(item.Substance_Name) || string.IsNullOrEmpty(item.CASCode))
{
continue;
}
item.WorkSafe_NZ_TWA_PPM = worksheet.Cells[rowIndex, 4].Value?.ToString();
item.WorkSafe_NZ_TWA_MG = worksheet.Cells[rowIndex, 5].Value?.ToString();
item.WorkSafe_NZ_STEL_PPM = worksheet.Cells[rowIndex, 6].Value?.ToString();
item.WorkSafe_NZ_STEL_MG = worksheet.Cells[rowIndex, 7].Value?.ToString();
item.WorkSafe_AUS_TWA_PPM = worksheet.Cells[rowIndex, 8].Value?.ToString();
item.WorkSafe_AUS_TWA_MG = worksheet.Cells[rowIndex, 9].Value?.ToString();
item.WorkSafe_AUS_STEL_PPM = worksheet.Cells[rowIndex, 10].Value?.ToString();
item.WorkSafe_AUS_STEL_MG = worksheet.Cells[rowIndex, 11].Value?.ToString();
item.GBZ_TWA = worksheet.Cells[rowIndex, 12].Value?.ToString();
item.GBZ_STEL = worksheet.Cells[rowIndex, 13].Value?.ToString();
item.GBZ_MAC = worksheet.Cells[rowIndex, 14].Value?.ToString();
item.ACGIH_TLV_TWA_PPM = worksheet.Cells[rowIndex, 15].Value?.ToString();
item.ACGIH_TLV_TWA_MG = worksheet.Cells[rowIndex, 16].Value?.ToString();
item.ACGIH_TLV_STEL_PPM = worksheet.Cells[rowIndex, 17].Value?.ToString();
item.ACGIH_TLV_STEL_MG = worksheet.Cells[rowIndex, 18].Value?.ToString();
item.HSE_UK_EH40_TWA_PPM = worksheet.Cells[rowIndex, 19].Value?.ToString();
item.HSE_UK_EH40_TWA_MG = worksheet.Cells[rowIndex, 20].Value?.ToString();
item.HSE_UK_EH40_STEL_PPM = worksheet.Cells[rowIndex, 21].Value?.ToString();
item.HSE_UK_EH40_STEL_MG = worksheet.Cells[rowIndex, 22].Value?.ToString();
item.Molecular_Weight = worksheet.Cells[rowIndex, 23].Value?.ToString();
item.ERPG1 = worksheet.Cells[rowIndex, 24].Value?.ToString();
item.ERPG2 = worksheet.Cells[rowIndex, 25].Value?.ToString();
item.ERPG3 = worksheet.Cells[rowIndex, 26].Value?.ToString();
item.AEGL1_60 = worksheet.Cells[rowIndex, 27].Value?.ToString();
item.AEGL2_60 = worksheet.Cells[rowIndex, 28].Value?.ToString();
item.AEGL3_60 = worksheet.Cells[rowIndex, 29].Value?.ToString();
item.TEEL0 = worksheet.Cells[rowIndex, 30].Value?.ToString();
item.TEEL1 = worksheet.Cells[rowIndex, 31].Value?.ToString();
item.TEEL2 = worksheet.Cells[rowIndex, 32].Value?.ToString();
item.TEEL3 = worksheet.Cells[rowIndex, 33].Value?.ToString();
item.IDLH = worksheet.Cells[rowIndex, 34].Value?.ToString();
item.Cancerogen_IARC = worksheet.Cells[rowIndex, 35].Value?.ToString();
item.Cancerogen_NTP = worksheet.Cells[rowIndex, 36].Value?.ToString();
item.Cancerogen_ACGIH = worksheet.Cells[rowIndex, 37].Value?.ToString();
item.Cancerogen_CP65 = worksheet.Cells[rowIndex, 38].Value?.ToString();
item.Cancerogen_OSHA = worksheet.Cells[rowIndex, 39].Value?.ToString();
item.Cancerogen_EPA = worksheet.Cells[rowIndex, 40].Value?.ToString();
item.Teratogenesis = worksheet.Cells[rowIndex, 41].Value?.ToString();
item.Reproduction_Toxicity = worksheet.Cells[rowIndex, 42].Value?.ToString();
item.ER_NA = worksheet.Cells[rowIndex, 43].Value?.ToString();
item.ER_CN = worksheet.Cells[rowIndex, 44].Value?.ToString();
item.Catalog = worksheet.Cells[rowIndex, 45].Value?.ToString();
list.Add(item);
#endregion
}
}
lock (syncRoot)
{
ProcessStatus[id] = (double)(k * 100 / 26);
}
k++;
}
stream.Close();
stream.Dispose();
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
