using DataRWDAL.Base;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Reflection;
using XImagingXhandler.XDAL;

namespace DataRWDAL
{
    /// <summary>
    /// 菌落颜色库表操作类
    /// </summary>
    public class BacteriaColorDB: BaseDB
    {
        #region 查询返回菌落颜色数据集
        /// <summary>
        /// 查询返回菌落颜色数据集
        /// </summary>
        /// <returns></returns>
        public static ObservableCollection<BacteriaColor> GetBacteriaColorList()
        {
            using (var db = GetInstance())
            {
                return new ObservableCollection<BacteriaColor>(db.Queryable<BacteriaColor>().OrderBy(it => it.bacteria_color_id).ToList());
            }
        }
        #endregion
    }
}