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

namespace DataRWDAL
{
    /// <summary>
    /// 液体参数库表操作类
    /// </summary>
    public class LiquidDB:BaseDB
    {
        #region 查询返回一条液体参数数据 by 液体参数Id
        /// <summary>
        /// 查询返回一条液体参数数据 by 液体参数Id
        /// </summary>
        /// <param name="liquidid">液体参数Id</param>
        /// <returns>1：成功；0：失败</returns>
        public static Liquid GetALiquidFromdb(string liquidid)
        {
            using (var db = GetInstance())
            {
                return db.Queryable<Liquid>().Where(it=>it.liquid_id.Equals(liquidid)&&it.liquid_status.Equals(1)).First();
            }
        }
        #endregion

        #region 添加一条新的液体参数数据 by 液体参数数据
        /// <summary>
        /// 添加一条新的液体参数数据 by 液体参数数据
        /// </summary>
        /// <param name="liquid">液体参数数据</param>
        /// <returns>1:成功；0：失败</returns>
        public static int AddLiquidIntodb(Liquid liquid)
        {
            using (var db = GetInstance())
            {
                return db.Insertable<Liquid>(liquid).ExecuteCommand();
            }
        }
        #endregion

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

        #region 查找返回是否存在一条相同名称的液体参数 by 液体范围数据对象、液体类型名称
        /// <summary>
        /// 查找返回是否存在一条相同名称的液体参数 by 液体范围数据对象、液体类型名称
        /// </summary>
        /// <param name="liquidTypeRSRange">液体范围数据对象</param>
        /// <param name="liquidName">液体类型名称</param>
        /// <returns>-1:不存在；其它值：存在</returns>
        public static string IsExistSameNameLiquidTypeRSRangeIntodb(LiquidTypeRSRange liquidTypeRSRange, string liquidName)
        {
            string iResult = "-1";
            using (var db = GetInstance())
            {
                var query = db.Queryable("LiquidTypeRSRange", "t").AddJoinInfo("Liquid", "l", "t.liquid_id=l.liquid_id and t.liquid_type_id='"
                    + liquidTypeRSRange.liquid_type_id + "'"
                    + " and t.liquid_range_id='" + liquidTypeRSRange.liquid_range_id + "'"
                    + " and t.device_arm_id=" + liquidTypeRSRange.device_arm_id
                    + " and l.liquid_name='" + liquidName + "'"
                    + " and l.liquid_status=1", JoinType.Inner)
                    .Select("l.*");

                //var query= db.Queryable<Liquid, LiquidTypeRSRange>((st, sc) => st.liquid_id == sc.liquid_id).Where(st=>st.liquid_name.Equals(liquidName)
                //                                                 && st.liquid_type_id.Equals(liquidTypeRSRange.liquid_type_id) 
                //                                                 && st.liquid_range_id.Equals(liquidTypeRSRange.liquid_range_id)
                //                                                 && st.device_arm_id.Equals(liquidTypeRSRange.device_arm_id.ToString())
                //                                                 && st.liquid_status.Equals(1)).ToList();
                iResult = query.ToList().Count.ToString();
            }
            return iResult;
        }
        #endregion

        #region 查询返回是否存在一条同名的液体参数数据 by 液体类型
        /// <summary>
        /// 查询返回是否存在一条同名的液体参数数据 by 液体类型
        /// </summary>
        /// <param name="liquidType">液体类型</param>
        /// <returns>-1:不存在；其它值：存在</returns>
        public static string IsExistLiquidTypeIntodb(string liquidType)
        {
            string iResult = "-1";
            using (var db = GetInstance())
            {
                var query = db.Queryable<LiquidType>().Where(it=>it.liquid_type_name.Equals(liquidType)).ToList();
                iResult = query.Count.ToString();
            }
            return iResult;
        }
        #endregion

        #region 删除一条新的液体参数数据 by 液体参数数据对象
        /// <summary>
        /// 删除一条新的液体参数数据 by 液体参数数据对象
        /// </summary>
        /// <param name="liquid">液体参数数据对象</param>
        /// <returns>1:成功；0：失败</returns>
        public static int DeleteLiquidIntodb(Liquid liquid)
        {
            using (var db = GetInstance())
            {
                liquid.liquid_status= 0;
                return db.Updateable<Liquid>(liquid).ExecuteCommand();
            }
        }
        #endregion
    }
}