private void Design_IRC_Abutment_Bridges_Box_Type_IRC()
{
string file_path = Get_Project_Folder();
//file_path = Path.Combine(file_path, "BoQ_Bridges_Box_Type.xlsx");
file_path = Path.Combine(file_path, "Counterfort Abutment Limit State Design [IRC].xlsm");
string copy_path = file_path;
//file_path = Path.Combine(Application.StartupPath, @"DESIGN\Abutment\Abutment Design IRC\IRC Abutment Design.xlsx");
file_path = Path.Combine(Application.StartupPath, @"DESIGN\Abutment\Counterfort Abutment LS\Counterfort Abutment Limit State Design [IRC].xlsm");
if (File.Exists(file_path))
{
File.Copy(file_path, copy_path, true);
}
iapp.Excel_Open_Message();
Excel.Application myExcelApp;
Excel.Workbooks myExcelWorkbooks;
Excel.Workbook myExcelWorkbook;
object misValue = System.Reflection.Missing.Value;
myExcelApp = new Excel.ApplicationClass();
myExcelApp.Visible = true;
myExcelWorkbooks = myExcelApp.Workbooks;
myExcelWorkbook = myExcelWorkbooks.Open(copy_path, 0, false, 5, "2011ap", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["DLSUP"];
if (rbtn_calculated.Checked == false)
{
//myExcelWorksheet.get_Range("F179").Formula = Reaction_A;
//myExcelWorksheet.get_Range("F181").Formula = Reaction_B;
myExcelWorksheet.get_Range("F179").Formula = Reaction_A;
myExcelWorksheet.get_Range("F181").Formula = Reaction_A;
myExcelWorksheet.get_Range("G179").Formula = "(Values Taken from Analysis / User)";
myExcelWorksheet.get_Range("G181").Formula = "(Values Taken from Analysis / User)";
}
List <string> list = new List <string>();
DataGridView dgv = dgv_input_data;
int rindx = 0;
#region Design Data
myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["Design Data"];
rindx = 0;
dgv = dgv_input_data;
DataInputCollections dips = new DataInputCollections();
dips.Load_Data_from_Grid(dgv);
List <string> ldbl = new List <string>();
//for (int i = 0; i < dgv.RowCount; i++)
//{
// try
// {
// if (dgv[1, i].Value.ToString() != "")
// ldbl.Add(dgv[1, i].Value.ToString());
// }
// catch (Exception exx) { }
//}
rindx = 0;
for (int i = 7; i < 123; i++)
{
if ((i >= 12 && i <= 14) ||
(i >= 22 && i <= 25) ||
(i >= 30 && i <= 31) ||
(i >= 36 && i <= 37) ||
(i >= 40 && i <= 41) ||
(i >= 47 && i <= 48) ||
(i >= 52 && i <= 53) ||
(i >= 58 && i <= 59) ||
(i >= 68 && i <= 70) ||
(i >= 72 && i <= 74) ||
(i >= 88 && i <= 90) ||
(i >= 92 && i <= 94) ||
(i >= 98 && i <= 100) ||
(i >= 103 && i <= 105) ||
(i >= 110 && i <= 116)
)
{
continue;
}
else
{
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToString();
if (rindx == 60)
{
myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToUpper().Replace("M", "").Trim().ToString();
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx].DATA.ToUpper().Replace("M", "").Trim().ToString();
}
else if (rindx == 61)
{
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx].DATA.ToUpper().Replace("M", "").Trim().ToString();
myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToUpper().Replace("FE", "").Trim().ToString();
}
else
{
myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToString();
}
}
}
#endregion Design Data
rindx = 0;
myExcelWorkbook.Save();
releaseObject(myExcelWorkbook);
iapp.Excel_Close_Message();
}
private void Design_IRC_Abutment_Bridges_Box_Type_BS()
{
string file_path = Get_Project_Folder();
//file_path = Path.Combine(file_path, "BoQ_Bridges_Box_Type.xlsx");
file_path = Path.Combine(file_path, "Counterfort Abutment Limit State Design [BS].xlsm");
string copy_path = file_path;
//file_path = Path.Combine(Application.StartupPath, @"DESIGN\Abutment\Abutment Design IRC\IRC Abutment Design.xlsx");
file_path = Path.Combine(Application.StartupPath, @"DESIGN\Abutment\Counterfort Abutment LS\Counterfort Abutment Limit State Design [BS].xlsm");
if (File.Exists(file_path))
{
File.Copy(file_path, copy_path, true);
}
else
{
return;
}
Excel.Application myExcelApp;
Excel.Workbooks myExcelWorkbooks;
Excel.Workbook myExcelWorkbook;
object misValue = System.Reflection.Missing.Value;
myExcelApp = new Excel.ApplicationClass();
myExcelApp.Visible = true;
myExcelWorkbooks = myExcelApp.Workbooks;
iapp.Excel_Open_Message();
myExcelWorkbook = myExcelWorkbooks.Open(copy_path, 0, false, 5, "2011ap", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["DLSUP"];
if (rbtn_calculated.Checked == false)
{
myExcelWorksheet.get_Range("F179").Formula = Reaction_A;
myExcelWorksheet.get_Range("F181").Formula = Reaction_B;
}
List <string> list = new List <string>();
DataGridView dgv = dgv_input_data;
int rindx = 0;
int i = 0;
#region Design Data
myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["Design Data"];
rindx = 0;
dgv = dgv_input_data;
DataInputCollections dips = new DataInputCollections();
dips.Load_Data_from_Grid(dgv);
List <string> ldbl = new List <string>();
//for (int i = 0; i < dgv.RowCount; i++)
//{
// try
// {
// if (dgv[1, i].Value.ToString() != "")
// ldbl.Add(dgv[1, i].Value.ToString());
// }
// catch (Exception exx) { }
//}
rindx = 0;
for (i = 7; i < 123; i++)
{
if ((i >= 12 && i <= 14) ||
(i >= 22 && i <= 25) ||
(i >= 30 && i <= 31) ||
(i >= 36 && i <= 37) ||
(i >= 40 && i <= 41) ||
(i >= 47 && i <= 48) ||
(i >= 52 && i <= 53) ||
(i >= 58 && i <= 59) ||
(i >= 68 && i <= 70) ||
(i >= 72 && i <= 74) ||
(i >= 88 && i <= 90) ||
(i >= 92 && i <= 94) ||
(i >= 98 && i <= 100) ||
(i >= 103 && i <= 105) ||
(i >= 110 && i <= 116)
)
{
continue;
}
else
{
if (rindx == 60)
{
myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToUpper().Replace("M", "").Trim().ToString();
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx].DATA.ToUpper().Replace("M", "").Trim().ToString();
}
else if (rindx == 61)
{
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx].DATA.ToUpper().Replace("M", "").Trim().ToString();
myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToUpper().Replace("FE", "").Trim().ToString();
}
else
{
myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx++].DATA.ToString();
}
}
}
#endregion Design Data
#region cwll
myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["cwll"];
List <string> xls_cell = new List <string>();
xls_cell.Add("Q");
xls_cell.Add("R");
xls_cell.Add("S");
xls_cell.Add("T");
xls_cell.Add("U");
xls_cell.Add("V");
xls_cell.Add("W");
List <double> load1 = new List <double>();
List <double> dist1 = new List <double>();
List <double> load2 = new List <double>();
List <double> dist2 = new List <double>();
i = 0;
for (i = 0; i < dgv_bs_ll_1.RowCount; i++)
{
try
{
load1.Add(MyList.StringToDouble(dgv_bs_ll_1[1, i].Value.ToString(), 0.0));
if (i > 0)
{
dist1.Add(MyList.StringToDouble(dgv_bs_ll_1[2, i].Value.ToString(), 0.0));
}
}
catch (Exception exx1) { }
}
for (i = 0; i < dgv_bs_ll_2.RowCount; i++)
{
try
{
load2.Add(MyList.StringToDouble(dgv_bs_ll_2[1, i].Value.ToString(), 0.0));
if (i > 0)
{
dist2.Add(MyList.StringToDouble(dgv_bs_ll_2[2, i].Value.ToString(), 0.0));
}
}
catch (Exception exx1) { }
}
#region HB Load 1
int cell = 26;
string kStr = "";
//myExcelWorksheet.get_Range("Q25").Formula = cmb_bs_ll_1.Text + " Loading";
myExcelWorksheet.get_Range("Q25").Formula = cmb_bs_ll_1.Text;
for (i = 0; i < xls_cell.Count; i++)
{
kStr = xls_cell[i] + cell;
if (i < load1.Count)
{
myExcelWorksheet.get_Range(kStr).Formula = load1[i].ToString();
}
else
{
myExcelWorksheet.get_Range(kStr).Formula = "";
}
}
cell = 27;
for (i = 1; i < xls_cell.Count; i++)
{
kStr = xls_cell[i] + cell;
if ((i - 1) < dist1.Count)
{
myExcelWorksheet.get_Range(kStr).Formula = dist1[i - 1].ToString();
}
else
{
myExcelWorksheet.get_Range(kStr).Formula = "";
}
}
#endregion HA Load 1
#region HB Load 2
xls_cell.Insert(0, "P");
cell = 64;
kStr = "";
//myExcelWorksheet.get_Range("P63").Formula = cmb_bs_ll_2.Text + " Loading";
myExcelWorksheet.get_Range("P63").Formula = cmb_bs_ll_2.Text;
for (i = 0; i < xls_cell.Count; i++)
{
kStr = xls_cell[i] + cell;
if (i < load1.Count)
{
myExcelWorksheet.get_Range(kStr).Formula = load1[i].ToString();
}
else
{
myExcelWorksheet.get_Range(kStr).Formula = "";
}
}
cell = 65;
for (i = 1; i < xls_cell.Count; i++)
{
kStr = xls_cell[i] + cell;
if ((i - 1) < dist1.Count)
{
myExcelWorksheet.get_Range(kStr).Formula = dist1[i - 1].ToString();
}
else
{
myExcelWorksheet.get_Range(kStr).Formula = "";
}
}
#endregion HA Load 2
#endregion cwll
rindx = 0;
myExcelWorkbook.Save();
releaseObject(myExcelWorkbook);
}
private void Box_Culvert_Single_Cell()
{
string file_path = Path.Combine(iApp.LastDesignWorkingFolder, Title);
if (iApp.user_path != "")
{
file_path = Path.Combine(iApp.user_path, Title);
}
if (!Directory.Exists(file_path))
{
Directory.CreateDirectory(file_path);
}
//file_path = Path.Combine(file_path, "RCC Cantilever Abutment Design");
//if (!Directory.Exists(file_path)) Directory.CreateDirectory(file_path);
file_path = Path.Combine(file_path, "Single cell box.xlsx");
//file_path = Path.Combine(file_path, "BoQ_Flyover_ROB_RUBs.xlsx");
//file_path = Path.Combine(file_path, "BoQ for " + cmb_boq_item.Text + ".xlsx");
string copy_path = file_path;
file_path = Path.Combine(Application.StartupPath, @"DESIGN\Limit State Method\Box Culvert\Single cell box.xlsx");
if (File.Exists(file_path))
{
File.Copy(file_path, copy_path, true);
}
else
{
MessageBox.Show(file_path + " file not found.");
return;
}
iApp.Excel_Open_Message();
Excel.Application myExcelApp;
Excel.Workbooks myExcelWorkbooks;
Excel.Workbook myExcelWorkbook;
object misValue = System.Reflection.Missing.Value;
myExcelApp = new Excel.ApplicationClass();
myExcelApp.Visible = true;
//myExcelApp.Visible = false;
myExcelWorkbooks = myExcelApp.Workbooks;
//myExcelWorkbook = myExcelWorkbooks.Open(fileName, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);
myExcelWorkbook = myExcelWorkbooks.Open(copy_path, 0, false, 5, "2011ap", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
//Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.ActiveSheet;
Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["Design Data"];
List <double> data = new List <double>();
try
{
if (false)
{
List <string> list = new List <string>();
DataGridView dgv = dgv_design_data_single;
int rindx = 0;
int i = 0;
#region Design Data
myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.Sheets["Design Data"];
rindx = 0;
dgv = dgv_design_data_single;
DataInputCollections dips = new DataInputCollections();
dips.Load_Data_from_Grid(dgv);
List <string> ldbl = new List <string>();
rindx = 0;
for (i = 6; i < 68; i++)
{
if ((i >= 12 && i <= 26) ||
(i >= 22 && i <= 30) ||
(i >= 30 && i <= 31) ||
(i >= 36 && i <= 37) ||
(i >= 40 && i <= 41) ||
(i >= 47 && i <= 48) ||
(i >= 52 && i <= 53) ||
(i >= 58 && i <= 59) ||
(i >= 68 && i <= 70) ||
(i >= 72 && i <= 74) ||
(i >= 88 && i <= 90) ||
(i >= 92 && i <= 94) ||
(i >= 98 && i <= 100) ||
(i >= 103 && i <= 105) ||
(i >= 110 && i <= 116)
)
{
continue;
}
else
{
if (rindx == 60)
{
myExcelWorksheet.get_Range("G" + i).Formula = dips[rindx++].DATA.ToUpper().Replace("M", "").Trim().ToString();
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx].DATA.ToUpper().Replace("M", "").Trim().ToString();
}
else if (rindx == 61)
{
//myExcelWorksheet.get_Range("E" + i).Formula = dips[rindx].DATA.ToUpper().Replace("M", "").Trim().ToString();
myExcelWorksheet.get_Range("G" + i).Formula = dips[rindx++].DATA.ToUpper().Replace("FE", "").Trim().ToString();
}
else
{
myExcelWorksheet.get_Range("G" + i).Formula = dips[rindx++].DATA.ToString();
}
}
}
#endregion Design Data
rindx = 0;
}
}
catch (Exception exx) { }
iApp.Excel_Close_Message();
myExcelWorkbook.Save();
releaseObject(myExcelWorkbook);
//iApp.Excel_Open_Message();
}