From ede4690d2acb18d0d6e7ff65ed2f5e676e45c7ef Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 21 三月 2023 10:32:37 +0800
Subject: [PATCH] 1
---
ExportMap/cs/SGUtils.cs | 3 +++
ExportMap/db/PubDBHelper.cs | 16 ++++++++++++++++
2 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/ExportMap/cs/SGUtils.cs b/ExportMap/cs/SGUtils.cs
index c9bda39..6e74778 100644
--- a/ExportMap/cs/SGUtils.cs
+++ b/ExportMap/cs/SGUtils.cs
@@ -246,6 +246,9 @@
string strmi = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".strmi"));
File.Move(strmi, Path.Combine(sgFolder, meta.id + "_" + meta.name.Replace(".mpt", ".strmi")));
}
+
+ meta.path = "SG" + "\\" + meta.id + "_" + meta.name;
+ PubDBHelper.UpdateMetaPath(meta);
}
}
diff --git a/ExportMap/db/PubDBHelper.cs b/ExportMap/db/PubDBHelper.cs
index d97aa92..58f1c12 100644
--- a/ExportMap/db/PubDBHelper.cs
+++ b/ExportMap/db/PubDBHelper.cs
@@ -21,6 +21,8 @@
// 妯″瀷-@cnName锛宮odel-@enName锛岃嚜鍔ㄥ彂甯冩ā鍨�-@name锛宧ttp:// - @url锛孴ileset-@serve锛�1-@user锛�7-@pubid
private static string insertLayerSql = "insert into lf.sys_layer (pid, cn_name, en_name, url, type, level, order_num, is_show, create_user, data_type, serve_type, pubid, elev) values ((select coalesce(id, 0) from lf.sys_layer where cn_name = @name limit 1), @cnName, @enName, @url, 2, (select coalesce(level, 0) + 1 from lf.sys_layer where cn_name = @name limit 1), (select coalesce(max(order_num), 0) + 1 from lf.sys_layer where pid = (select id from lf.sys_layer where cn_name = @name limit 1)), 0, @user, @name, @serve, @pubid, @elev);";
+ private static string updateMetaSql = "update lf.sys_meta set path = @path where id = @id";
+
/// <summary>
/// 鏄�/鍚﹀彂甯冭繃
/// </summary>
@@ -97,6 +99,20 @@
}
/// <summary>
+ /// 鏇存柊鍏冩暟鎹枃浠惰矾寰�
+ /// </summary>
+ public static int UpdateMetaPath(SysMeta meta)
+ {
+ List<DbParameter> list = new List<DbParameter>();
+ list.Add(new NpgsqlParameter("@id", meta.id));
+ list.Add(new NpgsqlParameter("@path", meta.path));
+
+ int rows = Tool.DBHelper.ExecuteNonQuery(updateMetaSql, list.ToArray());
+
+ return rows;
+ }
+
+ /// <summary>
/// 鑾峰彇鍙傛暟鍒楄〃
/// </summary>
public static List<DbParameter> GetParams<T>(string sql, T t)
--
Gitblit v1.9.3