示例#1
0
文件: Form1.cs 项目: yenyulin/FOODEDM
        /// <summary>
        /// 用linq取回年份(TWYear)
        /// </summary>
        private int GetYear(DataSet ds, string strPeriodID)
        {
            DataTable Periods = ds.Tables[0];
            EnumerableRowCollection <DataRow> query = from Period in Periods.AsEnumerable()
                                                      where Period.Field <int>("Period") == Convert.ToInt32(strPeriodID)
                                                      select Period;

            IEnumerable <DataRow> rows = from row in query
                                         select row;
            int intYear = 0;

            foreach (DataRow row in rows)
            {
                //取得資料
                intYear = Convert.ToInt32(row["PeriodYear"].ToString());
            }
            return(intYear);
        }