public void AddFabricationRow(int index, DXFData dxfData)
{
excelLocation = ExcelLocation(index);
if (index < 2)
{
hssfSheet.GetRow(excelLocation).GetCell(0).SetCellValue(dxfData.TYPE_NO);
hssfSheet.GetRow(excelLocation).GetCell(1).SetCellValue(dxfData.NO_OF_TYPES * dxfData.NO_OF_STRANDS);
}
else
{
hssfSheet.GetRow(excelLocation).CreateCell(0).SetCellValue(dxfData.TYPE_NO);
hssfSheet.GetRow(excelLocation).CreateCell(1).SetCellValue(dxfData.NO_OF_TYPES * dxfData.NO_OF_STRANDS);
}
overallLength = dxfData.NO_OF_LIVES == 1 ? dxfData.LENGTH + 0.5 : dxfData.LENGTH + 1.1;
overallLength = overallLength == 1.1 ? 0 : overallLength;
if (overallLength >= 25)
{
if (overallLength <= 33)
{
overallLength += 0.1;
}
else if (overallLength <= 39)
{
overallLength += 0.2;
}
else
{
overallLength += 0.3;
}
}
hssfSheet.GetRow(excelLocation).CreateCell(2).SetCellValue(Convert.ToDouble((Math.Ceiling(overallLength * 10) / 10).ToString("0.0")));
hssfSheet.GetRow(excelLocation).CreateCell(3).SetCellValue(Convert.ToDouble((Math.Ceiling(overallLength * 10 * 3.27) / 10.0).ToString("0.0")));
if (dxfData.NO_OF_LIVES == 1)
{
hssfSheet.GetRow(excelLocation).CreateCell(4).SetCellValue(0);
}
else
{
hssfSheet.GetRow(excelLocation).CreateCell(4).SetCellValue("بلا بصلة");
}
if (index % 2 != 0)
{
for (int i = 0; i < 5; i++)
{
hssfSheet.GetRow(excelLocation).GetCell(i).CellStyle = hssfSheet.GetRow(14).GetCell(0).CellStyle;
}
}
else
{
for (int i = 0; i < 5; i++)
{
hssfSheet.GetRow(excelLocation).GetCell(i).CellStyle = hssfSheet.GetRow(13).GetCell(0).CellStyle;
}
}
}
public void AddStressingRow(int index, DXFData dxfData, DXFTendonRef dxfTendonRef)
{
if (index < 6)
{
localRow = 16 + index * 5;
}
else
{
index -= 6;
localRow = pageNumOfRows + (index / dataNumOfRows) * pageNumOfRows;
localRow += 5 + (index % dataNumOfRows) * 5;
}
if (localRow > 16)
{
for (int i = 0; i < 5; i++)
{
for (int j = 0; j < 11; j++)
{
hssfSheet.GetRow(localRow + i).CreateCell(j);
hssfSheet.GetRow(localRow + i).GetCell(j).CellStyle = hssfSheet.GetRow(16 + i).GetCell(j).CellStyle;
}
}
}
CellRangeAddress region = new CellRangeAddress(localRow + 1, localRow + 4, 0, 0);
hssfSheet.AddMergedRegion(region);
for (int i = 5; i < 11; i++)
{
region = new CellRangeAddress(localRow, localRow + 4, i, i);
hssfSheet.AddMergedRegion(region);
}
hssfSheet.GetRow(localRow).GetCell(0).SetCellValue(dxfTendonRef.tendonType);
hssfSheet.GetRow(localRow + 1).GetCell(0).SetCellValue("#" + dxfTendonRef.tendonNumber);
switch (dxfData.NO_OF_STRANDS)
{
case 5:
hssfSheet.GetRow(localRow + 0).GetCell(1).SetCellValue("Center");
hssfSheet.GetRow(localRow + 1).GetCell(1).SetCellValue("Left int.");
hssfSheet.GetRow(localRow + 2).GetCell(1).SetCellValue("right int.");
hssfSheet.GetRow(localRow + 3).GetCell(1).SetCellValue("left ext.");
hssfSheet.GetRow(localRow + 4).GetCell(1).SetCellValue("Right ext.");
break;
case 4:
hssfSheet.GetRow(localRow + 0).GetCell(1).SetCellValue("Left int.");
hssfSheet.GetRow(localRow + 1).GetCell(1).SetCellValue("Right int.");
hssfSheet.GetRow(localRow + 2).GetCell(1).SetCellValue("left ext.");
hssfSheet.GetRow(localRow + 3).GetCell(1).SetCellValue("Right ext.");
hssfSheet.GetRow(localRow + 4).GetCell(1).SetCellValue("");
break;
case 3:
hssfSheet.GetRow(localRow + 0).GetCell(1).SetCellValue("Left int.");
hssfSheet.GetRow(localRow + 1).GetCell(1).SetCellValue("Right int.");
hssfSheet.GetRow(localRow + 2).GetCell(1).SetCellValue("left ext.");
hssfSheet.GetRow(localRow + 3).GetCell(1).SetCellValue("");
hssfSheet.GetRow(localRow + 4).GetCell(1).SetCellValue("");
break;
case 2:
hssfSheet.GetRow(localRow + 0).GetCell(1).SetCellValue("Left int.");
hssfSheet.GetRow(localRow + 1).GetCell(1).SetCellValue("Right int.");
hssfSheet.GetRow(localRow + 2).GetCell(1).SetCellValue("");
hssfSheet.GetRow(localRow + 3).GetCell(1).SetCellValue("");
hssfSheet.GetRow(localRow + 4).GetCell(1).SetCellValue("");
break;
case 1:
hssfSheet.GetRow(localRow + 0).GetCell(1).SetCellValue("Left int.");
hssfSheet.GetRow(localRow + 1).GetCell(1).SetCellValue("Right int.");
hssfSheet.GetRow(localRow + 2).GetCell(1).SetCellValue("");
hssfSheet.GetRow(localRow + 3).GetCell(1).SetCellValue("");
hssfSheet.GetRow(localRow + 4).GetCell(1).SetCellValue("");
hssfSheet.GetRow(localRow + 1).GetCell(2).SetCellValue(Convert.ToInt32(dxfData.JACK_FORCE.Replace("KN", "")));
hssfSheet.GetRow(localRow + 1).GetCell(3).SetCellValue(dxfData.GUAGEReadingCCL);
break;
default:
break;
}
for (int i = 0; i < dxfData.NO_OF_STRANDS; i++)
{
hssfSheet.GetRow(localRow + i).GetCell(2).SetCellValue(Convert.ToInt32(dxfData.JACK_FORCE.Replace("KN", "")));
hssfSheet.GetRow(localRow + i).GetCell(3).SetCellValue(dxfData.GUAGEReadingCCL);
//hssfSheet.GetRow(localRow + i).GetCell(4).SetCellValue(dxfData.ActualExtension);
}
string[] arrayExtension = dxfData.ActualExtension.Split(',');
for (int i = 0; i < arrayExtension.Length; i++)
{
hssfSheet.GetRow(localRow + i).GetCell(4).SetCellValue(arrayExtension[i]);
}
hssfSheet.GetRow(localRow).GetCell(5).SetCellFormula("AVERAGE(E" + (localRow + 1) + ":E" + (localRow + 5) + ")");
hssfSheet.GetRow(localRow).GetCell(6).SetCellValue(dxfData.EXTENSION);
hssfSheet.GetRow(localRow).GetCell(7).SetCellFormula(dxfData.UpdatedAverageExtension);
hssfSheet.GetRow(localRow).GetCell(8).SetCellFormula("(F" + (localRow + 1) + "-G" + (localRow + 1) + ")/G" + (localRow + 1) + "");
hssfSheet.GetRow(localRow).GetCell(9).SetCellFormula(dxfData.UpdatedDeviationPerc);
hssfSheet.GetRow(localRow).GetCell(10).SetCellValue(dxfData.Remarks);
}
public void AddProjectInfo(DXFData dxfData)
{
hssfSheet.GetRow(6).GetCell(4).SetCellValue(": " + DateTime.Now.ToShortDateString());
hssfSheet.GetRow(9).GetCell(1).SetCellValue(": " + dxfData.STRAND_TYPE);
}
/// <summary>
/// Parsing DXF File
/// </summary>
/// <param name="dxfFileLocation">Dxf File Location</param>
/// <param name="dxfData">Replicating data to simplify Stressing</param>
/// <param name="dxfData12_9">Splitting data for better sorting 12,9</param>
/// <param name="dxfData15_7">Splitting data for better sorting 15.7</param>
/// <param name="dxfTendonRef"></param>
public void ParseDXFFile(string dxfFileLocation, ref string projectNumber, ref List <DXFData> dxfData,
ref List <DXFData> dxfData12_9, ref List <DXFData> dxfData15_7
, ref List <DXFTendonRef> dxfTendonRef)
{
dxfData.Clear();
dxfData12_9.Clear();
dxfData15_7.Clear();
dxfTendonRef.Clear();
localDxfTendonRef.Clear();
//int counter = 0;
string line;
// Read the file and display it line by line.
System.IO.StreamReader file = new System.IO.StreamReader(dxfFileLocation);
DXFData row = new DXFData();
bool falg = false;
while ((line = file.ReadLine()) != null)
{
// Select that this is the the ACDbText Type Input
if (line != "AcDbText")
{
continue;
}
// Skip Settings to reach value
for (int i = 0; i < 9; i++)
{
file.ReadLine();
}
//line = file.ReadLine();
//if(line.StartsWith("B-"))
//{
// Console.WriteLine(line);
//}
// Save Value
valueExtracted = file.ReadLine();
if (valueExtracted.StartsWith("B-"))
{
string[] projectValues = valueExtracted.Split('-');
projectNumber = "B961-" + projectValues[1];
}
if (valueExtracted.Contains("TYPE "))
{
for (int i = 0; i < 80; i++)
{
line = file.ReadLine();
if (line == "TEXT")
{
break;
}
}
for (int i = 0; i < 19; i++)
{
file.ReadLine();
}
line = file.ReadLine();
if (!falg)
{
falg = true;
}
else
{
//if (int.TryParse(, out tempTendonRef))
//{
DXFTendonRef dxfTendonRefLocal = new DXFTendonRef();
dxfTendonRefLocal.tendonType = valueExtracted.Remove(0, 5);
dxfTendonRefLocal.tendonNumber = line;
localDxfTendonRef.Add(dxfTendonRefLocal);
//
}
continue;
}
// Skip Settings to reach Type of input
for (int i = 0; i < 17; i++)
{
file.ReadLine();
}
// Save Input Type
line = file.ReadLine();
try
{
// This switch is just to save that this value
// is known and it's linked to these selected types
switch (line)
{
case "TYPE_NO":
row.TYPE_NO = valueExtracted;
dxfData.Add(row);
if (row.STRAND_TYPE.Contains("12.9"))
{
dxfData12_9.Add(row);
}
else
{
dxfData15_7.Add(row);
}
row = new DXFData();
break;
case "NO_OF_TYPES":
row.NO_OF_TYPES = int.Parse(valueExtracted);
break;
case "ANCHOR_TYPE":
row.ANCHOR_TYPE = valueExtracted;
break;
case "NO_OF_LIVES":
row.NO_OF_LIVES = int.Parse(valueExtracted);
break;
case "NO_OF_STRANDS":
row.NO_OF_STRANDS = int.Parse(valueExtracted);
break;
case "STRAND_TYPE":
row.STRAND_TYPE = valueExtracted;
break;
case "GUTS":
row.GUTS = int.Parse(valueExtracted);
break;
case "LENGTH":
row.LENGTH = double.Parse(valueExtracted);
break;
case "JACK_FORCE":
row.JACK_FORCE = valueExtracted;
break;
case "EXTENSION":
row.EXTENSION = int.Parse(valueExtracted);
break;
case "STRESSING":
row.STRESSING = valueExtracted;
break;
}
}
catch (Exception ex)
{
Trace.TraceInformation("Error Input:" + ex.Message);
continue;
}
}
file.Close();
for (int i = 0; i < dxfData.Count; i++)
{
for (int j = 0; j < localDxfTendonRef.Count; j++)
{
if (localDxfTendonRef[j].tendonType == dxfData[i].TYPE_NO)
{
dxfTendonRef.Add(localDxfTendonRef[j]);
}
}
}
//// 1a Problemmmmmmmm
//dxfTendonRef.Sort(delegate(DXFTendonRef a, DXFTendonRef b)
//{
// int xdiff = a.tendonType.CompareTo(b.tendonType);
// if (xdiff != 0) return xdiff;
// else return a.tendonNumber.CompareTo(b.tendonNumber);
//});
}
