wangguanjie
/
NDBGJK5.0
4
1
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
年度变更建库软件5.0版本
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
4 Branches
0 Tags
121 MiB
 
 
Tag: Branch: Tree: wgj
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'wgj'
${ noResults }
NDBGJK5.0/Kingo.Plugins/Kingo.Plugin.AttributeProcess/Views/UCAttributeBatchAssignment....

633 lines
33 KiB
Raw Permalink Blame History

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();
}
}
}