using DevExpress.Xpf.Grid;
using KGIS.Framework.DBOperator;
using KGIS.Framework.Maps;
using KGIS.Framework.Platform;
using KGIS.Framework.Utils;
using KGIS.Framework.Utils.ExtensionMethod;
using KGIS.Framework.Utils.Helper;
using KGIS.Framework.Utils.Interface;
using Kingo.Plugin.General.Helper;
using Kingo.PluginServiceInterface;
using Kingo.PluginServiceInterface.Helper;
using Kingo.PluginServiceInterface.Model;
using KUI.Windows;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;

namespace Kingo.Plugin.DTBJK_XJ.View
{
    /// <summary>
    /// UCLoadDTBJKData.xaml 的交互逻辑
    /// </summary>
    public partial class UCLoadDTBJKData : BaseWindow
    {
        JKTBTask taskList = null;
        private int currentPage = 1;
        private int pageSize = 50;// 每页显示的数据量
        private int totalRecords = 100; // 总记录数
        private int totalPages = 2; // 总页数
        List<TaskPackage> taskPackages = new List<TaskPackage>();
        private ProjectInfo projectInfo = null;
        public UCLoadDTBJKData()
        {
            InitializeComponent();
            this.Height = 520;
            this.Width = 1000;
            if (projectInfo == null)
                projectInfo = MapsManager.Instance.MapService.GetProjectInfo() as ProjectInfo;
            #region 生命周期
            //生命周期  1:待分配 2：建库待领取 3：建库中 4：待解析 5：省级核查中  6:解析失败 7省级核查通过 8省级核查不通过
            List<ListValue> list = new List<ListValue>();
            list.Add(new ListValue("待领取", "2"));
            list.Add(new ListValue("建库中", "3"));
            list.Add(new ListValue("已上传", "4"));
            list.Add(new ListValue("省级核查中", "5"));
            list.Add(new ListValue("省级核查通过", "7"));
            list.Add(new ListValue("省级核查不通过", "8"));
            cycle.ItemsSource = list;
            cycle.SelectedIndex = 0;
            #endregion

            #region 绑定业务类型
            list = new List<ListValue>();
            string ywlx = UserLoginHelper.GetAppsetingValueByKey("YWLX");
            if (string.IsNullOrEmpty(ywlx))
            {
                MessageBox.Show("业务类型获取失败", "提示信息", MessageBoxButton.OK);
                return;
            }
            foreach (var item in ywlx.Split(','))
            {
                list.Add(new ListValue(item, item));
            }
            cbxYwlx.ItemsSource = list;
            cbxYwlx.SelectedIndex = 0;
            #endregion

            #region 绑定图斑所在的包文件
            string taskPath = projectInfo.TaskPath + "\\临时";
            if (string.IsNullOrEmpty(taskPath) || !Directory.Exists(taskPath))
            {
                MessageBox.Show("未检测到任务目录，请先设置任务目录。", "提示信息", MessageBoxButton.OK);
                return;
            }
            if (projectInfo != null && projectInfo.ListTaskPackage != null && projectInfo.ListTaskPackage.Count != 0)
            {
                taskPackages = projectInfo.ListTaskPackage;
            }
            else
            {
                string[] filePaths = Directory.GetDirectories(taskPath);
                string fileName = "";
                foreach (string filePath in filePaths)
                {
                    fileName = System.IO.Path.GetFileName(filePath);
                    taskPackages.Add(new TaskPackage() { Ischeck = false, State = "未上传", PackageName = fileName, PackagePath = filePath });
                }
            }
            fileName.ItemsSource = taskPackages;
            #endregion

            perPageNum.ItemsSource = new string[] { "10", "20", "50", "100", "200", "500" };
            perPageNum.Text = "50";

            //县镇村  地区代码
            InittXZQDic();
        }

        private void LoadData()
        {
            try
            {
                string userId = string.Empty, ywlx = string.Empty;
                userId = UserLoginHelper.GetAppsetingValueByKey("UserId");
                if (string.IsNullOrEmpty(userId) || int.Parse(userId) <= 0)
                {
                    MessageBox.Show("用户ID获取失败", "提示信息", MessageBoxButton.OK);
                    return;
                }
                ywlx = cbxYwlx.SelectedValue.ToSafeString();
                if (string.IsNullOrEmpty(ywlx))
                {
                    MessageBox.Show("业务类型获取失败", "提示信息", MessageBoxButton.OK);
                    return;
                }
                this.ShowLoading("正在加载，请稍候...", 0, 0);

                //string sdm = "";
                string xdm = "";
                string zdm = "";
                string cdm = "";

                //if (cbxShidm.SelectedIndex > -1 && cbxShidm.SelectedItem != null && !string.IsNullOrEmpty(cbxShidm.SelectedItem.ToString()))
                //    sdm = cbxShidm.SelectedItem.ToString().Split('-')[0];

                //后台接口不做修改  市级和县级选择  都用xzqdm字段传值查询请求
                if (cbxXiandm.SelectedIndex > -1 && cbxXiandm.SelectedItem != null && !string.IsNullOrEmpty(cbxXiandm.SelectedItem.ToString()))
                    xdm = cbxXiandm.SelectedItem.ToString().Split('-')[0];
                else if (cbxShidm.SelectedIndex > -1 && cbxShidm.SelectedItem != null && !string.IsNullOrEmpty(cbxShidm.SelectedItem.ToString()))
                    xdm = cbxShidm.SelectedItem.ToString().Split('-')[0];
                if (cbxZhendm.SelectedIndex > -1 && cbxZhendm.SelectedItem != null && !string.IsNullOrEmpty(cbxZhendm.SelectedItem.ToString()))
                    zdm = cbxZhendm.SelectedItem.ToString().Split('-')[0];
                if (cbxCundm.SelectedIndex > -1 && cbxCundm.SelectedItem != null && !string.IsNullOrEmpty(cbxCundm.SelectedItem.ToString()))
                    cdm = cbxCundm.SelectedItem.ToString().Split('-')[0];

                IJKTBTask taskHelper = new JKTBTaskHelper();
                taskList = taskHelper.LoadJKTBTask(ywlx, int.Parse(userId), Convert.ToInt32(cycle.SelectedValue), pageSize, currentPage, xdm, zdm, cdm);

                if (taskList != null)
                {
                    totalRecords = taskList.total;
                    total.Content = $"总数：【{totalRecords}】   ";
                    totalPages = (int)Math.Ceiling((double)totalRecords / pageSize);
                    rTotal.Text = totalPages.ToString();
                    currentPageNum.Content = $"当前页显示数：【{taskList.records.Count}】   ";
                    dgTableMapping.ItemsSource = taskList.records;
                }
                else
                {
                    dgTableMapping.ItemsSource = null;
                }
                this.CloseLoading();
            }
            catch (Exception ex)
            {
                this.CloseLoading();
                LogAPI.Debug("UCLoadDTBJKData.LoadData异常：" + ex.Message);
                LogAPI.Debug("UCLoadDTBJKData.LoadData异常：" + ex.StackTrace);
                throw ex;
            }
        }

        #region 县镇村  地区代码
        List<string> shidm = new List<string>();
        List<string> xiandm = new List<string>();
        List<string> zhendm = new List<string>();
        List<string> cundm = new List<string>();

        //市县镇村
        private void InittXZQDic()
        {
            IRDBHelper rdbHelper = null;
            try
            {
                shidm.Clear();
                if (projectInfo == null || string.IsNullOrEmpty(projectInfo.CODE)) return;
                string systemPath = SysAppPath.GetDataBasePath() + "System.mdb";
                if (File.Exists(systemPath))
                {
                    string connStr = SysConfigsOprator.GetDBConnectionByName("MDBOledbConnection");
                    connStr = string.Format(connStr, systemPath);
                    rdbHelper = RDBFactory.CreateDbHelper(connStr, DatabaseType.MSAccess);
                    string strSQL = $"select distinct SDM, SMC from XZQ where SHDM = '{projectInfo.CODE.Substring(0, 2)}' ";
                    DataTable dt = rdbHelper.ExecuteDatatable("Dic", strSQL, true);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        shidm.AddRange(dt.Rows.OfType<DataRow>().Where(r => r["SDM"] != null && !string.IsNullOrEmpty(r["SDM"].ToString())).Select(r => $"{r["SDM"].ToString()}" + "-" + $"{r["SMC"].ToString()}"));
                    }
                    cbxShidm.ItemsSource = shidm;
                }
            }
            catch (Exception ex)
            {
                LogAPI.Debug("UCLoadDTBJKData.InittXZQDic 异常：" + ex.Message);
                LogAPI.Debug("UCLoadDTBJKData.InittXZQDic 异常：" + ex.StackTrace);
            }
            finally
            {
                if (rdbHelper != null)
                    rdbHelper.DisConnect();
            }
        }
        #endregion

        private void checkBox_Click(object sender, RoutedEventArgs e)
        {
            JKTaskInfo tbm = dgTableMapping.SelectedItem as JKTaskInfo;
            if (tbm != null)
            {
                tbm.ischeck = (bool)(sender as CheckBox).IsChecked;
            }
        }

        private void btnCreate_Click(object sender, RoutedEventArgs e)
        {
            IRDBHelper rdbHelper = null;
            IRDBHelper dbHelper = null;
            try
            {
                if (projectInfo == null)
                {
                    MessageBox.Show("未找到工程文件，建议重新创建工程后操作。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                //1、判断任务目录是否为空
                string taskPath = projectInfo.TaskPath + "\\未完成";
                if (string.IsNullOrEmpty(taskPath) || !Directory.Exists(taskPath))
                {
                    MessageBox.Show("未检测到任务目录，请先设置任务目录。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                //2、判断是否选中建库数据
                if (taskList == null || taskList.records == null || taskList.records.Count == 0)
                {
                    MessageBox.Show("未检测到有建库任务数据。", "提示信息", MessageBoxButton.OK);
                    return;                    
                }
                List<JKTaskInfo> tasks = taskList.records.FindAll(a => a.ischeck == true);
                if (tasks == null || tasks.Count <= 0)
                //if (dgTableMapping.SelectedItems.Count <= 0)
                {
                    MessageBox.Show("请选择要建库的图斑信息。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                //3、创建建库任务DB包
                if (!File.Exists(System.AppDomain.CurrentDomain.BaseDirectory + "Template\\JK_Task.jkrw"))
                {
                    MessageBox.Show("未检测到建库模板。", "提示信息", MessageBoxButton.OK);
                    return;
                }

                this.ShowLoading("正在生成任务，请稍候...", 0, 0);
                string taskDBName = $"建库任务_{tasks.Count}个图斑_{DateTime.Now.ToString("yyyyMMddHHmmss")}.encrypt.jkrw";
                string tempPath = System.AppDomain.CurrentDomain.BaseDirectory + "Temp";
                if (!Directory.Exists(tempPath))
                {
                    Directory.CreateDirectory(tempPath);
                }
                File.Copy(System.AppDomain.CurrentDomain.BaseDirectory + "Template\\JK_Task.jkrw", System.AppDomain.CurrentDomain.BaseDirectory + "Temp\\JK_Task.jkrw", true);
                //4、写入建库数据
                IJKTBTask taskHelper = new JKTBTaskHelper();
                string strResult = taskHelper.CreateJKTask(tasks, cbxYwlx.SelectedValue.ToSafeString(), cycle.SelectedValue.ToSafeString(), System.AppDomain.CurrentDomain.BaseDirectory + "Temp\\JK_Task.jkrw");
                if (!string.IsNullOrEmpty(strResult))
                {
                    UserLoginHelper.UpdateAppsettingValueByKey("JkTaskDBName", projectInfo.TaskPath + "\\临时" + $"\\{taskDBName}\\" + taskDBName.Replace("encrypt.", ""));
                    UserLoginHelper.UpdateAppsettingValueByKey("JkTaskDBYWLX", cbxYwlx.SelectedValue.ToSafeString());
                    File.Copy(System.AppDomain.CurrentDomain.BaseDirectory + "Temp\\JK_Task.jkrw", taskPath + "\\" + taskDBName, true);
                    Platform.Instance.SendMsg(new NotifyMsgPackage() { MsgType = "LoadTreeData" });
                    #region 记录监测编号与任务包的对应关系
                    rdbHelper = RDBFactory.CreateDbHelper(System.IO.Path.Combine(projectInfo.ProjDir, "BGTJ.sqlite"), DatabaseType.SQLite);
                    #region 判断JCTB_TaskPackage表是否存在
                    rdbHelper.ExecuteNonQueryWithException(@"CREATE TABLE if not exists JCTB_TaskPackage ( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT,JCBH TEXT(100),YWLX TEXT(50),PackageName TEXT(255),PackagePath TEXT(500),PackageTempPath TEXT(255)); ", System.Data.CommandType.Text);
                    #endregion
                    dbHelper = RDBFactory.CreateDbHelper($"{taskPath + "\\" + taskDBName}{(MapsManager.Instance.CurrProjectInfo as ProjectInfo).Pathpassword}", DatabaseType.SQLite);
                    DataTable dataTable = dbHelper.ExecuteDatatable("WYRW", "select TBBSM from WYRW", true);
                    StringBuilder stringBuilder = new StringBuilder();
                    if (dataTable != null && dataTable.Rows.Count > 0)
                    {
                        foreach (DataRow item in dataTable.Rows)
                        {
                            var sql = $"INSERT INTO JCTB_TaskPackage (JCBH,YWLX,PackageName,PackagePath,PackageTempPath) VALUES('{item["TBBSM"]}','{cbxYwlx.SelectedValue.ToSafeString()}', '{taskDBName}', '{taskPath + "\\" + taskDBName}', '{projectInfo.TaskPath + "\\临时" + $"\\{taskDBName}\\" + taskDBName.Replace("encrypt.", "")}'); ";
                            stringBuilder.Append(sql);

                            //rdbHelper.ExecuteNonQueryWithException(sql, System.Data.CommandType.Text);

                        }
                        rdbHelper.ExecuteNonQueryWithException(stringBuilder.ToString(), System.Data.CommandType.Text);
                    }
                    #endregion
                    this.CloseLoading();
                    MessageBox.Show(strResult, "提示信息", MessageBoxButton.OK);
                    LoadData();
                }
                else
                {
                    MessageBox.Show("建库任务失败", "提示信息", MessageBoxButton.OK);
                }
            }
            catch (Exception ex)
            {
                this.CloseLoading();
                LogAPI.Debug("UCLoadDTBJKData.btnCreate_Click生成任务失败：" + ex);
                MessageHelper.ShowError("生成任务失败！" + ex.Message);
            }
            finally
            {
                this.CloseLoading();
                if (rdbHelper != null)
                    rdbHelper.DisConnect();
                if (dbHelper != null)
                    dbHelper.DisConnect();

            }
        }

        private void btnSubmitJKTB_Click(object sender, RoutedEventArgs e)
        {
            IRDBHelper rdbHelper = null;
            try
            {
                if(projectInfo == null)
                {
                    MessageBox.Show("未找到工程文件，建议重新创建工程后操作。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                //1、判断任务目录是否为空
                string taskPath = projectInfo.TaskPath + "\\未完成";
                if (string.IsNullOrEmpty(taskPath) || !Directory.Exists(taskPath))
                {
                    MessageBox.Show("未检测到任务目录，请先设置任务目录。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                //2、判断是否选中建库数据
                if (taskList == null || taskList.records == null || taskList.records.Count == 0)
                {
                    MessageBox.Show("未检测到有建库任务数据。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                List<JKTaskInfo> tasks = taskList.records.FindAll(a => a.ischeck == true);
                if (tasks == null || tasks.Count <= 0)
                //if (dgTableMapping.SelectedItems.Count <= 0)
                {
                    MessageBox.Show("请选择要建库的图斑信息。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                //3.提交数据
                IJKTBTask taskHelper = new JKTBTaskHelper();
                string strtbbsm = string.Join(",", tasks.Select(x => $"'{x.tbbsm}'"));
                rdbHelper = RDBFactory.CreateDbHelper(System.IO.Path.Combine(projectInfo.ProjDir, "BGTJ.sqlite"), DatabaseType.SQLite);
                if (!rdbHelper.TableIsExist("JCTB_TaskPackage"))
                {
                    MessageBox.Show("未找到任务表，请先进行任务下发生成任务，作业后进行上传操作。", "提示信息", MessageBoxButton.OK);
                    return;
                }
                this.ShowLoading("正在进行任务上报......", 0, 0);
                DataTable dataTable = rdbHelper.ExecuteDatatable("JCTB_TaskPackage", $" select distinct PackageTempPath, PackageName from JCTB_TaskPackage where JCBH in({strtbbsm}) ", true);
                if (dataTable != null && dataTable.Rows.Count > 0)
                {
                    int successCount = 0, failCount = 0;
                    int successTBCount = 0, failTBCount = 0;
                    string errorMessage = "";
                    foreach (DataRow item in dataTable.Rows)
                    {
                        //var result = taskHelper.SaveJTTBData(item["PackagePath"].ToTrim(), cbxYwlx.SelectedValue.ToSafeString(), UserLoginHelper.GetAppsetingValueByKey("UserId"), out int ZT);
                        string tbbsmInTaskPackage = "";
                        DataTable dtTbbsm = rdbHelper.ExecuteDatatable("JCTB_TaskPackage", $" select distinct JCBH from JCTB_TaskPackage where PackageTempPath = '{item["PackageTempPath"].ToTrim()}'", true);
                        if (dtTbbsm != null && dtTbbsm.Rows.Count > 0)
                        {
                            foreach (DataRow bsm in dtTbbsm.Rows)
                            {
                                if (bsm["JCBH"].ToTrim() != null && strtbbsm.Contains(bsm["JCBH"].ToTrim()))
                                    tbbsmInTaskPackage += $"'{bsm["JCBH"].ToTrim()}',";
                            }
                        }
                        if (!string.IsNullOrEmpty(tbbsmInTaskPackage))
                            tbbsmInTaskPackage = tbbsmInTaskPackage.TrimEnd(',');

                        var result = taskHelper.SaveJTTBData(item["PackageTempPath"].ToTrim(), cbxYwlx.SelectedValue.ToSafeString(), UserLoginHelper.GetAppsetingValueByKey("UserId"), tbbsmInTaskPackage);
                        if (result != null)
                        {
                            successTBCount += result.SuccessCount;
                            failTBCount += result.FailCount;

                            if (result.Code == 200)
                            {
                                successCount++;
                                LogAPI.Debug("任务包为" + item["PackageName"].ToTrim() + "上传成功 ：" + result.Message);
                                //MessageBox.Show("任务包为" + item["PackageName"].ToTrim() + "上传：" + result.Message, "提示信息", MessageBoxButton.OK);
                            }
                            else
                            {
                                failCount++;
                                LogAPI.Debug("任务包为" + item["PackageName"].ToTrim() + "数据上传成功失败 ：" + result.Error);
                                errorMessage = result.Error;
                                //MessageBox.Show("任务包为" + item["PackageName"].ToTrim() + "数据上报失败：" + result.Error, "提示信息", MessageBoxButton.OK);
                            }
                        }
                    }

                    this.CloseLoading();

                    if (dataTable.Rows.Count == successCount)
                        MessageHelper.ShowTips("任务包全部上传成功。" + $"变更范围图斑共计{successTBCount + failTBCount }个，成功上传{successTBCount}个，失败{failTBCount}个。");
                    else if (failCount > 0 && successCount > 0)
                        MessageHelper.ShowTips($"变更范围图斑共计{successTBCount + failTBCount }个，成功上传{successTBCount}个，失败{failTBCount}个。" + errorMessage);
                    else
                        MessageHelper.ShowTips("任务包全部上传失败。" + errorMessage + $"变更范围图斑共计{successTBCount + failTBCount }个，成功上传{successTBCount}个，失败{failTBCount}个。");

                }
                else
                {
                    System.Threading.Thread.Sleep(1000);
                    this.CloseLoading();
                    LogAPI.Debug("查找JCTB_TaskPackage记录为0，未找到任务包数据！");
                    MessageHelper.ShowTips("未找到任务包数据！");
                }
                this.CloseLoading();
            }
            catch (Exception ex)
            {
                LogAPI.Debug("数据上报失败" + ex.Message);
                LogAPI.Debug("数据上报失败" + ex.StackTrace);
                MessageHelper.ShowError("数据上报失败，原因是：" + ex.Message);
            }
            finally
            {
                this.CloseLoading();
                if (rdbHelper != null)
                    rdbHelper.DisConnect();
            }
            //try
            //{
            //    IJKTBTask taskHelper = new JKTBTaskHelper();
            //    var result = taskHelper.SaveJTTBData("", cbxYwlx.SelectedValue.ToSafeString(), UserLoginHelper.GetAppsetingValueByKey("UserId"), out int ZT);
            //    if (result != null && result.Code == 200)
            //    {
            //        MessageBox.Show(result.Message, "提示信息", MessageBoxButton.OK);
            //    }
            //    else
            //    {
            //        MessageBox.Show("数据上报失败," + result.Error, "提示信息", MessageBoxButton.OK);
            //    }
            //}
            //catch (Exception ex)
            //{
            //    LogAPI.Debug("数据上报失败" + ex.Message);
            //    LogAPI.Debug("数据上报失败" + ex.StackTrace);
            //    MessageBox.Show("数据上报失败。", "提示信息", MessageBoxButton.OK);
            //}
        }

        private void AllCheckEidt_EditValueChanged(object sender, DevExpress.Xpf.Editors.EditValueChangedEventArgs e)
        {

            try
            {
                if (this.dgTableMapping == null || (dgTableMapping.ItemsSource as List<JKTaskInfo>) == null)
                {
                    return;
                }
                List<JKTaskInfo> listTableMapping = dgTableMapping.ItemsSource as List<JKTaskInfo>;
                bool check = (sender as DevExpress.Xpf.Editors.CheckEdit).IsChecked == null ? false : bool.Parse((sender as DevExpress.Xpf.Editors.CheckEdit).IsChecked.Value.ToString());
                if (check)
                {
                    //selectTbbsm = listTableMapping.Select(a => a.tbbsm).ToList();
                    listTableMapping.ForEach(a => a.ischeck = true);
                }
                else
                {
                    //selectTbbsm.Clear();
                    listTableMapping.ForEach(a => a.ischeck = false);
                }
                dgTableMapping.RefreshData();
                dgTableMapping.ItemsSource = null;
                dgTableMapping.ItemsSource = listTableMapping;
            }
            catch (Exception ex)
            {
                MessageHelper.ShowTips("全选发生异常：" + ex.Message);
            }
        }
        #region 分页
        private void FirstPageButton_Click(object sender, RoutedEventArgs e)
        {
            currentPage = 1;
            rCurrent.Text = currentPage.ToString();
            LoadData();
        }
        private void PreviousPageButton_Click(object sender, RoutedEventArgs e)
        {
            if (currentPage > 1)
            {
                currentPage--;
                rCurrent.Text = currentPage.ToString();
                LoadData();
            }
        }
        private void NextPageButton_Click(object sender, RoutedEventArgs e)
        {
            int totalPages = (int)Math.Ceiling((double)totalRecords / pageSize);
            if (currentPage < totalPages)
            {
                currentPage++;
                rCurrent.Text = currentPage.ToString();
                LoadData();
            }
        }
        private void LastPageButton_Click(object sender, RoutedEventArgs e)
        {
            int totalPages = (int)Math.Ceiling((double)totalRecords / pageSize);
            currentPage = totalPages;
            rCurrent.Text = currentPage.ToString();
            LoadData();
        }
        #endregion

        private void perPageNum_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            string perPageNum = this.perPageNum.SelectedValue.ToString();
            pageSize = int.Parse(perPageNum);
            if (e.RemovedItems.Count > 0)
            {
                LoadData();
            }
        }

        private void dgTableMapping_CustomColumnDisplayText(object sender, CustomColumnDisplayTextEventArgs e)
        {
            try
            {
                //生命周期  1:待分配 2：建库待领取 3：建库中 4：待解析 5：省级核查中  6:解析失败 7省级核查通过 8省级核查不通过
                #region 生命周期
                if (e.Column.FieldName == "lifecycle")
                {
                    switch ((int)e.Value)
                    {
                        case 2:
                            e.DisplayText = "待领取";
                            break;
                        case 3:
                            e.DisplayText = "建库中";
                            break;
                        case 4:
                            e.DisplayText = "已上传";
                            break;
                        case 5:
                            e.DisplayText = "省级核查中";
                            break;
                        case 7:
                            e.DisplayText = "省级核查通过";
                            break;
                        case 8:
                            e.DisplayText = "省级核查不通过";
                            break;
                        default:
                            e.DisplayText = "未获取到生命周期";
                            break;
                    }
                }
                #endregion
            }
            catch (Exception ex)
            {
                LogAPI.Debug("dgTableMapping_CustomColumnDisplayText异常：" + ex.Message);
                LogAPI.Debug("dgTableMapping_CustomColumnDisplayText异常：" + ex.StackTrace);
            }
        }

        private void cbxYwlx_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (cycle.SelectedValue != null && cbxYwlx.SelectedValue != null)
            {
                LoadData();
                fileName.SelectedIndex = -1;
            }
        }

        //private void cbxDqdm_SelectionChanged(object sender, SelectionChangedEventArgs e)
        //{
        //    if (cbxDqdm.SelectedValue != null)
        //    {
        //        LoadData();
        //        fileName.SelectedIndex = -1;
        //    }
        //}

        private void cycle_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (cycle.SelectedValue != null && cbxYwlx.SelectedValue != null)
            {
                if (cycle.SelectedValue.ToTrim() != "2" && cycle.SelectedValue.ToTrim() != "3" && cycle.SelectedValue.ToTrim() != "8")
                {
                    btnCreate.IsEnabled = false;
                }
                else
                {
                    btnCreate.IsEnabled = true;
                }
                LoadData();
                fileName.SelectedIndex = -1;
                cbxShidm.SelectedIndex = -1;
            }
        }

        private void fileName_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            IRDBHelper rdbHelper = null;
            IRDBHelper rdbHelperTemp = null;
            if (fileName.SelectedValue != null && cbxYwlx.SelectedValue != null)
                try
                {
                    rdbHelper = RDBFactory.CreateDbHelper(System.IO.Path.Combine(projectInfo.ProjDir, "BGTJ.sqlite"), DatabaseType.SQLite);
                    if (!rdbHelper.TableIsExist("JCTB_TaskPackage"))
                    {
                        LogAPI.Debug("fileName_SelectionChanged异常：JCTB_TaskPackage表格不存在");
                        return;
                    }
                    DataTable dataTable = rdbHelper.ExecuteDatatable("JCTB_TaskPackage", $" select  JCBH, PackageTempPath, PackageName, PackagePath from JCTB_TaskPackage where PackagePath='{fileName.SelectedValue.ToTrim()}' ", true);                   
                    if (dataTable != null && dataTable.Rows.Count > 0)
                    {
                        #region 去掉未完成
                        string strTbbsm = "";
                        string packageTempPath = dataTable.Rows[0]["PackageTempPath"].ToTrim();
                        if (!string.IsNullOrEmpty(packageTempPath) && System.IO.File.Exists(packageTempPath))
                        {
                            rdbHelper = RDBFactory.CreateDbHelper($"{packageTempPath}{(MapsManager.Instance.CurrProjectInfo as ProjectInfo).Pathpassword}", DatabaseType.SQLite);
                            DataTable tempdataTable = rdbHelper.ExecuteDatatable("tempdataTable", "select tbbsm from wyrw where ZT <> '未完成' ", true);
                            if (tempdataTable != null && tempdataTable.Rows.Count > 0)
                            {
                                strTbbsm = string.Join(",", tempdataTable.Rows.OfType<DataRow>().Select(r => $"{r[0].ToString()}"));
                            }
                        }
                        #endregion

                        //string sdm = "";
                        string xdm = "";
                        string zdm = "";
                        string cdm = "";

                        //if (cbxShidm.SelectedIndex > -1 && cbxShidm.SelectedItem != null && !string.IsNullOrEmpty(cbxShidm.SelectedItem.ToString()))
                        //    sdm = cbxShidm.SelectedItem.ToString().Split('-')[0];

                        //后台接口不做修改  市级和县级选择  都用xzqdm字段传值查询请求
                        if (cbxXiandm.SelectedIndex > -1 && cbxXiandm.SelectedItem != null && !string.IsNullOrEmpty(cbxXiandm.SelectedItem.ToString()))
                            xdm = cbxXiandm.SelectedItem.ToString().Split('-')[0];
                        else if (cbxShidm.SelectedIndex > -1 && cbxShidm.SelectedItem != null && !string.IsNullOrEmpty(cbxShidm.SelectedItem.ToString()))
                            xdm = cbxShidm.SelectedItem.ToString().Split('-')[0];
                        if (cbxZhendm.SelectedIndex > -1 && cbxZhendm.SelectedItem != null && !string.IsNullOrEmpty(cbxZhendm.SelectedItem.ToString()))
                            zdm = cbxZhendm.SelectedItem.ToString().Split('-')[0];
                        if (cbxCundm.SelectedIndex > -1 && cbxCundm.SelectedItem != null && !string.IsNullOrEmpty(cbxCundm.SelectedItem.ToString()))
                            cdm = cbxCundm.SelectedItem.ToString().Split('-')[0];

                        IJKTBTask taskHelper = new JKTBTaskHelper();
                        //去掉未完成
                        string strjcbh = string.Join(",", dataTable.Rows.OfType<DataRow>().Where(r => strTbbsm.Contains(r[0].ToString())).Select(r => $"{r[0].ToString()}"));
                        //string strjcbh = string.Join(",", dataTable.Rows.OfType<DataRow>().Select(r => $"{r[0].ToString()}"));
                        string userId = UserLoginHelper.GetAppsetingValueByKey("UserId");
                        taskList = taskHelper.LoadJKTBTask(cbxYwlx.SelectedValue.ToTrim(), int.Parse(userId), Convert.ToInt32(cycle.SelectedValue), 999999, 1, xdm, zdm, cdm);

                        #region 添加自主变更图斑
                        if (cycle.SelectedIndex > -1 && cycle.SelectedValue.ToString() == "3")
                        {
                            rdbHelperTemp = RDBFactory.CreateDbHelper($"{dataTable.Rows[0]["PackageTempPath"].ToString()}{(MapsManager.Instance.CurrProjectInfo as ProjectInfo).Pathpassword}", DatabaseType.SQLite);
                            //DataTable dataTableTemp = rdbHelperTemp.ExecuteDatatable("rdbHelperTemp", $" select  * from wyrw where substr(TBBSM,7,4) = 'ZZBG' and ZT <> '已上传' ", true);
                            //去掉未完成
                            DataTable dataTableTemp = rdbHelperTemp.ExecuteDatatable("rdbHelperTemp", $" select  * from wyrw where substr(TBBSM,7,4) = 'ZZBG' and ZT <> '已上传' and ZT <> '未完成' ", true);
                            if (dataTableTemp != null && dataTableTemp.Rows.Count > 0)
                            {
                                foreach (DataRow bsm in dataTableTemp.Rows)
                                {
                                    taskList.records.Add(new JKTaskInfo()
                                    {
                                        tbbsm = bsm["TBBSM"].ToTrim(),
                                        lifecycle = 3,
                                        username = UserLoginHelper.GetAppsetingValueByKey("UserName"),
                                        bsm = taskList.records.Count + 1,
                                        ischeck = false
                                    }
                                    ); 
                                    strjcbh += "," + bsm["TBBSM"].ToTrim();

                                    rdbHelper.ExecuteNonQueryWithException($"INSERT INTO JCTB_TaskPackage (JCBH,YWLX,PackageName,PackagePath,PackageTempPath) VALUES('{bsm["TBBSM"]}','{cbxYwlx.SelectedValue.ToSafeString()}', '{dataTable.Rows[0]["PackageName"].ToString()}', '{dataTable.Rows[0]["PackagePath"].ToString()}', '{dataTable.Rows[0]["PackageTempPath"].ToString()}'); ", System.Data.CommandType.Text);
                                }
                            }
                        }
                        #endregion
                        
                        if (taskList != null)
                        {
                            taskList.records = taskList.records.Where(x => strjcbh.Contains(x.tbbsm)).ToList();
                            totalRecords = taskList.records.Count;
                            total.Content = $"总数：【{totalRecords}】   ";
                            totalPages = (int)Math.Ceiling((double)totalRecords / pageSize);
                            rTotal.Text = totalPages.ToString();
                            currentPageNum.Content = $"当前页显示数：【{taskList.records.Count}】   ";
                            dgTableMapping.ItemsSource = taskList.records;
                        }
                        else
                        {
                            dgTableMapping.ItemsSource = null;
                            total.Content = $"总数：【0】   ";
                            currentPageNum.Content = $"当前页显示数：【0】   ";
                        }
                    }
                    else
                    {
                        dgTableMapping.ItemsSource = null;
                        total.Content = $"总数：【0】   ";
                        currentPageNum.Content = $"当前页显示数：【0】   ";
                    }
                }
                catch (Exception ex)
                {
                    LogAPI.Debug("fileName_SelectionChanged异常：" + ex.Message);
                    LogAPI.Debug("fileName_SelectionChanged异常：" + ex.StackTrace);
                }
                finally
                {
                    if (rdbHelper != null)
                        rdbHelper.DisConnect();
                    if (rdbHelperTemp != null)
                        rdbHelperTemp.DisConnect();
                }
        }


        #region 县镇村  地区代码

        //市县镇村  接口尚未完成
        private void cbxShidm_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (cbxShidm.SelectedIndex < 0 || string.IsNullOrEmpty(cbxShidm.SelectedValue.ToString())) return;
            IRDBHelper rdbHelper = null;
            try
            {
                xiandm.Clear();
                cbxXiandm.SelectedIndex = -1;
                cbxZhendm.SelectedIndex = -1;
                cbxCundm.SelectedIndex = -1;
                cbxXiandm.ItemsSource = null;
                cbxZhendm.ItemsSource = null;
                cbxCundm.ItemsSource = null;
                string shiDM = cbxShidm.SelectedValue.ToString().Split('-')[0];
                if (string.IsNullOrEmpty(shiDM) || string.IsNullOrWhiteSpace(shiDM)) return;
                cbxXiandm.ItemsSource = GetResponseXZQDM(3, shiDM);
                LoadData();
            }
            catch (Exception ex)
            {
                LogAPI.Debug(ex);
                LogAPI.Debug("UCLoadDTBJKData.cbxXiandm_SelectionChanged 异常：" + ex.Message);
                LogAPI.Debug("UCLoadDTBJKData.cbxXiandm_SelectionChanged 异常：" + ex.StackTrace);
            }
            finally
            {
                if (rdbHelper != null)
                    rdbHelper.DisConnect();
            }
        }

        private void cbxXiandm_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (cbxXiandm.SelectedIndex < 0 || string.IsNullOrEmpty(cbxXiandm.SelectedValue.ToString())) return;
            IRDBHelper rdbHelper = null;
            try
            {
                zhendm.Clear();
                cbxZhendm.SelectedIndex = -1;
                cbxCundm.SelectedIndex = -1;
                cbxZhendm.ItemsSource = null;
                cbxCundm.ItemsSource = null;
                string xianDM = cbxXiandm.SelectedValue.ToString().Split('-')[0];
                if (string.IsNullOrEmpty(xianDM) || string.IsNullOrWhiteSpace(xianDM)) return;                               
                cbxZhendm.ItemsSource = GetResponseXZQDM(1, xianDM);
                LoadData();
            }
            catch (Exception ex)
            {
                LogAPI.Debug(ex);
                LogAPI.Debug("UCLoadDTBJKData.cbxXiandm_SelectionChanged 异常：" + ex.Message);
                LogAPI.Debug("UCLoadDTBJKData.cbxXiandm_SelectionChanged 异常：" + ex.StackTrace);
            }
            finally
            {
                if (rdbHelper != null)
                    rdbHelper.DisConnect();
            }
        }

        private List<string> GetResponseXZQDM(int type, string dm)
        {
            List<string> qdm = new List<string>();
            try
            {
                string url = $"{UserLoginHelper.GetAppsetingValueByKey("ApiHost")}nyprocess/GetConditionCounty/{type}/{dm}/{cbxYwlx.SelectedValue.ToSafeString()}";
                ResultInfo<List<XZQDM>> requestData = HttpHelper.GetResponse<ResultInfo<List<XZQDM>>>(url);
                if (requestData != null && requestData.Code == 200)
                {
                    foreach (XZQDM item in requestData.Data)
                    {
                        if (item != null && item.qdm != null && item.qname != null)
                        {
                            qdm.Add(item.qdm + "-" + item.qname);
                        }
                    }
                    return qdm;
                }
                return qdm;
            }
            catch (Exception ex)
            {
                LogAPI.Debug("UCLoadDTBJKData.GetResponseXZQDM 异常：" + ex.Message);
                LogAPI.Debug("UCLoadDTBJKData.GetResponseXZQDM 异常：" + ex.StackTrace);
                return qdm;
            }
        }

        private void cbxZhendm_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (cbxZhendm.SelectedIndex < 0 || string.IsNullOrEmpty(cbxZhendm.SelectedValue.ToString())) return;
            IRDBHelper rdbHelper = null;
            try
            {
                cundm.Clear();
                cbxCundm.SelectedIndex = -1;
                cbxCundm.ItemsSource = null;
                string zhenDM = cbxZhendm.SelectedValue.ToString().Split('-')[0];
                if (string.IsNullOrEmpty(zhenDM) || string.IsNullOrWhiteSpace(zhenDM)) return;
                cbxCundm.ItemsSource = GetResponseXZQDM(2, zhenDM);
                LoadData();
            }
            catch (Exception ex)
            {
                LogAPI.Debug(ex);
                LogAPI.Debug("UCLoadDTBJKData.cbxZhendm_SelectionChanged 异常：" + ex.Message);
                LogAPI.Debug("UCLoadDTBJKData.cbxZhendm_SelectionChanged 异常：" + ex.StackTrace);
            }
            finally
            {
                if (rdbHelper != null)
                    rdbHelper.DisConnect();
            }
        }

        private void cbxCundm_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (cbxCundm.SelectedValue != null)
            {
                LoadData();
            }
        }
        #endregion

    }

    public class XZQDM
    {
        public string qdm { get; set; }
        public string qname { get; set; }
    }


}