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
|
}
|
}
|