From 8482a6fef58c0d699795435ef525a8f188e502a1 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 21 八月 2023 13:44:11 +0800
Subject: [PATCH] 修改Postgres数据库帮助类

---
 DataLoader/CS/PostgreHelper.cs |   35 +++++++++++++++++++++++++++++------
 1 files changed, 29 insertions(+), 6 deletions(-)

diff --git a/DataLoader/CS/PostgreHelper.cs b/DataLoader/CS/PostgreHelper.cs
index 7b99a94..11f4ead 100644
--- a/DataLoader/CS/PostgreHelper.cs
+++ b/DataLoader/CS/PostgreHelper.cs
@@ -5,9 +5,8 @@
 using System.Data;
 using System.Data.Common;
 using System.Linq;
-using System.Text;
 using System.Text.RegularExpressions;
-using System.Threading.Tasks;
+using System.Web;
 
 namespace DataLoader.CS
 {
@@ -29,11 +28,9 @@
 
         private string conStr = null;
 
-        public PostgreHelper(DbEnum db)
+        public PostgreHelper()
         {
-            string str = ConfigurationManager.AppSettings["pgConn"];
-
-            this.conStr = string.Format(str, db.ToString());
+            this.conStr = ConfigurationManager.AppSettings["pgConn"];
         }
 
         /// <summary>
@@ -135,6 +132,32 @@
             }
         }
 
+        public int GetIntScalar(string sql, params DbParameter[] args)
+        {
+            using (NpgsqlConnection con = new NpgsqlConnection(ConStr))
+            {
+                if (con.State != ConnectionState.Open)
+                {
+                    con.Open();
+                }
+
+                using (NpgsqlCommand cmd = new NpgsqlCommand(sql, con))
+                {
+                    if (args != null)
+                    {
+                        foreach (DbParameter arg in args)
+                        {
+                            cmd.Parameters.Add(arg);
+                        }
+                    }
+
+                    object obj = cmd.ExecuteScalar();
+
+                    return null == obj ? 0 : Convert.ToInt32(obj);
+                }
+            }
+        }
+
         /// <summary>
         /// 鎵цSQL锛岃繑鍥炲奖鍝嶈鏁�
         /// </summary>

--
Gitblit v1.9.3