using DataEntity.Device;
using DataEntity.Page;
using DataEntity.Rack;
using DataRWDAL.Base;
using HxEnum;
using SqlSugar;
using System;
using System.Collections.Generic;
using XCommon.SqlSugar;

namespace DataRWDAL.Rack
{
    public class RackConfigDB : BaseDB
    {
        /// <summary>
        /// 根据Id，获取暂存架配置信息
        /// </summary>
        /// <param name="id"></param>
        /// <param name="softwareInformationId"></param>
        /// <returns></returns>
        public static RackConfigModel GetInfo(string softwareInformationId)
        {
            using (var db = GetInstance())
            {
                return db.Queryable<RackConfigModel>().Single(it => it.software_information_id.Equals(softwareInformationId));
            }
        }

        /// <summary>
        /// 登录暂存架配置信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static int Add(RackConfigModel model)
        {
            using (var db = GetInstance())
            {
                return db.Insertable<RackConfigModel>(model).ExecuteCommand();
            }
        }

        /// <summary>
        /// 更新暂存架配置信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static int Update(RackConfigModel model)
        {
            using (var db = GetInstance())
            {
                return db.Updateable<RackConfigModel>(model).ExecuteCommand();
            }
        }
    }
}