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/db/PubDBHelper.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
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