From 0ecd041107a93991b890b8762de9b32498fc9911 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 20 九月 2023 09:44:22 +0800 Subject: [PATCH] 更新发布时级联更新图层名称 --- ExportMap/db/PubDBHelper.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/ExportMap/db/PubDBHelper.cs b/ExportMap/db/PubDBHelper.cs index abc2075..b82e0b1 100644 --- a/ExportMap/db/PubDBHelper.cs +++ b/ExportMap/db/PubDBHelper.cs @@ -113,7 +113,7 @@ { string str = null == geom ? "" : string.Format(", geom={0}", geom); str += null == url ? "" : string.Format(", url='{0}'", url); - string sql = string.Format("update lf.sys_publish set name=@name, update_user=@userId, update_time=now(){0} where id=@id", str); + string sql = string.Format("update lf.sys_publish set name=@name, update_user=@userId, update_time=now(){0} where id=@id;update lf.sys_layer set cn_name=@name where pubid=@id;", str); DbParameter dp1 = new NpgsqlParameter("@name", name); DbParameter dp2 = new NpgsqlParameter("@userId", userId); -- Gitblit v1.9.3