using ESRI.ArcGIS.Carto;
using ESRI.ArcGIS.Geodatabase;
using KGIS.Framework.AE;
using KGIS.Framework.AE.GPHelper;
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 Kingo.PluginServiceInterface;
using KUI.Windows;
using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Runtime.InteropServices;
using System.Threading.Tasks;
using System.Windows;
using System.Linq;

namespace Kingo.Plugin.AttributeProcess.Views
{
    /// <summary>
    /// UCAttributeBatchAssignment.xaml 的交互逻辑
    /// </summary>
    public partial class UCAttributeBatchAssignment : BaseWindow
    {
        public UCAttributeBatchAssignment()
        {
            InitializeComponent();
        }

        private void BtnExtract_Click(object sender, RoutedEventArgs e)
        {
            if (QS_ZL_SX.IsChecked == false && MSSM.IsChecked == false && DLMC.IsChecked == false && QSXZ.IsChecked == false && BZ.IsChecked == false && FRDBS.IsChecked == false && XHDM.IsChecked == false && ZZSX.IsChecked == false)
            {
                if (GD_PDJB_KCXS.IsChecked == false && GD_LX_DB.IsChecked == false && TBXHDM_TBXHMC.IsChecked == false && ZZSXDM_ZZSXMC.IsChecked == false && CZCSXM.IsChecked == false && XZDWKD.IsChecked == false)
                {
                    MessageHelper.ShowTips("请至少勾选一个选项!");
                    return;
                }
            }
            //图形编辑完成后，就生成相应的地类图斑变更层，依据2021年度客户变更问题来看，很多存在属性不全的情况，只填写地类编码或者是地类名称、其他属性都未填写，或者是非耕地图斑标注耕地属性，只填写权属代码未填写名称等等，提前维护属性，则可以减少在图斑变更后造成的问题。
            IFeatureLayer bgtbFeatureLayer = null;
            IFeatureLayer jldltbFeatureLayer = null;
            IFeatureCursor pCursor = null;
            IFeature feature = null;
            List<string> liststr = null;
            IFeatureLayer JCDLTB_DLTBBGLayer = null;
            try
            {
                bgtbFeatureLayer = MapsManager.Instance.MapService.GetFeatureLayerByName("DLTBBG"); //地类图斑变更层
                if (bgtbFeatureLayer == null || bgtbFeatureLayer.FeatureClass == null)
                {
                    MessageHelper.Show("未找到变更图斑图层，请检查变更图斑图层是否存在！");
                    return;
                }
                if (bgtbFeatureLayer.FeatureClass.FeatureCount(null) == 0)
                {
                    MessageHelper.Show("变更图斑图层不存在数据，请导入数据后再执行！");
                    return;
                }
                jldltbFeatureLayer = MapsManager.Instance.MapService.GetFeatureLayerByLayerName("地类图斑");//基础地类图斑
                if (jldltbFeatureLayer == null)
                {
                    MessageHelper.Show("未找到地类图斑图层，请检查地类图斑图层是否存在！");
                    return;
                }
                IRDBHelper rdbHelper = null;
                string dbpath = System.IO.Path.GetDirectoryName((MapsManager.Instance.MapService.GetProjectInfo() as ProjectInfo).GetProjFilePath()) + @"\BGTJ.sqlite";
                rdbHelper = rdbHelper = RDBFactory.CreateDbHelper("Data Source=" + dbpath, DatabaseType.SQLite);
                if (rdbHelper == null)
                {
                    throw new Exception("数据库连接打开失败：" + dbpath);
                }
                DataTable dtDict = rdbHelper.ExecuteDatatable("Sys_DicType", $"SELECT CODE,NAME FROM Sys_DicDetail WHERE OWNERDIC='2' ", true);
                List<DataDicTionary> DicsZZSX = Platform.Instance.DicHelper.GetDic(DicTypeEnum.ZZSX);
                List<DataDicTionary> DicsXHLX = Platform.Instance.DicHelper.GetDic(DicTypeEnum.TBXHLX);
                this.ShowLoading("正在进行属性批量维护......", 0, 0);
                string tableName = "result" + DateTime.Now.ToString("HHmmss");
                string dbName = "result" + DateTime.Now.ToString("HHmmss");
                string currentAppPath = SysAppPath.GetCurrentAppPath();
                string templeteGDBPath = Path.Combine(currentAppPath, "Template", "TempGDB.gdb");
                string resultPath = Path.Combine(currentAppPath, "Temp\\Union_DLTBBG_DLTB");
                if (!Directory.Exists(resultPath))
                {
                    Directory.CreateDirectory(resultPath);
                }
                string savePath = Path.Combine(resultPath, dbName + ".gdb");
                CopyDirectory(templeteGDBPath, savePath, true);
                string outPath = Path.Combine(savePath, tableName);
                GPParamClass gPParamClass = new GPParamClass
                {
                    FirstFeatureLayer = bgtbFeatureLayer,
                    SecondFeatureLayer = jldltbFeatureLayer,
                    OutFeatureClassPath = outPath,
                    IsGetOutPutFeature = true
                };
                this.UpdateMsg($"正在进行数据分析处理...");
                GeoprocessorHelper.IntersectAnalysis(gPParamClass, ref JCDLTB_DLTBBGLayer);
                string templeteDBPath = Path.Combine(currentAppPath, "Template", "result.db");
                string resultDBPath = Path.Combine(resultPath, dbName + ".db");
                File.Copy(templeteDBPath, resultDBPath, true);
                rdbHelper = RDBFactory.CreateDbHelper(string.Format("Data Source={0};Initial Catalog=sqlite;Integrated Security=True;Max Pool Size=10;", resultDBPath), DatabaseType.SQLite);
                this.UpdateMsg($"正在数据写入...");
                SetFeatureEllipsoidArea(JCDLTB_DLTBBGLayer.FeatureClass, rdbHelper, resultDBPath, tableName);
                var featurecount = 0;
                var count = bgtbFeatureLayer.FeatureClass.FeatureCount(null);
                pCursor = bgtbFeatureLayer.FeatureClass.Update(null, true);
                #region 属性
                int iQSDWDM = bgtbFeatureLayer.FeatureClass.Fields.FindField("QSDWDM");//权属单位代码
                int iQSDWMC = bgtbFeatureLayer.FeatureClass.Fields.FindField("QSDWMC");//权属单位名称
                int iZLDWDM = bgtbFeatureLayer.FeatureClass.Fields.FindField("ZLDWDM");//坐落单位代码
                int iZLDWMC = bgtbFeatureLayer.FeatureClass.Fields.FindField("ZLDWMC");//坐落单位名称
                int iMSSM = bgtbFeatureLayer.FeatureClass.Fields.FindField("MSSM");//描述说明
                int iDLBM = bgtbFeatureLayer.FeatureClass.Fields.FindField("DLBM");//地类编码
                int iDLMC = bgtbFeatureLayer.FeatureClass.Fields.FindField("DLMC");//地类名称
                int iQSXZ = bgtbFeatureLayer.FeatureClass.Fields.FindField("QSXZ");//权属性质
                int iGDPDJB = bgtbFeatureLayer.FeatureClass.Fields.FindField("GDPDJB");//耕地坡度级别
                int iKCDLXS = bgtbFeatureLayer.FeatureClass.Fields.FindField("KCXS");//扣除地类系数
                int iKCDLBM = bgtbFeatureLayer.FeatureClass.Fields.FindField("KCDLBM");//扣除地类编码
                int iGDLX = bgtbFeatureLayer.FeatureClass.Fields.FindField("GDLX");//耕地类型
                int iGDDB = bgtbFeatureLayer.FeatureClass.Fields.FindField("GDDB");//耕地等别
                int iTBXHDM = bgtbFeatureLayer.FeatureClass.Fields.FindField("TBXHDM");//图斑细化代码
                int iTBXHMC = bgtbFeatureLayer.FeatureClass.Fields.FindField("TBXHMC");//图斑细化名称
                int iZZSXDM = bgtbFeatureLayer.FeatureClass.Fields.FindField("ZZSXDM");//种植属性代码
                int iZZSXMC = bgtbFeatureLayer.FeatureClass.Fields.FindField("ZZSXMC");//种植属性名称
                int iCZCSXM = bgtbFeatureLayer.FeatureClass.Fields.FindField("CZCSXM");//城镇村属性码
                int iXZDWKD = bgtbFeatureLayer.FeatureClass.Fields.FindField("XZDWKD");//线状地物宽度
                int iBZ = bgtbFeatureLayer.FeatureClass.Fields.FindField("BZ");//备注
                int iFRDBS = bgtbFeatureLayer.FeatureClass.Fields.FindField("FRDBS");//飞入地标识
                int iBSM = bgtbFeatureLayer.FeatureClass.Fields.FindField("BSM");//标识码
                #endregion
                var data = rdbHelper.ExecuteDatatable("table", $"select FID_DLTBBG,SHAPE_Area,QSDWDM_1,QSDWMC_1,ZLDWDM_1,ZLDWMC_1,MSSM_1,QSXZ_1,FRDBS_1 from  {tableName} ", true);
                int bsm = 1;
                while ((feature = pCursor.NextFeature()) != null)
                {
                    featurecount++;
                    if (featurecount % 100 == 0 || featurecount == count)
                        this.UpdateMsg($"属性批量维护...【{featurecount}/{count}】");
                    string strDLBM = feature.Value[iDLBM].ToTrim();
                    if (!string.IsNullOrEmpty(strDLBM) && strDLBM.Length > 2)
                    {
                        strDLBM = strDLBM.Substring(0, 2);
                    }
                    #region 属性赋值
                    var datarow = data.Select($"FID_DLTBBG={feature.OID} ", "SHAPE_Area desc");
                    DataRow dr = null;
                    if (datarow.Length > 0)
                    {
                        dr = datarow[0];
                    }
                    else
                    {
                        LogAPI.Debug($"属性批量维护失败：未查找到{feature.OID}对应的基础地类图斑数据！");
                        continue;
                    }
                    //权属/坐落单位属性
                    if (QS_ZL_SX.IsChecked == true)
                    {
                        //权属、坐落单位代码及名称未赋值的，按照基础地类图斑数据进行赋值。
                        if (string.IsNullOrEmpty(feature.Value[iQSDWDM].ToTrim()))
                            feature.Value[iQSDWDM] = dr["QSDWDM_1"];
                        if (string.IsNullOrEmpty(feature.Value[iQSDWMC].ToTrim()))
                            feature.Value[iQSDWMC] = dr["QSDWMC_1"];
                        if (string.IsNullOrEmpty(feature.Value[iZLDWDM].ToTrim()))
                            feature.Value[iZLDWDM] = dr["ZLDWDM_1"];
                        if (string.IsNullOrEmpty(feature.Value[iZLDWMC].ToTrim()))
                            feature.Value[iZLDWMC] = dr["ZLDWMC_1"];
                    }
                    //描述说明
                    if (MSSM.IsChecked == true)
                    {
                        if (string.IsNullOrEmpty(feature.Value[iMSSM].ToTrim()))
                            feature.Value[iMSSM] = dr["MSSM_1"];
                    }
                    //地类名称
                    if (DLMC.IsChecked == true)
                    {
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()))
                        {
                            var dtrow = dtDict.Select($"CODE = '{feature.Value[iDLBM].ToString()}'");
                            if (dtrow.Length > 0)
                                feature.Value[iDLMC] = dtrow[0]["NAME"].ToString();
                        }
                    }
                    //权属性质
                    if (QSXZ.IsChecked == true)
                    {
                        if (string.IsNullOrEmpty(feature.Value[iQSXZ].ToTrim()))
                        {
                            feature.Value[iQSXZ] = dr["QSXZ_1"];
                        }
                        if (feature.Value[iQSXZ].ToTrim() == "21" || feature.Value[iQSXZ].ToTrim() == "41")
                        {
                            //权属性质:"21","41"，描述说明为“01”
                            feature.Value[iMSSM] = "01";
                        }
                        else if ("10,30,31,32,33,34".Contains(feature.Value[iQSXZ].ToTrim()))
                        {
                            //权属性质:非"21","41"，描述说明为“00”
                            feature.Value[iMSSM] = "00";
                        }
                    }
                    //耕地坡度级别/扣除地类系数/扣除地类编码
                    if (GD_PDJB_KCXS.IsChecked == true)
                    {
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()))
                        {
                            if (strDLBM != "01" && !string.IsNullOrEmpty(feature.Value[iGDDB].ToTrim()))
                            {
                                feature.Value[iGDDB] = DBNull.Value;
                            }
                            if (strDLBM != "01" && !string.IsNullOrEmpty(feature.Value[iKCDLXS].ToTrim()))
                            {
                                feature.Value[iKCDLXS] = 0;
                            }
                            if (strDLBM != "01" && !string.IsNullOrEmpty(feature.Value[iKCDLBM].ToTrim()))
                            {
                                feature.Value[iKCDLBM] = null;
                            }
                            if (strDLBM != "01" && !string.IsNullOrEmpty(feature.Value[iGDPDJB].ToTrim()))
                            {
                                feature.Value[iGDPDJB] = null;
                            }
                        }
                    }
                    //耕地类型/耕地等别
                    if (GD_LX_DB.IsChecked == true)
                    {
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()))
                        {
                            if (strDLBM != "01" && !string.IsNullOrWhiteSpace(feature.Value[iGDLX].ToTrim()))
                            {
                                feature.Value[iGDLX] = "";
                            }
                            if (strDLBM != "01" && !string.IsNullOrWhiteSpace(feature.Value[iGDDB].ToTrim()))
                            {
                                feature.Value[iGDDB] = DBNull.Value;
                            }
                        }
                    }
                    //图斑细化代码/图斑细化名称
                    if (TBXHDM_TBXHMC.IsChecked == true)
                    {
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()) && !string.IsNullOrWhiteSpace(feature.Value[iTBXHDM].ToString()))
                        {
                            //非01类图斑，图斑细化代码标注HDGD、HQGD、LQGD、MQGD、SHGD、SMGD、YJGD的需清空。
                            liststr = new List<string>() { "HDGD", "HQGD", "LQGD", "MQGD", "SHGD", "SMGD", "YJGD", "河道耕地", "湖区耕地", "林区耕地", "牧区耕地", "沙荒耕地", "石漠化耕地", "盐碱化耕地" };
                            if (strDLBM != "01" && (liststr.Contains(feature.Value[iTBXHDM].ToTrim()) || liststr.Contains(feature.Value[iTBXHMC].ToTrim())))
                            {
                                feature.Value[iTBXHDM] = "";
                                feature.Value[iTBXHMC] = "";
                            }
                            //非06类用地，TBXHDM字段为HDGY、GTGY、MTGY、SNGY、BLGY、DLGY的需清空。
                            liststr = new List<string>() { "HDGY", "GTGY", "MTGY", "SNGY", "BLGY", "DLGY", "火电工业用地", "钢铁工业用地", "煤炭工业用地", "水泥工业用地", "玻璃工业用地", "电解铝工业用地" };
                            if (strDLBM != "06" && (liststr.Contains(feature.Value[iTBXHDM].ToTrim()) || liststr.Contains(feature.Value[iTBXHMC].ToTrim())))
                            {
                                feature.Value[iTBXHDM] = "";
                                feature.Value[iTBXHMC] = "";
                            }
                            //非04类图斑，标注GCCD的需清除。
                            if (strDLBM != "04" && feature.Value[iTBXHDM].ToString() == "GCCD")
                            {
                                feature.Value[iTBXHDM] = "";
                                feature.Value[iTBXHMC] = "";
                            }
                            //非03类，0404的图斑，标注LJTM的需要清除。
                            if (strDLBM != "03" && feature.Value[iDLBM].ToString() != "0404" && feature.Value[iTBXHDM].ToString() == "LJTM")
                            {
                                feature.Value[iTBXHDM] = "";
                                feature.Value[iTBXHMC] = "";
                            }
                            //地类编码字段前2位非01、02、03、04，且不等于0601、0602、1001、1003，或属于湿地的，不能进行图斑细化标注
                            liststr = new List<string>() { "01", "02", "03", "04", "0601", "0602", "1001", "1003", "0303", "0304", "0306", "0402", "0603", "1105", "1106", "1108" };
                            if (!liststr.Contains(strDLBM) && !liststr.Contains(feature.Value[iDLBM].ToString()) && !liststr.Contains(feature.Value[iDLBM].ToString()))
                            {
                                feature.Value[iTBXHDM] = "";
                                feature.Value[iTBXHMC] = "";
                            }
                            string STrDLBM = feature.Value[iDLBM].ToTrim();
                            if ((STrDLBM == "0602" || STrDLBM == "1003" || STrDLBM == "1001") && feature.Value[iTBXHDM].ToTrim() != "FQ")
                            {
                                feature.Value[iTBXHDM] = "";
                                feature.Value[iTBXHMC] = "";
                            }
                        }
                        else if (string.IsNullOrWhiteSpace(feature.Value[iTBXHDM].ToString()))
                        {
                            feature.Value[iTBXHDM] = "";
                            feature.Value[iTBXHMC] = "";
                        }
                    }
                    //细化代码覆盖名称赋值
                    if (XHDM.IsChecked == true)
                    {
                        if (!string.IsNullOrWhiteSpace(feature.Value[iTBXHDM].ToTrim()))
                        {
                            DataDicTionary XHMC = DicsXHLX.FirstOrDefault(x => x.CODE == feature.Value[iTBXHDM].ToTrim());
                            if (XHMC != null) feature.Value[iTBXHMC] = XHMC.NAME;
                        }
                    }
                    //种植属性代码/种植属性名称
                    if (ZZSXDM_ZZSXMC.IsChecked == true)
                    {
                        liststr = new List<string>() { "LS", "FLS", "LYFL", "XG", "LLJZ", "WG", "种植粮食作物", "种植非粮作物", "粮与非粮轮作", "休耕", "林粮间作", "未耕种" };
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()))
                        {
                            //非01类图斑，种植属性代码标注LS、FLS、LYFL、XG、LLJZ、WG的需要清空；
                            if (strDLBM != "01" && !strDLBM.StartsWith("01") && (liststr.Contains(feature.Value[iZZSXDM].ToTrim()) || liststr.Contains(feature.Value[iZZSXMC].ToTrim())))
                            {
                                feature.Value[iZZSXDM] = "";
                                feature.Value[iZZSXMC] = "";
                            }
                            //非0301、0302、0305、0307、0404、1104、1104A，0201、0202、0203、0204、0201K、0202K、0203K、0204K、0301K、0302K、0307K、0403K、1104K的种植属性代码填写JKHF、GCHF的需清空。
                            liststr = new List<string>() { "0301", "0302", "0305", "0307", "0404", "1104", "1104A", "0201", "0202", "0203", "0204", "0201K", "0202K", "0203K", "0204K", "0301K", "0302K", "0307K", "0403K", "1104K" };
                            if (!liststr.Contains(feature.Value[iDLBM].ToTrim()) && (feature.Value[iZZSXDM].ToTrim() == "JKHF" || feature.Value[iZZSXDM].ToTrim() == "GCHF"))
                            {
                                feature.Value[iZZSXDM] = "";
                                feature.Value[iZZSXMC] = "";
                            }
                            //地类编码字段前2位为04（不包括0404、0403K)、05、06、07、08、09、10、11（不包括1104、1104A、1104K）、12，或属于湿地的，不能进行种植属性标注或恢复属性标注;
                            liststr = new List<string>() { "04", "05", "06", "07", "08", "09", "10", "11", "12", "0303", "0304", "0306", "0402", "0603", "1105", "1106", "1108" };
                            var liststr1 = new List<string>() { "0404", "0403K", "1104", "1104A", "1104K" };
                            if ((liststr.Contains(strDLBM) || liststr.Contains(feature.Value[iDLBM].ToTrim())) && !liststr1.Contains(feature.Value[iDLBM].ToTrim()))
                            {
                                feature.Value[iZZSXDM] = "";
                                feature.Value[iZZSXMC] = "";
                            }
                        }
                    }
                    //种植属性名称覆盖赋值
                    if (ZZSX.IsChecked == true)
                    {
                        if (!string.IsNullOrWhiteSpace(feature.Value[iZZSXDM].ToTrim()))
                        {
                            DataDicTionary XHZZ = DicsZZSX.FirstOrDefault(x => x.CODE == feature.Value[iZZSXDM].ToTrim());
                            if (XHZZ != null) feature.Value[iZZSXMC] = XHZZ.NAME;
                        }
                    }
                    //城镇村属性码
                    if (CZCSXM.IsChecked == true)
                    {
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()))
                        {
                            //1001、1002、1003、1007、1008、1009、1109的图斑，城镇村属性码应为空
                            liststr = new List<string>() { "1001", "1002", "1003", "1007", "1008", "1009", "1109" };
                            if (liststr.Contains(feature.Value[iDLBM].ToString()))
                            {
                                feature.Value[iCZCSXM] = "";
                            }
                        }
                    }
                    //线状地物宽度
                    if (XZDWKD.IsChecked == true)
                    {
                        if (!string.IsNullOrEmpty(feature.Value[iDLBM].ToTrim()))
                        {
                            //非线性图斑要清除线状地物宽度
                            liststr = new List<string>() { "1001", "1002", "1003", "1004", "1006", "1009", "1101", "1107", "1107A", "1203" };
                            if (!liststr.Contains(feature.Value[iDLBM].ToString()) && feature.Value[iXZDWKD].ToString() != "0")
                            {
                                feature.Value[iXZDWKD] = 0;
                            }
                        }
                    }
                    if (BZ.IsChecked == true)
                    {
                        feature.Value[iBZ] = "";
                    }
                    //飞入地标识
                    if (FRDBS.IsChecked == true)
                    {
                        if (string.IsNullOrEmpty(feature.Value[iFRDBS].ToTrim()))
                        {
                            feature.Value[iFRDBS] = dr["FRDBS_1"];
                        }
                    }
                    #endregion
                    feature.Value[iBSM] = $"{(MapsManager.Instance.CurrProjectInfo as ProjectInfo).CODE}2110{(bsm++).ToString().PadLeft(8, '0')}";
                    feature.Store();
                }
                pCursor.Flush();
                this.CloseLoading();
                MessageHelper.Show("属性批量维护完成！");
            }
            catch (Exception ex)
            {
                LogAPI.Debug("属性批量维护失败：" + ex.Message);
                this.CloseLoading();
                MessageHelper.Show("属性批量维护失败！" + ex.Message);
            }
            finally
            {
                this.CloseLoading();
                if (bgtbFeatureLayer != null)
                    Marshal.ReleaseComObject(bgtbFeatureLayer);
                if (jldltbFeatureLayer != null)
                    Marshal.ReleaseComObject(jldltbFeatureLayer);
            }
        }

        private void SetFeatureEllipsoidArea(IFeatureClass featureClass, IRDBHelper rdbHelper, string dbPath, string tableName)
        {
            ICursor pCursor = null;
            IRow pRow = null;
            try
            {
                if (featureClass == null)
                {
                    return;
                }
                IFeatureClassAPI featureClassAPI = new FeatureClassAPI(featureClass);
                int shapeIndex = featureClass.Fields.FindField("SHAPE");
                if (shapeIndex < 0)
                {
                    throw new Exception("未找到SHAPE字段");
                }
                List<string> listSQL = new List<string>();
                string fieldStr = string.Empty;
                string insertField = string.Empty;
                Dictionary<int, bool> listFieldIndex = new Dictionary<int, bool>();
                for (int f = 0; f < featureClassAPI.FeatureClass.Fields.FieldCount; f++)
                {
                    IField field = featureClassAPI.FeatureClass.Fields.Field[f];
                    if (field.Name.ToUpper() == "SHAPE")
                    {
                        continue;
                    }
                    switch (field.Type)
                    {
                        case esriFieldType.esriFieldTypeSmallInteger:
                        case esriFieldType.esriFieldTypeInteger:
                        case esriFieldType.esriFieldTypeOID:
                            fieldStr += field.Name + " INTEGER,";
                            insertField += field.Name + ",";
                            listFieldIndex.Add(f, false);
                            break;
                        case esriFieldType.esriFieldTypeDouble:
                        case esriFieldType.esriFieldTypeSingle:
                            fieldStr += field.Name + " NUMERIC,";
                            insertField += field.Name + ",";
                            listFieldIndex.Add(f, false);
                            break;
                        case esriFieldType.esriFieldTypeString:
                        case esriFieldType.esriFieldTypeDate:
                            fieldStr += field.Name + " TEXT,";
                            insertField += field.Name + ",";
                            listFieldIndex.Add(f, true);
                            break;
                    }
                }
                string createTableSQL = string.Format("CREATE TABLE {1} ({0})", fieldStr.TrimEnd(','), tableName);
                rdbHelper.ExecuteNonQueryWithException(createTableSQL, CommandType.Text);
                string insertSQL = "insert into " + tableName + "(" + insertField.TrimEnd(',') + ")values({0});";
                int count = featureClassAPI.FeatureClass.FeatureCount(null);
                int i = 0;
                pCursor = (featureClass as ITable).Search(null, true);
                while ((pRow = pCursor.NextRow()) != null)
                {
                    string value = string.Empty;
                    foreach (var item in listFieldIndex)
                    {
                        object obj = pRow.get_Value(item.Key);
                        if (item.Value)
                        {
                            if (obj == null || string.IsNullOrWhiteSpace(obj.ToString()))
                            {
                                value += "'',";
                            }
                            else
                            {
                                value += "'" + obj.ToString().Replace("'", "") + "',";
                            }
                        }
                        else
                        {
                            if (obj == null || string.IsNullOrWhiteSpace(obj.ToString()))
                            {
                                obj = 0;
                            }
                            value += obj + ",";
                        }
                    }
                    listSQL.Add(string.Format(insertSQL, value.TrimEnd(',')));
                    i++;
                    if (i % 100 == 0 || i == count)
                        this.UpdateMsg($"正在数据写入...【{i}/{count}】");
                    if (listSQL.Count > 6000)
                    {
                        InsertDB(listSQL, dbPath);
                        listSQL.Clear();
                    }
                    else if (i == count)
                    {
                        InsertDB(listSQL, dbPath);
                        listSQL.Clear();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (pCursor != null)
                {
                    Marshal.ReleaseComObject(pCursor);
                }
                if (pRow != null)
                {
                    Marshal.ReleaseComObject(pRow);
                }
            }
        }

        /// <summary>
        /// 多线程插入数据到db中
        /// </summary>
        /// <param name="listSQL"></param>
        /// <param name="dbPath"></param>
        private void InsertDB(List<string> listSQL, string dbPath)
        {
            try
            {
                using (BlockingCollection<string> blockingCollection = new BlockingCollection<string>())
                {
                    listSQL.ForEach(x => blockingCollection.Add(x));
                    blockingCollection.CompleteAdding();
                    int taskNum = 5;
                    Task[] tasks = new Task[taskNum];
                    for (int i = 0; i < taskNum; i++)
                    {
                        tasks[i] = Task.Factory.StartNew(() =>
                        {
                            ExcuteThead(blockingCollection, dbPath);
                        });
                    }
                    Task.WaitAll(tasks);
                    for (int i = 0; i < taskNum; i++)
                    {
                        tasks[i].Dispose();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        private void ExcuteThead(BlockingCollection<string> blockingCollection, string dbPath)
        {
            IRDBHelper rdbHelper = null;
            string sqlDe = string.Empty;
            try
            {
                rdbHelper = RDBFactory.CreateDbHelper(string.Format("Data Source={0};Initial Catalog=sqlite;Integrated Security=True;Max Pool Size=10;", dbPath), DatabaseType.SQLite);
                if (rdbHelper == null)
                {
                    throw new Exception("执行成果接收时打开数据库连接字符串失败！");
                }
                rdbHelper.BeginTransaction();
                foreach (string sql in blockingCollection.GetConsumingEnumerable())
                {
                    sqlDe = sql;
                    rdbHelper.ExecuteNonQueryWithException(sql, CommandType.Text);
                }
                rdbHelper.Commit();
            }
            catch (Exception ex)
            {
                if (rdbHelper != null)
                {
                    rdbHelper.Rollback();
                }
                LogAPI.Debug(sqlDe);
                LogAPI.Debug(ex);
                throw ex;
            }
            finally
            {
                if (rdbHelper != null)
                {
                    rdbHelper.DisConnect();
                }
            }
        }
        /// <summary>
        /// 拷贝模板gdb文件夹
        /// </summary>
        /// <param name="SourcePath"></param>
        /// <param name="DestinationPath"></param>
        /// <param name="overwriteexisting"></param>
        public static void CopyDirectory(string SourcePath, string DestinationPath, bool overwriteexisting)
        {
            try
            {
                SourcePath = SourcePath.EndsWith(@"\") ? SourcePath : SourcePath + @"\";
                DestinationPath = DestinationPath.EndsWith(@"\") ? DestinationPath : DestinationPath + @"\";

                if (Directory.Exists(SourcePath))
                {
                    if (Directory.Exists(DestinationPath) == false)
                        Directory.CreateDirectory(DestinationPath);

                    foreach (string fls in Directory.GetFiles(SourcePath))
                    {
                        FileInfo flinfo = new FileInfo(fls);
                        flinfo.CopyTo(DestinationPath + flinfo.Name, overwriteexisting);
                    }
                    foreach (string drs in Directory.GetDirectories(SourcePath))
                    {
                        DirectoryInfo drinfo = new DirectoryInfo(drs);
                        CopyDirectory(drs, DestinationPath + drinfo.Name, overwriteexisting);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        private void BtnConfirm_Click(object sender, RoutedEventArgs e)
        {
            this.Close();
        }
    }
}