private void FillSummaryGraphDataRow(ExcelWorksheet ws, int rowIndex, DX_GetAssayReportSummary_Result item)
{
FillSummaryDataRow(ws, rowIndex, item);
for (int i = 1; i <= 12; i++)
{
for (int j = rowIndex; j <= rowIndex + 19; j++)
{
var cell = ws.Cells[j, i];
SetBorderStyle(cell.Style.Border, EXCEL_BORDER_COLOR);
}
ws.Cells[rowIndex, i, rowIndex + 19, i].Merge = true;
}
AddImage(ws, rowIndex, 11, string.Format(Utility.GetAPPSettingKey("GraphImageURL"), item.AssayID), 250, 750);
//AddImage(ws, rowIndex, 11, string.Format(Utility.GetAPPSettingKey("GraphImageURL"), item.AssayID), 252, 252);
}
private void FillSummaryDataRow(ExcelWorksheet ws, int rowIndex, DX_GetAssayReportSummary_Result item)
{
int colIndex = 1;
SetCellValue(ws, rowIndex, colIndex, item.CompoundName, ExcelHorizontalAlignment.Left);
SetCellValue(ws, rowIndex, ++colIndex, item.ProjectID, ExcelHorizontalAlignment.Left);
SetCellValue(ws, rowIndex, ++colIndex, item.AssayName, ExcelHorizontalAlignment.Left);
SetCellValue(ws, rowIndex, ++colIndex, item.AssayFormat, ExcelHorizontalAlignment.Left);
SetCellValue(ws, rowIndex, ++colIndex, item.AssayTarget, ExcelHorizontalAlignment.Left);
SetCellValue(ws, rowIndex, ++colIndex, item.ResultType, ExcelHorizontalAlignment.Left);
if (item.ValuePrefix.ParseString() != string.Empty)
{
SetCellValue(ws, rowIndex, ++colIndex, item.ValuePrefix.ParseString() + item.ResultValue.ParseString(), ExcelHorizontalAlignment.Right);
}
else
{
SetCellValueNumber(ws, rowIndex, ++colIndex, item.ResultValue);
}
SetCellValueNumber(ws, rowIndex, ++colIndex, item.Hill);
SetCellValueNumber(ws, rowIndex, ++colIndex, item.CurveBottom);
SetCellValueNumber(ws, rowIndex, ++colIndex, item.CurveTop);
SetCellValueNumber(ws, rowIndex, ++colIndex, item.MaxResponse);
}
