using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using ExcelDna.Integration;
using ExcelDna.IntelliSense;
using static System.Math;

namespace UnitWeightCalculation
{
    public class StartUp : IExcelAddIn
    {
        public void AutoClose()
        {
            IntelliSenseServer.Uninstall();
        }

        public void AutoOpen()
        {
            //ExcelIntegration.RegisterMethods(new List<System.Reflection.MethodInfo>() { typeof(Functions).GetMethod("UnitWeightSteel") });
            IntelliSenseServer.Install();
        }
    }


    public static class Functions
    {
        [ExcelFunction(
            Name = "UnitWeight.Steel",
            Description = "根据关键字+截面参数计算米重，支持圆D，冷弯C,槽钢[,角钢L，U型钢U,方管B",
            Category = "几何")]
        public static double UnitWeightSteel([ExcelArgument(Name = "截面内容")] string para)
        {
            double area = 0;

            MatchCollection secStr = Regex.Matches(para, @"[0-9.]*");

            var secPara = new List<double> { };
            foreach (var item in secStr)
            {
                if (item.ToString().Length != 0)
                {
                    secPara.Add(double.Parse(item.ToString()));
                }
                
            }

            switch (para.ToUpper()[0])
            {
                case 'C':
                    if (secPara.Count == 3)
                    {
                        area = Section.coldC(secPara[0], secPara[1], 0, secPara[2]);
                    }
                    else if (secPara.Count == 4)
                    {
                        area = Section.coldC(secPara[0], secPara[1], secPara[2], secPara[3]);
                    }
                    else
                    {
                        area = 0;
                    }
                    break;
                case '[':
                    switch (para[para.Length-1])
                    {
                        case 'B':
                            area = Section.channelC(secPara[0], 1);
                            break;
                        case 'C':
                            area = Section.channelC(secPara[0], 2);
                            break;
                        default:
                            area = Section.channelC(secPara[0], 0);
                            break;
                    }
                    break;
                case 'D':
                    area = secPara.Count == 1 ? Section.circleTube(secPara[0], 0) : Section.circleTube(secPara[0], secPara[0] - 2 * secPara[1]);
                    break;
                case 'B':
                    switch (secPara.Count)
                    {
                        case 2:
                            area = Section.recTube(secPara[0], secPara[0], secPara[0] - 2 * secPara[1], secPara[0] - 2 * secPara[1]);
                            break;
                        case 3:
                            area = Section.recTube(secPara[0], secPara[1], secPara[0] - 2 * secPara[2], secPara[1] - 2 * secPara[2]);
                            break;
                        case 4:
                            area = Section.recTube(secPara[0], secPara[1], secPara[0] - 2 * secPara[2], secPara[1] - 2 * secPara[3]);
                            break;
                        default:
                            area = 0;
                            break;
                    }
                    break;
                case 'L':
                    area = secPara.Count == 2 ? Section.angleL(secPara[0], secPara[0], secPara[1]) : Section.angleL(secPara[0], secPara[1], secPara[2]);
                    break;
                case 'U':
                    area = Section.coldU(secPara[0], secPara[1], secPara[2], secPara[3]);
                    break;
                default :
                    area = 0;
                    break;
            }
  
            return area*7850/1e6;
        }
    } 


    public class Section
    {
        public static double circleTube(double D, double d = 0)
        {
            return (D + d) * (D - d) / 4 * PI;
        }

        public static double recTube(double A, double B, double a = 0, double b = 0)
        {
            return A * B - a * b;
        }

        public static double coldC(double H, double B ,double a, double t)
        {
            return (2 * a + 2 * B + H - 4 * t) * t;
        }

        public static double angleL(double A, double B, double T)
        {
            return A > B ?
                ((double)angle.Select($"D= {A} and B = {B} and T = {T}")[0]["AX"]) *100:
                ((double)angle.Select($"D= {B} and B = {A} and T = {T}")[0]["AX"]) * 100;
        }

        public static double channelC(double D,int type)
        {
            return ((double)channel.Select($"D={D * 10}")[type]["AX"]) *100;
        }

        public static double coldU(double H, double B, double A, double T)
        {
            return (double)Ushape.Select($"H= {H} and B = {B} and A = {A} and T = {T}")[0]["AX"];
        }

        public static DataTable angle
        {
            get
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("name", typeof(string));
                dt.Columns.Add("D", typeof(double));    // unit: mm
                dt.Columns.Add("B", typeof(double));    // unit: mm
                dt.Columns.Add("T", typeof(double));    // unit: mm
                dt.Columns.Add("Ax", typeof(double));   // unit: cm^2
                dt.Columns.Add("Rz", typeof(double));   // unit: cm
                dt.Columns.Add("Ry", typeof(double));   // unit: cm
                dt.Columns.Add("Long", typeof(double)); // unit: cm
                dt.Columns.Add("Short", typeof(double));// unit: cm
                dt.Columns.Add("Iy", typeof(double));   // unit: cm^4
                dt.Columns.Add("Iz", typeof(double));   // unit: cm^4
                dt.Columns.Add("Wy", typeof(double));   // unit: cm^3
                dt.Columns.Add("Wz", typeof(double));   // unit: cm^3
                dt.Columns.Add("RootRadius", typeof(double));
                dt.Rows.Add("L20X20X3", 20, 20, 3, 1.132, 0.39, 0.75, 0.6, 0.6, 0.63, 0.17, 0.45, 0.2, 3.5);
                dt.Rows.Add("L20X20X4", 20, 20, 4, 1.459, 0.38, 0.73, 0.64, 0.64, 0.78, 0.22, 0.55, 0.24, 3.5);
                dt.Rows.Add("L25X16X3", 25, 16, 3, 1.162, 0.34, 0.82, 0.42, 0.86, 0.78, 0.14, 0.34, 0.16, 3.5);
                dt.Rows.Add("L25X16X4", 25, 16, 4, 1.499, 0.34, 0.81, 0.46, 0.9, 0.98, 0.17, 0.42, 0.2, 3.5);
                dt.Rows.Add("L25X25X3", 25, 25, 3, 1.432, 0.49, 0.95, 0.73, 0.73, 1.29, 0.34, 0.73, 0.33, 3.5);
                dt.Rows.Add("L25X25X4", 25, 25, 4, 1.859, 0.48, 0.93, 0.76, 0.76, 1.62, 0.43, 0.92, 0.4, 3.5);
                dt.Rows.Add("L30X30X3", 30, 30, 3, 1.749, 0.59, 1.15, 0.85, 0.85, 2.31, 0.61, 1.09, 0.51, 4.5);
                dt.Rows.Add("L30X30X4", 30, 30, 4, 2.276, 0.58, 1.13, 0.89, 0.89, 2.92, 0.77, 1.37, 0.62, 4.5);
                dt.Rows.Add("L32X20X3", 32, 20, 3, 1.492, 0.43, 1.07, 0.49, 1.08, 1.71, 0.28, 0.57, 0.25, 3.5);
                dt.Rows.Add("L32X20X4", 32, 20, 4, 1.939, 0.42, 1.05, 0.53, 1.12, 2.15, 0.35, 0.72, 0.32, 3.5);
                dt.Rows.Add("L36X36X3", 36, 36, 3, 2.109, 0.71, 1.39, 1, 1, 4.09, 1.07, 1.61, 0.76, 4.5);
                dt.Rows.Add("L36X36X4", 36, 36, 4, 2.756, 0.7, 1.38, 1.04, 1.04, 5.22, 1.37, 2.05, 0.93, 4.5);
                dt.Rows.Add("L36X36X5", 36, 36, 5, 3.382, 0.7, 1.36, 1.07, 1.07, 6.24, 1.65, 2.45, 1.09, 4.5);
                dt.Rows.Add("L40X25X3", 40, 25, 3, 1.89, 0.54, 1.35, 0.59, 1.32, 3.45, 0.56, 0.92, 0.4, 4);
                dt.Rows.Add("L40X25X4", 40, 25, 4, 2.467, 0.54, 1.34, 0.63, 1.37, 4.4, 0.71, 1.18, 0.52, 4);
                dt.Rows.Add("L40X40X3", 40, 40, 3, 2.359, 0.79, 1.55, 1.09, 1.09, 5.69, 1.49, 2.01, 0.96, 5);
                dt.Rows.Add("L40X40X4", 40, 40, 4, 3.086, 0.79, 1.54, 1.13, 1.13, 7.29, 1.91, 2.58, 1.19, 5);
                dt.Rows.Add("L40X40X5", 40, 40, 5, 3.792, 0.78, 1.52, 1.17, 1.17, 8.76, 2.3, 3.1, 1.39, 5);
                dt.Rows.Add("L45X28X3", 45, 28, 3, 2.149, 0.61, 1.52, 0.64, 1.47, 4.99, 0.8, 1.19, 0.51, 5);
                dt.Rows.Add("L45X28X4", 45, 28, 4, 2.806, 0.6, 1.51, 0.68, 1.51, 6.37, 1.02, 1.51, 0.66, 5);
                dt.Rows.Add("L45X45X3", 45, 45, 3, 2.659, 0.89, 1.76, 1.22, 1.22, 8.2, 2.14, 2.58, 1.24, 5);
                dt.Rows.Add("L45X45X4", 45, 45, 4, 3.486, 0.89, 1.74, 1.26, 1.26, 10.6, 2.75, 3.32, 1.54, 5);
                dt.Rows.Add("L45X45X5", 45, 45, 5, 4.292, 0.88, 1.72, 1.3, 1.3, 12.7, 3.33, 4, 1.81, 5);
                dt.Rows.Add("L45X45X6", 45, 45, 6, 5.077, 0.88, 1.7, 1.33, 1.33, 14.8, 3.89, 4.64, 2.06, 5);
                dt.Rows.Add("L50X32X3", 50, 32, 3, 2.431, 0.7, 1.7, 0.73, 1.6, 7.06, 1.2, 1.52, 0.68, 5.5);
                dt.Rows.Add("L50X32X4", 50, 32, 4, 3.177, 0.69, 1.69, 0.77, 1.65, 9.07, 1.53, 1.96, 0.87, 5.5);
                dt.Rows.Add("L50X50X3", 50, 50, 3, 2.971, 1, 1.96, 1.34, 1.34, 11.4, 2.98, 3.22, 1.57, 5.5);
                dt.Rows.Add("L50X50X4", 50, 50, 4, 3.897, 0.99, 1.94, 1.38, 1.38, 14.7, 3.82, 4.16, 1.96, 5.5);
                dt.Rows.Add("L50X50X5", 50, 50, 5, 4.803, 0.98, 1.92, 1.42, 1.42, 17.8, 4.64, 5.03, 2.31, 5.5);
                dt.Rows.Add("L50X50X6", 50, 50, 6, 5.688, 0.98, 1.91, 1.46, 1.46, 20.7, 5.42, 5.85, 2.63, 5.5);
                dt.Rows.Add("L56X36X3", 56, 36, 3, 2.743, 0.79, 1.92, 0.8, 1.78, 10.07, 1.73, 1.94, 0.87, 6);
                dt.Rows.Add("L56X36X4", 56, 36, 4, 3.59, 0.79, 1.91, 0.85, 1.82, 13.03, 2.23, 2.51, 1.13, 6);
                dt.Rows.Add("L56X36X5", 56, 36, 5, 4.415, 0.78, 1.89, 0.88, 1.87, 15.72, 2.67, 3.03, 1.36, 6);
                dt.Rows.Add("L56X56X3", 56, 56, 3, 3.343, 1.13, 2.2, 1.48, 1.48, 16.1, 4.24, 4.08, 2.02, 6);
                dt.Rows.Add("L56X56X4", 56, 56, 4, 4.39, 1.11, 2.18, 1.53, 1.53, 20.9, 5.46, 5.28, 2.52, 6);
                dt.Rows.Add("L56X56X5", 56, 56, 5, 5.415, 1.1, 2.17, 1.57, 1.57, 25.4, 6.61, 6.42, 2.98, 6);
                dt.Rows.Add("L56X56X6", 56, 56, 6, 6.42, 1.1, 2.15, 1.61, 1.61, 29.7, 7.73, 7.49, 3.4, 6);
                dt.Rows.Add("L56X56X7", 56, 56, 7, 7.404, 1.09, 2.13, 1.64, 1.64, 33.6, 8.82, 8.49, 3.8, 6);
                dt.Rows.Add("L56X56X8", 56, 56, 8, 8.367, 1.09, 2.11, 1.68, 1.68, 37.4, 9.89, 9.44, 4.16, 6);
                dt.Rows.Add("L60X60X5", 60, 60, 5, 5.829, 1.19, 2.33, 1.67, 1.67, 31.6, 8.21, 7.44, 3.48, 6.5);
                dt.Rows.Add("L60X60X6", 60, 60, 6, 6.914, 1.18, 2.31, 1.7, 1.7, 36.9, 9.6, 8.7, 3.98, 6.5);
                dt.Rows.Add("L60X60X7", 60, 60, 7, 7.977, 1.17, 2.29, 1.74, 1.74, 41.9, 11, 9.88, 4.45, 6.5);
                dt.Rows.Add("L60X60X8", 60, 60, 8, 9.02, 1.17, 2.27, 1.78, 1.78, 46.7, 12.3, 11, 4.88, 6.5);
                dt.Rows.Add("L63X40X4", 63, 40, 4, 4.058, 0.88, 2.14, 0.92, 2.04, 18.61, 3.12, 3.18, 1.4, 7);
                dt.Rows.Add("L63X40X5", 63, 40, 5, 4.993, 0.87, 2.13, 0.95, 2.08, 22.55, 3.76, 3.85, 1.71, 7);
                dt.Rows.Add("L63X40X6", 63, 40, 6, 5.908, 0.86, 2.11, 0.99, 2.12, 26.35, 4.34, 4.49, 1.99, 7);
                dt.Rows.Add("L63X40X7", 63, 40, 7, 6.802, 0.86, 2.09, 1.03, 2.15, 29.77, 4.97, 5.07, 2.29, 7);
                dt.Rows.Add("L63X63X4", 63, 63, 4, 4.978, 1.26, 2.46, 1.7, 1.7, 30.2, 7.89, 6.78, 3.29, 7);
                dt.Rows.Add("L63X63X5", 63, 63, 5, 6.143, 1.25, 2.45, 1.74, 1.74, 36.8, 9.57, 8.25, 3.9, 7);
                dt.Rows.Add("L63X63X6", 63, 63, 6, 7.288, 1.24, 2.43, 1.78, 1.78, 43, 11.2, 9.66, 4.46, 7);
                dt.Rows.Add("L63X63X7", 63, 63, 7, 8.412, 1.23, 2.41, 1.82, 1.82, 49, 12.8, 11, 4.98, 7);
                dt.Rows.Add("L63X63X8", 63, 63, 8, 9.515, 1.23, 2.4, 1.85, 1.85, 54.6, 14.3, 12.3, 5.47, 7);
                dt.Rows.Add("L63X63X10", 63, 63, 10, 11.66, 1.22, 2.36, 1.93, 1.93, 64.9, 17.3, 14.6, 6.36, 7);
                dt.Rows.Add("L70X45X4", 70, 45, 4, 4.553, 0.98, 2.41, 1.02, 2.24, 26.35, 4.4, 4.07, 1.77, 7.5);
                dt.Rows.Add("L70X45X5", 70, 45, 5, 5.609, 0.98, 2.38, 1.06, 2.28, 31.73, 5.4, 4.89, 2.19, 7.5);
                dt.Rows.Add("L70X45X6", 70, 45, 6, 6.644, 0.98, 2.35, 1.09, 2.32, 36.75, 6.35, 5.66, 2.59, 7.5);
                dt.Rows.Add("L70X45X7", 70, 45, 7, 7.658, 0.97, 2.34, 1.13, 2.36, 42.04, 7.16, 6.47, 2.94, 7.5);
                dt.Rows.Add("L70X70X4", 70, 70, 4, 5.57, 1.4, 2.74, 1.86, 1.86, 41.8, 11, 8.44, 4.17, 8);
                dt.Rows.Add("L70X70X5", 70, 70, 5, 6.876, 1.39, 2.73, 1.91, 1.91, 51.1, 13.3, 10.3, 4.95, 8);
                dt.Rows.Add("L70X70X6", 70, 70, 6, 8.16, 1.38, 2.71, 1.95, 1.95, 59.9, 15.6, 12.1, 5.67, 8);
                dt.Rows.Add("L70X70X7", 70, 70, 7, 9.424, 1.38, 2.69, 1.99, 1.99, 68.4, 17.8, 13.8, 6.34, 8);
                dt.Rows.Add("L70X70X8", 70, 70, 8, 10.67, 1.37, 2.68, 2.03, 2.03, 76.4, 20, 15.4, 6.98, 8);
                dt.Rows.Add("L75X50X5", 75, 50, 5, 6.126, 1.1, 2.56, 1.17, 2.4, 40.09, 7.41, 5.83, 2.74, 8);
                dt.Rows.Add("L75X50X6", 75, 50, 6, 7.26, 1.08, 2.55, 1.21, 2.44, 47.26, 8.54, 6.87, 3.19, 8);
                dt.Rows.Add("L75X50X8", 75, 50, 8, 9.467, 1.07, 2.52, 1.29, 2.52, 60, 10.9, 8.71, 4.1, 8);
                dt.Rows.Add("L75X50X10", 75, 50, 10, 11.59, 1.06, 2.49, 1.36, 2.6, 71.6, 13.1, 10.37, 4.99, 8);
                dt.Rows.Add("L75X75X5", 75, 75, 5, 7.412, 1.5, 2.92, 2.04, 2.04, 63.3, 16.6, 11.9, 5.77, 9);
                dt.Rows.Add("L75X75X6", 75, 75, 6, 8.797, 1.49, 2.9, 2.07, 2.07, 74.4, 19.5, 14, 6.67, 9);
                dt.Rows.Add("L75X75X7", 75, 75, 7, 10.16, 1.48, 2.89, 2.11, 2.11, 85, 22.2, 16, 7.44, 9);
                dt.Rows.Add("L75X75X8", 75, 75, 8, 11.5, 1.47, 2.88, 2.15, 2.15, 95.1, 24.9, 17.9, 8.19, 9);
                dt.Rows.Add("L75X75X9", 75, 75, 9, 12.83, 1.46, 2.86, 2.18, 2.18, 105, 27.5, 19.8, 8.89, 9);
                dt.Rows.Add("L75X75X10", 75, 75, 10, 14.13, 1.46, 2.84, 2.22, 2.22, 114, 30.1, 21.5, 9.56, 9);
                dt.Rows.Add("L80X50X5", 80, 50, 5, 6.376, 1.1, 2.72, 1.14, 2.6, 47.14, 7.66, 6.32, 2.74, 8);
                dt.Rows.Add("L80X50X6", 80, 50, 6, 7.56, 1.08, 2.71, 1.18, 2.65, 55.65, 8.85, 7.46, 3.2, 8);
                dt.Rows.Add("L80X50X7", 80, 50, 7, 8.724, 1.08, 2.69, 1.21, 2.69, 63, 10.2, 8.44, 3.7, 8);
                dt.Rows.Add("L80X50X8", 80, 50, 8, 9.867, 1.07, 2.67, 1.25, 2.73, 70.3, 11.4, 9.4, 4.16, 8);
                dt.Rows.Add("L80X80X5", 80, 80, 5, 7.912, 1.6, 3.13, 2.15, 2.15, 77.3, 20.3, 13.7, 6.66, 9);
                dt.Rows.Add("L80X80X6", 80, 80, 6, 9.397, 1.59, 3.11, 2.19, 2.19, 91, 23.7, 16.1, 7.65, 9);
                dt.Rows.Add("L80X80X7", 80, 80, 7, 10.86, 1.58, 3.1, 2.23, 2.23, 104, 27.1, 18.4, 8.58, 9);
                dt.Rows.Add("L80X80X8", 80, 80, 8, 12.3, 1.57, 3.08, 2.27, 2.27, 117, 30.4, 20.6, 9.46, 9);
                dt.Rows.Add("L80X80X9", 80, 80, 9, 13.73, 1.56, 3.06, 2.31, 2.31, 129, 33.6, 22.7, 10.3, 9);
                dt.Rows.Add("L80X80X10", 80, 80, 10, 15.13, 1.56, 3.04, 2.35, 2.35, 140, 36.8, 24.8, 11.1, 9);
                dt.Rows.Add("L90X56X5", 90, 56, 5, 7.212, 1.23, 3.07, 1.25, 2.91, 67.8, 11, 8.07, 3.49, 9);
                dt.Rows.Add("L90X56X6", 90, 56, 6, 8.557, 1.23, 3.05, 1.29, 2.95, 79.5, 12.9, 9.46, 4.13, 9);
                dt.Rows.Add("L90X56X7", 90, 56, 7, 9.881, 1.22, 3.03, 1.33, 3, 90.7, 14.7, 10.79, 4.72, 9);
                dt.Rows.Add("L90X56X8", 90, 56, 8, 11.18, 1.21, 3.02, 1.36, 3.04, 101.9, 16.3, 12.11, 5.29, 9);
                dt.Rows.Add("L90X90X6", 90, 90, 6, 10.64, 1.8, 3.51, 2.44, 2.44, 131, 34.3, 20.6, 9.95, 10);
                dt.Rows.Add("L90X90X7", 90, 90, 7, 12.3, 1.78, 3.5, 2.48, 2.48, 150, 39.2, 23.6, 11.2, 10);
                dt.Rows.Add("L90X90X8", 90, 90, 8, 13.94, 1.78, 3.48, 2.52, 2.52, 169, 44, 26.6, 12.4, 10);
                dt.Rows.Add("L90X90X9", 90, 90, 9, 15.57, 1.77, 3.46, 2.56, 2.56, 187, 48.7, 29.4, 13.5, 10);
                dt.Rows.Add("L90X90X10", 90, 90, 10, 17.17, 1.76, 3.45, 2.59, 2.59, 204, 53.3, 32, 14.5, 10);
                dt.Rows.Add("L90X90X12", 90, 90, 12, 20.31, 1.75, 3.41, 2.67, 2.67, 236, 62.2, 37.1, 16.5, 10);
                dt.Rows.Add("L100X63X6", 100, 63, 6, 9.618, 1.38, 3.41, 1.43, 3.24, 111.6, 18.4, 11.99, 5.25, 10);
                dt.Rows.Add("L100X63X7", 100, 63, 7, 11.11, 1.38, 3.38, 1.47, 3.28, 127.3, 21, 13.68, 6.02, 10);
                dt.Rows.Add("L100X63X8", 100, 63, 8, 12.58, 1.37, 3.37, 1.5, 3.32, 142.9, 23.5, 15.34, 6.78, 10);
                dt.Rows.Add("L100X63X10", 100, 63, 10, 15.47, 1.35, 3.34, 1.58, 3.4, 172.8, 28.3, 18.53, 8.24, 10);
                dt.Rows.Add("L100X80X6", 100, 80, 6, 10.64, 1.72, 3.58, 1.97, 2.95, 136.5, 31.7, 16.11, 8.37, 10);
                dt.Rows.Add("L100X80X7", 100, 80, 7, 12.3, 1.72, 3.57, 2.01, 3, 156.9, 36.2, 18.51, 9.6, 10);
                dt.Rows.Add("L100X80X8", 100, 80, 8, 13.94, 1.71, 3.55, 2.05, 3.04, 176, 40.6, 20.75, 10.8, 10);
                dt.Rows.Add("L100X80X10", 100, 80, 10, 17.17, 1.69, 3.52, 2.13, 3.12, 212.6, 49.1, 25.04, 13.1, 10);
                dt.Rows.Add("L100X100X6", 100, 100, 6, 11.93, 2, 3.9, 2.67, 2.67, 182, 47.9, 25.7, 12.7, 12);
                dt.Rows.Add("L100X100X7", 100, 100, 7, 13.8, 1.99, 3.89, 2.71, 2.71, 209, 54.7, 29.6, 14.3, 12);
                dt.Rows.Add("L100X100X8", 100, 100, 8, 15.64, 1.98, 3.88, 2.76, 2.76, 235, 61.4, 33.2, 15.8, 12);
                dt.Rows.Add("L100X100X9", 100, 100, 9, 17.46, 1.97, 3.86, 2.8, 2.8, 260, 68, 36.8, 17.2, 12);
                dt.Rows.Add("L100X100X10", 100, 100, 10, 19.26, 1.96, 3.84, 2.84, 2.84, 285, 74.4, 40.3, 18.5, 12);
                dt.Rows.Add("L100X100X12", 100, 100, 12, 22.8, 1.95, 3.81, 2.91, 2.91, 331, 86.8, 46.8, 21.1, 12);
                dt.Rows.Add("L100X100X14", 100, 100, 14, 26.26, 1.94, 3.77, 2.99, 2.99, 374, 99, 52.9, 23.4, 12);
                dt.Rows.Add("L100X100X16", 100, 100, 16, 29.63, 1.94, 3.74, 3.06, 3.06, 414, 111, 58.6, 25.6, 12);
                dt.Rows.Add("L110X70X6", 110, 70, 6, 10.64, 1.54, 3.76, 1.57, 3.53, 150.5, 25.4, 14.75, 6.53, 10);
                dt.Rows.Add("L110X70X7", 110, 70, 7, 12.3, 1.53, 3.75, 1.61, 3.57, 173, 29, 16.95, 7.5, 10);
                dt.Rows.Add("L110X70X8", 110, 70, 8, 13.94, 1.53, 3.73, 1.65, 3.62, 194.4, 32.5, 19.04, 8.45, 10);
                dt.Rows.Add("L110X70X10", 110, 70, 10, 17.17, 1.51, 3.7, 1.72, 3.7, 234.7, 39.2, 22.96, 10.3, 10);
                dt.Rows.Add("L110X110X7", 110, 110, 7, 15.2, 2.2, 4.3, 2.96, 2.96, 281, 73.4, 36.1, 17.5, 12);
                dt.Rows.Add("L110X110X8", 110, 110, 8, 17.24, 2.19, 4.28, 3.01, 3.01, 316, 82.4, 40.7, 19.4, 12);
                dt.Rows.Add("L110X110X10", 110, 110, 10, 21.26, 2.17, 4.25, 3.09, 3.09, 384, 100, 49.4, 22.9, 12);
                dt.Rows.Add("L110X110X12", 110, 110, 12, 25.2, 2.15, 4.22, 3.16, 3.16, 448, 117, 57.6, 26.2, 12);
                dt.Rows.Add("L110X110X14", 110, 110, 14, 29.06, 2.14, 4.18, 3.24, 3.24, 508, 133, 65.3, 29.1, 12);
                dt.Rows.Add("L125X80X7", 125, 80, 7, 14.1, 1.76, 4.28, 1.8, 4.01, 258.6, 43.8, 22.34, 9.92, 11);
                dt.Rows.Add("L125X80X8", 125, 80, 8, 15.99, 1.75, 4.27, 1.84, 4.06, 291.3, 49.2, 25.16, 11.2, 11);
                dt.Rows.Add("L125X80X10", 125, 80, 10, 19.71, 1.74, 4.23, 1.92, 4.14, 353.5, 59.5, 30.5, 13.6, 11);
                dt.Rows.Add("L125X80X12", 125, 80, 12, 23.35, 1.72, 4.2, 2, 4.22, 411.6, 69.4, 35.46, 16, 11);
                dt.Rows.Add("L125X125X8", 125, 125, 8, 19.75, 2.5, 4.88, 3.37, 3.37, 471, 123, 53.3, 25.9, 14);
                dt.Rows.Add("L125X125X10", 125, 125, 10, 24.37, 2.48, 4.85, 3.45, 3.45, 574, 149, 64.9, 30.6, 14);
                dt.Rows.Add("L125X125X12", 125, 125, 12, 28.91, 2.46, 4.82, 3.53, 3.53, 671, 175, 76, 35, 14);
                dt.Rows.Add("L125X125X14", 125, 125, 14, 33.37, 2.45, 4.78, 3.61, 3.61, 764, 200, 86.4, 39.1, 14);
                dt.Rows.Add("L125X125X16", 125, 125, 16, 37.74, 2.43, 4.75, 3.68, 3.68, 851, 224, 96.3, 43, 14);
                dt.Rows.Add("L140X90X8", 140, 90, 8, 18.04, 1.98, 4.8, 2.04, 4.5, 416.2, 70.8, 32.14, 14.3, 12);
                dt.Rows.Add("L140X90X10", 140, 90, 10, 22.26, 1.96, 4.74, 2.12, 4.58, 500.2, 85.8, 38.6, 17.5, 12);
                dt.Rows.Add("L140X90X12", 140, 90, 12, 26.4, 1.95, 4.74, 2.19, 4.66, 592, 100, 45.64, 20.5, 12);
                dt.Rows.Add("L140X90X14", 140, 90, 14, 30.46, 1.94, 4.7, 2.27, 4.74, 672, 114, 51.75, 23.5, 12);
                dt.Rows.Add("L140X140X10", 140, 140, 10, 27.37, 2.78, 5.46, 3.82, 3.82, 817, 212, 82.6, 39.2, 14);
                dt.Rows.Add("L140X140X12", 140, 140, 12, 32.51, 2.76, 5.43, 3.9, 3.9, 959, 249, 96.9, 45, 14);
                dt.Rows.Add("L140X140X14", 140, 140, 14, 37.57, 2.75, 5.4, 3.98, 3.98, 1090, 284, 110, 50.5, 14);
                dt.Rows.Add("L140X140X16", 140, 140, 16, 42.54, 2.74, 5.36, 4.06, 4.06, 1220, 319, 123, 55.6, 14);
                dt.Rows.Add("L150X90X8", 150, 90, 8, 18.84, 1.98, 5.1, 1.97, 4.92, 490.9, 74.1, 34.83, 14.5, 12);
                dt.Rows.Add("L150X90X10", 150, 90, 10, 23.26, 1.97, 5.07, 2.05, 5.01, 598.1, 89.9, 42.41, 17.7, 12);
                dt.Rows.Add("L150X90X12", 150, 90, 12, 27.6, 1.95, 5.04, 2.12, 5.09, 700, 105, 49.58, 20.8, 12);
                dt.Rows.Add("L150X90X14", 150, 90, 14, 31.86, 1.94, 5, 2.2, 5.17, 797, 120, 56.4, 23.8, 12);
                dt.Rows.Add("L150X90X15", 150, 90, 15, 33.95, 1.93, 4.99, 2.24, 5.21, 844, 127, 59.69, 25.3, 12);
                dt.Rows.Add("L150X90X16", 150, 90, 16, 36.03, 1.93, 4.97, 2.27, 5.25, 889, 134, 62.83, 26.8, 12);
                dt.Rows.Add("L150X150X8", 150, 150, 8, 23.75, 3.01, 5.9, 3.99, 3.99, 827, 215, 78, 38.1, 14);
                dt.Rows.Add("L150X150X10", 150, 150, 10, 29.37, 2.99, 5.87, 4.08, 4.08, 1010, 262, 95.5, 45.5, 14);
                dt.Rows.Add("L150X150X12", 150, 150, 12, 34.91, 2.97, 5.84, 4.15, 4.15, 1190, 308, 112, 52.4, 14);
                dt.Rows.Add("L150X150X14", 150, 150, 14, 40.37, 2.95, 5.8, 4.23, 4.23, 1360, 352, 128, 58.8, 14);
                dt.Rows.Add("L150X150X15", 150, 150, 15, 43.06, 2.95, 5.78, 4.27, 4.27, 1440, 374, 136, 61.9, 14);
                dt.Rows.Add("L150X150X16", 150, 150, 16, 45.74, 2.94, 5.77, 4.31, 4.31, 1520, 395, 143, 64.9, 14);
                dt.Rows.Add("L160X100X10", 160, 100, 10, 25.32, 2.19, 5.45, 2.28, 5.24, 752, 122, 50.45, 21.9, 13);
                dt.Rows.Add("L160X100X12", 160, 100, 12, 30.05, 2.17, 5.42, 2.36, 5.32, 882, 142, 59.13, 25.8, 13);
                dt.Rows.Add("L160X100X14", 160, 100, 14, 34.71, 2.16, 5.38, 2.43, 5.4, 1005, 162, 67.31, 29.6, 13);
                dt.Rows.Add("L160X100X16", 160, 100, 16, 39.28, 2.16, 5.34, 2.51, 5.48, 1119, 183, 74.87, 33.4, 13);
                dt.Rows.Add("L160X160X10", 160, 160, 10, 31.5, 3.2, 6.27, 4.31, 4.31, 1240, 322, 109, 52.8, 16);
                dt.Rows.Add("L160X160X12", 160, 160, 12, 37.44, 3.18, 6.24, 4.39, 4.39, 1460, 377, 129, 60.7, 16);
                dt.Rows.Add("L160X160X14", 160, 160, 14, 43.3, 3.16, 6.2, 4.47, 4.47, 1670, 432, 147, 68.2, 16);
                dt.Rows.Add("L160X160X16", 160, 160, 16, 49.07, 3.14, 6.17, 4.55, 4.55, 1870, 485, 165, 75.3, 16);
                dt.Rows.Add("L180X110X10", 180, 110, 10, 28.37, 2.42, 6.13, 2.44, 5.89, 1067, 167, 63.33, 26.9, 14);
                dt.Rows.Add("L180X110X12", 180, 110, 12, 33.71, 2.4, 6.09, 2.52, 5.98, 1250, 195, 74.14, 31.7, 14);
                dt.Rows.Add("L180X110X14", 180, 110, 14, 38.97, 2.39, 6.07, 2.59, 6.06, 1438, 222, 85.24, 36.3, 14);
                dt.Rows.Add("L180X110X16", 180, 110, 16, 44.14, 2.38, 6.03, 2.67, 6.14, 1603, 249, 94.93, 40.9, 14);
                dt.Rows.Add("L180X180X12", 180, 180, 12, 42.24, 3.58, 7.05, 4.89, 4.89, 2100, 543, 165, 78.4, 16);
                dt.Rows.Add("L180X180X14", 180, 180, 14, 48.9, 3.56, 7.02, 4.97, 4.97, 2410, 622, 189, 88.4, 16);
                dt.Rows.Add("L180X180X16", 180, 180, 16, 55.47, 3.55, 6.98, 5.05, 5.05, 2700, 699, 212, 97.8, 16);
                dt.Rows.Add("L180X180X18", 180, 180, 18, 61.96, 3.51, 6.94, 5.13, 5.13, 2990, 762, 235, 105, 16);
                dt.Rows.Add("L200X125X12", 200, 125, 12, 37.91, 2.74, 6.83, 2.83, 6.54, 1767, 286, 94.9, 41.2, 14);
                dt.Rows.Add("L200X125X14", 200, 125, 14, 43.87, 2.73, 6.79, 2.91, 6.62, 2024, 327, 108.62, 47.3, 14);
                dt.Rows.Add("L200X125X16", 200, 125, 16, 49.74, 2.71, 6.75, 2.99, 6.7, 2269, 366, 121.69, 53.3, 14);
                dt.Rows.Add("L200X125X18", 200, 125, 18, 55.53, 2.7, 6.73, 3.06, 6.78, 2512, 405, 134.59, 59.2, 14);
                dt.Rows.Add("L200X200X14", 200, 200, 14, 54.64, 3.98, 7.82, 5.46, 5.46, 3340, 864, 236, 112, 18);
                dt.Rows.Add("L200X200X16", 200, 200, 16, 62.01, 3.96, 7.79, 5.54, 5.54, 3760, 971, 266, 124, 18);
                dt.Rows.Add("L200X200X18", 200, 200, 18, 69.3, 3.94, 7.75, 5.62, 5.62, 4160, 1080, 294, 136, 18);
                dt.Rows.Add("L200X200X20", 200, 200, 20, 76.51, 3.93, 7.72, 5.69, 5.69, 4550, 1180, 322, 147, 18);
                dt.Rows.Add("L200X200X24", 200, 200, 24, 90.66, 3.9, 7.64, 5.87, 5.87, 5290, 1380, 374, 167, 18);
                dt.Rows.Add("L220X220X16", 220, 220, 16, 68.67, 4.37, 8.59, 6.03, 6.03, 5060, 1310, 326, 154, 21);
                dt.Rows.Add("L220X220X18", 220, 220, 18, 76.75, 4.35, 8.55, 6.11, 6.11, 5620, 1450, 361, 168, 21);
                dt.Rows.Add("L220X220X20", 220, 220, 20, 84.76, 4.34, 8.52, 6.18, 6.18, 6150, 1590, 395, 182, 21);
                dt.Rows.Add("L220X220X22", 220, 220, 22, 92.68, 4.32, 8.48, 6.26, 6.26, 6670, 1730, 429, 195, 21);
                dt.Rows.Add("L220X220X24", 220, 220, 24, 100.5, 4.31, 8.45, 6.33, 6.33, 7170, 1870, 461, 208, 21);
                dt.Rows.Add("L220X220X26", 220, 220, 26, 108.3, 4.3, 8.41, 6.41, 6.41, 7690, 2000, 492, 221, 21);
                dt.Rows.Add("L250X250X18", 250, 250, 18, 87.84, 4.97, 9.76, 6.84, 6.84, 8370, 2170, 473, 224, 24);
                dt.Rows.Add("L250X250X20", 250, 250, 20, 97.05, 4.95, 9.73, 6.92, 6.92, 9180, 2380, 519, 243, 24);
                dt.Rows.Add("L250X250X22", 250, 250, 22, 106.2, 4.93, 9.69, 7, 7, 9970, 2580, 564, 261, 24);
                dt.Rows.Add("L250X250X24", 250, 250, 24, 115.2, 4.92, 9.66, 7.07, 7.07, 10700, 2790, 608, 278, 24);
                dt.Rows.Add("L250X250X26", 250, 250, 26, 124.2, 4.9, 9.62, 7.15, 7.15, 11500, 2980, 650, 295, 24);
                dt.Rows.Add("L250X250X28", 250, 250, 28, 133, 4.89, 9.58, 7.22, 7.22, 12200, 3180, 691, 311, 24);
                dt.Rows.Add("L250X250X30", 250, 250, 30, 141.8, 4.88, 9.55, 7.3, 7.3, 12900, 3380, 731, 327, 24);
                dt.Rows.Add("L250X250X32", 250, 250, 32, 150.5, 4.87, 9.51, 7.37, 7.37, 13600, 3570, 770, 342, 24);
                dt.Rows.Add("L250X250X35", 250, 250, 35, 163.4, 4.86, 9.46, 7.48, 7.48, 14600, 3850, 827, 364, 24);
                return dt;
            }
        }
        public static DataTable channel
        {
            get
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("name", typeof(string));
                dt.Columns.Add("Ax", typeof(double));// unit:cm^2
                dt.Columns.Add("D", typeof(double));// unit:mm
                dt.Columns.Add("Bf", typeof(double));// unit:mm
                dt.Columns.Add("Tf", typeof(double));// unit:mm
                dt.Columns.Add("Tw", typeof(double));// unit:mm
                dt.Columns.Add("Iz", typeof(double));// unit:cm^4
                dt.Columns.Add("Iy", typeof(double));// unit:cm^4
                dt.Columns.Add("Zo", typeof(double));// unit:cm
                dt.Columns.Add("Ix", typeof(double));// unit:cm^4
                dt.Columns.Add("Pz", typeof(double));// unit:cm^3
                dt.Columns.Add("Py", typeof(double));// unit:cm^3
                dt.Columns.Add("r", typeof(double));// unit:mm
                dt.Columns.Add("Wz", typeof(double));// unit:cm^3
                dt.Columns.Add("Wy", typeof(double));// unit:cm^3
                dt.Columns.Add("Rz", typeof(double));// unit:cm
                dt.Columns.Add("Ry", typeof(double));// unit:cm

                dt.Rows.Add("CH5", 6.925, 50, 37, 7, 4.5, 26, 8.3, 1.35, 0.925, 12.595, 6.955, 7, 10.4, 3.55, 1.94, 1.1);
                dt.Rows.Add("CH6.3", 8.446, 63, 40, 7.5, 4.8, 50.8, 11.9, 1.36, 1.262, 19.415, 9.17, 7.5, 16.1, 4.5, 2.45, 1.19);
                dt.Rows.Add("CH6.5", 8.292, 65, 40, 7.5, 4.3, 55.2, 12, 1.38, 1.217, 19.938, 9.067, 7.5, 17, 4.59, 2.54, 1.19);
                dt.Rows.Add("CH8", 10.24, 80, 43, 8, 5, 101, 16.6, 1.43, 1.682, 29.888, 11.876, 8, 25.3, 5.79, 3.15, 1.27);
                dt.Rows.Add("CH10", 12.74, 100, 48, 8.5, 5.3, 198, 25.6, 1.52, 2.311, 46.46, 16.338, 8.5, 39.7, 7.8, 3.95, 1.41);
                dt.Rows.Add("CH12", 15.36, 120, 53, 9, 5.5, 346, 37.4, 1.62, 3.058, 67.253, 21.593, 9, 57.7, 10.2, 4.75, 1.56);
                dt.Rows.Add("CH12.6", 15.69, 126, 53, 9, 5.5, 391, 38, 1.59, 3.091, 71.847, 21.848, 9, 62.1, 10.2, 4.95, 1.57);
                dt.Rows.Add("CH14A", 18.51, 140, 58, 9.5, 6, 564, 53.2, 1.71, 4.083, 93.867, 27.92, 9.5, 80.5, 13, 5.52, 1.7);
                dt.Rows.Add("CH14B", 21.31, 140, 60, 9.5, 8, 609, 61.1, 1.67, 5.428, 103.667, 30.137, 9.5, 87.1, 14.1, 5.35, 1.69);
                dt.Rows.Add("CH16A", 21.95, 160, 63, 10, 6.5, 866, 73.3, 1.8, 5.356, 126.35, 35.201, 10, 108, 16.3, 6.28, 1.83);
                dt.Rows.Add("CH16B", 25.15, 160, 65, 10, 8.5, 935, 83.4, 1.75, 7.121, 139.15, 37.62, 10, 117, 17.6, 6.1, 1.82);
                dt.Rows.Add("CH18A", 25.69, 180, 68, 10.5, 7, 1270, 98.6, 1.88, 6.916, 165.265, 43.475, 10.5, 141, 20, 7.04, 1.96);
                dt.Rows.Add("CH18B", 29.29, 180, 70, 10.5, 9, 1370, 111, 1.84, 9.174, 181.465, 46.201, 10.5, 152, 21.5, 6.84, 1.95);
                dt.Rows.Add("CH20A", 28.83, 200, 73, 11, 7, 1780, 128, 2.01, 8.328, 207.214, 52.785, 11, 178, 24.2, 7.86, 2.11);
                dt.Rows.Add("CH20B", 32.83, 200, 75, 11, 9, 1910, 144, 1.95, 10.848, 227.214, 55.865, 11, 191, 25.9, 7.64, 2.09);
                dt.Rows.Add("CH22A", 31.83, 220, 77, 11.5, 7, 2390, 158, 2.1, 9.836, 252.543, 61.687, 11.5, 218, 28.2, 8.67, 2.23);
                dt.Rows.Add("CH22B", 36.23, 220, 79, 11.5, 9, 2570, 176, 2.03, 12.62, 276.743, 65.104, 11.5, 234, 30.1, 8.42, 2.21);
                dt.Rows.Add("CH24A", 34.21, 240, 78, 12, 7, 3050, 174, 2.1, 11.189, 295.056, 66.366, 12, 254, 30.5, 9.45, 2.25);
                dt.Rows.Add("CH24B", 39.01, 240, 80, 12, 9, 3280, 194, 2.03, 14.238, 323.856, 69.995, 12, 274, 32.5, 9.17, 2.23);
                dt.Rows.Add("CH24C", 43.81, 240, 82, 12, 11, 3510, 213, 2, 18.928, 352.656, 74.099, 12, 293, 34.4, 8.96, 2.21);
                dt.Rows.Add("CH25A", 34.91, 250, 78, 12, 7, 3370, 176, 2.07, 11.304, 312.151, 66.615, 12, 270, 30.6, 9.82, 2.24);
                dt.Rows.Add("CH25B", 39.91, 250, 80, 12, 9, 3530, 196, 1.98, 14.481, 343.401, 70.319, 12, 282, 32.7, 9.41, 2.22);
                dt.Rows.Add("CH25C", 44.91, 250, 82, 12, 11, 3690, 218, 1.92, 19.372, 374.651, 74.523, 12, 295, 35.9, 9.07, 2.21);
                dt.Rows.Add("CH27A", 39.27, 270, 82, 12.5, 7.5, 4360, 216, 2.13, 13.81, 376.484, 76.947, 12.5, 323, 35.5, 10.5, 2.34);
                dt.Rows.Add("CH27B", 44.67, 270, 84, 12.5, 9.5, 4690, 239, 2.06, 17.678, 412.934, 81.105, 12.5, 347, 37.7, 10.3, 2.31);
                dt.Rows.Add("CH27C", 50.07, 270, 86, 12.5, 11.5, 5020, 261, 2.03, 23.503, 449.384, 85.802, 12.5, 372, 39.8, 10.1, 2.28);
                dt.Rows.Add("CH28A", 40.02, 280, 82, 12.5, 7.5, 4760, 218, 2.1, 13.951, 396.109, 77.203, 12.5, 340, 35.7, 10.9, 2.33);
                dt.Rows.Add("CH28B", 45.62, 280, 84, 12.5, 9.5, 5130, 242, 2.02, 17.964, 435.309, 81.445, 12.5, 366, 37.9, 10.6, 2.3);
                dt.Rows.Add("CH28C", 51.22, 280, 86, 12.5, 11.5, 5500, 268, 1.95, 24.01, 474.509, 86.248, 12.5, 393, 40.3, 10.4, 2.29);
                dt.Rows.Add("CH30A", 43.89, 300, 85, 13.5, 7.5, 6050, 260, 2.17, 17.356, 468.501, 89.501, 13.5, 403, 41.1, 11.7, 2.43);
                dt.Rows.Add("CH30B", 49.89, 300, 87, 13.5, 9.5, 6500, 289, 2.13, 21.679, 513.501, 94.144, 13.5, 433, 44, 11.4, 2.41);
                dt.Rows.Add("CH30C", 55.89, 300, 89, 13.5, 11.5, 6950, 316, 2.09, 28.179, 558.501, 99.386, 13.5, 463, 46.4, 11.2, 2.38);
                dt.Rows.Add("CH32A", 48.5, 320, 88, 14, 8, 7600, 305, 2.24, 20.589, 547.52, 99.76, 14, 475, 46.5, 12.5, 2.5);
                dt.Rows.Add("CH32B", 54.9, 320, 90, 14, 10, 8140, 336, 2.16, 25.749, 598.72, 104.88, 14, 509, 49.2, 12.2, 2.47);
                dt.Rows.Add("CH32C", 61.3, 320, 92, 14, 12, 8690, 374, 2.09, 33.358, 649.92, 110.64, 14, 543, 52.6, 11.9, 2.47);
                dt.Rows.Add("CH36A", 60.89, 360, 96, 16, 9, 11900, 455, 2.44, 33.345, 770.448, 135.54, 16, 660, 63.5, 14, 2.73);
                dt.Rows.Add("CH36B", 68.09, 360, 98, 16, 11, 12700, 497, 2.37, 40.521, 835.248, 141.924, 16, 703, 66.9, 13.6, 2.7);
                dt.Rows.Add("CH36C", 75.29, 360, 100, 16, 13, 13400, 536, 2.34, 50.724, 900.048, 149.028, 16, 746, 70, 13.4, 2.67);
                dt.Rows.Add("CH40A", 75.04, 400, 100, 18, 10.5, 17600, 592, 2.49, 51.579, 1035.402, 165.637, 18, 879, 78.8, 15.3, 2.81);
                dt.Rows.Add("CH40B", 83.04, 400, 102, 18, 12.5, 18600, 640, 2.44, 62.097, 1115.402, 173.459, 18, 932, 82.5, 15, 2.78);
                dt.Rows.Add("CH40C", 91.04, 400, 104, 18, 14.5, 19700, 688, 2.42, 76.436, 1195.402, 182.081, 18, 986, 86.2, 14.7, 2.75);

                return dt;
            }
        }
        public static DataTable Ushape
        {
            get
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("H", typeof(double));    // unit: mm
                dt.Columns.Add("B", typeof(double));    // unit: mm
                dt.Columns.Add("A", typeof(double));    // unit: mm
                dt.Columns.Add("T", typeof(double));   // unit: cm^2
                dt.Columns.Add("AX", typeof(double));   // unit: cm

                dt.Rows.Add(20.6,41.3,7.5,2.0,165.3);
                dt.Rows.Add(31, 41.3, 7.5, 2.0, 204.9);
                dt.Rows.Add(41.3, 41.3, 7.5, 2.0, 245.1);
                dt.Rows.Add(41.3, 41.3, 7.5, 3.0, 348.4);
                dt.Rows.Add(52, 41.3, 7.5, 2.5, 352.1);
                dt.Rows.Add(72, 41.3, 7.5, 2.75, 492.8);
                return dt;
            }
        }
    }

}