From a12c2baf8246d0af0e15756b7e008ded544e9b1c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 02 八月 2023 10:17:04 +0800
Subject: [PATCH] 1
---
ExportMap/db/PubDBHelper.cs | 17 ++++++++++++++---
1 files changed, 14 insertions(+), 3 deletions(-)
diff --git a/ExportMap/db/PubDBHelper.cs b/ExportMap/db/PubDBHelper.cs
index 658ad31..3cf8dea 100644
--- a/ExportMap/db/PubDBHelper.cs
+++ b/ExportMap/db/PubDBHelper.cs
@@ -31,7 +31,7 @@
private static string selectLayerSql = "select id from lf.sys_layer where pid = @pid and en_name = @en_name";
/// <summary>
- /// 鏄�/鍚﹀彂甯冭繃
+ /// 鏄�/鍚﹀彂甯冭繃 *
/// </summary>
public static bool IsPublish(int metaid)
{
@@ -44,7 +44,7 @@
}
/// <summary>
- /// 鏄�/鍚﹀彂甯冭繃
+ /// 鏄�/鍚﹀彂甯冭繃 *
/// </summary>
public static bool IsPublish(string dirid, string type = "DOM")
{
@@ -55,6 +55,17 @@
int count = obj == null ? 0 : Convert.ToInt32(obj);
return count > 0;
+ }
+
+ /// <summary>
+ /// 鑾峰彇鍙戝竷ID
+ /// </summary>
+ public static int GetPushlishId(int metaid)
+ {
+ string sql = string.Format("select pubid from lf.sys_meta_pub where metaid={0} order by id desc limit 1", metaid);
+ object obj = Tools.DBHelper.GetScalar(sql);
+
+ return null == obj ? 0 : Convert.ToInt32(obj);
}
/// <summary>
@@ -101,7 +112,7 @@
public static int UpdatePublish(int pubid, string name, int userId, string geom)
{
string str = null == geom ? "" : string.Format(", geom={0}", geom);
- string sql = string.Format("update lf.sys_publish set name=@name, update_user=@userId, create_time=now(), update_time=now(){0} where id=@id", str);
+ string sql = string.Format("update lf.sys_publish set name=@name, create_time=now(), update_user=@userId, update_time=now(){0} where id=@id", str);
DbParameter dp1 = new NpgsqlParameter("@name", name);
DbParameter dp2 = new NpgsqlParameter("@userId", userId);
--
Gitblit v1.9.3