/// <summary>
/// 맨홀높이 Sheet를 만든다.
/// </summary>
/// <param name="Data"></param>
private void ExportToSpread2(CPLHDataProc Data)
{
IWorkbook workbook = Spread2.Document;
Worksheet sheet = workbook.Worksheets[0];
sheet.Name = "맨홀높이";
DataTable dt = CGetTableType.GetMhHeight();
foreach (CPLHData Item in Data.PLHMngr.PLHDataList)
{
foreach (DataRow Item2 in Item.PLDLineData.Rows)
{
DataRow dr = dt.NewRow();
dr["LINENAME"] = "M1-" + Item2["LINENAME"];
dr["MhHeight"] = Item2["gap"];
dt.Rows.Add(dr);
}
}
workbook.BeginUpdate();
int nRowIndex = 0;
foreach (DataRow item in dt.Rows)
{
sheet.Cells[nRowIndex, 0].SetValue(item["LINENAME"]);
sheet.Cells[nRowIndex, 1].SetValue(item["MhHeight"]);
nRowIndex++;
}
workbook.EndUpdate();
}
private void MakeBaseData()
{
BaseTable = CGetTableType.GtMassData();
///전체 pipe Data가 들어있음
foreach (CPipeData item in PipeMngr.Data)
{
InsertManhole(item.Data1);
int nPipeCnt = item.Data1.Rows.Count;
foreach (DataRow pipeRow in item.Data1.Rows)
{
CMassData massData = MassMngr.Data.Find(x => x.SheetName == item.SheetName);
if (massData == null)
{
continue;
}
//string strSearch = string.Format("{0}='{1}'", "지반고", pipeRow["지반고"]);
//DataRow[] searchRow = massData.Data.Select(strSearch);
nPipeCnt += -1;
// massData.Rows[nPipeCnt];
//LINENAME NO 지반고 관저고 계획고 육상(토사) 육상(풍화암) 육상(연암) 수중(토사) 수중(풍화암) 수중(연암) 관상부
//관주위 ASP CONC 덧씌우기 보도블럭 모래부설 보조기층 동상방지층 구간
DataRow dr = BaseTable.NewRow();
dr["LINE"] = item.SheetName;
string sfilter = pipeRow["맨홀"].ToString().Substring(0, 3);
if (sfilter == "M1-" || sfilter == "M2-" || sfilter == "M3-" || sfilter == "M4-" ||
sfilter == "E1-" || sfilter == "E2-" || sfilter == "E3-" || sfilter == "E4-")
{
dr["LINENAME"] = pipeRow["맨홀"].ToString().Remove(0, 3);
}
else
{
dr["LINENAME"] = pipeRow["맨홀"];
}
dr["누가거리"] = pipeRow["누가거리"];
dr["NO"] = massData.Data.Rows[nPipeCnt]["NO"];
dr["지반고"] = massData.Data.Rows[nPipeCnt]["지반고"];
dr["관저고"] = massData.Data.Rows[nPipeCnt]["관저고"];
dr["계획고"] = massData.Data.Rows[nPipeCnt]["계획고"];
dr["육상(토사)"] = massData.Data.Rows[nPipeCnt]["육상(토사)"];
dr["육상(풍화암)"] = massData.Data.Rows[nPipeCnt]["육상(풍화암)"];
dr["육상(연암)"] = massData.Data.Rows[nPipeCnt]["육상(연암)"];
dr["수중(토사)"] = massData.Data.Rows[nPipeCnt]["수중(토사)"];
dr["수중(풍화암)"] = massData.Data.Rows[nPipeCnt]["수중(풍화암)"];
dr["수중(연암)"] = massData.Data.Rows[nPipeCnt]["수중(연암)"];
dr["관상부"] = massData.Data.Rows[nPipeCnt]["관상부"];
dr["관주위"] = massData.Data.Rows[nPipeCnt]["관주위"];
dr["ASP"] = massData.Data.Rows[nPipeCnt]["ASP"];
dr["CONC"] = massData.Data.Rows[nPipeCnt]["CONC"];
dr["덧씌우기"] = massData.Data.Rows[nPipeCnt]["덧씌우기"];
dr["보도블럭"] = massData.Data.Rows[nPipeCnt]["보도블럭"];
dr["모래부설"] = massData.Data.Rows[nPipeCnt]["모래부설"];
dr["보조기층"] = massData.Data.Rows[nPipeCnt]["보조기층"];
dr["동상방지층"] = massData.Data.Rows[nPipeCnt]["동상방지층"];
dr["구간"] = pipeRow["구간"];
dr["관경"] = pipeRow["관경"];
dr["맨홀규격"] = pipeRow["맨홀규격"];
dr["굴착공법"] = pipeRow["굴착공법"];
dr["Column3"] = pipeRow["Column3"];
dr["포장종류"] = pipeRow["포장종류"];
BaseTable.Rows.Add(dr);
}
}
}
