using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Xml;
using XImagingXhandler.XDAL;
using System.Collections.ObjectModel;
using XCommon;
using DataRWDAL;

namespace XImagingXhandler.XDAL
{
    /// <summary>
    /// 文件中孔位的计算排序等
    /// </summary>
    public class WellFileCalc
    {

        #region 重新排序文件移液表格中的数据，使得数据为同一板内一列一列显示
        /// <summary>
        /// 重新排序文件移液表格中的数据，使得数据为同一板内一列一列显示
        /// </summary>
        /// <param name="dataTable">移液表</param>
        /// <param name="sortColumn">待排序的列名</param>
        /// <param name="sortType">排序方式：asc；desc</param>
        /// <returns>某一列排序后的移液表</returns>
        public DataTable SortFileData(DataTable dataTable, string sortColumn, string sortType)
        {
            DataTable dt = new DataTable();
            if (dataTable != null)
            {
                DataView dv = dataTable.DefaultView;
                dv.Sort = sortColumn + " " + sortType;

                dt = dv.ToTable();
            }
            return dt;
        }
        #endregion

        #region 重新排序文件移液表格中的数据，使得数据为同一板内一列一列显示A1~H1 A2~H2 ... A12~H12
        /// <summary>
        /// 重新排序文件移液表格中的数据，使得数据为同一板内一列一列显示A1~H1 A2~H2 ... A12~H12
        /// </summary>
        /// <param name="dataTable">移液表</param>
        /// <param name="plateNode">台面布局xmlnode</param>
        /// <param name="methodNode">移液方法xmlnode</param>
        /// <param name="excludeWell">输出参数，数据中不包含的孔位集合</param>
        /// <param name="bSameVolume">同一列体积是否相同</param>
        /// <param name="bfullDecWell">目标孔是否是完整的列</param>
        /// <param name="bfullChangeTips">更换Tip列是否完整</param>
        /// <returns>所有列排序后的移液表</returns>
        public DataTable SortFileData(DataTable dataTable, XmlNode plateNode, XmlNode methodNode, out List<DropdownName> excludeWell, out bool bSameVolume, out bool bfullDecWell, out bool bfullChangeTips)
        {
            excludeWell = new List<DropdownName>();
            DataTable dt = dataTable.Clone();
            bSameVolume = true;//同一列体积是否相同
            bfullDecWell = true;//目标孔是否是完整的列
            bfullChangeTips = true;//更换Tip列是否完整

            if (dataTable != null)
            {
                //DataView dv = dataTable.DefaultView;
                //dv.Sort = sortColumn + " " + sortType;
                string colSrcName = methodNode.SelectSingleNode("sourceLabware").InnerText;
                string colSrcWellName = methodNode.SelectSingleNode("sourceWell").InnerText;
                string colVolumeName = methodNode.SelectSingleNode("destVolume").InnerText;
                string colTipSet = methodNode.SelectSingleNode("tipSet").InnerText;

                //把数据表中所有的来源板的行列数获取
                List<Labware> labwares = this.GetLabwaresByDataTable(dataTable, colSrcName, colSrcWellName, plateNode);

                string wellName = "";//保存当前的孔名称

                //来源孔位排序之后，看看目标板位是否完整
                string colDecName = methodNode.SelectSingleNode("destinationLabware").InnerText;
                string colDecWellName = methodNode.SelectSingleNode("destinationWell").InnerText;
                List<Labware> decLabwares = new List<Labware>();
                decLabwares = this.GetLabwaresByDataTable(dataTable, colDecName, colDecWellName, plateNode);

                for (int m = 0; m < labwares.Count; m++)// Labware labware in labwares)
                {
                    ObservableCollection<XImagingXhandler.XDAL.Labware> labware01 = LabwareDB.GetLabware(1, labwares[m].labware_id);
                    if (labware01.Count == 0)
                    {
                        labware01 = LabwareDB.GetLabware(0, labwares[m].labware_id);
                    }

                    for (int i = 1; i < (int)labware01[0].number_column + 1; i++)// 列
                    {
                        float destVolume = 0.0f;//目标体积
                        int countlabware = 0;//目标板位被统计的次数
                        int countwell = 0;//目标板的孔位被统计的次数
                        int counttip = 0;//目标板的Tips设置被统计的次数
                        string declabwarename = "";
                        string decwellname = "";
                        string decTip = "";

                        for (int j = 1; j < labware01[0].number_row + 1; j++)//行
                        {

                            string rowName = ComUtility.GetRowChar(j - 1);
                            wellName = rowName + i.ToString();

                            //拿着该孔到datatable中查询数据，如果存在，则把它添加到dt中，如果不存在就跳过
                            var a = dataTable.Select(colSrcName + "='" + labwares[m].labware_name + "' and " + colSrcWellName + "='" + wellName + "'");
                            DataRow am = null;
                            if (a.Length > 1)
                            {
                                //查询比当前m小的同类型板的个数
                                int vId = 0;
                                for (int im = 0; im < (m); im++)
                                {
                                    if (labwares[im].labware_name == labwares[m].labware_name)
                                    {
                                        vId++;
                                    }
                                }

                                am = a[vId];
                            }
                            else if (a.Length == 1)
                            {
                                am = a[0];
                            }

                            if (a.Length != 0)
                            {
                                DataRow ndr = dt.NewRow();
                                for (int q = 0; q < am.ItemArray.Length; q++)
                                {
                                    ndr[q] = am.ItemArray[q];
                                }
                                dt.Rows.Add(ndr);

                                if (j == 1)
                                {
                                    destVolume = (float)Convert.ToDouble(am[colVolumeName]);
                                    //获取此条记录的目标板和目标孔位
                                    declabwarename = am[colDecName].ToString();
                                    decwellname = am[colDecWellName].ToString();
                                    countlabware++;
                                    countwell++;

                                    if (dataTable.Columns.Contains(colTipSet))//如果包含Tip列的话，可以判断
                                    {
                                        decTip = am[colTipSet].ToString();
                                        counttip++;
                                    }
                                }
                                else
                                {
                                    if ((float)Convert.ToDouble(am[colVolumeName]) != destVolume)
                                    {
                                        bSameVolume = false;
                                    }
                                    if (am[colDecName].ToString() == declabwarename)
                                    {
                                        countlabware++;
                                        string index1 = decwellname.Substring(1, decwellname.Length - 1);
                                        string s = am[colDecWellName].ToString();
                                        string index2 = s.Substring(1, s.Length - 1);
                                        if (index1 == index2)
                                        {
                                            countwell++;
                                        }
                                    }

                                    if (dataTable.Columns.Contains(colTipSet))//如果包含Tip列的话，可以判断
                                    {
                                        if (am[colTipSet].ToString() == decTip)
                                        {
                                            counttip++;
                                        }
                                    }
                                }

                                //判断每列最后一个行结束时，总个数是否能被行数整除，如果能则表示完整，否则记录不完整的数据
                                if (j == labware01[0].number_row)
                                {
                                    if (countlabware != countwell || countwell != labware01[0].number_row)
                                    {
                                        bfullDecWell = false;
                                    }

                                    if (counttip != labware01[0].number_row)
                                    {
                                        bfullChangeTips = false;
                                    }
                                }
                            }
                            else//有没有的列
                            {
                                if (j != 1)
                                {
                                    string index3 = wellName.Substring(0, 1);
                                    //查询看看本列的第一个孔在不在
                                    var b = dt.Select(colSrcName + "='" + labwares[m].labware_name + "' and " + colSrcWellName + "='" + index3 + "1'");
                                    if (b.Length == 0)//不在的话，就不添加进入dt，在的话就添加进入dt
                                    {
                                        //DropdownName dropdownName = new DropdownName();
                                        //dropdownName.dropdown_id = labwares[m].labware_name;
                                        //dropdownName.dropdown_name = wellName;
                                        //excludeWell.Add(dropdownName);
                                    }
                                    else
                                    {

                                    }
                                }
                            }
                        }
                    }
                }
            }
            return dt;
        }
        #endregion

        #region 从指定的数据列中获取labware数据集合
        /// <summary>
        /// 从指定的数据列中获取labware数据集合
        /// </summary>
        /// <param name="dt">移液数据</param>
        /// <param name="colName">指定的列名</param>
        /// <param name="colWellName">指定的来源孔列名</param>
        /// <param name="xmlNode">当前台面布局</param>
        /// <returns>labware数据集合</returns>
        public List<Labware> GetLabwaresByDataTable(DataTable dt, string colName, string colWellName, XmlNode xmlNode)
        {

            List<Labware> labwares = new List<Labware>();
            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    var labname = xmlNode.SelectSingleNode("platform[labware_sname='" + dr[colName] + "']");
                    if (labname != null)
                    {
                        var labid = labname.SelectSingleNode("labware_id");
                        var labsname = labname.SelectSingleNode("labware_sname");
                        if (labwares.Count != 0)
                        {
                            var hasLabwares = labwares.FindAll(x => x.labware_id == labid.InnerText && x.labware_name == labsname.InnerText && x.labware_well_id == dr[colWellName].ToString());
                            if (hasLabwares.Count > 1)
                            {
                                Labware labware = new Labware();
                                labware.labware_id = labid.InnerText;
                                labware.labware_name = dr[colName].ToString();
                                labware.labware_well_id = dr[colWellName].ToString();
                                labwares.Add(labware);
                                continue;
                            }
                            else if (hasLabwares.Count == 1)
                            {
                                Labware labware = new Labware();
                                labware.labware_id = labid.InnerText;
                                labware.labware_name = dr[colName].ToString();
                                labware.labware_well_id = dr[colWellName].ToString();
                                labwares.Add(labware);
                            }
                            else
                            {
                                if (labwares.FindAll(x => x.labware_id == labid.InnerText && x.labware_name == labsname.InnerText).Count == 0)
                                {
                                    Labware labware = new Labware();
                                    labware.labware_id = labid.InnerText;
                                    labware.labware_name = dr[colName].ToString();
                                    labware.labware_well_id = dr[colWellName].ToString();
                                    labwares.Add(labware);
                                }
                                else
                                {

                                }
                            }
                        }
                        else
                        {
                            Labware labware = new Labware();
                            labware.labware_id = labid.InnerText;
                            labware.labware_name = dr[colName].ToString();
                            labware.labware_well_id = dr[colWellName].ToString();
                            labwares.Add(labware);
                        }
                    }

                }
            }
            return labwares;
        }
        #endregion

    }
}