using DataEntity.Device;
using DataRWDAL.Base;
using HxEnum;
using MySql.Data.MySqlClient;
using SqlSugar;
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;

namespace XImagingXhandler.XDAL
{
    public class DeviceArmDB : BaseDB
    {
        #region 获取当前设备臂信息
        /// <summary>
        /// 获取当前设备臂信息
        /// </summary>
        /// <param name="softwareId">设备系列号</param>
        public static List<DeviceArm> GetDeviceArmFromdb(string softwareId)
        {
            using (var db = GetInstance())
            {
                return db.Queryable<DeviceArm>().Where(it => it.software_information_id.Equals(softwareId)).ToList();
            }
        }
        #endregion

        #region 修改一条新的设备臂数据 by 设备臂数据
        /// <summary>
        /// 修改一条新的液体参数数据 by 设备臂数据
        /// </summary>
        /// <param name="deviceArm">设备臂数据</param>
        /// <returns>1:成功；0：失败</returns>
        public static int UpdateDeviceIntodb(DeviceArm deviceArm)
        {
            using (var db = GetInstance())
            {
                return db.Updateable<DeviceArm>(deviceArm).ExecuteCommand();
            }
        }
        #endregion
    }
}