From 072f76a9a62b244ea65f44e912bbc6a17d8e6966 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 29 七月 2023 19:58:13 +0800
Subject: [PATCH] 1
---
ExportMap/cs/TerraUtils.cs | 2 +-
ExportMap/db/PubDBHelper.cs | 8 ++++----
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/ExportMap/cs/TerraUtils.cs b/ExportMap/cs/TerraUtils.cs
index b6721a6..72d4a56 100644
--- a/ExportMap/cs/TerraUtils.cs
+++ b/ExportMap/cs/TerraUtils.cs
@@ -303,7 +303,7 @@
if (!File.Exists(txtFile)) return null;
string[] strs = File.ReadAllLines(txtFile, Encoding.UTF8);
- File.Delete(txtFile);
+ // File.Delete(txtFile); // 鍒犻櫎鍧愭爣鏂囦欢
if (null == strs || strs.Length == 0) return null;
string[] str = strs[0].Split(new string[] { ", " }, StringSplitOptions.None);
diff --git a/ExportMap/db/PubDBHelper.cs b/ExportMap/db/PubDBHelper.cs
index 1b0703a..4147e5b 100644
--- a/ExportMap/db/PubDBHelper.cs
+++ b/ExportMap/db/PubDBHelper.cs
@@ -100,10 +100,10 @@
/// </summary>
public static int UpdatePublishGeom(int pid, string geom)
{
- string sql = string.Format("update lf.sys_publish set geom = @geom where id = {0}", pid);
- DbParameter dp = new NpgsqlParameter("@geom", geom);
+ string sql = string.Format("update lf.sys_publish set geom = {0} where id = {1}", string.IsNullOrEmpty(geom) ? "null" : geom, pid);
+ //DbParameter dp = new NpgsqlParameter("@geom", geom);
- return Tools.DBHelper.ExecuteNonQuery(sql, dp);
+ return Tools.DBHelper.ExecuteNonQuery(sql);
}
/// <summary>
@@ -122,7 +122,7 @@
public static int InsertPublish(SysPublish sys)
{
List<DbParameter> list = Tools.GetParams<SysPublish>(insertPublishSql, sys);
- string sql = string.Format(insertPublishSql, sys.geom == null ? "null" : sys.geom);
+ string sql = string.Format(insertPublishSql, string.IsNullOrEmpty(sys.geom) ? "null" : sys.geom);
object obj = Tools.DBHelper.GetScalar(sql, list.ToArray());
--
Gitblit v1.9.3