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

namespace DataRWDAL
{
    /// <summary>
    /// 耗材类型库表操作类
    /// </summary>
    public class LabwareTypeDB:BaseDB
    {
        #region 查询返回耗材类型数据 by 查询请求类型Id
        /// <summary>
        /// 查询返回耗材类型数据 by 查询请求类型Id
        /// </summary>
        /// <param name="labwareTypeId">耗材类型Id</param>
        /// <returns>耗材类型数据</returns>
        public static LabwareType GetLabwareTypeInfo(int labwareTypeId)
        {
            using (var db = GetInstance())
            {
                return db.Queryable<LabwareType>().Single(it => it.labwaretype_id.Equals(labwareTypeId.ToString()));
            }
        }
        #endregion

        #region 查询返回耗材类型数据集 by 查询请求类型
        /// <summary>
        /// 查询返回耗材类型数据集 by 查询请求类型
        /// </summary>
        /// <param name="lType">1:系统默认类型；2：自定义类型：0：所有可用类型</param>
        /// <returns>耗材类型数据集</returns>
        public static ObservableCollection<LabwareType> GetLabwareTypeFromdb(int lType)
        {
            using (var db = GetInstance())
            {
                if (lType == 1)
                {
                    return new ObservableCollection<LabwareType>(db.Queryable<LabwareType>().Where(it => it.is_default_type.Equals(1)
                                                  &&it.labware_type_status.Equals(1)).OrderBy(it=>it.labwaretype_id,SqlSugar.OrderByType.Asc).ToList());
                }
                else if(lType== 2)
                {
                    return new ObservableCollection<LabwareType>(db.Queryable<LabwareType>().Where(it => it.is_default_type.Equals(0)
                                                  && it.labware_type_status.Equals(1)).OrderBy(it => it.labwaretype_id, SqlSugar.OrderByType.Asc).ToList());
                }
                else
                {
                    return new ObservableCollection<LabwareType>(db.Queryable<LabwareType>().Where(it => it.labware_type_status.Equals(1)).OrderBy(it => it.labwaretype_id, SqlSugar.OrderByType.Asc).ToList());
                }
            }
        }
        #endregion

        #region 添加一条新的耗材类型 by 耗材类型对象
        /// <summary>
        /// 添加一条新的耗材类型 by 耗材类型对象
        /// </summary>
        /// <param name="labwareType">耗材类型对象</param>
        /// <returns>1:成功；0:失败</returns>
        public static int AddLabwareTypeIntodb(LabwareType labwareType)
        {
            using (var db = GetInstance())
            {
                return db.Insertable<LabwareType>(labwareType).ExecuteCommand();
            }
        }
        #endregion

        #region 查询返回是否存在重名耗材类型 by 耗材类型对象
        /// <summary>
        /// 查询返回是否存在重名耗材类型 by 耗材类型对象
        /// </summary>
        /// <param name="labwareType">耗材类型对象</param>
        /// <returns>true：存在重名；false：不存在重名</returns>
        public static bool GetIsDoubleLabwareTypeOndb(LabwareType labwareType)
        {
            bool isExistUser = false;

            using (var db = GetInstance())
            {
                if(labwareType.labwaretype_id != null)
                {
                    var query1 = db.Queryable<LabwareType>().Where(it => it.labwaretype_name.Equals(labwareType.labwaretype_name)
                                                  &&it.labware_type_status.Equals(labwareType.labware_type_status)
                                                  &&!it.labwaretype_id.Equals(labwareType.labwaretype_id)).ToList().Count;
                    var query2 = db.Queryable<LabwareType>().Where(it => it.labware_well_name_en.Equals(labwareType.labware_well_name_en)
                                                  &&it.labware_type_status.Equals(labwareType.labware_type_status)
                                                  &&it.labwaretype_id.Equals(labwareType.labwaretype_id)).ToList().Count;
                    if(query1>0)
                    {
                        isExistUser = true;
                    }
                    if(query2>0)
                    {
                        isExistUser = true;
                    }
                    else
                    {
                        isExistUser = false;
                    }
                }
                else
                {
                    var query1 = db.Queryable<LabwareType>().Where(it => it.labwaretype_name.Equals(labwareType.labwaretype_name)
                                                  && it.labware_type_status.Equals(labwareType.labware_type_status)).ToList().Count;
                    var query2 = db.Queryable<LabwareType>().Where(it => it.labware_well_name_en.Equals(labwareType.labware_well_name_en)
                                                  && it.labware_type_status.Equals(labwareType.labware_type_status)).ToList().Count;
                    if (query1 > 0)
                    {
                        isExistUser = true;
                    }
                    if (query2 > 0)
                    {
                        isExistUser = true;
                    }
                    else
                    {
                        isExistUser = false;
                    }
                }
            }
            return isExistUser;
        }
        #endregion

        #region 删除一条耗材类型数据 by 耗材类型Id
        /// <summary>
        /// 删除一条耗材类型数据 by 耗材类型Id
        /// </summary>
        /// <param name="labwaretypeid">耗材类型Id</param>
        /// <returns>1:成功；0：失败</returns>
        public static int DeleteLabwareTypeFromdb(string labwaretypeid)
        {
            using (var db = GetInstance())
            {
                return db.Updateable<LabwareType>().Where(it=>it.labwaretype_id.Equals(labwaretypeid)).ExecuteCommand();
            }
        }
        #endregion

        #region 修改一条耗材类型数据 by 耗材类型对象
        /// <summary>
        /// 修改一条耗材类型数据 by 耗材类型对象
        /// </summary>
        /// <param name="labwareType">耗材类型对象</param>
        /// <returns>1:成功；0：失败</returns>
        public static int UpdateLabwareTypeFromdb(LabwareType labwareType)
        {
            using (var db = GetInstance())
            {
                return db.Updateable<LabwareType>(labwareType).ExecuteCommand();
            }
        }
        #endregion

        #region 构建圆形皿耗材规格分格可选数据集合
        /// <summary>
        /// 构建圆形皿耗材规格分格可选数据集合
        /// </summary>
        /// <returns></returns>
        public static ObservableCollection<LabwareRoundShape> GetLabwareRoundShapeData()
        {
            ObservableCollection<LabwareRoundShape> labwareRoundShapes = new ObservableCollection<LabwareRoundShape>();

            LabwareRoundShape labwareRoundShape = new LabwareRoundShape();
            labwareRoundShape.roundshape_id = 1;
            labwareRoundShape.roundshape_name = "1格";
            labwareRoundShapes.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundShape();
            labwareRoundShape.roundshape_id = 2;
            labwareRoundShape.roundshape_name = "2格";
            labwareRoundShapes.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundShape();
            labwareRoundShape.roundshape_id = 3;
            labwareRoundShape.roundshape_name = "3格";
            labwareRoundShapes.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundShape();
            labwareRoundShape.roundshape_id = 4;
            labwareRoundShape.roundshape_name = "4格";
            labwareRoundShapes.Add(labwareRoundShape);
            return labwareRoundShapes;
        }
        #endregion

        #region 构建圆形皿耗材规格直径可选数据集合
        /// <summary>
        /// 构建圆形皿耗材规格直径可选数据集合
        /// </summary>
        /// <returns></returns>
        public static ObservableCollection<LabwareRoundDiameter> GetLabwareRoundDiameterData()
        {
            ObservableCollection<LabwareRoundDiameter> labwareRoundDiameters = new ObservableCollection<LabwareRoundDiameter>();

            LabwareRoundDiameter labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 1;
            labwareRoundShape.roundiameter_name = "35";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 2;
            labwareRoundShape.roundiameter_name = "55";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 3;
            labwareRoundShape.roundiameter_name = "60";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 4;
            labwareRoundShape.roundiameter_name = "65";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 5;
            labwareRoundShape.roundiameter_name = "75";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 6;
            labwareRoundShape.roundiameter_name = "90";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 7;
            labwareRoundShape.roundiameter_name = "100";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 8;
            labwareRoundShape.roundiameter_name = "120";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 9;
            labwareRoundShape.roundiameter_name = "150";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 10;
            labwareRoundShape.roundiameter_name = "180";
            labwareRoundDiameters.Add(labwareRoundShape);

            labwareRoundShape = new LabwareRoundDiameter();
            labwareRoundShape.roundiameter_id = 11;
            labwareRoundShape.roundiameter_name = "200";
            labwareRoundDiameters.Add(labwareRoundShape);
            return labwareRoundDiameters;
        }
        #endregion

        #region 构建圆形皿耗材规格高度可选数据集合
        /// <summary>
        /// 构建圆形皿耗材规格高度可选数据集合
        /// </summary>
        /// <returns></returns>
        public static ObservableCollection<LabwareRoundHeight> GetLabwareRoundHeightData()
        {
            ObservableCollection<LabwareRoundHeight> labwareRoundHeights = new ObservableCollection<LabwareRoundHeight>();

            LabwareRoundHeight labwareRoundHeight = new LabwareRoundHeight();
            labwareRoundHeight.roundheight_id = 1;
            labwareRoundHeight.roundheight_name = "9";
            labwareRoundHeights.Add(labwareRoundHeight);

            labwareRoundHeight = new LabwareRoundHeight();
            labwareRoundHeight.roundheight_id = 2;
            labwareRoundHeight.roundheight_name = "10";
            labwareRoundHeights.Add(labwareRoundHeight);

            labwareRoundHeight = new LabwareRoundHeight();
            labwareRoundHeight.roundheight_id = 3;
            labwareRoundHeight.roundheight_name = "15";
            labwareRoundHeights.Add(labwareRoundHeight);

            labwareRoundHeight = new LabwareRoundHeight();
            labwareRoundHeight.roundheight_id = 4;
            labwareRoundHeight.roundheight_name = "20";
            labwareRoundHeights.Add(labwareRoundHeight);
            return labwareRoundHeights;
        }
        #endregion
    }
}