From 73a1a2b861db44a9519e434152934b627747efcb Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 21 三月 2023 10:15:59 +0800
Subject: [PATCH] 1
---
ExportMap/db/PubDBHelper.cs | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/ExportMap/db/PubDBHelper.cs b/ExportMap/db/PubDBHelper.cs
index d2c82f1..b0ae290 100644
--- a/ExportMap/db/PubDBHelper.cs
+++ b/ExportMap/db/PubDBHelper.cs
@@ -19,7 +19,7 @@
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})";
// 妯″瀷-@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) 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) from lf.sys_layer where pid = (select id from lf.sys_layer where cn_name = @name limit 1)), 0, @user, @name, @serve, @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) from lf.sys_layer where pid = (select id from lf.sys_layer where cn_name = @name limit 1)), 0, @user, @name, @serve, @pubid, @elev);";
/// <summary>
/// 鏄�/鍚﹀彂甯冭繃
@@ -74,7 +74,7 @@
/// <summary>
/// 鎻掑叆鍥惧眰琛ㄨ褰�
/// </summary>
- public static int InsertLayer(SysPublish sys, SysMeta meta)
+ public static int InsertLayer(SysPublish sys, SysMeta meta, double elev = 0)
{
bool isImg = imgList.Contains(meta.type);
string cnName = meta.name.Split(new char[] { '.' })[0];
@@ -89,6 +89,7 @@
list.Add(new NpgsqlParameter("@serve", serve));
list.Add(new NpgsqlParameter("@pubid", sys.id));
list.Add(new NpgsqlParameter("@user", sys.create_user));
+ list.Add(new NpgsqlParameter("@elev", elev));
int rows = Tool.DBHelper.ExecuteNonQuery(insertLayerSql, list.ToArray());
--
Gitblit v1.9.3