using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using XCommon.Log;
using XCommon.MySql;
using DataRWDAL.Base;

namespace XImagingXhandler.XDAL
{
    /// <summary>
    /// 菜单分组库表操作类
    /// </summary>
    public class MethodGroupDB:BaseDB
    {
        #region 从数据库获取工作站已实现的方法分组信息数据
        /// <summary>
        /// 从数据库获取工作站已实现的方法分组信息数据
        /// </summary>
        /// <returns>实现的方法分组信息数据实体集合</returns>
        public static ObservableCollection<MethodGroup> GetMethodGroupFromdb()
        {
            using (var db = GetInstance())
            {
                return new ObservableCollection<MethodGroup>(db.Queryable<MethodGroup>().OrderBy(it => it.method_group_id, SqlSugar.OrderByType.Asc).ToList());
            }
        }
        #endregion
    }
}