From 5e06e700474cf8cf8f8e17358d1803cfd2cd23b9 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期四, 03 八月 2023 20:40:34 +0800 Subject: [PATCH] 1 --- ExportMap/cs/SGUtils.cs | 93 ++++++++++++++++++++++++++++++++-------------- 1 files changed, 64 insertions(+), 29 deletions(-) diff --git a/ExportMap/cs/SGUtils.cs b/ExportMap/cs/SGUtils.cs index bbec34b..0a7f67f 100644 --- a/ExportMap/cs/SGUtils.cs +++ b/ExportMap/cs/SGUtils.cs @@ -73,6 +73,10 @@ Tools.SetIsModel(args, list); MoveFiles(list); + SysTask task = CreateTask(args, list); + task.pid = 0; + task.id = TaskDBHelper.Insert(task); + //string names = GetNames(list); string sql = getSql(list); for (int i = 0; i < 61; i++) @@ -83,10 +87,41 @@ List<SpatialItem> items = SelectItemsBySql(sql); if (null == items || items.Count == 0) continue; + task = TaskDBHelper.SelectById(task.id); + if (null != task && task.status < 2) + { + task.status = 2; + TaskDBHelper.Update(task); + } + return InsertInto(list, items, args); } + task = TaskDBHelper.SelectById(task.id); + if (null != task && task.status < 2) + { + task.status = 4; + task.err = "娌℃湁鏁版嵁瑕佸彂甯�"; + TaskDBHelper.Update(task); + } + return null; + } + + /// <summary> + /// 鍒涘缓浠诲姟 + /// </summary> + private SysTask CreateTask(XYZArgs args, List<SysMeta> list) + { + switch (list[0].type) + { + case "3dml": + return TaskDBHelper.CreateTask(args, "3DML", "涓夌淮妯″瀷(3DML)"); + case "cpt": + return TaskDBHelper.CreateTask(args, "CPT", "鐐逛簯鏁版嵁(CPT)"); + default: + return TaskDBHelper.CreateTask(args, "MPT", "鍦烘櫙鏁版嵁(MPT)"); + } } /// <summary> @@ -116,35 +151,6 @@ return list; } - - #region 搴熷純 * - /// <summary> - /// 鏌ヨSG鏁版嵁椤� - /// </summary> - public List<SpatialItem> SelectItems(string names) - { - string sql = string.Format("select id, Name, RelativePath, LayerName, DataSourceId, Description from SpatialItems where Name in ({0}) order by id desc", names); - - DataTable dt = SQLiteHelper.GetDataTable(sql); - List<SpatialItem> list = ModelHandler.FillModel<SpatialItem>(dt); - - return list; - } - - /// <summary> - /// 鑾峰彇鍚嶇О瀛楃涓� - /// </summary> - private string GetNames(List<SysMeta> metas) - { - List<string> list = new List<string>(); - foreach (SysMeta meta in metas) - { - list.Add("'" + meta.id + "_" + meta.name + "'"); - } - - return string.Join(",", list); - } - #endregion /// <summary> /// 绉婚櫎绌烘枃浠� @@ -260,6 +266,35 @@ } } + #region 搴熷純 * + /// <summary> + /// 鏌ヨSG鏁版嵁椤� + /// </summary> + public List<SpatialItem> SelectItems(string names) + { + string sql = string.Format("select id, Name, RelativePath, LayerName, DataSourceId, Description from SpatialItems where Name in ({0}) order by id desc", names); + + DataTable dt = SQLiteHelper.GetDataTable(sql); + List<SpatialItem> list = ModelHandler.FillModel<SpatialItem>(dt); + + return list; + } + + /// <summary> + /// 鑾峰彇鍚嶇О瀛楃涓� + /// </summary> + private string GetNames(List<SysMeta> metas) + { + List<string> list = new List<string>(); + foreach (SysMeta meta in metas) + { + list.Add("'" + meta.id + "_" + meta.name + "'"); + } + + return string.Join(",", list); + } + #endregion + #region * 搴熷純 * /// <summary> /// 鑾峰彇鏈�澶D鍊� -- Gitblit v1.9.3