From c7ff08e7465588935ae2dcd680df5bf331827b0b Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 17 三月 2023 18:54:58 +0800 Subject: [PATCH] 1 --- ExportMap/db/PubDBHelper.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/ExportMap/db/PubDBHelper.cs b/ExportMap/db/PubDBHelper.cs index 2a57095..69e4ef9 100644 --- a/ExportMap/db/PubDBHelper.cs +++ b/ExportMap/db/PubDBHelper.cs @@ -14,7 +14,7 @@ { private static string insertPublishSql = "insert into lf.sys_publish(name, url, path, type, status, dirid, depid, min, max, json, create_user, geom, bak) values (@name, @url, @path, @type, @status, @dirid, @depid, @min, @max, @json, @create_user, @geom, @bak) returning id"; - private static string insertMetaPubSql = "insert into lf.sys_meta_pub (metaid, pubid) select {0}, {1} from (select 1) temp where not exists (select 1 from lf.sys_meta_pub where metaid = {0} and pubid = {1})"; + private static string insertMetaPubSql = "insert into lf.sys_meta_pub (metaid, pubid, create_user) select {0}, {1}, {2} from (select 1) temp where not exists (select 1 from lf.sys_meta_pub where metaid = {0} and pubid = {1})"; /// <summary> /// 鏄�/鍚﹀彂甯冭繃 @@ -46,9 +46,9 @@ /// <summary> /// 鎻掑叆鍏冩暟鎹�-鏁版嵁鍙戝竷琛ㄨ褰� /// </summary> - public static int InsertMetaPub(int metaid, int pubid) + public static int InsertMetaPub(int metaid, int pubid, int userId) { - string sql = string.Format(insertMetaPubSql, metaid, pubid); + string sql = string.Format(insertMetaPubSql, metaid, pubid, userId); return Tool.DBHelper.ExecuteNonQuery(sql); } -- Gitblit v1.9.3