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

namespace DataRWDAL
{
    /// <summary>
    /// 菌落库表操作类
    /// </summary>
    public class BacteriaDB: BaseDB
    {
        #region 根据菌落Id，获取菌落信息
        /// <summary>
        /// 根据菌落Id，获取菌落信息
        /// </summary>
        /// <param name="bacteriaid">菌落Id</param>
        /// <returns>菌落对象</returns>
        public static Bacteria GetABacteriaFromdb(string bacteriaid)
        {
            using (var db = GetInstance())
            {
                return db.Queryable<Bacteria>().Single(it => it.bacteria_id.Equals(bacteriaid));
            }
        }
        #endregion

        #region 添加一条新的菌数据 by 菌落对象
        /// <summary>
        /// 添加一条新的菌落数据 by 菌落对象
        /// </summary>
        /// <param name="bacteria">菌落对象</param>
        /// <returns>1:成功；0:失败</returns>
        public static int AddBacteriaIntodb(Bacteria bacteria)
        {
            using (var db = GetInstance())
            {
                return db.Insertable<Bacteria>(bacteria).ExecuteCommand();
            }
        }
        #endregion

        #region 查询菌落是否重名 by 菌落对象
        /// <summary>
        /// 查询菌落是否重名 by 菌落对象
        /// </summary>
        /// <param name="bacteria">菌落对象</param>
        /// <returns>true:存在；false:不存在</returns>
        public static bool GetIsDoubleBacteriaOndb(Bacteria bacteria)
        {
            bool isExistUser = false;
            int count = 0;
            using (var db = GetInstance())
            {
                if (bacteria.bacteria_id != "")
                {
                    count= db.Queryable<Bacteria>().Where(it => it.bacteria_name.Equals(bacteria.bacteria_name)&&!it.bacteria_id.Equals(bacteria.bacteria_id)&&it.bacteria_status.Equals(1)).Count();
                }
                else
                {
                    count = db.Queryable<Bacteria>().Where(it => it.bacteria_name.Equals(bacteria.bacteria_name) && it.bacteria_status.Equals(1)).Count();
                }

                if(count>0)
                {
                    isExistUser = true;
                }
                else
                {
                    isExistUser = false;
                }
            }
            return isExistUser;
        }
        #endregion

        #region 修改一条新的菌落数据 by 菌落对象
        /// <summary>
        /// 修改一条新的菌落数据 by 菌落对象
        /// </summary>
        /// <param name="bacteria">菌落对象</param>
        /// <returns>1：成功；0：失败</returns>
        public static int UpdateBacteriaIntodb(Bacteria bacteria)
        {
            using (var db = GetInstance())
            {
                return db.Updateable<Bacteria>(bacteria).ExecuteCommand();
            }
        }
        #endregion

        #region 查询返回菌落数据集 by 默认类型
        /// <summary>
        /// 查询返回菌落数据集 by 默认类型
        /// </summary>
        /// <param name="isDefault">1:系统默认；0：非默认；2：全部</param>
        /// <returns></returns>
        public static ObservableCollection<Bacteria> GetBacteriaListFromdb(int isDefault)
        {
            using (var db = GetInstance())
            {
                if (isDefault == 2)
                {
                    return new ObservableCollection<Bacteria>(db.Queryable<Bacteria>().Where(it => it.bacteria_status.Equals(1)).ToList());
                }
                else
                {
                    return new ObservableCollection<Bacteria>(db.Queryable<Bacteria>().Where(it => it.bacteria_status.Equals(1)&&it.is_default_type.Equals(isDefault)).ToList());
                }
            }
            
        }
        #endregion

        #region 构建返回挑菌位置数据集合信息
        /// <summary>
        /// 构建返回挑菌位置数据集合信息
        /// </summary>
        /// <returns>挑菌位置实体集合</returns>
        public static ObservableCollection<DropdownName> GetBacteriaPositionListFromdb()
        {
            ObservableCollection<DropdownName> dropdowns = new ObservableCollection<DropdownName>();

            DropdownName dropdown = new DropdownName();

            dropdown.dropdown_id = "1";
            dropdown.dropdown_name = "距离皿底距离";
            dropdowns.Add(dropdown);

            dropdown = new DropdownName();

            dropdown.dropdown_id = "2";
            dropdown.dropdown_name = "菌表面距离";
            dropdowns.Add(dropdown);

            return dropdowns;
        }
        #endregion
    }
}