コード例 #1
0
ファイル: PrePlanner.cs プロジェクト: scliu96/PrePlaner
        public static void load_fb()
        {
            DataTable dt_xls_dates = FeatureBuild.excelToDataSet("FZM FBP tool.xlsb", "Feature Build,Start Date,End Date", "Dates");                      //调用GetData方发写上Excel文件所在的路径,这样就能获取到Excel表里面的数据了
            DataTable dt_xls_cap   = FeatureBuild.excelToDataSet("FZM FBP tool.xlsb", "Capacities,FT_FZ01_Dev,FT_FZ02_Dev", "cap");                       //调用GetData方发写上Excel文件所在的路径,这样就能获取到Excel表里面的数据了

            var dt_dates = FeatureBuild.FormatDataTableDates(dt_xls_dates);
            var dt_cap   = FeatureBuild.FormatDataTableCap(dt_xls_cap);

            DT_REL = FeatureBuild.FormatDataTableRelease(dt_xls_dates);
            DT_FB  = FeatureBuild.MergeDataTable(dt_dates, dt_cap);
        }
コード例 #2
0
ファイル: FM_Main.cs プロジェクト: dreamgazer/PrePlaner
        private void LoadFB()
        {
            dgv_FBList.DataSource = null;                                                                                            //每次打开清空内容
            DataTable dt_xls_dates = FeatureBuild.excelToDataSet("FZM FBP tool.xlsb", "Feature Build,Start Date,End Date", "Dates"); //调用GetData方发写上Excel文件所在的路径,这样就能获取到Excel表里面的数据了
            DataTable dt_xls_cap   = FeatureBuild.excelToDataSet("FZM FBP tool.xlsb", "Capacities,FT_FZ01_Dev,FT_FZ02_Dev", "cap");  //调用GetData方发写上Excel文件所在的路径,这样就能获取到Excel表里面的数据了

            var dt_dates = FeatureBuild.FormatDataTableDates(dt_xls_dates);
            var dt_cap   = FeatureBuild.FormatDataTableCap(dt_xls_cap);

            DT_Rel = FeatureBuild.FormatDataTableRelease(dt_xls_dates);

            DT_FB = FeatureBuild.MergeDataTable(dt_dates, dt_cap);
            dgv_FBList.DataSource  = DT_FB;
            dgv_Release.DataSource = DT_Rel;
        }